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_CREDITCARD_PKG dependencies on HZ_LOCATIONS

Line 1752: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,

1748: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1749: x_owner_id OUT NOCOPY iby_creditcard.card_owner_id%TYPE,
1750: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,
1751: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
1752: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
1753: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
1754: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
1755: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1756: x_billing_county OUT NOCOPY hz_locations.county%TYPE,

Line 1753: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,

1749: x_owner_id OUT NOCOPY iby_creditcard.card_owner_id%TYPE,
1750: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,
1751: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
1752: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
1753: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
1754: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
1755: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1756: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
1757: x_billing_state OUT NOCOPY hz_locations.state%TYPE,

Line 1754: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,

1750: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,
1751: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
1752: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
1753: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
1754: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
1755: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1756: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
1757: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
1758: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,

Line 1755: x_billing_city OUT NOCOPY hz_locations.city%TYPE,

1751: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
1752: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
1753: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
1754: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
1755: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1756: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
1757: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
1758: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
1759: x_billing_country OUT NOCOPY hz_locations.country%TYPE,

Line 1756: x_billing_county OUT NOCOPY hz_locations.county%TYPE,

1752: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
1753: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
1754: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
1755: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1756: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
1757: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
1758: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
1759: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
1760: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,

Line 1757: x_billing_state OUT NOCOPY hz_locations.state%TYPE,

1753: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
1754: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
1755: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1756: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
1757: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
1758: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
1759: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
1760: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,
1761: x_expiry_date OUT NOCOPY iby_creditcard.expirydate%TYPE,

Line 1758: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,

1754: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
1755: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1756: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
1757: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
1758: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
1759: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
1760: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,
1761: x_expiry_date OUT NOCOPY iby_creditcard.expirydate%TYPE,
1762: x_instr_type OUT NOCOPY iby_creditcard.instrument_type%TYPE,

Line 1759: x_billing_country OUT NOCOPY hz_locations.country%TYPE,

1755: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1756: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
1757: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
1758: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
1759: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
1760: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,
1761: x_expiry_date OUT NOCOPY iby_creditcard.expirydate%TYPE,
1762: x_instr_type OUT NOCOPY iby_creditcard.instrument_type%TYPE,
1763: x_pcard_flag OUT NOCOPY iby_creditcard.purchasecard_flag%TYPE,

Line 1802: hz_locations l

1798: c.description, c.active_flag, c.inactive_date,
1799: c.encrypted, c.expiry_sec_segment_id,
1800: c.chname_sec_segment_id
1801: FROM iby_creditcard c, hz_party_site_uses su, hz_party_sites s,
1802: hz_locations l
1803: WHERE (instrid = ci_instr_id)
1804: AND (c.addressid = su.party_site_use_id(+))
1805: AND (su.party_site_id = s.party_site_id(+))
1806: AND (s.location_id = l.location_id(+));

Line 1868: retrieved from hz_locations table.

1864: Bug 9735830: CANADIAN ORDER FAILING CC AUTH WITH INVALID/MISSING BILL STATE
1865: Adding an overloaded procedure for Query_Card.
1866: This will return an additional o/p parameter for the province.
1867: Province is needed for the authorization of canadian address and will be
1868: retrieved from hz_locations table.
1869: Bug 13003193:BILLING ADDRESS VALIDATION FAILURE FOR STATE CODE ON CANADA CUSTOMERS
1870: The state is loaded with state/province as provided as the payment system
1871: doesnot recognise the new oapfprovince paramter added.
1872: */

Line 1880: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,

1876: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1877: x_owner_id OUT NOCOPY iby_creditcard.card_owner_id%TYPE,
1878: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,
1879: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
1880: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
1881: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
1882: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
1883: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1884: x_billing_county OUT NOCOPY hz_locations.county%TYPE,

Line 1881: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,

1877: x_owner_id OUT NOCOPY iby_creditcard.card_owner_id%TYPE,
1878: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,
1879: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
1880: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
1881: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
1882: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
1883: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1884: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
1885: x_billing_state OUT NOCOPY hz_locations.state%TYPE,

Line 1882: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,

1878: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,
1879: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
1880: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
1881: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
1882: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
1883: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1884: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
1885: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
1886: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,

Line 1883: x_billing_city OUT NOCOPY hz_locations.city%TYPE,

1879: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
1880: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
1881: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
1882: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
1883: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1884: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
1885: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
1886: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
1887: x_billing_country OUT NOCOPY hz_locations.country%TYPE,

Line 1884: x_billing_county OUT NOCOPY hz_locations.county%TYPE,

1880: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
1881: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
1882: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
1883: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1884: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
1885: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
1886: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
1887: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
1888: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,

Line 1885: x_billing_state OUT NOCOPY hz_locations.state%TYPE,

1881: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
1882: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
1883: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1884: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
1885: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
1886: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
1887: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
1888: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,
1889: x_expiry_date OUT NOCOPY iby_creditcard.expirydate%TYPE,

Line 1886: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,

1882: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
1883: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1884: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
1885: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
1886: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
1887: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
1888: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,
1889: x_expiry_date OUT NOCOPY iby_creditcard.expirydate%TYPE,
1890: x_instr_type OUT NOCOPY iby_creditcard.instrument_type%TYPE,

Line 1887: x_billing_country OUT NOCOPY hz_locations.country%TYPE,

1883: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1884: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
1885: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
1886: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
1887: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
1888: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,
1889: x_expiry_date OUT NOCOPY iby_creditcard.expirydate%TYPE,
1890: x_instr_type OUT NOCOPY iby_creditcard.instrument_type%TYPE,
1891: x_pcard_flag OUT NOCOPY iby_creditcard.purchasecard_flag%TYPE,

Line 1902: x_province OUT NOCOPY hz_locations.country%TYPE

1898: x_desc OUT NOCOPY iby_creditcard.description%TYPE,
1899: x_active_flag OUT NOCOPY iby_creditcard.active_flag%TYPE,
1900: x_inactive_date OUT NOCOPY iby_creditcard.inactive_date%TYPE,
1901: x_result_code OUT NOCOPY VARCHAR2,
1902: x_province OUT NOCOPY hz_locations.country%TYPE
1903: )
1904: IS
1905: l_ccnum_ciphertxt iby_creditcard.ccnumber%TYPE;
1906: l_encrypted iby_creditcard.encrypted%TYPE;

Line 1931: hz_locations l

1927: c.description, c.active_flag, c.inactive_date,
1928: c.encrypted, c.expiry_sec_segment_id,
1929: c.chname_sec_segment_id , l.province
1930: FROM iby_creditcard c, hz_party_site_uses su, hz_party_sites s,
1931: hz_locations l
1932: WHERE (instrid = ci_instr_id)
1933: AND (c.addressid = su.party_site_use_id(+))
1934: AND (su.party_site_id = s.party_site_id(+))
1935: AND (s.location_id = l.location_id(+));