207: l_session_id number;
208: --
209: BEGIN
210: --
211: IF (hr_startup_data_api_support.return_startup_mode IN
212: ('STARTUP','GENERIC')) THEN
213: --
214: l_session_id := nvl(hr_startup_data_api_support.g_startup_session_id,
215: hr_startup_data_api_support.g_session_id);
210: --
211: IF (hr_startup_data_api_support.return_startup_mode IN
212: ('STARTUP','GENERIC')) THEN
213: --
214: l_session_id := nvl(hr_startup_data_api_support.g_startup_session_id,
215: hr_startup_data_api_support.g_session_id);
216: --
217: FOR c1 IN csr_definition(l_session_id) LOOP
218: --
211: IF (hr_startup_data_api_support.return_startup_mode IN
212: ('STARTUP','GENERIC')) THEN
213: --
214: l_session_id := nvl(hr_startup_data_api_support.g_startup_session_id,
215: hr_startup_data_api_support.g_session_id);
216: --
217: FOR c1 IN csr_definition(l_session_id) LOOP
218: --
219: INSERT INTO hr_application_ownerships