APPS.MRP_FLOW_SCHEDULE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 250

	IF (   p_flow_schedule_rec.last_updated_by    = FND_API.G_MISS_NUM) THEN
		x_Flow_Schedule_Pvt_Rec.last_updated_by      := NULL;

Line: 253

		x_Flow_Schedule_Pvt_Rec.last_updated_by    := nvl(p_flow_schedule_rec.last_updated_by,FND_API.G_MISS_NUM)    ;

Line: 256

	IF (   p_flow_schedule_rec.last_update_date    = FND_API.G_MISS_DATE ) THEN
		x_Flow_Schedule_Pvt_Rec.last_update_date     := NULL;

Line: 259

		x_Flow_Schedule_Pvt_Rec.last_update_date   := nvl(p_flow_schedule_rec.last_update_date,FND_API.G_MISS_DATE)   ;

Line: 262

	IF (   p_flow_schedule_rec.last_update_login  = FND_API.G_MISS_NUM ) THEN
		x_Flow_Schedule_Pvt_Rec.last_update_login    := NULL;

Line: 265

		x_Flow_Schedule_Pvt_Rec.last_update_login  := nvl(p_flow_schedule_rec.last_update_login,FND_API.G_MISS_NUM)  ;

Line: 358

	IF (   p_flow_schedule_rec.program_update_date  = FND_API.G_MISS_DATE ) THEN
		x_Flow_Schedule_Pvt_Rec.program_update_date  := NULL;

Line: 361

		x_Flow_Schedule_Pvt_Rec.program_update_date  := nvl(p_flow_schedule_rec.program_update_date,FND_API.G_MISS_DATE)  ;

Line: 770

	IF (   p_flow_schedule_pvt_rec.last_updated_by    = FND_API.G_MISS_NUM) THEN
		x_Flow_Schedule_Rec.last_updated_by      := NULL;

Line: 773

		x_Flow_Schedule_Rec.last_updated_by    := nvl(p_flow_schedule_pvt_rec.last_updated_by,FND_API.G_MISS_NUM)    ;

Line: 776

	IF (   p_flow_schedule_pvt_rec.last_update_date    = FND_API.G_MISS_DATE ) THEN
		x_Flow_Schedule_Rec.last_update_date     := NULL;

Line: 779

		x_Flow_Schedule_Rec.last_update_date   := nvl(p_flow_schedule_pvt_rec.last_update_date,FND_API.G_MISS_DATE)   ;

Line: 782

	IF (   p_flow_schedule_pvt_rec.last_update_login  = FND_API.G_MISS_NUM ) THEN
		x_Flow_Schedule_Rec.last_update_login    := NULL;

Line: 785

		x_Flow_Schedule_Rec.last_update_login  := nvl(p_flow_schedule_pvt_rec.last_update_login,FND_API.G_MISS_NUM)  ;

Line: 878

	IF (   p_flow_schedule_pvt_rec.program_update_date  = FND_API.G_MISS_DATE ) THEN
		x_Flow_Schedule_Rec.program_update_date  := NULL;

Line: 881

		x_Flow_Schedule_Rec.program_update_date  := nvl(p_flow_schedule_pvt_rec.program_update_date,FND_API.G_MISS_DATE)  ;

Line: 1086

    ELSIF l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_UPDATE
    OR    l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_DELETE
    THEN
        l_flow_schedule_rec.db_flag := FND_API.G_TRUE;

Line: 1185

        IF l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_DELETE THEN

            MRP_Validate_Flow_Schedule.Entity_Delete
            (   x_return_status               => l_return_status
            ,   p_flow_schedule_rec           => l_flow_schedule_rec
            );

Line: 1214

        IF l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_DELETE THEN

            MRP_Flow_Schedule_Util.Delete_Row
            (   p_wip_entity_id               => l_flow_schedule_rec.wip_entity_id
            );

Line: 1225

            l_flow_schedule_rec.last_update_date := SYSDATE;

Line: 1226

            l_flow_schedule_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line: 1227

            l_flow_schedule_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 1229

            IF l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_UPDATE THEN

                MRP_Flow_Schedule_Util.Update_Row (l_flow_schedule_rec);

Line: 1238

                MRP_Flow_Schedule_Util.Insert_Row (l_flow_schedule_rec);