APPS.IBY_PAYINSTR_PUB dependencies on IBY_PAYMENT_PROFILES

Line 81: p_processing_type IN IBY_PAYMENT_PROFILES.

77: *---------------------------------------------------------------------*/
78: PROCEDURE createPaymentInstructions(
79:
80: /*-- processing criteria --*/
81: p_processing_type IN IBY_PAYMENT_PROFILES.
82: processing_type%TYPE,
83: p_pmt_document_id IN CE_PAYMENT_DOCUMENTS.
84: payment_document_id%TYPE,
85: p_printer_name IN VARCHAR2,

Line 3699: IBY_PAYMENT_PROFILES prof,

3695: FROM
3696: IBY_VALIDATION_SETS_VL val,
3697: IBY_VAL_ASSIGNMENTS val_asgn,
3698: IBY_PAY_INSTRUCTIONS_ALL pmt_instr,
3699: IBY_PAYMENT_PROFILES prof,
3700: IBY_TRANSMIT_CONFIGS_VL txconf,
3701: IBY_TRANSMIT_PROTOCOLS_VL txproto,
3702: IBY_PAYMENTS_SEC_V pmt
3703: WHERE

Line 3839: IBY_PAYMENT_PROFILES prof,

3835: FROM
3836: IBY_VALIDATION_SETS_VL val,
3837: IBY_VAL_ASSIGNMENTS val_asgn,
3838: IBY_PAY_INSTRUCTIONS_ALL pmt_instr,
3839: IBY_PAYMENT_PROFILES prof,
3840: IBY_TRANSMIT_CONFIGS_VL txconf,
3841: IBY_TRANSMIT_PROTOCOLS_VL txproto,
3842: IBY_TRANSACTION_ERRORS txerrors
3843: WHERE

Line 5580: l_profile_code IBY_PAYMENT_PROFILES.system_profile_code%TYPE;

5576: RETURN sortOptionsRecType
5577:
5578: IS
5579: l_sort_options_rec sortOptionsRecType;
5580: l_profile_code IBY_PAYMENT_PROFILES.system_profile_code%TYPE;
5581:
5582: l_module_name VARCHAR2(200) := G_PKG_NAME || '.getSortOptionsForProfile';
5583:
5584: BEGIN

Line 6005: l_profile_code IBY_PAYMENT_PROFILES.system_profile_code%TYPE;

6001: l_docs_limit NUMBER(15);
6002: l_pmt_details_len_limit NUMBER(15);
6003: l_module_name VARCHAR2(200) := G_PKG_NAME
6004: || '.flagSeparateRemitAdvcPayments';
6005: l_profile_code IBY_PAYMENT_PROFILES.system_profile_code%TYPE;
6006: BEGIN
6007:
6008: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6009: print_debuginfo(l_module_name, 'ENTER');

Line 7358: IBY_PAYMENT_PROFILES prof

7354: icr.sort_option_3,
7355: icr.sort_order_3
7356: FROM
7357: IBY_INSTR_CREATION_RULES icr,
7358: IBY_PAYMENT_PROFILES prof
7359: WHERE
7360: prof.payment_profile_id = p_profile_id AND
7361: icr.system_profile_code = prof.system_profile_code
7362: ;