[Home] [Help]
538: -- budget lines with +ve amounts and new rbs element id again.
539: ---------2.Reporting lines API will NOT be called for the budget lines with start_date > etc_start_date. The
540: -- calling API should take care of these budget lines ( Calling this API with context 'DEL_FLAG_Y'
541: -- delete the reporting lines for budget lines with start_Date > etc_start_date)
542: -- 2. PA_FP_RA_MAP_TMP (This is the global temporary table which contains the resouce assignments in the source that
543: -- should copied. This is used for copying a version fully or some of the assignments in it ). This table is used
544: -- as the reference for deciding the budget lines for which reporting lines should be created
545: -- 3. PL-SQL : The source will be pl/sql if the pl/sql tables are populated. These pl/sql tables will be used in
546: -- populated the tmp table for calling the PJI Update API. This will be used in delete_planning_transactions
772: END IF;
773:
774: END IF;
775:
776: IF p_source ='PA_FP_RA_MAP_TMP' THEN
777:
778: IF l_debug_mode = 'Y' THEN
779: pa_debug.g_err_stage:='Selectiong from PA_FP_RA_MAP_TMP ';
780: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
775:
776: IF p_source ='PA_FP_RA_MAP_TMP' THEN
777:
778: IF l_debug_mode = 'Y' THEN
779: pa_debug.g_err_stage:='Selectiong from PA_FP_RA_MAP_TMP ';
780: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
781: END IF;
782:
783: INSERT INTO PJI_FM_EXTR_PLAN_LINES
845: FROM pa_projects_all p
846: ,pa_resource_assignments pra
847: ,pa_budget_versions pbv
848: ,pa_proj_fp_options pfo
849: ,pa_fp_ra_map_tmp tmp
850: ,pa_budget_lines pbl
851: WHERE p.project_id=pbv.project_id
852: AND pbv.budget_version_id=p_budget_version_id
853: AND pra.resource_assignment_id=tmp.target_res_assignment_id