DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on INV_CONVERT

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

5501: l_hours := 0;
5502: l_days := 0;
5503: shipping_option := true;
5504: IF l_lead_time > 0 THEN
5505: l_hours := inv_convert.inv_um_convert (null,6,l_lead_time,l_lead_time_uom,l_default_unit_for_hour,null,null);
5506: IF l_hours >= 24 then
5507: IF l_delivery_time is null THEN
5508: l_hours := l_hours ;
5509: l_delivery_date := (l_sysdate + (1/24) * l_hours);

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

5680: l_hours := 0;
5681: l_days := 0;
5682: x_shipping_option := true;
5683: IF l_lead_time > 0 THEN
5684: l_hours := inv_convert.inv_um_convert (null,6,l_lead_time,l_lead_time_uom,l_default_unit_for_hour,null,null);
5685: IF l_hours >= 24 then
5686: IF l_delivery_time is null THEN
5687: l_hours := l_hours ;
5688: l_delivery_date := (SYSDATE + (1/24) * l_hours);

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

6383: FETCH primary_uom_code INTO l_primary_uom_code;
6384: CLOSE primary_uom_code;
6385: IF l_primary_uom_code <> p_parts_list(I).item_uom THEN
6386: l_unavailable_list(l_unavailable_list.count).quantity :=
6387: inv_convert.inv_um_convert( item_id => p_parts_list(I).item_id
6388: , PRECISION => NULL -- use default precision
6389: , from_quantity => p_parts_list(I).quantity
6390: , from_unit => p_parts_list(I).item_uom
6391: , to_unit => l_primary_uom_code

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

6485: WHEN primary_uom_code% NOTFOUND;
6486: END LOOP;
6487: CLOSE primary_uom_code;
6488: log('check_parts_availability', 'l_uom_code: '||l_uom_code);
6489: l_temp_quantity := inv_convert.inv_um_convert( item_id => l_supersede_items(J)
6490: , PRECISION => NULL -- use default precision
6491: , from_quantity => p_parts_list(I).quantity
6492: , from_unit => p_parts_list(I).item_uom
6493: , to_unit => l_uom_code

Line 6525: l_temp_quantity := inv_convert.inv_um_convert(item_id => l_substitute_item , PRECISION => NULL -- use default precision

6521: WHEN primary_uom_code% NOTFOUND;
6522: end loop;
6523: CLOSE primary_uom_code;
6524: log('check_parts_availability', 'l_uom_code: '||l_uom_code);
6525: l_temp_quantity := inv_convert.inv_um_convert(item_id => l_substitute_item , PRECISION => NULL -- use default precision
6526: , from_quantity => p_parts_list(I).quantity , from_unit => p_parts_list(I).item_uom , to_unit => l_uom_code , from_name => NULL -- from uom name
6527: , to_name => NULL -- to uom name
6528: );
6529: log('check_parts_availability', 'l_temp_quantity: '||l_temp_quantity);

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

6804: x_availability(loop_count).source_org_id := l_final_available_list(k).source_org;
6805: x_availability(loop_count).shipping_methode := l_final_available_list(k).shipping_methode;
6806: x_availability(loop_count).item_type := l_final_available_list(k).item_type ;
6807: x_availability(loop_count).sub_inventory_code := l_final_available_list(k).sub_inventory;
6808: x_availability(loop_count).available_quantity := inv_convert.inv_um_convert( item_id => l_final_available_list(K).item_id
6809: , PRECISION => NULL -- use default precision
6810: , from_quantity => l_final_available_list(K).available_quantity
6811: , from_unit => l_final_available_list(K).item_uom
6812: , to_unit => p_parts_list(I).item_uom

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

6873: -- x_availability(loop_count).ordered_quantity := l_available_list(J).quantity;
6874: x_availability(loop_count).item_type := l_available_list(J).item_type ;
6875: -- x_availability(loop_count).source_type := 'IO' ;
6876: x_availability(loop_count).sub_inventory_code := l_available_list(J).sub_inventory;
6877: x_availability(loop_count).available_quantity := inv_convert.inv_um_convert( item_id => l_available_list(J).item_id
6878: , PRECISION => NULL -- use default precision
6879: , from_quantity => l_available_list(J).available_quantity
6880: , from_unit => l_available_list(J).item_uom
6881: , to_unit => p_parts_list(I).item_uom

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

7321: close primary_uom_code;
7322:
7323: -- for available_quantity
7324: x_available_list(x_available_list.count).available_quantity :=
7325: inv_convert.inv_um_convert(item_id => x_available_list(x_available_list.count).item_id
7326: , precision => NULL -- use default precision
7327: , from_quantity => l_att
7328: , from_unit => l_primary_uom
7329: , to_unit => x_available_list(x_available_list.count).item_uom

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

7332: );
7333:
7334: -- for on_hand_quantity
7335: x_available_list(x_available_list.count).on_hand_quantity :=
7336: inv_convert.inv_um_convert(item_id => x_available_list(x_available_list.count).item_id
7337: , precision => NULL -- use default precision
7338: , from_quantity => l_onhand
7339: , from_unit => l_primary_uom
7340: , to_unit => x_available_list(x_available_list.count).item_uom

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

7494: close primary_uom_code;
7495:
7496: -- for available_quantity
7497: x_available_list(x_available_list.count).available_quantity :=
7498: inv_convert.inv_um_convert(item_id => x_available_list(x_available_list.count).item_id
7499: , precision => NULL -- use default precision
7500: , from_quantity => l_att
7501: , from_unit => l_primary_uom
7502: , to_unit => x_available_list(x_available_list.count).item_uom

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

7505: );
7506:
7507: -- for on_hand_quantity
7508: x_available_list(x_available_list.count).on_hand_quantity :=
7509: inv_convert.inv_um_convert(item_id => x_available_list(x_available_list.count).item_id
7510: , precision => NULL -- use default precision
7511: , from_quantity => l_onhand
7512: , from_unit => l_primary_uom
7513: , to_unit => x_available_list(x_available_list.count).item_uom

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

7788: END LOOP;
7789: CLOSE primary_uom_code;
7790:
7791: l_temp_quantity :=
7792: inv_convert.inv_um_convert(item_id => l_supersede_items(J)
7793: , precision => NULL -- use default precision
7794: , from_quantity => p_parts_rec.quantity
7795: , from_unit => p_parts_rec.item_uom
7796: , to_unit => l_uom_code

Line 7823: inv_convert.inv_um_convert(item_id => l_substitute_item

7819: EXIT WHEN primary_uom_code% NOTFOUND;
7820: END LOOP;
7821: CLOSE primary_uom_code;
7822: l_temp_quantity :=
7823: inv_convert.inv_um_convert(item_id => l_substitute_item
7824: , precision => NULL -- use default precision
7825: , from_quantity => p_parts_rec.quantity
7826: , from_unit => p_parts_rec.item_uom
7827: , to_unit => l_uom_code