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 1598: from GMS_AWARDS

1594: nvl(Preaward_Date,START_DATE_ACTIVE) preaward_date,
1595: End_Date_Active end_date,
1596: Close_Date close_date,
1597: Status
1598: from GMS_AWARDS
1599: where award_id = l_award_id;
1600:
1601: c_award_rec GET_VALID_AWARDS%ROWTYPE ;
1602: -- =========================================================================

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