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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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: --