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_PAYMENT_PROFILES

Line 1356: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%type;

1352: l_pmt_reason_flag VARCHAR2(1) := 'N';
1353: l_due_date_flag VARCHAR2(1) := 'N';
1354: l_prom_note_flag VARCHAR2(1) := 'N';
1355:
1356: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%type;
1357:
1358: /*
1359: * Used to substitute null values in date comparisons.
1360: * It is assumed that year 5100 = doomsday.

Line 1699: IBY_PAYMENT_PROFILES ppf,

1695: docs.ext_inv_payee_id
1696: /*TPP-Start*/
1697: FROM IBY_DOCS_PAYABLE_ALL docs,
1698: IBY_PMT_CREATION_RULES pcr,
1699: IBY_PAYMENT_PROFILES ppf,
1700: IBY_PAY_SERVICE_REQUESTS prq,
1701: IBY_EXTERNAL_PAYEES_ALL ext_payee,
1702: IBY_PAYMENT_METHODS_B pmt_mthd,
1703: CE_BANK_ACCOUNTS iba

Line 3436: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%type;

3432: l_pmt_reason_flag VARCHAR2(1) := 'N';
3433: l_due_date_flag VARCHAR2(1) := 'N';
3434: l_prom_note_flag VARCHAR2(1) := 'N';
3435:
3436: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%type;
3437:
3438: /*
3439: * Used to substitute null values in date comparisons.
3440: * It is assumed that year 5100 = doomsday.

Line 3779: IBY_PAYMENT_PROFILES ppf,

3775: /*TPP-Start*/
3776: docs.affects_rejection_level --AWT Enh 16296267
3777: FROM IBY_DOCS_PAYABLE_ALL docs,
3778: IBY_PMT_CREATION_RULES pcr,
3779: IBY_PAYMENT_PROFILES ppf,
3780: IBY_PAY_SERVICE_REQUESTS prq,
3781: IBY_EXTERNAL_PAYEES_ALL ext_payee,
3782: IBY_PAYMENT_METHODS_B pmt_mthd,
3783: CE_BANK_ACCOUNTS iba

Line 9576: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%type;

9572: || '.performCentralBankReporting';
9573: l_pmt_fx_amount iby_payments_all.payment_amount%TYPE := -1;
9574: l_return_status VARCHAR2(200);
9575: l_declare_flag VARCHAR2(1);
9576: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%type;
9577:
9578: BEGIN
9579:
9580: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 9908: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%type;

9904: || '.performCentralBankReporting';
9905: l_pmt_fx_amount iby_payments_all.payment_amount%TYPE := -1;
9906: l_return_status VARCHAR2(200);
9907: l_declare_flag VARCHAR2(1);
9908: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%type;
9909:
9910: BEGIN
9911:
9912: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 10384: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%type;

10380: l_error_code VARCHAR2(100);
10381: l_error_msg VARCHAR2(500);
10382: l_token_rec IBY_TRXN_ERROR_TOKENS%ROWTYPE;
10383:
10384: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%type;
10385: l_disabled_ppp VARCHAR2(1) := 'N';
10386:
10387: BEGIN
10388: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 15844: l_profile_code IBY_PAYMENT_PROFILES.system_profile_code%TYPE;

15840: l_successDocCountTab successDocsCountPerPmtTab;
15841:
15842: /* maps profile ids to system profile codes */
15843: l_profile_map IBY_BUILD_UTILS_PKG.profileIdToCodeMapTabType;
15844: l_profile_code IBY_PAYMENT_PROFILES.system_profile_code%TYPE;
15845:
15846: /*
15847: * Remittance advices cursor -- Only pick those
15848: * records that have the format attched... there

Line 16105: l_profile_code IBY_PAYMENT_PROFILES.system_profile_code%TYPE;

16101: l_successDocCountTab successDocsCountPerPmtTab;
16102:
16103: /* maps profile ids to system profile codes */
16104: l_profile_map IBY_BUILD_UTILS_PKG.profileIdToCodeMapTabType;
16105: l_profile_code IBY_PAYMENT_PROFILES.system_profile_code%TYPE;
16106:
16107: /*
16108: * Remittance advices cursor -- Only pick those
16109: * records that have the format attched... there

Line 16127: IBY_PAYMENT_PROFILES ppp,

16123: COUNT(document_payable_id)
16124:
16125: FROM
16126: IBY_REMIT_ADVICE_SETUP advice,
16127: IBY_PAYMENT_PROFILES ppp,
16128: IBY_PAYMENTS_ALL pmt,
16129: IBY_DOCS_PAYABLE_ALL docs
16130:
16131: WHERE

Line 18108: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;

18104: l_country CE_BANK_BRANCHES_V.country%TYPE;
18105: l_bank_home_country CE_BANK_BRANCHES_V.bank_home_country%TYPE;
18106: l_allow_zero_pmt_flag CE_BANK_ACCOUNTS.zero_amount_allowed%TYPE;
18107:
18108: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;
18109: l_payment_format_cd IBY_PAYMENT_PROFILES.payment_format_code%TYPE;
18110: l_bepid IBY_PAYMENT_PROFILES.bepid%TYPE;
18111: l_transmit_protocol_cd IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE;
18112:

Line 18109: l_payment_format_cd IBY_PAYMENT_PROFILES.payment_format_code%TYPE;

18105: l_bank_home_country CE_BANK_BRANCHES_V.bank_home_country%TYPE;
18106: l_allow_zero_pmt_flag CE_BANK_ACCOUNTS.zero_amount_allowed%TYPE;
18107:
18108: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;
18109: l_payment_format_cd IBY_PAYMENT_PROFILES.payment_format_code%TYPE;
18110: l_bepid IBY_PAYMENT_PROFILES.bepid%TYPE;
18111: l_transmit_protocol_cd IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE;
18112:
18113: /*

Line 18110: l_bepid IBY_PAYMENT_PROFILES.bepid%TYPE;

18106: l_allow_zero_pmt_flag CE_BANK_ACCOUNTS.zero_amount_allowed%TYPE;
18107:
18108: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;
18109: l_payment_format_cd IBY_PAYMENT_PROFILES.payment_format_code%TYPE;
18110: l_bepid IBY_PAYMENT_PROFILES.bepid%TYPE;
18111: l_transmit_protocol_cd IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE;
18112:
18113: /*
18114: * Pick up all validation sets applicable to a particular payment.

Line 18111: l_transmit_protocol_cd IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE;

18107:
18108: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;
18109: l_payment_format_cd IBY_PAYMENT_PROFILES.payment_format_code%TYPE;
18110: l_bepid IBY_PAYMENT_PROFILES.bepid%TYPE;
18111: l_transmit_protocol_cd IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE;
18112:
18113: /*
18114: * Pick up all validation sets applicable to a particular payment.
18115: */

Line 18120: p_payment_format_code IBY_PAYMENT_PROFILES.payment_format_code%TYPE,

18116:
18117: CURSOR c_pmt_val_sets(p_payment_id IBY_PAYMENTS_ALL.payment_id%TYPE,
18118: p_payment_method_code IBY_PAYMENTS_ALL.payment_method_code%TYPE,
18119: p_int_bank_acct_id IBY_PAYMENTS_ALL.internal_bank_account_id%TYPE,
18120: p_payment_format_code IBY_PAYMENT_PROFILES.payment_format_code%TYPE,
18121: p_bepid IBY_PAYMENT_PROFILES.bepid%TYPE,
18122: p_transmit_protocol_code IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE,
18123: p_country CE_BANK_BRANCHES_V.country%TYPE)
18124: IS

Line 18121: p_bepid IBY_PAYMENT_PROFILES.bepid%TYPE,

18117: CURSOR c_pmt_val_sets(p_payment_id IBY_PAYMENTS_ALL.payment_id%TYPE,
18118: p_payment_method_code IBY_PAYMENTS_ALL.payment_method_code%TYPE,
18119: p_int_bank_acct_id IBY_PAYMENTS_ALL.internal_bank_account_id%TYPE,
18120: p_payment_format_code IBY_PAYMENT_PROFILES.payment_format_code%TYPE,
18121: p_bepid IBY_PAYMENT_PROFILES.bepid%TYPE,
18122: p_transmit_protocol_code IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE,
18123: p_country CE_BANK_BRANCHES_V.country%TYPE)
18124: IS
18125: SELECT DISTINCT

Line 18122: p_transmit_protocol_code IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE,

18118: p_payment_method_code IBY_PAYMENTS_ALL.payment_method_code%TYPE,
18119: p_int_bank_acct_id IBY_PAYMENTS_ALL.internal_bank_account_id%TYPE,
18120: p_payment_format_code IBY_PAYMENT_PROFILES.payment_format_code%TYPE,
18121: p_bepid IBY_PAYMENT_PROFILES.bepid%TYPE,
18122: p_transmit_protocol_code IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE,
18123: p_country CE_BANK_BRANCHES_V.country%TYPE)
18124: IS
18125: SELECT DISTINCT
18126: val_asgn.validation_assignment_id,

Line 18352: FROM IBY_PAYMENT_PROFILES ipp

18348: BEGIN
18349: SELECT ipp.payment_profile_id,
18350: ipp.payment_format_code, ipp.bepid, ipp.transmit_protocol_code
18351: INTO l_profile_id,l_payment_format_cd,l_bepid,l_transmit_protocol_cd
18352: FROM IBY_PAYMENT_PROFILES ipp
18353: WHERE ipp.payment_profile_id = IBY_PAYGROUP_PUB.pmtTable.PAYMENT_PROFILE_ID(l_trx_valid_index) ;
18354:
18355: EXCEPTION
18356: WHEN NO_DATA_FOUND THEN

Line 22560: IBY_PAYMENT_PROFILES prof

22556: prof.declaration_currency_code,
22557: prof.declaration_threshold_amount
22558: FROM
22559: IBY_PAYMENTS_ALL pmt,
22560: IBY_PAYMENT_PROFILES prof
22561: WHERE
22562: pmt.payment_id = p_payment_id AND
22563: pmt.payment_profile_id = prof.payment_profile_id
22564: ;

Line 22873: IBY_PAYMENT_PROFILES prof

22869: prof.declaration_currency_code,
22870: prof.declaration_threshold_amount
22871: FROM
22872: IBY_PAYMENTS_ALL pmt,
22873: IBY_PAYMENT_PROFILES prof
22874: WHERE
22875: pmt.payment_id = p_payment_id AND
22876: pmt.payment_profile_id = prof.payment_profile_id
22877: ;

Line 25639: IBY_PAYMENT_PROFILES prof,

25635:
25636:
25637: FROM
25638: /* Profile related */
25639: IBY_PAYMENT_PROFILES prof,
25640: /* Remit advice related */
25641: IBY_REMIT_ADVICE_SETUP remit_advice,
25642: /* Bank instruction related */
25643: IBY_BANK_INSTRUCTIONS_VL bank_instr1,