Oracle Applications Knowledge Repository

How to Create Custom Employee Number Generation via Fast Formula

1. Create Sequence create sequence sac_emp_number start with 1 2. Create Function to Generate Desired Sequence Number CREATE OR REP...
Query to Get AME Details which contains Rule Name, Condition and Approver Group

SELECT ar . rule_id , art . description rule_name , ar . start_date , ar . end_date , ame...
API to Create Lookup Values - "FND_LOOKUP_VALUES"

Note: Before you start running the Below code, Kindly note we have only inserted records for Language as "US". If one has du...
Programs to Synchronize Workflow Roles

Resend Failed/Error Workflow Notifications Workflow notifications fail to be sent for multiple reasons. The workflow mailer can hang d...
How to Setup up Leave Accrual Plan

Accrual Plan: Oracle Provides Accrual plan Functionality for calculating leaves balance calculation and Balance Carry Over calculatio...
Query to Get Element Entry Value and Process Status

SELECT per . employee_number , per . full_name , petf . element_name , peevf . screen_entry_value FROM pa...
API to Update FND_LOOKUP

DECLARE l_lookup_type VARCHAR2 ( 250 ); l_lookup_code VARCHAR2 ( 250 ); l_enabled_flag VA...
How to Register/Delete Procedure in User Hook

1) Create API Hook Call (Register Procedure in User Hook) · Package Name: hr_api_hook_call_api.create_api_hook_call d...
How to Return Multiple Values and Rows with PL/SQL Function

STEP – 1 à Create Object Type EMP_DETAILS (COLLECTION) CREATE OR REPLACE TYPE emp_details -- Collection AS OBJECT ( firs...
Query to Get Organization Hierarchy

SELECT * FROM (SELECT haou .name, ( SELECT LISTAGG ( ' Level: ' || ...

Viewers

Bijoy Joseph. Picture Window theme. Theme images by sndr. Powered by Blogger.