APPS.HZ_LOCATIONS_PKG dependencies on HR_LOCATIONS_S

Line 182: fnd_api.g_miss_num, hr_locations_s.NEXTVAL,

178: delivery_point_code
179: )
180: VALUES (
181: DECODE(x_location_id,
182: fnd_api.g_miss_num, hr_locations_s.NEXTVAL,
183: NULL, hr_locations_s.NEXTVAL,
184: x_location_id),
185: hz_utility_v2pub.last_update_date,
186: hz_utility_v2pub.last_updated_by,

Line 183: NULL, hr_locations_s.NEXTVAL,

179: )
180: VALUES (
181: DECODE(x_location_id,
182: fnd_api.g_miss_num, hr_locations_s.NEXTVAL,
183: NULL, hr_locations_s.NEXTVAL,
184: x_location_id),
185: hz_utility_v2pub.last_update_date,
186: hz_utility_v2pub.last_updated_by,
187: hz_utility_v2pub.creation_date,

Line 219: hr_locations_s.CURRVAL)),

215: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
216: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),
217: DECODE(x_orig_system_reference,
218: fnd_api.g_miss_char, TO_CHAR(NVL(x_location_id,
219: hr_locations_s.CURRVAL)),
220: NULL, TO_CHAR(NVL(x_location_id, hr_locations_s.CURRVAL)),
221: x_orig_system_reference),
222: DECODE(x_country, fnd_api.g_miss_char, NULL, x_country),
223: DECODE(x_address1, fnd_api.g_miss_char, NULL, x_address1),

Line 220: NULL, TO_CHAR(NVL(x_location_id, hr_locations_s.CURRVAL)),

216: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),
217: DECODE(x_orig_system_reference,
218: fnd_api.g_miss_char, TO_CHAR(NVL(x_location_id,
219: hr_locations_s.CURRVAL)),
220: NULL, TO_CHAR(NVL(x_location_id, hr_locations_s.CURRVAL)),
221: x_orig_system_reference),
222: DECODE(x_country, fnd_api.g_miss_char, NULL, x_country),
223: DECODE(x_address1, fnd_api.g_miss_char, NULL, x_address1),
224: DECODE(x_address2, fnd_api.g_miss_char, NULL, x_address2),

Line 322: SELECT hr_locations_s.NEXTVAL

318: l_dummy VARCHAR2(1);
319: BEGIN
320: l_count := 1;
321: WHILE l_count > 0 LOOP
322: SELECT hr_locations_s.NEXTVAL
323: INTO x_location_id
324: FROM dual;
325:
326: BEGIN