APPS.HR_DM_COPY dependencies on BEN_BATCH_PARAMETER

Line 963: -- copy the ben_batch_parameter info

959:
960: end if;
961:
962:
963: -- copy the ben_batch_parameter info
964: -- only perform for an FW or A migration
965:
966: if (l_migration_type in ('FW', 'A')) then
967:

Line 986: 'BEN_BATCH_PARAMETER',

982: CREATION_DATE,
983: OBJECT_VERSION_NUMBER)
984: select
985: hr_dm_exp_imps_s.nextval,
986: 'BEN_BATCH_PARAMETER',
987: batch_parameter_id,
988: batch_exe_cd,
989: thread_cnt_num,
990: max_err_num,

Line 999: from BEN_BATCH_PARAMETER

995: last_update_login,
996: created_by,
997: to_char(creation_date,'YYYYMMDD HH24:MI:SS'),
998: object_version_number
999: from BEN_BATCH_PARAMETER
1000: where business_group_id = l_business_group_id
1001: and batch_exe_cd = 'HRDM'
1002: and last_update_date >= nvl(p_last_migration_date,
1003: last_update_date);

Line 1006: execute immediate 'delete HRDPV_UBEN_BATCH_PARAMETER ' ||

1002: and last_update_date >= nvl(p_last_migration_date,
1003: last_update_date);
1004:
1005: -- remove entry for data migrator from the batch lines table
1006: execute immediate 'delete HRDPV_UBEN_BATCH_PARAMETER ' ||
1007: ' where p_batch_exe_cd = ''HRDM''';
1008:
1009: end if;
1010:

Line 1101: from ben_batch_parameter

1097:
1098: cursor csr_batch_info_db is
1099: select
1100: batch_parameter_id
1101: from ben_batch_parameter
1102: where (business_group_id = l_business_group_id)
1103: and (batch_exe_cd = 'HRDM');
1104:
1105: begin

Line 1772: -- copy the ben_batch_parameter info

1768:
1769:
1770: end if;
1771:
1772: -- copy the ben_batch_parameter info
1773: -- only perform for an FW or A migration
1774:
1775: if (l_migration_type in ('FW', 'A')) then
1776: hr_utility.trace('Importing BEN_BATCH_PARAMETER information.');

Line 1776: hr_utility.trace('Importing BEN_BATCH_PARAMETER information.');

1772: -- copy the ben_batch_parameter info
1773: -- only perform for an FW or A migration
1774:
1775: if (l_migration_type in ('FW', 'A')) then
1776: hr_utility.trace('Importing BEN_BATCH_PARAMETER information.');
1777:
1778: open csr_batch_info;
1779: fetch csr_batch_info into
1780: l_batch_exe_cd,

Line 1795: update BEN_BATCH_PARAMETER

1791: fetch csr_batch_info_db into l_batch_parameter_id;
1792:
1793: if csr_batch_info_db%found then
1794: -- do an update
1795: update BEN_BATCH_PARAMETER
1796: set batch_exe_cd = l_batch_exe_cd,
1797: thread_cnt_num = l_thread_cnt_num,
1798: max_err_num = l_max_err_num,
1799: chunk_size = l_chunk_size,

Line 1805: insert into BEN_BATCH_PARAMETER (

1801: where (business_group_id = l_business_group_id)
1802: and (batch_exe_cd = 'HRDM');
1803: else
1804: -- do an insert
1805: insert into BEN_BATCH_PARAMETER (
1806: BATCH_PARAMETER_ID,
1807: BATCH_EXE_CD,
1808: THREAD_CNT_NUM,
1809: MAX_ERR_NUM,