eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_CHANGE_USER_ATTRS_PUB dependencies on ENG_CHG_USR_ATR_INTERFACE

Line 93: FROM ENG_CHG_USR_ATR_INTERFACE

89: CURSOR change_num_to_id_cursor (cp_data_set_id IN NUMBER)
90: IS
91: SELECT DISTINCT ORGANIZATION_ID
92: ,CHANGE_NUMBER
93: FROM ENG_CHG_USR_ATR_INTERFACE
94: WHERE DATA_SET_ID = cp_data_set_id
95: AND PROCESS_STATUS = G_PS_IN_PROCESS
96: AND CHANGE_NUMBER IS NOT NULL
97: AND CHANGE_ID IS NULL;

Line 112: FROM ENG_CHG_USR_ATR_INTERFACE

108: ,CHANGE_MGMT_TYPE_CODE
109: ,CHANGE_TYPE_ID
110: ,ROW_IDENTIFIER
111: ,CHANGE_LINE_ID
112: FROM ENG_CHG_USR_ATR_INTERFACE
113: WHERE DATA_SET_ID = cp_data_set_id
114: AND PROCESS_STATUS = G_PS_ERROR;
115:
116: -------------------------------------------------------------------

Line 140: FROM ENG_CHG_USR_ATR_INTERFACE

136: ,CHANGE_ID
137: ,CHANGE_TYPE_ID
138: ,ATTR_GROUP_ID
139: ,CHANGE_LINE_ID
140: FROM ENG_CHG_USR_ATR_INTERFACE
141: WHERE DATA_SET_ID = cp_data_set_id
142: AND CHANGE_LINE_ID is NULL
143: AND PROCESS_STATUS = G_PS_IN_PROCESS
144: ORDER BY ORGANIZATION_ID, CHANGE_ID,(DECODE (UPPER(TRANSACTION_TYPE),

Line 172: FROM ENG_CHG_USR_ATR_INTERFACE

168: ,CHANGE_ID
169: ,CHANGE_TYPE_ID
170: ,ATTR_GROUP_ID
171: ,CHANGE_LINE_ID
172: FROM ENG_CHG_USR_ATR_INTERFACE
173: WHERE DATA_SET_ID = cp_data_set_id
174: AND CHANGE_LINE_ID is NOT NULL
175: AND PROCESS_STATUS = G_PS_IN_PROCESS
176: ORDER BY ORGANIZATION_ID, CHANGE_LINE_ID,(DECODE (UPPER(TRANSACTION_TYPE),

Line 245: UPDATE ENG_CHG_USR_ATR_INTERFACE

241: -- also update Concurrent Request information for better tracking --
242: -- and update the "WHO" columns on the assumption that the current --
243: -- user is also the person who loaded this data set into the table --
244: ---------------------------------------------------------------------
245: UPDATE ENG_CHG_USR_ATR_INTERFACE
246: SET PROCESS_STATUS = G_PS_IN_PROCESS
247: ,ORGANIZATION_ID = NULL
248: ,CHANGE_TYPE_ID = NULL
249: ,CHANGE_ID = NULL

Line 272: UPDATE ENG_CHG_USR_ATR_INTERFACE UAI

268: -- 1). Convert Organization Code to Organization ID
269: ------------------------------------------------------------------
270: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Org Code conversion', 2);
271:
272: UPDATE ENG_CHG_USR_ATR_INTERFACE UAI
273: SET UAI.ORGANIZATION_ID = (SELECT MP.ORGANIZATION_ID
274: FROM MTL_PARAMETERS MP
275: WHERE MP.ORGANIZATION_CODE = UAI.ORGANIZATION_CODE)
276: WHERE UAI.DATA_SET_ID = p_data_set_id

Line 286: -- UPDATE ENG_CHG_USR_ATR_INTERFACE

282: ---------------------------------------------------------------------
283: -- Mark as errors all rows where we didn't get an Organization ID --
284: -- (marking errors as we go avoids further processing of bad rows) --
285: ---------------------------------------------------------------------
286: -- UPDATE ENG_CHG_USR_ATR_INTERFACE
287: -- SET PROCESS_STATUS = G_PS_ERROR
288: -- WHERE DATA_SET_ID = p_data_set_id
289: -- AND PROCESS_STATUS = G_PS_IN_PROCESS
290: -- AND ORGANIZATION_ID IS NULL;

Line 295: UPDATE ENG_CHG_USR_ATR_INTERFACE

291:
292: -- Joseph George : Bug Fix for Change Management Import Bulk Loading
293: -- Bug No : 2873555, Base Bug
294:
295: UPDATE ENG_CHG_USR_ATR_INTERFACE
296: SET PROCESS_STATUS = G_PS_ERROR
297: WHERE ROW_IDENTIFIER IN (SELECT DISTINCT ROW_IDENTIFIER
298: FROM ENG_CHG_USR_ATR_INTERFACE
299: WHERE DATA_SET_ID = p_data_set_id

Line 298: FROM ENG_CHG_USR_ATR_INTERFACE

294:
295: UPDATE ENG_CHG_USR_ATR_INTERFACE
296: SET PROCESS_STATUS = G_PS_ERROR
297: WHERE ROW_IDENTIFIER IN (SELECT DISTINCT ROW_IDENTIFIER
298: FROM ENG_CHG_USR_ATR_INTERFACE
299: WHERE DATA_SET_ID = p_data_set_id
300: AND PROCESS_STATUS = G_PS_IN_PROCESS
301: AND ORGANIZATION_ID IS NULL)
302: AND DATA_SET_ID = p_data_set_id;

Line 314: UPDATE ENG_CHG_USR_ATR_INTERFACE UAI

310: -- from change_line_sequence_number
311: -------------------------------------------------------------------------
312: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Change Number conversion', 2);
313:
314: UPDATE ENG_CHG_USR_ATR_INTERFACE UAI
315: SET UAI.CHANGE_ID =
316: (SELECT EEC.CHANGE_ID
317: FROM ENG_ENGINEERING_CHANGES EEC
318: WHERE EEC.ORGANIZATION_ID = UAI.ORGANIZATION_ID

Line 332: UPDATE ENG_CHG_USR_ATR_INTERFACE UAI SET

328: AND EEC.CHANGE_MGMT_TYPE_CODE = UAI.CHANGE_MGMT_TYPE_CODE
329: AND UAI.CHANGE_LINE_SEQUENCE_NUMBER IS NULL);
330:
331:
332: UPDATE ENG_CHG_USR_ATR_INTERFACE UAI SET
333: UAI.CHANGE_LINE_ID=
334: (SELECT ELV.CHANGE_LINE_ID
335: FROM ENG_CHANGE_LINES ELV,ENG_ENGINEERING_CHANGES EEC
336: WHERE

Line 368: -- UPDATE ENG_CHG_USR_ATR_INTERFACE

364: ---------------------------------------------------------------------------
365: -- Mark as errors all rows where we didn't get Change_id --
366: -- (as always, ignoring rows that errored out earlier in our processing) --
367: ---------------------------------------------------------------------------
368: -- UPDATE ENG_CHG_USR_ATR_INTERFACE
369: -- SET PROCESS_STATUS = G_PS_ERROR
370: -- WHERE DATA_SET_ID = p_data_set_id
371: -- AND PROCESS_STATUS = G_PS_IN_PROCESS
372: -- AND CHANGE_ID IS NULL

Line 378: UPDATE ENG_CHG_USR_ATR_INTERFACE

374:
375: -- Joseph George : Bug Fix for Change Management Import Bulk Loading
376: -- Bug No : 2873555, Base Bug
377:
378: UPDATE ENG_CHG_USR_ATR_INTERFACE
379: SET PROCESS_STATUS = G_PS_ERROR
380: WHERE ROW_IDENTIFIER IN (SELECT DISTINCT ROW_IDENTIFIER
381: FROM ENG_CHG_USR_ATR_INTERFACE
382: WHERE DATA_SET_ID = p_data_set_id

Line 381: FROM ENG_CHG_USR_ATR_INTERFACE

377:
378: UPDATE ENG_CHG_USR_ATR_INTERFACE
379: SET PROCESS_STATUS = G_PS_ERROR
380: WHERE ROW_IDENTIFIER IN (SELECT DISTINCT ROW_IDENTIFIER
381: FROM ENG_CHG_USR_ATR_INTERFACE
382: WHERE DATA_SET_ID = p_data_set_id
383: AND PROCESS_STATUS = G_PS_IN_PROCESS
384: AND CHANGE_ID IS NULL
385: AND CHANGE_LINE_SEQUENCE_NUMBER IS NULL)

Line 389: UPDATE ENG_CHG_USR_ATR_INTERFACE

385: AND CHANGE_LINE_SEQUENCE_NUMBER IS NULL)
386: AND DATA_SET_ID = p_data_set_id;
387:
388:
389: UPDATE ENG_CHG_USR_ATR_INTERFACE
390: SET PROCESS_STATUS = G_PS_ERROR
391: WHERE ROW_IDENTIFIER IN (SELECT DISTINCT ROW_IDENTIFIER
392: FROM ENG_CHG_USR_ATR_INTERFACE
393: WHERE DATA_SET_ID = p_data_set_id

Line 392: FROM ENG_CHG_USR_ATR_INTERFACE

388:
389: UPDATE ENG_CHG_USR_ATR_INTERFACE
390: SET PROCESS_STATUS = G_PS_ERROR
391: WHERE ROW_IDENTIFIER IN (SELECT DISTINCT ROW_IDENTIFIER
392: FROM ENG_CHG_USR_ATR_INTERFACE
393: WHERE DATA_SET_ID = p_data_set_id
394: AND PROCESS_STATUS = G_PS_IN_PROCESS
395: AND CHANGE_LINE_ID IS NULL
396: AND CHANGE_LINE_SEQUENCE_NUMBER IS NOT NULL)

Line 404: UPDATE ENG_CHG_USR_ATR_INTERFACE UAI

400: -- 4). Find the Change Type Id for each Change and Change Line--
401: ------------------------------------------------------
402: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Change Type Id conversion', 2);
403:
404: UPDATE ENG_CHG_USR_ATR_INTERFACE UAI
405: SET UAI.CHANGE_TYPE_ID =
406: (SELECT EEC.CHANGE_ORDER_TYPE_ID
407: FROM ENG_ENGINEERING_CHANGES EEC
408: WHERE EEC.ORGANIZATION_ID = UAI.ORGANIZATION_ID

Line 420: UPDATE ENG_CHG_USR_ATR_INTERFACE UAI

416: AND EEC.CHANGE_ID = UAI.CHANGE_ID
417: AND UAI.CHANGE_LINE_SEQUENCE_NUMBER IS NULL);
418:
419:
420: UPDATE ENG_CHG_USR_ATR_INTERFACE UAI
421: SET UAI.CHANGE_TYPE_ID =
422: (SELECT EEC.CHANGE_TYPE_ID
423: FROM ENG_CHANGE_LINES_VL EEC
424: WHERE

Line 435: -- UPDATE ENG_CHG_USR_ATR_INTERFACE

431: ---------------------------------------------------------------------------
432: -- Mark as errors all rows where we didn't get Change Type ID --
433: -- (as always, ignoring rows that errored out earlier in our processing) --
434: ---------------------------------------------------------------------------
435: -- UPDATE ENG_CHG_USR_ATR_INTERFACE
436: -- SET PROCESS_STATUS = G_PS_ERROR
437: -- WHERE DATA_SET_ID = p_data_set_id
438: -- AND PROCESS_STATUS = G_PS_IN_PROCESS
439: -- AND CHANGE_TYPE_ID IS NULL;

Line 444: UPDATE ENG_CHG_USR_ATR_INTERFACE

440:
441: -- Joseph George : Bug Fix for Change Management Import Bulk Loading
442: -- Bug No : 2873555, Base Bug
443:
444: UPDATE ENG_CHG_USR_ATR_INTERFACE
445: SET PROCESS_STATUS = G_PS_ERROR
446: WHERE ROW_IDENTIFIER IN (SELECT DISTINCT ROW_IDENTIFIER
447: FROM ENG_CHG_USR_ATR_INTERFACE
448: WHERE DATA_SET_ID = p_data_set_id

Line 447: FROM ENG_CHG_USR_ATR_INTERFACE

443:
444: UPDATE ENG_CHG_USR_ATR_INTERFACE
445: SET PROCESS_STATUS = G_PS_ERROR
446: WHERE ROW_IDENTIFIER IN (SELECT DISTINCT ROW_IDENTIFIER
447: FROM ENG_CHG_USR_ATR_INTERFACE
448: WHERE DATA_SET_ID = p_data_set_id
449: AND PROCESS_STATUS = G_PS_IN_PROCESS
450: AND CHANGE_TYPE_ID IS NULL )
451: AND DATA_SET_ID = p_data_set_id;

Line 609: UPDATE ENG_CHG_USR_ATR_INTERFACE

605: -- call to Process_User_Attrs_Data includes a commit, and FOR UPDATE --
606: -- cursors can't handle commits done in mid-looping. --
607: -------------------------------------------------------------------------
608:
609: UPDATE ENG_CHG_USR_ATR_INTERFACE
610: SET PROCESS_STATUS = G_PS_ERROR
611: WHERE DATA_SET_ID = p_data_set_id
612: AND ORGANIZATION_ID = attr_rec.ORGANIZATION_ID
613: AND CHANGE_ID = attr_rec.CHANGE_ID;

Line 906: UPDATE ENG_CHG_USR_ATR_INTERFACE

902: -- call to Process_User_Attrs_Data includes a commit, and FOR UPDATE --
903: -- cursors can't handle commits done in mid-looping. --
904: -------------------------------------------------------------------------
905:
906: UPDATE ENG_CHG_USR_ATR_INTERFACE
907: SET PROCESS_STATUS = G_PS_ERROR
908: WHERE DATA_SET_ID = p_data_set_id
909: AND ORGANIZATION_ID = attr_rec.ORGANIZATION_ID
910: AND CHANGE_LINE_ID = attr_rec.CHANGE_LINE_ID;

Line 1172: l_dynamic_sql := 'UPDATE ENG_CHG_USR_ATR_INTERFACE'||

1168: -- concurrent program--so the fact that our failed Row IDs --
1169: -- aren't passed as a bind variable doesn't matter, because --
1170: -- the statement won't get parsed more than once anyway). --
1171: ---------------------------------------------------------------
1172: l_dynamic_sql := 'UPDATE ENG_CHG_USR_ATR_INTERFACE'||
1173: ' SET PROCESS_STATUS = '|| G_PS_ERROR ||
1174: ' WHERE DATA_SET_ID = :1'||
1175: ' AND ROW_IDENTIFIER IN ('|| l_failed_row_id_list || ')';
1176:

Line 1186: DELETE FROM ENG_CHG_USR_ATR_INTERFACE

1182: -----------------------------------------------
1183: -- Delete all successful rows from the table --
1184: -- (they're the only rows still in process) --
1185: -----------------------------------------------
1186: DELETE FROM ENG_CHG_USR_ATR_INTERFACE
1187: WHERE DATA_SET_ID = p_data_set_id
1188: AND PROCESS_STATUS = G_PS_IN_PROCESS;
1189: ELSE
1190: ----------------------------------------------

Line 1194: UPDATE ENG_CHG_USR_ATR_INTERFACE

1190: ----------------------------------------------
1191: -- Mark all rows we've processed as success --
1192: -- if they weren't marked as failure above --
1193: ----------------------------------------------
1194: UPDATE ENG_CHG_USR_ATR_INTERFACE
1195: SET PROCESS_STATUS = G_PS_SUCCESS
1196: WHERE DATA_SET_ID = p_data_set_id
1197: AND PROCESS_STATUS = G_PS_IN_PROCESS;
1198: END IF;