DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_PUB dependencies on INV_QUANTITY_TREE_PVT

Line 3348: INV_QUANTITY_TREE_PVT.create_tree

3344: IF ( l_srctypeid = INv_GLOBALS.G_SOURCETYPE_WIP AND
3345: l_actid = INV_GLOBALS.G_ACTION_ASSYRETURN AND l_dem_hdr_id IS NOT NULL ) then
3346:
3347:
3348: INV_QUANTITY_TREE_PVT.create_tree
3349: ( p_api_version_number => 1.0
3350: , p_init_msg_lst => fnd_api.g_false
3351: , x_return_status => l_return_status
3352: , x_msg_count => l_msg_count

Line 3376: INV_QUANTITY_TREE_PVT.create_tree

3372:
3373:
3374: ELSE
3375:
3376: INV_QUANTITY_TREE_PVT.create_tree
3377: ( p_api_version_number => 1.0
3378: , p_init_msg_lst => fnd_api.g_false
3379: , x_return_status => l_return_status
3380: , x_msg_count => l_msg_count

Line 3451: INV_QUANTITY_TREE_PVT.query_tree

3447: END IF; --400
3448: END IF;--350
3449:
3450: IF ( NOT l_current_batch_failed) THEN --100
3451: INV_QUANTITY_TREE_PVT.query_tree
3452: ( p_api_version_number => 1.0
3453: , p_init_msg_lst => fnd_api.g_false
3454: , x_return_status => l_return_status
3455: , x_msg_count => l_msg_count

Line 3649: INV_QUANTITY_TREE_PVT.query_tree

3645: END IF; --override_rsv_for_backflush
3646: END IF;
3647:
3648: IF (NOT l_current_batch_failed ) THEN --200
3649: INV_QUANTITY_TREE_PVT.query_tree
3650: ( p_api_version_number => 1.0
3651: , p_init_msg_lst => fnd_api.g_false
3652: , x_return_status => l_return_status
3653: , x_msg_count => l_msg_count

Line 3874: p_quantity_type => inv_quantity_tree_pvt.g_qoh,

3870: p_lot_number => l_lotnum,
3871: p_subinventory_code => l_xfrsub,
3872: p_locator_id => l_xlocid,
3873: p_primary_quantity => l_trx_qty,
3874: p_quantity_type => inv_quantity_tree_pvt.g_qoh,
3875: p_onhand_source => inv_quantity_tree_pvt.g_all_subs,
3876: x_qoh => l_qoh,
3877: x_rqoh => l_rqoh,
3878: x_qr => l_qr,

Line 3875: p_onhand_source => inv_quantity_tree_pvt.g_all_subs,

3871: p_subinventory_code => l_xfrsub,
3872: p_locator_id => l_xlocid,
3873: p_primary_quantity => l_trx_qty,
3874: p_quantity_type => inv_quantity_tree_pvt.g_qoh,
3875: p_onhand_source => inv_quantity_tree_pvt.g_all_subs,
3876: x_qoh => l_qoh,
3877: x_rqoh => l_rqoh,
3878: x_qr => l_qr,
3879: x_qs => l_qs,

Line 3944: p_quantity_type => inv_quantity_tree_pvt.g_qoh,

3940: p_lot_number => l_lotnum,
3941: p_subinventory_code => l_sub_code,
3942: p_locator_id => l_locid,
3943: p_primary_quantity => (sign(l_line_rec_type.transaction_quantity)*(l_trx_qty)),
3944: p_quantity_type => inv_quantity_tree_pvt.g_qoh,
3945: p_onhand_source => inv_quantity_tree_pvt.g_all_subs,
3946: x_qoh => l_qoh,
3947: x_rqoh => l_rqoh,
3948: x_qr => l_qr,

Line 3945: p_onhand_source => inv_quantity_tree_pvt.g_all_subs,

3941: p_subinventory_code => l_sub_code,
3942: p_locator_id => l_locid,
3943: p_primary_quantity => (sign(l_line_rec_type.transaction_quantity)*(l_trx_qty)),
3944: p_quantity_type => inv_quantity_tree_pvt.g_qoh,
3945: p_onhand_source => inv_quantity_tree_pvt.g_all_subs,
3946: x_qoh => l_qoh,
3947: x_rqoh => l_rqoh,
3948: x_qr => l_qr,
3949: x_qs => l_qs,

Line 4146: INV_QUANTITY_TREE_PVT.free_tree

4142: END LOOP; -- endloop for AA1 (MTI)
4143:
4144: /*Bug:5209598. Freeing the Tree created for reservation checks.*/
4145: IF (l_tree_id IS NOT NULL) THEN
4146: INV_QUANTITY_TREE_PVT.free_tree
4147: ( p_api_version_number => 1.0
4148: , p_init_msg_lst => fnd_api.g_false
4149: , x_return_status => l_return_status
4150: , x_msg_count => l_msg_count

Line 5246: inv_quantity_tree_pvt.clear_quantity_cache;

5242: , 9
5243: );
5244: END IF;
5245: l_progress_indicator := '60';
5246: inv_quantity_tree_pvt.clear_quantity_cache;
5247:
5248: --Bug #5086940
5249: --demand_source_name cannot be greater than 30 characters
5250: IF (LENGTH(l_src_code) > 30) THEN

Line 5255: inv_quantity_tree_pvt.create_tree (

5251: l_src_code := NULL;
5252: END IF;
5253:
5254: l_progress_indicator := '70';
5255: inv_quantity_tree_pvt.create_tree (
5256: p_api_version_number => 1.0
5257: , p_init_msg_lst => fnd_api.g_false
5258: , x_return_status => l_return_status
5259: , x_msg_count => l_msg_count

Line 5338: inv_quantity_tree_pvt.query_tree

5334: inv_log_util.TRACE ('Locator is : '||l_locid , l_procedure_name , 9);
5335: END IF;
5336:
5337: l_progress_indicator := '100';
5338: inv_quantity_tree_pvt.query_tree
5339: (p_api_version_number => 1.0
5340: , p_init_msg_lst => fnd_api.g_false
5341: , x_return_status => l_return_status
5342: , x_msg_count => l_msg_count

Line 5422: inv_quantity_tree_pvt.query_tree

5418: RAISE fnd_api.g_exc_error;
5419: END IF;
5420:
5421: l_progress_indicator := '140';
5422: inv_quantity_tree_pvt.query_tree
5423: (p_api_version_number => 1.0
5424: , p_init_msg_lst => fnd_api.g_false
5425: , x_return_status => l_return_status
5426: , x_msg_count => l_msg_count

Line 5557: inv_quantity_tree_pvt.free_all (p_api_version_number => 1.0

5553: CLOSE z1;
5554:
5555: IF (tree_exists) THEN
5556: l_progress_indicator := '200';
5557: inv_quantity_tree_pvt.free_all (p_api_version_number => 1.0
5558: , p_init_msg_lst => fnd_api.g_false
5559: , x_return_status => l_return_status
5560: , x_msg_count => l_msg_count
5561: , x_msg_data => l_msg_data

Line 6141: INV_QUANTITY_TREE_PVT.clear_quantity_cache;

6137:
6138: IF (l_line_rec_type.transaction_interface_id IS NOT NULL ) AND ( g_interface_id IS NULL OR g_interface_id <> l_line_rec_type.transaction_interface_id ) THEN
6139:
6140: l_progress_indicator := '135';
6141: INV_QUANTITY_TREE_PVT.clear_quantity_cache;
6142:
6143: l_progress_indicator := '1351';
6144: INV_QUANTITY_TREE_PVT.create_tree
6145: ( p_api_version_number => 1.0

Line 6144: INV_QUANTITY_TREE_PVT.create_tree

6140: l_progress_indicator := '135';
6141: INV_QUANTITY_TREE_PVT.clear_quantity_cache;
6142:
6143: l_progress_indicator := '1351';
6144: INV_QUANTITY_TREE_PVT.create_tree
6145: ( p_api_version_number => 1.0
6146: , p_init_msg_lst => fnd_api.g_false
6147: , x_return_status => l_return_status
6148: , x_msg_count => l_msg_count

Line 6256: INV_QUANTITY_TREE_PVT.free_All

6252: CLOSE c1;
6253: l_progress_indicator := '180';
6254: IF (tree_exists) THEN
6255: l_progress_indicator := '190';
6256: INV_QUANTITY_TREE_PVT.free_All
6257: ( p_api_version_number => 1.0
6258: , p_init_msg_lst => fnd_api.g_false
6259: , x_return_status => l_return_status
6260: , x_msg_count => l_msg_count