![Fast Formula and Functions [PDF]](https://pdfs.asia/img/200x200/fast-formula-and-functions.jpg)
17 0 974 KB
Fast Formula and Functions
We have tried to list all the available Fusion Functions below. You can always approach the Oracle team for further explanation. Some functions may be obsolete or not available in your release. Please check with the documentation or with the Oracle support. Function Name
CALCULATE_HOURS_WORKED
Return
Parameter
Type
In Out
Optional
Seq.
P_STD_HOURS
Num
In
No
1
P_RANGE_START
Dt
In
No
2
P_RANGE_END
Dt
In
No
3
P_STD_FREQ
Txt
In
No
4
Context
Num
PAYROLL_ID CALCULATE_PAYROLL_PERIODS
Num EFFECTIVE_DATE
HRC_CREATE_BO_EXTRACT
GET_ABSENCE
GET_ACCRUAL_BAND
GET_ASG_INACTIVE_DAYS
P_OBJECT_NAME
Txt
In
No
1
P_EXTRACT_TYPE
Txt
In
No
2
P_START_DATE
Dt
In
No
1
PAYROLL_ASSIGNMENT_ID
P_CALCULATION_DATE
Dt
In
No
2
ACCRUAL_PLAN_ID
P_BAND_GROUP
Txt
In
No
1
P_BAND_RANGE
Num
In
No
2
P_PERIOD_SD
Dt
In
No
1
P_PERIOD_ED
Dt
In
No
2
Num
Num
Num
ACCRUAL_PLAN_ID
Num
PAYROLL_ASSIGNMENT_ID PAYROLL_ASSIGNMENT_ID
GET_ASSIGNMENT_SALARY
Num
GET_ASSIGNMENT_STATUS
Num
EFFECTIVE_DATE
GET_CARRY_OVER
GET_EARLIEST_ASGCHANGE_DATE
PAYROLL_ASSIGNMENT_ID P_START_DATE
Dt
In
No
1
PAYROLL_ASSIGNMENT_ID
P_CALCULATION_DATE
Dt
In
No
2
ACCRUAL_PLAN_ID
P_EVENT_GROUP
Txt
In
No
1
LEGISLATIVE_DATA_GROUP_ID
P_START_DATE
Dt
In
No
2
PAYROLL_ASSIGNMENT_ID
P_END_DATE
Dt
In
No
3
P_RECALC_DATE
Dt
In
No
4
Num
Dt
ELEMENT_ENTRY_ID GET_ELEMENT_ENTRY
Num
PAYROLL_ASSIGNMENT_ID PAYROLL_REL_ACTION_ID
GET_END_DATE
GET_NET_ACCRUAL
GET_OTHER_NET_CONTRIBUTION
GET_PAYROLL_DETAILS
Dt
P_START_DATE
Dt
In
No
1
P_PERIOD_LENGTH
Num
In
No
2
P_PERIOD_UOM
Txt
In
No
3
P_ACCRUAL_PLAN_ID
Num
In
No
1
PAYROLL_ASSIGNMENT_ID
P_ACCRUAL_START_DATE
Dt
In
No
2
PAYROLL_ID
P_CALCULATION_DATE
Dt
In
No
3
PAYROLL_REL_ACTION_ID
P_ACCRUAL_LATEST_BALANCE
Num
In
No
4
P_START_DATE
Dt
In
No
1
PAYROLL_ASSIGNMENT_ID
P_CALCULATION_DATE
Dt
In
No
2
ACCRUAL_PLAN_ID
P_PAYROLL_ID
Num
In
No
1
P_DATE_IN_PERIOD
Dt
In
No
2
Num
Num
Num
GET_PAYROLL_DTRANGE
Num
P_PAYROLL_ID
Num
In
No
1
GET_PAYROLL_ID
Num
P_DATE_IN_PERIOD
Dt
In
No
1
GET_PAYROLL_PERIOD
Num
P_DATE_IN_PERIOD
Dt
In
No
1
GET_PERIOD_DATES
Num
P_BASE_START_DATE
Dt
In
No
1
PAYROLL_ASSIGNMENT_ID PAYROLL_ID PAYROLL_ID
GET_RETRO_ELEMENT
Num
GET_START_DATE
Dt
GET_TERMINATION_DATE
Num
GET_WORKING_DAYS
Num
P_PERIOD_LENGTH
Num
In
No
2
P_PERIOD_UNITS
Txt
In
No
3
P_DATE_IN_PERIOD
Dt
In
No
4
Yes P_ACCRUAL_START_DATE
Dt
In
No
1
PAYROLL_ASSIGNMENT_ID
P_TURN_OF_YEAR_DATE
Dt
In
No
2
ACCRUAL_PLAN_ID PAYROLL_REL_ACTION_ID
RESET_ACCRUALS
SET_ACCRUAL_BALANCE
PAYROLL_ASSIGNMENT_ID P_START_DATE
Dt
In
No
1
P_END_DATE
Dt
In
No
2
Txt
Num
Yes P_ELEMENT_TYPE
Txt
In
No
1
ACCRUAL_PLAN_ID
P_ELEMENT_TYPE_ID
Num
In
No
2
PAYROLL_ASSIGNMENT_ID
P_INPUT_VALUE_ID
Num
In
No
3
P_ACCRUAL_BAND_ID
Num
In
No
4
P_ABSENCE_TYPE_ID
Num
In
No
5
P_ABSENCE_ATTENDANCE_ID
Num
In
No
6
P_START_DATE
Dt
In
No
7
P_END_DATE
Dt
In
No
8
P_CONTRIBUTED_AMT
Num
In
No
9
ARCHIVE_CLEAR
Txt
Yes
ARCHIVE_CLEAR_RECORD
Txt
Yes
ARCHIVE_FLUSH
Txt
ARCHIVE_INIT
Txt
ARCHIVE_MESSAGE
ARCHIVE_VALUE
ARCHIVE_VALUE
ARCHIVE_VALUE
BEN_CHK_ABS_TYPE BEN_FN_EFFECTIVE_DATE
BEN_FN_GET_CHAR_VALUE
Txt
Yes category
Txt
In
No
1
p_application
Num
In
No
1
message
Txt
In
No
2
p_severity
Txt
In
No
3
p_token_name1
Txt
In
Yes
4
p_token_value1
Txt
In
Yes
5
p_token_name2
Txt
In
Yes
6
p_token_value2
Txt
In
Yes
7
p_token_name3
Txt
In
Yes
8
p_token_value3
Txt
In
Yes
9
p_token_name4
Txt
In
Yes
10
p_token_value4
Txt
In
Yes
11
p_token_name5
Txt
In
Yes
12
p_token_value5
Txt
In
Yes
13
name
Txt
In
No
1
value
Txt
In
No
2
name
Txt
In
No
1
value
Dt
In
No
2
name
Txt
In
No
1
value
Num
In
No
2
l_absence_type_id
Txt
In
No
1
l_yn
Txt
Out
No
2
P_TABLE_NAME
Txt
In
No
1
HR_ASSIGNMENT_ID
P_COLUMN_NAME
Txt
In
No
2
EFFECTIVE_DATE
P_PL_NAME
Txt
In
Yes
3
BUSINESS_GROUP_ID
P_OPT_NAME
Txt
In
Yes
4
P_ADD_KEY_NAME
Txt
In
Yes
5
dd
Txt
Txt
Txt
Txt
PL_ID
Dt
Txt
EFFECTIVE_DATE
P_ADD_KEY_VALUE
Txt
In
Yes
6
Txt
ovr_type
Txt
In
No
1
Txt
range_value
Num
In
Yes
1
periodicity
Txt
Out
No
1
out_uom
Txt
Out
No
2
base_value
Num
In
No
3
range_value
Num
In
Yes
4
factor
Num
In
Yes
5
range_offset
Num
In
Yes
6
range_name
Txt
In
Yes
7
base_value
Num
In
No
1
range_value
Num
In
Yes
2
factor
Num
In
Yes
3
range_offset
Num
In
Yes
4
range_name
Txt
In
Yes
5
item_calc_type
Txt
Out
No
1
overall_calc_type
Txt
Out
No
2
low_value
Num
Out
No
3
high_value
Num
Out
No
4
base_value
Num
Out
No
5
rate
Num
Out
No
6
flat_amount
Num
Out
No
7
multiplier
Num
Out
No
8
parameter
Txt
Out
No
9
A
Num
Out
No
10
B
Num
Out
No
11
C
Num
Out
No
12
val_def_name
Txt
Out
No
13
override_flags
Txt
Out
No
14
P_PRINT_MESSAGE_CODE
Txt
In
No
1
P_PRINT_MESSAGE
Txt
In
No
2
range_name
Txt
In
No
1
range_name
Txt
In
No
1
low_value
Num
In
No
2
high_value
Num
In
No
3
p_src_amount
Num
In
No
1
PAYROLL_ID
p_src_periodicity
Txt
In
No
2
ELEMENT_TYPE_ID
p_trgt_periodicity
Txt
In
No
3
p_date_used
Dt
In
No
4
NUM
Num
In
No
1
DAT
Dt
In
No
1
NUM
Num
In
No
2
DAT
Dt
In
No
1
MONTHS
Num
In
No
2
DAT
Dt
In
No
1
YEARS
Num
In
No
2
NUM
Num
In
No
1
STR
Txt
In
No
1
DEST
Txt
In
No
2
SOURCE
Txt
In
Yes
3
CALC_DIR_EXISTS
Txt
CALC_DIR_GET_OVERRIDE_LEVEL CALC_DIR_TEXT_VALUE
CALC_DIR_VALUE
CALC_DIR_VALUE
CALC_DIR_VALUE_DETAIL
CA_FORMULA_LOGGING DEFINE_RANGE
DEFINE_RANGE_ITEM
ELEMENT_RATE_CONVERTER
ABS ADD_DAYS
ADD_MONTHS
ADD_YEARS CHR
Num
Num
Num
Txt Num
Num
Num
Num Dt
Dt
Dt Txt
Txt
DATE_TO_TEXT
Txt
DAT
Dt
In
No
1
DATE_TO_TEXT
Txt
DAT
Dt
In
No
1
DATE_TO_TEXT
Txt
FMT
Txt
In
No
2
DAT1
Dt
In
No
1
DAT2
Dt
In
No
2
LOOKUP_TYPE
Txt
In
No
1
LOOKUP_CODE
Txt
In
No
2
DEFAULT_MEANING
Txt
In
No
3
DAYS_BETWEEN
GET_LOOKUP_MEANING
Num
Txt
ESS_LOG_WRITE
Txt
LOG_MESSAGE
Txt
In
No
1
FLOOR
Num
NUM
Num
In
No
1
GET_FORMULA_NAME
Txt
FORMULA_ID
Num
In
No
1
APP_NAME
Txt
In
No
1
MESG_NAME
Txt
In
No
2
TOKEN1
Txt
In
Yes
3
VALUE1
Txt
In
Yes
4
TOKEN2
Txt
In
Yes
5
VALUE2
Txt
In
Yes
6
TOKEN3
Txt
In
Yes
7
VALUE3
Txt
In
Yes
8
TOKEN4
Txt
In
Yes
9
VALUE4
Txt
In
Yes
10
TOKEN5
Txt
In
Yes
11
VALUE5
Txt
In
Yes
12
LOOKUP_TYPE
Txt
In
No
1
LOOKUP_CODE
Txt
In
No
2
EXPR1
Dt
In
No
1
EXPR2
Dt
In
Yes
2
Num
In
No
1
Num
In
Yes
2
EXPR1
Txt
In
No
1
EXPR2
Txt
In
Yes
2
GET_MESG
GET_LOOKUP_MEANING
GREATEST
GREATEST
GREATEST
Txt
Txt
Dt
Num
EXPR1
Txt
HR_TRACE
Txt
TRACE_DATA
Txt
In
No
1
INITCAP
Txt
STR
Txt
In
No
1
STR1
Txt
In
No
1
STR2
Txt
In
No
2
STR1
Txt
In
No
1
STR2
Txt
In
No
2
NUM1
Num
In
No
3
NUM2
Num
In
Yes
4
STR1
Txt
In
No
1
STR2
Txt
In
No
2
STR1
Txt
In
No
1
STR2
Txt
In
No
2
NUM1
Num
In
No
3
NUM2
Num
In
Yes
4
DAT
Dt
In
No
1
EXPR1
Dt
In
No
1
EXPR2
Dt
In
Yes
2
EXPR1
Num
In
No
1
EXPR2
Num
In
Yes
2
EXPR1
Txt
In
No
1
INSTRB
INSTRB
INSTR
INSTR
LAST_DAY LEAST
LEAST LEAST
Num
Num
Num
Num
Dt Dt
Num Txt
EXPR2
Txt
In
Yes
2
LENGTH
Num
STR
Txt
In
No
1
LENGTHB
Num
STR
Txt
In
No
1
LOWER
Txt
STR
Txt
In
No
1
STR
Txt
In
No
1
LEN
Num
In
No
2
PAD
Txt
In
Yes
3
STR
Txt
In
No
1
SET
Txt
In
Yes
2
N1
Num
In
No
1
N2
Num
In
No
2
DAT1
Dt
In
No
1
DAT2
Dt
In
No
2
DAT
Dt
In
No
1
ZONE1
Txt
In
No
2
ZONE2
Txt
In
No
3
DAT
Dt
In
No
1
DAY
Txt
In
No
2
NUM
Num
In
No
1
FMT
Txt
In
No
2
NUM1
Num
In
No
1
NUM2
Num
In
No
2
STR1
Txt
In
No
1
STR2
Txt
In
No
2
STR3
Txt
In
Yes
3
DAT
Dt
In
No
1
FMT
Txt
In
Yes
2
NUM
Num
In
No
1
PLACES
Num
In
Yes
2
NUM1
Num
In
No
1
NUM1
Num
In
No
1
PLACES
Num
In
No
2
STR
Txt
In
No
1
LEN
Num
In
No
2
PAD
Txt
In
Yes
3
STR
Txt
In
No
1
SET
Txt
In
Yes
2
STR
Txt
In
No
1
POS
Num
In
No
2
LEN
Num
In
Yes
3
STR
Txt
In
No
1
POS
Num
In
No
2
LEN
Num
In
Yes
3
LPAD
LTRIM
MOD
MONTHS_BETWEEN
NEW_TIME
NEXT_DAY
NUM_TO_CHAR
POWER
REPLACE
ROUND
ROUND ROUND_UP ROUND_UP
RPAD
RTRIM
SUBSTR
SUBSTRB
Txt
Txt
Num
Num
Dt
Dt
Txt
Num
Txt
Dt
Num Num Num
Txt
Txt
Txt
Txt
TO_CHAR
Txt
DAT
Dt
In
No
1
TO_CHAR
Txt
NUM
Num
In
No
1
DAT
Dt
In
No
1
FMT
Txt
In
No
2
STR
Txt
In
No
1
STR
Txt
In
No
1
FMT
Txt
In
No
2
STR
Txt
In
No
1
TO_CHAR
Txt
TO_DATE
Dt
TO_DATE
Dt
TO_NUMBER
Num
TO_TEXT TO_TEXT TO_TEXT
TRANSLATE
Txt
Txt
Txt
Txt
TRUNC
Dt
UPPER
GET_ABSENCE_COUNTS
GET_ABSENCE_DAYS_PER_TYPE
GET_ABS_MIN_MAX_DATES
GET_ACCRUAL_BALANCE
GET_BAL_COMP_VAL
GET_BAL_HDR_VAL
Dt
In
No
1
DAT
Dt
In
No
1
FMT
Txt
In
No
2
NUM
Num
In
No
1
STR
Txt
In
No
1
FROM
Txt
In
No
2
TO
Txt
In
No
3
STR
Txt
In
No
1
DAT
Dt
In
No
1
FMT
Txt
In
Yes
2
NUM
Num
In
No
1
PLACES
Num
In
Yes
2
STR
Txt
In
No
1
P_PERSON_ID
Num
In
No
1
PERSON_ID
P_INCLUDE_TYPE_ID
Num
In
No
2
HR_ASSIGNMENT_ID
P_EXCLUDE_TYPE_ID
Num
In
No
3
ACCRUAL_PLAN_ID
P_INCLUDE_CATEGOR_ID
Num
In
No
4
EFFECTIVE_DATE
P_EXCLUDE_CATEGORY_ID
Num
In
No
5
P_INCLUDE_REASON_ID
Num
In
No
6
P_EXCLUDE_REASON_ID
Num
In
No
7
P_START_DATE_FROM
Dt
In
No
8
P_START_DATE_TO
Dt
In
No
9
P_DURATION_DAYS
Num
Out
No
10
P_DURATION_HOURS
Num
Out
No
11
P_DURATION_CAL
Num
Out
No
12
P_DURATION_WEEKS
Num
Out
No
13
P_DURATION_MONTHS
Num
Out
No
14
P_DURATION_YEARS
Num
Out
No
15
P_OCCURANCES
Num
Out
No
16
P_ABSENCE_TYPE_NAME
Txt
In
No
1
P_START_DATE
Dt
In
No
2
P_END_DATE
Dt
In
No
3
P_PERSON_ID
Num
In
No
1
P_INCLUDE_TYPE_ID
Num
In
No
2
P_EXCLUDE_TYPE_ID
Num
In
No
3
P_INCLUDE_CATEGOR_ID
Num
In
No
4
P_EXCLUDE_CATEGORY_ID
Num
In
No
5
P_INCLUDE_REASON_ID
Num
In
No
6
P_EXCLUDE_REASON_ID
Num
In
No
7
P_START_DATE_FROM
Dt
In
No
8
P_START_DATE_TO
Dt
In
No
9
P_MIN_DATE
Dt
Out
No
10
P_MAX_DATE
Dt
Out
No
11
Txt
TRIM
TRUNC
DAT
Num Txt
Num
Num
Num
Num
Num
PERSON_ID
Yes P_PL_NAME
Txt
In
Yes
1
PERSON_ID
P_START_DATE
Dt
In
Yes
2
HR_ASSIGNMENT_ID
P_END_DATE
Dt
In
Yes
3
EFFECTIVE_DATE
P_TYPE
Txt
In
Yes
4
LEGISLATIVE_DATA_GROUP_ID
P_ADJ_REASON
Txt
In
Yes
5
P_PL_NAME
Txt
In
No
1
PERSON_ID
P_BEGIN_BAL
Num
Out
No
2
HR_ASSIGNMENT_ID
Num
P_ACCRUED
Num
Out
No
3
EFFECTIVE_DATE
P_USED
Num
Out
No
4
LEGISLATIVE_DATA_GROUP_ID
P_END_BAL
Num
Out
No
5
P_ACCRUAL_PERIOD
Dt
Out
No
6
GET_CONTEXT_VALUE
Txt
name
Txt
In
No
1
GET_CONTEXT_VALUE_DATE
Dt
name
Txt
In
No
1
GET_CONTEXT_VALUE_NUMBER
Num
name
Txt
In
No
1
P_START_DATETIME
Dt
In
Yes
1
PERSON_ID
P_END_DATETIME
Dt
In
Yes
2
HR_ASSIGNMENT_ID
P_UOM
Txt
In
Yes
3
P_PL_NAME
Txt
In
No
1
PERSON_ID
P_ENRT_ST_DT
Dt
Out
No
2
HR_ASSIGNMENT_ID
P_ENRT_END_DT
Dt
Out
No
3
EFFECTIVE_DATE
P_LAST_ACCRUAL_RUN
Dt
Out
No
4
LEGISLATIVE_DATA_GROUP_ID
P_PL_NAME
Txt
In
Yes
1
PERSON_ID
P_BAND_NAME
Txt
In
Yes
2
LEGISLATIVE_DATA_GROUP_ID
P_BAND_PERCENTAGE
Num
In
Yes
3
P_START_DATE
Dt
In
Yes
4
P_END_DATE
Dt
In
Yes
5
P_START_DATE
Dt
In
Yes
1
PERSON_ID
P_END_DATE
Dt
In
Yes
2
HR_ASSIGNMENT_ID
P_EVENT_TYPE
Txt
In
Yes
3
geography_id
Num
Out
No
1
geography_name
Txt
In
No
2
level
Txt
In
No
3
parent_geography_id
Num
In
Yes
4
provider
Txt
In
Yes
5
subtype
Txt
In
Yes
6
use
Txt
In
Yes
7
geography_id
Num
In
No
1
use
Txt
In
Yes
2
geography_code
Txt
In
No
1
level
Txt
In
No
2
provider
Txt
In
Yes
3
subtype
Txt
In
Yes
4
use
Txt
In
Yes
5
sec_subtype
Txt
In
Yes
6
GET_DURATION
GET_ENRT_DTLS
GET_ENTITLEMENTS
GET_EVENT_DATE
GET_GEOGRAPHY_IDENTIFIER
GET_GEOGRAPHY_NAME
GET_GEO_STD_NAME_BY_USER_COD E
Num
Num
Num
Dt
Txt
Txt
Txt
GET_PARAMETER_VALUE
Txt
name
Txt
In
No
1
GET_PARAMETER_VALUE_DATE
Dt
name
Txt
In
No
1
GET_PARAMETER_VALUE_NUMBER
Num
name
Txt
In
No
1
P_RESOURCE_TYPE
Txt
In
Yes
1
P_PERIOD_START
Dt
In
Yes
2
P_PERIOD_END
Dt
In
Yes
3
P_USE_SCH_ASG
Txt
In
Yes
4
P_USE_SCH_INH
Txt
In
Yes
5
P_INCLUDE_NOSHIFT
Txt
In
Yes
6
P_INCLUDE_CALEVENTS
Txt
In
Yes
7
P_CALC_UNITS
Txt
In
Yes
8
P_GET_FULL_PAY_PERIOD
Txt
In
Yes
9
P_USE_WORKING_HOUR_METHOD
Txt
In
Yes
10
P_DEFAULT_HOURS_PER_DAY
Num
In
Yes
11
GET_PAY_AVAILABILITY
Num
HR_ASSIGNMENT_ID
P_DEFAULT_START_TIME
Txt
In
Yes
12
P_DEFAULT_WORK_WEEK
Txt
In
Yes
13 PERSON_ID HR_ASSIGNMENT_ID
GET_PLAN_BALANCE
Num
P_PL_NAME
Txt
In
Yes
1
from_currency
Txt
In
No
1
to_currency
Txt
In
No
2
rate_type
Txt
In
No
3
processing_type
Txt
In
No
1
FROM_CURRENCY
Txt
In
No
1
TO_CURRENCY
Txt
In
No
2
RATE_TYPE
Txt
In
No
3
DEFAULT_RATE
Num
In
No
4
table_name
Txt
In
No
1
column_name
Txt
In
No
2
row_value
Txt
In
No
3
effective_date
Dt
In
No
4
group_level
Txt
In
Yes
5
default_value
Txt
In
Yes
6
table_name
Txt
In
No
1
LEGISLATIVE_DATA_GROUP_ID
column_name
Txt
In
No
2
EFFECTIVE_DATE
row_value
Txt
In
No
3
default_value
Txt
In
Yes
4
p_rate_def_name
Txt
In
No
1
PAYROLL_RELATIONSHIP_ID
p_out_periodicity
Txt
Out
No
2
EFFECTIVE_DATE
range_value
Num
In
No
3
base_value
Num
In
No
4
factor
Num
In
No
5
range_offset
Num
In
No
6
P_VALUESET
Txt
In
No
1
P_BINDS
Txt
In
Yes
2
P_FILTER
Txt
In
Yes
3
P_ENABLE_CACHE
Txt
In
Yes
4
p_ffs_id
Num
In
No
1
p_parm_name
Txt
In
No
2
p_parm_seq
Num
In
No
3
defval
Num
In
No
4
EFFECTIVE_DATE LEGISLATIVE_DATA_GROUP_ID
GET_RATE
Txt
EFFECTIVE_DATE
EFFECTIVE_DATE GET_RATE_TYPE
GET_RATE
GET_TABLE_VALUE
GET_TABLE_VALUE
GET_VALUE_BY_CRITERIA
GET_VALUE_SET
GET_WRK_NUM
Txt
Txt
Num
Txt
Num
P_INFO_TYPE
Txt
In
No
1
HRX_AE_GET_EMP_DETAILS
Txt
P_LEGISLATION_CODE
Txt
In
No
2
HRX_AE_GET_FORMULA_NAME
Txt
P_FORMULA_ID
Num
In
No
1
HRX_AE_GET_GRADE_DETAILS
Num
P_GRADE_NAME
Txt
Out
No
1
P_RATE
Num
In
No
1
P_GRADE_ID
Num
In
No
2
P_TABLE_NAME
Txt
In
No
1
P_GRADE_ID
Num
In
No
2
P_TABLE_EXISTS
Txt
Out
No
3
P_PCT_VALUE
Num
In
No
1
P_SUBJECT_TO_GOSI
Num
In
No
2
P_INFO_TYPE
Txt
In
No
1
HRX_SA_GET_C_WAGE_EMP_AGE HRX_SA_GET_EMP_DETAILS
LEGISLATIVE_DATA_GROUP_ID
Txt
Txt
HRX_AE_GET_RATE_FROM_TAB_NAME
EFFECTIVE_DATE
Num
HRX_AE_GET_EMP_DETAILS
HRX_AE_GET_RATE_FROM_TAB_ID
ENTERPRISE_ID
Num
Num
Num Txt
Txt
In
No
2
HRX_SA_GET_FORMULA_NAME
Txt
P_FORMULA_ID
Num
In
No
1
HRX_SA_GET_GRADE_DETAILS
Num
P_GRADE_NAME
Txt
Out
No
1
P_RATE
Num
In
No
1
P_GRADE_ID
Num
In
No
2
P_TABLE_NAME
Txt
In
No
1
P_GRADE_ID
Num
In
No
2
P_TABLE_EXISTS
Txt
Out
No
3
table_name
Txt
In
No
1
ENTERPRISE_ID
column_name
Txt
In
No
2
EFFECTIVE_DATE
row_value
Txt
In
No
3
default_value
Txt
In
Yes
4
p_ffs_id
Num
In
No
1
p_log_text
Txt
In
No
2
p_ffs_id
Num
In
No
1
p_rule_id
Num
In
No
2
p_log_text
Txt
In
No
3
p_ffs_id
Num
In
No
1
p_rule_id
Num
In
No
2
p_message_text
Txt
In
No
3
person_assignment_id
Num
In
No
1
is_Person_id
Txt
In
No
2
start_date
Dt
In
No
3
stop_date
Dt
In
No
4
payroll_time_type
Txt
In
Yes
5
pyr_aprv_status
Txt
In
Yes
6
default_value
Num
In
Yes
7
p_in_date
Dt
In
No
1
p_exp_id
Txt
In
No
1
defval
Txt
In
No
2
Txt
p_in_date
Dt
In
No
1
Txt
p_format
Txt
In
No
2
Txt
p_in_day_of_week
Txt
In
No
1
p_ffs_id
Num
In
No
1
p_value_name
Txt
In
No
2
defval
Dt
In
No
3
p_ffs_id
Num
In
No
1
p_value_name
Txt
In
No
2
defval
Num
In
No
3
p_ffs_id
Num
In
No
1
p_value_name
Txt
In
No
2
defval
Txt
In
No
3
P_rule_Id
Num
In
No
1
p_column_name
Txt
In
No
2
defval
Txt
In
No
3
p_in_date
Dt
In
No
1
p_in_day_of_week
Txt
In
No
2
start_time
Dt
In
No
1
HRX_SA_GET_RATE_FROM_TAB_ID
HRX_SA_GET_RATE_FROM_TAB_NAME
HR_GET_TABLE_VALUE
ADD_LOG
ADD_RLOG
RAISE_ERROR
GET_CALCULATED_HOURS
GET_DATE_DAY_OF_WEEK GET_EXPENDITURE_TYPE_NAME
Num
Num
Txt
Num
Num
Num
Num
Txt Txt
GET_FORMATED_DATE GET_FORMATED_DAY_OF_WEEK
GET_FVALUE_DATE
GET_FVALUE_NUMBER
GET_FVALUE_TEXT
GET_HDR_TEXT
GET_IS_DATE_SAME_AS_DOW
Dt
Num
Txt
Txt
Txt
GET_MEASURE_FROM_TIME
Num stop_time
Dt
In
No
2
GET_MSG_ATTRIBUTE
Txt
p_msg_attr_name
Txt
In
No
1
GET_MSG_SEVERITY
Txt
p_msg_severity
Txt
In
No
1
GET_OUTPUT_MSG
GET_OUTPUT_MSG1
GET_OUTPUT_MSG2
GET_OUTPUT_MSG3
GET_OUTPUT_MSG4
GET_PROJECT_NUMBER
GET_REPORTED_HOURS
GET_RULE_HDR_TEXT
GET_RVALUE_DATE
p_app_short_name
Txt
In
No
1
p_message_name
Txt
In
No
2
p_app_short_name
Txt
In
No
1
p_message_name
Txt
In
No
2
token1_Name
Txt
In
No
3
token1_Value
Txt
In
No
4
p_app_short_name
Txt
In
No
1
p_message_name
Txt
In
No
2
token1_Name
Txt
In
No
3
token1_Value
Txt
In
No
4
token2_Name
Txt
In
No
5
token2_Value
Txt
In
No
6
p_app_short_name
Txt
In
No
1
p_message_name
Txt
In
No
2
token1_Name
Txt
In
No
3
token1_Value
Txt
In
No
4
token2_Name
Txt
In
No
5
token2_Value
Txt
In
No
6
token3_Name
Txt
In
No
7
token3_Value
Txt
In
No
8
p_app_short_name
Txt
In
No
1
p_message_name
Txt
In
No
2
token1_Name
Txt
In
No
3
token1_Value
Txt
In
No
4
token2_Name
Txt
In
No
5
token2_Value
Txt
In
No
6
token3_Name
Txt
In
No
7
token3_Value
Txt
In
No
8
token4_Name
Txt
In
No
9
token4_Value
Txt
In
No
10
p_id
Num
In
No
1
defval
Txt
In
No
2
Num
In
No
1
Txt
In
No
2
Dt
In
No
3
Dt
In
No
4
Txt
In
Yes
5
Txt
In
Yes
6
Num
In
Yes
7
p_ffs_id
Num
In
No
1
p_column_name
Txt
In
No
2
defval
Txt
In
No
3
p_rule_id
Num
In
No
1
p_value_name
Txt
In
No
2
defval
Dt
In
No
3
Txt
Txt
Txt
Txt
Txt
Txt
Num
Txt
Dt
person_assignment_id
GET_RVALUE_NUMBER
Num
p_rule_id
Num
In
No
1
GET_RVALUE_NUMBER
Num
p_value_name
Txt
In
No
2
GET_RVALUE_NUMBER
Num
defval
Num
In
No
3
p_rule_id
Num
In
No
1
GET_RVALUE_TEXT
Txt
p_value_name
Txt
In
No
2
defval
Txt
In
No
3
GET_TASK_NUMBER
GET_TOIL_HOURS
GET_WRK_DATE
GET_WRK_TEXT
INIT_UTIL
SET_WRK_DATE
SET_WRK_NUM
SET_WRK_TEXT
TIME_HHMM_TO_DEC
GET_ASG_STATUS
GET_ENT_NAME
GET_GRADE_NAME
GET_JOB_NAME
GET_LEGENTITY_NAME
p_id
Num
In
No
1
defval
Txt
In
No
2
person_id
Num
In
No
1
start_date
Dt
In
No
2
stop_date
Dt
In
No
3
payroll_time_type
Txt
In
No
4
pyr_aprv_status
Txt
In
No
5
default_value
Num
In
No
6
p_ffs_id
Num
In
No
1
p_parm_name
Txt
In
No
2
p_parm_seq
Num
In
No
3
defval
Dt
In
No
4
p_ffs_id
Num
In
No
1
p_parm_name
Txt
In
No
2
p_parm_seq
Num
In
No
3
defval
Txt
In
No
4
p_ffs_id
Num
In
No
1
p_rule_id
Num
In
No
2
p_ffs_id
Num
In
No
1
p_parm_name
Txt
In
No
2
p_parm_seq
Num
In
No
3
p_parm_value
Dt
In
No
4
p_ffs_id
Num
In
No
1
p_parm_name
Txt
In
No
2
p_parm_seq
Num
In
No
3
p_parm_value
Num
In
No
4
p_ffs_id
Num
In
No
1
p_parm_name
Txt
In
No
2
p_parm_seq
Num
In
No
3
p_parm_value
Txt
In
No
4
time_dec
Num
In
No
1
P_ASG_ID
Num
In
No
1
P_CALC_DATE
Dt
In
No
2
P_VALUE
Txt
Out
No
3
P_NAME
Txt
Out
No
4
P_ASG_ID
Num
In
No
1
P_CALC_DATE
Dt
In
No
2
P_VALUE
Txt
Out
No
3
P_NAME
Txt
Out
No
4
P_ASG_ID
Num
In
No
1
P_CALC_DATE
Dt
In
No
2
P_VALUE
Txt
Out
No
3
P_NAME
Txt
Out
No
4
P_ASG_ID
Num
In
No
1
P_CALC_DATE
Dt
In
No
2
P_VALUE
Txt
Out
No
3
P_NAME
Txt
Out
No
4
P_ASG_ID
Num
In
No
1
P_CALC_DATE
Dt
In
No
2
P_VALUE
Txt
Out
No
3
P_NAME
Txt
Out
No
4
Txt
Num
Dt
Txt
Num
Num
Num
Num
Num
Num
Num
Num
Num
Num
GET_LOCATON_NAME
GET_MGR_NAME
GET_ORG_NAME
GET_POSITION_NAME
GET_HOME_CITY
GET_HOME_COUNTRY
GET_RATING_LEVEL
P_ASG_ID
Num
In
No
1
P_CALC_DATE
Dt
In
No
2
P_VALUE
Txt
Out
No
3
P_NAME
Txt
Out
No
4
P_ASG_ID
Num
In
No
1
P_CALC_DATE
Dt
In
No
2
P_VALUE
Txt
Out
No
3
P_NAME
Txt
Out
No
4
P_ASG_ID
Num
In
No
1
P_CALC_DATE
Dt
In
No
2
P_VALUE
Txt
Out
No
3
P_NAME
Txt
Out
No
4
P_ASG_ID
Num
In
No
1
P_CALC_DATE
Dt
In
No
2
P_VALUE
Txt
Out
No
3
P_NAME
Txt
Out
No
4
P_ASG_ID
Num
In
No
1
P_CALC_DATE
Dt
In
No
2
P_VALUE
Txt
Out
No
3
P_NAME
Txt
Out
No
4
P_ASG_ID
Num
In
No
1
P_CALC_DATE
Dt
In
No
2
P_VALUE
Txt
Out
No
3
P_NAME
Txt
Out
No
4
P_ASG_ID
Num
In
No
1
P_CALC_DATE
Dt
In
No
2
P_VALUE
Txt
Out
No
3
P_NAME
Txt
Out
No
4
calc_mode
Txt
In
No
1
result_value
Num
In
Yes
1
Num
Num
Num
Num
Num
Num
Num
ENTERPRISE_ID
ITERATIVE_GET_BINARY_GUESS
Num
ITERATIVE_GET_HIGH_VALUE
Num
ITERATIVE_GET_INTERP_GUESS
Num
ITERATIVE_GET_LOW_VALUE
Num
ELEMENT_ENTRY_ID
ITERATIVE_GET_TARGET_VALUE
Num
ELEMENT_ENTRY_ID
ITERATIVE_INITIALISE
Num
ITERATIVE_IS_AMOUNT_SET
Num
ELEMENT_ENTRY_ID
ITERATIVE_IS_FIRST_SETTING
Num
ELEMENT_ENTRY_ID
PAY_EDN_PUBLISH_EVENT
Txt
p_namespace
Txt
In
No
1
PAY_EDN_PUBLISH_EVENT
Txt
p_local_name
Txt
In
No
2
PAY_EDN_PUBLISH_EVENT
Txt
p_payload
Txt
In
No
3
PAY_GET_RATE_TYPE
Txt
processing_type
Txt
In
No
1
PAY_INTERNAL_LOG_WRITE
Txt
print_string
Txt
In
No
1
name
Txt
In
No
1
token1
Txt
In
Yes
2
token2
Txt
In
Yes
3
token3
Txt
In
Yes
4
name
Txt
In
No
1
token1
Txt
In
Yes
2
token2
Txt
In
Yes
3
token3
Txt
In
Yes
4
EFFECTIVE_DATE
target_value
Num
In
No
1
ELEMENT_ENTRY_ID
ELEMENT_ENTRY_ID
EFFECTIVE_DATE
PAY_LOG_ERROR
PAY_LOG_WARNING
CLEAR_GLOBALS
Txt
Txt
Num
Yes
LEGISLATIVE_DATA_GROUP_ID
DEBUG
Num
P_MESSAGE
Txt
In
No
1
GET_DATE
Dt
P_NAME
Txt
In
No
1
GET_NUMBER
Num
P_NAME
Txt
In
No
1
GET_TEXT
Txt
P_NAME
Txt
In
No
1
IS_DATE_NULL
Txt
P_VALUE
Dt
In
No
1
ISNULL
Txt
P_VALUE
Dt
In
No
1
ISNULL
Txt
P_VALUE
Num
In
No
1
ISNULL
Txt
P_VALUE
Txt
In
No
1
IS_NUMBER_NULL
Txt
P_VALUE
Num
In
No
1
IS_TEXT_NULL
Txt
P_VALUE
Txt
In
No
1
P_APPLICATION_ID
Num
In
No
1
P_MESSAGE_NAME
Txt
In
No
2
P_NAME
Txt
In
No
1
P_VALUE
Dt
In
No
2
P_NAME
Txt
In
No
1
RAISE_ERROR
Num
REMOVE_GLOBALS
Num
SET_DATE
Num
SET_NUMBER
Num P_VALUE
Num
In
No
2
Num
P_NAME
Txt
In
No
1
Num
P_VALUE
Txt
In
No
2
low
Num
In
No
1
high
Num
In
No
2
number1
Num
In
No
1
p_src_amount
Num
In
No
1
p_src_periodicity
Txt
In
No
2
p_trgt_periodicity
Txt
In
No
3
p_rate_def_name
Txt
In
No
1
PAYROLL_RELATIONSHIP_ID
p_out_periodicity
Txt
Out
No
2
EFFECTIVE_DATE
range_value
Num
In
No
3
base_value
Num
In
No
4
factor
Num
In
No
5
range_offset
Num
In
No
6
p_ovr_periodicity
Txt
In
No
7
p_ovr_mode
Txt
In
No
8
SET_TEXT
RAND
Num
RAND
Num
RAND_SEED
Num
RATE_CONVERTER
RATE_ENGINE
Num
Num
RATE_ENGINE_INIT
Num
RATE_ENGINE_PUT_VALUE
Num
STD_ANNUALIZED_RATE_CONVERTER
TAXABILITY_RULE_EXISTS
UNIT_CONVERTER
UPDATE_CONTEXT_ARRAY
Num
Yes p_name
Txt
In
No
1
p_value
Txt
In
No
2
p_datatype
Txt
In
No
3
p_src_amount
Num
In
No
1
p_src_periodicity
Txt
In
No
2
p_trgt_periodicity
Txt
In
No
3
ignore_class
Txt
In
No
1
use_base_ee
Txt
In
No
2
IN_UNIT
Txt
In
Yes
1
IN_UOM
Txt
In
Yes
2
IN_REPORTING_UOM
Txt
In
Yes
3
name
Txt
In
No
1
value
Txt
In
No
2
name
Txt
In
No
1
value
Dt
In
No
2
name
Txt
In
No
1
Txt
Num
Txt
UPDATE_PARAMETER_ARRAY
value
Num
In
No
2
name
Txt
In
No
1
value
Txt
In
No
2
Txt
name
Txt
In
No
1
Txt
value
Dt
In
No
2
Txt
name
Txt
In
No
1
Txt
value
Num
In
No
2
P_JUR_CODE
Txt
In
No
1
P_TAX_TYPE
Txt
In
No
2
P_MODE
Txt
In
No
3
P_125_REDNS
Num
Both
No
4
P_401_REDNS
Num
Both
No
5
P_403_REDNS
Num
Both
No
6
P_457_REDNS
Num
Both
No
7
P_DEP_CARE_REDNS
Num
Both
No
8
P_OTHER_PRETAX_REDNS
Num
Both
No
9
P_GROSS
Num
Both
No
10
P_SUBJ_NWHABLE
Num
Both
No
11
P_LOCATION
Txt
In
No
12
P_REDUCED_SUBJ
Num
Both
No
13
P_SUBJ
Num
Both
No
14
P_IMPUTED
Num
In
No
15
P_PRINT_MESSAGE_CODE
Txt
In
No
1
P_PRINT_MESSAGE
Txt
In
No
2
P_LEGISLATIVE_DATA_GROUP_ID
Num
In
No
1
P_EFFECTIVE_DATE
Dt
In
No
2
P_TAX_UNIT_ID
Num
In
No
3
P_PAYROLL_ACTION_ID
Num
In
No
4
P_TAX_REGION
Txt
In
No
5
P_STATE
Txt
In
No
6
P_COUNTY
Txt
In
No
7
P_CITY
Txt
In
No
8
P_SCHOOL_DISTRICT
Txt
In
No
9
P_TAX_CODE
Txt
In
No
10
P_COUNT_CODE
Txt
In
No
11
P_STATE_NAME
Txt
In
No
1
Txt
UPDATE_PARAMETER_ARRAY
UPDATE_PARAMETER_ARRAY
US_ADJUST_TAX_BALANCES
US_FORMULA_LOGGING
US_PR_EXT_TAX_CODE_COUNT
Txt
Txt
Num
US_STATE_ABBREVIATION
Txt
VALUE_CRITERIA_INIT
Num
VALUE_CRITERIA_PUT_VALUE
Num
VX_CALCULATE
VX_GET_FORM_VALUE
VX_INIT_EMPLOYEE
Yes p_name
Txt
In
No
1
p_value
Txt
In
No
2
p_datatype
Txt
In
No
3
l_taxid
Num
In
No
1
l_taxtype
Num
In
No
2
l_paramname
Txt
In
No
3
l_empid
Txt
In
No
1
l_paydate
Dt
In
No
2
l_payprds
Num
In
No
3
l_payprds_set
Num
In
No
4
l_rgeocode
Num
In
No
5
l_rgeocode_set
Num
In
No
6
l_curprd
Num
In
No
7
Txt
Txt
Txt
Yes
PAYROLL_ACTION_ID
VX_SET_DEDUCT_AMOUNT
VX_SET_FORM_VALUE
VX_SET_GROSS_AMOUNT
VX_SET_TAX_AMOUNT
VX_TRANSFER
VX_TRANSLATE
Txt
Txt
Txt
Txt
l_curprd_set
Num
In
No
8
l_futarate
Num
In
No
9
l_futarate_set
Num
In
No
10
l_suirate
Num
In
No
11
l_suirate_set
Num
In
No
12
l_sdirate
Num
In
No
13
l_sdirate_set
Num
In
No
14
l_taxid
Num
In
No
1
l_taxtype
Num
In
No
2
l_dedamtid
Num
In
No
3
l_amount
Num
In
No
4
l_amount_set
Num
In
No
5
l_cash_opt
Num
In
No
6
l_cash_opt_set
Num
In
No
7
l_amount_ytd
Num
In
No
8
l_amount_ytd_set
Num
In
No
9
l_taxid
Num
In
No
1
l_taxtype
Num
In
No
2
l_paramname
Txt
In
No
3
l_value
Txt
In
No
4
l_value_set
Num
In
No
5
l_taxid
Num
In
No
1
l_taxtype
Num
In
No
2
l_grsamtid
Num
In
No
3
l_amount
Num
In
No
4
l_amount_set
Num
In
No
5
l_taxid
Num
In
No
1
l_taxtype
Num
In
No
2
l_taxamtid
Num
In
No
3
l_amount
Num
In
No
4
l_amount_set
Num
In
No
5
ptype
Txt
In
No
1
from_val
Txt
In
No
2
found
Txt
In
No
3
context1
Txt
In
Yes
4
context2
Txt
In
Yes
5
context3
Txt
In
Yes
6
context4
Txt
In
Yes
7
context5
Txt
In
Yes
8
context6
Txt
In
Yes
9
Txt
Txt
