503: --
504:
505: -- --------------------------- seed_ua_da_data ---------------------------
506: -- Description: Seeds the passed data into the hr_dm_phase_items and the
507: -- hr_dm_loader_phase_items tables
508: --
509: --
510: -- Input Parameters
511: -- p_param_rec data record
593: -- generate filename
594: l_filename := get_filename(l_phase_item_id_da,
595: p_param_rec.loader_conc_program);
596:
597: -- hr_dm_loader_phase_items
598: INSERT INTO hr_dm_loader_phase_items (
599: loader_phase_item_id,
600: da_phase_item_id,
601: ua_phase_item_id,
594: l_filename := get_filename(l_phase_item_id_da,
595: p_param_rec.loader_conc_program);
596:
597: -- hr_dm_loader_phase_items
598: INSERT INTO hr_dm_loader_phase_items (
599: loader_phase_item_id,
600: da_phase_item_id,
601: ua_phase_item_id,
602: loader_name,
616: parameter_9,
617: parameter_10,
618: custom_code_specified)
619: SELECT
620: hr_dm_loader_phase_items_s.nextval,
621: l_phase_item_id_da,
622: l_phase_item_id_ua,
623: p_param_rec.loader_name,
624: p_param_rec.loader_conc_program,
1035:
1036: -- seed data for:
1037: -- 1. hr_dm_phase_items da phase
1038: -- 2. hr_dm_phase_items ua phase
1039: -- 3. hr_dm_loader_phase_items
1040:
1041: -- no data is automatically seeded when:
1042: -- 1. l_check_custom_flex_call is not null
1043: -- 2. up/downloading flexfield data