DBA Data[Home] [Help]

APPS.INV_CYC_LOVS dependencies on INV_QUANTITY_TREE_PUB

Line 2902: inv_quantity_tree_pub.clear_quantity_cache;

2898: END IF;
2899:
2900: /* Bug 5704910*/
2901: --Clearing the quantity tree cache
2902: inv_quantity_tree_pub.clear_quantity_cache;
2903:
2904: -- Get the required variable values
2905: -- Get the item primary uom code
2906: SELECT primary_uom_code

Line 2998: inv_quantity_tree_pub.query_quantities ( p_api_version_number => 1.0,

2994: END IF;
2995:
2996: IF ( l_lpn_subinv <> '###' AND l_lpn_locator_id <> -99 ) THEN
2997:
2998: inv_quantity_tree_pub.query_quantities ( p_api_version_number => 1.0,
2999: p_init_msg_lst => 'F',
3000: x_return_status => x_return_status,
3001: x_msg_count => l_msg_count,
3002: x_msg_data => l_msg_data,

Line 3049: inv_quantity_tree_pub.query_quantities ( p_api_version_number => 1.0,

3045: /*
3046: End of Bug 5725198
3047: */
3048:
3049: inv_quantity_tree_pub.query_quantities ( p_api_version_number => 1.0,
3050: p_init_msg_lst => 'F',
3051: x_return_status => x_return_status,
3052: x_msg_count => l_msg_count,
3053: x_msg_data => l_msg_data,

Line 3161: inv_quantity_tree_pub.update_quantities ( p_api_version_number => 1.0,

3157: IF ( l_neg_inv_rcpt_code = 2 ) THEN
3158:
3159: /* Bug 5725198-Added the check for LPN being counted to update quantity tree */
3160: IF (( l_lpn_id IS NOT NULL ) AND (l_lpn_subinv <> '###' AND l_lpn_locator_id <> -99)) THEN
3161: inv_quantity_tree_pub.update_quantities ( p_api_version_number => 1.0,
3162: p_init_msg_lst => 'F',
3163: x_return_status => x_return_status,
3164: x_msg_count => l_msg_count,
3165: x_msg_data => l_msg_data,

Line 3212: inv_quantity_tree_pub.update_quantities ( p_api_version_number => 1.0,

3208: ELSE
3209: /*
3210: End of Bug 5725198
3211: */
3212: inv_quantity_tree_pub.update_quantities ( p_api_version_number => 1.0,
3213: p_init_msg_lst => 'F',
3214: x_return_status => x_return_status,
3215: x_msg_count => l_msg_count,
3216: x_msg_data => l_msg_data,

Line 6399: inv_quantity_tree_pub.clear_quantity_cache;

6395: END IF;
6396:
6397: /*Bug 5704910*/
6398: --Clearing the quantity tree cache
6399: inv_quantity_tree_pub.clear_quantity_cache;
6400:
6401: --Bug# 3640622
6402: g_cc_entry.adjustment_date := SYSDATE;
6403:

Line 6530: inv_quantity_tree_pub.query_quantities ( p_api_version_number => 1.0,

6526: IF ( v_rev_code <> 1 ) THEN
6527: v_is_rev_controlled := TRUE;
6528: END IF;
6529:
6530: inv_quantity_tree_pub.query_quantities ( p_api_version_number => 1.0,
6531: p_init_msg_lst => 'F',
6532: x_return_status => x_return_status,
6533: x_msg_count => l_msg_count,
6534: x_msg_data => l_msg_data,

Line 6607: inv_quantity_tree_pub.update_quantities ( p_api_version_number => 1.0,

6603: -- irrespective of the the l_neg_inv_rcpt_code flag value
6604:
6605: IF ( l_neg_inv_rcpt_code = 2 ) THEN
6606:
6607: inv_quantity_tree_pub.update_quantities ( p_api_version_number => 1.0,
6608: p_init_msg_lst => 'F',
6609: x_return_status => x_return_status,
6610: x_msg_count => l_msg_count,
6611: x_msg_data => l_msg_data,