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_VALIDATIONSETS_PUB dependencies on IBY_PAYMENT_PROFILES

Line 654: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;

650:
651: l_payee_id IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE;
652: l_payee_party_id IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE;
653:
654: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;
655: l_payment_format_cd IBY_PAYMENT_PROFILES.payment_format_code%TYPE;
656: l_bepid IBY_PAYMENT_PROFILES.bepid%TYPE;
657: l_transmit_protocol_cd IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE;
658: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||

Line 655: l_payment_format_cd IBY_PAYMENT_PROFILES.payment_format_code%TYPE;

651: l_payee_id IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE;
652: l_payee_party_id IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE;
653:
654: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;
655: l_payment_format_cd IBY_PAYMENT_PROFILES.payment_format_code%TYPE;
656: l_bepid IBY_PAYMENT_PROFILES.bepid%TYPE;
657: l_transmit_protocol_cd IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE;
658: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
659: '.applyDocumentValidationSets';

Line 656: l_bepid IBY_PAYMENT_PROFILES.bepid%TYPE;

652: l_payee_party_id IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE;
653:
654: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;
655: l_payment_format_cd IBY_PAYMENT_PROFILES.payment_format_code%TYPE;
656: l_bepid IBY_PAYMENT_PROFILES.bepid%TYPE;
657: l_transmit_protocol_cd IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE;
658: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
659: '.applyDocumentValidationSets';
660:

Line 657: l_transmit_protocol_cd IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE;

653:
654: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;
655: l_payment_format_cd IBY_PAYMENT_PROFILES.payment_format_code%TYPE;
656: l_bepid IBY_PAYMENT_PROFILES.bepid%TYPE;
657: l_transmit_protocol_cd IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE;
658: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
659: '.applyDocumentValidationSets';
660:
661: l_trx_doc_index BINARY_INTEGER; --Enh 16296267

Line 724: p_payment_format_code IBY_PAYMENT_PROFILES.payment_format_code%TYPE,

720: p_payment_grouping_number IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
721: p_ext_payee_id IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
722: p_payment_method_code IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
723: p_int_bank_acct_id IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
724: p_payment_format_code IBY_PAYMENT_PROFILES.payment_format_code%TYPE,
725: p_bepid IBY_PAYMENT_PROFILES.bepid%TYPE,
726: p_transmit_protocol_code IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE,
727: p_country CE_BANK_BRANCHES_V.country%TYPE
728: )

Line 725: p_bepid IBY_PAYMENT_PROFILES.bepid%TYPE,

721: p_ext_payee_id IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
722: p_payment_method_code IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
723: p_int_bank_acct_id IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
724: p_payment_format_code IBY_PAYMENT_PROFILES.payment_format_code%TYPE,
725: p_bepid IBY_PAYMENT_PROFILES.bepid%TYPE,
726: p_transmit_protocol_code IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE,
727: p_country CE_BANK_BRANCHES_V.country%TYPE
728: )
729: IS

Line 726: p_transmit_protocol_code IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE,

722: p_payment_method_code IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
723: p_int_bank_acct_id IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
724: p_payment_format_code IBY_PAYMENT_PROFILES.payment_format_code%TYPE,
725: p_bepid IBY_PAYMENT_PROFILES.bepid%TYPE,
726: p_transmit_protocol_code IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE,
727: p_country CE_BANK_BRANCHES_V.country%TYPE
728: )
729: IS
730: SELECT DISTINCT

Line 1715: FROM IBY_PAYMENT_PROFILES ipp

1711: BEGIN
1712: SELECT ipp.payment_profile_id,
1713: ipp.payment_format_code, ipp.bepid, ipp.transmit_protocol_code
1714: INTO l_profile_id,l_payment_format_cd,l_bepid,l_transmit_protocol_cd
1715: FROM IBY_PAYMENT_PROFILES ipp
1716: WHERE ipp.payment_profile_id = l_docs_tab(i).profile_id ;
1717:
1718: EXCEPTION
1719: WHEN NO_DATA_FOUND THEN

Line 6510: l_payment_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;

6506:
6507: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
6508: l_payee_format_cd IBY_EXTERNAL_PAYEES_ALL.payment_format_code%TYPE;
6509:
6510: l_payment_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;
6511: l_prof_pmt_format_cd IBY_PAYMENT_PROFILES.payment_format_code%TYPE;
6512: l_bepid IBY_PAYMENT_PROFILES.bepid%TYPE;
6513: l_transmit_protocol_cd IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE;
6514:

Line 6511: l_prof_pmt_format_cd IBY_PAYMENT_PROFILES.payment_format_code%TYPE;

6507: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
6508: l_payee_format_cd IBY_EXTERNAL_PAYEES_ALL.payment_format_code%TYPE;
6509:
6510: l_payment_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;
6511: l_prof_pmt_format_cd IBY_PAYMENT_PROFILES.payment_format_code%TYPE;
6512: l_bepid IBY_PAYMENT_PROFILES.bepid%TYPE;
6513: l_transmit_protocol_cd IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE;
6514:
6515:

Line 6512: l_bepid IBY_PAYMENT_PROFILES.bepid%TYPE;

6508: l_payee_format_cd IBY_EXTERNAL_PAYEES_ALL.payment_format_code%TYPE;
6509:
6510: l_payment_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;
6511: l_prof_pmt_format_cd IBY_PAYMENT_PROFILES.payment_format_code%TYPE;
6512: l_bepid IBY_PAYMENT_PROFILES.bepid%TYPE;
6513: l_transmit_protocol_cd IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE;
6514:
6515:
6516: BEGIN

Line 6513: l_transmit_protocol_cd IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE;

6509:
6510: l_payment_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;
6511: l_prof_pmt_format_cd IBY_PAYMENT_PROFILES.payment_format_code%TYPE;
6512: l_bepid IBY_PAYMENT_PROFILES.bepid%TYPE;
6513: l_transmit_protocol_cd IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE;
6514:
6515:
6516: BEGIN
6517:

Line 6667: FROM IBY_PAYMENT_PROFILES ipp

6663: END IF;
6664: SELECT
6665: ipp.payment_profile_id, ipp.payment_format_code,ipp.bepid, ipp.transmit_protocol_code
6666: INTO l_payment_profile_id,l_prof_pmt_format_cd,l_bepid,l_transmit_protocol_cd
6667: FROM IBY_PAYMENT_PROFILES ipp
6668: WHERE ipp.payment_profile_id = p_profile_id ;
6669:
6670: EXCEPTION
6671: WHEN NO_DATA_FOUND THEN