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_GNR_UTIL_PKG dependencies on HZ_GEO_NAME_REFERENCE_LOG

Line 80: FROM HZ_GEO_NAME_REFERENCE_LOG

76: p_location_table_name IN VARCHAR2) RETURN BOOLEAN IS
77:
78: CURSOR c_gnr IS
79: SELECT MAP_STATUS
80: FROM HZ_GEO_NAME_REFERENCE_LOG
81: WHERE LOCATION_TABLE_NAME = p_location_table_name
82: AND LOCATION_ID = p_location_id;
83:
84: l_address_status VARCHAR2(30);

Line 1226: DELETE FROM hz_geo_name_reference_log

1222: END IF;
1223:
1224: -- delete thing the location id and table name combination from gnr
1225: BEGIN
1226: DELETE FROM hz_geo_name_reference_log
1227: WHERE location_id = p_locid
1228: AND location_table_name = p_loctbl;
1229: EXCEPTION
1230: WHEN others THEN

Line 1274: INSERT INTO hz_geo_name_reference_log

1270:
1271: END IF;
1272:
1273: IF (l_status = fnd_api.g_ret_sts_success) THEN
1274: INSERT INTO hz_geo_name_reference_log
1275: (location_id, location_table_name,
1276: message_text,
1277: object_version_number, map_status,
1278: last_updated_by, creation_date,

Line 2583: FROM hz_geo_name_reference_log

2579: CURSOR c_check_gnr_log_exist (p_location_id NUMBER,
2580: p_location_table_name VARCHAR2,
2581: p_usage_code VARCHAR2) IS
2582: SELECT 'Y'
2583: FROM hz_geo_name_reference_log
2584: WHERE location_id = p_location_id
2585: AND location_table_name = p_location_table_name
2586: AND usage_code = p_usage_code
2587: ;

Line 2661: from HZ_GEO_NAME_REFERENCE_LOG

2657: j number;
2658:
2659: cursor get_old_map_status is
2660: select map_status
2661: from HZ_GEO_NAME_REFERENCE_LOG
2662: where location_id = p_location_id
2663: and map_status = 'S';
2664:
2665: cursor get_gnr_superloc_rec is

Line 2772: (p_message => 'Before inserting record into hz_geo_name_reference_log with map status '||p_map_status,

2768: IF (l_gnr_log_exist <> 'Y') THEN
2769:
2770: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2771: hz_utility_v2pub.debug
2772: (p_message => 'Before inserting record into hz_geo_name_reference_log with map status '||p_map_status,
2773: p_prefix => l_debug_prefix,
2774: p_msg_level => fnd_log.level_statement,
2775: p_module_prefix => l_module_prefix,
2776: p_module => l_module

Line 2780: INSERT INTO hz_geo_name_reference_log

2776: p_module => l_module
2777: );
2778: END IF;
2779:
2780: INSERT INTO hz_geo_name_reference_log
2781: (location_id, location_table_name,usage_code,
2782: message_text,
2783: object_version_number, map_status,
2784: last_updated_by, creation_date,

Line 2797: (p_message => 'After inserting record into hz_geo_name_reference_log ',

2793: l_conc_login_id, l_program_application_id, l_request_id);
2794:
2795: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2796: hz_utility_v2pub.debug
2797: (p_message => 'After inserting record into hz_geo_name_reference_log ',
2798: p_prefix => l_debug_prefix,
2799: p_msg_level => fnd_log.level_statement,
2800: p_module_prefix => l_module_prefix,
2801: p_module => l_module

Line 2809: (p_message => 'Before updating record into hz_geo_name_reference_log with map status '||p_map_status,

2805: ELSE -- GNR Log already exists, we will update it
2806:
2807: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2808: hz_utility_v2pub.debug
2809: (p_message => 'Before updating record into hz_geo_name_reference_log with map status '||p_map_status,
2810: p_prefix => l_debug_prefix,
2811: p_msg_level => fnd_log.level_statement,
2812: p_module_prefix => l_module_prefix,
2813: p_module => l_module

Line 2817: UPDATE hz_geo_name_reference_log

2813: p_module => l_module
2814: );
2815: END IF;
2816:
2817: UPDATE hz_geo_name_reference_log
2818: SET map_status = p_map_status,
2819: object_version_number = object_version_number + 1,
2820: last_updated_by = l_last_updated_by,
2821: last_update_date = l_last_update_date,

Line 2829: (p_message => 'After updating record into hz_geo_name_reference_log ',

2825: AND usage_code = p_usage_code;
2826:
2827: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2828: hz_utility_v2pub.debug
2829: (p_message => 'After updating record into hz_geo_name_reference_log ',
2830: p_prefix => l_debug_prefix,
2831: p_msg_level => fnd_log.level_statement,
2832: p_module_prefix => l_module_prefix,
2833: p_module => l_module

Line 3032: FROm HZ_GEO_NAME_REFERENCE_LOG

3028: AND LOCATION_TABLE_NAME = p_location_table_name;
3029:
3030: CURSOR c_gnr_log IS
3031: SELECT MAP_STATUS,USAGE_CODE
3032: FROm HZ_GEO_NAME_REFERENCE_LOG
3033: WHERE LOCATION_ID = p_location_id
3034: AND LOCATION_TABLE_NAME = p_location_table_name;
3035:
3036: l_gnr_exists varchar2(1);

Line 3100: UPDATE hz_geo_name_reference_log

3096: END IF;
3097:
3098: IF l_success = 'Y' THEN
3099: IF l_usage_log_exists = 'Y' THEN
3100: UPDATE hz_geo_name_reference_log
3101: SET map_status = 'S',
3102: object_version_number = object_version_number + 1,
3103: last_updated_by = l_last_updated_by,
3104: last_update_date = l_last_update_date,

Line 3110: INSERT INTO hz_geo_name_reference_log

3106: WHERE location_id = p_location_id
3107: AND location_table_name = p_location_table_name
3108: AND usage_code = p_usage_code;
3109: ELSE
3110: INSERT INTO hz_geo_name_reference_log
3111: (location_id, location_table_name,usage_code,
3112: message_text,
3113: object_version_number, map_status,
3114: last_updated_by, creation_date,