APPS.PA_GANTT_VIEWS_PKG dependencies on PA_GANTT_VIEWS_TL

Line 143: insert into PA_GANTT_VIEWS_TL (

139: X_LAST_UPDATED_BY,
140: X_LAST_UPDATE_LOGIN
141: );
142:
143: insert into PA_GANTT_VIEWS_TL (
144: GANTT_VIEW_ID,
145: NAME,
146: DESCRIPTION,
147: LAST_UPDATE_DATE,

Line 169: from PA_GANTT_VIEWS_TL T

165: from FND_LANGUAGES L
166: where L.INSTALLED_FLAG in ('I', 'B')
167: and not exists
168: (select NULL
169: from PA_GANTT_VIEWS_TL T
170: where T.GANTT_VIEW_ID = l_gantt_view_id
171: and T.LANGUAGE = L.LANGUAGE_CODE
172: );
173:

Line 264: from PA_GANTT_VIEWS_TL

260: cursor c1 is select
261: NAME,
262: DESCRIPTION,
263: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
264: from PA_GANTT_VIEWS_TL
265: where GANTT_VIEW_ID = X_GANTT_VIEW_ID
266: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
267: for update of GANTT_VIEW_ID nowait;
268: begin

Line 439: update PA_GANTT_VIEWS_TL set

435: if (sql%notfound) then
436: raise no_data_found;
437: end if;
438:
439: update PA_GANTT_VIEWS_TL set
440: NAME = X_NAME,
441: DESCRIPTION = X_DESCRIPTION,
442: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
443: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 459: delete from PA_GANTT_VIEWS_TL

455: X_GANTT_VIEW_ID in NUMBER
456: )
457: is
458: begin
459: delete from PA_GANTT_VIEWS_TL
460: where GANTT_VIEW_ID = X_GANTT_VIEW_ID;
461:
462: if (sql%notfound) then
463: raise no_data_found;

Line 477: delete from PA_GANTT_VIEWS_TL T

473:
474: procedure ADD_LANGUAGE
475: is
476: begin
477: delete from PA_GANTT_VIEWS_TL T
478: where not exists
479: (select NULL
480: from PA_GANTT_VIEWS_B B
481: where B.GANTT_VIEW_ID = T.GANTT_VIEW_ID

Line 484: update PA_GANTT_VIEWS_TL T set (

480: from PA_GANTT_VIEWS_B B
481: where B.GANTT_VIEW_ID = T.GANTT_VIEW_ID
482: );
483:
484: update PA_GANTT_VIEWS_TL T set (
485: NAME,
486: DESCRIPTION
487: ) = (select
488: B.NAME,

Line 490: from PA_GANTT_VIEWS_TL B

486: DESCRIPTION
487: ) = (select
488: B.NAME,
489: B.DESCRIPTION
490: from PA_GANTT_VIEWS_TL B
491: where B.GANTT_VIEW_ID = T.GANTT_VIEW_ID
492: and B.LANGUAGE = T.SOURCE_LANG)
493: where (
494: T.GANTT_VIEW_ID,

Line 499: from PA_GANTT_VIEWS_TL SUBB, PA_GANTT_VIEWS_TL SUBT

495: T.LANGUAGE
496: ) in (select
497: SUBT.GANTT_VIEW_ID,
498: SUBT.LANGUAGE
499: from PA_GANTT_VIEWS_TL SUBB, PA_GANTT_VIEWS_TL SUBT
500: where SUBB.GANTT_VIEW_ID = SUBT.GANTT_VIEW_ID
501: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
502: and (SUBB.NAME <> SUBT.NAME
503: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 508: insert into PA_GANTT_VIEWS_TL (

504: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
505: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
506: ));
507:
508: insert into PA_GANTT_VIEWS_TL (
509: GANTT_VIEW_ID,
510: NAME,
511: DESCRIPTION,
512: LAST_UPDATE_DATE,

Line 530: from PA_GANTT_VIEWS_TL B, FND_LANGUAGES L

526: B.CREATED_BY,
527: B.LAST_UPDATE_LOGIN,
528: L.LANGUAGE_CODE,
529: B.SOURCE_LANG
530: from PA_GANTT_VIEWS_TL B, FND_LANGUAGES L
531: where L.INSTALLED_FLAG in ('I', 'B')
532: and B.LANGUAGE = userenv('LANG')
533: and not exists
534: (select NULL

Line 535: from PA_GANTT_VIEWS_TL T

531: where L.INSTALLED_FLAG in ('I', 'B')
532: and B.LANGUAGE = userenv('LANG')
533: and not exists
534: (select NULL
535: from PA_GANTT_VIEWS_TL T
536: where T.GANTT_VIEW_ID = B.GANTT_VIEW_ID
537: and T.LANGUAGE = L.LANGUAGE_CODE);
538: end ADD_LANGUAGE;
539:

Line 555: update PA_GANTT_VIEWS_TL

551: else
552: l_user_id := 0;
553: end if;
554:
555: update PA_GANTT_VIEWS_TL
556: set
557: LAST_UPDATE_DATE = SYSDATE,
558: LAST_UPDATED_BY = l_user_id,
559: LAST_UPDATE_LOGIN = 0,