APPS.GMS_POR_API dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 33: po_req_distributions_all req

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
36: and adl_status = 'A'
37: and adl_line_num = 1

Line 129: po_req_distributions_all req

125:
126: cursor c_req_award is
127: select adl.award_id
128: from gms_award_distributions adl ,
129: po_req_distributions_all req
130: where adl.award_set_id = req.award_id
131: and req.distribution_id = X_req_distribution_id
132: and adl_status = 'A'
133: and adl.adl_line_num = 1 ;

Line 598: from po_req_distributions_all

594: l_award_set_id NUMBER ;
595:
596: Cursor c_award_set_id is
597: select award_id
598: from po_req_distributions_all
599: where distribution_id = X_distribution_id ;
600:
601: BEGIN
602: -- ==============================================================

Line 682: UPDATE PO_REQ_DISTRIBUTIONS_ALL

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 ;
685:
686: x_award_set_id := x_adl_rec.award_set_id ;

Line 709: from po_req_distributions_all

705: l_award_set_id NUMBER ;
706:
707: Cursor c_award_set_id is
708: select award_id
709: from po_req_distributions_all
710: where distribution_id = X_distribution_id ;
711:
712: BEGIN
713:

Line 759: from po_req_distributions_all

755: x_award_set_id NUMBER ;
756:
757: Cursor c_award_set_id is
758: select award_id
759: from po_req_distributions_all
760: where distribution_id = X_distribution_id ;
761:
762: BEGIN
763: -- ==============================================================

Line 796: UPDATE PO_REQ_DISTRIBUTIONS_ALL

792: delete from gms_award_distributions
793: where award_set_id = x_award_set_id
794: and adl_status = 'A' ;
795:
796: UPDATE PO_REQ_DISTRIBUTIONS_ALL
797: SET award_id = NULL
798: where distribution_id = X_distribution_id ;
799:
800: RETURN ;

Line 836: from po_req_distributions_all

832: x_award_set_id NUMBER ;
833:
834: Cursor c_award_set_id is
835: select award_id
836: from po_req_distributions_all
837: where distribution_id = X_distribution_id ;
838:
839: BEGIN
840: -- ==============================================================