DBA Data[Home] [Help]

APPS.WMS_STRATEGY_PVT dependencies on INV_QUANTITY_TREE_PVT

Line 13: -- Modified : 09/06/2008 Kbanddyo - [Added call to procedure INV_Quantity_Tree_PVT. release_lock

9: -- : 04/20/99 bitang modified
10: -- Modified : 05/17/02 Grao
11: -- Modified : 05/12/05 Grao - [Added code to handle rule_id instead of strategy_id from
12: -- rules workbench ]
13: -- Modified : 09/06/2008 Kbanddyo - [Added call to procedure INV_Quantity_Tree_PVT. release_lock
14: -- as part of bug fix 6867434]
15:
16: g_pkg_name constant varchar2(30) := 'WMS_Strategy_PVT';
17: -- API versions called within WMS_Strategy_PVT.Apply API

Line 19: g_qty_tree_api_version constant number := 1.0; -- INV_Quantity_Tree_PVT

15:
16: g_pkg_name constant varchar2(30) := 'WMS_Strategy_PVT';
17: -- API versions called within WMS_Strategy_PVT.Apply API
18: g_pp_rule_api_version constant number := 1.0; -- WMS_Rule_PVT
19: g_qty_tree_api_version constant number := 1.0; -- INV_Quantity_Tree_PVT
20:
21: --Procedures for logging messages
22: PROCEDURE log_event(
23: p_api_name VARCHAR2,

Line 365: x_tree_mode := INV_Quantity_Tree_PVT.g_transaction_mode;

361: -- Tree mode should be parameter for pp engine call ??!!
362: -- ER 7307189 changes start
363: /*
364: if p_type_code = 2 then
365: x_tree_mode := INV_Quantity_Tree_PVT.g_transaction_mode;
366: else
367: x_tree_mode := null;
368: end if;
369: */

Line 378: x_tree_mode := INV_Quantity_Tree_PVT.g_transaction_mode;

374:
375: if p_type_code= 2 and x_transaction_source_type_id=4 and l_transaction_action_id=2 then
376: x_tree_mode := INV_Quantity_Tree_PUB.g_no_lpn_rsvs_mode ;
377: elsif p_type_code = 2 then
378: x_tree_mode := INV_Quantity_Tree_PVT.g_transaction_mode;
379: else
380: x_tree_mode := null;
381: end if;
382:

Line 745: INV_Quantity_Tree_PVT.Create_Tree

741: log_event(l_api_name, 'create_tree',
742: 'Trying to create quantity tree in exclusive mode');
743: End if;
744:
745: INV_Quantity_Tree_PVT.Create_Tree
746: (
747: p_api_version_number => g_qty_tree_api_version
748: --,p_init_msg_list => fnd_api.g_false
749: ,x_return_status => x_return_status

Line 766: ,p_onhand_source => inv_quantity_tree_pvt.g_all_subs

762: ,p_demand_source_line_id => l_trx_source_line_id
763: ,p_demand_source_name => p_transaction_source_name
764: ,p_demand_source_delivery => p_trx_source_delivery_id
765: ,p_lot_expiration_date => sysdate
766: ,p_onhand_source => inv_quantity_tree_pvt.g_all_subs
767: ,p_exclusive => inv_quantity_tree_pvt.g_exclusive
768: ,p_pick_release => inv_quantity_tree_pvt.g_pick_release_yes
769: ,x_tree_id => x_tree_id
770: );

Line 767: ,p_exclusive => inv_quantity_tree_pvt.g_exclusive

763: ,p_demand_source_name => p_transaction_source_name
764: ,p_demand_source_delivery => p_trx_source_delivery_id
765: ,p_lot_expiration_date => sysdate
766: ,p_onhand_source => inv_quantity_tree_pvt.g_all_subs
767: ,p_exclusive => inv_quantity_tree_pvt.g_exclusive
768: ,p_pick_release => inv_quantity_tree_pvt.g_pick_release_yes
769: ,x_tree_id => x_tree_id
770: );
771: --

Line 768: ,p_pick_release => inv_quantity_tree_pvt.g_pick_release_yes

764: ,p_demand_source_delivery => p_trx_source_delivery_id
765: ,p_lot_expiration_date => sysdate
766: ,p_onhand_source => inv_quantity_tree_pvt.g_all_subs
767: ,p_exclusive => inv_quantity_tree_pvt.g_exclusive
768: ,p_pick_release => inv_quantity_tree_pvt.g_pick_release_yes
769: ,x_tree_id => x_tree_id
770: );
771: --
772: If (l_debug = 1) then

Line 1745: -- and INV_Quantity_Tree_PVT

1741: -- Previous version
1742: --
1743: -- Initial version 1.0
1744: -- Notes : calls API's of Wms_re_common_pvt, WMS_Rule_PVT
1745: -- and INV_Quantity_Tree_PVT
1746: -- This API must be called internally by
1747: -- WMS_Engine_PVT.Create_Suggestions only !
1748: -- End of comments
1749:

Line 2378: INV_Quantity_Tree_PVT. release_lock(

2374: , p_task_id => p_task_id
2375: ) ;
2376:
2377: --bug#6867434 start
2378: INV_Quantity_Tree_PVT. release_lock(
2379: p_api_version_number => g_qty_tree_api_version,
2380: p_init_msg_lst => fnd_api.g_false,
2381: x_return_status => x_return_status,
2382: x_msg_count => l_msg_count,