APPS.WMS_STRATEGY_PVT dependencies on WMS_STRATEGY_MEMBERS

Line 511: l_rule_id WMS_STRATEGY_MEMBERS.RULE_ID%type;

507: ,p_strategy_id in number
508: ) is
509:
510: l_api_name VARCHAR2(30) := 'InitStrategyRules';
511: l_rule_id WMS_STRATEGY_MEMBERS.RULE_ID%type;
512: l_partial_success_allowed_flag
513: WMS_STRATEGY_MEMBERS.PARTIAL_SUCCESS_ALLOWED_FLAG%type;
514: l_rule_counter integer;
515: l_debug NUMBER;

Line 513: WMS_STRATEGY_MEMBERS.PARTIAL_SUCCESS_ALLOWED_FLAG%type;

509:
510: l_api_name VARCHAR2(30) := 'InitStrategyRules';
511: l_rule_id WMS_STRATEGY_MEMBERS.RULE_ID%type;
512: l_partial_success_allowed_flag
513: WMS_STRATEGY_MEMBERS.PARTIAL_SUCCESS_ALLOWED_FLAG%type;
514: l_rule_counter integer;
515: l_debug NUMBER;
516:
517: l_over_alloc_mode NUMBER; -- 8809951

Line 527: FROM wms_strategy_members wsm

523: CURSOR rules IS
524: SELECT wsm.rule_id
525: ,wsm.partial_success_allowed_flag
526: ,NVL(wsb.over_allocation_mode, 1) ,wsb.tolerance_value
527: FROM wms_strategy_members wsm
528: ,wms_strategies_b wsb
529: ,wms_rules_b wrb
530: WHERE wsm.strategy_id = p_strategy_id
531: AND wsb.strategy_id = p_strategy_id

Line 1875: -- WMS_STRATEGY_MEMBERS identified by parameter

1871: -- WMS_TRANSACTIONS_TEMP )
1872: -- strategy record in WMS_STRATEGIES_B uniquely identified by
1873: -- parameter p_strategy_id
1874: -- at least one strategy member record in
1875: -- WMS_STRATEGY_MEMBERS identified by parameter
1876: -- p_strategy_id
1877: -- Parameters :
1878: -- p_api_version in number required
1879: -- p_init_msg_list in varchar2 optional default = fnd_api.g_false

Line 1961: l_rule_id WMS_STRATEGY_MEMBERS.RULE_ID%type;

1957: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_NAME%type;
1958: l_transaction_type_id
1959: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_TYPE_ID%type;
1960:
1961: l_rule_id WMS_STRATEGY_MEMBERS.RULE_ID%type;
1962: l_partial_success_allowed_flag
1963: WMS_STRATEGY_MEMBERS.PARTIAL_SUCCESS_ALLOWED_FLAG%type;
1964: l_finished VARCHAR2(1);
1965: l_tree_mode NUMBER;

Line 1963: WMS_STRATEGY_MEMBERS.PARTIAL_SUCCESS_ALLOWED_FLAG%type;

1959: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_TYPE_ID%type;
1960:
1961: l_rule_id WMS_STRATEGY_MEMBERS.RULE_ID%type;
1962: l_partial_success_allowed_flag
1963: WMS_STRATEGY_MEMBERS.PARTIAL_SUCCESS_ALLOWED_FLAG%type;
1964: l_finished VARCHAR2(1);
1965: l_tree_mode NUMBER;
1966: l_tree_id NUMBER;
1967: l_msg_data VARCHAR2(240);