APPS.PA_GANTT_BAR_STYLES_PKG dependencies on PA_GANTT_BAR_STYLES_TL

Line 132: insert into PA_GANTT_BAR_STYLES_TL (

128: X_LAST_UPDATED_BY,
129: X_LAST_UPDATE_LOGIN
130: );
131:
132: insert into PA_GANTT_BAR_STYLES_TL (
133: GANTT_BAR_STYLE_ID,
134: NAME,
135: CREATION_DATE,
136: CREATED_BY,

Line 156: from PA_GANTT_BAR_STYLES_TL T

152: from FND_LANGUAGES L
153: where L.INSTALLED_FLAG in ('I', 'B')
154: and not exists
155: (select NULL
156: from PA_GANTT_BAR_STYLES_TL T
157: where T.GANTT_BAR_STYLE_ID = l_gantt_bar_style_id
158: and T.LANGUAGE = L.LANGUAGE_CODE);
159:
160: open c(l_gantt_bar_style_id);

Line 242: from PA_GANTT_BAR_STYLES_TL

238:
239: cursor c1 is select
240: NAME,
241: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
242: from PA_GANTT_BAR_STYLES_TL
243: where GANTT_BAR_STYLE_ID = X_GANTT_BAR_STYLE_ID
244: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
245: for update of GANTT_BAR_STYLE_ID nowait;
246: begin

Line 405: update PA_GANTT_BAR_STYLES_TL set

401: if (sql%notfound) then
402: raise no_data_found;
403: end if;
404:
405: update PA_GANTT_BAR_STYLES_TL set
406: NAME = X_NAME,
407: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
408: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
409: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 423: delete from PA_GANTT_BAR_STYLES_TL

419: procedure DELETE_ROW (
420: X_GANTT_BAR_STYLE_ID in NUMBER
421: ) is
422: begin
423: delete from PA_GANTT_BAR_STYLES_TL
424: where GANTT_BAR_STYLE_ID = X_GANTT_BAR_STYLE_ID;
425:
426: if (sql%notfound) then
427: raise no_data_found;

Line 441: delete from PA_GANTT_BAR_STYLES_TL T

437:
438: procedure ADD_LANGUAGE
439: is
440: begin
441: delete from PA_GANTT_BAR_STYLES_TL T
442: where not exists
443: (select NULL
444: from PA_GANTT_BAR_STYLES_B B
445: where B.GANTT_BAR_STYLE_ID = T.GANTT_BAR_STYLE_ID

Line 448: update PA_GANTT_BAR_STYLES_TL T set (

444: from PA_GANTT_BAR_STYLES_B B
445: where B.GANTT_BAR_STYLE_ID = T.GANTT_BAR_STYLE_ID
446: );
447:
448: update PA_GANTT_BAR_STYLES_TL T set (
449: NAME
450: ) = (select
451: B.NAME
452: from PA_GANTT_BAR_STYLES_TL B

Line 452: from PA_GANTT_BAR_STYLES_TL B

448: update PA_GANTT_BAR_STYLES_TL T set (
449: NAME
450: ) = (select
451: B.NAME
452: from PA_GANTT_BAR_STYLES_TL B
453: where B.GANTT_BAR_STYLE_ID = T.GANTT_BAR_STYLE_ID
454: and B.LANGUAGE = T.SOURCE_LANG)
455: where (
456: T.GANTT_BAR_STYLE_ID,

Line 461: from PA_GANTT_BAR_STYLES_TL SUBB, PA_GANTT_BAR_STYLES_TL SUBT

457: T.LANGUAGE
458: ) in (select
459: SUBT.GANTT_BAR_STYLE_ID,
460: SUBT.LANGUAGE
461: from PA_GANTT_BAR_STYLES_TL SUBB, PA_GANTT_BAR_STYLES_TL SUBT
462: where SUBB.GANTT_BAR_STYLE_ID = SUBT.GANTT_BAR_STYLE_ID
463: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
464: and (SUBB.NAME <> SUBT.NAME
465: ));

Line 467: insert into PA_GANTT_BAR_STYLES_TL (

463: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
464: and (SUBB.NAME <> SUBT.NAME
465: ));
466:
467: insert into PA_GANTT_BAR_STYLES_TL (
468: GANTT_BAR_STYLE_ID,
469: NAME,
470: CREATION_DATE,
471: CREATED_BY,

Line 487: from PA_GANTT_BAR_STYLES_TL B, FND_LANGUAGES L

483: B.LAST_UPDATED_BY,
484: B.LAST_UPDATE_LOGIN,
485: L.LANGUAGE_CODE,
486: B.SOURCE_LANG
487: from PA_GANTT_BAR_STYLES_TL B, FND_LANGUAGES L
488: where L.INSTALLED_FLAG in ('I', 'B')
489: and B.LANGUAGE = userenv('LANG')
490: and not exists
491: (select NULL

Line 492: from PA_GANTT_BAR_STYLES_TL T

488: where L.INSTALLED_FLAG in ('I', 'B')
489: and B.LANGUAGE = userenv('LANG')
490: and not exists
491: (select NULL
492: from PA_GANTT_BAR_STYLES_TL T
493: where T.GANTT_BAR_STYLE_ID = B.GANTT_BAR_STYLE_ID
494: and T.LANGUAGE = L.LANGUAGE_CODE);
495: end ADD_LANGUAGE;
496:

Line 511: update PA_GANTT_BAR_STYLES_TL

507: else
508: l_user_id := 0;
509: end if;
510:
511: update PA_GANTT_BAR_STYLES_TL
512: set
513: LAST_UPDATE_DATE = SYSDATE,
514: LAST_UPDATED_BY = l_user_id,
515: LAST_UPDATE_LOGIN = 0,