APPS.GMD_VERSION_CONTROL dependencies on GMD_ITEM_SUBSTITUTION_DTL

Line 1662: l_substitution_line_id gmd_item_substitution_dtl.substitution_line_id%type;

1658: --===================================================================== */
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

Line 1669: SELECT gmd_item_substitution_dtl_s.nextval

1665: CURSOR cur_hdr_s IS
1666: SELECT gmd_item_substitution_hdr_s.nextval
1667: FROM DUAL;
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;

Line 1691: FROM GMD_ITEM_SUBSTITUTION_DTL

1687: AND OWNER_ORGANIZATION_ID = X_hdr_rec.OWNER_ORGANIZATION_ID;
1688:
1689: CURSOR Cur_get_det IS
1690: SELECT *
1691: FROM GMD_ITEM_SUBSTITUTION_DTL
1692: WHERE substitution_id = p_substitution_id;
1693:
1694: TYPE get_det IS TABLE OF Cur_get_det%ROWTYPE INDEX BY BINARY_INTEGER;
1695: X_get_det_tbl get_det;

Line 1811: GMD_ITEM_SUBSTITUTION_DTL_PKG.INSERT_ROW(

1807: l_rowid :=NULL;
1808: OPEN cur_dtl_s;
1809: FETCH cur_dtl_s INTO l_substitution_line_id;
1810: CLOSE cur_dtl_s;
1811: GMD_ITEM_SUBSTITUTION_DTL_PKG.INSERT_ROW(
1812: X_ROWID => l_rowid,
1813: X_SUBSTITUTION_LINE_ID => l_substitution_line_id,
1814: X_SUBSTITUTION_ID => x_substitution_id,
1815: X_INVENTORY_ITEM_ID => X_get_det_tbl(i).INVENTORY_ITEM_ID,