198: x_seeded_flag := l_x_FNA_rec.seeded_flag;
199:
200: -- Load display out parameters if any
201:
202: l_FNA_val_rec := QP_Fna_Util.Get_Values
203: ( p_FNA_rec => l_x_FNA_rec
204: );
205: x_enabled := l_FNA_val_rec.enabled;
206: x_functional_area := l_FNA_val_rec.functional_area;
371: );
372:
373: l_old_FNA_rec := l_FNA_rec;
374:
375: IF p_attr_id = QP_Fna_Util.G_ENABLED THEN
376: l_FNA_rec.enabled_flag := p_attr_value;
377: ELSIF p_attr_id = QP_Fna_Util.G_FUNCTIONAL_AREA THEN
378: l_FNA_rec.functional_area_id := TO_NUMBER(p_attr_value);
379: ELSIF p_attr_id = QP_Fna_Util.G_PTE_SOURCESYSTEM_FNAREA THEN
373: l_old_FNA_rec := l_FNA_rec;
374:
375: IF p_attr_id = QP_Fna_Util.G_ENABLED THEN
376: l_FNA_rec.enabled_flag := p_attr_value;
377: ELSIF p_attr_id = QP_Fna_Util.G_FUNCTIONAL_AREA THEN
378: l_FNA_rec.functional_area_id := TO_NUMBER(p_attr_value);
379: ELSIF p_attr_id = QP_Fna_Util.G_PTE_SOURCESYSTEM_FNAREA THEN
380: l_FNA_rec.pte_sourcesystem_fnarea_id := TO_NUMBER(p_attr_value);
381: ELSIF p_attr_id = QP_Fna_Util.G_PTE_SOURCE_SYSTEM THEN
375: IF p_attr_id = QP_Fna_Util.G_ENABLED THEN
376: l_FNA_rec.enabled_flag := p_attr_value;
377: ELSIF p_attr_id = QP_Fna_Util.G_FUNCTIONAL_AREA THEN
378: l_FNA_rec.functional_area_id := TO_NUMBER(p_attr_value);
379: ELSIF p_attr_id = QP_Fna_Util.G_PTE_SOURCESYSTEM_FNAREA THEN
380: l_FNA_rec.pte_sourcesystem_fnarea_id := TO_NUMBER(p_attr_value);
381: ELSIF p_attr_id = QP_Fna_Util.G_PTE_SOURCE_SYSTEM THEN
382: l_FNA_rec.pte_source_system_id := TO_NUMBER(p_attr_value);
383: ELSIF p_attr_id = QP_Fna_Util.G_SEEDED THEN
377: ELSIF p_attr_id = QP_Fna_Util.G_FUNCTIONAL_AREA THEN
378: l_FNA_rec.functional_area_id := TO_NUMBER(p_attr_value);
379: ELSIF p_attr_id = QP_Fna_Util.G_PTE_SOURCESYSTEM_FNAREA THEN
380: l_FNA_rec.pte_sourcesystem_fnarea_id := TO_NUMBER(p_attr_value);
381: ELSIF p_attr_id = QP_Fna_Util.G_PTE_SOURCE_SYSTEM THEN
382: l_FNA_rec.pte_source_system_id := TO_NUMBER(p_attr_value);
383: ELSIF p_attr_id = QP_Fna_Util.G_SEEDED THEN
384: l_FNA_rec.seeded_flag := p_attr_value;
385: ELSIF p_attr_id = QP_Fna_Util.G_ATTRIBUTE1
379: ELSIF p_attr_id = QP_Fna_Util.G_PTE_SOURCESYSTEM_FNAREA THEN
380: l_FNA_rec.pte_sourcesystem_fnarea_id := TO_NUMBER(p_attr_value);
381: ELSIF p_attr_id = QP_Fna_Util.G_PTE_SOURCE_SYSTEM THEN
382: l_FNA_rec.pte_source_system_id := TO_NUMBER(p_attr_value);
383: ELSIF p_attr_id = QP_Fna_Util.G_SEEDED THEN
384: l_FNA_rec.seeded_flag := p_attr_value;
385: ELSIF p_attr_id = QP_Fna_Util.G_ATTRIBUTE1
386: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE10
387: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE11
381: ELSIF p_attr_id = QP_Fna_Util.G_PTE_SOURCE_SYSTEM THEN
382: l_FNA_rec.pte_source_system_id := TO_NUMBER(p_attr_value);
383: ELSIF p_attr_id = QP_Fna_Util.G_SEEDED THEN
384: l_FNA_rec.seeded_flag := p_attr_value;
385: ELSIF p_attr_id = QP_Fna_Util.G_ATTRIBUTE1
386: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE10
387: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE11
388: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE12
389: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE13
382: l_FNA_rec.pte_source_system_id := TO_NUMBER(p_attr_value);
383: ELSIF p_attr_id = QP_Fna_Util.G_SEEDED THEN
384: l_FNA_rec.seeded_flag := p_attr_value;
385: ELSIF p_attr_id = QP_Fna_Util.G_ATTRIBUTE1
386: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE10
387: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE11
388: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE12
389: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE13
390: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE15
383: ELSIF p_attr_id = QP_Fna_Util.G_SEEDED THEN
384: l_FNA_rec.seeded_flag := p_attr_value;
385: ELSIF p_attr_id = QP_Fna_Util.G_ATTRIBUTE1
386: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE10
387: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE11
388: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE12
389: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE13
390: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE15
391: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE2
384: l_FNA_rec.seeded_flag := p_attr_value;
385: ELSIF p_attr_id = QP_Fna_Util.G_ATTRIBUTE1
386: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE10
387: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE11
388: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE12
389: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE13
390: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE15
391: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE2
392: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE3
385: ELSIF p_attr_id = QP_Fna_Util.G_ATTRIBUTE1
386: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE10
387: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE11
388: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE12
389: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE13
390: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE15
391: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE2
392: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE3
393: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE4
386: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE10
387: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE11
388: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE12
389: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE13
390: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE15
391: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE2
392: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE3
393: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE4
394: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE5
387: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE11
388: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE12
389: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE13
390: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE15
391: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE2
392: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE3
393: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE4
394: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE5
395: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE6
388: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE12
389: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE13
390: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE15
391: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE2
392: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE3
393: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE4
394: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE5
395: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE6
396: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE7
389: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE13
390: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE15
391: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE2
392: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE3
393: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE4
394: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE5
395: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE6
396: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE7
397: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE8
390: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE15
391: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE2
392: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE3
393: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE4
394: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE5
395: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE6
396: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE7
397: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE8
398: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE9
391: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE2
392: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE3
393: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE4
394: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE5
395: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE6
396: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE7
397: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE8
398: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE9
399: OR p_attr_id = QP_Fna_Util.G_CONTEXT
392: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE3
393: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE4
394: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE5
395: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE6
396: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE7
397: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE8
398: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE9
399: OR p_attr_id = QP_Fna_Util.G_CONTEXT
400: THEN
393: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE4
394: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE5
395: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE6
396: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE7
397: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE8
398: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE9
399: OR p_attr_id = QP_Fna_Util.G_CONTEXT
400: THEN
401:
394: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE5
395: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE6
396: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE7
397: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE8
398: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE9
399: OR p_attr_id = QP_Fna_Util.G_CONTEXT
400: THEN
401:
402: l_FNA_rec.attribute1 := p_attribute1;
395: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE6
396: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE7
397: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE8
398: OR p_attr_id = QP_Fna_Util.G_ATTRIBUTE9
399: OR p_attr_id = QP_Fna_Util.G_CONTEXT
400: THEN
401:
402: l_FNA_rec.attribute1 := p_attribute1;
403: l_FNA_rec.attribute10 := p_attribute10;
506: x_seeded := FND_API.G_MISS_CHAR;
507:
508: -- Load display out parameters if any
509:
510: l_FNA_val_rec := QP_Fna_Util.Get_Values
511: ( p_FNA_rec => l_x_FNA_rec
512: , p_old_FNA_rec => l_FNA_rec
513: );
514:
1339: THEN
1340:
1341: -- Query row from DB
1342:
1343: g_FNA_rec := QP_Fna_Util.Query_Row
1344: ( p_pte_sourcesystem_fnarea_id => p_pte_sourcesystem_fnarea_id
1345: );
1346:
1347: g_FNA_rec.db_flag := FND_API.G_TRUE;