302:
303: -- Set missing old record elements to NULL.
304:
305: l_old_RQT_rec :=
306: QP_Rqt_Util.Convert_Miss_To_Null (l_old_RQT_rec);
307:
308: ELSIF l_RQT_rec.operation = QP_GLOBALS.G_OPR_UPDATE
309: OR l_RQT_rec.operation = QP_GLOBALS.G_OPR_DELETE
310: THEN
315:
316: IF l_old_RQT_rec.request_type_code = FND_API.G_MISS_CHAR
317: THEN
318:
319: l_old_RQT_rec := QP_Rqt_Util.Query_Row
320: ( p_request_type_code => l_RQT_rec.request_type_code
321: );
322:
323: ELSE
324:
325: -- Set missing old record elements to NULL.
326:
327: l_old_RQT_rec :=
328: QP_Rqt_Util.Convert_Miss_To_Null (l_old_RQT_rec);
329:
330: END IF;
331:
332: -- Complete new record from old
330: END IF;
331:
332: -- Complete new record from old
333:
334: l_RQT_rec := QP_Rqt_Util.Complete_Record
335: ( p_RQT_rec => l_RQT_rec
336: , p_old_RQT_rec => l_old_RQT_rec
337: );
338:
366:
367: IF l_control_rec.change_attributes THEN
368:
369: l_p_RQT_rec := l_RQT_rec;
370: QP_Rqt_Util.Clear_Dependent_Attr
371: ( p_RQT_rec => l_p_RQT_rec
372: , p_old_RQT_rec => l_old_RQT_rec
373: , x_RQT_rec => l_RQT_rec
374: );
393: IF l_control_rec.default_attributes
394: OR l_control_rec.change_attributes
395: THEN
396: l_p_RQT_rec := l_RQT_rec;
397: QP_Rqt_Util.Apply_Attribute_Changes
398: ( p_RQT_rec => l_p_RQT_rec
399: , p_old_RQT_rec => l_old_RQT_rec
400: , x_RQT_rec => l_RQT_rec
401: );
436: IF l_control_rec.write_to_db THEN
437:
438: IF l_RQT_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
439:
440: QP_Rqt_Util.Delete_Row
441: ( p_request_type_code => l_RQT_rec.request_type_code
442: );
443:
444: ELSE
450: l_RQT_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
451:
452: IF l_RQT_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
453:
454: QP_Rqt_Util.Update_Row (l_RQT_rec);
455:
456: ELSIF l_RQT_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
457:
458: l_RQT_rec.creation_date := SYSDATE;
457:
458: l_RQT_rec.creation_date := SYSDATE;
459: l_RQT_rec.created_by := FND_GLOBAL.USER_ID;
460:
461: QP_Rqt_Util.Insert_Row (l_RQT_rec);
462:
463: END IF;
464:
465: END IF;
2408: FOR I IN 1..p_RQT_tbl.COUNT LOOP
2409:
2410: IF p_RQT_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2411:
2412: QP_Rqt_Util.Lock_Row
2413: ( p_RQT_rec => p_RQT_tbl(I)
2414: , x_RQT_rec => l_RQT_rec
2415: , x_return_status => l_return_status
2416: );
2660: );
2661:
2662: -- Get RQT ( parent = PTE )
2663:
2664: l_RQT_tbl := QP_Rqt_Util.Query_Rows
2665: ( p_lookup_code => l_PTE_rec.lookup_code
2666: );
2667:
2668: