DBA Data[Home] [Help]

APPS.GMD_AUTO_STEP_CALC dependencies on INV_CONVERT

Line 1008: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_material_rec.inventory_item_id

1004:
1005: /* If all steps of OTHER um type then you dont have to bother
1006: about converting line qtys to MASS and VOLUME type um */
1007: IF NOT (G_OTHER_UM_TYPE_EXISTS) THEN
1008: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_material_rec.inventory_item_id
1009: ,precision => 5
1010: ,from_quantity => X_material_rec.qty
1011: ,from_unit => X_material_rec.detail_uom
1012: ,to_unit => G_mass_std_um

Line 1042: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_material_rec.inventory_item_id

1038: /*Commented the following IF as we need to proceed with the volume conversion though the mass */
1039: /*conversion has failed as there is a possibility of all the routing steps and the formula lines */
1040: /*belong to the same UOM type */
1041: -- IF (X_temp_qty > 0) THEN
1042: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_material_rec.inventory_item_id
1043: ,precision => 5
1044: ,from_quantity => X_material_rec.qty
1045: ,from_unit => X_material_rec.detail_uom
1046: ,to_unit => G_vol_std_um

Line 1074: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_material_rec.inventory_item_id

1070: /*Commented the END IF following IF */
1071: -- END IF;
1072: ELSE /* When only other um type exists */
1073: /* Added by Shyam - To capture the line qty in the other um types std um */
1074: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_material_rec.inventory_item_id
1075: ,precision => 5
1076: ,from_quantity => X_material_rec.qty
1077: ,from_unit => X_material_rec.detail_uom
1078: ,to_unit => G_other_std_um

Line 1116: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_batch_rec.inventory_item_id

1112:
1113: /* If all steps of OTHER um type then you dont have to bother
1114: about converting line qtys to MASS and VOLUME type um */
1115: IF NOT (G_OTHER_UM_TYPE_EXISTS) THEN
1116: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_batch_rec.inventory_item_id
1117: ,precision => 5
1118: ,from_quantity => X_batch_rec.plan_qty
1119: ,from_unit => X_batch_rec.dtl_um
1120: ,to_unit => G_mass_std_um

Line 1137: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_batch_rec.inventory_item_id

1133: ELSE
1134: P_work_step_tbl(X_cur_rec).line_mass_qty := X_temp_qty;
1135: END IF;
1136: -- Shikha Nagar B2304515
1137: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_batch_rec.inventory_item_id
1138: ,precision => 5
1139: ,from_quantity => X_batch_rec.actual_qty
1140: ,from_unit => X_batch_rec.dtl_um
1141: ,to_unit => G_mass_std_um

Line 1157: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_batch_rec.inventory_item_id

1153: ELSE
1154: P_work_step_tbl(X_cur_rec).actual_mass_qty := X_temp_qty;
1155: END IF;
1156:
1157: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_batch_rec.inventory_item_id
1158: ,precision => 5
1159: ,from_quantity => X_batch_rec.plan_qty
1160: ,from_unit => X_batch_rec.dtl_um
1161: ,to_unit => G_vol_std_um

Line 1178: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_batch_rec.inventory_item_id

1174: P_work_step_tbl(X_cur_rec).line_vol_qty := X_temp_qty;
1175: END IF;
1176:
1177: -- Shikha Nagar B2304515
1178: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_batch_rec.inventory_item_id
1179: ,precision => 5
1180: ,from_quantity => X_batch_rec.actual_qty
1181: ,from_unit => X_batch_rec.dtl_um
1182: ,to_unit => G_vol_std_um

Line 1199: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_batch_rec.inventory_item_id

1195: P_work_step_tbl(X_cur_rec).actual_vol_qty := X_temp_qty;
1196: END IF;
1197:
1198: ELSE /* Condition that checks for other type um */
1199: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_batch_rec.inventory_item_id
1200: ,precision => 5
1201: ,from_quantity => X_batch_rec.plan_qty
1202: ,from_unit => X_batch_rec.dtl_um
1203: ,to_unit => G_other_std_um

Line 1220: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_batch_rec.inventory_item_id

1216: ELSE
1217: P_work_step_tbl(X_cur_rec).line_other_qty := X_temp_qty;
1218: END IF;
1219: -- Shikha Nagar B2304515
1220: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_batch_rec.inventory_item_id
1221: ,precision => 5
1222: ,from_quantity => X_batch_rec.actual_qty
1223: ,from_unit => X_batch_rec.dtl_um
1224: ,to_unit => G_other_std_um

Line 1450: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_material_rec.inventory_item_id

1446: IF (X_material_rec.formulaline_id = p_formulaline_scale_tab(k).formulaline_id) THEN
1447: /* If all steps of OTHER um type then you dont have to bother
1448: about converting line qtys to MASS and VOLUME type um */
1449: IF NOT (G_OTHER_UM_TYPE_EXISTS) THEN
1450: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_material_rec.inventory_item_id
1451: ,precision => 5
1452: ,from_quantity => p_formulaline_scale_tab(k).qty
1453: ,from_unit => p_formulaline_scale_tab(k).detail_uom
1454: ,to_unit => G_mass_std_um

Line 1484: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_material_rec.inventory_item_id

1480: /*Commented the following IF as we need to proceed with the volume conversion though the mass */
1481: /*conversion has failed as there is a possibility of all the routing steps and the formula lines */
1482: /*belong to the same UOM type */
1483: -- IF (X_temp_qty > 0) THEN
1484: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_material_rec.inventory_item_id
1485: ,precision => 5
1486: ,from_quantity => p_formulaline_scale_tab(k).qty
1487: ,from_unit => p_formulaline_scale_tab(k).detail_uom
1488: ,to_unit => G_vol_std_um

Line 1517: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_material_rec.inventory_item_id

1513: -- END IF; /* x_temp_qty > 0 condition */
1514:
1515: ELSE /* When only other um type exists */
1516: /* Added by Shyam - To capture the line qty in the other um types std um */
1517: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_material_rec.inventory_item_id
1518: ,precision => 5
1519: ,from_quantity => p_formulaline_scale_tab(k).qty
1520: ,from_unit => p_formulaline_scale_tab(k).detail_uom
1521: ,to_unit => G_other_std_um

Line 1952: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_material_rec.inventory_item_id

1948: to the step qty are convertible to the mass and volume uom types */
1949: FOR x_material_rec IN Cur_get_material_lines (X_recipe_details_rec.formula_id) LOOP
1950:
1951: IF (G_PROFILE_OTHER_UM_TYPE IS NULL) THEN
1952: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_material_rec.inventory_item_id
1953: ,precision => 5
1954: ,from_quantity => X_material_rec.qty
1955: ,from_unit => X_material_rec.detail_uom
1956: ,to_unit => G_mass_std_um

Line 1967: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_material_rec.inventory_item_id

1963: IF (p_ignore_mass_conv = FALSE) THEN
1964: RAISE UOM_CONVERSION_ERROR;
1965: END IF;
1966: END IF;
1967: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_material_rec.inventory_item_id
1968: ,precision => 5
1969: ,from_quantity => X_material_rec.qty
1970: ,from_unit => X_material_rec.detail_uom
1971: ,to_unit => G_vol_std_um

Line 1984: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_material_rec.inventory_item_id

1980: RAISE UOM_CONVERSION_ERROR;
1981: END IF;
1982: END IF;
1983: ELSE /* IF the um type is of other type */
1984: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_material_rec.inventory_item_id
1985: ,precision => 5
1986: ,from_quantity => X_material_rec.qty
1987: ,from_unit => X_material_rec.detail_uom
1988: ,to_unit => G_other_std_um