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_FP_COPY_FROM_PKG dependencies on PA_NUM_TBL_TYPE

Line 1907: ,p_src_ra_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1903: For workplan context target rlm id would be passed for each source resource assignment
1904: =====================================================================================*/
1905: PROCEDURE create_res_task_maps(
1906: p_context IN VARCHAR2 --Can be WORKPLAN, BUDGET
1907: ,p_src_ra_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1908: ,p_src_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1909: ,p_targ_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1910: ,p_targ_proj_assmt_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1911: ,p_targ_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE -- Bug 3615617

Line 1908: ,p_src_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1904: =====================================================================================*/
1905: PROCEDURE create_res_task_maps(
1906: p_context IN VARCHAR2 --Can be WORKPLAN, BUDGET
1907: ,p_src_ra_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1908: ,p_src_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1909: ,p_targ_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1910: ,p_targ_proj_assmt_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1911: ,p_targ_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE -- Bug 3615617
1912: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

Line 1909: ,p_targ_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1905: PROCEDURE create_res_task_maps(
1906: p_context IN VARCHAR2 --Can be WORKPLAN, BUDGET
1907: ,p_src_ra_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1908: ,p_src_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1909: ,p_targ_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1910: ,p_targ_proj_assmt_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1911: ,p_targ_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE -- Bug 3615617
1912: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1913: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

Line 1910: ,p_targ_proj_assmt_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1906: p_context IN VARCHAR2 --Can be WORKPLAN, BUDGET
1907: ,p_src_ra_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1908: ,p_src_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1909: ,p_targ_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1910: ,p_targ_proj_assmt_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1911: ,p_targ_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE -- Bug 3615617
1912: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1913: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1914: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

Line 1911: ,p_targ_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE -- Bug 3615617

1907: ,p_src_ra_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1908: ,p_src_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1909: ,p_targ_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1910: ,p_targ_proj_assmt_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1911: ,p_targ_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE -- Bug 3615617
1912: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1913: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1914: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1915: ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

Line 1938: l_targ_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

1934: --End of variables used for debugging
1935: --Bug 4201936
1936: l_temp VARCHAR2(15);
1937: l_src_elem_ver_id pa_proj_element_versions.element_version_id%TYPE;
1938: l_targ_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1939: TYPE src_elem_targ_elem_map_tbl_typ IS TABLE OF NUMBER INDEX BY VARCHAR2(15);
1940: l_src_elem_targ_elem_map_tbl src_elem_targ_elem_map_tbl_typ;
1941:
1942: BEGIN

Line 4116: l_bl_id_tbl SYSTEM.pa_num_tbl_type;

4112: l_return_status VARCHAR2(2000);
4113: l_debug_mode VARCHAR2(30);
4114: l_module_name VARCHAR2(100);
4115:
4116: l_bl_id_tbl SYSTEM.pa_num_tbl_type;
4117: l_ra_id_tbl SYSTEM.pa_num_tbl_type;
4118: l_quantity_tbl SYSTEM.pa_num_tbl_type;
4119: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4120: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;

Line 4117: l_ra_id_tbl SYSTEM.pa_num_tbl_type;

4113: l_debug_mode VARCHAR2(30);
4114: l_module_name VARCHAR2(100);
4115:
4116: l_bl_id_tbl SYSTEM.pa_num_tbl_type;
4117: l_ra_id_tbl SYSTEM.pa_num_tbl_type;
4118: l_quantity_tbl SYSTEM.pa_num_tbl_type;
4119: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4120: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4121: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;

Line 4118: l_quantity_tbl SYSTEM.pa_num_tbl_type;

4114: l_module_name VARCHAR2(100);
4115:
4116: l_bl_id_tbl SYSTEM.pa_num_tbl_type;
4117: l_ra_id_tbl SYSTEM.pa_num_tbl_type;
4118: l_quantity_tbl SYSTEM.pa_num_tbl_type;
4119: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4120: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4121: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4122: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;

Line 4119: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;

4115:
4116: l_bl_id_tbl SYSTEM.pa_num_tbl_type;
4117: l_ra_id_tbl SYSTEM.pa_num_tbl_type;
4118: l_quantity_tbl SYSTEM.pa_num_tbl_type;
4119: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4120: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4121: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4122: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
4123: l_raw_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;

Line 4120: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;

4116: l_bl_id_tbl SYSTEM.pa_num_tbl_type;
4117: l_ra_id_tbl SYSTEM.pa_num_tbl_type;
4118: l_quantity_tbl SYSTEM.pa_num_tbl_type;
4119: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4120: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4121: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4122: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
4123: l_raw_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4124: l_burd_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;

Line 4121: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;

4117: l_ra_id_tbl SYSTEM.pa_num_tbl_type;
4118: l_quantity_tbl SYSTEM.pa_num_tbl_type;
4119: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4120: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4121: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4122: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
4123: l_raw_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4124: l_burd_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4125: l_bill_override_rate_tbl SYSTEM.pa_num_tbl_type;

Line 4123: l_raw_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;

4119: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4120: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4121: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4122: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
4123: l_raw_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4124: l_burd_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4125: l_bill_override_rate_tbl SYSTEM.pa_num_tbl_type;
4126: l_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type;
4127: l_bl_rb_flag_chg_tbl SYSTEM.pa_varchar2_1_tbl_type;

Line 4124: l_burd_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;

4120: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4121: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4122: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
4123: l_raw_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4124: l_burd_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4125: l_bill_override_rate_tbl SYSTEM.pa_num_tbl_type;
4126: l_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type;
4127: l_bl_rb_flag_chg_tbl SYSTEM.pa_varchar2_1_tbl_type;
4128: l_target_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

Line 4125: l_bill_override_rate_tbl SYSTEM.pa_num_tbl_type;

4121: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4122: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
4123: l_raw_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4124: l_burd_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4125: l_bill_override_rate_tbl SYSTEM.pa_num_tbl_type;
4126: l_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type;
4127: l_bl_rb_flag_chg_tbl SYSTEM.pa_varchar2_1_tbl_type;
4128: l_target_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
4129: l_prev_ra_id pa_resource_assignments.resource_assignment_id%TYPE;

Line 4126: l_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type;

4122: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
4123: l_raw_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4124: l_burd_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4125: l_bill_override_rate_tbl SYSTEM.pa_num_tbl_type;
4126: l_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type;
4127: l_bl_rb_flag_chg_tbl SYSTEM.pa_varchar2_1_tbl_type;
4128: l_target_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
4129: l_prev_ra_id pa_resource_assignments.resource_assignment_id%TYPE;
4130: l_temp_flag VARCHAR2(1);

Line 4131: l_init_quantity_tbl SYSTEM.pa_num_tbl_type;

4127: l_bl_rb_flag_chg_tbl SYSTEM.pa_varchar2_1_tbl_type;
4128: l_target_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
4129: l_prev_ra_id pa_resource_assignments.resource_assignment_id%TYPE;
4130: l_temp_flag VARCHAR2(1);
4131: l_init_quantity_tbl SYSTEM.pa_num_tbl_type;
4132: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
4133: l_temp NUMBER;
4134:
4135: /* Bug 5078538 --Added the out variables to avoid the uninitialized collection

Line 4139: l_quantity_out_tbl SYSTEM.pa_num_tbl_type;

4135: /* Bug 5078538 --Added the out variables to avoid the uninitialized collection
4136: error. Note that this error is caused when the same variables are passed as
4137: In and In Out parameters in a api call.
4138: */
4139: l_quantity_out_tbl SYSTEM.pa_num_tbl_type;
4140: l_txn_raw_cost_out_tbl SYSTEM.pa_num_tbl_type;
4141: l_txn_burdened_cost_out_tbl SYSTEM.pa_num_tbl_type;
4142: l_txn_revenue_out_tbl SYSTEM.pa_num_tbl_type;
4143:

Line 4140: l_txn_raw_cost_out_tbl SYSTEM.pa_num_tbl_type;

4136: error. Note that this error is caused when the same variables are passed as
4137: In and In Out parameters in a api call.
4138: */
4139: l_quantity_out_tbl SYSTEM.pa_num_tbl_type;
4140: l_txn_raw_cost_out_tbl SYSTEM.pa_num_tbl_type;
4141: l_txn_burdened_cost_out_tbl SYSTEM.pa_num_tbl_type;
4142: l_txn_revenue_out_tbl SYSTEM.pa_num_tbl_type;
4143:
4144: BEGIN

Line 4141: l_txn_burdened_cost_out_tbl SYSTEM.pa_num_tbl_type;

4137: In and In Out parameters in a api call.
4138: */
4139: l_quantity_out_tbl SYSTEM.pa_num_tbl_type;
4140: l_txn_raw_cost_out_tbl SYSTEM.pa_num_tbl_type;
4141: l_txn_burdened_cost_out_tbl SYSTEM.pa_num_tbl_type;
4142: l_txn_revenue_out_tbl SYSTEM.pa_num_tbl_type;
4143:
4144: BEGIN
4145:

Line 4142: l_txn_revenue_out_tbl SYSTEM.pa_num_tbl_type;

4138: */
4139: l_quantity_out_tbl SYSTEM.pa_num_tbl_type;
4140: l_txn_raw_cost_out_tbl SYSTEM.pa_num_tbl_type;
4141: l_txn_burdened_cost_out_tbl SYSTEM.pa_num_tbl_type;
4142: l_txn_revenue_out_tbl SYSTEM.pa_num_tbl_type;
4143:
4144: BEGIN
4145:
4146: x_msg_count := 0;

Line 6062: l_budget_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

6058: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
6059: l_appr_cost_plan_type_flag pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;
6060: l_appr_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;
6061: l_struct_elem_version_id pa_proj_element_versions.element_version_id%TYPE;
6062: l_budget_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6063: l_src_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6064:
6065:
6066: /* Code addition for bug 2986930 starts */

Line 6063: l_src_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

6059: l_appr_cost_plan_type_flag pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;
6060: l_appr_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;
6061: l_struct_elem_version_id pa_proj_element_versions.element_version_id%TYPE;
6062: l_budget_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6063: l_src_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6064:
6065:
6066: /* Code addition for bug 2986930 starts */
6067: CURSOR c_ar_chk( p_source_ver_id pa_budget_versions.budget_version_id%TYPE) IS

Line 6633: l_budget_version_ids := SYSTEM.pa_num_tbl_type(l_target_version_id);

6629: ,x_msg_data => l_msg_data );
6630:
6631: /* FP M - Reporting lines integration */
6632: l_budget_version_ids.delete;
6633: l_budget_version_ids := SYSTEM.pa_num_tbl_type(l_target_version_id);
6634:
6635: IF P_PA_DEBUG_MODE = 'Y' THEN
6636: pa_debug.write('Copy_Finplans_From_Project','Calling PJI_FM_XBS_ACCUM_MAINT.PLAN_CREATE ' ,5);
6637: pa_debug.write('Copy_Finplans_From_Project','p_fp_version_ids count '|| l_budget_version_ids.count(),5);

Line 6648: l_src_budget_version_id_tbl := SYSTEM.pa_num_tbl_type(l_source_version_id);

6644: END IF;
6645: END LOOP;
6646:
6647: l_src_budget_version_id_tbl.delete;
6648: l_src_budget_version_id_tbl := SYSTEM.pa_num_tbl_type(l_source_version_id);
6649: -- This parameter will be used when the source project is not equal to the target project.
6650: --This will be passed as null in the MSP flow other wise it will be defaulted to 'P'.
6651: Declare
6652: l_copy_mode VARCHAR2(1);

Line 8740: ,p_src_sv_ids_tbl IN SYSTEM.pa_num_tbl_type

8736: PROCEDURE copy_wp_budget_versions
8737: (
8738: p_source_project_id IN pa_proj_element_versions.project_id%TYPE
8739: ,p_target_project_id IN pa_proj_element_versions.element_version_id%TYPE
8740: ,p_src_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
8741: ,p_target_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
8742: ,p_copy_act_from_str_ids_tbl IN SYSTEM.pa_num_tbl_type -- bug 3847386
8743: ,p_copy_people_flag IN VARCHAR2
8744: ,p_copy_equip_flag IN VARCHAR2

Line 8741: ,p_target_sv_ids_tbl IN SYSTEM.pa_num_tbl_type

8737: (
8738: p_source_project_id IN pa_proj_element_versions.project_id%TYPE
8739: ,p_target_project_id IN pa_proj_element_versions.element_version_id%TYPE
8740: ,p_src_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
8741: ,p_target_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
8742: ,p_copy_act_from_str_ids_tbl IN SYSTEM.pa_num_tbl_type -- bug 3847386
8743: ,p_copy_people_flag IN VARCHAR2
8744: ,p_copy_equip_flag IN VARCHAR2
8745: ,p_copy_mat_item_flag IN VARCHAR2

Line 8742: ,p_copy_act_from_str_ids_tbl IN SYSTEM.pa_num_tbl_type -- bug 3847386

8738: p_source_project_id IN pa_proj_element_versions.project_id%TYPE
8739: ,p_target_project_id IN pa_proj_element_versions.element_version_id%TYPE
8740: ,p_src_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
8741: ,p_target_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
8742: ,p_copy_act_from_str_ids_tbl IN SYSTEM.pa_num_tbl_type -- bug 3847386
8743: ,p_copy_people_flag IN VARCHAR2
8744: ,p_copy_equip_flag IN VARCHAR2
8745: ,p_copy_mat_item_flag IN VARCHAR2
8746: ,p_copy_fin_elem_flag IN VARCHAR2

Line 8787: l_src_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

8783: l_targ_elem_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
8784: */
8785:
8786:
8787: l_src_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8788: l_targ_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8789:
8790: -- ----------------------------------------------------------------------
8791:

Line 8788: l_targ_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

8784: */
8785:
8786:
8787: l_src_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8788: l_targ_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8789:
8790: -- ----------------------------------------------------------------------
8791:
8792: l_copy_external_flag VARCHAR2(1);

Line 8795: l_budget_version_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

8791:
8792: l_copy_external_flag VARCHAR2(1);
8793:
8794: --This table will be used in the PJI API call
8795: l_budget_version_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8796: l_src_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8797:
8798: --Cursor for getting the source and target element version ids. This will be used in calling the
8799: --Copy Planning Txn API

Line 8796: l_src_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

8792: l_copy_external_flag VARCHAR2(1);
8793:
8794: --This table will be used in the PJI API call
8795: l_budget_version_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8796: l_src_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8797:
8798: --Cursor for getting the source and target element version ids. This will be used in calling the
8799: --Copy Planning Txn API
8800: CURSOR l_prep_plan_txn_csr(c_source_plan_version_id pa_budget_versions.budget_version_id%TYPE

Line 9085: l_budget_version_ids := SYSTEM.pa_num_tbl_type(l_targ_budget_version_id);

9081: -- FP M - Reporting lines integration. The create API is being called even before calling the copy
9082: --planning txn as the copy planning txn will take care of later calling the PJI plan update API for
9083: --the new budget lines created
9084: l_budget_version_ids.delete;
9085: l_budget_version_ids := SYSTEM.pa_num_tbl_type(l_targ_budget_version_id);
9086:
9087: l_src_budget_version_id_tbl.delete;
9088: l_src_budget_version_id_tbl := SYSTEM.pa_num_tbl_type(l_src_budget_version_id);
9089:

Line 9088: l_src_budget_version_id_tbl := SYSTEM.pa_num_tbl_type(l_src_budget_version_id);

9084: l_budget_version_ids.delete;
9085: l_budget_version_ids := SYSTEM.pa_num_tbl_type(l_targ_budget_version_id);
9086:
9087: l_src_budget_version_id_tbl.delete;
9088: l_src_budget_version_id_tbl := SYSTEM.pa_num_tbl_type(l_src_budget_version_id);
9089:
9090: IF l_debug_mode = 'Y' THEN
9091: pa_debug.write(l_module_name,'Calling PJI_FM_XBS_ACCUM_MAINT.PLAN_CREATE ' ,5);
9092: pa_debug.write(l_module_name,'p_fp_version_ids count '|| l_budget_version_ids.count(),5);

Line 9380: l_budget_line_idTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;

9376: l_burden_cost_rate_override NUMBER;
9377:
9378: /* Initialized plsql tables for bug 3709036 */
9379:
9380: l_budget_line_idTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9381: l_quantityTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9382: l_raw_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9383: l_burdened_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9384: l_revenueTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;

Line 9381: l_quantityTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;

9377:
9378: /* Initialized plsql tables for bug 3709036 */
9379:
9380: l_budget_line_idTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9381: l_quantityTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9382: l_raw_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9383: l_burdened_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9384: l_revenueTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9385: l_change_reason_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 9382: l_raw_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;

9378: /* Initialized plsql tables for bug 3709036 */
9379:
9380: l_budget_line_idTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9381: l_quantityTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9382: l_raw_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9383: l_burdened_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9384: l_revenueTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9385: l_change_reason_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9386: l_descriptionTab SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

Line 9383: l_burdened_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;

9379:
9380: l_budget_line_idTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9381: l_quantityTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9382: l_raw_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9383: l_burdened_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9384: l_revenueTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9385: l_change_reason_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9386: l_descriptionTab SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
9387: l_attribute_categoryTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 9384: l_revenueTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;

9380: l_budget_line_idTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9381: l_quantityTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9382: l_raw_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9383: l_burdened_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9384: l_revenueTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9385: l_change_reason_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9386: l_descriptionTab SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
9387: l_attribute_categoryTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9388: l_attribute1Tab SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

Line 9403: l_project_raw_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

9399: l_attribute12Tab SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
9400: l_attribute13Tab SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
9401: l_attribute14Tab SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
9402: l_attribute15Tab SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
9403: l_project_raw_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
9404: l_project_burdened_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
9405: l_project_revenueTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
9406: l_txn_currency_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9407: l_projfunc_currency_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 9404: l_project_burdened_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

9400: l_attribute13Tab SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
9401: l_attribute14Tab SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
9402: l_attribute15Tab SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
9403: l_project_raw_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
9404: l_project_burdened_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
9405: l_project_revenueTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
9406: l_txn_currency_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9407: l_projfunc_currency_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9408: l_project_currency_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 9405: l_project_revenueTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

9401: l_attribute14Tab SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
9402: l_attribute15Tab SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
9403: l_project_raw_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
9404: l_project_burdened_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
9405: l_project_revenueTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
9406: l_txn_currency_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9407: l_projfunc_currency_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9408: l_project_currency_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9409: l_end_dateTab SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE ();

Line 10123: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

10119: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10120: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10121: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10122:
10123: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10124: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10125: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10126: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10127:

Line 10124: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

10120: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10121: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10122:
10123: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10124: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10125: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10126: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10127:
10128: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 10125: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

10121: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10122:
10123: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10124: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10125: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10126: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10127:
10128: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10129:

Line 10126: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

10122:
10123: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10124: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10125: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10126: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10127:
10128: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10129:
10130: CURSOR parent_plan_type_cur IS

Line 10128: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

10124: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10125: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10126: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10127:
10128: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10129:
10130: CURSOR parent_plan_type_cur IS
10131: SELECT pfo.proj_fp_options_id
10132: ,pfo.track_workplan_costs_flag

Line 10419: l_budget_version_id_tbl := SYSTEM.pa_num_tbl_type(p_wp_version_id);

10415: AND resource_assignment_id = l_txn_source_id_tbl(i);
10416: END IF;
10417:
10418: -- populating the l_budget_version_id_tbl with p_budget_version_id
10419: l_budget_version_id_tbl := SYSTEM.pa_num_tbl_type(p_wp_version_id);
10420:
10421:
10422: END IF;
10423: