198:
199: -- Get Who Information
200:
201: l_FORMULA_rec.last_update_date := SYSDATE;
202: l_FORMULA_rec.last_updated_by := FND_GLOBAL.USER_ID;
203: l_FORMULA_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
204:
205: IF l_FORMULA_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
206:
199: -- Get Who Information
200:
201: l_FORMULA_rec.last_update_date := SYSDATE;
202: l_FORMULA_rec.last_updated_by := FND_GLOBAL.USER_ID;
203: l_FORMULA_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
204:
205: IF l_FORMULA_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
206:
207: QP_Formula_Util.Update_Row (l_FORMULA_rec);
208:
209: ELSIF l_FORMULA_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
210:
211: l_FORMULA_rec.creation_date := SYSDATE;
212: l_FORMULA_rec.created_by := FND_GLOBAL.USER_ID;
213:
214: QP_Formula_Util.Insert_Row (l_FORMULA_rec);
215:
216: END IF;
471:
472: -- Get Who Information
473:
474: l_FORMULA_LINES_rec.last_update_date := SYSDATE;
475: l_FORMULA_LINES_rec.last_updated_by := FND_GLOBAL.USER_ID;
476: l_FORMULA_LINES_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
477:
478: IF l_FORMULA_LINES_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
479:
472: -- Get Who Information
473:
474: l_FORMULA_LINES_rec.last_update_date := SYSDATE;
475: l_FORMULA_LINES_rec.last_updated_by := FND_GLOBAL.USER_ID;
476: l_FORMULA_LINES_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
477:
478: IF l_FORMULA_LINES_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
479:
480: QP_Formula_Lines_Util.Update_Row (l_FORMULA_LINES_rec);
481:
482: ELSIF l_FORMULA_LINES_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
483:
484: l_FORMULA_LINES_rec.creation_date := SYSDATE;
485: l_FORMULA_LINES_rec.created_by := FND_GLOBAL.USER_ID;
486:
487: QP_Formula_Lines_Util.Insert_Row (l_FORMULA_LINES_rec);
488:
489: END IF;