208:
209: -- Get Who Information
210:
211: l_Contract_rec.last_update_date := SYSDATE;
212: l_Contract_rec.last_updated_by := FND_GLOBAL.USER_ID;
213: l_Contract_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
214:
215: IF l_Contract_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
216:
209: -- Get Who Information
210:
211: l_Contract_rec.last_update_date := SYSDATE;
212: l_Contract_rec.last_updated_by := FND_GLOBAL.USER_ID;
213: l_Contract_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
214:
215: IF l_Contract_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
216:
217: OE_Contract_Util.Update_Row (l_Contract_rec);
218:
219: ELSIF l_Contract_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
220:
221: l_Contract_rec.creation_date := SYSDATE;
222: l_Contract_rec.created_by := FND_GLOBAL.USER_ID;
223:
224: OE_Contract_Util.Insert_Row (l_Contract_rec);
225:
226: END IF;
556:
557: -- Get Who Information
558:
559: l_Agreement_rec.last_update_date := SYSDATE;
560: l_Agreement_rec.last_updated_by := FND_GLOBAL.USER_ID;
561: l_Agreement_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
562:
563: IF l_Agreement_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
564:
557: -- Get Who Information
558:
559: l_Agreement_rec.last_update_date := SYSDATE;
560: l_Agreement_rec.last_updated_by := FND_GLOBAL.USER_ID;
561: l_Agreement_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
562:
563: IF l_Agreement_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
564:
565: OE_Agreement_Util.Update_Row (l_Agreement_rec);
604:
605: ELSIF l_Agreement_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
606:
607: l_Agreement_rec.creation_date := SYSDATE;
608: l_Agreement_rec.created_by := FND_GLOBAL.USER_ID;
609:
610: OE_Agreement_Util.Insert_Row (l_Agreement_rec);
611:
612:
952:
953: -- Get Who Information
954:
955: l_Price_LHeader_rec.last_update_date := SYSDATE;
956: l_Price_LHeader_rec.last_updated_by := FND_GLOBAL.USER_ID;
957: l_Price_LHeader_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
958:
959: IF l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
960:
953: -- Get Who Information
954:
955: l_Price_LHeader_rec.last_update_date := SYSDATE;
956: l_Price_LHeader_rec.last_updated_by := FND_GLOBAL.USER_ID;
957: l_Price_LHeader_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
958:
959: IF l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
960:
961: OE_Price_List_Util.Update_Row (l_Price_LHeader_rec);
962:
963: ELSIF l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
964:
965: l_Price_LHeader_rec.creation_date := SYSDATE;
966: l_Price_LHeader_rec.created_by := FND_GLOBAL.USER_ID;
967:
968: OE_Price_List_Util.Insert_Row (l_Price_LHeader_rec);
969:
970: END IF;
1234:
1235: -- Get Who Information
1236:
1237: l_Price_LLine_rec.last_update_date := SYSDATE;
1238: l_Price_LLine_rec.last_updated_by := FND_GLOBAL.USER_ID;
1239: l_Price_LLine_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1240:
1241: IF l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1242:
1235: -- Get Who Information
1236:
1237: l_Price_LLine_rec.last_update_date := SYSDATE;
1238: l_Price_LLine_rec.last_updated_by := FND_GLOBAL.USER_ID;
1239: l_Price_LLine_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1240:
1241: IF l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1242:
1243: OE_Price_List_Line_Util.Update_Row (l_Price_LLine_rec);
1244:
1245: ELSIF l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1246:
1247: l_Price_LLine_rec.creation_date := SYSDATE;
1248: l_Price_LLine_rec.created_by := FND_GLOBAL.USER_ID;
1249:
1250:
1251: OE_Price_List_Line_Util.Insert_Row (l_Price_LLine_rec );
1252:
1566:
1567: -- Get Who Information
1568:
1569: l_Price_Break_rec.last_update_date := SYSDATE;
1570: l_Price_Break_rec.last_updated_by := FND_GLOBAL.USER_ID;
1571: l_Price_Break_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1572:
1573: IF l_Price_Break_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1574:
1567: -- Get Who Information
1568:
1569: l_Price_Break_rec.last_update_date := SYSDATE;
1570: l_Price_Break_rec.last_updated_by := FND_GLOBAL.USER_ID;
1571: l_Price_Break_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1572:
1573: IF l_Price_Break_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1574:
1575: NULL;
1578: */
1579: ELSIF l_Price_Break_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1580:
1581: l_Price_Break_rec.creation_date := SYSDATE;
1582: l_Price_Break_rec.created_by := FND_GLOBAL.USER_ID;
1583: /*
1584: OE_Price_Break_Util.Insert_Row (l_Price_Break_rec);
1585: */
1586: