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.

[Home] [Help]

APPS.IBY_FNDCPT_SETUP_PUB dependencies on IBY_CREDITCARD

Line 42: CURSOR c_creditcard(ci_instrid IN iby_creditcard.instrid%TYPE)

38: IS
39:
40: l_instr_count NUMBER := 0;
41:
42: CURSOR c_creditcard(ci_instrid IN iby_creditcard.instrid%TYPE)
43: IS
44: SELECT COUNT(instrid)
45: FROM iby_creditcard
46: WHERE (instrid = ci_instrid);

Line 45: FROM iby_creditcard

41:
42: CURSOR c_creditcard(ci_instrid IN iby_creditcard.instrid%TYPE)
43: IS
44: SELECT COUNT(instrid)
45: FROM iby_creditcard
46: WHERE (instrid = ci_instrid);
47:
48: CURSOR c_bankaccount
49: (ci_instrid IN iby_ext_bank_accounts.ext_bank_account_id%TYPE)

Line 96: l_addressid iby_creditcard.addressid%TYPE;

92: lx_msg_data VARCHAR2(3000);
93: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
94: lx_channel_attribs PmtChannel_AttribUses_rec_type;
95:
96: l_addressid iby_creditcard.addressid%TYPE;
97: l_billing_zip iby_creditcard.billing_addr_postal_code%TYPE;
98: l_billing_terr iby_creditcard.bill_addr_territory_code%TYPE;
99:
100: BEGIN

Line 97: l_billing_zip iby_creditcard.billing_addr_postal_code%TYPE;

93: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
94: lx_channel_attribs PmtChannel_AttribUses_rec_type;
95:
96: l_addressid iby_creditcard.addressid%TYPE;
97: l_billing_zip iby_creditcard.billing_addr_postal_code%TYPE;
98: l_billing_terr iby_creditcard.bill_addr_territory_code%TYPE;
99:
100: BEGIN
101:

Line 98: l_billing_terr iby_creditcard.bill_addr_territory_code%TYPE;

94: lx_channel_attribs PmtChannel_AttribUses_rec_type;
95:
96: l_addressid iby_creditcard.addressid%TYPE;
97: l_billing_zip iby_creditcard.billing_addr_postal_code%TYPE;
98: l_billing_terr iby_creditcard.bill_addr_territory_code%TYPE;
99:
100: BEGIN
101:
102: IF (p_creditcard.Info_Only_Flag = 'Y') THEN

Line 1698: p_owner_id IN iby_creditcard.card_owner_id%TYPE,

1694: END Get_Trxn_Appl_Instr_Assign;
1695:
1696: PROCEDURE Create_Card_Wrapper
1697: (p_commit IN VARCHAR2,
1698: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
1699: p_holder_name IN iby_creditcard.chname%TYPE,
1700: p_billing_address_id IN iby_creditcard.addressid%TYPE,
1701: p_address_type IN VARCHAR2,
1702: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,

Line 1699: p_holder_name IN iby_creditcard.chname%TYPE,

1695:
1696: PROCEDURE Create_Card_Wrapper
1697: (p_commit IN VARCHAR2,
1698: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
1699: p_holder_name IN iby_creditcard.chname%TYPE,
1700: p_billing_address_id IN iby_creditcard.addressid%TYPE,
1701: p_address_type IN VARCHAR2,
1702: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
1703: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,

Line 1700: p_billing_address_id IN iby_creditcard.addressid%TYPE,

1696: PROCEDURE Create_Card_Wrapper
1697: (p_commit IN VARCHAR2,
1698: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
1699: p_holder_name IN iby_creditcard.chname%TYPE,
1700: p_billing_address_id IN iby_creditcard.addressid%TYPE,
1701: p_address_type IN VARCHAR2,
1702: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
1703: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
1704: p_card_number IN iby_creditcard.ccnumber%TYPE,

Line 1702: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,

1698: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
1699: p_holder_name IN iby_creditcard.chname%TYPE,
1700: p_billing_address_id IN iby_creditcard.addressid%TYPE,
1701: p_address_type IN VARCHAR2,
1702: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
1703: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
1704: p_card_number IN iby_creditcard.ccnumber%TYPE,
1705: p_expiry_date IN iby_creditcard.expirydate%TYPE,
1706: p_instr_type IN iby_creditcard.instrument_type%TYPE,

Line 1703: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,

1699: p_holder_name IN iby_creditcard.chname%TYPE,
1700: p_billing_address_id IN iby_creditcard.addressid%TYPE,
1701: p_address_type IN VARCHAR2,
1702: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
1703: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
1704: p_card_number IN iby_creditcard.ccnumber%TYPE,
1705: p_expiry_date IN iby_creditcard.expirydate%TYPE,
1706: p_instr_type IN iby_creditcard.instrument_type%TYPE,
1707: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,

Line 1704: p_card_number IN iby_creditcard.ccnumber%TYPE,

1700: p_billing_address_id IN iby_creditcard.addressid%TYPE,
1701: p_address_type IN VARCHAR2,
1702: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
1703: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
1704: p_card_number IN iby_creditcard.ccnumber%TYPE,
1705: p_expiry_date IN iby_creditcard.expirydate%TYPE,
1706: p_instr_type IN iby_creditcard.instrument_type%TYPE,
1707: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
1708: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,

Line 1705: p_expiry_date IN iby_creditcard.expirydate%TYPE,

1701: p_address_type IN VARCHAR2,
1702: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
1703: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
1704: p_card_number IN iby_creditcard.ccnumber%TYPE,
1705: p_expiry_date IN iby_creditcard.expirydate%TYPE,
1706: p_instr_type IN iby_creditcard.instrument_type%TYPE,
1707: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
1708: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
1709: p_issuer IN iby_creditcard.card_issuer_code%TYPE,

Line 1706: p_instr_type IN iby_creditcard.instrument_type%TYPE,

1702: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
1703: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
1704: p_card_number IN iby_creditcard.ccnumber%TYPE,
1705: p_expiry_date IN iby_creditcard.expirydate%TYPE,
1706: p_instr_type IN iby_creditcard.instrument_type%TYPE,
1707: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
1708: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
1709: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
1710: p_fi_name IN iby_creditcard.finame%TYPE,

Line 1707: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,

1703: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
1704: p_card_number IN iby_creditcard.ccnumber%TYPE,
1705: p_expiry_date IN iby_creditcard.expirydate%TYPE,
1706: p_instr_type IN iby_creditcard.instrument_type%TYPE,
1707: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
1708: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
1709: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
1710: p_fi_name IN iby_creditcard.finame%TYPE,
1711: p_single_use IN iby_creditcard.single_use_flag%TYPE,

Line 1708: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,

1704: p_card_number IN iby_creditcard.ccnumber%TYPE,
1705: p_expiry_date IN iby_creditcard.expirydate%TYPE,
1706: p_instr_type IN iby_creditcard.instrument_type%TYPE,
1707: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
1708: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
1709: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
1710: p_fi_name IN iby_creditcard.finame%TYPE,
1711: p_single_use IN iby_creditcard.single_use_flag%TYPE,
1712: p_info_only IN iby_creditcard.information_only_flag%TYPE,

Line 1709: p_issuer IN iby_creditcard.card_issuer_code%TYPE,

1705: p_expiry_date IN iby_creditcard.expirydate%TYPE,
1706: p_instr_type IN iby_creditcard.instrument_type%TYPE,
1707: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
1708: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
1709: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
1710: p_fi_name IN iby_creditcard.finame%TYPE,
1711: p_single_use IN iby_creditcard.single_use_flag%TYPE,
1712: p_info_only IN iby_creditcard.information_only_flag%TYPE,
1713: p_purpose IN iby_creditcard.card_purpose%TYPE,

Line 1710: p_fi_name IN iby_creditcard.finame%TYPE,

1706: p_instr_type IN iby_creditcard.instrument_type%TYPE,
1707: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
1708: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
1709: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
1710: p_fi_name IN iby_creditcard.finame%TYPE,
1711: p_single_use IN iby_creditcard.single_use_flag%TYPE,
1712: p_info_only IN iby_creditcard.information_only_flag%TYPE,
1713: p_purpose IN iby_creditcard.card_purpose%TYPE,
1714: p_desc IN iby_creditcard.description%TYPE,

Line 1711: p_single_use IN iby_creditcard.single_use_flag%TYPE,

1707: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
1708: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
1709: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
1710: p_fi_name IN iby_creditcard.finame%TYPE,
1711: p_single_use IN iby_creditcard.single_use_flag%TYPE,
1712: p_info_only IN iby_creditcard.information_only_flag%TYPE,
1713: p_purpose IN iby_creditcard.card_purpose%TYPE,
1714: p_desc IN iby_creditcard.description%TYPE,
1715: p_active_flag IN iby_creditcard.active_flag%TYPE,

Line 1712: p_info_only IN iby_creditcard.information_only_flag%TYPE,

1708: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
1709: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
1710: p_fi_name IN iby_creditcard.finame%TYPE,
1711: p_single_use IN iby_creditcard.single_use_flag%TYPE,
1712: p_info_only IN iby_creditcard.information_only_flag%TYPE,
1713: p_purpose IN iby_creditcard.card_purpose%TYPE,
1714: p_desc IN iby_creditcard.description%TYPE,
1715: p_active_flag IN iby_creditcard.active_flag%TYPE,
1716: p_inactive_date IN iby_creditcard.inactive_date%TYPE,

Line 1713: p_purpose IN iby_creditcard.card_purpose%TYPE,

1709: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
1710: p_fi_name IN iby_creditcard.finame%TYPE,
1711: p_single_use IN iby_creditcard.single_use_flag%TYPE,
1712: p_info_only IN iby_creditcard.information_only_flag%TYPE,
1713: p_purpose IN iby_creditcard.card_purpose%TYPE,
1714: p_desc IN iby_creditcard.description%TYPE,
1715: p_active_flag IN iby_creditcard.active_flag%TYPE,
1716: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
1717: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,

Line 1714: p_desc IN iby_creditcard.description%TYPE,

1710: p_fi_name IN iby_creditcard.finame%TYPE,
1711: p_single_use IN iby_creditcard.single_use_flag%TYPE,
1712: p_info_only IN iby_creditcard.information_only_flag%TYPE,
1713: p_purpose IN iby_creditcard.card_purpose%TYPE,
1714: p_desc IN iby_creditcard.description%TYPE,
1715: p_active_flag IN iby_creditcard.active_flag%TYPE,
1716: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
1717: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1718: p_attribute_category IN iby_creditcard.attribute_category%TYPE,

Line 1715: p_active_flag IN iby_creditcard.active_flag%TYPE,

1711: p_single_use IN iby_creditcard.single_use_flag%TYPE,
1712: p_info_only IN iby_creditcard.information_only_flag%TYPE,
1713: p_purpose IN iby_creditcard.card_purpose%TYPE,
1714: p_desc IN iby_creditcard.description%TYPE,
1715: p_active_flag IN iby_creditcard.active_flag%TYPE,
1716: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
1717: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1718: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
1719: p_attribute1 IN iby_creditcard.attribute1%TYPE,

Line 1716: p_inactive_date IN iby_creditcard.inactive_date%TYPE,

1712: p_info_only IN iby_creditcard.information_only_flag%TYPE,
1713: p_purpose IN iby_creditcard.card_purpose%TYPE,
1714: p_desc IN iby_creditcard.description%TYPE,
1715: p_active_flag IN iby_creditcard.active_flag%TYPE,
1716: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
1717: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1718: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
1719: p_attribute1 IN iby_creditcard.attribute1%TYPE,
1720: p_attribute2 IN iby_creditcard.attribute2%TYPE,

Line 1718: p_attribute_category IN iby_creditcard.attribute_category%TYPE,

1714: p_desc IN iby_creditcard.description%TYPE,
1715: p_active_flag IN iby_creditcard.active_flag%TYPE,
1716: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
1717: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1718: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
1719: p_attribute1 IN iby_creditcard.attribute1%TYPE,
1720: p_attribute2 IN iby_creditcard.attribute2%TYPE,
1721: p_attribute3 IN iby_creditcard.attribute3%TYPE,
1722: p_attribute4 IN iby_creditcard.attribute4%TYPE,

Line 1719: p_attribute1 IN iby_creditcard.attribute1%TYPE,

1715: p_active_flag IN iby_creditcard.active_flag%TYPE,
1716: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
1717: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1718: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
1719: p_attribute1 IN iby_creditcard.attribute1%TYPE,
1720: p_attribute2 IN iby_creditcard.attribute2%TYPE,
1721: p_attribute3 IN iby_creditcard.attribute3%TYPE,
1722: p_attribute4 IN iby_creditcard.attribute4%TYPE,
1723: p_attribute5 IN iby_creditcard.attribute5%TYPE,

Line 1720: p_attribute2 IN iby_creditcard.attribute2%TYPE,

1716: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
1717: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1718: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
1719: p_attribute1 IN iby_creditcard.attribute1%TYPE,
1720: p_attribute2 IN iby_creditcard.attribute2%TYPE,
1721: p_attribute3 IN iby_creditcard.attribute3%TYPE,
1722: p_attribute4 IN iby_creditcard.attribute4%TYPE,
1723: p_attribute5 IN iby_creditcard.attribute5%TYPE,
1724: p_attribute6 IN iby_creditcard.attribute6%TYPE,

Line 1721: p_attribute3 IN iby_creditcard.attribute3%TYPE,

1717: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1718: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
1719: p_attribute1 IN iby_creditcard.attribute1%TYPE,
1720: p_attribute2 IN iby_creditcard.attribute2%TYPE,
1721: p_attribute3 IN iby_creditcard.attribute3%TYPE,
1722: p_attribute4 IN iby_creditcard.attribute4%TYPE,
1723: p_attribute5 IN iby_creditcard.attribute5%TYPE,
1724: p_attribute6 IN iby_creditcard.attribute6%TYPE,
1725: p_attribute7 IN iby_creditcard.attribute7%TYPE,

Line 1722: p_attribute4 IN iby_creditcard.attribute4%TYPE,

1718: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
1719: p_attribute1 IN iby_creditcard.attribute1%TYPE,
1720: p_attribute2 IN iby_creditcard.attribute2%TYPE,
1721: p_attribute3 IN iby_creditcard.attribute3%TYPE,
1722: p_attribute4 IN iby_creditcard.attribute4%TYPE,
1723: p_attribute5 IN iby_creditcard.attribute5%TYPE,
1724: p_attribute6 IN iby_creditcard.attribute6%TYPE,
1725: p_attribute7 IN iby_creditcard.attribute7%TYPE,
1726: p_attribute8 IN iby_creditcard.attribute8%TYPE,

Line 1723: p_attribute5 IN iby_creditcard.attribute5%TYPE,

1719: p_attribute1 IN iby_creditcard.attribute1%TYPE,
1720: p_attribute2 IN iby_creditcard.attribute2%TYPE,
1721: p_attribute3 IN iby_creditcard.attribute3%TYPE,
1722: p_attribute4 IN iby_creditcard.attribute4%TYPE,
1723: p_attribute5 IN iby_creditcard.attribute5%TYPE,
1724: p_attribute6 IN iby_creditcard.attribute6%TYPE,
1725: p_attribute7 IN iby_creditcard.attribute7%TYPE,
1726: p_attribute8 IN iby_creditcard.attribute8%TYPE,
1727: p_attribute9 IN iby_creditcard.attribute9%TYPE,

Line 1724: p_attribute6 IN iby_creditcard.attribute6%TYPE,

1720: p_attribute2 IN iby_creditcard.attribute2%TYPE,
1721: p_attribute3 IN iby_creditcard.attribute3%TYPE,
1722: p_attribute4 IN iby_creditcard.attribute4%TYPE,
1723: p_attribute5 IN iby_creditcard.attribute5%TYPE,
1724: p_attribute6 IN iby_creditcard.attribute6%TYPE,
1725: p_attribute7 IN iby_creditcard.attribute7%TYPE,
1726: p_attribute8 IN iby_creditcard.attribute8%TYPE,
1727: p_attribute9 IN iby_creditcard.attribute9%TYPE,
1728: p_attribute10 IN iby_creditcard.attribute10%TYPE,

Line 1725: p_attribute7 IN iby_creditcard.attribute7%TYPE,

1721: p_attribute3 IN iby_creditcard.attribute3%TYPE,
1722: p_attribute4 IN iby_creditcard.attribute4%TYPE,
1723: p_attribute5 IN iby_creditcard.attribute5%TYPE,
1724: p_attribute6 IN iby_creditcard.attribute6%TYPE,
1725: p_attribute7 IN iby_creditcard.attribute7%TYPE,
1726: p_attribute8 IN iby_creditcard.attribute8%TYPE,
1727: p_attribute9 IN iby_creditcard.attribute9%TYPE,
1728: p_attribute10 IN iby_creditcard.attribute10%TYPE,
1729: p_attribute11 IN iby_creditcard.attribute11%TYPE,

Line 1726: p_attribute8 IN iby_creditcard.attribute8%TYPE,

1722: p_attribute4 IN iby_creditcard.attribute4%TYPE,
1723: p_attribute5 IN iby_creditcard.attribute5%TYPE,
1724: p_attribute6 IN iby_creditcard.attribute6%TYPE,
1725: p_attribute7 IN iby_creditcard.attribute7%TYPE,
1726: p_attribute8 IN iby_creditcard.attribute8%TYPE,
1727: p_attribute9 IN iby_creditcard.attribute9%TYPE,
1728: p_attribute10 IN iby_creditcard.attribute10%TYPE,
1729: p_attribute11 IN iby_creditcard.attribute11%TYPE,
1730: p_attribute12 IN iby_creditcard.attribute12%TYPE,

Line 1727: p_attribute9 IN iby_creditcard.attribute9%TYPE,

1723: p_attribute5 IN iby_creditcard.attribute5%TYPE,
1724: p_attribute6 IN iby_creditcard.attribute6%TYPE,
1725: p_attribute7 IN iby_creditcard.attribute7%TYPE,
1726: p_attribute8 IN iby_creditcard.attribute8%TYPE,
1727: p_attribute9 IN iby_creditcard.attribute9%TYPE,
1728: p_attribute10 IN iby_creditcard.attribute10%TYPE,
1729: p_attribute11 IN iby_creditcard.attribute11%TYPE,
1730: p_attribute12 IN iby_creditcard.attribute12%TYPE,
1731: p_attribute13 IN iby_creditcard.attribute13%TYPE,

Line 1728: p_attribute10 IN iby_creditcard.attribute10%TYPE,

1724: p_attribute6 IN iby_creditcard.attribute6%TYPE,
1725: p_attribute7 IN iby_creditcard.attribute7%TYPE,
1726: p_attribute8 IN iby_creditcard.attribute8%TYPE,
1727: p_attribute9 IN iby_creditcard.attribute9%TYPE,
1728: p_attribute10 IN iby_creditcard.attribute10%TYPE,
1729: p_attribute11 IN iby_creditcard.attribute11%TYPE,
1730: p_attribute12 IN iby_creditcard.attribute12%TYPE,
1731: p_attribute13 IN iby_creditcard.attribute13%TYPE,
1732: p_attribute14 IN iby_creditcard.attribute14%TYPE,

Line 1729: p_attribute11 IN iby_creditcard.attribute11%TYPE,

1725: p_attribute7 IN iby_creditcard.attribute7%TYPE,
1726: p_attribute8 IN iby_creditcard.attribute8%TYPE,
1727: p_attribute9 IN iby_creditcard.attribute9%TYPE,
1728: p_attribute10 IN iby_creditcard.attribute10%TYPE,
1729: p_attribute11 IN iby_creditcard.attribute11%TYPE,
1730: p_attribute12 IN iby_creditcard.attribute12%TYPE,
1731: p_attribute13 IN iby_creditcard.attribute13%TYPE,
1732: p_attribute14 IN iby_creditcard.attribute14%TYPE,
1733: p_attribute15 IN iby_creditcard.attribute15%TYPE,

Line 1730: p_attribute12 IN iby_creditcard.attribute12%TYPE,

1726: p_attribute8 IN iby_creditcard.attribute8%TYPE,
1727: p_attribute9 IN iby_creditcard.attribute9%TYPE,
1728: p_attribute10 IN iby_creditcard.attribute10%TYPE,
1729: p_attribute11 IN iby_creditcard.attribute11%TYPE,
1730: p_attribute12 IN iby_creditcard.attribute12%TYPE,
1731: p_attribute13 IN iby_creditcard.attribute13%TYPE,
1732: p_attribute14 IN iby_creditcard.attribute14%TYPE,
1733: p_attribute15 IN iby_creditcard.attribute15%TYPE,
1734: p_attribute16 IN iby_creditcard.attribute16%TYPE,

Line 1731: p_attribute13 IN iby_creditcard.attribute13%TYPE,

1727: p_attribute9 IN iby_creditcard.attribute9%TYPE,
1728: p_attribute10 IN iby_creditcard.attribute10%TYPE,
1729: p_attribute11 IN iby_creditcard.attribute11%TYPE,
1730: p_attribute12 IN iby_creditcard.attribute12%TYPE,
1731: p_attribute13 IN iby_creditcard.attribute13%TYPE,
1732: p_attribute14 IN iby_creditcard.attribute14%TYPE,
1733: p_attribute15 IN iby_creditcard.attribute15%TYPE,
1734: p_attribute16 IN iby_creditcard.attribute16%TYPE,
1735: p_attribute17 IN iby_creditcard.attribute17%TYPE,

Line 1732: p_attribute14 IN iby_creditcard.attribute14%TYPE,

1728: p_attribute10 IN iby_creditcard.attribute10%TYPE,
1729: p_attribute11 IN iby_creditcard.attribute11%TYPE,
1730: p_attribute12 IN iby_creditcard.attribute12%TYPE,
1731: p_attribute13 IN iby_creditcard.attribute13%TYPE,
1732: p_attribute14 IN iby_creditcard.attribute14%TYPE,
1733: p_attribute15 IN iby_creditcard.attribute15%TYPE,
1734: p_attribute16 IN iby_creditcard.attribute16%TYPE,
1735: p_attribute17 IN iby_creditcard.attribute17%TYPE,
1736: p_attribute18 IN iby_creditcard.attribute18%TYPE,

Line 1733: p_attribute15 IN iby_creditcard.attribute15%TYPE,

1729: p_attribute11 IN iby_creditcard.attribute11%TYPE,
1730: p_attribute12 IN iby_creditcard.attribute12%TYPE,
1731: p_attribute13 IN iby_creditcard.attribute13%TYPE,
1732: p_attribute14 IN iby_creditcard.attribute14%TYPE,
1733: p_attribute15 IN iby_creditcard.attribute15%TYPE,
1734: p_attribute16 IN iby_creditcard.attribute16%TYPE,
1735: p_attribute17 IN iby_creditcard.attribute17%TYPE,
1736: p_attribute18 IN iby_creditcard.attribute18%TYPE,
1737: p_attribute19 IN iby_creditcard.attribute19%TYPE,

Line 1734: p_attribute16 IN iby_creditcard.attribute16%TYPE,

1730: p_attribute12 IN iby_creditcard.attribute12%TYPE,
1731: p_attribute13 IN iby_creditcard.attribute13%TYPE,
1732: p_attribute14 IN iby_creditcard.attribute14%TYPE,
1733: p_attribute15 IN iby_creditcard.attribute15%TYPE,
1734: p_attribute16 IN iby_creditcard.attribute16%TYPE,
1735: p_attribute17 IN iby_creditcard.attribute17%TYPE,
1736: p_attribute18 IN iby_creditcard.attribute18%TYPE,
1737: p_attribute19 IN iby_creditcard.attribute19%TYPE,
1738: p_attribute20 IN iby_creditcard.attribute20%TYPE,

Line 1735: p_attribute17 IN iby_creditcard.attribute17%TYPE,

1731: p_attribute13 IN iby_creditcard.attribute13%TYPE,
1732: p_attribute14 IN iby_creditcard.attribute14%TYPE,
1733: p_attribute15 IN iby_creditcard.attribute15%TYPE,
1734: p_attribute16 IN iby_creditcard.attribute16%TYPE,
1735: p_attribute17 IN iby_creditcard.attribute17%TYPE,
1736: p_attribute18 IN iby_creditcard.attribute18%TYPE,
1737: p_attribute19 IN iby_creditcard.attribute19%TYPE,
1738: p_attribute20 IN iby_creditcard.attribute20%TYPE,
1739: p_attribute21 IN iby_creditcard.attribute21%TYPE,

Line 1736: p_attribute18 IN iby_creditcard.attribute18%TYPE,

1732: p_attribute14 IN iby_creditcard.attribute14%TYPE,
1733: p_attribute15 IN iby_creditcard.attribute15%TYPE,
1734: p_attribute16 IN iby_creditcard.attribute16%TYPE,
1735: p_attribute17 IN iby_creditcard.attribute17%TYPE,
1736: p_attribute18 IN iby_creditcard.attribute18%TYPE,
1737: p_attribute19 IN iby_creditcard.attribute19%TYPE,
1738: p_attribute20 IN iby_creditcard.attribute20%TYPE,
1739: p_attribute21 IN iby_creditcard.attribute21%TYPE,
1740: p_attribute22 IN iby_creditcard.attribute22%TYPE,

Line 1737: p_attribute19 IN iby_creditcard.attribute19%TYPE,

1733: p_attribute15 IN iby_creditcard.attribute15%TYPE,
1734: p_attribute16 IN iby_creditcard.attribute16%TYPE,
1735: p_attribute17 IN iby_creditcard.attribute17%TYPE,
1736: p_attribute18 IN iby_creditcard.attribute18%TYPE,
1737: p_attribute19 IN iby_creditcard.attribute19%TYPE,
1738: p_attribute20 IN iby_creditcard.attribute20%TYPE,
1739: p_attribute21 IN iby_creditcard.attribute21%TYPE,
1740: p_attribute22 IN iby_creditcard.attribute22%TYPE,
1741: p_attribute23 IN iby_creditcard.attribute23%TYPE,

Line 1738: p_attribute20 IN iby_creditcard.attribute20%TYPE,

1734: p_attribute16 IN iby_creditcard.attribute16%TYPE,
1735: p_attribute17 IN iby_creditcard.attribute17%TYPE,
1736: p_attribute18 IN iby_creditcard.attribute18%TYPE,
1737: p_attribute19 IN iby_creditcard.attribute19%TYPE,
1738: p_attribute20 IN iby_creditcard.attribute20%TYPE,
1739: p_attribute21 IN iby_creditcard.attribute21%TYPE,
1740: p_attribute22 IN iby_creditcard.attribute22%TYPE,
1741: p_attribute23 IN iby_creditcard.attribute23%TYPE,
1742: p_attribute24 IN iby_creditcard.attribute24%TYPE,

Line 1739: p_attribute21 IN iby_creditcard.attribute21%TYPE,

1735: p_attribute17 IN iby_creditcard.attribute17%TYPE,
1736: p_attribute18 IN iby_creditcard.attribute18%TYPE,
1737: p_attribute19 IN iby_creditcard.attribute19%TYPE,
1738: p_attribute20 IN iby_creditcard.attribute20%TYPE,
1739: p_attribute21 IN iby_creditcard.attribute21%TYPE,
1740: p_attribute22 IN iby_creditcard.attribute22%TYPE,
1741: p_attribute23 IN iby_creditcard.attribute23%TYPE,
1742: p_attribute24 IN iby_creditcard.attribute24%TYPE,
1743: p_attribute25 IN iby_creditcard.attribute25%TYPE,

Line 1740: p_attribute22 IN iby_creditcard.attribute22%TYPE,

1736: p_attribute18 IN iby_creditcard.attribute18%TYPE,
1737: p_attribute19 IN iby_creditcard.attribute19%TYPE,
1738: p_attribute20 IN iby_creditcard.attribute20%TYPE,
1739: p_attribute21 IN iby_creditcard.attribute21%TYPE,
1740: p_attribute22 IN iby_creditcard.attribute22%TYPE,
1741: p_attribute23 IN iby_creditcard.attribute23%TYPE,
1742: p_attribute24 IN iby_creditcard.attribute24%TYPE,
1743: p_attribute25 IN iby_creditcard.attribute25%TYPE,
1744: p_attribute26 IN iby_creditcard.attribute26%TYPE,

Line 1741: p_attribute23 IN iby_creditcard.attribute23%TYPE,

1737: p_attribute19 IN iby_creditcard.attribute19%TYPE,
1738: p_attribute20 IN iby_creditcard.attribute20%TYPE,
1739: p_attribute21 IN iby_creditcard.attribute21%TYPE,
1740: p_attribute22 IN iby_creditcard.attribute22%TYPE,
1741: p_attribute23 IN iby_creditcard.attribute23%TYPE,
1742: p_attribute24 IN iby_creditcard.attribute24%TYPE,
1743: p_attribute25 IN iby_creditcard.attribute25%TYPE,
1744: p_attribute26 IN iby_creditcard.attribute26%TYPE,
1745: p_attribute27 IN iby_creditcard.attribute27%TYPE,

Line 1742: p_attribute24 IN iby_creditcard.attribute24%TYPE,

1738: p_attribute20 IN iby_creditcard.attribute20%TYPE,
1739: p_attribute21 IN iby_creditcard.attribute21%TYPE,
1740: p_attribute22 IN iby_creditcard.attribute22%TYPE,
1741: p_attribute23 IN iby_creditcard.attribute23%TYPE,
1742: p_attribute24 IN iby_creditcard.attribute24%TYPE,
1743: p_attribute25 IN iby_creditcard.attribute25%TYPE,
1744: p_attribute26 IN iby_creditcard.attribute26%TYPE,
1745: p_attribute27 IN iby_creditcard.attribute27%TYPE,
1746: p_attribute28 IN iby_creditcard.attribute28%TYPE,

Line 1743: p_attribute25 IN iby_creditcard.attribute25%TYPE,

1739: p_attribute21 IN iby_creditcard.attribute21%TYPE,
1740: p_attribute22 IN iby_creditcard.attribute22%TYPE,
1741: p_attribute23 IN iby_creditcard.attribute23%TYPE,
1742: p_attribute24 IN iby_creditcard.attribute24%TYPE,
1743: p_attribute25 IN iby_creditcard.attribute25%TYPE,
1744: p_attribute26 IN iby_creditcard.attribute26%TYPE,
1745: p_attribute27 IN iby_creditcard.attribute27%TYPE,
1746: p_attribute28 IN iby_creditcard.attribute28%TYPE,
1747: p_attribute29 IN iby_creditcard.attribute29%TYPE,

Line 1744: p_attribute26 IN iby_creditcard.attribute26%TYPE,

1740: p_attribute22 IN iby_creditcard.attribute22%TYPE,
1741: p_attribute23 IN iby_creditcard.attribute23%TYPE,
1742: p_attribute24 IN iby_creditcard.attribute24%TYPE,
1743: p_attribute25 IN iby_creditcard.attribute25%TYPE,
1744: p_attribute26 IN iby_creditcard.attribute26%TYPE,
1745: p_attribute27 IN iby_creditcard.attribute27%TYPE,
1746: p_attribute28 IN iby_creditcard.attribute28%TYPE,
1747: p_attribute29 IN iby_creditcard.attribute29%TYPE,
1748: p_attribute30 IN iby_creditcard.attribute30%TYPE,

Line 1745: p_attribute27 IN iby_creditcard.attribute27%TYPE,

1741: p_attribute23 IN iby_creditcard.attribute23%TYPE,
1742: p_attribute24 IN iby_creditcard.attribute24%TYPE,
1743: p_attribute25 IN iby_creditcard.attribute25%TYPE,
1744: p_attribute26 IN iby_creditcard.attribute26%TYPE,
1745: p_attribute27 IN iby_creditcard.attribute27%TYPE,
1746: p_attribute28 IN iby_creditcard.attribute28%TYPE,
1747: p_attribute29 IN iby_creditcard.attribute29%TYPE,
1748: p_attribute30 IN iby_creditcard.attribute30%TYPE,
1749: x_result_code OUT NOCOPY VARCHAR2,

Line 1746: p_attribute28 IN iby_creditcard.attribute28%TYPE,

1742: p_attribute24 IN iby_creditcard.attribute24%TYPE,
1743: p_attribute25 IN iby_creditcard.attribute25%TYPE,
1744: p_attribute26 IN iby_creditcard.attribute26%TYPE,
1745: p_attribute27 IN iby_creditcard.attribute27%TYPE,
1746: p_attribute28 IN iby_creditcard.attribute28%TYPE,
1747: p_attribute29 IN iby_creditcard.attribute29%TYPE,
1748: p_attribute30 IN iby_creditcard.attribute30%TYPE,
1749: x_result_code OUT NOCOPY VARCHAR2,
1750: x_return_status OUT NOCOPY VARCHAR2,

Line 1747: p_attribute29 IN iby_creditcard.attribute29%TYPE,

1743: p_attribute25 IN iby_creditcard.attribute25%TYPE,
1744: p_attribute26 IN iby_creditcard.attribute26%TYPE,
1745: p_attribute27 IN iby_creditcard.attribute27%TYPE,
1746: p_attribute28 IN iby_creditcard.attribute28%TYPE,
1747: p_attribute29 IN iby_creditcard.attribute29%TYPE,
1748: p_attribute30 IN iby_creditcard.attribute30%TYPE,
1749: x_result_code OUT NOCOPY VARCHAR2,
1750: x_return_status OUT NOCOPY VARCHAR2,
1751: x_instr_id OUT NOCOPY iby_creditcard.instrid%TYPE

Line 1748: p_attribute30 IN iby_creditcard.attribute30%TYPE,

1744: p_attribute26 IN iby_creditcard.attribute26%TYPE,
1745: p_attribute27 IN iby_creditcard.attribute27%TYPE,
1746: p_attribute28 IN iby_creditcard.attribute28%TYPE,
1747: p_attribute29 IN iby_creditcard.attribute29%TYPE,
1748: p_attribute30 IN iby_creditcard.attribute30%TYPE,
1749: x_result_code OUT NOCOPY VARCHAR2,
1750: x_return_status OUT NOCOPY VARCHAR2,
1751: x_instr_id OUT NOCOPY iby_creditcard.instrid%TYPE
1752: )

Line 1751: x_instr_id OUT NOCOPY iby_creditcard.instrid%TYPE

1747: p_attribute29 IN iby_creditcard.attribute29%TYPE,
1748: p_attribute30 IN iby_creditcard.attribute30%TYPE,
1749: x_result_code OUT NOCOPY VARCHAR2,
1750: x_return_status OUT NOCOPY VARCHAR2,
1751: x_instr_id OUT NOCOPY iby_creditcard.instrid%TYPE
1752: )
1753: IS
1754: -- create a record type and populate it
1755: x_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;

Line 1850: l_info_only iby_creditcard.information_only_flag%TYPE := NULL;

1846: lx_result_code VARCHAR2(30);
1847: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1848: lx_card_rec CreditCard_rec_type;
1849:
1850: l_info_only iby_creditcard.information_only_flag%TYPE := NULL;
1851: l_sec_mode iby_sys_security_options.cc_encryption_mode%TYPE;
1852: l_cc_reg IBY_INSTRREG_PUB.CreditCardInstr_rec_type;
1853: l_instr_reg IBY_INSTRREG_PUB.PmtInstr_rec_type;
1854:

Line 1908: x_response.Result_Code := iby_creditcard_pkg.G_RC_INVALID_ADDRESS;

1904: IF (lx_card_rec.Card_Id IS NULL) THEN
1905:
1906: -- validate billing address information
1907: IF (NOT Validate_CC_Billing(FND_API.G_FALSE,p_card_instrument)) THEN
1908: x_response.Result_Code := iby_creditcard_pkg.G_RC_INVALID_ADDRESS;
1909: iby_fndcpt_common_pub.Prepare_Result
1910: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1911: RETURN;
1912: END IF;

Line 1978: iby_creditcard_pkg.Create_Card

1974: ELSE
1975: iby_debug_pub.add('database registration',
1976: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1977:
1978: iby_creditcard_pkg.Create_Card
1979: (FND_API.G_FALSE,
1980: p_card_instrument.Owner_Id, p_card_instrument.Card_Holder_Name,
1981: p_card_instrument.Billing_Address_Id,
1982: p_card_instrument.Address_Type,

Line 2037: x_response.Result_Code := iby_creditcard_pkg.G_RC_INVALID_ADDRESS;

2033: END IF;
2034:
2035: -- validate billing address information
2036: IF (NOT Validate_CC_Billing(FND_API.G_TRUE,p_card_instrument)) THEN
2037: x_response.Result_Code := iby_creditcard_pkg.G_RC_INVALID_ADDRESS;
2038: iby_fndcpt_common_pub.Prepare_Result
2039: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2040: RETURN;
2041: END IF;

Line 2045: x_response.Result_Code := iby_creditcard_pkg.G_RC_INVALID_CCEXPIRY;

2041: END IF;
2042: -- validate expiration date
2043: IF (TRUNC(p_card_instrument.Expiration_Date,'DD') < TRUNC(SYSDATE,'DD'))
2044: THEN
2045: x_response.Result_Code := iby_creditcard_pkg.G_RC_INVALID_CCEXPIRY;
2046: iby_fndcpt_common_pub.Prepare_Result
2047: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2048: RETURN;
2049: END IF;

Line 2051: iby_creditcard_pkg.Update_Card

2047: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2048: RETURN;
2049: END IF;
2050:
2051: iby_creditcard_pkg.Update_Card
2052: (FND_API.G_FALSE, lx_card_rec.Card_Id, p_card_instrument.Owner_Id,
2053: p_card_instrument.Card_Holder_Name,
2054: p_card_instrument.Billing_Address_Id,
2055: p_card_instrument.Address_Type,

Line 2141: p_instr_id IN iby_creditcard.instrid%TYPE,

2137:
2138: PROCEDURE Update_Card_Wrapper
2139: (
2140: p_commit IN VARCHAR2,
2141: p_instr_id IN iby_creditcard.instrid%TYPE,
2142: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
2143: p_holder_name IN iby_creditcard.chname%TYPE,
2144: p_billing_address_id IN iby_creditcard.addressid%TYPE,
2145: p_address_type IN VARCHAR2,

Line 2142: p_owner_id IN iby_creditcard.card_owner_id%TYPE,

2138: PROCEDURE Update_Card_Wrapper
2139: (
2140: p_commit IN VARCHAR2,
2141: p_instr_id IN iby_creditcard.instrid%TYPE,
2142: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
2143: p_holder_name IN iby_creditcard.chname%TYPE,
2144: p_billing_address_id IN iby_creditcard.addressid%TYPE,
2145: p_address_type IN VARCHAR2,
2146: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,

Line 2143: p_holder_name IN iby_creditcard.chname%TYPE,

2139: (
2140: p_commit IN VARCHAR2,
2141: p_instr_id IN iby_creditcard.instrid%TYPE,
2142: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
2143: p_holder_name IN iby_creditcard.chname%TYPE,
2144: p_billing_address_id IN iby_creditcard.addressid%TYPE,
2145: p_address_type IN VARCHAR2,
2146: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
2147: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,

Line 2144: p_billing_address_id IN iby_creditcard.addressid%TYPE,

2140: p_commit IN VARCHAR2,
2141: p_instr_id IN iby_creditcard.instrid%TYPE,
2142: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
2143: p_holder_name IN iby_creditcard.chname%TYPE,
2144: p_billing_address_id IN iby_creditcard.addressid%TYPE,
2145: p_address_type IN VARCHAR2,
2146: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
2147: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
2148: p_expiry_date IN iby_creditcard.expirydate%TYPE,

Line 2146: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,

2142: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
2143: p_holder_name IN iby_creditcard.chname%TYPE,
2144: p_billing_address_id IN iby_creditcard.addressid%TYPE,
2145: p_address_type IN VARCHAR2,
2146: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
2147: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
2148: p_expiry_date IN iby_creditcard.expirydate%TYPE,
2149: p_instr_type IN iby_creditcard.instrument_type%TYPE,
2150: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,

Line 2147: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,

2143: p_holder_name IN iby_creditcard.chname%TYPE,
2144: p_billing_address_id IN iby_creditcard.addressid%TYPE,
2145: p_address_type IN VARCHAR2,
2146: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
2147: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
2148: p_expiry_date IN iby_creditcard.expirydate%TYPE,
2149: p_instr_type IN iby_creditcard.instrument_type%TYPE,
2150: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
2151: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,

Line 2148: p_expiry_date IN iby_creditcard.expirydate%TYPE,

2144: p_billing_address_id IN iby_creditcard.addressid%TYPE,
2145: p_address_type IN VARCHAR2,
2146: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
2147: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
2148: p_expiry_date IN iby_creditcard.expirydate%TYPE,
2149: p_instr_type IN iby_creditcard.instrument_type%TYPE,
2150: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
2151: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
2152: p_fi_name IN iby_creditcard.finame%TYPE,

Line 2149: p_instr_type IN iby_creditcard.instrument_type%TYPE,

2145: p_address_type IN VARCHAR2,
2146: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
2147: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
2148: p_expiry_date IN iby_creditcard.expirydate%TYPE,
2149: p_instr_type IN iby_creditcard.instrument_type%TYPE,
2150: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
2151: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
2152: p_fi_name IN iby_creditcard.finame%TYPE,
2153: p_single_use IN iby_creditcard.single_use_flag%TYPE,

Line 2150: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,

2146: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
2147: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
2148: p_expiry_date IN iby_creditcard.expirydate%TYPE,
2149: p_instr_type IN iby_creditcard.instrument_type%TYPE,
2150: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
2151: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
2152: p_fi_name IN iby_creditcard.finame%TYPE,
2153: p_single_use IN iby_creditcard.single_use_flag%TYPE,
2154: p_info_only IN iby_creditcard.information_only_flag%TYPE,

Line 2151: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,

2147: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
2148: p_expiry_date IN iby_creditcard.expirydate%TYPE,
2149: p_instr_type IN iby_creditcard.instrument_type%TYPE,
2150: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
2151: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
2152: p_fi_name IN iby_creditcard.finame%TYPE,
2153: p_single_use IN iby_creditcard.single_use_flag%TYPE,
2154: p_info_only IN iby_creditcard.information_only_flag%TYPE,
2155: p_purpose IN iby_creditcard.card_purpose%TYPE,

Line 2152: p_fi_name IN iby_creditcard.finame%TYPE,

2148: p_expiry_date IN iby_creditcard.expirydate%TYPE,
2149: p_instr_type IN iby_creditcard.instrument_type%TYPE,
2150: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
2151: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
2152: p_fi_name IN iby_creditcard.finame%TYPE,
2153: p_single_use IN iby_creditcard.single_use_flag%TYPE,
2154: p_info_only IN iby_creditcard.information_only_flag%TYPE,
2155: p_purpose IN iby_creditcard.card_purpose%TYPE,
2156: p_desc IN iby_creditcard.description%TYPE,

Line 2153: p_single_use IN iby_creditcard.single_use_flag%TYPE,

2149: p_instr_type IN iby_creditcard.instrument_type%TYPE,
2150: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
2151: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
2152: p_fi_name IN iby_creditcard.finame%TYPE,
2153: p_single_use IN iby_creditcard.single_use_flag%TYPE,
2154: p_info_only IN iby_creditcard.information_only_flag%TYPE,
2155: p_purpose IN iby_creditcard.card_purpose%TYPE,
2156: p_desc IN iby_creditcard.description%TYPE,
2157: p_active_flag IN iby_creditcard.active_flag%TYPE,

Line 2154: p_info_only IN iby_creditcard.information_only_flag%TYPE,

2150: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
2151: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
2152: p_fi_name IN iby_creditcard.finame%TYPE,
2153: p_single_use IN iby_creditcard.single_use_flag%TYPE,
2154: p_info_only IN iby_creditcard.information_only_flag%TYPE,
2155: p_purpose IN iby_creditcard.card_purpose%TYPE,
2156: p_desc IN iby_creditcard.description%TYPE,
2157: p_active_flag IN iby_creditcard.active_flag%TYPE,
2158: p_inactive_date IN iby_creditcard.inactive_date%TYPE,

Line 2155: p_purpose IN iby_creditcard.card_purpose%TYPE,

2151: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
2152: p_fi_name IN iby_creditcard.finame%TYPE,
2153: p_single_use IN iby_creditcard.single_use_flag%TYPE,
2154: p_info_only IN iby_creditcard.information_only_flag%TYPE,
2155: p_purpose IN iby_creditcard.card_purpose%TYPE,
2156: p_desc IN iby_creditcard.description%TYPE,
2157: p_active_flag IN iby_creditcard.active_flag%TYPE,
2158: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
2159: p_attribute_category IN iby_creditcard.attribute_category%TYPE,

Line 2156: p_desc IN iby_creditcard.description%TYPE,

2152: p_fi_name IN iby_creditcard.finame%TYPE,
2153: p_single_use IN iby_creditcard.single_use_flag%TYPE,
2154: p_info_only IN iby_creditcard.information_only_flag%TYPE,
2155: p_purpose IN iby_creditcard.card_purpose%TYPE,
2156: p_desc IN iby_creditcard.description%TYPE,
2157: p_active_flag IN iby_creditcard.active_flag%TYPE,
2158: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
2159: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
2160: p_attribute1 IN iby_creditcard.attribute1%TYPE,

Line 2157: p_active_flag IN iby_creditcard.active_flag%TYPE,

2153: p_single_use IN iby_creditcard.single_use_flag%TYPE,
2154: p_info_only IN iby_creditcard.information_only_flag%TYPE,
2155: p_purpose IN iby_creditcard.card_purpose%TYPE,
2156: p_desc IN iby_creditcard.description%TYPE,
2157: p_active_flag IN iby_creditcard.active_flag%TYPE,
2158: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
2159: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
2160: p_attribute1 IN iby_creditcard.attribute1%TYPE,
2161: p_attribute2 IN iby_creditcard.attribute2%TYPE,

Line 2158: p_inactive_date IN iby_creditcard.inactive_date%TYPE,

2154: p_info_only IN iby_creditcard.information_only_flag%TYPE,
2155: p_purpose IN iby_creditcard.card_purpose%TYPE,
2156: p_desc IN iby_creditcard.description%TYPE,
2157: p_active_flag IN iby_creditcard.active_flag%TYPE,
2158: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
2159: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
2160: p_attribute1 IN iby_creditcard.attribute1%TYPE,
2161: p_attribute2 IN iby_creditcard.attribute2%TYPE,
2162: p_attribute3 IN iby_creditcard.attribute3%TYPE,

Line 2159: p_attribute_category IN iby_creditcard.attribute_category%TYPE,

2155: p_purpose IN iby_creditcard.card_purpose%TYPE,
2156: p_desc IN iby_creditcard.description%TYPE,
2157: p_active_flag IN iby_creditcard.active_flag%TYPE,
2158: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
2159: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
2160: p_attribute1 IN iby_creditcard.attribute1%TYPE,
2161: p_attribute2 IN iby_creditcard.attribute2%TYPE,
2162: p_attribute3 IN iby_creditcard.attribute3%TYPE,
2163: p_attribute4 IN iby_creditcard.attribute4%TYPE,

Line 2160: p_attribute1 IN iby_creditcard.attribute1%TYPE,

2156: p_desc IN iby_creditcard.description%TYPE,
2157: p_active_flag IN iby_creditcard.active_flag%TYPE,
2158: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
2159: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
2160: p_attribute1 IN iby_creditcard.attribute1%TYPE,
2161: p_attribute2 IN iby_creditcard.attribute2%TYPE,
2162: p_attribute3 IN iby_creditcard.attribute3%TYPE,
2163: p_attribute4 IN iby_creditcard.attribute4%TYPE,
2164: p_attribute5 IN iby_creditcard.attribute5%TYPE,

Line 2161: p_attribute2 IN iby_creditcard.attribute2%TYPE,

2157: p_active_flag IN iby_creditcard.active_flag%TYPE,
2158: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
2159: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
2160: p_attribute1 IN iby_creditcard.attribute1%TYPE,
2161: p_attribute2 IN iby_creditcard.attribute2%TYPE,
2162: p_attribute3 IN iby_creditcard.attribute3%TYPE,
2163: p_attribute4 IN iby_creditcard.attribute4%TYPE,
2164: p_attribute5 IN iby_creditcard.attribute5%TYPE,
2165: p_attribute6 IN iby_creditcard.attribute6%TYPE,

Line 2162: p_attribute3 IN iby_creditcard.attribute3%TYPE,

2158: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
2159: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
2160: p_attribute1 IN iby_creditcard.attribute1%TYPE,
2161: p_attribute2 IN iby_creditcard.attribute2%TYPE,
2162: p_attribute3 IN iby_creditcard.attribute3%TYPE,
2163: p_attribute4 IN iby_creditcard.attribute4%TYPE,
2164: p_attribute5 IN iby_creditcard.attribute5%TYPE,
2165: p_attribute6 IN iby_creditcard.attribute6%TYPE,
2166: p_attribute7 IN iby_creditcard.attribute7%TYPE,

Line 2163: p_attribute4 IN iby_creditcard.attribute4%TYPE,

2159: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
2160: p_attribute1 IN iby_creditcard.attribute1%TYPE,
2161: p_attribute2 IN iby_creditcard.attribute2%TYPE,
2162: p_attribute3 IN iby_creditcard.attribute3%TYPE,
2163: p_attribute4 IN iby_creditcard.attribute4%TYPE,
2164: p_attribute5 IN iby_creditcard.attribute5%TYPE,
2165: p_attribute6 IN iby_creditcard.attribute6%TYPE,
2166: p_attribute7 IN iby_creditcard.attribute7%TYPE,
2167: p_attribute8 IN iby_creditcard.attribute8%TYPE,

Line 2164: p_attribute5 IN iby_creditcard.attribute5%TYPE,

2160: p_attribute1 IN iby_creditcard.attribute1%TYPE,
2161: p_attribute2 IN iby_creditcard.attribute2%TYPE,
2162: p_attribute3 IN iby_creditcard.attribute3%TYPE,
2163: p_attribute4 IN iby_creditcard.attribute4%TYPE,
2164: p_attribute5 IN iby_creditcard.attribute5%TYPE,
2165: p_attribute6 IN iby_creditcard.attribute6%TYPE,
2166: p_attribute7 IN iby_creditcard.attribute7%TYPE,
2167: p_attribute8 IN iby_creditcard.attribute8%TYPE,
2168: p_attribute9 IN iby_creditcard.attribute9%TYPE,

Line 2165: p_attribute6 IN iby_creditcard.attribute6%TYPE,

2161: p_attribute2 IN iby_creditcard.attribute2%TYPE,
2162: p_attribute3 IN iby_creditcard.attribute3%TYPE,
2163: p_attribute4 IN iby_creditcard.attribute4%TYPE,
2164: p_attribute5 IN iby_creditcard.attribute5%TYPE,
2165: p_attribute6 IN iby_creditcard.attribute6%TYPE,
2166: p_attribute7 IN iby_creditcard.attribute7%TYPE,
2167: p_attribute8 IN iby_creditcard.attribute8%TYPE,
2168: p_attribute9 IN iby_creditcard.attribute9%TYPE,
2169: p_attribute10 IN iby_creditcard.attribute10%TYPE,

Line 2166: p_attribute7 IN iby_creditcard.attribute7%TYPE,

2162: p_attribute3 IN iby_creditcard.attribute3%TYPE,
2163: p_attribute4 IN iby_creditcard.attribute4%TYPE,
2164: p_attribute5 IN iby_creditcard.attribute5%TYPE,
2165: p_attribute6 IN iby_creditcard.attribute6%TYPE,
2166: p_attribute7 IN iby_creditcard.attribute7%TYPE,
2167: p_attribute8 IN iby_creditcard.attribute8%TYPE,
2168: p_attribute9 IN iby_creditcard.attribute9%TYPE,
2169: p_attribute10 IN iby_creditcard.attribute10%TYPE,
2170: p_attribute11 IN iby_creditcard.attribute11%TYPE,

Line 2167: p_attribute8 IN iby_creditcard.attribute8%TYPE,

2163: p_attribute4 IN iby_creditcard.attribute4%TYPE,
2164: p_attribute5 IN iby_creditcard.attribute5%TYPE,
2165: p_attribute6 IN iby_creditcard.attribute6%TYPE,
2166: p_attribute7 IN iby_creditcard.attribute7%TYPE,
2167: p_attribute8 IN iby_creditcard.attribute8%TYPE,
2168: p_attribute9 IN iby_creditcard.attribute9%TYPE,
2169: p_attribute10 IN iby_creditcard.attribute10%TYPE,
2170: p_attribute11 IN iby_creditcard.attribute11%TYPE,
2171: p_attribute12 IN iby_creditcard.attribute12%TYPE,

Line 2168: p_attribute9 IN iby_creditcard.attribute9%TYPE,

2164: p_attribute5 IN iby_creditcard.attribute5%TYPE,
2165: p_attribute6 IN iby_creditcard.attribute6%TYPE,
2166: p_attribute7 IN iby_creditcard.attribute7%TYPE,
2167: p_attribute8 IN iby_creditcard.attribute8%TYPE,
2168: p_attribute9 IN iby_creditcard.attribute9%TYPE,
2169: p_attribute10 IN iby_creditcard.attribute10%TYPE,
2170: p_attribute11 IN iby_creditcard.attribute11%TYPE,
2171: p_attribute12 IN iby_creditcard.attribute12%TYPE,
2172: p_attribute13 IN iby_creditcard.attribute13%TYPE,

Line 2169: p_attribute10 IN iby_creditcard.attribute10%TYPE,

2165: p_attribute6 IN iby_creditcard.attribute6%TYPE,
2166: p_attribute7 IN iby_creditcard.attribute7%TYPE,
2167: p_attribute8 IN iby_creditcard.attribute8%TYPE,
2168: p_attribute9 IN iby_creditcard.attribute9%TYPE,
2169: p_attribute10 IN iby_creditcard.attribute10%TYPE,
2170: p_attribute11 IN iby_creditcard.attribute11%TYPE,
2171: p_attribute12 IN iby_creditcard.attribute12%TYPE,
2172: p_attribute13 IN iby_creditcard.attribute13%TYPE,
2173: p_attribute14 IN iby_creditcard.attribute14%TYPE,

Line 2170: p_attribute11 IN iby_creditcard.attribute11%TYPE,

2166: p_attribute7 IN iby_creditcard.attribute7%TYPE,
2167: p_attribute8 IN iby_creditcard.attribute8%TYPE,
2168: p_attribute9 IN iby_creditcard.attribute9%TYPE,
2169: p_attribute10 IN iby_creditcard.attribute10%TYPE,
2170: p_attribute11 IN iby_creditcard.attribute11%TYPE,
2171: p_attribute12 IN iby_creditcard.attribute12%TYPE,
2172: p_attribute13 IN iby_creditcard.attribute13%TYPE,
2173: p_attribute14 IN iby_creditcard.attribute14%TYPE,
2174: p_attribute15 IN iby_creditcard.attribute15%TYPE,

Line 2171: p_attribute12 IN iby_creditcard.attribute12%TYPE,

2167: p_attribute8 IN iby_creditcard.attribute8%TYPE,
2168: p_attribute9 IN iby_creditcard.attribute9%TYPE,
2169: p_attribute10 IN iby_creditcard.attribute10%TYPE,
2170: p_attribute11 IN iby_creditcard.attribute11%TYPE,
2171: p_attribute12 IN iby_creditcard.attribute12%TYPE,
2172: p_attribute13 IN iby_creditcard.attribute13%TYPE,
2173: p_attribute14 IN iby_creditcard.attribute14%TYPE,
2174: p_attribute15 IN iby_creditcard.attribute15%TYPE,
2175: p_attribute16 IN iby_creditcard.attribute16%TYPE,

Line 2172: p_attribute13 IN iby_creditcard.attribute13%TYPE,

2168: p_attribute9 IN iby_creditcard.attribute9%TYPE,
2169: p_attribute10 IN iby_creditcard.attribute10%TYPE,
2170: p_attribute11 IN iby_creditcard.attribute11%TYPE,
2171: p_attribute12 IN iby_creditcard.attribute12%TYPE,
2172: p_attribute13 IN iby_creditcard.attribute13%TYPE,
2173: p_attribute14 IN iby_creditcard.attribute14%TYPE,
2174: p_attribute15 IN iby_creditcard.attribute15%TYPE,
2175: p_attribute16 IN iby_creditcard.attribute16%TYPE,
2176: p_attribute17 IN iby_creditcard.attribute17%TYPE,

Line 2173: p_attribute14 IN iby_creditcard.attribute14%TYPE,

2169: p_attribute10 IN iby_creditcard.attribute10%TYPE,
2170: p_attribute11 IN iby_creditcard.attribute11%TYPE,
2171: p_attribute12 IN iby_creditcard.attribute12%TYPE,
2172: p_attribute13 IN iby_creditcard.attribute13%TYPE,
2173: p_attribute14 IN iby_creditcard.attribute14%TYPE,
2174: p_attribute15 IN iby_creditcard.attribute15%TYPE,
2175: p_attribute16 IN iby_creditcard.attribute16%TYPE,
2176: p_attribute17 IN iby_creditcard.attribute17%TYPE,
2177: p_attribute18 IN iby_creditcard.attribute18%TYPE,

Line 2174: p_attribute15 IN iby_creditcard.attribute15%TYPE,

2170: p_attribute11 IN iby_creditcard.attribute11%TYPE,
2171: p_attribute12 IN iby_creditcard.attribute12%TYPE,
2172: p_attribute13 IN iby_creditcard.attribute13%TYPE,
2173: p_attribute14 IN iby_creditcard.attribute14%TYPE,
2174: p_attribute15 IN iby_creditcard.attribute15%TYPE,
2175: p_attribute16 IN iby_creditcard.attribute16%TYPE,
2176: p_attribute17 IN iby_creditcard.attribute17%TYPE,
2177: p_attribute18 IN iby_creditcard.attribute18%TYPE,
2178: p_attribute19 IN iby_creditcard.attribute19%TYPE,

Line 2175: p_attribute16 IN iby_creditcard.attribute16%TYPE,

2171: p_attribute12 IN iby_creditcard.attribute12%TYPE,
2172: p_attribute13 IN iby_creditcard.attribute13%TYPE,
2173: p_attribute14 IN iby_creditcard.attribute14%TYPE,
2174: p_attribute15 IN iby_creditcard.attribute15%TYPE,
2175: p_attribute16 IN iby_creditcard.attribute16%TYPE,
2176: p_attribute17 IN iby_creditcard.attribute17%TYPE,
2177: p_attribute18 IN iby_creditcard.attribute18%TYPE,
2178: p_attribute19 IN iby_creditcard.attribute19%TYPE,
2179: p_attribute20 IN iby_creditcard.attribute20%TYPE,

Line 2176: p_attribute17 IN iby_creditcard.attribute17%TYPE,

2172: p_attribute13 IN iby_creditcard.attribute13%TYPE,
2173: p_attribute14 IN iby_creditcard.attribute14%TYPE,
2174: p_attribute15 IN iby_creditcard.attribute15%TYPE,
2175: p_attribute16 IN iby_creditcard.attribute16%TYPE,
2176: p_attribute17 IN iby_creditcard.attribute17%TYPE,
2177: p_attribute18 IN iby_creditcard.attribute18%TYPE,
2178: p_attribute19 IN iby_creditcard.attribute19%TYPE,
2179: p_attribute20 IN iby_creditcard.attribute20%TYPE,
2180: p_attribute21 IN iby_creditcard.attribute21%TYPE,

Line 2177: p_attribute18 IN iby_creditcard.attribute18%TYPE,

2173: p_attribute14 IN iby_creditcard.attribute14%TYPE,
2174: p_attribute15 IN iby_creditcard.attribute15%TYPE,
2175: p_attribute16 IN iby_creditcard.attribute16%TYPE,
2176: p_attribute17 IN iby_creditcard.attribute17%TYPE,
2177: p_attribute18 IN iby_creditcard.attribute18%TYPE,
2178: p_attribute19 IN iby_creditcard.attribute19%TYPE,
2179: p_attribute20 IN iby_creditcard.attribute20%TYPE,
2180: p_attribute21 IN iby_creditcard.attribute21%TYPE,
2181: p_attribute22 IN iby_creditcard.attribute22%TYPE,

Line 2178: p_attribute19 IN iby_creditcard.attribute19%TYPE,

2174: p_attribute15 IN iby_creditcard.attribute15%TYPE,
2175: p_attribute16 IN iby_creditcard.attribute16%TYPE,
2176: p_attribute17 IN iby_creditcard.attribute17%TYPE,
2177: p_attribute18 IN iby_creditcard.attribute18%TYPE,
2178: p_attribute19 IN iby_creditcard.attribute19%TYPE,
2179: p_attribute20 IN iby_creditcard.attribute20%TYPE,
2180: p_attribute21 IN iby_creditcard.attribute21%TYPE,
2181: p_attribute22 IN iby_creditcard.attribute22%TYPE,
2182: p_attribute23 IN iby_creditcard.attribute23%TYPE,

Line 2179: p_attribute20 IN iby_creditcard.attribute20%TYPE,

2175: p_attribute16 IN iby_creditcard.attribute16%TYPE,
2176: p_attribute17 IN iby_creditcard.attribute17%TYPE,
2177: p_attribute18 IN iby_creditcard.attribute18%TYPE,
2178: p_attribute19 IN iby_creditcard.attribute19%TYPE,
2179: p_attribute20 IN iby_creditcard.attribute20%TYPE,
2180: p_attribute21 IN iby_creditcard.attribute21%TYPE,
2181: p_attribute22 IN iby_creditcard.attribute22%TYPE,
2182: p_attribute23 IN iby_creditcard.attribute23%TYPE,
2183: p_attribute24 IN iby_creditcard.attribute24%TYPE,

Line 2180: p_attribute21 IN iby_creditcard.attribute21%TYPE,

2176: p_attribute17 IN iby_creditcard.attribute17%TYPE,
2177: p_attribute18 IN iby_creditcard.attribute18%TYPE,
2178: p_attribute19 IN iby_creditcard.attribute19%TYPE,
2179: p_attribute20 IN iby_creditcard.attribute20%TYPE,
2180: p_attribute21 IN iby_creditcard.attribute21%TYPE,
2181: p_attribute22 IN iby_creditcard.attribute22%TYPE,
2182: p_attribute23 IN iby_creditcard.attribute23%TYPE,
2183: p_attribute24 IN iby_creditcard.attribute24%TYPE,
2184: p_attribute25 IN iby_creditcard.attribute25%TYPE,

Line 2181: p_attribute22 IN iby_creditcard.attribute22%TYPE,

2177: p_attribute18 IN iby_creditcard.attribute18%TYPE,
2178: p_attribute19 IN iby_creditcard.attribute19%TYPE,
2179: p_attribute20 IN iby_creditcard.attribute20%TYPE,
2180: p_attribute21 IN iby_creditcard.attribute21%TYPE,
2181: p_attribute22 IN iby_creditcard.attribute22%TYPE,
2182: p_attribute23 IN iby_creditcard.attribute23%TYPE,
2183: p_attribute24 IN iby_creditcard.attribute24%TYPE,
2184: p_attribute25 IN iby_creditcard.attribute25%TYPE,
2185: p_attribute26 IN iby_creditcard.attribute26%TYPE,

Line 2182: p_attribute23 IN iby_creditcard.attribute23%TYPE,

2178: p_attribute19 IN iby_creditcard.attribute19%TYPE,
2179: p_attribute20 IN iby_creditcard.attribute20%TYPE,
2180: p_attribute21 IN iby_creditcard.attribute21%TYPE,
2181: p_attribute22 IN iby_creditcard.attribute22%TYPE,
2182: p_attribute23 IN iby_creditcard.attribute23%TYPE,
2183: p_attribute24 IN iby_creditcard.attribute24%TYPE,
2184: p_attribute25 IN iby_creditcard.attribute25%TYPE,
2185: p_attribute26 IN iby_creditcard.attribute26%TYPE,
2186: p_attribute27 IN iby_creditcard.attribute27%TYPE,

Line 2183: p_attribute24 IN iby_creditcard.attribute24%TYPE,

2179: p_attribute20 IN iby_creditcard.attribute20%TYPE,
2180: p_attribute21 IN iby_creditcard.attribute21%TYPE,
2181: p_attribute22 IN iby_creditcard.attribute22%TYPE,
2182: p_attribute23 IN iby_creditcard.attribute23%TYPE,
2183: p_attribute24 IN iby_creditcard.attribute24%TYPE,
2184: p_attribute25 IN iby_creditcard.attribute25%TYPE,
2185: p_attribute26 IN iby_creditcard.attribute26%TYPE,
2186: p_attribute27 IN iby_creditcard.attribute27%TYPE,
2187: p_attribute28 IN iby_creditcard.attribute28%TYPE,

Line 2184: p_attribute25 IN iby_creditcard.attribute25%TYPE,

2180: p_attribute21 IN iby_creditcard.attribute21%TYPE,
2181: p_attribute22 IN iby_creditcard.attribute22%TYPE,
2182: p_attribute23 IN iby_creditcard.attribute23%TYPE,
2183: p_attribute24 IN iby_creditcard.attribute24%TYPE,
2184: p_attribute25 IN iby_creditcard.attribute25%TYPE,
2185: p_attribute26 IN iby_creditcard.attribute26%TYPE,
2186: p_attribute27 IN iby_creditcard.attribute27%TYPE,
2187: p_attribute28 IN iby_creditcard.attribute28%TYPE,
2188: p_attribute29 IN iby_creditcard.attribute29%TYPE,

Line 2185: p_attribute26 IN iby_creditcard.attribute26%TYPE,

2181: p_attribute22 IN iby_creditcard.attribute22%TYPE,
2182: p_attribute23 IN iby_creditcard.attribute23%TYPE,
2183: p_attribute24 IN iby_creditcard.attribute24%TYPE,
2184: p_attribute25 IN iby_creditcard.attribute25%TYPE,
2185: p_attribute26 IN iby_creditcard.attribute26%TYPE,
2186: p_attribute27 IN iby_creditcard.attribute27%TYPE,
2187: p_attribute28 IN iby_creditcard.attribute28%TYPE,
2188: p_attribute29 IN iby_creditcard.attribute29%TYPE,
2189: p_attribute30 IN iby_creditcard.attribute30%TYPE,

Line 2186: p_attribute27 IN iby_creditcard.attribute27%TYPE,

2182: p_attribute23 IN iby_creditcard.attribute23%TYPE,
2183: p_attribute24 IN iby_creditcard.attribute24%TYPE,
2184: p_attribute25 IN iby_creditcard.attribute25%TYPE,
2185: p_attribute26 IN iby_creditcard.attribute26%TYPE,
2186: p_attribute27 IN iby_creditcard.attribute27%TYPE,
2187: p_attribute28 IN iby_creditcard.attribute28%TYPE,
2188: p_attribute29 IN iby_creditcard.attribute29%TYPE,
2189: p_attribute30 IN iby_creditcard.attribute30%TYPE,
2190: x_result_code OUT NOCOPY VARCHAR2,

Line 2187: p_attribute28 IN iby_creditcard.attribute28%TYPE,

2183: p_attribute24 IN iby_creditcard.attribute24%TYPE,
2184: p_attribute25 IN iby_creditcard.attribute25%TYPE,
2185: p_attribute26 IN iby_creditcard.attribute26%TYPE,
2186: p_attribute27 IN iby_creditcard.attribute27%TYPE,
2187: p_attribute28 IN iby_creditcard.attribute28%TYPE,
2188: p_attribute29 IN iby_creditcard.attribute29%TYPE,
2189: p_attribute30 IN iby_creditcard.attribute30%TYPE,
2190: x_result_code OUT NOCOPY VARCHAR2,
2191: x_return_status OUT NOCOPY VARCHAR2

Line 2188: p_attribute29 IN iby_creditcard.attribute29%TYPE,

2184: p_attribute25 IN iby_creditcard.attribute25%TYPE,
2185: p_attribute26 IN iby_creditcard.attribute26%TYPE,
2186: p_attribute27 IN iby_creditcard.attribute27%TYPE,
2187: p_attribute28 IN iby_creditcard.attribute28%TYPE,
2188: p_attribute29 IN iby_creditcard.attribute29%TYPE,
2189: p_attribute30 IN iby_creditcard.attribute30%TYPE,
2190: x_result_code OUT NOCOPY VARCHAR2,
2191: x_return_status OUT NOCOPY VARCHAR2
2192: )

Line 2189: p_attribute30 IN iby_creditcard.attribute30%TYPE,

2185: p_attribute26 IN iby_creditcard.attribute26%TYPE,
2186: p_attribute27 IN iby_creditcard.attribute27%TYPE,
2187: p_attribute28 IN iby_creditcard.attribute28%TYPE,
2188: p_attribute29 IN iby_creditcard.attribute29%TYPE,
2189: p_attribute30 IN iby_creditcard.attribute30%TYPE,
2190: x_result_code OUT NOCOPY VARCHAR2,
2191: x_return_status OUT NOCOPY VARCHAR2
2192: )
2193: IS

Line 2284: l_info_only iby_creditcard.information_only_flag%TYPE := NULL;

2280: l_prev_msg_count NUMBER;
2281:
2282: lx_result_code VARCHAR2(30);
2283:
2284: l_info_only iby_creditcard.information_only_flag%TYPE := NULL;
2285:
2286: BEGIN
2287: IF NOT FND_API.Compatible_API_Call (l_api_version,
2288: p_api_version,

Line 2313: x_response.Result_Code := iby_creditcard_pkg.G_RC_INVALID_ADDRESS;

2309: l_info_only := p_card_instrument.Info_Only_Flag;
2310: END IF;
2311: -- validate billing address information
2312: IF (NOT Validate_CC_Billing(FND_API.G_TRUE,p_card_instrument)) THEN
2313: x_response.Result_Code := iby_creditcard_pkg.G_RC_INVALID_ADDRESS;
2314: iby_fndcpt_common_pub.Prepare_Result
2315: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2316: RETURN;
2317: END IF;

Line 2319: iby_creditcard_pkg.Update_Card

2315: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2316: RETURN;
2317: END IF;
2318:
2319: iby_creditcard_pkg.Update_Card
2320: (FND_API.G_FALSE, p_card_instrument.Card_Id, p_card_instrument.Owner_Id,
2321: p_card_instrument.Card_Holder_Name,
2322: p_card_instrument.Billing_Address_Id,
2323: p_card_instrument.Address_Type,

Line 2424: CURSOR c_card(ci_card_id IN iby_creditcard.instrid%TYPE)

2420: l_prev_msg_count NUMBER;
2421:
2422: l_card_count NUMBER;
2423:
2424: CURSOR c_card(ci_card_id IN iby_creditcard.instrid%TYPE)
2425: IS
2426: SELECT card_owner_id, chname, addressid, masked_cc_number, expirydate,
2427: instrument_type,
2428: purchasecard_subtype, card_issuer_code, finame, single_use_flag,

Line 2430: FROM iby_creditcard

2426: SELECT card_owner_id, chname, addressid, masked_cc_number, expirydate,
2427: instrument_type,
2428: purchasecard_subtype, card_issuer_code, finame, single_use_flag,
2429: information_only_flag, card_purpose, description, inactive_date
2430: FROM iby_creditcard
2431: WHERE (instrid = ci_card_id);
2432: BEGIN
2433: IF (c_card%ISOPEN) THEN
2434: CLOSE c_card;

Line 2537: l_card_id iby_creditcard.instrid%TYPE;

2533: l_api_version CONSTANT NUMBER := 1.0;
2534: l_module CONSTANT VARCHAR2(30) := 'Card_Exists';
2535: l_prev_msg_count NUMBER;
2536:
2537: l_card_id iby_creditcard.instrid%TYPE;
2538: l_cc_hash1 iby_creditcard.cc_number_hash1%TYPE;
2539: l_cc_hash2 iby_creditcard.cc_number_hash2%TYPE;
2540: l_char_allowed VARCHAR2(1) := 'N';
2541: lx_return_status VARCHAR2(1);

Line 2538: l_cc_hash1 iby_creditcard.cc_number_hash1%TYPE;

2534: l_module CONSTANT VARCHAR2(30) := 'Card_Exists';
2535: l_prev_msg_count NUMBER;
2536:
2537: l_card_id iby_creditcard.instrid%TYPE;
2538: l_cc_hash1 iby_creditcard.cc_number_hash1%TYPE;
2539: l_cc_hash2 iby_creditcard.cc_number_hash2%TYPE;
2540: l_char_allowed VARCHAR2(1) := 'N';
2541: lx_return_status VARCHAR2(1);
2542: lx_msg_count NUMBER;

Line 2539: l_cc_hash2 iby_creditcard.cc_number_hash2%TYPE;

2535: l_prev_msg_count NUMBER;
2536:
2537: l_card_id iby_creditcard.instrid%TYPE;
2538: l_cc_hash1 iby_creditcard.cc_number_hash1%TYPE;
2539: l_cc_hash2 iby_creditcard.cc_number_hash2%TYPE;
2540: l_char_allowed VARCHAR2(1) := 'N';
2541: lx_return_status VARCHAR2(1);
2542: lx_msg_count NUMBER;
2543: lx_msg_data VARCHAR2(200);

Line 2544: lx_cc_number iby_creditcard.ccnumber%TYPE;

2540: l_char_allowed VARCHAR2(1) := 'N';
2541: lx_return_status VARCHAR2(1);
2542: lx_msg_count NUMBER;
2543: lx_msg_data VARCHAR2(200);
2544: lx_cc_number iby_creditcard.ccnumber%TYPE;
2545: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2546:
2547: CURSOR c_card
2548: (ci_cc_hash1 IN iby_creditcard.cc_number_hash1%TYPE,

Line 2548: (ci_cc_hash1 IN iby_creditcard.cc_number_hash1%TYPE,

2544: lx_cc_number iby_creditcard.ccnumber%TYPE;
2545: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2546:
2547: CURSOR c_card
2548: (ci_cc_hash1 IN iby_creditcard.cc_number_hash1%TYPE,
2549: ci_cc_hash2 IN iby_creditcard.cc_number_hash2%TYPE,
2550: ci_card_owner IN iby_creditcard.card_owner_id%TYPE
2551: )
2552: IS

Line 2549: ci_cc_hash2 IN iby_creditcard.cc_number_hash2%TYPE,

2545: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2546:
2547: CURSOR c_card
2548: (ci_cc_hash1 IN iby_creditcard.cc_number_hash1%TYPE,
2549: ci_cc_hash2 IN iby_creditcard.cc_number_hash2%TYPE,
2550: ci_card_owner IN iby_creditcard.card_owner_id%TYPE
2551: )
2552: IS
2553: SELECT instrid

Line 2550: ci_card_owner IN iby_creditcard.card_owner_id%TYPE

2546:
2547: CURSOR c_card
2548: (ci_cc_hash1 IN iby_creditcard.cc_number_hash1%TYPE,
2549: ci_cc_hash2 IN iby_creditcard.cc_number_hash2%TYPE,
2550: ci_card_owner IN iby_creditcard.card_owner_id%TYPE
2551: )
2552: IS
2553: SELECT instrid
2554: FROM iby_creditcard

Line 2554: FROM iby_creditcard

2550: ci_card_owner IN iby_creditcard.card_owner_id%TYPE
2551: )
2552: IS
2553: SELECT instrid
2554: FROM iby_creditcard
2555: WHERE (cc_number_hash1 = ci_cc_hash1)
2556: AND (cc_number_hash2 = ci_cc_hash2)
2557: AND ( (card_owner_id = NVL(ci_card_owner,card_owner_id))
2558: OR (card_owner_id IS NULL AND ci_card_owner IS NULL) )

Line 2593: x_response.Result_Code := iby_creditcard_pkg.G_RC_INVALID_CCNUMBER;

2589: lx_return_status, lx_msg_count, lx_msg_data, lx_cc_number
2590: );
2591:
2592: IF (lx_cc_number IS NULL) THEN
2593: x_response.Result_Code := iby_creditcard_pkg.G_RC_INVALID_CCNUMBER;
2594: iby_fndcpt_common_pub.Prepare_Result
2595: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2596: RETURN;
2597: END IF;

Line 2801: lx_cc_number iby_creditcard.ccnumber%TYPE;

2797: IS
2798: lx_return_status VARCHAR2(1);
2799: lx_msg_count NUMBER;
2800: lx_msg_data VARCHAR2(200);
2801: lx_cc_number iby_creditcard.ccnumber%TYPE;
2802: BEGIN
2803: iby_cc_validate.StripCC
2804: (1.0, FND_API.G_FALSE, p_number,
2805: lx_return_status, lx_msg_count, lx_msg_data, lx_cc_number

Line 2816: lx_cc_number iby_creditcard.ccnumber%TYPE;

2812: IS
2813: lx_return_status VARCHAR2(1);
2814: lx_msg_count NUMBER;
2815: lx_msg_data VARCHAR2(200);
2816: lx_cc_number iby_creditcard.ccnumber%TYPE;
2817: BEGIN
2818: iby_cc_validate.StripCC
2819: (1.0, FND_API.G_FALSE, p_number,
2820: lx_return_status, lx_msg_count, lx_msg_data, lx_cc_number