[Home] [Help]
803: set start_date= v_project_start_date,
804: end_date = v_project_completion_date
805: where resource_assignment_id in
806: (select resource_assignment_id
807: from gms_resource_assignments
808: where budget_version_id = x_dest_version_id)
809: and ((start_date <> v_project_start_date) OR (end_date <> v_project_completion_date));
810:
811: -- update for draft version
813: set start_date= v_project_start_date,
814: end_date = v_project_completion_date
815: where resource_assignment_id in
816: (select resource_assignment_id
817: from gms_resource_assignments
818: where budget_version_id = x_draft_version_id)
819: and ((start_date <> v_project_start_date) OR (end_date <> v_project_completion_date));
820:
821: -- Added check that rows should be updated only if the project start or end
833: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Calling gms_budget_utils.get_valid_period_dates','C');
834: END IF;
835:
836: for b1_rec in (select t.task_id, resource_assignment_id
837: from pa_tasks t , gms_resource_assignments r
838: where t.task_id = r.task_id
839: and r.budget_version_id = x_dest_version_id) loop
840:
841: -- Added the call to gms_budget_utils.get_valid_period_dates() for Bug: 2592747
878: END IF;
879:
880: --following loop is for draft version
881: for b2_rec in (select t.task_id, resource_assignment_id
882: from pa_tasks t , gms_resource_assignments r
883: where t.task_id = r.task_id
884: and r.budget_version_id = x_draft_version_id) loop
885:
886: -- Added the call to gms_budget_utils.get_valid_period_dates() for Bug: 2592747
1491: || '>' ;
1492:
1493: if (x_entry_level_code <> 'P') then
1494:
1495: insert into gms_resource_assignments
1496: (resource_assignment_id,
1497: budget_version_id,
1498: project_id,
1499: task_id,
1504: created_by,
1505: last_update_login,
1506: unit_of_measure,
1507: track_as_labor_flag)
1508: select gms_resource_assignments_s.nextval,
1509: x_dest_version_id,
1510: dt.project_id,
1511: dt.task_id,
1512: sa.resource_list_member_id,
1517: x_last_update_login,
1518: sa.unit_of_measure,
1519: sa.track_as_labor_flag
1520: from
1521: gms_resource_assignments sa,
1522: pa_tasks st,
1523: pa_tasks dt,
1524: gms_budget_versions dv
1525: where sa.budget_version_id = x_src_version_id
1530: and dv.budget_version_id = x_dest_version_id;
1531:
1532: else
1533:
1534: insert into gms_resource_assignments
1535: (resource_assignment_id,
1536: budget_version_id,
1537: project_id,
1538: task_id,
1543: created_by,
1544: last_update_login,
1545: unit_of_measure,
1546: track_as_labor_flag)
1547: select gms_resource_assignments_s.nextval,
1548: x_dest_version_id,
1549: dv.project_id,
1550: 0,
1551: sa.resource_list_member_id,
1556: x_last_update_login,
1557: sa.unit_of_measure,
1558: sa.track_as_labor_flag
1559: from
1560: gms_resource_assignments sa,
1561: gms_budget_versions dv
1562: where sa.budget_version_id = x_src_version_id
1563: and sa.task_id = 0
1564: and dv.budget_version_id = x_dest_version_id;
1570:
1571: for budget_line_row in
1572: (select l.resource_assignment_id, l.start_date, l.end_date,a.task_id
1573: from gms_budget_lines l,
1574: gms_resource_assignments a
1575: where a.budget_version_id = x_src_version_id
1576: and a.resource_assignment_id = l.resource_assignment_id
1577: ) loop
1578:
1719: 'B',
1720: 'B',
1721: 'B'
1722: from gms_budget_lines l,
1723: gms_resource_assignments sa,
1724: pa_tasks st,
1725: pa_tasks dt,
1726: gms_resource_assignments da
1727: where l.resource_assignment_id =
1722: from gms_budget_lines l,
1723: gms_resource_assignments sa,
1724: pa_tasks st,
1725: pa_tasks dt,
1726: gms_resource_assignments da
1727: where l.resource_assignment_id =
1728: budget_line_row.resource_assignment_id
1729: and l.start_date = budget_line_row.start_date
1730: and l.resource_assignment_id = sa.resource_assignment_id
1816: 'B',
1817: 'B',
1818: 'B'
1819: from gms_budget_lines l,
1820: gms_resource_assignments sa,
1821: gms_resource_assignments da
1822: where l.resource_assignment_id =
1823: budget_line_row.resource_assignment_id
1824: and l.start_date = budget_line_row.start_date
1817: 'B',
1818: 'B'
1819: from gms_budget_lines l,
1820: gms_resource_assignments sa,
1821: gms_resource_assignments da
1822: where l.resource_assignment_id =
1823: budget_line_row.resource_assignment_id
1824: and l.start_date = budget_line_row.start_date
1825: and l.resource_assignment_id = sa.resource_assignment_id
1858:
1859:
1860: CURSOR c_draft_details IS
1861: SELECT task_id,resource_list_member_id
1862: FROM gms_resource_assignments gra, gms_budget_lines gbl
1863: WHERE gra.resource_assignment_id = gbl.resource_assignment_id
1864: AND gra.budget_version_id = draft_bvid;
1865:
1866:
1872: AND gbv.budget_entry_method_code = pbem.budget_entry_method_code;
1873:
1874: CURSOR c_period_dates_draft IS
1875: SELECT MIN (start_date), MAX (end_date)
1876: FROM gms_resource_assignments gra, gms_budget_lines gbl
1877: WHERE gra.resource_assignment_id = gbl.resource_assignment_id
1878: AND gra.budget_version_id = draft_bvid;
1879:
1880: CURSOR c_period_dates_baselined IS
2063: BEGIN
2064:
2065: SELECT MIN (start_date), MAX (end_date)
2066: INTO x_pdb_start_date, x_pdb_end_date
2067: FROM gms_resource_assignments gra,
2068: gms_budget_versions gbv,
2069: gms_budget_lines gbl
2070: WHERE gbv.budget_version_id = gra.budget_version_id
2071: AND gbv.budget_version_id = x_version_id
2246: select gra.task_id,
2247: gra.resource_list_member_id,
2248: gbl.period_name,
2249: gbl.start_date
2250: from gms_resource_assignments gra,
2251: gms_budget_lines gbl
2252: where gbl.resource_assignment_id = gra.resource_assignment_id
2253: and gra.budget_version_id = p_budget_version_id
2254: and gbl.start_date between p_start_date and p_end_date;
2373: select rowid
2374: from gms_budget_lines l
2375: where l.resource_assignment_id in
2376: (select a.resource_assignment_id
2377: from gms_resource_assignments a
2378: where a.budget_version_id = x_version_id)
2379: and l.start_date between x_start_period_start_date and
2380: x_end_period_end_date) loop
2381: */
3263: x_err_stage := 'copy resource assignment <' || to_char(x_src_version_id)
3264: || '>' ;
3265:
3266: IF L_DEBUG = 'Y' THEN
3267: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.COPY_DRAFT_LINES- Inserting records into gms_resource_assignments','C');
3268: END IF;
3269:
3270:
3271: insert into gms_resource_assignments
3267: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.COPY_DRAFT_LINES- Inserting records into gms_resource_assignments','C');
3268: END IF;
3269:
3270:
3271: insert into gms_resource_assignments
3272: (resource_assignment_id,
3273: budget_version_id,
3274: project_id,
3275: task_id,
3280: created_by,
3281: last_update_login,
3282: unit_of_measure,
3283: track_as_labor_flag)
3284: select gms_resource_assignments_s.nextval,
3285: x_dest_version_id,
3286: s.project_id,
3287: s.task_id,
3288: s.resource_list_member_id,
3293: x_last_update_login,
3294: s.unit_of_measure,
3295: s.track_as_labor_flag
3296: from
3297: gms_resource_assignments s
3298: where s.budget_version_id = x_src_version_id;
3299:
3300:
3301: x_err_stage := 'copy budget lines <' ||to_char(x_src_version_id)
3382: 'B',
3383: 'B',
3384: 'B'
3385: from gms_budget_lines l,
3386: gms_resource_assignments sa,
3387: gms_resource_assignments da
3388: where l.resource_assignment_id = sa.resource_assignment_id
3389: and sa.budget_version_id = x_src_version_id
3390: and sa.task_id = da.task_id
3383: 'B',
3384: 'B'
3385: from gms_budget_lines l,
3386: gms_resource_assignments sa,
3387: gms_resource_assignments da
3388: where l.resource_assignment_id = sa.resource_assignment_id
3389: and sa.budget_version_id = x_src_version_id
3390: and sa.task_id = da.task_id
3391: and sa.project_id = da.project_id