eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_DISBURSE_SUBMIT_PUB_PKG dependencies on IBY_PAY_SERVICE_REQUESTS

Line 4: TYPE payreq_tbl_type IS TABLE of iby_pay_service_requests.

1: PACKAGE IBY_DISBURSE_SUBMIT_PUB_PKG AUTHID CURRENT_USER AS
2: /*$Header: ibybilds.pls 120.28.12020000.3 2013/02/25 10:15:41 kchavali ship $*/
3:
4: TYPE payreq_tbl_type IS TABLE of iby_pay_service_requests.
5: payment_service_request_id%TYPE
6: INDEX BY BINARY_INTEGER;
7:
8: --

Line 414: IBY_PAY_SERVICE_REQUESTS.maximum_payment_amount%TYPE

410: IBY_PAYMENT_PROFILES.declaration_threshold_amount%TYPE
411: INDEX BY BINARY_INTEGER;
412:
413: TYPE t_maximum_payment_amount IS TABLE OF
414: IBY_PAY_SERVICE_REQUESTS.maximum_payment_amount%TYPE
415: INDEX BY BINARY_INTEGER;
416: TYPE t_minimum_payment_amount IS TABLE OF
417: IBY_PAY_SERVICE_REQUESTS.minimum_payment_amount%TYPE
418: INDEX BY BINARY_INTEGER;

Line 417: IBY_PAY_SERVICE_REQUESTS.minimum_payment_amount%TYPE

413: TYPE t_maximum_payment_amount IS TABLE OF
414: IBY_PAY_SERVICE_REQUESTS.maximum_payment_amount%TYPE
415: INDEX BY BINARY_INTEGER;
416: TYPE t_minimum_payment_amount IS TABLE OF
417: IBY_PAY_SERVICE_REQUESTS.minimum_payment_amount%TYPE
418: INDEX BY BINARY_INTEGER;
419: TYPE t_allow_zero_payments_flag IS TABLE OF
420: IBY_PAY_SERVICE_REQUESTS.allow_zero_payments_flag%TYPE
421: INDEX BY BINARY_INTEGER;

Line 420: IBY_PAY_SERVICE_REQUESTS.allow_zero_payments_flag%TYPE

416: TYPE t_minimum_payment_amount IS TABLE OF
417: IBY_PAY_SERVICE_REQUESTS.minimum_payment_amount%TYPE
418: INDEX BY BINARY_INTEGER;
419: TYPE t_allow_zero_payments_flag IS TABLE OF
420: IBY_PAY_SERVICE_REQUESTS.allow_zero_payments_flag%TYPE
421: INDEX BY BINARY_INTEGER;
422:
423: TYPE t_support_bills_payable_flag IS TABLE OF
424: IBY_PAYMENT_METHODS_B.support_bills_payable_flag%TYPE

Line 881: p_status IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_status%TYPE)

877: | NOTES:
878: |
879: *---------------------------------------------------------------------*/
880: FUNCTION get_payreq_list (
881: p_status IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_status%TYPE)
882: RETURN payreq_tbl_type;
883:
884: /*--------------------------------------------------------------------
885: | NAME:

Line 905: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)

901: | NOTES:
902: |
903: *---------------------------------------------------------------------*/
904: FUNCTION get_payreq_status (
905: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)
906: RETURN VARCHAR2;
907:
908: /*--------------------------------------------------------------------
909: | NAME:

Line 929: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,

925: | NOTES:
926: |
927: *---------------------------------------------------------------------*/
928: FUNCTION insert_payreq (
929: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
930: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
931: call_app_pay_service_req_code%TYPE,
932: p_internal_bank_account_id
933: IN IBY_PAY_SERVICE_REQUESTS.

Line 930: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.

926: |
927: *---------------------------------------------------------------------*/
928: FUNCTION insert_payreq (
929: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
930: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
931: call_app_pay_service_req_code%TYPE,
932: p_internal_bank_account_id
933: IN IBY_PAY_SERVICE_REQUESTS.
934: internal_bank_account_id%TYPE,

Line 933: IN IBY_PAY_SERVICE_REQUESTS.

929: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
930: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
931: call_app_pay_service_req_code%TYPE,
932: p_internal_bank_account_id
933: IN IBY_PAY_SERVICE_REQUESTS.
934: internal_bank_account_id%TYPE,
935: p_payment_profile_id
936: IN IBY_PAY_SERVICE_REQUESTS.
937: payment_profile_id%TYPE,

Line 936: IN IBY_PAY_SERVICE_REQUESTS.

932: p_internal_bank_account_id
933: IN IBY_PAY_SERVICE_REQUESTS.
934: internal_bank_account_id%TYPE,
935: p_payment_profile_id
936: IN IBY_PAY_SERVICE_REQUESTS.
937: payment_profile_id%TYPE,
938: p_allow_zero_payments_flag
939: IN IBY_PAY_SERVICE_REQUESTS.
940: allow_zero_payments_flag%TYPE,

Line 939: IN IBY_PAY_SERVICE_REQUESTS.

935: p_payment_profile_id
936: IN IBY_PAY_SERVICE_REQUESTS.
937: payment_profile_id%TYPE,
938: p_allow_zero_payments_flag
939: IN IBY_PAY_SERVICE_REQUESTS.
940: allow_zero_payments_flag%TYPE,
941: p_maximum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
942: maximum_payment_amount%TYPE,
943: p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.

Line 941: p_maximum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.

937: payment_profile_id%TYPE,
938: p_allow_zero_payments_flag
939: IN IBY_PAY_SERVICE_REQUESTS.
940: allow_zero_payments_flag%TYPE,
941: p_maximum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
942: maximum_payment_amount%TYPE,
943: p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
944: minimum_payment_amount%TYPE,
945: p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.

Line 943: p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.

939: IN IBY_PAY_SERVICE_REQUESTS.
940: allow_zero_payments_flag%TYPE,
941: p_maximum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
942: maximum_payment_amount%TYPE,
943: p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
944: minimum_payment_amount%TYPE,
945: p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.
946: document_rejection_level_code%TYPE,
947: p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.

Line 945: p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.

941: p_maximum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
942: maximum_payment_amount%TYPE,
943: p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
944: minimum_payment_amount%TYPE,
945: p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.
946: document_rejection_level_code%TYPE,
947: p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.
948: payment_rejection_level_code%TYPE,
949: p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.

Line 947: p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.

943: p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
944: minimum_payment_amount%TYPE,
945: p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.
946: document_rejection_level_code%TYPE,
947: p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.
948: payment_rejection_level_code%TYPE,
949: p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.
950: require_prop_pmts_review_flag%TYPE,
951: p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.

Line 949: p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.

945: p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.
946: document_rejection_level_code%TYPE,
947: p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.
948: payment_rejection_level_code%TYPE,
949: p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.
950: require_prop_pmts_review_flag%TYPE,
951: p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.
952: create_pmt_instructions_flag%TYPE,
953: p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.

Line 951: p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.

947: p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.
948: payment_rejection_level_code%TYPE,
949: p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.
950: require_prop_pmts_review_flag%TYPE,
951: p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.
952: create_pmt_instructions_flag%TYPE,
953: p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.
954: payment_document_id%TYPE,
955: p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.

Line 953: p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.

949: p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.
950: require_prop_pmts_review_flag%TYPE,
951: p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.
952: create_pmt_instructions_flag%TYPE,
953: p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.
954: payment_document_id%TYPE,
955: p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.
956: attribute_category%TYPE,
957: p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.

Line 955: p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.

951: p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.
952: create_pmt_instructions_flag%TYPE,
953: p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.
954: payment_document_id%TYPE,
955: p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.
956: attribute_category%TYPE,
957: p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.
958: attribute1%TYPE,
959: p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.

Line 957: p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.

953: p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.
954: payment_document_id%TYPE,
955: p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.
956: attribute_category%TYPE,
957: p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.
958: attribute1%TYPE,
959: p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.
960: attribute2%TYPE,
961: p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.

Line 959: p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.

955: p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.
956: attribute_category%TYPE,
957: p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.
958: attribute1%TYPE,
959: p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.
960: attribute2%TYPE,
961: p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.
962: attribute3%TYPE,
963: p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.

Line 961: p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.

957: p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.
958: attribute1%TYPE,
959: p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.
960: attribute2%TYPE,
961: p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.
962: attribute3%TYPE,
963: p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.
964: attribute4%TYPE,
965: p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.

Line 963: p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.

959: p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.
960: attribute2%TYPE,
961: p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.
962: attribute3%TYPE,
963: p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.
964: attribute4%TYPE,
965: p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.
966: attribute5%TYPE,
967: p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.

Line 965: p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.

961: p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.
962: attribute3%TYPE,
963: p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.
964: attribute4%TYPE,
965: p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.
966: attribute5%TYPE,
967: p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.
968: attribute6%TYPE,
969: p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.

Line 967: p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.

963: p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.
964: attribute4%TYPE,
965: p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.
966: attribute5%TYPE,
967: p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.
968: attribute6%TYPE,
969: p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.
970: attribute7%TYPE,
971: p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.

Line 969: p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.

965: p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.
966: attribute5%TYPE,
967: p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.
968: attribute6%TYPE,
969: p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.
970: attribute7%TYPE,
971: p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.
972: attribute8%TYPE,
973: p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.

Line 971: p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.

967: p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.
968: attribute6%TYPE,
969: p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.
970: attribute7%TYPE,
971: p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.
972: attribute8%TYPE,
973: p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.
974: attribute9%TYPE,
975: p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.

Line 973: p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.

969: p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.
970: attribute7%TYPE,
971: p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.
972: attribute8%TYPE,
973: p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.
974: attribute9%TYPE,
975: p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.
976: attribute10%TYPE,
977: p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.

Line 975: p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.

971: p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.
972: attribute8%TYPE,
973: p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.
974: attribute9%TYPE,
975: p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.
976: attribute10%TYPE,
977: p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.
978: attribute11%TYPE,
979: p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.

Line 977: p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.

973: p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.
974: attribute9%TYPE,
975: p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.
976: attribute10%TYPE,
977: p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.
978: attribute11%TYPE,
979: p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.
980: attribute12%TYPE,
981: p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.

Line 979: p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.

975: p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.
976: attribute10%TYPE,
977: p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.
978: attribute11%TYPE,
979: p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.
980: attribute12%TYPE,
981: p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.
982: attribute13%TYPE,
983: p_attribute14 IN IBY_PAY_SERVICE_REQUESTS.

Line 981: p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.

977: p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.
978: attribute11%TYPE,
979: p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.
980: attribute12%TYPE,
981: p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.
982: attribute13%TYPE,
983: p_attribute14 IN IBY_PAY_SERVICE_REQUESTS.
984: attribute14%TYPE,
985: p_attribute15 IN IBY_PAY_SERVICE_REQUESTS.

Line 983: p_attribute14 IN IBY_PAY_SERVICE_REQUESTS.

979: p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.
980: attribute12%TYPE,
981: p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.
982: attribute13%TYPE,
983: p_attribute14 IN IBY_PAY_SERVICE_REQUESTS.
984: attribute14%TYPE,
985: p_attribute15 IN IBY_PAY_SERVICE_REQUESTS.
986: attribute15%TYPE
987: )

Line 985: p_attribute15 IN IBY_PAY_SERVICE_REQUESTS.

981: p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.
982: attribute13%TYPE,
983: p_attribute14 IN IBY_PAY_SERVICE_REQUESTS.
984: attribute14%TYPE,
985: p_attribute15 IN IBY_PAY_SERVICE_REQUESTS.
986: attribute15%TYPE
987: )
988: RETURN NUMBER;
989:

Line 1033: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,

1029: | NOTES:
1030: |
1031: *---------------------------------------------------------------------*/
1032: FUNCTION insert_payreq_documents (
1033: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
1034: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
1035: call_app_pay_service_req_code%TYPE,
1036: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
1037: payment_service_request_id%TYPE

Line 1034: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.

1030: |
1031: *---------------------------------------------------------------------*/
1032: FUNCTION insert_payreq_documents (
1033: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
1034: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
1035: call_app_pay_service_req_code%TYPE,
1036: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
1037: payment_service_request_id%TYPE
1038: )

Line 1036: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.

1032: FUNCTION insert_payreq_documents (
1033: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
1034: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
1035: call_app_pay_service_req_code%TYPE,
1036: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
1037: payment_service_request_id%TYPE
1038: )
1039: RETURN NUMBER;
1040:

Line 1105: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,

1101: | NOTES:
1102: |
1103: *---------------------------------------------------------------------*/
1104: FUNCTION checkIfDuplicate(
1105: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
1106: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
1107: call_app_pay_service_req_code%TYPE
1108: )
1109: RETURN NUMBER;

Line 1106: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.

1102: |
1103: *---------------------------------------------------------------------*/
1104: FUNCTION checkIfDuplicate(
1105: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
1106: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
1107: call_app_pay_service_req_code%TYPE
1108: )
1109: RETURN NUMBER;
1110:

Line 1342: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)

1338: | NOTES:
1339: |
1340: *---------------------------------------------------------------------*/
1341: FUNCTION checkIfPmtsInModifiedStatus(
1342: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)
1343: RETURN BOOLEAN;
1344:
1345: /*--------------------------------------------------------------------
1346: | NAME:

Line 1366: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)

1362: | NOTES:
1363: |
1364: *---------------------------------------------------------------------*/
1365: FUNCTION checkIfPmtsInModBankAccStatus(
1366: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)
1367: RETURN BOOLEAN;
1368:
1369: /*--------------------------------------------------------------------
1370: | NAME:

Line 1389: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.

1385: | NOTES:
1386: |
1387: *---------------------------------------------------------------------*/
1388: PROCEDURE launchPPRStatusReport(
1389: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
1390: payment_service_request_id%TYPE
1391: );
1392:
1393:

Line 1415: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,

1411: | NOTES:
1412: |
1413: *---------------------------------------------------------------------*/
1414: PROCEDURE update_payreq_status (
1415: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
1416: l_payreq_status IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_status%TYPE,
1417: x_return_status IN OUT NOCOPY VARCHAR2);
1418:
1419: PROCEDURE print_log(

Line 1416: l_payreq_status IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_status%TYPE,

1412: |
1413: *---------------------------------------------------------------------*/
1414: PROCEDURE update_payreq_status (
1415: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
1416: l_payreq_status IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_status%TYPE,
1417: x_return_status IN OUT NOCOPY VARCHAR2);
1418:
1419: PROCEDURE print_log(
1420: p_module IN VARCHAR2,