APPS.PA_GANTT_CONFIG_PKG dependencies on PA_GANTT_CONFIG_B

Line 43: cursor C(c_gantt_config_id PA_GANTT_CONFIG_B.gantt_config_id%TYPE) is

39: X_LAST_UPDATE_LOGIN in NUMBER
40: )
41: is
42:
43: cursor C(c_gantt_config_id PA_GANTT_CONFIG_B.gantt_config_id%TYPE) is
44: select ROWID
45: from PA_GANTT_CONFIG_B
46: where GANTT_CONFIG_ID = c_gantt_config_id;
47:

Line 45: from PA_GANTT_CONFIG_B

41: is
42:
43: cursor C(c_gantt_config_id PA_GANTT_CONFIG_B.gantt_config_id%TYPE) is
44: select ROWID
45: from PA_GANTT_CONFIG_B
46: where GANTT_CONFIG_ID = c_gantt_config_id;
47:
48: l_gantt_config_id PA_GANTT_CONFIG_B.gantt_config_id%TYPE;
49:

Line 48: l_gantt_config_id PA_GANTT_CONFIG_B.gantt_config_id%TYPE;

44: select ROWID
45: from PA_GANTT_CONFIG_B
46: where GANTT_CONFIG_ID = c_gantt_config_id;
47:
48: l_gantt_config_id PA_GANTT_CONFIG_B.gantt_config_id%TYPE;
49:
50: begin
51:
52: select nvl(X_GANTT_CONFIG_ID,PA_GANTT_CONFIG_B_S.nextval)

Line 52: select nvl(X_GANTT_CONFIG_ID,PA_GANTT_CONFIG_B_S.nextval)

48: l_gantt_config_id PA_GANTT_CONFIG_B.gantt_config_id%TYPE;
49:
50: begin
51:
52: select nvl(X_GANTT_CONFIG_ID,PA_GANTT_CONFIG_B_S.nextval)
53: into l_gantt_config_id
54: from dual;
55:
56: insert into PA_GANTT_CONFIG_B (

Line 56: insert into PA_GANTT_CONFIG_B (

52: select nvl(X_GANTT_CONFIG_ID,PA_GANTT_CONFIG_B_S.nextval)
53: into l_gantt_config_id
54: from dual;
55:
56: insert into PA_GANTT_CONFIG_B (
57: GANTT_CONFIG_ID,
58: GANTT_VIEW_ID,
59: GANTT_CONFIG_USAGE,
60: FILTER_CODE,

Line 222: from PA_GANTT_CONFIG_B

218: ATTRIBUTE12,
219: ATTRIBUTE13,
220: ATTRIBUTE14,
221: ATTRIBUTE15
222: from PA_GANTT_CONFIG_B
223: where GANTT_CONFIG_ID = X_GANTT_CONFIG_ID
224: for update of GANTT_CONFIG_ID nowait;
225: recinfo c%rowtype;
226:

Line 345: update PA_GANTT_CONFIG_B set

341: X_LAST_UPDATED_BY in NUMBER,
342: X_LAST_UPDATE_LOGIN in NUMBER
343: ) is
344: begin
345: update PA_GANTT_CONFIG_B set
346: GANTT_VIEW_ID = X_GANTT_VIEW_ID,
347: GANTT_CONFIG_USAGE = X_GANTT_CONFIG_USAGE,
348: FILTER_CODE = X_FILTER_CODE,
349: TIME_SCALE_CODE = X_TIME_SCALE_CODE,

Line 408: delete from PA_GANTT_CONFIG_B

404: if (sql%notfound) then
405: raise no_data_found;
406: end if;
407:
408: delete from PA_GANTT_CONFIG_B
409: where GANTT_CONFIG_ID = X_GANTT_CONFIG_ID;
410:
411: if (sql%notfound) then
412: raise no_data_found;

Line 423: from PA_GANTT_CONFIG_B B

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
425: );
426:
427: update PA_GANTT_CONFIG_TL T set (