DBA Data[Home] [Help]

APPS.PO_CREATE_SR_ASL dependencies on MRP_SOURCING_RULES

Line 749: -- from mrp_sourcing_rules

745: --would be ignored.
746: --
747: -- select count(*)
748: -- into l_sr_name_count
749: -- from mrp_sourcing_rules
750: -- where sourcing_rule_name=p_sourcing_rule_name;
751: --
752: -- IF l_sr_name_count >0 THEN
753: -- l_error_message :=PO_CORE_S.get_translated_text('PO_SR_ASL_UNIQUE_RULE_NAME');

Line 1052: p_rule_name IN MRP_SOURCING_RULES.sourcing_rule_name%type,

1048: p_sourcing_level IN VARCHAR2,
1049: p_item_id IN MTL_SYSTEM_ITEMS.inventory_item_id%type,
1050: p_category_id IN MTL_ITEM_CATEGORIES.category_id%type,
1051: p_rel_gen_method IN PO_ASL_ATTRIBUTES.release_generation_method%type,
1052: p_rule_name IN MRP_SOURCING_RULES.sourcing_rule_name%type,
1053: p_rule_name_prefix IN VARCHAR2,
1054: p_start_date IN DATE,
1055: p_end_date IN DATE,
1056: p_assignment_set_id IN MRP_ASSIGNMENT_SETS.assignment_set_id%type,