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 2578: FROM hz_geo_name_reference_log

2574: CURSOR c_check_gnr_log_exist (p_location_id NUMBER,
2575: p_location_table_name VARCHAR2,
2576: p_usage_code VARCHAR2) IS
2577: SELECT 'Y'
2578: FROM hz_geo_name_reference_log
2579: WHERE location_id = p_location_id
2580: AND location_table_name = p_location_table_name
2581: AND usage_code = p_usage_code
2582: ;

Line 2656: from HZ_GEO_NAME_REFERENCE_LOG

2652: j number;
2653:
2654: cursor get_old_map_status is
2655: select map_status
2656: from HZ_GEO_NAME_REFERENCE_LOG
2657: where location_id = p_location_id
2658: and map_status = 'S';
2659:
2660: cursor get_gnr_superloc_rec is

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

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

Line 2775: INSERT INTO hz_geo_name_reference_log

2771: p_module => l_module
2772: );
2773: END IF;
2774:
2775: INSERT INTO hz_geo_name_reference_log
2776: (location_id, location_table_name,usage_code,
2777: message_text,
2778: object_version_number, map_status,
2779: last_updated_by, creation_date,

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

2788: l_conc_login_id, l_program_application_id, l_request_id);
2789:
2790: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2791: hz_utility_v2pub.debug
2792: (p_message => 'After inserting record into hz_geo_name_reference_log ',
2793: p_prefix => l_debug_prefix,
2794: p_msg_level => fnd_log.level_statement,
2795: p_module_prefix => l_module_prefix,
2796: p_module => l_module

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

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

Line 2812: UPDATE hz_geo_name_reference_log

2808: p_module => l_module
2809: );
2810: END IF;
2811:
2812: UPDATE hz_geo_name_reference_log
2813: SET map_status = p_map_status,
2814: object_version_number = object_version_number + 1,
2815: last_updated_by = l_last_updated_by,
2816: last_update_date = l_last_update_date,

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

2820: AND usage_code = p_usage_code;
2821:
2822: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2823: hz_utility_v2pub.debug
2824: (p_message => 'After updating record into hz_geo_name_reference_log ',
2825: p_prefix => l_debug_prefix,
2826: p_msg_level => fnd_log.level_statement,
2827: p_module_prefix => l_module_prefix,
2828: p_module => l_module

Line 3027: FROm HZ_GEO_NAME_REFERENCE_LOG

3023: AND LOCATION_TABLE_NAME = p_location_table_name;
3024:
3025: CURSOR c_gnr_log IS
3026: SELECT MAP_STATUS,USAGE_CODE
3027: FROm HZ_GEO_NAME_REFERENCE_LOG
3028: WHERE LOCATION_ID = p_location_id
3029: AND LOCATION_TABLE_NAME = p_location_table_name;
3030:
3031: l_gnr_exists varchar2(1);

Line 3095: UPDATE hz_geo_name_reference_log

3091: END IF;
3092:
3093: IF l_success = 'Y' THEN
3094: IF l_usage_log_exists = 'Y' THEN
3095: UPDATE hz_geo_name_reference_log
3096: SET map_status = 'S',
3097: object_version_number = object_version_number + 1,
3098: last_updated_by = l_last_updated_by,
3099: last_update_date = l_last_update_date,

Line 3105: INSERT INTO hz_geo_name_reference_log

3101: WHERE location_id = p_location_id
3102: AND location_table_name = p_location_table_name
3103: AND usage_code = p_usage_code;
3104: ELSE
3105: INSERT INTO hz_geo_name_reference_log
3106: (location_id, location_table_name,usage_code,
3107: message_text,
3108: object_version_number, map_status,
3109: last_updated_by, creation_date,