DBA Data[Home] [Help]

APPS.PA_BUDGET_PUB dependencies on PA_FIN_PLAN_AMOUNT_SETS

Line 5211: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;

5207: lx_revenue_flag VARCHAR2(1) := NULL;
5208: lx_cost_qty_flag VARCHAR2(1) := NULL;
5209: lx_revenue_qty_flag VARCHAR2(1) := NULL;
5210: lx_all_qty_flag VARCHAR2(1) := NULL;
5211: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
5212: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
5213: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
5214: l_allow_qty_flag VARCHAR2(1);
5215:

Line 5212: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;

5208: lx_cost_qty_flag VARCHAR2(1) := NULL;
5209: lx_revenue_qty_flag VARCHAR2(1) := NULL;
5210: lx_all_qty_flag VARCHAR2(1) := NULL;
5211: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
5212: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
5213: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
5214: l_allow_qty_flag VARCHAR2(1);
5215:
5216: l_msg_count NUMBER := 0;

Line 5213: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;

5209: lx_revenue_qty_flag VARCHAR2(1) := NULL;
5210: lx_all_qty_flag VARCHAR2(1) := NULL;
5211: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
5212: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
5213: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
5214: l_allow_qty_flag VARCHAR2(1);
5215:
5216: l_msg_count NUMBER := 0;
5217: l_msg_data VARCHAR2(2000);

Line 9562: -- l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;

9558: l_msg_index_out NUMBER;
9559:
9560: /*Commenting the old variables and adding new ones for bug 6408139*/
9561: /*Earlier they were not being used anywhere else, but now will be used */
9562: -- l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
9563: -- l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9564: -- l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
9565: lx_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
9566: lx_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;

Line 9563: -- l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;

9559:
9560: /*Commenting the old variables and adding new ones for bug 6408139*/
9561: /*Earlier they were not being used anywhere else, but now will be used */
9562: -- l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
9563: -- l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9564: -- l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
9565: lx_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
9566: lx_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9567: lx_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;

Line 9564: -- l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;

9560: /*Commenting the old variables and adding new ones for bug 6408139*/
9561: /*Earlier they were not being used anywhere else, but now will be used */
9562: -- l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
9563: -- l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9564: -- l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
9565: lx_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
9566: lx_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9567: lx_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
9568: l_using_resource_lists_flag VARCHAR2(1);

Line 9565: lx_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;

9561: /*Earlier they were not being used anywhere else, but now will be used */
9562: -- l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
9563: -- l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9564: -- l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
9565: lx_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
9566: lx_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9567: lx_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
9568: l_using_resource_lists_flag VARCHAR2(1);
9569: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 9566: lx_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;

9562: -- l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
9563: -- l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9564: -- l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
9565: lx_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
9566: lx_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9567: lx_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
9568: l_using_resource_lists_flag VARCHAR2(1);
9569: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
9570: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 9567: lx_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;

9563: -- l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9564: -- l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
9565: lx_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
9566: lx_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9567: lx_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
9568: l_using_resource_lists_flag VARCHAR2(1);
9569: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
9570: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
9571: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 9593: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

9589:
9590: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
9591: /*Added local variables for bug 6408139*/
9592: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
9593: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9594: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9595: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9596: l_proj_fp_options_id_new pa_proj_fp_options.proj_fp_options_id%TYPE;
9597:

Line 9594: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

9590: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
9591: /*Added local variables for bug 6408139*/
9592: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
9593: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9594: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9595: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9596: l_proj_fp_options_id_new pa_proj_fp_options.proj_fp_options_id%TYPE;
9597:
9598:

Line 9595: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

9591: /*Added local variables for bug 6408139*/
9592: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
9593: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9594: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9595: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9596: l_proj_fp_options_id_new pa_proj_fp_options.proj_fp_options_id%TYPE;
9597:
9598:
9599: /*Added local variables for Bug 6417360*/

Line 13288: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;

13284: lx_revenue_flag VARCHAR2(1) := NULL;
13285: lx_cost_qty_flag VARCHAR2(1) := NULL;
13286: lx_revenue_qty_flag VARCHAR2(1) := NULL;
13287: lx_all_qty_flag VARCHAR2(1) := NULL;
13288: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
13289: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
13290: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
13291: l_allow_qty_flag VARCHAR2(1);
13292:

Line 13289: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;

13285: lx_cost_qty_flag VARCHAR2(1) := NULL;
13286: lx_revenue_qty_flag VARCHAR2(1) := NULL;
13287: lx_all_qty_flag VARCHAR2(1) := NULL;
13288: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
13289: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
13290: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
13291: l_allow_qty_flag VARCHAR2(1);
13292:
13293: l_msg_count NUMBER := 0;

Line 13290: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;

13286: lx_revenue_qty_flag VARCHAR2(1) := NULL;
13287: lx_all_qty_flag VARCHAR2(1) := NULL;
13288: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
13289: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
13290: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
13291: l_allow_qty_flag VARCHAR2(1);
13292:
13293: l_msg_count NUMBER := 0;
13294: l_msg_data VARCHAR2(2000);

Line 17381: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17377: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17378: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17379: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17380: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17381: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17382: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17383: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17384: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17385: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17382: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17378: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17379: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17380: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17381: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17382: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17383: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17384: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17385: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17386: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17383: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17379: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17380: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17381: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17382: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17383: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17384: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17385: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17386: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17387: ,p_create_new_curr_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17384: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17380: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17381: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17382: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17383: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17384: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17385: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17386: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17387: ,p_create_new_curr_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17388: ,p_replace_current_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17385: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17381: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17382: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17383: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17384: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17385: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17386: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17387: ,p_create_new_curr_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17388: ,p_replace_current_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17389: ,p_using_resource_lists_flag IN VARCHAR2 DEFAULT 'N'

Line 17386: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17382: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17383: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17384: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17385: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17386: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17387: ,p_create_new_curr_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17388: ,p_replace_current_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17389: ,p_using_resource_lists_flag IN VARCHAR2 DEFAULT 'N'
17390: ,p_finplan_trans_tab IN pa_budget_pub.FinPlan_Trans_Tab

Line 17420: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

17416: l_task_number pa_tasks.task_number%TYPE;
17417: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
17418: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
17419: l_curr_work_version_id pa_budget_versions.budget_version_id%TYPE;
17420: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17421: l_struct_elem_version_id pa_proj_elem_ver_structure.element_version_id%TYPE;
17422: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17423: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17424: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

Line 17422: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

17418: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
17419: l_curr_work_version_id pa_budget_versions.budget_version_id%TYPE;
17420: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17421: l_struct_elem_version_id pa_proj_elem_ver_structure.element_version_id%TYPE;
17422: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17423: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17424: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17425: l_created_version_id pa_budget_versions.budget_version_id%TYPE;
17426: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

Line 17423: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

17419: l_curr_work_version_id pa_budget_versions.budget_version_id%TYPE;
17420: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17421: l_struct_elem_version_id pa_proj_elem_ver_structure.element_version_id%TYPE;
17422: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17423: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17424: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17425: l_created_version_id pa_budget_versions.budget_version_id%TYPE;
17426: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
17427: l_uncat_rlmid pa_resource_assignments.resource_list_member_id%TYPE;

Line 17424: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

17420: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17421: l_struct_elem_version_id pa_proj_elem_ver_structure.element_version_id%TYPE;
17422: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17423: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17424: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17425: l_created_version_id pa_budget_versions.budget_version_id%TYPE;
17426: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
17427: l_uncat_rlmid pa_resource_assignments.resource_list_member_id%TYPE;
17428: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;

Line 19156: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19152: ,P_PLAN_IN_MULTI_CURR_FLAG IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19153: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19154: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19155: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19156: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19157: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19158: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19159: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19160: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19157: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19153: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19154: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19155: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19156: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19157: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19158: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19159: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19160: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19161: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19158: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19154: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19155: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19156: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19157: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19158: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19159: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19160: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19161: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19162: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19159: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19155: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19156: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19157: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19158: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19159: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19160: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19161: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19162: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19163: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19160: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19156: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19157: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19158: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19159: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19160: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19161: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19162: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19163: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19164: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19161: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19157: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19158: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19159: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19160: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19161: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19162: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19163: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19164: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19165: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR