eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_FNDCPT_TX_EXTENSIONS

Line 30: -- From IBY_FNDCPT_TX_EXTENSIONS

26:
27:
28: TYPE FuncCaptureOrder_rec_type IS RECORD (
29: TRXNMID IBY_TRXN_SUMMARIES_ALL.TRXNMID%TYPE,
30: -- From IBY_FNDCPT_TX_EXTENSIONS
31: TRXN_REF_NUMBER1 IBY_FNDCPT_TX_EXTENSIONS.TRXN_REF_NUMBER1%TYPE,
32: TRXN_REF_NUMBER2 IBY_FNDCPT_TX_EXTENSIONS.TRXN_REF_NUMBER2%TYPE,
33: PAYMENT_CHANNEL_CODE IBY_FNDCPT_TX_EXTENSIONS.PAYMENT_CHANNEL_CODE%TYPE,
34: PO_NUMBER IBY_FNDCPT_TX_EXTENSIONS.PO_NUMBER%TYPE,

Line 31: TRXN_REF_NUMBER1 IBY_FNDCPT_TX_EXTENSIONS.TRXN_REF_NUMBER1%TYPE,

27:
28: TYPE FuncCaptureOrder_rec_type IS RECORD (
29: TRXNMID IBY_TRXN_SUMMARIES_ALL.TRXNMID%TYPE,
30: -- From IBY_FNDCPT_TX_EXTENSIONS
31: TRXN_REF_NUMBER1 IBY_FNDCPT_TX_EXTENSIONS.TRXN_REF_NUMBER1%TYPE,
32: TRXN_REF_NUMBER2 IBY_FNDCPT_TX_EXTENSIONS.TRXN_REF_NUMBER2%TYPE,
33: PAYMENT_CHANNEL_CODE IBY_FNDCPT_TX_EXTENSIONS.PAYMENT_CHANNEL_CODE%TYPE,
34: PO_NUMBER IBY_FNDCPT_TX_EXTENSIONS.PO_NUMBER%TYPE,
35: VOICE_AUTHORIZATION_FLAG IBY_FNDCPT_TX_EXTENSIONS.VOICE_AUTHORIZATION_FLAG%TYPE,

Line 32: TRXN_REF_NUMBER2 IBY_FNDCPT_TX_EXTENSIONS.TRXN_REF_NUMBER2%TYPE,

28: TYPE FuncCaptureOrder_rec_type IS RECORD (
29: TRXNMID IBY_TRXN_SUMMARIES_ALL.TRXNMID%TYPE,
30: -- From IBY_FNDCPT_TX_EXTENSIONS
31: TRXN_REF_NUMBER1 IBY_FNDCPT_TX_EXTENSIONS.TRXN_REF_NUMBER1%TYPE,
32: TRXN_REF_NUMBER2 IBY_FNDCPT_TX_EXTENSIONS.TRXN_REF_NUMBER2%TYPE,
33: PAYMENT_CHANNEL_CODE IBY_FNDCPT_TX_EXTENSIONS.PAYMENT_CHANNEL_CODE%TYPE,
34: PO_NUMBER IBY_FNDCPT_TX_EXTENSIONS.PO_NUMBER%TYPE,
35: VOICE_AUTHORIZATION_FLAG IBY_FNDCPT_TX_EXTENSIONS.VOICE_AUTHORIZATION_FLAG%TYPE,
36: PAYMENT_FUNCTION IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,

Line 33: PAYMENT_CHANNEL_CODE IBY_FNDCPT_TX_EXTENSIONS.PAYMENT_CHANNEL_CODE%TYPE,

29: TRXNMID IBY_TRXN_SUMMARIES_ALL.TRXNMID%TYPE,
30: -- From IBY_FNDCPT_TX_EXTENSIONS
31: TRXN_REF_NUMBER1 IBY_FNDCPT_TX_EXTENSIONS.TRXN_REF_NUMBER1%TYPE,
32: TRXN_REF_NUMBER2 IBY_FNDCPT_TX_EXTENSIONS.TRXN_REF_NUMBER2%TYPE,
33: PAYMENT_CHANNEL_CODE IBY_FNDCPT_TX_EXTENSIONS.PAYMENT_CHANNEL_CODE%TYPE,
34: PO_NUMBER IBY_FNDCPT_TX_EXTENSIONS.PO_NUMBER%TYPE,
35: VOICE_AUTHORIZATION_FLAG IBY_FNDCPT_TX_EXTENSIONS.VOICE_AUTHORIZATION_FLAG%TYPE,
36: PAYMENT_FUNCTION IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
37: -- From the ORDERS View

Line 34: PO_NUMBER IBY_FNDCPT_TX_EXTENSIONS.PO_NUMBER%TYPE,

30: -- From IBY_FNDCPT_TX_EXTENSIONS
31: TRXN_REF_NUMBER1 IBY_FNDCPT_TX_EXTENSIONS.TRXN_REF_NUMBER1%TYPE,
32: TRXN_REF_NUMBER2 IBY_FNDCPT_TX_EXTENSIONS.TRXN_REF_NUMBER2%TYPE,
33: PAYMENT_CHANNEL_CODE IBY_FNDCPT_TX_EXTENSIONS.PAYMENT_CHANNEL_CODE%TYPE,
34: PO_NUMBER IBY_FNDCPT_TX_EXTENSIONS.PO_NUMBER%TYPE,
35: VOICE_AUTHORIZATION_FLAG IBY_FNDCPT_TX_EXTENSIONS.VOICE_AUTHORIZATION_FLAG%TYPE,
36: PAYMENT_FUNCTION IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
37: -- From the ORDERS View
38: CALL_APP_SERVICE_REQ_CODE IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,

Line 35: VOICE_AUTHORIZATION_FLAG IBY_FNDCPT_TX_EXTENSIONS.VOICE_AUTHORIZATION_FLAG%TYPE,

31: TRXN_REF_NUMBER1 IBY_FNDCPT_TX_EXTENSIONS.TRXN_REF_NUMBER1%TYPE,
32: TRXN_REF_NUMBER2 IBY_FNDCPT_TX_EXTENSIONS.TRXN_REF_NUMBER2%TYPE,
33: PAYMENT_CHANNEL_CODE IBY_FNDCPT_TX_EXTENSIONS.PAYMENT_CHANNEL_CODE%TYPE,
34: PO_NUMBER IBY_FNDCPT_TX_EXTENSIONS.PO_NUMBER%TYPE,
35: VOICE_AUTHORIZATION_FLAG IBY_FNDCPT_TX_EXTENSIONS.VOICE_AUTHORIZATION_FLAG%TYPE,
36: PAYMENT_FUNCTION IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
37: -- From the ORDERS View
38: CALL_APP_SERVICE_REQ_CODE IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,
39: --CALLING_APP_DOC_REF_NUMBER IBY_TRXN_SUMMARIES_ALL.CALLING_APP_DOC_REF_NUMBER%TYPE,

Line 46: PAYMENT_TRXN_EXTENSION_ID IBY_FNDCPT_TX_EXTENSIONS.TRXN_EXTENSION_ID%TYPE,

42: BR_MATURITY_DATE IBY_TRXN_SUMMARIES_ALL.BR_MATURITY_DATE%TYPE,
43: ORDER_DESCRIPTION VARCHAR2(255),
44: SETTLEMENT_CURRENCY_CODE IBY_TRXN_SUMMARIES_ALL.CURRENCYNAMECODE%TYPE,
45: SETTLEMENT_AMOUNT IBY_TRXN_SUMMARIES_ALL.AMOUNT%TYPE,
46: PAYMENT_TRXN_EXTENSION_ID IBY_FNDCPT_TX_EXTENSIONS.TRXN_EXTENSION_ID%TYPE,
47: INTERNAL_BANK_ACCOUNT_ID CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE,
48: PAYER_PARTY_ID IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%TYPE,
49: CUST_ACCOUNT_ID IBY_TRXN_SUMMARIES_ALL.CUST_ACCOUNT_ID%TYPE,
50: ACCT_SITE_USE_ID IBY_TRXN_SUMMARIES_ALL.ACCT_SITE_USE_ID%TYPE,

Line 206: (p_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,

202: --
203: -- Use: Determine the reason extension lookup failed in the auth API
204: --
205: FUNCTION Get_Extension_Auth_Fail
206: (p_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
207: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type
208: )
209: RETURN VARCHAR2
210: IS

Line 213: l_ext_payer_id iby_fndcpt_tx_extensions.ext_payer_id%TYPE;

209: RETURN VARCHAR2
210: IS
211: l_msg VARCHAR2(100);
212: l_instr_assign_id iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;
213: l_ext_payer_id iby_fndcpt_tx_extensions.ext_payer_id%TYPE;
214:
215: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Extension_Auth_Fail';
216: BEGIN
217:

Line 225: FROM iby_fndcpt_tx_extensions

221: BEGIN
222:
223: SELECT instr_assignment_id, ext_payer_id
224: INTO l_instr_assign_id, l_ext_payer_id
225: FROM iby_fndcpt_tx_extensions
226: WHERE (p_trxn_extension_id = trxn_extension_id);
227: EXCEPTION
228: WHEN NO_DATA_FOUND THEN
229: RETURN l_msg;

Line 267: p_order_id IN iby_fndcpt_tx_extensions.order_id%TYPE,

263: END Get_Extension_Encrypt_Mode;
264:
265: FUNCTION Get_Tangible_Id
266: (p_app_short_name IN fnd_application.application_short_name%TYPE,
267: p_order_id IN iby_fndcpt_tx_extensions.order_id%TYPE,
268: p_trxn_ref1 IN iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE,
269: p_trxn_ref2 IN iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE
270: )
271: RETURN iby_trxn_summaries_all.tangibleid%TYPE

Line 268: p_trxn_ref1 IN iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE,

264:
265: FUNCTION Get_Tangible_Id
266: (p_app_short_name IN fnd_application.application_short_name%TYPE,
267: p_order_id IN iby_fndcpt_tx_extensions.order_id%TYPE,
268: p_trxn_ref1 IN iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE,
269: p_trxn_ref2 IN iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE
270: )
271: RETURN iby_trxn_summaries_all.tangibleid%TYPE
272: IS

Line 269: p_trxn_ref2 IN iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE

265: FUNCTION Get_Tangible_Id
266: (p_app_short_name IN fnd_application.application_short_name%TYPE,
267: p_order_id IN iby_fndcpt_tx_extensions.order_id%TYPE,
268: p_trxn_ref1 IN iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE,
269: p_trxn_ref2 IN iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE
270: )
271: RETURN iby_trxn_summaries_all.tangibleid%TYPE
272: IS
273: l_tangible_id iby_trxn_summaries_all.tangibleid%TYPE;

Line 290: p_trxn_extn_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE

286:
287: --Overloading this function for bug : 7628586
288: FUNCTION Get_Tangible_Id
289: (p_app_short_name IN fnd_application.application_short_name%TYPE,
290: p_trxn_extn_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE
291: )
292: RETURN iby_trxn_summaries_all.tangibleid%TYPE
293: IS
294: l_tangible_id iby_trxn_summaries_all.tangibleid%TYPE;

Line 332: (p_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)

328: RETURN l_payeeid;
329: END Get_Internal_Payee;
330:
331: FUNCTION Get_Tx_Extension_Copy_Count
332: (p_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
333: RETURN NUMBER
334: IS
335: l_copy_count NUMBER;
336:

Line 337: CURSOR c_xe_copies(ci_x_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)

333: RETURN NUMBER
334: IS
335: l_copy_count NUMBER;
336:
337: CURSOR c_xe_copies(ci_x_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
338: IS
339: SELECT COUNT(copy_trxn_extension_id)
340: FROM iby_fndcpt_tx_xe_copies
341: WHERE (source_trxn_extension_id = ci_x_id);

Line 778: (p_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)

774: END Payer_InstrAssignment_Valid;
775:
776:
777: FUNCTION Extension_Operation_Exists
778: (p_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
779: RETURN BOOLEAN
780: IS
781: l_count NUMBER;
782:

Line 784: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)

780: IS
781: l_count NUMBER;
782:
783: CURSOR c_operation
784: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
785: IS
786: SELECT count(1)
787: FROM iby_trxn_extensions_v
788: WHERE (trxn_extension_id = ci_extension_id)

Line 1010: SELECT iby_fndcpt_tx_extensions_s.NEXTVAL INTO x_entity_id FROM DUAL;

1006: -- test_debug('l_segment_id: '|| l_segment_id);
1007: -- test_debug('l_encrypted: '|| l_encrypted);
1008: -- test_debug('l_sec_code: '|| l_sec_code);
1009:
1010: SELECT iby_fndcpt_tx_extensions_s.NEXTVAL INTO x_entity_id FROM DUAL;
1011: INSERT INTO iby_fndcpt_tx_extensions
1012: (trxn_extension_id, payment_channel_code, ext_payer_id,
1013: instr_assignment_id, origin_application_id, instrument_security_code,
1014: voice_authorization_flag, voice_authorization_date,

Line 1011: INSERT INTO iby_fndcpt_tx_extensions

1007: -- test_debug('l_encrypted: '|| l_encrypted);
1008: -- test_debug('l_sec_code: '|| l_sec_code);
1009:
1010: SELECT iby_fndcpt_tx_extensions_s.NEXTVAL INTO x_entity_id FROM DUAL;
1011: INSERT INTO iby_fndcpt_tx_extensions
1012: (trxn_extension_id, payment_channel_code, ext_payer_id,
1013: instr_assignment_id, origin_application_id, instrument_security_code,
1014: voice_authorization_flag, voice_authorization_date,
1015: voice_authorization_code, order_id, po_number,

Line 1115: l_xtension_id iby_fndcpt_tx_extensions.trxn_extension_id%TYPE;

1111: l_payer_level VARCHAR2(30);
1112: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1113: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
1114:
1115: l_xtension_id iby_fndcpt_tx_extensions.trxn_extension_id%TYPE;
1116: l_pmt_channel iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE;
1117: l_instr_assign iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;
1118: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
1119: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;

Line 1118: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;

1114:
1115: l_xtension_id iby_fndcpt_tx_extensions.trxn_extension_id%TYPE;
1116: l_pmt_channel iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE;
1117: l_instr_assign iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;
1118: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
1119: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
1120: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
1121: l_app_id iby_fndcpt_tx_extensions.origin_application_id%TYPE;
1122: -- l_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;

Line 1119: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;

1115: l_xtension_id iby_fndcpt_tx_extensions.trxn_extension_id%TYPE;
1116: l_pmt_channel iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE;
1117: l_instr_assign iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;
1118: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
1119: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
1120: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
1121: l_app_id iby_fndcpt_tx_extensions.origin_application_id%TYPE;
1122: -- l_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
1123:

Line 1120: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;

1116: l_pmt_channel iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE;
1117: l_instr_assign iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;
1118: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
1119: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
1120: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
1121: l_app_id iby_fndcpt_tx_extensions.origin_application_id%TYPE;
1122: -- l_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
1123:
1124: lx_channel_instr iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE;

Line 1121: l_app_id iby_fndcpt_tx_extensions.origin_application_id%TYPE;

1117: l_instr_assign iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;
1118: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
1119: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
1120: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
1121: l_app_id iby_fndcpt_tx_extensions.origin_application_id%TYPE;
1122: -- l_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
1123:
1124: lx_channel_instr iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE;
1125:

Line 1122: -- l_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;

1118: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
1119: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
1120: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
1121: l_app_id iby_fndcpt_tx_extensions.origin_application_id%TYPE;
1122: -- l_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
1123:
1124: lx_channel_instr iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE;
1125:
1126: l_msg_count NUMBER;

Line 1137: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,

1133:
1134: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || l_module;
1135:
1136: CURSOR c_extension
1137: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
1138: ci_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
1139: ci_payer_level IN VARCHAR2,
1140: ci_payer_equiv IN VARCHAR2
1141: )

Line 1147: FROM iby_fndcpt_tx_extensions x, iby_external_payers_all p

1143: SELECT
1144: x.trxn_extension_id, x.payment_channel_code, x.instr_assignment_id,
1145: x.order_id, x.trxn_ref_number1, x.trxn_ref_number2,
1146: x.origin_application_id, x.instr_code_sec_segment_id
1147: FROM iby_fndcpt_tx_extensions x, iby_external_payers_all p
1148: WHERE (x.ext_payer_id = p.ext_payer_id)
1149: AND (x.trxn_extension_id = ci_extension_id)
1150: AND (p.party_id = ci_payer.Party_Id)
1151: AND (IBY_FNDCPT_COMMON_PUB.Compare_Payer

Line 1323: UPDATE iby_fndcpt_tx_extensions

1319: -- as an intention to NULL-out
1320: --
1321: -- test_debug('p_trxn_attribs.Instrument_Security_Code: '||p_trxn_attribs.Instrument_Security_Code);
1322: -- test_debug('encrypted: '||);
1323: UPDATE iby_fndcpt_tx_extensions
1324: SET
1325: payment_channel_code = NVL(p_pmt_channel,payment_channel_code),
1326: instr_assignment_id =
1327: DECODE(p_instr_assignment, FND_API.G_MISS_NUM,NULL,

Line 1466: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)

1462:
1463: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || l_module;
1464:
1465: CURSOR c_extension
1466: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
1467: IS
1468: SELECT
1469: origin_application_id, RPAD('X',instr_sec_code_length,'X'),
1470: voice_authorization_flag, voice_authorization_date,

Line 1473: FROM iby_fndcpt_tx_extensions

1469: origin_application_id, RPAD('X',instr_sec_code_length,'X'),
1470: voice_authorization_flag, voice_authorization_date,
1471: voice_authorization_code, order_id, po_number,
1472: po_line_number, trxn_ref_number1, trxn_ref_number2, additional_info
1473: FROM iby_fndcpt_tx_extensions
1474: WHERE trxn_extension_id = ci_extension_id;
1475:
1476: BEGIN
1477: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

Line 1609: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,

1605:
1606: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || l_module;
1607:
1608: CURSOR c_extension
1609: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
1610: ci_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
1611: ci_payer_level IN VARCHAR2,
1612: ci_payer_equiv IN VARCHAR2
1613: )

Line 1616: FROM iby_fndcpt_tx_extensions x, iby_external_payers_all p,

1612: ci_payer_equiv IN VARCHAR2
1613: )
1614: IS
1615: SELECT x.trxn_extension_id
1616: FROM iby_fndcpt_tx_extensions x, iby_external_payers_all p,
1617: iby_pmt_instr_uses_all i
1618: WHERE (x.trxn_extension_id = ci_extension_id)
1619: AND (x.instr_assignment_id = i.instrument_payment_use_id(+))
1620: AND (NVL(x.ext_payer_id,i.ext_pmt_party_id) = p.ext_payer_id)

Line 1681: DELETE iby_fndcpt_tx_extensions

1677: -- delete all links to its source extensions
1678: DELETE iby_fndcpt_tx_xe_copies
1679: WHERE (copy_trxn_extension_id = p_entity_id);
1680:
1681: DELETE iby_fndcpt_tx_extensions
1682: WHERE (trxn_extension_id = p_entity_id);
1683: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS;
1684: END IF;
1685: ELSE

Line 1771: l_pmt_channel iby_fndcpt_tx_extensions.payment_channel_code%TYPE;

1767: l_payer_level VARCHAR2(30);
1768: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1769: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
1770:
1771: l_pmt_channel iby_fndcpt_tx_extensions.payment_channel_code%TYPE;
1772: l_instr_assign_id iby_fndcpt_tx_extensions.instr_assignment_id%TYPE;
1773: lc_pmt_channel iby_fndcpt_tx_extensions.payment_channel_code%TYPE;
1774: lc_instr_assign_id iby_fndcpt_tx_extensions.instr_assignment_id%TYPE;
1775: lc_sec_code iby_fndcpt_tx_extensions.instrument_security_code%TYPE;

Line 1772: l_instr_assign_id iby_fndcpt_tx_extensions.instr_assignment_id%TYPE;

1768: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1769: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
1770:
1771: l_pmt_channel iby_fndcpt_tx_extensions.payment_channel_code%TYPE;
1772: l_instr_assign_id iby_fndcpt_tx_extensions.instr_assignment_id%TYPE;
1773: lc_pmt_channel iby_fndcpt_tx_extensions.payment_channel_code%TYPE;
1774: lc_instr_assign_id iby_fndcpt_tx_extensions.instr_assignment_id%TYPE;
1775: lc_sec_code iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
1776: lc_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;

Line 1773: lc_pmt_channel iby_fndcpt_tx_extensions.payment_channel_code%TYPE;

1769: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
1770:
1771: l_pmt_channel iby_fndcpt_tx_extensions.payment_channel_code%TYPE;
1772: l_instr_assign_id iby_fndcpt_tx_extensions.instr_assignment_id%TYPE;
1773: lc_pmt_channel iby_fndcpt_tx_extensions.payment_channel_code%TYPE;
1774: lc_instr_assign_id iby_fndcpt_tx_extensions.instr_assignment_id%TYPE;
1775: lc_sec_code iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
1776: lc_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;
1777: lc_va_flag iby_fndcpt_tx_extensions.voice_authorization_flag%TYPE;

Line 1774: lc_instr_assign_id iby_fndcpt_tx_extensions.instr_assignment_id%TYPE;

1770:
1771: l_pmt_channel iby_fndcpt_tx_extensions.payment_channel_code%TYPE;
1772: l_instr_assign_id iby_fndcpt_tx_extensions.instr_assignment_id%TYPE;
1773: lc_pmt_channel iby_fndcpt_tx_extensions.payment_channel_code%TYPE;
1774: lc_instr_assign_id iby_fndcpt_tx_extensions.instr_assignment_id%TYPE;
1775: lc_sec_code iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
1776: lc_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;
1777: lc_va_flag iby_fndcpt_tx_extensions.voice_authorization_flag%TYPE;
1778: lc_va_code iby_fndcpt_tx_extensions.voice_authorization_code%TYPE;

Line 1775: lc_sec_code iby_fndcpt_tx_extensions.instrument_security_code%TYPE;

1771: l_pmt_channel iby_fndcpt_tx_extensions.payment_channel_code%TYPE;
1772: l_instr_assign_id iby_fndcpt_tx_extensions.instr_assignment_id%TYPE;
1773: lc_pmt_channel iby_fndcpt_tx_extensions.payment_channel_code%TYPE;
1774: lc_instr_assign_id iby_fndcpt_tx_extensions.instr_assignment_id%TYPE;
1775: lc_sec_code iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
1776: lc_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;
1777: lc_va_flag iby_fndcpt_tx_extensions.voice_authorization_flag%TYPE;
1778: lc_va_code iby_fndcpt_tx_extensions.voice_authorization_code%TYPE;
1779: lc_va_date iby_fndcpt_tx_extensions.voice_authorization_date%TYPE;

Line 1776: lc_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;

1772: l_instr_assign_id iby_fndcpt_tx_extensions.instr_assignment_id%TYPE;
1773: lc_pmt_channel iby_fndcpt_tx_extensions.payment_channel_code%TYPE;
1774: lc_instr_assign_id iby_fndcpt_tx_extensions.instr_assignment_id%TYPE;
1775: lc_sec_code iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
1776: lc_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;
1777: lc_va_flag iby_fndcpt_tx_extensions.voice_authorization_flag%TYPE;
1778: lc_va_code iby_fndcpt_tx_extensions.voice_authorization_code%TYPE;
1779: lc_va_date iby_fndcpt_tx_extensions.voice_authorization_date%TYPE;
1780: lc_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;

Line 1777: lc_va_flag iby_fndcpt_tx_extensions.voice_authorization_flag%TYPE;

1773: lc_pmt_channel iby_fndcpt_tx_extensions.payment_channel_code%TYPE;
1774: lc_instr_assign_id iby_fndcpt_tx_extensions.instr_assignment_id%TYPE;
1775: lc_sec_code iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
1776: lc_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;
1777: lc_va_flag iby_fndcpt_tx_extensions.voice_authorization_flag%TYPE;
1778: lc_va_code iby_fndcpt_tx_extensions.voice_authorization_code%TYPE;
1779: lc_va_date iby_fndcpt_tx_extensions.voice_authorization_date%TYPE;
1780: lc_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;
1781: lc_instr_code_sec_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;

Line 1778: lc_va_code iby_fndcpt_tx_extensions.voice_authorization_code%TYPE;

1774: lc_instr_assign_id iby_fndcpt_tx_extensions.instr_assignment_id%TYPE;
1775: lc_sec_code iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
1776: lc_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;
1777: lc_va_flag iby_fndcpt_tx_extensions.voice_authorization_flag%TYPE;
1778: lc_va_code iby_fndcpt_tx_extensions.voice_authorization_code%TYPE;
1779: lc_va_date iby_fndcpt_tx_extensions.voice_authorization_date%TYPE;
1780: lc_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;
1781: lc_instr_code_sec_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
1782:

Line 1779: lc_va_date iby_fndcpt_tx_extensions.voice_authorization_date%TYPE;

1775: lc_sec_code iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
1776: lc_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;
1777: lc_va_flag iby_fndcpt_tx_extensions.voice_authorization_flag%TYPE;
1778: lc_va_code iby_fndcpt_tx_extensions.voice_authorization_code%TYPE;
1779: lc_va_date iby_fndcpt_tx_extensions.voice_authorization_date%TYPE;
1780: lc_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;
1781: lc_instr_code_sec_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
1782:
1783: l_extension TrxnExtension_rec_type;

Line 1780: lc_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;

1776: lc_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;
1777: lc_va_flag iby_fndcpt_tx_extensions.voice_authorization_flag%TYPE;
1778: lc_va_code iby_fndcpt_tx_extensions.voice_authorization_code%TYPE;
1779: lc_va_date iby_fndcpt_tx_extensions.voice_authorization_date%TYPE;
1780: lc_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;
1781: lc_instr_code_sec_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
1782:
1783: l_extension TrxnExtension_rec_type;
1784: l_x_not_found BOOLEAN;

Line 1781: lc_instr_code_sec_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;

1777: lc_va_flag iby_fndcpt_tx_extensions.voice_authorization_flag%TYPE;
1778: lc_va_code iby_fndcpt_tx_extensions.voice_authorization_code%TYPE;
1779: lc_va_date iby_fndcpt_tx_extensions.voice_authorization_date%TYPE;
1780: lc_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;
1781: lc_instr_code_sec_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
1782:
1783: l_extension TrxnExtension_rec_type;
1784: l_x_not_found BOOLEAN;
1785: -- whether the new instrument assignment (if passed) was validated

Line 1798: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,

1794:
1795: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || l_module;
1796:
1797: CURSOR c_extension
1798: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
1799: ci_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
1800: ci_payer_level IN VARCHAR2,
1801: ci_payer_equiv IN VARCHAR2,
1802: ci_copy_instr_assign_id IN

Line 1810: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i,

1806: SELECT x.payment_channel_code, x.instr_assignment_id,
1807: x.instrument_security_code, x.instr_sec_code_length,
1808: x.voice_authorization_flag, x.voice_authorization_code,
1809: x.voice_authorization_date, x.encrypted, x.instr_code_sec_segment_id
1810: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i,
1811: iby_pmt_instr_uses_all cpi, iby_external_payers_all p
1812: WHERE (x.instr_assignment_id = i.instrument_payment_use_id)
1813: -- can assume this assignment is for funds capture
1814: -- bug 7017004 - use the payer information on the trxn extension

Line 1849: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)

1845: )
1846: ORDER BY x.creation_date DESC;
1847:
1848: CURSOR c_auths
1849: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
1850: IS
1851: SELECT NVL(sp.settle_require_vrfy_flag,'Y')
1852: FROM iby_trxn_ext_auths_v x, iby_fndcpt_sys_eft_pf_b sp,
1853: iby_fndcpt_user_eft_pf_b up

Line 2070: SELECT iby_fndcpt_tx_extensions_s.NEXTVAL INTO x_entity_id FROM DUAL;

2066: IF (NOT Extension_Valid(l_pmt_channel,l_extension,FALSE,
2067: l_consumed_cvv2)) THEN
2068: x_response.Result_Code := G_RC_INVALID_EXTENSION_ATTRIB;
2069: ELSE
2070: SELECT iby_fndcpt_tx_extensions_s.NEXTVAL INTO x_entity_id FROM DUAL;
2071: INSERT INTO iby_fndcpt_tx_extensions
2072: (trxn_extension_id, payment_channel_code,
2073: ext_payer_id, instr_assignment_id,
2074: origin_application_id, instrument_security_code,

Line 2071: INSERT INTO iby_fndcpt_tx_extensions

2067: l_consumed_cvv2)) THEN
2068: x_response.Result_Code := G_RC_INVALID_EXTENSION_ATTRIB;
2069: ELSE
2070: SELECT iby_fndcpt_tx_extensions_s.NEXTVAL INTO x_entity_id FROM DUAL;
2071: INSERT INTO iby_fndcpt_tx_extensions
2072: (trxn_extension_id, payment_channel_code,
2073: ext_payer_id, instr_assignment_id,
2074: origin_application_id, instrument_security_code,
2075: instr_sec_code_length, encrypted, instr_code_sec_segment_id,

Line 2207: p_segment_id IN iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE

2203: --
2204: PROCEDURE Consume_CVV
2205: (
2206: p_trxn_extn_id IN NUMBER,
2207: p_segment_id IN iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE
2208: )
2209: IS PRAGMA AUTONOMOUS_TRANSACTION;
2210: l_random_val NUMBER;
2211: BEGIN

Line 2218: UPDATE iby_fndcpt_tx_extensions

2214: -- Just securely wipe out the CVV column in this case.
2215:
2216: IF (p_segment_id IS NULL) THEN
2217: SELECT trunc(DBMS_RANDOM.VALUE(1000,9999)) INTO l_random_val FROM dual;
2218: UPDATE iby_fndcpt_tx_extensions
2219: -- Update the sec_code with a randomly generated number
2220: SET instrument_security_code = l_random_val,
2221: --instr_sec_code_length = NULL,
2222: encrypted = 'N',

Line 2231: UPDATE iby_fndcpt_tx_extensions

2227: WHERE trxn_extension_id = p_trxn_extn_id;
2228: COMMIT;
2229:
2230: -- Again update the sec_code column with NULL value.
2231: UPDATE iby_fndcpt_tx_extensions
2232: SET instrument_security_code = NULL,
2233: --instr_sec_code_length = NULL,
2234: encrypted = 'N',
2235: last_updated_by = fnd_global.user_id,

Line 2248: UPDATE iby_fndcpt_tx_extensions

2244: -- Need not do any secure wipeout for the instrument_security_code
2245: -- column here, since this just contains the truncated value
2246: -- Just Nulling out the column is enough.
2247:
2248: UPDATE iby_fndcpt_tx_extensions
2249: SET instrument_security_code = NULL,
2250: --instr_sec_code_length = NULL,
2251: encrypted = 'N',
2252: last_updated_by = fnd_global.user_id,

Line 2307: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;

2303: l_single_use iby_fndcpt_payer_assgn_instr_v.card_single_use_flag%TYPE;
2304:
2305: l_ecapp_id NUMBER;
2306: l_app_short_name fnd_application.application_short_name%TYPE;
2307: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
2308: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
2309: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
2310: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;
2311: l_code_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;

Line 2308: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;

2304:
2305: l_ecapp_id NUMBER;
2306: l_app_short_name fnd_application.application_short_name%TYPE;
2307: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
2308: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
2309: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
2310: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;
2311: l_code_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
2312: l_payee IBY_PAYMENT_ADAPTER_PUB.Payee_rec_type;

Line 2309: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;

2305: l_ecapp_id NUMBER;
2306: l_app_short_name fnd_application.application_short_name%TYPE;
2307: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
2308: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
2309: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
2310: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;
2311: l_code_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
2312: l_payee IBY_PAYMENT_ADAPTER_PUB.Payee_rec_type;
2313: l_payer IBY_PAYMENT_ADAPTER_PUB.Payer_rec_type;

Line 2310: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;

2306: l_app_short_name fnd_application.application_short_name%TYPE;
2307: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
2308: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
2309: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
2310: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;
2311: l_code_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
2312: l_payee IBY_PAYMENT_ADAPTER_PUB.Payee_rec_type;
2313: l_payer IBY_PAYMENT_ADAPTER_PUB.Payer_rec_type;
2314: l_tangible IBY_PAYMENT_ADAPTER_PUB.Tangible_rec_type;

Line 2311: l_code_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;

2307: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
2308: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
2309: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
2310: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;
2311: l_code_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
2312: l_payee IBY_PAYMENT_ADAPTER_PUB.Payee_rec_type;
2313: l_payer IBY_PAYMENT_ADAPTER_PUB.Payer_rec_type;
2314: l_tangible IBY_PAYMENT_ADAPTER_PUB.Tangible_rec_type;
2315: l_pmt_instr IBY_PAYMENT_ADAPTER_PUB.PmtInstr_rec_type;

Line 2330: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,

2326:
2327: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || l_module;
2328:
2329: CURSOR c_extension
2330: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
2331: ci_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
2332: ci_payer_level IN VARCHAR2,
2333: ci_payer_equiv IN VARCHAR2
2334: )

Line 2344: FROM iby_fndcpt_tx_extensions x, iby_fndcpt_payer_assgn_instr_v i,

2340: x.instrument_security_code, x.instr_code_sec_segment_id, x.encrypted,
2341: x.po_number, x.voice_authorization_flag, x.voice_authorization_code,
2342: x.voice_authorization_date, i.card_single_use_flag,
2343: NVL(x.instr_assignment_id,0), x.payment_channel_code
2344: FROM iby_fndcpt_tx_extensions x, iby_fndcpt_payer_assgn_instr_v i,
2345: iby_external_payers_all p, fnd_application a,
2346: iby_fndcpt_pmt_chnnls_b pc
2347: WHERE (x.instr_assignment_id = i.instr_assignment_id(+))
2348: AND (x.payment_channel_code = pc.payment_channel_code)

Line 2361: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)

2357: ci_payer_level,ci_payer_equiv,p.org_type,p.org_id,
2358: p.cust_account_id,p.acct_site_use_id) = 'T');
2359:
2360: CURSOR c_auth
2361: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
2362: IS
2363: SELECT authorized_flag
2364: FROM iby_trxn_extensions_v
2365: WHERE (trxn_extension_id = ci_extension_id);

Line 2380: (ci_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,

2376: AND (instrument_type = ci_instr_type)
2377: AND (trxn_extension_id <> ci_trxn_x_id);
2378:
2379: CURSOR c_operation_count
2380: (ci_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
2381: ci_trxn_id IN iby_trxn_summaries_all.transactionid%TYPE)
2382: IS
2383: SELECT count(1)
2384: FROM iby_fndcpt_tx_operations o

Line 2579: -- UPDATE iby_fndcpt_tx_extensions

2575: END IF;
2576: END IF;
2577:
2578: -- consume the security code
2579: -- UPDATE iby_fndcpt_tx_extensions
2580: -- SET instrument_security_code = NULL,
2581: --instr_sec_code_length = NULL,
2582: -- encrypted = 'N',
2583: -- last_updated_by = fnd_global.user_id,

Line 2620: -- IBY_FNDCPT_TX_EXTENSIONS table

2616:
2617: END;
2618:
2619: -- Fix for bug# 7377455. Stamp the tangibleid on the PSON column of
2620: -- IBY_FNDCPT_TX_EXTENSIONS table
2621: iby_debug_pub.add( 'Stamping the PSON on the extension as '||
2622: l_tangible.Tangible_Id,
2623: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2624:

Line 2625: UPDATE iby_fndcpt_tx_extensions

2621: iby_debug_pub.add( 'Stamping the PSON on the extension as '||
2622: l_tangible.Tangible_Id,
2623: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2624:
2625: UPDATE iby_fndcpt_tx_extensions
2626: SET payment_system_order_number = l_tangible.Tangible_Id
2627: WHERE trxn_extension_id = p_trxn_entity_id;
2628:
2629: -- Fix for bug# 7530578. Stamp the initiator transaction extension id

Line 2836: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)

2832: l_module CONSTANT VARCHAR2(30) := 'Get_Authorization';
2833: l_prev_msg_count NUMBER;
2834:
2835: CURSOR c_auth
2836: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
2837: IS
2838: SELECT authorization_id, authorization_date, authorization_code,
2839: avs_code, instr_sec_code_check, pmt_sys_err_code, pmt_sys_err_msg
2840: FROM iby_trxn_ext_auths_v

Line 3042: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;

3038: lx_msg_data VARCHAR2(3000);
3039:
3040:
3041: l_app_short_name fnd_application.application_short_name%TYPE;
3042: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
3043: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
3044: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
3045: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;
3046: l_code_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;

Line 3043: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;

3039:
3040:
3041: l_app_short_name fnd_application.application_short_name%TYPE;
3042: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
3043: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
3044: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
3045: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;
3046: l_code_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
3047: l_payee IBY_PAYMENT_ADAPTER_PUB.Payee_rec_type;

Line 3044: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;

3040:
3041: l_app_short_name fnd_application.application_short_name%TYPE;
3042: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
3043: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
3044: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
3045: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;
3046: l_code_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
3047: l_payee IBY_PAYMENT_ADAPTER_PUB.Payee_rec_type;
3048: l_payer IBY_PAYMENT_ADAPTER_PUB.Payer_rec_type;

Line 3045: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;

3041: l_app_short_name fnd_application.application_short_name%TYPE;
3042: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
3043: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
3044: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
3045: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;
3046: l_code_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
3047: l_payee IBY_PAYMENT_ADAPTER_PUB.Payee_rec_type;
3048: l_payer IBY_PAYMENT_ADAPTER_PUB.Payer_rec_type;
3049: l_tangible IBY_PAYMENT_ADAPTER_PUB.Tangible_rec_type;

Line 3046: l_code_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;

3042: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
3043: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
3044: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
3045: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;
3046: l_code_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
3047: l_payee IBY_PAYMENT_ADAPTER_PUB.Payee_rec_type;
3048: l_payer IBY_PAYMENT_ADAPTER_PUB.Payer_rec_type;
3049: l_tangible IBY_PAYMENT_ADAPTER_PUB.Tangible_rec_type;
3050: l_pmt_instr IBY_PAYMENT_ADAPTER_PUB.PmtInstr_rec_type;

Line 3060: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,

3056:
3057: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || l_module;
3058:
3059: CURSOR c_extension
3060: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
3061: ci_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
3062: ci_payer_level IN VARCHAR2,
3063: ci_payer_equiv IN VARCHAR2
3064: )

Line 3073: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i,

3069: x.instrument_security_code, x.instr_code_sec_segment_id, x.encrypted,
3070: x.po_number, x.voice_authorization_flag, x.voice_authorization_code,
3071: x.voice_authorization_date, NVL(x.instr_assignment_id,0),
3072: x.payment_channel_code
3073: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i,
3074: iby_external_payers_all p, fnd_application a,
3075: iby_fndcpt_pmt_chnnls_b pc
3076: WHERE (x.instr_assignment_id = i.instrument_payment_use_id(+))
3077: AND (x.payment_channel_code = pc.payment_channel_code)

Line 3090: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)

3086: ci_payer_level,ci_payer_equiv,p.org_type,p.org_id,
3087: p.cust_account_id,p.acct_site_use_id) = 'T');
3088:
3089: CURSOR c_auth
3090: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
3091: IS
3092: SELECT authorization_id
3093: FROM iby_trxn_ext_auths_v
3094: WHERE (trxn_extension_id = ci_extension_id)

Line 3098: CURSOR C_PAYEE (ci_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE) IS

3094: WHERE (trxn_extension_id = ci_extension_id)
3095: AND (authorization_status = 0);
3096:
3097:
3098: CURSOR C_PAYEE (ci_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE) IS
3099: select s.payeeid, s.org_id, s.org_type
3100: from iby_trxn_summaries_all s, iby_fndcpt_tx_operations o
3101: where s.trxntypeid = 20
3102: and s.transactionid = o.transactionid

Line 3106: (ci_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,

3102: and s.transactionid = o.transactionid
3103: and o.trxn_extension_id = ci_trxn_extension_id;
3104:
3105: CURSOR c_operation_count
3106: (ci_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
3107: ci_trxn_id IN iby_trxn_summaries_all.transactionid%TYPE)
3108: IS
3109: SELECT count(1)
3110: FROM iby_fndcpt_tx_operations o

Line 3257: -- IBY_FNDCPT_TX_EXTENSIONS table

3253: to_char(l_reqresp.Trxn_ID),
3254: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3255:
3256: -- Fix for bug# 7377455. Stamp the tangibleid on the PSON column of
3257: -- IBY_FNDCPT_TX_EXTENSIONS table
3258: iby_debug_pub.add( 'Stamping the PSON on the extension as '||
3259: l_tangible.Tangible_Id,
3260: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3261:

Line 3262: UPDATE iby_fndcpt_tx_extensions

3258: iby_debug_pub.add( 'Stamping the PSON on the extension as '||
3259: l_tangible.Tangible_Id,
3260: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3261:
3262: UPDATE iby_fndcpt_tx_extensions
3263: SET payment_system_order_number = l_tangible.Tangible_Id
3264: WHERE trxn_extension_id = p_trxn_entity_id;
3265:
3266: -- Fix for bug# 7530578. Stamp the initiator transaction extension id

Line 3610: extension_id IBY_FNDCPT_TX_EXTENSIONS.trxn_extension_id%TYPE,

3606: -- attribute of an extension.
3607: -- This is the only attribute that we are populating in this table after a settlement
3608: -- so we will keep only this record in the record. We may add more in future
3609: TYPE Pson_rec_type IS RECORD (
3610: extension_id IBY_FNDCPT_TX_EXTENSIONS.trxn_extension_id%TYPE,
3611: tangibleid IBY_FNDCPT_TX_EXTENSIONS.payment_system_order_number%TYPE
3612: );
3613:
3614: TYPE PsonTabType IS TABLE OF Pson_rec_type

Line 3611: tangibleid IBY_FNDCPT_TX_EXTENSIONS.payment_system_order_number%TYPE

3607: -- This is the only attribute that we are populating in this table after a settlement
3608: -- so we will keep only this record in the record. We may add more in future
3609: TYPE Pson_rec_type IS RECORD (
3610: extension_id IBY_FNDCPT_TX_EXTENSIONS.trxn_extension_id%TYPE,
3611: tangibleid IBY_FNDCPT_TX_EXTENSIONS.payment_system_order_number%TYPE
3612: );
3613:
3614: TYPE PsonTabType IS TABLE OF Pson_rec_type
3615: INDEX BY BINARY_INTEGER;

Line 3950: IBY_FNDCPT_TX_EXTENSIONS trxnext,

3946: COUNT(auth.transactionid) OVER (PARTITION BY
3947: orders.PAYMENT_TRXN_EXTENSION_ID) auth_count,
3948: auth.dirdeb_instruction_code auth_dirdeb_instruction_code
3949: FROM '||l_view_name||' orders,
3950: IBY_FNDCPT_TX_EXTENSIONS trxnext,
3951: IBY_EXTERNAL_PAYERS_ALL payer,
3952: IBY_TRXN_SUMMARIES_ALL auth,
3953: IBY_FNDCPT_TX_OPERATIONS trxnop,
3954: IBY_TRXN_SUMMARIES_ALL captures,

Line 4431: -- IBY_FNDCPT_TX_EXTENSIONS table

4427:
4428: IF (l_pson_Tab.COUNT > 0) THEN
4429:
4430: -- Fix for bug# 7377455. Stamp the tangibleid on the PSON column of
4431: -- IBY_FNDCPT_TX_EXTENSIONS table
4432: -- FORALL j IN l_pson_Tab.first..l_pson_Tab.last
4433: -- UPDATE iby_fndcpt_tx_extensions
4434: -- SET payment_system_order_number = TREAT(l_pson_Tab(j) AS Pson_rec_type).tangibleid
4435: -- WHERE trxn_extension_id = TREAT(l_pson_Tab(j) AS Pson_rec_type).extension_id;

Line 4433: -- UPDATE iby_fndcpt_tx_extensions

4429:
4430: -- Fix for bug# 7377455. Stamp the tangibleid on the PSON column of
4431: -- IBY_FNDCPT_TX_EXTENSIONS table
4432: -- FORALL j IN l_pson_Tab.first..l_pson_Tab.last
4433: -- UPDATE iby_fndcpt_tx_extensions
4434: -- SET payment_system_order_number = TREAT(l_pson_Tab(j) AS Pson_rec_type).tangibleid
4435: -- WHERE trxn_extension_id = TREAT(l_pson_Tab(j) AS Pson_rec_type).extension_id;
4436:
4437: FOR i IN 0..(l_pson_Tab.COUNT-1) LOOP --index starts from 0 and ends at (COUNT-1)

Line 4440: UPDATE iby_fndcpt_tx_extensions

4436:
4437: FOR i IN 0..(l_pson_Tab.COUNT-1) LOOP --index starts from 0 and ends at (COUNT-1)
4438: iby_debug_pub.add('updating extension '|| l_pson_Tab(i).extension_id
4439: ||' with PSON '||l_pson_Tab(i).tangibleid, iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);
4440: UPDATE iby_fndcpt_tx_extensions
4441: SET payment_system_order_number = l_pson_Tab(i).tangibleid,
4442: object_version_number = object_version_number + 1
4443: WHERE trxn_extension_id = l_pson_Tab(i).extension_id;
4444: END LOOP;

Line 4546: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;

4542: l_extension_found BOOLEAN;
4543:
4544: l_ecapp_id NUMBER;
4545: l_app_short_name fnd_application.application_short_name%TYPE;
4546: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
4547: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
4548: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
4549: l_payee IBY_PAYMENT_ADAPTER_PUB.Payee_rec_type;
4550: l_tangible IBY_PAYMENT_ADAPTER_PUB.Tangible_rec_type;

Line 4547: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;

4543:
4544: l_ecapp_id NUMBER;
4545: l_app_short_name fnd_application.application_short_name%TYPE;
4546: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
4547: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
4548: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
4549: l_payee IBY_PAYMENT_ADAPTER_PUB.Payee_rec_type;
4550: l_tangible IBY_PAYMENT_ADAPTER_PUB.Tangible_rec_type;
4551: l_pmt_instr IBY_PAYMENT_ADAPTER_PUB.PmtInstr_rec_type;

Line 4548: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;

4544: l_ecapp_id NUMBER;
4545: l_app_short_name fnd_application.application_short_name%TYPE;
4546: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
4547: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
4548: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
4549: l_payee IBY_PAYMENT_ADAPTER_PUB.Payee_rec_type;
4550: l_tangible IBY_PAYMENT_ADAPTER_PUB.Tangible_rec_type;
4551: l_pmt_instr IBY_PAYMENT_ADAPTER_PUB.PmtInstr_rec_type;
4552: l_return_trxn IBY_PAYMENT_ADAPTER_PUB.ReturnTrxn_rec_type;

Line 4567: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,

4563:
4564: l_return_pson VARCHAR2(100);
4565:
4566: CURSOR c_extension
4567: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
4568: ci_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
4569: ci_payer_level IN VARCHAR2,
4570: ci_payer_equiv IN VARCHAR2
4571: )

Line 4593: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)

4589: ci_payer_level,ci_payer_equiv,p.org_type,p.org_id,
4590: p.cust_account_id,p.acct_site_use_id) = 'T');
4591:
4592: CURSOR c_settlement
4593: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
4594: IS
4595: SELECT settlement_id, payee_id, org_id, payment_system_order_number
4596: FROM iby_trxn_ext_settlements_v
4597: WHERE (trxn_extension_id = ci_extension_id)

Line 4697: -- IBY_FNDCPT_TX_EXTENSIONS table

4693: START WITH copy_trxn_extension_id = p_trxn_entity_id
4694: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;
4695:
4696: -- Fix for bug# 7377455. Stamp the tangibleid on the PSON column of
4697: -- IBY_FNDCPT_TX_EXTENSIONS table
4698: iby_debug_pub.add( 'Stamping the PSON on the extension as '||
4699: l_tangible.Tangible_Id,
4700: iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4701:

Line 4702: UPDATE iby_fndcpt_tx_extensions

4698: iby_debug_pub.add( 'Stamping the PSON on the extension as '||
4699: l_tangible.Tangible_Id,
4700: iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4701:
4702: UPDATE iby_fndcpt_tx_extensions
4703: SET payment_system_order_number = l_tangible.Tangible_Id
4704: WHERE trxn_extension_id = p_trxn_entity_id;
4705:
4706: -- Fix for bug# 7530578. Stamp the initiator transaction extension id

Line 4745: -- IBY_FNDCPT_TX_EXTENSIONS table

4741: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_GENERIC_SYS_ERROR;
4742: l_interface_code := IBY_FNDCPT_COMMON_PUB.G_INTERFACE_CODE;
4743:
4744: -- Fix for bug# 7377455. Stamp the tangibleid on the PSON column of
4745: -- IBY_FNDCPT_TX_EXTENSIONS table
4746: iby_debug_pub.add( 'Stamping the PSON on the extension as '||
4747: l_return_pson,
4748: iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4749:

Line 4750: UPDATE iby_fndcpt_tx_extensions

4746: iby_debug_pub.add( 'Stamping the PSON on the extension as '||
4747: l_return_pson,
4748: iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4749:
4750: UPDATE iby_fndcpt_tx_extensions
4751: SET payment_system_order_number = l_return_pson
4752: WHERE trxn_extension_id = p_trxn_entity_id;
4753:
4754: -- Fix for bug# 7530578. Stamp the initiator transaction extension id

Line 4880: lx_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;

4876: )
4877: IS
4878: l_mode iby_sys_security_options.instr_sec_code_encryption_mode%TYPE;
4879: l_cvv2 VARCHAR2(100);
4880: lx_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
4881: l_subkey iby_security_pkg.DES3_KEY_TYPE;
4882:
4883: CURSOR c_extensions
4884: IS

Line 4886: FROM iby_fndcpt_tx_extensions x

4882:
4883: CURSOR c_extensions
4884: IS
4885: SELECT x.trxn_extension_id, x.instrument_security_code
4886: FROM iby_fndcpt_tx_extensions x
4887: WHERE (NVL(x.encrypted,'N') = 'N')
4888: AND (NOT instrument_security_code IS NULL);
4889: BEGIN
4890:

Line 4911: UPDATE iby_fndcpt_tx_extensions

4907: IBY_SECURITY_PKG.Create_Segment
4908: (FND_API.G_FALSE,l_cvv2,iby_security_pkg.G_ENCODING_NUMERIC,
4909: p_sys_security_key,lx_segment_id);
4910:
4911: UPDATE iby_fndcpt_tx_extensions
4912: SET
4913: instrument_security_code = LPAD('X',LENGTH(instrument_security_code),'X'),
4914: encrypted = 'Y',
4915: instr_code_sec_segment_id = lx_segment_id,

Line 4931: p_security_code IN iby_fndcpt_tx_extensions.instrument_security_code%TYPE,

4927:
4928: PROCEDURE Encrypt_Security_Code
4929: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
4930: p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,
4931: p_security_code IN iby_fndcpt_tx_extensions.instrument_security_code%TYPE,
4932: x_segment_id OUT NOCOPY NUMBER,
4933: x_err_code OUT NOCOPY VARCHAR2
4934: )
4935: IS

Line 4938: lx_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;

4934: )
4935: IS
4936: l_mode iby_sys_security_options.instr_sec_code_encryption_mode%TYPE;
4937: l_cvv2 VARCHAR2(100);
4938: lx_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
4939: l_subkey iby_security_pkg.DES3_KEY_TYPE;
4940:
4941: BEGIN
4942: -- test_debug('Inside Encrypt_Security_Code.. ');

Line 4980: FROM iby_fndcpt_tx_extensions x, iby_security_segments s,

4976: IS
4977: SELECT x.trxn_extension_id, x.instr_sec_code_length,
4978: NVL(x.encrypted,'N'), s.segment_cipher_text, k.subkey_cipher_text,
4979: s.sec_segment_id
4980: FROM iby_fndcpt_tx_extensions x, iby_security_segments s,
4981: iby_sys_security_subkeys k
4982: WHERE (NVL(x.encrypted,'N') = 'Y')
4983: AND (NOT instrument_security_code IS NULL)
4984: AND (x.instr_code_sec_segment_id = s.sec_segment_id(+))

Line 5000: UPDATE iby_fndcpt_tx_extensions

4996: RETURN;
4997: END IF;
4998:
4999: FOR c_ext_rec IN c_extensions LOOP
5000: UPDATE iby_fndcpt_tx_extensions
5001: SET
5002: instrument_security_code =
5003: Get_Security_Code(p_sys_security_key,
5004: c_ext_rec.subkey_cipher_text,

Line 5029: p_sec_code_len IN iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE

5025: FUNCTION Get_Security_Code
5026: (p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
5027: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
5028: p_sec_code_cipher IN iby_security_segments.segment_cipher_text%TYPE,
5029: p_sec_code_len IN iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE
5030: )
5031: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE
5032: IS
5033: --Increased the varchar2 size from 30 to 100 since we now

Line 5031: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE

5027: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
5028: p_sec_code_cipher IN iby_security_segments.segment_cipher_text%TYPE,
5029: p_sec_code_len IN iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE
5030: )
5031: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE
5032: IS
5033: --Increased the varchar2 size from 30 to 100 since we now
5034: --pad the cvv to 32 bytes of data.
5035: l_sec_code VARCHAR2(100);

Line 5053: (p_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,

5049: RETURN l_sec_code;
5050: END Get_Security_Code;
5051:
5052: FUNCTION Get_Security_Code
5053: (p_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
5054: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
5055: )
5056: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE
5057: IS

Line 5056: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE

5052: FUNCTION Get_Security_Code
5053: (p_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
5054: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
5055: )
5056: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE
5057: IS
5058: l_sec_code iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
5059: l_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;
5060: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;

Line 5058: l_sec_code iby_fndcpt_tx_extensions.instrument_security_code%TYPE;

5054: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
5055: )
5056: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE
5057: IS
5058: l_sec_code iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
5059: l_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;
5060: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
5061: l_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5062: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;

Line 5059: l_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;

5055: )
5056: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE
5057: IS
5058: l_sec_code iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
5059: l_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;
5060: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
5061: l_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5062: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;
5063: lx_err_code VARCHAR2(100);

Line 5062: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;

5058: l_sec_code iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
5059: l_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;
5060: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
5061: l_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5062: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;
5063: lx_err_code VARCHAR2(100);
5064:
5065: CURSOR c_extension
5066: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)

Line 5066: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)

5062: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;
5063: lx_err_code VARCHAR2(100);
5064:
5065: CURSOR c_extension
5066: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
5067: IS
5068: SELECT x.instrument_security_code, x.instr_sec_code_length,
5069: NVL(x.encrypted,'N'), s.segment_cipher_text, k.subkey_cipher_text
5070: FROM iby_fndcpt_tx_extensions x, iby_security_segments s,

Line 5070: FROM iby_fndcpt_tx_extensions x, iby_security_segments s,

5066: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
5067: IS
5068: SELECT x.instrument_security_code, x.instr_sec_code_length,
5069: NVL(x.encrypted,'N'), s.segment_cipher_text, k.subkey_cipher_text
5070: FROM iby_fndcpt_tx_extensions x, iby_security_segments s,
5071: iby_sys_security_subkeys k
5072: WHERE (trxn_extension_id = ci_extension_id)
5073: AND (x.instr_code_sec_segment_id = s.sec_segment_id(+))
5074: AND (s.sec_subkey_id = k.sec_subkey_id(+));