APPS.INV_WIP_PICKING_PVT dependencies on INV_QUANTITY_TREE_PVT

Line 554: inv_quantity_tree_pvt.clear_quantity_cache;

550: l_savept_exists := FALSE;
551:
552: l_counter := l_last_batch_rec + 1;
553: l_line_tbl.DELETE;
554: inv_quantity_tree_pvt.clear_quantity_cache;
555: END LOOP;
556: ELSE
557: -- WIP is 11.5.8 or lower
558: l_line_tbl := p_mo_line_rec_tbl;

Line 798: inv_quantity_tree_pvt.clear_quantity_cache;

794: RAISE fnd_api.g_exc_unexpected_error;
795: END IF;
796:
797: -- Bug 2038564: Clearing Qty Tree
798: inv_quantity_tree_pvt.clear_quantity_cache;
799:
800: -- Validate that all move order lines are from the same org, that all lines
801: -- have a status of pre-approved (7) or approved (3), and that all of the move
802: -- order lines are of type Manufacturing Component Pick (5)

Line 914: inv_quantity_tree_pvt.create_tree

910: END IF;
911: RAISE fnd_api.g_exc_unexpected_error;
912: END;
913:
914: inv_quantity_tree_pvt.create_tree
915: ( p_api_version_number => 1.0
916: , p_init_msg_lst => fnd_api.g_false
917: , x_return_status => l_api_return_status
918: , x_msg_count => x_msg_count

Line 922: , p_tree_mode => inv_quantity_tree_pvt.g_transaction_mode

918: , x_msg_count => x_msg_count
919: , x_msg_data => x_msg_data
920: , p_organization_id => l_organization_id
921: , p_inventory_item_id => l_mo_line.inventory_item_id
922: , p_tree_mode => inv_quantity_tree_pvt.g_transaction_mode
923: , p_is_revision_control => (l_revision_control_code = 2)
924: , p_is_lot_control => (l_lot_control_code = 2)
925: , p_is_serial_control => FALSE
926: , p_asset_sub_only => FALSE

Line 935: , p_exclusive => inv_quantity_tree_pvt.g_exclusive

931: , p_demand_source_delivery => NULL
932: , p_demand_source_name => NULL
933: , p_lot_expiration_date => SYSDATE
934: , x_tree_id => l_tree_id
935: , p_exclusive => inv_quantity_tree_pvt.g_exclusive
936: , p_pick_release => inv_quantity_tree_pvt.g_pick_release_yes
937: );
938:
939: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

Line 936: , p_pick_release => inv_quantity_tree_pvt.g_pick_release_yes

932: , p_demand_source_name => NULL
933: , p_lot_expiration_date => SYSDATE
934: , x_tree_id => l_tree_id
935: , p_exclusive => inv_quantity_tree_pvt.g_exclusive
936: , p_pick_release => inv_quantity_tree_pvt.g_pick_release_yes
937: );
938:
939: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
940: RAISE fnd_api.g_exc_error;

Line 994: inv_quantity_tree_pvt.backup_tree(x_return_status => l_api_return_status, p_tree_id => l_tree_id);

990: IF (l_debug = 1) THEN
991: print_debug('Backing up qty tree: '|| TO_CHAR(l_tree_id), 'PICK_RELEASE');
992: END IF;
993: l_tree_id := l_quantity_tree_tbl(l_mo_line.inventory_item_id);
994: inv_quantity_tree_pvt.backup_tree(x_return_status => l_api_return_status, p_tree_id => l_tree_id);
995:
996: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
997: RAISE fnd_api.g_exc_error;
998: ELSIF l_api_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1078: inv_quantity_tree_pvt.restore_tree

1074: IF (l_debug = 1) THEN
1075: print_debug('Restoring Quantity Tree: '|| TO_CHAR(l_tree_id), 'PICK_RELEASE');
1076: END IF;
1077:
1078: inv_quantity_tree_pvt.restore_tree
1079: ( x_return_status => l_api_return_status
1080: , p_tree_id => l_tree_id
1081: );
1082:

Line 1302: inv_quantity_tree_pvt.clear_quantity_cache;

1298:
1299: EXCEPTION
1300: WHEN fnd_api.g_exc_error THEN
1301: ROLLBACK TO pick_release;
1302: inv_quantity_tree_pvt.clear_quantity_cache;
1303: x_return_status := fnd_api.g_ret_sts_error;
1304: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1305: WHEN OTHERS THEN
1306: ROLLBACK TO pick_release;

Line 1307: inv_quantity_tree_pvt.clear_quantity_cache;

1303: x_return_status := fnd_api.g_ret_sts_error;
1304: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1305: WHEN OTHERS THEN
1306: ROLLBACK TO pick_release;
1307: inv_quantity_tree_pvt.clear_quantity_cache;
1308: x_return_status := fnd_api.g_ret_sts_unexp_error;
1309: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1310: END pick_release;
1311: