Approval in OTL (Oracle Time and Labor)

>Approval in OTL, 1) Created or modify existing fast formula, And create Time Entry Rules, OTL Application Developer => Time Entry Rules

2) Now Create Approval Style, OTL Application Developer => Approval => Approval Style

Formulas, Approver Finder Formulas, OA Custom OTL Time Entry Approval for Line Manager /* ****************************************************************** Formula Name : HXC_OVERRIDE_APPROVER_WF_PERSON Description : Implement approval workflow person Contexts : None Explanation : Formula gets the override approver based on the timecard id and ovn. Change History: Date Author Comments ------------ -------------- ------------------------------------ */ /***************************************************************** Initialise Variables which can be null ******************************************************************/ default for formula_status is 'S' default for formula_message is 'NO MESSAGE' /* ****************************************************************** READ IN INPUT VARIABLES ****************************************************************** */ INPUTS ARE timecard_bb_id (number) , timecard_bb_ovn (number) , application_period_bb_id (number) , application_period_bb_ovn (number) , time_recipient_id (number) , resource_id (number) , resource_type (text) /* **************************************************************** Processing **************************************************************** */ approval_mechanism = 'PERSON' approval_mechanism_id = XXTEST_GET_LINEMGR_ID ( resource_id,timecard_bb_id, timecard_bb_ovn ) /* **************************************************************** RETURN VARIABLE **************************************************************** */ RETURN approval_mechanism , approval_mechanism_id , formula_status , formula_message OA Custom OTL Time Entry Approval for TK /* ****************************************************************** Formula Name : HXC_OVERRIDE_APPROVER_WF_PERSON Description : Implement approval workflow person Contexts : None Explanation : Formula gets the override approver based on the timecard id and ovn. Change History: Date Author Comments ------------ -------------- ------------------------------------ */ /***************************************************************** Initialise Variables which can be null ******************************************************************/ default for formula_status is 'S' default for formula_message is 'NO MESSAGE' /* ****************************************************************** READ IN INPUT VARIABLES ****************************************************************** */ INPUTS ARE timecard_bb_id (number) , timecard_bb_ovn (number) , application_period_bb_id (number) , application_period_bb_ovn (number) , time_recipient_id (number) , resource_id (number) , resource_type (text) /* **************************************************************** Processing **************************************************************** */ approval_mechanism = 'PERSON' approval_mechanism_id = XXTEST_GET_TIMEKEEPER_ID ( resource_id,timecard_bb_id, timecard_bb_ovn ) /* **************************************************************** RETURN VARIABLE **************************************************************** */ RETURN approval_mechanism , approval_mechanism_id , formula_status , formula_message Time Entry Rule Fast Formula, OA Approval - approval maximum test (Custom) /******************************************************************* Formula Name : HXC_APPROVAL_MAXIMUM Description : Implements simple hours test for approvals Contexts : None Explanation : The formula is passed a resource id, period start and period end and maximum hours. Period start and end are the application period start and end dates. If the maximum hours is less than the number of hours over the period specified then the formula returns TO APPROVE equal to Y to initiate the approval process *********************************************************************/ /* Change History: Date Author Comments ------------ -------------- ------------------------------------ 04-Nov-2013 Sameer Patil */ /***************************************************************** Initialise Variables which can be null ******************************************************************/ default for db_pre_period_start is ' ' default for db_pre_period_end is ' ' default for db_post_period_start is ' ' default for db_post_period_end is ' ' default for db_ref_period_start is ' ' default for db_ref_period_end is ' ' default for reference_period is 1 default for duration_in_days is 1 default for period is 1 default for timecard_hrs is 0 default for period_maximum is 0 /* ****************************************************************** READ IN INPUT VARIABLES ****************************************************************** */ INPUTS ARE resource_id (number) , submission_date (text) , period (number) , period_maximum (number) , reference_period (number) , db_pre_period_start (text) , db_pre_period_end (text) , db_post_period_start (text) , db_post_period_end (text) , db_ref_period_start (text) , db_ref_period_end (text) , duration_in_days (number) , timecard_hrs (number) /* **************************************************************** Processing **************************************************************** */ IF ( xxtest_period_max (resource_id, submission_date, period_maximum, period, reference_period, db_pre_period_start, db_pre_period_end, db_post_period_start, db_post_period_end, db_ref_period_start, db_ref_period_end, duration_in_days, timecard_hrs ) = 1 ) THEN to_approve = 'Y' ELSE to_approve = 'N' /* **************************************************************** RETURN VARIABLE **************************************************************** */ RETURN to_approve "Team Work" More We Less Me.