[Home] [Help]
170: l_api_name CONSTANT VARCHAR2(30) := 'create_draft_budget';
171: l_return_status VARCHAR2(1);
172:
173: l_project_id pa_projects_all.project_id%TYPE;
174: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
175: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
176: l_err_code NUMBER;
177: l_err_stage VARCHAR2(120);
178: l_err_stack VARCHAR2(630);
180: l_budget_line_in_rec pa_budget_pub.budget_line_in_rec_type;
181: l_budget_entry_method_rec pa_budget_entry_methods%rowtype;
182: l_budget_amount_code pa_budget_types.budget_amount_code%type;
183: l_description VARCHAR2(255);
184: l_resource_name pa_resource_lists_tl.Name%type;
185: l_dummy VARCHAR2(1);
186: l_attribute_category VARCHAR2(30);
187: l_attribute1 VARCHAR2(150);
188: l_attribute2 VARCHAR2(150);
233: l_replace_current_working_flag VARCHAR2(1);
234: l_allow_cost_budget_entry_flag VARCHAR2(1);
235: l_allow_rev_budget_entry_flag VARCHAR2(1);
236: p_multiple_task_msg VARCHAR2(1) := 'T';
237: l_resource_list_name pa_resource_lists_tl.Name%TYPE;
238: l_msg_count NUMBER := 0;
239: l_data VARCHAR2(2000);
240: l_msg_data VARCHAR2(2000);
241: l_msg_index_out NUMBER;
5180: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE := p_fin_plan_type_name;
5181: l_version_type pa_budget_versions.version_type%TYPE := p_version_type;
5182: l_budget_version_id NUMBER;
5183: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
5184: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
5185: l_budget_amount_code pa_budget_types.budget_amount_code%type;
5186: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
5187: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
5188: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
8104:
8105: CURSOR l_uncategorized_list_csr
8106: IS
8107: SELECT prlm.resource_list_member_id
8108: FROM pa_resource_lists prl
8109: , pa_resource_list_members prlm
8110: WHERE prl.resource_list_id = prlm.resource_list_id
8111: AND prl.uncategorized_flag='Y'
8112: and prlm.resource_class_code = 'FINANCIAL_ELEMENTS';
9296:
9297: CURSOR l_uncategorized_list_csr
9298: IS
9299: SELECT prlm.resource_list_member_id
9300: FROM pa_resource_lists prl
9301: , pa_resource_list_members prlm
9302: WHERE prl.resource_list_id = prlm.resource_list_id
9303: AND prl.uncategorized_flag='Y';
9304:
9308:
9309: CURSOR l_uncategorized_list_csr
9310: IS
9311: SELECT prlm.resource_list_member_id
9312: FROM pa_resource_lists prl
9313: , pa_resource_list_members prlm
9314: WHERE prl.resource_list_id = prlm.resource_list_id
9315: AND prl.uncategorized_flag='Y'
9316: and prlm.resource_class_code = 'FINANCIAL_ELEMENTS';
9441:
9442: CURSOR get_resource_list_name_csr(p_resource_list_id NUMBER)
9443: IS
9444: SELECT name
9445: FROM pa_resource_lists
9446: WHERE p_resource_list_id=p_resource_list_id;
9447:
9448: CURSOR get_status_code_csr(p_budget_version_id NUMBER)
9449: IS
9525: lx_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9526: lx_resource_list_id pa_budget_versions.resource_list_id%TYPE;
9527: lx_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
9528: lx_time_phased_type_code pa_proj_fp_options.cost_time_phased_code%TYPE;
9529: lx_resource_list_name pa_resource_lists_all_bg.Name%TYPE := null;
9530: lx_raw_cost_flag VARCHAR2(1) ;
9531: lx_burdened_cost_flag VARCHAR2(1);
9532: lx_revenue_flag VARCHAR2(1);
9533: lx_cost_qty_flag VARCHAR2(1);
11868: ,prlm.track_as_labor_flag
11869: INTO l_unit_of_measure
11870: ,l_track_as_labor_flag
11871: FROM pa_resources pr
11872: ,pa_resource_lists prl
11873: ,pa_resource_list_members prlm
11874: WHERE prl.resource_list_id = lx_resource_list_id -- bug 3453650
11875: AND pr.resource_id = prlm.resource_id
11876: AND prl.resource_list_id = prlm.resource_list_id
17370: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17371: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17372: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17373: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17374: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17375: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17376: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%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
17439: l_CW_record_version_number pa_budget_versions.record_version_number%TYPE;
17440: l_created_ver_rec_ver_num pa_budget_versions.record_version_number%TYPE;
17441:
17442: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;
17443: l_resource_list_name PA_RESOURCE_LISTS.NAME%TYPE;
17444: l_resource_list_id PA_RESOURCE_LISTS.resource_list_id%TYPE;
17445:
17446: l_description PA_BUDGET_VERSIONS.description%Type;
17447: l_attribute_category PA_BUDGET_VERSIONS.attribute_category%Type;
17440: l_created_ver_rec_ver_num pa_budget_versions.record_version_number%TYPE;
17441:
17442: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;
17443: l_resource_list_name PA_RESOURCE_LISTS.NAME%TYPE;
17444: l_resource_list_id PA_RESOURCE_LISTS.resource_list_id%TYPE;
17445:
17446: l_description PA_BUDGET_VERSIONS.description%Type;
17447: l_attribute_category PA_BUDGET_VERSIONS.attribute_category%Type;
17448: l_attribute1 PA_BUDGET_VERSIONS.attribute1%Type;
19145: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19146: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19147: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19148: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19149: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19150: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19151: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%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
19404: l_fin_plan_class_code varchar2(30);
19405: l_version_type pa_budget_versions.version_type%TYPE;
19406: l_budget_version_id NUMBER;
19407: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
19408: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
19409: l_budget_amount_code pa_budget_types.budget_amount_code%type;
19410: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
19411: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
19412: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;