APPS.IBY_PAYINSTR_PUB dependencies on IBY_PAYMENT_PROFILES

Line 79: p_processing_type IN IBY_PAYMENT_PROFILES.

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

Line 3256: IBY_PAYMENT_PROFILES prof,

3252: FROM
3253: IBY_VALIDATION_SETS_VL val,
3254: IBY_VAL_ASSIGNMENTS val_asgn,
3255: IBY_PAY_INSTRUCTIONS_ALL pmt_instr,
3256: IBY_PAYMENT_PROFILES prof,
3257: IBY_TRANSMIT_CONFIGS_VL txconf,
3258: IBY_TRANSMIT_PROTOCOLS_VL txproto,
3259: IBY_PAYMENTS_SEC_V pmt
3260: WHERE

Line 3385: IBY_PAYMENT_PROFILES prof,

3381: FROM
3382: IBY_VALIDATION_SETS_VL val,
3383: IBY_VAL_ASSIGNMENTS val_asgn,
3384: IBY_PAY_INSTRUCTIONS_ALL pmt_instr,
3385: IBY_PAYMENT_PROFILES prof,
3386: IBY_TRANSMIT_CONFIGS_VL txconf,
3387: IBY_TRANSMIT_PROTOCOLS_VL txproto,
3388: IBY_TRANSACTION_ERRORS txerrors
3389: WHERE

Line 4963: l_profile_code IBY_PAYMENT_PROFILES.system_profile_code%TYPE;

4959: RETURN sortOptionsRecType
4960:
4961: IS
4962: l_sort_options_rec sortOptionsRecType;
4963: l_profile_code IBY_PAYMENT_PROFILES.system_profile_code%TYPE;
4964:
4965: l_module_name VARCHAR2(200) := G_PKG_NAME || '.getSortOptionsForProfile';
4966:
4967: BEGIN

Line 5397: l_profile_code IBY_PAYMENT_PROFILES.system_profile_code%TYPE;

5393: l_docs_limit NUMBER(15);
5394: l_pmt_details_len_limit NUMBER(15);
5395: l_module_name VARCHAR2(200) := G_PKG_NAME
5396: || '.flagSeparateRemitAdvcPayments';
5397: l_profile_code IBY_PAYMENT_PROFILES.system_profile_code%TYPE;
5398: BEGIN
5399:
5400: print_debuginfo(l_module_name, 'ENTER');
5401:

Line 6680: IBY_PAYMENT_PROFILES prof

6676: icr.sort_option_3,
6677: icr.sort_order_3
6678: FROM
6679: IBY_INSTR_CREATION_RULES icr,
6680: IBY_PAYMENT_PROFILES prof
6681: WHERE
6682: prof.payment_profile_id = p_profile_id AND
6683: icr.system_profile_code = prof.system_profile_code
6684: ;