eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_TXN_VALIDATIONS dependencies on INV_QUANTITY_TREE_PVT

Line 721: /* This Overloaded Procedure Calls INV_QUANTITY_TREE_PVT to return pqoh

717:
718:
719:
720:
721: /* This Overloaded Procedure Calls INV_QUANTITY_TREE_PVT to return pqoh
722: */
723:
724: PROCEDURE GET_AVAILABLE_QUANTITY(
725: x_return_status OUT NOCOPY VARCHAR2,

Line 852: inv_quantity_tree_pvt.clear_quantity_cache;

848: l_asset_sub_only BOOLEAN := FALSE;
849:
850: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
851: BEGIN
852: inv_quantity_tree_pvt.clear_quantity_cache;
853:
854: IF p_is_revision_control = 'true' THEN
855: l_is_revision_control := TRUE;
856: END IF;

Line 876: INV_QUANTITY_TREE_PVT.create_tree

872: IF fnd_api.to_boolean(p_init_msg_lst) THEN
873: fnd_msg_pub.initialize;
874: END IF;
875:
876: INV_QUANTITY_TREE_PVT.create_tree
877: ( p_api_version_number => 1.0
878: , p_init_msg_lst => fnd_api.g_false
879: , x_return_status => l_return_status
880: , x_msg_count => x_msg_count

Line 912: INV_QUANTITY_TREE_PVT.query_tree

908: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
909: RAISE fnd_api.g_exc_unexpected_error;
910: END IF;
911:
912: INV_QUANTITY_TREE_PVT.query_tree
913: ( p_api_version_number => 1.0
914: , p_init_msg_lst => fnd_api.g_false
915: , x_return_status => l_return_status
916: , x_msg_count => x_msg_count

Line 952: INV_QUANTITY_TREE_PVT.query_tree

948:
949: -- This query_tree quaries qoh and att at Item level,
950: -- so we are passing null for p_subinventory_code and p_locator_id
951:
952: INV_QUANTITY_TREE_PVT.query_tree
953: ( p_api_version_number => 1.0
954: , p_init_msg_lst => fnd_api.g_false
955: , x_return_status => l_return_status
956: , x_msg_count => x_msg_count

Line 989: INV_QUANTITY_TREE_PVT.get_total_qoh

985: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
986: RAISE fnd_api.g_exc_unexpected_error;
987: END IF;
988:
989: INV_QUANTITY_TREE_PVT.get_total_qoh
990: ( x_return_status => l_return_status
991: , x_msg_count => x_msg_count
992: , x_msg_data => x_msg_data
993: , p_tree_id => l_tree_id

Line 1058: /* This Overloaded Procedure Calls INV_QUANTITY_TREE_PVT to return pqoh.

1054: END get_available_quantity;
1055:
1056:
1057:
1058: /* This Overloaded Procedure Calls INV_QUANTITY_TREE_PVT to return pqoh.
1059: --This procedure takes in the cost group
1060: */
1061:
1062: PROCEDURE GET_AVAILABLE_QUANTITY

Line 1195: inv_quantity_tree_pvt.clear_quantity_cache;

1191: l_asset_sub_only BOOLEAN := FALSE;
1192:
1193: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1194: BEGIN
1195: inv_quantity_tree_pvt.clear_quantity_cache;
1196:
1197: IF p_is_revision_control = 'true' THEN
1198: l_is_revision_control := TRUE;
1199: END IF;

Line 1219: INV_QUANTITY_TREE_PVT.create_tree

1215: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1216: fnd_msg_pub.initialize;
1217: END IF;
1218:
1219: INV_QUANTITY_TREE_PVT.create_tree
1220: ( p_api_version_number => 1.0
1221: , p_init_msg_lst => fnd_api.g_false
1222: , x_return_status => l_return_status
1223: , x_msg_count => x_msg_count

Line 1255: INV_QUANTITY_TREE_PVT.query_tree

1251: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1252: RAISE fnd_api.g_exc_unexpected_error;
1253: END IF;
1254:
1255: INV_QUANTITY_TREE_PVT.query_tree
1256: ( p_api_version_number => 1.0
1257: , p_init_msg_lst => fnd_api.g_false
1258: , x_return_status => l_return_status
1259: , x_msg_count => x_msg_count

Line 1295: INV_QUANTITY_TREE_PVT.query_tree

1291:
1292: -- This query_tree quaries qoh and att at Item level,
1293: -- so we are passing null for p_subinventory_code and p_locator_id
1294:
1295: INV_QUANTITY_TREE_PVT.query_tree
1296: ( p_api_version_number => 1.0
1297: , p_init_msg_lst => fnd_api.g_false
1298: , x_return_status => l_return_status
1299: , x_msg_count => x_msg_count

Line 1332: INV_QUANTITY_TREE_PVT.get_total_qoh

1328: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1329: RAISE fnd_api.g_exc_unexpected_error;
1330: END IF;
1331:
1332: INV_QUANTITY_TREE_PVT.get_total_qoh
1333: ( x_return_status => l_return_status
1334: , x_msg_count => x_msg_count
1335: , x_msg_data => x_msg_data
1336: , p_tree_id => l_tree_id

Line 2757: , p_quantity_type => inv_quantity_tree_pvt.g_qoh

2753: , p_lot_number => l_lot_number
2754: , p_subinventory_code => l_subinventory_code
2755: , p_locator_id => l_locator_id
2756: , p_primary_quantity => l_updt_qoh
2757: , p_quantity_type => inv_quantity_tree_pvt.g_qoh
2758: , x_qoh => l_qoh
2759: , x_rqoh => l_rqoh
2760: , x_qr => l_qr
2761: , x_qs => l_qs

Line 3029: , p_quantity_type => inv_quantity_tree_pvt.g_qoh

3025: , p_lot_number => l_lot_number
3026: , p_subinventory_code => l_subinventory_code
3027: , p_locator_id => l_locator_id
3028: , p_primary_quantity => l_updt_qoh
3029: , p_quantity_type => inv_quantity_tree_pvt.g_qoh
3030: , x_qoh => l_qoh
3031: , x_rqoh => l_rqoh
3032: , x_qr => l_qr
3033: , x_qs => l_qs

Line 3872: l_quantity_type NUMBER := inv_quantity_tree_pvt.g_qoh;

3868: l_is_revision_control BOOLEAN;
3869: l_is_lot_control BOOLEAN;
3870:
3871: l_tree_mode NUMBER := inv_quantity_tree_pub.g_transaction_mode;
3872: l_quantity_type NUMBER := inv_quantity_tree_pvt.g_qoh;
3873: l_onhand_source NUMBER := inv_quantity_tree_pvt.g_all_subs;
3874: l_qoh NUMBER;
3875: l_rqoh NUMBER;
3876: l_qr NUMBER;

Line 3873: l_onhand_source NUMBER := inv_quantity_tree_pvt.g_all_subs;

3869: l_is_lot_control BOOLEAN;
3870:
3871: l_tree_mode NUMBER := inv_quantity_tree_pub.g_transaction_mode;
3872: l_quantity_type NUMBER := inv_quantity_tree_pvt.g_qoh;
3873: l_onhand_source NUMBER := inv_quantity_tree_pvt.g_all_subs;
3874: l_qoh NUMBER;
3875: l_rqoh NUMBER;
3876: l_qr NUMBER;
3877: l_qs NUMBER;