DBA Data[Home] [Help]

APPS.GMD_VALIDITY_RULES dependencies on GMD_COMMON_SCALE

Line 1764: l_scale_tab_in GMD_COMMON_SCALE.scale_tab;

1760: l_cost_mthd VARCHAR2(25);
1761: l_cost_source NUMBER(15);
1762: l_product_qty NUMBER := 0;
1763: l_product_uom VARCHAR2(3);
1764: l_scale_tab_in GMD_COMMON_SCALE.scale_tab;
1765: l_scale_tab_out GMD_COMMON_SCALE.scale_tab;
1766: l_count BINARY_INTEGER := 0;
1767: l_return_status VARCHAR2(1);
1768: l_return_id BINARY_INTEGER;

Line 1765: l_scale_tab_out GMD_COMMON_SCALE.scale_tab;

1761: l_cost_source NUMBER(15);
1762: l_product_qty NUMBER := 0;
1763: l_product_uom VARCHAR2(3);
1764: l_scale_tab_in GMD_COMMON_SCALE.scale_tab;
1765: l_scale_tab_out GMD_COMMON_SCALE.scale_tab;
1766: l_count BINARY_INTEGER := 0;
1767: l_return_status VARCHAR2(1);
1768: l_return_id BINARY_INTEGER;
1769: l_cost NUMBER;

Line 1833: GMD_COMMON_SCALE.scale(p_scale_tab => l_scale_tab_in

1829:
1830: /* Lets check if we need to scale the formula based on the requested qty */
1831: IF (l_product_qty <> p_requested_qty) OR
1832: (p_requested_uom <> l_product_uom) THEN
1833: GMD_COMMON_SCALE.scale(p_scale_tab => l_scale_tab_in
1834: ,p_orgn_id => G_cost_source_orgn_id
1835: ,p_scale_factor => p_requested_qty / l_product_qty
1836: ,p_primaries => 'PRODUCT'
1837: ,x_scale_tab => l_scale_tab_out