APPS.ARP_TRX_DEFAULTS_3 dependencies on IBY_TRXN_EXTENSIONS_V

Line 2039: l_instrument iby_trxn_extensions_v.card_number%type;

2035: ra_customer_trx.payment_trxn_extension_id%type,
2036: p_payment_channel_code IN
2037: ar_receipt_methods.payment_channel_code%type
2038: ) RETURN VARCHAR2 IS
2039: l_instrument iby_trxn_extensions_v.card_number%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()+');

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_trxn_extensions_v.card_number%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 2148: iby_trxn_extensions_v.bank_name%type,

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

Line 2150: iby_trxn_extensions_v.bank_branch_name%type,

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

Line 2152: iby_trxn_extensions_v.instr_assignment_id%type,

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

Line 2154: iby_trxn_extensions_v.account_number%type)

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

Line 2160: from iby_trxn_extensions_v

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

Line 2179: p_instrument_assignment_id OUT NOCOPY iby_trxn_extensions_v.instr_assignment_id%type

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