APPS.GMD_VERSION_CONTROL dependencies on GMD_FORMULA_SUBSTITUTION

Line 1663: l_formula_substitution_id gmd_formula_substitution.formula_substitution_id%type;

1659: l_rowid VARCHAR2(18);
1660: X_recipe_vers NUMBER;
1661: X_row NUMBER;
1662: l_substitution_line_id gmd_item_substitution_dtl.substitution_line_id%type;
1663: l_formula_substitution_id gmd_formula_substitution.formula_substitution_id%type;
1664:
1665: CURSOR cur_hdr_s IS
1666: SELECT gmd_item_substitution_hdr_s.nextval
1667: FROM DUAL;

Line 1672: SELECT gmd_formula_substitution_s.nextval

1668: CURSOR cur_dtl_s IS
1669: SELECT gmd_item_substitution_dtl_s.nextval
1670: FROM DUAL;
1671: CURSOR cur_frsb_s IS
1672: SELECT gmd_formula_substitution_s.nextval
1673: FROM DUAL;
1674:
1675: CURSOR Cur_get_hdr IS
1676: SELECT *

Line 1699: FROM GMD_FORMULA_SUBSTITUTION

1695: X_get_det_tbl get_det;
1696:
1697: CURSOR Cur_formula_sub IS
1698: SELECT *
1699: FROM GMD_FORMULA_SUBSTITUTION
1700: WHERE substitution_id = p_substitution_id;
1701:
1702: TYPE formula_sub IS TABLE OF Cur_formula_sub%ROWTYPE INDEX BY BINARY_INTEGER;
1703: X_formula_sub_tbl formula_sub;

Line 1792: GMD_FORMULA_SUBSTITUTION_PKG.INSERT_ROW(

1788: OPEN cur_frsb_s;
1789: FETCH cur_frsb_s INTO l_formula_substitution_id;
1790: CLOSE cur_frsb_s;
1791: l_rowid :=NULL;
1792: GMD_FORMULA_SUBSTITUTION_PKG.INSERT_ROW(
1793: X_ROWID => l_rowid,
1794: X_FORMULA_SUBSTITUTION_ID => l_formula_substitution_id,
1795: X_SUBSTITUTION_ID => x_substitution_id,
1796: X_FORMULA_ID => X_formula_sub_tbl(i).FORMULA_ID,