APPS.IEU_SEED_DATA_LOADER_PKG dependencies on IEU_UWQ_SEL_ENUMERATORS

Line 182: PROCEDURE Load_IEU_UWQ_SEL_ENUMERATORS (

178: end if;
179:
180: end Load_IEU_UWQ_SVR_MPS_PLUGINS;
181:
182: PROCEDURE Load_IEU_UWQ_SEL_ENUMERATORS (
183: P_UPLOAD_MODE IN VARCHAR2,
184: P_SEL_ENUM_ID IN VARCHAR2,
185: P_ENUM_PROC IN VARCHAR2,
186: P_REFRESH_PROC IN VARCHAR2,

Line 202: update IEU_UWQ_SEL_ENUMERATORS b

198: -- end if;
199:
200: user_id := fnd_load_util.owner_id(P_OWNER);
201:
202: update IEU_UWQ_SEL_ENUMERATORS b
203: set b.LAST_UPDATED_BY = user_id,
204: b.LAST_UPDATE_DATE = SYSDATE,
205: b.LAST_UPDATE_LOGIN = 0,
206: b.ENUM_PROC = P_ENUM_PROC,

Line 217: insert into IEU_UWQ_SEL_ENUMERATORS (

213: end if;
214:
215: exception
216: when NO_DATA_FOUND then
217: insert into IEU_UWQ_SEL_ENUMERATORS (
218: SEL_ENUM_ID,
219: CREATED_BY,
220: CREATION_DATE,
221: LAST_UPDATED_BY,

Line 239: end Load_IEU_UWQ_SEL_ENUMERATORS;

235: P_ENUM_TYPE_UUID);
236: end;
237: end if;
238:
239: end Load_IEU_UWQ_SEL_ENUMERATORS;
240:
241: --ieuenum.lct
242:
243: PROCEDURE Load_IEU_UWQ_SEL_ENUMERATORS (

Line 243: PROCEDURE Load_IEU_UWQ_SEL_ENUMERATORS (

239: end Load_IEU_UWQ_SEL_ENUMERATORS;
240:
241: --ieuenum.lct
242:
243: PROCEDURE Load_IEU_UWQ_SEL_ENUMERATORS (
244: P_UPLOAD_MODE IN VARCHAR2,
245: P_SEL_ENUM_ID IN VARCHAR2,
246: P_APPLICATION_SHORT_NAME IN VARCHAR2,
247: P_ENUM_TYPE_UUID IN VARCHAR2,

Line 305: IEU_UWQ_SEL_ENUMERATORS e

301: application_id
302: into
303: l_cur_app_id
304: from
305: IEU_UWQ_SEL_ENUMERATORS e
306: where
307: e.SEL_ENUM_ID = P_SEL_ENUM_ID;
308:
309: if (sql%notfound) then

Line 315: update IEU_UWQ_SEL_ENUMERATORS e

311: end if;
312:
313: if ((l_cur_app_id = 696) or (l_cur_app_id = -1)) then
314:
315: update IEU_UWQ_SEL_ENUMERATORS e
316: set
317: e.LAST_UPDATED_BY = l_user_id,
318: e.LAST_UPDATE_DATE = SYSDATE,
319: e.LAST_UPDATE_LOGIN = 0,

Line 347: update IEU_UWQ_SEL_ENUMERATORS e

343:
344: end if;
345: else
346:
347: update IEU_UWQ_SEL_ENUMERATORS e
348: set
349: e.LAST_UPDATED_BY = l_user_id,
350: e.LAST_UPDATE_DATE = SYSDATE,
351: e.LAST_UPDATE_LOGIN = 0,

Line 385: insert into IEU_UWQ_SEL_ENUMERATORS (

381:
382: exception
383: when NO_DATA_FOUND then
384:
385: insert into IEU_UWQ_SEL_ENUMERATORS (
386: SEL_ENUM_ID,
387: CREATED_BY,
388: CREATION_DATE,
389: LAST_UPDATED_BY,

Line 446: end Load_IEU_UWQ_SEL_ENUMERATORS;

442: P_WORK_Q_REGISTER_TYPE,
443: P_WORK_PANEL_REGISTERED_FLAG );
444: end;
445:
446: end Load_IEU_UWQ_SEL_ENUMERATORS;
447:
448:
449:
450: PROCEDURE Load_IEU_UWQ_NODE_DS (