APPS.GMS_AWARDS_DIST_PKG dependencies on PO_REQ_DISTRIBUTIONS

Line 298: update po_req_distributions

294:
295:
296: NULL ;
297: ELSIF p_doc_type = 'REQ' THEN -- Bug 2155774
298: update po_req_distributions
299: set award_id = x_new_award_set_id
300: where distribution_id = p_dist_id
301: and award_id = p_award_set_id
302: and exists ( select 'X'

Line 872: FROM po_req_distributions_all rd,

868: rd.creation_date creation_date,
869: rd.last_updated_by last_updated_by,
870: rd.created_by created_by,
871: nvl(rd.last_update_login,0) last_update_login
872: FROM po_req_distributions_all rd,
873: po_requisition_lines_all rl,
874: pa_projects_all pp,
875: gms_project_types gpt
876: WHERE rl.requisition_header_id = p_header_id

Line 903: FROM po_req_distributions_all rd,

899: --
900:
901: SELECT adl2.award_set_id
902: bulk collect into l_dummy_tab
903: FROM po_req_distributions_all rd,
904: po_requisition_lines_all rl,
905: gms_award_distributions adl2
906: WHERE rl.requisition_header_id = p_header_id
907: AND rd.requisition_line_id = rl.requisition_line_id

Line 937: FROM po_req_distributions_all rd,

933: -- : Update statements were changed to bulk updates.
934: --
935: SELECT adl2.award_set_id
936: bulk collect into l_dummy_tab
937: FROM po_req_distributions_all rd,
938: po_requisition_lines_all rl,
939: gms_award_distributions adl2
940: WHERE rl.requisition_header_id = p_header_id
941: AND rd.requisition_line_id = rl.requisition_line_id

Line 972: FROM po_req_distributions_all rd2,

968: --
969:
970: SELECT rd2.distribution_id
971: bulk collect into l_dummy_tab
972: FROM po_req_distributions_all rd2,
973: po_requisition_lines_all rl,
974: pa_projects_all pp,
975: gms_project_types gpt
976: WHERE rl.requisition_header_id = p_header_id

Line 986: UPDATE po_req_distributions_all rd

982:
983: IF l_dummy_tab.count > 0 THEN
984:
985: FORALL i in l_dummy_tab.FIRST..l_dummy_tab.LAST
986: UPDATE po_req_distributions_all rd
987: SET award_id = NULL
988: WHERE rd.distribution_id = l_dummy_tab(i) ;
989:
990: END IF ;

Line 1103: UPDATE po_req_distributions_all

1099: -- Update REQ distribution with the award set id.
1100: -- End of comment.
1101:
1102: FORALL k in l_distribution_id.FIRST..l_distribution_id.LAST
1103: UPDATE po_req_distributions_all
1104: SET award_id = l_new_award_set_id(k)
1105: WHERE distribution_id = l_distribution_id(k);
1106:
1107: