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_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 1769: -- that is passed in to fetch value of award_id from gms_awards table

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

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

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

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

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

Line 2461: from gms_awards_all

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

Line 2522: from gms_awards_all

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

Line 2703: FROM gms_awards_v

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

Line 2723: FROM gms_awards

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

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

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

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

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

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

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

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

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

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

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

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

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