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_PKG dependencies on HR_LOCATIONS_ALL

Line 202: ELSIF p_location_table_name NOT IN ( 'HR_LOCATIONS_ALL',

198: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_LOC_TABLE_MAND');
199: FND_MSG_PUB.ADD;
200: RAISE FND_API.G_EXC_ERROR;
201:
202: ELSIF p_location_table_name NOT IN ( 'HR_LOCATIONS_ALL',
203: 'HZ_LOCATIONS') THEN
204:
205: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_LOC_TABLE_INVALID');
206: FND_MSG_PUB.ADD;

Line 480: FROM hr_locations_all loc

476: p_usage_code IN VARCHAR2,
477: p_table_name IN VARCHAR2
478: ) IS
479: SELECT loc.location_id
480: FROM hr_locations_all loc
481: WHERE (((p_from_location_id IS NOT NULL and p_to_location_id IS NOT NULL) and
482: (loc.location_id BETWEEN p_from_location_id and p_to_location_id )) or
483: ((p_from_location_id IS NOT NULL and p_to_location_id IS NULL) and
484: (loc.location_id >= p_from_location_id)) or

Line 530: FROM hr_locations_all loc

526: p_usage_code IN VARCHAR2,
527: p_table_name IN VARCHAR2
528: ) IS
529: SELECT loc.location_id
530: FROM hr_locations_all loc
531: WHERE (((p_from_location_id IS NOT NULL and p_to_location_id IS NOT NULL) and
532: (loc.location_id BETWEEN p_from_location_id and p_to_location_id )) or
533: ((p_from_location_id IS NOT NULL and p_to_location_id IS NULL) and
534: (loc.location_id >= p_from_location_id)) or

Line 579: FROM hr_locations_all loc

575: p_num_workers IN NUMBER,
576: p_worker_number IN NUMBER
577: ) IS
578: SELECT loc.location_id
579: FROM hr_locations_all loc
580: WHERE (((p_from_location_id IS NOT NULL and p_to_location_id IS NOT NULL) and
581: (loc.location_id BETWEEN p_from_location_id and p_to_location_id )) or
582: ((p_from_location_id IS NOT NULL and p_to_location_id IS NULL) and
583: (loc.location_id >= p_from_location_id)) or

Line 899: -- 1. If table is HR_LOCATIONS_ALL, GNR for only TAX usage is generated. It will

895:
896: retcode := 0;
897:
898: -- Set l_usage_code. This depends on table name and run type.
899: -- 1. If table is HR_LOCATIONS_ALL, GNR for only TAX usage is generated. It will
900: -- ignore whatever usage code is passed for HZ_LOCATIONS_ALL.
901: -- 2. If table is HZ_LOCATIONS,
902: -- i. If run type is ALL, we delete GNR for all usages, so we will generate GNR for all usages.
903: -- ii.If run type is ERROR or NEW, we will generate GNR for specific usage passed.

Line 912: (p_location_table_name = 'HR_LOCATIONS_ALL') THEN

908: ELSE
909: l_usage_code := NVL(p_usage_code,'ALL');
910: END IF;
911: ELSIF
912: (p_location_table_name = 'HR_LOCATIONS_ALL') THEN
913: l_usage_code := 'TAX';
914: ELSE
915: l_usage_code := NVL(p_usage_code,'ALL');
916: END IF;

Line 955: -- Table : HR_LOCATIONS_ALL Run Type : ALL

951: -- source records. The log will print the location
952: -- record processed and in the end it will print the
953: -- total number of records processed.
954:
955: -- Table : HR_LOCATIONS_ALL Run Type : ALL
956: IF ((p_location_table_name = 'HR_LOCATIONS_ALL') AND (l_run_type = 'ALL')) THEN
957:
958: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HR_LOCATIONS_ALL and Run Type : ALL');
959: HZ_GNR_UTIL_PKG.outandlog('Parameters: Country Code :'||NVL(l_country_code,'NULL'));

Line 956: IF ((p_location_table_name = 'HR_LOCATIONS_ALL') AND (l_run_type = 'ALL')) THEN

952: -- record processed and in the end it will print the
953: -- total number of records processed.
954:
955: -- Table : HR_LOCATIONS_ALL Run Type : ALL
956: IF ((p_location_table_name = 'HR_LOCATIONS_ALL') AND (l_run_type = 'ALL')) THEN
957:
958: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HR_LOCATIONS_ALL and Run Type : ALL');
959: HZ_GNR_UTIL_PKG.outandlog('Parameters: Country Code :'||NVL(l_country_code,'NULL'));
960: HZ_GNR_UTIL_PKG.outandlog(' Usage Code :'||l_usage_code);

Line 958: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HR_LOCATIONS_ALL and Run Type : ALL');

954:
955: -- Table : HR_LOCATIONS_ALL Run Type : ALL
956: IF ((p_location_table_name = 'HR_LOCATIONS_ALL') AND (l_run_type = 'ALL')) THEN
957:
958: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HR_LOCATIONS_ALL and Run Type : ALL');
959: HZ_GNR_UTIL_PKG.outandlog('Parameters: Country Code :'||NVL(l_country_code,'NULL'));
960: HZ_GNR_UTIL_PKG.outandlog(' Usage Code :'||l_usage_code);
961: HZ_GNR_UTIL_PKG.outandlog(' From Location Id :'||NVL(TO_CHAR(l_from_location_id),'NULL')
962: ||': To Location Id:'||NVL(TO_CHAR(l_to_location_id),'NULL'));

Line 1044: -- Table : HR_LOCATIONS_ALL Run Type : NEW

1040: HZ_GNR_UTIL_PKG.out(l_err_loc_msg_prefix || l_num_err_locations);
1041:
1042: HZ_GNR_UTIL_PKG.log('Geo Name Referencing process completed successfully');
1043:
1044: -- Table : HR_LOCATIONS_ALL Run Type : NEW
1045: ELSIF ((p_location_table_name = 'HR_LOCATIONS_ALL') AND (l_run_type = 'NEW')) THEN
1046:
1047: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HR_LOCATIONS_ALL and Run Type : NEW');
1048: HZ_GNR_UTIL_PKG.outandlog('Parameters: Country Code :'||NVL(l_country_code,'NULL'));

Line 1045: ELSIF ((p_location_table_name = 'HR_LOCATIONS_ALL') AND (l_run_type = 'NEW')) THEN

1041:
1042: HZ_GNR_UTIL_PKG.log('Geo Name Referencing process completed successfully');
1043:
1044: -- Table : HR_LOCATIONS_ALL Run Type : NEW
1045: ELSIF ((p_location_table_name = 'HR_LOCATIONS_ALL') AND (l_run_type = 'NEW')) THEN
1046:
1047: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HR_LOCATIONS_ALL and Run Type : NEW');
1048: HZ_GNR_UTIL_PKG.outandlog('Parameters: Country Code :'||NVL(l_country_code,'NULL'));
1049: HZ_GNR_UTIL_PKG.outandlog(' Usage Code :'||l_usage_code);

Line 1047: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HR_LOCATIONS_ALL and Run Type : NEW');

1043:
1044: -- Table : HR_LOCATIONS_ALL Run Type : NEW
1045: ELSIF ((p_location_table_name = 'HR_LOCATIONS_ALL') AND (l_run_type = 'NEW')) THEN
1046:
1047: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HR_LOCATIONS_ALL and Run Type : NEW');
1048: HZ_GNR_UTIL_PKG.outandlog('Parameters: Country Code :'||NVL(l_country_code,'NULL'));
1049: HZ_GNR_UTIL_PKG.outandlog(' Usage Code :'||l_usage_code);
1050: HZ_GNR_UTIL_PKG.outandlog(' From Location Id :'||NVL(TO_CHAR(l_from_location_id),'NULL')
1051: ||': To Location Id:'||NVL(TO_CHAR(l_to_location_id),'NULL'));

Line 1129: -- Table : HR_LOCATIONS_ALL Run Type : ERROR

1125: HZ_GNR_UTIL_PKG.out(l_err_loc_msg_prefix || l_num_err_locations);
1126:
1127: HZ_GNR_UTIL_PKG.log('Geo Name Referencing process completed successfully');
1128:
1129: -- Table : HR_LOCATIONS_ALL Run Type : ERROR
1130: ELSIF ((p_location_table_name = 'HR_LOCATIONS_ALL') AND (l_run_type = 'ERROR')) THEN
1131:
1132: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HR_LOCATIONS_ALL and Run Type : ERROR');
1133: HZ_GNR_UTIL_PKG.outandlog('Parameters: Country Code :'||NVL(l_country_code,'NULL'));

Line 1130: ELSIF ((p_location_table_name = 'HR_LOCATIONS_ALL') AND (l_run_type = 'ERROR')) THEN

1126:
1127: HZ_GNR_UTIL_PKG.log('Geo Name Referencing process completed successfully');
1128:
1129: -- Table : HR_LOCATIONS_ALL Run Type : ERROR
1130: ELSIF ((p_location_table_name = 'HR_LOCATIONS_ALL') AND (l_run_type = 'ERROR')) THEN
1131:
1132: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HR_LOCATIONS_ALL and Run Type : ERROR');
1133: HZ_GNR_UTIL_PKG.outandlog('Parameters: Country Code :'||NVL(l_country_code,'NULL'));
1134: HZ_GNR_UTIL_PKG.outandlog(' Usage Code :'||l_usage_code);

Line 1132: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HR_LOCATIONS_ALL and Run Type : ERROR');

1128:
1129: -- Table : HR_LOCATIONS_ALL Run Type : ERROR
1130: ELSIF ((p_location_table_name = 'HR_LOCATIONS_ALL') AND (l_run_type = 'ERROR')) THEN
1131:
1132: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HR_LOCATIONS_ALL and Run Type : ERROR');
1133: HZ_GNR_UTIL_PKG.outandlog('Parameters: Country Code :'||NVL(l_country_code,'NULL'));
1134: HZ_GNR_UTIL_PKG.outandlog(' Usage Code :'||l_usage_code);
1135: HZ_GNR_UTIL_PKG.outandlog(' From Location Id :'||NVL(TO_CHAR(l_from_location_id),'NULL')
1136: ||': To Location Id:'||NVL(TO_CHAR(l_to_location_id),'NULL'));

Line 1777: FROM hr_locations_all

1773: l_debug_prefix VARCHAR2(30) := p_location_id;
1774:
1775: CURSOR c_loc(p_loc_id in number) IS
1776: SELECT country,style
1777: FROM hr_locations_all
1778: WHERE location_id = p_loc_id;
1779: BEGIN
1780: x_status := fnd_api.g_ret_sts_success; -- defaulting the sucess status.
1781:

Line 1793: l_map_id := get_map_id(l_c_loc.country,'HR_LOCATIONS_ALL',l_c_loc.style);

1789: );
1790: END IF;
1791:
1792: FOR l_c_loc in c_loc(P_LOCATION_ID) LOOP -- only one record will be featched.
1793: l_map_id := get_map_id(l_c_loc.country,'HR_LOCATIONS_ALL',l_c_loc.style);
1794: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1795: hz_utility_v2pub.debug
1796: (p_message => ' Map Id for the country : '||l_map_id,
1797: p_prefix => l_debug_prefix,