APPS.PA_FP_REFRESH_ELEMENTS_PUB dependencies on PA_PLSQL_DATATYPES

Line 26: PROCEDURE update_process_status( p_fp_opt_tab IN PA_PLSQL_DATATYPES.IdTabTyp,

22:
23: /* This API updates the budget version and proj fp options table
24: for plan processing code and process_update_wbs_flag columns based on the
25: p_return_status value. */
26: PROCEDURE update_process_status( p_fp_opt_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
27: p_return_status IN VARCHAR2,
28: p_project_id IN NUMBER,
29: p_request_id IN NUMBER,
30: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 43: p_fp_opt_tab IN PA_PLSQL_DATATYPES.IdTabTyp,

39: This API should be called only in case of unexpected errors and the process
40: is running thru the concurrent program. */
41:
42: PROCEDURE update_process_status_auto(
43: p_fp_opt_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
44: p_return_status IN VARCHAR2,
45: p_project_id IN NUMBER,
46: p_request_id IN NUMBER,
47: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 126: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

122: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
123: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
124: l_impacted_tasks_rec PA_FP_ELEMENTS_PUB.l_wbs_refresh_tasks_tbl_typ;
125: i number;
126: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
127: l_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
128: l_parent_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
129: l_task_level_tab PA_PLSQL_DATATYPES.Char1TabTyp;
130: l_fp_opt_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 127: l_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

123: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
124: l_impacted_tasks_rec PA_FP_ELEMENTS_PUB.l_wbs_refresh_tasks_tbl_typ;
125: i number;
126: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
127: l_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
128: l_parent_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
129: l_task_level_tab PA_PLSQL_DATATYPES.Char1TabTyp;
130: l_fp_opt_tbl PA_PLSQL_DATATYPES.IdTabTyp;
131: l_tname_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 128: l_parent_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

124: l_impacted_tasks_rec PA_FP_ELEMENTS_PUB.l_wbs_refresh_tasks_tbl_typ;
125: i number;
126: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
127: l_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
128: l_parent_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
129: l_task_level_tab PA_PLSQL_DATATYPES.Char1TabTyp;
130: l_fp_opt_tbl PA_PLSQL_DATATYPES.IdTabTyp;
131: l_tname_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
132: l_dummy NUMBER;

Line 129: l_task_level_tab PA_PLSQL_DATATYPES.Char1TabTyp;

125: i number;
126: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
127: l_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
128: l_parent_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
129: l_task_level_tab PA_PLSQL_DATATYPES.Char1TabTyp;
130: l_fp_opt_tbl PA_PLSQL_DATATYPES.IdTabTyp;
131: l_tname_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
132: l_dummy NUMBER;
133: l_module VARCHAR2(255):='pa_fp_refresh_elements_pub.refresh_planning_elements';

Line 130: l_fp_opt_tbl PA_PLSQL_DATATYPES.IdTabTyp;

126: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
127: l_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
128: l_parent_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
129: l_task_level_tab PA_PLSQL_DATATYPES.Char1TabTyp;
130: l_fp_opt_tbl PA_PLSQL_DATATYPES.IdTabTyp;
131: l_tname_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
132: l_dummy NUMBER;
133: l_module VARCHAR2(255):='pa_fp_refresh_elements_pub.refresh_planning_elements';
134: l_calling_context VARCHAR2(10);

Line 131: l_tname_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

127: l_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
128: l_parent_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
129: l_task_level_tab PA_PLSQL_DATATYPES.Char1TabTyp;
130: l_fp_opt_tbl PA_PLSQL_DATATYPES.IdTabTyp;
131: l_tname_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
132: l_dummy NUMBER;
133: l_module VARCHAR2(255):='pa_fp_refresh_elements_pub.refresh_planning_elements';
134: l_calling_context VARCHAR2(10);
135: l_msg VARCHAR2(300);