1401: p_doc_payable_id OUT NOCOPY NUMBER,
1402: p_return_status OUT NOCOPY VARCHAR2)
1403: IS
1404:
1405: l_docs_payable_rec IBY_DOCS_PAYABLE_GT%ROWTYPE;
1406: l_return_status VARCHAR2(20);
1407: l_msg_count NUMBER;
1408: l_msg_data VARCHAR2(1000);
1409: l_transaction_id NUMBER;
1447: PAYMENT_REASON_COMMENTS,
1448: REMITTANCE_MESSAGE1,
1449: REMITTANCE_MESSAGE2,
1450: REMITTANCE_MESSAGE3,
1451: IBY_DOCS_PAYABLE_GT_S.nextval
1452: INTO
1453: l_docs_payable_rec.anticipated_value_date,
1454: l_docs_payable_rec.allow_removing_document_flag,
1455: l_docs_payable_rec.bank_charge_bearer,
1485: ce_payment_transactions
1486: WHERE
1487: trxn_reference_number = p_trxn_reference_number;
1488:
1489: log('inserting data into iby_docs_payable_gt');
1490:
1491: INSERT INTO IBY_DOCS_PAYABLE_GT(
1492: ANTICIPATED_VALUE_DATE,
1493: ALLOW_REMOVING_DOCUMENT_FLAG,
1487: trxn_reference_number = p_trxn_reference_number;
1488:
1489: log('inserting data into iby_docs_payable_gt');
1490:
1491: INSERT INTO IBY_DOCS_PAYABLE_GT(
1492: ANTICIPATED_VALUE_DATE,
1493: ALLOW_REMOVING_DOCUMENT_FLAG,
1494: BANK_CHARGE_BEARER,
1495: CALLING_APP_DOC_UNIQUE_REF1,