APPS.AMS_LIST_SRC_TYPES_PKG dependencies on AMS_LIST_SRC_TYPES_S

Line 247: UPDATE ams_list_src_types SET

243: END IF;
244: CLOSE c_import_type;
245: end if;
246:
247: UPDATE ams_list_src_types SET
248: object_version_number = x_object_version_number,
249: list_source_name = x_list_source_name,
250: list_source_type = x_list_source_type,
251: source_type_code = x_source_type_code,

Line 336: SELECT ams_list_src_types_s.NEXTVAL

332: FROM ams_list_src_types
333: WHERE list_source_type_id = x_list_source_type_id;
334:
335: CURSOR c_get_id is
336: SELECT ams_list_src_types_s.NEXTVAL
337: FROM DUAL;
338: BEGIN
339: if X_OWNER = 'SEED' then
340: l_user_id := 1;