DBA Data[Home] [Help]

APPS.PA_BUDGET_PUB dependencies on PA_FIN_PLAN_AMOUNT_SETS

Line 5101: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;

5097: lx_revenue_flag VARCHAR2(1) := NULL;
5098: lx_cost_qty_flag VARCHAR2(1) := NULL;
5099: lx_revenue_qty_flag VARCHAR2(1) := NULL;
5100: lx_all_qty_flag VARCHAR2(1) := NULL;
5101: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
5102: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
5103: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
5104: l_allow_qty_flag VARCHAR2(1);
5105:

Line 5102: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;

5098: lx_cost_qty_flag VARCHAR2(1) := NULL;
5099: lx_revenue_qty_flag VARCHAR2(1) := NULL;
5100: lx_all_qty_flag VARCHAR2(1) := NULL;
5101: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
5102: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
5103: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
5104: l_allow_qty_flag VARCHAR2(1);
5105:
5106: l_msg_count NUMBER := 0;

Line 5103: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;

5099: lx_revenue_qty_flag VARCHAR2(1) := NULL;
5100: lx_all_qty_flag VARCHAR2(1) := NULL;
5101: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
5102: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
5103: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
5104: l_allow_qty_flag VARCHAR2(1);
5105:
5106: l_msg_count NUMBER := 0;
5107: l_msg_data VARCHAR2(2000);

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

9375: l_msg_index_out NUMBER;
9376:
9377: /*Commenting the old variables and adding new ones for bug 6408139*/
9378: /*Earlier they were not being used anywhere else, but now will be used */
9379: -- l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
9380: -- l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9381: -- l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
9382: lx_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
9383: lx_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;

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

9376:
9377: /*Commenting the old variables and adding new ones for bug 6408139*/
9378: /*Earlier they were not being used anywhere else, but now will be used */
9379: -- l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
9380: -- l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9381: -- l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
9382: lx_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
9383: lx_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9384: lx_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;

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

9377: /*Commenting the old variables and adding new ones for bug 6408139*/
9378: /*Earlier they were not being used anywhere else, but now will be used */
9379: -- l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
9380: -- l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9381: -- l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
9382: lx_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
9383: lx_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9384: lx_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
9385: l_using_resource_lists_flag VARCHAR2(1);

Line 9382: lx_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;

9378: /*Earlier they were not being used anywhere else, but now will be used */
9379: -- l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
9380: -- l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9381: -- l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
9382: lx_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
9383: lx_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9384: lx_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
9385: l_using_resource_lists_flag VARCHAR2(1);
9386: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 9383: lx_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;

9379: -- l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
9380: -- l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9381: -- l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
9382: lx_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
9383: lx_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9384: lx_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
9385: l_using_resource_lists_flag VARCHAR2(1);
9386: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
9387: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 9384: lx_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;

9380: -- l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9381: -- l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
9382: lx_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
9383: lx_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9384: lx_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
9385: l_using_resource_lists_flag VARCHAR2(1);
9386: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
9387: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
9388: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 9410: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

9406:
9407: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
9408: /*Added local variables for bug 6408139*/
9409: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
9410: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9411: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9412: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9413: l_proj_fp_options_id_new pa_proj_fp_options.proj_fp_options_id%TYPE;
9414:

Line 9411: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

9407: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
9408: /*Added local variables for bug 6408139*/
9409: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
9410: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9411: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9412: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9413: l_proj_fp_options_id_new pa_proj_fp_options.proj_fp_options_id%TYPE;
9414:
9415:

Line 9412: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

9408: /*Added local variables for bug 6408139*/
9409: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
9410: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9411: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9412: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9413: l_proj_fp_options_id_new pa_proj_fp_options.proj_fp_options_id%TYPE;
9414:
9415:
9416: /*Added local variables for Bug 6417360*/

Line 13065: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;

13061: lx_revenue_flag VARCHAR2(1) := NULL;
13062: lx_cost_qty_flag VARCHAR2(1) := NULL;
13063: lx_revenue_qty_flag VARCHAR2(1) := NULL;
13064: lx_all_qty_flag VARCHAR2(1) := NULL;
13065: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
13066: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
13067: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
13068: l_allow_qty_flag VARCHAR2(1);
13069:

Line 13066: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;

13062: lx_cost_qty_flag VARCHAR2(1) := NULL;
13063: lx_revenue_qty_flag VARCHAR2(1) := NULL;
13064: lx_all_qty_flag VARCHAR2(1) := NULL;
13065: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
13066: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
13067: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
13068: l_allow_qty_flag VARCHAR2(1);
13069:
13070: l_msg_count NUMBER := 0;

Line 13067: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;

13063: lx_revenue_qty_flag VARCHAR2(1) := NULL;
13064: lx_all_qty_flag VARCHAR2(1) := NULL;
13065: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%type;
13066: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
13067: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
13068: l_allow_qty_flag VARCHAR2(1);
13069:
13070: l_msg_count NUMBER := 0;
13071: l_msg_data VARCHAR2(2000);

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

17118: ,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
17119: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17120: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17121: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17122: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17123: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17124: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17125: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17126: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

17119: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17120: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17121: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17122: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17123: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17124: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17125: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17126: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17127: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

17120: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17121: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17122: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17123: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17124: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17125: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17126: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17127: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17128: ,p_create_new_curr_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

17121: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17122: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17123: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17124: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17125: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17126: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17127: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17128: ,p_create_new_curr_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17129: ,p_replace_current_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

17122: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17123: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17124: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17125: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17126: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17127: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17128: ,p_create_new_curr_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17129: ,p_replace_current_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17130: ,p_using_resource_lists_flag IN VARCHAR2 DEFAULT 'N'

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

17123: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17124: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17125: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17126: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17127: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17128: ,p_create_new_curr_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17129: ,p_replace_current_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17130: ,p_using_resource_lists_flag IN VARCHAR2 DEFAULT 'N'
17131: ,p_finplan_trans_tab IN pa_budget_pub.FinPlan_Trans_Tab

Line 17161: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

17157: l_task_number pa_tasks.task_number%TYPE;
17158: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
17159: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
17160: l_curr_work_version_id pa_budget_versions.budget_version_id%TYPE;
17161: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17162: l_struct_elem_version_id pa_proj_elem_ver_structure.element_version_id%TYPE;
17163: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17164: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17165: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

Line 17163: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

17159: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
17160: l_curr_work_version_id pa_budget_versions.budget_version_id%TYPE;
17161: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17162: l_struct_elem_version_id pa_proj_elem_ver_structure.element_version_id%TYPE;
17163: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17164: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17165: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17166: l_created_version_id pa_budget_versions.budget_version_id%TYPE;
17167: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

Line 17164: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

17160: l_curr_work_version_id pa_budget_versions.budget_version_id%TYPE;
17161: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17162: l_struct_elem_version_id pa_proj_elem_ver_structure.element_version_id%TYPE;
17163: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17164: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17165: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17166: l_created_version_id pa_budget_versions.budget_version_id%TYPE;
17167: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
17168: l_uncat_rlmid pa_resource_assignments.resource_list_member_id%TYPE;

Line 17165: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

17161: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17162: l_struct_elem_version_id pa_proj_elem_ver_structure.element_version_id%TYPE;
17163: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17164: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17165: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17166: l_created_version_id pa_budget_versions.budget_version_id%TYPE;
17167: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
17168: l_uncat_rlmid pa_resource_assignments.resource_list_member_id%TYPE;
17169: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;

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

18867: ,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
18868: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18869: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18870: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18871: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18872: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18873: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18874: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18875: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18868: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18869: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18870: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18871: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18872: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18873: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18874: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18875: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18876: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18869: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18870: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18871: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18872: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18873: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18874: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18875: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18876: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18877: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18870: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18871: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18872: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18873: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18874: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18875: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18876: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18877: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18878: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18871: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18872: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18873: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18874: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18875: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18876: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18877: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18878: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18879: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18872: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18873: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18874: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18875: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18876: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18877: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18878: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18879: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18880: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR