DBA Data[Home] [Help]

APPS.CSP_PART_SEARCH_PVT dependencies on INV_QUANTITY_TREE_PUB

Line 1726: log('get_avail_qty','calling inv_quantity_tree_pub.clear_quantity_cache');

1722: l_b_revision := TRUE;
1723: else
1724: l_b_revision := FALSE;
1725: end if;
1726: log('get_avail_qty','calling inv_quantity_tree_pub.clear_quantity_cache');
1727: inv_quantity_tree_pub.clear_quantity_cache;
1728: log('get_avail_qty','calling inv_quantity_tree_pub.query_quantities');
1729: if not l_b_revision then
1730: inv_quantity_tree_pub.query_quantities(

Line 1727: inv_quantity_tree_pub.clear_quantity_cache;

1723: else
1724: l_b_revision := FALSE;
1725: end if;
1726: log('get_avail_qty','calling inv_quantity_tree_pub.clear_quantity_cache');
1727: inv_quantity_tree_pub.clear_quantity_cache;
1728: log('get_avail_qty','calling inv_quantity_tree_pub.query_quantities');
1729: if not l_b_revision then
1730: inv_quantity_tree_pub.query_quantities(
1731: p_api_version_number => l_api_version

Line 1728: log('get_avail_qty','calling inv_quantity_tree_pub.query_quantities');

1724: l_b_revision := FALSE;
1725: end if;
1726: log('get_avail_qty','calling inv_quantity_tree_pub.clear_quantity_cache');
1727: inv_quantity_tree_pub.clear_quantity_cache;
1728: log('get_avail_qty','calling inv_quantity_tree_pub.query_quantities');
1729: if not l_b_revision then
1730: inv_quantity_tree_pub.query_quantities(
1731: p_api_version_number => l_api_version
1732: , p_init_msg_lst => fnd_api.g_false

Line 1730: inv_quantity_tree_pub.query_quantities(

1726: log('get_avail_qty','calling inv_quantity_tree_pub.clear_quantity_cache');
1727: inv_quantity_tree_pub.clear_quantity_cache;
1728: log('get_avail_qty','calling inv_quantity_tree_pub.query_quantities');
1729: if not l_b_revision then
1730: inv_quantity_tree_pub.query_quantities(
1731: p_api_version_number => l_api_version
1732: , p_init_msg_lst => fnd_api.g_false
1733: , x_return_status => l_return_status
1734: , x_msg_count => l_msg_count

Line 1761: inv_quantity_tree_pub.query_quantities(

1757: , x_atr => l_dummy);
1758: else
1759: for crr in c_revisions loop
1760: log('get_avail_qty','crr.revision'||crr.revision);
1761: inv_quantity_tree_pub.query_quantities(
1762: p_api_version_number => l_api_version
1763: , p_init_msg_lst => fnd_api.g_false
1764: , x_return_status => l_return_status
1765: , x_msg_count => l_msg_count

Line 1805: log('get_avail_qty','calling inv_quantity_tree_pub.query_quantities');

1801: and ((nvl(p_quantity_type,'AVAILABLE') = 'AVAILABLE' and l_att > 0)
1802: or (nvl(p_quantity_type,'AVAILABLE') <> 'AVAILABLE' and l_qoh > 0)) then
1803: for cr in c_defective_sub loop
1804: log('get_avail_qty','in c_defective_sub loop');
1805: log('get_avail_qty','calling inv_quantity_tree_pub.query_quantities');
1806: inv_quantity_tree_pub.query_quantities(
1807: p_api_version_number => l_api_version
1808: , p_init_msg_lst => fnd_api.g_false
1809: , x_return_status => l_return_status

Line 1806: inv_quantity_tree_pub.query_quantities(

1802: or (nvl(p_quantity_type,'AVAILABLE') <> 'AVAILABLE' and l_qoh > 0)) then
1803: for cr in c_defective_sub loop
1804: log('get_avail_qty','in c_defective_sub loop');
1805: log('get_avail_qty','calling inv_quantity_tree_pub.query_quantities');
1806: inv_quantity_tree_pub.query_quantities(
1807: p_api_version_number => l_api_version
1808: , p_init_msg_lst => fnd_api.g_false
1809: , x_return_status => l_return_status
1810: , x_msg_count => l_msg_count