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_CREDITCARD_PKG dependencies on IBY_CREDITCARD

Line 1: PACKAGE BODY iby_creditcard_pkg AS

1: PACKAGE BODY iby_creditcard_pkg AS
2: /*$Header: ibyccb.pls 120.23.12010000.19 2009/03/24 17:13:18 sugottum ship $*/
3:
4:
5: --

Line 125: FROM iby_creditcard

121:
122: IF (NOT l_keyvalid IS NULL) THEN
123: SELECT count(instrid)
124: INTO l_encrypted_count
125: FROM iby_creditcard
126: WHERE (NVL(encrypted,'N')='Y');
127:
128: IF (l_encrypted_count>0) THEN
129: raise_application_error(-20000,l_keyvalid, FALSE);

Line 139: p_instr_id IN iby_creditcard.instrid%TYPE,

135: -- USE: Saves card information to the credit card history table
136: --
137: PROCEDURE Archive_Card
138: (p_commit IN VARCHAR2,
139: p_instr_id IN iby_creditcard.instrid%TYPE,
140: x_history_id OUT NOCOPY iby_creditcard_h.card_history_change_id%TYPE
141: )
142: IS
143: BEGIN

Line 140: x_history_id OUT NOCOPY iby_creditcard_h.card_history_change_id%TYPE

136: --
137: PROCEDURE Archive_Card
138: (p_commit IN VARCHAR2,
139: p_instr_id IN iby_creditcard.instrid%TYPE,
140: x_history_id OUT NOCOPY iby_creditcard_h.card_history_change_id%TYPE
141: )
142: IS
143: BEGIN
144:

Line 148: * The active_flag column is nullable in IBY_CREDITCARD

144:
145: /*
146: * Fix for bug 5256903 by rameshsh:
147: *
148: * The active_flag column is nullable in IBY_CREDITCARD
149: * but nor in IBY_CREDITCARD_H.
150: *
151: * If active_flag is not set for a particular credit card
152: * in IBY_CREDITCARD, default the value to 'Y', otherwise

Line 149: * but nor in IBY_CREDITCARD_H.

145: /*
146: * Fix for bug 5256903 by rameshsh:
147: *
148: * The active_flag column is nullable in IBY_CREDITCARD
149: * but nor in IBY_CREDITCARD_H.
150: *
151: * If active_flag is not set for a particular credit card
152: * in IBY_CREDITCARD, default the value to 'Y', otherwise
153: * this method will throw a 'cannot insert NULL exception ..'

Line 152: * in IBY_CREDITCARD, default the value to 'Y', otherwise

148: * The active_flag column is nullable in IBY_CREDITCARD
149: * but nor in IBY_CREDITCARD_H.
150: *
151: * If active_flag is not set for a particular credit card
152: * in IBY_CREDITCARD, default the value to 'Y', otherwise
153: * this method will throw a 'cannot insert NULL exception ..'
154: */
155: SELECT iby_creditcard_h_s.NEXTVAL INTO x_history_id FROM dual;
156: INSERT INTO iby_creditcard_h

Line 155: SELECT iby_creditcard_h_s.NEXTVAL INTO x_history_id FROM dual;

151: * If active_flag is not set for a particular credit card
152: * in IBY_CREDITCARD, default the value to 'Y', otherwise
153: * this method will throw a 'cannot insert NULL exception ..'
154: */
155: SELECT iby_creditcard_h_s.NEXTVAL INTO x_history_id FROM dual;
156: INSERT INTO iby_creditcard_h
157: (card_history_change_id, instrid, expirydate, expiry_sec_segment_id,
158: addressid,
159: description, chname, chname_sec_segment_id, finame, security_group_id,

Line 156: INSERT INTO iby_creditcard_h

152: * in IBY_CREDITCARD, default the value to 'Y', otherwise
153: * this method will throw a 'cannot insert NULL exception ..'
154: */
155: SELECT iby_creditcard_h_s.NEXTVAL INTO x_history_id FROM dual;
156: INSERT INTO iby_creditcard_h
157: (card_history_change_id, instrid, expirydate, expiry_sec_segment_id,
158: addressid,
159: description, chname, chname_sec_segment_id, finame, security_group_id,
160: encrypted,

Line 190: FROM iby_creditcard

186: attribute26, attribute27, attribute28, attribute29, attribute30,
187: request_id, program_application_id, program_id, program_update_date,
188: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
189: fnd_global.login_id, 1
190: FROM iby_creditcard
191: WHERE (instrid = p_instr_id);
192:
193: IF FND_API.To_Boolean(p_commit) THEN
194: COMMIT;

Line 230: (p_cc_number IN iby_creditcard.ccnumber%TYPE,

226: END IF;
227: END Get_Mask_Settings;
228:
229: FUNCTION Mask_Card_Number
230: (p_cc_number IN iby_creditcard.ccnumber%TYPE,
231: p_mask_option IN iby_creditcard.card_mask_setting%TYPE,
232: p_unmask_len IN iby_creditcard.card_unmask_length%TYPE
233: )
234: RETURN iby_creditcard.masked_cc_number%TYPE

Line 231: p_mask_option IN iby_creditcard.card_mask_setting%TYPE,

227: END Get_Mask_Settings;
228:
229: FUNCTION Mask_Card_Number
230: (p_cc_number IN iby_creditcard.ccnumber%TYPE,
231: p_mask_option IN iby_creditcard.card_mask_setting%TYPE,
232: p_unmask_len IN iby_creditcard.card_unmask_length%TYPE
233: )
234: RETURN iby_creditcard.masked_cc_number%TYPE
235: IS

Line 232: p_unmask_len IN iby_creditcard.card_unmask_length%TYPE

228:
229: FUNCTION Mask_Card_Number
230: (p_cc_number IN iby_creditcard.ccnumber%TYPE,
231: p_mask_option IN iby_creditcard.card_mask_setting%TYPE,
232: p_unmask_len IN iby_creditcard.card_unmask_length%TYPE
233: )
234: RETURN iby_creditcard.masked_cc_number%TYPE
235: IS
236: BEGIN

Line 234: RETURN iby_creditcard.masked_cc_number%TYPE

230: (p_cc_number IN iby_creditcard.ccnumber%TYPE,
231: p_mask_option IN iby_creditcard.card_mask_setting%TYPE,
232: p_unmask_len IN iby_creditcard.card_unmask_length%TYPE
233: )
234: RETURN iby_creditcard.masked_cc_number%TYPE
235: IS
236: BEGIN
237: RETURN iby_security_pkg.Mask_Data
238: (p_cc_number,p_mask_option,p_unmask_len,G_MASK_CHARACTER);

Line 245: (p_cc_number IN iby_creditcard.ccnumber%TYPE,

241: --
242: -- Return: The masked card number, usable for display purposes
243: --
244: PROCEDURE Mask_Card_Number
245: (p_cc_number IN iby_creditcard.ccnumber%TYPE,
246: x_masked_number OUT NOCOPY iby_creditcard.masked_cc_number%TYPE,
247: x_mask_setting OUT NOCOPY iby_sys_security_options.credit_card_mask_setting%TYPE,
248: x_unmask_len OUT NOCOPY iby_sys_security_options.credit_card_unmask_len%TYPE
249: )

Line 246: x_masked_number OUT NOCOPY iby_creditcard.masked_cc_number%TYPE,

242: -- Return: The masked card number, usable for display purposes
243: --
244: PROCEDURE Mask_Card_Number
245: (p_cc_number IN iby_creditcard.ccnumber%TYPE,
246: x_masked_number OUT NOCOPY iby_creditcard.masked_cc_number%TYPE,
247: x_mask_setting OUT NOCOPY iby_sys_security_options.credit_card_mask_setting%TYPE,
248: x_unmask_len OUT NOCOPY iby_sys_security_options.credit_card_unmask_len%TYPE
249: )
250: IS

Line 257: FUNCTION Mask_Card_Number(p_cc_number IN iby_creditcard.ccnumber%TYPE)

253: x_masked_number :=
254: Mask_Card_Number(p_cc_number,x_mask_setting,x_unmask_len);
255: END Mask_Card_Number;
256:
257: FUNCTION Mask_Card_Number(p_cc_number IN iby_creditcard.ccnumber%TYPE)
258: RETURN iby_creditcard.masked_cc_number%TYPE
259: IS
260: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
261: lx_mask_number iby_creditcard.masked_cc_number%TYPE;

Line 258: RETURN iby_creditcard.masked_cc_number%TYPE

254: Mask_Card_Number(p_cc_number,x_mask_setting,x_unmask_len);
255: END Mask_Card_Number;
256:
257: FUNCTION Mask_Card_Number(p_cc_number IN iby_creditcard.ccnumber%TYPE)
258: RETURN iby_creditcard.masked_cc_number%TYPE
259: IS
260: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
261: lx_mask_number iby_creditcard.masked_cc_number%TYPE;
262: lx_unmask_len iby_sys_security_options.credit_card_unmask_len%TYPE;

Line 260: lx_mask_option iby_creditcard.card_mask_setting%TYPE;

256:
257: FUNCTION Mask_Card_Number(p_cc_number IN iby_creditcard.ccnumber%TYPE)
258: RETURN iby_creditcard.masked_cc_number%TYPE
259: IS
260: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
261: lx_mask_number iby_creditcard.masked_cc_number%TYPE;
262: lx_unmask_len iby_sys_security_options.credit_card_unmask_len%TYPE;
263: BEGIN
264: Mask_Card_Number(p_cc_number,lx_mask_number,lx_mask_option,lx_unmask_len);

Line 261: lx_mask_number iby_creditcard.masked_cc_number%TYPE;

257: FUNCTION Mask_Card_Number(p_cc_number IN iby_creditcard.ccnumber%TYPE)
258: RETURN iby_creditcard.masked_cc_number%TYPE
259: IS
260: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
261: lx_mask_number iby_creditcard.masked_cc_number%TYPE;
262: lx_unmask_len iby_sys_security_options.credit_card_unmask_len%TYPE;
263: BEGIN
264: Mask_Card_Number(p_cc_number,lx_mask_number,lx_mask_option,lx_unmask_len);
265: RETURN lx_mask_number;

Line 271: p_owner_id IN iby_creditcard.card_owner_id%TYPE,

267:
268:
269: PROCEDURE Create_Card
270: (p_commit IN VARCHAR2,
271: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
272: p_holder_name IN iby_creditcard.chname%TYPE,
273: p_billing_address_id IN iby_creditcard.addressid%TYPE,
274: p_address_type IN VARCHAR2,
275: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,

Line 272: p_holder_name IN iby_creditcard.chname%TYPE,

268:
269: PROCEDURE Create_Card
270: (p_commit IN VARCHAR2,
271: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
272: p_holder_name IN iby_creditcard.chname%TYPE,
273: p_billing_address_id IN iby_creditcard.addressid%TYPE,
274: p_address_type IN VARCHAR2,
275: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
276: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,

Line 273: p_billing_address_id IN iby_creditcard.addressid%TYPE,

269: PROCEDURE Create_Card
270: (p_commit IN VARCHAR2,
271: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
272: p_holder_name IN iby_creditcard.chname%TYPE,
273: p_billing_address_id IN iby_creditcard.addressid%TYPE,
274: p_address_type IN VARCHAR2,
275: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
276: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
277: p_card_number IN iby_creditcard.ccnumber%TYPE,

Line 275: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,

271: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
272: p_holder_name IN iby_creditcard.chname%TYPE,
273: p_billing_address_id IN iby_creditcard.addressid%TYPE,
274: p_address_type IN VARCHAR2,
275: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
276: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
277: p_card_number IN iby_creditcard.ccnumber%TYPE,
278: p_expiry_date IN iby_creditcard.expirydate%TYPE,
279: p_instr_type IN iby_creditcard.instrument_type%TYPE,

Line 276: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,

272: p_holder_name IN iby_creditcard.chname%TYPE,
273: p_billing_address_id IN iby_creditcard.addressid%TYPE,
274: p_address_type IN VARCHAR2,
275: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
276: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
277: p_card_number IN iby_creditcard.ccnumber%TYPE,
278: p_expiry_date IN iby_creditcard.expirydate%TYPE,
279: p_instr_type IN iby_creditcard.instrument_type%TYPE,
280: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,

Line 277: p_card_number IN iby_creditcard.ccnumber%TYPE,

273: p_billing_address_id IN iby_creditcard.addressid%TYPE,
274: p_address_type IN VARCHAR2,
275: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
276: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
277: p_card_number IN iby_creditcard.ccnumber%TYPE,
278: p_expiry_date IN iby_creditcard.expirydate%TYPE,
279: p_instr_type IN iby_creditcard.instrument_type%TYPE,
280: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
281: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,

Line 278: p_expiry_date IN iby_creditcard.expirydate%TYPE,

274: p_address_type IN VARCHAR2,
275: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
276: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
277: p_card_number IN iby_creditcard.ccnumber%TYPE,
278: p_expiry_date IN iby_creditcard.expirydate%TYPE,
279: p_instr_type IN iby_creditcard.instrument_type%TYPE,
280: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
281: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
282: p_issuer IN iby_creditcard.card_issuer_code%TYPE,

Line 279: p_instr_type IN iby_creditcard.instrument_type%TYPE,

275: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
276: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
277: p_card_number IN iby_creditcard.ccnumber%TYPE,
278: p_expiry_date IN iby_creditcard.expirydate%TYPE,
279: p_instr_type IN iby_creditcard.instrument_type%TYPE,
280: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
281: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
282: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
283: p_fi_name IN iby_creditcard.finame%TYPE,

Line 280: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,

276: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
277: p_card_number IN iby_creditcard.ccnumber%TYPE,
278: p_expiry_date IN iby_creditcard.expirydate%TYPE,
279: p_instr_type IN iby_creditcard.instrument_type%TYPE,
280: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
281: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
282: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
283: p_fi_name IN iby_creditcard.finame%TYPE,
284: p_single_use IN iby_creditcard.single_use_flag%TYPE,

Line 281: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,

277: p_card_number IN iby_creditcard.ccnumber%TYPE,
278: p_expiry_date IN iby_creditcard.expirydate%TYPE,
279: p_instr_type IN iby_creditcard.instrument_type%TYPE,
280: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
281: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
282: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
283: p_fi_name IN iby_creditcard.finame%TYPE,
284: p_single_use IN iby_creditcard.single_use_flag%TYPE,
285: p_info_only IN iby_creditcard.information_only_flag%TYPE,

Line 282: p_issuer IN iby_creditcard.card_issuer_code%TYPE,

278: p_expiry_date IN iby_creditcard.expirydate%TYPE,
279: p_instr_type IN iby_creditcard.instrument_type%TYPE,
280: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
281: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
282: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
283: p_fi_name IN iby_creditcard.finame%TYPE,
284: p_single_use IN iby_creditcard.single_use_flag%TYPE,
285: p_info_only IN iby_creditcard.information_only_flag%TYPE,
286: p_purpose IN iby_creditcard.card_purpose%TYPE,

Line 283: p_fi_name IN iby_creditcard.finame%TYPE,

279: p_instr_type IN iby_creditcard.instrument_type%TYPE,
280: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
281: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
282: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
283: p_fi_name IN iby_creditcard.finame%TYPE,
284: p_single_use IN iby_creditcard.single_use_flag%TYPE,
285: p_info_only IN iby_creditcard.information_only_flag%TYPE,
286: p_purpose IN iby_creditcard.card_purpose%TYPE,
287: p_desc IN iby_creditcard.description%TYPE,

Line 284: p_single_use IN iby_creditcard.single_use_flag%TYPE,

280: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
281: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
282: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
283: p_fi_name IN iby_creditcard.finame%TYPE,
284: p_single_use IN iby_creditcard.single_use_flag%TYPE,
285: p_info_only IN iby_creditcard.information_only_flag%TYPE,
286: p_purpose IN iby_creditcard.card_purpose%TYPE,
287: p_desc IN iby_creditcard.description%TYPE,
288: p_active_flag IN iby_creditcard.active_flag%TYPE,

Line 285: p_info_only IN iby_creditcard.information_only_flag%TYPE,

281: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
282: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
283: p_fi_name IN iby_creditcard.finame%TYPE,
284: p_single_use IN iby_creditcard.single_use_flag%TYPE,
285: p_info_only IN iby_creditcard.information_only_flag%TYPE,
286: p_purpose IN iby_creditcard.card_purpose%TYPE,
287: p_desc IN iby_creditcard.description%TYPE,
288: p_active_flag IN iby_creditcard.active_flag%TYPE,
289: p_inactive_date IN iby_creditcard.inactive_date%TYPE,

Line 286: p_purpose IN iby_creditcard.card_purpose%TYPE,

282: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
283: p_fi_name IN iby_creditcard.finame%TYPE,
284: p_single_use IN iby_creditcard.single_use_flag%TYPE,
285: p_info_only IN iby_creditcard.information_only_flag%TYPE,
286: p_purpose IN iby_creditcard.card_purpose%TYPE,
287: p_desc IN iby_creditcard.description%TYPE,
288: p_active_flag IN iby_creditcard.active_flag%TYPE,
289: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
290: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,

Line 287: p_desc IN iby_creditcard.description%TYPE,

283: p_fi_name IN iby_creditcard.finame%TYPE,
284: p_single_use IN iby_creditcard.single_use_flag%TYPE,
285: p_info_only IN iby_creditcard.information_only_flag%TYPE,
286: p_purpose IN iby_creditcard.card_purpose%TYPE,
287: p_desc IN iby_creditcard.description%TYPE,
288: p_active_flag IN iby_creditcard.active_flag%TYPE,
289: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
290: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
291: p_attribute_category IN iby_creditcard.attribute_category%TYPE,

Line 288: p_active_flag IN iby_creditcard.active_flag%TYPE,

284: p_single_use IN iby_creditcard.single_use_flag%TYPE,
285: p_info_only IN iby_creditcard.information_only_flag%TYPE,
286: p_purpose IN iby_creditcard.card_purpose%TYPE,
287: p_desc IN iby_creditcard.description%TYPE,
288: p_active_flag IN iby_creditcard.active_flag%TYPE,
289: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
290: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
291: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
292: p_attribute1 IN iby_creditcard.attribute1%TYPE,

Line 289: p_inactive_date IN iby_creditcard.inactive_date%TYPE,

285: p_info_only IN iby_creditcard.information_only_flag%TYPE,
286: p_purpose IN iby_creditcard.card_purpose%TYPE,
287: p_desc IN iby_creditcard.description%TYPE,
288: p_active_flag IN iby_creditcard.active_flag%TYPE,
289: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
290: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
291: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
292: p_attribute1 IN iby_creditcard.attribute1%TYPE,
293: p_attribute2 IN iby_creditcard.attribute2%TYPE,

Line 291: p_attribute_category IN iby_creditcard.attribute_category%TYPE,

287: p_desc IN iby_creditcard.description%TYPE,
288: p_active_flag IN iby_creditcard.active_flag%TYPE,
289: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
290: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
291: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
292: p_attribute1 IN iby_creditcard.attribute1%TYPE,
293: p_attribute2 IN iby_creditcard.attribute2%TYPE,
294: p_attribute3 IN iby_creditcard.attribute3%TYPE,
295: p_attribute4 IN iby_creditcard.attribute4%TYPE,

Line 292: p_attribute1 IN iby_creditcard.attribute1%TYPE,

288: p_active_flag IN iby_creditcard.active_flag%TYPE,
289: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
290: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
291: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
292: p_attribute1 IN iby_creditcard.attribute1%TYPE,
293: p_attribute2 IN iby_creditcard.attribute2%TYPE,
294: p_attribute3 IN iby_creditcard.attribute3%TYPE,
295: p_attribute4 IN iby_creditcard.attribute4%TYPE,
296: p_attribute5 IN iby_creditcard.attribute5%TYPE,

Line 293: p_attribute2 IN iby_creditcard.attribute2%TYPE,

289: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
290: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
291: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
292: p_attribute1 IN iby_creditcard.attribute1%TYPE,
293: p_attribute2 IN iby_creditcard.attribute2%TYPE,
294: p_attribute3 IN iby_creditcard.attribute3%TYPE,
295: p_attribute4 IN iby_creditcard.attribute4%TYPE,
296: p_attribute5 IN iby_creditcard.attribute5%TYPE,
297: p_attribute6 IN iby_creditcard.attribute6%TYPE,

Line 294: p_attribute3 IN iby_creditcard.attribute3%TYPE,

290: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
291: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
292: p_attribute1 IN iby_creditcard.attribute1%TYPE,
293: p_attribute2 IN iby_creditcard.attribute2%TYPE,
294: p_attribute3 IN iby_creditcard.attribute3%TYPE,
295: p_attribute4 IN iby_creditcard.attribute4%TYPE,
296: p_attribute5 IN iby_creditcard.attribute5%TYPE,
297: p_attribute6 IN iby_creditcard.attribute6%TYPE,
298: p_attribute7 IN iby_creditcard.attribute7%TYPE,

Line 295: p_attribute4 IN iby_creditcard.attribute4%TYPE,

291: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
292: p_attribute1 IN iby_creditcard.attribute1%TYPE,
293: p_attribute2 IN iby_creditcard.attribute2%TYPE,
294: p_attribute3 IN iby_creditcard.attribute3%TYPE,
295: p_attribute4 IN iby_creditcard.attribute4%TYPE,
296: p_attribute5 IN iby_creditcard.attribute5%TYPE,
297: p_attribute6 IN iby_creditcard.attribute6%TYPE,
298: p_attribute7 IN iby_creditcard.attribute7%TYPE,
299: p_attribute8 IN iby_creditcard.attribute8%TYPE,

Line 296: p_attribute5 IN iby_creditcard.attribute5%TYPE,

292: p_attribute1 IN iby_creditcard.attribute1%TYPE,
293: p_attribute2 IN iby_creditcard.attribute2%TYPE,
294: p_attribute3 IN iby_creditcard.attribute3%TYPE,
295: p_attribute4 IN iby_creditcard.attribute4%TYPE,
296: p_attribute5 IN iby_creditcard.attribute5%TYPE,
297: p_attribute6 IN iby_creditcard.attribute6%TYPE,
298: p_attribute7 IN iby_creditcard.attribute7%TYPE,
299: p_attribute8 IN iby_creditcard.attribute8%TYPE,
300: p_attribute9 IN iby_creditcard.attribute9%TYPE,

Line 297: p_attribute6 IN iby_creditcard.attribute6%TYPE,

293: p_attribute2 IN iby_creditcard.attribute2%TYPE,
294: p_attribute3 IN iby_creditcard.attribute3%TYPE,
295: p_attribute4 IN iby_creditcard.attribute4%TYPE,
296: p_attribute5 IN iby_creditcard.attribute5%TYPE,
297: p_attribute6 IN iby_creditcard.attribute6%TYPE,
298: p_attribute7 IN iby_creditcard.attribute7%TYPE,
299: p_attribute8 IN iby_creditcard.attribute8%TYPE,
300: p_attribute9 IN iby_creditcard.attribute9%TYPE,
301: p_attribute10 IN iby_creditcard.attribute10%TYPE,

Line 298: p_attribute7 IN iby_creditcard.attribute7%TYPE,

294: p_attribute3 IN iby_creditcard.attribute3%TYPE,
295: p_attribute4 IN iby_creditcard.attribute4%TYPE,
296: p_attribute5 IN iby_creditcard.attribute5%TYPE,
297: p_attribute6 IN iby_creditcard.attribute6%TYPE,
298: p_attribute7 IN iby_creditcard.attribute7%TYPE,
299: p_attribute8 IN iby_creditcard.attribute8%TYPE,
300: p_attribute9 IN iby_creditcard.attribute9%TYPE,
301: p_attribute10 IN iby_creditcard.attribute10%TYPE,
302: p_attribute11 IN iby_creditcard.attribute11%TYPE,

Line 299: p_attribute8 IN iby_creditcard.attribute8%TYPE,

295: p_attribute4 IN iby_creditcard.attribute4%TYPE,
296: p_attribute5 IN iby_creditcard.attribute5%TYPE,
297: p_attribute6 IN iby_creditcard.attribute6%TYPE,
298: p_attribute7 IN iby_creditcard.attribute7%TYPE,
299: p_attribute8 IN iby_creditcard.attribute8%TYPE,
300: p_attribute9 IN iby_creditcard.attribute9%TYPE,
301: p_attribute10 IN iby_creditcard.attribute10%TYPE,
302: p_attribute11 IN iby_creditcard.attribute11%TYPE,
303: p_attribute12 IN iby_creditcard.attribute12%TYPE,

Line 300: p_attribute9 IN iby_creditcard.attribute9%TYPE,

296: p_attribute5 IN iby_creditcard.attribute5%TYPE,
297: p_attribute6 IN iby_creditcard.attribute6%TYPE,
298: p_attribute7 IN iby_creditcard.attribute7%TYPE,
299: p_attribute8 IN iby_creditcard.attribute8%TYPE,
300: p_attribute9 IN iby_creditcard.attribute9%TYPE,
301: p_attribute10 IN iby_creditcard.attribute10%TYPE,
302: p_attribute11 IN iby_creditcard.attribute11%TYPE,
303: p_attribute12 IN iby_creditcard.attribute12%TYPE,
304: p_attribute13 IN iby_creditcard.attribute13%TYPE,

Line 301: p_attribute10 IN iby_creditcard.attribute10%TYPE,

297: p_attribute6 IN iby_creditcard.attribute6%TYPE,
298: p_attribute7 IN iby_creditcard.attribute7%TYPE,
299: p_attribute8 IN iby_creditcard.attribute8%TYPE,
300: p_attribute9 IN iby_creditcard.attribute9%TYPE,
301: p_attribute10 IN iby_creditcard.attribute10%TYPE,
302: p_attribute11 IN iby_creditcard.attribute11%TYPE,
303: p_attribute12 IN iby_creditcard.attribute12%TYPE,
304: p_attribute13 IN iby_creditcard.attribute13%TYPE,
305: p_attribute14 IN iby_creditcard.attribute14%TYPE,

Line 302: p_attribute11 IN iby_creditcard.attribute11%TYPE,

298: p_attribute7 IN iby_creditcard.attribute7%TYPE,
299: p_attribute8 IN iby_creditcard.attribute8%TYPE,
300: p_attribute9 IN iby_creditcard.attribute9%TYPE,
301: p_attribute10 IN iby_creditcard.attribute10%TYPE,
302: p_attribute11 IN iby_creditcard.attribute11%TYPE,
303: p_attribute12 IN iby_creditcard.attribute12%TYPE,
304: p_attribute13 IN iby_creditcard.attribute13%TYPE,
305: p_attribute14 IN iby_creditcard.attribute14%TYPE,
306: p_attribute15 IN iby_creditcard.attribute15%TYPE,

Line 303: p_attribute12 IN iby_creditcard.attribute12%TYPE,

299: p_attribute8 IN iby_creditcard.attribute8%TYPE,
300: p_attribute9 IN iby_creditcard.attribute9%TYPE,
301: p_attribute10 IN iby_creditcard.attribute10%TYPE,
302: p_attribute11 IN iby_creditcard.attribute11%TYPE,
303: p_attribute12 IN iby_creditcard.attribute12%TYPE,
304: p_attribute13 IN iby_creditcard.attribute13%TYPE,
305: p_attribute14 IN iby_creditcard.attribute14%TYPE,
306: p_attribute15 IN iby_creditcard.attribute15%TYPE,
307: p_attribute16 IN iby_creditcard.attribute16%TYPE,

Line 304: p_attribute13 IN iby_creditcard.attribute13%TYPE,

300: p_attribute9 IN iby_creditcard.attribute9%TYPE,
301: p_attribute10 IN iby_creditcard.attribute10%TYPE,
302: p_attribute11 IN iby_creditcard.attribute11%TYPE,
303: p_attribute12 IN iby_creditcard.attribute12%TYPE,
304: p_attribute13 IN iby_creditcard.attribute13%TYPE,
305: p_attribute14 IN iby_creditcard.attribute14%TYPE,
306: p_attribute15 IN iby_creditcard.attribute15%TYPE,
307: p_attribute16 IN iby_creditcard.attribute16%TYPE,
308: p_attribute17 IN iby_creditcard.attribute17%TYPE,

Line 305: p_attribute14 IN iby_creditcard.attribute14%TYPE,

301: p_attribute10 IN iby_creditcard.attribute10%TYPE,
302: p_attribute11 IN iby_creditcard.attribute11%TYPE,
303: p_attribute12 IN iby_creditcard.attribute12%TYPE,
304: p_attribute13 IN iby_creditcard.attribute13%TYPE,
305: p_attribute14 IN iby_creditcard.attribute14%TYPE,
306: p_attribute15 IN iby_creditcard.attribute15%TYPE,
307: p_attribute16 IN iby_creditcard.attribute16%TYPE,
308: p_attribute17 IN iby_creditcard.attribute17%TYPE,
309: p_attribute18 IN iby_creditcard.attribute18%TYPE,

Line 306: p_attribute15 IN iby_creditcard.attribute15%TYPE,

302: p_attribute11 IN iby_creditcard.attribute11%TYPE,
303: p_attribute12 IN iby_creditcard.attribute12%TYPE,
304: p_attribute13 IN iby_creditcard.attribute13%TYPE,
305: p_attribute14 IN iby_creditcard.attribute14%TYPE,
306: p_attribute15 IN iby_creditcard.attribute15%TYPE,
307: p_attribute16 IN iby_creditcard.attribute16%TYPE,
308: p_attribute17 IN iby_creditcard.attribute17%TYPE,
309: p_attribute18 IN iby_creditcard.attribute18%TYPE,
310: p_attribute19 IN iby_creditcard.attribute19%TYPE,

Line 307: p_attribute16 IN iby_creditcard.attribute16%TYPE,

303: p_attribute12 IN iby_creditcard.attribute12%TYPE,
304: p_attribute13 IN iby_creditcard.attribute13%TYPE,
305: p_attribute14 IN iby_creditcard.attribute14%TYPE,
306: p_attribute15 IN iby_creditcard.attribute15%TYPE,
307: p_attribute16 IN iby_creditcard.attribute16%TYPE,
308: p_attribute17 IN iby_creditcard.attribute17%TYPE,
309: p_attribute18 IN iby_creditcard.attribute18%TYPE,
310: p_attribute19 IN iby_creditcard.attribute19%TYPE,
311: p_attribute20 IN iby_creditcard.attribute20%TYPE,

Line 308: p_attribute17 IN iby_creditcard.attribute17%TYPE,

304: p_attribute13 IN iby_creditcard.attribute13%TYPE,
305: p_attribute14 IN iby_creditcard.attribute14%TYPE,
306: p_attribute15 IN iby_creditcard.attribute15%TYPE,
307: p_attribute16 IN iby_creditcard.attribute16%TYPE,
308: p_attribute17 IN iby_creditcard.attribute17%TYPE,
309: p_attribute18 IN iby_creditcard.attribute18%TYPE,
310: p_attribute19 IN iby_creditcard.attribute19%TYPE,
311: p_attribute20 IN iby_creditcard.attribute20%TYPE,
312: p_attribute21 IN iby_creditcard.attribute21%TYPE,

Line 309: p_attribute18 IN iby_creditcard.attribute18%TYPE,

305: p_attribute14 IN iby_creditcard.attribute14%TYPE,
306: p_attribute15 IN iby_creditcard.attribute15%TYPE,
307: p_attribute16 IN iby_creditcard.attribute16%TYPE,
308: p_attribute17 IN iby_creditcard.attribute17%TYPE,
309: p_attribute18 IN iby_creditcard.attribute18%TYPE,
310: p_attribute19 IN iby_creditcard.attribute19%TYPE,
311: p_attribute20 IN iby_creditcard.attribute20%TYPE,
312: p_attribute21 IN iby_creditcard.attribute21%TYPE,
313: p_attribute22 IN iby_creditcard.attribute22%TYPE,

Line 310: p_attribute19 IN iby_creditcard.attribute19%TYPE,

306: p_attribute15 IN iby_creditcard.attribute15%TYPE,
307: p_attribute16 IN iby_creditcard.attribute16%TYPE,
308: p_attribute17 IN iby_creditcard.attribute17%TYPE,
309: p_attribute18 IN iby_creditcard.attribute18%TYPE,
310: p_attribute19 IN iby_creditcard.attribute19%TYPE,
311: p_attribute20 IN iby_creditcard.attribute20%TYPE,
312: p_attribute21 IN iby_creditcard.attribute21%TYPE,
313: p_attribute22 IN iby_creditcard.attribute22%TYPE,
314: p_attribute23 IN iby_creditcard.attribute23%TYPE,

Line 311: p_attribute20 IN iby_creditcard.attribute20%TYPE,

307: p_attribute16 IN iby_creditcard.attribute16%TYPE,
308: p_attribute17 IN iby_creditcard.attribute17%TYPE,
309: p_attribute18 IN iby_creditcard.attribute18%TYPE,
310: p_attribute19 IN iby_creditcard.attribute19%TYPE,
311: p_attribute20 IN iby_creditcard.attribute20%TYPE,
312: p_attribute21 IN iby_creditcard.attribute21%TYPE,
313: p_attribute22 IN iby_creditcard.attribute22%TYPE,
314: p_attribute23 IN iby_creditcard.attribute23%TYPE,
315: p_attribute24 IN iby_creditcard.attribute24%TYPE,

Line 312: p_attribute21 IN iby_creditcard.attribute21%TYPE,

308: p_attribute17 IN iby_creditcard.attribute17%TYPE,
309: p_attribute18 IN iby_creditcard.attribute18%TYPE,
310: p_attribute19 IN iby_creditcard.attribute19%TYPE,
311: p_attribute20 IN iby_creditcard.attribute20%TYPE,
312: p_attribute21 IN iby_creditcard.attribute21%TYPE,
313: p_attribute22 IN iby_creditcard.attribute22%TYPE,
314: p_attribute23 IN iby_creditcard.attribute23%TYPE,
315: p_attribute24 IN iby_creditcard.attribute24%TYPE,
316: p_attribute25 IN iby_creditcard.attribute25%TYPE,

Line 313: p_attribute22 IN iby_creditcard.attribute22%TYPE,

309: p_attribute18 IN iby_creditcard.attribute18%TYPE,
310: p_attribute19 IN iby_creditcard.attribute19%TYPE,
311: p_attribute20 IN iby_creditcard.attribute20%TYPE,
312: p_attribute21 IN iby_creditcard.attribute21%TYPE,
313: p_attribute22 IN iby_creditcard.attribute22%TYPE,
314: p_attribute23 IN iby_creditcard.attribute23%TYPE,
315: p_attribute24 IN iby_creditcard.attribute24%TYPE,
316: p_attribute25 IN iby_creditcard.attribute25%TYPE,
317: p_attribute26 IN iby_creditcard.attribute26%TYPE,

Line 314: p_attribute23 IN iby_creditcard.attribute23%TYPE,

310: p_attribute19 IN iby_creditcard.attribute19%TYPE,
311: p_attribute20 IN iby_creditcard.attribute20%TYPE,
312: p_attribute21 IN iby_creditcard.attribute21%TYPE,
313: p_attribute22 IN iby_creditcard.attribute22%TYPE,
314: p_attribute23 IN iby_creditcard.attribute23%TYPE,
315: p_attribute24 IN iby_creditcard.attribute24%TYPE,
316: p_attribute25 IN iby_creditcard.attribute25%TYPE,
317: p_attribute26 IN iby_creditcard.attribute26%TYPE,
318: p_attribute27 IN iby_creditcard.attribute27%TYPE,

Line 315: p_attribute24 IN iby_creditcard.attribute24%TYPE,

311: p_attribute20 IN iby_creditcard.attribute20%TYPE,
312: p_attribute21 IN iby_creditcard.attribute21%TYPE,
313: p_attribute22 IN iby_creditcard.attribute22%TYPE,
314: p_attribute23 IN iby_creditcard.attribute23%TYPE,
315: p_attribute24 IN iby_creditcard.attribute24%TYPE,
316: p_attribute25 IN iby_creditcard.attribute25%TYPE,
317: p_attribute26 IN iby_creditcard.attribute26%TYPE,
318: p_attribute27 IN iby_creditcard.attribute27%TYPE,
319: p_attribute28 IN iby_creditcard.attribute28%TYPE,

Line 316: p_attribute25 IN iby_creditcard.attribute25%TYPE,

312: p_attribute21 IN iby_creditcard.attribute21%TYPE,
313: p_attribute22 IN iby_creditcard.attribute22%TYPE,
314: p_attribute23 IN iby_creditcard.attribute23%TYPE,
315: p_attribute24 IN iby_creditcard.attribute24%TYPE,
316: p_attribute25 IN iby_creditcard.attribute25%TYPE,
317: p_attribute26 IN iby_creditcard.attribute26%TYPE,
318: p_attribute27 IN iby_creditcard.attribute27%TYPE,
319: p_attribute28 IN iby_creditcard.attribute28%TYPE,
320: p_attribute29 IN iby_creditcard.attribute29%TYPE,

Line 317: p_attribute26 IN iby_creditcard.attribute26%TYPE,

313: p_attribute22 IN iby_creditcard.attribute22%TYPE,
314: p_attribute23 IN iby_creditcard.attribute23%TYPE,
315: p_attribute24 IN iby_creditcard.attribute24%TYPE,
316: p_attribute25 IN iby_creditcard.attribute25%TYPE,
317: p_attribute26 IN iby_creditcard.attribute26%TYPE,
318: p_attribute27 IN iby_creditcard.attribute27%TYPE,
319: p_attribute28 IN iby_creditcard.attribute28%TYPE,
320: p_attribute29 IN iby_creditcard.attribute29%TYPE,
321: p_attribute30 IN iby_creditcard.attribute30%TYPE,

Line 318: p_attribute27 IN iby_creditcard.attribute27%TYPE,

314: p_attribute23 IN iby_creditcard.attribute23%TYPE,
315: p_attribute24 IN iby_creditcard.attribute24%TYPE,
316: p_attribute25 IN iby_creditcard.attribute25%TYPE,
317: p_attribute26 IN iby_creditcard.attribute26%TYPE,
318: p_attribute27 IN iby_creditcard.attribute27%TYPE,
319: p_attribute28 IN iby_creditcard.attribute28%TYPE,
320: p_attribute29 IN iby_creditcard.attribute29%TYPE,
321: p_attribute30 IN iby_creditcard.attribute30%TYPE,
322: x_result_code OUT NOCOPY VARCHAR2,

Line 319: p_attribute28 IN iby_creditcard.attribute28%TYPE,

315: p_attribute24 IN iby_creditcard.attribute24%TYPE,
316: p_attribute25 IN iby_creditcard.attribute25%TYPE,
317: p_attribute26 IN iby_creditcard.attribute26%TYPE,
318: p_attribute27 IN iby_creditcard.attribute27%TYPE,
319: p_attribute28 IN iby_creditcard.attribute28%TYPE,
320: p_attribute29 IN iby_creditcard.attribute29%TYPE,
321: p_attribute30 IN iby_creditcard.attribute30%TYPE,
322: x_result_code OUT NOCOPY VARCHAR2,
323: x_instr_id OUT NOCOPY iby_creditcard.instrid%TYPE

Line 320: p_attribute29 IN iby_creditcard.attribute29%TYPE,

316: p_attribute25 IN iby_creditcard.attribute25%TYPE,
317: p_attribute26 IN iby_creditcard.attribute26%TYPE,
318: p_attribute27 IN iby_creditcard.attribute27%TYPE,
319: p_attribute28 IN iby_creditcard.attribute28%TYPE,
320: p_attribute29 IN iby_creditcard.attribute29%TYPE,
321: p_attribute30 IN iby_creditcard.attribute30%TYPE,
322: x_result_code OUT NOCOPY VARCHAR2,
323: x_instr_id OUT NOCOPY iby_creditcard.instrid%TYPE
324: )

Line 321: p_attribute30 IN iby_creditcard.attribute30%TYPE,

317: p_attribute26 IN iby_creditcard.attribute26%TYPE,
318: p_attribute27 IN iby_creditcard.attribute27%TYPE,
319: p_attribute28 IN iby_creditcard.attribute28%TYPE,
320: p_attribute29 IN iby_creditcard.attribute29%TYPE,
321: p_attribute30 IN iby_creditcard.attribute30%TYPE,
322: x_result_code OUT NOCOPY VARCHAR2,
323: x_instr_id OUT NOCOPY iby_creditcard.instrid%TYPE
324: )
325: IS

Line 323: x_instr_id OUT NOCOPY iby_creditcard.instrid%TYPE

319: p_attribute28 IN iby_creditcard.attribute28%TYPE,
320: p_attribute29 IN iby_creditcard.attribute29%TYPE,
321: p_attribute30 IN iby_creditcard.attribute30%TYPE,
322: x_result_code OUT NOCOPY VARCHAR2,
323: x_instr_id OUT NOCOPY iby_creditcard.instrid%TYPE
324: )
325: IS
326:
327: lx_checksum_valid BOOLEAN := FALSE;

Line 331: lx_card_issuer iby_creditcard.card_issuer_code%TYPE;

327: lx_checksum_valid BOOLEAN := FALSE;
328: lx_return_status VARCHAR2(1);
329: lx_msg_count NUMBER;
330: lx_msg_data VARCHAR2(200);
331: lx_card_issuer iby_creditcard.card_issuer_code%TYPE;
332: lx_issuer_range iby_creditcard.cc_issuer_range_id%TYPE;
333: lx_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
334: lx_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
335: l_card_len iby_creditcard.cc_number_length%TYPE;

Line 332: lx_issuer_range iby_creditcard.cc_issuer_range_id%TYPE;

328: lx_return_status VARCHAR2(1);
329: lx_msg_count NUMBER;
330: lx_msg_data VARCHAR2(200);
331: lx_card_issuer iby_creditcard.card_issuer_code%TYPE;
332: lx_issuer_range iby_creditcard.cc_issuer_range_id%TYPE;
333: lx_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
334: lx_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
335: l_card_len iby_creditcard.cc_number_length%TYPE;
336:

Line 334: lx_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;

330: lx_msg_data VARCHAR2(200);
331: lx_card_issuer iby_creditcard.card_issuer_code%TYPE;
332: lx_issuer_range iby_creditcard.cc_issuer_range_id%TYPE;
333: lx_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
334: lx_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
335: l_card_len iby_creditcard.cc_number_length%TYPE;
336:
337: lx_cc_number iby_creditcard.ccnumber%TYPE;
338: lx_cc_compressed iby_creditcard.ccnumber%TYPE;

Line 335: l_card_len iby_creditcard.cc_number_length%TYPE;

331: lx_card_issuer iby_creditcard.card_issuer_code%TYPE;
332: lx_issuer_range iby_creditcard.cc_issuer_range_id%TYPE;
333: lx_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
334: lx_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
335: l_card_len iby_creditcard.cc_number_length%TYPE;
336:
337: lx_cc_number iby_creditcard.ccnumber%TYPE;
338: lx_cc_compressed iby_creditcard.ccnumber%TYPE;
339: lx_unmasked_digits iby_creditcard.ccnumber%TYPE;

Line 337: lx_cc_number iby_creditcard.ccnumber%TYPE;

333: lx_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
334: lx_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
335: l_card_len iby_creditcard.cc_number_length%TYPE;
336:
337: lx_cc_number iby_creditcard.ccnumber%TYPE;
338: lx_cc_compressed iby_creditcard.ccnumber%TYPE;
339: lx_unmasked_digits iby_creditcard.ccnumber%TYPE;
340: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
341: l_encrypted iby_creditcard.encrypted%TYPE;

Line 338: lx_cc_compressed iby_creditcard.ccnumber%TYPE;

334: lx_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
335: l_card_len iby_creditcard.cc_number_length%TYPE;
336:
337: lx_cc_number iby_creditcard.ccnumber%TYPE;
338: lx_cc_compressed iby_creditcard.ccnumber%TYPE;
339: lx_unmasked_digits iby_creditcard.ccnumber%TYPE;
340: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
341: l_encrypted iby_creditcard.encrypted%TYPE;
342: lx_masked_number iby_creditcard.masked_cc_number%TYPE;

Line 339: lx_unmasked_digits iby_creditcard.ccnumber%TYPE;

335: l_card_len iby_creditcard.cc_number_length%TYPE;
336:
337: lx_cc_number iby_creditcard.ccnumber%TYPE;
338: lx_cc_compressed iby_creditcard.ccnumber%TYPE;
339: lx_unmasked_digits iby_creditcard.ccnumber%TYPE;
340: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
341: l_encrypted iby_creditcard.encrypted%TYPE;
342: lx_masked_number iby_creditcard.masked_cc_number%TYPE;
343: lx_mask_option iby_creditcard.card_mask_setting%TYPE;

Line 341: l_encrypted iby_creditcard.encrypted%TYPE;

337: lx_cc_number iby_creditcard.ccnumber%TYPE;
338: lx_cc_compressed iby_creditcard.ccnumber%TYPE;
339: lx_unmasked_digits iby_creditcard.ccnumber%TYPE;
340: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
341: l_encrypted iby_creditcard.encrypted%TYPE;
342: lx_masked_number iby_creditcard.masked_cc_number%TYPE;
343: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
344: lx_unmask_len iby_creditcard.card_unmask_length%TYPE;
345: l_cc_hash1 iby_creditcard.cc_number_hash1%TYPE;

Line 342: lx_masked_number iby_creditcard.masked_cc_number%TYPE;

338: lx_cc_compressed iby_creditcard.ccnumber%TYPE;
339: lx_unmasked_digits iby_creditcard.ccnumber%TYPE;
340: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
341: l_encrypted iby_creditcard.encrypted%TYPE;
342: lx_masked_number iby_creditcard.masked_cc_number%TYPE;
343: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
344: lx_unmask_len iby_creditcard.card_unmask_length%TYPE;
345: l_cc_hash1 iby_creditcard.cc_number_hash1%TYPE;
346: l_cc_hash2 iby_creditcard.cc_number_hash2%TYPE;

Line 343: lx_mask_option iby_creditcard.card_mask_setting%TYPE;

339: lx_unmasked_digits iby_creditcard.ccnumber%TYPE;
340: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
341: l_encrypted iby_creditcard.encrypted%TYPE;
342: lx_masked_number iby_creditcard.masked_cc_number%TYPE;
343: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
344: lx_unmask_len iby_creditcard.card_unmask_length%TYPE;
345: l_cc_hash1 iby_creditcard.cc_number_hash1%TYPE;
346: l_cc_hash2 iby_creditcard.cc_number_hash2%TYPE;
347: lx_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

Line 344: lx_unmask_len iby_creditcard.card_unmask_length%TYPE;

340: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
341: l_encrypted iby_creditcard.encrypted%TYPE;
342: lx_masked_number iby_creditcard.masked_cc_number%TYPE;
343: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
344: lx_unmask_len iby_creditcard.card_unmask_length%TYPE;
345: l_cc_hash1 iby_creditcard.cc_number_hash1%TYPE;
346: l_cc_hash2 iby_creditcard.cc_number_hash2%TYPE;
347: lx_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
348:

Line 345: l_cc_hash1 iby_creditcard.cc_number_hash1%TYPE;

341: l_encrypted iby_creditcard.encrypted%TYPE;
342: lx_masked_number iby_creditcard.masked_cc_number%TYPE;
343: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
344: lx_unmask_len iby_creditcard.card_unmask_length%TYPE;
345: l_cc_hash1 iby_creditcard.cc_number_hash1%TYPE;
346: l_cc_hash2 iby_creditcard.cc_number_hash2%TYPE;
347: lx_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
348:
349: l_expiry_date iby_creditcard.expirydate%TYPE;

Line 346: l_cc_hash2 iby_creditcard.cc_number_hash2%TYPE;

342: lx_masked_number iby_creditcard.masked_cc_number%TYPE;
343: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
344: lx_unmask_len iby_creditcard.card_unmask_length%TYPE;
345: l_cc_hash1 iby_creditcard.cc_number_hash1%TYPE;
346: l_cc_hash2 iby_creditcard.cc_number_hash2%TYPE;
347: lx_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
348:
349: l_expiry_date iby_creditcard.expirydate%TYPE;
350: l_billing_site hz_party_site_uses.party_site_use_id%TYPE;

Line 349: l_expiry_date iby_creditcard.expirydate%TYPE;

345: l_cc_hash1 iby_creditcard.cc_number_hash1%TYPE;
346: l_cc_hash2 iby_creditcard.cc_number_hash2%TYPE;
347: lx_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
348:
349: l_expiry_date iby_creditcard.expirydate%TYPE;
350: l_billing_site hz_party_site_uses.party_site_use_id%TYPE;
351:
352: -- variabled for CHNAME and EXPDATE encryption
353: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

Line 368: ci_hash1 IN iby_creditcard.cc_number_hash1%TYPE,

364:
365:
366: CURSOR c_card
367: (ci_owner_id IN hz_parties.party_id%TYPE,
368: ci_hash1 IN iby_creditcard.cc_number_hash1%TYPE,
369: ci_hash2 IN iby_creditcard.cc_number_hash1%TYPE
370: )
371: IS
372: SELECT instrid

Line 369: ci_hash2 IN iby_creditcard.cc_number_hash1%TYPE

365:
366: CURSOR c_card
367: (ci_owner_id IN hz_parties.party_id%TYPE,
368: ci_hash1 IN iby_creditcard.cc_number_hash1%TYPE,
369: ci_hash2 IN iby_creditcard.cc_number_hash1%TYPE
370: )
371: IS
372: SELECT instrid
373: FROM iby_creditcard

Line 373: FROM iby_creditcard

369: ci_hash2 IN iby_creditcard.cc_number_hash1%TYPE
370: )
371: IS
372: SELECT instrid
373: FROM iby_creditcard
374: WHERE (cc_number_hash1 = ci_hash1)
375: AND (cc_number_hash2 = ci_hash2)
376: AND ( (NVL(card_owner_id,ci_owner_id) = NVL(ci_owner_id,card_owner_id))
377: OR (card_owner_id IS NULL AND ci_owner_id IS NULL)

Line 564: INSERT INTO iby_creditcard

560: -- l_chname_length := NVL(LENGTH(p_holder_name), 0);
561:
562: SELECT iby_instr_s.NEXTVAL INTO x_instr_id FROM DUAL;
563:
564: INSERT INTO iby_creditcard
565: (instrid, ccnumber, masked_cc_number,
566: card_mask_setting, card_unmask_length, cc_number_hash1, cc_number_hash2,
567: expirydate, expiry_sec_segment_id,
568: card_owner_id, chname, chname_sec_segment_id,

Line 616: p_instr_id IN iby_creditcard.instrid%TYPE,

612: END Create_Card;
613:
614: PROCEDURE Update_Card
615: (p_commit IN VARCHAR2,
616: p_instr_id IN iby_creditcard.instrid%TYPE,
617: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
618: p_holder_name IN iby_creditcard.chname%TYPE,
619: p_billing_address_id IN iby_creditcard.addressid%TYPE,
620: p_address_type IN VARCHAR2,

Line 617: p_owner_id IN iby_creditcard.card_owner_id%TYPE,

613:
614: PROCEDURE Update_Card
615: (p_commit IN VARCHAR2,
616: p_instr_id IN iby_creditcard.instrid%TYPE,
617: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
618: p_holder_name IN iby_creditcard.chname%TYPE,
619: p_billing_address_id IN iby_creditcard.addressid%TYPE,
620: p_address_type IN VARCHAR2,
621: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,

Line 618: p_holder_name IN iby_creditcard.chname%TYPE,

614: PROCEDURE Update_Card
615: (p_commit IN VARCHAR2,
616: p_instr_id IN iby_creditcard.instrid%TYPE,
617: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
618: p_holder_name IN iby_creditcard.chname%TYPE,
619: p_billing_address_id IN iby_creditcard.addressid%TYPE,
620: p_address_type IN VARCHAR2,
621: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
622: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,

Line 619: p_billing_address_id IN iby_creditcard.addressid%TYPE,

615: (p_commit IN VARCHAR2,
616: p_instr_id IN iby_creditcard.instrid%TYPE,
617: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
618: p_holder_name IN iby_creditcard.chname%TYPE,
619: p_billing_address_id IN iby_creditcard.addressid%TYPE,
620: p_address_type IN VARCHAR2,
621: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
622: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
623: p_expiry_date IN iby_creditcard.expirydate%TYPE,

Line 621: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,

617: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
618: p_holder_name IN iby_creditcard.chname%TYPE,
619: p_billing_address_id IN iby_creditcard.addressid%TYPE,
620: p_address_type IN VARCHAR2,
621: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
622: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
623: p_expiry_date IN iby_creditcard.expirydate%TYPE,
624: p_instr_type IN iby_creditcard.instrument_type%TYPE,
625: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,

Line 622: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,

618: p_holder_name IN iby_creditcard.chname%TYPE,
619: p_billing_address_id IN iby_creditcard.addressid%TYPE,
620: p_address_type IN VARCHAR2,
621: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
622: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
623: p_expiry_date IN iby_creditcard.expirydate%TYPE,
624: p_instr_type IN iby_creditcard.instrument_type%TYPE,
625: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
626: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,

Line 623: p_expiry_date IN iby_creditcard.expirydate%TYPE,

619: p_billing_address_id IN iby_creditcard.addressid%TYPE,
620: p_address_type IN VARCHAR2,
621: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
622: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
623: p_expiry_date IN iby_creditcard.expirydate%TYPE,
624: p_instr_type IN iby_creditcard.instrument_type%TYPE,
625: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
626: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
627: p_fi_name IN iby_creditcard.finame%TYPE,

Line 624: p_instr_type IN iby_creditcard.instrument_type%TYPE,

620: p_address_type IN VARCHAR2,
621: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
622: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
623: p_expiry_date IN iby_creditcard.expirydate%TYPE,
624: p_instr_type IN iby_creditcard.instrument_type%TYPE,
625: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
626: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
627: p_fi_name IN iby_creditcard.finame%TYPE,
628: p_single_use IN iby_creditcard.single_use_flag%TYPE,

Line 625: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,

621: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
622: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
623: p_expiry_date IN iby_creditcard.expirydate%TYPE,
624: p_instr_type IN iby_creditcard.instrument_type%TYPE,
625: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
626: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
627: p_fi_name IN iby_creditcard.finame%TYPE,
628: p_single_use IN iby_creditcard.single_use_flag%TYPE,
629: p_info_only IN iby_creditcard.information_only_flag%TYPE,

Line 626: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,

622: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
623: p_expiry_date IN iby_creditcard.expirydate%TYPE,
624: p_instr_type IN iby_creditcard.instrument_type%TYPE,
625: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
626: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
627: p_fi_name IN iby_creditcard.finame%TYPE,
628: p_single_use IN iby_creditcard.single_use_flag%TYPE,
629: p_info_only IN iby_creditcard.information_only_flag%TYPE,
630: p_purpose IN iby_creditcard.card_purpose%TYPE,

Line 627: p_fi_name IN iby_creditcard.finame%TYPE,

623: p_expiry_date IN iby_creditcard.expirydate%TYPE,
624: p_instr_type IN iby_creditcard.instrument_type%TYPE,
625: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
626: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
627: p_fi_name IN iby_creditcard.finame%TYPE,
628: p_single_use IN iby_creditcard.single_use_flag%TYPE,
629: p_info_only IN iby_creditcard.information_only_flag%TYPE,
630: p_purpose IN iby_creditcard.card_purpose%TYPE,
631: p_desc IN iby_creditcard.description%TYPE,

Line 628: p_single_use IN iby_creditcard.single_use_flag%TYPE,

624: p_instr_type IN iby_creditcard.instrument_type%TYPE,
625: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
626: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
627: p_fi_name IN iby_creditcard.finame%TYPE,
628: p_single_use IN iby_creditcard.single_use_flag%TYPE,
629: p_info_only IN iby_creditcard.information_only_flag%TYPE,
630: p_purpose IN iby_creditcard.card_purpose%TYPE,
631: p_desc IN iby_creditcard.description%TYPE,
632: p_active_flag IN iby_creditcard.active_flag%TYPE,

Line 629: p_info_only IN iby_creditcard.information_only_flag%TYPE,

625: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
626: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
627: p_fi_name IN iby_creditcard.finame%TYPE,
628: p_single_use IN iby_creditcard.single_use_flag%TYPE,
629: p_info_only IN iby_creditcard.information_only_flag%TYPE,
630: p_purpose IN iby_creditcard.card_purpose%TYPE,
631: p_desc IN iby_creditcard.description%TYPE,
632: p_active_flag IN iby_creditcard.active_flag%TYPE,
633: p_inactive_date IN iby_creditcard.inactive_date%TYPE,

Line 630: p_purpose IN iby_creditcard.card_purpose%TYPE,

626: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
627: p_fi_name IN iby_creditcard.finame%TYPE,
628: p_single_use IN iby_creditcard.single_use_flag%TYPE,
629: p_info_only IN iby_creditcard.information_only_flag%TYPE,
630: p_purpose IN iby_creditcard.card_purpose%TYPE,
631: p_desc IN iby_creditcard.description%TYPE,
632: p_active_flag IN iby_creditcard.active_flag%TYPE,
633: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
634: p_attribute_category IN iby_creditcard.attribute_category%TYPE,

Line 631: p_desc IN iby_creditcard.description%TYPE,

627: p_fi_name IN iby_creditcard.finame%TYPE,
628: p_single_use IN iby_creditcard.single_use_flag%TYPE,
629: p_info_only IN iby_creditcard.information_only_flag%TYPE,
630: p_purpose IN iby_creditcard.card_purpose%TYPE,
631: p_desc IN iby_creditcard.description%TYPE,
632: p_active_flag IN iby_creditcard.active_flag%TYPE,
633: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
634: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
635: p_attribute1 IN iby_creditcard.attribute1%TYPE,

Line 632: p_active_flag IN iby_creditcard.active_flag%TYPE,

628: p_single_use IN iby_creditcard.single_use_flag%TYPE,
629: p_info_only IN iby_creditcard.information_only_flag%TYPE,
630: p_purpose IN iby_creditcard.card_purpose%TYPE,
631: p_desc IN iby_creditcard.description%TYPE,
632: p_active_flag IN iby_creditcard.active_flag%TYPE,
633: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
634: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
635: p_attribute1 IN iby_creditcard.attribute1%TYPE,
636: p_attribute2 IN iby_creditcard.attribute2%TYPE,

Line 633: p_inactive_date IN iby_creditcard.inactive_date%TYPE,

629: p_info_only IN iby_creditcard.information_only_flag%TYPE,
630: p_purpose IN iby_creditcard.card_purpose%TYPE,
631: p_desc IN iby_creditcard.description%TYPE,
632: p_active_flag IN iby_creditcard.active_flag%TYPE,
633: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
634: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
635: p_attribute1 IN iby_creditcard.attribute1%TYPE,
636: p_attribute2 IN iby_creditcard.attribute2%TYPE,
637: p_attribute3 IN iby_creditcard.attribute3%TYPE,

Line 634: p_attribute_category IN iby_creditcard.attribute_category%TYPE,

630: p_purpose IN iby_creditcard.card_purpose%TYPE,
631: p_desc IN iby_creditcard.description%TYPE,
632: p_active_flag IN iby_creditcard.active_flag%TYPE,
633: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
634: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
635: p_attribute1 IN iby_creditcard.attribute1%TYPE,
636: p_attribute2 IN iby_creditcard.attribute2%TYPE,
637: p_attribute3 IN iby_creditcard.attribute3%TYPE,
638: p_attribute4 IN iby_creditcard.attribute4%TYPE,

Line 635: p_attribute1 IN iby_creditcard.attribute1%TYPE,

631: p_desc IN iby_creditcard.description%TYPE,
632: p_active_flag IN iby_creditcard.active_flag%TYPE,
633: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
634: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
635: p_attribute1 IN iby_creditcard.attribute1%TYPE,
636: p_attribute2 IN iby_creditcard.attribute2%TYPE,
637: p_attribute3 IN iby_creditcard.attribute3%TYPE,
638: p_attribute4 IN iby_creditcard.attribute4%TYPE,
639: p_attribute5 IN iby_creditcard.attribute5%TYPE,

Line 636: p_attribute2 IN iby_creditcard.attribute2%TYPE,

632: p_active_flag IN iby_creditcard.active_flag%TYPE,
633: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
634: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
635: p_attribute1 IN iby_creditcard.attribute1%TYPE,
636: p_attribute2 IN iby_creditcard.attribute2%TYPE,
637: p_attribute3 IN iby_creditcard.attribute3%TYPE,
638: p_attribute4 IN iby_creditcard.attribute4%TYPE,
639: p_attribute5 IN iby_creditcard.attribute5%TYPE,
640: p_attribute6 IN iby_creditcard.attribute6%TYPE,

Line 637: p_attribute3 IN iby_creditcard.attribute3%TYPE,

633: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
634: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
635: p_attribute1 IN iby_creditcard.attribute1%TYPE,
636: p_attribute2 IN iby_creditcard.attribute2%TYPE,
637: p_attribute3 IN iby_creditcard.attribute3%TYPE,
638: p_attribute4 IN iby_creditcard.attribute4%TYPE,
639: p_attribute5 IN iby_creditcard.attribute5%TYPE,
640: p_attribute6 IN iby_creditcard.attribute6%TYPE,
641: p_attribute7 IN iby_creditcard.attribute7%TYPE,

Line 638: p_attribute4 IN iby_creditcard.attribute4%TYPE,

634: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
635: p_attribute1 IN iby_creditcard.attribute1%TYPE,
636: p_attribute2 IN iby_creditcard.attribute2%TYPE,
637: p_attribute3 IN iby_creditcard.attribute3%TYPE,
638: p_attribute4 IN iby_creditcard.attribute4%TYPE,
639: p_attribute5 IN iby_creditcard.attribute5%TYPE,
640: p_attribute6 IN iby_creditcard.attribute6%TYPE,
641: p_attribute7 IN iby_creditcard.attribute7%TYPE,
642: p_attribute8 IN iby_creditcard.attribute8%TYPE,

Line 639: p_attribute5 IN iby_creditcard.attribute5%TYPE,

635: p_attribute1 IN iby_creditcard.attribute1%TYPE,
636: p_attribute2 IN iby_creditcard.attribute2%TYPE,
637: p_attribute3 IN iby_creditcard.attribute3%TYPE,
638: p_attribute4 IN iby_creditcard.attribute4%TYPE,
639: p_attribute5 IN iby_creditcard.attribute5%TYPE,
640: p_attribute6 IN iby_creditcard.attribute6%TYPE,
641: p_attribute7 IN iby_creditcard.attribute7%TYPE,
642: p_attribute8 IN iby_creditcard.attribute8%TYPE,
643: p_attribute9 IN iby_creditcard.attribute9%TYPE,

Line 640: p_attribute6 IN iby_creditcard.attribute6%TYPE,

636: p_attribute2 IN iby_creditcard.attribute2%TYPE,
637: p_attribute3 IN iby_creditcard.attribute3%TYPE,
638: p_attribute4 IN iby_creditcard.attribute4%TYPE,
639: p_attribute5 IN iby_creditcard.attribute5%TYPE,
640: p_attribute6 IN iby_creditcard.attribute6%TYPE,
641: p_attribute7 IN iby_creditcard.attribute7%TYPE,
642: p_attribute8 IN iby_creditcard.attribute8%TYPE,
643: p_attribute9 IN iby_creditcard.attribute9%TYPE,
644: p_attribute10 IN iby_creditcard.attribute10%TYPE,

Line 641: p_attribute7 IN iby_creditcard.attribute7%TYPE,

637: p_attribute3 IN iby_creditcard.attribute3%TYPE,
638: p_attribute4 IN iby_creditcard.attribute4%TYPE,
639: p_attribute5 IN iby_creditcard.attribute5%TYPE,
640: p_attribute6 IN iby_creditcard.attribute6%TYPE,
641: p_attribute7 IN iby_creditcard.attribute7%TYPE,
642: p_attribute8 IN iby_creditcard.attribute8%TYPE,
643: p_attribute9 IN iby_creditcard.attribute9%TYPE,
644: p_attribute10 IN iby_creditcard.attribute10%TYPE,
645: p_attribute11 IN iby_creditcard.attribute11%TYPE,

Line 642: p_attribute8 IN iby_creditcard.attribute8%TYPE,

638: p_attribute4 IN iby_creditcard.attribute4%TYPE,
639: p_attribute5 IN iby_creditcard.attribute5%TYPE,
640: p_attribute6 IN iby_creditcard.attribute6%TYPE,
641: p_attribute7 IN iby_creditcard.attribute7%TYPE,
642: p_attribute8 IN iby_creditcard.attribute8%TYPE,
643: p_attribute9 IN iby_creditcard.attribute9%TYPE,
644: p_attribute10 IN iby_creditcard.attribute10%TYPE,
645: p_attribute11 IN iby_creditcard.attribute11%TYPE,
646: p_attribute12 IN iby_creditcard.attribute12%TYPE,

Line 643: p_attribute9 IN iby_creditcard.attribute9%TYPE,

639: p_attribute5 IN iby_creditcard.attribute5%TYPE,
640: p_attribute6 IN iby_creditcard.attribute6%TYPE,
641: p_attribute7 IN iby_creditcard.attribute7%TYPE,
642: p_attribute8 IN iby_creditcard.attribute8%TYPE,
643: p_attribute9 IN iby_creditcard.attribute9%TYPE,
644: p_attribute10 IN iby_creditcard.attribute10%TYPE,
645: p_attribute11 IN iby_creditcard.attribute11%TYPE,
646: p_attribute12 IN iby_creditcard.attribute12%TYPE,
647: p_attribute13 IN iby_creditcard.attribute13%TYPE,

Line 644: p_attribute10 IN iby_creditcard.attribute10%TYPE,

640: p_attribute6 IN iby_creditcard.attribute6%TYPE,
641: p_attribute7 IN iby_creditcard.attribute7%TYPE,
642: p_attribute8 IN iby_creditcard.attribute8%TYPE,
643: p_attribute9 IN iby_creditcard.attribute9%TYPE,
644: p_attribute10 IN iby_creditcard.attribute10%TYPE,
645: p_attribute11 IN iby_creditcard.attribute11%TYPE,
646: p_attribute12 IN iby_creditcard.attribute12%TYPE,
647: p_attribute13 IN iby_creditcard.attribute13%TYPE,
648: p_attribute14 IN iby_creditcard.attribute14%TYPE,

Line 645: p_attribute11 IN iby_creditcard.attribute11%TYPE,

641: p_attribute7 IN iby_creditcard.attribute7%TYPE,
642: p_attribute8 IN iby_creditcard.attribute8%TYPE,
643: p_attribute9 IN iby_creditcard.attribute9%TYPE,
644: p_attribute10 IN iby_creditcard.attribute10%TYPE,
645: p_attribute11 IN iby_creditcard.attribute11%TYPE,
646: p_attribute12 IN iby_creditcard.attribute12%TYPE,
647: p_attribute13 IN iby_creditcard.attribute13%TYPE,
648: p_attribute14 IN iby_creditcard.attribute14%TYPE,
649: p_attribute15 IN iby_creditcard.attribute15%TYPE,

Line 646: p_attribute12 IN iby_creditcard.attribute12%TYPE,

642: p_attribute8 IN iby_creditcard.attribute8%TYPE,
643: p_attribute9 IN iby_creditcard.attribute9%TYPE,
644: p_attribute10 IN iby_creditcard.attribute10%TYPE,
645: p_attribute11 IN iby_creditcard.attribute11%TYPE,
646: p_attribute12 IN iby_creditcard.attribute12%TYPE,
647: p_attribute13 IN iby_creditcard.attribute13%TYPE,
648: p_attribute14 IN iby_creditcard.attribute14%TYPE,
649: p_attribute15 IN iby_creditcard.attribute15%TYPE,
650: p_attribute16 IN iby_creditcard.attribute16%TYPE,

Line 647: p_attribute13 IN iby_creditcard.attribute13%TYPE,

643: p_attribute9 IN iby_creditcard.attribute9%TYPE,
644: p_attribute10 IN iby_creditcard.attribute10%TYPE,
645: p_attribute11 IN iby_creditcard.attribute11%TYPE,
646: p_attribute12 IN iby_creditcard.attribute12%TYPE,
647: p_attribute13 IN iby_creditcard.attribute13%TYPE,
648: p_attribute14 IN iby_creditcard.attribute14%TYPE,
649: p_attribute15 IN iby_creditcard.attribute15%TYPE,
650: p_attribute16 IN iby_creditcard.attribute16%TYPE,
651: p_attribute17 IN iby_creditcard.attribute17%TYPE,

Line 648: p_attribute14 IN iby_creditcard.attribute14%TYPE,

644: p_attribute10 IN iby_creditcard.attribute10%TYPE,
645: p_attribute11 IN iby_creditcard.attribute11%TYPE,
646: p_attribute12 IN iby_creditcard.attribute12%TYPE,
647: p_attribute13 IN iby_creditcard.attribute13%TYPE,
648: p_attribute14 IN iby_creditcard.attribute14%TYPE,
649: p_attribute15 IN iby_creditcard.attribute15%TYPE,
650: p_attribute16 IN iby_creditcard.attribute16%TYPE,
651: p_attribute17 IN iby_creditcard.attribute17%TYPE,
652: p_attribute18 IN iby_creditcard.attribute18%TYPE,

Line 649: p_attribute15 IN iby_creditcard.attribute15%TYPE,

645: p_attribute11 IN iby_creditcard.attribute11%TYPE,
646: p_attribute12 IN iby_creditcard.attribute12%TYPE,
647: p_attribute13 IN iby_creditcard.attribute13%TYPE,
648: p_attribute14 IN iby_creditcard.attribute14%TYPE,
649: p_attribute15 IN iby_creditcard.attribute15%TYPE,
650: p_attribute16 IN iby_creditcard.attribute16%TYPE,
651: p_attribute17 IN iby_creditcard.attribute17%TYPE,
652: p_attribute18 IN iby_creditcard.attribute18%TYPE,
653: p_attribute19 IN iby_creditcard.attribute19%TYPE,

Line 650: p_attribute16 IN iby_creditcard.attribute16%TYPE,

646: p_attribute12 IN iby_creditcard.attribute12%TYPE,
647: p_attribute13 IN iby_creditcard.attribute13%TYPE,
648: p_attribute14 IN iby_creditcard.attribute14%TYPE,
649: p_attribute15 IN iby_creditcard.attribute15%TYPE,
650: p_attribute16 IN iby_creditcard.attribute16%TYPE,
651: p_attribute17 IN iby_creditcard.attribute17%TYPE,
652: p_attribute18 IN iby_creditcard.attribute18%TYPE,
653: p_attribute19 IN iby_creditcard.attribute19%TYPE,
654: p_attribute20 IN iby_creditcard.attribute20%TYPE,

Line 651: p_attribute17 IN iby_creditcard.attribute17%TYPE,

647: p_attribute13 IN iby_creditcard.attribute13%TYPE,
648: p_attribute14 IN iby_creditcard.attribute14%TYPE,
649: p_attribute15 IN iby_creditcard.attribute15%TYPE,
650: p_attribute16 IN iby_creditcard.attribute16%TYPE,
651: p_attribute17 IN iby_creditcard.attribute17%TYPE,
652: p_attribute18 IN iby_creditcard.attribute18%TYPE,
653: p_attribute19 IN iby_creditcard.attribute19%TYPE,
654: p_attribute20 IN iby_creditcard.attribute20%TYPE,
655: p_attribute21 IN iby_creditcard.attribute21%TYPE,

Line 652: p_attribute18 IN iby_creditcard.attribute18%TYPE,

648: p_attribute14 IN iby_creditcard.attribute14%TYPE,
649: p_attribute15 IN iby_creditcard.attribute15%TYPE,
650: p_attribute16 IN iby_creditcard.attribute16%TYPE,
651: p_attribute17 IN iby_creditcard.attribute17%TYPE,
652: p_attribute18 IN iby_creditcard.attribute18%TYPE,
653: p_attribute19 IN iby_creditcard.attribute19%TYPE,
654: p_attribute20 IN iby_creditcard.attribute20%TYPE,
655: p_attribute21 IN iby_creditcard.attribute21%TYPE,
656: p_attribute22 IN iby_creditcard.attribute22%TYPE,

Line 653: p_attribute19 IN iby_creditcard.attribute19%TYPE,

649: p_attribute15 IN iby_creditcard.attribute15%TYPE,
650: p_attribute16 IN iby_creditcard.attribute16%TYPE,
651: p_attribute17 IN iby_creditcard.attribute17%TYPE,
652: p_attribute18 IN iby_creditcard.attribute18%TYPE,
653: p_attribute19 IN iby_creditcard.attribute19%TYPE,
654: p_attribute20 IN iby_creditcard.attribute20%TYPE,
655: p_attribute21 IN iby_creditcard.attribute21%TYPE,
656: p_attribute22 IN iby_creditcard.attribute22%TYPE,
657: p_attribute23 IN iby_creditcard.attribute23%TYPE,

Line 654: p_attribute20 IN iby_creditcard.attribute20%TYPE,

650: p_attribute16 IN iby_creditcard.attribute16%TYPE,
651: p_attribute17 IN iby_creditcard.attribute17%TYPE,
652: p_attribute18 IN iby_creditcard.attribute18%TYPE,
653: p_attribute19 IN iby_creditcard.attribute19%TYPE,
654: p_attribute20 IN iby_creditcard.attribute20%TYPE,
655: p_attribute21 IN iby_creditcard.attribute21%TYPE,
656: p_attribute22 IN iby_creditcard.attribute22%TYPE,
657: p_attribute23 IN iby_creditcard.attribute23%TYPE,
658: p_attribute24 IN iby_creditcard.attribute24%TYPE,

Line 655: p_attribute21 IN iby_creditcard.attribute21%TYPE,

651: p_attribute17 IN iby_creditcard.attribute17%TYPE,
652: p_attribute18 IN iby_creditcard.attribute18%TYPE,
653: p_attribute19 IN iby_creditcard.attribute19%TYPE,
654: p_attribute20 IN iby_creditcard.attribute20%TYPE,
655: p_attribute21 IN iby_creditcard.attribute21%TYPE,
656: p_attribute22 IN iby_creditcard.attribute22%TYPE,
657: p_attribute23 IN iby_creditcard.attribute23%TYPE,
658: p_attribute24 IN iby_creditcard.attribute24%TYPE,
659: p_attribute25 IN iby_creditcard.attribute25%TYPE,

Line 656: p_attribute22 IN iby_creditcard.attribute22%TYPE,

652: p_attribute18 IN iby_creditcard.attribute18%TYPE,
653: p_attribute19 IN iby_creditcard.attribute19%TYPE,
654: p_attribute20 IN iby_creditcard.attribute20%TYPE,
655: p_attribute21 IN iby_creditcard.attribute21%TYPE,
656: p_attribute22 IN iby_creditcard.attribute22%TYPE,
657: p_attribute23 IN iby_creditcard.attribute23%TYPE,
658: p_attribute24 IN iby_creditcard.attribute24%TYPE,
659: p_attribute25 IN iby_creditcard.attribute25%TYPE,
660: p_attribute26 IN iby_creditcard.attribute26%TYPE,

Line 657: p_attribute23 IN iby_creditcard.attribute23%TYPE,

653: p_attribute19 IN iby_creditcard.attribute19%TYPE,
654: p_attribute20 IN iby_creditcard.attribute20%TYPE,
655: p_attribute21 IN iby_creditcard.attribute21%TYPE,
656: p_attribute22 IN iby_creditcard.attribute22%TYPE,
657: p_attribute23 IN iby_creditcard.attribute23%TYPE,
658: p_attribute24 IN iby_creditcard.attribute24%TYPE,
659: p_attribute25 IN iby_creditcard.attribute25%TYPE,
660: p_attribute26 IN iby_creditcard.attribute26%TYPE,
661: p_attribute27 IN iby_creditcard.attribute27%TYPE,

Line 658: p_attribute24 IN iby_creditcard.attribute24%TYPE,

654: p_attribute20 IN iby_creditcard.attribute20%TYPE,
655: p_attribute21 IN iby_creditcard.attribute21%TYPE,
656: p_attribute22 IN iby_creditcard.attribute22%TYPE,
657: p_attribute23 IN iby_creditcard.attribute23%TYPE,
658: p_attribute24 IN iby_creditcard.attribute24%TYPE,
659: p_attribute25 IN iby_creditcard.attribute25%TYPE,
660: p_attribute26 IN iby_creditcard.attribute26%TYPE,
661: p_attribute27 IN iby_creditcard.attribute27%TYPE,
662: p_attribute28 IN iby_creditcard.attribute28%TYPE,

Line 659: p_attribute25 IN iby_creditcard.attribute25%TYPE,

655: p_attribute21 IN iby_creditcard.attribute21%TYPE,
656: p_attribute22 IN iby_creditcard.attribute22%TYPE,
657: p_attribute23 IN iby_creditcard.attribute23%TYPE,
658: p_attribute24 IN iby_creditcard.attribute24%TYPE,
659: p_attribute25 IN iby_creditcard.attribute25%TYPE,
660: p_attribute26 IN iby_creditcard.attribute26%TYPE,
661: p_attribute27 IN iby_creditcard.attribute27%TYPE,
662: p_attribute28 IN iby_creditcard.attribute28%TYPE,
663: p_attribute29 IN iby_creditcard.attribute29%TYPE,

Line 660: p_attribute26 IN iby_creditcard.attribute26%TYPE,

656: p_attribute22 IN iby_creditcard.attribute22%TYPE,
657: p_attribute23 IN iby_creditcard.attribute23%TYPE,
658: p_attribute24 IN iby_creditcard.attribute24%TYPE,
659: p_attribute25 IN iby_creditcard.attribute25%TYPE,
660: p_attribute26 IN iby_creditcard.attribute26%TYPE,
661: p_attribute27 IN iby_creditcard.attribute27%TYPE,
662: p_attribute28 IN iby_creditcard.attribute28%TYPE,
663: p_attribute29 IN iby_creditcard.attribute29%TYPE,
664: p_attribute30 IN iby_creditcard.attribute30%TYPE,

Line 661: p_attribute27 IN iby_creditcard.attribute27%TYPE,

657: p_attribute23 IN iby_creditcard.attribute23%TYPE,
658: p_attribute24 IN iby_creditcard.attribute24%TYPE,
659: p_attribute25 IN iby_creditcard.attribute25%TYPE,
660: p_attribute26 IN iby_creditcard.attribute26%TYPE,
661: p_attribute27 IN iby_creditcard.attribute27%TYPE,
662: p_attribute28 IN iby_creditcard.attribute28%TYPE,
663: p_attribute29 IN iby_creditcard.attribute29%TYPE,
664: p_attribute30 IN iby_creditcard.attribute30%TYPE,
665: x_result_code OUT NOCOPY VARCHAR2

Line 662: p_attribute28 IN iby_creditcard.attribute28%TYPE,

658: p_attribute24 IN iby_creditcard.attribute24%TYPE,
659: p_attribute25 IN iby_creditcard.attribute25%TYPE,
660: p_attribute26 IN iby_creditcard.attribute26%TYPE,
661: p_attribute27 IN iby_creditcard.attribute27%TYPE,
662: p_attribute28 IN iby_creditcard.attribute28%TYPE,
663: p_attribute29 IN iby_creditcard.attribute29%TYPE,
664: p_attribute30 IN iby_creditcard.attribute30%TYPE,
665: x_result_code OUT NOCOPY VARCHAR2
666: )

Line 663: p_attribute29 IN iby_creditcard.attribute29%TYPE,

659: p_attribute25 IN iby_creditcard.attribute25%TYPE,
660: p_attribute26 IN iby_creditcard.attribute26%TYPE,
661: p_attribute27 IN iby_creditcard.attribute27%TYPE,
662: p_attribute28 IN iby_creditcard.attribute28%TYPE,
663: p_attribute29 IN iby_creditcard.attribute29%TYPE,
664: p_attribute30 IN iby_creditcard.attribute30%TYPE,
665: x_result_code OUT NOCOPY VARCHAR2
666: )
667: IS

Line 664: p_attribute30 IN iby_creditcard.attribute30%TYPE,

660: p_attribute26 IN iby_creditcard.attribute26%TYPE,
661: p_attribute27 IN iby_creditcard.attribute27%TYPE,
662: p_attribute28 IN iby_creditcard.attribute28%TYPE,
663: p_attribute29 IN iby_creditcard.attribute29%TYPE,
664: p_attribute30 IN iby_creditcard.attribute30%TYPE,
665: x_result_code OUT NOCOPY VARCHAR2
666: )
667: IS
668: l_history_id iby_creditcard_h.card_history_change_id%TYPE;

Line 668: l_history_id iby_creditcard_h.card_history_change_id%TYPE;

664: p_attribute30 IN iby_creditcard.attribute30%TYPE,
665: x_result_code OUT NOCOPY VARCHAR2
666: )
667: IS
668: l_history_id iby_creditcard_h.card_history_change_id%TYPE;
669: l_billing_site NUMBER;
670: l_expiry_date iby_creditcard.expirydate%TYPE;
671:
672: -- variabled for CHNAME and EXPDATE encryption

Line 670: l_expiry_date iby_creditcard.expirydate%TYPE;

666: )
667: IS
668: l_history_id iby_creditcard_h.card_history_change_id%TYPE;
669: l_billing_site NUMBER;
670: l_expiry_date iby_creditcard.expirydate%TYPE;
671:
672: -- variabled for CHNAME and EXPDATE encryption
673: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
674: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

Line 751: SELECT encrypted INTO l_encrypted FROM iby_creditcard

747: END IF;
748: END IF;
749:
750: -- Get the encrypted flag value of the existing record
751: SELECT encrypted INTO l_encrypted FROM iby_creditcard
752: WHERE instrid = p_instr_id;
753:
754: -- Need to encrypt the sensitive data only if the record was
755: -- previously encrypted and of course the encryption mode

Line 797: UPDATE iby_creditcard

793:
794: Archive_Card(FND_API.G_FALSE,p_instr_id,l_history_id);
795:
796:
797: UPDATE iby_creditcard
798: SET chname = DECODE(p_holder_name, FND_API.G_MISS_CHAR,NULL, NULL,chname, l_masked_chname),
799: chname_sec_segment_id = l_chname_sec_segment_id,
800: card_owner_id = NVL(card_owner_id,p_owner_id),
801: addressid = DECODE(l_billing_site, FND_API.G_MISS_NUM,NULL,

Line 872: (p_instrid IN iby_creditcard.instrid%TYPE,

868: END IF;
869: END Update_Card;
870:
871: FUNCTION uncipher_ccnumber
872: (p_instrid IN iby_creditcard.instrid%TYPE,
873: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
874: )
875: RETURN iby_creditcard.ccnumber%TYPE
876: IS

Line 875: RETURN iby_creditcard.ccnumber%TYPE

871: FUNCTION uncipher_ccnumber
872: (p_instrid IN iby_creditcard.instrid%TYPE,
873: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
874: )
875: RETURN iby_creditcard.ccnumber%TYPE
876: IS
877: l_cc_number iby_creditcard.ccnumber%TYPE;
878: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
879: l_card_len iby_creditcard.cc_number_length%TYPE;

Line 877: l_cc_number iby_creditcard.ccnumber%TYPE;

873: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
874: )
875: RETURN iby_creditcard.ccnumber%TYPE
876: IS
877: l_cc_number iby_creditcard.ccnumber%TYPE;
878: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
879: l_card_len iby_creditcard.cc_number_length%TYPE;
880: l_encrypted iby_creditcard.encrypted%TYPE;
881: l_cc_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;

Line 879: l_card_len iby_creditcard.cc_number_length%TYPE;

875: RETURN iby_creditcard.ccnumber%TYPE
876: IS
877: l_cc_number iby_creditcard.ccnumber%TYPE;
878: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
879: l_card_len iby_creditcard.cc_number_length%TYPE;
880: l_encrypted iby_creditcard.encrypted%TYPE;
881: l_cc_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
882: l_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
883: l_mask_option iby_creditcard.card_mask_setting%TYPE;

Line 880: l_encrypted iby_creditcard.encrypted%TYPE;

876: IS
877: l_cc_number iby_creditcard.ccnumber%TYPE;
878: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
879: l_card_len iby_creditcard.cc_number_length%TYPE;
880: l_encrypted iby_creditcard.encrypted%TYPE;
881: l_cc_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
882: l_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
883: l_mask_option iby_creditcard.card_mask_setting%TYPE;
884: l_unmask_len iby_creditcard.card_unmask_length%TYPE;

Line 882: l_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;

878: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
879: l_card_len iby_creditcard.cc_number_length%TYPE;
880: l_encrypted iby_creditcard.encrypted%TYPE;
881: l_cc_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
882: l_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
883: l_mask_option iby_creditcard.card_mask_setting%TYPE;
884: l_unmask_len iby_creditcard.card_unmask_length%TYPE;
885: l_unmask_digits iby_creditcard.ccnumber%TYPE;
886:

Line 883: l_mask_option iby_creditcard.card_mask_setting%TYPE;

879: l_card_len iby_creditcard.cc_number_length%TYPE;
880: l_encrypted iby_creditcard.encrypted%TYPE;
881: l_cc_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
882: l_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
883: l_mask_option iby_creditcard.card_mask_setting%TYPE;
884: l_unmask_len iby_creditcard.card_unmask_length%TYPE;
885: l_unmask_digits iby_creditcard.ccnumber%TYPE;
886:
887: l_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;

Line 884: l_unmask_len iby_creditcard.card_unmask_length%TYPE;

880: l_encrypted iby_creditcard.encrypted%TYPE;
881: l_cc_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
882: l_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
883: l_mask_option iby_creditcard.card_mask_setting%TYPE;
884: l_unmask_len iby_creditcard.card_unmask_length%TYPE;
885: l_unmask_digits iby_creditcard.ccnumber%TYPE;
886:
887: l_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
888: l_keyvalid VARCHAR2(100) := NULL;

Line 885: l_unmask_digits iby_creditcard.ccnumber%TYPE;

881: l_cc_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
882: l_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
883: l_mask_option iby_creditcard.card_mask_setting%TYPE;
884: l_unmask_len iby_creditcard.card_unmask_length%TYPE;
885: l_unmask_digits iby_creditcard.ccnumber%TYPE;
886:
887: l_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
888: l_keyvalid VARCHAR2(100) := NULL;
889:

Line 890: CURSOR c_instr_num(ci_instrid iby_creditcard.instrid%TYPE)

886:
887: l_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
888: l_keyvalid VARCHAR2(100) := NULL;
889:
890: CURSOR c_instr_num(ci_instrid iby_creditcard.instrid%TYPE)
891: IS
892: SELECT
893: c.ccnumber, seg.segment_cipher_text,
894: NVL(c.encrypted,'N'), k.subkey_cipher_text, r.card_number_prefix,

Line 898: FROM iby_creditcard c, iby_security_segments seg,

894: NVL(c.encrypted,'N'), k.subkey_cipher_text, r.card_number_prefix,
895: NVL(i.digit_check_flag,'N'), c.card_mask_setting, c.card_unmask_length,
896: DECODE(encrypted, 'Y',c.ccnumber, NULL),
897: NVL(r.card_number_length,c.cc_number_length)
898: FROM iby_creditcard c, iby_security_segments seg,
899: iby_sys_security_subkeys k, iby_cc_issuer_ranges r,
900: iby_creditcard_issuers_b i
901: WHERE (instrid = ci_instrid)
902: AND (c.cc_num_sec_segment_id = seg.sec_segment_id(+))

Line 900: iby_creditcard_issuers_b i

896: DECODE(encrypted, 'Y',c.ccnumber, NULL),
897: NVL(r.card_number_length,c.cc_number_length)
898: FROM iby_creditcard c, iby_security_segments seg,
899: iby_sys_security_subkeys k, iby_cc_issuer_ranges r,
900: iby_creditcard_issuers_b i
901: WHERE (instrid = ci_instrid)
902: AND (c.cc_num_sec_segment_id = seg.sec_segment_id(+))
903: AND (seg.sec_subkey_id = k.sec_subkey_id(+))
904: AND (c.cc_issuer_range_id = r.cc_issuer_range_id(+))

Line 935: (p_cc_number IN iby_creditcard.ccnumber%TYPE,

931: l_unmask_len, l_unmask_digits);
932: END uncipher_ccnumber;
933:
934: FUNCTION uncipher_ccnumber
935: (p_cc_number IN iby_creditcard.ccnumber%TYPE,
936: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
937: p_encrypted IN iby_creditcard.encrypted%TYPE,
938: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
939: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,

Line 937: p_encrypted IN iby_creditcard.encrypted%TYPE,

933:
934: FUNCTION uncipher_ccnumber
935: (p_cc_number IN iby_creditcard.ccnumber%TYPE,
936: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
937: p_encrypted IN iby_creditcard.encrypted%TYPE,
938: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
939: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
940: p_card_len IN iby_cc_issuer_ranges.card_number_length%TYPE,
941: p_cc_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,

Line 942: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,

938: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
939: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
940: p_card_len IN iby_cc_issuer_ranges.card_number_length%TYPE,
941: p_cc_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
942: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
943: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
944: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
945: p_unmask_digits IN iby_creditcard.masked_cc_number%TYPE
946: )

Line 945: p_unmask_digits IN iby_creditcard.masked_cc_number%TYPE

941: p_cc_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
942: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
943: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
944: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
945: p_unmask_digits IN iby_creditcard.masked_cc_number%TYPE
946: )
947: RETURN iby_creditcard.ccnumber%TYPE
948: IS
949: l_sub_key iby_security_pkg.DES3_KEY_TYPE;

Line 947: RETURN iby_creditcard.ccnumber%TYPE

943: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
944: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
945: p_unmask_digits IN iby_creditcard.masked_cc_number%TYPE
946: )
947: RETURN iby_creditcard.ccnumber%TYPE
948: IS
949: l_sub_key iby_security_pkg.DES3_KEY_TYPE;
950: l_segment_raw iby_security_segments.segment_cipher_text%TYPE;
951: l_cc_number iby_creditcard.ccnumber%TYPE;

Line 951: l_cc_number iby_creditcard.ccnumber%TYPE;

947: RETURN iby_creditcard.ccnumber%TYPE
948: IS
949: l_sub_key iby_security_pkg.DES3_KEY_TYPE;
950: l_segment_raw iby_security_segments.segment_cipher_text%TYPE;
951: l_cc_number iby_creditcard.ccnumber%TYPE;
952: l_compress_len NUMBER;
953: BEGIN
954: l_cc_number := '';
955: l_compress_len := Get_Compressed_Len

Line 985: (i_instrid IN iby_creditcard.instrid%TYPE,

981: END IF;
982: END uncipher_ccnumber;
983:
984: FUNCTION uncipher_ccnumber_ui_wrp
985: (i_instrid IN iby_creditcard.instrid%TYPE,
986: i_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE)
987: RETURN iby_creditcard.ccnumber%TYPE
988: IS
989: BEGIN

Line 987: RETURN iby_creditcard.ccnumber%TYPE

983:
984: FUNCTION uncipher_ccnumber_ui_wrp
985: (i_instrid IN iby_creditcard.instrid%TYPE,
986: i_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE)
987: RETURN iby_creditcard.ccnumber%TYPE
988: IS
989: BEGIN
990: RETURN uncipher_ccnumber(i_instrid, i_sys_sec_key);
991: EXCEPTION

Line 1001: l_cc_number iby_creditcard.ccnumber%TYPE;

997: (p_commit IN VARCHAR2,
998: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
999: )
1000: IS
1001: l_cc_number iby_creditcard.ccnumber%TYPE;
1002:
1003: -- variabled for CHNAME and EXPDATE decryption
1004: l_chname VARCHAR2(80);
1005: l_str_exp_date VARCHAR2(20);

Line 1018: FROM iby_creditcard c, iby_creditcard_issuers_b i,

1014: r.card_number_prefix, i.digit_check_flag, c.card_mask_setting,
1015: c.card_unmask_length, c.ccnumber unmask_digits, c.cc_num_sec_segment_id,
1016: c.chname, c.chname_sec_segment_id,
1017: c.expirydate, c.expiry_sec_segment_id
1018: FROM iby_creditcard c, iby_creditcard_issuers_b i,
1019: iby_cc_issuer_ranges r, iby_sys_security_subkeys k,
1020: iby_security_segments seg
1021: WHERE (NVL(c.encrypted,'N') = 'Y')
1022: AND (c.card_issuer_code = i.card_issuer_code(+))

Line 1060: UPDATE iby_creditcard

1056: l_chname := c_card_rec.chname;
1057: END IF;
1058:
1059:
1060: UPDATE iby_creditcard
1061: SET
1062: ccnumber = l_cc_number,
1063: encrypted = 'N',
1064: cc_num_sec_segment_id = NULL,

Line 1093: lx_compress_cc iby_creditcard.ccnumber%TYPE;

1089: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
1090: )
1091: IS
1092: l_mode iby_sys_security_options.cc_encryption_mode%TYPE;
1093: lx_compress_cc iby_creditcard.ccnumber%TYPE;
1094: lx_mask_digits iby_creditcard.masked_cc_number%TYPE;
1095:
1096: l_subkey iby_security_pkg.DES3_KEY_TYPE;
1097: l_segment_id iby_security_segments.sec_segment_id%TYPE;

Line 1094: lx_mask_digits iby_creditcard.masked_cc_number%TYPE;

1090: )
1091: IS
1092: l_mode iby_sys_security_options.cc_encryption_mode%TYPE;
1093: lx_compress_cc iby_creditcard.ccnumber%TYPE;
1094: lx_mask_digits iby_creditcard.masked_cc_number%TYPE;
1095:
1096: l_subkey iby_security_pkg.DES3_KEY_TYPE;
1097: l_segment_id iby_security_segments.sec_segment_id%TYPE;
1098: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;

Line 1112: FROM iby_creditcard c, iby_creditcard_issuers_b i,

1108: IS
1109: SELECT c.instrid, c.ccnumber, c.cc_issuer_range_id,
1110: k.subkey_cipher_text, r.card_number_prefix, i.digit_check_flag,
1111: c.card_mask_setting, c.card_unmask_length, c.chname, c.expirydate
1112: FROM iby_creditcard c, iby_creditcard_issuers_b i,
1113: iby_cc_issuer_ranges r, iby_security_segments seg,
1114: iby_sys_security_subkeys k
1115: WHERE (NVL(c.encrypted,'N') = 'N')
1116: AND (c.card_issuer_code = i.card_issuer_code(+))

Line 1176: UPDATE iby_creditcard

1172: l_exp_date := c_card_rec.expirydate;
1173: END IF;
1174:
1175:
1176: UPDATE iby_creditcard
1177: SET
1178: ccnumber = NVL(lx_mask_digits,0),
1179: cc_num_sec_segment_id = l_segment_id,
1180: encrypted = 'Y',

Line 1204: l_cc_number iby_creditcard.ccnumber%TYPE;

1200: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
1201: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
1202: )
1203: IS
1204: l_cc_number iby_creditcard.ccnumber%TYPE;
1205: lx_compress_cc iby_creditcard.ccnumber%TYPE;
1206: lx_mask_digits iby_creditcard.ccnumber%TYPE;
1207: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
1208: lx_unmask_len iby_creditcard.card_unmask_length%TYPE;

Line 1205: lx_compress_cc iby_creditcard.ccnumber%TYPE;

1201: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
1202: )
1203: IS
1204: l_cc_number iby_creditcard.ccnumber%TYPE;
1205: lx_compress_cc iby_creditcard.ccnumber%TYPE;
1206: lx_mask_digits iby_creditcard.ccnumber%TYPE;
1207: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
1208: lx_unmask_len iby_creditcard.card_unmask_length%TYPE;
1209: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;

Line 1206: lx_mask_digits iby_creditcard.ccnumber%TYPE;

1202: )
1203: IS
1204: l_cc_number iby_creditcard.ccnumber%TYPE;
1205: lx_compress_cc iby_creditcard.ccnumber%TYPE;
1206: lx_mask_digits iby_creditcard.ccnumber%TYPE;
1207: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
1208: lx_unmask_len iby_creditcard.card_unmask_length%TYPE;
1209: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
1210: lx_segment_id iby_security_segments.sec_segment_id%TYPE;

Line 1207: lx_mask_option iby_creditcard.card_mask_setting%TYPE;

1203: IS
1204: l_cc_number iby_creditcard.ccnumber%TYPE;
1205: lx_compress_cc iby_creditcard.ccnumber%TYPE;
1206: lx_mask_digits iby_creditcard.ccnumber%TYPE;
1207: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
1208: lx_unmask_len iby_creditcard.card_unmask_length%TYPE;
1209: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
1210: lx_segment_id iby_security_segments.sec_segment_id%TYPE;
1211:

Line 1208: lx_unmask_len iby_creditcard.card_unmask_length%TYPE;

1204: l_cc_number iby_creditcard.ccnumber%TYPE;
1205: lx_compress_cc iby_creditcard.ccnumber%TYPE;
1206: lx_mask_digits iby_creditcard.ccnumber%TYPE;
1207: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
1208: lx_unmask_len iby_creditcard.card_unmask_length%TYPE;
1209: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
1210: lx_segment_id iby_security_segments.sec_segment_id%TYPE;
1211:
1212: CURSOR c_card

Line 1213: (ci_mask_option iby_creditcard.card_mask_setting%TYPE,

1209: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
1210: lx_segment_id iby_security_segments.sec_segment_id%TYPE;
1211:
1212: CURSOR c_card
1213: (ci_mask_option iby_creditcard.card_mask_setting%TYPE,
1214: ci_unmask_len iby_creditcard.card_unmask_length%TYPE
1215: )
1216: IS
1217: SELECT c.instrid, c.ccnumber, seg.segment_cipher_text,

Line 1214: ci_unmask_len iby_creditcard.card_unmask_length%TYPE

1210: lx_segment_id iby_security_segments.sec_segment_id%TYPE;
1211:
1212: CURSOR c_card
1213: (ci_mask_option iby_creditcard.card_mask_setting%TYPE,
1214: ci_unmask_len iby_creditcard.card_unmask_length%TYPE
1215: )
1216: IS
1217: SELECT c.instrid, c.ccnumber, seg.segment_cipher_text,
1218: c.encrypted, k.subkey_cipher_text,

Line 1223: FROM iby_creditcard c, iby_creditcard_issuers_b i,

1219: NVL(r.card_number_length,c.cc_number_length) card_len,
1220: r.card_number_prefix, i.digit_check_flag, c.card_mask_setting,
1221: c.card_unmask_length, c.ccnumber unmask_digits, seg.sec_segment_id,
1222: LENGTH(c.ccnumber) len
1223: FROM iby_creditcard c, iby_creditcard_issuers_b i,
1224: iby_cc_issuer_ranges r, iby_sys_security_subkeys k,
1225: iby_security_segments seg
1226: WHERE (c.card_issuer_code = i.card_issuer_code(+))
1227: AND (c.cc_issuer_range_id = r.cc_issuer_range_id(+))

Line 1284: UPDATE iby_creditcard

1280: DELETE iby_security_segments WHERE (sec_segment_id = lx_segment_id);
1281: END IF;
1282: END IF;
1283:
1284: UPDATE iby_creditcard
1285: SET
1286: ccnumber = DECODE(encrypted, 'Y',NVL(lx_mask_digits,'0'), ccnumber),
1287: masked_cc_number =
1288: Mask_Card_Number(l_cc_number,lx_mask_option,lx_unmask_len),

Line 1305: (p_card_number IN iby_creditcard.ccnumber%TYPE,

1301: END IF;
1302: END Remask_Instruments;
1303:
1304: PROCEDURE Compress_CC_Number
1305: (p_card_number IN iby_creditcard.ccnumber%TYPE,
1306: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1307: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1308: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1309: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,

Line 1307: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,

1303:
1304: PROCEDURE Compress_CC_Number
1305: (p_card_number IN iby_creditcard.ccnumber%TYPE,
1306: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1307: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1308: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1309: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
1310: x_compress_num OUT NOCOPY iby_creditcard.ccnumber%TYPE,
1311: x_unmask_digits OUT NOCOPY iby_creditcard.masked_cc_number%TYPE

Line 1310: x_compress_num OUT NOCOPY iby_creditcard.ccnumber%TYPE,

1306: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1307: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1308: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1309: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
1310: x_compress_num OUT NOCOPY iby_creditcard.ccnumber%TYPE,
1311: x_unmask_digits OUT NOCOPY iby_creditcard.masked_cc_number%TYPE
1312: )
1313: IS
1314: l_prefix_index NUMBER;

Line 1311: x_unmask_digits OUT NOCOPY iby_creditcard.masked_cc_number%TYPE

1307: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1308: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1309: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
1310: x_compress_num OUT NOCOPY iby_creditcard.ccnumber%TYPE,
1311: x_unmask_digits OUT NOCOPY iby_creditcard.masked_cc_number%TYPE
1312: )
1313: IS
1314: l_prefix_index NUMBER;
1315: l_unmask_len NUMBER;

Line 1359: (p_card_number IN iby_creditcard.ccnumber%TYPE,

1355: END IF;
1356: END Compress_CC_Number;
1357:
1358: FUNCTION Uncompress_CC_Number
1359: (p_card_number IN iby_creditcard.ccnumber%TYPE,
1360: p_card_length IN iby_creditcard.cc_number_length%TYPE,
1361: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1362: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1363: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,

Line 1360: p_card_length IN iby_creditcard.cc_number_length%TYPE,

1356: END Compress_CC_Number;
1357:
1358: FUNCTION Uncompress_CC_Number
1359: (p_card_number IN iby_creditcard.ccnumber%TYPE,
1360: p_card_length IN iby_creditcard.cc_number_length%TYPE,
1361: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1362: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1363: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1364: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,

Line 1362: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,

1358: FUNCTION Uncompress_CC_Number
1359: (p_card_number IN iby_creditcard.ccnumber%TYPE,
1360: p_card_length IN iby_creditcard.cc_number_length%TYPE,
1361: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1362: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1363: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1364: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
1365: p_unmask_digits IN iby_creditcard.masked_cc_number%TYPE
1366: )

Line 1365: p_unmask_digits IN iby_creditcard.masked_cc_number%TYPE

1361: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1362: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1363: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1364: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
1365: p_unmask_digits IN iby_creditcard.masked_cc_number%TYPE
1366: )
1367: RETURN iby_creditcard.ccnumber%TYPE
1368: IS
1369: l_cc_num iby_creditcard.ccnumber%TYPE;

Line 1367: RETURN iby_creditcard.ccnumber%TYPE

1363: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1364: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
1365: p_unmask_digits IN iby_creditcard.masked_cc_number%TYPE
1366: )
1367: RETURN iby_creditcard.ccnumber%TYPE
1368: IS
1369: l_cc_num iby_creditcard.ccnumber%TYPE;
1370: l_mod_sum NUMBER;
1371: l_unmask_digits_len NUMBER;

Line 1369: l_cc_num iby_creditcard.ccnumber%TYPE;

1365: p_unmask_digits IN iby_creditcard.masked_cc_number%TYPE
1366: )
1367: RETURN iby_creditcard.ccnumber%TYPE
1368: IS
1369: l_cc_num iby_creditcard.ccnumber%TYPE;
1370: l_mod_sum NUMBER;
1371: l_unmask_digits_len NUMBER;
1372: l_prefix_len NUMBER;
1373: l_prefix_use NUMBER;

Line 1425: (p_card_length IN iby_creditcard.cc_number_length%TYPE,

1421:
1422: END Uncompress_CC_Number;
1423:
1424: FUNCTION Get_Compressed_Len
1425: (p_card_length IN iby_creditcard.cc_number_length%TYPE,
1426: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1427: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1428: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1429: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE

Line 1427: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,

1423:
1424: FUNCTION Get_Compressed_Len
1425: (p_card_length IN iby_creditcard.cc_number_length%TYPE,
1426: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1427: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1428: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1429: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE
1430: )
1431: RETURN NUMBER

Line 1433: l_compress_len iby_creditcard.ccnumber%TYPE;

1429: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE
1430: )
1431: RETURN NUMBER
1432: IS
1433: l_compress_len iby_creditcard.ccnumber%TYPE;
1434: l_prefix_len NUMBER;
1435: BEGIN
1436: l_compress_len := p_card_length;
1437: l_prefix_len := NVL(LENGTH(p_prefix),0);

Line 1477: (p_card_id IN iby_creditcard.instrid%TYPE,

1473: RETURN l_compress_len;
1474: END Get_Compressed_Len;
1475:
1476: PROCEDURE Query_Card
1477: (p_card_id IN iby_creditcard.instrid%TYPE,
1478: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1479: x_owner_id OUT NOCOPY iby_creditcard.card_owner_id%TYPE,
1480: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,
1481: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,

Line 1479: x_owner_id OUT NOCOPY iby_creditcard.card_owner_id%TYPE,

1475:
1476: PROCEDURE Query_Card
1477: (p_card_id IN iby_creditcard.instrid%TYPE,
1478: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1479: x_owner_id OUT NOCOPY iby_creditcard.card_owner_id%TYPE,
1480: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,
1481: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
1482: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
1483: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,

Line 1480: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,

1476: PROCEDURE Query_Card
1477: (p_card_id IN iby_creditcard.instrid%TYPE,
1478: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1479: x_owner_id OUT NOCOPY iby_creditcard.card_owner_id%TYPE,
1480: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,
1481: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
1482: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
1483: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
1484: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,

Line 1481: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,

1477: (p_card_id IN iby_creditcard.instrid%TYPE,
1478: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1479: x_owner_id OUT NOCOPY iby_creditcard.card_owner_id%TYPE,
1480: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,
1481: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
1482: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
1483: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
1484: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
1485: x_billing_city OUT NOCOPY hz_locations.city%TYPE,

Line 1490: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,

1486: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
1487: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
1488: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
1489: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
1490: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,
1491: x_expiry_date OUT NOCOPY iby_creditcard.expirydate%TYPE,
1492: x_instr_type OUT NOCOPY iby_creditcard.instrument_type%TYPE,
1493: x_pcard_flag OUT NOCOPY iby_creditcard.purchasecard_flag%TYPE,
1494: x_pcard_type OUT NOCOPY iby_creditcard.purchasecard_subtype%TYPE,

Line 1491: x_expiry_date OUT NOCOPY iby_creditcard.expirydate%TYPE,

1487: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
1488: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
1489: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
1490: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,
1491: x_expiry_date OUT NOCOPY iby_creditcard.expirydate%TYPE,
1492: x_instr_type OUT NOCOPY iby_creditcard.instrument_type%TYPE,
1493: x_pcard_flag OUT NOCOPY iby_creditcard.purchasecard_flag%TYPE,
1494: x_pcard_type OUT NOCOPY iby_creditcard.purchasecard_subtype%TYPE,
1495: x_issuer OUT NOCOPY iby_creditcard.card_issuer_code%TYPE,

Line 1492: x_instr_type OUT NOCOPY iby_creditcard.instrument_type%TYPE,

1488: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
1489: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
1490: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,
1491: x_expiry_date OUT NOCOPY iby_creditcard.expirydate%TYPE,
1492: x_instr_type OUT NOCOPY iby_creditcard.instrument_type%TYPE,
1493: x_pcard_flag OUT NOCOPY iby_creditcard.purchasecard_flag%TYPE,
1494: x_pcard_type OUT NOCOPY iby_creditcard.purchasecard_subtype%TYPE,
1495: x_issuer OUT NOCOPY iby_creditcard.card_issuer_code%TYPE,
1496: x_fi_name OUT NOCOPY iby_creditcard.finame%TYPE,

Line 1493: x_pcard_flag OUT NOCOPY iby_creditcard.purchasecard_flag%TYPE,

1489: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
1490: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,
1491: x_expiry_date OUT NOCOPY iby_creditcard.expirydate%TYPE,
1492: x_instr_type OUT NOCOPY iby_creditcard.instrument_type%TYPE,
1493: x_pcard_flag OUT NOCOPY iby_creditcard.purchasecard_flag%TYPE,
1494: x_pcard_type OUT NOCOPY iby_creditcard.purchasecard_subtype%TYPE,
1495: x_issuer OUT NOCOPY iby_creditcard.card_issuer_code%TYPE,
1496: x_fi_name OUT NOCOPY iby_creditcard.finame%TYPE,
1497: x_single_use OUT NOCOPY iby_creditcard.single_use_flag%TYPE,

Line 1494: x_pcard_type OUT NOCOPY iby_creditcard.purchasecard_subtype%TYPE,

1490: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,
1491: x_expiry_date OUT NOCOPY iby_creditcard.expirydate%TYPE,
1492: x_instr_type OUT NOCOPY iby_creditcard.instrument_type%TYPE,
1493: x_pcard_flag OUT NOCOPY iby_creditcard.purchasecard_flag%TYPE,
1494: x_pcard_type OUT NOCOPY iby_creditcard.purchasecard_subtype%TYPE,
1495: x_issuer OUT NOCOPY iby_creditcard.card_issuer_code%TYPE,
1496: x_fi_name OUT NOCOPY iby_creditcard.finame%TYPE,
1497: x_single_use OUT NOCOPY iby_creditcard.single_use_flag%TYPE,
1498: x_info_only OUT NOCOPY iby_creditcard.information_only_flag%TYPE,

Line 1495: x_issuer OUT NOCOPY iby_creditcard.card_issuer_code%TYPE,

1491: x_expiry_date OUT NOCOPY iby_creditcard.expirydate%TYPE,
1492: x_instr_type OUT NOCOPY iby_creditcard.instrument_type%TYPE,
1493: x_pcard_flag OUT NOCOPY iby_creditcard.purchasecard_flag%TYPE,
1494: x_pcard_type OUT NOCOPY iby_creditcard.purchasecard_subtype%TYPE,
1495: x_issuer OUT NOCOPY iby_creditcard.card_issuer_code%TYPE,
1496: x_fi_name OUT NOCOPY iby_creditcard.finame%TYPE,
1497: x_single_use OUT NOCOPY iby_creditcard.single_use_flag%TYPE,
1498: x_info_only OUT NOCOPY iby_creditcard.information_only_flag%TYPE,
1499: x_purpose OUT NOCOPY iby_creditcard.card_purpose%TYPE,

Line 1496: x_fi_name OUT NOCOPY iby_creditcard.finame%TYPE,

1492: x_instr_type OUT NOCOPY iby_creditcard.instrument_type%TYPE,
1493: x_pcard_flag OUT NOCOPY iby_creditcard.purchasecard_flag%TYPE,
1494: x_pcard_type OUT NOCOPY iby_creditcard.purchasecard_subtype%TYPE,
1495: x_issuer OUT NOCOPY iby_creditcard.card_issuer_code%TYPE,
1496: x_fi_name OUT NOCOPY iby_creditcard.finame%TYPE,
1497: x_single_use OUT NOCOPY iby_creditcard.single_use_flag%TYPE,
1498: x_info_only OUT NOCOPY iby_creditcard.information_only_flag%TYPE,
1499: x_purpose OUT NOCOPY iby_creditcard.card_purpose%TYPE,
1500: x_desc OUT NOCOPY iby_creditcard.description%TYPE,

Line 1497: x_single_use OUT NOCOPY iby_creditcard.single_use_flag%TYPE,

1493: x_pcard_flag OUT NOCOPY iby_creditcard.purchasecard_flag%TYPE,
1494: x_pcard_type OUT NOCOPY iby_creditcard.purchasecard_subtype%TYPE,
1495: x_issuer OUT NOCOPY iby_creditcard.card_issuer_code%TYPE,
1496: x_fi_name OUT NOCOPY iby_creditcard.finame%TYPE,
1497: x_single_use OUT NOCOPY iby_creditcard.single_use_flag%TYPE,
1498: x_info_only OUT NOCOPY iby_creditcard.information_only_flag%TYPE,
1499: x_purpose OUT NOCOPY iby_creditcard.card_purpose%TYPE,
1500: x_desc OUT NOCOPY iby_creditcard.description%TYPE,
1501: x_active_flag OUT NOCOPY iby_creditcard.active_flag%TYPE,

Line 1498: x_info_only OUT NOCOPY iby_creditcard.information_only_flag%TYPE,

1494: x_pcard_type OUT NOCOPY iby_creditcard.purchasecard_subtype%TYPE,
1495: x_issuer OUT NOCOPY iby_creditcard.card_issuer_code%TYPE,
1496: x_fi_name OUT NOCOPY iby_creditcard.finame%TYPE,
1497: x_single_use OUT NOCOPY iby_creditcard.single_use_flag%TYPE,
1498: x_info_only OUT NOCOPY iby_creditcard.information_only_flag%TYPE,
1499: x_purpose OUT NOCOPY iby_creditcard.card_purpose%TYPE,
1500: x_desc OUT NOCOPY iby_creditcard.description%TYPE,
1501: x_active_flag OUT NOCOPY iby_creditcard.active_flag%TYPE,
1502: x_inactive_date OUT NOCOPY iby_creditcard.inactive_date%TYPE,

Line 1499: x_purpose OUT NOCOPY iby_creditcard.card_purpose%TYPE,

1495: x_issuer OUT NOCOPY iby_creditcard.card_issuer_code%TYPE,
1496: x_fi_name OUT NOCOPY iby_creditcard.finame%TYPE,
1497: x_single_use OUT NOCOPY iby_creditcard.single_use_flag%TYPE,
1498: x_info_only OUT NOCOPY iby_creditcard.information_only_flag%TYPE,
1499: x_purpose OUT NOCOPY iby_creditcard.card_purpose%TYPE,
1500: x_desc OUT NOCOPY iby_creditcard.description%TYPE,
1501: x_active_flag OUT NOCOPY iby_creditcard.active_flag%TYPE,
1502: x_inactive_date OUT NOCOPY iby_creditcard.inactive_date%TYPE,
1503: x_result_code OUT NOCOPY VARCHAR2

Line 1500: x_desc OUT NOCOPY iby_creditcard.description%TYPE,

1496: x_fi_name OUT NOCOPY iby_creditcard.finame%TYPE,
1497: x_single_use OUT NOCOPY iby_creditcard.single_use_flag%TYPE,
1498: x_info_only OUT NOCOPY iby_creditcard.information_only_flag%TYPE,
1499: x_purpose OUT NOCOPY iby_creditcard.card_purpose%TYPE,
1500: x_desc OUT NOCOPY iby_creditcard.description%TYPE,
1501: x_active_flag OUT NOCOPY iby_creditcard.active_flag%TYPE,
1502: x_inactive_date OUT NOCOPY iby_creditcard.inactive_date%TYPE,
1503: x_result_code OUT NOCOPY VARCHAR2
1504: )

Line 1501: x_active_flag OUT NOCOPY iby_creditcard.active_flag%TYPE,

1497: x_single_use OUT NOCOPY iby_creditcard.single_use_flag%TYPE,
1498: x_info_only OUT NOCOPY iby_creditcard.information_only_flag%TYPE,
1499: x_purpose OUT NOCOPY iby_creditcard.card_purpose%TYPE,
1500: x_desc OUT NOCOPY iby_creditcard.description%TYPE,
1501: x_active_flag OUT NOCOPY iby_creditcard.active_flag%TYPE,
1502: x_inactive_date OUT NOCOPY iby_creditcard.inactive_date%TYPE,
1503: x_result_code OUT NOCOPY VARCHAR2
1504: )
1505: IS

Line 1502: x_inactive_date OUT NOCOPY iby_creditcard.inactive_date%TYPE,

1498: x_info_only OUT NOCOPY iby_creditcard.information_only_flag%TYPE,
1499: x_purpose OUT NOCOPY iby_creditcard.card_purpose%TYPE,
1500: x_desc OUT NOCOPY iby_creditcard.description%TYPE,
1501: x_active_flag OUT NOCOPY iby_creditcard.active_flag%TYPE,
1502: x_inactive_date OUT NOCOPY iby_creditcard.inactive_date%TYPE,
1503: x_result_code OUT NOCOPY VARCHAR2
1504: )
1505: IS
1506: l_ccnum_ciphertxt iby_creditcard.ccnumber%TYPE;

Line 1506: l_ccnum_ciphertxt iby_creditcard.ccnumber%TYPE;

1502: x_inactive_date OUT NOCOPY iby_creditcard.inactive_date%TYPE,
1503: x_result_code OUT NOCOPY VARCHAR2
1504: )
1505: IS
1506: l_ccnum_ciphertxt iby_creditcard.ccnumber%TYPE;
1507: l_encrypted iby_creditcard.encrypted%TYPE;
1508: l_err_code VARCHAR2(200);
1509: l_instr_found BOOLEAN;
1510:

Line 1507: l_encrypted iby_creditcard.encrypted%TYPE;

1503: x_result_code OUT NOCOPY VARCHAR2
1504: )
1505: IS
1506: l_ccnum_ciphertxt iby_creditcard.ccnumber%TYPE;
1507: l_encrypted iby_creditcard.encrypted%TYPE;
1508: l_err_code VARCHAR2(200);
1509: l_instr_found BOOLEAN;
1510:
1511: -- variabled for CHNAME and EXPDATE decryption

Line 1519: CURSOR c_creditcard(ci_instr_id iby_creditcard.instrid%TYPE)

1515: l_str_exp_date VARCHAR2(20);
1516: --l_exp_date DATE;
1517: --l_encrypted_date_format VARCHAR2(20);
1518:
1519: CURSOR c_creditcard(ci_instr_id iby_creditcard.instrid%TYPE)
1520: IS
1521: SELECT
1522: c.card_owner_id, c.chname, c.addressid,
1523: l.address1, l.address2, l.address3, l.city, l.county,

Line 1531: FROM iby_creditcard c, hz_party_site_uses su, hz_party_sites s,

1527: c.single_use_flag, c.information_only_flag, c.card_purpose,
1528: c.description, c.active_flag, c.inactive_date,
1529: c.encrypted, c.expiry_sec_segment_id,
1530: c.chname_sec_segment_id
1531: FROM iby_creditcard c, hz_party_site_uses su, hz_party_sites s,
1532: hz_locations l
1533: WHERE (instrid = ci_instr_id)
1534: AND (c.addressid = su.party_site_use_id(+))
1535: AND (su.party_site_id = s.party_site_id(+))

Line 1653: FROM iby_creditcard

1649:
1650: CURSOR c_card
1651: IS
1652: SELECT instrid, expiry_sec_segment_id
1653: FROM iby_creditcard
1654: WHERE (encrypted = 'Y')
1655: AND (expiry_sec_segment_id IS NOT NULL)
1656: AND (expired_flag <> 'Y');
1657: BEGIN

Line 1672: UPDATE iby_creditcard

1668: ELSE
1669: l_expired_flag := 'N';
1670: END IF;
1671:
1672: UPDATE iby_creditcard
1673: SET expired_flag = l_expired_flag
1674: WHERE (instrid = c_card_rec.instrid);
1675:
1676: END LOOP;

Line 1683: END iby_creditcard_pkg;

1679: COMMIT;
1680: END IF;
1681: END Mark_Expired_Cards;
1682:
1683: END iby_creditcard_pkg;