APPS.INV_QUANTITY_TREE_PVT dependencies on INV_QUANTITY_TREE_PVT

Line 1: PACKAGE BODY inv_quantity_tree_pvt as

1: PACKAGE BODY inv_quantity_tree_pvt as
2: /* $Header: INVVQTTB.pls 120.61.12020000.15 2013/04/26 11:04:37 brana ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_Quantity_Tree_PVT';
5: g_is_lot_control BOOLEAN := FALSE;

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_Quantity_Tree_PVT';

1: PACKAGE BODY inv_quantity_tree_pvt as
2: /* $Header: INVVQTTB.pls 120.61.12020000.15 2013/04/26 11:04:37 brana ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_Quantity_Tree_PVT';
5: g_is_lot_control BOOLEAN := FALSE;
6:
7: --
8: -- synonyms used in this program

Line 335: inv_log_util.trace(p_message, 'INV_QUANTITY_TREE_PVT', p_level);

331: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
332: END IF;
333:
334: IF (g_debug = 1) THEN
335: inv_log_util.trace(p_message, 'INV_QUANTITY_TREE_PVT', p_level);
336: END IF;
337: END;
338:
339: --------------------------------------------------

Line 1081: IF (inv_quantity_tree_pvt.g_is_mat_status_used = 2) THEN

1077: x_return_status := l_return_status;
1078:
1079: ELSE
1080:
1081: IF (inv_quantity_tree_pvt.g_is_mat_status_used = 2) THEN
1082: --Bug 4587505. The value returned from here is used to set the is_reservable_sub property of the node
1083: --and for any node that is higher than subinventory(for example LOT node), the is_reservable_sub should
1084: --be set to TRUE, when INV_MATERIAL_STATUS profile is set to 2
1085: IF(p_subinventory_code IS NULL) THEN

Line 2916: IF (INV_QUANTITY_TREE_PVT.g_is_mat_status_used = 2) AND p_is_reservable_sub IS NOT NULL THEN

2912: /*
2913: l_sub_index := get_ancestor_sub(l_node_index);
2914: print_debug('after get_ancestor_sub... node_index='||l_node_index||', l_sub_index='||l_sub_index||', level='||g_nodes(l_sub_index).node_level);
2915:
2916: IF (INV_QUANTITY_TREE_PVT.g_is_mat_status_used = 2) AND p_is_reservable_sub IS NOT NULL THEN
2917: print_debug('in add_qty, p_is_reservable_sub=NOT NULL');
2918: l_is_reservable_sub := p_is_reservable_sub;
2919: ELSE
2920: print_debug('in add_qty, p_is_reservable_sub=NULL');

Line 8751: IF (inv_quantity_tree_pvt.g_is_mat_status_used = 2) /* Bug 7158174 */

8747: CLOSE c_no_lot;
8748: ELSE
8749: IF (g_is_lot_control = FALSE)
8750: THEN
8751: IF (inv_quantity_tree_pvt.g_is_mat_status_used = 2) /* Bug 7158174 */
8752: THEN
8753: print_debug('build_tree: open c_plain');
8754: --item is not lot controlled or unit effective
8755: OPEN c_plain;

Line 10883: print_debug(' >>>>>>>>> In create_tree. mode='||p_tree_mode||', grade='||p_grade_code||', rev_ctl=TRUE. mat_stat='||INV_QUANTITY_TREE_PVT.g_is_mat_status_used);

10879:
10880:
10881: if (p_is_revision_control = TRUE)
10882: THEN
10883: print_debug(' >>>>>>>>> In create_tree. mode='||p_tree_mode||', grade='||p_grade_code||', rev_ctl=TRUE. mat_stat='||INV_QUANTITY_TREE_PVT.g_is_mat_status_used);
10884: else
10885: print_debug(' >>>>>>>>> In create_tree. mode='||p_tree_mode||', grade='||p_grade_code||', rev_ctl=FALSE. mat_stat='||INV_QUANTITY_TREE_PVT.g_is_mat_status_used);
10886: end if;
10887:

Line 10885: print_debug(' >>>>>>>>> In create_tree. mode='||p_tree_mode||', grade='||p_grade_code||', rev_ctl=FALSE. mat_stat='||INV_QUANTITY_TREE_PVT.g_is_mat_status_used);

10881: if (p_is_revision_control = TRUE)
10882: THEN
10883: print_debug(' >>>>>>>>> In create_tree. mode='||p_tree_mode||', grade='||p_grade_code||', rev_ctl=TRUE. mat_stat='||INV_QUANTITY_TREE_PVT.g_is_mat_status_used);
10884: else
10885: print_debug(' >>>>>>>>> In create_tree. mode='||p_tree_mode||', grade='||p_grade_code||', rev_ctl=FALSE. mat_stat='||INV_QUANTITY_TREE_PVT.g_is_mat_status_used);
10886: end if;
10887:
10888: -- Standard call to check for call compatibility
10889: IF NOT fnd_api.compatible_api_call(l_api_version_number

Line 10953: IF (inv_quantity_tree_pvt.g_is_mat_status_used = 1 AND l_lot_control = 2)

10949: FND_MSG_PUB.ADD;
10950: RAISE FND_API.G_EXC_ERROR;
10951: END IF;
10952: -- invConv comment : g_is_mat_status_used = 1 == Material Status is USED
10953: IF (inv_quantity_tree_pvt.g_is_mat_status_used = 1 AND l_lot_control = 2)
10954: THEN
10955: g_is_lot_control := TRUE;
10956: ELSE
10957: g_is_lot_control := FALSE;

Line 11420: inv_quantity_tree_pvt.get_total_qoh

11416: l_stqoh NUMBER;
11417:
11418: BEGIN
11419:
11420: inv_quantity_tree_pvt.get_total_qoh
11421: ( x_return_status => x_return_status
11422: , x_msg_count => x_msg_count
11423: , x_msg_data => x_msg_data
11424: , p_tree_id => p_tree_id

Line 12577: inv_quantity_tree_pvt.update_quantities

12573: l_satt NUMBER;
12574: l_satr NUMBER;
12575: BEGIN
12576:
12577: inv_quantity_tree_pvt.update_quantities
12578: ( p_api_version_number => p_api_version_number
12579: , p_init_msg_lst => p_init_msg_lst
12580: , x_return_status => x_return_status
12581: , x_msg_count => x_msg_count

Line 12862: inv_quantity_tree_pvt.update_quantities_for_form

12858: l_satr NUMBER;
12859:
12860: BEGIN
12861:
12862: inv_quantity_tree_pvt.update_quantities_for_form
12863: ( p_api_version_number => p_api_version_number
12864: , p_init_msg_lst => p_init_msg_lst
12865: , x_return_status => x_return_status
12866: , x_msg_count => x_msg_count

Line 13429: INV_QUANTITY_TREE_PVT.release_lock(

13425: l_api_number number := 1.0;
13426:
13427: begin
13428: for c1_rec in C1 loop
13429: INV_QUANTITY_TREE_PVT.release_lock(
13430: l_api_number,
13431: fnd_api.g_false,
13432: l_return_status,
13433: l_msg_count,

Line 13454: END inv_quantity_tree_pvt;

13450: -- 2. Procedures or functions not exposed to user do not have the following parameters:
13451: -- p_api_version, p_msg_count, p_msg_data. x_return_status is optional.
13452: -- 3. identation and character case uses plsql mode of emacs
13453: -------------------------------------------------------------------------------
13454: END inv_quantity_tree_pvt;