DBA Data[Home] [Help]

APPS.INV_CYC_LOVS dependencies on INV_QUANTITY_TREE_PUB

Line 3153: inv_quantity_tree_pub.clear_quantity_cache;

3149: END IF;
3150:
3151: /* Bug 5704910*/
3152: --Clearing the quantity tree cache
3153: inv_quantity_tree_pub.clear_quantity_cache;
3154:
3155: -- Get the required variable values
3156: -- Get the item primary uom code
3157: SELECT primary_uom_code

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

3251: END IF;
3252:
3253: IF ( l_lpn_subinv <> '###' AND l_lpn_locator_id <> -99 ) THEN
3254:
3255: inv_quantity_tree_pub.query_quantities ( p_api_version_number => 1.0,
3256: p_init_msg_lst => 'F',
3257: x_return_status => x_return_status,
3258: x_msg_count => l_msg_count,
3259: x_msg_data => l_msg_data,

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

3302: /*
3303: End of Bug 5725198
3304: */
3305:
3306: inv_quantity_tree_pub.query_quantities ( p_api_version_number => 1.0,
3307: p_init_msg_lst => 'F',
3308: x_return_status => x_return_status,
3309: x_msg_count => l_msg_count,
3310: x_msg_data => l_msg_data,

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

3443: IF ( l_neg_inv_rcpt_code = 2 ) THEN
3444:
3445: /* Bug 5725198-Added the check for LPN being counted to update quantity tree */
3446: IF (( l_lpn_id IS NOT NULL ) AND (l_lpn_subinv <> '###' AND l_lpn_locator_id <> -99)) THEN
3447: inv_quantity_tree_pub.update_quantities ( p_api_version_number => 1.0,
3448: p_init_msg_lst => 'F',
3449: x_return_status => x_return_status,
3450: x_msg_count => l_msg_count,
3451: x_msg_data => l_msg_data,

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

3494: ELSE
3495: /*
3496: End of Bug 5725198
3497: */
3498: inv_quantity_tree_pub.update_quantities ( p_api_version_number => 1.0,
3499: p_init_msg_lst => 'F',
3500: x_return_status => x_return_status,
3501: x_msg_count => l_msg_count,
3502: x_msg_data => l_msg_data,

Line 6505: inv_quantity_tree_pub.clear_quantity_cache;

6501: END IF;
6502:
6503: /*Bug 5704910*/
6504: --Clearing the quantity tree cache
6505: inv_quantity_tree_pub.clear_quantity_cache;
6506:
6507: --Bug# 3640622
6508: g_cc_entry.adjustment_date := SYSDATE;
6509:

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

6632: IF ( v_rev_code <> 1 ) THEN
6633: v_is_rev_controlled := TRUE;
6634: END IF;
6635:
6636: inv_quantity_tree_pub.query_quantities ( p_api_version_number => 1.0,
6637: p_init_msg_lst => 'F',
6638: x_return_status => x_return_status,
6639: x_msg_count => l_msg_count,
6640: x_msg_data => l_msg_data,

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

6709: -- irrespective of the the l_neg_inv_rcpt_code flag value
6710:
6711: IF ( l_neg_inv_rcpt_code = 2 ) THEN
6712:
6713: inv_quantity_tree_pub.update_quantities ( p_api_version_number => 1.0,
6714: p_init_msg_lst => 'F',
6715: x_return_status => x_return_status,
6716: x_msg_count => l_msg_count,
6717: x_msg_data => l_msg_data,