eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_GANTT_CONFIG_PVT dependencies on PA_GANTT_CONFIG_B

Line 11: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,

7:
8: procedure CREATE_GANTT_CONFIG (
9: P_COMMIT in VARCHAR2,
10: P_CALLING_MODULE in VARCHAR2,
11: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
12: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
13: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
14: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
15: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,

Line 12: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,

8: procedure CREATE_GANTT_CONFIG (
9: P_COMMIT in VARCHAR2,
10: P_CALLING_MODULE in VARCHAR2,
11: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
12: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
13: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
14: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
15: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
16: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,

Line 13: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,

9: P_COMMIT in VARCHAR2,
10: P_CALLING_MODULE in VARCHAR2,
11: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
12: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
13: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
14: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
15: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
16: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
17: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,

Line 14: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,

10: P_CALLING_MODULE in VARCHAR2,
11: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
12: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
13: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
14: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
15: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
16: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
17: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
18: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,

Line 15: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,

11: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
12: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
13: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
14: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
15: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
16: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
17: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
18: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
19: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,

Line 16: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,

12: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
13: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
14: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
15: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
16: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
17: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
18: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
19: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
20: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,

Line 17: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,

13: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
14: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
15: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
16: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
17: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
18: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
19: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
20: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
21: P_DESCRIPTION in PA_GANTT_CONFIG_TL.description%TYPE,

Line 18: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,

14: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
15: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
16: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
17: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
18: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
19: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
20: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
21: P_DESCRIPTION in PA_GANTT_CONFIG_TL.description%TYPE,
22: PX_GANTT_CONFIG_ID in OUT NOCOPY PA_GANTT_CONFIG_B.gantt_config_id%TYPE, --File.Sql.39 bug 4440895

Line 19: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,

15: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
16: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
17: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
18: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
19: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
20: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
21: P_DESCRIPTION in PA_GANTT_CONFIG_TL.description%TYPE,
22: PX_GANTT_CONFIG_ID in OUT NOCOPY PA_GANTT_CONFIG_B.gantt_config_id%TYPE, --File.Sql.39 bug 4440895
23: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 22: PX_GANTT_CONFIG_ID in OUT NOCOPY PA_GANTT_CONFIG_B.gantt_config_id%TYPE, --File.Sql.39 bug 4440895

18: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
19: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
20: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
21: P_DESCRIPTION in PA_GANTT_CONFIG_TL.description%TYPE,
22: PX_GANTT_CONFIG_ID in OUT NOCOPY PA_GANTT_CONFIG_B.gantt_config_id%TYPE, --File.Sql.39 bug 4440895
23: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
24: X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
25: X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
26: )

Line 160: P_GANTT_CONFIG_ID in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,

156:
157: procedure UPDATE_GANTT_CONFIG (
158: P_COMMIT in VARCHAR2 ,
159: P_CALLING_MODULE in VARCHAR2 ,
160: P_GANTT_CONFIG_ID in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,
161: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
162: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
163: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
164: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,

Line 161: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,

157: procedure UPDATE_GANTT_CONFIG (
158: P_COMMIT in VARCHAR2 ,
159: P_CALLING_MODULE in VARCHAR2 ,
160: P_GANTT_CONFIG_ID in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,
161: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
162: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
163: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
164: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
165: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,

Line 162: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,

158: P_COMMIT in VARCHAR2 ,
159: P_CALLING_MODULE in VARCHAR2 ,
160: P_GANTT_CONFIG_ID in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,
161: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
162: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
163: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
164: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
165: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
166: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,

Line 163: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,

159: P_CALLING_MODULE in VARCHAR2 ,
160: P_GANTT_CONFIG_ID in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,
161: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
162: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
163: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
164: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
165: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
166: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
167: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,

Line 164: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,

160: P_GANTT_CONFIG_ID in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,
161: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
162: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
163: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
164: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
165: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
166: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
167: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
168: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,

Line 165: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,

161: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
162: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
163: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
164: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
165: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
166: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
167: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
168: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
169: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,

Line 166: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,

162: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
163: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
164: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
165: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
166: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
167: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
168: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
169: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
170: P_RECORD_VERSION_NUMBER in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,

Line 167: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,

163: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
164: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
165: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
166: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
167: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
168: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
169: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
170: P_RECORD_VERSION_NUMBER in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,
171: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,

Line 168: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,

164: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
165: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
166: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
167: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
168: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
169: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
170: P_RECORD_VERSION_NUMBER in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,
171: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
172: P_DESCRIPTION in PA_GANTT_CONFIG_TL.description%TYPE,

Line 169: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,

165: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
166: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
167: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
168: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
169: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
170: P_RECORD_VERSION_NUMBER in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,
171: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
172: P_DESCRIPTION in PA_GANTT_CONFIG_TL.description%TYPE,
173: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 170: P_RECORD_VERSION_NUMBER in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,

166: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
167: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
168: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
169: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
170: P_RECORD_VERSION_NUMBER in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,
171: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
172: P_DESCRIPTION in PA_GANTT_CONFIG_TL.description%TYPE,
173: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
174: X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 190: CURSOR cur_gantt_config_rvn(c_gantt_config_id pa_gantt_config_b.gantt_config_id%TYPE)

186: l_debug_level3 CONSTANT NUMBER := 3;
187: l_debug_level4 CONSTANT NUMBER := 4;
188: l_debug_level5 CONSTANT NUMBER := 5;
189:
190: CURSOR cur_gantt_config_rvn(c_gantt_config_id pa_gantt_config_b.gantt_config_id%TYPE)
191: is
192: select record_version_number
193: from pa_gantt_config_b
194: where gantt_config_id = c_gantt_config_id;

Line 193: from pa_gantt_config_b

189:
190: CURSOR cur_gantt_config_rvn(c_gantt_config_id pa_gantt_config_b.gantt_config_id%TYPE)
191: is
192: select record_version_number
193: from pa_gantt_config_b
194: where gantt_config_id = c_gantt_config_id;
195:
196: l_gantt_config_rvn pa_gantt_config_b.record_version_number%TYPE;
197:

Line 196: l_gantt_config_rvn pa_gantt_config_b.record_version_number%TYPE;

192: select record_version_number
193: from pa_gantt_config_b
194: where gantt_config_id = c_gantt_config_id;
195:
196: l_gantt_config_rvn pa_gantt_config_b.record_version_number%TYPE;
197:
198: BEGIN
199: IF p_commit = 'Y' THEN
200: savepoint update_gantt_config;

Line 325: P_GANTT_CONFIG_ID in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,

321:
322: procedure DELETE_GANTT_CONFIG (
323: P_COMMIT in VARCHAR2 ,
324: P_CALLING_MODULE in VARCHAR2 ,
325: P_GANTT_CONFIG_ID in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,
326: P_RECORD_VERSION_NUMBER in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,
327: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
328: X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
329: X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 326: P_RECORD_VERSION_NUMBER in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,

322: procedure DELETE_GANTT_CONFIG (
323: P_COMMIT in VARCHAR2 ,
324: P_CALLING_MODULE in VARCHAR2 ,
325: P_GANTT_CONFIG_ID in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,
326: P_RECORD_VERSION_NUMBER in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,
327: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
328: X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
329: X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
330: )

Line 344: CURSOR cur_gantt_config_rvn(c_gantt_config_id pa_gantt_config_b.gantt_config_id%TYPE)

340: l_debug_level3 CONSTANT NUMBER := 3;
341: l_debug_level4 CONSTANT NUMBER := 4;
342: l_debug_level5 CONSTANT NUMBER := 5;
343:
344: CURSOR cur_gantt_config_rvn(c_gantt_config_id pa_gantt_config_b.gantt_config_id%TYPE)
345: is
346: select record_version_number
347: from pa_gantt_config_b
348: where gantt_config_id = c_gantt_config_id;

Line 347: from pa_gantt_config_b

343:
344: CURSOR cur_gantt_config_rvn(c_gantt_config_id pa_gantt_config_b.gantt_config_id%TYPE)
345: is
346: select record_version_number
347: from pa_gantt_config_b
348: where gantt_config_id = c_gantt_config_id;
349:
350: l_gantt_config_rvn pa_gantt_config_b.record_version_number%TYPE;
351:

Line 350: l_gantt_config_rvn pa_gantt_config_b.record_version_number%TYPE;

346: select record_version_number
347: from pa_gantt_config_b
348: where gantt_config_id = c_gantt_config_id;
349:
350: l_gantt_config_rvn pa_gantt_config_b.record_version_number%TYPE;
351:
352: BEGIN
353: IF p_commit = 'Y' THEN
354: savepoint delete_gantt_config;