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 4104: l_bl_id_tbl SYSTEM.pa_num_tbl_type;

4100: l_return_status VARCHAR2(2000);
4101: l_debug_mode VARCHAR2(30);
4102: l_module_name VARCHAR2(100);
4103:
4104: l_bl_id_tbl SYSTEM.pa_num_tbl_type;
4105: l_ra_id_tbl SYSTEM.pa_num_tbl_type;
4106: l_quantity_tbl SYSTEM.pa_num_tbl_type;
4107: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4108: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;

Line 4105: l_ra_id_tbl SYSTEM.pa_num_tbl_type;

4101: l_debug_mode VARCHAR2(30);
4102: l_module_name VARCHAR2(100);
4103:
4104: l_bl_id_tbl SYSTEM.pa_num_tbl_type;
4105: l_ra_id_tbl SYSTEM.pa_num_tbl_type;
4106: l_quantity_tbl SYSTEM.pa_num_tbl_type;
4107: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4108: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4109: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;

Line 4106: l_quantity_tbl SYSTEM.pa_num_tbl_type;

4102: l_module_name VARCHAR2(100);
4103:
4104: l_bl_id_tbl SYSTEM.pa_num_tbl_type;
4105: l_ra_id_tbl SYSTEM.pa_num_tbl_type;
4106: l_quantity_tbl SYSTEM.pa_num_tbl_type;
4107: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4108: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4109: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4110: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;

Line 4107: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;

4103:
4104: l_bl_id_tbl SYSTEM.pa_num_tbl_type;
4105: l_ra_id_tbl SYSTEM.pa_num_tbl_type;
4106: l_quantity_tbl SYSTEM.pa_num_tbl_type;
4107: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4108: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4109: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4110: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
4111: l_raw_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;

Line 4108: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;

4104: l_bl_id_tbl SYSTEM.pa_num_tbl_type;
4105: l_ra_id_tbl SYSTEM.pa_num_tbl_type;
4106: l_quantity_tbl SYSTEM.pa_num_tbl_type;
4107: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4108: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4109: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4110: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
4111: l_raw_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4112: l_burd_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;

Line 4109: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;

4105: l_ra_id_tbl SYSTEM.pa_num_tbl_type;
4106: l_quantity_tbl SYSTEM.pa_num_tbl_type;
4107: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4108: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4109: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4110: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
4111: l_raw_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4112: l_burd_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4113: l_bill_override_rate_tbl SYSTEM.pa_num_tbl_type;

Line 4111: l_raw_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;

4107: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4108: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4109: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4110: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
4111: l_raw_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4112: l_burd_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4113: l_bill_override_rate_tbl SYSTEM.pa_num_tbl_type;
4114: l_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type;
4115: l_bl_rb_flag_chg_tbl SYSTEM.pa_varchar2_1_tbl_type;

Line 4112: l_burd_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;

4108: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4109: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4110: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
4111: l_raw_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4112: l_burd_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4113: l_bill_override_rate_tbl SYSTEM.pa_num_tbl_type;
4114: l_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type;
4115: l_bl_rb_flag_chg_tbl SYSTEM.pa_varchar2_1_tbl_type;
4116: l_target_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

Line 4113: l_bill_override_rate_tbl SYSTEM.pa_num_tbl_type;

4109: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4110: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
4111: l_raw_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4112: l_burd_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4113: l_bill_override_rate_tbl SYSTEM.pa_num_tbl_type;
4114: l_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type;
4115: l_bl_rb_flag_chg_tbl SYSTEM.pa_varchar2_1_tbl_type;
4116: l_target_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
4117: l_prev_ra_id pa_resource_assignments.resource_assignment_id%TYPE;

Line 4114: l_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type;

4110: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
4111: l_raw_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4112: l_burd_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4113: l_bill_override_rate_tbl SYSTEM.pa_num_tbl_type;
4114: l_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type;
4115: l_bl_rb_flag_chg_tbl SYSTEM.pa_varchar2_1_tbl_type;
4116: l_target_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
4117: l_prev_ra_id pa_resource_assignments.resource_assignment_id%TYPE;
4118: l_temp_flag VARCHAR2(1);

Line 4119: l_init_quantity_tbl SYSTEM.pa_num_tbl_type;

4115: l_bl_rb_flag_chg_tbl SYSTEM.pa_varchar2_1_tbl_type;
4116: l_target_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
4117: l_prev_ra_id pa_resource_assignments.resource_assignment_id%TYPE;
4118: l_temp_flag VARCHAR2(1);
4119: l_init_quantity_tbl SYSTEM.pa_num_tbl_type;
4120: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
4121: l_temp NUMBER;
4122:
4123: /* Bug 5078538 --Added the out variables to avoid the uninitialized collection

Line 4127: l_quantity_out_tbl SYSTEM.pa_num_tbl_type;

4123: /* Bug 5078538 --Added the out variables to avoid the uninitialized collection
4124: error. Note that this error is caused when the same variables are passed as
4125: In and In Out parameters in a api call.
4126: */
4127: l_quantity_out_tbl SYSTEM.pa_num_tbl_type;
4128: l_txn_raw_cost_out_tbl SYSTEM.pa_num_tbl_type;
4129: l_txn_burdened_cost_out_tbl SYSTEM.pa_num_tbl_type;
4130: l_txn_revenue_out_tbl SYSTEM.pa_num_tbl_type;
4131:

Line 4128: l_txn_raw_cost_out_tbl SYSTEM.pa_num_tbl_type;

4124: error. Note that this error is caused when the same variables are passed as
4125: In and In Out parameters in a api call.
4126: */
4127: l_quantity_out_tbl SYSTEM.pa_num_tbl_type;
4128: l_txn_raw_cost_out_tbl SYSTEM.pa_num_tbl_type;
4129: l_txn_burdened_cost_out_tbl SYSTEM.pa_num_tbl_type;
4130: l_txn_revenue_out_tbl SYSTEM.pa_num_tbl_type;
4131:
4132: BEGIN

Line 4129: l_txn_burdened_cost_out_tbl SYSTEM.pa_num_tbl_type;

4125: In and In Out parameters in a api call.
4126: */
4127: l_quantity_out_tbl SYSTEM.pa_num_tbl_type;
4128: l_txn_raw_cost_out_tbl SYSTEM.pa_num_tbl_type;
4129: l_txn_burdened_cost_out_tbl SYSTEM.pa_num_tbl_type;
4130: l_txn_revenue_out_tbl SYSTEM.pa_num_tbl_type;
4131:
4132: BEGIN
4133:

Line 4130: l_txn_revenue_out_tbl SYSTEM.pa_num_tbl_type;

4126: */
4127: l_quantity_out_tbl SYSTEM.pa_num_tbl_type;
4128: l_txn_raw_cost_out_tbl SYSTEM.pa_num_tbl_type;
4129: l_txn_burdened_cost_out_tbl SYSTEM.pa_num_tbl_type;
4130: l_txn_revenue_out_tbl SYSTEM.pa_num_tbl_type;
4131:
4132: BEGIN
4133:
4134: x_msg_count := 0;

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

6045: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
6046: l_appr_cost_plan_type_flag pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;
6047: l_appr_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;
6048: l_struct_elem_version_id pa_proj_element_versions.element_version_id%TYPE;
6049: l_budget_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6050: l_src_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6051:
6052:
6053: /* Code addition for bug 2986930 starts */

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

6046: l_appr_cost_plan_type_flag pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;
6047: l_appr_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;
6048: l_struct_elem_version_id pa_proj_element_versions.element_version_id%TYPE;
6049: l_budget_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6050: l_src_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6051:
6052:
6053: /* Code addition for bug 2986930 starts */
6054: CURSOR c_ar_chk( p_source_ver_id pa_budget_versions.budget_version_id%TYPE) IS

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

6612: ,x_msg_data => l_msg_data );
6613:
6614: /* FP M - Reporting lines integration */
6615: l_budget_version_ids.delete;
6616: l_budget_version_ids := SYSTEM.pa_num_tbl_type(l_target_version_id);
6617:
6618: IF P_PA_DEBUG_MODE = 'Y' THEN
6619: pa_debug.write('Copy_Finplans_From_Project','Calling PJI_FM_XBS_ACCUM_MAINT.PLAN_CREATE ' ,5);
6620: pa_debug.write('Copy_Finplans_From_Project','p_fp_version_ids count '|| l_budget_version_ids.count(),5);

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

6627: END IF;
6628: END LOOP;
6629:
6630: l_src_budget_version_id_tbl.delete;
6631: l_src_budget_version_id_tbl := SYSTEM.pa_num_tbl_type(l_source_version_id);
6632: -- This parameter will be used when the source project is not equal to the target project.
6633: --This will be passed as null in the MSP flow other wise it will be defaulted to 'P'.
6634: Declare
6635: l_copy_mode VARCHAR2(1);

Line 8713: ,p_src_sv_ids_tbl IN SYSTEM.pa_num_tbl_type

8709: PROCEDURE copy_wp_budget_versions
8710: (
8711: p_source_project_id IN pa_proj_element_versions.project_id%TYPE
8712: ,p_target_project_id IN pa_proj_element_versions.element_version_id%TYPE
8713: ,p_src_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
8714: ,p_target_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
8715: ,p_copy_act_from_str_ids_tbl IN SYSTEM.pa_num_tbl_type -- bug 3847386
8716: ,p_copy_people_flag IN VARCHAR2
8717: ,p_copy_equip_flag IN VARCHAR2

Line 8714: ,p_target_sv_ids_tbl IN SYSTEM.pa_num_tbl_type

8710: (
8711: p_source_project_id IN pa_proj_element_versions.project_id%TYPE
8712: ,p_target_project_id IN pa_proj_element_versions.element_version_id%TYPE
8713: ,p_src_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
8714: ,p_target_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
8715: ,p_copy_act_from_str_ids_tbl IN SYSTEM.pa_num_tbl_type -- bug 3847386
8716: ,p_copy_people_flag IN VARCHAR2
8717: ,p_copy_equip_flag IN VARCHAR2
8718: ,p_copy_mat_item_flag IN VARCHAR2

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

8711: p_source_project_id IN pa_proj_element_versions.project_id%TYPE
8712: ,p_target_project_id IN pa_proj_element_versions.element_version_id%TYPE
8713: ,p_src_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
8714: ,p_target_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
8715: ,p_copy_act_from_str_ids_tbl IN SYSTEM.pa_num_tbl_type -- bug 3847386
8716: ,p_copy_people_flag IN VARCHAR2
8717: ,p_copy_equip_flag IN VARCHAR2
8718: ,p_copy_mat_item_flag IN VARCHAR2
8719: ,p_copy_fin_elem_flag IN VARCHAR2

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

8756: l_targ_elem_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
8757: */
8758:
8759:
8760: l_src_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8761: l_targ_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8762:
8763: -- ----------------------------------------------------------------------
8764:

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

8757: */
8758:
8759:
8760: l_src_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8761: l_targ_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8762:
8763: -- ----------------------------------------------------------------------
8764:
8765: l_copy_external_flag VARCHAR2(1);

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

8764:
8765: l_copy_external_flag VARCHAR2(1);
8766:
8767: --This table will be used in the PJI API call
8768: l_budget_version_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8769: l_src_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8770:
8771: --Cursor for getting the source and target element version ids. This will be used in calling the
8772: --Copy Planning Txn API

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

8765: l_copy_external_flag VARCHAR2(1);
8766:
8767: --This table will be used in the PJI API call
8768: l_budget_version_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8769: l_src_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8770:
8771: --Cursor for getting the source and target element version ids. This will be used in calling the
8772: --Copy Planning Txn API
8773: CURSOR l_prep_plan_txn_csr(c_source_plan_version_id pa_budget_versions.budget_version_id%TYPE

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

9054: -- FP M - Reporting lines integration. The create API is being called even before calling the copy
9055: --planning txn as the copy planning txn will take care of later calling the PJI plan update API for
9056: --the new budget lines created
9057: l_budget_version_ids.delete;
9058: l_budget_version_ids := SYSTEM.pa_num_tbl_type(l_targ_budget_version_id);
9059:
9060: l_src_budget_version_id_tbl.delete;
9061: l_src_budget_version_id_tbl := SYSTEM.pa_num_tbl_type(l_src_budget_version_id);
9062:

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

9057: l_budget_version_ids.delete;
9058: l_budget_version_ids := SYSTEM.pa_num_tbl_type(l_targ_budget_version_id);
9059:
9060: l_src_budget_version_id_tbl.delete;
9061: l_src_budget_version_id_tbl := SYSTEM.pa_num_tbl_type(l_src_budget_version_id);
9062:
9063: IF l_debug_mode = 'Y' THEN
9064: pa_debug.write(l_module_name,'Calling PJI_FM_XBS_ACCUM_MAINT.PLAN_CREATE ' ,5);
9065: pa_debug.write(l_module_name,'p_fp_version_ids count '|| l_budget_version_ids.count(),5);

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

9349: l_burden_cost_rate_override NUMBER;
9350:
9351: /* Initialized plsql tables for bug 3709036 */
9352:
9353: l_budget_line_idTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9354: l_quantityTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9355: l_raw_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9356: l_burdened_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9357: l_revenueTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;

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

9350:
9351: /* Initialized plsql tables for bug 3709036 */
9352:
9353: l_budget_line_idTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9354: l_quantityTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9355: l_raw_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9356: l_burdened_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9357: l_revenueTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9358: l_change_reason_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

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

9351: /* Initialized plsql tables for bug 3709036 */
9352:
9353: l_budget_line_idTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9354: l_quantityTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9355: l_raw_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9356: l_burdened_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9357: l_revenueTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9358: l_change_reason_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9359: l_descriptionTab SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

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

9352:
9353: l_budget_line_idTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9354: l_quantityTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9355: l_raw_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9356: l_burdened_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9357: l_revenueTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9358: l_change_reason_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9359: l_descriptionTab SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
9360: l_attribute_categoryTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

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

9353: l_budget_line_idTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9354: l_quantityTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9355: l_raw_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9356: l_burdened_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9357: l_revenueTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
9358: l_change_reason_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9359: l_descriptionTab SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
9360: l_attribute_categoryTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9361: l_attribute1Tab SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

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

9372: l_attribute12Tab SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
9373: l_attribute13Tab SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
9374: l_attribute14Tab SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
9375: l_attribute15Tab SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
9376: l_project_raw_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
9377: l_project_burdened_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
9378: l_project_revenueTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
9379: l_txn_currency_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9380: l_projfunc_currency_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

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

9373: l_attribute13Tab SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
9374: l_attribute14Tab SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
9375: l_attribute15Tab SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
9376: l_project_raw_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
9377: l_project_burdened_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
9378: l_project_revenueTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
9379: l_txn_currency_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9380: l_projfunc_currency_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9381: l_project_currency_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

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

9374: l_attribute14Tab SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
9375: l_attribute15Tab SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
9376: l_project_raw_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
9377: l_project_burdened_costTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
9378: l_project_revenueTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
9379: l_txn_currency_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9380: l_projfunc_currency_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9381: l_project_currency_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9382: l_end_dateTab SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE ();

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

10092: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10093: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10094: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10095:
10096: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10097: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10098: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10099: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10100:

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

10093: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10094: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10095:
10096: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10097: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10098: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10099: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10100:
10101: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

10094: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10095:
10096: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10097: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10098: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10099: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10100:
10101: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10102:

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

10095:
10096: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10097: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10098: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10099: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10100:
10101: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10102:
10103: CURSOR parent_plan_type_cur IS

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

10097: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10098: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10099: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10100:
10101: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10102:
10103: CURSOR parent_plan_type_cur IS
10104: SELECT pfo.proj_fp_options_id
10105: ,pfo.track_workplan_costs_flag

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

10388: AND resource_assignment_id = l_txn_source_id_tbl(i);
10389: END IF;
10390:
10391: -- populating the l_budget_version_id_tbl with p_budget_version_id
10392: l_budget_version_id_tbl := SYSTEM.pa_num_tbl_type(p_wp_version_id);
10393:
10394:
10395: END IF;
10396: