APPS.ENG_CHANGE_ROUTE_PEOPLE_UTIL dependencies on ENG_CHANGE_ROUTE_PEOPLE_TL

Line 735: insert into ENG_CHANGE_ROUTE_PEOPLE_TL (

731: X_RESPONSE_CONDITION_CODE,
732: X_PARENT_ROUTE_PEOPLE_ID
733: );
734:
735: insert into ENG_CHANGE_ROUTE_PEOPLE_TL (
736: ROUTE_PEOPLE_ID,
737: CREATION_DATE,
738: CREATED_BY,
739: LAST_UPDATE_DATE,

Line 759: from ENG_CHANGE_ROUTE_PEOPLE_TL T

755: from FND_LANGUAGES L
756: where L.INSTALLED_FLAG in ('I', 'B')
757: and not exists
758: (select NULL
759: from ENG_CHANGE_ROUTE_PEOPLE_TL T
760: where T.ROUTE_PEOPLE_ID = X_ROUTE_PEOPLE_ID
761: and T.LANGUAGE = L.LANGUAGE_CODE);
762:
763: open c;

Line 820: from ENG_CHANGE_ROUTE_PEOPLE_TL

816:
817: cursor c1 is select
818: RESPONSE_DESCRIPTION,
819: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
820: from ENG_CHANGE_ROUTE_PEOPLE_TL
821: where ROUTE_PEOPLE_ID = X_ROUTE_PEOPLE_ID
822: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
823: for update of ROUTE_PEOPLE_ID nowait;
824:

Line 944: update ENG_CHANGE_ROUTE_PEOPLE_TL set

940: if (sql%notfound) then
941: raise no_data_found;
942: end if;
943:
944: update ENG_CHANGE_ROUTE_PEOPLE_TL set
945: RESPONSE_DESCRIPTION = X_RESPONSE_DESCRIPTION,
946: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
947: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
948: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 970: delete from ENG_CHANGE_ROUTE_PEOPLE_TL

966:
967: BEGIN
968:
969:
970: delete from ENG_CHANGE_ROUTE_PEOPLE_TL
971: where ROUTE_PEOPLE_ID = X_ROUTE_PEOPLE_ID;
972:
973: if (sql%notfound) then
974: raise no_data_found;

Line 992: delete from ENG_CHANGE_ROUTE_PEOPLE_TL T

988: IS
989:
990: BEGIN
991:
992: delete from ENG_CHANGE_ROUTE_PEOPLE_TL T
993: where not exists
994: (select NULL
995: from ENG_CHANGE_ROUTE_PEOPLE B
996: where B.ROUTE_PEOPLE_ID = T.ROUTE_PEOPLE_ID

Line 999: update ENG_CHANGE_ROUTE_PEOPLE_TL T set (

995: from ENG_CHANGE_ROUTE_PEOPLE B
996: where B.ROUTE_PEOPLE_ID = T.ROUTE_PEOPLE_ID
997: );
998:
999: update ENG_CHANGE_ROUTE_PEOPLE_TL T set (
1000: RESPONSE_DESCRIPTION
1001: ) = (select
1002: B.RESPONSE_DESCRIPTION
1003: from ENG_CHANGE_ROUTE_PEOPLE_TL B

Line 1003: from ENG_CHANGE_ROUTE_PEOPLE_TL B

999: update ENG_CHANGE_ROUTE_PEOPLE_TL T set (
1000: RESPONSE_DESCRIPTION
1001: ) = (select
1002: B.RESPONSE_DESCRIPTION
1003: from ENG_CHANGE_ROUTE_PEOPLE_TL B
1004: where B.ROUTE_PEOPLE_ID = T.ROUTE_PEOPLE_ID
1005: and B.LANGUAGE = T.SOURCE_LANG)
1006: where (
1007: T.ROUTE_PEOPLE_ID,

Line 1012: from ENG_CHANGE_ROUTE_PEOPLE_TL SUBB, ENG_CHANGE_ROUTE_PEOPLE_TL SUBT

1008: T.LANGUAGE
1009: ) in (select
1010: SUBT.ROUTE_PEOPLE_ID,
1011: SUBT.LANGUAGE
1012: from ENG_CHANGE_ROUTE_PEOPLE_TL SUBB, ENG_CHANGE_ROUTE_PEOPLE_TL SUBT
1013: where SUBB.ROUTE_PEOPLE_ID = SUBT.ROUTE_PEOPLE_ID
1014: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1015: and (SUBB.RESPONSE_DESCRIPTION <> SUBT.RESPONSE_DESCRIPTION
1016: or (SUBB.RESPONSE_DESCRIPTION is null and SUBT.RESPONSE_DESCRIPTION is not null)

Line 1020: insert into ENG_CHANGE_ROUTE_PEOPLE_TL (

1016: or (SUBB.RESPONSE_DESCRIPTION is null and SUBT.RESPONSE_DESCRIPTION is not null)
1017: or (SUBB.RESPONSE_DESCRIPTION is not null and SUBT.RESPONSE_DESCRIPTION is null)
1018: ));
1019:
1020: insert into ENG_CHANGE_ROUTE_PEOPLE_TL (
1021: ROUTE_PEOPLE_ID,
1022: CREATION_DATE,
1023: CREATED_BY,
1024: LAST_UPDATE_DATE,

Line 1040: from ENG_CHANGE_ROUTE_PEOPLE_TL B, FND_LANGUAGES L

1036: B.LAST_UPDATE_LOGIN,
1037: B.RESPONSE_DESCRIPTION,
1038: L.LANGUAGE_CODE,
1039: B.SOURCE_LANG
1040: from ENG_CHANGE_ROUTE_PEOPLE_TL B, FND_LANGUAGES L
1041: where L.INSTALLED_FLAG in ('I', 'B')
1042: and B.LANGUAGE = userenv('LANG')
1043: and not exists
1044: (select NULL

Line 1045: from ENG_CHANGE_ROUTE_PEOPLE_TL T

1041: where L.INSTALLED_FLAG in ('I', 'B')
1042: and B.LANGUAGE = userenv('LANG')
1043: and not exists
1044: (select NULL
1045: from ENG_CHANGE_ROUTE_PEOPLE_TL T
1046: where T.ROUTE_PEOPLE_ID = B.ROUTE_PEOPLE_ID
1047: and T.LANGUAGE = L.LANGUAGE_CODE);
1048:
1049: END ADD_LANGUAGE;