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.HZ_ADDRESS_USAGES_PUB dependencies on HZ_ADDRESS_USAGES_S

Line 118: SELECT HZ_ADDRESS_USAGES_S.nextval

114:
115:
116: BEGIN --insert row
117:
118: SELECT HZ_ADDRESS_USAGES_S.nextval
119: INTO l_usage_id
120: FROM dual;
121:
122: hz_address_usages_pkg.insert_row(

Line 166: SELECT HZ_ADDRESS_USAGES_S.nextval

162:
163: -- The below variable is to display the geography type in case of unique error from pkg API
164: l_geotype := p_address_usage_dtls_tbl(i).geography_type;
165:
166: SELECT HZ_ADDRESS_USAGES_S.nextval
167: INTO l_usage_dtl_id
168: FROM dual;
169:
170: hz_address_usage_dtls_pkg.insert_row(

Line 333: db_status_flag hz_address_usages.status_flag%TYPE;

329:
330: db_object_version_number hz_address_usages.object_version_number%TYPE;
331: db_map_id hz_address_usages.map_id%TYPE;
332: db_usage_code hz_address_usages.usage_code%TYPE;
333: db_status_flag hz_address_usages.status_flag%TYPE;
334: db_created_by hz_address_usages.created_by%TYPE;
335: db_creation_date hz_address_usages.creation_date%TYPE;
336: db_last_updated_by hz_address_usages.last_updated_by%TYPE;
337: db_last_update_date hz_address_usages.last_update_date%TYPE;

Line 621: SELECT HZ_ADDRESS_USAGES_S.nextval

617:
618: -- The below variable is to display the geography type in case of unique error from pkg API
619: l_geotype := p_address_usage_dtls_tbl(i).geography_type;
620:
621: SELECT HZ_ADDRESS_USAGES_S.nextval
622: INTO l_usage_dtl_id
623: FROM dual;
624:
625: hz_address_usage_dtls_pkg.insert_row(