APPS.WMS_STRATEGY_PVT dependencies on WMS_STRATEGY_MEMBERS

Line 502: l_rule_id WMS_STRATEGY_MEMBERS.RULE_ID%type;

498: ,p_strategy_id in number
499: ) is
500:
501: l_api_name VARCHAR2(30) := 'InitStrategyRules';
502: l_rule_id WMS_STRATEGY_MEMBERS.RULE_ID%type;
503: l_partial_success_allowed_flag
504: WMS_STRATEGY_MEMBERS.PARTIAL_SUCCESS_ALLOWED_FLAG%type;
505: l_rule_counter integer;
506: l_debug NUMBER;

Line 504: WMS_STRATEGY_MEMBERS.PARTIAL_SUCCESS_ALLOWED_FLAG%type;

500:
501: l_api_name VARCHAR2(30) := 'InitStrategyRules';
502: l_rule_id WMS_STRATEGY_MEMBERS.RULE_ID%type;
503: l_partial_success_allowed_flag
504: WMS_STRATEGY_MEMBERS.PARTIAL_SUCCESS_ALLOWED_FLAG%type;
505: l_rule_counter integer;
506: l_debug NUMBER;
507: --changed by jcearley on 12/8/99
508: --rules assigned to strategies can now be disabled, so we

Line 515: FROM wms_strategy_members wsm

511: CURSOR rules IS
512: SELECT wsm.rule_id
513: ,wsm.partial_success_allowed_flag
514: ,NVL(wsb.over_allocation_mode, 1) ,wsb.tolerance_value
515: FROM wms_strategy_members wsm
516: ,wms_strategies_b wsb
517: ,wms_rules_b wrb
518: WHERE wsm.strategy_id = p_strategy_id
519: AND wsb.strategy_id = p_strategy_id

Line 1720: -- WMS_STRATEGY_MEMBERS identified by parameter

1716: -- WMS_TRANSACTIONS_TEMP )
1717: -- strategy record in WMS_STRATEGIES_B uniquely identified by
1718: -- parameter p_strategy_id
1719: -- at least one strategy member record in
1720: -- WMS_STRATEGY_MEMBERS identified by parameter
1721: -- p_strategy_id
1722: -- Parameters :
1723: -- p_api_version in number required
1724: -- p_init_msg_list in varchar2 optional default = fnd_api.g_false

Line 1805: l_rule_id WMS_STRATEGY_MEMBERS.RULE_ID%type;

1801: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_NAME%type;
1802: l_transaction_type_id
1803: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_TYPE_ID%type;
1804:
1805: l_rule_id WMS_STRATEGY_MEMBERS.RULE_ID%type;
1806: l_partial_success_allowed_flag
1807: WMS_STRATEGY_MEMBERS.PARTIAL_SUCCESS_ALLOWED_FLAG%type;
1808: l_finished VARCHAR2(1);
1809: l_tree_mode NUMBER;

Line 1807: WMS_STRATEGY_MEMBERS.PARTIAL_SUCCESS_ALLOWED_FLAG%type;

1803: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_TYPE_ID%type;
1804:
1805: l_rule_id WMS_STRATEGY_MEMBERS.RULE_ID%type;
1806: l_partial_success_allowed_flag
1807: WMS_STRATEGY_MEMBERS.PARTIAL_SUCCESS_ALLOWED_FLAG%type;
1808: l_finished VARCHAR2(1);
1809: l_tree_mode NUMBER;
1810: l_tree_id NUMBER;
1811: l_msg_data VARCHAR2(240);