APPS.PA_GANTT_CONFIG_PKG dependencies on PA_GANTT_CONFIG_TL

Line 124: insert into PA_GANTT_CONFIG_TL (

120: X_LAST_UPDATED_BY,
121: X_LAST_UPDATE_LOGIN
122: );
123:
124: insert into PA_GANTT_CONFIG_TL (
125: GANTT_CONFIG_ID,
126: NAME,
127: DESCRIPTION,
128: LAST_UPDATE_DATE,

Line 150: from PA_GANTT_CONFIG_TL T

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

Line 231: from PA_GANTT_CONFIG_TL

227: cursor c1 is select
228: NAME,
229: DESCRIPTION,
230: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
231: from PA_GANTT_CONFIG_TL
232: where GANTT_CONFIG_ID = X_GANTT_CONFIG_ID
233: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
234: for update of GANTT_CONFIG_ID nowait;
235: begin

Line 381: update PA_GANTT_CONFIG_TL set

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

Line 401: delete from PA_GANTT_CONFIG_TL

397: X_GANTT_CONFIG_ID in NUMBER
398: )
399: is
400: begin
401: delete from PA_GANTT_CONFIG_TL
402: where GANTT_CONFIG_ID = X_GANTT_CONFIG_ID;
403:
404: if (sql%notfound) then
405: raise no_data_found;

Line 420: delete from PA_GANTT_CONFIG_TL T

416:
417: procedure ADD_LANGUAGE
418: is
419: begin
420: delete from PA_GANTT_CONFIG_TL T
421: where not exists
422: (select NULL
423: from PA_GANTT_CONFIG_B B
424: where B.GANTT_CONFIG_ID = T.GANTT_CONFIG_ID

Line 427: update PA_GANTT_CONFIG_TL T set (

423: from PA_GANTT_CONFIG_B B
424: where B.GANTT_CONFIG_ID = T.GANTT_CONFIG_ID
425: );
426:
427: update PA_GANTT_CONFIG_TL T set (
428: NAME,
429: DESCRIPTION
430: ) = (select
431: B.NAME,

Line 433: from PA_GANTT_CONFIG_TL B

429: DESCRIPTION
430: ) = (select
431: B.NAME,
432: B.DESCRIPTION
433: from PA_GANTT_CONFIG_TL B
434: where B.GANTT_CONFIG_ID = T.GANTT_CONFIG_ID
435: and B.LANGUAGE = T.SOURCE_LANG)
436: where (
437: T.GANTT_CONFIG_ID,

Line 442: from PA_GANTT_CONFIG_TL SUBB, PA_GANTT_CONFIG_TL SUBT

438: T.LANGUAGE
439: ) in (select
440: SUBT.GANTT_CONFIG_ID,
441: SUBT.LANGUAGE
442: from PA_GANTT_CONFIG_TL SUBB, PA_GANTT_CONFIG_TL SUBT
443: where SUBB.GANTT_CONFIG_ID = SUBT.GANTT_CONFIG_ID
444: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
445: and (SUBB.NAME <> SUBT.NAME
446: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 451: insert into PA_GANTT_CONFIG_TL (

447: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
448: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
449: ));
450:
451: insert into PA_GANTT_CONFIG_TL (
452: GANTT_CONFIG_ID,
453: NAME,
454: DESCRIPTION,
455: LAST_UPDATE_DATE,

Line 473: from PA_GANTT_CONFIG_TL B, FND_LANGUAGES L

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

Line 478: from PA_GANTT_CONFIG_TL T

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

Line 498: update PA_GANTT_CONFIG_TL

494: else
495: l_user_id := 0;
496: end if;
497:
498: update PA_GANTT_CONFIG_TL
499: set
500: LAST_UPDATE_DATE = SYSDATE,
501: LAST_UPDATED_BY = l_user_id,
502: LAST_UPDATE_LOGIN = 0,