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.ENG_CHANGE_ROUTE_STEP_UTIL dependencies on ENG_CHANGE_ROUTE_STEPS

Line 164: from ENG_CHANGE_ROUTE_STEPS_VL

160: PROGRAM_APPLICATION_ID,
161: PROGRAM_UPDATE_DATE,
162: ASSIGNMENT_CODE,
163: INSTRUCTION
164: from ENG_CHANGE_ROUTE_STEPS_VL
165: where ROUTE_ID = P_FROM_ROUTE_ID ;
166:
167: -- No Need to Lock
168: -- for update of STEP_ID nowait;

Line 203: SELECT ENG_CHANGE_ROUTE_STEPS_S.NEXTVAL into l_step_id

199:
200: for recinfo in c loop
201:
202: -- Get Next Sequence Value for ROUTE_ID
203: SELECT ENG_CHANGE_ROUTE_STEPS_S.NEXTVAL into l_step_id
204: FROM DUAL;
205:
206: INSERT_ROW (
207: X_ROWID => l_rowid,

Line 327: CURSOR C IS select ROWID from ENG_CHANGE_ROUTE_STEPS

323: X_ASSIGNMENT_CODE IN VARCHAR2
324: )
325: IS
326:
327: CURSOR C IS select ROWID from ENG_CHANGE_ROUTE_STEPS
328: where STEP_ID = X_STEP_ID
329: ;
330:
331: BEGIN

Line 333: insert into ENG_CHANGE_ROUTE_STEPS (

329: ;
330:
331: BEGIN
332:
333: insert into ENG_CHANGE_ROUTE_STEPS (
334: STEP_ID,
335: ROUTE_ID,
336: STEP_SEQ_NUM,
337: ADHOC_STEP_FLAG,

Line 419: insert into ENG_CHANGE_ROUTE_STEPS_TL (

415: X_PROGRAM_UPDATE_DATE,
416: X_ASSIGNMENT_CODE
417: );
418:
419: insert into ENG_CHANGE_ROUTE_STEPS_TL (
420: STEP_ID,
421: CREATION_DATE,
422: CREATED_BY,
423: LAST_UPDATE_DATE,

Line 443: from ENG_CHANGE_ROUTE_STEPS_TL T

439: from FND_LANGUAGES L
440: where L.INSTALLED_FLAG in ('I', 'B')
441: and not exists
442: (select NULL
443: from ENG_CHANGE_ROUTE_STEPS_TL T
444: where T.STEP_ID = X_STEP_ID
445: and T.LANGUAGE = L.LANGUAGE_CODE);
446:
447: open c;

Line 534: from ENG_CHANGE_ROUTE_STEPS

530: PROGRAM_ID,
531: PROGRAM_APPLICATION_ID,
532: PROGRAM_UPDATE_DATE,
533: ASSIGNMENT_CODE
534: from ENG_CHANGE_ROUTE_STEPS
535: where STEP_ID = X_STEP_ID
536: for update of STEP_ID nowait;
537: recinfo c%rowtype;
538:

Line 542: from ENG_CHANGE_ROUTE_STEPS_TL

538:
539: cursor c1 is select
540: INSTRUCTION,
541: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
542: from ENG_CHANGE_ROUTE_STEPS_TL
543: where STEP_ID = X_STEP_ID
544: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
545: for update of STEP_ID nowait;
546:

Line 696: update ENG_CHANGE_ROUTE_STEPS set

692: IS
693:
694: BEGIN
695:
696: update ENG_CHANGE_ROUTE_STEPS set
697: ROUTE_ID = X_ROUTE_ID,
698: STEP_SEQ_NUM = X_STEP_SEQ_NUM,
699: ADHOC_STEP_FLAG = X_ADHOC_STEP_FLAG,
700: WF_ITEM_TYPE = X_WF_ITEM_TYPE,

Line 741: update ENG_CHANGE_ROUTE_STEPS_TL set

737: if (sql%notfound) then
738: raise no_data_found;
739: end if;
740:
741: update ENG_CHANGE_ROUTE_STEPS_TL set
742: INSTRUCTION = X_INSTRUCTION,
743: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
744: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
745: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 764: delete from ENG_CHANGE_ROUTE_STEPS_TL

760: IS
761:
762: BEGIN
763:
764: delete from ENG_CHANGE_ROUTE_STEPS_TL
765: where STEP_ID = X_STEP_ID;
766:
767: if (sql%notfound) then
768: raise no_data_found;

Line 771: delete from ENG_CHANGE_ROUTE_STEPS

767: if (sql%notfound) then
768: raise no_data_found;
769: end if;
770:
771: delete from ENG_CHANGE_ROUTE_STEPS
772: where STEP_ID = X_STEP_ID;
773:
774: if (sql%notfound) then
775: raise no_data_found;

Line 787: delete from ENG_CHANGE_ROUTE_STEPS_TL T

783: IS
784:
785: BEGIN
786:
787: delete from ENG_CHANGE_ROUTE_STEPS_TL T
788: where not exists
789: (select NULL
790: from ENG_CHANGE_ROUTE_STEPS B
791: where B.STEP_ID = T.STEP_ID

Line 790: from ENG_CHANGE_ROUTE_STEPS B

786:
787: delete from ENG_CHANGE_ROUTE_STEPS_TL T
788: where not exists
789: (select NULL
790: from ENG_CHANGE_ROUTE_STEPS B
791: where B.STEP_ID = T.STEP_ID
792: );
793:
794: update ENG_CHANGE_ROUTE_STEPS_TL T set (

Line 794: update ENG_CHANGE_ROUTE_STEPS_TL T set (

790: from ENG_CHANGE_ROUTE_STEPS B
791: where B.STEP_ID = T.STEP_ID
792: );
793:
794: update ENG_CHANGE_ROUTE_STEPS_TL T set (
795: INSTRUCTION
796: ) = (select
797: B.INSTRUCTION
798: from ENG_CHANGE_ROUTE_STEPS_TL B

Line 798: from ENG_CHANGE_ROUTE_STEPS_TL B

794: update ENG_CHANGE_ROUTE_STEPS_TL T set (
795: INSTRUCTION
796: ) = (select
797: B.INSTRUCTION
798: from ENG_CHANGE_ROUTE_STEPS_TL B
799: where B.STEP_ID = T.STEP_ID
800: and B.LANGUAGE = T.SOURCE_LANG)
801: where (
802: T.STEP_ID,

Line 807: from ENG_CHANGE_ROUTE_STEPS_TL SUBB, ENG_CHANGE_ROUTE_STEPS_TL SUBT

803: T.LANGUAGE
804: ) in (select
805: SUBT.STEP_ID,
806: SUBT.LANGUAGE
807: from ENG_CHANGE_ROUTE_STEPS_TL SUBB, ENG_CHANGE_ROUTE_STEPS_TL SUBT
808: where SUBB.STEP_ID = SUBT.STEP_ID
809: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
810: and (SUBB.INSTRUCTION <> SUBT.INSTRUCTION
811: or (SUBB.INSTRUCTION is null and SUBT.INSTRUCTION is not null)

Line 816: insert into ENG_CHANGE_ROUTE_STEPS_TL (

812: or (SUBB.INSTRUCTION is not null and SUBT.INSTRUCTION is null)
813: ));
814:
815:
816: insert into ENG_CHANGE_ROUTE_STEPS_TL (
817: STEP_ID,
818: CREATION_DATE,
819: CREATED_BY,
820: LAST_UPDATE_DATE,

Line 836: from ENG_CHANGE_ROUTE_STEPS_TL B, FND_LANGUAGES L

832: B.LAST_UPDATE_LOGIN,
833: B.INSTRUCTION,
834: L.LANGUAGE_CODE,
835: B.SOURCE_LANG
836: from ENG_CHANGE_ROUTE_STEPS_TL B, FND_LANGUAGES L
837: where L.INSTALLED_FLAG in ('I', 'B')
838: and B.LANGUAGE = userenv('LANG')
839: and not exists
840: (select NULL

Line 841: from ENG_CHANGE_ROUTE_STEPS_TL T

837: where L.INSTALLED_FLAG in ('I', 'B')
838: and B.LANGUAGE = userenv('LANG')
839: and not exists
840: (select NULL
841: from ENG_CHANGE_ROUTE_STEPS_TL T
842: where T.STEP_ID = B.STEP_ID
843: and T.LANGUAGE = L.LANGUAGE_CODE);
844:
845: