DBA Data[Home] [Help]

APPS.PO_ASL_UPGRADE_SV dependencies on MRP_SOURCING_RULES

Line 85: SELECT MRP_SOURCING_RULES_S.NEXTVAL

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

Line 227: INSERT INTO MRP_SOURCING_RULES(

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,