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_PAYMENTCARD_PKG dependencies on IBY_PAYMENTCARD

Line 1: PACKAGE BODY iby_paymentcard_pkg AS

1: PACKAGE BODY iby_paymentcard_pkg AS
2: /*$Header: ibypmtcardb.pls 120.1.12010000.4 2009/01/20 13:30:44 lmallick noship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_PAYMENTCARD_PKG';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_PAYMENTCARD_PKG';

1: PACKAGE BODY iby_paymentcard_pkg AS
2: /*$Header: ibypmtcardb.pls 120.1.12010000.4 2009/01/20 13:30:44 lmallick noship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_PAYMENTCARD_PKG';
5:
6: G_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'iby.plsql.IBY_PAYMENTCARD_PKG';
7:
8:

Line 6: G_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'iby.plsql.IBY_PAYMENTCARD_PKG';

2: /*$Header: ibypmtcardb.pls 120.1.12010000.4 2009/01/20 13:30:44 lmallick noship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_PAYMENTCARD_PKG';
5:
6: G_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'iby.plsql.IBY_PAYMENTCARD_PKG';
7:
8:
9: FUNCTION Get_Billing_Site
10: (p_party_site_id IN hz_party_sites.party_site_id%TYPE,

Line 114: (p_card_number IN iby_paymentcard.card_number%TYPE,

110: END IF;
111: END Get_Mask_Settings;
112:
113: FUNCTION Mask_Card_Number
114: (p_card_number IN iby_paymentcard.card_number%TYPE,
115: p_mask_option IN iby_paymentcard.card_mask_setting%TYPE,
116: p_unmask_len IN iby_paymentcard.card_unmask_length%TYPE
117: )
118: RETURN iby_paymentcard.masked_card_number%TYPE

Line 115: p_mask_option IN iby_paymentcard.card_mask_setting%TYPE,

111: END Get_Mask_Settings;
112:
113: FUNCTION Mask_Card_Number
114: (p_card_number IN iby_paymentcard.card_number%TYPE,
115: p_mask_option IN iby_paymentcard.card_mask_setting%TYPE,
116: p_unmask_len IN iby_paymentcard.card_unmask_length%TYPE
117: )
118: RETURN iby_paymentcard.masked_card_number%TYPE
119: IS

Line 116: p_unmask_len IN iby_paymentcard.card_unmask_length%TYPE

112:
113: FUNCTION Mask_Card_Number
114: (p_card_number IN iby_paymentcard.card_number%TYPE,
115: p_mask_option IN iby_paymentcard.card_mask_setting%TYPE,
116: p_unmask_len IN iby_paymentcard.card_unmask_length%TYPE
117: )
118: RETURN iby_paymentcard.masked_card_number%TYPE
119: IS
120: BEGIN

Line 118: RETURN iby_paymentcard.masked_card_number%TYPE

114: (p_card_number IN iby_paymentcard.card_number%TYPE,
115: p_mask_option IN iby_paymentcard.card_mask_setting%TYPE,
116: p_unmask_len IN iby_paymentcard.card_unmask_length%TYPE
117: )
118: RETURN iby_paymentcard.masked_card_number%TYPE
119: IS
120: BEGIN
121: RETURN iby_security_pkg.Mask_Data
122: (p_card_number,p_mask_option,p_unmask_len,G_MASK_CHARACTER);

Line 129: (p_card_number IN iby_paymentcard.card_number%TYPE,

125: --
126: -- Return: The masked card number, usable for display purposes
127: --
128: PROCEDURE Mask_Card_Number
129: (p_card_number IN iby_paymentcard.card_number%TYPE,
130: x_masked_number OUT NOCOPY iby_paymentcard.masked_card_number%TYPE,
131: x_mask_setting OUT NOCOPY iby_sys_security_options.credit_card_mask_setting%TYPE,
132: x_unmask_len OUT NOCOPY iby_sys_security_options.credit_card_unmask_len%TYPE
133: )

Line 130: x_masked_number OUT NOCOPY iby_paymentcard.masked_card_number%TYPE,

126: -- Return: The masked card number, usable for display purposes
127: --
128: PROCEDURE Mask_Card_Number
129: (p_card_number IN iby_paymentcard.card_number%TYPE,
130: x_masked_number OUT NOCOPY iby_paymentcard.masked_card_number%TYPE,
131: x_mask_setting OUT NOCOPY iby_sys_security_options.credit_card_mask_setting%TYPE,
132: x_unmask_len OUT NOCOPY iby_sys_security_options.credit_card_unmask_len%TYPE
133: )
134: IS

Line 141: FUNCTION Mask_Card_Number(p_card_number IN iby_paymentcard.card_number%TYPE)

137: x_masked_number :=
138: Mask_Card_Number(p_card_number,x_mask_setting,x_unmask_len);
139: END Mask_Card_Number;
140:
141: FUNCTION Mask_Card_Number(p_card_number IN iby_paymentcard.card_number%TYPE)
142: RETURN iby_paymentcard.masked_card_number%TYPE
143: IS
144: lx_mask_option iby_paymentcard.card_mask_setting%TYPE;
145: lx_mask_number iby_paymentcard.masked_card_number%TYPE;

Line 142: RETURN iby_paymentcard.masked_card_number%TYPE

138: Mask_Card_Number(p_card_number,x_mask_setting,x_unmask_len);
139: END Mask_Card_Number;
140:
141: FUNCTION Mask_Card_Number(p_card_number IN iby_paymentcard.card_number%TYPE)
142: RETURN iby_paymentcard.masked_card_number%TYPE
143: IS
144: lx_mask_option iby_paymentcard.card_mask_setting%TYPE;
145: lx_mask_number iby_paymentcard.masked_card_number%TYPE;
146: lx_unmask_len iby_sys_security_options.credit_card_unmask_len%TYPE;

Line 144: lx_mask_option iby_paymentcard.card_mask_setting%TYPE;

140:
141: FUNCTION Mask_Card_Number(p_card_number IN iby_paymentcard.card_number%TYPE)
142: RETURN iby_paymentcard.masked_card_number%TYPE
143: IS
144: lx_mask_option iby_paymentcard.card_mask_setting%TYPE;
145: lx_mask_number iby_paymentcard.masked_card_number%TYPE;
146: lx_unmask_len iby_sys_security_options.credit_card_unmask_len%TYPE;
147: BEGIN
148: Mask_Card_Number(p_card_number,lx_mask_number,lx_mask_option,lx_unmask_len);

Line 145: lx_mask_number iby_paymentcard.masked_card_number%TYPE;

141: FUNCTION Mask_Card_Number(p_card_number IN iby_paymentcard.card_number%TYPE)
142: RETURN iby_paymentcard.masked_card_number%TYPE
143: IS
144: lx_mask_option iby_paymentcard.card_mask_setting%TYPE;
145: lx_mask_number iby_paymentcard.masked_card_number%TYPE;
146: lx_unmask_len iby_sys_security_options.credit_card_unmask_len%TYPE;
147: BEGIN
148: Mask_Card_Number(p_card_number,lx_mask_number,lx_mask_option,lx_unmask_len);
149: RETURN lx_mask_number;

Line 163: l_addressid iby_paymentcard.addressid%TYPE;

159: lx_msg_count NUMBER;
160: lx_msg_data VARCHAR2(3000);
161: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
162:
163: l_addressid iby_paymentcard.addressid%TYPE;
164: l_billing_zip iby_paymentcard.billing_addr_postal_code%TYPE;
165: l_billing_terr iby_paymentcard.bill_addr_territory_code%TYPE;
166:
167: BEGIN

Line 164: l_billing_zip iby_paymentcard.billing_addr_postal_code%TYPE;

160: lx_msg_data VARCHAR2(3000);
161: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
162:
163: l_addressid iby_paymentcard.addressid%TYPE;
164: l_billing_zip iby_paymentcard.billing_addr_postal_code%TYPE;
165: l_billing_terr iby_paymentcard.bill_addr_territory_code%TYPE;
166:
167: BEGIN
168:

Line 165: l_billing_terr iby_paymentcard.bill_addr_territory_code%TYPE;

161: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
162:
163: l_addressid iby_paymentcard.addressid%TYPE;
164: l_billing_zip iby_paymentcard.billing_addr_postal_code%TYPE;
165: l_billing_terr iby_paymentcard.bill_addr_territory_code%TYPE;
166:
167: BEGIN
168:
169: IF (p_paymentcard.Info_Only_Flag = 'Y') THEN

Line 223: p_owner_id IN iby_paymentcard.card_owner_id%TYPE,

219:
220:
221: PROCEDURE Create_Card
222: (p_commit IN VARCHAR2,
223: p_owner_id IN iby_paymentcard.card_owner_id%TYPE,
224: p_holder_name IN iby_paymentcard.chname%TYPE,
225: p_billing_address_id IN iby_paymentcard.addressid%TYPE,
226: p_address_type IN VARCHAR2,
227: p_billing_zip IN iby_paymentcard.billing_addr_postal_code%TYPE,

Line 224: p_holder_name IN iby_paymentcard.chname%TYPE,

220:
221: PROCEDURE Create_Card
222: (p_commit IN VARCHAR2,
223: p_owner_id IN iby_paymentcard.card_owner_id%TYPE,
224: p_holder_name IN iby_paymentcard.chname%TYPE,
225: p_billing_address_id IN iby_paymentcard.addressid%TYPE,
226: p_address_type IN VARCHAR2,
227: p_billing_zip IN iby_paymentcard.billing_addr_postal_code%TYPE,
228: p_billing_country IN iby_paymentcard.bill_addr_territory_code%TYPE,

Line 225: p_billing_address_id IN iby_paymentcard.addressid%TYPE,

221: PROCEDURE Create_Card
222: (p_commit IN VARCHAR2,
223: p_owner_id IN iby_paymentcard.card_owner_id%TYPE,
224: p_holder_name IN iby_paymentcard.chname%TYPE,
225: p_billing_address_id IN iby_paymentcard.addressid%TYPE,
226: p_address_type IN VARCHAR2,
227: p_billing_zip IN iby_paymentcard.billing_addr_postal_code%TYPE,
228: p_billing_country IN iby_paymentcard.bill_addr_territory_code%TYPE,
229: p_card_number IN iby_paymentcard.card_number%TYPE,

Line 227: p_billing_zip IN iby_paymentcard.billing_addr_postal_code%TYPE,

223: p_owner_id IN iby_paymentcard.card_owner_id%TYPE,
224: p_holder_name IN iby_paymentcard.chname%TYPE,
225: p_billing_address_id IN iby_paymentcard.addressid%TYPE,
226: p_address_type IN VARCHAR2,
227: p_billing_zip IN iby_paymentcard.billing_addr_postal_code%TYPE,
228: p_billing_country IN iby_paymentcard.bill_addr_territory_code%TYPE,
229: p_card_number IN iby_paymentcard.card_number%TYPE,
230: p_expiry_date IN iby_paymentcard.expirydate%TYPE,
231: p_instr_type IN iby_paymentcard.instrument_type%TYPE,

Line 228: p_billing_country IN iby_paymentcard.bill_addr_territory_code%TYPE,

224: p_holder_name IN iby_paymentcard.chname%TYPE,
225: p_billing_address_id IN iby_paymentcard.addressid%TYPE,
226: p_address_type IN VARCHAR2,
227: p_billing_zip IN iby_paymentcard.billing_addr_postal_code%TYPE,
228: p_billing_country IN iby_paymentcard.bill_addr_territory_code%TYPE,
229: p_card_number IN iby_paymentcard.card_number%TYPE,
230: p_expiry_date IN iby_paymentcard.expirydate%TYPE,
231: p_instr_type IN iby_paymentcard.instrument_type%TYPE,
232: p_issuer IN iby_paymentcard.card_issuer_code%TYPE,

Line 229: p_card_number IN iby_paymentcard.card_number%TYPE,

225: p_billing_address_id IN iby_paymentcard.addressid%TYPE,
226: p_address_type IN VARCHAR2,
227: p_billing_zip IN iby_paymentcard.billing_addr_postal_code%TYPE,
228: p_billing_country IN iby_paymentcard.bill_addr_territory_code%TYPE,
229: p_card_number IN iby_paymentcard.card_number%TYPE,
230: p_expiry_date IN iby_paymentcard.expirydate%TYPE,
231: p_instr_type IN iby_paymentcard.instrument_type%TYPE,
232: p_issuer IN iby_paymentcard.card_issuer_code%TYPE,
233: p_fi_name IN iby_paymentcard.finame%TYPE,

Line 230: p_expiry_date IN iby_paymentcard.expirydate%TYPE,

226: p_address_type IN VARCHAR2,
227: p_billing_zip IN iby_paymentcard.billing_addr_postal_code%TYPE,
228: p_billing_country IN iby_paymentcard.bill_addr_territory_code%TYPE,
229: p_card_number IN iby_paymentcard.card_number%TYPE,
230: p_expiry_date IN iby_paymentcard.expirydate%TYPE,
231: p_instr_type IN iby_paymentcard.instrument_type%TYPE,
232: p_issuer IN iby_paymentcard.card_issuer_code%TYPE,
233: p_fi_name IN iby_paymentcard.finame%TYPE,
234: p_single_use IN iby_paymentcard.single_use_flag%TYPE,

Line 231: p_instr_type IN iby_paymentcard.instrument_type%TYPE,

227: p_billing_zip IN iby_paymentcard.billing_addr_postal_code%TYPE,
228: p_billing_country IN iby_paymentcard.bill_addr_territory_code%TYPE,
229: p_card_number IN iby_paymentcard.card_number%TYPE,
230: p_expiry_date IN iby_paymentcard.expirydate%TYPE,
231: p_instr_type IN iby_paymentcard.instrument_type%TYPE,
232: p_issuer IN iby_paymentcard.card_issuer_code%TYPE,
233: p_fi_name IN iby_paymentcard.finame%TYPE,
234: p_single_use IN iby_paymentcard.single_use_flag%TYPE,
235: p_info_only IN iby_paymentcard.information_only_flag%TYPE,

Line 232: p_issuer IN iby_paymentcard.card_issuer_code%TYPE,

228: p_billing_country IN iby_paymentcard.bill_addr_territory_code%TYPE,
229: p_card_number IN iby_paymentcard.card_number%TYPE,
230: p_expiry_date IN iby_paymentcard.expirydate%TYPE,
231: p_instr_type IN iby_paymentcard.instrument_type%TYPE,
232: p_issuer IN iby_paymentcard.card_issuer_code%TYPE,
233: p_fi_name IN iby_paymentcard.finame%TYPE,
234: p_single_use IN iby_paymentcard.single_use_flag%TYPE,
235: p_info_only IN iby_paymentcard.information_only_flag%TYPE,
236: p_purpose IN iby_paymentcard.card_purpose%TYPE,

Line 233: p_fi_name IN iby_paymentcard.finame%TYPE,

229: p_card_number IN iby_paymentcard.card_number%TYPE,
230: p_expiry_date IN iby_paymentcard.expirydate%TYPE,
231: p_instr_type IN iby_paymentcard.instrument_type%TYPE,
232: p_issuer IN iby_paymentcard.card_issuer_code%TYPE,
233: p_fi_name IN iby_paymentcard.finame%TYPE,
234: p_single_use IN iby_paymentcard.single_use_flag%TYPE,
235: p_info_only IN iby_paymentcard.information_only_flag%TYPE,
236: p_purpose IN iby_paymentcard.card_purpose%TYPE,
237: p_desc IN iby_paymentcard.description%TYPE,

Line 234: p_single_use IN iby_paymentcard.single_use_flag%TYPE,

230: p_expiry_date IN iby_paymentcard.expirydate%TYPE,
231: p_instr_type IN iby_paymentcard.instrument_type%TYPE,
232: p_issuer IN iby_paymentcard.card_issuer_code%TYPE,
233: p_fi_name IN iby_paymentcard.finame%TYPE,
234: p_single_use IN iby_paymentcard.single_use_flag%TYPE,
235: p_info_only IN iby_paymentcard.information_only_flag%TYPE,
236: p_purpose IN iby_paymentcard.card_purpose%TYPE,
237: p_desc IN iby_paymentcard.description%TYPE,
238: p_active_flag IN iby_paymentcard.active_flag%TYPE,

Line 235: p_info_only IN iby_paymentcard.information_only_flag%TYPE,

231: p_instr_type IN iby_paymentcard.instrument_type%TYPE,
232: p_issuer IN iby_paymentcard.card_issuer_code%TYPE,
233: p_fi_name IN iby_paymentcard.finame%TYPE,
234: p_single_use IN iby_paymentcard.single_use_flag%TYPE,
235: p_info_only IN iby_paymentcard.information_only_flag%TYPE,
236: p_purpose IN iby_paymentcard.card_purpose%TYPE,
237: p_desc IN iby_paymentcard.description%TYPE,
238: p_active_flag IN iby_paymentcard.active_flag%TYPE,
239: p_inactive_date IN iby_paymentcard.inactive_date%TYPE,

Line 236: p_purpose IN iby_paymentcard.card_purpose%TYPE,

232: p_issuer IN iby_paymentcard.card_issuer_code%TYPE,
233: p_fi_name IN iby_paymentcard.finame%TYPE,
234: p_single_use IN iby_paymentcard.single_use_flag%TYPE,
235: p_info_only IN iby_paymentcard.information_only_flag%TYPE,
236: p_purpose IN iby_paymentcard.card_purpose%TYPE,
237: p_desc IN iby_paymentcard.description%TYPE,
238: p_active_flag IN iby_paymentcard.active_flag%TYPE,
239: p_inactive_date IN iby_paymentcard.inactive_date%TYPE,
240: p_attribute_category IN iby_paymentcard.attribute_category%TYPE,

Line 237: p_desc IN iby_paymentcard.description%TYPE,

233: p_fi_name IN iby_paymentcard.finame%TYPE,
234: p_single_use IN iby_paymentcard.single_use_flag%TYPE,
235: p_info_only IN iby_paymentcard.information_only_flag%TYPE,
236: p_purpose IN iby_paymentcard.card_purpose%TYPE,
237: p_desc IN iby_paymentcard.description%TYPE,
238: p_active_flag IN iby_paymentcard.active_flag%TYPE,
239: p_inactive_date IN iby_paymentcard.inactive_date%TYPE,
240: p_attribute_category IN iby_paymentcard.attribute_category%TYPE,
241: p_attribute1 IN iby_paymentcard.attribute1%TYPE,

Line 238: p_active_flag IN iby_paymentcard.active_flag%TYPE,

234: p_single_use IN iby_paymentcard.single_use_flag%TYPE,
235: p_info_only IN iby_paymentcard.information_only_flag%TYPE,
236: p_purpose IN iby_paymentcard.card_purpose%TYPE,
237: p_desc IN iby_paymentcard.description%TYPE,
238: p_active_flag IN iby_paymentcard.active_flag%TYPE,
239: p_inactive_date IN iby_paymentcard.inactive_date%TYPE,
240: p_attribute_category IN iby_paymentcard.attribute_category%TYPE,
241: p_attribute1 IN iby_paymentcard.attribute1%TYPE,
242: p_attribute2 IN iby_paymentcard.attribute2%TYPE,

Line 239: p_inactive_date IN iby_paymentcard.inactive_date%TYPE,

235: p_info_only IN iby_paymentcard.information_only_flag%TYPE,
236: p_purpose IN iby_paymentcard.card_purpose%TYPE,
237: p_desc IN iby_paymentcard.description%TYPE,
238: p_active_flag IN iby_paymentcard.active_flag%TYPE,
239: p_inactive_date IN iby_paymentcard.inactive_date%TYPE,
240: p_attribute_category IN iby_paymentcard.attribute_category%TYPE,
241: p_attribute1 IN iby_paymentcard.attribute1%TYPE,
242: p_attribute2 IN iby_paymentcard.attribute2%TYPE,
243: p_attribute3 IN iby_paymentcard.attribute3%TYPE,

Line 240: p_attribute_category IN iby_paymentcard.attribute_category%TYPE,

236: p_purpose IN iby_paymentcard.card_purpose%TYPE,
237: p_desc IN iby_paymentcard.description%TYPE,
238: p_active_flag IN iby_paymentcard.active_flag%TYPE,
239: p_inactive_date IN iby_paymentcard.inactive_date%TYPE,
240: p_attribute_category IN iby_paymentcard.attribute_category%TYPE,
241: p_attribute1 IN iby_paymentcard.attribute1%TYPE,
242: p_attribute2 IN iby_paymentcard.attribute2%TYPE,
243: p_attribute3 IN iby_paymentcard.attribute3%TYPE,
244: p_attribute4 IN iby_paymentcard.attribute4%TYPE,

Line 241: p_attribute1 IN iby_paymentcard.attribute1%TYPE,

237: p_desc IN iby_paymentcard.description%TYPE,
238: p_active_flag IN iby_paymentcard.active_flag%TYPE,
239: p_inactive_date IN iby_paymentcard.inactive_date%TYPE,
240: p_attribute_category IN iby_paymentcard.attribute_category%TYPE,
241: p_attribute1 IN iby_paymentcard.attribute1%TYPE,
242: p_attribute2 IN iby_paymentcard.attribute2%TYPE,
243: p_attribute3 IN iby_paymentcard.attribute3%TYPE,
244: p_attribute4 IN iby_paymentcard.attribute4%TYPE,
245: p_attribute5 IN iby_paymentcard.attribute5%TYPE,

Line 242: p_attribute2 IN iby_paymentcard.attribute2%TYPE,

238: p_active_flag IN iby_paymentcard.active_flag%TYPE,
239: p_inactive_date IN iby_paymentcard.inactive_date%TYPE,
240: p_attribute_category IN iby_paymentcard.attribute_category%TYPE,
241: p_attribute1 IN iby_paymentcard.attribute1%TYPE,
242: p_attribute2 IN iby_paymentcard.attribute2%TYPE,
243: p_attribute3 IN iby_paymentcard.attribute3%TYPE,
244: p_attribute4 IN iby_paymentcard.attribute4%TYPE,
245: p_attribute5 IN iby_paymentcard.attribute5%TYPE,
246: p_attribute6 IN iby_paymentcard.attribute6%TYPE,

Line 243: p_attribute3 IN iby_paymentcard.attribute3%TYPE,

239: p_inactive_date IN iby_paymentcard.inactive_date%TYPE,
240: p_attribute_category IN iby_paymentcard.attribute_category%TYPE,
241: p_attribute1 IN iby_paymentcard.attribute1%TYPE,
242: p_attribute2 IN iby_paymentcard.attribute2%TYPE,
243: p_attribute3 IN iby_paymentcard.attribute3%TYPE,
244: p_attribute4 IN iby_paymentcard.attribute4%TYPE,
245: p_attribute5 IN iby_paymentcard.attribute5%TYPE,
246: p_attribute6 IN iby_paymentcard.attribute6%TYPE,
247: p_attribute7 IN iby_paymentcard.attribute7%TYPE,

Line 244: p_attribute4 IN iby_paymentcard.attribute4%TYPE,

240: p_attribute_category IN iby_paymentcard.attribute_category%TYPE,
241: p_attribute1 IN iby_paymentcard.attribute1%TYPE,
242: p_attribute2 IN iby_paymentcard.attribute2%TYPE,
243: p_attribute3 IN iby_paymentcard.attribute3%TYPE,
244: p_attribute4 IN iby_paymentcard.attribute4%TYPE,
245: p_attribute5 IN iby_paymentcard.attribute5%TYPE,
246: p_attribute6 IN iby_paymentcard.attribute6%TYPE,
247: p_attribute7 IN iby_paymentcard.attribute7%TYPE,
248: p_attribute8 IN iby_paymentcard.attribute8%TYPE,

Line 245: p_attribute5 IN iby_paymentcard.attribute5%TYPE,

241: p_attribute1 IN iby_paymentcard.attribute1%TYPE,
242: p_attribute2 IN iby_paymentcard.attribute2%TYPE,
243: p_attribute3 IN iby_paymentcard.attribute3%TYPE,
244: p_attribute4 IN iby_paymentcard.attribute4%TYPE,
245: p_attribute5 IN iby_paymentcard.attribute5%TYPE,
246: p_attribute6 IN iby_paymentcard.attribute6%TYPE,
247: p_attribute7 IN iby_paymentcard.attribute7%TYPE,
248: p_attribute8 IN iby_paymentcard.attribute8%TYPE,
249: p_attribute9 IN iby_paymentcard.attribute9%TYPE,

Line 246: p_attribute6 IN iby_paymentcard.attribute6%TYPE,

242: p_attribute2 IN iby_paymentcard.attribute2%TYPE,
243: p_attribute3 IN iby_paymentcard.attribute3%TYPE,
244: p_attribute4 IN iby_paymentcard.attribute4%TYPE,
245: p_attribute5 IN iby_paymentcard.attribute5%TYPE,
246: p_attribute6 IN iby_paymentcard.attribute6%TYPE,
247: p_attribute7 IN iby_paymentcard.attribute7%TYPE,
248: p_attribute8 IN iby_paymentcard.attribute8%TYPE,
249: p_attribute9 IN iby_paymentcard.attribute9%TYPE,
250: p_attribute10 IN iby_paymentcard.attribute10%TYPE,

Line 247: p_attribute7 IN iby_paymentcard.attribute7%TYPE,

243: p_attribute3 IN iby_paymentcard.attribute3%TYPE,
244: p_attribute4 IN iby_paymentcard.attribute4%TYPE,
245: p_attribute5 IN iby_paymentcard.attribute5%TYPE,
246: p_attribute6 IN iby_paymentcard.attribute6%TYPE,
247: p_attribute7 IN iby_paymentcard.attribute7%TYPE,
248: p_attribute8 IN iby_paymentcard.attribute8%TYPE,
249: p_attribute9 IN iby_paymentcard.attribute9%TYPE,
250: p_attribute10 IN iby_paymentcard.attribute10%TYPE,
251: p_attribute11 IN iby_paymentcard.attribute11%TYPE,

Line 248: p_attribute8 IN iby_paymentcard.attribute8%TYPE,

244: p_attribute4 IN iby_paymentcard.attribute4%TYPE,
245: p_attribute5 IN iby_paymentcard.attribute5%TYPE,
246: p_attribute6 IN iby_paymentcard.attribute6%TYPE,
247: p_attribute7 IN iby_paymentcard.attribute7%TYPE,
248: p_attribute8 IN iby_paymentcard.attribute8%TYPE,
249: p_attribute9 IN iby_paymentcard.attribute9%TYPE,
250: p_attribute10 IN iby_paymentcard.attribute10%TYPE,
251: p_attribute11 IN iby_paymentcard.attribute11%TYPE,
252: p_attribute12 IN iby_paymentcard.attribute12%TYPE,

Line 249: p_attribute9 IN iby_paymentcard.attribute9%TYPE,

245: p_attribute5 IN iby_paymentcard.attribute5%TYPE,
246: p_attribute6 IN iby_paymentcard.attribute6%TYPE,
247: p_attribute7 IN iby_paymentcard.attribute7%TYPE,
248: p_attribute8 IN iby_paymentcard.attribute8%TYPE,
249: p_attribute9 IN iby_paymentcard.attribute9%TYPE,
250: p_attribute10 IN iby_paymentcard.attribute10%TYPE,
251: p_attribute11 IN iby_paymentcard.attribute11%TYPE,
252: p_attribute12 IN iby_paymentcard.attribute12%TYPE,
253: p_attribute13 IN iby_paymentcard.attribute13%TYPE,

Line 250: p_attribute10 IN iby_paymentcard.attribute10%TYPE,

246: p_attribute6 IN iby_paymentcard.attribute6%TYPE,
247: p_attribute7 IN iby_paymentcard.attribute7%TYPE,
248: p_attribute8 IN iby_paymentcard.attribute8%TYPE,
249: p_attribute9 IN iby_paymentcard.attribute9%TYPE,
250: p_attribute10 IN iby_paymentcard.attribute10%TYPE,
251: p_attribute11 IN iby_paymentcard.attribute11%TYPE,
252: p_attribute12 IN iby_paymentcard.attribute12%TYPE,
253: p_attribute13 IN iby_paymentcard.attribute13%TYPE,
254: p_attribute14 IN iby_paymentcard.attribute14%TYPE,

Line 251: p_attribute11 IN iby_paymentcard.attribute11%TYPE,

247: p_attribute7 IN iby_paymentcard.attribute7%TYPE,
248: p_attribute8 IN iby_paymentcard.attribute8%TYPE,
249: p_attribute9 IN iby_paymentcard.attribute9%TYPE,
250: p_attribute10 IN iby_paymentcard.attribute10%TYPE,
251: p_attribute11 IN iby_paymentcard.attribute11%TYPE,
252: p_attribute12 IN iby_paymentcard.attribute12%TYPE,
253: p_attribute13 IN iby_paymentcard.attribute13%TYPE,
254: p_attribute14 IN iby_paymentcard.attribute14%TYPE,
255: p_attribute15 IN iby_paymentcard.attribute15%TYPE,

Line 252: p_attribute12 IN iby_paymentcard.attribute12%TYPE,

248: p_attribute8 IN iby_paymentcard.attribute8%TYPE,
249: p_attribute9 IN iby_paymentcard.attribute9%TYPE,
250: p_attribute10 IN iby_paymentcard.attribute10%TYPE,
251: p_attribute11 IN iby_paymentcard.attribute11%TYPE,
252: p_attribute12 IN iby_paymentcard.attribute12%TYPE,
253: p_attribute13 IN iby_paymentcard.attribute13%TYPE,
254: p_attribute14 IN iby_paymentcard.attribute14%TYPE,
255: p_attribute15 IN iby_paymentcard.attribute15%TYPE,
256: x_result_code OUT NOCOPY VARCHAR2,

Line 253: p_attribute13 IN iby_paymentcard.attribute13%TYPE,

249: p_attribute9 IN iby_paymentcard.attribute9%TYPE,
250: p_attribute10 IN iby_paymentcard.attribute10%TYPE,
251: p_attribute11 IN iby_paymentcard.attribute11%TYPE,
252: p_attribute12 IN iby_paymentcard.attribute12%TYPE,
253: p_attribute13 IN iby_paymentcard.attribute13%TYPE,
254: p_attribute14 IN iby_paymentcard.attribute14%TYPE,
255: p_attribute15 IN iby_paymentcard.attribute15%TYPE,
256: x_result_code OUT NOCOPY VARCHAR2,
257: x_instr_id OUT NOCOPY iby_paymentcard.instrid%TYPE

Line 254: p_attribute14 IN iby_paymentcard.attribute14%TYPE,

250: p_attribute10 IN iby_paymentcard.attribute10%TYPE,
251: p_attribute11 IN iby_paymentcard.attribute11%TYPE,
252: p_attribute12 IN iby_paymentcard.attribute12%TYPE,
253: p_attribute13 IN iby_paymentcard.attribute13%TYPE,
254: p_attribute14 IN iby_paymentcard.attribute14%TYPE,
255: p_attribute15 IN iby_paymentcard.attribute15%TYPE,
256: x_result_code OUT NOCOPY VARCHAR2,
257: x_instr_id OUT NOCOPY iby_paymentcard.instrid%TYPE
258: )

Line 255: p_attribute15 IN iby_paymentcard.attribute15%TYPE,

251: p_attribute11 IN iby_paymentcard.attribute11%TYPE,
252: p_attribute12 IN iby_paymentcard.attribute12%TYPE,
253: p_attribute13 IN iby_paymentcard.attribute13%TYPE,
254: p_attribute14 IN iby_paymentcard.attribute14%TYPE,
255: p_attribute15 IN iby_paymentcard.attribute15%TYPE,
256: x_result_code OUT NOCOPY VARCHAR2,
257: x_instr_id OUT NOCOPY iby_paymentcard.instrid%TYPE
258: )
259: IS

Line 257: x_instr_id OUT NOCOPY iby_paymentcard.instrid%TYPE

253: p_attribute13 IN iby_paymentcard.attribute13%TYPE,
254: p_attribute14 IN iby_paymentcard.attribute14%TYPE,
255: p_attribute15 IN iby_paymentcard.attribute15%TYPE,
256: x_result_code OUT NOCOPY VARCHAR2,
257: x_instr_id OUT NOCOPY iby_paymentcard.instrid%TYPE
258: )
259: IS
260:
261: lx_return_status VARCHAR2(1);

Line 265: l_card_len iby_paymentcard.card_number_length%TYPE;

261: lx_return_status VARCHAR2(1);
262: lx_msg_count NUMBER;
263: lx_msg_data VARCHAR2(200);
264:
265: l_card_len iby_paymentcard.card_number_length%TYPE;
266:
267: lx_card_number iby_paymentcard.card_number%TYPE;
268: lx_unmasked_digits iby_paymentcard.card_number%TYPE;
269:

Line 267: lx_card_number iby_paymentcard.card_number%TYPE;

263: lx_msg_data VARCHAR2(200);
264:
265: l_card_len iby_paymentcard.card_number_length%TYPE;
266:
267: lx_card_number iby_paymentcard.card_number%TYPE;
268: lx_unmasked_digits iby_paymentcard.card_number%TYPE;
269:
270: lx_masked_number iby_paymentcard.masked_card_number%TYPE;
271: lx_mask_option iby_paymentcard.card_mask_setting%TYPE;

Line 268: lx_unmasked_digits iby_paymentcard.card_number%TYPE;

264:
265: l_card_len iby_paymentcard.card_number_length%TYPE;
266:
267: lx_card_number iby_paymentcard.card_number%TYPE;
268: lx_unmasked_digits iby_paymentcard.card_number%TYPE;
269:
270: lx_masked_number iby_paymentcard.masked_card_number%TYPE;
271: lx_mask_option iby_paymentcard.card_mask_setting%TYPE;
272: lx_unmask_len iby_paymentcard.card_unmask_length%TYPE;

Line 270: lx_masked_number iby_paymentcard.masked_card_number%TYPE;

266:
267: lx_card_number iby_paymentcard.card_number%TYPE;
268: lx_unmasked_digits iby_paymentcard.card_number%TYPE;
269:
270: lx_masked_number iby_paymentcard.masked_card_number%TYPE;
271: lx_mask_option iby_paymentcard.card_mask_setting%TYPE;
272: lx_unmask_len iby_paymentcard.card_unmask_length%TYPE;
273:
274:

Line 271: lx_mask_option iby_paymentcard.card_mask_setting%TYPE;

267: lx_card_number iby_paymentcard.card_number%TYPE;
268: lx_unmasked_digits iby_paymentcard.card_number%TYPE;
269:
270: lx_masked_number iby_paymentcard.masked_card_number%TYPE;
271: lx_mask_option iby_paymentcard.card_mask_setting%TYPE;
272: lx_unmask_len iby_paymentcard.card_unmask_length%TYPE;
273:
274:
275: l_expiry_date iby_paymentcard.expirydate%TYPE;

Line 272: lx_unmask_len iby_paymentcard.card_unmask_length%TYPE;

268: lx_unmasked_digits iby_paymentcard.card_number%TYPE;
269:
270: lx_masked_number iby_paymentcard.masked_card_number%TYPE;
271: lx_mask_option iby_paymentcard.card_mask_setting%TYPE;
272: lx_unmask_len iby_paymentcard.card_unmask_length%TYPE;
273:
274:
275: l_expiry_date iby_paymentcard.expirydate%TYPE;
276: l_billing_site hz_party_site_uses.party_site_use_id%TYPE;

Line 275: l_expiry_date iby_paymentcard.expirydate%TYPE;

271: lx_mask_option iby_paymentcard.card_mask_setting%TYPE;
272: lx_unmask_len iby_paymentcard.card_unmask_length%TYPE;
273:
274:
275: l_expiry_date iby_paymentcard.expirydate%TYPE;
276: l_billing_site hz_party_site_uses.party_site_use_id%TYPE;
277:
278:
279: CURSOR c_card

Line 281: ci_card_number IN iby_paymentcard.card_number%TYPE

277:
278:
279: CURSOR c_card
280: (ci_owner_id IN hz_parties.party_id%TYPE,
281: ci_card_number IN iby_paymentcard.card_number%TYPE
282: )
283: IS
284: SELECT instrid
285: FROM iby_paymentcard

Line 285: FROM iby_paymentcard

281: ci_card_number IN iby_paymentcard.card_number%TYPE
282: )
283: IS
284: SELECT instrid
285: FROM iby_paymentcard
286: WHERE (card_number = ci_card_number)
287: AND ( (NVL(card_owner_id,ci_owner_id) = NVL(ci_owner_id,card_owner_id))
288: OR (card_owner_id IS NULL AND ci_owner_id IS NULL)
289: )

Line 360: SELECT iby_paymentcard_s.NEXTVAL INTO x_instr_id FROM DUAL;

356: CLOSE c_card;
357:
358: IF (NOT x_instr_id IS NULL) THEN RETURN; END IF;
359:
360: SELECT iby_paymentcard_s.NEXTVAL INTO x_instr_id FROM DUAL;
361:
362: INSERT INTO iby_paymentcard
363: (instrid, card_number, masked_card_number,
364: card_mask_setting, card_unmask_length,

Line 362: INSERT INTO iby_paymentcard

358: IF (NOT x_instr_id IS NULL) THEN RETURN; END IF;
359:
360: SELECT iby_paymentcard_s.NEXTVAL INTO x_instr_id FROM DUAL;
361:
362: INSERT INTO iby_paymentcard
363: (instrid, card_number, masked_card_number,
364: card_mask_setting, card_unmask_length,
365: expirydate, card_owner_id, chname,
366: addressid, billing_addr_postal_code, bill_addr_territory_code,

Line 402: p_instr_id IN iby_paymentcard.instrid%TYPE,

398: END Create_Card;
399:
400: PROCEDURE Update_Card
401: (p_commit IN VARCHAR2,
402: p_instr_id IN iby_paymentcard.instrid%TYPE,
403: p_owner_id IN iby_paymentcard.card_owner_id%TYPE,
404: p_holder_name IN iby_paymentcard.chname%TYPE,
405: p_billing_address_id IN iby_paymentcard.addressid%TYPE,
406: p_address_type IN VARCHAR2 := G_PARTY_SITE_ID,

Line 403: p_owner_id IN iby_paymentcard.card_owner_id%TYPE,

399:
400: PROCEDURE Update_Card
401: (p_commit IN VARCHAR2,
402: p_instr_id IN iby_paymentcard.instrid%TYPE,
403: p_owner_id IN iby_paymentcard.card_owner_id%TYPE,
404: p_holder_name IN iby_paymentcard.chname%TYPE,
405: p_billing_address_id IN iby_paymentcard.addressid%TYPE,
406: p_address_type IN VARCHAR2 := G_PARTY_SITE_ID,
407: p_billing_zip IN iby_paymentcard.billing_addr_postal_code%TYPE,

Line 404: p_holder_name IN iby_paymentcard.chname%TYPE,

400: PROCEDURE Update_Card
401: (p_commit IN VARCHAR2,
402: p_instr_id IN iby_paymentcard.instrid%TYPE,
403: p_owner_id IN iby_paymentcard.card_owner_id%TYPE,
404: p_holder_name IN iby_paymentcard.chname%TYPE,
405: p_billing_address_id IN iby_paymentcard.addressid%TYPE,
406: p_address_type IN VARCHAR2 := G_PARTY_SITE_ID,
407: p_billing_zip IN iby_paymentcard.billing_addr_postal_code%TYPE,
408: p_billing_country IN iby_paymentcard.bill_addr_territory_code%TYPE,

Line 405: p_billing_address_id IN iby_paymentcard.addressid%TYPE,

401: (p_commit IN VARCHAR2,
402: p_instr_id IN iby_paymentcard.instrid%TYPE,
403: p_owner_id IN iby_paymentcard.card_owner_id%TYPE,
404: p_holder_name IN iby_paymentcard.chname%TYPE,
405: p_billing_address_id IN iby_paymentcard.addressid%TYPE,
406: p_address_type IN VARCHAR2 := G_PARTY_SITE_ID,
407: p_billing_zip IN iby_paymentcard.billing_addr_postal_code%TYPE,
408: p_billing_country IN iby_paymentcard.bill_addr_territory_code%TYPE,
409: p_expiry_date IN iby_paymentcard.expirydate%TYPE,

Line 407: p_billing_zip IN iby_paymentcard.billing_addr_postal_code%TYPE,

403: p_owner_id IN iby_paymentcard.card_owner_id%TYPE,
404: p_holder_name IN iby_paymentcard.chname%TYPE,
405: p_billing_address_id IN iby_paymentcard.addressid%TYPE,
406: p_address_type IN VARCHAR2 := G_PARTY_SITE_ID,
407: p_billing_zip IN iby_paymentcard.billing_addr_postal_code%TYPE,
408: p_billing_country IN iby_paymentcard.bill_addr_territory_code%TYPE,
409: p_expiry_date IN iby_paymentcard.expirydate%TYPE,
410: p_instr_type IN iby_paymentcard.instrument_type%TYPE,
411: p_fi_name IN iby_paymentcard.finame%TYPE,

Line 408: p_billing_country IN iby_paymentcard.bill_addr_territory_code%TYPE,

404: p_holder_name IN iby_paymentcard.chname%TYPE,
405: p_billing_address_id IN iby_paymentcard.addressid%TYPE,
406: p_address_type IN VARCHAR2 := G_PARTY_SITE_ID,
407: p_billing_zip IN iby_paymentcard.billing_addr_postal_code%TYPE,
408: p_billing_country IN iby_paymentcard.bill_addr_territory_code%TYPE,
409: p_expiry_date IN iby_paymentcard.expirydate%TYPE,
410: p_instr_type IN iby_paymentcard.instrument_type%TYPE,
411: p_fi_name IN iby_paymentcard.finame%TYPE,
412: p_single_use IN iby_paymentcard.single_use_flag%TYPE,

Line 409: p_expiry_date IN iby_paymentcard.expirydate%TYPE,

405: p_billing_address_id IN iby_paymentcard.addressid%TYPE,
406: p_address_type IN VARCHAR2 := G_PARTY_SITE_ID,
407: p_billing_zip IN iby_paymentcard.billing_addr_postal_code%TYPE,
408: p_billing_country IN iby_paymentcard.bill_addr_territory_code%TYPE,
409: p_expiry_date IN iby_paymentcard.expirydate%TYPE,
410: p_instr_type IN iby_paymentcard.instrument_type%TYPE,
411: p_fi_name IN iby_paymentcard.finame%TYPE,
412: p_single_use IN iby_paymentcard.single_use_flag%TYPE,
413: p_info_only IN iby_paymentcard.information_only_flag%TYPE,

Line 410: p_instr_type IN iby_paymentcard.instrument_type%TYPE,

406: p_address_type IN VARCHAR2 := G_PARTY_SITE_ID,
407: p_billing_zip IN iby_paymentcard.billing_addr_postal_code%TYPE,
408: p_billing_country IN iby_paymentcard.bill_addr_territory_code%TYPE,
409: p_expiry_date IN iby_paymentcard.expirydate%TYPE,
410: p_instr_type IN iby_paymentcard.instrument_type%TYPE,
411: p_fi_name IN iby_paymentcard.finame%TYPE,
412: p_single_use IN iby_paymentcard.single_use_flag%TYPE,
413: p_info_only IN iby_paymentcard.information_only_flag%TYPE,
414: p_purpose IN iby_paymentcard.card_purpose%TYPE,

Line 411: p_fi_name IN iby_paymentcard.finame%TYPE,

407: p_billing_zip IN iby_paymentcard.billing_addr_postal_code%TYPE,
408: p_billing_country IN iby_paymentcard.bill_addr_territory_code%TYPE,
409: p_expiry_date IN iby_paymentcard.expirydate%TYPE,
410: p_instr_type IN iby_paymentcard.instrument_type%TYPE,
411: p_fi_name IN iby_paymentcard.finame%TYPE,
412: p_single_use IN iby_paymentcard.single_use_flag%TYPE,
413: p_info_only IN iby_paymentcard.information_only_flag%TYPE,
414: p_purpose IN iby_paymentcard.card_purpose%TYPE,
415: p_desc IN iby_paymentcard.description%TYPE,

Line 412: p_single_use IN iby_paymentcard.single_use_flag%TYPE,

408: p_billing_country IN iby_paymentcard.bill_addr_territory_code%TYPE,
409: p_expiry_date IN iby_paymentcard.expirydate%TYPE,
410: p_instr_type IN iby_paymentcard.instrument_type%TYPE,
411: p_fi_name IN iby_paymentcard.finame%TYPE,
412: p_single_use IN iby_paymentcard.single_use_flag%TYPE,
413: p_info_only IN iby_paymentcard.information_only_flag%TYPE,
414: p_purpose IN iby_paymentcard.card_purpose%TYPE,
415: p_desc IN iby_paymentcard.description%TYPE,
416: p_active_flag IN iby_paymentcard.active_flag%TYPE,

Line 413: p_info_only IN iby_paymentcard.information_only_flag%TYPE,

409: p_expiry_date IN iby_paymentcard.expirydate%TYPE,
410: p_instr_type IN iby_paymentcard.instrument_type%TYPE,
411: p_fi_name IN iby_paymentcard.finame%TYPE,
412: p_single_use IN iby_paymentcard.single_use_flag%TYPE,
413: p_info_only IN iby_paymentcard.information_only_flag%TYPE,
414: p_purpose IN iby_paymentcard.card_purpose%TYPE,
415: p_desc IN iby_paymentcard.description%TYPE,
416: p_active_flag IN iby_paymentcard.active_flag%TYPE,
417: p_inactive_date IN iby_paymentcard.inactive_date%TYPE,

Line 414: p_purpose IN iby_paymentcard.card_purpose%TYPE,

410: p_instr_type IN iby_paymentcard.instrument_type%TYPE,
411: p_fi_name IN iby_paymentcard.finame%TYPE,
412: p_single_use IN iby_paymentcard.single_use_flag%TYPE,
413: p_info_only IN iby_paymentcard.information_only_flag%TYPE,
414: p_purpose IN iby_paymentcard.card_purpose%TYPE,
415: p_desc IN iby_paymentcard.description%TYPE,
416: p_active_flag IN iby_paymentcard.active_flag%TYPE,
417: p_inactive_date IN iby_paymentcard.inactive_date%TYPE,
418: p_attribute_category IN iby_paymentcard.attribute_category%TYPE,

Line 415: p_desc IN iby_paymentcard.description%TYPE,

411: p_fi_name IN iby_paymentcard.finame%TYPE,
412: p_single_use IN iby_paymentcard.single_use_flag%TYPE,
413: p_info_only IN iby_paymentcard.information_only_flag%TYPE,
414: p_purpose IN iby_paymentcard.card_purpose%TYPE,
415: p_desc IN iby_paymentcard.description%TYPE,
416: p_active_flag IN iby_paymentcard.active_flag%TYPE,
417: p_inactive_date IN iby_paymentcard.inactive_date%TYPE,
418: p_attribute_category IN iby_paymentcard.attribute_category%TYPE,
419: p_attribute1 IN iby_paymentcard.attribute1%TYPE,

Line 416: p_active_flag IN iby_paymentcard.active_flag%TYPE,

412: p_single_use IN iby_paymentcard.single_use_flag%TYPE,
413: p_info_only IN iby_paymentcard.information_only_flag%TYPE,
414: p_purpose IN iby_paymentcard.card_purpose%TYPE,
415: p_desc IN iby_paymentcard.description%TYPE,
416: p_active_flag IN iby_paymentcard.active_flag%TYPE,
417: p_inactive_date IN iby_paymentcard.inactive_date%TYPE,
418: p_attribute_category IN iby_paymentcard.attribute_category%TYPE,
419: p_attribute1 IN iby_paymentcard.attribute1%TYPE,
420: p_attribute2 IN iby_paymentcard.attribute2%TYPE,

Line 417: p_inactive_date IN iby_paymentcard.inactive_date%TYPE,

413: p_info_only IN iby_paymentcard.information_only_flag%TYPE,
414: p_purpose IN iby_paymentcard.card_purpose%TYPE,
415: p_desc IN iby_paymentcard.description%TYPE,
416: p_active_flag IN iby_paymentcard.active_flag%TYPE,
417: p_inactive_date IN iby_paymentcard.inactive_date%TYPE,
418: p_attribute_category IN iby_paymentcard.attribute_category%TYPE,
419: p_attribute1 IN iby_paymentcard.attribute1%TYPE,
420: p_attribute2 IN iby_paymentcard.attribute2%TYPE,
421: p_attribute3 IN iby_paymentcard.attribute3%TYPE,

Line 418: p_attribute_category IN iby_paymentcard.attribute_category%TYPE,

414: p_purpose IN iby_paymentcard.card_purpose%TYPE,
415: p_desc IN iby_paymentcard.description%TYPE,
416: p_active_flag IN iby_paymentcard.active_flag%TYPE,
417: p_inactive_date IN iby_paymentcard.inactive_date%TYPE,
418: p_attribute_category IN iby_paymentcard.attribute_category%TYPE,
419: p_attribute1 IN iby_paymentcard.attribute1%TYPE,
420: p_attribute2 IN iby_paymentcard.attribute2%TYPE,
421: p_attribute3 IN iby_paymentcard.attribute3%TYPE,
422: p_attribute4 IN iby_paymentcard.attribute4%TYPE,

Line 419: p_attribute1 IN iby_paymentcard.attribute1%TYPE,

415: p_desc IN iby_paymentcard.description%TYPE,
416: p_active_flag IN iby_paymentcard.active_flag%TYPE,
417: p_inactive_date IN iby_paymentcard.inactive_date%TYPE,
418: p_attribute_category IN iby_paymentcard.attribute_category%TYPE,
419: p_attribute1 IN iby_paymentcard.attribute1%TYPE,
420: p_attribute2 IN iby_paymentcard.attribute2%TYPE,
421: p_attribute3 IN iby_paymentcard.attribute3%TYPE,
422: p_attribute4 IN iby_paymentcard.attribute4%TYPE,
423: p_attribute5 IN iby_paymentcard.attribute5%TYPE,

Line 420: p_attribute2 IN iby_paymentcard.attribute2%TYPE,

416: p_active_flag IN iby_paymentcard.active_flag%TYPE,
417: p_inactive_date IN iby_paymentcard.inactive_date%TYPE,
418: p_attribute_category IN iby_paymentcard.attribute_category%TYPE,
419: p_attribute1 IN iby_paymentcard.attribute1%TYPE,
420: p_attribute2 IN iby_paymentcard.attribute2%TYPE,
421: p_attribute3 IN iby_paymentcard.attribute3%TYPE,
422: p_attribute4 IN iby_paymentcard.attribute4%TYPE,
423: p_attribute5 IN iby_paymentcard.attribute5%TYPE,
424: p_attribute6 IN iby_paymentcard.attribute6%TYPE,

Line 421: p_attribute3 IN iby_paymentcard.attribute3%TYPE,

417: p_inactive_date IN iby_paymentcard.inactive_date%TYPE,
418: p_attribute_category IN iby_paymentcard.attribute_category%TYPE,
419: p_attribute1 IN iby_paymentcard.attribute1%TYPE,
420: p_attribute2 IN iby_paymentcard.attribute2%TYPE,
421: p_attribute3 IN iby_paymentcard.attribute3%TYPE,
422: p_attribute4 IN iby_paymentcard.attribute4%TYPE,
423: p_attribute5 IN iby_paymentcard.attribute5%TYPE,
424: p_attribute6 IN iby_paymentcard.attribute6%TYPE,
425: p_attribute7 IN iby_paymentcard.attribute7%TYPE,

Line 422: p_attribute4 IN iby_paymentcard.attribute4%TYPE,

418: p_attribute_category IN iby_paymentcard.attribute_category%TYPE,
419: p_attribute1 IN iby_paymentcard.attribute1%TYPE,
420: p_attribute2 IN iby_paymentcard.attribute2%TYPE,
421: p_attribute3 IN iby_paymentcard.attribute3%TYPE,
422: p_attribute4 IN iby_paymentcard.attribute4%TYPE,
423: p_attribute5 IN iby_paymentcard.attribute5%TYPE,
424: p_attribute6 IN iby_paymentcard.attribute6%TYPE,
425: p_attribute7 IN iby_paymentcard.attribute7%TYPE,
426: p_attribute8 IN iby_paymentcard.attribute8%TYPE,

Line 423: p_attribute5 IN iby_paymentcard.attribute5%TYPE,

419: p_attribute1 IN iby_paymentcard.attribute1%TYPE,
420: p_attribute2 IN iby_paymentcard.attribute2%TYPE,
421: p_attribute3 IN iby_paymentcard.attribute3%TYPE,
422: p_attribute4 IN iby_paymentcard.attribute4%TYPE,
423: p_attribute5 IN iby_paymentcard.attribute5%TYPE,
424: p_attribute6 IN iby_paymentcard.attribute6%TYPE,
425: p_attribute7 IN iby_paymentcard.attribute7%TYPE,
426: p_attribute8 IN iby_paymentcard.attribute8%TYPE,
427: p_attribute9 IN iby_paymentcard.attribute9%TYPE,

Line 424: p_attribute6 IN iby_paymentcard.attribute6%TYPE,

420: p_attribute2 IN iby_paymentcard.attribute2%TYPE,
421: p_attribute3 IN iby_paymentcard.attribute3%TYPE,
422: p_attribute4 IN iby_paymentcard.attribute4%TYPE,
423: p_attribute5 IN iby_paymentcard.attribute5%TYPE,
424: p_attribute6 IN iby_paymentcard.attribute6%TYPE,
425: p_attribute7 IN iby_paymentcard.attribute7%TYPE,
426: p_attribute8 IN iby_paymentcard.attribute8%TYPE,
427: p_attribute9 IN iby_paymentcard.attribute9%TYPE,
428: p_attribute10 IN iby_paymentcard.attribute10%TYPE,

Line 425: p_attribute7 IN iby_paymentcard.attribute7%TYPE,

421: p_attribute3 IN iby_paymentcard.attribute3%TYPE,
422: p_attribute4 IN iby_paymentcard.attribute4%TYPE,
423: p_attribute5 IN iby_paymentcard.attribute5%TYPE,
424: p_attribute6 IN iby_paymentcard.attribute6%TYPE,
425: p_attribute7 IN iby_paymentcard.attribute7%TYPE,
426: p_attribute8 IN iby_paymentcard.attribute8%TYPE,
427: p_attribute9 IN iby_paymentcard.attribute9%TYPE,
428: p_attribute10 IN iby_paymentcard.attribute10%TYPE,
429: p_attribute11 IN iby_paymentcard.attribute11%TYPE,

Line 426: p_attribute8 IN iby_paymentcard.attribute8%TYPE,

422: p_attribute4 IN iby_paymentcard.attribute4%TYPE,
423: p_attribute5 IN iby_paymentcard.attribute5%TYPE,
424: p_attribute6 IN iby_paymentcard.attribute6%TYPE,
425: p_attribute7 IN iby_paymentcard.attribute7%TYPE,
426: p_attribute8 IN iby_paymentcard.attribute8%TYPE,
427: p_attribute9 IN iby_paymentcard.attribute9%TYPE,
428: p_attribute10 IN iby_paymentcard.attribute10%TYPE,
429: p_attribute11 IN iby_paymentcard.attribute11%TYPE,
430: p_attribute12 IN iby_paymentcard.attribute12%TYPE,

Line 427: p_attribute9 IN iby_paymentcard.attribute9%TYPE,

423: p_attribute5 IN iby_paymentcard.attribute5%TYPE,
424: p_attribute6 IN iby_paymentcard.attribute6%TYPE,
425: p_attribute7 IN iby_paymentcard.attribute7%TYPE,
426: p_attribute8 IN iby_paymentcard.attribute8%TYPE,
427: p_attribute9 IN iby_paymentcard.attribute9%TYPE,
428: p_attribute10 IN iby_paymentcard.attribute10%TYPE,
429: p_attribute11 IN iby_paymentcard.attribute11%TYPE,
430: p_attribute12 IN iby_paymentcard.attribute12%TYPE,
431: p_attribute13 IN iby_paymentcard.attribute13%TYPE,

Line 428: p_attribute10 IN iby_paymentcard.attribute10%TYPE,

424: p_attribute6 IN iby_paymentcard.attribute6%TYPE,
425: p_attribute7 IN iby_paymentcard.attribute7%TYPE,
426: p_attribute8 IN iby_paymentcard.attribute8%TYPE,
427: p_attribute9 IN iby_paymentcard.attribute9%TYPE,
428: p_attribute10 IN iby_paymentcard.attribute10%TYPE,
429: p_attribute11 IN iby_paymentcard.attribute11%TYPE,
430: p_attribute12 IN iby_paymentcard.attribute12%TYPE,
431: p_attribute13 IN iby_paymentcard.attribute13%TYPE,
432: p_attribute14 IN iby_paymentcard.attribute14%TYPE,

Line 429: p_attribute11 IN iby_paymentcard.attribute11%TYPE,

425: p_attribute7 IN iby_paymentcard.attribute7%TYPE,
426: p_attribute8 IN iby_paymentcard.attribute8%TYPE,
427: p_attribute9 IN iby_paymentcard.attribute9%TYPE,
428: p_attribute10 IN iby_paymentcard.attribute10%TYPE,
429: p_attribute11 IN iby_paymentcard.attribute11%TYPE,
430: p_attribute12 IN iby_paymentcard.attribute12%TYPE,
431: p_attribute13 IN iby_paymentcard.attribute13%TYPE,
432: p_attribute14 IN iby_paymentcard.attribute14%TYPE,
433: p_attribute15 IN iby_paymentcard.attribute15%TYPE,

Line 430: p_attribute12 IN iby_paymentcard.attribute12%TYPE,

426: p_attribute8 IN iby_paymentcard.attribute8%TYPE,
427: p_attribute9 IN iby_paymentcard.attribute9%TYPE,
428: p_attribute10 IN iby_paymentcard.attribute10%TYPE,
429: p_attribute11 IN iby_paymentcard.attribute11%TYPE,
430: p_attribute12 IN iby_paymentcard.attribute12%TYPE,
431: p_attribute13 IN iby_paymentcard.attribute13%TYPE,
432: p_attribute14 IN iby_paymentcard.attribute14%TYPE,
433: p_attribute15 IN iby_paymentcard.attribute15%TYPE,
434: x_result_code OUT NOCOPY VARCHAR2

Line 431: p_attribute13 IN iby_paymentcard.attribute13%TYPE,

427: p_attribute9 IN iby_paymentcard.attribute9%TYPE,
428: p_attribute10 IN iby_paymentcard.attribute10%TYPE,
429: p_attribute11 IN iby_paymentcard.attribute11%TYPE,
430: p_attribute12 IN iby_paymentcard.attribute12%TYPE,
431: p_attribute13 IN iby_paymentcard.attribute13%TYPE,
432: p_attribute14 IN iby_paymentcard.attribute14%TYPE,
433: p_attribute15 IN iby_paymentcard.attribute15%TYPE,
434: x_result_code OUT NOCOPY VARCHAR2
435: )

Line 432: p_attribute14 IN iby_paymentcard.attribute14%TYPE,

428: p_attribute10 IN iby_paymentcard.attribute10%TYPE,
429: p_attribute11 IN iby_paymentcard.attribute11%TYPE,
430: p_attribute12 IN iby_paymentcard.attribute12%TYPE,
431: p_attribute13 IN iby_paymentcard.attribute13%TYPE,
432: p_attribute14 IN iby_paymentcard.attribute14%TYPE,
433: p_attribute15 IN iby_paymentcard.attribute15%TYPE,
434: x_result_code OUT NOCOPY VARCHAR2
435: )
436: IS

Line 433: p_attribute15 IN iby_paymentcard.attribute15%TYPE,

429: p_attribute11 IN iby_paymentcard.attribute11%TYPE,
430: p_attribute12 IN iby_paymentcard.attribute12%TYPE,
431: p_attribute13 IN iby_paymentcard.attribute13%TYPE,
432: p_attribute14 IN iby_paymentcard.attribute14%TYPE,
433: p_attribute15 IN iby_paymentcard.attribute15%TYPE,
434: x_result_code OUT NOCOPY VARCHAR2
435: )
436: IS
437: l_billing_site NUMBER;

Line 438: l_expiry_date iby_paymentcard.expirydate%TYPE;

434: x_result_code OUT NOCOPY VARCHAR2
435: )
436: IS
437: l_billing_site NUMBER;
438: l_expiry_date iby_paymentcard.expirydate%TYPE;
439:
440:
441: l_msg_count NUMBER;
442: l_msg_data VARCHAR2(300);

Line 504: UPDATE iby_paymentcard

500: RETURN;
501: END IF;
502: END IF;
503:
504: UPDATE iby_paymentcard
505: SET chname = DECODE(p_holder_name, FND_API.G_MISS_CHAR,NULL, NULL,chname, p_holder_name),
506:
507: card_owner_id = NVL(card_owner_id,p_owner_id),
508: addressid = DECODE(l_billing_site, FND_API.G_MISS_NUM,NULL,

Line 579: l_info_only iby_paymentcard.information_only_flag%TYPE := NULL;

575: lx_result_code VARCHAR2(30);
576: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
577: lx_card_rec PaymentCard_rec_type;
578:
579: l_info_only iby_paymentcard.information_only_flag%TYPE := NULL;
580:
581: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || l_module;
582:
583:

Line 789: l_info_only iby_paymentcard.information_only_flag%TYPE := NULL;

785: l_prev_msg_count NUMBER;
786:
787: lx_result_code VARCHAR2(30);
788:
789: l_info_only iby_paymentcard.information_only_flag%TYPE := NULL;
790:
791: BEGIN
792: IF NOT FND_API.Compatible_API_Call (l_api_version,
793: p_api_version,

Line 908: l_card_number iby_paymentcard.card_number%TYPE;

904: (
905: p_commit IN VARCHAR2 := FND_API.G_TRUE
906: )
907: IS
908: l_card_number iby_paymentcard.card_number%TYPE;
909: lx_mask_digits iby_paymentcard.card_number%TYPE;
910: lx_mask_option iby_paymentcard.card_mask_setting%TYPE;
911: lx_unmask_len iby_paymentcard.card_unmask_length%TYPE;
912:

Line 909: lx_mask_digits iby_paymentcard.card_number%TYPE;

905: p_commit IN VARCHAR2 := FND_API.G_TRUE
906: )
907: IS
908: l_card_number iby_paymentcard.card_number%TYPE;
909: lx_mask_digits iby_paymentcard.card_number%TYPE;
910: lx_mask_option iby_paymentcard.card_mask_setting%TYPE;
911: lx_unmask_len iby_paymentcard.card_unmask_length%TYPE;
912:
913: CURSOR c_card

Line 910: lx_mask_option iby_paymentcard.card_mask_setting%TYPE;

906: )
907: IS
908: l_card_number iby_paymentcard.card_number%TYPE;
909: lx_mask_digits iby_paymentcard.card_number%TYPE;
910: lx_mask_option iby_paymentcard.card_mask_setting%TYPE;
911: lx_unmask_len iby_paymentcard.card_unmask_length%TYPE;
912:
913: CURSOR c_card
914: (ci_mask_option iby_paymentcard.card_mask_setting%TYPE,

Line 911: lx_unmask_len iby_paymentcard.card_unmask_length%TYPE;

907: IS
908: l_card_number iby_paymentcard.card_number%TYPE;
909: lx_mask_digits iby_paymentcard.card_number%TYPE;
910: lx_mask_option iby_paymentcard.card_mask_setting%TYPE;
911: lx_unmask_len iby_paymentcard.card_unmask_length%TYPE;
912:
913: CURSOR c_card
914: (ci_mask_option iby_paymentcard.card_mask_setting%TYPE,
915: ci_unmask_len iby_paymentcard.card_unmask_length%TYPE

Line 914: (ci_mask_option iby_paymentcard.card_mask_setting%TYPE,

910: lx_mask_option iby_paymentcard.card_mask_setting%TYPE;
911: lx_unmask_len iby_paymentcard.card_unmask_length%TYPE;
912:
913: CURSOR c_card
914: (ci_mask_option iby_paymentcard.card_mask_setting%TYPE,
915: ci_unmask_len iby_paymentcard.card_unmask_length%TYPE
916: )
917: IS
918: SELECT c.instrid, c.card_number,

Line 915: ci_unmask_len iby_paymentcard.card_unmask_length%TYPE

911: lx_unmask_len iby_paymentcard.card_unmask_length%TYPE;
912:
913: CURSOR c_card
914: (ci_mask_option iby_paymentcard.card_mask_setting%TYPE,
915: ci_unmask_len iby_paymentcard.card_unmask_length%TYPE
916: )
917: IS
918: SELECT c.instrid, c.card_number,
919: c.card_number_length card_len

Line 920: FROM iby_paymentcard c

916: )
917: IS
918: SELECT c.instrid, c.card_number,
919: c.card_number_length card_len
920: FROM iby_paymentcard c
921: WHERE ( (NVL(card_unmask_length,-1) <> ci_unmask_len) OR
922: (NVL(card_mask_setting,' ') <> ci_mask_option)
923: );
924: BEGIN

Line 931: UPDATE iby_paymentcard

927:
928: Get_Mask_Settings(lx_mask_option,lx_unmask_len);
929:
930: FOR c_card_rec IN c_card(lx_mask_option,lx_unmask_len) LOOP
931: UPDATE iby_paymentcard
932: SET
933: masked_card_number =
934: Mask_Card_Number(c_card_rec.card_number,lx_mask_option,lx_unmask_len),
935: card_mask_setting = lx_mask_option,

Line 951: (p_card_id IN iby_paymentcard.instrid%TYPE,

947: END Remask_Instruments;
948:
949:
950: PROCEDURE Query_Card
951: (p_card_id IN iby_paymentcard.instrid%TYPE,
952: x_owner_id OUT NOCOPY iby_paymentcard.card_owner_id%TYPE,
953: x_holder_name OUT NOCOPY iby_paymentcard.chname%TYPE,
954: x_billing_address_id OUT NOCOPY iby_paymentcard.addressid%TYPE,
955: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,

Line 952: x_owner_id OUT NOCOPY iby_paymentcard.card_owner_id%TYPE,

948:
949:
950: PROCEDURE Query_Card
951: (p_card_id IN iby_paymentcard.instrid%TYPE,
952: x_owner_id OUT NOCOPY iby_paymentcard.card_owner_id%TYPE,
953: x_holder_name OUT NOCOPY iby_paymentcard.chname%TYPE,
954: x_billing_address_id OUT NOCOPY iby_paymentcard.addressid%TYPE,
955: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
956: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,

Line 953: x_holder_name OUT NOCOPY iby_paymentcard.chname%TYPE,

949:
950: PROCEDURE Query_Card
951: (p_card_id IN iby_paymentcard.instrid%TYPE,
952: x_owner_id OUT NOCOPY iby_paymentcard.card_owner_id%TYPE,
953: x_holder_name OUT NOCOPY iby_paymentcard.chname%TYPE,
954: x_billing_address_id OUT NOCOPY iby_paymentcard.addressid%TYPE,
955: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
956: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
957: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,

Line 954: x_billing_address_id OUT NOCOPY iby_paymentcard.addressid%TYPE,

950: PROCEDURE Query_Card
951: (p_card_id IN iby_paymentcard.instrid%TYPE,
952: x_owner_id OUT NOCOPY iby_paymentcard.card_owner_id%TYPE,
953: x_holder_name OUT NOCOPY iby_paymentcard.chname%TYPE,
954: x_billing_address_id OUT NOCOPY iby_paymentcard.addressid%TYPE,
955: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
956: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
957: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
958: x_billing_city OUT NOCOPY hz_locations.city%TYPE,

Line 963: x_card_number OUT NOCOPY iby_paymentcard.card_number%TYPE,

959: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
960: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
961: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
962: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
963: x_card_number OUT NOCOPY iby_paymentcard.card_number%TYPE,
964: x_masked_card_number OUT NOCOPY iby_paymentcard.card_number%TYPE,
965: x_expiry_date OUT NOCOPY iby_paymentcard.expirydate%TYPE,
966: x_instr_type OUT NOCOPY iby_paymentcard.instrument_type%TYPE,
967: x_issuer OUT NOCOPY iby_paymentcard.card_issuer_code%TYPE,

Line 964: x_masked_card_number OUT NOCOPY iby_paymentcard.card_number%TYPE,

960: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
961: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
962: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
963: x_card_number OUT NOCOPY iby_paymentcard.card_number%TYPE,
964: x_masked_card_number OUT NOCOPY iby_paymentcard.card_number%TYPE,
965: x_expiry_date OUT NOCOPY iby_paymentcard.expirydate%TYPE,
966: x_instr_type OUT NOCOPY iby_paymentcard.instrument_type%TYPE,
967: x_issuer OUT NOCOPY iby_paymentcard.card_issuer_code%TYPE,
968: x_fi_name OUT NOCOPY iby_paymentcard.finame%TYPE,

Line 965: x_expiry_date OUT NOCOPY iby_paymentcard.expirydate%TYPE,

961: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
962: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
963: x_card_number OUT NOCOPY iby_paymentcard.card_number%TYPE,
964: x_masked_card_number OUT NOCOPY iby_paymentcard.card_number%TYPE,
965: x_expiry_date OUT NOCOPY iby_paymentcard.expirydate%TYPE,
966: x_instr_type OUT NOCOPY iby_paymentcard.instrument_type%TYPE,
967: x_issuer OUT NOCOPY iby_paymentcard.card_issuer_code%TYPE,
968: x_fi_name OUT NOCOPY iby_paymentcard.finame%TYPE,
969: x_single_use OUT NOCOPY iby_paymentcard.single_use_flag%TYPE,

Line 966: x_instr_type OUT NOCOPY iby_paymentcard.instrument_type%TYPE,

962: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
963: x_card_number OUT NOCOPY iby_paymentcard.card_number%TYPE,
964: x_masked_card_number OUT NOCOPY iby_paymentcard.card_number%TYPE,
965: x_expiry_date OUT NOCOPY iby_paymentcard.expirydate%TYPE,
966: x_instr_type OUT NOCOPY iby_paymentcard.instrument_type%TYPE,
967: x_issuer OUT NOCOPY iby_paymentcard.card_issuer_code%TYPE,
968: x_fi_name OUT NOCOPY iby_paymentcard.finame%TYPE,
969: x_single_use OUT NOCOPY iby_paymentcard.single_use_flag%TYPE,
970: x_info_only OUT NOCOPY iby_paymentcard.information_only_flag%TYPE,

Line 967: x_issuer OUT NOCOPY iby_paymentcard.card_issuer_code%TYPE,

963: x_card_number OUT NOCOPY iby_paymentcard.card_number%TYPE,
964: x_masked_card_number OUT NOCOPY iby_paymentcard.card_number%TYPE,
965: x_expiry_date OUT NOCOPY iby_paymentcard.expirydate%TYPE,
966: x_instr_type OUT NOCOPY iby_paymentcard.instrument_type%TYPE,
967: x_issuer OUT NOCOPY iby_paymentcard.card_issuer_code%TYPE,
968: x_fi_name OUT NOCOPY iby_paymentcard.finame%TYPE,
969: x_single_use OUT NOCOPY iby_paymentcard.single_use_flag%TYPE,
970: x_info_only OUT NOCOPY iby_paymentcard.information_only_flag%TYPE,
971: x_purpose OUT NOCOPY iby_paymentcard.card_purpose%TYPE,

Line 968: x_fi_name OUT NOCOPY iby_paymentcard.finame%TYPE,

964: x_masked_card_number OUT NOCOPY iby_paymentcard.card_number%TYPE,
965: x_expiry_date OUT NOCOPY iby_paymentcard.expirydate%TYPE,
966: x_instr_type OUT NOCOPY iby_paymentcard.instrument_type%TYPE,
967: x_issuer OUT NOCOPY iby_paymentcard.card_issuer_code%TYPE,
968: x_fi_name OUT NOCOPY iby_paymentcard.finame%TYPE,
969: x_single_use OUT NOCOPY iby_paymentcard.single_use_flag%TYPE,
970: x_info_only OUT NOCOPY iby_paymentcard.information_only_flag%TYPE,
971: x_purpose OUT NOCOPY iby_paymentcard.card_purpose%TYPE,
972: x_desc OUT NOCOPY iby_paymentcard.description%TYPE,

Line 969: x_single_use OUT NOCOPY iby_paymentcard.single_use_flag%TYPE,

965: x_expiry_date OUT NOCOPY iby_paymentcard.expirydate%TYPE,
966: x_instr_type OUT NOCOPY iby_paymentcard.instrument_type%TYPE,
967: x_issuer OUT NOCOPY iby_paymentcard.card_issuer_code%TYPE,
968: x_fi_name OUT NOCOPY iby_paymentcard.finame%TYPE,
969: x_single_use OUT NOCOPY iby_paymentcard.single_use_flag%TYPE,
970: x_info_only OUT NOCOPY iby_paymentcard.information_only_flag%TYPE,
971: x_purpose OUT NOCOPY iby_paymentcard.card_purpose%TYPE,
972: x_desc OUT NOCOPY iby_paymentcard.description%TYPE,
973: x_active_flag OUT NOCOPY iby_paymentcard.active_flag%TYPE,

Line 970: x_info_only OUT NOCOPY iby_paymentcard.information_only_flag%TYPE,

966: x_instr_type OUT NOCOPY iby_paymentcard.instrument_type%TYPE,
967: x_issuer OUT NOCOPY iby_paymentcard.card_issuer_code%TYPE,
968: x_fi_name OUT NOCOPY iby_paymentcard.finame%TYPE,
969: x_single_use OUT NOCOPY iby_paymentcard.single_use_flag%TYPE,
970: x_info_only OUT NOCOPY iby_paymentcard.information_only_flag%TYPE,
971: x_purpose OUT NOCOPY iby_paymentcard.card_purpose%TYPE,
972: x_desc OUT NOCOPY iby_paymentcard.description%TYPE,
973: x_active_flag OUT NOCOPY iby_paymentcard.active_flag%TYPE,
974: x_inactive_date OUT NOCOPY iby_paymentcard.inactive_date%TYPE,

Line 971: x_purpose OUT NOCOPY iby_paymentcard.card_purpose%TYPE,

967: x_issuer OUT NOCOPY iby_paymentcard.card_issuer_code%TYPE,
968: x_fi_name OUT NOCOPY iby_paymentcard.finame%TYPE,
969: x_single_use OUT NOCOPY iby_paymentcard.single_use_flag%TYPE,
970: x_info_only OUT NOCOPY iby_paymentcard.information_only_flag%TYPE,
971: x_purpose OUT NOCOPY iby_paymentcard.card_purpose%TYPE,
972: x_desc OUT NOCOPY iby_paymentcard.description%TYPE,
973: x_active_flag OUT NOCOPY iby_paymentcard.active_flag%TYPE,
974: x_inactive_date OUT NOCOPY iby_paymentcard.inactive_date%TYPE,
975: x_result_code OUT NOCOPY VARCHAR2

Line 972: x_desc OUT NOCOPY iby_paymentcard.description%TYPE,

968: x_fi_name OUT NOCOPY iby_paymentcard.finame%TYPE,
969: x_single_use OUT NOCOPY iby_paymentcard.single_use_flag%TYPE,
970: x_info_only OUT NOCOPY iby_paymentcard.information_only_flag%TYPE,
971: x_purpose OUT NOCOPY iby_paymentcard.card_purpose%TYPE,
972: x_desc OUT NOCOPY iby_paymentcard.description%TYPE,
973: x_active_flag OUT NOCOPY iby_paymentcard.active_flag%TYPE,
974: x_inactive_date OUT NOCOPY iby_paymentcard.inactive_date%TYPE,
975: x_result_code OUT NOCOPY VARCHAR2
976: )

Line 973: x_active_flag OUT NOCOPY iby_paymentcard.active_flag%TYPE,

969: x_single_use OUT NOCOPY iby_paymentcard.single_use_flag%TYPE,
970: x_info_only OUT NOCOPY iby_paymentcard.information_only_flag%TYPE,
971: x_purpose OUT NOCOPY iby_paymentcard.card_purpose%TYPE,
972: x_desc OUT NOCOPY iby_paymentcard.description%TYPE,
973: x_active_flag OUT NOCOPY iby_paymentcard.active_flag%TYPE,
974: x_inactive_date OUT NOCOPY iby_paymentcard.inactive_date%TYPE,
975: x_result_code OUT NOCOPY VARCHAR2
976: )
977: IS

Line 974: x_inactive_date OUT NOCOPY iby_paymentcard.inactive_date%TYPE,

970: x_info_only OUT NOCOPY iby_paymentcard.information_only_flag%TYPE,
971: x_purpose OUT NOCOPY iby_paymentcard.card_purpose%TYPE,
972: x_desc OUT NOCOPY iby_paymentcard.description%TYPE,
973: x_active_flag OUT NOCOPY iby_paymentcard.active_flag%TYPE,
974: x_inactive_date OUT NOCOPY iby_paymentcard.inactive_date%TYPE,
975: x_result_code OUT NOCOPY VARCHAR2
976: )
977: IS
978:

Line 982: CURSOR c_paymentcard(ci_instr_id iby_paymentcard.instrid%TYPE)

978:
979: l_err_code VARCHAR2(200);
980: l_instr_found BOOLEAN;
981:
982: CURSOR c_paymentcard(ci_instr_id iby_paymentcard.instrid%TYPE)
983: IS
984: SELECT
985: c.card_owner_id, c.chname, c.addressid,
986: l.address1, l.address2, l.address3, l.city, l.county,

Line 992: FROM iby_paymentcard c, hz_party_site_uses su, hz_party_sites s,

988: c.card_number, c.masked_card_number, c.expirydate, c.instrument_type,
989: c.card_issuer_code, c.finame,
990: c.single_use_flag, c.information_only_flag, c.card_purpose,
991: c.description, c.active_flag, c.inactive_date
992: FROM iby_paymentcard c, hz_party_site_uses su, hz_party_sites s,
993: hz_locations l
994: WHERE (instrid = ci_instr_id)
995: AND (c.addressid = su.party_site_use_id(+))
996: AND (su.party_site_id = s.party_site_id(+))

Line 1042: l_card_id iby_paymentcard.instrid%TYPE;

1038: l_api_version CONSTANT NUMBER := 1.0;
1039: l_module CONSTANT VARCHAR2(30) := 'Card_Exists';
1040: l_prev_msg_count NUMBER;
1041:
1042: l_card_id iby_paymentcard.instrid%TYPE;
1043:
1044: l_char_allowed VARCHAR2(1) := 'N';
1045: lx_return_status VARCHAR2(1);
1046: lx_msg_count NUMBER;

Line 1048: lx_card_number iby_paymentcard.card_number%TYPE;

1044: l_char_allowed VARCHAR2(1) := 'N';
1045: lx_return_status VARCHAR2(1);
1046: lx_msg_count NUMBER;
1047: lx_msg_data VARCHAR2(200);
1048: lx_card_number iby_paymentcard.card_number%TYPE;
1049: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1050:
1051: CURSOR p_card
1052: (pi_card_owner IN iby_paymentcard.card_owner_id%TYPE

Line 1052: (pi_card_owner IN iby_paymentcard.card_owner_id%TYPE

1048: lx_card_number iby_paymentcard.card_number%TYPE;
1049: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1050:
1051: CURSOR p_card
1052: (pi_card_owner IN iby_paymentcard.card_owner_id%TYPE
1053: )
1054: IS
1055: SELECT instrid
1056: FROM iby_paymentcard

Line 1056: FROM iby_paymentcard

1052: (pi_card_owner IN iby_paymentcard.card_owner_id%TYPE
1053: )
1054: IS
1055: SELECT instrid
1056: FROM iby_paymentcard
1057: WHERE ( (card_owner_id = NVL(pi_card_owner,card_owner_id))
1058: OR (card_owner_id IS NULL AND pi_card_owner IS NULL) )
1059: AND (NVL(single_use_flag,'N')='N');
1060: BEGIN

Line 1174: CURSOR p_card(pi_card_id IN iby_paymentcard.instrid%TYPE)

1170: l_prev_msg_count NUMBER;
1171:
1172: l_card_count NUMBER;
1173:
1174: CURSOR p_card(pi_card_id IN iby_paymentcard.instrid%TYPE)
1175: IS
1176: SELECT card_owner_id, chname, addressid, masked_card_number, expirydate,
1177: instrument_type,
1178: card_issuer_code, finame, single_use_flag,

Line 1180: FROM iby_paymentcard

1176: SELECT card_owner_id, chname, addressid, masked_card_number, expirydate,
1177: instrument_type,
1178: card_issuer_code, finame, single_use_flag,
1179: information_only_flag, card_purpose, description, inactive_date
1180: FROM iby_paymentcard
1181: WHERE (instrid = pi_card_id);
1182: BEGIN
1183: IF (p_card%ISOPEN) THEN
1184: CLOSE p_card;

Line 1269: END iby_paymentcard_pkg;

1265: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1266: module => G_DEBUG_MODULE || l_module);
1267: END Get_Card;
1268:
1269: END iby_paymentcard_pkg;