[Home] [Help]
7171: x_return_status := FND_API.G_RET_STS_SUCCESS;
7172: x_msg_count := 0;
7173: x_msg_data := NULL;
7174:
7175: Insert into pa_resource_lists_tl (
7176: LAST_UPDATE_LOGIN,
7177: CREATION_DATE,
7178: CREATED_BY,
7179: LAST_UPDATE_DATE,
7198: fnd_languages l
7199: where l.Installed_Flag in ('I', 'B')
7200: and lst.resource_list_id = p_resource_list_id
7201: and not exists (select 'Y'
7202: from pa_resource_lists_tl T
7203: where t.resource_list_id = lst.resource_list_id);
7204: EXCEPTION
7205: WHEN OTHERS THEN
7206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;