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

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 119: adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;

115: adl_rec.adl_status := 'A';
116: adl_rec.document_type := 'EXP';
117: adl_rec.billed_flag := 'N';
118: adl_rec.bill_hold_flag := x_flag ;
119: adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;
120: adl_rec.award_id := source_award_id ;
121: adl_rec.raw_cost := rev_rec.raw_cost;
122: adl_rec.last_update_date := rev_rec.last_update_date;
123: adl_rec.creation_date := rev_rec.creation_date;

Line 127: gms_awards_dist_pkg.create_adls(adl_rec);

123: adl_rec.creation_date := rev_rec.creation_date;
124: adl_rec.last_updated_by := rev_rec.last_updated_by;
125: adl_rec.created_by := rev_rec.created_by;
126: adl_rec.last_update_login := rev_rec.last_update_login;
127: gms_awards_dist_pkg.create_adls(adl_rec);
128: x_billable_flag := rev_rec.billable_flag; -- Bug 1756179
129: END LOOP;
130:
131: FOR new_rec IN new_item (x_expenditure_item_id) LOOP

Line 144: adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;

140: adl_rec.adl_status := 'A';
141: adl_rec.document_type := 'EXP';
142: adl_rec.billed_flag := 'N';
143: adl_rec.bill_hold_flag := x_flag ;
144: adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;
145: adl_rec.award_id := source_award_id;
146: adl_rec.raw_cost := new_rec.raw_cost;
147: adl_rec.last_update_date := new_rec.last_update_date;
148: adl_rec.creation_date := new_rec.creation_date;

Line 152: gms_awards_dist_pkg.create_adls(adl_rec);

148: adl_rec.creation_date := new_rec.creation_date;
149: adl_rec.last_updated_by := new_rec.last_updated_by;
150: adl_rec.created_by := new_rec.created_by;
151: adl_rec.last_update_login := new_rec.last_update_login;
152: gms_awards_dist_pkg.create_adls(adl_rec);
153: -- Start, Bug 1756179
154: update pa_expenditure_items_all
155: set billable_flag = x_billable_flag
156: where expenditure_item_id = new_rec.expenditure_item_id

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 593: adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;

589: adl_rec.adl_status := 'A';
590: adl_rec.document_type := 'EXP';
591: adl_rec.billed_flag := 'N';
592: adl_rec.bill_hold_flag := x_flag ;
593: adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;
594: adl_rec.award_id := SOURCE_AWARD_ID;
595: adl_rec.raw_cost := rev_rec.raw_cost;
596: adl_rec.last_update_date := rev_rec.last_update_date;
597: adl_rec.creation_date := rev_rec.creation_date;

Line 601: gms_awards_dist_pkg.create_adls(adl_rec);

597: adl_rec.creation_date := rev_rec.creation_date;
598: adl_rec.last_updated_by := rev_rec.last_updated_by;
599: adl_rec.created_by := rev_rec.created_by;
600: adl_rec.last_update_login := rev_rec.last_update_login;
601: gms_awards_dist_pkg.create_adls(adl_rec);
602: END LOOP;
603: END IF;
604:
605:

Line 623: adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;

619: adl_rec.adl_status := 'A';
620: adl_rec.document_type := 'EXP';
621: adl_rec.billed_flag := 'N';
622: adl_rec.bill_hold_flag := x_flag ;
623: adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;
624: adl_rec.award_id := DEST_AWARD_ID;
625: adl_rec.raw_cost := new_rec.raw_cost;
626: adl_rec.last_update_date := new_rec.last_update_date;
627: adl_rec.creation_date := new_rec.creation_date;

Line 631: gms_awards_dist_pkg.create_adls(adl_rec);

627: adl_rec.creation_date := new_rec.creation_date;
628: adl_rec.last_updated_by := new_rec.last_updated_by;
629: adl_rec.created_by := new_rec.created_by;
630: adl_rec.last_update_login := new_rec.last_update_login;
631: gms_awards_dist_pkg.create_adls(adl_rec);
632: END LOOP;
633: END IF;
634:
635: END LOOP;

Line 832: x_award_set_id := gms_awards_dist_pkg.get_award_set_id ;

828: RAISE invalid_award ; -- Bug 2368907, Added
829: -- return ; -- Bug 2368907, Commented
830: END IF ;
831:
832: x_award_set_id := gms_awards_dist_pkg.get_award_set_id ;
833: X_award_id := P_AWARD_ID ;
834: x_adl_rec.award_set_id := x_award_set_id ;
835: X_adl_rec.adl_line_num := 1 ;
836: X_adl_rec.project_id := X_project_id ;

Line 860: gms_error_pkg.gms_debug('GMS: Before call to gms_awards_dist_pkg.create_adl', 'C');

856: /* Commenting out NOCOPY the code below as it is not relevant here... bug 2596697
857: */ -- Commented out NOCOPY the code above as it is irrelevant. Bug 2596697
858:
859: IF L_DEBUG = 'Y' THEN
860: gms_error_pkg.gms_debug('GMS: Before call to gms_awards_dist_pkg.create_adl', 'C');
861: END IF;
862: gms_awards_dist_pkg.create_adls(x_adl_rec) ;
863:
864: IF L_DEBUG = 'Y' THEN

Line 862: gms_awards_dist_pkg.create_adls(x_adl_rec) ;

858:
859: IF L_DEBUG = 'Y' THEN
860: gms_error_pkg.gms_debug('GMS: Before call to gms_awards_dist_pkg.create_adl', 'C');
861: END IF;
862: gms_awards_dist_pkg.create_adls(x_adl_rec) ;
863:
864: IF L_DEBUG = 'Y' THEN
865: gms_error_pkg.gms_debug('GMS: After call to gms_awards_dist_pkg.create_adl', 'C');
866: END IF;

Line 865: gms_error_pkg.gms_debug('GMS: After call to gms_awards_dist_pkg.create_adl', 'C');

861: END IF;
862: gms_awards_dist_pkg.create_adls(x_adl_rec) ;
863:
864: IF L_DEBUG = 'Y' THEN
865: gms_error_pkg.gms_debug('GMS: After call to gms_awards_dist_pkg.create_adl', 'C');
866: END IF;
867:
868: EXCEPTION
869: WHEN invalid_award THEN -- Bug 2368907, Added

Line 889: x_award_set_id := gms_awards_dist_pkg.get_award_set_id ;

885: X_TXN_XFACE_ID NUMBER ;
886: X_award_id NUMBER ;
887: BEGIN
888: FOR LD_REC IN C_GOLD LOOP
889: x_award_set_id := gms_awards_dist_pkg.get_award_set_id ;
890: x_txn_xface_id := LD_REC.TXN_INTERFACE_ID ;
891: X_award_id := get_award_id( LD_REC.AWARD_ID, LD_REC.AWARD_NUMBER);
892: --LD_REC.AWARD_ID ; -- Bug 3221039
893: x_adl_rec.award_set_id := x_award_set_id ;

Line 919: gms_awards_dist_pkg.create_adls(x_adl_rec) ;

915:
916: /* Commenting the whole code below as it is not relevant for txns coming from LD distributions
917: **/ -- Commented all the above code as it is irrelevant bug 2596697
918:
919: gms_awards_dist_pkg.create_adls(x_adl_rec) ;
920:
921: -- bug : 3684711 UNABLE TO ENTER A REVERSAL BATCH GMS_AWARD_REQD
922: -- Create award distribution line for the reversal item.
923: IF ld_rec.period_end_accrual_flag = 'Y' and

Line 932: x_award_set_id := gms_awards_dist_pkg.get_award_set_id ;

928: from pa_expenditure_items_all ei
929: where ei.adjusted_expenditure_item_id = x_ei_id ;
930: IF SQL%FOUND THEN
931: x_adl_rec.raw_cost := X_raw_cost * -1 ;
932: x_award_set_id := gms_awards_dist_pkg.get_award_set_id ;
933: x_adl_rec.award_set_id := x_award_set_id ;
934: gms_awards_dist_pkg.create_adls(x_adl_rec) ;
935: END IF ;
936:

Line 934: gms_awards_dist_pkg.create_adls(x_adl_rec) ;

930: IF SQL%FOUND THEN
931: x_adl_rec.raw_cost := X_raw_cost * -1 ;
932: x_award_set_id := gms_awards_dist_pkg.get_award_set_id ;
933: x_adl_rec.award_set_id := x_award_set_id ;
934: gms_awards_dist_pkg.create_adls(x_adl_rec) ;
935: END IF ;
936:
937: END IF ;
938: -- end of bug : 3684711 Fix.

Line 1611: from GMS_AWARDS

1607: nvl(Preaward_Date,START_DATE_ACTIVE) preaward_date,
1608: End_Date_Active end_date,
1609: Close_Date close_date,
1610: Status
1611: from GMS_AWARDS
1612: where award_id = l_award_id;
1613:
1614: c_award_rec GET_VALID_AWARDS%ROWTYPE ;
1615: -- =========================================================================

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';