APPS.HZ_LOCATION_PROFILES_PKG dependencies on HZ_LOCATION_PROFILES_S

Line 72: fnd_api.g_miss_num, hz_location_profiles_s.NEXTVAL,

68: object_version_number
69: )
70: VALUES (
71: DECODE(x_location_profile_id,
72: fnd_api.g_miss_num, hz_location_profiles_s.NEXTVAL,
73: NULL, hz_location_profiles_s.NEXTVAL,
74: x_location_profile_id),
75: DECODE(x_location_id, fnd_api.g_miss_num, NULL, x_location_id),
76: DECODE(x_actual_content_source, fnd_api.g_miss_char, NULL, x_actual_content_source),

Line 73: NULL, hz_location_profiles_s.NEXTVAL,

69: )
70: VALUES (
71: DECODE(x_location_profile_id,
72: fnd_api.g_miss_num, hz_location_profiles_s.NEXTVAL,
73: NULL, hz_location_profiles_s.NEXTVAL,
74: x_location_profile_id),
75: DECODE(x_location_id, fnd_api.g_miss_num, NULL, x_location_id),
76: DECODE(x_actual_content_source, fnd_api.g_miss_char, NULL, x_actual_content_source),
77: DECODE(x_effective_start_date, fnd_api.g_miss_date, TO_DATE(NULL), x_effective_start_date),

Line 124: SELECT HZ_LOCATION_PROFILES_S.NEXTVAL

120: l_temp_profile_id := 0;
121: SELECT max(LOCATION_PROFILE_ID) INTO l_max_profile_id
122: FROM HZ_LOCATION_PROFILES;
123: WHILE l_temp_profile_id <= l_max_profile_id LOOP
124: SELECT HZ_LOCATION_PROFILES_S.NEXTVAL
125: INTO l_temp_profile_id FROM dual;
126: END LOOP;
127: END;
128: