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_SCH dependencies on BEN_EXT_PERSON

Line 141: l_prev_event_dtl_rec ben_ext_person.t_detailed_output_tab_rec;

137: FUNCTION is_curr_evt_processed
138: RETURN BOOLEAN
139: IS
140: l_proc VARCHAR2(72) := g_proc_name||'.is_curr_evt_processed';
141: l_prev_event_dtl_rec ben_ext_person.t_detailed_output_tab_rec;
142: l_flag VARCHAR2(1);
143: l_return BOOLEAN;
144: BEGIN
145: l_return:= false;

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

144: BEGIN
145: l_return:= false;
146: debug_enter(l_proc);
147: IF g_prev_event_dtl_rec.dated_table_id IS NOT NULL THEN
148: l_prev_event_dtl_rec := g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index);
149: l_prev_event_dtl_rec.change_mode := g_prev_event_dtl_rec.change_mode;
150: l_flag := 'Y';
151: IF l_prev_event_dtl_rec.dated_table_id <> g_prev_event_dtl_rec.dated_table_id THEN
152: l_flag := 'N';

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

177: debug('Event already processed',30);
178: debug_exit(l_proc);
179: l_return:= TRUE;
180: ELSE
181: g_prev_event_dtl_rec := g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index);
182: l_return := FALSE;
183: END IF;
184: ELSE
185: debug('First event');

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

182: l_return := FALSE;
183: END IF;
184: ELSE
185: debug('First event');
186: g_prev_event_dtl_rec := g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index);
187: l_return := FALSE;
188: END IF;
189: RETURN l_return;
190: debug('leaving is_curr_evt_processed');

Line 417: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;

413: debug('Inputs are: ',10);
414: debug('p_assignment_id: '||p_assignment_id,10);
415: debug('p_effective_date: '||TO_CHAR(p_effective_date,'dd/mm/yyyy'),10);
416: -- set the global events table
417: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
418: -- set global assignment_id
419: g_assignment_id := p_assignment_id;
420: debug('g_assignment_id: '||g_assignment_id,20);
421: debug('now calling PQP_GB_PSI_FUNCTIONS.init_st_end_date_glob ',30);

Line 565: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;

561: end if;
562: close csr_lgps_pension_change;
563:
564: /*
565: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
566: debug('count is:'||g_pay_proc_evt_tab.COUNT);
567: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
568: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
569: debug('l_chg_surrogate_key:'||l_chg_surrogate_key);

Line 567: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;

563:
564: /*
565: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
566: debug('count is:'||g_pay_proc_evt_tab.COUNT);
567: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
568: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
569: debug('l_chg_surrogate_key:'||l_chg_surrogate_key);
570: debug('g_pay_proc_evt_tab(l_curr_evt_index).update_type:'||g_pay_proc_evt_tab(l_curr_evt_index).update_type);
571: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;

Line 568: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;

564: /*
565: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
566: debug('count is:'||g_pay_proc_evt_tab.COUNT);
567: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
568: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
569: debug('l_chg_surrogate_key:'||l_chg_surrogate_key);
570: debug('g_pay_proc_evt_tab(l_curr_evt_index).update_type:'||g_pay_proc_evt_tab(l_curr_evt_index).update_type);
571: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
572: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;

Line 673: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;

669: ELSE
670: l_return := 'N';
671: END IF;
672: IF l_return = 'Y' THEN
673: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
674: debug('count is:'||g_pay_proc_evt_tab.COUNT);
675: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
676: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
677: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;

Line 675: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;

671: END IF;
672: IF l_return = 'Y' THEN
673: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
674: debug('count is:'||g_pay_proc_evt_tab.COUNT);
675: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
676: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
677: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
678: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;
679: l_chg_column_name := g_pay_proc_evt_tab(l_curr_evt_index).column_name;

Line 676: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;

672: IF l_return = 'Y' THEN
673: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
674: debug('count is:'||g_pay_proc_evt_tab.COUNT);
675: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
676: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
677: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
678: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;
679: l_chg_column_name := g_pay_proc_evt_tab(l_curr_evt_index).column_name;
680: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);

Line 753: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;

749: debug('entering '||l_proc_name);
750: l_scheme_name:= get_pen_scheme_memb( p_assignment_id => p_assignment_id ,p_effective_date => p_effective_date ,
751: p_tab_pen_sch_map_cv => g_tab_pen_sch_map_cv ,p_rec_ele_ent_details => l_rec_ele_ent_details );
752: if g_current_run = 'PERIODIC' then
753: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
754: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
755: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
756: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
757: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;

Line 754: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;

750: l_scheme_name:= get_pen_scheme_memb( p_assignment_id => p_assignment_id ,p_effective_date => p_effective_date ,
751: p_tab_pen_sch_map_cv => g_tab_pen_sch_map_cv ,p_rec_ele_ent_details => l_rec_ele_ent_details );
752: if g_current_run = 'PERIODIC' then
753: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
754: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
755: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
756: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
757: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;
758: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);

Line 755: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;

751: p_tab_pen_sch_map_cv => g_tab_pen_sch_map_cv ,p_rec_ele_ent_details => l_rec_ele_ent_details );
752: if g_current_run = 'PERIODIC' then
753: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
754: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
755: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
756: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
757: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;
758: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);
759: l_chg_value := g_pay_proc_evt_tab(l_curr_evt_index).change_values;

Line 829: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;

825: l_proc_name VARCHAR2(61):= g_proc_name||'getContributionStartDate';
826: BEGIN
827: debug('entering '||l_proc_name);
828: if g_current_run = 'PERIODIC' then
829: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
830: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
831: p_effective_start_date:= TO_CHAR(g_pay_proc_evt_tab(l_curr_evt_index).actual_date,'DD/MM/YYYY');
832: elsif g_current_run = 'CUTOVER' then
833: open csr_lgps_pension_change(p_assignment_id, g_cutover_date);

Line 830: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;

826: BEGIN
827: debug('entering '||l_proc_name);
828: if g_current_run = 'PERIODIC' then
829: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
830: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
831: p_effective_start_date:= TO_CHAR(g_pay_proc_evt_tab(l_curr_evt_index).actual_date,'DD/MM/YYYY');
832: elsif g_current_run = 'CUTOVER' then
833: open csr_lgps_pension_change(p_assignment_id, g_cutover_date);
834: fetch csr_lgps_pension_change into l_change_record;

Line 886: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;

882: l_effective_date DATE;
883: BEGIN
884: debug('Entering '||g_proc_name);
885: if g_current_run = 'PERIODIC' then
886: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
887: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
888: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
889: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
890: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;

Line 887: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;

883: BEGIN
884: debug('Entering '||g_proc_name);
885: if g_current_run = 'PERIODIC' then
886: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
887: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
888: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
889: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
890: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;
891: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);

Line 888: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;

884: debug('Entering '||g_proc_name);
885: if g_current_run = 'PERIODIC' then
886: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
887: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
888: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
889: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
890: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;
891: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);
892: debug('l_curr_evt_index:'||l_curr_evt_index,20);