DBA Data[Home] [Help]

APPS.GMD_COMMON_VAL dependencies on GMD_COMMON_SCALE

Line 1006: l_scale_tab GMD_COMMON_SCALE.scale_tab;

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

Line 1007: l_material_tab GMD_COMMON_SCALE.scale_tab;

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

Line 1097: GMD_COMMON_SCALE.scale (p_scale_tab => l_scale_tab

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

Line 2603: l_material_tab gmd_common_scale.scale_tab;

2599:
2600: -- Definition of variables
2601: l_auto_calc VARCHAR2(1) := 'N';
2602: l_count NUMBER (5) DEFAULT 0;
2603: l_material_tab gmd_common_scale.scale_tab;
2604: l_uom VARCHAR2(30);
2605: l_conv_uom VARCHAR2(30);
2606: l_temp_qty NUMBER := 0;
2607: