186:
187: -- Get Who Information
188:
189: l_CON_rec.last_update_date := SYSDATE;
190: l_CON_rec.last_updated_by := FND_GLOBAL.USER_ID;
191: l_CON_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
192:
193: IF l_CON_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
194:
187: -- Get Who Information
188:
189: l_CON_rec.last_update_date := SYSDATE;
190: l_CON_rec.last_updated_by := FND_GLOBAL.USER_ID;
191: l_CON_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
192:
193: IF l_CON_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
194:
195: QP_Con_Util.Update_Row (l_CON_rec);
196:
197: ELSIF l_CON_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
198:
199: l_CON_rec.creation_date := SYSDATE;
200: l_CON_rec.created_by := FND_GLOBAL.USER_ID;
201:
202: QP_Con_Util.Insert_Row (l_CON_rec);
203:
204: END IF;
446:
447: -- Get Who Information
448:
449: l_SEG_rec.last_update_date := SYSDATE;
450: l_SEG_rec.last_updated_by := FND_GLOBAL.USER_ID;
451: l_SEG_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
452:
453: IF l_SEG_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
454:
447: -- Get Who Information
448:
449: l_SEG_rec.last_update_date := SYSDATE;
450: l_SEG_rec.last_updated_by := FND_GLOBAL.USER_ID;
451: l_SEG_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
452:
453: IF l_SEG_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
454:
455: QP_Seg_Util.Update_Row (l_SEG_rec);
456:
457: ELSIF l_SEG_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
458:
459: l_SEG_rec.creation_date := SYSDATE;
460: l_SEG_rec.created_by := FND_GLOBAL.USER_ID;
461:
462: QP_Seg_Util.Insert_Row (l_SEG_rec);
463:
464: END IF;