Below is a Sample Formula shows How to Call a Value set in Fast Formula :
Inputs are hr_id (number),
eff_st_date(text),
eff_end_date(text),
mode (text)
l_hr_per_id = hr_id
l_eff_st_date = eff_st_date
l_eff_end_date = eff_end_date
X_OUTPUT = '0001/01/01 00:00:00' (DATE)
X_OUTPUT_NUMBER = 0
X_OUTPUT_TEXT = ' '
IF mode = 'GROSS' THEN
(
X_OUTPUT_TEXT = GET_VALUE_SET ( 'AH_GET_GROSS_YTD_VALUE' , '|=L_PERSON_ID='''|| TO_CHAR(l_hr_per_id)||''''||'|L_CMP_START_DATE='''|| l_eff_st_date ||''''||'|L_CMP_END_DATE='''|| l_eff_end_date ||'''')
)
ELSE
(
X_OUTPUT_TEXT = '0'
)
RETURN X_OUTPUT_TEXT
Inputs are hr_id (number),
eff_st_date(text),
eff_end_date(text),
mode (text)
l_hr_per_id = hr_id
l_eff_st_date = eff_st_date
l_eff_end_date = eff_end_date
X_OUTPUT = '0001/01/01 00:00:00' (DATE)
X_OUTPUT_NUMBER = 0
X_OUTPUT_TEXT = ' '
IF mode = 'GROSS' THEN
(
X_OUTPUT_TEXT = GET_VALUE_SET ( 'AH_GET_GROSS_YTD_VALUE' , '|=L_PERSON_ID='''|| TO_CHAR(l_hr_per_id)||''''||'|L_CMP_START_DATE='''|| l_eff_st_date ||''''||'|L_CMP_END_DATE='''|| l_eff_end_date ||'''')
)
ELSE
(
X_OUTPUT_TEXT = '0'
)
RETURN X_OUTPUT_TEXT
No comments:
Post a Comment