DBA Data[Home] [Help]

APPS.GMD_VALIDITY_RULES dependencies on GMD_COMMON_SCALE

Line 1742: l_scale_tab_in GMD_COMMON_SCALE.scale_tab;

1738: l_cost_mthd VARCHAR2(25);
1739: l_cost_source NUMBER(15);
1740: l_product_qty NUMBER := 0;
1741: l_product_uom VARCHAR2(3);
1742: l_scale_tab_in GMD_COMMON_SCALE.scale_tab;
1743: l_scale_tab_out GMD_COMMON_SCALE.scale_tab;
1744: l_count BINARY_INTEGER := 0;
1745: l_return_status VARCHAR2(1);
1746: l_return_id BINARY_INTEGER;

Line 1743: l_scale_tab_out GMD_COMMON_SCALE.scale_tab;

1739: l_cost_source NUMBER(15);
1740: l_product_qty NUMBER := 0;
1741: l_product_uom VARCHAR2(3);
1742: l_scale_tab_in GMD_COMMON_SCALE.scale_tab;
1743: l_scale_tab_out GMD_COMMON_SCALE.scale_tab;
1744: l_count BINARY_INTEGER := 0;
1745: l_return_status VARCHAR2(1);
1746: l_return_id BINARY_INTEGER;
1747: l_cost NUMBER;

Line 1811: GMD_COMMON_SCALE.scale(p_scale_tab => l_scale_tab_in

1807:
1808: /* Lets check if we need to scale the formula based on the requested qty */
1809: IF (l_product_qty <> p_requested_qty) OR
1810: (p_requested_uom <> l_product_uom) THEN
1811: GMD_COMMON_SCALE.scale(p_scale_tab => l_scale_tab_in
1812: ,p_orgn_id => G_cost_source_orgn_id
1813: ,p_scale_factor => p_requested_qty / l_product_qty
1814: ,p_primaries => 'PRODUCT'
1815: ,x_scale_tab => l_scale_tab_out