DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_PUB dependencies on INV_QUANTITY_TREE_PVT

Line 3467: INV_QUANTITY_TREE_PVT.create_tree

3463: IF ( l_srctypeid = INv_GLOBALS.G_SOURCETYPE_WIP AND
3464: l_actid = INV_GLOBALS.G_ACTION_ASSYRETURN AND l_dem_hdr_id IS NOT NULL ) then
3465:
3466:
3467: INV_QUANTITY_TREE_PVT.create_tree
3468: ( p_api_version_number => 1.0
3469: , p_init_msg_lst => fnd_api.g_false
3470: , x_return_status => l_return_status
3471: , x_msg_count => l_msg_count

Line 3495: INV_QUANTITY_TREE_PVT.create_tree

3491:
3492:
3493: ELSE
3494:
3495: INV_QUANTITY_TREE_PVT.create_tree
3496: ( p_api_version_number => 1.0
3497: , p_init_msg_lst => fnd_api.g_false
3498: , x_return_status => l_return_status
3499: , x_msg_count => l_msg_count

Line 3570: INV_QUANTITY_TREE_PVT.query_tree

3566: END IF; --400
3567: END IF;--350
3568:
3569: IF ( NOT l_current_batch_failed) THEN --100
3570: INV_QUANTITY_TREE_PVT.query_tree
3571: ( p_api_version_number => 1.0
3572: , p_init_msg_lst => fnd_api.g_false
3573: , x_return_status => l_return_status
3574: , x_msg_count => l_msg_count

Line 3768: INV_QUANTITY_TREE_PVT.query_tree

3764: END IF; --override_rsv_for_backflush
3765: END IF;
3766:
3767: IF (NOT l_current_batch_failed ) THEN --200
3768: INV_QUANTITY_TREE_PVT.query_tree
3769: ( p_api_version_number => 1.0
3770: , p_init_msg_lst => fnd_api.g_false
3771: , x_return_status => l_return_status
3772: , x_msg_count => l_msg_count

Line 3993: p_quantity_type => inv_quantity_tree_pvt.g_qoh,

3989: p_lot_number => l_lotnum,
3990: p_subinventory_code => l_xfrsub,
3991: p_locator_id => l_xlocid,
3992: p_primary_quantity => l_trx_qty,
3993: p_quantity_type => inv_quantity_tree_pvt.g_qoh,
3994: p_onhand_source => inv_quantity_tree_pvt.g_all_subs,
3995: x_qoh => l_qoh,
3996: x_rqoh => l_rqoh,
3997: x_qr => l_qr,

Line 3994: p_onhand_source => inv_quantity_tree_pvt.g_all_subs,

3990: p_subinventory_code => l_xfrsub,
3991: p_locator_id => l_xlocid,
3992: p_primary_quantity => l_trx_qty,
3993: p_quantity_type => inv_quantity_tree_pvt.g_qoh,
3994: p_onhand_source => inv_quantity_tree_pvt.g_all_subs,
3995: x_qoh => l_qoh,
3996: x_rqoh => l_rqoh,
3997: x_qr => l_qr,
3998: x_qs => l_qs,

Line 4063: p_quantity_type => inv_quantity_tree_pvt.g_qoh,

4059: p_lot_number => l_lotnum,
4060: p_subinventory_code => l_sub_code,
4061: p_locator_id => l_locid,
4062: p_primary_quantity => (sign(l_line_rec_type.transaction_quantity)*(l_trx_qty)),
4063: p_quantity_type => inv_quantity_tree_pvt.g_qoh,
4064: p_onhand_source => inv_quantity_tree_pvt.g_all_subs,
4065: x_qoh => l_qoh,
4066: x_rqoh => l_rqoh,
4067: x_qr => l_qr,

Line 4064: p_onhand_source => inv_quantity_tree_pvt.g_all_subs,

4060: p_subinventory_code => l_sub_code,
4061: p_locator_id => l_locid,
4062: p_primary_quantity => (sign(l_line_rec_type.transaction_quantity)*(l_trx_qty)),
4063: p_quantity_type => inv_quantity_tree_pvt.g_qoh,
4064: p_onhand_source => inv_quantity_tree_pvt.g_all_subs,
4065: x_qoh => l_qoh,
4066: x_rqoh => l_rqoh,
4067: x_qr => l_qr,
4068: x_qs => l_qs,

Line 4268: INV_QUANTITY_TREE_PVT.free_tree

4264: END LOOP; -- endloop for AA1 (MTI)
4265:
4266: /*Bug:5209598. Freeing the Tree created for reservation checks.*/
4267: IF (l_tree_id IS NOT NULL) THEN
4268: INV_QUANTITY_TREE_PVT.free_tree
4269: ( p_api_version_number => 1.0
4270: , p_init_msg_lst => fnd_api.g_false
4271: , x_return_status => l_return_status
4272: , x_msg_count => l_msg_count

Line 5389: inv_quantity_tree_pvt.clear_quantity_cache;

5385: , 9
5386: );
5387: END IF;
5388: l_progress_indicator := '60';
5389: inv_quantity_tree_pvt.clear_quantity_cache;
5390:
5391: --Bug #5086940
5392: --demand_source_name cannot be greater than 30 characters
5393: IF (LENGTH(l_src_code) > 30) THEN

Line 5398: inv_quantity_tree_pvt.create_tree (

5394: l_src_code := NULL;
5395: END IF;
5396:
5397: l_progress_indicator := '70';
5398: inv_quantity_tree_pvt.create_tree (
5399: p_api_version_number => 1.0
5400: , p_init_msg_lst => fnd_api.g_false
5401: , x_return_status => l_return_status
5402: , x_msg_count => l_msg_count

Line 5481: inv_quantity_tree_pvt.query_tree

5477: inv_log_util.TRACE ('Locator is : '||l_locid , l_procedure_name , 9);
5478: END IF;
5479:
5480: l_progress_indicator := '100';
5481: inv_quantity_tree_pvt.query_tree
5482: (p_api_version_number => 1.0
5483: , p_init_msg_lst => fnd_api.g_false
5484: , x_return_status => l_return_status
5485: , x_msg_count => l_msg_count

Line 5573: inv_quantity_tree_pvt.query_tree

5569: END IF;
5570: END IF;
5571:
5572: l_progress_indicator := '140';
5573: inv_quantity_tree_pvt.query_tree
5574: (p_api_version_number => 1.0
5575: , p_init_msg_lst => fnd_api.g_false
5576: , x_return_status => l_return_status
5577: , x_msg_count => l_msg_count

Line 5753: inv_quantity_tree_pvt.free_all (p_api_version_number => 1.0

5749: CLOSE z1;
5750:
5751: IF (tree_exists) THEN
5752: l_progress_indicator := '200';
5753: inv_quantity_tree_pvt.free_all (p_api_version_number => 1.0
5754: , p_init_msg_lst => fnd_api.g_false
5755: , x_return_status => l_return_status
5756: , x_msg_count => l_msg_count
5757: , x_msg_data => l_msg_data

Line 6337: INV_QUANTITY_TREE_PVT.clear_quantity_cache;

6333:
6334: 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
6335:
6336: l_progress_indicator := '135';
6337: INV_QUANTITY_TREE_PVT.clear_quantity_cache;
6338:
6339: l_progress_indicator := '1351';
6340: INV_QUANTITY_TREE_PVT.create_tree
6341: ( p_api_version_number => 1.0

Line 6340: INV_QUANTITY_TREE_PVT.create_tree

6336: l_progress_indicator := '135';
6337: INV_QUANTITY_TREE_PVT.clear_quantity_cache;
6338:
6339: l_progress_indicator := '1351';
6340: INV_QUANTITY_TREE_PVT.create_tree
6341: ( p_api_version_number => 1.0
6342: , p_init_msg_lst => fnd_api.g_false
6343: , x_return_status => l_return_status
6344: , x_msg_count => l_msg_count

Line 6452: INV_QUANTITY_TREE_PVT.free_All

6448: CLOSE c1;
6449: l_progress_indicator := '180';
6450: IF (tree_exists) THEN
6451: l_progress_indicator := '190';
6452: INV_QUANTITY_TREE_PVT.free_All
6453: ( p_api_version_number => 1.0
6454: , p_init_msg_lst => fnd_api.g_false
6455: , x_return_status => l_return_status
6456: , x_msg_count => l_msg_count