Convert Client Time zone date to Server Time Zone Date

Convert Client Time zone date to Server Time Zone Date



Select TO_CHAR (FND_TIMEZONES_PVT.ADJUST_DATETIME
                                (LAST_ACCPET_DATE, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,
                                                                   FND_TIMEZONES.GET_CLIENT_TIMEZONE_CODE),
                                                                   'DD-MON-YYYY HH24:MI:SS')
 from PO_LINE_LOCATIONS_ALL where line_location_id =xxxxxxxx;

Show Serial Number in RTF Template

XML Tag to show Serial Number in RTF template


<?position()/>

Delete Attachment in EBS

Hi,

If you are looking for a code that can favor you to Delete multiple/Single attachments, here is an oracle provided API that do fortunes with Attachments.

API Name:
fnd_attached_documents2_pkg 

1. If you want to delete all the attachments from specific transaction for example, Attachments from Sales order Headers or say GL Journal Header  , do Use

Procedure "DELETE_ATTACHMENTS" 

           This procedure attracts 3 mandatory parameters and those are

• ENTITY_NAME-->TABLE_NAME
• PK1_VALUE --> Transaction_Id (can be OrdeR_Header_id, Journal_Header_id)
• Delete_document_Flag --> 'Y'

This will delete all the available attachments from the Transaction.

2. If you want to delete Single attachments from specific transaction for example, Sequence No 10 from Attachments from Sales order Headers or say GL Journal Header  , do Use

Procedure "DELETE_ATTACHMENT" 

           This procedure attracts 2 mandatory parameters and those are

• attachment_document_id--> fnd_attached_docs_form_vl%attachment_document_id
• Delete_document_Flag --> 'Y'

This will delete Specific attachment (corresponding to the specific attachment_document_id) from fnd_attached_docs_form_vl