APPS.IBY_BUILD_INSTRUCTIONS_PUB_PKG dependencies on IBY_PAY_INSTRUCTIONS_ALL

Line 836: l_instr_status IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE;

832: l_return_status NUMBER;
833: l_ret_status VARCHAR2 (100);
834: l_return_message VARCHAR2 (3000);
835:
836: l_instr_status IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE;
837: l_instr_rec IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE;
838: l_instr_tab IBY_PAYINSTR_PUB.pmtInstrTabType;
839:
840: l_doc_error_tab IBY_VALIDATIONSETS_PUB.docErrorTabType;

Line 837: l_instr_rec IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE;

833: l_ret_status VARCHAR2 (100);
834: l_return_message VARCHAR2 (3000);
835:
836: l_instr_status IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE;
837: l_instr_rec IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE;
838: l_instr_tab IBY_PAYINSTR_PUB.pmtInstrTabType;
839:
840: l_doc_error_tab IBY_VALIDATIONSETS_PUB.docErrorTabType;
841: l_doc_token_tab IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType;

Line 1336: p_instr_to_skip IN IBY_PAY_INSTRUCTIONS_ALL.

1332: |
1333: *---------------------------------------------------------------------*/
1334: PROCEDURE moveInstrToDeferredStatus(
1335: p_pmtInstrTab IN OUT NOCOPY IBY_PAYINSTR_PUB.pmtInstrTabType,
1336: p_instr_to_skip IN IBY_PAY_INSTRUCTIONS_ALL.
1337: payment_instruction_id%TYPE DEFAULT NULL
1338: )
1339: IS
1340: l_module_name VARCHAR2(200) := G_PKG_NAME || '.moveInstrToDeferredStatus';

Line 1343: l_instr_status IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE;

1339: IS
1340: l_module_name VARCHAR2(200) := G_PKG_NAME || '.moveInstrToDeferredStatus';
1341:
1342: l_send_to_file_flag VARCHAR2(1);
1343: l_instr_status IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE;
1344:
1345: BEGIN
1346:
1347: print_debuginfo(l_module_name, 'ENTER');

Line 1394: IBY_PAY_INSTRUCTIONS_ALL

1390: END IF;
1391:
1392:
1393: UPDATE
1394: IBY_PAY_INSTRUCTIONS_ALL
1395: SET
1396: payment_instruction_status = l_instr_status
1397: WHERE
1398: payment_instruction_id = p_pmtInstrTab(i).

Line 1514: l_pmt_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE)

1510: | NOTES:
1511: |
1512: *---------------------------------------------------------------------*/
1513: FUNCTION get_instruction_attributes(
1514: l_pmt_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE)
1515: RETURN IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE
1516: IS
1517:
1518: l_module_name VARCHAR2(200) := G_PKG_NAME ||

Line 1515: RETURN IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE

1511: |
1512: *---------------------------------------------------------------------*/
1513: FUNCTION get_instruction_attributes(
1514: l_pmt_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE)
1515: RETURN IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE
1516: IS
1517:
1518: l_module_name VARCHAR2(200) := G_PKG_NAME ||
1519: '.get_instruction_attributes';

Line 1521: l_instr_rec IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE;

1517:
1518: l_module_name VARCHAR2(200) := G_PKG_NAME ||
1519: '.get_instruction_attributes';
1520:
1521: l_instr_rec IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE;
1522:
1523: BEGIN
1524:
1525: SELECT

Line 1634: IBY_PAY_INSTRUCTIONS_ALL

1630: l_instr_rec.attribute13,
1631: l_instr_rec.attribute14,
1632: l_instr_rec.attribute15
1633: FROM
1634: IBY_PAY_INSTRUCTIONS_ALL
1635: WHERE
1636: payment_instruction_id = l_pmt_instr_id
1637: ;
1638: