81: WHERE ITEM_ID = x_item_id
82: ORDER BY start_date;
83:
84: CURSOR I1 is
85: SELECT MRP_SOURCING_RULES_S.NEXTVAL
86: FROM SYS.DUAL;
87:
88: CURSOR I2 is
89: SELECT MRP_SR_RECEIPT_ORG_S.NEXTVAL
223: x_progress := '100';
224: fnd_file.put_line(fnd_file.log, 'Creating sourcing rule. SOURCING_RULE_ID = '||x_sourcing_rule_id);
225: fnd_file.put_line(fnd_file.log, 'SOURCING_RULE_NAME = '||x_autosource_rule_name);
226:
227: INSERT INTO MRP_SOURCING_RULES(
228: sourcing_rule_id,
229: sourcing_rule_name,
230: status,
231: sourcing_rule_type,