DBA Data[Home] [Help]

APPS.GMD_TECH_PARAMS dependencies on GMICUOM

Line 554: X_conv_qty := gmicuom.uom_conversion(item_master_tbl(i).item_id, item_master_tbl(i).formula_id,

550: CLOSE Cur_get_um;
551: END IF;
552: FOR i IN 1..item_master_tbl.count LOOP
553: IF (item_master_tbl(i).item_primary_uom <> item_master_tbl(i).uom) THEN
554: X_conv_qty := gmicuom.uom_conversion(item_master_tbl(i).item_id, item_master_tbl(i).formula_id,
555: item_master_tbl(i).quantity, item_master_tbl(i).uom,
556: item_master_tbl(i).item_primary_uom, 0, p_lab_type);
557: IF (X_conv_qty < 0) THEN
558: X_item_no := item_master_tbl(i).item_no;

Line 568: X_conv_qty := gmicuom.uom_conversion(item_master_tbl(i).item_id, item_master_tbl(i).formula_id,

564: END IF;
565: X_conv_qty := 0;
566: IF (X_mass_ind = 1) THEN
567: IF (item_master_tbl(i).uom <> X_mass_um) THEN
568: X_conv_qty := gmicuom.uom_conversion(item_master_tbl(i).item_id, item_master_tbl(i).formula_id,
569: item_master_tbl(i).quantity, item_master_tbl(i).uom,
570: X_mass_um, 0, p_lab_type);
571: IF (X_conv_qty < 0) THEN
572: X_item_no := item_master_tbl(i).item_no;

Line 583: X_conv_qty := gmicuom.uom_conversion(item_master_tbl(i).item_id, item_master_tbl(i).formula_id,

579: END IF;
580: X_conv_qty := 0;
581: IF (X_vol_ind = 1) THEN
582: IF (item_master_tbl(i).uom <> X_vol_um) THEN
583: X_conv_qty := gmicuom.uom_conversion(item_master_tbl(i).item_id, item_master_tbl(i).formula_id,
584: item_master_tbl(i).quantity, item_master_tbl(i).uom,
585: X_vol_um, 0, p_lab_type);
586: IF (X_conv_qty < 0) THEN
587: X_item_no := item_master_tbl(i).item_no;

Line 816: X_conv_qty := gmicuom.uom_conversion(item_master_tbl(i).item_id, item_master_tbl(i).formula_id,

812: (item_master_tbl(i).line_type = attrib_master_tbl(j).line_type) AND
813: (item_master_tbl(i).line_no = attrib_master_tbl(j).line_no) AND
814: (attrib_master_tbl(j).tech_parm_name = p_tech_parm_name)) THEN
815: IF (item_master_tbl(i).item_primary_uom <> p_prod_uom) THEN
816: X_conv_qty := gmicuom.uom_conversion(item_master_tbl(i).item_id, item_master_tbl(i).formula_id,
817: item_master_tbl(i).primary_uom_qty, item_master_tbl(i).item_primary_uom,
818: p_prod_uom, 0, p_lab_type);
819: IF (X_conv_qty < 0) THEN
820: X_item_no := item_master_tbl(i).item_no;

Line 880: X_eq_wt_qty := gmicuom.uom_conversion(item_master_tbl(i).item_id, item_master_tbl(i).formula_id,

876: (attrib_master_tbl(j).tech_parm_name = p_tech_parm_name)) THEN
877: IF (item_master_tbl(i).line_type <> 1) THEN
878: X_eq_wt_qty := item_master_tbl(i).quantity;
879: IF (item_master_tbl(i).uom <> p_prod_uom) THEN
880: X_eq_wt_qty := gmicuom.uom_conversion(item_master_tbl(i).item_id, item_master_tbl(i).formula_id,
881: item_master_tbl(i).quantity, item_master_tbl(i).uom,
882: p_prod_uom, 0, p_lab_type);
883: IF (X_eq_wt_qty < 0) THEN
884: X_item_no := item_master_tbl(i).item_no;