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.

[Home] [Help]

APPS.GMS_BUDGET_PUB dependencies on GMS_AWARDS

Line 257: from gms_awards

253:
254: cursor l_award_id_csr(p_award_id_in NUMBER)
255: IS
256: select 'X'
257: from gms_awards
258: where award_id = p_award_id_in;
259:
260: cursor l_award_number_csr(p_award_number_in VARCHAR2)
261: is

Line 263: from gms_awards

259:
260: cursor l_award_number_csr(p_award_number_in VARCHAR2)
261: is
262: select award_id
263: from gms_awards
264: where award_number = p_award_number_in;
265:
266: l_dummy VARCHAR2(1);
267: l_old_stack VARCHAR2(630);

Line 912: gms_awards ga,

908: trunc(gi.start_date_active) start_date_active,
909: nvl(trunc(ga.preaward_date),trunc(gi.start_date_active)) start_date_active_preawd, -- for Bug: 1906414
910: trunc(gi.end_date_active) end_date_active
911: from gms_installments gi,
912: gms_awards ga,
913: gms_summary_project_fundings gspf
914: where gi.installment_id = gspf.installment_id
915: and ga.award_id = gi.award_id
916: and gi.award_id = x_award_id

Line 1770: -- that is passed in to fetch value of award_id from gms_awards table

1766: END IF;
1767:
1768: ----------------------------------------------------------------------------
1769: -- If award_id is passed in then use it otherwise use the award_number
1770: -- that is passed in to fetch value of award_id from gms_awards table
1771: -- If both are missing then raise an error.
1772:
1773: IF (p_award_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
1774: AND p_award_number IS NOT NULL)

Line 2456: l_award_number gms_awards_all.award_number%type ; /bug 3651888/

2452: p_award_id IN NUMBER,
2453: p_mark_as_original IN VARCHAR
2454: )
2455: IS
2456: l_award_number gms_awards_all.award_number%type ; /*bug 3651888*/
2457: l_org_id gms_awards_all.org_id%type ; /*bug 4864049 */
2458: begin
2459: /* Bug 3651888 */
2460: Select award_number ,org_id

Line 2457: l_org_id gms_awards_all.org_id%type ; /bug 4864049 /

2453: p_mark_as_original IN VARCHAR
2454: )
2455: IS
2456: l_award_number gms_awards_all.award_number%type ; /*bug 3651888*/
2457: l_org_id gms_awards_all.org_id%type ; /*bug 4864049 */
2458: begin
2459: /* Bug 3651888 */
2460: Select award_number ,org_id
2461: into l_award_number ,l_org_id

Line 2462: from gms_awards_all

2458: begin
2459: /* Bug 3651888 */
2460: Select award_number ,org_id
2461: into l_award_number ,l_org_id
2462: from gms_awards_all
2463: where award_id = p_award_id;
2464:
2465: --Bug 486404: Shared Service Enhancement :Set the ORG_ID context before invoking Concurrent programs
2466: FND_REQUEST.SET_ORG_ID(l_org_id);

Line 2523: from gms_awards_all

2519:
2520: /* Bug 3651888 */
2521: Select award_id
2522: into l_award_id
2523: from gms_awards_all
2524: where award_number = p_award_number;
2525:
2526: gms_budget_pub.baseline_budget( p_api_version_number => 1.0,
2527: x_err_code => l_err_code,

Line 2704: FROM gms_awards_v

2700:
2701: CURSOR l_award_csr(p_award_id IN NUMBER)
2702: IS
2703: SELECT award_number
2704: FROM gms_awards_v
2705: WHERE award_id = p_award_id;
2706:
2707: CURSOR l_project_csr(p_project_id IN NUMBER)
2708: IS

Line 2724: FROM gms_awards

2720: /*Fix for bug 5620089*/
2721: CURSOR l_wf_enabled_csr(p_award_id IN NUMBER)
2722: IS
2723: SELECT BUDGET_WF_ENABLED_FLAG
2724: FROM gms_awards
2725: WHERE award_id = p_award_id;
2726: /*End of fix for bug 5620089*/
2727:
2728: -- ROW LOCKING ---------------------------------------------------------------

Line 2847: -- that is passed in to fetch value of award_id from gms_awards table

2843: END IF;
2844:
2845: ----------------------------------------------------------------------------
2846: -- If award_id is passed in then use it otherwise use the award_number
2847: -- that is passed in to fetch value of award_id from gms_awards table
2848: -- If both are missing then raise an error.
2849:
2850: IF (p_award_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
2851: AND p_award_number IS NOT NULL)

Line 4312: -- that is passed in to fetch value of award_id from gms_awards table

4308: APP_EXCEPTION.RAISE_EXCEPTION;
4309: END IF;
4310: ----------------------------------------------------------------------------
4311: -- If award_id is passed in then use it otherwise use the award_number
4312: -- that is passed in to fetch value of award_id from gms_awards table
4313: -- If both are missing then raise an error.
4314:
4315: IF (p_award_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
4316: AND p_award_number IS NOT NULL)

Line 5234: -- that is passed in to fetch value of award_id from gms_awards table

5230: END IF;
5231:
5232: ----------------------------------------------------------------------------
5233: -- If award_id is passed in then use it otherwise use the award_number
5234: -- that is passed in to fetch value of award_id from gms_awards table
5235: -- If both are missing then raise an error.
5236:
5237: IF (p_award_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
5238: AND p_award_number IS NOT NULL)

Line 5693: -- that is passed in to fetch value of award_id from gms_awards table

5689: END IF;
5690:
5691: ----------------------------------------------------------------------------
5692: -- If award_id is passed in then use it otherwise use the award_number
5693: -- that is passed in to fetch value of award_id from gms_awards table
5694: -- If both are missing then raise an error.
5695:
5696: IF (p_award_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
5697: AND p_award_number IS NOT NULL)

Line 6469: -- that is passed in to fetch value of award_id from gms_awards table

6465: END IF;
6466:
6467: ----------------------------------------------------------------------------
6468: -- If award_id is passed in then use it otherwise use the award_number
6469: -- that is passed in to fetch value of award_id from gms_awards table
6470: -- If both are missing then raise an error.
6471:
6472: IF (p_award_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
6473: AND p_award_number IS NOT NULL)

Line 7155: -- that is passed in to fetch value of award_id from gms_awards table

7151: END IF;
7152:
7153: ----------------------------------------------------------------------------
7154: -- If award_id is passed in then use it otherwise use the award_number
7155: -- that is passed in to fetch value of award_id from gms_awards table
7156: -- If both are missing then raise an error.
7157:
7158: IF (p_award_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
7159: AND p_award_number IS NOT NULL)