APPS.ENG_CHANGE_ROUTE_UTIL dependencies on ENG_CHANGE_ROUTES_TL

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 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 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 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 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 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: