DBA Data[Home] [Help]

APPS.PO_CREATE_SR_ASL dependencies on MRP_SOURCING_RULES

Line 751: -- from mrp_sourcing_rules

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

Line 1054: p_rule_name IN MRP_SOURCING_RULES.sourcing_rule_name%type,

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