APPS.GMS_POR_API dependencies on GMS_AWARD_DISTRIBUTIONS

Line 29: gms_award_distributions adl

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
33: and adl.award_id = a.award_id ;

Line 38: gms_award_distributions adl ,

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
42: and adl_status = 'A'

Line 147: from gms_award_distributions adl

143: where award_number = X_award_number ;
144:
145: cursor c_adl_award is
146: select adl.award_id
147: from gms_award_distributions adl
148: where adl.award_set_id = X_award_set_id
149: and adl_status = 'A'
150: and adl_line_num = 1 ;
151:

Line 154: from gms_award_distributions adl ,

150: and adl_line_num = 1 ;
151:
152: cursor c_req_award is
153: select adl.award_id
154: from gms_award_distributions adl ,
155: po_req_distributions_all req
156: where adl.award_set_id = req.award_id
157: and req.distribution_id = X_req_distribution_id
158: and adl_status = 'A'

Line 588: x_adl_rec gms_award_distributions%ROWTYPE;

584: X_event IN VARCHAR2,
585: X_award_set_id IN OUT NOCOPY NUMBER,
586: X_status IN OUT NOCOPY varchar2 ) is
587:
588: x_adl_rec gms_award_distributions%ROWTYPE;
589: l_sponsored_flag varchar2(1) ;
590: l_award_set_id number ;
591: l_status varchar2(1) ;
592:

Line 627: delete from gms_award_distributions

623: END IF ;
624:
625: IF X_event = 'REMOVE' THEN
626:
627: delete from gms_award_distributions
628: where award_set_id = X_award_set_id ;
629:
630: RETURN ;
631: END IF ;

Line 765: x_adl_rec gms_award_distributions%ROWTYPE;

761: --X_raw_cost IN NUMBER,
762: X_award_set_id OUT NOCOPY NUMBER,
763: X_status IN OUT NOCOPY varchar2 ) is
764:
765: x_adl_rec gms_award_distributions%ROWTYPE;
766: BEGIN
767:
768: g_error_procedure_name := 'when_insert_line';
769:

Line 961: delete from gms_award_distributions

957:
958: ELSE
959: IF NOT IS_SPONSORED_PROJECT( X_project_id ) THEN
960:
961: delete from gms_award_distributions
962: where award_set_id = x_award_set_id
963: and adl_status = 'A' ;
964:
965: UPDATE PO_REQ_DISTRIBUTIONS_ALL

Line 972: update gms_award_distributions

968:
969: RETURN ;
970: END IF ;
971:
972: update gms_award_distributions
973: set project_id = X_project_id,
974: task_id = X_task_id,
975: award_id = X_award_id
976: where award_set_id = x_award_set_id

Line 1036: delete from gms_award_distributions

1032: close c_award_set_id ;
1033:
1034: IF NVL(x_award_set_id, 0) > 0 THEN
1035:
1036: delete from gms_award_distributions
1037: where award_set_id = x_award_set_id
1038: and adl_status = 'A' ;
1039:
1040: END IF ;

Line 1052: -- Function : Deletes a record from gms_award_distributions

1048: -- Start of comments
1049: -- API name : delete_adl
1050: -- Type : Public
1051: -- Pre-reqs : None.
1052: -- Function : Deletes a record from gms_award_distributions
1053: -- table.
1054: -- Parameters :
1055: -- IN : p_award_set_id IN NUMBER Required
1056: -- .

Line 1092: delete from gms_award_distributions

1088: END IF ;
1089:
1090: IF NVL(p_award_set_id, 0) > 0 THEN
1091:
1092: delete from gms_award_distributions
1093: where award_set_id = p_award_set_id
1094: and adl_status = 'A' ;
1095:
1096: IF SQL%NOTFOUND then