March 4, 2016

HRMS API with tables

Converstion API Table
Organization hr_organization_api.create_hr_organization hr_all_organization_units
Job hr_job_api.create_job hr.per_jobs pj,
 hr.per_job_definitions pjd
Organization Update hr_organization_api.update_organization hr_all_organization_units 
EIT hr_person_extra_info_api.create_person_extra_info PER_PEOPLE_EXTRA_INFO
SIT hr_sit_api.create_sit hr.per_person_analyses ppa,
hr.per_special_info_types psit,
hr.per_analysis_criteria pac,
applsys.fnd_id_flex_structures_tl fifs
Address hr_ae_person_address_api.create_ae_person_address hr.per_addresses 
Assignments hr_assignment_api.update_emp_asg hr.per_all_assignments_f 
Basic Salary hr_maintain_proposal_api.insert_salary_proposal HR.PER_PAY_PROPOSALS 
Contact hr_contact_rel_api.create_contact hr.per_contact_relationships 
DOCR HR_DOCUMENT_EXTRA_INFO_API.create_doc_extra_info hr_document_types hdt,
    hr_document_extra_info hdei,
Element pay_element_types_api.create_element_type hr.pay_element_types_f 
Element Links pay_element_link_api.create_element_link hr.pay_element_links_f 
Employee hr_employee_api.create_employee Per_all_people_f    
Fast Formula ff_functions_api.create_function FF_FUNCTIONS
ff_function_parameters_api.create_parameter FF_FUNCTION_PARAMETERS

No comments:

Post a Comment

Thanks for your comments submitted.,will review and Post soon! by admin.

COALESCE-SQL

Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...