| 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 |
Oracle Technical Experience and Test Cases Shared from different resource and through self leanings.
March 4, 2016
HRMS API with tables
Subscribe to:
Post Comments (Atom)
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...
-
In HRMS we do use date with timestamp for EIT ans SIT segments. To change the format od the date we can use fnd_date . canonical_to_date ...
-
Mandatory Changes TCA model based Changes Receivable module based views used to populate the customer and contact information has ...
-
Extract Query: SELECT 'RULE', PET.Element_Name, TO_CHAR(PPR.legislation_code) ATTRIBUTE1, TO_CHAR(PPR.assignment_status_typ...
No comments:
Post a Comment
Thanks for your comments submitted.,will review and Post soon! by admin.