NAME: Purge Position Transaction
SHORT CODE: PQHPOSPUR
MODULE: Oracle Public Sector HR

Description: Purging of Position Transaction
Navigation: Oracle Public Sector HR Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• p_alias : Master table alias name
• paramname1 : Short Name
• paramvalue1 : Value for Short Name
• paramname4 : Status
• paramvalue4 : Value for Status
• paramname2 : Start Action Date
• paramvalue2 : Value for Start Date
• paramname3 : End Action Date
• paramvalue3 : Value for End Date
• paramname5 : Null
• paramvalue5 : Null
• p_effective_date : Effective date

NAME: Purge Mass Processes
SHORT CODE: PQHMPPUR
MODULE: Oracle Public Sector HR

Description: Purging For Mass Processes
Navigation: Oracle Public Sector HR Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• p_alias : Master Table alias name
• paramname1 : Short Name
• paramvalue1 : Value for Short Name
• paramname2 : Status
• paramvalue2 : Value of Status
• paramname3 : Start action date
• paramvalue3 : Value of Start Date
• paramname4 : End action date
• paramvalue4 : Value of end date
• paramname5 : Null
• paramvalue5 : Null
• p_effective_date : For datetracked forms

NAME: Rank Employees for Grade/Step Progression
SHORT CODE: PQHGSRNK
MODULE: Oracle Public Sector HR

Description: Procedure to Compute Ranks for GSP
Navigation: Oracle Public Sector HR Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• p_business_group_id : Business Group
• p_pgm_id : Grade Ladder
• p_pl_id : Grade
• p_process_dt_start : Life Event Processed Date Start
• p_process_dt_end : Life Event Processed Date End
• p_benefit_action_id : Participation Process Run
• p_audit_log : Audit Log
• p_commit_data : Validate
• p_rank_wf_pending : Include Progressions Pending Approval