189: x_row_id := l_x_RQT_rec.row_id;
190:
191: -- Load display out parameters if any
192:
193: l_RQT_val_rec := QP_Rqt_Util.Get_Values
194: ( p_RQT_rec => l_x_RQT_rec
195: );
196: x_enabled := l_RQT_val_rec.enabled;
197: x_pte := l_RQT_val_rec.pte;
364: );
365:
366: l_old_RQT_rec := l_RQT_rec;
367:
368: IF p_attr_id = QP_Rqt_Util.G_ENABLED THEN
369: l_RQT_rec.enabled_flag := p_attr_value;
370: ELSIF p_attr_id = QP_Rqt_Util.G_LINE_LEVEL_GLOBAL_STRUCT THEN
371: l_RQT_rec.line_level_global_struct := p_attr_value;
372: ELSIF p_attr_id = QP_Rqt_Util.G_LINE_LEVEL_VIEW_NAME THEN
366: l_old_RQT_rec := l_RQT_rec;
367:
368: IF p_attr_id = QP_Rqt_Util.G_ENABLED THEN
369: l_RQT_rec.enabled_flag := p_attr_value;
370: ELSIF p_attr_id = QP_Rqt_Util.G_LINE_LEVEL_GLOBAL_STRUCT THEN
371: l_RQT_rec.line_level_global_struct := p_attr_value;
372: ELSIF p_attr_id = QP_Rqt_Util.G_LINE_LEVEL_VIEW_NAME THEN
373: l_RQT_rec.line_level_view_name := p_attr_value;
374: ELSIF p_attr_id = QP_Rqt_Util.G_ORDER_LEVEL_GLOBAL_STRUCT THEN
368: IF p_attr_id = QP_Rqt_Util.G_ENABLED THEN
369: l_RQT_rec.enabled_flag := p_attr_value;
370: ELSIF p_attr_id = QP_Rqt_Util.G_LINE_LEVEL_GLOBAL_STRUCT THEN
371: l_RQT_rec.line_level_global_struct := p_attr_value;
372: ELSIF p_attr_id = QP_Rqt_Util.G_LINE_LEVEL_VIEW_NAME THEN
373: l_RQT_rec.line_level_view_name := p_attr_value;
374: ELSIF p_attr_id = QP_Rqt_Util.G_ORDER_LEVEL_GLOBAL_STRUCT THEN
375: l_RQT_rec.order_level_global_struct := p_attr_value;
376: ELSIF p_attr_id = QP_Rqt_Util.G_ORDER_LEVEL_VIEW_NAME THEN
370: ELSIF p_attr_id = QP_Rqt_Util.G_LINE_LEVEL_GLOBAL_STRUCT THEN
371: l_RQT_rec.line_level_global_struct := p_attr_value;
372: ELSIF p_attr_id = QP_Rqt_Util.G_LINE_LEVEL_VIEW_NAME THEN
373: l_RQT_rec.line_level_view_name := p_attr_value;
374: ELSIF p_attr_id = QP_Rqt_Util.G_ORDER_LEVEL_GLOBAL_STRUCT THEN
375: l_RQT_rec.order_level_global_struct := p_attr_value;
376: ELSIF p_attr_id = QP_Rqt_Util.G_ORDER_LEVEL_VIEW_NAME THEN
377: l_RQT_rec.order_level_view_name := p_attr_value;
378: ELSIF p_attr_id = QP_Rqt_Util.G_PTE THEN
372: ELSIF p_attr_id = QP_Rqt_Util.G_LINE_LEVEL_VIEW_NAME THEN
373: l_RQT_rec.line_level_view_name := p_attr_value;
374: ELSIF p_attr_id = QP_Rqt_Util.G_ORDER_LEVEL_GLOBAL_STRUCT THEN
375: l_RQT_rec.order_level_global_struct := p_attr_value;
376: ELSIF p_attr_id = QP_Rqt_Util.G_ORDER_LEVEL_VIEW_NAME THEN
377: l_RQT_rec.order_level_view_name := p_attr_value;
378: ELSIF p_attr_id = QP_Rqt_Util.G_PTE THEN
379: l_RQT_rec.pte_code := p_attr_value;
380: ELSIF p_attr_id = QP_Rqt_Util.G_REQUEST_TYPE THEN
374: ELSIF p_attr_id = QP_Rqt_Util.G_ORDER_LEVEL_GLOBAL_STRUCT THEN
375: l_RQT_rec.order_level_global_struct := p_attr_value;
376: ELSIF p_attr_id = QP_Rqt_Util.G_ORDER_LEVEL_VIEW_NAME THEN
377: l_RQT_rec.order_level_view_name := p_attr_value;
378: ELSIF p_attr_id = QP_Rqt_Util.G_PTE THEN
379: l_RQT_rec.pte_code := p_attr_value;
380: ELSIF p_attr_id = QP_Rqt_Util.G_REQUEST_TYPE THEN
381: l_RQT_rec.request_type_code := p_attr_value;
382: ELSIF p_attr_id = QP_Rqt_Util.G_REQUEST_TYPE_DESC THEN
376: ELSIF p_attr_id = QP_Rqt_Util.G_ORDER_LEVEL_VIEW_NAME THEN
377: l_RQT_rec.order_level_view_name := p_attr_value;
378: ELSIF p_attr_id = QP_Rqt_Util.G_PTE THEN
379: l_RQT_rec.pte_code := p_attr_value;
380: ELSIF p_attr_id = QP_Rqt_Util.G_REQUEST_TYPE THEN
381: l_RQT_rec.request_type_code := p_attr_value;
382: ELSIF p_attr_id = QP_Rqt_Util.G_REQUEST_TYPE_DESC THEN
383: l_RQT_rec.request_type_desc := p_attr_value;
384: ELSIF p_attr_id = QP_Rqt_Util.G_ROW THEN
378: ELSIF p_attr_id = QP_Rqt_Util.G_PTE THEN
379: l_RQT_rec.pte_code := p_attr_value;
380: ELSIF p_attr_id = QP_Rqt_Util.G_REQUEST_TYPE THEN
381: l_RQT_rec.request_type_code := p_attr_value;
382: ELSIF p_attr_id = QP_Rqt_Util.G_REQUEST_TYPE_DESC THEN
383: l_RQT_rec.request_type_desc := p_attr_value;
384: ELSIF p_attr_id = QP_Rqt_Util.G_ROW THEN
385: l_RQT_rec.row_id := p_attr_value;
386: ELSIF p_attr_id = QP_Rqt_Util.G_ATTRIBUTE1
380: ELSIF p_attr_id = QP_Rqt_Util.G_REQUEST_TYPE THEN
381: l_RQT_rec.request_type_code := p_attr_value;
382: ELSIF p_attr_id = QP_Rqt_Util.G_REQUEST_TYPE_DESC THEN
383: l_RQT_rec.request_type_desc := p_attr_value;
384: ELSIF p_attr_id = QP_Rqt_Util.G_ROW THEN
385: l_RQT_rec.row_id := p_attr_value;
386: ELSIF p_attr_id = QP_Rqt_Util.G_ATTRIBUTE1
387: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE10
388: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE11
382: ELSIF p_attr_id = QP_Rqt_Util.G_REQUEST_TYPE_DESC THEN
383: l_RQT_rec.request_type_desc := p_attr_value;
384: ELSIF p_attr_id = QP_Rqt_Util.G_ROW THEN
385: l_RQT_rec.row_id := p_attr_value;
386: ELSIF p_attr_id = QP_Rqt_Util.G_ATTRIBUTE1
387: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE10
388: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE11
389: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE12
390: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE13
383: l_RQT_rec.request_type_desc := p_attr_value;
384: ELSIF p_attr_id = QP_Rqt_Util.G_ROW THEN
385: l_RQT_rec.row_id := p_attr_value;
386: ELSIF p_attr_id = QP_Rqt_Util.G_ATTRIBUTE1
387: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE10
388: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE11
389: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE12
390: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE13
391: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE14
384: ELSIF p_attr_id = QP_Rqt_Util.G_ROW THEN
385: l_RQT_rec.row_id := p_attr_value;
386: ELSIF p_attr_id = QP_Rqt_Util.G_ATTRIBUTE1
387: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE10
388: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE11
389: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE12
390: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE13
391: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE14
392: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE15
385: l_RQT_rec.row_id := p_attr_value;
386: ELSIF p_attr_id = QP_Rqt_Util.G_ATTRIBUTE1
387: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE10
388: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE11
389: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE12
390: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE13
391: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE14
392: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE15
393: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE2
386: ELSIF p_attr_id = QP_Rqt_Util.G_ATTRIBUTE1
387: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE10
388: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE11
389: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE12
390: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE13
391: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE14
392: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE15
393: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE2
394: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE3
387: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE10
388: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE11
389: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE12
390: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE13
391: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE14
392: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE15
393: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE2
394: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE3
395: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE4
388: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE11
389: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE12
390: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE13
391: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE14
392: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE15
393: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE2
394: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE3
395: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE4
396: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE5
389: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE12
390: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE13
391: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE14
392: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE15
393: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE2
394: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE3
395: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE4
396: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE5
397: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE6
390: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE13
391: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE14
392: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE15
393: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE2
394: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE3
395: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE4
396: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE5
397: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE6
398: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE7
391: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE14
392: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE15
393: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE2
394: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE3
395: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE4
396: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE5
397: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE6
398: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE7
399: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE8
392: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE15
393: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE2
394: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE3
395: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE4
396: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE5
397: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE6
398: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE7
399: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE8
400: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE9
393: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE2
394: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE3
395: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE4
396: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE5
397: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE6
398: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE7
399: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE8
400: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE9
401: OR p_attr_id = QP_Rqt_Util.G_CONTEXT
394: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE3
395: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE4
396: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE5
397: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE6
398: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE7
399: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE8
400: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE9
401: OR p_attr_id = QP_Rqt_Util.G_CONTEXT
402: THEN
395: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE4
396: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE5
397: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE6
398: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE7
399: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE8
400: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE9
401: OR p_attr_id = QP_Rqt_Util.G_CONTEXT
402: THEN
403:
396: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE5
397: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE6
398: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE7
399: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE8
400: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE9
401: OR p_attr_id = QP_Rqt_Util.G_CONTEXT
402: THEN
403:
404: l_RQT_rec.attribute1 := p_attribute1;
397: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE6
398: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE7
399: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE8
400: OR p_attr_id = QP_Rqt_Util.G_ATTRIBUTE9
401: OR p_attr_id = QP_Rqt_Util.G_CONTEXT
402: THEN
403:
404: l_RQT_rec.attribute1 := p_attribute1;
405: l_RQT_rec.attribute10 := p_attribute10;
512: x_row := FND_API.G_MISS_CHAR;
513:
514: -- Load display out parameters if any
515:
516: l_RQT_val_rec := QP_Rqt_Util.Get_Values
517: ( p_RQT_rec => l_x_RQT_rec
518: , p_old_RQT_rec => l_RQT_rec
519: );
520:
1374: THEN
1375:
1376: -- Query row from DB
1377:
1378: g_RQT_rec := QP_Rqt_Util.Query_Row
1379: ( p_request_type_code => p_request_type_code
1380: );
1381:
1382: g_RQT_rec.db_flag := FND_API.G_TRUE;