DBA Data[Home] [Help]

APPS.BEN_EFC_ADJUSTMENTS1 dependencies on HR_EFC_INFO

Line 982: hr_efc_info.insert_line('-- ');

978: ||' order by pil.per_in_ler_id ';
979: --
980: if l_efc_batch then
981: --
982: hr_efc_info.insert_line('-- ');
983: hr_efc_info.insert_line('-- Adjusting participant rate values ');
984: hr_efc_info.insert_line('-- ');
985: --
986: open c_efc_rows FOR l_sql_str using p_action_id, p_pk1, p_total_workers, p_worker_id;

Line 983: hr_efc_info.insert_line('-- Adjusting participant rate values ');

979: --
980: if l_efc_batch then
981: --
982: hr_efc_info.insert_line('-- ');
983: hr_efc_info.insert_line('-- Adjusting participant rate values ');
984: hr_efc_info.insert_line('-- ');
985: --
986: open c_efc_rows FOR l_sql_str using p_action_id, p_pk1, p_total_workers, p_worker_id;
987: --

Line 984: hr_efc_info.insert_line('-- ');

980: if l_efc_batch then
981: --
982: hr_efc_info.insert_line('-- ');
983: hr_efc_info.insert_line('-- Adjusting participant rate values ');
984: hr_efc_info.insert_line('-- ');
985: --
986: open c_efc_rows FOR l_sql_str using p_action_id, p_pk1, p_total_workers, p_worker_id;
987: --
988: elsif p_valworker_id is not null

Line 2190: hr_efc_info.insert_line('-- ');

2186: /*
2187: l_sql_str := l_sql_str||' for update of eev.element_entry_value_id ';
2188: --
2189: */
2190: hr_efc_info.insert_line('-- ');
2191: hr_efc_info.insert_line('-- Adjusting element entry values. Worker: '||p_worker_id
2192: ||' of '||p_total_workers
2193: );
2194: hr_efc_info.insert_line('-- ');

Line 2191: hr_efc_info.insert_line('-- Adjusting element entry values. Worker: '||p_worker_id

2187: l_sql_str := l_sql_str||' for update of eev.element_entry_value_id ';
2188: --
2189: */
2190: hr_efc_info.insert_line('-- ');
2191: hr_efc_info.insert_line('-- Adjusting element entry values. Worker: '||p_worker_id
2192: ||' of '||p_total_workers
2193: );
2194: hr_efc_info.insert_line('-- ');
2195: --

Line 2194: hr_efc_info.insert_line('-- ');

2190: hr_efc_info.insert_line('-- ');
2191: hr_efc_info.insert_line('-- Adjusting element entry values. Worker: '||p_worker_id
2192: ||' of '||p_total_workers
2193: );
2194: hr_efc_info.insert_line('-- ');
2195: --
2196: open c_efc_rows FOR l_sql_str using p_action_id, p_pk1, p_total_workers, p_worker_id;
2197: --
2198: elsif p_valworker_id is not null

Line 2206: hr_efc_info.insert_line('-- ');

2202: open c_efc_rows FOR l_sql_str using p_valtotal_workers, p_valworker_id;
2203: --
2204: else
2205: --
2206: hr_efc_info.insert_line('-- ');
2207: hr_efc_info.insert_line('-- Validating element entry value adjustments');
2208: hr_efc_info.insert_line('-- ');
2209: --
2210: open c_efc_rows FOR l_sql_str;

Line 2207: hr_efc_info.insert_line('-- Validating element entry value adjustments');

2203: --
2204: else
2205: --
2206: hr_efc_info.insert_line('-- ');
2207: hr_efc_info.insert_line('-- Validating element entry value adjustments');
2208: hr_efc_info.insert_line('-- ');
2209: --
2210: open c_efc_rows FOR l_sql_str;
2211: --

Line 2208: hr_efc_info.insert_line('-- ');

2204: else
2205: --
2206: hr_efc_info.insert_line('-- ');
2207: hr_efc_info.insert_line('-- Validating element entry value adjustments');
2208: hr_efc_info.insert_line('-- ');
2209: --
2210: open c_efc_rows FOR l_sql_str;
2211: --
2212: end if;

Line 3204: hr_efc_info.insert_line('-- ');

3200: ||' order by pil.per_in_ler_id, bpl.prtt_enrt_rslt_id ';
3201: --
3202: if l_efc_batch then
3203: --
3204: hr_efc_info.insert_line('-- ');
3205: hr_efc_info.insert_line('-- Adjusting benefit provider ledgers ');
3206: hr_efc_info.insert_line('-- ');
3207: --
3208: open c_efc_rows FOR l_sql_str using p_action_id, p_pk1, p_total_workers, p_worker_id;

Line 3205: hr_efc_info.insert_line('-- Adjusting benefit provider ledgers ');

3201: --
3202: if l_efc_batch then
3203: --
3204: hr_efc_info.insert_line('-- ');
3205: hr_efc_info.insert_line('-- Adjusting benefit provider ledgers ');
3206: hr_efc_info.insert_line('-- ');
3207: --
3208: open c_efc_rows FOR l_sql_str using p_action_id, p_pk1, p_total_workers, p_worker_id;
3209: --

Line 3206: hr_efc_info.insert_line('-- ');

3202: if l_efc_batch then
3203: --
3204: hr_efc_info.insert_line('-- ');
3205: hr_efc_info.insert_line('-- Adjusting benefit provider ledgers ');
3206: hr_efc_info.insert_line('-- ');
3207: --
3208: open c_efc_rows FOR l_sql_str using p_action_id, p_pk1, p_total_workers, p_worker_id;
3209: --
3210: elsif p_valworker_id is not null