DBA Data[Home] [Help]

APPS.IBY_FNDCPT_SETUP_PUB dependencies on IBY_CREDITCARD

Line 521: p_instr_id IN iby_creditcard.instrid%TYPE,

517: -- Initial version : 1.0
518: PROCEDURE Update_Card_Wrapper
519: (
520: p_commit IN VARCHAR2,
521: p_instr_id IN iby_creditcard.instrid%TYPE,
522: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
523: p_holder_name IN iby_creditcard.chname%TYPE,
524: p_billing_address_id IN iby_creditcard.addressid%TYPE,
525: p_address_type IN VARCHAR2,

Line 522: p_owner_id IN iby_creditcard.card_owner_id%TYPE,

518: PROCEDURE Update_Card_Wrapper
519: (
520: p_commit IN VARCHAR2,
521: p_instr_id IN iby_creditcard.instrid%TYPE,
522: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
523: p_holder_name IN iby_creditcard.chname%TYPE,
524: p_billing_address_id IN iby_creditcard.addressid%TYPE,
525: p_address_type IN VARCHAR2,
526: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,

Line 523: p_holder_name IN iby_creditcard.chname%TYPE,

519: (
520: p_commit IN VARCHAR2,
521: p_instr_id IN iby_creditcard.instrid%TYPE,
522: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
523: p_holder_name IN iby_creditcard.chname%TYPE,
524: p_billing_address_id IN iby_creditcard.addressid%TYPE,
525: p_address_type IN VARCHAR2,
526: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
527: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,

Line 524: p_billing_address_id IN iby_creditcard.addressid%TYPE,

520: p_commit IN VARCHAR2,
521: p_instr_id IN iby_creditcard.instrid%TYPE,
522: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
523: p_holder_name IN iby_creditcard.chname%TYPE,
524: p_billing_address_id IN iby_creditcard.addressid%TYPE,
525: p_address_type IN VARCHAR2,
526: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
527: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
528: p_expiry_date IN iby_creditcard.expirydate%TYPE,

Line 526: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,

522: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
523: p_holder_name IN iby_creditcard.chname%TYPE,
524: p_billing_address_id IN iby_creditcard.addressid%TYPE,
525: p_address_type IN VARCHAR2,
526: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
527: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
528: p_expiry_date IN iby_creditcard.expirydate%TYPE,
529: p_instr_type IN iby_creditcard.instrument_type%TYPE,
530: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,

Line 527: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,

523: p_holder_name IN iby_creditcard.chname%TYPE,
524: p_billing_address_id IN iby_creditcard.addressid%TYPE,
525: p_address_type IN VARCHAR2,
526: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
527: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
528: p_expiry_date IN iby_creditcard.expirydate%TYPE,
529: p_instr_type IN iby_creditcard.instrument_type%TYPE,
530: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
531: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,

Line 528: p_expiry_date IN iby_creditcard.expirydate%TYPE,

524: p_billing_address_id IN iby_creditcard.addressid%TYPE,
525: p_address_type IN VARCHAR2,
526: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
527: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
528: p_expiry_date IN iby_creditcard.expirydate%TYPE,
529: p_instr_type IN iby_creditcard.instrument_type%TYPE,
530: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
531: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
532: p_fi_name IN iby_creditcard.finame%TYPE,

Line 529: p_instr_type IN iby_creditcard.instrument_type%TYPE,

525: p_address_type IN VARCHAR2,
526: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
527: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
528: p_expiry_date IN iby_creditcard.expirydate%TYPE,
529: p_instr_type IN iby_creditcard.instrument_type%TYPE,
530: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
531: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
532: p_fi_name IN iby_creditcard.finame%TYPE,
533: p_single_use IN iby_creditcard.single_use_flag%TYPE,

Line 530: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,

526: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
527: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
528: p_expiry_date IN iby_creditcard.expirydate%TYPE,
529: p_instr_type IN iby_creditcard.instrument_type%TYPE,
530: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
531: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
532: p_fi_name IN iby_creditcard.finame%TYPE,
533: p_single_use IN iby_creditcard.single_use_flag%TYPE,
534: p_info_only IN iby_creditcard.information_only_flag%TYPE,

Line 531: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,

527: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
528: p_expiry_date IN iby_creditcard.expirydate%TYPE,
529: p_instr_type IN iby_creditcard.instrument_type%TYPE,
530: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
531: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
532: p_fi_name IN iby_creditcard.finame%TYPE,
533: p_single_use IN iby_creditcard.single_use_flag%TYPE,
534: p_info_only IN iby_creditcard.information_only_flag%TYPE,
535: p_purpose IN iby_creditcard.card_purpose%TYPE,

Line 532: p_fi_name IN iby_creditcard.finame%TYPE,

528: p_expiry_date IN iby_creditcard.expirydate%TYPE,
529: p_instr_type IN iby_creditcard.instrument_type%TYPE,
530: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
531: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
532: p_fi_name IN iby_creditcard.finame%TYPE,
533: p_single_use IN iby_creditcard.single_use_flag%TYPE,
534: p_info_only IN iby_creditcard.information_only_flag%TYPE,
535: p_purpose IN iby_creditcard.card_purpose%TYPE,
536: p_desc IN iby_creditcard.description%TYPE,

Line 533: p_single_use IN iby_creditcard.single_use_flag%TYPE,

529: p_instr_type IN iby_creditcard.instrument_type%TYPE,
530: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
531: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
532: p_fi_name IN iby_creditcard.finame%TYPE,
533: p_single_use IN iby_creditcard.single_use_flag%TYPE,
534: p_info_only IN iby_creditcard.information_only_flag%TYPE,
535: p_purpose IN iby_creditcard.card_purpose%TYPE,
536: p_desc IN iby_creditcard.description%TYPE,
537: p_active_flag IN iby_creditcard.active_flag%TYPE,

Line 534: p_info_only IN iby_creditcard.information_only_flag%TYPE,

530: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
531: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
532: p_fi_name IN iby_creditcard.finame%TYPE,
533: p_single_use IN iby_creditcard.single_use_flag%TYPE,
534: p_info_only IN iby_creditcard.information_only_flag%TYPE,
535: p_purpose IN iby_creditcard.card_purpose%TYPE,
536: p_desc IN iby_creditcard.description%TYPE,
537: p_active_flag IN iby_creditcard.active_flag%TYPE,
538: p_inactive_date IN iby_creditcard.inactive_date%TYPE,

Line 535: p_purpose IN iby_creditcard.card_purpose%TYPE,

531: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
532: p_fi_name IN iby_creditcard.finame%TYPE,
533: p_single_use IN iby_creditcard.single_use_flag%TYPE,
534: p_info_only IN iby_creditcard.information_only_flag%TYPE,
535: p_purpose IN iby_creditcard.card_purpose%TYPE,
536: p_desc IN iby_creditcard.description%TYPE,
537: p_active_flag IN iby_creditcard.active_flag%TYPE,
538: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
539: p_attribute_category IN iby_creditcard.attribute_category%TYPE,

Line 536: p_desc IN iby_creditcard.description%TYPE,

532: p_fi_name IN iby_creditcard.finame%TYPE,
533: p_single_use IN iby_creditcard.single_use_flag%TYPE,
534: p_info_only IN iby_creditcard.information_only_flag%TYPE,
535: p_purpose IN iby_creditcard.card_purpose%TYPE,
536: p_desc IN iby_creditcard.description%TYPE,
537: p_active_flag IN iby_creditcard.active_flag%TYPE,
538: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
539: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
540: p_attribute1 IN iby_creditcard.attribute1%TYPE,

Line 537: p_active_flag IN iby_creditcard.active_flag%TYPE,

533: p_single_use IN iby_creditcard.single_use_flag%TYPE,
534: p_info_only IN iby_creditcard.information_only_flag%TYPE,
535: p_purpose IN iby_creditcard.card_purpose%TYPE,
536: p_desc IN iby_creditcard.description%TYPE,
537: p_active_flag IN iby_creditcard.active_flag%TYPE,
538: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
539: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
540: p_attribute1 IN iby_creditcard.attribute1%TYPE,
541: p_attribute2 IN iby_creditcard.attribute2%TYPE,

Line 538: p_inactive_date IN iby_creditcard.inactive_date%TYPE,

534: p_info_only IN iby_creditcard.information_only_flag%TYPE,
535: p_purpose IN iby_creditcard.card_purpose%TYPE,
536: p_desc IN iby_creditcard.description%TYPE,
537: p_active_flag IN iby_creditcard.active_flag%TYPE,
538: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
539: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
540: p_attribute1 IN iby_creditcard.attribute1%TYPE,
541: p_attribute2 IN iby_creditcard.attribute2%TYPE,
542: p_attribute3 IN iby_creditcard.attribute3%TYPE,

Line 539: p_attribute_category IN iby_creditcard.attribute_category%TYPE,

535: p_purpose IN iby_creditcard.card_purpose%TYPE,
536: p_desc IN iby_creditcard.description%TYPE,
537: p_active_flag IN iby_creditcard.active_flag%TYPE,
538: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
539: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
540: p_attribute1 IN iby_creditcard.attribute1%TYPE,
541: p_attribute2 IN iby_creditcard.attribute2%TYPE,
542: p_attribute3 IN iby_creditcard.attribute3%TYPE,
543: p_attribute4 IN iby_creditcard.attribute4%TYPE,

Line 540: p_attribute1 IN iby_creditcard.attribute1%TYPE,

536: p_desc IN iby_creditcard.description%TYPE,
537: p_active_flag IN iby_creditcard.active_flag%TYPE,
538: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
539: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
540: p_attribute1 IN iby_creditcard.attribute1%TYPE,
541: p_attribute2 IN iby_creditcard.attribute2%TYPE,
542: p_attribute3 IN iby_creditcard.attribute3%TYPE,
543: p_attribute4 IN iby_creditcard.attribute4%TYPE,
544: p_attribute5 IN iby_creditcard.attribute5%TYPE,

Line 541: p_attribute2 IN iby_creditcard.attribute2%TYPE,

537: p_active_flag IN iby_creditcard.active_flag%TYPE,
538: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
539: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
540: p_attribute1 IN iby_creditcard.attribute1%TYPE,
541: p_attribute2 IN iby_creditcard.attribute2%TYPE,
542: p_attribute3 IN iby_creditcard.attribute3%TYPE,
543: p_attribute4 IN iby_creditcard.attribute4%TYPE,
544: p_attribute5 IN iby_creditcard.attribute5%TYPE,
545: p_attribute6 IN iby_creditcard.attribute6%TYPE,

Line 542: p_attribute3 IN iby_creditcard.attribute3%TYPE,

538: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
539: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
540: p_attribute1 IN iby_creditcard.attribute1%TYPE,
541: p_attribute2 IN iby_creditcard.attribute2%TYPE,
542: p_attribute3 IN iby_creditcard.attribute3%TYPE,
543: p_attribute4 IN iby_creditcard.attribute4%TYPE,
544: p_attribute5 IN iby_creditcard.attribute5%TYPE,
545: p_attribute6 IN iby_creditcard.attribute6%TYPE,
546: p_attribute7 IN iby_creditcard.attribute7%TYPE,

Line 543: p_attribute4 IN iby_creditcard.attribute4%TYPE,

539: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
540: p_attribute1 IN iby_creditcard.attribute1%TYPE,
541: p_attribute2 IN iby_creditcard.attribute2%TYPE,
542: p_attribute3 IN iby_creditcard.attribute3%TYPE,
543: p_attribute4 IN iby_creditcard.attribute4%TYPE,
544: p_attribute5 IN iby_creditcard.attribute5%TYPE,
545: p_attribute6 IN iby_creditcard.attribute6%TYPE,
546: p_attribute7 IN iby_creditcard.attribute7%TYPE,
547: p_attribute8 IN iby_creditcard.attribute8%TYPE,

Line 544: p_attribute5 IN iby_creditcard.attribute5%TYPE,

540: p_attribute1 IN iby_creditcard.attribute1%TYPE,
541: p_attribute2 IN iby_creditcard.attribute2%TYPE,
542: p_attribute3 IN iby_creditcard.attribute3%TYPE,
543: p_attribute4 IN iby_creditcard.attribute4%TYPE,
544: p_attribute5 IN iby_creditcard.attribute5%TYPE,
545: p_attribute6 IN iby_creditcard.attribute6%TYPE,
546: p_attribute7 IN iby_creditcard.attribute7%TYPE,
547: p_attribute8 IN iby_creditcard.attribute8%TYPE,
548: p_attribute9 IN iby_creditcard.attribute9%TYPE,

Line 545: p_attribute6 IN iby_creditcard.attribute6%TYPE,

541: p_attribute2 IN iby_creditcard.attribute2%TYPE,
542: p_attribute3 IN iby_creditcard.attribute3%TYPE,
543: p_attribute4 IN iby_creditcard.attribute4%TYPE,
544: p_attribute5 IN iby_creditcard.attribute5%TYPE,
545: p_attribute6 IN iby_creditcard.attribute6%TYPE,
546: p_attribute7 IN iby_creditcard.attribute7%TYPE,
547: p_attribute8 IN iby_creditcard.attribute8%TYPE,
548: p_attribute9 IN iby_creditcard.attribute9%TYPE,
549: p_attribute10 IN iby_creditcard.attribute10%TYPE,

Line 546: p_attribute7 IN iby_creditcard.attribute7%TYPE,

542: p_attribute3 IN iby_creditcard.attribute3%TYPE,
543: p_attribute4 IN iby_creditcard.attribute4%TYPE,
544: p_attribute5 IN iby_creditcard.attribute5%TYPE,
545: p_attribute6 IN iby_creditcard.attribute6%TYPE,
546: p_attribute7 IN iby_creditcard.attribute7%TYPE,
547: p_attribute8 IN iby_creditcard.attribute8%TYPE,
548: p_attribute9 IN iby_creditcard.attribute9%TYPE,
549: p_attribute10 IN iby_creditcard.attribute10%TYPE,
550: p_attribute11 IN iby_creditcard.attribute11%TYPE,

Line 547: p_attribute8 IN iby_creditcard.attribute8%TYPE,

543: p_attribute4 IN iby_creditcard.attribute4%TYPE,
544: p_attribute5 IN iby_creditcard.attribute5%TYPE,
545: p_attribute6 IN iby_creditcard.attribute6%TYPE,
546: p_attribute7 IN iby_creditcard.attribute7%TYPE,
547: p_attribute8 IN iby_creditcard.attribute8%TYPE,
548: p_attribute9 IN iby_creditcard.attribute9%TYPE,
549: p_attribute10 IN iby_creditcard.attribute10%TYPE,
550: p_attribute11 IN iby_creditcard.attribute11%TYPE,
551: p_attribute12 IN iby_creditcard.attribute12%TYPE,

Line 548: p_attribute9 IN iby_creditcard.attribute9%TYPE,

544: p_attribute5 IN iby_creditcard.attribute5%TYPE,
545: p_attribute6 IN iby_creditcard.attribute6%TYPE,
546: p_attribute7 IN iby_creditcard.attribute7%TYPE,
547: p_attribute8 IN iby_creditcard.attribute8%TYPE,
548: p_attribute9 IN iby_creditcard.attribute9%TYPE,
549: p_attribute10 IN iby_creditcard.attribute10%TYPE,
550: p_attribute11 IN iby_creditcard.attribute11%TYPE,
551: p_attribute12 IN iby_creditcard.attribute12%TYPE,
552: p_attribute13 IN iby_creditcard.attribute13%TYPE,

Line 549: p_attribute10 IN iby_creditcard.attribute10%TYPE,

545: p_attribute6 IN iby_creditcard.attribute6%TYPE,
546: p_attribute7 IN iby_creditcard.attribute7%TYPE,
547: p_attribute8 IN iby_creditcard.attribute8%TYPE,
548: p_attribute9 IN iby_creditcard.attribute9%TYPE,
549: p_attribute10 IN iby_creditcard.attribute10%TYPE,
550: p_attribute11 IN iby_creditcard.attribute11%TYPE,
551: p_attribute12 IN iby_creditcard.attribute12%TYPE,
552: p_attribute13 IN iby_creditcard.attribute13%TYPE,
553: p_attribute14 IN iby_creditcard.attribute14%TYPE,

Line 550: p_attribute11 IN iby_creditcard.attribute11%TYPE,

546: p_attribute7 IN iby_creditcard.attribute7%TYPE,
547: p_attribute8 IN iby_creditcard.attribute8%TYPE,
548: p_attribute9 IN iby_creditcard.attribute9%TYPE,
549: p_attribute10 IN iby_creditcard.attribute10%TYPE,
550: p_attribute11 IN iby_creditcard.attribute11%TYPE,
551: p_attribute12 IN iby_creditcard.attribute12%TYPE,
552: p_attribute13 IN iby_creditcard.attribute13%TYPE,
553: p_attribute14 IN iby_creditcard.attribute14%TYPE,
554: p_attribute15 IN iby_creditcard.attribute15%TYPE,

Line 551: p_attribute12 IN iby_creditcard.attribute12%TYPE,

547: p_attribute8 IN iby_creditcard.attribute8%TYPE,
548: p_attribute9 IN iby_creditcard.attribute9%TYPE,
549: p_attribute10 IN iby_creditcard.attribute10%TYPE,
550: p_attribute11 IN iby_creditcard.attribute11%TYPE,
551: p_attribute12 IN iby_creditcard.attribute12%TYPE,
552: p_attribute13 IN iby_creditcard.attribute13%TYPE,
553: p_attribute14 IN iby_creditcard.attribute14%TYPE,
554: p_attribute15 IN iby_creditcard.attribute15%TYPE,
555: p_attribute16 IN iby_creditcard.attribute16%TYPE,

Line 552: p_attribute13 IN iby_creditcard.attribute13%TYPE,

548: p_attribute9 IN iby_creditcard.attribute9%TYPE,
549: p_attribute10 IN iby_creditcard.attribute10%TYPE,
550: p_attribute11 IN iby_creditcard.attribute11%TYPE,
551: p_attribute12 IN iby_creditcard.attribute12%TYPE,
552: p_attribute13 IN iby_creditcard.attribute13%TYPE,
553: p_attribute14 IN iby_creditcard.attribute14%TYPE,
554: p_attribute15 IN iby_creditcard.attribute15%TYPE,
555: p_attribute16 IN iby_creditcard.attribute16%TYPE,
556: p_attribute17 IN iby_creditcard.attribute17%TYPE,

Line 553: p_attribute14 IN iby_creditcard.attribute14%TYPE,

549: p_attribute10 IN iby_creditcard.attribute10%TYPE,
550: p_attribute11 IN iby_creditcard.attribute11%TYPE,
551: p_attribute12 IN iby_creditcard.attribute12%TYPE,
552: p_attribute13 IN iby_creditcard.attribute13%TYPE,
553: p_attribute14 IN iby_creditcard.attribute14%TYPE,
554: p_attribute15 IN iby_creditcard.attribute15%TYPE,
555: p_attribute16 IN iby_creditcard.attribute16%TYPE,
556: p_attribute17 IN iby_creditcard.attribute17%TYPE,
557: p_attribute18 IN iby_creditcard.attribute18%TYPE,

Line 554: p_attribute15 IN iby_creditcard.attribute15%TYPE,

550: p_attribute11 IN iby_creditcard.attribute11%TYPE,
551: p_attribute12 IN iby_creditcard.attribute12%TYPE,
552: p_attribute13 IN iby_creditcard.attribute13%TYPE,
553: p_attribute14 IN iby_creditcard.attribute14%TYPE,
554: p_attribute15 IN iby_creditcard.attribute15%TYPE,
555: p_attribute16 IN iby_creditcard.attribute16%TYPE,
556: p_attribute17 IN iby_creditcard.attribute17%TYPE,
557: p_attribute18 IN iby_creditcard.attribute18%TYPE,
558: p_attribute19 IN iby_creditcard.attribute19%TYPE,

Line 555: p_attribute16 IN iby_creditcard.attribute16%TYPE,

551: p_attribute12 IN iby_creditcard.attribute12%TYPE,
552: p_attribute13 IN iby_creditcard.attribute13%TYPE,
553: p_attribute14 IN iby_creditcard.attribute14%TYPE,
554: p_attribute15 IN iby_creditcard.attribute15%TYPE,
555: p_attribute16 IN iby_creditcard.attribute16%TYPE,
556: p_attribute17 IN iby_creditcard.attribute17%TYPE,
557: p_attribute18 IN iby_creditcard.attribute18%TYPE,
558: p_attribute19 IN iby_creditcard.attribute19%TYPE,
559: p_attribute20 IN iby_creditcard.attribute20%TYPE,

Line 556: p_attribute17 IN iby_creditcard.attribute17%TYPE,

552: p_attribute13 IN iby_creditcard.attribute13%TYPE,
553: p_attribute14 IN iby_creditcard.attribute14%TYPE,
554: p_attribute15 IN iby_creditcard.attribute15%TYPE,
555: p_attribute16 IN iby_creditcard.attribute16%TYPE,
556: p_attribute17 IN iby_creditcard.attribute17%TYPE,
557: p_attribute18 IN iby_creditcard.attribute18%TYPE,
558: p_attribute19 IN iby_creditcard.attribute19%TYPE,
559: p_attribute20 IN iby_creditcard.attribute20%TYPE,
560: p_attribute21 IN iby_creditcard.attribute21%TYPE,

Line 557: p_attribute18 IN iby_creditcard.attribute18%TYPE,

553: p_attribute14 IN iby_creditcard.attribute14%TYPE,
554: p_attribute15 IN iby_creditcard.attribute15%TYPE,
555: p_attribute16 IN iby_creditcard.attribute16%TYPE,
556: p_attribute17 IN iby_creditcard.attribute17%TYPE,
557: p_attribute18 IN iby_creditcard.attribute18%TYPE,
558: p_attribute19 IN iby_creditcard.attribute19%TYPE,
559: p_attribute20 IN iby_creditcard.attribute20%TYPE,
560: p_attribute21 IN iby_creditcard.attribute21%TYPE,
561: p_attribute22 IN iby_creditcard.attribute22%TYPE,

Line 558: p_attribute19 IN iby_creditcard.attribute19%TYPE,

554: p_attribute15 IN iby_creditcard.attribute15%TYPE,
555: p_attribute16 IN iby_creditcard.attribute16%TYPE,
556: p_attribute17 IN iby_creditcard.attribute17%TYPE,
557: p_attribute18 IN iby_creditcard.attribute18%TYPE,
558: p_attribute19 IN iby_creditcard.attribute19%TYPE,
559: p_attribute20 IN iby_creditcard.attribute20%TYPE,
560: p_attribute21 IN iby_creditcard.attribute21%TYPE,
561: p_attribute22 IN iby_creditcard.attribute22%TYPE,
562: p_attribute23 IN iby_creditcard.attribute23%TYPE,

Line 559: p_attribute20 IN iby_creditcard.attribute20%TYPE,

555: p_attribute16 IN iby_creditcard.attribute16%TYPE,
556: p_attribute17 IN iby_creditcard.attribute17%TYPE,
557: p_attribute18 IN iby_creditcard.attribute18%TYPE,
558: p_attribute19 IN iby_creditcard.attribute19%TYPE,
559: p_attribute20 IN iby_creditcard.attribute20%TYPE,
560: p_attribute21 IN iby_creditcard.attribute21%TYPE,
561: p_attribute22 IN iby_creditcard.attribute22%TYPE,
562: p_attribute23 IN iby_creditcard.attribute23%TYPE,
563: p_attribute24 IN iby_creditcard.attribute24%TYPE,

Line 560: p_attribute21 IN iby_creditcard.attribute21%TYPE,

556: p_attribute17 IN iby_creditcard.attribute17%TYPE,
557: p_attribute18 IN iby_creditcard.attribute18%TYPE,
558: p_attribute19 IN iby_creditcard.attribute19%TYPE,
559: p_attribute20 IN iby_creditcard.attribute20%TYPE,
560: p_attribute21 IN iby_creditcard.attribute21%TYPE,
561: p_attribute22 IN iby_creditcard.attribute22%TYPE,
562: p_attribute23 IN iby_creditcard.attribute23%TYPE,
563: p_attribute24 IN iby_creditcard.attribute24%TYPE,
564: p_attribute25 IN iby_creditcard.attribute25%TYPE,

Line 561: p_attribute22 IN iby_creditcard.attribute22%TYPE,

557: p_attribute18 IN iby_creditcard.attribute18%TYPE,
558: p_attribute19 IN iby_creditcard.attribute19%TYPE,
559: p_attribute20 IN iby_creditcard.attribute20%TYPE,
560: p_attribute21 IN iby_creditcard.attribute21%TYPE,
561: p_attribute22 IN iby_creditcard.attribute22%TYPE,
562: p_attribute23 IN iby_creditcard.attribute23%TYPE,
563: p_attribute24 IN iby_creditcard.attribute24%TYPE,
564: p_attribute25 IN iby_creditcard.attribute25%TYPE,
565: p_attribute26 IN iby_creditcard.attribute26%TYPE,

Line 562: p_attribute23 IN iby_creditcard.attribute23%TYPE,

558: p_attribute19 IN iby_creditcard.attribute19%TYPE,
559: p_attribute20 IN iby_creditcard.attribute20%TYPE,
560: p_attribute21 IN iby_creditcard.attribute21%TYPE,
561: p_attribute22 IN iby_creditcard.attribute22%TYPE,
562: p_attribute23 IN iby_creditcard.attribute23%TYPE,
563: p_attribute24 IN iby_creditcard.attribute24%TYPE,
564: p_attribute25 IN iby_creditcard.attribute25%TYPE,
565: p_attribute26 IN iby_creditcard.attribute26%TYPE,
566: p_attribute27 IN iby_creditcard.attribute27%TYPE,

Line 563: p_attribute24 IN iby_creditcard.attribute24%TYPE,

559: p_attribute20 IN iby_creditcard.attribute20%TYPE,
560: p_attribute21 IN iby_creditcard.attribute21%TYPE,
561: p_attribute22 IN iby_creditcard.attribute22%TYPE,
562: p_attribute23 IN iby_creditcard.attribute23%TYPE,
563: p_attribute24 IN iby_creditcard.attribute24%TYPE,
564: p_attribute25 IN iby_creditcard.attribute25%TYPE,
565: p_attribute26 IN iby_creditcard.attribute26%TYPE,
566: p_attribute27 IN iby_creditcard.attribute27%TYPE,
567: p_attribute28 IN iby_creditcard.attribute28%TYPE,

Line 564: p_attribute25 IN iby_creditcard.attribute25%TYPE,

560: p_attribute21 IN iby_creditcard.attribute21%TYPE,
561: p_attribute22 IN iby_creditcard.attribute22%TYPE,
562: p_attribute23 IN iby_creditcard.attribute23%TYPE,
563: p_attribute24 IN iby_creditcard.attribute24%TYPE,
564: p_attribute25 IN iby_creditcard.attribute25%TYPE,
565: p_attribute26 IN iby_creditcard.attribute26%TYPE,
566: p_attribute27 IN iby_creditcard.attribute27%TYPE,
567: p_attribute28 IN iby_creditcard.attribute28%TYPE,
568: p_attribute29 IN iby_creditcard.attribute29%TYPE,

Line 565: p_attribute26 IN iby_creditcard.attribute26%TYPE,

561: p_attribute22 IN iby_creditcard.attribute22%TYPE,
562: p_attribute23 IN iby_creditcard.attribute23%TYPE,
563: p_attribute24 IN iby_creditcard.attribute24%TYPE,
564: p_attribute25 IN iby_creditcard.attribute25%TYPE,
565: p_attribute26 IN iby_creditcard.attribute26%TYPE,
566: p_attribute27 IN iby_creditcard.attribute27%TYPE,
567: p_attribute28 IN iby_creditcard.attribute28%TYPE,
568: p_attribute29 IN iby_creditcard.attribute29%TYPE,
569: p_attribute30 IN iby_creditcard.attribute30%TYPE,

Line 566: p_attribute27 IN iby_creditcard.attribute27%TYPE,

562: p_attribute23 IN iby_creditcard.attribute23%TYPE,
563: p_attribute24 IN iby_creditcard.attribute24%TYPE,
564: p_attribute25 IN iby_creditcard.attribute25%TYPE,
565: p_attribute26 IN iby_creditcard.attribute26%TYPE,
566: p_attribute27 IN iby_creditcard.attribute27%TYPE,
567: p_attribute28 IN iby_creditcard.attribute28%TYPE,
568: p_attribute29 IN iby_creditcard.attribute29%TYPE,
569: p_attribute30 IN iby_creditcard.attribute30%TYPE,
570: x_result_code OUT NOCOPY VARCHAR2,

Line 567: p_attribute28 IN iby_creditcard.attribute28%TYPE,

563: p_attribute24 IN iby_creditcard.attribute24%TYPE,
564: p_attribute25 IN iby_creditcard.attribute25%TYPE,
565: p_attribute26 IN iby_creditcard.attribute26%TYPE,
566: p_attribute27 IN iby_creditcard.attribute27%TYPE,
567: p_attribute28 IN iby_creditcard.attribute28%TYPE,
568: p_attribute29 IN iby_creditcard.attribute29%TYPE,
569: p_attribute30 IN iby_creditcard.attribute30%TYPE,
570: x_result_code OUT NOCOPY VARCHAR2,
571: x_return_status OUT NOCOPY VARCHAR2

Line 568: p_attribute29 IN iby_creditcard.attribute29%TYPE,

564: p_attribute25 IN iby_creditcard.attribute25%TYPE,
565: p_attribute26 IN iby_creditcard.attribute26%TYPE,
566: p_attribute27 IN iby_creditcard.attribute27%TYPE,
567: p_attribute28 IN iby_creditcard.attribute28%TYPE,
568: p_attribute29 IN iby_creditcard.attribute29%TYPE,
569: p_attribute30 IN iby_creditcard.attribute30%TYPE,
570: x_result_code OUT NOCOPY VARCHAR2,
571: x_return_status OUT NOCOPY VARCHAR2
572: );

Line 569: p_attribute30 IN iby_creditcard.attribute30%TYPE,

565: p_attribute26 IN iby_creditcard.attribute26%TYPE,
566: p_attribute27 IN iby_creditcard.attribute27%TYPE,
567: p_attribute28 IN iby_creditcard.attribute28%TYPE,
568: p_attribute29 IN iby_creditcard.attribute29%TYPE,
569: p_attribute30 IN iby_creditcard.attribute30%TYPE,
570: x_result_code OUT NOCOPY VARCHAR2,
571: x_return_status OUT NOCOPY VARCHAR2
572: );
573:

Line 586: p_owner_id IN iby_creditcard.card_owner_id%TYPE,

582: -- Initial version : 1.0
583:
584: PROCEDURE Create_Card_Wrapper
585: (p_commit IN VARCHAR2,
586: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
587: p_holder_name IN iby_creditcard.chname%TYPE,
588: p_billing_address_id IN iby_creditcard.addressid%TYPE,
589: p_address_type IN VARCHAR2,
590: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,

Line 587: p_holder_name IN iby_creditcard.chname%TYPE,

583:
584: PROCEDURE Create_Card_Wrapper
585: (p_commit IN VARCHAR2,
586: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
587: p_holder_name IN iby_creditcard.chname%TYPE,
588: p_billing_address_id IN iby_creditcard.addressid%TYPE,
589: p_address_type IN VARCHAR2,
590: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
591: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,

Line 588: p_billing_address_id IN iby_creditcard.addressid%TYPE,

584: PROCEDURE Create_Card_Wrapper
585: (p_commit IN VARCHAR2,
586: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
587: p_holder_name IN iby_creditcard.chname%TYPE,
588: p_billing_address_id IN iby_creditcard.addressid%TYPE,
589: p_address_type IN VARCHAR2,
590: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
591: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
592: p_card_number IN iby_creditcard.ccnumber%TYPE,

Line 590: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,

586: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
587: p_holder_name IN iby_creditcard.chname%TYPE,
588: p_billing_address_id IN iby_creditcard.addressid%TYPE,
589: p_address_type IN VARCHAR2,
590: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
591: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
592: p_card_number IN iby_creditcard.ccnumber%TYPE,
593: p_expiry_date IN iby_creditcard.expirydate%TYPE,
594: p_instr_type IN iby_creditcard.instrument_type%TYPE,

Line 591: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,

587: p_holder_name IN iby_creditcard.chname%TYPE,
588: p_billing_address_id IN iby_creditcard.addressid%TYPE,
589: p_address_type IN VARCHAR2,
590: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
591: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
592: p_card_number IN iby_creditcard.ccnumber%TYPE,
593: p_expiry_date IN iby_creditcard.expirydate%TYPE,
594: p_instr_type IN iby_creditcard.instrument_type%TYPE,
595: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,

Line 592: p_card_number IN iby_creditcard.ccnumber%TYPE,

588: p_billing_address_id IN iby_creditcard.addressid%TYPE,
589: p_address_type IN VARCHAR2,
590: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
591: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
592: p_card_number IN iby_creditcard.ccnumber%TYPE,
593: p_expiry_date IN iby_creditcard.expirydate%TYPE,
594: p_instr_type IN iby_creditcard.instrument_type%TYPE,
595: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
596: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,

Line 593: p_expiry_date IN iby_creditcard.expirydate%TYPE,

589: p_address_type IN VARCHAR2,
590: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
591: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
592: p_card_number IN iby_creditcard.ccnumber%TYPE,
593: p_expiry_date IN iby_creditcard.expirydate%TYPE,
594: p_instr_type IN iby_creditcard.instrument_type%TYPE,
595: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
596: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
597: p_issuer IN iby_creditcard.card_issuer_code%TYPE,

Line 594: p_instr_type IN iby_creditcard.instrument_type%TYPE,

590: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
591: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
592: p_card_number IN iby_creditcard.ccnumber%TYPE,
593: p_expiry_date IN iby_creditcard.expirydate%TYPE,
594: p_instr_type IN iby_creditcard.instrument_type%TYPE,
595: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
596: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
597: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
598: p_fi_name IN iby_creditcard.finame%TYPE,

Line 595: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,

591: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
592: p_card_number IN iby_creditcard.ccnumber%TYPE,
593: p_expiry_date IN iby_creditcard.expirydate%TYPE,
594: p_instr_type IN iby_creditcard.instrument_type%TYPE,
595: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
596: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
597: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
598: p_fi_name IN iby_creditcard.finame%TYPE,
599: p_single_use IN iby_creditcard.single_use_flag%TYPE,

Line 596: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,

592: p_card_number IN iby_creditcard.ccnumber%TYPE,
593: p_expiry_date IN iby_creditcard.expirydate%TYPE,
594: p_instr_type IN iby_creditcard.instrument_type%TYPE,
595: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
596: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
597: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
598: p_fi_name IN iby_creditcard.finame%TYPE,
599: p_single_use IN iby_creditcard.single_use_flag%TYPE,
600: p_info_only IN iby_creditcard.information_only_flag%TYPE,

Line 597: p_issuer IN iby_creditcard.card_issuer_code%TYPE,

593: p_expiry_date IN iby_creditcard.expirydate%TYPE,
594: p_instr_type IN iby_creditcard.instrument_type%TYPE,
595: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
596: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
597: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
598: p_fi_name IN iby_creditcard.finame%TYPE,
599: p_single_use IN iby_creditcard.single_use_flag%TYPE,
600: p_info_only IN iby_creditcard.information_only_flag%TYPE,
601: p_purpose IN iby_creditcard.card_purpose%TYPE,

Line 598: p_fi_name IN iby_creditcard.finame%TYPE,

594: p_instr_type IN iby_creditcard.instrument_type%TYPE,
595: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
596: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
597: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
598: p_fi_name IN iby_creditcard.finame%TYPE,
599: p_single_use IN iby_creditcard.single_use_flag%TYPE,
600: p_info_only IN iby_creditcard.information_only_flag%TYPE,
601: p_purpose IN iby_creditcard.card_purpose%TYPE,
602: p_desc IN iby_creditcard.description%TYPE,

Line 599: p_single_use IN iby_creditcard.single_use_flag%TYPE,

595: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
596: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
597: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
598: p_fi_name IN iby_creditcard.finame%TYPE,
599: p_single_use IN iby_creditcard.single_use_flag%TYPE,
600: p_info_only IN iby_creditcard.information_only_flag%TYPE,
601: p_purpose IN iby_creditcard.card_purpose%TYPE,
602: p_desc IN iby_creditcard.description%TYPE,
603: p_active_flag IN iby_creditcard.active_flag%TYPE,

Line 600: p_info_only IN iby_creditcard.information_only_flag%TYPE,

596: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
597: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
598: p_fi_name IN iby_creditcard.finame%TYPE,
599: p_single_use IN iby_creditcard.single_use_flag%TYPE,
600: p_info_only IN iby_creditcard.information_only_flag%TYPE,
601: p_purpose IN iby_creditcard.card_purpose%TYPE,
602: p_desc IN iby_creditcard.description%TYPE,
603: p_active_flag IN iby_creditcard.active_flag%TYPE,
604: p_inactive_date IN iby_creditcard.inactive_date%TYPE,

Line 601: p_purpose IN iby_creditcard.card_purpose%TYPE,

597: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
598: p_fi_name IN iby_creditcard.finame%TYPE,
599: p_single_use IN iby_creditcard.single_use_flag%TYPE,
600: p_info_only IN iby_creditcard.information_only_flag%TYPE,
601: p_purpose IN iby_creditcard.card_purpose%TYPE,
602: p_desc IN iby_creditcard.description%TYPE,
603: p_active_flag IN iby_creditcard.active_flag%TYPE,
604: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
605: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,

Line 602: p_desc IN iby_creditcard.description%TYPE,

598: p_fi_name IN iby_creditcard.finame%TYPE,
599: p_single_use IN iby_creditcard.single_use_flag%TYPE,
600: p_info_only IN iby_creditcard.information_only_flag%TYPE,
601: p_purpose IN iby_creditcard.card_purpose%TYPE,
602: p_desc IN iby_creditcard.description%TYPE,
603: p_active_flag IN iby_creditcard.active_flag%TYPE,
604: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
605: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
606: p_attribute_category IN iby_creditcard.attribute_category%TYPE,

Line 603: p_active_flag IN iby_creditcard.active_flag%TYPE,

599: p_single_use IN iby_creditcard.single_use_flag%TYPE,
600: p_info_only IN iby_creditcard.information_only_flag%TYPE,
601: p_purpose IN iby_creditcard.card_purpose%TYPE,
602: p_desc IN iby_creditcard.description%TYPE,
603: p_active_flag IN iby_creditcard.active_flag%TYPE,
604: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
605: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
606: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
607: p_attribute1 IN iby_creditcard.attribute1%TYPE,

Line 604: p_inactive_date IN iby_creditcard.inactive_date%TYPE,

600: p_info_only IN iby_creditcard.information_only_flag%TYPE,
601: p_purpose IN iby_creditcard.card_purpose%TYPE,
602: p_desc IN iby_creditcard.description%TYPE,
603: p_active_flag IN iby_creditcard.active_flag%TYPE,
604: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
605: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
606: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
607: p_attribute1 IN iby_creditcard.attribute1%TYPE,
608: p_attribute2 IN iby_creditcard.attribute2%TYPE,

Line 606: p_attribute_category IN iby_creditcard.attribute_category%TYPE,

602: p_desc IN iby_creditcard.description%TYPE,
603: p_active_flag IN iby_creditcard.active_flag%TYPE,
604: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
605: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
606: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
607: p_attribute1 IN iby_creditcard.attribute1%TYPE,
608: p_attribute2 IN iby_creditcard.attribute2%TYPE,
609: p_attribute3 IN iby_creditcard.attribute3%TYPE,
610: p_attribute4 IN iby_creditcard.attribute4%TYPE,

Line 607: p_attribute1 IN iby_creditcard.attribute1%TYPE,

603: p_active_flag IN iby_creditcard.active_flag%TYPE,
604: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
605: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
606: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
607: p_attribute1 IN iby_creditcard.attribute1%TYPE,
608: p_attribute2 IN iby_creditcard.attribute2%TYPE,
609: p_attribute3 IN iby_creditcard.attribute3%TYPE,
610: p_attribute4 IN iby_creditcard.attribute4%TYPE,
611: p_attribute5 IN iby_creditcard.attribute5%TYPE,

Line 608: p_attribute2 IN iby_creditcard.attribute2%TYPE,

604: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
605: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
606: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
607: p_attribute1 IN iby_creditcard.attribute1%TYPE,
608: p_attribute2 IN iby_creditcard.attribute2%TYPE,
609: p_attribute3 IN iby_creditcard.attribute3%TYPE,
610: p_attribute4 IN iby_creditcard.attribute4%TYPE,
611: p_attribute5 IN iby_creditcard.attribute5%TYPE,
612: p_attribute6 IN iby_creditcard.attribute6%TYPE,

Line 609: p_attribute3 IN iby_creditcard.attribute3%TYPE,

605: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
606: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
607: p_attribute1 IN iby_creditcard.attribute1%TYPE,
608: p_attribute2 IN iby_creditcard.attribute2%TYPE,
609: p_attribute3 IN iby_creditcard.attribute3%TYPE,
610: p_attribute4 IN iby_creditcard.attribute4%TYPE,
611: p_attribute5 IN iby_creditcard.attribute5%TYPE,
612: p_attribute6 IN iby_creditcard.attribute6%TYPE,
613: p_attribute7 IN iby_creditcard.attribute7%TYPE,

Line 610: p_attribute4 IN iby_creditcard.attribute4%TYPE,

606: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
607: p_attribute1 IN iby_creditcard.attribute1%TYPE,
608: p_attribute2 IN iby_creditcard.attribute2%TYPE,
609: p_attribute3 IN iby_creditcard.attribute3%TYPE,
610: p_attribute4 IN iby_creditcard.attribute4%TYPE,
611: p_attribute5 IN iby_creditcard.attribute5%TYPE,
612: p_attribute6 IN iby_creditcard.attribute6%TYPE,
613: p_attribute7 IN iby_creditcard.attribute7%TYPE,
614: p_attribute8 IN iby_creditcard.attribute8%TYPE,

Line 611: p_attribute5 IN iby_creditcard.attribute5%TYPE,

607: p_attribute1 IN iby_creditcard.attribute1%TYPE,
608: p_attribute2 IN iby_creditcard.attribute2%TYPE,
609: p_attribute3 IN iby_creditcard.attribute3%TYPE,
610: p_attribute4 IN iby_creditcard.attribute4%TYPE,
611: p_attribute5 IN iby_creditcard.attribute5%TYPE,
612: p_attribute6 IN iby_creditcard.attribute6%TYPE,
613: p_attribute7 IN iby_creditcard.attribute7%TYPE,
614: p_attribute8 IN iby_creditcard.attribute8%TYPE,
615: p_attribute9 IN iby_creditcard.attribute9%TYPE,

Line 612: p_attribute6 IN iby_creditcard.attribute6%TYPE,

608: p_attribute2 IN iby_creditcard.attribute2%TYPE,
609: p_attribute3 IN iby_creditcard.attribute3%TYPE,
610: p_attribute4 IN iby_creditcard.attribute4%TYPE,
611: p_attribute5 IN iby_creditcard.attribute5%TYPE,
612: p_attribute6 IN iby_creditcard.attribute6%TYPE,
613: p_attribute7 IN iby_creditcard.attribute7%TYPE,
614: p_attribute8 IN iby_creditcard.attribute8%TYPE,
615: p_attribute9 IN iby_creditcard.attribute9%TYPE,
616: p_attribute10 IN iby_creditcard.attribute10%TYPE,

Line 613: p_attribute7 IN iby_creditcard.attribute7%TYPE,

609: p_attribute3 IN iby_creditcard.attribute3%TYPE,
610: p_attribute4 IN iby_creditcard.attribute4%TYPE,
611: p_attribute5 IN iby_creditcard.attribute5%TYPE,
612: p_attribute6 IN iby_creditcard.attribute6%TYPE,
613: p_attribute7 IN iby_creditcard.attribute7%TYPE,
614: p_attribute8 IN iby_creditcard.attribute8%TYPE,
615: p_attribute9 IN iby_creditcard.attribute9%TYPE,
616: p_attribute10 IN iby_creditcard.attribute10%TYPE,
617: p_attribute11 IN iby_creditcard.attribute11%TYPE,

Line 614: p_attribute8 IN iby_creditcard.attribute8%TYPE,

610: p_attribute4 IN iby_creditcard.attribute4%TYPE,
611: p_attribute5 IN iby_creditcard.attribute5%TYPE,
612: p_attribute6 IN iby_creditcard.attribute6%TYPE,
613: p_attribute7 IN iby_creditcard.attribute7%TYPE,
614: p_attribute8 IN iby_creditcard.attribute8%TYPE,
615: p_attribute9 IN iby_creditcard.attribute9%TYPE,
616: p_attribute10 IN iby_creditcard.attribute10%TYPE,
617: p_attribute11 IN iby_creditcard.attribute11%TYPE,
618: p_attribute12 IN iby_creditcard.attribute12%TYPE,

Line 615: p_attribute9 IN iby_creditcard.attribute9%TYPE,

611: p_attribute5 IN iby_creditcard.attribute5%TYPE,
612: p_attribute6 IN iby_creditcard.attribute6%TYPE,
613: p_attribute7 IN iby_creditcard.attribute7%TYPE,
614: p_attribute8 IN iby_creditcard.attribute8%TYPE,
615: p_attribute9 IN iby_creditcard.attribute9%TYPE,
616: p_attribute10 IN iby_creditcard.attribute10%TYPE,
617: p_attribute11 IN iby_creditcard.attribute11%TYPE,
618: p_attribute12 IN iby_creditcard.attribute12%TYPE,
619: p_attribute13 IN iby_creditcard.attribute13%TYPE,

Line 616: p_attribute10 IN iby_creditcard.attribute10%TYPE,

612: p_attribute6 IN iby_creditcard.attribute6%TYPE,
613: p_attribute7 IN iby_creditcard.attribute7%TYPE,
614: p_attribute8 IN iby_creditcard.attribute8%TYPE,
615: p_attribute9 IN iby_creditcard.attribute9%TYPE,
616: p_attribute10 IN iby_creditcard.attribute10%TYPE,
617: p_attribute11 IN iby_creditcard.attribute11%TYPE,
618: p_attribute12 IN iby_creditcard.attribute12%TYPE,
619: p_attribute13 IN iby_creditcard.attribute13%TYPE,
620: p_attribute14 IN iby_creditcard.attribute14%TYPE,

Line 617: p_attribute11 IN iby_creditcard.attribute11%TYPE,

613: p_attribute7 IN iby_creditcard.attribute7%TYPE,
614: p_attribute8 IN iby_creditcard.attribute8%TYPE,
615: p_attribute9 IN iby_creditcard.attribute9%TYPE,
616: p_attribute10 IN iby_creditcard.attribute10%TYPE,
617: p_attribute11 IN iby_creditcard.attribute11%TYPE,
618: p_attribute12 IN iby_creditcard.attribute12%TYPE,
619: p_attribute13 IN iby_creditcard.attribute13%TYPE,
620: p_attribute14 IN iby_creditcard.attribute14%TYPE,
621: p_attribute15 IN iby_creditcard.attribute15%TYPE,

Line 618: p_attribute12 IN iby_creditcard.attribute12%TYPE,

614: p_attribute8 IN iby_creditcard.attribute8%TYPE,
615: p_attribute9 IN iby_creditcard.attribute9%TYPE,
616: p_attribute10 IN iby_creditcard.attribute10%TYPE,
617: p_attribute11 IN iby_creditcard.attribute11%TYPE,
618: p_attribute12 IN iby_creditcard.attribute12%TYPE,
619: p_attribute13 IN iby_creditcard.attribute13%TYPE,
620: p_attribute14 IN iby_creditcard.attribute14%TYPE,
621: p_attribute15 IN iby_creditcard.attribute15%TYPE,
622: p_attribute16 IN iby_creditcard.attribute16%TYPE,

Line 619: p_attribute13 IN iby_creditcard.attribute13%TYPE,

615: p_attribute9 IN iby_creditcard.attribute9%TYPE,
616: p_attribute10 IN iby_creditcard.attribute10%TYPE,
617: p_attribute11 IN iby_creditcard.attribute11%TYPE,
618: p_attribute12 IN iby_creditcard.attribute12%TYPE,
619: p_attribute13 IN iby_creditcard.attribute13%TYPE,
620: p_attribute14 IN iby_creditcard.attribute14%TYPE,
621: p_attribute15 IN iby_creditcard.attribute15%TYPE,
622: p_attribute16 IN iby_creditcard.attribute16%TYPE,
623: p_attribute17 IN iby_creditcard.attribute17%TYPE,

Line 620: p_attribute14 IN iby_creditcard.attribute14%TYPE,

616: p_attribute10 IN iby_creditcard.attribute10%TYPE,
617: p_attribute11 IN iby_creditcard.attribute11%TYPE,
618: p_attribute12 IN iby_creditcard.attribute12%TYPE,
619: p_attribute13 IN iby_creditcard.attribute13%TYPE,
620: p_attribute14 IN iby_creditcard.attribute14%TYPE,
621: p_attribute15 IN iby_creditcard.attribute15%TYPE,
622: p_attribute16 IN iby_creditcard.attribute16%TYPE,
623: p_attribute17 IN iby_creditcard.attribute17%TYPE,
624: p_attribute18 IN iby_creditcard.attribute18%TYPE,

Line 621: p_attribute15 IN iby_creditcard.attribute15%TYPE,

617: p_attribute11 IN iby_creditcard.attribute11%TYPE,
618: p_attribute12 IN iby_creditcard.attribute12%TYPE,
619: p_attribute13 IN iby_creditcard.attribute13%TYPE,
620: p_attribute14 IN iby_creditcard.attribute14%TYPE,
621: p_attribute15 IN iby_creditcard.attribute15%TYPE,
622: p_attribute16 IN iby_creditcard.attribute16%TYPE,
623: p_attribute17 IN iby_creditcard.attribute17%TYPE,
624: p_attribute18 IN iby_creditcard.attribute18%TYPE,
625: p_attribute19 IN iby_creditcard.attribute19%TYPE,

Line 622: p_attribute16 IN iby_creditcard.attribute16%TYPE,

618: p_attribute12 IN iby_creditcard.attribute12%TYPE,
619: p_attribute13 IN iby_creditcard.attribute13%TYPE,
620: p_attribute14 IN iby_creditcard.attribute14%TYPE,
621: p_attribute15 IN iby_creditcard.attribute15%TYPE,
622: p_attribute16 IN iby_creditcard.attribute16%TYPE,
623: p_attribute17 IN iby_creditcard.attribute17%TYPE,
624: p_attribute18 IN iby_creditcard.attribute18%TYPE,
625: p_attribute19 IN iby_creditcard.attribute19%TYPE,
626: p_attribute20 IN iby_creditcard.attribute20%TYPE,

Line 623: p_attribute17 IN iby_creditcard.attribute17%TYPE,

619: p_attribute13 IN iby_creditcard.attribute13%TYPE,
620: p_attribute14 IN iby_creditcard.attribute14%TYPE,
621: p_attribute15 IN iby_creditcard.attribute15%TYPE,
622: p_attribute16 IN iby_creditcard.attribute16%TYPE,
623: p_attribute17 IN iby_creditcard.attribute17%TYPE,
624: p_attribute18 IN iby_creditcard.attribute18%TYPE,
625: p_attribute19 IN iby_creditcard.attribute19%TYPE,
626: p_attribute20 IN iby_creditcard.attribute20%TYPE,
627: p_attribute21 IN iby_creditcard.attribute21%TYPE,

Line 624: p_attribute18 IN iby_creditcard.attribute18%TYPE,

620: p_attribute14 IN iby_creditcard.attribute14%TYPE,
621: p_attribute15 IN iby_creditcard.attribute15%TYPE,
622: p_attribute16 IN iby_creditcard.attribute16%TYPE,
623: p_attribute17 IN iby_creditcard.attribute17%TYPE,
624: p_attribute18 IN iby_creditcard.attribute18%TYPE,
625: p_attribute19 IN iby_creditcard.attribute19%TYPE,
626: p_attribute20 IN iby_creditcard.attribute20%TYPE,
627: p_attribute21 IN iby_creditcard.attribute21%TYPE,
628: p_attribute22 IN iby_creditcard.attribute22%TYPE,

Line 625: p_attribute19 IN iby_creditcard.attribute19%TYPE,

621: p_attribute15 IN iby_creditcard.attribute15%TYPE,
622: p_attribute16 IN iby_creditcard.attribute16%TYPE,
623: p_attribute17 IN iby_creditcard.attribute17%TYPE,
624: p_attribute18 IN iby_creditcard.attribute18%TYPE,
625: p_attribute19 IN iby_creditcard.attribute19%TYPE,
626: p_attribute20 IN iby_creditcard.attribute20%TYPE,
627: p_attribute21 IN iby_creditcard.attribute21%TYPE,
628: p_attribute22 IN iby_creditcard.attribute22%TYPE,
629: p_attribute23 IN iby_creditcard.attribute23%TYPE,

Line 626: p_attribute20 IN iby_creditcard.attribute20%TYPE,

622: p_attribute16 IN iby_creditcard.attribute16%TYPE,
623: p_attribute17 IN iby_creditcard.attribute17%TYPE,
624: p_attribute18 IN iby_creditcard.attribute18%TYPE,
625: p_attribute19 IN iby_creditcard.attribute19%TYPE,
626: p_attribute20 IN iby_creditcard.attribute20%TYPE,
627: p_attribute21 IN iby_creditcard.attribute21%TYPE,
628: p_attribute22 IN iby_creditcard.attribute22%TYPE,
629: p_attribute23 IN iby_creditcard.attribute23%TYPE,
630: p_attribute24 IN iby_creditcard.attribute24%TYPE,

Line 627: p_attribute21 IN iby_creditcard.attribute21%TYPE,

623: p_attribute17 IN iby_creditcard.attribute17%TYPE,
624: p_attribute18 IN iby_creditcard.attribute18%TYPE,
625: p_attribute19 IN iby_creditcard.attribute19%TYPE,
626: p_attribute20 IN iby_creditcard.attribute20%TYPE,
627: p_attribute21 IN iby_creditcard.attribute21%TYPE,
628: p_attribute22 IN iby_creditcard.attribute22%TYPE,
629: p_attribute23 IN iby_creditcard.attribute23%TYPE,
630: p_attribute24 IN iby_creditcard.attribute24%TYPE,
631: p_attribute25 IN iby_creditcard.attribute25%TYPE,

Line 628: p_attribute22 IN iby_creditcard.attribute22%TYPE,

624: p_attribute18 IN iby_creditcard.attribute18%TYPE,
625: p_attribute19 IN iby_creditcard.attribute19%TYPE,
626: p_attribute20 IN iby_creditcard.attribute20%TYPE,
627: p_attribute21 IN iby_creditcard.attribute21%TYPE,
628: p_attribute22 IN iby_creditcard.attribute22%TYPE,
629: p_attribute23 IN iby_creditcard.attribute23%TYPE,
630: p_attribute24 IN iby_creditcard.attribute24%TYPE,
631: p_attribute25 IN iby_creditcard.attribute25%TYPE,
632: p_attribute26 IN iby_creditcard.attribute26%TYPE,

Line 629: p_attribute23 IN iby_creditcard.attribute23%TYPE,

625: p_attribute19 IN iby_creditcard.attribute19%TYPE,
626: p_attribute20 IN iby_creditcard.attribute20%TYPE,
627: p_attribute21 IN iby_creditcard.attribute21%TYPE,
628: p_attribute22 IN iby_creditcard.attribute22%TYPE,
629: p_attribute23 IN iby_creditcard.attribute23%TYPE,
630: p_attribute24 IN iby_creditcard.attribute24%TYPE,
631: p_attribute25 IN iby_creditcard.attribute25%TYPE,
632: p_attribute26 IN iby_creditcard.attribute26%TYPE,
633: p_attribute27 IN iby_creditcard.attribute27%TYPE,

Line 630: p_attribute24 IN iby_creditcard.attribute24%TYPE,

626: p_attribute20 IN iby_creditcard.attribute20%TYPE,
627: p_attribute21 IN iby_creditcard.attribute21%TYPE,
628: p_attribute22 IN iby_creditcard.attribute22%TYPE,
629: p_attribute23 IN iby_creditcard.attribute23%TYPE,
630: p_attribute24 IN iby_creditcard.attribute24%TYPE,
631: p_attribute25 IN iby_creditcard.attribute25%TYPE,
632: p_attribute26 IN iby_creditcard.attribute26%TYPE,
633: p_attribute27 IN iby_creditcard.attribute27%TYPE,
634: p_attribute28 IN iby_creditcard.attribute28%TYPE,

Line 631: p_attribute25 IN iby_creditcard.attribute25%TYPE,

627: p_attribute21 IN iby_creditcard.attribute21%TYPE,
628: p_attribute22 IN iby_creditcard.attribute22%TYPE,
629: p_attribute23 IN iby_creditcard.attribute23%TYPE,
630: p_attribute24 IN iby_creditcard.attribute24%TYPE,
631: p_attribute25 IN iby_creditcard.attribute25%TYPE,
632: p_attribute26 IN iby_creditcard.attribute26%TYPE,
633: p_attribute27 IN iby_creditcard.attribute27%TYPE,
634: p_attribute28 IN iby_creditcard.attribute28%TYPE,
635: p_attribute29 IN iby_creditcard.attribute29%TYPE,

Line 632: p_attribute26 IN iby_creditcard.attribute26%TYPE,

628: p_attribute22 IN iby_creditcard.attribute22%TYPE,
629: p_attribute23 IN iby_creditcard.attribute23%TYPE,
630: p_attribute24 IN iby_creditcard.attribute24%TYPE,
631: p_attribute25 IN iby_creditcard.attribute25%TYPE,
632: p_attribute26 IN iby_creditcard.attribute26%TYPE,
633: p_attribute27 IN iby_creditcard.attribute27%TYPE,
634: p_attribute28 IN iby_creditcard.attribute28%TYPE,
635: p_attribute29 IN iby_creditcard.attribute29%TYPE,
636: p_attribute30 IN iby_creditcard.attribute30%TYPE,

Line 633: p_attribute27 IN iby_creditcard.attribute27%TYPE,

629: p_attribute23 IN iby_creditcard.attribute23%TYPE,
630: p_attribute24 IN iby_creditcard.attribute24%TYPE,
631: p_attribute25 IN iby_creditcard.attribute25%TYPE,
632: p_attribute26 IN iby_creditcard.attribute26%TYPE,
633: p_attribute27 IN iby_creditcard.attribute27%TYPE,
634: p_attribute28 IN iby_creditcard.attribute28%TYPE,
635: p_attribute29 IN iby_creditcard.attribute29%TYPE,
636: p_attribute30 IN iby_creditcard.attribute30%TYPE,
637: x_result_code OUT NOCOPY VARCHAR2,

Line 634: p_attribute28 IN iby_creditcard.attribute28%TYPE,

630: p_attribute24 IN iby_creditcard.attribute24%TYPE,
631: p_attribute25 IN iby_creditcard.attribute25%TYPE,
632: p_attribute26 IN iby_creditcard.attribute26%TYPE,
633: p_attribute27 IN iby_creditcard.attribute27%TYPE,
634: p_attribute28 IN iby_creditcard.attribute28%TYPE,
635: p_attribute29 IN iby_creditcard.attribute29%TYPE,
636: p_attribute30 IN iby_creditcard.attribute30%TYPE,
637: x_result_code OUT NOCOPY VARCHAR2,
638: x_return_status OUT NOCOPY VARCHAR2,

Line 635: p_attribute29 IN iby_creditcard.attribute29%TYPE,

631: p_attribute25 IN iby_creditcard.attribute25%TYPE,
632: p_attribute26 IN iby_creditcard.attribute26%TYPE,
633: p_attribute27 IN iby_creditcard.attribute27%TYPE,
634: p_attribute28 IN iby_creditcard.attribute28%TYPE,
635: p_attribute29 IN iby_creditcard.attribute29%TYPE,
636: p_attribute30 IN iby_creditcard.attribute30%TYPE,
637: x_result_code OUT NOCOPY VARCHAR2,
638: x_return_status OUT NOCOPY VARCHAR2,
639: x_instr_id OUT NOCOPY iby_creditcard.instrid%TYPE

Line 636: p_attribute30 IN iby_creditcard.attribute30%TYPE,

632: p_attribute26 IN iby_creditcard.attribute26%TYPE,
633: p_attribute27 IN iby_creditcard.attribute27%TYPE,
634: p_attribute28 IN iby_creditcard.attribute28%TYPE,
635: p_attribute29 IN iby_creditcard.attribute29%TYPE,
636: p_attribute30 IN iby_creditcard.attribute30%TYPE,
637: x_result_code OUT NOCOPY VARCHAR2,
638: x_return_status OUT NOCOPY VARCHAR2,
639: x_instr_id OUT NOCOPY iby_creditcard.instrid%TYPE
640: );

Line 639: x_instr_id OUT NOCOPY iby_creditcard.instrid%TYPE

635: p_attribute29 IN iby_creditcard.attribute29%TYPE,
636: p_attribute30 IN iby_creditcard.attribute30%TYPE,
637: x_result_code OUT NOCOPY VARCHAR2,
638: x_return_status OUT NOCOPY VARCHAR2,
639: x_instr_id OUT NOCOPY iby_creditcard.instrid%TYPE
640: );
641:
642: ------------------------------------------------------------------------------
643: -- IV. Utility Functions

Line 678: (p_instrid IN IBY_CREDITCARD.instrid%TYPE,

674: -- and hence done only when very much required)
675: --
676: --
677: PROCEDURE Get_Card_Expiration_Status
678: (p_instrid IN IBY_CREDITCARD.instrid%TYPE,
679: p_input_date IN DATE,
680: x_expired OUT NOCOPY VARCHAR2,
681: x_result_code OUT NOCOPY VARCHAR2
682: );