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 PQP_GB_PSI_FUNCTIONS

Line 225: IF pqp_gb_psi_functions.g_pension_scheme_mapping.COUNT = 0 THEN

221: DEBUG(l_proc_name, l_proc_step);
222: DEBUG('p_business_group_id: ' || p_business_group_id);
223: END IF;
224: l_configuration_type := 'PQP_GB_PENSERV_SCHEME_MAP_INFO';
225: IF pqp_gb_psi_functions.g_pension_scheme_mapping.COUNT = 0 THEN
226: pqp_utilities.get_config_type_values( p_configuration_type => l_configuration_type ,p_business_group_id => p_business_group_id ,p_legislation_code => g_legislation_code ,p_tab_config_values => l_tab_config_values );
227: ELSE -- get it from cached collection
228: l_tab_config_values := pqp_gb_psi_functions.g_pension_scheme_mapping;
229: END IF;

Line 228: l_tab_config_values := pqp_gb_psi_functions.g_pension_scheme_mapping;

224: l_configuration_type := 'PQP_GB_PENSERV_SCHEME_MAP_INFO';
225: IF pqp_gb_psi_functions.g_pension_scheme_mapping.COUNT = 0 THEN
226: pqp_utilities.get_config_type_values( p_configuration_type => l_configuration_type ,p_business_group_id => p_business_group_id ,p_legislation_code => g_legislation_code ,p_tab_config_values => l_tab_config_values );
227: ELSE -- get it from cached collection
228: l_tab_config_values := pqp_gb_psi_functions.g_pension_scheme_mapping;
229: END IF;
230: IF g_debug THEN
231: l_proc_step := 30;
232: DEBUG(l_proc_name, l_proc_step);

Line 421: debug('now calling PQP_GB_PSI_FUNCTIONS.init_st_end_date_glob ',30);

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);
422: PQP_GB_PSI_FUNCTIONS.init_st_end_date_glob();
423: g_is_terminated := 'N';
424: debug_exit(l_proc_name);
425: EXCEPTION

Line 422: PQP_GB_PSI_FUNCTIONS.init_st_end_date_glob();

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);
422: PQP_GB_PSI_FUNCTIONS.init_st_end_date_glob();
423: g_is_terminated := 'N';
424: debug_exit(l_proc_name);
425: EXCEPTION
426: WHEN OTHERS THEN

Line 532: PQP_GB_PSI_FUNCTIONS.set_shared_globals (p_business_group_id => p_business_group_id ,p_paypoint => g_paypoint -- OUT

528: debug('Globals setting');
529: debug('g_ext_dfn_id:'||g_ext_dfn_id);
530: debug('g_paypoint:'||g_paypoint);
531: debug('g_cutover_date:'||g_cutover_date);
532: PQP_GB_PSI_FUNCTIONS.set_shared_globals (p_business_group_id => p_business_group_id ,p_paypoint => g_paypoint -- OUT
533: ,p_cutover_date => g_cutover_date -- OUT
534: ,p_ext_dfn_id => g_ext_dfn_id -- OUT
535: );
536: set_sch_globals ( p_business_group_id => p_business_group_id ,p_assignment_id => p_assignment_id ,p_effective_date => p_effective_date );

Line 539: l_return := PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria (p_business_group_id => p_business_group_id ,

535: );
536: set_sch_globals ( p_business_group_id => p_business_group_id ,p_assignment_id => p_assignment_id ,p_effective_date => p_effective_date );
537: debug('Globals setting for assignment');
538: set_assignment_globals ( p_assignment_id => p_assignment_id ,p_effective_date => p_effective_date );
539: l_return := PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria (p_business_group_id => p_business_group_id ,
540: p_effective_date => p_effective_date ,p_assignment_id => p_assignment_id ,p_person_dtl => g_person_dtl ,p_assignment_dtl => g_assignment_dtl );
541: g_current_run:= 'CUTOVER';
542: debug('New scheme contribution periodic criteria:'||p_assignment_id);
543: debug('after current event processed function');

Line 574: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);

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;
573: l_chg_column_name := g_pay_proc_evt_tab(l_curr_evt_index).column_name;
574: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);
575: l_chg_value := g_pay_proc_evt_tab(l_curr_evt_index).change_values;
576: debug('----------');
577: debug('Record :'||l_curr_evt_index);
578: debug('----------');

Line 606: l_return := pqp_gb_psi_functions.include_event (p_actual_date => g_pay_proc_evt_tab(l_curr_evt_index).actual_date ,p_effective_date => g_pay_proc_evt_tab(l_curr_evt_index).effective_date );

602: ,p_per_new_percentage=>l_new_percent);
603: debug('l_percent_change:'||l_percent_change);
604: IF l_percent_change <> 0 THEN
605: debug('percentage change is non zero hence adding it into include_event');
606: l_return := pqp_gb_psi_functions.include_event (p_actual_date => g_pay_proc_evt_tab(l_curr_evt_index).actual_date ,p_effective_date => g_pay_proc_evt_tab(l_curr_evt_index).effective_date );
607: ELSE -- no change in percentage, hence no need to report this event
608: l_return := 'N';
609: debug('percentage change is zero hence no need to include this event');
610: END IF;

Line 648: PQP_GB_PSI_FUNCTIONS.set_shared_globals (p_business_group_id => p_business_group_id ,p_paypoint => g_paypoint -- OUT

644: debug('Globals setting');
645: debug('g_ext_dfn_id:'||g_ext_dfn_id);
646: debug('g_paypoint:'||g_paypoint);
647: debug('g_cutover_date:'||g_cutover_date);
648: PQP_GB_PSI_FUNCTIONS.set_shared_globals (p_business_group_id => p_business_group_id ,p_paypoint => g_paypoint -- OUT
649: ,p_cutover_date => g_cutover_date -- OUT
650: ,p_ext_dfn_id => g_ext_dfn_id -- OUT
651: );
652: set_sch_globals ( p_business_group_id => p_business_group_id ,p_assignment_id => p_assignment_id ,p_effective_date => p_effective_date );

Line 655: l_return := PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria (p_business_group_id => p_business_group_id ,

651: );
652: set_sch_globals ( p_business_group_id => p_business_group_id ,p_assignment_id => p_assignment_id ,p_effective_date => p_effective_date );
653: debug('Globals setting for assignment');
654: set_assignment_globals ( p_assignment_id => p_assignment_id ,p_effective_date => p_effective_date );
655: l_return := PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria (p_business_group_id => p_business_group_id ,
656: p_effective_date => p_effective_date ,p_assignment_id => p_assignment_id ,p_person_dtl => g_person_dtl ,p_assignment_dtl => g_assignment_dtl );
657: g_current_run:= 'PERIODIC';
658: debug('New scheme contribution periodic criteria:'||p_assignment_id);
659: IF is_curr_evt_processed() THEN

Line 680: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);

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);
681: l_chg_value := g_pay_proc_evt_tab(l_curr_evt_index).change_values;
682: debug('----------');
683: debug('Record :'||l_curr_evt_index);
684: debug('----------');

Line 709: l_return := pqp_gb_psi_functions.include_event (p_actual_date => g_pay_proc_evt_tab(l_curr_evt_index).actual_date ,p_effective_date => g_pay_proc_evt_tab(l_curr_evt_index).effective_date );

705: ,p_per_new_percentage=>l_new_percent);
706: debug('l_percent_change:'||l_percent_change);
707: IF l_percent_change <> 0 THEN
708: debug('There is a change in percentage contribution, hence adding it into include_event');
709: l_return := pqp_gb_psi_functions.include_event (p_actual_date => g_pay_proc_evt_tab(l_curr_evt_index).actual_date ,p_effective_date => g_pay_proc_evt_tab(l_curr_evt_index).effective_date );
710: ELSE -- no change in percentage, hence no need to report this event
711: l_return := 'N';
712: debug('percentage change is zero hence no need to include this event');
713: END IF;

Line 758: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);

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;
760: debug('update type:'||l_update_type);
761: debug('l_dated_table_id:'||l_dated_table_id);
762: debug('l_chg_table:'||l_chg_table);

Line 768: debug('scheme returned by PQP_GB_PSI_FUNCTIONS.check_employee_pension_scheme function:'||l_scheme_name);

764: debug('new_value :'||g_pay_proc_evt_tab(l_curr_evt_index).new_value ,20);
765: debug('change_values :'||g_pay_proc_evt_tab(l_curr_evt_index).change_values ,20);
766: IF l_chg_table = 'PQP_ASSIGNMENT_ATTRIBUTES_F' THEN
767:
768: debug('scheme returned by PQP_GB_PSI_FUNCTIONS.check_employee_pension_scheme function:'||l_scheme_name);
769: debug('l_update_type:'||l_update_type);
770: IF l_update_type = 'C' THEN
771: get_old_and_new_values( l_chg_value ,l_old_value ,l_new_value ); -- get the value from pattern matching code
772: debug('old_value :'||g_pay_proc_evt_tab(l_curr_evt_index).old_value ,20);

Line 891: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);

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);
893: debug('l_chg_surrogate_key :'||l_chg_surrogate_key ,20);
894: debug('l_update_type :'||l_update_type ,20);
895: debug('l_dated_table_id :'||l_dated_table_id ,20);

Line 937: pqp_gb_psi_functions.common_post_process(p_business_group_id => g_business_group_id);

933: IF g_debug THEN
934: l_proc_step := 10;
935: debug_enter(l_proc_name);
936: END IF;
937: pqp_gb_psi_functions.common_post_process(p_business_group_id => g_business_group_id);
938: IF g_debug THEN
939: l_proc_step := 20;
940: debug_exit(l_proc_name);
941: END IF;