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.

[Home] [Help]

APPS.GMS_POR_API dependencies on GMS_AWARDS

Line 23: from gms_awards_all

19: return VARCHAR2 IS
20:
21: cursor c_award_number is
22: select award_number
23: from gms_awards_all
24: where award_id = X_award_id ;
25:
26: cursor c_adl_award is
27: select a.award_number

Line 28: from gms_awards_all a,

24: where award_id = X_award_id ;
25:
26: cursor c_adl_award is
27: select a.award_number
28: from gms_awards_all a,
29: gms_award_distributions adl
30: where adl.award_set_id = X_award_set_id
31: and adl_status = 'A'
32: and adl_line_num = 1

Line 37: from gms_awards_all a,

33: and adl.award_id = a.award_id ;
34:
35: cursor c_req_award is
36: select a.award_number
37: from gms_awards_all a,
38: gms_award_distributions adl ,
39: po_req_distributions_all req
40: where adl.award_set_id = req.award_id
41: and req.distribution_id = X_req_distribution_id

Line 142: from gms_awards_all

138: return NUMBER IS
139:
140: cursor c_award_id is
141: select award_id
142: from gms_awards_all
143: where award_number = X_award_number ;
144:
145: cursor c_adl_award is
146: select adl.award_id

Line 331: from gms_awards

327: select 'Y'
328: from dual
329: where exists
330: (select 1
331: from gms_awards
332: where award_number = X_award_number
333: and nvl(award_id,0) = nvl(l_award_id,0));
334: --Bug 2579915
335: Cursor valid_project_type_class is

Line 486: from gms_awards

482:
483: BEGIN
484: select award_id
485: into l_award_id
486: from gms_awards
487: where award_number = X_award_number;
488: EXCEPTION
489: When no_data_found then
490: l_award_id := 0 ;

Line 657: x_adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;

653: x_adl_rec.adl_status := 'A';
654: x_adl_rec.document_type := 'REQ';
655: x_adl_rec.billed_flag := 'N';
656: x_adl_rec.bill_hold_flag := NULL ;
657: x_adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;
658: x_adl_rec.award_id := X_award_id;
659: x_adl_rec.raw_cost := 0;
660: x_adl_rec.last_update_date := SYSDATE;
661: x_adl_rec.creation_date := SYSDATE;

Line 666: gms_awards_dist_pkg.create_adls(X_adl_rec);

662: x_adl_rec.last_updated_by := 0;
663: x_adl_rec.created_by := 0;
664: x_adl_rec.last_update_login := 0;
665:
666: gms_awards_dist_pkg.create_adls(X_adl_rec);
667:
668: X_award_set_id := x_adl_rec.award_set_id ;
669: l_award_set_id := x_adl_rec.award_set_id ;
670: --db_pack_message('Account Gen : awsid '||X_event||' asid :'||NVL(X_award_set_id,0)) ;

Line 801: x_adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;

797: x_adl_rec.adl_status := 'A';
798: x_adl_rec.document_type := 'REQ';
799: x_adl_rec.billed_flag := 'N';
800: x_adl_rec.bill_hold_flag := NULL ;
801: x_adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;
802: x_adl_rec.award_id := X_award_id;
803: x_adl_rec.raw_cost := NULL;
804: x_adl_rec.last_update_date := SYSDATE;
805: x_adl_rec.creation_date := SYSDATE;

Line 814: gms_error_pkg.gms_debug (g_error_procedure_name||' Calling gms_awards_dist_pkg.create_adls','C');

810: --db_pack_message('When Insert Line Test :'||X_distribution_id) ;
811:
812: --Added debug messages for the bug 12901042
813: IF g_debug = 'Y' THEN
814: gms_error_pkg.gms_debug (g_error_procedure_name||' Calling gms_awards_dist_pkg.create_adls','C');
815: END IF;
816: --End for the bug 12901042
817:
818: gms_awards_dist_pkg.create_adls(X_adl_rec);

Line 818: gms_awards_dist_pkg.create_adls(X_adl_rec);

814: gms_error_pkg.gms_debug (g_error_procedure_name||' Calling gms_awards_dist_pkg.create_adls','C');
815: END IF;
816: --End for the bug 12901042
817:
818: gms_awards_dist_pkg.create_adls(X_adl_rec);
819:
820: --Added debug messages for the bug 12901042
821: IF g_debug = 'Y' THEN
822: gms_error_pkg.gms_debug (g_error_procedure_name||' Updating PO_REQ_DISTRIBUTIONS_ALL table','C');

Line 1182: l_award_id gms_awards_all.award_id%TYPE:=p_award_id;

1178: p_expenditure_type IN VARCHAR2,
1179: p_status IN OUT NOCOPY VARCHAR2,
1180: p_err_msg_label OUT NOCOPY VARCHAR2 )
1181: AS
1182: l_award_id gms_awards_all.award_id%TYPE:=p_award_id;
1183: l_dummy NUMBER;
1184: l_exp_type gms_allowable_expenditures.expenditure_type%TYPE;
1185: l_msg_label VARCHAR2(50);
1186: l_status VARCHAR2(1);

Line 1213: gms_awards ga

1209: FROM gms_funding_patterns gfp,
1210: gms_fp_distributions gfd,
1211: gms_allowable_expenditures gae,
1212: pa_tasks t,
1213: gms_awards ga
1214: WHERE t.task_id =p_task_id
1215: AND t.project_id =p_project_id
1216: AND gfp.project_id =p_project_id
1217: AND nvl(gfp.task_id,t.top_task_id ) =t.top_task_id

Line 1528: gms_awards_all a

1524: l_award_qty_obj.award_id,
1525: l_award_qty_obj.quantity
1526: FROM gms_distribution_details awdd,
1527: gms_distributions awd,
1528: gms_awards_all a
1529: WHERE awd.document_distribution_id = awdd.document_distribution_id
1530: AND awd.document_header_id = awdd.document_header_id
1531: AND awd.document_distribution_id = l_distribution_id
1532: AND awd.document_header_id = l_doc_header_id