APPS.HR_DM_LIBRARY dependencies on HR_DM_UPLOAD

Line 2325: -- NVL(hr_dm_upload.g_data_migrator_source_db, ''));

2321: raise e_fatal_error;
2322: end if;
2323:
2324: --hr_data_pump.message('source db is - ' ||
2325: -- NVL(hr_dm_upload.g_data_migrator_source_db, ''));
2326:
2327:
2328:
2329: if p_source_id <> p_destination_id then

Line 2342: hr_dm_upload.g_data_migrator_source_db,

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
2346: from dual

Line 2350: hr_dm_upload.g_data_migrator_source_db

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);
2353:
2354: -- see if a row has been inserted

Line 2360: hr_dm_upload.g_data_migrator_source_db

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
2362: and source_id = p_source_id;
2363: end if;
2364:

Line 2412: and source_database_instance = hr_dm_upload.g_data_migrator_source_db;

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
2414: hr_dm_utility.message('ROUT','entry:hr_dm_library.get_resolved_pk', 5);
2415: hr_dm_utility.message('PARA','(p_source_id - ' || p_source_id ||
2416: ')(p_table_name - ' || p_table_name ||