APPS.GMS_POR_API dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 39: po_req_distributions_all req

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'
43: and adl_line_num = 1

Line 155: po_req_distributions_all req

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'
159: and adl.adl_line_num = 1 ;

Line 700: from po_req_distributions_all

696: l_award_set_id NUMBER ;
697:
698: Cursor c_award_set_id is
699: select award_id
700: from po_req_distributions_all
701: where distribution_id = X_distribution_id ;
702:
703: BEGIN
704:

Line 822: gms_error_pkg.gms_debug (g_error_procedure_name||' Updating PO_REQ_DISTRIBUTIONS_ALL table','C');

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');
823: END IF;
824: --End for the bug 12901042
825:
826: UPDATE PO_REQ_DISTRIBUTIONS_ALL

Line 826: UPDATE PO_REQ_DISTRIBUTIONS_ALL

822: gms_error_pkg.gms_debug (g_error_procedure_name||' Updating PO_REQ_DISTRIBUTIONS_ALL table','C');
823: END IF;
824: --End for the bug 12901042
825:
826: UPDATE PO_REQ_DISTRIBUTIONS_ALL
827: SET award_id = x_adl_rec.award_set_id
828: where distribution_id = X_distribution_id ;
829:
830: x_award_set_id := x_adl_rec.award_set_id ;

Line 858: from po_req_distributions_all

854: l_award_set_id NUMBER ;
855:
856: Cursor c_award_set_id is
857: select award_id
858: from po_req_distributions_all
859: where distribution_id = X_distribution_id ;
860:
861: BEGIN
862:

Line 921: from po_req_distributions_all

917: x_award_set_id NUMBER ;
918:
919: Cursor c_award_set_id is
920: select award_id
921: from po_req_distributions_all
922: where distribution_id = X_distribution_id ;
923:
924: BEGIN
925:

Line 965: UPDATE PO_REQ_DISTRIBUTIONS_ALL

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
966: SET award_id = NULL
967: where distribution_id = X_distribution_id ;
968:
969: RETURN ;

Line 1011: from po_req_distributions_all

1007: x_award_set_id NUMBER ;
1008:
1009: Cursor c_award_set_id is
1010: select award_id
1011: from po_req_distributions_all
1012: where distribution_id = X_distribution_id ;
1013:
1014: BEGIN
1015: