13: return VARCHAR2 IS
14:
15: cursor c_award_number is
16: select award_number
17: from gms_awards_all
18: where award_id = X_award_id ;
19:
20: cursor c_adl_award is
21: select a.award_number
18: where award_id = X_award_id ;
19:
20: cursor c_adl_award is
21: select a.award_number
22: from gms_awards_all a,
23: gms_award_distributions adl
24: where adl.award_set_id = X_award_set_id
25: and adl_status = 'A'
26: and adl_line_num = 1
27: and adl.award_id = a.award_id ;
28:
29: cursor c_req_award is
30: select a.award_number
31: from gms_awards_all a,
32: gms_award_distributions adl ,
33: po_req_distributions_all req
34: where adl.award_set_id = req.award_id
35: and req.distribution_id = X_req_distribution_id
112: return NUMBER IS
113:
114: cursor c_award_id is
115: select award_id
116: from gms_awards_all
117: where award_number = X_award_number ;
118:
119: cursor c_adl_award is
120: select adl.award_id
270: select 'Y'
271: from dual
272: where exists
273: (select 1
274: from gms_awards
275: where award_number = X_award_number
276: and nvl(award_id,0) = nvl(l_award_id,0));
277: --Bug 2579915
278: Cursor valid_project_type_class is
415:
416: BEGIN
417: select award_id
418: into l_award_id
419: from gms_awards
420: where award_number = X_award_number;
421: EXCEPTION
422: When no_data_found then
423: l_award_id := 0 ;
562: x_adl_rec.adl_status := 'A';
563: x_adl_rec.document_type := 'REQ';
564: x_adl_rec.billed_flag := 'N';
565: x_adl_rec.bill_hold_flag := NULL ;
566: x_adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;
567: x_adl_rec.award_id := X_award_id;
568: x_adl_rec.raw_cost := 0;
569: x_adl_rec.last_update_date := SYSDATE;
570: x_adl_rec.creation_date := SYSDATE;
571: x_adl_rec.last_updated_by := 0;
572: x_adl_rec.created_by := 0;
573: x_adl_rec.last_update_login := 0;
574:
575: gms_awards_dist_pkg.create_adls(X_adl_rec);
576:
577: X_award_set_id := x_adl_rec.award_set_id ;
578: l_award_set_id := x_adl_rec.award_set_id ;
579: --db_pack_message('Account Gen : awsid '||X_event||' asid :'||NVL(X_award_set_id,0)) ;
664: x_adl_rec.adl_status := 'A';
665: x_adl_rec.document_type := 'REQ';
666: x_adl_rec.billed_flag := 'N';
667: x_adl_rec.bill_hold_flag := NULL ;
668: x_adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;
669: x_adl_rec.award_id := X_award_id;
670: x_adl_rec.raw_cost := NULL;
671: x_adl_rec.last_update_date := SYSDATE;
672: x_adl_rec.creation_date := SYSDATE;
676: X_adl_rec.distribution_id := X_distribution_id ;
677: --db_pack_message('When Insert Line Test :'||X_distribution_id) ;
678:
679:
680: gms_awards_dist_pkg.create_adls(X_adl_rec);
681:
682: UPDATE PO_REQ_DISTRIBUTIONS_ALL
683: SET award_id = x_adl_rec.award_set_id
684: where distribution_id = X_distribution_id ;
975: p_expenditure_type IN VARCHAR2,
976: p_status IN OUT NOCOPY VARCHAR2,
977: p_err_msg_label OUT NOCOPY VARCHAR2 )
978: AS
979: l_award_id gms_awards_all.award_id%TYPE:=p_award_id;
980: l_dummy NUMBER;
981: l_exp_type gms_allowable_expenditures.expenditure_type%TYPE;
982: l_msg_label VARCHAR2(50);
983: l_status VARCHAR2(1);
1004: FROM gms_funding_patterns gfp,
1005: gms_fp_distributions gfd,
1006: gms_allowable_expenditures gae,
1007: pa_tasks t,
1008: gms_awards ga
1009: WHERE t.task_id =p_task_id
1010: AND t.project_id =p_project_id
1011: AND gfp.project_id =p_project_id
1012: AND nvl(gfp.task_id,t.top_task_id ) =t.top_task_id
1247: l_award_qty_obj.award_id,
1248: l_award_qty_obj.quantity
1249: FROM gms_distribution_details awdd,
1250: gms_distributions awd,
1251: gms_awards_all a
1252: WHERE awd.document_distribution_id = awdd.document_distribution_id
1253: AND awd.document_header_id = awdd.document_header_id
1254: AND awd.document_distribution_id = l_distribution_id
1255: AND awd.document_header_id = l_doc_header_id