APPS.AMS_IMP_LIST_IMPORT_TYPES_PKG dependencies on AMS_IMP_LIST_IMPORT_TYPES_S

Line 106: update AMS_IMP_LIST_IMPORT_TYPES set

102: X_LAST_UPDATED_BY in NUMBER,
103: X_LAST_UPDATE_LOGIN in NUMBER
104: ) is
105: begin
106: update AMS_IMP_LIST_IMPORT_TYPES set
107: IMPORT_TYPE = X_IMPORT_TYPE,
108: VIEW_NAME = X_VIEW_NAME,
109: B2B_FLAG = X_B2B_FLAG,
110: CONCURRENT_PROGRAM = X_CONCURRENT_PROGRAM,

Line 162: select ams_imp_list_import_types_s.nextval

158: from ams_imp_list_import_types
159: where IMPORT_TYPE_ID = X_IMPORT_TYPE_ID;
160:
161: cursor c_get_import_type_id is
162: select ams_imp_list_import_types_s.nextval
163: from dual;
164: BEGIN
165: if X_OWNER = 'SEED' then
166: l_user_id := 1;