eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_PSI_WPS_HISTORY dependencies on BEN_EXT_PERSON

Line 265: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;

261: debug('p_assignment_id: '||p_assignment_id,10);
262: debug('p_effective_date: '||to_char(p_effective_date,'dd/mm/yyyy'),10);
263:
264: -- set the global events table
265: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
266:
267: -- set global assignment_id
268: g_assignment_id := p_assignment_id;
269: debug('g_assignment_id: '||g_assignment_id,20);

Line 300: l_prev_event_dtl_rec ben_ext_person.t_detailed_output_tab_rec;

296:
297: FUNCTION is_curr_evt_processed RETURN BOOLEAN
298: IS
299: l_proc varchar2(72) := g_proc_name||'.is_curr_evt_processed';
300: l_prev_event_dtl_rec ben_ext_person.t_detailed_output_tab_rec;
301: l_flag VARCHAR2(1);
302: BEGIN
303: debug_enter(l_proc);
304: IF g_prev_event_dtl_rec.dated_table_id IS NOT NULL THEN

Line 305: l_prev_event_dtl_rec := g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index);

301: l_flag VARCHAR2(1);
302: BEGIN
303: debug_enter(l_proc);
304: IF g_prev_event_dtl_rec.dated_table_id IS NOT NULL THEN
305: l_prev_event_dtl_rec := g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index);
306: l_prev_event_dtl_rec.change_mode := g_prev_event_dtl_rec.change_mode;
307: l_flag := 'Y';
308: IF l_prev_event_dtl_rec.dated_table_id <> g_prev_event_dtl_rec.dated_table_id THEN
309: l_flag := 'N';

Line 339: g_prev_event_dtl_rec := g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index);

335: debug('Event already processed',30);
336: debug_exit(l_proc);
337: RETURN TRUE;
338: ELSE
339: g_prev_event_dtl_rec := g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index);
340: END IF;
341: ELSE
342: debug('First event');
343: g_prev_event_dtl_rec := g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index);

Line 343: g_prev_event_dtl_rec := g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index);

339: g_prev_event_dtl_rec := g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index);
340: END IF;
341: ELSE
342: debug('First event');
343: g_prev_event_dtl_rec := g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index);
344: END IF;
345:
346: debug_exit(l_proc);
347: RETURN FALSE;

Line 610: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;

606: IF l_return = 'Y'
607: THEN
608: debug('Calling the common include event proc');
609: -- set the global events table
610: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
611: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
612: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
613: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
614: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;

Line 611: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;

607: THEN
608: debug('Calling the common include event proc');
609: -- set the global events table
610: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
611: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
612: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
613: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
614: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;
615: l_chg_column_name := g_pay_proc_evt_tab(l_curr_evt_index).column_name;

Line 612: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;

608: debug('Calling the common include event proc');
609: -- set the global events table
610: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
611: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
612: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
613: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
614: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;
615: l_chg_column_name := g_pay_proc_evt_tab(l_curr_evt_index).column_name;
616: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);

Line 1003: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;

999: debug_enter(l_proc_name);
1000: debug('g_current_run: '||g_current_run);
1001: IF g_current_run = 'PERIODIC'
1002: THEN
1003: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
1004: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
1005: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
1006: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
1007: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;

Line 1004: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;

1000: debug('g_current_run: '||g_current_run);
1001: IF g_current_run = 'PERIODIC'
1002: THEN
1003: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
1004: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
1005: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
1006: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
1007: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;
1008: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);

Line 1005: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;

1001: IF g_current_run = 'PERIODIC'
1002: THEN
1003: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
1004: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
1005: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
1006: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
1007: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;
1008: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);
1009:

Line 1180: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;

1176: BEGIN
1177: debug_enter(l_proc_name);
1178: IF g_current_run = 'PERIODIC'
1179: THEN
1180: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
1181: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
1182: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
1183: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
1184:

Line 1181: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;

1177: debug_enter(l_proc_name);
1178: IF g_current_run = 'PERIODIC'
1179: THEN
1180: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
1181: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
1182: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
1183: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
1184:
1185: -- For Bug 5998123

Line 1182: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;

1178: IF g_current_run = 'PERIODIC'
1179: THEN
1180: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
1181: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
1182: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
1183: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
1184:
1185: -- For Bug 5998123
1186: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;