1: PACKAGE IBY_DISBURSE_SUBMIT_PUB_PKG AS
2: /*$Header: ibybilds.pls 120.22.12010000.3 2008/12/02 20:55:44 pschalla 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: --
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;
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;
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
770: | NOTES:
771: |
772: *---------------------------------------------------------------------*/
773: FUNCTION get_payreq_list (
774: p_status IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_status%TYPE)
775: RETURN payreq_tbl_type;
776:
777: /*--------------------------------------------------------------------
778: | NAME:
794: | NOTES:
795: |
796: *---------------------------------------------------------------------*/
797: FUNCTION get_payreq_status (
798: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)
799: RETURN VARCHAR2;
800:
801: /*--------------------------------------------------------------------
802: | NAME:
818: | NOTES:
819: |
820: *---------------------------------------------------------------------*/
821: FUNCTION insert_payreq (
822: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
823: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
824: call_app_pay_service_req_code%TYPE,
825: p_internal_bank_account_id
826: IN IBY_PAY_SERVICE_REQUESTS.
819: |
820: *---------------------------------------------------------------------*/
821: FUNCTION insert_payreq (
822: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
823: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
824: call_app_pay_service_req_code%TYPE,
825: p_internal_bank_account_id
826: IN IBY_PAY_SERVICE_REQUESTS.
827: internal_bank_account_id%TYPE,
822: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
823: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
824: call_app_pay_service_req_code%TYPE,
825: p_internal_bank_account_id
826: IN IBY_PAY_SERVICE_REQUESTS.
827: internal_bank_account_id%TYPE,
828: p_payment_profile_id
829: IN IBY_PAY_SERVICE_REQUESTS.
830: payment_profile_id%TYPE,
825: p_internal_bank_account_id
826: IN IBY_PAY_SERVICE_REQUESTS.
827: internal_bank_account_id%TYPE,
828: p_payment_profile_id
829: IN IBY_PAY_SERVICE_REQUESTS.
830: payment_profile_id%TYPE,
831: p_allow_zero_payments_flag
832: IN IBY_PAY_SERVICE_REQUESTS.
833: allow_zero_payments_flag%TYPE,
828: p_payment_profile_id
829: IN IBY_PAY_SERVICE_REQUESTS.
830: payment_profile_id%TYPE,
831: p_allow_zero_payments_flag
832: IN IBY_PAY_SERVICE_REQUESTS.
833: allow_zero_payments_flag%TYPE,
834: p_maximum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
835: maximum_payment_amount%TYPE,
836: p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
830: payment_profile_id%TYPE,
831: p_allow_zero_payments_flag
832: IN IBY_PAY_SERVICE_REQUESTS.
833: allow_zero_payments_flag%TYPE,
834: p_maximum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
835: maximum_payment_amount%TYPE,
836: p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
837: minimum_payment_amount%TYPE,
838: p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.
832: IN IBY_PAY_SERVICE_REQUESTS.
833: allow_zero_payments_flag%TYPE,
834: p_maximum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
835: maximum_payment_amount%TYPE,
836: p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
837: minimum_payment_amount%TYPE,
838: p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.
839: document_rejection_level_code%TYPE,
840: p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.
834: p_maximum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
835: maximum_payment_amount%TYPE,
836: p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
837: minimum_payment_amount%TYPE,
838: p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.
839: document_rejection_level_code%TYPE,
840: p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.
841: payment_rejection_level_code%TYPE,
842: p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.
836: p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
837: minimum_payment_amount%TYPE,
838: p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.
839: document_rejection_level_code%TYPE,
840: p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.
841: payment_rejection_level_code%TYPE,
842: p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.
843: require_prop_pmts_review_flag%TYPE,
844: p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.
838: p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.
839: document_rejection_level_code%TYPE,
840: p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.
841: payment_rejection_level_code%TYPE,
842: p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.
843: require_prop_pmts_review_flag%TYPE,
844: p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.
845: create_pmt_instructions_flag%TYPE,
846: p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.
840: p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.
841: payment_rejection_level_code%TYPE,
842: p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.
843: require_prop_pmts_review_flag%TYPE,
844: p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.
845: create_pmt_instructions_flag%TYPE,
846: p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.
847: payment_document_id%TYPE,
848: p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.
842: p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.
843: require_prop_pmts_review_flag%TYPE,
844: p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.
845: create_pmt_instructions_flag%TYPE,
846: p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.
847: payment_document_id%TYPE,
848: p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.
849: attribute_category%TYPE,
850: p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.
844: p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.
845: create_pmt_instructions_flag%TYPE,
846: p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.
847: payment_document_id%TYPE,
848: p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.
849: attribute_category%TYPE,
850: p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.
851: attribute1%TYPE,
852: p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.
846: p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.
847: payment_document_id%TYPE,
848: p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.
849: attribute_category%TYPE,
850: p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.
851: attribute1%TYPE,
852: p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.
853: attribute2%TYPE,
854: p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.
848: p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.
849: attribute_category%TYPE,
850: p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.
851: attribute1%TYPE,
852: p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.
853: attribute2%TYPE,
854: p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.
855: attribute3%TYPE,
856: p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.
850: p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.
851: attribute1%TYPE,
852: p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.
853: attribute2%TYPE,
854: p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.
855: attribute3%TYPE,
856: p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.
857: attribute4%TYPE,
858: p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.
852: p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.
853: attribute2%TYPE,
854: p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.
855: attribute3%TYPE,
856: p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.
857: attribute4%TYPE,
858: p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.
859: attribute5%TYPE,
860: p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.
854: p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.
855: attribute3%TYPE,
856: p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.
857: attribute4%TYPE,
858: p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.
859: attribute5%TYPE,
860: p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.
861: attribute6%TYPE,
862: p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.
856: p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.
857: attribute4%TYPE,
858: p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.
859: attribute5%TYPE,
860: p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.
861: attribute6%TYPE,
862: p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.
863: attribute7%TYPE,
864: p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.
858: p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.
859: attribute5%TYPE,
860: p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.
861: attribute6%TYPE,
862: p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.
863: attribute7%TYPE,
864: p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.
865: attribute8%TYPE,
866: p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.
860: p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.
861: attribute6%TYPE,
862: p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.
863: attribute7%TYPE,
864: p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.
865: attribute8%TYPE,
866: p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.
867: attribute9%TYPE,
868: p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.
862: p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.
863: attribute7%TYPE,
864: p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.
865: attribute8%TYPE,
866: p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.
867: attribute9%TYPE,
868: p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.
869: attribute10%TYPE,
870: p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.
864: p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.
865: attribute8%TYPE,
866: p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.
867: attribute9%TYPE,
868: p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.
869: attribute10%TYPE,
870: p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.
871: attribute11%TYPE,
872: p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.
866: p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.
867: attribute9%TYPE,
868: p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.
869: attribute10%TYPE,
870: p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.
871: attribute11%TYPE,
872: p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.
873: attribute12%TYPE,
874: p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.
868: p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.
869: attribute10%TYPE,
870: p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.
871: attribute11%TYPE,
872: p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.
873: attribute12%TYPE,
874: p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.
875: attribute13%TYPE,
876: p_attribute14 IN IBY_PAY_SERVICE_REQUESTS.
870: p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.
871: attribute11%TYPE,
872: p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.
873: attribute12%TYPE,
874: p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.
875: attribute13%TYPE,
876: p_attribute14 IN IBY_PAY_SERVICE_REQUESTS.
877: attribute14%TYPE,
878: p_attribute15 IN IBY_PAY_SERVICE_REQUESTS.
872: p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.
873: attribute12%TYPE,
874: p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.
875: attribute13%TYPE,
876: p_attribute14 IN IBY_PAY_SERVICE_REQUESTS.
877: attribute14%TYPE,
878: p_attribute15 IN IBY_PAY_SERVICE_REQUESTS.
879: attribute15%TYPE
880: )
874: p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.
875: attribute13%TYPE,
876: p_attribute14 IN IBY_PAY_SERVICE_REQUESTS.
877: attribute14%TYPE,
878: p_attribute15 IN IBY_PAY_SERVICE_REQUESTS.
879: attribute15%TYPE
880: )
881: RETURN NUMBER;
882:
922: | NOTES:
923: |
924: *---------------------------------------------------------------------*/
925: FUNCTION insert_payreq_documents (
926: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
927: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
928: call_app_pay_service_req_code%TYPE,
929: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
930: payment_service_request_id%TYPE
923: |
924: *---------------------------------------------------------------------*/
925: FUNCTION insert_payreq_documents (
926: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
927: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
928: call_app_pay_service_req_code%TYPE,
929: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
930: payment_service_request_id%TYPE
931: )
925: FUNCTION insert_payreq_documents (
926: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
927: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
928: call_app_pay_service_req_code%TYPE,
929: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
930: payment_service_request_id%TYPE
931: )
932: RETURN NUMBER;
933:
994: | NOTES:
995: |
996: *---------------------------------------------------------------------*/
997: FUNCTION checkIfDuplicate(
998: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
999: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
1000: call_app_pay_service_req_code%TYPE
1001: )
1002: RETURN NUMBER;
995: |
996: *---------------------------------------------------------------------*/
997: FUNCTION checkIfDuplicate(
998: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
999: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
1000: call_app_pay_service_req_code%TYPE
1001: )
1002: RETURN NUMBER;
1003:
1231: | NOTES:
1232: |
1233: *---------------------------------------------------------------------*/
1234: FUNCTION checkIfPmtsInModifiedStatus(
1235: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)
1236: RETURN BOOLEAN;
1237:
1238: /*--------------------------------------------------------------------
1239: | NAME:
1255: | NOTES:
1256: |
1257: *---------------------------------------------------------------------*/
1258: FUNCTION checkIfPmtsInModBankAccStatus(
1259: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)
1260: RETURN BOOLEAN;
1261:
1262: /*--------------------------------------------------------------------
1263: | NAME:
1278: | NOTES:
1279: |
1280: *---------------------------------------------------------------------*/
1281: PROCEDURE launchPPRStatusReport(
1282: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
1283: payment_service_request_id%TYPE
1284: );
1285:
1286: END IBY_DISBURSE_SUBMIT_PUB_PKG;