DBA Data[Home] [Help]

APPS.CLN_NTFYINVC_PKG dependencies on AR_DOCUMENT_TRANSFERS

Line 721: -- Function : Updates the status for the transaction in the 'ar_document_transfers' table.

717: -- Start of comments
718: -- API name : CLN_UPDATE_DOCUMENT_STATUS
719: -- Type : Private
720: -- Pre-reqs : None.
721: -- Function : Updates the status for the transaction in the 'ar_document_transfers' table.
722: -- Version : Current version 1.0
723: -- Previous version 1.0
724: -- Initial version 1.0
725: -- Notes :

Line 808: UPDATE ar_document_transfers

804: IF (l_debug_level <= 1) THEN
805: cln_debug_pub.Add('l_status: '|| l_status , 1);
806: END IF;
807:
808: UPDATE ar_document_transfers
809: SET status = decode(l_status,'x','TRANSMITTED','FAILED')
810: WHERE document_transfer_id = l_doc_id;
811:
812: IF (l_debug_level <= 1) THEN

Line 813: cln_debug_pub.Add('ar_document_transfers row updated', 1);

809: SET status = decode(l_status,'x','TRANSMITTED','FAILED')
810: WHERE document_transfer_id = l_doc_id;
811:
812: IF (l_debug_level <= 1) THEN
813: cln_debug_pub.Add('ar_document_transfers row updated', 1);
814: END IF;
815:
816: x_resultout := 'YES';
817: