DBA Data[Home] [Help]

APPS.INV_PICK_RELEASE_PVT dependencies on INV_QUANTITY_TREE_PUB

Line 918: inv_quantity_tree_pub.query_quantities(

914: -- Call quantity tree to obtain the quantity available to reserve
915: -- Bug 1890424 - pass in expiration date of sysdate. Expired lots
916: -- shouldn't appear as available
917: -- Added following secondary qty related section for Bug 7377744
918: inv_quantity_tree_pub.query_quantities(
919: p_api_version_number => 1.0
920: , p_init_msg_lst => fnd_api.g_false
921: , x_return_status => l_api_return_status
922: , x_msg_count => x_msg_count

Line 926: , p_tree_mode => inv_quantity_tree_pub.g_reservation_mode

922: , x_msg_count => x_msg_count
923: , x_msg_data => x_msg_data
924: , p_organization_id => p_mo_line_rec.organization_id
925: , p_inventory_item_id => p_mo_line_rec.inventory_item_id
926: , p_tree_mode => inv_quantity_tree_pub.g_reservation_mode
927: , p_is_revision_control => l_is_revision_control
928: , p_is_lot_control => l_is_lot_control
929: , p_is_serial_control => l_is_serial_control
930: , p_demand_source_type_id => p_demand_source_type

Line 1054: inv_quantity_tree_pub.update_quantities(

1050: 'Inv_Pick_Release_PVT.Process_Reservations');
1051: END IF;
1052:
1053: -- Added following secondary qty related section for Bug 7377744
1054: inv_quantity_tree_pub.update_quantities(
1055: p_api_version_number => 1.0
1056: , p_init_msg_lst => fnd_api.g_false
1057: , x_return_status => l_api_return_status
1058: , x_msg_count => x_msg_count

Line 1062: , p_tree_mode => inv_quantity_tree_pub.g_reservation_mode

1058: , x_msg_count => x_msg_count
1059: , x_msg_data => x_msg_data
1060: , p_organization_id => p_mo_line_rec.organization_id
1061: , p_inventory_item_id => p_mo_line_rec.inventory_item_id
1062: , p_tree_mode => inv_quantity_tree_pub.g_reservation_mode
1063: , p_is_revision_control => l_is_revision_control
1064: , p_is_lot_control => l_is_lot_control
1065: , p_is_serial_control => l_is_serial_control
1066: , p_demand_source_type_id => p_demand_source_type

Line 1077: , p_quantity_type => inv_quantity_tree_pub.g_qr_same_demand

1073: , p_subinventory_code => NULL
1074: , p_locator_id => NULL
1075: , p_primary_quantity => l_quantity_to_reserve
1076: , p_secondary_quantity => l_sec_quantity_to_reserve -- Bug 7377744
1077: , p_quantity_type => inv_quantity_tree_pub.g_qr_same_demand
1078: , x_qoh => l_qty_on_hand
1079: , x_rqoh => l_qty_res_on_hand
1080: , x_qr => l_qty_res
1081: , x_qs => l_qty_sug

Line 2632: inv_quantity_tree_pub.update_quantities(

2628: END IF;
2629:
2630:
2631: -- Added secondary qty related parameters section for Bug 7377744
2632: inv_quantity_tree_pub.update_quantities(
2633: p_api_version_number => 1.0
2634: , p_init_msg_lst => fnd_api.g_false
2635: , x_return_status => l_api_return_status
2636: , x_msg_count => x_msg_count

Line 2640: , p_tree_mode => inv_quantity_tree_pub.g_reservation_mode

2636: , x_msg_count => x_msg_count
2637: , x_msg_data => x_msg_data
2638: , p_organization_id => p_mo_line_rec.organization_id
2639: , p_inventory_item_id => p_mo_line_rec.inventory_item_id
2640: , p_tree_mode => inv_quantity_tree_pub.g_reservation_mode
2641: , p_is_revision_control => l_is_revision_control
2642: , p_is_lot_control => l_is_lot_control
2643: , p_is_serial_control => l_is_serial_control
2644: , p_demand_source_type_id => l_demand_source_type

Line 2655: , p_quantity_type => inv_quantity_tree_pub.g_qr_same_demand

2651: , p_subinventory_code => NULL
2652: , p_locator_id => NULL
2653: , p_primary_quantity => -(l_rsv_qty_available)
2654: , p_secondary_quantity => -(l_rsv_qty2_available) -- Bug 7377744
2655: , p_quantity_type => inv_quantity_tree_pub.g_qr_same_demand
2656: , x_qoh => l_qty_on_hand
2657: , x_rqoh => l_qty_res_on_hand
2658: , x_qr => l_qty_res
2659: , x_qs => l_qty_sug

Line 2960: inv_quantity_tree_pub.update_quantities(

2956: --update quantity tree
2957: IF is_debug THEN
2958: print_debug('updating quantity tree', 'Inv_Pick_Release_PVT.Process_Line');
2959: END IF;
2960: inv_quantity_tree_pub.update_quantities(
2961: p_api_version_number => 1.0
2962: , p_init_msg_lst => fnd_api.g_false
2963: , x_return_status => l_api_return_status
2964: , x_msg_count => x_msg_count

Line 2968: , p_tree_mode => inv_quantity_tree_pub.g_reservation_mode

2964: , x_msg_count => x_msg_count
2965: , x_msg_data => x_msg_data
2966: , p_organization_id => p_mo_line_rec.organization_id
2967: , p_inventory_item_id => p_mo_line_rec.inventory_item_id
2968: , p_tree_mode => inv_quantity_tree_pub.g_reservation_mode
2969: , p_is_revision_control => l_is_revision_control
2970: , p_is_lot_control => l_is_lot_control
2971: , p_is_serial_control => l_is_serial_control
2972: , p_demand_source_type_id => l_demand_source_type

Line 2984: , p_quantity_type => inv_quantity_tree_pub.g_qr_same_demand

2980: , p_locator_id => l_demand_rsvs_ordered(l_res_ordered_index).locator_id
2981: , p_primary_quantity => -(l_reservation_detailed_qty - l_prev_rsv_detailed_qty)
2982: , p_secondary_quantity => -(l_rsv_detailed_qty2 - l_prev_rsv_detailed_qty2) /* Bug 7377744 */
2983: , p_lpn_id => l_demand_rsvs_ordered(l_res_ordered_index).lpn_id /* Bug 7229711 */
2984: , p_quantity_type => inv_quantity_tree_pub.g_qr_same_demand
2985: , x_qoh => l_qty_on_hand
2986: , x_rqoh => l_qty_res_on_hand
2987: , x_qr => l_qty_res
2988: , x_qs => l_qty_sug