APPS.AMW_AUDIT_PROCEDURES_PKG dependencies on AMW_AUDIT_PROCEDURES_TL

Line 121: insert into AMW_AUDIT_PROCEDURES_TL (

117: X_LAST_UPDATE_LOGIN,
118: X_CLASSIFICATION
119: );
120:
121: insert into AMW_AUDIT_PROCEDURES_TL (
122: AUDIT_PROCEDURE_REV_ID,
123: NAME,
124: DESCRIPTION,
125: LAST_UPDATE_DATE,

Line 149: from AMW_AUDIT_PROCEDURES_TL T

145: from FND_LANGUAGES L
146: where L.INSTALLED_FLAG in ('I', 'B')
147: and not exists
148: (select NULL
149: from AMW_AUDIT_PROCEDURES_TL T
150: where T.AUDIT_PROCEDURE_REV_ID = X_AUDIT_PROCEDURE_REV_ID
151: and T.LANGUAGE = L.LANGUAGE_CODE);
152:
153: open c;

Line 236: from AMW_AUDIT_PROCEDURES_TL

232: cursor c1 is select
233: NAME,
234: DESCRIPTION,
235: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
236: from AMW_AUDIT_PROCEDURES_TL
237: where AUDIT_PROCEDURE_REV_ID = X_AUDIT_PROCEDURE_REV_ID
238: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
239: for update of AUDIT_PROCEDURE_REV_ID nowait;
240: begin

Line 403: update AMW_AUDIT_PROCEDURES_TL set

399: if (sql%notfound) then
400: raise no_data_found;
401: end if;
402:
403: update AMW_AUDIT_PROCEDURES_TL set
404: NAME = X_NAME,
405: DESCRIPTION = X_DESCRIPTION,
406: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
407: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 422: delete from AMW_AUDIT_PROCEDURES_TL

418: procedure DELETE_ROW (
419: X_AUDIT_PROCEDURE_REV_ID in NUMBER
420: ) is
421: begin
422: delete from AMW_AUDIT_PROCEDURES_TL
423: where AUDIT_PROCEDURE_REV_ID = X_AUDIT_PROCEDURE_REV_ID;
424:
425: if (sql%notfound) then
426: raise no_data_found;

Line 440: delete from AMW_AUDIT_PROCEDURES_TL T

436:
437: procedure ADD_LANGUAGE
438: is
439: begin
440: delete from AMW_AUDIT_PROCEDURES_TL T
441: where not exists
442: (select NULL
443: from AMW_AUDIT_PROCEDURES_B B
444: where B.AUDIT_PROCEDURE_REV_ID = T.AUDIT_PROCEDURE_REV_ID

Line 447: update AMW_AUDIT_PROCEDURES_TL T set (

443: from AMW_AUDIT_PROCEDURES_B B
444: where B.AUDIT_PROCEDURE_REV_ID = T.AUDIT_PROCEDURE_REV_ID
445: );
446:
447: update AMW_AUDIT_PROCEDURES_TL T set (
448: NAME,
449: DESCRIPTION
450: ) = (select
451: B.NAME,

Line 453: from AMW_AUDIT_PROCEDURES_TL B

449: DESCRIPTION
450: ) = (select
451: B.NAME,
452: B.DESCRIPTION
453: from AMW_AUDIT_PROCEDURES_TL B
454: where B.AUDIT_PROCEDURE_REV_ID = T.AUDIT_PROCEDURE_REV_ID
455: and B.LANGUAGE = T.SOURCE_LANG)
456: where (
457: T.AUDIT_PROCEDURE_REV_ID,

Line 462: from AMW_AUDIT_PROCEDURES_TL SUBB, AMW_AUDIT_PROCEDURES_TL SUBT

458: T.LANGUAGE
459: ) in (select
460: SUBT.AUDIT_PROCEDURE_REV_ID,
461: SUBT.LANGUAGE
462: from AMW_AUDIT_PROCEDURES_TL SUBB, AMW_AUDIT_PROCEDURES_TL SUBT
463: where SUBB.AUDIT_PROCEDURE_REV_ID = SUBT.AUDIT_PROCEDURE_REV_ID
464: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
465: and (SUBB.NAME <> SUBT.NAME
466: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 471: insert into AMW_AUDIT_PROCEDURES_TL (

467: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
468: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
469: ));
470:
471: insert into AMW_AUDIT_PROCEDURES_TL (
472: AUDIT_PROCEDURE_REV_ID,
473: NAME,
474: DESCRIPTION,
475: LAST_UPDATE_DATE,

Line 495: from AMW_AUDIT_PROCEDURES_TL B, FND_LANGUAGES L

491: B.LAST_UPDATE_LOGIN,
492: B.SECURITY_GROUP_ID,
493: L.LANGUAGE_CODE,
494: B.SOURCE_LANG
495: from AMW_AUDIT_PROCEDURES_TL B, FND_LANGUAGES L
496: where L.INSTALLED_FLAG in ('I', 'B')
497: and B.LANGUAGE = userenv('LANG')
498: and not exists
499: (select NULL

Line 500: from AMW_AUDIT_PROCEDURES_TL T

496: where L.INSTALLED_FLAG in ('I', 'B')
497: and B.LANGUAGE = userenv('LANG')
498: and not exists
499: (select NULL
500: from AMW_AUDIT_PROCEDURES_TL T
501: where T.AUDIT_PROCEDURE_REV_ID = B.AUDIT_PROCEDURE_REV_ID
502: and T.LANGUAGE = L.LANGUAGE_CODE);
503: end ADD_LANGUAGE;
504: