Sameer Patil,Oracle Apps,Bangalore
Updating the Per_periods_of_service table using
hr_ex_employee_api.update_term_details_emp
Terminating using
hr_ex_employee_api.actual_termination_emp
Applying the final process in the shared instance using hr_ex_employee_api.final_process_emp
Re - Hire
hr_employee_api.re_hire_ex_employee
Updation On Already Existing Records
hr_person_api.update_us_person
New Hire
hr_employee_api.create_us_employee
Costing
pay_cost_allocation_api.create_cost_allocation
Load Update Assign
hr_assignment_api.update_us_emp_asg
Load Update Assign Criteria
hr_assignment_api.update_emp_asg_criteria
IF CONTACT PERSON ALREADY CREATED AND ONLY RELATION SHIP IS TO BE CREATED -
Note : Contact Person Id Is To Be Passed
hr_contact_rel_api.create_contact
If Contact Person Already Not Created
Note : Contact Person Id is passed as Null(default of API)
hr_contact_rel_api.create_contact
Load Phones
hr_phone_api.create_phone
hr_person_address_api.update_person_address
Load Addresses
hr_person_address_api.update_person_address
hr_person_address_api.create_person_address
Load Payment Methods
hr_personal_pay_method_api.create_us_personal_pay_method
Element Loading
py_element_entry_api.create_element_entry
py_element_entry_api.update_element_entry
Load Salaries
hr_upload_proposal_api.upload_salary_proposal
Approve Salary Proposal
hr_maintain_proposal_api.approve_salary_proposal
Starts To Validate/Load Federal Tax For A Person pay_federal_tax_rule_api.update_fed_tax_rule
State tax rules
pay_state_tax_rule_api.create_state_tax_rule
pay_state_tax_rule_api.update_state_tax_rule
County Tax Rules
pay_county_tax_rule_api.create_county_tax_rule
pay_county_tax_rule_api.update_county_tax_rule
City Tax Rules
pay_city_tax_rule_api.create_city_tax_rule
pay_city_tax_rule_api.update_city_tax_rule
Schools and Colleges
per_esa_upd.upd
per_esa_ins.ins
Performance Reviews
hr_perf_review_api.create_perf_review
hr_perf_review_api.update_perf_review
State Information Taxes
hr_sit_api.update_sit
hr_sit_api.create_sit
Qualifications
per_qualifications_api.create_qualification
per_qualifications_api.update_qualification
Locations
hr_location_api.update_location
hr_location_api.create_location
Organization
hr_organization_api.update_organization
hr_organization_api.create_org_classification
If any Change in Organization information.
if information2 = 'Y' then
hr_organization_api.enable_org_classification
If any Change in Organization information.
if information2 = 'N' then
hr_organization_api.disable_org_classification
If Organization does not exist in instance
hr_organization_api.create_organization api
Jobs
hr_job_api.update_job
hr_job_api.create_job
Positions
hr_position_api.update_position
hr_position_api.create_position
hr_ex_employee_api.update_term_details_emp
Terminating using
hr_ex_employee_api.actual_termination_emp
Applying the final process in the shared instance using hr_ex_employee_api.final_process_emp
Re - Hire
hr_employee_api.re_hire_ex_employee
Updation On Already Existing Records
hr_person_api.update_us_person
New Hire
hr_employee_api.create_us_employee
Costing
pay_cost_allocation_api.create_cost_allocation
Load Update Assign
hr_assignment_api.update_us_emp_asg
Load Update Assign Criteria
hr_assignment_api.update_emp_asg_criteria
IF CONTACT PERSON ALREADY CREATED AND ONLY RELATION SHIP IS TO BE CREATED -
Note : Contact Person Id Is To Be Passed
hr_contact_rel_api.create_contact
If Contact Person Already Not Created
Note : Contact Person Id is passed as Null(default of API)
hr_contact_rel_api.create_contact
Load Phones
hr_phone_api.create_phone
hr_person_address_api.update_person_address
Load Addresses
hr_person_address_api.update_person_address
hr_person_address_api.create_person_address
Load Payment Methods
hr_personal_pay_method_api.create_us_personal_pay_method
Element Loading
py_element_entry_api.create_element_entry
py_element_entry_api.update_element_entry
Load Salaries
hr_upload_proposal_api.upload_salary_proposal
Approve Salary Proposal
hr_maintain_proposal_api.approve_salary_proposal
Starts To Validate/Load Federal Tax For A Person pay_federal_tax_rule_api.update_fed_tax_rule
State tax rules
pay_state_tax_rule_api.create_state_tax_rule
pay_state_tax_rule_api.update_state_tax_rule
County Tax Rules
pay_county_tax_rule_api.create_county_tax_rule
pay_county_tax_rule_api.update_county_tax_rule
City Tax Rules
pay_city_tax_rule_api.create_city_tax_rule
pay_city_tax_rule_api.update_city_tax_rule
Schools and Colleges
per_esa_upd.upd
per_esa_ins.ins
Performance Reviews
hr_perf_review_api.create_perf_review
hr_perf_review_api.update_perf_review
State Information Taxes
hr_sit_api.update_sit
hr_sit_api.create_sit
Qualifications
per_qualifications_api.create_qualification
per_qualifications_api.update_qualification
Locations
hr_location_api.update_location
hr_location_api.create_location
Organization
hr_organization_api.update_organization
hr_organization_api.create_org_classification
If any Change in Organization information.
if information2 = 'Y' then
hr_organization_api.enable_org_classification
If any Change in Organization information.
if information2 = 'N' then
hr_organization_api.disable_org_classification
If Organization does not exist in instance
hr_organization_api.create_organization api
Jobs
hr_job_api.update_job
hr_job_api.create_job
Positions
hr_position_api.update_position
hr_position_api.create_position
I have a requirement where I need to create a contact. If it is to be primary then I need to check for existing primary, make it non primary
ReplyDeleteand create the new primary.
If it is not a primary contact, then simply it should create a contact.
I am new to API's and PL/SQL coding. Can somebody help me with this.
Thanks,
Bhaskar
Can you please tell api to close contacts of customer (i.e. Customer should be there and only bulk contacts have to close with end date. ex- there
ReplyDeleteare many locations contacts, if we give particular location that contacts have to close)