APPS.PA_GANTT_BAR_STYLES_PKG dependencies on PA_GANTT_BAR_STYLES_B

Line 45: cursor C(c_bar_style_id pa_gantt_bar_styles_b.gantt_bar_style_id%TYPE) is

41: X_LAST_UPDATE_LOGIN in NUMBER
42: )
43: is
44:
45: cursor C(c_bar_style_id pa_gantt_bar_styles_b.gantt_bar_style_id%TYPE) is
46: select ROWID
47: from PA_GANTT_BAR_STYLES_B
48: where GANTT_BAR_STYLE_ID = c_bar_style_id;
49:

Line 47: from PA_GANTT_BAR_STYLES_B

43: is
44:
45: cursor C(c_bar_style_id pa_gantt_bar_styles_b.gantt_bar_style_id%TYPE) is
46: select ROWID
47: from PA_GANTT_BAR_STYLES_B
48: where GANTT_BAR_STYLE_ID = c_bar_style_id;
49:
50: l_gantt_bar_style_id PA_GANTT_BAR_STYLES_B.GANTT_BAR_STYLE_ID%TYPE;
51: begin

Line 50: l_gantt_bar_style_id PA_GANTT_BAR_STYLES_B.GANTT_BAR_STYLE_ID%TYPE;

46: select ROWID
47: from PA_GANTT_BAR_STYLES_B
48: where GANTT_BAR_STYLE_ID = c_bar_style_id;
49:
50: l_gantt_bar_style_id PA_GANTT_BAR_STYLES_B.GANTT_BAR_STYLE_ID%TYPE;
51: begin
52:
53: select nvl(X_GANTT_BAR_STYLE_ID,PA_GANTT_BAR_STYLES_B_S.nextval)
54: into l_gantt_bar_style_id

Line 53: select nvl(X_GANTT_BAR_STYLE_ID,PA_GANTT_BAR_STYLES_B_S.nextval)

49:
50: l_gantt_bar_style_id PA_GANTT_BAR_STYLES_B.GANTT_BAR_STYLE_ID%TYPE;
51: begin
52:
53: select nvl(X_GANTT_BAR_STYLE_ID,PA_GANTT_BAR_STYLES_B_S.nextval)
54: into l_gantt_bar_style_id
55: from dual;
56:
57: insert into PA_GANTT_BAR_STYLES_B (

Line 57: insert into PA_GANTT_BAR_STYLES_B (

53: select nvl(X_GANTT_BAR_STYLE_ID,PA_GANTT_BAR_STYLES_B_S.nextval)
54: into l_gantt_bar_style_id
55: from dual;
56:
57: insert into PA_GANTT_BAR_STYLES_B (
58: GANTT_BAR_STYLE_ID,
59: GANTT_VIEW_ID,
60: DISPLAY_SEQUENCE,
61: START_FROM,

Line 234: from PA_GANTT_BAR_STYLES_B

230: ATTRIBUTE12,
231: ATTRIBUTE13,
232: ATTRIBUTE14,
233: ATTRIBUTE15
234: from PA_GANTT_BAR_STYLES_B
235: where GANTT_BAR_STYLE_ID = X_GANTT_BAR_STYLE_ID
236: for update of GANTT_BAR_STYLE_ID nowait;
237: recinfo c%rowtype;
238:

Line 366: update PA_GANTT_BAR_STYLES_B set

362: X_LAST_UPDATE_LOGIN in NUMBER
363: )
364: is
365: begin
366: update PA_GANTT_BAR_STYLES_B set
367: GANTT_VIEW_ID = X_GANTT_VIEW_ID,
368: DISPLAY_SEQUENCE = X_DISPLAY_SEQUENCE,
369: START_FROM = X_START_FROM,
370: END_TO = X_END_TO,

Line 430: delete from PA_GANTT_BAR_STYLES_B

426: if (sql%notfound) then
427: raise no_data_found;
428: end if;
429:
430: delete from PA_GANTT_BAR_STYLES_B
431: where GANTT_BAR_STYLE_ID = X_GANTT_BAR_STYLE_ID;
432:
433: if (sql%notfound) then
434: raise no_data_found;

Line 444: from PA_GANTT_BAR_STYLES_B B

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
446: );
447:
448: update PA_GANTT_BAR_STYLES_TL T set (