APPS.AMW_CONSTRAINTS_PKG dependencies on AMW_CONSTRAINTS_TL

Line 22: -- in AMW_CONSTRAINTS_B and AMW_CONSTRAINTS_TL

18: -- Procedure name
19: -- INSERT_ROW
20: -- Purpose
21: -- create new constraint
22: -- in AMW_CONSTRAINTS_B and AMW_CONSTRAINTS_TL
23: -- ===============================================================
24: procedure INSERT_ROW (
25: X_ROWID in out nocopy VARCHAR2,
26: X_CONSTRAINT_ID in NUMBER,

Line 140: insert into AMW_CONSTRAINTS_TL (

136: X_OBJECTIVE_CODE,
137: X_CONTROL_ID
138: );
139:
140: insert into AMW_CONSTRAINTS_TL (
141: LAST_UPDATE_LOGIN,
142: CONSTRAINT_ID,
143: NAME,
144: DESCRIPTION,

Line 168: from AMW_CONSTRAINTS_TL T

164: from FND_LANGUAGES L
165: where L.INSTALLED_FLAG in ('I', 'B')
166: and not exists
167: (select NULL
168: from AMW_CONSTRAINTS_TL T
169: where T.CONSTRAINT_ID = X_CONSTRAINT_ID
170: and T.LANGUAGE = L.LANGUAGE_CODE);
171:
172: open c;

Line 260: from AMW_CONSTRAINTS_TL

256: cursor c1 is select
257: NAME,
258: DESCRIPTION,
259: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
260: from AMW_CONSTRAINTS_TL
261: where CONSTRAINT_ID = X_CONSTRAINT_ID
262: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
263: for update of CONSTRAINT_ID nowait;
264: begin

Line 357: -- update AMW_CONSTRAINTS_B and AMW_CONSTRAINTS_TL

353: -- ===============================================================
354: -- Procedure name
355: -- UPDATE_ROW
356: -- Purpose
357: -- update AMW_CONSTRAINTS_B and AMW_CONSTRAINTS_TL
358: -- ===============================================================
359: procedure UPDATE_ROW (
360: X_CONSTRAINT_ID in NUMBER,
361: X_CONSTRAINT_REV_ID in NUMBER,

Line 433: update AMW_CONSTRAINTS_TL set

429: if (sql%notfound) then
430: raise no_data_found;
431: end if;
432:
433: update AMW_CONSTRAINTS_TL set
434: NAME = X_CONSTRAINT_NAME,
435: DESCRIPTION = X_CONSTRAINT_DESCRIPTION,
436: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
437: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 460: delete from AMW_CONSTRAINTS_TL

456: procedure DELETE_ROW (
457: X_CONSTRAINT_ID in NUMBER
458: ) is
459: begin
460: delete from AMW_CONSTRAINTS_TL
461: where CONSTRAINT_ID = X_CONSTRAINT_ID;
462:
463: if (sql%notfound) then
464: raise no_data_found;

Line 486: delete from AMW_CONSTRAINTS_TL T

482: -- ===============================================================
483: procedure ADD_LANGUAGE
484: is
485: begin
486: delete from AMW_CONSTRAINTS_TL T
487: where not exists
488: (select NULL
489: from AMW_CONSTRAINTS_B B
490: where B.CONSTRAINT_ID = T.CONSTRAINT_ID

Line 493: update AMW_CONSTRAINTS_TL T set (

489: from AMW_CONSTRAINTS_B B
490: where B.CONSTRAINT_ID = T.CONSTRAINT_ID
491: );
492:
493: update AMW_CONSTRAINTS_TL T set (
494: NAME,
495: DESCRIPTION
496: ) = (select
497: B.NAME,

Line 499: from AMW_CONSTRAINTS_TL B

495: DESCRIPTION
496: ) = (select
497: B.NAME,
498: B.DESCRIPTION
499: from AMW_CONSTRAINTS_TL B
500: where B.CONSTRAINT_ID = T.CONSTRAINT_ID
501: and B.LANGUAGE = T.SOURCE_LANG)
502: where (
503: T.CONSTRAINT_ID,

Line 508: from AMW_CONSTRAINTS_TL SUBB, AMW_CONSTRAINTS_TL SUBT

504: T.LANGUAGE
505: ) in (select
506: SUBT.CONSTRAINT_ID,
507: SUBT.LANGUAGE
508: from AMW_CONSTRAINTS_TL SUBB, AMW_CONSTRAINTS_TL SUBT
509: where SUBB.CONSTRAINT_ID = SUBT.CONSTRAINT_ID
510: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
511: and (SUBB.NAME <> SUBT.NAME
512: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 517: insert into AMW_CONSTRAINTS_TL (

513: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
514: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
515: ));
516:
517: insert into AMW_CONSTRAINTS_TL (
518: LAST_UPDATE_LOGIN,
519: CONSTRAINT_ID,
520: NAME,
521: DESCRIPTION,

Line 541: from AMW_CONSTRAINTS_TL B, FND_LANGUAGES L

537: B.CREATED_BY,
538: B.SECURITY_GROUP_ID,
539: L.LANGUAGE_CODE,
540: B.SOURCE_LANG
541: from AMW_CONSTRAINTS_TL B, FND_LANGUAGES L
542: where L.INSTALLED_FLAG in ('I', 'B')
543: and B.LANGUAGE = userenv('LANG')
544: and not exists
545: (select NULL

Line 546: from AMW_CONSTRAINTS_TL T

542: where L.INSTALLED_FLAG in ('I', 'B')
543: and B.LANGUAGE = userenv('LANG')
544: and not exists
545: (select NULL
546: from AMW_CONSTRAINTS_TL T
547: where T.CONSTRAINT_ID = B.CONSTRAINT_ID
548: and T.LANGUAGE = L.LANGUAGE_CODE);
549: end ADD_LANGUAGE;
550: