DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on INV_CONVERT

Line 3111: l_hours := inv_convert.inv_um_convert (null,6,l_lead_time,l_lead_time_uom,l_default_unit_for_hour,null,null);

3107: l_hours := 0;
3108: l_days := 0;
3109: shipping_option := true;
3110: IF l_lead_time > 0 THEN
3111: l_hours := inv_convert.inv_um_convert (null,6,l_lead_time,l_lead_time_uom,l_default_unit_for_hour,null,null);
3112: IF l_hours >= 24 then
3113: IF l_delivery_time is null THEN
3114: l_hours := l_hours ;
3115: l_delivery_date := (l_sysdate + (1/24) * l_hours);

Line 3290: l_hours := inv_convert.inv_um_convert (null,6,l_lead_time,l_lead_time_uom,l_default_unit_for_hour,null,null);

3286: l_hours := 0;
3287: l_days := 0;
3288: x_shipping_option := true;
3289: IF l_lead_time > 0 THEN
3290: l_hours := inv_convert.inv_um_convert (null,6,l_lead_time,l_lead_time_uom,l_default_unit_for_hour,null,null);
3291: IF l_hours >= 24 then
3292: IF l_delivery_time is null THEN
3293: l_hours := l_hours ;
3294: l_delivery_date := (SYSDATE + (1/24) * l_hours);

Line 3930: inv_convert.inv_um_convert(item_id => p_parts_list(I).item_id

3926: FETCH primary_uom_code INTO l_primary_uom_code;
3927: CLOSE primary_uom_code;
3928: IF l_primary_uom_code <> p_parts_list(I).item_uom THEN
3929: l_unavailable_list(l_unavailable_list.count).quantity :=
3930: inv_convert.inv_um_convert(item_id => p_parts_list(I).item_id
3931: , precision => NULL -- use default precision
3932: , from_quantity => p_parts_list(I).quantity
3933: , from_unit => p_parts_list(I).item_uom
3934: , to_unit => l_primary_uom_code

Line 4013: inv_convert.inv_um_convert(item_id => l_supersede_items(J)

4009: EXIT WHEN primary_uom_code% NOTFOUND;
4010: END LOOP;
4011: CLOSE primary_uom_code;
4012: l_temp_quantity :=
4013: inv_convert.inv_um_convert(item_id => l_supersede_items(J)
4014: , precision => NULL -- use default precision
4015: , from_quantity => p_parts_list(I).quantity
4016: , from_unit => p_parts_list(I).item_uom
4017: , to_unit => l_uom_code

Line 4044: inv_convert.inv_um_convert(item_id => l_substitute_item

4040: EXIT WHEN primary_uom_code% NOTFOUND;
4041: END LOOP;
4042: CLOSE primary_uom_code;
4043: l_temp_quantity :=
4044: inv_convert.inv_um_convert(item_id => l_substitute_item
4045: , precision => NULL -- use default precision
4046: , from_quantity => p_parts_list(I).quantity
4047: , from_unit => p_parts_list(I).item_uom
4048: , to_unit => l_uom_code

Line 4267: x_availability(loop_count).available_quantity := inv_convert.inv_um_convert(item_id => l_final_available_list(K).item_id

4263: x_availability(loop_count).shipping_methode := l_final_available_list(k).shipping_methode;
4264: x_availability(loop_count).item_type := l_final_available_list(k).item_type ;
4265: x_availability(loop_count).sub_inventory_code := l_final_available_list(k).sub_inventory;
4266:
4267: x_availability(loop_count).available_quantity := inv_convert.inv_um_convert(item_id => l_final_available_list(K).item_id
4268: , precision => NULL -- use default precision
4269: , from_quantity => l_final_available_list(K).available_quantity
4270: , from_unit => l_final_available_list(K).item_uom
4271: , to_unit => p_parts_list(I).item_uom

Line 4334: x_availability(loop_count).available_quantity := inv_convert.inv_um_convert(item_id => l_available_list(J).item_id

4330: -- x_availability(loop_count).ordered_quantity := l_available_list(J).quantity;
4331: x_availability(loop_count).item_type := l_available_list(J).item_type ;
4332: -- x_availability(loop_count).source_type := 'IO' ;
4333: x_availability(loop_count).sub_inventory_code := l_available_list(J).sub_inventory;
4334: x_availability(loop_count).available_quantity := inv_convert.inv_um_convert(item_id => l_available_list(J).item_id
4335: , precision => NULL -- use default precision
4336: , from_quantity => l_available_list(J).available_quantity
4337: , from_unit => l_available_list(J).item_uom
4338: , to_unit => p_parts_list(I).item_uom

Line 4783: inv_convert.inv_um_convert(item_id => x_available_list(x_available_list.count).item_id

4779: close primary_uom_code;
4780:
4781: -- for available_quantity
4782: x_available_list(x_available_list.count).available_quantity :=
4783: inv_convert.inv_um_convert(item_id => x_available_list(x_available_list.count).item_id
4784: , precision => NULL -- use default precision
4785: , from_quantity => l_att
4786: , from_unit => l_primary_uom
4787: , to_unit => x_available_list(x_available_list.count).item_uom

Line 4794: inv_convert.inv_um_convert(item_id => x_available_list(x_available_list.count).item_id

4790: );
4791:
4792: -- for on_hand_quantity
4793: x_available_list(x_available_list.count).on_hand_quantity :=
4794: inv_convert.inv_um_convert(item_id => x_available_list(x_available_list.count).item_id
4795: , precision => NULL -- use default precision
4796: , from_quantity => l_onhand
4797: , from_unit => l_primary_uom
4798: , to_unit => x_available_list(x_available_list.count).item_uom

Line 4956: inv_convert.inv_um_convert(item_id => x_available_list(x_available_list.count).item_id

4952: close primary_uom_code;
4953:
4954: -- for available_quantity
4955: x_available_list(x_available_list.count).available_quantity :=
4956: inv_convert.inv_um_convert(item_id => x_available_list(x_available_list.count).item_id
4957: , precision => NULL -- use default precision
4958: , from_quantity => l_att
4959: , from_unit => l_primary_uom
4960: , to_unit => x_available_list(x_available_list.count).item_uom

Line 4967: inv_convert.inv_um_convert(item_id => x_available_list(x_available_list.count).item_id

4963: );
4964:
4965: -- for on_hand_quantity
4966: x_available_list(x_available_list.count).on_hand_quantity :=
4967: inv_convert.inv_um_convert(item_id => x_available_list(x_available_list.count).item_id
4968: , precision => NULL -- use default precision
4969: , from_quantity => l_onhand
4970: , from_unit => l_primary_uom
4971: , to_unit => x_available_list(x_available_list.count).item_uom

Line 5250: inv_convert.inv_um_convert(item_id => l_supersede_items(J)

5246: END LOOP;
5247: CLOSE primary_uom_code;
5248:
5249: l_temp_quantity :=
5250: inv_convert.inv_um_convert(item_id => l_supersede_items(J)
5251: , precision => NULL -- use default precision
5252: , from_quantity => p_parts_rec.quantity
5253: , from_unit => p_parts_rec.item_uom
5254: , to_unit => l_uom_code

Line 5281: inv_convert.inv_um_convert(item_id => l_substitute_item

5277: EXIT WHEN primary_uom_code% NOTFOUND;
5278: END LOOP;
5279: CLOSE primary_uom_code;
5280: l_temp_quantity :=
5281: inv_convert.inv_um_convert(item_id => l_substitute_item
5282: , precision => NULL -- use default precision
5283: , from_quantity => p_parts_rec.quantity
5284: , from_unit => p_parts_rec.item_uom
5285: , to_unit => l_uom_code