APPS.OE_PAYMENT_TRXN_UTIL dependencies on IBY_TRXN_EXTENSIONS_V

Line 473: from IBY_TRXN_EXTENSIONS_V where trxn_extension_id = p_x_trxn_extension_id;

469:
470: -- Based on the trxn extension id get the corresponding
471: -- assignment id from the payments table
472: select instr_assignment_id into l_assign_id
473: from IBY_TRXN_EXTENSIONS_V where trxn_extension_id = p_x_trxn_extension_id;
474: IF l_debug_level > 0 THEN
475: oe_debug_pub.add('Instrument assignment id for existing instrument'||l_assign_id);
476: END IF;
477:

Line 1130: FROM iby_trxn_extensions_v

1126: -- to check if the authorization has been settled
1127: BEGIN
1128: SELECT nvl(settled_flag, 'N'),instrument_id,card_number
1129: INTO l_settled_flag,l_old_instrument_id,l_old_card_number
1130: FROM iby_trxn_extensions_v
1131: WHERE trxn_extension_id = p_trxn_extension_id;
1132: EXCEPTION WHEN NO_DATA_FOUND THEN
1133: l_settled_flag := 'N';
1134: l_old_instrument_id := NULL;

Line 1269: from iby_trxn_extensions_v

1265:
1266: BEGIN
1267: select trxn_ref_number2
1268: into l_trxn_ref_number2
1269: from iby_trxn_extensions_v
1270: where trxn_extension_id = p_trxn_extension_id;
1271:
1272: EXCEPTION WHEN NO_DATA_FOUND THEN
1273: null;

Line 1658: from iby_trxn_extensions_v

1654:
1655: Begin
1656: select instrument_id, instrument_type, instr_assignment_id
1657: into l_instrument_id, l_instrument_type, l_instr_assignment_id
1658: from iby_trxn_extensions_v
1659: where trxn_extension_id = p_trxn_extension_id;
1660: Exception When NO_DATA_FOUND THEN
1661: null;
1662: End;

Line 1925: From iby_trxn_extensions_v

1921: IF l_trxn_extension_id is not null then
1922: IF p_payment_type_code in ('ACH', 'DIRECT_DEBIT') then
1923: Select account_number
1924: Into x_bank_account_number
1925: From iby_trxn_extensions_v
1926: Where trxn_extension_id = l_trxn_extension_id;
1927: ELSIF p_payment_type_code = 'CREDIT_CARD' THEN
1928:
1929: Select itev.card_number,

Line 1947: IBY_TRXN_EXTENSIONS_V ITEV

1943: x_instrument_security_code,
1944: x_instrument_id,
1945: x_instrument_assignment_id
1946: FROM
1947: IBY_TRXN_EXTENSIONS_V ITEV
1948: WHERE ITEV.TRXN_EXTENSION_ID = l_trxn_extension_id;
1949:
1950: IF l_debug_level > 0 THEN
1951: oe_debug_pub.add('Values retrieved in Get_Payment_Trxn_Info...');

Line 2120: from iby_trxn_extensions_v where trxn_Extension_id=p_trxn_extension_id;

2116: --channel code is used.
2117: begin
2118: select payment_channel_code,settled_flag,authorized_flag
2119: into l_payment_channel_code,l_settled_flag,l_authorized_flag -- bug 5194228
2120: from iby_trxn_extensions_v where trxn_Extension_id=p_trxn_extension_id;
2121: exception
2122: when others then
2123: oe_debug_pub.add('Trxn extn id not found....');
2124: end ;

Line 2142: iby_trxn_extensions_v itev where

2138: oe_debug_pub.add('Inside the credit card query for site use id...'||p_trxn_extension_id);
2139: END IF;
2140: select ifpai.acct_site_use_id into l_site_use_id
2141: from iby_fndcpt_payer_assgn_instr_v ifpai,
2142: iby_trxn_extensions_v itev where
2143: ifpai.instr_assignment_id = itev.instr_assignment_id and
2144: itev.trxn_extension_id = p_trxn_extension_id;
2145: ELSE
2146: IF l_debug_level > 0 THEN

Line 2317: from iby_trxn_extensions_v

2313: IF p_trxn_extension_id IS NOT NULL AND
2314: NOT OE_GLOBALS.Equal(p_trxn_Extension_id, FND_API.G_MISS_NUM) THEN
2315: select settled_flag
2316: into l_Settled_flag
2317: from iby_trxn_extensions_v
2318: where trxn_Extension_id = p_trxn_extension_id;
2319: END IF;
2320: IF l_debug_level > 0 THEN
2321: oe_debug_pub.add('Settled flag retrieved successfully...');