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.PER_MX_SSAFFL_ARCHIVE dependencies on PER_MX_SSAFFL_ARCHIVE

Line 1: PACKAGE BODY PER_MX_SSAFFL_ARCHIVE AS

1: PACKAGE BODY PER_MX_SSAFFL_ARCHIVE AS
2: /* $Header: pemxafar.pkb 120.2 2006/08/04 10:05:24 sbairagi noship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : per_mx_ssaffl_archive

16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : per_mx_ssaffl_archive
21:
22: Description : This package is used by the Social Security Affiliation
23: Archive process to archive the Hire/Rehire, Termination
24: Affiliation records in pay_action_information table.

Line 486: gv_package := 'per_mx_ssaffl_archive' ;

482: BEGIN
483:
484: dbg('Entering range_cursor ....... ') ;
485:
486: gv_package := 'per_mx_ssaffl_archive' ;
487: gv_event_group := 'MX_HIRE_SEPARATION_EVG' ;
488: g_ambiguous_error := '1' ; -- Multiple GRE found
489: g_missing_gre_error := '2' ; -- Location is not in the hierarchy';
490: g_debug_flag := 'Y' ;

Line 632: -- ,per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date)

628: ,cp_event_group_id in number
629: ) is
630: select distinct ppe.assignment_id
631: -- ,paf.person_id,
632: -- ,per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date)
633: from pay_process_events ppe,
634: pay_event_updates peu,
635: pay_datetracked_events pde,
636: per_all_assignments_f paf

Line 649: and (( per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date) = -1 )

645: and peu.event_type=pde.update_type ) )
646: and paf.assignment_id = ppe.assignment_id
647: and paf.assignment_id between cp_start_assignment_id and cp_end_assignment_id
648: and ppe.effective_date between paf.effective_start_date and paf.effective_end_date
649: and (( per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date) = -1 )
650: or ( per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date) = -2 )
651: or ( cp_tran_gre_id is not null and cp_gre_id is not null and
652: per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date)=cp_gre_id )
653: or ( cp_tran_gre_id is not null and cp_gre_id is null and

Line 650: or ( per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date) = -2 )

646: and paf.assignment_id = ppe.assignment_id
647: and paf.assignment_id between cp_start_assignment_id and cp_end_assignment_id
648: and ppe.effective_date between paf.effective_start_date and paf.effective_end_date
649: and (( per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date) = -1 )
650: or ( per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date) = -2 )
651: or ( cp_tran_gre_id is not null and cp_gre_id is not null and
652: per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date)=cp_gre_id )
653: or ( cp_tran_gre_id is not null and cp_gre_id is null and
654: per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date)

Line 652: per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date)=cp_gre_id )

648: and ppe.effective_date between paf.effective_start_date and paf.effective_end_date
649: and (( per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date) = -1 )
650: or ( per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date) = -2 )
651: or ( cp_tran_gre_id is not null and cp_gre_id is not null and
652: per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date)=cp_gre_id )
653: or ( cp_tran_gre_id is not null and cp_gre_id is null and
654: per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date)
655: in
656: (select organization_id

Line 654: per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date)

650: or ( per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date) = -2 )
651: or ( cp_tran_gre_id is not null and cp_gre_id is not null and
652: per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date)=cp_gre_id )
653: or ( cp_tran_gre_id is not null and cp_gre_id is null and
654: per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date)
655: in
656: (select organization_id
657: from hr_organization_information hoi
658: where hoi.org_information_context = 'MX_SOC_SEC_DETAILS'

Line 680: gv_package := 'per_mx_ssaffl_archive' ;

676: begin
677:
678: dbg('Entering Action creation ..............') ;
679:
680: gv_package := 'per_mx_ssaffl_archive' ;
681: gv_event_group := 'MX_HIRE_SEPARATION_EVG' ;
682: g_debug_flag := 'Y' ;
683: -- g_concurrent_flag := 'Y' ;
684:

Line 788: gv_package := 'per_mx_ssaffl_archive' ;

784:
785:
786: dbg('Entering archinit .............');
787:
788: gv_package := 'per_mx_ssaffl_archive' ;
789: gv_event_group := 'MX_HIRE_SEPARATION_EVG' ;
790: g_ambiguous_error := '1' ; -- Multiple GRE found
791: g_missing_gre_error := '2' ; -- Location is not in the hierarchy';
792: g_action_hire_category := 'MX SS HIRE DETAILS' ;

Line 829: and per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,cp_effective_date)

825: from per_all_assignments_f paf
826: where paf.assignment_id <> cp_skip_assignment_id
827: and paf.person_id = cp_person_id
828: and cp_effective_date between paf.effective_start_date and paf.effective_end_date
829: and per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,cp_effective_date)
830: = cp_gre_id ;
831:
832: lv_flag VARCHAR2(1);
833:

Line 3225: end per_mx_ssaffl_archive;

3221:
3222: --begin
3223: --hr_utility.trace_on (null, 'SSAFFL');
3224:
3225: end per_mx_ssaffl_archive;