DBA Data[Home] [Help]

APPS.GMD_FORMULA_DESIGNER_PKG dependencies on FM_MATL_DTL

Line 742: FROM fm_matl_dtl

738: WHERE formula_id = p_formula_id;
739:
740: CURSOR Cur_get_line IS
741: SELECT *
742: FROM fm_matl_dtl
743: WHERE formulaline_id = p_formulaline_id AND
744: last_update_date = p_last_update_date_orig;
745:
746: l_line_rec Cur_get_line%ROWTYPE;

Line 898: update fm_matl_dtl

894: This is called when the user sets the parameter and enters the % value for a
895: product. Then for other products, the % is made 0 so that later validation does
896: not fail. */
897: if l_auto_product_calc = 'Y' THEN
898: update fm_matl_dtl
899: set prod_percent = 0
900: where formula_id = p_formula_id
901: and formulaline_id <> p_formulaline_id
902: and line_type = 1

Line 1163: FROM fm_matl_dtl

1159: x_error_msg OUT NOCOPY VARCHAR2) IS
1160:
1161: CURSOR Cur_get_dtl IS
1162: SELECT formulaline_id
1163: FROM fm_matl_dtl
1164: WHERE formula_id = p_formula_id AND
1165: formulaline_id = p_formulaline_id AND
1166: last_update_date = p_last_update_date;
1167:

Line 1266: FROM fm_matl_dtl

1262: x_error_msg OUT NOCOPY VARCHAR2) IS
1263:
1264: CURSOR Cur_get_dtl IS
1265: SELECT formulaline_id
1266: FROM fm_matl_dtl
1267: WHERE formula_id = p_formula_id AND
1268: formulaline_id = p_formulaline_id AND
1269: last_update_date = p_last_update_date;
1270:

Line 1296: fm_matl_dtl

1292:
1293: CLOSE Cur_get_dtl;
1294:
1295: DELETE FROM
1296: fm_matl_dtl
1297: WHERE
1298: formulaline_id = p_formulaline_id;
1299:
1300: EXCEPTION

Line 1347: FROM fm_matl_dtl

1343: COST_ALLOC_EXCEPTION EXCEPTION;
1344:
1345: CURSOR Cur_cost_alloc IS
1346: SELECT SUM(cost_alloc)
1347: FROM fm_matl_dtl
1348: WHERE line_type = 1
1349: AND formula_id = p_formula_id
1350: AND formulaline_id <> p_formulaline_id;
1351:

Line 1722: fm_matl_dtl

1718: scale_multiple,
1719: scale_rounding_variance,
1720: rounding_direction
1721: FROM
1722: fm_matl_dtl
1723: WHERE
1724: formula_id = p_formula_id;
1725:
1726: l_scale_tab GMD_COMMON_SCALE.scale_tab;

Line 1733: TYPE LineNoTab IS TABLE OF FM_MATL_DTL.line_no%TYPE;

1729: l_msg_data VARCHAR2(2000);
1730: l_message VARCHAR2(1000);
1731: l_dummy NUMBER;
1732: THEORETICAL_YIELD_EXCEPTION EXCEPTION;
1733: TYPE LineNoTab IS TABLE OF FM_MATL_DTL.line_no%TYPE;
1734: TYPE LineTypeTab IS TABLE OF FM_MATL_DTL.line_type%TYPE;
1735: TYPE ItemIdTab IS TABLE OF FM_MATL_DTL.inventory_item_id%TYPE; -- NPD Conv.
1736: TYPE QtyTab IS TABLE OF FM_MATL_DTL.qty%TYPE;
1737: TYPE ItemUmTab IS TABLE OF FM_MATL_DTL.detail_uom%TYPE; -- NPD Conv.

Line 1734: TYPE LineTypeTab IS TABLE OF FM_MATL_DTL.line_type%TYPE;

1730: l_message VARCHAR2(1000);
1731: l_dummy NUMBER;
1732: THEORETICAL_YIELD_EXCEPTION EXCEPTION;
1733: TYPE LineNoTab IS TABLE OF FM_MATL_DTL.line_no%TYPE;
1734: TYPE LineTypeTab IS TABLE OF FM_MATL_DTL.line_type%TYPE;
1735: TYPE ItemIdTab IS TABLE OF FM_MATL_DTL.inventory_item_id%TYPE; -- NPD Conv.
1736: TYPE QtyTab IS TABLE OF FM_MATL_DTL.qty%TYPE;
1737: TYPE ItemUmTab IS TABLE OF FM_MATL_DTL.detail_uom%TYPE; -- NPD Conv.
1738: TYPE ScaleTypeTab IS TABLE OF FM_MATL_DTL.scale_type%TYPE;

Line 1735: TYPE ItemIdTab IS TABLE OF FM_MATL_DTL.inventory_item_id%TYPE; -- NPD Conv.

1731: l_dummy NUMBER;
1732: THEORETICAL_YIELD_EXCEPTION EXCEPTION;
1733: TYPE LineNoTab IS TABLE OF FM_MATL_DTL.line_no%TYPE;
1734: TYPE LineTypeTab IS TABLE OF FM_MATL_DTL.line_type%TYPE;
1735: TYPE ItemIdTab IS TABLE OF FM_MATL_DTL.inventory_item_id%TYPE; -- NPD Conv.
1736: TYPE QtyTab IS TABLE OF FM_MATL_DTL.qty%TYPE;
1737: TYPE ItemUmTab IS TABLE OF FM_MATL_DTL.detail_uom%TYPE; -- NPD Conv.
1738: TYPE ScaleTypeTab IS TABLE OF FM_MATL_DTL.scale_type%TYPE;
1739: TYPE ContributeYieldIndTab IS TABLE OF FM_MATL_DTL.contribute_yield_ind%TYPE;

Line 1736: TYPE QtyTab IS TABLE OF FM_MATL_DTL.qty%TYPE;

1732: THEORETICAL_YIELD_EXCEPTION EXCEPTION;
1733: TYPE LineNoTab IS TABLE OF FM_MATL_DTL.line_no%TYPE;
1734: TYPE LineTypeTab IS TABLE OF FM_MATL_DTL.line_type%TYPE;
1735: TYPE ItemIdTab IS TABLE OF FM_MATL_DTL.inventory_item_id%TYPE; -- NPD Conv.
1736: TYPE QtyTab IS TABLE OF FM_MATL_DTL.qty%TYPE;
1737: TYPE ItemUmTab IS TABLE OF FM_MATL_DTL.detail_uom%TYPE; -- NPD Conv.
1738: TYPE ScaleTypeTab IS TABLE OF FM_MATL_DTL.scale_type%TYPE;
1739: TYPE ContributeYieldIndTab IS TABLE OF FM_MATL_DTL.contribute_yield_ind%TYPE;
1740: TYPE ScaleMultipleTab IS TABLE OF FM_MATL_DTL.scale_multiple%TYPE;

Line 1737: TYPE ItemUmTab IS TABLE OF FM_MATL_DTL.detail_uom%TYPE; -- NPD Conv.

1733: TYPE LineNoTab IS TABLE OF FM_MATL_DTL.line_no%TYPE;
1734: TYPE LineTypeTab IS TABLE OF FM_MATL_DTL.line_type%TYPE;
1735: TYPE ItemIdTab IS TABLE OF FM_MATL_DTL.inventory_item_id%TYPE; -- NPD Conv.
1736: TYPE QtyTab IS TABLE OF FM_MATL_DTL.qty%TYPE;
1737: TYPE ItemUmTab IS TABLE OF FM_MATL_DTL.detail_uom%TYPE; -- NPD Conv.
1738: TYPE ScaleTypeTab IS TABLE OF FM_MATL_DTL.scale_type%TYPE;
1739: TYPE ContributeYieldIndTab IS TABLE OF FM_MATL_DTL.contribute_yield_ind%TYPE;
1740: TYPE ScaleMultipleTab IS TABLE OF FM_MATL_DTL.scale_multiple%TYPE;
1741: TYPE ScaleRoundingTab IS TABLE OF FM_MATL_DTL.scale_rounding_variance%TYPE;

Line 1738: TYPE ScaleTypeTab IS TABLE OF FM_MATL_DTL.scale_type%TYPE;

1734: TYPE LineTypeTab IS TABLE OF FM_MATL_DTL.line_type%TYPE;
1735: TYPE ItemIdTab IS TABLE OF FM_MATL_DTL.inventory_item_id%TYPE; -- NPD Conv.
1736: TYPE QtyTab IS TABLE OF FM_MATL_DTL.qty%TYPE;
1737: TYPE ItemUmTab IS TABLE OF FM_MATL_DTL.detail_uom%TYPE; -- NPD Conv.
1738: TYPE ScaleTypeTab IS TABLE OF FM_MATL_DTL.scale_type%TYPE;
1739: TYPE ContributeYieldIndTab IS TABLE OF FM_MATL_DTL.contribute_yield_ind%TYPE;
1740: TYPE ScaleMultipleTab IS TABLE OF FM_MATL_DTL.scale_multiple%TYPE;
1741: TYPE ScaleRoundingTab IS TABLE OF FM_MATL_DTL.scale_rounding_variance%TYPE;
1742: TYPE RoundingDirectionTab IS TABLE OF FM_MATL_DTL.rounding_direction%TYPE;

Line 1739: TYPE ContributeYieldIndTab IS TABLE OF FM_MATL_DTL.contribute_yield_ind%TYPE;

1735: TYPE ItemIdTab IS TABLE OF FM_MATL_DTL.inventory_item_id%TYPE; -- NPD Conv.
1736: TYPE QtyTab IS TABLE OF FM_MATL_DTL.qty%TYPE;
1737: TYPE ItemUmTab IS TABLE OF FM_MATL_DTL.detail_uom%TYPE; -- NPD Conv.
1738: TYPE ScaleTypeTab IS TABLE OF FM_MATL_DTL.scale_type%TYPE;
1739: TYPE ContributeYieldIndTab IS TABLE OF FM_MATL_DTL.contribute_yield_ind%TYPE;
1740: TYPE ScaleMultipleTab IS TABLE OF FM_MATL_DTL.scale_multiple%TYPE;
1741: TYPE ScaleRoundingTab IS TABLE OF FM_MATL_DTL.scale_rounding_variance%TYPE;
1742: TYPE RoundingDirectionTab IS TABLE OF FM_MATL_DTL.rounding_direction%TYPE;
1743:

Line 1740: TYPE ScaleMultipleTab IS TABLE OF FM_MATL_DTL.scale_multiple%TYPE;

1736: TYPE QtyTab IS TABLE OF FM_MATL_DTL.qty%TYPE;
1737: TYPE ItemUmTab IS TABLE OF FM_MATL_DTL.detail_uom%TYPE; -- NPD Conv.
1738: TYPE ScaleTypeTab IS TABLE OF FM_MATL_DTL.scale_type%TYPE;
1739: TYPE ContributeYieldIndTab IS TABLE OF FM_MATL_DTL.contribute_yield_ind%TYPE;
1740: TYPE ScaleMultipleTab IS TABLE OF FM_MATL_DTL.scale_multiple%TYPE;
1741: TYPE ScaleRoundingTab IS TABLE OF FM_MATL_DTL.scale_rounding_variance%TYPE;
1742: TYPE RoundingDirectionTab IS TABLE OF FM_MATL_DTL.rounding_direction%TYPE;
1743:
1744: l_line_no LineNoTab;

Line 1741: TYPE ScaleRoundingTab IS TABLE OF FM_MATL_DTL.scale_rounding_variance%TYPE;

1737: TYPE ItemUmTab IS TABLE OF FM_MATL_DTL.detail_uom%TYPE; -- NPD Conv.
1738: TYPE ScaleTypeTab IS TABLE OF FM_MATL_DTL.scale_type%TYPE;
1739: TYPE ContributeYieldIndTab IS TABLE OF FM_MATL_DTL.contribute_yield_ind%TYPE;
1740: TYPE ScaleMultipleTab IS TABLE OF FM_MATL_DTL.scale_multiple%TYPE;
1741: TYPE ScaleRoundingTab IS TABLE OF FM_MATL_DTL.scale_rounding_variance%TYPE;
1742: TYPE RoundingDirectionTab IS TABLE OF FM_MATL_DTL.rounding_direction%TYPE;
1743:
1744: l_line_no LineNoTab;
1745: l_line_type LineTypeTab;

Line 1742: TYPE RoundingDirectionTab IS TABLE OF FM_MATL_DTL.rounding_direction%TYPE;

1738: TYPE ScaleTypeTab IS TABLE OF FM_MATL_DTL.scale_type%TYPE;
1739: TYPE ContributeYieldIndTab IS TABLE OF FM_MATL_DTL.contribute_yield_ind%TYPE;
1740: TYPE ScaleMultipleTab IS TABLE OF FM_MATL_DTL.scale_multiple%TYPE;
1741: TYPE ScaleRoundingTab IS TABLE OF FM_MATL_DTL.scale_rounding_variance%TYPE;
1742: TYPE RoundingDirectionTab IS TABLE OF FM_MATL_DTL.rounding_direction%TYPE;
1743:
1744: l_line_no LineNoTab;
1745: l_line_type LineTypeTab;
1746: l_inventory_item_id ItemIdTab; -- NPD Conv.

Line 1877: fm_matl_dtl

1873: scale_multiple,
1874: scale_rounding_variance,
1875: rounding_direction
1876: FROM
1877: fm_matl_dtl
1878: WHERE
1879: formula_id = p_formula_id;
1880:
1881: l_scale_tab GMD_COMMON_SCALE.scale_tab;

Line 1888: TYPE LineNoTab IS TABLE OF FM_MATL_DTL.line_no%TYPE;

1884: l_msg_data VARCHAR2(2000);
1885: l_message VARCHAR2(1000);
1886: l_dummy NUMBER;
1887: SCALE_EXCEPTION EXCEPTION;
1888: TYPE LineNoTab IS TABLE OF FM_MATL_DTL.line_no%TYPE;
1889: TYPE LineTypeTab IS TABLE OF FM_MATL_DTL.line_type%TYPE;
1890: TYPE ItemIdTab IS TABLE OF FM_MATL_DTL.inventory_item_id%TYPE; --NPD Conv.
1891: TYPE QtyTab IS TABLE OF FM_MATL_DTL.qty%TYPE;
1892: TYPE ItemUmTab IS TABLE OF FM_MATL_DTL.detail_uom%TYPE; --NPD Conv.

Line 1889: TYPE LineTypeTab IS TABLE OF FM_MATL_DTL.line_type%TYPE;

1885: l_message VARCHAR2(1000);
1886: l_dummy NUMBER;
1887: SCALE_EXCEPTION EXCEPTION;
1888: TYPE LineNoTab IS TABLE OF FM_MATL_DTL.line_no%TYPE;
1889: TYPE LineTypeTab IS TABLE OF FM_MATL_DTL.line_type%TYPE;
1890: TYPE ItemIdTab IS TABLE OF FM_MATL_DTL.inventory_item_id%TYPE; --NPD Conv.
1891: TYPE QtyTab IS TABLE OF FM_MATL_DTL.qty%TYPE;
1892: TYPE ItemUmTab IS TABLE OF FM_MATL_DTL.detail_uom%TYPE; --NPD Conv.
1893: TYPE ScaleTypeTab IS TABLE OF FM_MATL_DTL.scale_type%TYPE;

Line 1890: TYPE ItemIdTab IS TABLE OF FM_MATL_DTL.inventory_item_id%TYPE; --NPD Conv.

1886: l_dummy NUMBER;
1887: SCALE_EXCEPTION EXCEPTION;
1888: TYPE LineNoTab IS TABLE OF FM_MATL_DTL.line_no%TYPE;
1889: TYPE LineTypeTab IS TABLE OF FM_MATL_DTL.line_type%TYPE;
1890: TYPE ItemIdTab IS TABLE OF FM_MATL_DTL.inventory_item_id%TYPE; --NPD Conv.
1891: TYPE QtyTab IS TABLE OF FM_MATL_DTL.qty%TYPE;
1892: TYPE ItemUmTab IS TABLE OF FM_MATL_DTL.detail_uom%TYPE; --NPD Conv.
1893: TYPE ScaleTypeTab IS TABLE OF FM_MATL_DTL.scale_type%TYPE;
1894: TYPE ContributeYieldIndTab IS TABLE OF FM_MATL_DTL.contribute_yield_ind%TYPE;

Line 1891: TYPE QtyTab IS TABLE OF FM_MATL_DTL.qty%TYPE;

1887: SCALE_EXCEPTION EXCEPTION;
1888: TYPE LineNoTab IS TABLE OF FM_MATL_DTL.line_no%TYPE;
1889: TYPE LineTypeTab IS TABLE OF FM_MATL_DTL.line_type%TYPE;
1890: TYPE ItemIdTab IS TABLE OF FM_MATL_DTL.inventory_item_id%TYPE; --NPD Conv.
1891: TYPE QtyTab IS TABLE OF FM_MATL_DTL.qty%TYPE;
1892: TYPE ItemUmTab IS TABLE OF FM_MATL_DTL.detail_uom%TYPE; --NPD Conv.
1893: TYPE ScaleTypeTab IS TABLE OF FM_MATL_DTL.scale_type%TYPE;
1894: TYPE ContributeYieldIndTab IS TABLE OF FM_MATL_DTL.contribute_yield_ind%TYPE;
1895: TYPE ScaleMultipleTab IS TABLE OF FM_MATL_DTL.scale_multiple%TYPE;

Line 1892: TYPE ItemUmTab IS TABLE OF FM_MATL_DTL.detail_uom%TYPE; --NPD Conv.

1888: TYPE LineNoTab IS TABLE OF FM_MATL_DTL.line_no%TYPE;
1889: TYPE LineTypeTab IS TABLE OF FM_MATL_DTL.line_type%TYPE;
1890: TYPE ItemIdTab IS TABLE OF FM_MATL_DTL.inventory_item_id%TYPE; --NPD Conv.
1891: TYPE QtyTab IS TABLE OF FM_MATL_DTL.qty%TYPE;
1892: TYPE ItemUmTab IS TABLE OF FM_MATL_DTL.detail_uom%TYPE; --NPD Conv.
1893: TYPE ScaleTypeTab IS TABLE OF FM_MATL_DTL.scale_type%TYPE;
1894: TYPE ContributeYieldIndTab IS TABLE OF FM_MATL_DTL.contribute_yield_ind%TYPE;
1895: TYPE ScaleMultipleTab IS TABLE OF FM_MATL_DTL.scale_multiple%TYPE;
1896: TYPE ScaleRoundingTab IS TABLE OF FM_MATL_DTL.scale_rounding_variance%TYPE;

Line 1893: TYPE ScaleTypeTab IS TABLE OF FM_MATL_DTL.scale_type%TYPE;

1889: TYPE LineTypeTab IS TABLE OF FM_MATL_DTL.line_type%TYPE;
1890: TYPE ItemIdTab IS TABLE OF FM_MATL_DTL.inventory_item_id%TYPE; --NPD Conv.
1891: TYPE QtyTab IS TABLE OF FM_MATL_DTL.qty%TYPE;
1892: TYPE ItemUmTab IS TABLE OF FM_MATL_DTL.detail_uom%TYPE; --NPD Conv.
1893: TYPE ScaleTypeTab IS TABLE OF FM_MATL_DTL.scale_type%TYPE;
1894: TYPE ContributeYieldIndTab IS TABLE OF FM_MATL_DTL.contribute_yield_ind%TYPE;
1895: TYPE ScaleMultipleTab IS TABLE OF FM_MATL_DTL.scale_multiple%TYPE;
1896: TYPE ScaleRoundingTab IS TABLE OF FM_MATL_DTL.scale_rounding_variance%TYPE;
1897: TYPE RoundingDirectionTab IS TABLE OF FM_MATL_DTL.rounding_direction%TYPE;

Line 1894: TYPE ContributeYieldIndTab IS TABLE OF FM_MATL_DTL.contribute_yield_ind%TYPE;

1890: TYPE ItemIdTab IS TABLE OF FM_MATL_DTL.inventory_item_id%TYPE; --NPD Conv.
1891: TYPE QtyTab IS TABLE OF FM_MATL_DTL.qty%TYPE;
1892: TYPE ItemUmTab IS TABLE OF FM_MATL_DTL.detail_uom%TYPE; --NPD Conv.
1893: TYPE ScaleTypeTab IS TABLE OF FM_MATL_DTL.scale_type%TYPE;
1894: TYPE ContributeYieldIndTab IS TABLE OF FM_MATL_DTL.contribute_yield_ind%TYPE;
1895: TYPE ScaleMultipleTab IS TABLE OF FM_MATL_DTL.scale_multiple%TYPE;
1896: TYPE ScaleRoundingTab IS TABLE OF FM_MATL_DTL.scale_rounding_variance%TYPE;
1897: TYPE RoundingDirectionTab IS TABLE OF FM_MATL_DTL.rounding_direction%TYPE;
1898: l_line_no LineNoTab;

Line 1895: TYPE ScaleMultipleTab IS TABLE OF FM_MATL_DTL.scale_multiple%TYPE;

1891: TYPE QtyTab IS TABLE OF FM_MATL_DTL.qty%TYPE;
1892: TYPE ItemUmTab IS TABLE OF FM_MATL_DTL.detail_uom%TYPE; --NPD Conv.
1893: TYPE ScaleTypeTab IS TABLE OF FM_MATL_DTL.scale_type%TYPE;
1894: TYPE ContributeYieldIndTab IS TABLE OF FM_MATL_DTL.contribute_yield_ind%TYPE;
1895: TYPE ScaleMultipleTab IS TABLE OF FM_MATL_DTL.scale_multiple%TYPE;
1896: TYPE ScaleRoundingTab IS TABLE OF FM_MATL_DTL.scale_rounding_variance%TYPE;
1897: TYPE RoundingDirectionTab IS TABLE OF FM_MATL_DTL.rounding_direction%TYPE;
1898: l_line_no LineNoTab;
1899: l_line_type LineTypeTab;

Line 1896: TYPE ScaleRoundingTab IS TABLE OF FM_MATL_DTL.scale_rounding_variance%TYPE;

1892: TYPE ItemUmTab IS TABLE OF FM_MATL_DTL.detail_uom%TYPE; --NPD Conv.
1893: TYPE ScaleTypeTab IS TABLE OF FM_MATL_DTL.scale_type%TYPE;
1894: TYPE ContributeYieldIndTab IS TABLE OF FM_MATL_DTL.contribute_yield_ind%TYPE;
1895: TYPE ScaleMultipleTab IS TABLE OF FM_MATL_DTL.scale_multiple%TYPE;
1896: TYPE ScaleRoundingTab IS TABLE OF FM_MATL_DTL.scale_rounding_variance%TYPE;
1897: TYPE RoundingDirectionTab IS TABLE OF FM_MATL_DTL.rounding_direction%TYPE;
1898: l_line_no LineNoTab;
1899: l_line_type LineTypeTab;
1900: l_inventory_item_id ItemIdTab; --NPD Conv.

Line 1897: TYPE RoundingDirectionTab IS TABLE OF FM_MATL_DTL.rounding_direction%TYPE;

1893: TYPE ScaleTypeTab IS TABLE OF FM_MATL_DTL.scale_type%TYPE;
1894: TYPE ContributeYieldIndTab IS TABLE OF FM_MATL_DTL.contribute_yield_ind%TYPE;
1895: TYPE ScaleMultipleTab IS TABLE OF FM_MATL_DTL.scale_multiple%TYPE;
1896: TYPE ScaleRoundingTab IS TABLE OF FM_MATL_DTL.scale_rounding_variance%TYPE;
1897: TYPE RoundingDirectionTab IS TABLE OF FM_MATL_DTL.rounding_direction%TYPE;
1898: l_line_no LineNoTab;
1899: l_line_type LineTypeTab;
1900: l_inventory_item_id ItemIdTab; --NPD Conv.
1901: l_qty QtyTab;

Line 2030: FROM fm_matl_dtl

2026: x_return_code OUT NOCOPY VARCHAR2,
2027: x_error_msg OUT NOCOPY VARCHAR2) IS
2028: CURSOR check_num_details(p_line_type NUMBER) IS
2029: SELECT 1
2030: FROM fm_matl_dtl
2031: WHERE formula_id = p_formula_id AND
2032: line_type = p_line_type;
2033:
2034: -- Sriram.S Bug# 3702561

Line 2038: FROM fm_matl_dtl

2034: -- Sriram.S Bug# 3702561
2035: -- Added the below cursor to check for ingredients with zero qty.
2036: CURSOR check_for_zero_qty (l_line_type NUMBER) IS
2037: SELECT 1
2038: FROM fm_matl_dtl
2039: WHERE formula_id = p_formula_id AND
2040: qty = 0 AND
2041: line_type = l_line_type;
2042: