APPS.PA_GANTT_VIEWS_PKG dependencies on PA_GANTT_VIEWS_B

Line 49: cursor C(c_gantt_view_id pa_gantt_views_b.gantt_view_id%TYPE) is

45: ,X_LAST_UPDATE_LOGIN in NUMBER
46: )
47: is
48:
49: cursor C(c_gantt_view_id pa_gantt_views_b.gantt_view_id%TYPE) is
50: select ROWID
51: from PA_GANTT_VIEWS_B
52: where GANTT_VIEW_ID = c_gantt_view_id;
53:

Line 51: from PA_GANTT_VIEWS_B

47: is
48:
49: cursor C(c_gantt_view_id pa_gantt_views_b.gantt_view_id%TYPE) is
50: select ROWID
51: from PA_GANTT_VIEWS_B
52: where GANTT_VIEW_ID = c_gantt_view_id;
53:
54: l_gantt_view_id PA_GANTT_VIEWS_B.gantt_view_id%TYPE;
55:

Line 54: l_gantt_view_id PA_GANTT_VIEWS_B.gantt_view_id%TYPE;

50: select ROWID
51: from PA_GANTT_VIEWS_B
52: where GANTT_VIEW_ID = c_gantt_view_id;
53:
54: l_gantt_view_id PA_GANTT_VIEWS_B.gantt_view_id%TYPE;
55:
56: BEGIN
57:
58: select nvl(X_GANTT_VIEW_ID,PA_GANTT_VIEWS_B_S.nextval)

Line 58: select nvl(X_GANTT_VIEW_ID,PA_GANTT_VIEWS_B_S.nextval)

54: l_gantt_view_id PA_GANTT_VIEWS_B.gantt_view_id%TYPE;
55:
56: BEGIN
57:
58: select nvl(X_GANTT_VIEW_ID,PA_GANTT_VIEWS_B_S.nextval)
59: into l_gantt_view_id
60: from dual;
61:
62: insert into PA_GANTT_VIEWS_B (

Line 62: insert into PA_GANTT_VIEWS_B (

58: select nvl(X_GANTT_VIEW_ID,PA_GANTT_VIEWS_B_S.nextval)
59: into l_gantt_view_id
60: from dual;
61:
62: insert into PA_GANTT_VIEWS_B (
63: GANTT_VIEW_ID,
64: GANTT_VIEW_USAGE,
65: ENABLE_FLAG,
66: SHOW_SUMMARY_ROOT_FLAG,

Line 255: from PA_GANTT_VIEWS_B

251: ATTRIBUTE12,
252: ATTRIBUTE13,
253: ATTRIBUTE14,
254: ATTRIBUTE15
255: from PA_GANTT_VIEWS_B
256: where GANTT_VIEW_ID = X_GANTT_VIEW_ID
257: for update of GANTT_VIEW_ID nowait;
258: recinfo c%rowtype;
259:

Line 397: update PA_GANTT_VIEWS_B set

393: X_LAST_UPDATE_LOGIN in NUMBER
394: )
395: is
396: begin
397: update PA_GANTT_VIEWS_B set
398: GANTT_VIEW_USAGE = X_GANTT_VIEW_USAGE,
399: ENABLE_FLAG = X_ENABLE_FLAG,
400: SHOW_SUMMARY_ROOT_FLAG = X_SHOW_SUMMARY_ROOT_FLAG,
401: SHOW_DEPENDENCIES_FLAG = X_SHOW_DEPENDENCIES_FLAG,

Line 466: delete from PA_GANTT_VIEWS_B

462: if (sql%notfound) then
463: raise no_data_found;
464: end if;
465:
466: delete from PA_GANTT_VIEWS_B
467: where GANTT_VIEW_ID = X_GANTT_VIEW_ID;
468:
469: if (sql%notfound) then
470: raise no_data_found;

Line 480: from PA_GANTT_VIEWS_B B

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
482: );
483:
484: update PA_GANTT_VIEWS_TL T set (