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 622: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;

618: IF l_return = 'Y'
619: THEN
620: debug('Calling the common include event proc');
621: -- set the global events table
622: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
623: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
624: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
625: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
626: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;

Line 623: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;

619: THEN
620: debug('Calling the common include event proc');
621: -- set the global events table
622: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
623: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
624: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
625: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
626: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;
627: l_chg_column_name := g_pay_proc_evt_tab(l_curr_evt_index).column_name;

Line 624: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;

620: debug('Calling the common include event proc');
621: -- set the global events table
622: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
623: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
624: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
625: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
626: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;
627: l_chg_column_name := g_pay_proc_evt_tab(l_curr_evt_index).column_name;
628: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);

Line 1039: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;

1035: debug_enter(l_proc_name);
1036: debug('g_current_run: '||g_current_run);
1037: IF g_current_run = 'PERIODIC'
1038: THEN
1039: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
1040: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
1041: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
1042: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
1043: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;

Line 1040: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;

1036: debug('g_current_run: '||g_current_run);
1037: IF g_current_run = 'PERIODIC'
1038: THEN
1039: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
1040: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
1041: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
1042: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
1043: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;
1044: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);

Line 1041: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;

1037: IF g_current_run = 'PERIODIC'
1038: THEN
1039: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
1040: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
1041: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
1042: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
1043: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;
1044: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);
1045:

Line 1216: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;

1212: BEGIN
1213: debug_enter(l_proc_name);
1214: IF g_current_run = 'PERIODIC'
1215: THEN
1216: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
1217: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
1218: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
1219: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
1220:

Line 1217: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;

1213: debug_enter(l_proc_name);
1214: IF g_current_run = 'PERIODIC'
1215: THEN
1216: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
1217: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
1218: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
1219: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
1220:
1221: -- For Bug 5998123

Line 1218: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;

1214: IF g_current_run = 'PERIODIC'
1215: THEN
1216: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
1217: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
1218: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
1219: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
1220:
1221: -- For Bug 5998123
1222: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;