APPS.MRP_VENDORMERGE_GRP dependencies on MRP_SOURCING_RULES

Line 28: l_sourcing_rule_name mrp_sourcing_rules.sourcing_rule_name%TYPE;

24: l_api_version CONSTANT NUMBER := 1.0;
25: l_row_count NUMBER;
26: TYPE t_sr_receipt_id IS TABLE OF mrp_sr_receipt_org.sr_receipt_id%TYPE;
27: l_sr_receipt_id t_sr_receipt_id;
28: l_sourcing_rule_name mrp_sourcing_rules.sourcing_rule_name%TYPE;
29:
30: CURSOR c1(receipt_id NUMBER) IS
31: SELECT SUM(allocation_percent) , rank
32: FROM mrp_sr_source_org

Line 124: UPDATE mrp_sourcing_rules

120: IF (l_row_count > 0) THEN
121: FOR j IN l_sr_receipt_id.FIRST..l_sr_receipt_id.LAST LOOP
122: FOR c1rec in c1(l_sr_receipt_id(j)) LOOP
123: IF c1%FOUND THEN
124: UPDATE mrp_sourcing_rules
125: SET planning_active = 2
126: WHERE sourcing_rule_id = ( SELECT sourcing_rule_id
127: FROM mrp_sr_receipt_org
128: WHERE sr_receipt_id = l_sr_receipt_id(j))