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.

APPS.IBY_FNDCPT_SETUP_PUB dependencies on IBY_CREDITCARD

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

127: IS
128:
129: l_instr_count NUMBER := 0;
130:
131: CURSOR c_creditcard(ci_instrid IN iby_creditcard.instrid%TYPE)
132: IS
133: SELECT COUNT(instrid)
134: FROM iby_creditcard
135: WHERE (instrid = ci_instrid);

Line 134: FROM iby_creditcard

130:
131: CURSOR c_creditcard(ci_instrid IN iby_creditcard.instrid%TYPE)
132: IS
133: SELECT COUNT(instrid)
134: FROM iby_creditcard
135: WHERE (instrid = ci_instrid);
136:
137: CURSOR c_bankaccount
138: (ci_instrid IN iby_ext_bank_accounts.ext_bank_account_id%TYPE)

Line 185: l_addressid iby_creditcard.addressid%TYPE;

181: lx_msg_data VARCHAR2(3000);
182: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
183: lx_channel_attribs PmtChannel_AttribUses_rec_type;
184:
185: l_addressid iby_creditcard.addressid%TYPE;
186: l_billing_zip iby_creditcard.billing_addr_postal_code%TYPE;
187: l_billing_terr iby_creditcard.bill_addr_territory_code%TYPE;
188:
189: BEGIN

Line 186: l_billing_zip iby_creditcard.billing_addr_postal_code%TYPE;

182: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
183: lx_channel_attribs PmtChannel_AttribUses_rec_type;
184:
185: l_addressid iby_creditcard.addressid%TYPE;
186: l_billing_zip iby_creditcard.billing_addr_postal_code%TYPE;
187: l_billing_terr iby_creditcard.bill_addr_territory_code%TYPE;
188:
189: BEGIN
190:

Line 187: l_billing_terr iby_creditcard.bill_addr_territory_code%TYPE;

183: lx_channel_attribs PmtChannel_AttribUses_rec_type;
184:
185: l_addressid iby_creditcard.addressid%TYPE;
186: l_billing_zip iby_creditcard.billing_addr_postal_code%TYPE;
187: l_billing_terr iby_creditcard.bill_addr_territory_code%TYPE;
188:
189: BEGIN
190:
191: IF (p_creditcard.Info_Only_Flag = 'Y') THEN

Line 1800: -- by joining with iby_creditcard and iby_ext_bank_accounts.

1796: ) X,
1797: -- [lmallick]: bug# 12570664
1798: -- This API shouln't be returning the assignments that correspond
1799: -- to inactive instruments. Added the necessary filter conditions
1800: -- by joining with iby_creditcard and iby_ext_bank_accounts.
1801: iby_creditcard c,
1802: iby_ext_bank_accounts b
1803: WHERE X.DUP_RANK = 1
1804: AND c.instrid(+) = x.instrument_id

Line 1801: iby_creditcard c,

1797: -- [lmallick]: bug# 12570664
1798: -- This API shouln't be returning the assignments that correspond
1799: -- to inactive instruments. Added the necessary filter conditions
1800: -- by joining with iby_creditcard and iby_ext_bank_accounts.
1801: iby_creditcard c,
1802: iby_ext_bank_accounts b
1803: WHERE X.DUP_RANK = 1
1804: AND c.instrid(+) = x.instrument_id
1805: AND b.ext_bank_account_id(+) = x.instrument_id

Line 1913: p_owner_id IN iby_creditcard.card_owner_id%TYPE,

1909: END Get_Trxn_Appl_Instr_Assign;
1910:
1911: PROCEDURE Create_Card_Wrapper
1912: (p_commit IN VARCHAR2,
1913: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
1914: p_holder_name IN iby_creditcard.chname%TYPE,
1915: p_billing_address_id IN iby_creditcard.addressid%TYPE,
1916: p_address_type IN VARCHAR2,
1917: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,

Line 1914: p_holder_name IN iby_creditcard.chname%TYPE,

1910:
1911: PROCEDURE Create_Card_Wrapper
1912: (p_commit IN VARCHAR2,
1913: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
1914: p_holder_name IN iby_creditcard.chname%TYPE,
1915: p_billing_address_id IN iby_creditcard.addressid%TYPE,
1916: p_address_type IN VARCHAR2,
1917: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
1918: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,

Line 1915: p_billing_address_id IN iby_creditcard.addressid%TYPE,

1911: PROCEDURE Create_Card_Wrapper
1912: (p_commit IN VARCHAR2,
1913: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
1914: p_holder_name IN iby_creditcard.chname%TYPE,
1915: p_billing_address_id IN iby_creditcard.addressid%TYPE,
1916: p_address_type IN VARCHAR2,
1917: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
1918: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
1919: p_card_number IN iby_creditcard.ccnumber%TYPE,

Line 1917: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,

1913: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
1914: p_holder_name IN iby_creditcard.chname%TYPE,
1915: p_billing_address_id IN iby_creditcard.addressid%TYPE,
1916: p_address_type IN VARCHAR2,
1917: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
1918: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
1919: p_card_number IN iby_creditcard.ccnumber%TYPE,
1920: p_expiry_date IN iby_creditcard.expirydate%TYPE,
1921: p_instr_type IN iby_creditcard.instrument_type%TYPE,

Line 1918: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,

1914: p_holder_name IN iby_creditcard.chname%TYPE,
1915: p_billing_address_id IN iby_creditcard.addressid%TYPE,
1916: p_address_type IN VARCHAR2,
1917: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
1918: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
1919: p_card_number IN iby_creditcard.ccnumber%TYPE,
1920: p_expiry_date IN iby_creditcard.expirydate%TYPE,
1921: p_instr_type IN iby_creditcard.instrument_type%TYPE,
1922: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,

Line 1919: p_card_number IN iby_creditcard.ccnumber%TYPE,

1915: p_billing_address_id IN iby_creditcard.addressid%TYPE,
1916: p_address_type IN VARCHAR2,
1917: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
1918: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
1919: p_card_number IN iby_creditcard.ccnumber%TYPE,
1920: p_expiry_date IN iby_creditcard.expirydate%TYPE,
1921: p_instr_type IN iby_creditcard.instrument_type%TYPE,
1922: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
1923: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,

Line 1920: p_expiry_date IN iby_creditcard.expirydate%TYPE,

1916: p_address_type IN VARCHAR2,
1917: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
1918: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
1919: p_card_number IN iby_creditcard.ccnumber%TYPE,
1920: p_expiry_date IN iby_creditcard.expirydate%TYPE,
1921: p_instr_type IN iby_creditcard.instrument_type%TYPE,
1922: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
1923: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
1924: p_issuer IN iby_creditcard.card_issuer_code%TYPE,

Line 1921: p_instr_type IN iby_creditcard.instrument_type%TYPE,

1917: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
1918: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
1919: p_card_number IN iby_creditcard.ccnumber%TYPE,
1920: p_expiry_date IN iby_creditcard.expirydate%TYPE,
1921: p_instr_type IN iby_creditcard.instrument_type%TYPE,
1922: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
1923: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
1924: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
1925: p_fi_name IN iby_creditcard.finame%TYPE,

Line 1922: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,

1918: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
1919: p_card_number IN iby_creditcard.ccnumber%TYPE,
1920: p_expiry_date IN iby_creditcard.expirydate%TYPE,
1921: p_instr_type IN iby_creditcard.instrument_type%TYPE,
1922: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
1923: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
1924: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
1925: p_fi_name IN iby_creditcard.finame%TYPE,
1926: p_single_use IN iby_creditcard.single_use_flag%TYPE,

Line 1923: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,

1919: p_card_number IN iby_creditcard.ccnumber%TYPE,
1920: p_expiry_date IN iby_creditcard.expirydate%TYPE,
1921: p_instr_type IN iby_creditcard.instrument_type%TYPE,
1922: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
1923: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
1924: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
1925: p_fi_name IN iby_creditcard.finame%TYPE,
1926: p_single_use IN iby_creditcard.single_use_flag%TYPE,
1927: p_info_only IN iby_creditcard.information_only_flag%TYPE,

Line 1924: p_issuer IN iby_creditcard.card_issuer_code%TYPE,

1920: p_expiry_date IN iby_creditcard.expirydate%TYPE,
1921: p_instr_type IN iby_creditcard.instrument_type%TYPE,
1922: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
1923: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
1924: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
1925: p_fi_name IN iby_creditcard.finame%TYPE,
1926: p_single_use IN iby_creditcard.single_use_flag%TYPE,
1927: p_info_only IN iby_creditcard.information_only_flag%TYPE,
1928: p_purpose IN iby_creditcard.card_purpose%TYPE,

Line 1925: p_fi_name IN iby_creditcard.finame%TYPE,

1921: p_instr_type IN iby_creditcard.instrument_type%TYPE,
1922: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
1923: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
1924: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
1925: p_fi_name IN iby_creditcard.finame%TYPE,
1926: p_single_use IN iby_creditcard.single_use_flag%TYPE,
1927: p_info_only IN iby_creditcard.information_only_flag%TYPE,
1928: p_purpose IN iby_creditcard.card_purpose%TYPE,
1929: p_desc IN iby_creditcard.description%TYPE,

Line 1926: p_single_use IN iby_creditcard.single_use_flag%TYPE,

1922: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
1923: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
1924: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
1925: p_fi_name IN iby_creditcard.finame%TYPE,
1926: p_single_use IN iby_creditcard.single_use_flag%TYPE,
1927: p_info_only IN iby_creditcard.information_only_flag%TYPE,
1928: p_purpose IN iby_creditcard.card_purpose%TYPE,
1929: p_desc IN iby_creditcard.description%TYPE,
1930: p_active_flag IN iby_creditcard.active_flag%TYPE,

Line 1927: p_info_only IN iby_creditcard.information_only_flag%TYPE,

1923: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
1924: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
1925: p_fi_name IN iby_creditcard.finame%TYPE,
1926: p_single_use IN iby_creditcard.single_use_flag%TYPE,
1927: p_info_only IN iby_creditcard.information_only_flag%TYPE,
1928: p_purpose IN iby_creditcard.card_purpose%TYPE,
1929: p_desc IN iby_creditcard.description%TYPE,
1930: p_active_flag IN iby_creditcard.active_flag%TYPE,
1931: p_inactive_date IN iby_creditcard.inactive_date%TYPE,

Line 1928: p_purpose IN iby_creditcard.card_purpose%TYPE,

1924: p_issuer IN iby_creditcard.card_issuer_code%TYPE,
1925: p_fi_name IN iby_creditcard.finame%TYPE,
1926: p_single_use IN iby_creditcard.single_use_flag%TYPE,
1927: p_info_only IN iby_creditcard.information_only_flag%TYPE,
1928: p_purpose IN iby_creditcard.card_purpose%TYPE,
1929: p_desc IN iby_creditcard.description%TYPE,
1930: p_active_flag IN iby_creditcard.active_flag%TYPE,
1931: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
1932: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,

Line 1929: p_desc IN iby_creditcard.description%TYPE,

1925: p_fi_name IN iby_creditcard.finame%TYPE,
1926: p_single_use IN iby_creditcard.single_use_flag%TYPE,
1927: p_info_only IN iby_creditcard.information_only_flag%TYPE,
1928: p_purpose IN iby_creditcard.card_purpose%TYPE,
1929: p_desc IN iby_creditcard.description%TYPE,
1930: p_active_flag IN iby_creditcard.active_flag%TYPE,
1931: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
1932: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1933: p_attribute_category IN iby_creditcard.attribute_category%TYPE,

Line 1930: p_active_flag IN iby_creditcard.active_flag%TYPE,

1926: p_single_use IN iby_creditcard.single_use_flag%TYPE,
1927: p_info_only IN iby_creditcard.information_only_flag%TYPE,
1928: p_purpose IN iby_creditcard.card_purpose%TYPE,
1929: p_desc IN iby_creditcard.description%TYPE,
1930: p_active_flag IN iby_creditcard.active_flag%TYPE,
1931: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
1932: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1933: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
1934: p_attribute1 IN iby_creditcard.attribute1%TYPE,

Line 1931: p_inactive_date IN iby_creditcard.inactive_date%TYPE,

1927: p_info_only IN iby_creditcard.information_only_flag%TYPE,
1928: p_purpose IN iby_creditcard.card_purpose%TYPE,
1929: p_desc IN iby_creditcard.description%TYPE,
1930: p_active_flag IN iby_creditcard.active_flag%TYPE,
1931: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
1932: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1933: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
1934: p_attribute1 IN iby_creditcard.attribute1%TYPE,
1935: p_attribute2 IN iby_creditcard.attribute2%TYPE,

Line 1933: p_attribute_category IN iby_creditcard.attribute_category%TYPE,

1929: p_desc IN iby_creditcard.description%TYPE,
1930: p_active_flag IN iby_creditcard.active_flag%TYPE,
1931: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
1932: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1933: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
1934: p_attribute1 IN iby_creditcard.attribute1%TYPE,
1935: p_attribute2 IN iby_creditcard.attribute2%TYPE,
1936: p_attribute3 IN iby_creditcard.attribute3%TYPE,
1937: p_attribute4 IN iby_creditcard.attribute4%TYPE,

Line 1934: p_attribute1 IN iby_creditcard.attribute1%TYPE,

1930: p_active_flag IN iby_creditcard.active_flag%TYPE,
1931: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
1932: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1933: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
1934: p_attribute1 IN iby_creditcard.attribute1%TYPE,
1935: p_attribute2 IN iby_creditcard.attribute2%TYPE,
1936: p_attribute3 IN iby_creditcard.attribute3%TYPE,
1937: p_attribute4 IN iby_creditcard.attribute4%TYPE,
1938: p_attribute5 IN iby_creditcard.attribute5%TYPE,

Line 1935: p_attribute2 IN iby_creditcard.attribute2%TYPE,

1931: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
1932: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1933: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
1934: p_attribute1 IN iby_creditcard.attribute1%TYPE,
1935: p_attribute2 IN iby_creditcard.attribute2%TYPE,
1936: p_attribute3 IN iby_creditcard.attribute3%TYPE,
1937: p_attribute4 IN iby_creditcard.attribute4%TYPE,
1938: p_attribute5 IN iby_creditcard.attribute5%TYPE,
1939: p_attribute6 IN iby_creditcard.attribute6%TYPE,

Line 1936: p_attribute3 IN iby_creditcard.attribute3%TYPE,

1932: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1933: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
1934: p_attribute1 IN iby_creditcard.attribute1%TYPE,
1935: p_attribute2 IN iby_creditcard.attribute2%TYPE,
1936: p_attribute3 IN iby_creditcard.attribute3%TYPE,
1937: p_attribute4 IN iby_creditcard.attribute4%TYPE,
1938: p_attribute5 IN iby_creditcard.attribute5%TYPE,
1939: p_attribute6 IN iby_creditcard.attribute6%TYPE,
1940: p_attribute7 IN iby_creditcard.attribute7%TYPE,

Line 1937: p_attribute4 IN iby_creditcard.attribute4%TYPE,

1933: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
1934: p_attribute1 IN iby_creditcard.attribute1%TYPE,
1935: p_attribute2 IN iby_creditcard.attribute2%TYPE,
1936: p_attribute3 IN iby_creditcard.attribute3%TYPE,
1937: p_attribute4 IN iby_creditcard.attribute4%TYPE,
1938: p_attribute5 IN iby_creditcard.attribute5%TYPE,
1939: p_attribute6 IN iby_creditcard.attribute6%TYPE,
1940: p_attribute7 IN iby_creditcard.attribute7%TYPE,
1941: p_attribute8 IN iby_creditcard.attribute8%TYPE,

Line 1938: p_attribute5 IN iby_creditcard.attribute5%TYPE,

1934: p_attribute1 IN iby_creditcard.attribute1%TYPE,
1935: p_attribute2 IN iby_creditcard.attribute2%TYPE,
1936: p_attribute3 IN iby_creditcard.attribute3%TYPE,
1937: p_attribute4 IN iby_creditcard.attribute4%TYPE,
1938: p_attribute5 IN iby_creditcard.attribute5%TYPE,
1939: p_attribute6 IN iby_creditcard.attribute6%TYPE,
1940: p_attribute7 IN iby_creditcard.attribute7%TYPE,
1941: p_attribute8 IN iby_creditcard.attribute8%TYPE,
1942: p_attribute9 IN iby_creditcard.attribute9%TYPE,

Line 1939: p_attribute6 IN iby_creditcard.attribute6%TYPE,

1935: p_attribute2 IN iby_creditcard.attribute2%TYPE,
1936: p_attribute3 IN iby_creditcard.attribute3%TYPE,
1937: p_attribute4 IN iby_creditcard.attribute4%TYPE,
1938: p_attribute5 IN iby_creditcard.attribute5%TYPE,
1939: p_attribute6 IN iby_creditcard.attribute6%TYPE,
1940: p_attribute7 IN iby_creditcard.attribute7%TYPE,
1941: p_attribute8 IN iby_creditcard.attribute8%TYPE,
1942: p_attribute9 IN iby_creditcard.attribute9%TYPE,
1943: p_attribute10 IN iby_creditcard.attribute10%TYPE,

Line 1940: p_attribute7 IN iby_creditcard.attribute7%TYPE,

1936: p_attribute3 IN iby_creditcard.attribute3%TYPE,
1937: p_attribute4 IN iby_creditcard.attribute4%TYPE,
1938: p_attribute5 IN iby_creditcard.attribute5%TYPE,
1939: p_attribute6 IN iby_creditcard.attribute6%TYPE,
1940: p_attribute7 IN iby_creditcard.attribute7%TYPE,
1941: p_attribute8 IN iby_creditcard.attribute8%TYPE,
1942: p_attribute9 IN iby_creditcard.attribute9%TYPE,
1943: p_attribute10 IN iby_creditcard.attribute10%TYPE,
1944: p_attribute11 IN iby_creditcard.attribute11%TYPE,

Line 1941: p_attribute8 IN iby_creditcard.attribute8%TYPE,

1937: p_attribute4 IN iby_creditcard.attribute4%TYPE,
1938: p_attribute5 IN iby_creditcard.attribute5%TYPE,
1939: p_attribute6 IN iby_creditcard.attribute6%TYPE,
1940: p_attribute7 IN iby_creditcard.attribute7%TYPE,
1941: p_attribute8 IN iby_creditcard.attribute8%TYPE,
1942: p_attribute9 IN iby_creditcard.attribute9%TYPE,
1943: p_attribute10 IN iby_creditcard.attribute10%TYPE,
1944: p_attribute11 IN iby_creditcard.attribute11%TYPE,
1945: p_attribute12 IN iby_creditcard.attribute12%TYPE,

Line 1942: p_attribute9 IN iby_creditcard.attribute9%TYPE,

1938: p_attribute5 IN iby_creditcard.attribute5%TYPE,
1939: p_attribute6 IN iby_creditcard.attribute6%TYPE,
1940: p_attribute7 IN iby_creditcard.attribute7%TYPE,
1941: p_attribute8 IN iby_creditcard.attribute8%TYPE,
1942: p_attribute9 IN iby_creditcard.attribute9%TYPE,
1943: p_attribute10 IN iby_creditcard.attribute10%TYPE,
1944: p_attribute11 IN iby_creditcard.attribute11%TYPE,
1945: p_attribute12 IN iby_creditcard.attribute12%TYPE,
1946: p_attribute13 IN iby_creditcard.attribute13%TYPE,

Line 1943: p_attribute10 IN iby_creditcard.attribute10%TYPE,

1939: p_attribute6 IN iby_creditcard.attribute6%TYPE,
1940: p_attribute7 IN iby_creditcard.attribute7%TYPE,
1941: p_attribute8 IN iby_creditcard.attribute8%TYPE,
1942: p_attribute9 IN iby_creditcard.attribute9%TYPE,
1943: p_attribute10 IN iby_creditcard.attribute10%TYPE,
1944: p_attribute11 IN iby_creditcard.attribute11%TYPE,
1945: p_attribute12 IN iby_creditcard.attribute12%TYPE,
1946: p_attribute13 IN iby_creditcard.attribute13%TYPE,
1947: p_attribute14 IN iby_creditcard.attribute14%TYPE,

Line 1944: p_attribute11 IN iby_creditcard.attribute11%TYPE,

1940: p_attribute7 IN iby_creditcard.attribute7%TYPE,
1941: p_attribute8 IN iby_creditcard.attribute8%TYPE,
1942: p_attribute9 IN iby_creditcard.attribute9%TYPE,
1943: p_attribute10 IN iby_creditcard.attribute10%TYPE,
1944: p_attribute11 IN iby_creditcard.attribute11%TYPE,
1945: p_attribute12 IN iby_creditcard.attribute12%TYPE,
1946: p_attribute13 IN iby_creditcard.attribute13%TYPE,
1947: p_attribute14 IN iby_creditcard.attribute14%TYPE,
1948: p_attribute15 IN iby_creditcard.attribute15%TYPE,

Line 1945: p_attribute12 IN iby_creditcard.attribute12%TYPE,

1941: p_attribute8 IN iby_creditcard.attribute8%TYPE,
1942: p_attribute9 IN iby_creditcard.attribute9%TYPE,
1943: p_attribute10 IN iby_creditcard.attribute10%TYPE,
1944: p_attribute11 IN iby_creditcard.attribute11%TYPE,
1945: p_attribute12 IN iby_creditcard.attribute12%TYPE,
1946: p_attribute13 IN iby_creditcard.attribute13%TYPE,
1947: p_attribute14 IN iby_creditcard.attribute14%TYPE,
1948: p_attribute15 IN iby_creditcard.attribute15%TYPE,
1949: p_attribute16 IN iby_creditcard.attribute16%TYPE,

Line 1946: p_attribute13 IN iby_creditcard.attribute13%TYPE,

1942: p_attribute9 IN iby_creditcard.attribute9%TYPE,
1943: p_attribute10 IN iby_creditcard.attribute10%TYPE,
1944: p_attribute11 IN iby_creditcard.attribute11%TYPE,
1945: p_attribute12 IN iby_creditcard.attribute12%TYPE,
1946: p_attribute13 IN iby_creditcard.attribute13%TYPE,
1947: p_attribute14 IN iby_creditcard.attribute14%TYPE,
1948: p_attribute15 IN iby_creditcard.attribute15%TYPE,
1949: p_attribute16 IN iby_creditcard.attribute16%TYPE,
1950: p_attribute17 IN iby_creditcard.attribute17%TYPE,

Line 1947: p_attribute14 IN iby_creditcard.attribute14%TYPE,

1943: p_attribute10 IN iby_creditcard.attribute10%TYPE,
1944: p_attribute11 IN iby_creditcard.attribute11%TYPE,
1945: p_attribute12 IN iby_creditcard.attribute12%TYPE,
1946: p_attribute13 IN iby_creditcard.attribute13%TYPE,
1947: p_attribute14 IN iby_creditcard.attribute14%TYPE,
1948: p_attribute15 IN iby_creditcard.attribute15%TYPE,
1949: p_attribute16 IN iby_creditcard.attribute16%TYPE,
1950: p_attribute17 IN iby_creditcard.attribute17%TYPE,
1951: p_attribute18 IN iby_creditcard.attribute18%TYPE,

Line 1948: p_attribute15 IN iby_creditcard.attribute15%TYPE,

1944: p_attribute11 IN iby_creditcard.attribute11%TYPE,
1945: p_attribute12 IN iby_creditcard.attribute12%TYPE,
1946: p_attribute13 IN iby_creditcard.attribute13%TYPE,
1947: p_attribute14 IN iby_creditcard.attribute14%TYPE,
1948: p_attribute15 IN iby_creditcard.attribute15%TYPE,
1949: p_attribute16 IN iby_creditcard.attribute16%TYPE,
1950: p_attribute17 IN iby_creditcard.attribute17%TYPE,
1951: p_attribute18 IN iby_creditcard.attribute18%TYPE,
1952: p_attribute19 IN iby_creditcard.attribute19%TYPE,

Line 1949: p_attribute16 IN iby_creditcard.attribute16%TYPE,

1945: p_attribute12 IN iby_creditcard.attribute12%TYPE,
1946: p_attribute13 IN iby_creditcard.attribute13%TYPE,
1947: p_attribute14 IN iby_creditcard.attribute14%TYPE,
1948: p_attribute15 IN iby_creditcard.attribute15%TYPE,
1949: p_attribute16 IN iby_creditcard.attribute16%TYPE,
1950: p_attribute17 IN iby_creditcard.attribute17%TYPE,
1951: p_attribute18 IN iby_creditcard.attribute18%TYPE,
1952: p_attribute19 IN iby_creditcard.attribute19%TYPE,
1953: p_attribute20 IN iby_creditcard.attribute20%TYPE,

Line 1950: p_attribute17 IN iby_creditcard.attribute17%TYPE,

1946: p_attribute13 IN iby_creditcard.attribute13%TYPE,
1947: p_attribute14 IN iby_creditcard.attribute14%TYPE,
1948: p_attribute15 IN iby_creditcard.attribute15%TYPE,
1949: p_attribute16 IN iby_creditcard.attribute16%TYPE,
1950: p_attribute17 IN iby_creditcard.attribute17%TYPE,
1951: p_attribute18 IN iby_creditcard.attribute18%TYPE,
1952: p_attribute19 IN iby_creditcard.attribute19%TYPE,
1953: p_attribute20 IN iby_creditcard.attribute20%TYPE,
1954: p_attribute21 IN iby_creditcard.attribute21%TYPE,

Line 1951: p_attribute18 IN iby_creditcard.attribute18%TYPE,

1947: p_attribute14 IN iby_creditcard.attribute14%TYPE,
1948: p_attribute15 IN iby_creditcard.attribute15%TYPE,
1949: p_attribute16 IN iby_creditcard.attribute16%TYPE,
1950: p_attribute17 IN iby_creditcard.attribute17%TYPE,
1951: p_attribute18 IN iby_creditcard.attribute18%TYPE,
1952: p_attribute19 IN iby_creditcard.attribute19%TYPE,
1953: p_attribute20 IN iby_creditcard.attribute20%TYPE,
1954: p_attribute21 IN iby_creditcard.attribute21%TYPE,
1955: p_attribute22 IN iby_creditcard.attribute22%TYPE,

Line 1952: p_attribute19 IN iby_creditcard.attribute19%TYPE,

1948: p_attribute15 IN iby_creditcard.attribute15%TYPE,
1949: p_attribute16 IN iby_creditcard.attribute16%TYPE,
1950: p_attribute17 IN iby_creditcard.attribute17%TYPE,
1951: p_attribute18 IN iby_creditcard.attribute18%TYPE,
1952: p_attribute19 IN iby_creditcard.attribute19%TYPE,
1953: p_attribute20 IN iby_creditcard.attribute20%TYPE,
1954: p_attribute21 IN iby_creditcard.attribute21%TYPE,
1955: p_attribute22 IN iby_creditcard.attribute22%TYPE,
1956: p_attribute23 IN iby_creditcard.attribute23%TYPE,

Line 1953: p_attribute20 IN iby_creditcard.attribute20%TYPE,

1949: p_attribute16 IN iby_creditcard.attribute16%TYPE,
1950: p_attribute17 IN iby_creditcard.attribute17%TYPE,
1951: p_attribute18 IN iby_creditcard.attribute18%TYPE,
1952: p_attribute19 IN iby_creditcard.attribute19%TYPE,
1953: p_attribute20 IN iby_creditcard.attribute20%TYPE,
1954: p_attribute21 IN iby_creditcard.attribute21%TYPE,
1955: p_attribute22 IN iby_creditcard.attribute22%TYPE,
1956: p_attribute23 IN iby_creditcard.attribute23%TYPE,
1957: p_attribute24 IN iby_creditcard.attribute24%TYPE,

Line 1954: p_attribute21 IN iby_creditcard.attribute21%TYPE,

1950: p_attribute17 IN iby_creditcard.attribute17%TYPE,
1951: p_attribute18 IN iby_creditcard.attribute18%TYPE,
1952: p_attribute19 IN iby_creditcard.attribute19%TYPE,
1953: p_attribute20 IN iby_creditcard.attribute20%TYPE,
1954: p_attribute21 IN iby_creditcard.attribute21%TYPE,
1955: p_attribute22 IN iby_creditcard.attribute22%TYPE,
1956: p_attribute23 IN iby_creditcard.attribute23%TYPE,
1957: p_attribute24 IN iby_creditcard.attribute24%TYPE,
1958: p_attribute25 IN iby_creditcard.attribute25%TYPE,

Line 1955: p_attribute22 IN iby_creditcard.attribute22%TYPE,

1951: p_attribute18 IN iby_creditcard.attribute18%TYPE,
1952: p_attribute19 IN iby_creditcard.attribute19%TYPE,
1953: p_attribute20 IN iby_creditcard.attribute20%TYPE,
1954: p_attribute21 IN iby_creditcard.attribute21%TYPE,
1955: p_attribute22 IN iby_creditcard.attribute22%TYPE,
1956: p_attribute23 IN iby_creditcard.attribute23%TYPE,
1957: p_attribute24 IN iby_creditcard.attribute24%TYPE,
1958: p_attribute25 IN iby_creditcard.attribute25%TYPE,
1959: p_attribute26 IN iby_creditcard.attribute26%TYPE,

Line 1956: p_attribute23 IN iby_creditcard.attribute23%TYPE,

1952: p_attribute19 IN iby_creditcard.attribute19%TYPE,
1953: p_attribute20 IN iby_creditcard.attribute20%TYPE,
1954: p_attribute21 IN iby_creditcard.attribute21%TYPE,
1955: p_attribute22 IN iby_creditcard.attribute22%TYPE,
1956: p_attribute23 IN iby_creditcard.attribute23%TYPE,
1957: p_attribute24 IN iby_creditcard.attribute24%TYPE,
1958: p_attribute25 IN iby_creditcard.attribute25%TYPE,
1959: p_attribute26 IN iby_creditcard.attribute26%TYPE,
1960: p_attribute27 IN iby_creditcard.attribute27%TYPE,

Line 1957: p_attribute24 IN iby_creditcard.attribute24%TYPE,

1953: p_attribute20 IN iby_creditcard.attribute20%TYPE,
1954: p_attribute21 IN iby_creditcard.attribute21%TYPE,
1955: p_attribute22 IN iby_creditcard.attribute22%TYPE,
1956: p_attribute23 IN iby_creditcard.attribute23%TYPE,
1957: p_attribute24 IN iby_creditcard.attribute24%TYPE,
1958: p_attribute25 IN iby_creditcard.attribute25%TYPE,
1959: p_attribute26 IN iby_creditcard.attribute26%TYPE,
1960: p_attribute27 IN iby_creditcard.attribute27%TYPE,
1961: p_attribute28 IN iby_creditcard.attribute28%TYPE,

Line 1958: p_attribute25 IN iby_creditcard.attribute25%TYPE,

1954: p_attribute21 IN iby_creditcard.attribute21%TYPE,
1955: p_attribute22 IN iby_creditcard.attribute22%TYPE,
1956: p_attribute23 IN iby_creditcard.attribute23%TYPE,
1957: p_attribute24 IN iby_creditcard.attribute24%TYPE,
1958: p_attribute25 IN iby_creditcard.attribute25%TYPE,
1959: p_attribute26 IN iby_creditcard.attribute26%TYPE,
1960: p_attribute27 IN iby_creditcard.attribute27%TYPE,
1961: p_attribute28 IN iby_creditcard.attribute28%TYPE,
1962: p_attribute29 IN iby_creditcard.attribute29%TYPE,

Line 1959: p_attribute26 IN iby_creditcard.attribute26%TYPE,

1955: p_attribute22 IN iby_creditcard.attribute22%TYPE,
1956: p_attribute23 IN iby_creditcard.attribute23%TYPE,
1957: p_attribute24 IN iby_creditcard.attribute24%TYPE,
1958: p_attribute25 IN iby_creditcard.attribute25%TYPE,
1959: p_attribute26 IN iby_creditcard.attribute26%TYPE,
1960: p_attribute27 IN iby_creditcard.attribute27%TYPE,
1961: p_attribute28 IN iby_creditcard.attribute28%TYPE,
1962: p_attribute29 IN iby_creditcard.attribute29%TYPE,
1963: p_attribute30 IN iby_creditcard.attribute30%TYPE,

Line 1960: p_attribute27 IN iby_creditcard.attribute27%TYPE,

1956: p_attribute23 IN iby_creditcard.attribute23%TYPE,
1957: p_attribute24 IN iby_creditcard.attribute24%TYPE,
1958: p_attribute25 IN iby_creditcard.attribute25%TYPE,
1959: p_attribute26 IN iby_creditcard.attribute26%TYPE,
1960: p_attribute27 IN iby_creditcard.attribute27%TYPE,
1961: p_attribute28 IN iby_creditcard.attribute28%TYPE,
1962: p_attribute29 IN iby_creditcard.attribute29%TYPE,
1963: p_attribute30 IN iby_creditcard.attribute30%TYPE,
1964: x_result_code OUT NOCOPY VARCHAR2,

Line 1961: p_attribute28 IN iby_creditcard.attribute28%TYPE,

1957: p_attribute24 IN iby_creditcard.attribute24%TYPE,
1958: p_attribute25 IN iby_creditcard.attribute25%TYPE,
1959: p_attribute26 IN iby_creditcard.attribute26%TYPE,
1960: p_attribute27 IN iby_creditcard.attribute27%TYPE,
1961: p_attribute28 IN iby_creditcard.attribute28%TYPE,
1962: p_attribute29 IN iby_creditcard.attribute29%TYPE,
1963: p_attribute30 IN iby_creditcard.attribute30%TYPE,
1964: x_result_code OUT NOCOPY VARCHAR2,
1965: x_return_status OUT NOCOPY VARCHAR2,

Line 1962: p_attribute29 IN iby_creditcard.attribute29%TYPE,

1958: p_attribute25 IN iby_creditcard.attribute25%TYPE,
1959: p_attribute26 IN iby_creditcard.attribute26%TYPE,
1960: p_attribute27 IN iby_creditcard.attribute27%TYPE,
1961: p_attribute28 IN iby_creditcard.attribute28%TYPE,
1962: p_attribute29 IN iby_creditcard.attribute29%TYPE,
1963: p_attribute30 IN iby_creditcard.attribute30%TYPE,
1964: x_result_code OUT NOCOPY VARCHAR2,
1965: x_return_status OUT NOCOPY VARCHAR2,
1966: x_instr_id OUT NOCOPY iby_creditcard.instrid%TYPE

Line 1963: p_attribute30 IN iby_creditcard.attribute30%TYPE,

1959: p_attribute26 IN iby_creditcard.attribute26%TYPE,
1960: p_attribute27 IN iby_creditcard.attribute27%TYPE,
1961: p_attribute28 IN iby_creditcard.attribute28%TYPE,
1962: p_attribute29 IN iby_creditcard.attribute29%TYPE,
1963: p_attribute30 IN iby_creditcard.attribute30%TYPE,
1964: x_result_code OUT NOCOPY VARCHAR2,
1965: x_return_status OUT NOCOPY VARCHAR2,
1966: x_instr_id OUT NOCOPY iby_creditcard.instrid%TYPE
1967: )

Line 1966: x_instr_id OUT NOCOPY iby_creditcard.instrid%TYPE

1962: p_attribute29 IN iby_creditcard.attribute29%TYPE,
1963: p_attribute30 IN iby_creditcard.attribute30%TYPE,
1964: x_result_code OUT NOCOPY VARCHAR2,
1965: x_return_status OUT NOCOPY VARCHAR2,
1966: x_instr_id OUT NOCOPY iby_creditcard.instrid%TYPE
1967: )
1968: IS
1969: -- create a record type and populate it
1970: x_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;

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

2061: lx_result_code VARCHAR2(30);
2062: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2063: lx_card_rec CreditCard_rec_type;
2064:
2065: l_info_only iby_creditcard.information_only_flag%TYPE := NULL;
2066: l_sec_mode iby_sys_security_options.cc_encryption_mode%TYPE;
2067: l_cc_reg IBY_INSTRREG_PUB.CreditCardInstr_rec_type;
2068: l_instr_reg IBY_INSTRREG_PUB.PmtInstr_rec_type;
2069:

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

2124: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2125:
2126: -- validate billing address information
2127: IF (NOT Validate_CC_Billing(FND_API.G_FALSE,p_card_instrument)) THEN
2128: x_response.Result_Code := iby_creditcard_pkg.G_RC_INVALID_ADDRESS;
2129: iby_fndcpt_common_pub.Prepare_Result
2130: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2131: RETURN;
2132: END IF;

Line 2135: -- These validations have been moved from iby_creditcard_pkg because the TCA

2131: RETURN;
2132: END IF;
2133:
2134: -- lmallick (bug# 8721435)
2135: -- These validations have been moved from iby_creditcard_pkg because the TCA
2136: -- data might not have been committed to the db before invoking the Create_card API
2137: iby_debug_pub.add('Starting address validation ..',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2138:
2139: -- If Site use id is already provied then no need to call get_billing address

Line 2142: IF (p_card_instrument.Address_Type = IBY_CREDITCARD_PKG.G_PARTY_SITE_USE_ID) AND

2138:
2139: -- If Site use id is already provied then no need to call get_billing address
2140: iby_debug_pub.add('p_card_instrument.Address_Type = '||p_card_instrument.Address_Type,
2141: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2142: IF (p_card_instrument.Address_Type = IBY_CREDITCARD_PKG.G_PARTY_SITE_USE_ID) AND
2143: (NOT (p_card_instrument.Billing_Address_Id IS NULL)) THEN
2144: l_billing_site := p_card_instrument.Billing_Address_Id;
2145: ELSE
2146: IF (p_card_instrument.Billing_Address_Id = FND_API.G_MISS_NUM ) THEN

Line 2150: IBY_CREDITCARD_PKG.Get_Billing_Site(p_card_instrument.Billing_Address_Id,

2146: IF (p_card_instrument.Billing_Address_Id = FND_API.G_MISS_NUM ) THEN
2147: l_billing_site := FND_API.G_MISS_NUM;
2148: ELSIF (NOT (p_card_instrument.Billing_Address_Id IS NULL)) THEN
2149: l_billing_site :=
2150: IBY_CREDITCARD_PKG.Get_Billing_Site(p_card_instrument.Billing_Address_Id,
2151: p_card_instrument.Owner_Id);
2152: IF (l_billing_site IS NULL) THEN
2153: x_response.Result_Code := IBY_CREDITCARD_PKG.G_RC_INVALID_ADDRESS;
2154: iby_debug_pub.add('Invalid Billing site.',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 2153: x_response.Result_Code := IBY_CREDITCARD_PKG.G_RC_INVALID_ADDRESS;

2149: l_billing_site :=
2150: IBY_CREDITCARD_PKG.Get_Billing_Site(p_card_instrument.Billing_Address_Id,
2151: p_card_instrument.Owner_Id);
2152: IF (l_billing_site IS NULL) THEN
2153: x_response.Result_Code := IBY_CREDITCARD_PKG.G_RC_INVALID_ADDRESS;
2154: iby_debug_pub.add('Invalid Billing site.',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2155: iby_fndcpt_common_pub.Prepare_Result
2156: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2157: RETURN;

Line 2170: x_response.Result_Code := IBY_CREDITCARD_PKG.G_RC_INVALID_ADDRESS;

2166: OR (p_card_instrument.Billing_Address_Territory = FND_API.G_MISS_CHAR) )
2167: )
2168: THEN
2169: IF (NOT iby_utility_pvt.Validate_Territory(p_card_instrument.Billing_Address_Territory)) THEN
2170: x_response.Result_Code := IBY_CREDITCARD_PKG.G_RC_INVALID_ADDRESS;
2171: iby_debug_pub.add('Invalid Territory '|| p_card_instrument.Billing_Address_Territory,
2172: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2173: iby_fndcpt_common_pub.Prepare_Result
2174: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);

Line 2181: x_response.Result_Code := IBY_CREDITCARD_PKG.G_RC_INVALID_PARTY;

2177: END IF;
2178:
2179: IF (NOT p_card_instrument.Owner_Id IS NULL) THEN
2180: IF (NOT iby_utility_pvt.validate_party_id(p_card_instrument.Owner_Id)) THEN
2181: x_response.Result_Code := IBY_CREDITCARD_PKG.G_RC_INVALID_PARTY;
2182: iby_debug_pub.add('Invalid Owner party '||p_card_instrument.Owner_Id,
2183: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2184: iby_fndcpt_common_pub.Prepare_Result
2185: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);

Line 2264: iby_creditcard_pkg.Create_Card

2260: ELSE
2261: iby_debug_pub.add('database registration',
2262: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2263:
2264: iby_creditcard_pkg.Create_Card
2265: (FND_API.G_FALSE,
2266: p_card_instrument.Owner_Id, p_card_instrument.Card_Holder_Name,
2267: l_billing_site,
2268: p_card_instrument.Address_Type,

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

2322: END IF;
2323:
2324: -- validate billing address information
2325: IF (NOT Validate_CC_Billing(FND_API.G_TRUE,p_card_instrument)) THEN
2326: x_response.Result_Code := iby_creditcard_pkg.G_RC_INVALID_ADDRESS;
2327: iby_fndcpt_common_pub.Prepare_Result
2328: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2329: RETURN;
2330: END IF;

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

2330: END IF;
2331: -- validate expiration date
2332: IF (TRUNC(p_card_instrument.Expiration_Date,'DD') < TRUNC(SYSDATE,'DD'))
2333: THEN
2334: x_response.Result_Code := iby_creditcard_pkg.G_RC_INVALID_CCEXPIRY;
2335: iby_fndcpt_common_pub.Prepare_Result
2336: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2337: RETURN;
2338: END IF;

Line 2340: iby_creditcard_pkg.Update_Card

2336: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2337: RETURN;
2338: END IF;
2339:
2340: iby_creditcard_pkg.Update_Card
2341: (FND_API.G_FALSE, lx_card_rec.Card_Id, p_card_instrument.Owner_Id,
2342: p_card_instrument.Card_Holder_Name,
2343: p_card_instrument.Billing_Address_Id,
2344: p_card_instrument.Address_Type,

Line 2431: p_instr_id IN iby_creditcard.instrid%TYPE,

2427:
2428: PROCEDURE Update_Card_Wrapper
2429: (
2430: p_commit IN VARCHAR2,
2431: p_instr_id IN iby_creditcard.instrid%TYPE,
2432: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
2433: p_holder_name IN iby_creditcard.chname%TYPE,
2434: p_billing_address_id IN iby_creditcard.addressid%TYPE,
2435: p_address_type IN VARCHAR2,

Line 2432: p_owner_id IN iby_creditcard.card_owner_id%TYPE,

2428: PROCEDURE Update_Card_Wrapper
2429: (
2430: p_commit IN VARCHAR2,
2431: p_instr_id IN iby_creditcard.instrid%TYPE,
2432: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
2433: p_holder_name IN iby_creditcard.chname%TYPE,
2434: p_billing_address_id IN iby_creditcard.addressid%TYPE,
2435: p_address_type IN VARCHAR2,
2436: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,

Line 2433: p_holder_name IN iby_creditcard.chname%TYPE,

2429: (
2430: p_commit IN VARCHAR2,
2431: p_instr_id IN iby_creditcard.instrid%TYPE,
2432: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
2433: p_holder_name IN iby_creditcard.chname%TYPE,
2434: p_billing_address_id IN iby_creditcard.addressid%TYPE,
2435: p_address_type IN VARCHAR2,
2436: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
2437: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,

Line 2434: p_billing_address_id IN iby_creditcard.addressid%TYPE,

2430: p_commit IN VARCHAR2,
2431: p_instr_id IN iby_creditcard.instrid%TYPE,
2432: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
2433: p_holder_name IN iby_creditcard.chname%TYPE,
2434: p_billing_address_id IN iby_creditcard.addressid%TYPE,
2435: p_address_type IN VARCHAR2,
2436: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
2437: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
2438: p_expiry_date IN iby_creditcard.expirydate%TYPE,

Line 2436: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,

2432: p_owner_id IN iby_creditcard.card_owner_id%TYPE,
2433: p_holder_name IN iby_creditcard.chname%TYPE,
2434: p_billing_address_id IN iby_creditcard.addressid%TYPE,
2435: p_address_type IN VARCHAR2,
2436: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
2437: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
2438: p_expiry_date IN iby_creditcard.expirydate%TYPE,
2439: p_instr_type IN iby_creditcard.instrument_type%TYPE,
2440: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,

Line 2437: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,

2433: p_holder_name IN iby_creditcard.chname%TYPE,
2434: p_billing_address_id IN iby_creditcard.addressid%TYPE,
2435: p_address_type IN VARCHAR2,
2436: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
2437: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
2438: p_expiry_date IN iby_creditcard.expirydate%TYPE,
2439: p_instr_type IN iby_creditcard.instrument_type%TYPE,
2440: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
2441: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,

Line 2438: p_expiry_date IN iby_creditcard.expirydate%TYPE,

2434: p_billing_address_id IN iby_creditcard.addressid%TYPE,
2435: p_address_type IN VARCHAR2,
2436: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
2437: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
2438: p_expiry_date IN iby_creditcard.expirydate%TYPE,
2439: p_instr_type IN iby_creditcard.instrument_type%TYPE,
2440: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
2441: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
2442: p_fi_name IN iby_creditcard.finame%TYPE,

Line 2439: p_instr_type IN iby_creditcard.instrument_type%TYPE,

2435: p_address_type IN VARCHAR2,
2436: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
2437: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
2438: p_expiry_date IN iby_creditcard.expirydate%TYPE,
2439: p_instr_type IN iby_creditcard.instrument_type%TYPE,
2440: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
2441: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
2442: p_fi_name IN iby_creditcard.finame%TYPE,
2443: p_single_use IN iby_creditcard.single_use_flag%TYPE,

Line 2440: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,

2436: p_billing_zip IN iby_creditcard.billing_addr_postal_code%TYPE,
2437: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
2438: p_expiry_date IN iby_creditcard.expirydate%TYPE,
2439: p_instr_type IN iby_creditcard.instrument_type%TYPE,
2440: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
2441: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
2442: p_fi_name IN iby_creditcard.finame%TYPE,
2443: p_single_use IN iby_creditcard.single_use_flag%TYPE,
2444: p_info_only IN iby_creditcard.information_only_flag%TYPE,

Line 2441: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,

2437: p_billing_country IN iby_creditcard.bill_addr_territory_code%TYPE,
2438: p_expiry_date IN iby_creditcard.expirydate%TYPE,
2439: p_instr_type IN iby_creditcard.instrument_type%TYPE,
2440: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
2441: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
2442: p_fi_name IN iby_creditcard.finame%TYPE,
2443: p_single_use IN iby_creditcard.single_use_flag%TYPE,
2444: p_info_only IN iby_creditcard.information_only_flag%TYPE,
2445: p_purpose IN iby_creditcard.card_purpose%TYPE,

Line 2442: p_fi_name IN iby_creditcard.finame%TYPE,

2438: p_expiry_date IN iby_creditcard.expirydate%TYPE,
2439: p_instr_type IN iby_creditcard.instrument_type%TYPE,
2440: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
2441: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
2442: p_fi_name IN iby_creditcard.finame%TYPE,
2443: p_single_use IN iby_creditcard.single_use_flag%TYPE,
2444: p_info_only IN iby_creditcard.information_only_flag%TYPE,
2445: p_purpose IN iby_creditcard.card_purpose%TYPE,
2446: p_desc IN iby_creditcard.description%TYPE,

Line 2443: p_single_use IN iby_creditcard.single_use_flag%TYPE,

2439: p_instr_type IN iby_creditcard.instrument_type%TYPE,
2440: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
2441: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
2442: p_fi_name IN iby_creditcard.finame%TYPE,
2443: p_single_use IN iby_creditcard.single_use_flag%TYPE,
2444: p_info_only IN iby_creditcard.information_only_flag%TYPE,
2445: p_purpose IN iby_creditcard.card_purpose%TYPE,
2446: p_desc IN iby_creditcard.description%TYPE,
2447: p_active_flag IN iby_creditcard.active_flag%TYPE,

Line 2444: p_info_only IN iby_creditcard.information_only_flag%TYPE,

2440: p_pcard_flag IN iby_creditcard.purchasecard_flag%TYPE,
2441: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
2442: p_fi_name IN iby_creditcard.finame%TYPE,
2443: p_single_use IN iby_creditcard.single_use_flag%TYPE,
2444: p_info_only IN iby_creditcard.information_only_flag%TYPE,
2445: p_purpose IN iby_creditcard.card_purpose%TYPE,
2446: p_desc IN iby_creditcard.description%TYPE,
2447: p_active_flag IN iby_creditcard.active_flag%TYPE,
2448: p_inactive_date IN iby_creditcard.inactive_date%TYPE,

Line 2445: p_purpose IN iby_creditcard.card_purpose%TYPE,

2441: p_pcard_type IN iby_creditcard.purchasecard_subtype%TYPE,
2442: p_fi_name IN iby_creditcard.finame%TYPE,
2443: p_single_use IN iby_creditcard.single_use_flag%TYPE,
2444: p_info_only IN iby_creditcard.information_only_flag%TYPE,
2445: p_purpose IN iby_creditcard.card_purpose%TYPE,
2446: p_desc IN iby_creditcard.description%TYPE,
2447: p_active_flag IN iby_creditcard.active_flag%TYPE,
2448: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
2449: p_attribute_category IN iby_creditcard.attribute_category%TYPE,

Line 2446: p_desc IN iby_creditcard.description%TYPE,

2442: p_fi_name IN iby_creditcard.finame%TYPE,
2443: p_single_use IN iby_creditcard.single_use_flag%TYPE,
2444: p_info_only IN iby_creditcard.information_only_flag%TYPE,
2445: p_purpose IN iby_creditcard.card_purpose%TYPE,
2446: p_desc IN iby_creditcard.description%TYPE,
2447: p_active_flag IN iby_creditcard.active_flag%TYPE,
2448: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
2449: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
2450: p_attribute1 IN iby_creditcard.attribute1%TYPE,

Line 2447: p_active_flag IN iby_creditcard.active_flag%TYPE,

2443: p_single_use IN iby_creditcard.single_use_flag%TYPE,
2444: p_info_only IN iby_creditcard.information_only_flag%TYPE,
2445: p_purpose IN iby_creditcard.card_purpose%TYPE,
2446: p_desc IN iby_creditcard.description%TYPE,
2447: p_active_flag IN iby_creditcard.active_flag%TYPE,
2448: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
2449: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
2450: p_attribute1 IN iby_creditcard.attribute1%TYPE,
2451: p_attribute2 IN iby_creditcard.attribute2%TYPE,

Line 2448: p_inactive_date IN iby_creditcard.inactive_date%TYPE,

2444: p_info_only IN iby_creditcard.information_only_flag%TYPE,
2445: p_purpose IN iby_creditcard.card_purpose%TYPE,
2446: p_desc IN iby_creditcard.description%TYPE,
2447: p_active_flag IN iby_creditcard.active_flag%TYPE,
2448: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
2449: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
2450: p_attribute1 IN iby_creditcard.attribute1%TYPE,
2451: p_attribute2 IN iby_creditcard.attribute2%TYPE,
2452: p_attribute3 IN iby_creditcard.attribute3%TYPE,

Line 2449: p_attribute_category IN iby_creditcard.attribute_category%TYPE,

2445: p_purpose IN iby_creditcard.card_purpose%TYPE,
2446: p_desc IN iby_creditcard.description%TYPE,
2447: p_active_flag IN iby_creditcard.active_flag%TYPE,
2448: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
2449: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
2450: p_attribute1 IN iby_creditcard.attribute1%TYPE,
2451: p_attribute2 IN iby_creditcard.attribute2%TYPE,
2452: p_attribute3 IN iby_creditcard.attribute3%TYPE,
2453: p_attribute4 IN iby_creditcard.attribute4%TYPE,

Line 2450: p_attribute1 IN iby_creditcard.attribute1%TYPE,

2446: p_desc IN iby_creditcard.description%TYPE,
2447: p_active_flag IN iby_creditcard.active_flag%TYPE,
2448: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
2449: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
2450: p_attribute1 IN iby_creditcard.attribute1%TYPE,
2451: p_attribute2 IN iby_creditcard.attribute2%TYPE,
2452: p_attribute3 IN iby_creditcard.attribute3%TYPE,
2453: p_attribute4 IN iby_creditcard.attribute4%TYPE,
2454: p_attribute5 IN iby_creditcard.attribute5%TYPE,

Line 2451: p_attribute2 IN iby_creditcard.attribute2%TYPE,

2447: p_active_flag IN iby_creditcard.active_flag%TYPE,
2448: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
2449: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
2450: p_attribute1 IN iby_creditcard.attribute1%TYPE,
2451: p_attribute2 IN iby_creditcard.attribute2%TYPE,
2452: p_attribute3 IN iby_creditcard.attribute3%TYPE,
2453: p_attribute4 IN iby_creditcard.attribute4%TYPE,
2454: p_attribute5 IN iby_creditcard.attribute5%TYPE,
2455: p_attribute6 IN iby_creditcard.attribute6%TYPE,

Line 2452: p_attribute3 IN iby_creditcard.attribute3%TYPE,

2448: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
2449: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
2450: p_attribute1 IN iby_creditcard.attribute1%TYPE,
2451: p_attribute2 IN iby_creditcard.attribute2%TYPE,
2452: p_attribute3 IN iby_creditcard.attribute3%TYPE,
2453: p_attribute4 IN iby_creditcard.attribute4%TYPE,
2454: p_attribute5 IN iby_creditcard.attribute5%TYPE,
2455: p_attribute6 IN iby_creditcard.attribute6%TYPE,
2456: p_attribute7 IN iby_creditcard.attribute7%TYPE,

Line 2453: p_attribute4 IN iby_creditcard.attribute4%TYPE,

2449: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
2450: p_attribute1 IN iby_creditcard.attribute1%TYPE,
2451: p_attribute2 IN iby_creditcard.attribute2%TYPE,
2452: p_attribute3 IN iby_creditcard.attribute3%TYPE,
2453: p_attribute4 IN iby_creditcard.attribute4%TYPE,
2454: p_attribute5 IN iby_creditcard.attribute5%TYPE,
2455: p_attribute6 IN iby_creditcard.attribute6%TYPE,
2456: p_attribute7 IN iby_creditcard.attribute7%TYPE,
2457: p_attribute8 IN iby_creditcard.attribute8%TYPE,

Line 2454: p_attribute5 IN iby_creditcard.attribute5%TYPE,

2450: p_attribute1 IN iby_creditcard.attribute1%TYPE,
2451: p_attribute2 IN iby_creditcard.attribute2%TYPE,
2452: p_attribute3 IN iby_creditcard.attribute3%TYPE,
2453: p_attribute4 IN iby_creditcard.attribute4%TYPE,
2454: p_attribute5 IN iby_creditcard.attribute5%TYPE,
2455: p_attribute6 IN iby_creditcard.attribute6%TYPE,
2456: p_attribute7 IN iby_creditcard.attribute7%TYPE,
2457: p_attribute8 IN iby_creditcard.attribute8%TYPE,
2458: p_attribute9 IN iby_creditcard.attribute9%TYPE,

Line 2455: p_attribute6 IN iby_creditcard.attribute6%TYPE,

2451: p_attribute2 IN iby_creditcard.attribute2%TYPE,
2452: p_attribute3 IN iby_creditcard.attribute3%TYPE,
2453: p_attribute4 IN iby_creditcard.attribute4%TYPE,
2454: p_attribute5 IN iby_creditcard.attribute5%TYPE,
2455: p_attribute6 IN iby_creditcard.attribute6%TYPE,
2456: p_attribute7 IN iby_creditcard.attribute7%TYPE,
2457: p_attribute8 IN iby_creditcard.attribute8%TYPE,
2458: p_attribute9 IN iby_creditcard.attribute9%TYPE,
2459: p_attribute10 IN iby_creditcard.attribute10%TYPE,

Line 2456: p_attribute7 IN iby_creditcard.attribute7%TYPE,

2452: p_attribute3 IN iby_creditcard.attribute3%TYPE,
2453: p_attribute4 IN iby_creditcard.attribute4%TYPE,
2454: p_attribute5 IN iby_creditcard.attribute5%TYPE,
2455: p_attribute6 IN iby_creditcard.attribute6%TYPE,
2456: p_attribute7 IN iby_creditcard.attribute7%TYPE,
2457: p_attribute8 IN iby_creditcard.attribute8%TYPE,
2458: p_attribute9 IN iby_creditcard.attribute9%TYPE,
2459: p_attribute10 IN iby_creditcard.attribute10%TYPE,
2460: p_attribute11 IN iby_creditcard.attribute11%TYPE,

Line 2457: p_attribute8 IN iby_creditcard.attribute8%TYPE,

2453: p_attribute4 IN iby_creditcard.attribute4%TYPE,
2454: p_attribute5 IN iby_creditcard.attribute5%TYPE,
2455: p_attribute6 IN iby_creditcard.attribute6%TYPE,
2456: p_attribute7 IN iby_creditcard.attribute7%TYPE,
2457: p_attribute8 IN iby_creditcard.attribute8%TYPE,
2458: p_attribute9 IN iby_creditcard.attribute9%TYPE,
2459: p_attribute10 IN iby_creditcard.attribute10%TYPE,
2460: p_attribute11 IN iby_creditcard.attribute11%TYPE,
2461: p_attribute12 IN iby_creditcard.attribute12%TYPE,

Line 2458: p_attribute9 IN iby_creditcard.attribute9%TYPE,

2454: p_attribute5 IN iby_creditcard.attribute5%TYPE,
2455: p_attribute6 IN iby_creditcard.attribute6%TYPE,
2456: p_attribute7 IN iby_creditcard.attribute7%TYPE,
2457: p_attribute8 IN iby_creditcard.attribute8%TYPE,
2458: p_attribute9 IN iby_creditcard.attribute9%TYPE,
2459: p_attribute10 IN iby_creditcard.attribute10%TYPE,
2460: p_attribute11 IN iby_creditcard.attribute11%TYPE,
2461: p_attribute12 IN iby_creditcard.attribute12%TYPE,
2462: p_attribute13 IN iby_creditcard.attribute13%TYPE,

Line 2459: p_attribute10 IN iby_creditcard.attribute10%TYPE,

2455: p_attribute6 IN iby_creditcard.attribute6%TYPE,
2456: p_attribute7 IN iby_creditcard.attribute7%TYPE,
2457: p_attribute8 IN iby_creditcard.attribute8%TYPE,
2458: p_attribute9 IN iby_creditcard.attribute9%TYPE,
2459: p_attribute10 IN iby_creditcard.attribute10%TYPE,
2460: p_attribute11 IN iby_creditcard.attribute11%TYPE,
2461: p_attribute12 IN iby_creditcard.attribute12%TYPE,
2462: p_attribute13 IN iby_creditcard.attribute13%TYPE,
2463: p_attribute14 IN iby_creditcard.attribute14%TYPE,

Line 2460: p_attribute11 IN iby_creditcard.attribute11%TYPE,

2456: p_attribute7 IN iby_creditcard.attribute7%TYPE,
2457: p_attribute8 IN iby_creditcard.attribute8%TYPE,
2458: p_attribute9 IN iby_creditcard.attribute9%TYPE,
2459: p_attribute10 IN iby_creditcard.attribute10%TYPE,
2460: p_attribute11 IN iby_creditcard.attribute11%TYPE,
2461: p_attribute12 IN iby_creditcard.attribute12%TYPE,
2462: p_attribute13 IN iby_creditcard.attribute13%TYPE,
2463: p_attribute14 IN iby_creditcard.attribute14%TYPE,
2464: p_attribute15 IN iby_creditcard.attribute15%TYPE,

Line 2461: p_attribute12 IN iby_creditcard.attribute12%TYPE,

2457: p_attribute8 IN iby_creditcard.attribute8%TYPE,
2458: p_attribute9 IN iby_creditcard.attribute9%TYPE,
2459: p_attribute10 IN iby_creditcard.attribute10%TYPE,
2460: p_attribute11 IN iby_creditcard.attribute11%TYPE,
2461: p_attribute12 IN iby_creditcard.attribute12%TYPE,
2462: p_attribute13 IN iby_creditcard.attribute13%TYPE,
2463: p_attribute14 IN iby_creditcard.attribute14%TYPE,
2464: p_attribute15 IN iby_creditcard.attribute15%TYPE,
2465: p_attribute16 IN iby_creditcard.attribute16%TYPE,

Line 2462: p_attribute13 IN iby_creditcard.attribute13%TYPE,

2458: p_attribute9 IN iby_creditcard.attribute9%TYPE,
2459: p_attribute10 IN iby_creditcard.attribute10%TYPE,
2460: p_attribute11 IN iby_creditcard.attribute11%TYPE,
2461: p_attribute12 IN iby_creditcard.attribute12%TYPE,
2462: p_attribute13 IN iby_creditcard.attribute13%TYPE,
2463: p_attribute14 IN iby_creditcard.attribute14%TYPE,
2464: p_attribute15 IN iby_creditcard.attribute15%TYPE,
2465: p_attribute16 IN iby_creditcard.attribute16%TYPE,
2466: p_attribute17 IN iby_creditcard.attribute17%TYPE,

Line 2463: p_attribute14 IN iby_creditcard.attribute14%TYPE,

2459: p_attribute10 IN iby_creditcard.attribute10%TYPE,
2460: p_attribute11 IN iby_creditcard.attribute11%TYPE,
2461: p_attribute12 IN iby_creditcard.attribute12%TYPE,
2462: p_attribute13 IN iby_creditcard.attribute13%TYPE,
2463: p_attribute14 IN iby_creditcard.attribute14%TYPE,
2464: p_attribute15 IN iby_creditcard.attribute15%TYPE,
2465: p_attribute16 IN iby_creditcard.attribute16%TYPE,
2466: p_attribute17 IN iby_creditcard.attribute17%TYPE,
2467: p_attribute18 IN iby_creditcard.attribute18%TYPE,

Line 2464: p_attribute15 IN iby_creditcard.attribute15%TYPE,

2460: p_attribute11 IN iby_creditcard.attribute11%TYPE,
2461: p_attribute12 IN iby_creditcard.attribute12%TYPE,
2462: p_attribute13 IN iby_creditcard.attribute13%TYPE,
2463: p_attribute14 IN iby_creditcard.attribute14%TYPE,
2464: p_attribute15 IN iby_creditcard.attribute15%TYPE,
2465: p_attribute16 IN iby_creditcard.attribute16%TYPE,
2466: p_attribute17 IN iby_creditcard.attribute17%TYPE,
2467: p_attribute18 IN iby_creditcard.attribute18%TYPE,
2468: p_attribute19 IN iby_creditcard.attribute19%TYPE,

Line 2465: p_attribute16 IN iby_creditcard.attribute16%TYPE,

2461: p_attribute12 IN iby_creditcard.attribute12%TYPE,
2462: p_attribute13 IN iby_creditcard.attribute13%TYPE,
2463: p_attribute14 IN iby_creditcard.attribute14%TYPE,
2464: p_attribute15 IN iby_creditcard.attribute15%TYPE,
2465: p_attribute16 IN iby_creditcard.attribute16%TYPE,
2466: p_attribute17 IN iby_creditcard.attribute17%TYPE,
2467: p_attribute18 IN iby_creditcard.attribute18%TYPE,
2468: p_attribute19 IN iby_creditcard.attribute19%TYPE,
2469: p_attribute20 IN iby_creditcard.attribute20%TYPE,

Line 2466: p_attribute17 IN iby_creditcard.attribute17%TYPE,

2462: p_attribute13 IN iby_creditcard.attribute13%TYPE,
2463: p_attribute14 IN iby_creditcard.attribute14%TYPE,
2464: p_attribute15 IN iby_creditcard.attribute15%TYPE,
2465: p_attribute16 IN iby_creditcard.attribute16%TYPE,
2466: p_attribute17 IN iby_creditcard.attribute17%TYPE,
2467: p_attribute18 IN iby_creditcard.attribute18%TYPE,
2468: p_attribute19 IN iby_creditcard.attribute19%TYPE,
2469: p_attribute20 IN iby_creditcard.attribute20%TYPE,
2470: p_attribute21 IN iby_creditcard.attribute21%TYPE,

Line 2467: p_attribute18 IN iby_creditcard.attribute18%TYPE,

2463: p_attribute14 IN iby_creditcard.attribute14%TYPE,
2464: p_attribute15 IN iby_creditcard.attribute15%TYPE,
2465: p_attribute16 IN iby_creditcard.attribute16%TYPE,
2466: p_attribute17 IN iby_creditcard.attribute17%TYPE,
2467: p_attribute18 IN iby_creditcard.attribute18%TYPE,
2468: p_attribute19 IN iby_creditcard.attribute19%TYPE,
2469: p_attribute20 IN iby_creditcard.attribute20%TYPE,
2470: p_attribute21 IN iby_creditcard.attribute21%TYPE,
2471: p_attribute22 IN iby_creditcard.attribute22%TYPE,

Line 2468: p_attribute19 IN iby_creditcard.attribute19%TYPE,

2464: p_attribute15 IN iby_creditcard.attribute15%TYPE,
2465: p_attribute16 IN iby_creditcard.attribute16%TYPE,
2466: p_attribute17 IN iby_creditcard.attribute17%TYPE,
2467: p_attribute18 IN iby_creditcard.attribute18%TYPE,
2468: p_attribute19 IN iby_creditcard.attribute19%TYPE,
2469: p_attribute20 IN iby_creditcard.attribute20%TYPE,
2470: p_attribute21 IN iby_creditcard.attribute21%TYPE,
2471: p_attribute22 IN iby_creditcard.attribute22%TYPE,
2472: p_attribute23 IN iby_creditcard.attribute23%TYPE,

Line 2469: p_attribute20 IN iby_creditcard.attribute20%TYPE,

2465: p_attribute16 IN iby_creditcard.attribute16%TYPE,
2466: p_attribute17 IN iby_creditcard.attribute17%TYPE,
2467: p_attribute18 IN iby_creditcard.attribute18%TYPE,
2468: p_attribute19 IN iby_creditcard.attribute19%TYPE,
2469: p_attribute20 IN iby_creditcard.attribute20%TYPE,
2470: p_attribute21 IN iby_creditcard.attribute21%TYPE,
2471: p_attribute22 IN iby_creditcard.attribute22%TYPE,
2472: p_attribute23 IN iby_creditcard.attribute23%TYPE,
2473: p_attribute24 IN iby_creditcard.attribute24%TYPE,

Line 2470: p_attribute21 IN iby_creditcard.attribute21%TYPE,

2466: p_attribute17 IN iby_creditcard.attribute17%TYPE,
2467: p_attribute18 IN iby_creditcard.attribute18%TYPE,
2468: p_attribute19 IN iby_creditcard.attribute19%TYPE,
2469: p_attribute20 IN iby_creditcard.attribute20%TYPE,
2470: p_attribute21 IN iby_creditcard.attribute21%TYPE,
2471: p_attribute22 IN iby_creditcard.attribute22%TYPE,
2472: p_attribute23 IN iby_creditcard.attribute23%TYPE,
2473: p_attribute24 IN iby_creditcard.attribute24%TYPE,
2474: p_attribute25 IN iby_creditcard.attribute25%TYPE,

Line 2471: p_attribute22 IN iby_creditcard.attribute22%TYPE,

2467: p_attribute18 IN iby_creditcard.attribute18%TYPE,
2468: p_attribute19 IN iby_creditcard.attribute19%TYPE,
2469: p_attribute20 IN iby_creditcard.attribute20%TYPE,
2470: p_attribute21 IN iby_creditcard.attribute21%TYPE,
2471: p_attribute22 IN iby_creditcard.attribute22%TYPE,
2472: p_attribute23 IN iby_creditcard.attribute23%TYPE,
2473: p_attribute24 IN iby_creditcard.attribute24%TYPE,
2474: p_attribute25 IN iby_creditcard.attribute25%TYPE,
2475: p_attribute26 IN iby_creditcard.attribute26%TYPE,

Line 2472: p_attribute23 IN iby_creditcard.attribute23%TYPE,

2468: p_attribute19 IN iby_creditcard.attribute19%TYPE,
2469: p_attribute20 IN iby_creditcard.attribute20%TYPE,
2470: p_attribute21 IN iby_creditcard.attribute21%TYPE,
2471: p_attribute22 IN iby_creditcard.attribute22%TYPE,
2472: p_attribute23 IN iby_creditcard.attribute23%TYPE,
2473: p_attribute24 IN iby_creditcard.attribute24%TYPE,
2474: p_attribute25 IN iby_creditcard.attribute25%TYPE,
2475: p_attribute26 IN iby_creditcard.attribute26%TYPE,
2476: p_attribute27 IN iby_creditcard.attribute27%TYPE,

Line 2473: p_attribute24 IN iby_creditcard.attribute24%TYPE,

2469: p_attribute20 IN iby_creditcard.attribute20%TYPE,
2470: p_attribute21 IN iby_creditcard.attribute21%TYPE,
2471: p_attribute22 IN iby_creditcard.attribute22%TYPE,
2472: p_attribute23 IN iby_creditcard.attribute23%TYPE,
2473: p_attribute24 IN iby_creditcard.attribute24%TYPE,
2474: p_attribute25 IN iby_creditcard.attribute25%TYPE,
2475: p_attribute26 IN iby_creditcard.attribute26%TYPE,
2476: p_attribute27 IN iby_creditcard.attribute27%TYPE,
2477: p_attribute28 IN iby_creditcard.attribute28%TYPE,

Line 2474: p_attribute25 IN iby_creditcard.attribute25%TYPE,

2470: p_attribute21 IN iby_creditcard.attribute21%TYPE,
2471: p_attribute22 IN iby_creditcard.attribute22%TYPE,
2472: p_attribute23 IN iby_creditcard.attribute23%TYPE,
2473: p_attribute24 IN iby_creditcard.attribute24%TYPE,
2474: p_attribute25 IN iby_creditcard.attribute25%TYPE,
2475: p_attribute26 IN iby_creditcard.attribute26%TYPE,
2476: p_attribute27 IN iby_creditcard.attribute27%TYPE,
2477: p_attribute28 IN iby_creditcard.attribute28%TYPE,
2478: p_attribute29 IN iby_creditcard.attribute29%TYPE,

Line 2475: p_attribute26 IN iby_creditcard.attribute26%TYPE,

2471: p_attribute22 IN iby_creditcard.attribute22%TYPE,
2472: p_attribute23 IN iby_creditcard.attribute23%TYPE,
2473: p_attribute24 IN iby_creditcard.attribute24%TYPE,
2474: p_attribute25 IN iby_creditcard.attribute25%TYPE,
2475: p_attribute26 IN iby_creditcard.attribute26%TYPE,
2476: p_attribute27 IN iby_creditcard.attribute27%TYPE,
2477: p_attribute28 IN iby_creditcard.attribute28%TYPE,
2478: p_attribute29 IN iby_creditcard.attribute29%TYPE,
2479: p_attribute30 IN iby_creditcard.attribute30%TYPE,

Line 2476: p_attribute27 IN iby_creditcard.attribute27%TYPE,

2472: p_attribute23 IN iby_creditcard.attribute23%TYPE,
2473: p_attribute24 IN iby_creditcard.attribute24%TYPE,
2474: p_attribute25 IN iby_creditcard.attribute25%TYPE,
2475: p_attribute26 IN iby_creditcard.attribute26%TYPE,
2476: p_attribute27 IN iby_creditcard.attribute27%TYPE,
2477: p_attribute28 IN iby_creditcard.attribute28%TYPE,
2478: p_attribute29 IN iby_creditcard.attribute29%TYPE,
2479: p_attribute30 IN iby_creditcard.attribute30%TYPE,
2480: x_result_code OUT NOCOPY VARCHAR2,

Line 2477: p_attribute28 IN iby_creditcard.attribute28%TYPE,

2473: p_attribute24 IN iby_creditcard.attribute24%TYPE,
2474: p_attribute25 IN iby_creditcard.attribute25%TYPE,
2475: p_attribute26 IN iby_creditcard.attribute26%TYPE,
2476: p_attribute27 IN iby_creditcard.attribute27%TYPE,
2477: p_attribute28 IN iby_creditcard.attribute28%TYPE,
2478: p_attribute29 IN iby_creditcard.attribute29%TYPE,
2479: p_attribute30 IN iby_creditcard.attribute30%TYPE,
2480: x_result_code OUT NOCOPY VARCHAR2,
2481: x_return_status OUT NOCOPY VARCHAR2

Line 2478: p_attribute29 IN iby_creditcard.attribute29%TYPE,

2474: p_attribute25 IN iby_creditcard.attribute25%TYPE,
2475: p_attribute26 IN iby_creditcard.attribute26%TYPE,
2476: p_attribute27 IN iby_creditcard.attribute27%TYPE,
2477: p_attribute28 IN iby_creditcard.attribute28%TYPE,
2478: p_attribute29 IN iby_creditcard.attribute29%TYPE,
2479: p_attribute30 IN iby_creditcard.attribute30%TYPE,
2480: x_result_code OUT NOCOPY VARCHAR2,
2481: x_return_status OUT NOCOPY VARCHAR2
2482: )

Line 2479: p_attribute30 IN iby_creditcard.attribute30%TYPE,

2475: p_attribute26 IN iby_creditcard.attribute26%TYPE,
2476: p_attribute27 IN iby_creditcard.attribute27%TYPE,
2477: p_attribute28 IN iby_creditcard.attribute28%TYPE,
2478: p_attribute29 IN iby_creditcard.attribute29%TYPE,
2479: p_attribute30 IN iby_creditcard.attribute30%TYPE,
2480: x_result_code OUT NOCOPY VARCHAR2,
2481: x_return_status OUT NOCOPY VARCHAR2
2482: )
2483: IS

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

2570: l_prev_msg_count NUMBER;
2571:
2572: lx_result_code VARCHAR2(30);
2573:
2574: l_info_only iby_creditcard.information_only_flag%TYPE := NULL;
2575:
2576: BEGIN
2577: IF NOT FND_API.Compatible_API_Call (l_api_version,
2578: p_api_version,

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

2599: l_info_only := p_card_instrument.Info_Only_Flag;
2600: END IF;
2601: -- validate billing address information
2602: IF (NOT Validate_CC_Billing(FND_API.G_TRUE,p_card_instrument)) THEN
2603: x_response.Result_Code := iby_creditcard_pkg.G_RC_INVALID_ADDRESS;
2604: iby_fndcpt_common_pub.Prepare_Result
2605: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2606: RETURN;
2607: END IF;

Line 2609: iby_creditcard_pkg.Update_Card

2605: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2606: RETURN;
2607: END IF;
2608:
2609: iby_creditcard_pkg.Update_Card
2610: (FND_API.G_FALSE, p_card_instrument.Card_Id, p_card_instrument.Owner_Id,
2611: p_card_instrument.Card_Holder_Name,
2612: p_card_instrument.Billing_Address_Id,
2613: p_card_instrument.Address_Type,

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

2711: l_prev_msg_count NUMBER;
2712:
2713: l_card_count NUMBER;
2714:
2715: CURSOR c_card(ci_card_id IN iby_creditcard.instrid%TYPE)
2716: IS
2717: SELECT card_owner_id, chname, addressid, masked_cc_number,
2718: expirydate, DECODE(expirydate, null,expired_flag, decode(sign(expirydate-sysdate),-1,'Y','N')),
2719: instrument_type,purchasecard_subtype, card_issuer_code, finame, single_use_flag,

Line 2721: FROM iby_creditcard

2717: SELECT card_owner_id, chname, addressid, masked_cc_number,
2718: expirydate, DECODE(expirydate, null,expired_flag, decode(sign(expirydate-sysdate),-1,'Y','N')),
2719: instrument_type,purchasecard_subtype, card_issuer_code, finame, single_use_flag,
2720: information_only_flag, card_purpose, description, inactive_date
2721: FROM iby_creditcard
2722: WHERE (instrid = ci_card_id);
2723: BEGIN
2724: IF (c_card%ISOPEN) THEN
2725: CLOSE c_card;

Line 2829: l_card_id iby_creditcard.instrid%TYPE;

2825: l_api_version CONSTANT NUMBER := 1.0;
2826: l_module CONSTANT VARCHAR2(30) := 'Card_Exists';
2827: l_prev_msg_count NUMBER;
2828:
2829: l_card_id iby_creditcard.instrid%TYPE;
2830: l_cc_hash1 iby_creditcard.cc_number_hash1%TYPE;
2831: l_cc_hash2 iby_creditcard.cc_number_hash2%TYPE;
2832: l_char_allowed VARCHAR2(1) := 'N';
2833: lx_return_status VARCHAR2(1);

Line 2830: l_cc_hash1 iby_creditcard.cc_number_hash1%TYPE;

2826: l_module CONSTANT VARCHAR2(30) := 'Card_Exists';
2827: l_prev_msg_count NUMBER;
2828:
2829: l_card_id iby_creditcard.instrid%TYPE;
2830: l_cc_hash1 iby_creditcard.cc_number_hash1%TYPE;
2831: l_cc_hash2 iby_creditcard.cc_number_hash2%TYPE;
2832: l_char_allowed VARCHAR2(1) := 'N';
2833: lx_return_status VARCHAR2(1);
2834: lx_msg_count NUMBER;

Line 2831: l_cc_hash2 iby_creditcard.cc_number_hash2%TYPE;

2827: l_prev_msg_count NUMBER;
2828:
2829: l_card_id iby_creditcard.instrid%TYPE;
2830: l_cc_hash1 iby_creditcard.cc_number_hash1%TYPE;
2831: l_cc_hash2 iby_creditcard.cc_number_hash2%TYPE;
2832: l_char_allowed VARCHAR2(1) := 'N';
2833: lx_return_status VARCHAR2(1);
2834: lx_msg_count NUMBER;
2835: lx_msg_data VARCHAR2(200);

Line 2836: lx_cc_number iby_creditcard.ccnumber%TYPE;

2832: l_char_allowed VARCHAR2(1) := 'N';
2833: lx_return_status VARCHAR2(1);
2834: lx_msg_count NUMBER;
2835: lx_msg_data VARCHAR2(200);
2836: lx_cc_number iby_creditcard.ccnumber%TYPE;
2837: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2838:
2839: CURSOR c_card
2840: (ci_cc_hash1 IN iby_creditcard.cc_number_hash1%TYPE,

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

2836: lx_cc_number iby_creditcard.ccnumber%TYPE;
2837: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2838:
2839: CURSOR c_card
2840: (ci_cc_hash1 IN iby_creditcard.cc_number_hash1%TYPE,
2841: ci_cc_hash2 IN iby_creditcard.cc_number_hash2%TYPE,
2842: ci_card_owner IN iby_creditcard.card_owner_id%TYPE
2843: )
2844: IS

Line 2841: ci_cc_hash2 IN iby_creditcard.cc_number_hash2%TYPE,

2837: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2838:
2839: CURSOR c_card
2840: (ci_cc_hash1 IN iby_creditcard.cc_number_hash1%TYPE,
2841: ci_cc_hash2 IN iby_creditcard.cc_number_hash2%TYPE,
2842: ci_card_owner IN iby_creditcard.card_owner_id%TYPE
2843: )
2844: IS
2845: SELECT instrid

Line 2842: ci_card_owner IN iby_creditcard.card_owner_id%TYPE

2838:
2839: CURSOR c_card
2840: (ci_cc_hash1 IN iby_creditcard.cc_number_hash1%TYPE,
2841: ci_cc_hash2 IN iby_creditcard.cc_number_hash2%TYPE,
2842: ci_card_owner IN iby_creditcard.card_owner_id%TYPE
2843: )
2844: IS
2845: SELECT instrid
2846: FROM iby_creditcard

Line 2846: FROM iby_creditcard

2842: ci_card_owner IN iby_creditcard.card_owner_id%TYPE
2843: )
2844: IS
2845: SELECT instrid
2846: FROM iby_creditcard
2847: WHERE (cc_number_hash1 = ci_cc_hash1)
2848: AND (cc_number_hash2 = ci_cc_hash2)
2849: AND ( (card_owner_id = NVL(ci_card_owner,card_owner_id))
2850: OR (card_owner_id IS NULL AND ci_card_owner IS NULL) ); --Removed singleUseFlag validation to avoid duplicate singleusecard creation.

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

2881: lx_return_status, lx_msg_count, lx_msg_data, lx_cc_number
2882: );
2883:
2884: IF (lx_cc_number IS NULL) THEN
2885: x_response.Result_Code := iby_creditcard_pkg.G_RC_INVALID_CCNUMBER;
2886: iby_fndcpt_common_pub.Prepare_Result
2887: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2888: RETURN;
2889: END IF;

Line 3093: lx_cc_number iby_creditcard.ccnumber%TYPE;

3089: IS
3090: lx_return_status VARCHAR2(1);
3091: lx_msg_count NUMBER;
3092: lx_msg_data VARCHAR2(200);
3093: lx_cc_number iby_creditcard.ccnumber%TYPE;
3094: BEGIN
3095: iby_cc_validate.StripCC
3096: (1.0, FND_API.G_FALSE, p_number,
3097: lx_return_status, lx_msg_count, lx_msg_data, lx_cc_number

Line 3108: lx_cc_number iby_creditcard.ccnumber%TYPE;

3104: IS
3105: lx_return_status VARCHAR2(1);
3106: lx_msg_count NUMBER;
3107: lx_msg_data VARCHAR2(200);
3108: lx_cc_number iby_creditcard.ccnumber%TYPE;
3109: BEGIN
3110: iby_cc_validate.StripCC
3111: (1.0, FND_API.G_FALSE, p_number,
3112: lx_return_status, lx_msg_count, lx_msg_data, lx_cc_number

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

3165: -- USE: Gets the card expiration status w.r.t an input date
3166: --
3167: --
3168: PROCEDURE Get_Card_Expiration_Status
3169: (p_instrid IN IBY_CREDITCARD.instrid%TYPE,
3170: p_input_date IN DATE,
3171: x_expired OUT NOCOPY VARCHAR2,
3172: x_result_code OUT NOCOPY VARCHAR2
3173: )

Line 3190: FROM iby_creditcard

3186: x_result_code := FND_API.G_RET_STS_SUCCESS;
3187:
3188: SELECT expirydate, expiry_sec_segment_id
3189: INTO l_expiry_date, l_exp_sec_segment_id
3190: FROM iby_creditcard
3191: WHERE instrid = p_instrid;
3192:
3193: IF ((l_expiry_date IS NULL) AND (l_exp_sec_segment_id IS NULL)) THEN
3194: RETURN;