APPS.AMS_IMP_CONF_IMPORT_TYPES_PKG dependencies on AMS_IMP_CONFIG_IMPORT_TYPES

Line 21: insert into AMS_IMP_CONFIG_IMPORT_TYPES (

17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: begin
21: insert into AMS_IMP_CONFIG_IMPORT_TYPES (
22: IMP_CONFIG_IMPORT_TYPE_ID,
23: LAST_UPDATED_BY,
24: OBJECT_VERSION_NUMBER,
25: CREATED_BY,

Line 61: from AMS_IMP_CONFIG_IMPORT_TYPES

57: APPLICATION_ID,
58: IMPORT_TYPE,
59: ACCESS_ALLOWED,
60: IMP_CONFIG_IMPORT_TYPE_ID
61: from AMS_IMP_CONFIG_IMPORT_TYPES
62: where IMP_CONFIG_IMPORT_TYPE_ID = X_IMP_CONFIG_IMPORT_TYPE_ID
63: for update of IMP_CONFIG_IMPORT_TYPE_ID nowait;
64: begin
65: for tlinfo in c1 loop

Line 92: update AMS_IMP_CONFIG_IMPORT_TYPES set

88: X_LAST_UPDATED_BY in NUMBER,
89: X_LAST_UPDATE_LOGIN in NUMBER
90: ) is
91: begin
92: update AMS_IMP_CONFIG_IMPORT_TYPES set
93: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
94: APPLICATION_ID = X_APPLICATION_ID,
95: IMPORT_TYPE = X_IMPORT_TYPE,
96: ACCESS_ALLOWED = X_ACCESS_ALLOWED,

Line 111: delete from AMS_IMP_CONFIG_IMPORT_TYPES

107: procedure DELETE_ROW (
108: X_IMP_CONFIG_IMPORT_TYPE_ID in NUMBER
109: ) is
110: begin
111: delete from AMS_IMP_CONFIG_IMPORT_TYPES
112: where IMP_CONFIG_IMPORT_TYPE_ID = X_IMP_CONFIG_IMPORT_TYPE_ID;
113:
114: if (sql%notfound) then
115: raise no_data_found;

Line 141: from AMS_IMP_CONFIG_IMPORT_TYPES

137: l_row_id varchar2(100);
138:
139: cursor c_chk_col_exists is
140: select 'x'
141: from AMS_IMP_CONFIG_IMPORT_TYPES
142: where IMP_CONFIG_IMPORT_TYPE_ID = X_IMP_CONFIG_IMPORT_TYPE_ID;
143:
144: cursor c_get_con_com_id is
145: select AMS_IMP_CONFIG_IMPORT_TYPES_S.nextval

Line 145: select AMS_IMP_CONFIG_IMPORT_TYPES_S.nextval

141: from AMS_IMP_CONFIG_IMPORT_TYPES
142: where IMP_CONFIG_IMPORT_TYPE_ID = X_IMP_CONFIG_IMPORT_TYPE_ID;
143:
144: cursor c_get_con_com_id is
145: select AMS_IMP_CONFIG_IMPORT_TYPES_S.nextval
146: from dual;
147:
148: begin
149: