APPS.AMW_CONTROLS_PKG dependencies on AMW_CONTROLS_TL

Line 169: insert into AMW_CONTROLS_TL (

165: ---npanandi 12.10.2004: added below for Ctrl Classification
166: x_classification
167: );
168:
169: insert into AMW_CONTROLS_TL (
170: CONTROL_REV_ID,
171: NAME,
172: DESCRIPTION,
173: PHYSICAL_EVIDENCE,

Line 205: from AMW_CONTROLS_TL T

201: from FND_LANGUAGES L
202: where L.INSTALLED_FLAG in ('I', 'B')
203: and not exists
204: (select NULL
205: from AMW_CONTROLS_TL T
206: where T.CONTROL_REV_ID = X_CONTROL_REV_ID
207: and T.LANGUAGE = L.LANGUAGE_CODE);
208:
209: open c;

Line 328: from AMW_CONTROLS_TL

324: PHYSICAL_EVIDENCE,
325: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG,
326: verification_source_name,
327: verification_instruction
328: from AMW_CONTROLS_TL
329: where CONTROL_REV_ID = X_CONTROL_REV_ID
330: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
331: for update of CONTROL_REV_ID nowait;
332: begin

Line 565: update AMW_CONTROLS_TL set

561: if (sql%notfound) then
562: raise no_data_found;
563: end if;
564:
565: update AMW_CONTROLS_TL set
566: NAME = X_NAME,
567: DESCRIPTION = X_DESCRIPTION,
568: PHYSICAL_EVIDENCE = X_PHYSICAL_EVIDENCE,
569: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 587: delete from AMW_CONTROLS_TL

583: procedure DELETE_ROW (
584: X_CONTROL_REV_ID in NUMBER
585: ) is
586: begin
587: delete from AMW_CONTROLS_TL
588: where CONTROL_REV_ID = X_CONTROL_REV_ID;
589:
590: if (sql%notfound) then
591: raise no_data_found;

Line 605: delete from AMW_CONTROLS_TL T

601:
602: procedure ADD_LANGUAGE
603: is
604: begin
605: delete from AMW_CONTROLS_TL T
606: where not exists
607: (select NULL
608: from AMW_CONTROLS_B B
609: where B.CONTROL_REV_ID = T.CONTROL_REV_ID

Line 612: update AMW_CONTROLS_TL T set (

608: from AMW_CONTROLS_B B
609: where B.CONTROL_REV_ID = T.CONTROL_REV_ID
610: );
611:
612: update AMW_CONTROLS_TL T set (
613: NAME,
614: DESCRIPTION,
615: PHYSICAL_EVIDENCE,
616: verification_source_name,

Line 624: from AMW_CONTROLS_TL B

620: B.DESCRIPTION,
621: B.PHYSICAL_EVIDENCE,
622: B.verification_source_name,
623: B.verification_instruction
624: from AMW_CONTROLS_TL B
625: where B.CONTROL_REV_ID = T.CONTROL_REV_ID
626: and B.LANGUAGE = T.SOURCE_LANG)
627: where (
628: T.CONTROL_REV_ID,

Line 633: from AMW_CONTROLS_TL SUBB, AMW_CONTROLS_TL SUBT

629: T.LANGUAGE
630: ) in (select
631: SUBT.CONTROL_REV_ID,
632: SUBT.LANGUAGE
633: from AMW_CONTROLS_TL SUBB, AMW_CONTROLS_TL SUBT
634: where SUBB.CONTROL_REV_ID = SUBT.CONTROL_REV_ID
635: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
636: and (SUBB.NAME <> SUBT.NAME
637: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 651: insert into AMW_CONTROLS_TL (

647: or (SUBB.verification_instruction is null and SUBT.verification_instruction is not null)
648: or (SUBB.verification_instruction is not null and SUBT.verification_instruction is null)
649: ));
650:
651: insert into AMW_CONTROLS_TL (
652: CONTROL_REV_ID,
653: NAME,
654: DESCRIPTION,
655: PHYSICAL_EVIDENCE,

Line 683: from AMW_CONTROLS_TL B, FND_LANGUAGES L

679: L.LANGUAGE_CODE,
680: B.SOURCE_LANG,
681: B.verification_source_name,
682: B.verification_instruction
683: from AMW_CONTROLS_TL B, FND_LANGUAGES L
684: where L.INSTALLED_FLAG in ('I', 'B')
685: and B.LANGUAGE = userenv('LANG')
686: and not exists
687: (select NULL

Line 688: from AMW_CONTROLS_TL T

684: where L.INSTALLED_FLAG in ('I', 'B')
685: and B.LANGUAGE = userenv('LANG')
686: and not exists
687: (select NULL
688: from AMW_CONTROLS_TL T
689: where T.CONTROL_REV_ID = B.CONTROL_REV_ID
690: and T.LANGUAGE = L.LANGUAGE_CODE);
691: end ADD_LANGUAGE;
692: