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_SINGPAY_PUB dependencies on IBY_PAYGROUP_PUB

Line 64: | IBY_PAYGROUP_PUB package. That package is meant for normal

Line 103: -- l_cbrTab IBY_PAYGROUP_PUB.centralBankReportTabType;

99: l_decl_curr_code VARCHAR2(10) := '';
100: l_decl_threshold_amount NUMBER(15) := 0;
101:
102: /* Bug 5709596 */
103: -- l_cbrTab IBY_PAYGROUP_PUB.centralBankReportTabType;
104:
105: l_ca_payreq_cd VARCHAR2(255) := '';
106: l_ca_id NUMBER(15) := 0;
107: l_all_pmts_success_flag BOOLEAN := FALSE;

Line 114: l_paymentTab IBY_PAYGROUP_PUB.paymentTabType;

110: /* rejection level system options */
111: l_rejection_level VARCHAR2(200);
112: l_review_pmts_flag VARCHAR2(1) := 'N';
113:
114: l_paymentTab IBY_PAYGROUP_PUB.paymentTabType;
115: l_docsInPmtTab IBY_PAYGROUP_PUB.docsInPaymentTabType;
116:
117: /* these two are passed to calling app via hook */
118: l_hookPaymentTab IBY_PAYGROUP_PUB.hookPaymentTabType;

Line 115: l_docsInPmtTab IBY_PAYGROUP_PUB.docsInPaymentTabType;

111: l_rejection_level VARCHAR2(200);
112: l_review_pmts_flag VARCHAR2(1) := 'N';
113:
114: l_paymentTab IBY_PAYGROUP_PUB.paymentTabType;
115: l_docsInPmtTab IBY_PAYGROUP_PUB.docsInPaymentTabType;
116:
117: /* these two are passed to calling app via hook */
118: l_hookPaymentTab IBY_PAYGROUP_PUB.hookPaymentTabType;
119: l_hookDocsInPmtTab IBY_PAYGROUP_PUB.hookDocsInPaymentTabType;

Line 118: l_hookPaymentTab IBY_PAYGROUP_PUB.hookPaymentTabType;

114: l_paymentTab IBY_PAYGROUP_PUB.paymentTabType;
115: l_docsInPmtTab IBY_PAYGROUP_PUB.docsInPaymentTabType;
116:
117: /* these two are passed to calling app via hook */
118: l_hookPaymentTab IBY_PAYGROUP_PUB.hookPaymentTabType;
119: l_hookDocsInPmtTab IBY_PAYGROUP_PUB.hookDocsInPaymentTabType;
120:
121: /* holds the error messages against failed documents */
122: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

Line 119: l_hookDocsInPmtTab IBY_PAYGROUP_PUB.hookDocsInPaymentTabType;

115: l_docsInPmtTab IBY_PAYGROUP_PUB.docsInPaymentTabType;
116:
117: /* these two are passed to calling app via hook */
118: l_hookPaymentTab IBY_PAYGROUP_PUB.hookPaymentTabType;
119: l_hookDocsInPmtTab IBY_PAYGROUP_PUB.hookDocsInPaymentTabType;
120:
121: /* holds the error messages against failed documents */
122: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
123: l_docTokenTab IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType;

Line 127: l_payReqCriteria IBY_PAYGROUP_PUB.payReqImposedCriteria;

123: l_docTokenTab IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType;
124:
125: /* payment request imposed limits on payments */
126: /* not used but needs to be passed into performDocumentGrouping() method */
127: l_payReqCriteria IBY_PAYGROUP_PUB.payReqImposedCriteria;
128:
129: BEGIN
130:
131: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 141: IBY_PAYGROUP_PUB.performDocumentGrouping(p_payment_request_id

137: END IF;
138: /*
139: * Group the documents of the payment request into payments.
140: */
141: IBY_PAYGROUP_PUB.performDocumentGrouping(p_payment_request_id
142: , l_paymentTab
143: , l_docsInPmtTab
144: , l_ca_id
145: , l_ca_payreq_cd

Line 194: IBY_PAYGROUP_PUB.sweepCommonPmtAttributes(l_paymentTab, l_docsInPmtTab);

190: * of each payment, and set the corresponding
191: * attribute on the parent payment itself if
192: * such a common attribute is found.
193: */
194: IBY_PAYGROUP_PUB.sweepCommonPmtAttributes(l_paymentTab, l_docsInPmtTab);
195:
196: /*
197: * Set the default attributes for the created payments.
198: */

Line 283: IBY_PAYGROUP_PUB.insertPayments(l_paymentTab);

279: * that is expecting payments to be populated in
280: * IBY_PAYMENTS_ALL table. Therefore, payments need to
281: * inserted before performing central bank reporting as well.
282: */
283: IBY_PAYGROUP_PUB.insertPayments(l_paymentTab);
284:
285: /*
286: * Fix for bug 5972585:
287: *

Line 303: IBY_PAYGROUP_PUB.updateDocsWithPaymentID(l_docsInPmtTab);

299: * again the customer could potentially want to retrieve
300: * documents that are part of the created payments in the
301: * central bank reporting hook.
302: */
303: IBY_PAYGROUP_PUB.updateDocsWithPaymentID(l_docsInPmtTab);
304:
305: /*
306: * Fix for bug 5972585:
307: *

Line 329: --IBY_PAYGROUP_PUB.auditPaymentData(l_paymentTab);

325: *
326: * This information is also used by the extract and format
327: * logic.
328: */
329: --IBY_PAYGROUP_PUB.auditPaymentData(l_paymentTab);
330:
331: /*
332: * Fix for bug 5337671:
333: *

Line 345: IBY_PAYGROUP_PUB.performCentralBankReporting(

341:
342: /*
343: * Perform declarations / central bank reporting.
344: */
345: IBY_PAYGROUP_PUB.performCentralBankReporting(
346: l_paymentTab
347: , l_docsInPmtTab
348: -- , l_cbrTab
349: );

Line 360: IBY_PAYGROUP_PUB.updatePayments(l_paymentTab);

356: * payments by the hook. Therefore, we need to
357: * update the payments in IBY_PAYMENTS_ALL table
358: * so that this flag is accessible for validation.
359: */
360: IBY_PAYGROUP_PUB.updatePayments(l_paymentTab);
361:
362:
363: /*
364: * Payment validations

Line 366: --IBY_PAYGROUP_PUB.applyPaymentValidationSets(p_payment_request_id,l_paymentTab,

362:
363: /*
364: * Payment validations
365: */
366: --IBY_PAYGROUP_PUB.applyPaymentValidationSets(p_payment_request_id,l_paymentTab,
367: -- l_docsInPmtTab, l_docErrorTab, l_docTokenTab);
368:
369:
370: /* Validation check for negative payment amounts

Line 384: --IBY_PAYGROUP_PUB.performPmtGrpNumberValidation(l_paymentTab,

380: /*
381: * Commented out because of performance impact
382: * - Ramesh, Nov 17 2006.
383: */
384: --IBY_PAYGROUP_PUB.performPmtGrpNumberValidation(l_paymentTab,
385: -- l_docsInPmtTab, l_docErrorTab, l_docTokenTab);
386:
387: /*
388: * Payment validation might have failed some payments (and by

Line 394: IBY_PAYGROUP_PUB.adjustSisterDocsAndPmts(l_paymentTab,

390: *
391: * Make sure to fail related documents whenever documents are
392: * failed.
393: */
394: IBY_PAYGROUP_PUB.adjustSisterDocsAndPmts(l_paymentTab,
395: l_docsInPmtTab, l_docErrorTab, l_docTokenTab);
396:
397: /*
398: * Call post-payment creation hook. This hook will pass

Line 422: IBY_PAYGROUP_PUB.performPreHookProcess(

418: * calling application.
419: *
420: * This method writes the payment data to global temp tables.
421: */
422: IBY_PAYGROUP_PUB.performPreHookProcess(
423: l_ca_payreq_cd, l_ca_id, l_paymentTab,
424: l_docsInPmtTab, l_hookPaymentTab,
425: l_hookDocsInPmtTab);
426:

Line 437: IBY_PAYGROUP_PUB.callHook(p_payment_request_id);

433: *
434: * Any other miscellaneous correction of payment/document data
435: * is also allowed in the hook.
436: */
437: IBY_PAYGROUP_PUB.callHook(p_payment_request_id);
438:
439: /*
440: * The external app may decide not to pay a document(s)
441: * within a payment, or may decide not to make a payment(s).

Line 455: IBY_PAYGROUP_PUB.performPostHookProcess(

451: * constituent payment amounts must be adjusted
452: *
453: * This method reads the payment data from global temp tables.
454: */
455: IBY_PAYGROUP_PUB.performPostHookProcess(
456: l_paymentTab, l_docsInPmtTab,
457: l_hookPaymentTab, l_hookDocsInPmtTab,
458: l_docErrorTab, l_docTokenTab);
459:

Line 484: IBY_PAYGROUP_PUB.flagSeparateRemitAdvicePmts(l_paymentTab,

480: /*
481: * Flag payments that require separate remittance
482: * advice.
483: */
484: IBY_PAYGROUP_PUB.flagSeparateRemitAdvicePmts(l_paymentTab,
485: l_docsInPmtTab);
486:
487: /*
488: * Get the rejection level system option and pass

Line 578: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,

574: payment_service_request_id%type,
575: p_rej_level IN VARCHAR2,
576: p_review_pmts_flag IN VARCHAR2,
577: p_override_compl_pt IN VARCHAR2,
578: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
579: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.docsInPaymentTabType,
580: x_allPmtsSuccessFlag IN OUT NOCOPY BOOLEAN,
581: x_allPmtsFailedFlag IN OUT NOCOPY BOOLEAN,
582: x_return_status IN OUT NOCOPY VARCHAR2,

Line 579: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.docsInPaymentTabType,

575: p_rej_level IN VARCHAR2,
576: p_review_pmts_flag IN VARCHAR2,
577: p_override_compl_pt IN VARCHAR2,
578: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
579: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.docsInPaymentTabType,
580: x_allPmtsSuccessFlag IN OUT NOCOPY BOOLEAN,
581: x_allPmtsFailedFlag IN OUT NOCOPY BOOLEAN,
582: x_return_status IN OUT NOCOPY VARCHAR2,
583: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.

Line 697: IBY_PAYGROUP_PUB.failDocsOfPayment(

693:
694: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
695: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
696:
697: IBY_PAYGROUP_PUB.failDocsOfPayment(
698: x_paymentTab(i).payment_id,
699: DOC_STATUS_PAY_VAL_FAIL,
700: x_docsInPmtTab, x_docErrorTab,
701: x_errTokenTab);

Line 798: IBY_PAYGROUP_PUB.updatePayments(x_paymentTab);

794: * All payments for this payment request have been
795: * created and stored in a PLSQL table. Now write these
796: * payments to the database.
797: */
798: IBY_PAYGROUP_PUB.updatePayments(x_paymentTab);
799:
800: /*
801: * Update the documents table by providing a payment id to
802: * each document.

Line 804: IBY_PAYGROUP_PUB.updateDocsWithPaymentID(x_docsInPmtTab);

800: /*
801: * Update the documents table by providing a payment id to
802: * each document.
803: */
804: IBY_PAYGROUP_PUB.updateDocsWithPaymentID(x_docsInPmtTab);
805:
806: /*
807: * If any payments/documents were failed, the IBY_TRANSACTION_
808: * ERRORS table must be populated with the corresponding error

Line 886: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType

882: | NOTES:
883: |
884: *---------------------------------------------------------------------*/
885: PROCEDURE initializePmts(
886: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType
887: )
888: IS
889: BEGIN
890:

Line 940: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,

936: | NOTES: Added for the bug 7344352
937: |
938: *---------------------------------------------------------------------*/
939: PROCEDURE negativePmtAmountCheck(
940: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
941: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.docsInPaymentTabType,
942: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
943: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
944: )

Line 941: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.docsInPaymentTabType,

937: |
938: *---------------------------------------------------------------------*/
939: PROCEDURE negativePmtAmountCheck(
940: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
941: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.docsInPaymentTabType,
942: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
943: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
944: )
945: IS

Line 1000: IBY_PAYGROUP_PUB.failDocsOfPayment(x_paymentTab(i).payment_id,

996: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
997: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
998:
999: /* fail the docs of this payment */
1000: IBY_PAYGROUP_PUB.failDocsOfPayment(x_paymentTab(i).payment_id,
1001: DOC_STATUS_PAY_VAL_FAIL, x_docsInPmtTab,
1002: x_docErrorTab, x_errTokenTab);
1003:
1004: END IF;