eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TRAINING_PLAN_UPGRADE dependencies on OTA_UPGRADE_LOG

Line 196: from ota_upgrade_log

192: l_ret number(10);
193: cursor csr_get_pk(p_concat varchar2) is
194: select target_primary_key
195:
196: from ota_upgrade_log
197: where table_name = LP_MAP_TABLE_NAME_E
198: -- and upgrade_id = LP_MAP_UPGRADE_ID
199: and source_primary_key = p_concat;
200:

Line 212: from ota_upgrade_log

208: /*
209: begin
210: select nvl(target_primary_key,OTA_MIG_FAIL_ID)
211: into l_ret
212: from ota_upgrade_log
213: where table_name = LP_MAP_TABLE_NAME_E
214: -- and upgrade_id = LP_MAP_UPGRADE_ID
215: and source_primary_key = l_concat;
216:

Line 237: from ota_upgrade_log

233: l_ret number;
234:
235: cursor csr_get_pk(p_concat varchar2) is
236: select target_primary_key
237: from ota_upgrade_log
238: where table_name = LP_MAP_TABLE_NAME_M
239: -- and upgrade_id = LP_MAP_UPGRADE_ID
240: and source_primary_key = p_concat;
241:

Line 253: from ota_upgrade_log

249: end if;
250: /* begin
251: select nvl(target_primary_key,OTA_MIG_FAIL_ID)
252: into l_ret
253: from ota_upgrade_log
254: where table_name = LP_MAP_TABLE_NAME_M
255: -- and upgrade_id = LP_MAP_UPGRADE_ID
256: and source_primary_key = l_concat;
257:

Line 277: from ota_upgrade_log

273:
274: l_ret number(10);
275: cursor csr_get_pk(p_training_plan_member_id varchar2)is
276: select target_primary_key
277: from ota_upgrade_log
278: where table_name = LP_MAP_TABLE_NAME_M_E
279: and source_primary_key = p_training_plan_member_id;
280: begin
281: open csr_get_pk(p_training_plan_member_id);

Line 290: from ota_upgrade_log

286: /*
287: begin
288: select nvl(target_primary_key,OTA_MIG_FAIL_ID)
289: into l_ret
290: from ota_upgrade_log
291: where table_name = LP_MAP_TABLE_NAME_M_E
292: -- and upgrade_id = LP_MAP_UPGRADE_ID
293: and source_primary_key = p_training_plan_member_id;
294:

Line 317: from ota_upgrade_log

313: ,p_assignment_id in number) is
314:
315: cursor c_exists (p_concat in varchar2) is
316: select 1
317: from ota_upgrade_log
318: where table_name = LP_MAP_TABLE_NAME_E
319: -- and upgrade_id = LP_MAP_UPGRADE_ID
320: and source_primary_key = p_concat;
321:

Line 333: update ota_upgrade_log

329: open c_exists(l_concat);
330: fetch c_exists into l_dummy;
331:
332: if c_exists%found then
333: update ota_upgrade_log
334: set target_primary_key = p_new_lp_enr_id
335: where table_name = LP_MAP_TABLE_NAME_E
336: -- and upgrade_id = LP_MAP_UPGRADE_ID
337: and source_primary_key = l_concat;

Line 339: insert into ota_upgrade_log(upgrade_id,table_name,source_primary_key,target_primary_key

335: where table_name = LP_MAP_TABLE_NAME_E
336: -- and upgrade_id = LP_MAP_UPGRADE_ID
337: and source_primary_key = l_concat;
338: else
339: insert into ota_upgrade_log(upgrade_id,table_name,source_primary_key,target_primary_key
340: ,log_type,upgrade_name)
341: values (p_upgrade_id,LP_MAP_TABLE_NAME_E,l_concat,p_new_lp_enr_id
342: ,LP_LOG_TYPE_N,LP_UPGRADE_NAME);
343: end if;

Line 358: from ota_upgrade_log

354: ,p_completion_target_date date
355: ,p_new_lp_mem_id in number) is
356: cursor c_exists (l_concat in varchar2) is
357: select 1
358: from ota_upgrade_log
359: where table_name = LP_MAP_TABLE_NAME_M
360: -- and upgrade_id = LP_MAP_UPGRADE_ID
361: and source_primary_key = l_concat;
362:

Line 372: update ota_upgrade_log

368: open c_exists(l_concat);
369: fetch c_exists into l_dummy;
370:
371: if c_exists%found then
372: update ota_upgrade_log
373: set target_primary_key = p_new_lp_mem_id
374: where table_name = LP_MAP_TABLE_NAME_M
375: -- and upgrade_id = LP_MAP_UPGRADE_ID
376: and source_primary_key = l_concat;

Line 378: insert into ota_upgrade_log(upgrade_id,table_name,source_primary_key,target_primary_key

374: where table_name = LP_MAP_TABLE_NAME_M
375: -- and upgrade_id = LP_MAP_UPGRADE_ID
376: and source_primary_key = l_concat;
377: else
378: insert into ota_upgrade_log(upgrade_id,table_name,source_primary_key,target_primary_key
379: ,log_type,upgrade_name)
380: values (p_upgrade_id,LP_MAP_TABLE_NAME_M,l_concat,p_new_lp_mem_id,LP_LOG_TYPE_N,LP_UPGRADE_NAME);
381: end if;
382: close c_exists;

Line 393: from ota_upgrade_log

389: procedure set_lp_mem_enr_map (p_upgrade_id in number,p_training_plan_member_id in number
390: ,p_new_lp_mem_enr_id in number) is
391: cursor c_exists (p_training_plan_member_id in varchar2) is
392: select 1
393: from ota_upgrade_log
394: where table_name = LP_MAP_TABLE_NAME_M_E
395: -- and upgrade_id = LP_MAP_UPGRADE_ID
396: and source_primary_key = p_training_plan_member_id;
397:

Line 406: update ota_upgrade_log

402: open c_exists(p_training_plan_member_id);
403: fetch c_exists into l_dummy;
404:
405: if c_exists%found then
406: update ota_upgrade_log
407: set target_primary_key = p_new_lp_mem_enr_id
408: where table_name = LP_MAP_TABLE_NAME_M_E
409: -- and upgrade_id = LP_MAP_UPGRADE_ID
410: and source_primary_key = p_training_plan_member_id;

Line 412: insert into ota_upgrade_log(upgrade_id,table_name,source_primary_key,target_primary_key

408: where table_name = LP_MAP_TABLE_NAME_M_E
409: -- and upgrade_id = LP_MAP_UPGRADE_ID
410: and source_primary_key = p_training_plan_member_id;
411: else
412: insert into ota_upgrade_log(upgrade_id,table_name,source_primary_key,target_primary_key
413: ,log_type,upgrade_name)
414: values (p_upgrade_id,LP_MAP_TABLE_NAME_M_E,p_training_plan_member_id,p_new_lp_mem_enr_id
415: ,LP_LOG_TYPE_N,LP_UPGRADE_NAME);
416: end if;

Line 1103: from ota_upgrade_log

1099: -- for existing data in ota_learning_paths
1100: l_upgrade_id := null;
1101:
1102: select max(upgrade_id) INTO l_upgrade_id
1103: from ota_upgrade_log
1104: where upgrade_name = LP_UPGRADE_NAME;
1105:
1106: if l_upgrade_id is null then
1107: ota_classic_upgrade.add_log_entry( p_table_name=> 'DUMMY'