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_PAYGROUP_PUB dependencies on IBY_PAYMENTS_ALL

Line 253: * payments in the IBY_PAYMENTS_ALL table. Therefore, insert

249: /*
250: * Fix for bug 5935493:
251: *
252: * Payment validations are dependent upon finding the
253: * payments in the IBY_PAYMENTS_ALL table. Therefore, insert
254: * the payments from the PLSQL table into the
255: * IBY_PAYMENTS_ALL table.
256: *
257: * Central bank reporting could be implemented via a hook

Line 255: * IBY_PAYMENTS_ALL table.

251: *
252: * Payment validations are dependent upon finding the
253: * payments in the IBY_PAYMENTS_ALL table. Therefore, insert
254: * the payments from the PLSQL table into the
255: * IBY_PAYMENTS_ALL table.
256: *
257: * Central bank reporting could be implemented via a hook
258: * that is expecting payments to be populated in
259: * IBY_PAYMENTS_ALL table. Therefore, payments need to

Line 259: * IBY_PAYMENTS_ALL table. Therefore, payments need to

255: * IBY_PAYMENTS_ALL table.
256: *
257: * Central bank reporting could be implemented via a hook
258: * that is expecting payments to be populated in
259: * IBY_PAYMENTS_ALL table. Therefore, payments need to
260: * inserted before performing central bank reporting as well.
261: */
262: IF (l_payreq_status <> REQ_STATUS_RETRY_PMT_CREAT AND
263: l_payreq_status <> REQ_STATUS_USER_REVW_ERR) THEN

Line 351: * update the payments in IBY_PAYMENTS_ALL table

347: *
348: * After central bank reporting is completed,
349: * the declare payments flag could be set on some/all
350: * payments by the hook. Therefore, we need to
351: * update the payments in IBY_PAYMENTS_ALL table
352: * so that this flag is accessible for validation.
353: */
354: updatePayments(l_paymentTab);
355:

Line 695: l_bank_inst1_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;

691: */
692: l_impossible_date DATE := TO_DATE('01/01/5100 10:25:55',
693: 'MM/DD/YYYY HH24:MI:SS');
694:
695: l_bank_inst1_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
696: l_bank_inst2_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
697: l_pmt_txt_msg1 IBY_PAYMENTS_ALL.payment_text_message1%TYPE;
698: l_pmt_txt_msg2 IBY_PAYMENTS_ALL.payment_text_message2%TYPE;
699: l_pmt_txt_msg3 IBY_PAYMENTS_ALL.payment_text_message3%TYPE;

Line 696: l_bank_inst2_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;

692: l_impossible_date DATE := TO_DATE('01/01/5100 10:25:55',
693: 'MM/DD/YYYY HH24:MI:SS');
694:
695: l_bank_inst1_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
696: l_bank_inst2_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
697: l_pmt_txt_msg1 IBY_PAYMENTS_ALL.payment_text_message1%TYPE;
698: l_pmt_txt_msg2 IBY_PAYMENTS_ALL.payment_text_message2%TYPE;
699: l_pmt_txt_msg3 IBY_PAYMENTS_ALL.payment_text_message3%TYPE;
700:

Line 697: l_pmt_txt_msg1 IBY_PAYMENTS_ALL.payment_text_message1%TYPE;

693: 'MM/DD/YYYY HH24:MI:SS');
694:
695: l_bank_inst1_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
696: l_bank_inst2_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
697: l_pmt_txt_msg1 IBY_PAYMENTS_ALL.payment_text_message1%TYPE;
698: l_pmt_txt_msg2 IBY_PAYMENTS_ALL.payment_text_message2%TYPE;
699: l_pmt_txt_msg3 IBY_PAYMENTS_ALL.payment_text_message3%TYPE;
700:
701: l_processing_type VARCHAR2(100); -- CHECK | ELECTRONIC

Line 698: l_pmt_txt_msg2 IBY_PAYMENTS_ALL.payment_text_message2%TYPE;

694:
695: l_bank_inst1_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
696: l_bank_inst2_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
697: l_pmt_txt_msg1 IBY_PAYMENTS_ALL.payment_text_message1%TYPE;
698: l_pmt_txt_msg2 IBY_PAYMENTS_ALL.payment_text_message2%TYPE;
699: l_pmt_txt_msg3 IBY_PAYMENTS_ALL.payment_text_message3%TYPE;
700:
701: l_processing_type VARCHAR2(100); -- CHECK | ELECTRONIC
702: l_calc_doc_detail VARCHAR2(1000); -- Stores details for a single doc

Line 699: l_pmt_txt_msg3 IBY_PAYMENTS_ALL.payment_text_message3%TYPE;

695: l_bank_inst1_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
696: l_bank_inst2_code IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE;
697: l_pmt_txt_msg1 IBY_PAYMENTS_ALL.payment_text_message1%TYPE;
698: l_pmt_txt_msg2 IBY_PAYMENTS_ALL.payment_text_message2%TYPE;
699: l_pmt_txt_msg3 IBY_PAYMENTS_ALL.payment_text_message3%TYPE;
700:
701: l_processing_type VARCHAR2(100); -- CHECK | ELECTRONIC
702: l_calc_doc_detail VARCHAR2(1000); -- Stores details for a single doc
703:

Line 726: l_paymentRec IBY_PAYMENTS_ALL%ROWTYPE;

722: /* rejection level system options */
723: l_rejection_level VARCHAR2(200);
724: l_review_pmts_flag VARCHAR2(1) := 'N';
725:
726: l_paymentRec IBY_PAYMENTS_ALL%ROWTYPE;
727: l_docsInPmtRec IBY_PAYGROUP_PUB.docsInPaymentRecType;
728:
729: /*
730: * These two are related data structures. Each row in paymentTabType

Line 731: * PLSQL table is used in inserting a row into the IBY_PAYMENTS_ALL

727: l_docsInPmtRec IBY_PAYGROUP_PUB.docsInPaymentRecType;
728:
729: /*
730: * These two are related data structures. Each row in paymentTabType
731: * PLSQL table is used in inserting a row into the IBY_PAYMENTS_ALL
732: * table.
733: *
734: * Since the IBY_PAYMENTS_ALL table does not contain a document id, a
735: * separate data structure is needed to keep track of the documents

Line 734: * Since the IBY_PAYMENTS_ALL table does not contain a document id, a

730: * These two are related data structures. Each row in paymentTabType
731: * PLSQL table is used in inserting a row into the IBY_PAYMENTS_ALL
732: * table.
733: *
734: * Since the IBY_PAYMENTS_ALL table does not contain a document id, a
735: * separate data structure is needed to keep track of the documents
736: * that are part of a payment. This information is tracked in the
737: * docsInPaymentTabType table. The rows in docsInPaymentTabType are
738: * used to update the rows in IBY_DOCS_PAYABLE_ALL table with

Line 742: * (insert into IBY_PAYMENTS_ALL) (update IBY_DOCS_PAYABLE)

738: * used to update the rows in IBY_DOCS_PAYABLE_ALL table with
739: * payment ids.
740: *
741: * x_paymentTab x_docsInPmtTab
742: * (insert into IBY_PAYMENTS_ALL) (update IBY_DOCS_PAYABLE)
743: * /-------------------------------------\ /------------\
744: * |Payment|Payment|..|Payment|Docs |..| |Payment|Doc |
745: * |Id |Profile|..|Amount |Payable|..| |Id |Id |
746: * | |Id |..| |Count |..| | | |

Line 1664: * The length of the payment details field in IBY_PAYMENTS_ALL

1660: l_calc_doc_detail := null;
1661: END IF;
1662:
1663: /*
1664: * The length of the payment details field in IBY_PAYMENTS_ALL
1665: * table is 240 chars. This imposes a hard limit for the
1666: * length of payment details that can be stored against a
1667: * payment.
1668: *

Line 2611: x_paymentRec IN OUT NOCOPY IBY_PAYMENTS_ALL%ROWTYPE,

2607: | NOTES:
2608: |
2609: *---------------------------------------------------------------------*/
2610: PROCEDURE insertDocIntoPayment(
2611: x_paymentRec IN OUT NOCOPY IBY_PAYMENTS_ALL%ROWTYPE,
2612: x_paymentTab IN OUT NOCOPY paymentTabType,
2613: p_calcDocInfo IN VARCHAR2,
2614: p_newPaymentFlag IN BOOLEAN,
2615: x_currentPaymentId IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE,

Line 2615: x_currentPaymentId IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE,

2611: x_paymentRec IN OUT NOCOPY IBY_PAYMENTS_ALL%ROWTYPE,
2612: x_paymentTab IN OUT NOCOPY paymentTabType,
2613: p_calcDocInfo IN VARCHAR2,
2614: p_newPaymentFlag IN BOOLEAN,
2615: x_currentPaymentId IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE,
2616: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
2617: x_docsInPmtRec IN OUT NOCOPY docsInPaymentRecType,
2618: x_docsInPmtCount IN OUT NOCOPY NUMBER
2619: )

Line 2777: | table into IBY_PAYMENTS_ALL table.

2773: | insertPayments
2774: |
2775: | PURPOSE:
2776: | Performs a bulk insert of all created payments from PLSQL
2777: | table into IBY_PAYMENTS_ALL table.
2778: |
2779: | PARAMETERS:
2780: | IN
2781: |

Line 2796: TYPE tax_regis_num IS TABLE OF iby_payments_all.payee_tax_registration_num%TYPE INDEX BY BINARY_INTEGER;

2792: p_paymentTab IN paymentTabType
2793: )
2794: IS
2795: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.insertPayments';
2796: TYPE tax_regis_num IS TABLE OF iby_payments_all.payee_tax_registration_num%TYPE INDEX BY BINARY_INTEGER;
2797: l_tax_registration_num tax_regis_num;
2798: BEGIN
2799:
2800: print_debuginfo(l_module_name, 'ENTER');

Line 2805: || ' were found to insert into IBY_PAYMENTS_ALL table.'

2801:
2802: /* Normally, this shouldn't happen */
2803: IF (p_paymentTab.COUNT = 0) THEN
2804: print_debuginfo(l_module_name, 'After grouping, no payments'
2805: || ' were found to insert into IBY_PAYMENTS_ALL table.'
2806: || ' Possible data corruption issue.');
2807: RETURN;
2808: END IF;
2809:

Line 3173: * Bulk insert into IBY_PAYMENTS_ALL table using the

3169: END LOOP;
3170:
3171:
3172: /*
3173: * Bulk insert into IBY_PAYMENTS_ALL table using the
3174: * named columns syntax. This avoids any dependencies on
3175: * column order.
3176: */
3177: FORALL i in nvl(paymentTab.payment_id.FIRST,0) .. nvl(paymentTab.payment_id.LAST,-99)

Line 3178: INSERT INTO IBY_PAYMENTS_ALL

3174: * named columns syntax. This avoids any dependencies on
3175: * column order.
3176: */
3177: FORALL i in nvl(paymentTab.payment_id.FIRST,0) .. nvl(paymentTab.payment_id.LAST,-99)
3178: INSERT INTO IBY_PAYMENTS_ALL
3179: (
3180: payment_id,
3181: payment_method_code,
3182: payment_service_request_id,

Line 3704: | table into IBY_PAYMENTS_ALL table.

Line 3707: | IBY_PAYMENTS_ALL after grouping. So we only need to update

Line 3736: || ' were found to update IBY_PAYMENTS_ALL table.');

3732:
3733: /* Normally, this shouldn't happen */
3734: IF (p_paymentTab.COUNT = 0) THEN
3735: print_debuginfo(l_module_name, 'No payments'
3736: || ' were found to update IBY_PAYMENTS_ALL table.');
3737: RETURN;
3738: END IF;
3739:
3740: FOR i in p_paymentTab.FIRST..p_paymentTab.LAST LOOP

Line 3743: IBY_PAYMENTS_ALL

3739:
3740: FOR i in p_paymentTab.FIRST..p_paymentTab.LAST LOOP
3741:
3742: UPDATE
3743: IBY_PAYMENTS_ALL
3744: SET
3745: payment_status = p_paymentTab(i).payment_status,
3746: payment_amount = p_paymentTab(i).payment_amount,
3747: discount_amount_taken = p_paymentTab(i).discount_amount_taken,

Line 3785: x_paymentID IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE

3781: | NOTES:
3782: |
3783: *---------------------------------------------------------------------*/
3784: PROCEDURE getNextPaymentID(
3785: x_paymentID IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE
3786: )
3787: IS
3788:
3789: BEGIN

Line 3791: SELECT IBY_PAYMENTS_ALL_S.nextval INTO x_paymentID

3787: IS
3788:
3789: BEGIN
3790:
3791: SELECT IBY_PAYMENTS_ALL_S.nextval INTO x_paymentID
3792: FROM DUAL;
3793:
3794: END getNextPaymentID;
3795:

Line 3931: l_pmt_fx_amount iby_payments_all.payment_amount%TYPE := -1;

3927: IS
3928:
3929: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME
3930: || '.performCentralBankReporting';
3931: l_pmt_fx_amount iby_payments_all.payment_amount%TYPE := -1;
3932: l_return_status VARCHAR2(200);
3933: l_declare_flag VARCHAR2(1);
3934: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%type;
3935:

Line 4807: l_orig_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;

4803: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
4804: )
4805: IS
4806:
4807: l_orig_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
4808: l_orig_doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
4809: l_orig_pmt_grp_num IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE;
4810:
4811: l_compare_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;

Line 4811: l_compare_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;

4807: l_orig_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
4808: l_orig_doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
4809: l_orig_pmt_grp_num IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE;
4810:
4811: l_compare_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
4812: l_compare_doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
4813:
4814: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
4815:

Line 7174: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,

7170: | NOTES:
7171: |
7172: *---------------------------------------------------------------------*/
7173: PROCEDURE failDocsOfPayment(
7174: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
7175: p_docStatus IN IBY_DOCS_PAYABLE_ALL.
7176: document_status%TYPE,
7177: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
7178: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

Line 7609: l_triggering_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;

7605: l_request_status VARCHAR2(200);
7606: l_orig_req_status VARCHAR2(200);
7607:
7608: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
7609: l_triggering_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
7610:
7611: BEGIN
7612:
7613: print_debuginfo(l_module_name, 'ENTER');

Line 8087: CURSOR c_pmt_val_sets(p_payment_id IBY_PAYMENTS_ALL.payment_id%TYPE)

8083:
8084: /*
8085: * Pick up all validation sets applicable to a particular payment.
8086: */
8087: CURSOR c_pmt_val_sets(p_payment_id IBY_PAYMENTS_ALL.payment_id%TYPE)
8088: IS
8089: SELECT DISTINCT
8090: val_asgn.validation_assignment_id,
8091: val_asgn.val_assignment_entity_type,

Line 8099: IBY_PAYMENTS_ALL pmts,

8095: val.validation_code_entry_point
8096: FROM
8097: IBY_VALIDATION_SETS_VL val,
8098: IBY_VAL_ASSIGNMENTS val_asgn,
8099: IBY_PAYMENTS_ALL pmts,
8100: IBY_SYS_PMT_PROFILES_B sys_prof,
8101: IBY_ACCT_PMT_PROFILES_B acct_prof,
8102: IBY_TRANSMIT_CONFIGS_B txconf,
8103: IBY_TRANSMIT_PROTOCOLS_B txproto,

Line 8807: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,

8803: | NOTES:
8804: |
8805: *---------------------------------------------------------------------*/
8806: FUNCTION checkIfPmtAlreadyFailed(
8807: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
8808: p_paymentTab IN paymentTabType
8809: )
8810: RETURN BOOLEAN
8811: IS

Line 8855: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,

8851: | NOTES:
8852: |
8853: *---------------------------------------------------------------------*/
8854: FUNCTION checkIfPmtAlreadyAdded(
8855: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
8856: p_paymentTab IN pmtIdsTab
8857: )
8858: RETURN BOOLEAN
8859: IS

Line 10347: p_pmt_method_code IN IBY_PAYMENTS_ALL.payment_method_code%TYPE,

10343: | NOTES:
10344: |
10345: *---------------------------------------------------------------------*/
10346: FUNCTION getMaturityDaysForPmtMethod(
10347: p_pmt_method_code IN IBY_PAYMENTS_ALL.payment_method_code%TYPE,
10348: p_maturityDaysTab IN pmtMethodMaturityDaysTab
10349: ) RETURN NUMBER
10350: IS
10351: l_maturity_days_offset IBY_PAYMENT_METHODS_VL.maturity_date_offset_days%TYPE

Line 10417: p_adjustedPmtId IN IBY_PAYMENTS_ALL.payment_id%TYPE,

10413: | NOTES:
10414: |
10415: *---------------------------------------------------------------------*/
10416: PROCEDURE refreshDocAndPmtAmounts(
10417: p_adjustedPmtId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
10418: p_adjustedNegDocsTab IN docsInPaymentTabType,
10419: x_paymentTab IN OUT NOCOPY paymentTabType,
10420: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType
10421: )

Line 11217: l_pmt_amount IBY_PAYMENTS_ALL.payment_amount%TYPE;

11213: * Stores the documents payable for a single payment.
11214: */
11215: l_docsForPmtTab IBY_PAYGROUP_PUB.docsInPaymentTabType;
11216:
11217: l_pmt_amount IBY_PAYMENTS_ALL.payment_amount%TYPE;
11218:
11219: /*
11220: * For storing central bank reporting information related to
11221: * each payment.

Line 11234: IBY_PAYMENTS_ALL

11230: IS
11231: SELECT
11232: *
11233: FROM
11234: IBY_PAYMENTS_ALL
11235: WHERE
11236: payment_service_request_id = p_payment_request_id AND
11237:
11238: /*

Line 11320: IBY_PAYMENTS_ALL pmt,

11316: prof.declaration_curr_fx_rate_type,
11317: prof.declaration_currency_code,
11318: prof.declaration_threshold_amount
11319: FROM
11320: IBY_PAYMENTS_ALL pmt,
11321: IBY_PAYMENT_PROFILES prof
11322: WHERE
11323: pmt.payment_id = p_payment_id AND
11324: pmt.payment_profile_id = prof.payment_profile_id

Line 11848: IBY_PAYMENTS_ALL pmt,

11844:
11845: FROM
11846:
11847: /* Payment related */
11848: IBY_PAYMENTS_ALL pmt,
11849:
11850: /* Profile related */
11851: IBY_PAYMENT_PROFILES prof,
11852:

Line 12574: IBY_PAYMENTS_ALL pmt,

12570: )
12571: ) add_concat
12572:
12573: FROM
12574: IBY_PAYMENTS_ALL pmt,
12575:
12576: /* Employee address related */
12577: HR_LOCATIONS per_loc,
12578: PER_ADDRESSES per_addr,

Line 12991: IBY_PAYMENTS_ALL pmt,

12987:
12988: FROM
12989:
12990: /* Payment related */
12991: IBY_PAYMENTS_ALL pmt,
12992:
12993: /* Profile related */
12994: IBY_PAYMENT_PROFILES prof,
12995:

Line 13719: IBY_PAYMENTS_ALL pmt,

13715: )
13716: ) add_concat
13717:
13718: FROM
13719: IBY_PAYMENTS_ALL pmt,
13720:
13721: /* Employee address related */
13722: HR_LOCATIONS per_loc,
13723: PER_ADDRESSES per_addr,

Line 13904: * Update the IBY_PAYMENTS_ALL table using the retrieved

13900:
13901: END LOOP;
13902:
13903: /*
13904: * Update the IBY_PAYMENTS_ALL table using the retrieved
13905: * audit information.
13906: */
13907: insertAuditData(l_pmtAuditTab);
13908:

Line 13947: || 'was provided to update IBY_PAYMENTS_ALL table. '

13943: /* Normally, this shouldn't happen */
13944: IF (p_auditPmtTab.COUNT = 0) THEN
13945:
13946: print_debuginfo(l_module_name, 'No audit data '
13947: || 'was provided to update IBY_PAYMENTS_ALL table. '
13948: || 'Exiting ..'
13949: );
13950:
13951: print_debuginfo(l_module_name, 'EXIT');

Line 13961: IBY_PAYMENTS_ALL

13957:
13958: FOR i IN p_auditPmtTab.FIRST .. p_auditPmtTab.LAST LOOP
13959:
13960: UPDATE
13961: IBY_PAYMENTS_ALL
13962: SET
13963: payer_party_number = p_auditPmtTab(i).
13964: payer_party_number,
13965: payer_party_site_name = p_auditPmtTab(i).