Category Archives: Uncategorized

Programming Helping

By | September 4, 2017

While development there are lots of programming piece of codes that we use again and again. In this post, we shall be piling up such similar codes or tips or code structures which can help us during development. Structure of Creating Function create or replace function lsg_function return number is ln_temp number; begin ln_temp :=… Read More »

Update Bank Payment Method API

By | May 22, 2017

This API Updates the Bank Payment Method Detail.   DECLARE ln_method_id PAY_PERSONAL_PAYMENT_METHODS_F.PERSONAL_PAYMENT_METHOD_ID%TYPE; ln_ext_acc_id PAY_EXTERNAL_ACCOUNTS.EXTERNAL_ACCOUNT_ID%TYPE; ln_obj_ver_num PAY_PERSONAL_PAYMENT_METHODS_F.OBJECT_VERSION_NUMBER%TYPE; ld_eff_start_date DATE; ld_eff_end_date DATE; ln_comment_id NUMBER; cursor c1 is select pm.assignment_id,pm.object_version_number,pm.PERSONAL_PAYMENT_METHOD_ID,ac.segment2, ac.segment12,pm.effective_start_date,pm.effective_end_date ,’QNBS8′ stg_emp_Branch_code, stg_segment_12,pm.EXTERNAL_ACCOUNT_ID ,mv.employee_number pf from PAY_PERSONAL_PAYMENT_METHODS_F pm, PAY_EXTERNAL_ACCOUNTS ac, xxlsg_emp_master_v mv,XXLSG_PERSON_UPDATE_STG stg where 1=1 and pm.external_account_id = ac.external_account_id and pm.assignment_id = mv.assignment_id and mv.employee_number = stg.employee_number… Read More »

Vacancy Update API (PER_VACANCY_API.update_vacancy)

By | December 20, 2016

declare P_ASSIGNMENT_CHANGED boolean; p_inv_pos_grade_warning boolean; p_inv_job_grade_warning boolean; err_msg varchar2(500); cursor c1 is select vacancy_id,object_version_number,status,name from PER_ALL_VACANCIES where name = ‘IRC10377’; begin for r in c1 loop dbms_output.put_line(‘start’); begin PER_VACANCY_API.update_vacancy ( P_VALIDATE => FALSE , P_EFFECTIVE_DATE => TRUNC(SYSDATE) , P_VACANCY_ID =>r.vacancy_id , P_OBJECT_VERSION_NUMBER =>r.OBJECT_VERSION_NUMBER , P_DATE_TO => TRUNC(SYSDATE) , P_STATUS => ‘CLOSED’ , P_ASSIGNMENT_CHANGED => P_ASSIGNMENT_CHANGED… Read More »

Steps to Compile a Fast Formula

By | December 20, 2016

How to Compile a Fast Formula Following are the steps to compile a fast formula from Oracle HRMS application Go to following navigation Open the form Find the Formula Click on Edit Button Following screen will open. Click on Verify button. Once formula is verified. Message for successful compilation will be displayed in the bottom… Read More »

HR Security Profiles Data through SQL Query

By | December 17, 2016

Following is the full list of all HR Security Profiles Query to get Full List of Security Profiles Query to get Organization Based Security Profiles List Query to get Payroll Based Security Profiles List Query to get Custom Security Based Security Profiles List –Query to get Others Security Profiles List Oracle HRMS provides an option… Read More »

Calculate Leave Between Two Dates

By | December 5, 2016

Following function will help you to get the number of leaves between two dates. CREATE OR REPLACE function APPS.lsg_get_lv_btw_two_dates(p_person_id number,P_Period_Start_date date,P_Period_End_date date,p_leave_name varchar2) return number is ln_lv_curr_mnth_cnt number:=0; ln_lv_curr_mnth_cnt1 number:=0; ln_lv_curr_mnth_cnt2 number:=0; ln_lv_curr_mnth_cnt3 number:=0; ln_lv_curr_mnth_cnt4 number:=0; p_lv_st_dt date; p_lv_end_date date; date1 date; date2 date; –Created on December 5, 2016 by Syed Farhan Ashraf –This Function… Read More »

Workflow Customization in Oracle HRMS

By | November 22, 2016

In this article, we are going to cover how we can modify the workflow to change the notification. While you are working for oracle hrms in your environment. You may come across such requirement. so here are the stops to achieve this requirement. Contents Business Requirement Solution Steps —Identify the Item Key —Find the Process… Read More »

Steps for Developing Custom Form in Oracle Apps

By | October 4, 2016

In this article of oracle hrms overview, you will find the steps for development of custom forms (using oracle developer suite 10g). This article covers the end to end process starting from developing a form and running on oracle apps. Custom form in oracle apps is developed based on TEMPLATE.FMB which is available in resources… Read More »

Flexfields in Oracle HRMS

By | October 2, 2016

In this article, We have explained the flexfields in oracle hrms, its types and usages. What is Flex Field Types of Flex Field –Key Flexfields –Descriptive Flexfields Key Flexfields in Oracle HRMS –Job Key Flexfield –Grade Key Flexfield –Position Key Flexfield –Cost Allocation Key Flexfield –Competence Key Flexfield –Soft Coded Key Flex field –Bank Details… Read More »