APPS.ENG_CHANGE_ROUTE_STEP_UTIL dependencies on ENG_CHANGE_ROUTE_STEPS_TL

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