DBA Data[Home] [Help]

APPS.GMD_COMMON_VAL dependencies on GMD_COMMON_SCALE

Line 1005: l_scale_tab GMD_COMMON_SCALE.scale_tab;

1001: AND formula_id = vFormula_id;
1002:
1003: /* Bug 1683702 - Thomas Daniel */
1004: l_count NUMBER(5) DEFAULT 0;
1005: l_scale_tab GMD_COMMON_SCALE.scale_tab;
1006: l_material_tab GMD_COMMON_SCALE.scale_tab;
1007:
1008: -- NPD Conv. Use inventory_iem_id and detail_uom instead of item_id and item_um
1009: CURSOR Get_formula_lines (vFormula_id NUMBER) IS

Line 1006: l_material_tab GMD_COMMON_SCALE.scale_tab;

1002:
1003: /* Bug 1683702 - Thomas Daniel */
1004: l_count NUMBER(5) DEFAULT 0;
1005: l_scale_tab GMD_COMMON_SCALE.scale_tab;
1006: l_material_tab GMD_COMMON_SCALE.scale_tab;
1007:
1008: -- NPD Conv. Use inventory_iem_id and detail_uom instead of item_id and item_um
1009: CURSOR Get_formula_lines (vFormula_id NUMBER) IS
1010: SELECT line_no, line_type, inventory_item_id, qty, detail_uom, scale_type,

Line 1096: GMD_COMMON_SCALE.scale (p_scale_tab => l_scale_tab

1092: IF NVL(p_scale_factor, 1) = 1 THEN
1093: l_material_tab := l_scale_tab;
1094: ELSE
1095: -- NPD Conv. Pass orgn_id to the scale proc.
1096: GMD_COMMON_SCALE.scale (p_scale_tab => l_scale_tab
1097: ,p_orgn_id => l_orgn_id
1098: ,p_scale_factor => p_scale_factor
1099: ,p_primaries => p_primaries
1100: ,x_scale_tab => l_material_tab

Line 2545: l_material_tab gmd_common_scale.scale_tab;

2541:
2542: -- Definition of variables
2543: l_auto_calc VARCHAR2(1) := 'N';
2544: l_count NUMBER (5) DEFAULT 0;
2545: l_material_tab gmd_common_scale.scale_tab;
2546: l_uom fm_matl_dtl.item_um%TYPE;
2547: l_conv_uom VARCHAR2(30);
2548: l_temp_qty NUMBER := 0;
2549: