DBA Data[Home] [Help]

APPS.PA_PROGRESS_PUB dependencies on PA_NUM_TBL_TYPE

Line 338: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ;

334: /* Bug2756007 End */
335:
336: -- FPM Dev CR 3
337: l_record_version_number NUMBER;
338: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ;
339: l_planned_effort2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ;
340: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
341: l_end_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
342:

Line 339: l_planned_effort2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ;

335:
336: -- FPM Dev CR 3
337: l_record_version_number NUMBER;
338: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ;
339: l_planned_effort2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ;
340: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
341: l_end_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
342:
343: l_structure_sharing_code pa_projects_all.structure_sharing_code%TYPE; -- Bug 3586648

Line 7396: l_task_ver_id_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

7392: l_progress_rollup_id NUMBER := null;
7393: l_max_as_of_date date;
7394: l_as_of_date date;
7395:
7396: l_task_ver_id_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7397: l_planned_effort_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7398: l_start_date_tbl_task SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7399: l_end_date_tbl_task SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7400:

Line 7397: l_planned_effort_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

7393: l_max_as_of_date date;
7394: l_as_of_date date;
7395:
7396: l_task_ver_id_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7397: l_planned_effort_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7398: l_start_date_tbl_task SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7399: l_end_date_tbl_task SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7400:
7401: l_raw_cost_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 7401: l_raw_cost_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

7397: l_planned_effort_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7398: l_start_date_tbl_task SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7399: l_end_date_tbl_task SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7400:
7401: l_raw_cost_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7402: l_burdened_cost_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7403:
7404: l_task_ver_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7405: l_planned_ppl_effort_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 7402: l_burdened_cost_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

7398: l_start_date_tbl_task SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7399: l_end_date_tbl_task SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7400:
7401: l_raw_cost_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7402: l_burdened_cost_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7403:
7404: l_task_ver_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7405: l_planned_ppl_effort_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7406: l_planned_eqp_effort_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 7404: l_task_ver_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

7400:
7401: l_raw_cost_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7402: l_burdened_cost_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7403:
7404: l_task_ver_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7405: l_planned_ppl_effort_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7406: l_planned_eqp_effort_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7407: l_planned_qty_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7408: l_start_date_tbl_assgn SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 7405: l_planned_ppl_effort_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

7401: l_raw_cost_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7402: l_burdened_cost_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7403:
7404: l_task_ver_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7405: l_planned_ppl_effort_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7406: l_planned_eqp_effort_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7407: l_planned_qty_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7408: l_start_date_tbl_assgn SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7409: l_end_date_tbl_assgn SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 7406: l_planned_eqp_effort_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

7402: l_burdened_cost_tbl_task SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7403:
7404: l_task_ver_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7405: l_planned_ppl_effort_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7406: l_planned_eqp_effort_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7407: l_planned_qty_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7408: l_start_date_tbl_assgn SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7409: l_end_date_tbl_assgn SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7410: l_res_list_mem_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 7407: l_planned_qty_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

7403:
7404: l_task_ver_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7405: l_planned_ppl_effort_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7406: l_planned_eqp_effort_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7407: l_planned_qty_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7408: l_start_date_tbl_assgn SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7409: l_end_date_tbl_assgn SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7410: l_res_list_mem_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7411: l_cbs_element_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 7410: l_res_list_mem_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

7406: l_planned_eqp_effort_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7407: l_planned_qty_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7408: l_start_date_tbl_assgn SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7409: l_end_date_tbl_assgn SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7410: l_res_list_mem_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7411: l_cbs_element_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7412: l_res_assgn_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7413: l_currency_code_tbl_assgn SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
7414:

Line 7411: l_cbs_element_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

7407: l_planned_qty_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7408: l_start_date_tbl_assgn SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7409: l_end_date_tbl_assgn SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7410: l_res_list_mem_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7411: l_cbs_element_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7412: l_res_assgn_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7413: l_currency_code_tbl_assgn SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
7414:
7415: l_raw_cost_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 7412: l_res_assgn_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

7408: l_start_date_tbl_assgn SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7409: l_end_date_tbl_assgn SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7410: l_res_list_mem_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7411: l_cbs_element_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7412: l_res_assgn_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7413: l_currency_code_tbl_assgn SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
7414:
7415: l_raw_cost_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7416: l_burdened_cost_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 7415: l_raw_cost_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

7411: l_cbs_element_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7412: l_res_assgn_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7413: l_currency_code_tbl_assgn SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
7414:
7415: l_raw_cost_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7416: l_burdened_cost_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7417:
7418:
7419: l_act_TXN_COST_this_period NUMBER := 0;

Line 7416: l_burdened_cost_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

7412: l_res_assgn_id_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7413: l_currency_code_tbl_assgn SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
7414:
7415: l_raw_cost_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7416: l_burdened_cost_tbl_assgn SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7417:
7418:
7419: l_act_TXN_COST_this_period NUMBER := 0;
7420: l_act_PRJ_COST_this_period NUMBER := 0;

Line 7438: l_project_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

7434: -- Bug 3621404 : Raw Cost Changes End
7435:
7436: l_version_enabled_flag VARCHAR2(1) := null;
7437:
7438: l_project_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7439: l_struture_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7440: l_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7441:
7442: l_res_assign_id_out NUMBER := null;

Line 7439: l_struture_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

7435:
7436: l_version_enabled_flag VARCHAR2(1) := null;
7437:
7438: l_project_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7439: l_struture_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7440: l_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
7441:
7442: l_res_assign_id_out NUMBER := null;
7443: l_task_version_id_out NUMBER := null;

Line 8848: ,p_task_version_id IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type()

8844: ,p_debug_mode IN VARCHAR2 :='N'
8845: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8846: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8847: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8848: ,p_task_version_id IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type()
8849: ,p_calling_context IN VARCHAR2 := 'STRUCTURE_VERSION'
8850: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8851: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
8852: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 8979: l_project_id_list SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

8975: l_api_name CONSTANT VARCHAR2(30) := 'PULL_SUMMARIZED_ACTUALS';
8976: l_api_version CONSTANT NUMBER := p_api_version;
8977: l_user_id NUMBER := FND_GLOBAL.USER_ID;
8978: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
8979: l_project_id_list SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
8980: l_proj_pgm_level SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
8981: l_msg_code VARCHAR2(32);
8982:
8983: l_str_ver_id NUMBER;

Line 8980: l_proj_pgm_level SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

8976: l_api_version CONSTANT NUMBER := p_api_version;
8977: l_user_id NUMBER := FND_GLOBAL.USER_ID;
8978: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
8979: l_project_id_list SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
8980: l_proj_pgm_level SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
8981: l_msg_code VARCHAR2(32);
8982:
8983: l_str_ver_id NUMBER;
8984: Cursor cur_Summerized_Actuals

Line 9310: l_project_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type() ;

9306: l_task_id NUMBER; --3603636
9307: -- Bug 3722011 Begin
9308: L_SHARING_ENABLED VARCHAR2(1) ;
9309: L_SPLIT_WORKPLAN VARCHAR2(1) ;
9310: l_project_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type() ;
9311: l_struture_version_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type() ;
9312: l_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type() ;
9313: -- Bug 3722011 End
9314:

Line 9311: l_struture_version_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type() ;

9307: -- Bug 3722011 Begin
9308: L_SHARING_ENABLED VARCHAR2(1) ;
9309: L_SPLIT_WORKPLAN VARCHAR2(1) ;
9310: l_project_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type() ;
9311: l_struture_version_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type() ;
9312: l_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type() ;
9313: -- Bug 3722011 End
9314:
9315: -- BEGIN: Code to fix Bug # 3821106.

Line 13260: PROCEDURE GET_SUMMARIZED_ACTUALS(p_project_id_list IN SYSTEM.pa_num_tbl_type,

13256:
13257: END PUBLISH_PROGRESS;
13258:
13259:
13260: PROCEDURE GET_SUMMARIZED_ACTUALS(p_project_id_list IN SYSTEM.pa_num_tbl_type,
13261: p_extraction_type IN VARCHAR2,
13262: p_plan_res_level IN VARCHAR2,
13263: p_proj_pgm_level IN SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type(),
13264: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 13263: p_proj_pgm_level IN SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type(),

13259:
13260: PROCEDURE GET_SUMMARIZED_ACTUALS(p_project_id_list IN SYSTEM.pa_num_tbl_type,
13261: p_extraction_type IN VARCHAR2,
13262: p_plan_res_level IN VARCHAR2,
13263: p_proj_pgm_level IN SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type(),
13264: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
13265: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
13266: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
13267:

Line 13377: proj_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

13373: from pa_projects_all ppa
13374: where ppa.project_id = l_project_id;
13375:
13376: -- tables to hold project_ids, latest WP ids and res list ids.
13377: proj_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13378: latest_wp_struct_ver_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13379: res_list_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13380: proj_org_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13381: proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type();

Line 13378: latest_wp_struct_ver_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

13374: where ppa.project_id = l_project_id;
13375:
13376: -- tables to hold project_ids, latest WP ids and res list ids.
13377: proj_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13378: latest_wp_struct_ver_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13379: res_list_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13380: proj_org_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13381: proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type();
13382: calendar_type_tbl SYSTEM.pa_varchar2_1_tbl_type:= SYSTEM.pa_varchar2_1_tbl_type();

Line 13379: res_list_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

13375:
13376: -- tables to hold project_ids, latest WP ids and res list ids.
13377: proj_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13378: latest_wp_struct_ver_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13379: res_list_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13380: proj_org_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13381: proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type();
13382: calendar_type_tbl SYSTEM.pa_varchar2_1_tbl_type:= SYSTEM.pa_varchar2_1_tbl_type();
13383: proj_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type:= SYSTEM.pa_varchar2_15_tbl_type();

Line 13380: proj_org_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

13376: -- tables to hold project_ids, latest WP ids and res list ids.
13377: proj_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13378: latest_wp_struct_ver_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13379: res_list_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13380: proj_org_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13381: proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type();
13382: calendar_type_tbl SYSTEM.pa_varchar2_1_tbl_type:= SYSTEM.pa_varchar2_1_tbl_type();
13383: proj_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type:= SYSTEM.pa_varchar2_15_tbl_type();
13384: proj_func_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type:= SYSTEM.pa_varchar2_15_tbl_type();

Line 13385: proj_pgm_level_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

13381: proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type();
13382: calendar_type_tbl SYSTEM.pa_varchar2_1_tbl_type:= SYSTEM.pa_varchar2_1_tbl_type();
13383: proj_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type:= SYSTEM.pa_varchar2_15_tbl_type();
13384: proj_func_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type:= SYSTEM.pa_varchar2_15_tbl_type();
13385: proj_pgm_level_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13386:
13387: -- Added for bug 5464875
13388: base_struct_ver_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13389: populate_in_tbl PJI_FM_XBS_ACCUM_UTILS.populate_in_tbl_type;

Line 13388: base_struct_ver_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

13384: proj_func_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type:= SYSTEM.pa_varchar2_15_tbl_type();
13385: proj_pgm_level_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13386:
13387: -- Added for bug 5464875
13388: base_struct_ver_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13389: populate_in_tbl PJI_FM_XBS_ACCUM_UTILS.populate_in_tbl_type;
13390:
13391: /* Begin: Fix for Bug # 5526638. */
13392: l_act_err_flag SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 13392: l_act_err_flag SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

13388: base_struct_ver_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13389: populate_in_tbl PJI_FM_XBS_ACCUM_UTILS.populate_in_tbl_type;
13390:
13391: /* Begin: Fix for Bug # 5526638. */
13392: l_act_err_flag SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13393: --l_act_err_msg SYSTEM.pa_varchar2_240_tbl_type:= SYSTEM.pa_varchar2_240_tbl_type();
13394: l_act_err_msg SYSTEM.pa_varchar2_2000_tbl_type:= SYSTEM.pa_varchar2_2000_tbl_type(); --increased the size for the bug 13640836
13395: l_act_out_report VARCHAR2(1) := 'N';
13396: l_err_msg VARCHAR2(600); --increased the size for the bug 13640836

Line 13399: skip_proj_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

13395: l_act_out_report VARCHAR2(1) := 'N';
13396: l_err_msg VARCHAR2(600); --increased the size for the bug 13640836
13397: l_skip_exception Exception;
13398: l_pji_wp_exception Exception;
13399: skip_proj_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13400: skip_latest_wp_str_ver_id_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13401: skip_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type();
13402: /* End: Fix for Bug # 5526638. */
13403:

Line 13400: skip_latest_wp_str_ver_id_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

13396: l_err_msg VARCHAR2(600); --increased the size for the bug 13640836
13397: l_skip_exception Exception;
13398: l_pji_wp_exception Exception;
13399: skip_proj_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13400: skip_latest_wp_str_ver_id_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
13401: skip_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type();
13402: /* End: Fix for Bug # 5526638. */
13403:
13404: cursor max_as_of_Date is

Line 22571: ,p_project_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

22567: ,p_rollup_entire_wbs_flag IN VARCHAR2 :='N'
22568: ,p_progress_mode IN VARCHAR2 :='FUTURE'
22569: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
22570: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
22571: ,p_project_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22572: ,p_object_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22573: ,p_object_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22574: ,p_object_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
22575: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

Line 22572: ,p_object_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

22568: ,p_progress_mode IN VARCHAR2 :='FUTURE'
22569: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
22570: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
22571: ,p_project_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22572: ,p_object_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22573: ,p_object_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22574: ,p_object_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
22575: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22576: ,p_structure_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

Line 22573: ,p_object_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

22569: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
22570: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
22571: ,p_project_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22572: ,p_object_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22573: ,p_object_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22574: ,p_object_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
22575: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22576: ,p_structure_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22577: ,p_as_of_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()

Line 22575: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

22571: ,p_project_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22572: ,p_object_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22573: ,p_object_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22574: ,p_object_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
22575: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22576: ,p_structure_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22577: ,p_as_of_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22578: ,p_rbs_element_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22579: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

Line 22576: ,p_structure_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

22572: ,p_object_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22573: ,p_object_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22574: ,p_object_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
22575: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22576: ,p_structure_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22577: ,p_as_of_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22578: ,p_rbs_element_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22579: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22580: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type()

Line 22578: ,p_rbs_element_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

22574: ,p_object_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
22575: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22576: ,p_structure_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22577: ,p_as_of_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22578: ,p_rbs_element_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22579: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22580: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type()
22581: ,p_resource_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
22582: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()

Line 22579: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

22575: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22576: ,p_structure_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22577: ,p_as_of_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22578: ,p_rbs_element_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22579: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22580: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type()
22581: ,p_resource_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
22582: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
22583: ,p_percent_complete_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

Line 22583: ,p_percent_complete_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

22579: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22580: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type()
22581: ,p_resource_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
22582: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
22583: ,p_percent_complete_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22584: ,p_record_version_number_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22585: ,p_percent_complete_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22586: ,p_eff_rup_percent_complete_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22587: ,p_task_status_tbl IN SYSTEM.pa_varchar2_150_tbl_type := SYSTEM.pa_varchar2_150_tbl_type()

Line 22584: ,p_record_version_number_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

22580: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type()
22581: ,p_resource_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
22582: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
22583: ,p_percent_complete_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22584: ,p_record_version_number_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22585: ,p_percent_complete_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22586: ,p_eff_rup_percent_complete_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22587: ,p_task_status_tbl IN SYSTEM.pa_varchar2_150_tbl_type := SYSTEM.pa_varchar2_150_tbl_type()
22588: ,p_progress_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()

Line 22585: ,p_percent_complete_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

22581: ,p_resource_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
22582: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
22583: ,p_percent_complete_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22584: ,p_record_version_number_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22585: ,p_percent_complete_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22586: ,p_eff_rup_percent_complete_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22587: ,p_task_status_tbl IN SYSTEM.pa_varchar2_150_tbl_type := SYSTEM.pa_varchar2_150_tbl_type()
22588: ,p_progress_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
22589: ,p_progress_comment_tbl IN SYSTEM.pa_varchar2_4000_tbl_type2 := SYSTEM.pa_varchar2_4000_tbl_type2() /* 9754781 : Changes type */

Line 22586: ,p_eff_rup_percent_complete_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

22582: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
22583: ,p_percent_complete_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22584: ,p_record_version_number_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22585: ,p_percent_complete_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22586: ,p_eff_rup_percent_complete_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22587: ,p_task_status_tbl IN SYSTEM.pa_varchar2_150_tbl_type := SYSTEM.pa_varchar2_150_tbl_type()
22588: ,p_progress_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
22589: ,p_progress_comment_tbl IN SYSTEM.pa_varchar2_4000_tbl_type2 := SYSTEM.pa_varchar2_4000_tbl_type2() /* 9754781 : Changes type */
22590: ,p_brief_overview_tbl IN SYSTEM.pa_varchar2_250_tbl_type := SYSTEM.pa_varchar2_250_tbl_type() /* 7709400 : Changed type */

Line 22597: ,p_est_remaining_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

22593: ,p_estimated_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22594: ,p_estimated_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22595: ,p_scheduled_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22596: ,p_scheduled_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22597: ,p_est_remaining_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22598: ,p_etc_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22599: ,p_actual_work_quantity_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22600: ,p_actual_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22601: ,p_actual_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

Line 22598: ,p_etc_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

22594: ,p_estimated_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22595: ,p_scheduled_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22596: ,p_scheduled_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22597: ,p_est_remaining_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22598: ,p_etc_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22599: ,p_actual_work_quantity_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22600: ,p_actual_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22601: ,p_actual_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22602: ,p_act_eff_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

Line 22599: ,p_actual_work_quantity_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

22595: ,p_scheduled_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22596: ,p_scheduled_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22597: ,p_est_remaining_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22598: ,p_etc_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22599: ,p_actual_work_quantity_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22600: ,p_actual_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22601: ,p_actual_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22602: ,p_act_eff_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22603: ,p_actual_cost_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

Line 22600: ,p_actual_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

22596: ,p_scheduled_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
22597: ,p_est_remaining_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22598: ,p_etc_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22599: ,p_actual_work_quantity_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22600: ,p_actual_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22601: ,p_actual_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22602: ,p_act_eff_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22603: ,p_actual_cost_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22604: ,p_planned_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

Line 22601: ,p_actual_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

22597: ,p_est_remaining_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22598: ,p_etc_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22599: ,p_actual_work_quantity_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22600: ,p_actual_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22601: ,p_actual_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22602: ,p_act_eff_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22603: ,p_actual_cost_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22604: ,p_planned_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22605: ,p_planned_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

Line 22602: ,p_act_eff_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

22598: ,p_etc_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22599: ,p_actual_work_quantity_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22600: ,p_actual_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22601: ,p_actual_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22602: ,p_act_eff_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22603: ,p_actual_cost_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22604: ,p_planned_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22605: ,p_planned_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22606: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 22603: ,p_actual_cost_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

22599: ,p_actual_work_quantity_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22600: ,p_actual_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22601: ,p_actual_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22602: ,p_act_eff_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22603: ,p_actual_cost_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22604: ,p_planned_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22605: ,p_planned_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22606: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
22607: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 22604: ,p_planned_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

22600: ,p_actual_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22601: ,p_actual_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22602: ,p_act_eff_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22603: ,p_actual_cost_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22604: ,p_planned_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22605: ,p_planned_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22606: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
22607: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
22608: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 22605: ,p_planned_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

22601: ,p_actual_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22602: ,p_act_eff_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22603: ,p_actual_cost_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22604: ,p_planned_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22605: ,p_planned_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22606: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
22607: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
22608: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
22609: )

Line 22671: l_project_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

22667: l_last_split_workplan VARCHAR2(1);
22668: l_task_id NUMBER;
22669: L_SHARING_ENABLED VARCHAR2(1);
22670: L_SPLIT_WORKPLAN VARCHAR2(1);
22671: l_project_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22672: l_struture_version_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22673: l_struture_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22674: l_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type();
22675: l_task_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

Line 22672: l_struture_version_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

22668: l_task_id NUMBER;
22669: L_SHARING_ENABLED VARCHAR2(1);
22670: L_SPLIT_WORKPLAN VARCHAR2(1);
22671: l_project_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22672: l_struture_version_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22673: l_struture_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22674: l_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type();
22675: l_task_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22676: l_wp_rollup_method_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 22673: l_struture_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

22669: L_SHARING_ENABLED VARCHAR2(1);
22670: L_SPLIT_WORKPLAN VARCHAR2(1);
22671: l_project_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22672: l_struture_version_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22673: l_struture_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22674: l_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type();
22675: l_task_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22676: l_wp_rollup_method_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
22677: l_fin_rollup_method_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 22675: l_task_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

22671: l_project_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22672: l_struture_version_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22673: l_struture_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22674: l_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type();
22675: l_task_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22676: l_wp_rollup_method_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
22677: l_fin_rollup_method_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
22678: l_object_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
22679: l_lowest_level_task_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line 22680: l_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

22676: l_wp_rollup_method_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
22677: l_fin_rollup_method_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
22678: l_object_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
22679: l_lowest_level_task_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
22680: l_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22681: l_structure_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22682: l_rollup_call_required_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
22683: l_budget_call_required_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
22684: l_mass_rlp_call_required_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line 22681: l_structure_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

22677: l_fin_rollup_method_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
22678: l_object_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
22679: l_lowest_level_task_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
22680: l_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22681: l_structure_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22682: l_rollup_call_required_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
22683: l_budget_call_required_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
22684: l_mass_rlp_call_required_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
22685: l_action VARCHAR2(30);

Line 22696: l_mass_rollup_task_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

22692: l_count_of_rollup_calls NUMBER;
22693: l_count_of_budget_calls NUMBER;
22694:
22695: -- Bug 4218507
22696: l_mass_rollup_task_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
22697: l_unique_rec_exists VARCHAR2(1);
22698: l_calling_mode VARCHAR2(15);
22699: l_check VARCHAR2(1);
22700: