DBA Data[Home] [Help]

APPS.IBY_PAYMENTCARD_PKG dependencies on IBY_PAYMENTCARD_S

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