[Home] [Help]
73: ,TO_DPIS
74: ,FROM_RULE
75: ,TO_RULE
76: FROM
77: FA_MASS_CHANGES MCH,
78: FA_METHODS FM,
79: FA_METHODS TM,
80: FA_BOOK_CONTROLS BC
81: --WHERE MCH.MASS_CHANGE_ID = P_MASS_CHANGE_ID
107: FUNCTION C_DO_UPDATEFORMULA(C_COUNT IN NUMBER) RETURN NUMBER IS
108: BEGIN
109: BEGIN
110: UPDATE
111: FA_MASS_CHANGES
112: SET
113: STATUS = 'PREVIEWED'
114: --WHERE MASS_CHANGE_ID = P_MASS_CHANGE_ID
115: WHERE MASS_CHANGE_ID = P_MASS_CHANGE_ID1