[Home] [Help]
167: x_user_prc_context_name := l_x_CON_rec.user_prc_context_name;
168:
169: -- Load display out parameters if any
170:
171: l_CON_val_rec := QP_Con_Util.Get_Values
172: ( p_CON_rec => l_x_CON_rec
173: );
174: x_enabled := l_CON_val_rec.enabled;
175: x_prc_context := l_CON_val_rec.prc_context;
330: );
331:
332: l_old_CON_rec := l_CON_rec;
333:
334: IF p_attr_id = QP_Con_Util.G_ENABLED THEN
335: l_CON_rec.enabled_flag := p_attr_value;
336: ELSIF p_attr_id = QP_Con_Util.G_PRC_CONTEXT_code THEN
337: l_CON_rec.prc_context_code := p_attr_value;
338: ELSIF p_attr_id = QP_Con_Util.G_PRC_CONTEXT THEN
332: l_old_CON_rec := l_CON_rec;
333:
334: IF p_attr_id = QP_Con_Util.G_ENABLED THEN
335: l_CON_rec.enabled_flag := p_attr_value;
336: ELSIF p_attr_id = QP_Con_Util.G_PRC_CONTEXT_code THEN
337: l_CON_rec.prc_context_code := p_attr_value;
338: ELSIF p_attr_id = QP_Con_Util.G_PRC_CONTEXT THEN
339: l_CON_rec.prc_context_id := TO_NUMBER(p_attr_value);
340: ELSIF p_attr_id = QP_Con_Util.G_PRC_CONTEXT_TYPE THEN
334: IF p_attr_id = QP_Con_Util.G_ENABLED THEN
335: l_CON_rec.enabled_flag := p_attr_value;
336: ELSIF p_attr_id = QP_Con_Util.G_PRC_CONTEXT_code THEN
337: l_CON_rec.prc_context_code := p_attr_value;
338: ELSIF p_attr_id = QP_Con_Util.G_PRC_CONTEXT THEN
339: l_CON_rec.prc_context_id := TO_NUMBER(p_attr_value);
340: ELSIF p_attr_id = QP_Con_Util.G_PRC_CONTEXT_TYPE THEN
341: l_CON_rec.prc_context_type := p_attr_value;
342: ELSIF p_attr_id = QP_Con_Util.G_SEEDED_DESCRIPTION THEN
336: ELSIF p_attr_id = QP_Con_Util.G_PRC_CONTEXT_code THEN
337: l_CON_rec.prc_context_code := p_attr_value;
338: ELSIF p_attr_id = QP_Con_Util.G_PRC_CONTEXT THEN
339: l_CON_rec.prc_context_id := TO_NUMBER(p_attr_value);
340: ELSIF p_attr_id = QP_Con_Util.G_PRC_CONTEXT_TYPE THEN
341: l_CON_rec.prc_context_type := p_attr_value;
342: ELSIF p_attr_id = QP_Con_Util.G_SEEDED_DESCRIPTION THEN
343: l_CON_rec.seeded_description := p_attr_value;
344: ELSIF p_attr_id = QP_Con_Util.G_SEEDED THEN
338: ELSIF p_attr_id = QP_Con_Util.G_PRC_CONTEXT THEN
339: l_CON_rec.prc_context_id := TO_NUMBER(p_attr_value);
340: ELSIF p_attr_id = QP_Con_Util.G_PRC_CONTEXT_TYPE THEN
341: l_CON_rec.prc_context_type := p_attr_value;
342: ELSIF p_attr_id = QP_Con_Util.G_SEEDED_DESCRIPTION THEN
343: l_CON_rec.seeded_description := p_attr_value;
344: ELSIF p_attr_id = QP_Con_Util.G_SEEDED THEN
345: l_CON_rec.seeded_flag := p_attr_value;
346: ELSIF p_attr_id = QP_Con_Util.G_SEEDED_PRC_CONTEXT_NAME THEN
340: ELSIF p_attr_id = QP_Con_Util.G_PRC_CONTEXT_TYPE THEN
341: l_CON_rec.prc_context_type := p_attr_value;
342: ELSIF p_attr_id = QP_Con_Util.G_SEEDED_DESCRIPTION THEN
343: l_CON_rec.seeded_description := p_attr_value;
344: ELSIF p_attr_id = QP_Con_Util.G_SEEDED THEN
345: l_CON_rec.seeded_flag := p_attr_value;
346: ELSIF p_attr_id = QP_Con_Util.G_SEEDED_PRC_CONTEXT_NAME THEN
347: l_CON_rec.seeded_prc_context_name := p_attr_value;
348: ELSIF p_attr_id = QP_Con_Util.G_USER_DESCRIPTION THEN
342: ELSIF p_attr_id = QP_Con_Util.G_SEEDED_DESCRIPTION THEN
343: l_CON_rec.seeded_description := p_attr_value;
344: ELSIF p_attr_id = QP_Con_Util.G_SEEDED THEN
345: l_CON_rec.seeded_flag := p_attr_value;
346: ELSIF p_attr_id = QP_Con_Util.G_SEEDED_PRC_CONTEXT_NAME THEN
347: l_CON_rec.seeded_prc_context_name := p_attr_value;
348: ELSIF p_attr_id = QP_Con_Util.G_USER_DESCRIPTION THEN
349: l_CON_rec.user_description := p_attr_value;
350: ELSIF p_attr_id = QP_Con_Util.G_USER_PRC_CONTEXT_NAME THEN
344: ELSIF p_attr_id = QP_Con_Util.G_SEEDED THEN
345: l_CON_rec.seeded_flag := p_attr_value;
346: ELSIF p_attr_id = QP_Con_Util.G_SEEDED_PRC_CONTEXT_NAME THEN
347: l_CON_rec.seeded_prc_context_name := p_attr_value;
348: ELSIF p_attr_id = QP_Con_Util.G_USER_DESCRIPTION THEN
349: l_CON_rec.user_description := p_attr_value;
350: ELSIF p_attr_id = QP_Con_Util.G_USER_PRC_CONTEXT_NAME THEN
351: l_CON_rec.user_prc_context_name := p_attr_value;
352: ELSIF p_attr_id = QP_Con_Util.G_ATTRIBUTE1
346: ELSIF p_attr_id = QP_Con_Util.G_SEEDED_PRC_CONTEXT_NAME THEN
347: l_CON_rec.seeded_prc_context_name := p_attr_value;
348: ELSIF p_attr_id = QP_Con_Util.G_USER_DESCRIPTION THEN
349: l_CON_rec.user_description := p_attr_value;
350: ELSIF p_attr_id = QP_Con_Util.G_USER_PRC_CONTEXT_NAME THEN
351: l_CON_rec.user_prc_context_name := p_attr_value;
352: ELSIF p_attr_id = QP_Con_Util.G_ATTRIBUTE1
353: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE10
354: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE11
348: ELSIF p_attr_id = QP_Con_Util.G_USER_DESCRIPTION THEN
349: l_CON_rec.user_description := p_attr_value;
350: ELSIF p_attr_id = QP_Con_Util.G_USER_PRC_CONTEXT_NAME THEN
351: l_CON_rec.user_prc_context_name := p_attr_value;
352: ELSIF p_attr_id = QP_Con_Util.G_ATTRIBUTE1
353: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE10
354: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE11
355: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE12
356: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE13
349: l_CON_rec.user_description := p_attr_value;
350: ELSIF p_attr_id = QP_Con_Util.G_USER_PRC_CONTEXT_NAME THEN
351: l_CON_rec.user_prc_context_name := p_attr_value;
352: ELSIF p_attr_id = QP_Con_Util.G_ATTRIBUTE1
353: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE10
354: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE11
355: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE12
356: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE13
357: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE14
350: ELSIF p_attr_id = QP_Con_Util.G_USER_PRC_CONTEXT_NAME THEN
351: l_CON_rec.user_prc_context_name := p_attr_value;
352: ELSIF p_attr_id = QP_Con_Util.G_ATTRIBUTE1
353: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE10
354: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE11
355: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE12
356: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE13
357: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE14
358: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE15
351: l_CON_rec.user_prc_context_name := p_attr_value;
352: ELSIF p_attr_id = QP_Con_Util.G_ATTRIBUTE1
353: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE10
354: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE11
355: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE12
356: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE13
357: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE14
358: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE15
359: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE2
352: ELSIF p_attr_id = QP_Con_Util.G_ATTRIBUTE1
353: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE10
354: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE11
355: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE12
356: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE13
357: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE14
358: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE15
359: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE2
360: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE3
353: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE10
354: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE11
355: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE12
356: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE13
357: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE14
358: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE15
359: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE2
360: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE3
361: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE4
354: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE11
355: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE12
356: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE13
357: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE14
358: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE15
359: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE2
360: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE3
361: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE4
362: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE5
355: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE12
356: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE13
357: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE14
358: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE15
359: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE2
360: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE3
361: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE4
362: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE5
363: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE6
356: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE13
357: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE14
358: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE15
359: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE2
360: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE3
361: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE4
362: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE5
363: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE6
364: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE7
357: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE14
358: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE15
359: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE2
360: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE3
361: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE4
362: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE5
363: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE6
364: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE7
365: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE8
358: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE15
359: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE2
360: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE3
361: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE4
362: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE5
363: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE6
364: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE7
365: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE8
366: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE9
359: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE2
360: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE3
361: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE4
362: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE5
363: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE6
364: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE7
365: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE8
366: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE9
367: OR p_attr_id = QP_Con_Util.G_CONTEXT
360: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE3
361: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE4
362: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE5
363: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE6
364: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE7
365: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE8
366: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE9
367: OR p_attr_id = QP_Con_Util.G_CONTEXT
368: THEN
361: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE4
362: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE5
363: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE6
364: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE7
365: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE8
366: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE9
367: OR p_attr_id = QP_Con_Util.G_CONTEXT
368: THEN
369:
362: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE5
363: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE6
364: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE7
365: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE8
366: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE9
367: OR p_attr_id = QP_Con_Util.G_CONTEXT
368: THEN
369:
370: l_CON_rec.attribute1 := p_attribute1;
363: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE6
364: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE7
365: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE8
366: OR p_attr_id = QP_Con_Util.G_ATTRIBUTE9
367: OR p_attr_id = QP_Con_Util.G_CONTEXT
368: THEN
369:
370: l_CON_rec.attribute1 := p_attribute1;
371: l_CON_rec.attribute10 := p_attribute10;
464: x_seeded := FND_API.G_MISS_CHAR;
465:
466: -- Load display out parameters if any
467:
468: l_CON_val_rec := QP_Con_Util.Get_Values
469: ( p_CON_rec => l_x_CON_rec
470: , p_old_CON_rec => l_CON_rec
471: );
472:
1368: THEN
1369:
1370: -- Query row from DB
1371:
1372: g_CON_rec := QP_Con_Util.Query_Row
1373: ( p_prc_context_id => p_prc_context_id
1374: );
1375:
1376: g_CON_rec.db_flag := FND_API.G_TRUE;