APPS.HR_DM_LIBRARY dependencies on HR_DM_RESOLVE_PKS

Line 2299: -- Insert a row into hr_dm_resolve_pks table. It will be used by TUPS.

2295: end get_func_asg_with_dev_key;
2296:
2297: -- ------------------------ ins_resolve_pks ---------------------------------
2298: -- Description:
2299: -- Insert a row into hr_dm_resolve_pks table. It will be used by TUPS.
2300: -- Input Parameters
2301: -- p_table_name - Table name
2302: -- p_source_id - Value of the first primary key column
2303: -- p_destination_id - Value of the second primary key column

Line 2333: insert into hr_dm_resolve_pks

2329: if p_source_id <> p_destination_id then
2330:
2331: -- insert row if no matching row is already present
2332:
2333: insert into hr_dm_resolve_pks
2334: ( resolve_pk_id,
2335: source_database_instance,
2336: table_name,
2337: source_id,

Line 2341: hr_dm_resolve_pks_s.nextval,

2337: source_id,
2338: destination_id
2339: )
2340: select
2341: hr_dm_resolve_pks_s.nextval,
2342: hr_dm_upload.g_data_migrator_source_db,
2343: p_table_name,
2344: p_source_id,
2345: p_destination_id

Line 2348: from hr_dm_resolve_pks

2344: p_source_id,
2345: p_destination_id
2346: from dual
2347: where not exists (select null
2348: from hr_dm_resolve_pks
2349: where source_database_instance =
2350: hr_dm_upload.g_data_migrator_source_db
2351: and table_name = p_table_name
2352: and source_id = p_source_id);

Line 2357: update hr_dm_resolve_pks

2353:
2354: -- see if a row has been inserted
2355: -- if not, then a row already exists, so we must update it
2356: if sql%rowcount = 0 then
2357: update hr_dm_resolve_pks
2358: set destination_id = p_destination_id
2359: where source_database_instance =
2360: hr_dm_upload.g_data_migrator_source_db
2361: and table_name = p_table_name

Line 2368: 'hr_dm_resolve_pks table ',15);

2364:
2365: end if;
2366:
2367: hr_dm_utility.message('INFO','HR_DM_LIBARARY - insert row into ' ||
2368: 'hr_dm_resolve_pks table ',15);
2369: hr_dm_utility.message('ROUT','exit:hr_dm_library.ins_resolve_pks',
2370: 25);
2371: exception
2372: when e_fatal_error then

Line 2409: from hr_dm_resolve_pks

2405: -- type combination
2406:
2407: cursor csr_find_destination_pk is
2408: select destination_id
2409: from hr_dm_resolve_pks
2410: where table_name = upper(p_table_name)
2411: and source_id = p_source_id
2412: and source_database_instance = hr_dm_upload.g_data_migrator_source_db;
2413: begin