APPS.GMS_AWARDS_DIST_PKG dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 892: FROM po_req_distributions_all rd,

888: rd.creation_date creation_date,
889: rd.last_updated_by last_updated_by,
890: rd.created_by created_by,
891: nvl(rd.last_update_login,0) last_update_login
892: FROM po_req_distributions_all rd,
893: po_requisition_lines_all rl,
894: pa_projects_all pp,
895: gms_project_types gpt
896: WHERE rl.requisition_header_id = p_header_id

Line 923: FROM po_req_distributions_all rd,

919: --
920:
921: SELECT adl2.award_set_id
922: bulk collect into l_dummy_tab
923: FROM po_req_distributions_all rd,
924: po_requisition_lines_all rl,
925: gms_award_distributions adl2
926: WHERE rl.requisition_header_id = p_header_id
927: AND rd.requisition_line_id = rl.requisition_line_id

Line 957: FROM po_req_distributions_all rd,

953: -- : Update statements were changed to bulk updates.
954: --
955: SELECT adl2.award_set_id
956: bulk collect into l_dummy_tab
957: FROM po_req_distributions_all rd,
958: po_requisition_lines_all rl,
959: gms_award_distributions adl2
960: WHERE rl.requisition_header_id = p_header_id
961: AND rd.requisition_line_id = rl.requisition_line_id

Line 992: FROM po_req_distributions_all rd2,

988: --
989:
990: SELECT rd2.distribution_id
991: bulk collect into l_dummy_tab
992: FROM po_req_distributions_all rd2,
993: po_requisition_lines_all rl,
994: pa_projects_all pp,
995: gms_project_types gpt
996: WHERE rl.requisition_header_id = p_header_id

Line 1006: UPDATE po_req_distributions_all rd

1002:
1003: IF l_dummy_tab.count > 0 THEN
1004:
1005: FORALL i in l_dummy_tab.FIRST..l_dummy_tab.LAST
1006: UPDATE po_req_distributions_all rd
1007: SET award_id = NULL
1008: WHERE rd.distribution_id = l_dummy_tab(i) ;
1009:
1010: END IF ;

Line 1123: UPDATE po_req_distributions_all

1119: -- Update REQ distribution with the award set id.
1120: -- End of comment.
1121:
1122: FORALL k in l_distribution_id.FIRST..l_distribution_id.LAST
1123: UPDATE po_req_distributions_all
1124: SET award_id = l_new_award_set_id(k)
1125: WHERE distribution_id = l_distribution_id(k);
1126:
1127: