APPS.AMW_AP_STEPS_PKG dependencies on AMW_AP_STEPS_TL

Line 112: insert into AMW_AP_STEPS_TL (

108: X_TO_REV_NUM,
109: X_CSEQNUM
110: );
111:
112: insert into AMW_AP_STEPS_TL (
113: DESCRIPTION,
114: LAST_UPDATE_LOGIN,
115: SECURITY_GROUP_ID,
116: NAME,

Line 142: from AMW_AP_STEPS_TL T

138: from FND_LANGUAGES L
139: where L.INSTALLED_FLAG in ('I', 'B')
140: and not exists
141: (select NULL
142: from AMW_AP_STEPS_TL T
143: where T.AP_STEP_ID = X_AP_STEP_ID
144: and T.LANGUAGE = L.LANGUAGE_CODE);
145:
146: open c;

Line 223: from AMW_AP_STEPS_TL

219: cursor c1 is select
220: NAME,
221: DESCRIPTION,
222: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
223: from AMW_AP_STEPS_TL
224: where AP_STEP_ID = X_AP_STEP_ID
225: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
226: for update of AP_STEP_ID nowait;
227: begin

Line 379: update AMW_AP_STEPS_TL set

375: if (sql%notfound) then
376: raise no_data_found;
377: end if;
378:
379: update AMW_AP_STEPS_TL set
380: NAME = X_NAME,
381: DESCRIPTION = X_DESCRIPTION,
382: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
383: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 399: delete from AMW_AP_STEPS_TL

395: procedure DELETE_ROW (
396: X_AP_STEP_ID in NUMBER
397: ) is
398: begin
399: delete from AMW_AP_STEPS_TL
400: where AP_STEP_ID = X_AP_STEP_ID;
401:
402: if (sql%notfound) then
403: raise no_data_found;

Line 417: delete from AMW_AP_STEPS_TL T

413:
414: procedure ADD_LANGUAGE
415: is
416: begin
417: delete from AMW_AP_STEPS_TL T
418: where not exists
419: (select NULL
420: from AMW_AP_STEPS_B B
421: where B.AP_STEP_ID = T.AP_STEP_ID

Line 424: update AMW_AP_STEPS_TL T set (

420: from AMW_AP_STEPS_B B
421: where B.AP_STEP_ID = T.AP_STEP_ID
422: );
423:
424: update AMW_AP_STEPS_TL T set (
425: NAME,
426: DESCRIPTION
427: ) = (select
428: B.NAME,

Line 430: from AMW_AP_STEPS_TL B

426: DESCRIPTION
427: ) = (select
428: B.NAME,
429: B.DESCRIPTION
430: from AMW_AP_STEPS_TL B
431: where B.AP_STEP_ID = T.AP_STEP_ID
432: and B.LANGUAGE = T.SOURCE_LANG)
433: where (
434: T.AP_STEP_ID,

Line 439: from AMW_AP_STEPS_TL SUBB, AMW_AP_STEPS_TL SUBT

435: T.LANGUAGE
436: ) in (select
437: SUBT.AP_STEP_ID,
438: SUBT.LANGUAGE
439: from AMW_AP_STEPS_TL SUBB, AMW_AP_STEPS_TL SUBT
440: where SUBB.AP_STEP_ID = SUBT.AP_STEP_ID
441: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
442: and (SUBB.NAME <> SUBT.NAME
443: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 448: insert into AMW_AP_STEPS_TL (

444: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
445: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
446: ));
447:
448: insert into AMW_AP_STEPS_TL (
449: DESCRIPTION,
450: LAST_UPDATE_LOGIN,
451: SECURITY_GROUP_ID,
452: NAME,

Line 474: from AMW_AP_STEPS_TL B, FND_LANGUAGES L

470: B.LAST_UPDATE_DATE,
471: L.LANGUAGE_CODE,
472: B.SOURCE_LANG,
473: B.SOURCE_LANG
474: from AMW_AP_STEPS_TL B, FND_LANGUAGES L
475: where L.INSTALLED_FLAG in ('I', 'B')
476: and B.LANGUAGE = userenv('LANG')
477: and not exists
478: (select NULL

Line 479: from AMW_AP_STEPS_TL T

475: where L.INSTALLED_FLAG in ('I', 'B')
476: and B.LANGUAGE = userenv('LANG')
477: and not exists
478: (select NULL
479: from AMW_AP_STEPS_TL T
480: where T.AP_STEP_ID = B.AP_STEP_ID
481: and T.LANGUAGE = L.LANGUAGE_CODE);
482: end ADD_LANGUAGE;
483: