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_UTIL dependencies on ENG_CHANGE_ROUTES

Line 131: SELECT ENG_CHANGE_ROUTES_S.NEXTVAL into X_NEW_ROUTE_ID

127: BEGIN
128:
129:
130: -- Get Next Sequence Value for ROUTE_ID
131: SELECT ENG_CHANGE_ROUTES_S.NEXTVAL into X_NEW_ROUTE_ID
132: FROM DUAL;
133:
134: -- Call COPY_ROUTE Prodedure
135: COPY_ROUTE (

Line 143: UPDATE ENG_CHANGE_ROUTES

139: P_API_CALLER => P_API_CALLER
140: ) ;
141:
142: -- Set Original Route to History
143: UPDATE ENG_CHANGE_ROUTES
144: SET TEMPLATE_FLAG = 'H'
145: WHERE ROUTE_ID = P_ROUTE_ID ;
146:
147:

Line 204: from ENG_CHANGE_ROUTES

200: PROGRAM_UPDATE_DATE,
201: ORIGINAL_SYSTEM_REFERENCE,
202: CLASSIFICATION_CODE,
203: ROUTE_TYPE_CODE
204: from ENG_CHANGE_ROUTES
205: where ROUTE_ID = P_FROM_ROUTE_ID ;
206:
207: -- No need to lock
208: -- for update of ROUTE_ID nowait;

Line 216: from ENG_CHANGE_ROUTES_TL

212: cursor c1 is select
213: ROUTE_NAME,
214: ROUTE_DESCRIPTION,
215: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
216: from ENG_CHANGE_ROUTES_TL
217: where ROUTE_ID = P_FROM_ROUTE_ID
218: and userenv('LANG') in (LANGUAGE, SOURCE_LANG) ;
219:
220: -- No need to lock

Line 345: * Table Hander for TL Entity Object: ENG_CHANGE_ROUTES_VL

341:
342: /********************************************************************
343: * API Type : Private Table Hander APIs
344: * Purpose : Those APIs are private
345: * Table Hander for TL Entity Object: ENG_CHANGE_ROUTES_VL
346: * PROCEDURE INSERT_ROW;
347: * PROCEDURE LOCK_ROW;
348: * PROCEDURE UPDATE_ROW;
349: * PROCEDURE DELETE_ROW;

Line 405: SELECT ROWID FROM ENG_CHANGE_ROUTES

401: )
402: IS
403:
404: CURSOR C IS
405: SELECT ROWID FROM ENG_CHANGE_ROUTES
406: WHERE ROUTE_ID = X_ROUTE_ID
407: ;
408:
409: BEGIN

Line 411: insert into ENG_CHANGE_ROUTES (

407: ;
408:
409: BEGIN
410:
411: insert into ENG_CHANGE_ROUTES (
412: ROUTE_ID,
413: TEMPLATE_FLAG,
414: OWNER_ID,
415: FIXED_FLAG,

Line 507: insert into ENG_CHANGE_ROUTES_TL (

503: X_CLASSIFICATION_CODE,
504: X_ROUTE_TYPE_CODE
505: );
506:
507: insert into ENG_CHANGE_ROUTES_TL (
508: LAST_UPDATE_LOGIN,
509: ROUTE_NAME,
510: ROUTE_DESCRIPTION,
511: ROUTE_ID,

Line 533: from ENG_CHANGE_ROUTES_TL T

529: from FND_LANGUAGES L
530: where L.INSTALLED_FLAG in ('I', 'B')
531: and not exists
532: (select NULL
533: from ENG_CHANGE_ROUTES_TL T
534: where T.ROUTE_ID = X_ROUTE_ID
535: and T.LANGUAGE = L.LANGUAGE_CODE);
536:
537:

Line 638: from ENG_CHANGE_ROUTES

634: PROGRAM_UPDATE_DATE,
635: ORIGINAL_SYSTEM_REFERENCE,
636: CLASSIFICATION_CODE,
637: ROUTE_TYPE_CODE
638: from ENG_CHANGE_ROUTES
639: where ROUTE_ID = X_ROUTE_ID
640: for update of ROUTE_ID nowait;
641: recinfo c%rowtype;
642:

Line 647: from ENG_CHANGE_ROUTES_TL

643: cursor c1 is select
644: ROUTE_NAME,
645: ROUTE_DESCRIPTION,
646: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
647: from ENG_CHANGE_ROUTES_TL
648: where ROUTE_ID = X_ROUTE_ID
649: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
650: for update of ROUTE_ID nowait;
651:

Line 819: update ENG_CHANGE_ROUTES set

815: IS
816:
817: BEGIN
818:
819: update ENG_CHANGE_ROUTES set
820: TEMPLATE_FLAG = X_TEMPLATE_FLAG,
821: OWNER_ID = X_OWNER_ID,
822: FIXED_FLAG = X_FIXED_FLAG,
823: OBJECT_NAME = X_OBJECT_NAME,

Line 869: update ENG_CHANGE_ROUTES_TL set

865: if (sql%notfound) then
866: raise no_data_found;
867: end if;
868:
869: update ENG_CHANGE_ROUTES_TL set
870: ROUTE_NAME = X_ROUTE_NAME,
871: ROUTE_DESCRIPTION = X_ROUTE_DESCRIPTION,
872: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
873: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 892: delete from ENG_CHANGE_ROUTES_TL

888: )
889: IS
890:
891: BEGIN
892: delete from ENG_CHANGE_ROUTES_TL
893: where ROUTE_ID = X_ROUTE_ID;
894:
895: if (sql%notfound) then
896: raise no_data_found;

Line 899: delete from ENG_CHANGE_ROUTES

895: if (sql%notfound) then
896: raise no_data_found;
897: end if;
898:
899: delete from ENG_CHANGE_ROUTES
900: where ROUTE_ID = X_ROUTE_ID;
901:
902: if (sql%notfound) then
903: raise no_data_found;

Line 915: delete from ENG_CHANGE_ROUTES_TL T

911: IS
912:
913: BEGIN
914:
915: delete from ENG_CHANGE_ROUTES_TL T
916: where not exists
917: (select NULL
918: from ENG_CHANGE_ROUTES B
919: where B.ROUTE_ID = T.ROUTE_ID

Line 918: from ENG_CHANGE_ROUTES B

914:
915: delete from ENG_CHANGE_ROUTES_TL T
916: where not exists
917: (select NULL
918: from ENG_CHANGE_ROUTES B
919: where B.ROUTE_ID = T.ROUTE_ID
920: );
921:
922: update ENG_CHANGE_ROUTES_TL T set (

Line 922: update ENG_CHANGE_ROUTES_TL T set (

918: from ENG_CHANGE_ROUTES B
919: where B.ROUTE_ID = T.ROUTE_ID
920: );
921:
922: update ENG_CHANGE_ROUTES_TL T set (
923: ROUTE_NAME,
924: ROUTE_DESCRIPTION
925: ) = (select
926: B.ROUTE_NAME,

Line 928: from ENG_CHANGE_ROUTES_TL B

924: ROUTE_DESCRIPTION
925: ) = (select
926: B.ROUTE_NAME,
927: B.ROUTE_DESCRIPTION
928: from ENG_CHANGE_ROUTES_TL B
929: where B.ROUTE_ID = T.ROUTE_ID
930: and B.LANGUAGE = T.SOURCE_LANG)
931: where (
932: T.ROUTE_ID,

Line 937: from ENG_CHANGE_ROUTES_TL SUBB, ENG_CHANGE_ROUTES_TL SUBT

933: T.LANGUAGE
934: ) in (select
935: SUBT.ROUTE_ID,
936: SUBT.LANGUAGE
937: from ENG_CHANGE_ROUTES_TL SUBB, ENG_CHANGE_ROUTES_TL SUBT
938: where SUBB.ROUTE_ID = SUBT.ROUTE_ID
939: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
940: and (SUBB.ROUTE_NAME <> SUBT.ROUTE_NAME
941: or SUBB.ROUTE_DESCRIPTION <> SUBT.ROUTE_DESCRIPTION

Line 947: insert into ENG_CHANGE_ROUTES_TL (

943: or (SUBB.ROUTE_DESCRIPTION is not null and SUBT.ROUTE_DESCRIPTION is null)
944: ));
945:
946:
947: insert into ENG_CHANGE_ROUTES_TL (
948: LAST_UPDATE_LOGIN,
949: ROUTE_NAME,
950: ROUTE_DESCRIPTION,
951: ROUTE_ID,

Line 969: from ENG_CHANGE_ROUTES_TL B, FND_LANGUAGES L

965: B.LAST_UPDATE_DATE,
966: B.LAST_UPDATED_BY,
967: L.LANGUAGE_CODE,
968: B.SOURCE_LANG
969: from ENG_CHANGE_ROUTES_TL B, FND_LANGUAGES L
970: where L.INSTALLED_FLAG in ('I', 'B')
971: and B.LANGUAGE = userenv('LANG')
972: and not exists
973: (select NULL

Line 974: from ENG_CHANGE_ROUTES_TL T

970: where L.INSTALLED_FLAG in ('I', 'B')
971: and B.LANGUAGE = userenv('LANG')
972: and not exists
973: (select NULL
974: from ENG_CHANGE_ROUTES_TL T
975: where T.ROUTE_ID = B.ROUTE_ID
976: and T.LANGUAGE = L.LANGUAGE_CODE);
977:
978: