DBA Data[Home] [Help]

APPS.IBY_CREDITCARD_PKG dependencies on HZ_LOCATIONS

Line 237: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,

233: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
234: x_owner_id OUT NOCOPY iby_creditcard.card_owner_id%TYPE,
235: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,
236: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
237: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
238: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
239: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
240: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
241: x_billing_county OUT NOCOPY hz_locations.county%TYPE,

Line 238: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,

234: x_owner_id OUT NOCOPY iby_creditcard.card_owner_id%TYPE,
235: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,
236: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
237: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
238: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
239: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
240: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
241: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
242: x_billing_state OUT NOCOPY hz_locations.state%TYPE,

Line 239: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,

235: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,
236: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
237: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
238: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
239: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
240: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
241: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
242: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
243: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,

Line 240: x_billing_city OUT NOCOPY hz_locations.city%TYPE,

236: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
237: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
238: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
239: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
240: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
241: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
242: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
243: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
244: x_billing_country OUT NOCOPY hz_locations.country%TYPE,

Line 241: x_billing_county OUT NOCOPY hz_locations.county%TYPE,

237: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
238: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
239: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
240: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
241: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
242: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
243: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
244: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
245: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,

Line 242: x_billing_state OUT NOCOPY hz_locations.state%TYPE,

238: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
239: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
240: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
241: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
242: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
243: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
244: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
245: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,
246: x_expiry_date OUT NOCOPY iby_creditcard.expirydate%TYPE,

Line 243: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,

239: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
240: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
241: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
242: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
243: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
244: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
245: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,
246: x_expiry_date OUT NOCOPY iby_creditcard.expirydate%TYPE,
247: x_instr_type OUT NOCOPY iby_creditcard.instrument_type%TYPE,

Line 244: x_billing_country OUT NOCOPY hz_locations.country%TYPE,

240: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
241: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
242: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
243: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
244: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
245: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,
246: x_expiry_date OUT NOCOPY iby_creditcard.expirydate%TYPE,
247: x_instr_type OUT NOCOPY iby_creditcard.instrument_type%TYPE,
248: x_pcard_flag OUT NOCOPY iby_creditcard.purchasecard_flag%TYPE,

Line 268: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,

264: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
265: x_owner_id OUT NOCOPY iby_creditcard.card_owner_id%TYPE,
266: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,
267: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
268: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
269: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
270: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
271: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
272: x_billing_county OUT NOCOPY hz_locations.county%TYPE,

Line 269: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,

265: x_owner_id OUT NOCOPY iby_creditcard.card_owner_id%TYPE,
266: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,
267: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
268: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
269: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
270: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
271: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
272: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
273: x_billing_state OUT NOCOPY hz_locations.state%TYPE,

Line 270: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,

266: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,
267: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
268: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
269: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
270: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
271: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
272: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
273: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
274: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,

Line 271: x_billing_city OUT NOCOPY hz_locations.city%TYPE,

267: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
268: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
269: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
270: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
271: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
272: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
273: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
274: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
275: x_billing_country OUT NOCOPY hz_locations.country%TYPE,

Line 272: x_billing_county OUT NOCOPY hz_locations.county%TYPE,

268: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
269: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
270: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
271: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
272: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
273: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
274: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
275: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
276: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,

Line 273: x_billing_state OUT NOCOPY hz_locations.state%TYPE,

269: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
270: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
271: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
272: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
273: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
274: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
275: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
276: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,
277: x_expiry_date OUT NOCOPY iby_creditcard.expirydate%TYPE,

Line 274: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,

270: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
271: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
272: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
273: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
274: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
275: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
276: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,
277: x_expiry_date OUT NOCOPY iby_creditcard.expirydate%TYPE,
278: x_instr_type OUT NOCOPY iby_creditcard.instrument_type%TYPE,

Line 275: x_billing_country OUT NOCOPY hz_locations.country%TYPE,

271: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
272: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
273: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
274: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
275: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
276: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,
277: x_expiry_date OUT NOCOPY iby_creditcard.expirydate%TYPE,
278: x_instr_type OUT NOCOPY iby_creditcard.instrument_type%TYPE,
279: x_pcard_flag OUT NOCOPY iby_creditcard.purchasecard_flag%TYPE,

Line 290: x_province OUT NOCOPY hz_locations.country%TYPE

286: x_desc OUT NOCOPY iby_creditcard.description%TYPE,
287: x_active_flag OUT NOCOPY iby_creditcard.active_flag%TYPE,
288: x_inactive_date OUT NOCOPY iby_creditcard.inactive_date%TYPE,
289: x_result_code OUT NOCOPY VARCHAR2,
290: x_province OUT NOCOPY hz_locations.country%TYPE
291: );
292:
293:
294: --