DBA Data[Home] [Help]

APPS.WMS_CARTNZN_PUB dependencies on INV_CONVERT

Line 1743: l_wt := inv_convert.inv_um_convert

1739: l_std_wt_uom := l_gross_weight_uom_code;
1740:
1741: ELSIF (l_gross_weight_uom_code <> l_std_wt_uom ) THEN
1742:
1743: l_wt := inv_convert.inv_um_convert
1744: ( l_item_id,
1745: 5,
1746: l_gross_weight,
1747: l_gross_weight_uom_code,

Line 1783: l_twt := inv_convert.inv_um_convert

1779: l_std_wt_uom := l_tare_weight_uom_code;
1780:
1781: ELSIF (l_tare_weight_uom_code <> l_std_wt_uom ) THEN
1782:
1783: l_twt := inv_convert.inv_um_convert
1784: ( l_item_id,
1785: 5,
1786: l_tare_weight,
1787: l_tare_weight_uom_code,

Line 1830: l_vol := inv_convert.inv_um_convert

1826: l_std_vol_uom := l_content_volume_uom_code;
1827:
1828: ELSIF (l_content_volume_uom_code <> l_std_vol_uom ) THEN
1829:
1830: l_vol := inv_convert.inv_um_convert
1831: ( l_item_id,
1832: 5,
1833: l_content_volume,
1834: l_content_volume_uom_code,

Line 2610: tr_wt := inv_convert.inv_um_convert

2606: tr_wt := lpn_cur.tare_weight;
2607:
2608: ELSIF (lpn_cur.tare_weight_uom_code <> gr_wt_uom_code) THEN
2609:
2610: tr_wt := inv_convert.inv_um_convert
2611: ( null,
2612: 5,
2613: lpn_cur.tare_weight,
2614: lpn_cur.tare_weight_uom_code,

Line 4151: v_tr_qty_per_cont := inv_convert.inv_um_convert

4147: END IF;
4148:
4149: v_serial_control_code := NULL;
4150:
4151: v_tr_qty_per_cont := inv_convert.inv_um_convert
4152: ( v1.inventory_item_id,
4153: 5,
4154: v_qty_per_cont,
4155: v_primary_uom_code,

Line 4162: v_sec_tr_qty_per_cont := inv_convert.inv_um_convert

4158: null
4159: );
4160: --invconv kkillams
4161: IF v1.secondary_uom_code IS NOT NULL THEN
4162: v_sec_tr_qty_per_cont := inv_convert.inv_um_convert
4163: ( v1.inventory_item_id,
4164: 5,
4165: v_qty_per_cont,
4166: v_primary_uom_code,

Line 4216: tr_space_avail_for := inv_convert.inv_um_convert

4212: ELSE
4213:
4214: if (g_trace_on = 1) then log_event(' Prim qty '||v1.primary_quantity|| ' > '||space_avail_for); END IF;
4215:
4216: tr_space_avail_for := inv_convert.inv_um_convert
4217: ( v1.inventory_item_id,
4218: 5,
4219: space_avail_for,
4220: v_primary_uom_code,

Line 4228: sec_tr_space_avail_for := inv_convert.inv_um_convert

4224: );
4225: --invconv kkillams
4226: sec_tr_space_avail_for := NULL;
4227: IF v1.secondary_uom_code IS NOT NULL THEN
4228: sec_tr_space_avail_for := inv_convert.inv_um_convert
4229: ( v1.inventory_item_id,
4230: 5,
4231: space_avail_for,
4232: v_primary_uom_code,

Line 4255: v1.transaction_quantity := inv_convert.inv_um_convert

4251:
4252:
4253: v1.primary_quantity := v1.primary_quantity - space_avail_for;
4254:
4255: v1.transaction_quantity := inv_convert.inv_um_convert
4256: ( v1.inventory_item_id,
4257: 5,
4258: v1.primary_quantity,
4259: v_primary_uom_code,

Line 4267: := inv_convert.inv_um_convert

4263: );
4264: --invconv kkillams
4265: IF v1.secondary_uom_code IS NOT NULL THEN
4266: v1.secondary_transaction_quantity
4267: := inv_convert.inv_um_convert
4268: ( v1.inventory_item_id,
4269: 5,
4270: v1.primary_quantity,
4271: v_primary_uom_code,

Line 6389: v_tr_qty_per_cont := ROUND((v_qty_per_cont * inv_convert.inv_um_convert(

6385: END IF;
6386:
6387: v_serial_control_code := NULL;
6388:
6389: v_tr_qty_per_cont := ROUND((v_qty_per_cont * inv_convert.inv_um_convert(
6390: p_item_id => v1.inventory_item_id,
6391: p_from_uom_code => v_primary_uom_code,
6392: p_to_uom_code => v1.transaction_uom
6393: )),

Line 6399: v_sec_tr_qty_per_cont := ROUND((v_qty_per_cont * inv_convert.inv_um_convert(

6395:
6396: --invconv kkillams
6397: IF v1.secondary_uom_code IS NOT NULL THEN
6398:
6399: v_sec_tr_qty_per_cont := ROUND((v_qty_per_cont * inv_convert.inv_um_convert(
6400: p_item_id => v1.inventory_item_id,
6401: p_from_uom_code => v_primary_uom_code,
6402: p_to_uom_code => v1.secondary_uom_code
6403: )),

Line 6442: tr_space_avail_for := ROUND((space_avail_for * inv_convert.inv_um_convert(

6438: v1.primary_quantity := 0;
6439: ELSE
6440: if (g_trace_on = 1) then log_event(' Prim qty '||v1.primary_quantity|| ' > '||space_avail_for); END IF;
6441:
6442: tr_space_avail_for := ROUND((space_avail_for * inv_convert.inv_um_convert(
6443: p_item_id => v1.inventory_item_id,
6444: p_from_uom_code => v_primary_uom_code,
6445: p_to_uom_code => v1.transaction_uom
6446: )),

Line 6453: sec_tr_space_avail_for := ROUND((space_avail_for * inv_convert.inv_um_convert(

6449: sec_tr_space_avail_for := NULL;
6450:
6451: IF v1.secondary_uom_code IS NOT NULL THEN
6452:
6453: sec_tr_space_avail_for := ROUND((space_avail_for * inv_convert.inv_um_convert(
6454: p_item_id => v1.inventory_item_id,
6455: p_from_uom_code => v_primary_uom_code,
6456: p_to_uom_code => v1.secondary_uom_code
6457: )),

Line 6478: v1.transaction_quantity := ROUND((v1.primary_quantity * inv_convert.inv_um_convert(

6474: );
6475:
6476: v1.primary_quantity := v1.primary_quantity - space_avail_for;
6477:
6478: v1.transaction_quantity := ROUND((v1.primary_quantity * inv_convert.inv_um_convert(
6479: p_item_id => v1.inventory_item_id,
6480: p_from_uom_code => v_primary_uom_code,
6481: p_to_uom_code => v1.transaction_uom
6482: )),

Line 6487: v1.secondary_transaction_quantity := ROUND((v1.primary_quantity * inv_convert.inv_um_convert(

6483: 5);
6484:
6485: IF v1.secondary_uom_code IS NOT NULL THEN
6486:
6487: v1.secondary_transaction_quantity := ROUND((v1.primary_quantity * inv_convert.inv_um_convert(
6488: p_item_id => v1.inventory_item_id,
6489: p_from_uom_code => v_primary_uom_code,
6490: p_to_uom_code => v1.secondary_uom_code
6491: )),