8101: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
8102: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
8103:
8104: l_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE;
8105: l_trxn_handling IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE;
8106: l_edi_pmt_format IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE;
8107:
8108: BEGIN
8109:
8102: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
8103:
8104: l_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE;
8105: l_trxn_handling IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE;
8106: l_edi_pmt_format IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE;
8107:
8108: BEGIN
8109:
8110: /*
8203: INTO
8204: l_trxn_handling
8205: FROM
8206: IBY_DOCS_PAYABLE_ALL doc,
8207: IBY_EXTERNAL_PAYEES_ALL ep
8208: WHERE
8209: doc.document_payable_id = p_document_id
8210: AND doc.ext_payee_id = ep.ext_payee_id
8211: ;
8273: INTO
8274: l_edi_pmt_format
8275: FROM
8276: IBY_DOCS_PAYABLE_ALL doc,
8277: IBY_EXTERNAL_PAYEES_ALL ep
8278: WHERE
8279: doc.document_payable_id = p_document_id
8280: AND doc.ext_payee_id = ep.ext_payee_id
8281: ;