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 2306: gms_awards_all awd

2302: THEN
2303: select awd.award_id
2304: into l_award_id
2305: from gms_transaction_interface_all gti,
2306: gms_awards_all awd
2307: where gti.txn_interface_id = p_tran_item_id
2308: and NVL(gti.award_id, awd.award_id) = awd.award_id
2309: and NVL(gti.award_number, awd.award_number ) = awd.award_number
2310: and ( gti.award_id is NOT NULL OR gti.award_number is NOT NULL

Line 2391: l_award_status gms_awards_all.status%TYPE ;

2387: -- Expenditure Inquiry form.
2388: -- --------------------------------------------------------------------------
2389: 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
2390:
2391: l_award_status gms_awards_all.status%TYPE ;
2392: l_close_date gms_awards_all.close_date%TYPE ;
2393: l_project_id pa_projects_all.project_id%TYPE ;
2394:
2395: Begin

Line 2392: l_close_date gms_awards_all.close_date%TYPE ;

2388: -- --------------------------------------------------------------------------
2389: 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
2390:
2391: l_award_status gms_awards_all.status%TYPE ;
2392: l_close_date gms_awards_all.close_date%TYPE ;
2393: l_project_id pa_projects_all.project_id%TYPE ;
2394:
2395: Begin
2396:

Line 2399: from gms_award_distributions adl ,gms_awards_all aw

2395: Begin
2396:
2397: select aw.status, aw.close_date
2398: into l_award_status ,l_close_date
2399: from gms_award_distributions adl ,gms_awards_all aw
2400: where adl.expenditure_item_id = x_expenditure_item_id
2401: and adl.adl_status = 'A'
2402: and adl.document_type = nvl(x_doc_type, 'EXP') --Bug 5726575
2403: and adl.award_id = aw.award_id

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

2465: */
2466: FUNCTION VERT_GET_AWARD_NUMBER(
2467: p_expenditure_item_id IN PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE
2468: ) RETURN VARCHAR2 IS
2469: l_award_number GMS_AWARDS_ALL.AWARD_NUMBER%TYPE := NULL;
2470: BEGIN
2471: IF p_expenditure_item_id = G_EXPENDITURE_ITEM_ID THEN
2472: l_award_number := G_AWARD_NUMBER;
2473: ELSE

Line 2476: FROM gms_awards_all a

2472: l_award_number := G_AWARD_NUMBER;
2473: ELSE
2474: SELECT a.award_number
2475: INTO l_award_number
2476: FROM gms_awards_all a
2477: , gms_award_distributions adl
2478: WHERE adl.award_id = a.award_id
2479: AND adl.expenditure_item_id = p_expenditure_item_id
2480: AND adl.adl_line_num = 1

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

2497: If award range is specified, then the function returns 'N'.
2498: */
2499: FUNCTION VERT_IS_AWARD_WITHIN_RANGE(
2500: p_expenditure_item_id IN PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE
2501: ,p_from_award_number IN GMS_AWARDS_ALL.AWARD_NUMBER%TYPE DEFAULT NULL
2502: ,p_to_award_number IN GMS_AWARDS_ALL.AWARD_NUMBER%TYPE DEFAULT NULL
2503: ) RETURN VARCHAR2 IS
2504: l_award_number GMS_AWARDS_ALL.AWARD_NUMBER%TYPE := NULL;
2505: BEGIN

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

2498: */
2499: FUNCTION VERT_IS_AWARD_WITHIN_RANGE(
2500: p_expenditure_item_id IN PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE
2501: ,p_from_award_number IN GMS_AWARDS_ALL.AWARD_NUMBER%TYPE DEFAULT NULL
2502: ,p_to_award_number IN GMS_AWARDS_ALL.AWARD_NUMBER%TYPE DEFAULT NULL
2503: ) RETURN VARCHAR2 IS
2504: l_award_number GMS_AWARDS_ALL.AWARD_NUMBER%TYPE := NULL;
2505: BEGIN
2506: l_award_number := VERT_GET_AWARD_NUMBER(p_expenditure_item_id);

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

2500: p_expenditure_item_id IN PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE
2501: ,p_from_award_number IN GMS_AWARDS_ALL.AWARD_NUMBER%TYPE DEFAULT NULL
2502: ,p_to_award_number IN GMS_AWARDS_ALL.AWARD_NUMBER%TYPE DEFAULT NULL
2503: ) RETURN VARCHAR2 IS
2504: l_award_number GMS_AWARDS_ALL.AWARD_NUMBER%TYPE := NULL;
2505: BEGIN
2506: l_award_number := VERT_GET_AWARD_NUMBER(p_expenditure_item_id);
2507: IF l_award_number BETWEEN NVL(p_from_award_number,l_award_number) AND NVL(p_to_award_number,l_award_number) THEN
2508: RETURN 'Y';