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_PA_API dependencies on GMS_AWARDS_ALL

Line 30: G_AWARD_NUMBER GMS_AWARDS_ALL.AWARD_NUMBER%TYPE := NULL; /* 5490120 */

26: -- This function returns the error x_error set by the GMS_PA_API.VERT_TRANSFER
27: -- ----------------------------------------------------------------------------
28:
29: G_EXPENDITURE_ITEM_ID PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE := NULL; /* 5490120 */
30: G_AWARD_NUMBER GMS_AWARDS_ALL.AWARD_NUMBER%TYPE := NULL; /* 5490120 */
31:
32: FUNCTION return_error return VARCHAR2 IS
33: begin
34: return x_error ;

Line 49: FROM gms_awards_all ga

45: X_award_id NUMBER ;
46:
47: CURSOR C_get_award_id IS
48: SELECT ga.award_id
49: FROM gms_awards_all ga
50: WHERE ((p_award_number IS NULL AND ga.award_id = NVL(p_award_id,0)) OR
51: (ga.award_number = p_award_number) );
52: BEGIN
53:

Line 240: from gms_awards_all

236: -- Fix start for bug : 2474576
237: CURSOR C_source_award(source_award_id IN NUMBER) IS
238: select status,allowable_schedule_id ,nvl(preaward_date, start_date_active) start_date_active ,
239: end_date_active,close_date
240: from gms_awards_all
241: where award_id = source_award_id ;
242: -- Fix start for bug : 2474576
243:
244: CURSOR C_AWARDS(dest_award_id IN NUMBER) IS

Line 247: from gms_awards_all

243:
244: CURSOR C_AWARDS(dest_award_id IN NUMBER) IS
245: select status,allowable_schedule_id ,nvl(preaward_date, start_date_active) start_date_active ,
246: end_date_active,close_date
247: from gms_awards_all
248: where award_id = dest_award_id ;
249:
250: CURSOR C_EXP(x_expenditure_item_id IN NUMBER ) IS
251: select expenditure_type,expenditure_item_date

Line 2357: gms_awards_all awd

2353: THEN
2354: select awd.award_id
2355: into l_award_id
2356: from gms_transaction_interface_all gti,
2357: gms_awards_all awd
2358: where gti.txn_interface_id = p_tran_item_id
2359: and NVL(gti.award_id, awd.award_id) = awd.award_id
2360: and NVL(gti.award_number, awd.award_number ) = awd.award_number
2361: and ( gti.award_id is NOT NULL OR gti.award_number is NOT NULL

Line 2442: l_award_status gms_awards_all.status%TYPE ;

2438: -- Expenditure Inquiry form.
2439: -- --------------------------------------------------------------------------
2440: FUNCTION is_award_closed (x_expenditure_item_id IN NUMBER ,x_task_id IN NUMBER ,x_doc_type in varchar2 default 'EXP') return VARCHAR2 IS --Bug 5726575
2441:
2442: l_award_status gms_awards_all.status%TYPE ;
2443: l_close_date gms_awards_all.close_date%TYPE ;
2444: l_project_id pa_projects_all.project_id%TYPE ;
2445:
2446: Begin

Line 2443: l_close_date gms_awards_all.close_date%TYPE ;

2439: -- --------------------------------------------------------------------------
2440: FUNCTION is_award_closed (x_expenditure_item_id IN NUMBER ,x_task_id IN NUMBER ,x_doc_type in varchar2 default 'EXP') return VARCHAR2 IS --Bug 5726575
2441:
2442: l_award_status gms_awards_all.status%TYPE ;
2443: l_close_date gms_awards_all.close_date%TYPE ;
2444: l_project_id pa_projects_all.project_id%TYPE ;
2445:
2446: Begin
2447:

Line 2450: from gms_award_distributions adl ,gms_awards_all aw

2446: Begin
2447:
2448: select aw.status, aw.close_date
2449: into l_award_status ,l_close_date
2450: from gms_award_distributions adl ,gms_awards_all aw
2451: where adl.expenditure_item_id = x_expenditure_item_id
2452: and adl.adl_status = 'A'
2453: and adl.document_type = nvl(x_doc_type, 'EXP') --Bug 5726575
2454: and adl.award_id = aw.award_id

Line 2520: l_award_number GMS_AWARDS_ALL.AWARD_NUMBER%TYPE := NULL;

2516: */
2517: FUNCTION VERT_GET_AWARD_NUMBER(
2518: p_expenditure_item_id IN PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE
2519: ) RETURN VARCHAR2 IS
2520: l_award_number GMS_AWARDS_ALL.AWARD_NUMBER%TYPE := NULL;
2521: BEGIN
2522: IF p_expenditure_item_id = G_EXPENDITURE_ITEM_ID THEN
2523: l_award_number := G_AWARD_NUMBER;
2524: ELSE

Line 2527: FROM gms_awards_all a

2523: l_award_number := G_AWARD_NUMBER;
2524: ELSE
2525: SELECT a.award_number
2526: INTO l_award_number
2527: FROM gms_awards_all a
2528: , gms_award_distributions adl
2529: WHERE adl.award_id = a.award_id
2530: AND adl.expenditure_item_id = p_expenditure_item_id
2531: AND adl.adl_line_num = 1

Line 2552: ,p_from_award_number IN GMS_AWARDS_ALL.AWARD_NUMBER%TYPE DEFAULT NULL

2548: If award range is specified, then the function returns 'N'.
2549: */
2550: FUNCTION VERT_IS_AWARD_WITHIN_RANGE(
2551: p_expenditure_item_id IN PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE
2552: ,p_from_award_number IN GMS_AWARDS_ALL.AWARD_NUMBER%TYPE DEFAULT NULL
2553: ,p_to_award_number IN GMS_AWARDS_ALL.AWARD_NUMBER%TYPE DEFAULT NULL
2554: ) RETURN VARCHAR2 IS
2555: l_award_number GMS_AWARDS_ALL.AWARD_NUMBER%TYPE := NULL;
2556: BEGIN

Line 2553: ,p_to_award_number IN GMS_AWARDS_ALL.AWARD_NUMBER%TYPE DEFAULT NULL

2549: */
2550: FUNCTION VERT_IS_AWARD_WITHIN_RANGE(
2551: p_expenditure_item_id IN PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE
2552: ,p_from_award_number IN GMS_AWARDS_ALL.AWARD_NUMBER%TYPE DEFAULT NULL
2553: ,p_to_award_number IN GMS_AWARDS_ALL.AWARD_NUMBER%TYPE DEFAULT NULL
2554: ) RETURN VARCHAR2 IS
2555: l_award_number GMS_AWARDS_ALL.AWARD_NUMBER%TYPE := NULL;
2556: BEGIN
2557: l_award_number := VERT_GET_AWARD_NUMBER(p_expenditure_item_id);

Line 2555: l_award_number GMS_AWARDS_ALL.AWARD_NUMBER%TYPE := NULL;

2551: p_expenditure_item_id IN PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE
2552: ,p_from_award_number IN GMS_AWARDS_ALL.AWARD_NUMBER%TYPE DEFAULT NULL
2553: ,p_to_award_number IN GMS_AWARDS_ALL.AWARD_NUMBER%TYPE DEFAULT NULL
2554: ) RETURN VARCHAR2 IS
2555: l_award_number GMS_AWARDS_ALL.AWARD_NUMBER%TYPE := NULL;
2556: BEGIN
2557: l_award_number := VERT_GET_AWARD_NUMBER(p_expenditure_item_id);
2558: IF l_award_number BETWEEN NVL(p_from_award_number,l_award_number) AND NVL(p_to_award_number,l_award_number) THEN
2559: RETURN 'Y';