APPS.ARP_TRX_DEFAULTS_3 dependencies on IBY_TRXN_EXTENSIONS_V

Line 2040: l_instrument_type iby_trxn_extensions_v.instrument_type%type;

2036: p_payment_channel_code IN
2037: ar_receipt_methods.payment_channel_code%type
2038: ) RETURN VARCHAR2 IS
2039: l_instrument iby_ext_bank_accounts.MASKED_BANK_ACCOUNT_NUM%type;
2040: l_instrument_type iby_trxn_extensions_v.instrument_type%type;
2041: BEGIN
2042: IF PG_DEBUG in ('Y', 'C') THEN
2043: arp_standard.debug('arp_trx_defaults_3.get_payment_instrument()+');
2044: END IF;

Line 2147: iby_trxn_extensions_v.bank_name%type,

2143: ra_customer_trx.payment_trxn_extension_id%type,
2144: p_payment_channel_code IN
2145: ar_receipt_methods.payment_channel_code%type,
2146: p_bank_name OUT NOCOPY
2147: iby_trxn_extensions_v.bank_name%type,
2148: p_branch_name OUT NOCOPY
2149: iby_trxn_extensions_v.bank_branch_name%type,
2150: p_instr_assign_id OUT NOCOPY
2151: iby_trxn_extensions_v.instr_assignment_id%type,

Line 2149: iby_trxn_extensions_v.bank_branch_name%type,

2145: ar_receipt_methods.payment_channel_code%type,
2146: p_bank_name OUT NOCOPY
2147: iby_trxn_extensions_v.bank_name%type,
2148: p_branch_name OUT NOCOPY
2149: iby_trxn_extensions_v.bank_branch_name%type,
2150: p_instr_assign_id OUT NOCOPY
2151: iby_trxn_extensions_v.instr_assignment_id%type,
2152: p_instr_number OUT NOCOPY
2153: iby_trxn_extensions_v.account_number%type)

Line 2151: iby_trxn_extensions_v.instr_assignment_id%type,

2147: iby_trxn_extensions_v.bank_name%type,
2148: p_branch_name OUT NOCOPY
2149: iby_trxn_extensions_v.bank_branch_name%type,
2150: p_instr_assign_id OUT NOCOPY
2151: iby_trxn_extensions_v.instr_assignment_id%type,
2152: p_instr_number OUT NOCOPY
2153: iby_trxn_extensions_v.account_number%type)
2154: IS
2155:

Line 2153: iby_trxn_extensions_v.account_number%type)

2149: iby_trxn_extensions_v.bank_branch_name%type,
2150: p_instr_assign_id OUT NOCOPY
2151: iby_trxn_extensions_v.instr_assignment_id%type,
2152: p_instr_number OUT NOCOPY
2153: iby_trxn_extensions_v.account_number%type)
2154: IS
2155:
2156: BEGIN
2157: select bank_name,bank_branch_name,instr_assignment_id,account_number

Line 2159: from iby_trxn_extensions_v

2155:
2156: BEGIN
2157: select bank_name,bank_branch_name,instr_assignment_id,account_number
2158: into p_bank_name,p_branch_name,p_instr_assign_id,p_instr_number
2159: from iby_trxn_extensions_v
2160: where trxn_extension_id = p_payment_trxn_extension_id
2161: and payment_channel_code = p_payment_channel_code;
2162:
2163: exception

Line 2178: p_instrument_assignment_id OUT NOCOPY iby_trxn_extensions_v.instr_assignment_id%type

2174: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
2175: p_paying_site_use_id IN iby_fndcpt_payer_assgn_instr_v.acct_site_use_id%type,
2176: p_instrument_type IN iby_fndcpt_payer_assgn_instr_v.instrument_type%type,
2177: p_currency_code IN iby_fndcpt_payer_assgn_instr_v.currency_code%type ,
2178: p_instrument_assignment_id OUT NOCOPY iby_trxn_extensions_v.instr_assignment_id%type
2179:
2180: )
2181: IS
2182: l_instr_assignments IBY_FNDCPT_SETUP_PUB.pmtinstrassignment_tbl_type;