341: ,x_role_id => l_spa_row.role_id
342: ,x_comp_plan_id => l_spa_row.comp_plan_id
343: ,x_start_date => l_spa_row.start_date
344: ,x_end_date => l_spa_row.end_date
345: ,x_created_by => FND_GLOBAL.USER_ID
346: ,x_creation_date => sysdate
347: ,x_last_update_date => sysdate
348: ,x_last_updated_by => FND_GLOBAL.USER_ID
349: ,x_last_update_login => FND_GLOBAL.LOGIN_ID
344: ,x_end_date => l_spa_row.end_date
345: ,x_created_by => FND_GLOBAL.USER_ID
346: ,x_creation_date => sysdate
347: ,x_last_update_date => sysdate
348: ,x_last_updated_by => FND_GLOBAL.USER_ID
349: ,x_last_update_login => FND_GLOBAL.LOGIN_ID
350: ,x_attribute_category => p_attribute_rec.attribute_category
351: ,x_attribute1 => p_attribute_rec.attribute1
352: ,x_attribute2 => p_attribute_rec.attribute2
345: ,x_created_by => FND_GLOBAL.USER_ID
346: ,x_creation_date => sysdate
347: ,x_last_update_date => sysdate
348: ,x_last_updated_by => FND_GLOBAL.USER_ID
349: ,x_last_update_login => FND_GLOBAL.LOGIN_ID
350: ,x_attribute_category => p_attribute_rec.attribute_category
351: ,x_attribute1 => p_attribute_rec.attribute1
352: ,x_attribute2 => p_attribute_rec.attribute2
353: ,x_attribute3 => p_attribute_rec.attribute3
600: ,x_comp_plan_id => l_spa_row.comp_plan_id
601: ,x_start_date => l_spa_row.start_date
602: ,x_end_date => l_spa_row.end_date
603: ,x_last_update_date => sysdate
604: ,x_last_updated_by => fnd_global.user_id
605: ,x_last_update_login => fnd_global.login_id
606: ,x_attribute_category => NVL(p_attribute_rec.attribute_category,fnd_api.g_miss_char)
607: ,x_attribute1 => NVL(p_attribute_rec.attribute1,fnd_api.g_miss_char)
608: ,x_attribute2 => NVL(p_attribute_rec.attribute2,fnd_api.g_miss_char)
601: ,x_start_date => l_spa_row.start_date
602: ,x_end_date => l_spa_row.end_date
603: ,x_last_update_date => sysdate
604: ,x_last_updated_by => fnd_global.user_id
605: ,x_last_update_login => fnd_global.login_id
606: ,x_attribute_category => NVL(p_attribute_rec.attribute_category,fnd_api.g_miss_char)
607: ,x_attribute1 => NVL(p_attribute_rec.attribute1,fnd_api.g_miss_char)
608: ,x_attribute2 => NVL(p_attribute_rec.attribute2,fnd_api.g_miss_char)
609: ,x_attribute3 => NVL(p_attribute_rec.attribute3 ,fnd_api.g_miss_char)