APPS.IBY_BUILD_INSTRUCTIONS_PUB_PKG dependencies on IBY_PAY_INSTRUCTIONS_ALL

Line 945: l_instr_status IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE;

941: l_return_status NUMBER;
942: l_ret_status VARCHAR2 (100);
943: l_return_message VARCHAR2 (3000);
944:
945: l_instr_status IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE;
946: l_instr_rec IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE;
947: l_instr_tab IBY_PAYINSTR_PUB.pmtInstrTabType;
948:
949: l_doc_error_tab IBY_VALIDATIONSETS_PUB.docErrorTabType;

Line 946: l_instr_rec IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE;

942: l_ret_status VARCHAR2 (100);
943: l_return_message VARCHAR2 (3000);
944:
945: l_instr_status IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE;
946: l_instr_rec IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE;
947: l_instr_tab IBY_PAYINSTR_PUB.pmtInstrTabType;
948:
949: l_doc_error_tab IBY_VALIDATIONSETS_PUB.docErrorTabType;
950: l_doc_token_tab IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType;

Line 1684: p_instr_to_skip IN IBY_PAY_INSTRUCTIONS_ALL.

1680: |
1681: *---------------------------------------------------------------------*/
1682: PROCEDURE moveInstrToDeferredStatus(
1683: p_pmtInstrTab IN OUT NOCOPY IBY_PAYINSTR_PUB.pmtInstrTabType,
1684: p_instr_to_skip IN IBY_PAY_INSTRUCTIONS_ALL.
1685: payment_instruction_id%TYPE DEFAULT NULL
1686: )
1687: IS
1688: l_module_name VARCHAR2(200) := G_PKG_NAME || '.moveInstrToDeferredStatus';

Line 1692: l_instr_status IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE;

1688: l_module_name VARCHAR2(200) := G_PKG_NAME || '.moveInstrToDeferredStatus';
1689:
1690: l_send_to_file_flag VARCHAR2(1);
1691: l_processing_type IBY_PAYMENT_PROFILES.PROCESSING_TYPE%TYPE;
1692: l_instr_status IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE;
1693:
1694: BEGIN
1695:
1696: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1750: IBY_PAY_INSTRUCTIONS_ALL

1746: END IF;
1747:
1748:
1749: UPDATE
1750: IBY_PAY_INSTRUCTIONS_ALL
1751: SET
1752: payment_instruction_status = l_instr_status
1753: WHERE
1754: payment_instruction_id = p_pmtInstrTab(i).

Line 1770: IBY_PAY_INSTRUCTIONS_ALL

1766: END IF;
1767: ELSE
1768: l_instr_status := INS_STATUS_CREATED;
1769: UPDATE
1770: IBY_PAY_INSTRUCTIONS_ALL
1771: SET
1772: payment_instruction_status = l_instr_status
1773: WHERE
1774: payment_instruction_id = p_pmtInstrTab(i).

Line 2048: l_pmt_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE)

2044: | NOTES:
2045: |
2046: *---------------------------------------------------------------------*/
2047: FUNCTION get_instruction_attributes(
2048: l_pmt_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE)
2049: RETURN IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE
2050: IS
2051:
2052: l_module_name VARCHAR2(200) := G_PKG_NAME ||

Line 2049: RETURN IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE

2045: |
2046: *---------------------------------------------------------------------*/
2047: FUNCTION get_instruction_attributes(
2048: l_pmt_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE)
2049: RETURN IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE
2050: IS
2051:
2052: l_module_name VARCHAR2(200) := G_PKG_NAME ||
2053: '.get_instruction_attributes';

Line 2055: l_instr_rec IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE;

2051:
2052: l_module_name VARCHAR2(200) := G_PKG_NAME ||
2053: '.get_instruction_attributes';
2054:
2055: l_instr_rec IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE;
2056:
2057: BEGIN
2058:
2059: SELECT

Line 2168: IBY_PAY_INSTRUCTIONS_ALL

2164: l_instr_rec.attribute13,
2165: l_instr_rec.attribute14,
2166: l_instr_rec.attribute15
2167: FROM
2168: IBY_PAY_INSTRUCTIONS_ALL
2169: WHERE
2170: payment_instruction_id = l_pmt_instr_id
2171: ;
2172: