eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMS_BUDGET_CORE dependencies on GMS_BUDGET_LINES

Line 798: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Updating dates on gms_budget_lines','C');

794: p_budget_end_date_out => v_project_completion_date);
795:
796:
797: IF L_DEBUG = 'Y' THEN
798: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Updating dates on gms_budget_lines','C');
799: END IF;
800:
801: -- update for baselined version
802: update gms_budget_lines

Line 802: update gms_budget_lines

798: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Updating dates on gms_budget_lines','C');
799: END IF;
800:
801: -- update for baselined version
802: update gms_budget_lines
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

Line 812: update gms_budget_lines

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
812: update gms_budget_lines
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

Line 868: update gms_budget_lines

864: APP_EXCEPTION.RAISE_EXCEPTION;
865:
866: end if;
867:
868: update gms_budget_lines
869: set start_date = x_budget_start_date,
870: end_date = x_budget_end_date
871: where resource_assignment_id = b1_rec.resource_assignment_id
872: and ((start_date <> x_budget_start_date) or (end_date <> x_budget_end_date));

Line 913: update gms_budget_lines

909: APP_EXCEPTION.RAISE_EXCEPTION;
910:
911: end if;
912:
913: update gms_budget_lines
914: set start_date = x_budget_start_date,
915: end_date = x_budget_end_date
916: where resource_assignment_id = b2_rec.resource_assignment_id
917: and ((start_date <> x_budget_start_date) or (end_date <> x_budget_end_date));

Line 1573: from gms_budget_lines l,

1569: || '>' ;
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

Line 1645: insert into gms_budget_lines

1641:
1642:
1643: if (x_entry_level_code <> 'P') then
1644:
1645: insert into gms_budget_lines
1646: (resource_assignment_id,
1647: start_date,
1648: last_update_date,
1649: last_updated_by,

Line 1722: from gms_budget_lines l,

1718: 'B',
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

Line 1742: insert into gms_budget_lines

1738: and da.budget_version_id = x_dest_version_id;
1739:
1740: else
1741:
1742: insert into gms_budget_lines
1743: (resource_assignment_id,
1744: start_date,
1745: last_update_date,
1746: last_updated_by,

Line 1819: from gms_budget_lines l,

1815: 'B',
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

Line 1862: FROM gms_resource_assignments gra, gms_budget_lines gbl

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:

Line 1876: FROM gms_resource_assignments gra, gms_budget_lines gbl

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

Line 2069: gms_budget_lines gbl

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
2072: AND gra.resource_assignment_id = gbl.resource_assignment_id
2073: GROUP BY gbv.budget_version_id;

Line 2251: gms_budget_lines gbl

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;
2255:

Line 2374: from gms_budget_lines l

2370: || '>';
2371:
2372: /* for bl_rec in (
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)

Line 3305: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.COPY_DRAFT_LINES- Inserting records into gms_budget_lines','C');

3301: x_err_stage := 'copy budget lines <' ||to_char(x_src_version_id)
3302: || '>' ;
3303:
3304: IF L_DEBUG = 'Y' THEN
3305: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.COPY_DRAFT_LINES- Inserting records into gms_budget_lines','C');
3306: END IF;
3307:
3308: insert into gms_budget_lines
3309: (resource_assignment_id,

Line 3308: insert into gms_budget_lines

3304: IF L_DEBUG = 'Y' THEN
3305: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.COPY_DRAFT_LINES- Inserting records into gms_budget_lines','C');
3306: END IF;
3307:
3308: insert into gms_budget_lines
3309: (resource_assignment_id,
3310: start_date,
3311: last_update_date,
3312: last_updated_by,

Line 3385: from gms_budget_lines l,

3381: 'B',
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