Oracle HRMS Profile Options

Profile Option Name	Internal Name
AME:Installation Level	AME_INSTALLATION_LEVEL
AME:Installed	AME_INSTALLED_FLAG
Apply Assessment Competencies to Person	HR_APPLY_COMPETENCIES_TO_PERSON
Display Messages	NL_DISPLAY_MESSAGE
HR: Absence Duration Auto Overwrite	PER_ABSENCE_DURATION_AUTO_OVERWRITE
HR: Absence Start Date	HR_FR_ABSENCE_START_DATE
HR: Absence View Layout	HR_VIEWS_LAYOUT_ABSENCE
HR: Accrual Plan Element Set Displayed to User	PER_ACCRUAL_PLAN_ELEMENT_SET
HR: Actions - Validation	HR_ACTIONS_VALIDATION
HR: Applicant assignment cleanup Run Mode	HR_APL_UPD_RUN_MODE
HR: Applications View Layout	HR_VIEWS_LAYOUT_APPLICATIONS
HR: Appraisal Session Timeout	HR_APPR_SESSION_TIMEOUT
HR: Appraisal Template Lov	HR_APPRAISAL_TEMPLATE_LOV
HR: Appraisee Can Add Participants	HR_APPRAISEE_ADD_PARTICIPANTS
HR: Assignment ID	PER_ASSIGNMENT_ID
HR: Authoria Integration Enabled	HR_AUTHORIA_ENABLED
HR: Authoria UK URL	HR_AUTHORIA_URL_GB
HR: Authoria US URL	HR_AUTHORIA_URL_US
HR: Auto Apply Collective Agreement Entitlements	PER_AUTO_APPLY_ENTITLEMENTS
HR: Auto Evaluate Collective Agreement Entitlements	PER_AUTO_EVAL_ENTITLEMENTS
HR: Automatically synchronize single GL company cost centers with HR	HR_SYNC_SINGLE_GL_ORG
HR: BIS Job Hierarchy - Job Grouping Level 1	HR_BIS_JOB_FAMILY
HR: BIS Job Hierarchy - Job Grouping Level 2	HR_BIS_JOB_FUNCTION
HR: BIS Reporting Hierarchy	HR_BIS_REPORTING_HIERARCHY
HR: Base Salary Required	HR_BASE_SALARY_REQUIRED
HR: CWK in Head Count Reports	HR_HEADCOUNT_FOR_CWK
HR: Cancel Application	HR_CANCEL_APPLICATION
HR: Check Entitlement Cache	PER_CHECK_ENTITLEMENT_CACHE
HR: Collective Agreement Logging	PER_CAGR_LOG_DETAIL
HR: Data Exchange directory	PER_DATA_EXCHANGE_DIR
HR: Data Migrator Business Group Lockout	HR_DM_BG_LOCKOUT

HR: Default Correspondence Language	PER_DEFAULT_CORRESPONDENCE_LANGUAGE
HR: Default Full Name Format	HR_NL_FULL_NAME_PROFILE
HR: Default Nationality	PER_DEFAULT_NATIONALITY
HR: Disable Ethnicity Tab	HR_NL_ETHNICITY_PROFILE
HR: Display All Candidate Offers	HR_DISPLAY_ALL_OFFERS
HR: Employment View Layout	HR_VIEWS_LAYOUT_EMPLOYMENT
HR: Enable DTW4 defaulting	PER_ENABLE_DTW4
HR: Enable Multiple Assignments in SSHR	HR_ALLOW_MULTIPLE_ASSIGNMENTS
HR: Enable User Personalization	HR_ENABLE_USER_PERSONALIZATION
HR: Enable Web ADI Integration	HR_ADI_LAUNCH
HR: Expand Role of Contingent Worker	HR_TREAT_CWK_AS_EMP
HR: Extension Agent	HR_KPI_AGENT
HR: Extension Agent Adapter	HR_KPI_ADAPTER
HR: Extension Agent Client Timeout	HR_KPI_CLIENT_TIMEOUT
HR: Extension Agent Enabled	HR_KPI_ENABLED
HR: Extension Servlet	HR_KPI_SERVLET
HR: FastFormula debug level.	FF_DEBUG
HR: Free text school name allowed in Self Service	HR_SSHR_NEW_SCHOOL
HR: GL cost center org classifications	HR_GENERATE_GL_ORGS
HR: GL cost center synchronization options	HR_GENERATE_GL_OPTIONS
HR: GL organization  name format	HR_GL_ORG_NAME_FORMAT
HR: Generic Framework Servlet	HR_KPI_GENFWK_SERVLET
HR: HR/Payroll Representative Source	HR_PAYROLL_CONTACT_SOURCE
HR: Hierarchy - Individual Node Image	HR_HIERARCHY_NODE_GIF
HR: Hierarchy - Supervisor Image	HR_HIERARCHY_SUPERVISOR_GIF
HR: Include Terminated People in Search	HR_VIEW_TERM_PEOPLE_INSRCH
HR: Info Online: Open in New Window	HR_KPI_OPEN_NEW_WINDOW
HR: Info Online: RIA password	HR_KPI_RIA_PASSWORD
HR: Info Online: RIA username	HR_KPI_RIA_USERNAME
HR: Info Online: Toolbar Icon	HR_KPI_TOOLBAR_ICON
HR: Info Online: Use Field Context	HR_KPI_USE_FIELD_CONTEXT
HR: Informal Name Format	HR_INFORMAL_NAME_FORMAT
HR: Intermediate File Output Storage Folder	PER_P11D_OUTPUT_FOLDER
HR: Job Level	HR_NL_JOB_LEVEL_PROFILE
HR: KI Framework Version	HR_KPI_FRAMEWORK_VERSION
HR: KI Maximum Topics and Integrations	HR_KPI_MAX_SET_VALUE
HR: KI Providers Enabled	HR_KPI_PROVIDERS_ENABLED

HR: KI Topics Enabled	HR_KPI_TOPICS_ENABLED
HR: KI User Options Enabled	HR_KPI_USER_OPTIONS_ENABLED
HR: Local Nationality	PER_LOCAL_NATIONALITY
HR: Local or Global Name Format	HR_LOCAL_OR_GLOBAL_NAME_FORMAT
HR: Localization in SSHR	HR_SSHR_LOCALIZATION
HR: Location Id	PER_LOCATION_ID
HR: Manager Appraisals Menu	HR_MANAGER_APPRAISALS_MENU
HR: Mask Characters	HR_MASK_CHARACTERS
HR: Metalink Integration Application	HR_METALINK_APPLICATION
HR: Metalink Integration Enabled	HR_METALINK_ENABLED
HR: NI Unique Error or Warning	PER_NI_UNIQUE_ERROR_WARNING
HR: National Identifier Validation	PER_NATIONAL_IDENTIFIER_VALIDATION
HR: OAB New Benefits Model	PER_OAB_NEW_BENEFITS_MODEL
HR: Offers - Hiring Manager Initiation	HR_USE_HIRE_MGR_APPR_CHAIN
HR: Online Tax Forms Update Method	HR_OTF_UPDATE_METHOD
HR: Performance View Layout	HR_VIEWS_LAYOUT_PERFORMANCE
HR: Person Id	HR_FR_PERSON_ID
HR: Position Default Options for SSHR	HR_POSITION_DEFAULT_OPTIONS
HR: Position Name	HR_POSITION_NAME
HR: Propagate data changes	HR_PROPAGATE_DATA_CHANGES
HR: RI Business Group Id	PER_RI_WEBADI_BG_ID
HR: RI Web ADI REF1	PER_RI_WEBADI_REF1
HR: RI Workbench Installed	PER_RI_WORKBENCH_INSTALLED
HR: RIA Integration Enabled	HR_RIA_ENABLED
HR: Records to be Processed in Memory	PER_P11D_REC_PER_FILE
HR: Restrict Letter by Vacancy or Event	HR_LETTER_BY_VACANCY
HR: SM Employee Find Work Opp Menu	HR_SM_EMP_PERSONAL_ACTIONS_MENU
HR: SM Manager Find Person Menu	HR_SM_MANAGER_ACTIONS_MENU
HR: SM Manager Find Work Opp Menu	HR_SM_PERSONAL_ACTIONS_MENU
HR: Salary View Layout	HR_VIEWS_LAYOUT_SALARY
HR: Save and Stay in Appraisals Page	HR_SAVE_STAY_APPRAISALS_PAGE
HR: Security Profile	PER_SECURITY_PROFILE_ID
HR: Self Service HR Licensed	HR_SELF_SERVICE_HR_LICENSED
HR: Self Service Hire and Placement Default Values	HR_SSHR_NEW_HIRE_DEFAULTS
HR: Servlet Timeout	HR_KPI_SERVLET_TIMEOUT
HR: Subrogation	HR_FR_SUBROGATION
HR: Supervisor Hierarchy Usage	HR_SUPERVISOR_HIERARCHY_USAGE
HR: Training View Layout	HR_VIEWS_LAYOUT_TRAINING
HR: US Address Line Length	HR_US_ADDRESS_LINES_VALIDATION

Calling Oracle apps concurrent program report through Plsql code

CREATE OR REPLACE PROCEDURE APPS.XXASHRPEITEXCEL (errbuf             VARCHAR2
                  ,retcode            NUMBER
                  ,p_location         varchar2
                  ,p_eff_date         varchar2
                     )
    IS
        xml_layout                      BOOLEAN;
        req_id                          NUMBER;
        l_request_status                BOOLEAN;
        x_phase                         VARCHAR2(240);
        x_status                        VARCHAR2(240);
        x_dev_phase                     VARCHAR2(240);
        x_dev_status                    VARCHAR2(240);
        x_message                       VARCHAR2(240);

    BEGIN
        --
        xml_layout := FND_REQUEST.ADD_LAYOUT('XXAS'
                                            ,'XXASHRPEIT'
                                            ,'en'
                                            ,'US'
                                            ,'EXCEL'
                                            ); ---CALLING XML TEMPLATE
        --
        req_id := FND_REQUEST.SUBMIT_REQUEST('XXAS'
                                            ,'XXASHRPEIT'
                                            ,''
                                            ,''
                                            ,FALSE
                                            ,p_location --concurrent program parameters
                                            ,p_eff_date --concurrent program parameters
                                            ); ---CALLING Concurrent program
        --
        COMMIT;
        --
        IF req_id <> 0
        THEN
            l_request_status := FND_CONCURRENT.WAIT_FOR_REQUEST(req_id
                                                               ,30
                                                               ,0
                                                               ,x_phase
                                                               ,x_status
                                                               ,x_dev_phase
                                                               ,x_dev_status
                                                               ,x_message
                                                               );
        END IF;
        --
        COMMIT;
    END XXASHRPEITEXCEL;
/