[Home] [Help]
28: l_calling_context varchar2(200);
29: l_fin_plan_version_id number;
30: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
31: --pa_fp_rollup_tmp
32: l_project_id pa_projects.project_id%type;
33: l_d_task_id NUMBER;
34: l_resource_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
35: l_msg_count NUMBER ;
36: l_msg_data VARCHAR2(2000);
56: l_currency_code_tbl system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
57: l_raw_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
58: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
59:
60: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
61:
62: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
63:
64: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
71: -- 10/22/04: To handle only lines after the progress as of date
72: l_finplan_line_count NUMBER := 1;
73:
74: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
75: l_project_name pa_projects_all.name%TYPE;
76:
77: --bug#13059417.changes starts here.
78: l_spread_curve_id pa_resource_assignments.spread_curve_id%TYPE;
79: l_sp_fixed_date DATE;
105: C_Get_res_info_rec C_Get_res_info%ROWTYPE;
106:
107: CURSOR C_Get_Budget_Version_Id(p_structure_version_id IN NUMBER, p_project_id IN NUMBER) is
108: select a.budget_version_id, b.project_currency_code
109: from pa_budget_versions a, pa_projects_all b
110: where a.project_structure_version_id = p_structure_version_id
111: and a.project_id = b.project_id
112: and a.project_id = p_project_id;
113:
241: ppfo.all_time_phased_code) time_phase_code
242: ,pbv.etc_start_date
243: FROM gl_sets_of_books gsb
244: ,pa_implementations_all pia
245: ,pa_projects_all ppa
246: ,pa_budget_versions pbv
247: ,pa_proj_fp_options ppfo
248: WHERE ppa.project_id = pbv.project_id
249: AND pbv.budget_version_id = ppfo.fin_plan_version_id
633: ,l_time_phased_code
634: ,l_etc_start_date;
635: CLOSE get_fp_options_csr;
636:
637: select name into l_project_name from pa_projects_all where project_id = l_project_id;
638:
639: FOR i in 1..l_count LOOP
640:
641: -- Bug 3866222: Initial period details
1541: ppfo.all_time_phased_code) time_phase_code
1542: ,glp.start_date period_start_date,glp.end_date period_end_date
1543: FROM gl_sets_of_books gsb
1544: ,pa_implementations_all pia
1545: ,pa_projects_all ppa
1546: ,pa_budget_versions pbv
1547: ,pa_proj_fp_options ppfo
1548: ,gl_periods glp
1549: WHERE ppa.project_id = pbv.project_id
1733: * as the task level assignment with ta_display_flag = 'N' if
1734: * rlm is not passed into the API.
1735: **********************************************************************/
1736: PROCEDURE Derive_Task_Assignments
1737: ( p_project_id IN PA_PROJECTS_ALL.project_id%TYPE
1738: ,p_extraction_type IN VARCHAR2 DEFAULT NULL -- Added for bug 13419867
1739: ,p_task_version_id IN PA_PROJ_ELEMENT_VERSIONS.element_version_id%TYPE
1740: ,p_scheduled_start IN DATE
1741: ,p_scheduled_end IN DATE
1817: and rownum = 1;
1818:
1819: CURSOR get_proj_cur_code IS
1820: SELECT project_currency_code
1821: FROM pa_projects_all
1822: where project_id = p_project_id;
1823:
1824: CURSOR check_none_resource_list(c_resource_list_id NUMBER) IS
1825: SELECT uncategorized_flag
2081:
2082:
2083: PROCEDURE Copy_Missing_Unplanned_Asgmts
2084: (
2085: p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
2086: p_old_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2087: p_new_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2088: p_new_budget_version_id IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE DEFAULT NULL,
2089: x_msg_count OUT NOCOPY NUMBER,