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_WF_PKG dependencies on GMS_BUDGET_VERSIONS

Line 24: FROM gms_budget_versions

20: , p_budget_type_code VARCHAR2 )
21:
22: IS
23: SELECT budget_version_id
24: FROM gms_budget_versions
25: WHERE project_id = p_project_id
26: AND award_id = p_award_id
27: AND budget_type_code = p_budget_type_code
28: AND budget_status_code in ('S','W');

Line 316: -- p_pm_product_code - The PM vendor's product code stored in gms_budget_versions.

312: -- is requested.
313: -- p_award_id - Unique identifier for the award of the budget for which approval
314: -- is requested.
315: -- p_budget_type_code - Unique identifier for budget submitted for approval
316: -- p_pm_product_code - The PM vendor's product code stored in gms_budget_versions.
317: --
318: -- OUT NOCOPY Parameters
319: -- p_result - 'T' or 'F' (True/False)
320: -- p_err_code - Standard error code: 0, Success; x < 0, Unexpected Error;

Line 402: FROM gms_budget_versions

398:
399: CURSOR l_lock_budget_csr (p_project_id NUMBER, p_award_id NUMBER, p_budget_type_code VARCHAR2)
400: IS
401: SELECT 'x'
402: FROM gms_budget_versions
403: WHERE project_id = p_project_id
404: AND award_id = p_award_id
405: AND budget_type_code = p_budget_type_code
406: AND budget_status_code = 'S'

Line 480: UPDATE gms_budget_versions

476: CLOSE l_lock_budget_csr;
477:
478: -- UPDATE Draft Budget Version
479:
480: UPDATE gms_budget_versions
481: SET budget_status_code = 'W', WF_status_code = 'REJECTED'
482: WHERE project_id = l_project_id
483: AND award_id = l_award_id
484: AND budget_type_code = l_budget_type_code

Line 746: FROM gms_budget_versions v

742: -- Cursor for Verify_Budget_Rules
743: CURSOR l_budget_rules_csr(p_project_id NUMBER, p_award_id NUMBER, p_budget_type_code VARCHAR2)
744: IS
745: SELECT v.budget_version_id
746: FROM gms_budget_versions v
747: WHERE v.project_id = p_project_id
748: AND v.award_id = p_award_id
749: AND v.budget_type_code = p_budget_type_code
750: AND v.budget_status_code in ('S','W');

Line 764: l_mark_as_original gms_budget_versions.current_original_flag%TYPE;

760: l_warnings_only_flag VARCHAR2(1);
761: l_warnings_only VARCHAR2(1) := 'Y';
762: l_err_msg_count NUMBER := 0;
763: l_budget_version_id NUMBER;
764: l_mark_as_original gms_budget_versions.current_original_flag%TYPE;
765: l_resource_list_id NUMBER;
766: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
767:
768: l_msg_count NUMBER;

Line 1061: FROM gms_budget_versions

1057: , p_budget_type_code VARCHAR2 )
1058:
1059: IS
1060: SELECT MAX(budget_version_id)
1061: FROM gms_budget_versions
1062: WHERE project_id = p_project_id
1063: AND award_id = p_award_id
1064: AND budget_type_code = p_budget_type_code
1065: AND budget_status_code = 'B';

Line 1098: l_mark_as_original gms_budget_versions.current_original_flag%TYPE;

1094:
1095: l_warnings_only_flag VARCHAR2(1);
1096: l_warnings_only VARCHAR2(1) := 'Y';
1097: l_err_msg_count NUMBER;
1098: l_mark_as_original gms_budget_versions.current_original_flag%TYPE;
1099: l_resource_list_id NUMBER;
1100: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
1101:
1102: l_err_code NUMBER := 0;

Line 1492: FROM gms_budget_versions gbv,

1488: CURSOR l_time_phased_type_csr ( p_budget_version_id NUMBER)
1489: IS
1490: SELECT pbem.time_phased_type_code,
1491: pbem.entry_level_code
1492: FROM gms_budget_versions gbv,
1493: pa_budget_entry_methods pbem
1494: WHERE gbv.budget_version_id = p_budget_version_id
1495: AND gbv.budget_entry_method_code = pbem.budget_entry_method_code;
1496:

Line 1503: FROM gms_budget_versions gbv,

1499: CURSOR l_grp_resource_type_csr ( p_budget_version_id NUMBER)
1500: IS
1501: SELECT prl.group_resource_type_id,
1502: gbv.resource_list_id
1503: FROM gms_budget_versions gbv,
1504: pa_resource_lists prl
1505: WHERE gbv.budget_version_id = p_budget_version_id
1506: AND gbv.resource_list_id = prl.resource_list_id;
1507:

Line 1571: from gms_budget_versions bv,

1567: select bv.budget_version_id,
1568: bem.entry_level_code
1569: into l_prev_baselined_version_id,
1570: l_prev_entry_level_code
1571: from gms_budget_versions bv,
1572: pa_budget_entry_methods bem
1573: where bv.award_id = l_award_id
1574: and bv.project_id = l_project_id
1575: and bv.budget_type_code = l_budget_type_code

Line 1663: update gms_budget_versions

1659: --------------------------------------------------------------------------------------------------
1660:
1661: -- 1. set the current_flag = 'N' for the previously baselined budget.
1662:
1663: update gms_budget_versions
1664: set current_flag = 'N'
1665: where award_id = l_award_id
1666: and project_id = l_project_id
1667: and budget_type_code = l_budget_type_code

Line 1677: update gms_budget_versions

1673: -- 2. set the current_flag = 'Y' for the newly created budget.
1674:
1675: -- Corrected the query for Bug:2542827
1676:
1677: update gms_budget_versions
1678: set current_flag = 'Y'
1679: where budget_version_id = ( select max(budget_version_id)
1680: from gms_budget_versions
1681: where award_id = l_award_id

Line 1680: from gms_budget_versions

1676:
1677: update gms_budget_versions
1678: set current_flag = 'Y'
1679: where budget_version_id = ( select max(budget_version_id)
1680: from gms_budget_versions
1681: where award_id = l_award_id
1682: and project_id = l_project_id
1683: and budget_type_code = l_budget_type_code);
1684:

Line 1694: from gms_budget_versions

1690:
1691: begin
1692: select budget_version_id
1693: into l_baselined_version_id
1694: from gms_budget_versions
1695: where award_id = l_award_id
1696: and project_id = l_project_id
1697: and budget_type_code = l_budget_type_code
1698: and budget_status_code = 'B'

Line 1811: update gms_budget_versions

1807: if l_return_status <> 'S'
1808: then
1809: WF_CORE.CONTEXT('GMS_WF_PKG','FUNDS_CHECK', itemtype, itemkey, to_char(actid), funcmode);
1810: -- Bug 2386041
1811: update gms_budget_versions
1812: set current_flag = 'Y'
1813: where budget_version_id = l_prev_baselined_version_id;
1814:
1815: update gms_budget_versions

Line 1815: update gms_budget_versions

1811: update gms_budget_versions
1812: set current_flag = 'Y'
1813: where budget_version_id = l_prev_baselined_version_id;
1814:
1815: update gms_budget_versions
1816: set current_flag = 'N'
1817: where budget_version_id = l_baselined_version_id;
1818: RAISE FND_API.G_EXC_ERROR;
1819: -- Bug 2386041

Line 1825: update gms_budget_versions

1821:
1822:
1823: -- 5. set the budget_status_code = 'W' and wf_status_code = NULL for the budget that was 'Submitted'.
1824:
1825: update gms_budget_versions
1826: set budget_status_code = 'W',
1827: wf_status_code = NULL
1828: where award_id = l_award_id
1829: and project_id = l_project_id

Line 1870: update gms_budget_versions

1866: if l_err_code <> 0 then -- Checking for 0 (zero) instead of 'S' for Bug:2464800
1867:
1868: WF_CORE.CONTEXT('GMS_WF_PKG','FUNDS_CHECK', itemtype, itemkey, to_char(actid), funcmode);
1869: -- Bug 2386041
1870: update gms_budget_versions
1871: set current_flag = 'Y'
1872: where budget_version_id = l_prev_baselined_version_id;
1873:
1874: update gms_budget_versions

Line 1874: update gms_budget_versions

1870: update gms_budget_versions
1871: set current_flag = 'Y'
1872: where budget_version_id = l_prev_baselined_version_id;
1873:
1874: update gms_budget_versions
1875: set current_flag = 'N'
1876: where budget_version_id = l_baselined_version_id;
1877:
1878: RAISE FND_API.G_EXC_ERROR;

Line 1891: update gms_budget_versions

1887: then
1888: -- Budget Status is set to 'Submitted' and FC_MODE is set to 'B' since the Funds check process
1889: -- for baselining looks for budget_status_code = 'S' and FC_MODE = 'B'
1890:
1891: update gms_budget_versions
1892: set budget_status_code = 'S'
1893: where award_id = l_award_id
1894: and project_id = l_project_id
1895: and budget_type_code = l_budget_type_code

Line 1913: update gms_budget_versions

1909: -- if Funds check failed then the previously baselined budget (whose current_flag was set to 'R' earlier) should be restored
1910:
1911: if l_mode = 'B'
1912: then
1913: update gms_budget_versions
1914: set current_flag = 'Y'
1915: where award_id = l_award_id
1916: and project_id = l_project_id
1917: and budget_type_code = l_budget_type_code

Line 2036: update gms_budget_versions

2032: itemkey => itemkey,
2033: aname => 'FC_MODE',
2034: avalue => 'B');
2035:
2036: update gms_budget_versions
2037: set budget_status_code = 'S'
2038: where award_id = l_award_id
2039: and project_id = l_project_id
2040: and budget_type_code = l_budget_type_code