DBA Data[Home] [Help]

APPS.GMD_AUTO_STEP_CALC dependencies on INV_CONVERT

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

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

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

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

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

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

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

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

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

1127: ELSE
1128: P_work_step_tbl(X_cur_rec).line_mass_qty := X_temp_qty;
1129: END IF;
1130: -- Shikha Nagar B2304515
1131: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_batch_rec.inventory_item_id
1132: ,precision => 5
1133: ,from_quantity => X_batch_rec.actual_qty
1134: ,from_unit => X_batch_rec.dtl_um
1135: ,to_unit => G_mass_std_um

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

1147: ELSE
1148: P_work_step_tbl(X_cur_rec).actual_mass_qty := X_temp_qty;
1149: END IF;
1150:
1151: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_batch_rec.inventory_item_id
1152: ,precision => 5
1153: ,from_quantity => X_batch_rec.plan_qty
1154: ,from_unit => X_batch_rec.dtl_um
1155: ,to_unit => G_vol_std_um

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

1168: P_work_step_tbl(X_cur_rec).line_vol_qty := X_temp_qty;
1169: END IF;
1170:
1171: -- Shikha Nagar B2304515
1172: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_batch_rec.inventory_item_id
1173: ,precision => 5
1174: ,from_quantity => X_batch_rec.actual_qty
1175: ,from_unit => X_batch_rec.dtl_um
1176: ,to_unit => G_vol_std_um

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

1189: P_work_step_tbl(X_cur_rec).actual_vol_qty := X_temp_qty;
1190: END IF;
1191:
1192: ELSE /* Condition that checks for other type um */
1193: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_batch_rec.inventory_item_id
1194: ,precision => 5
1195: ,from_quantity => X_batch_rec.plan_qty
1196: ,from_unit => X_batch_rec.dtl_um
1197: ,to_unit => G_other_std_um

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

1210: ELSE
1211: P_work_step_tbl(X_cur_rec).line_other_qty := X_temp_qty;
1212: END IF;
1213: -- Shikha Nagar B2304515
1214: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_batch_rec.inventory_item_id
1215: ,precision => 5
1216: ,from_quantity => X_batch_rec.actual_qty
1217: ,from_unit => X_batch_rec.dtl_um
1218: ,to_unit => G_other_std_um

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

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

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

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

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

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

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

1940: to the step qty are convertible to the mass and volume uom types */
1941: FOR x_material_rec IN Cur_get_material_lines (X_recipe_details_rec.formula_id) LOOP
1942:
1943: IF (G_PROFILE_OTHER_UM_TYPE IS NULL) THEN
1944: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_material_rec.inventory_item_id
1945: ,precision => 5
1946: ,from_quantity => X_material_rec.qty
1947: ,from_unit => X_material_rec.detail_uom
1948: ,to_unit => G_mass_std_um

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

1955: IF (p_ignore_mass_conv = FALSE) THEN
1956: RAISE UOM_CONVERSION_ERROR;
1957: END IF;
1958: END IF;
1959: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_material_rec.inventory_item_id
1960: ,precision => 5
1961: ,from_quantity => X_material_rec.qty
1962: ,from_unit => X_material_rec.detail_uom
1963: ,to_unit => G_vol_std_um

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

1972: RAISE UOM_CONVERSION_ERROR;
1973: END IF;
1974: END IF;
1975: ELSE /* IF the um type is of other type */
1976: X_temp_qty := INV_CONVERT.inv_um_convert(item_id => X_material_rec.inventory_item_id
1977: ,precision => 5
1978: ,from_quantity => X_material_rec.qty
1979: ,from_unit => X_material_rec.detail_uom
1980: ,to_unit => G_other_std_um