192:
193: -- Get Who Information
194:
195: l_Sourcing_Rule_rec.last_update_date := SYSDATE;
196: l_Sourcing_Rule_rec.last_updated_by := FND_GLOBAL.USER_ID;
197: l_Sourcing_Rule_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
198:
199: IF l_Sourcing_Rule_rec.operation = MRP_Globals.G_OPR_UPDATE THEN
200:
193: -- Get Who Information
194:
195: l_Sourcing_Rule_rec.last_update_date := SYSDATE;
196: l_Sourcing_Rule_rec.last_updated_by := FND_GLOBAL.USER_ID;
197: l_Sourcing_Rule_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
198:
199: IF l_Sourcing_Rule_rec.operation = MRP_Globals.G_OPR_UPDATE THEN
200:
201: MRP_Sourcing_Rule_Handlers.Update_Row (l_Sourcing_Rule_rec);
202:
203: ELSIF l_Sourcing_Rule_rec.operation = MRP_Globals.G_OPR_CREATE THEN
204:
205: l_Sourcing_Rule_rec.creation_date := SYSDATE;
206: l_Sourcing_Rule_rec.created_by := FND_GLOBAL.USER_ID;
207:
208: MRP_Sourcing_Rule_Handlers.Insert_Row (l_Sourcing_Rule_rec);
209:
210: END IF;
455:
456: -- Get Who Information
457:
458: l_Receiving_Org_rec.last_update_date := SYSDATE;
459: l_Receiving_Org_rec.last_updated_by := FND_GLOBAL.USER_ID;
460: l_Receiving_Org_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
461:
462: IF l_Receiving_Org_rec.operation = MRP_Globals.G_OPR_UPDATE THEN
463:
456: -- Get Who Information
457:
458: l_Receiving_Org_rec.last_update_date := SYSDATE;
459: l_Receiving_Org_rec.last_updated_by := FND_GLOBAL.USER_ID;
460: l_Receiving_Org_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
461:
462: IF l_Receiving_Org_rec.operation = MRP_Globals.G_OPR_UPDATE THEN
463:
464: MRP_Receiving_Org_Handlers.Update_Row (l_Receiving_Org_rec);
465:
466: ELSIF l_Receiving_Org_rec.operation = MRP_Globals.G_OPR_CREATE THEN
467:
468: l_Receiving_Org_rec.creation_date := SYSDATE;
469: l_Receiving_Org_rec.created_by := FND_GLOBAL.USER_ID;
470:
471: -- dbms_output.put_line ('Inserting Rec Org');
472: MRP_Receiving_Org_Handlers.Insert_Row (l_Receiving_Org_rec);
473:
752:
753: -- Get Who Information
754:
755: l_Shipping_Org_rec.last_update_date := SYSDATE;
756: l_Shipping_Org_rec.last_updated_by := FND_GLOBAL.USER_ID;
757: l_Shipping_Org_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
758:
759: IF l_Shipping_Org_rec.operation = MRP_Globals.G_OPR_UPDATE THEN
760:
753: -- Get Who Information
754:
755: l_Shipping_Org_rec.last_update_date := SYSDATE;
756: l_Shipping_Org_rec.last_updated_by := FND_GLOBAL.USER_ID;
757: l_Shipping_Org_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
758:
759: IF l_Shipping_Org_rec.operation = MRP_Globals.G_OPR_UPDATE THEN
760:
761: MRP_Shipping_Org_Handlers.Update_Row (l_Shipping_Org_rec);
762:
763: ELSIF l_Shipping_Org_rec.operation = MRP_Globals.G_OPR_CREATE THEN
764:
765: l_Shipping_Org_rec.creation_date := SYSDATE;
766: l_Shipping_Org_rec.created_by := FND_GLOBAL.USER_ID;
767:
768: MRP_Shipping_Org_Handlers.Insert_Row (l_Shipping_Org_rec);
769:
770: END IF;