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

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

1478: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1479: x_owner_id OUT NOCOPY iby_creditcard.card_owner_id%TYPE,
1480: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,
1481: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
1482: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
1483: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
1484: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
1485: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1486: x_billing_county OUT NOCOPY hz_locations.county%TYPE,

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

1479: x_owner_id OUT NOCOPY iby_creditcard.card_owner_id%TYPE,
1480: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,
1481: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
1482: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
1483: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
1484: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
1485: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1486: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
1487: x_billing_state OUT NOCOPY hz_locations.state%TYPE,

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

1480: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,
1481: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
1482: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
1483: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
1484: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
1485: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1486: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
1487: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
1488: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,

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

1481: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
1482: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
1483: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
1484: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
1485: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1486: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
1487: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
1488: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
1489: x_billing_country OUT NOCOPY hz_locations.country%TYPE,

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

1482: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
1483: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
1484: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
1485: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1486: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
1487: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
1488: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
1489: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
1490: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,

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

1483: x_billing_address2 OUT NOCOPY hz_locations.address2%TYPE,
1484: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
1485: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1486: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
1487: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
1488: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
1489: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
1490: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,
1491: x_expiry_date OUT NOCOPY iby_creditcard.expirydate%TYPE,

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

1484: x_billing_address3 OUT NOCOPY hz_locations.address3%TYPE,
1485: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1486: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
1487: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
1488: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
1489: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
1490: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,
1491: x_expiry_date OUT NOCOPY iby_creditcard.expirydate%TYPE,
1492: x_instr_type OUT NOCOPY iby_creditcard.instrument_type%TYPE,

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

1485: x_billing_city OUT NOCOPY hz_locations.city%TYPE,
1486: x_billing_county OUT NOCOPY hz_locations.county%TYPE,
1487: x_billing_state OUT NOCOPY hz_locations.state%TYPE,
1488: x_billing_zip OUT NOCOPY hz_locations.postal_code%TYPE,
1489: x_billing_country OUT NOCOPY hz_locations.country%TYPE,
1490: x_card_number OUT NOCOPY iby_creditcard.ccnumber%TYPE,
1491: x_expiry_date OUT NOCOPY iby_creditcard.expirydate%TYPE,
1492: x_instr_type OUT NOCOPY iby_creditcard.instrument_type%TYPE,
1493: x_pcard_flag OUT NOCOPY iby_creditcard.purchasecard_flag%TYPE,

Line 1532: hz_locations l

1528: c.description, c.active_flag, c.inactive_date,
1529: c.encrypted, c.expiry_sec_segment_id,
1530: c.chname_sec_segment_id
1531: FROM iby_creditcard c, hz_party_site_uses su, hz_party_sites s,
1532: hz_locations l
1533: WHERE (instrid = ci_instr_id)
1534: AND (c.addressid = su.party_site_use_id(+))
1535: AND (su.party_site_id = s.party_site_id(+))
1536: AND (s.location_id = l.location_id(+));