Round
Syntax
Round(dec, precision)
Description
Use the Round function to round a decimal number to a specified precision.
Parameters
|
Field or Control |
Definition |
|---|---|
| dec |
A Number value to be rounded. |
| precision |
A number value specifying the decimal precision to which to round dec . |
Returns
Returns a Number value equal to ...
RoundCurrency
Syntax
RoundCurrency(amt, currency_cd, effdt)
Description
Different currencies are represented at different decimal precessions. The RoundCurrency function is a rounding function that takes currency precision into account, using a value stored in the CURRENCY_CD_TBL PeopleTools table.
Parameters
|
Field or Control |
Definition |
|---|---|
| amt |
The amount to be rounded. |
| currency_cd |
The currency ... |
RowFlush
Syntax
RowFlush(scrollpath, target_row)
Where scrollpath is:
[RECORD.level1_recname, level1_row, [RECORD.level2_recname, level2_row, ] RECORD.target_recname
To prevent ambiguous references, you can use SCROLL. scrollname , where scrollname is the same as the scroll levelâs primary record name.
Description
Use the RowFlush function to remove a specific row from a ...
RowScrollSelect
Syntax
RowScrollSelect(levelnum, scrollpath, Record.sel_recname [, sqlstr [, bindvars]] [, turbo])
Where scrollpath is:
[RECORD.level1_recname, level1_row, [Record.level2_recname, level2_row, ] Record.target_recname
and where bindvars is an arbitrary-length list of bind variables in the form:
bindvar1 [, bindvar2]. . .
To prevent ambiguous references, you can use Scroll. scrollname , where scrollname is the same as ...
RowScrollSelectNew
Syntax
RowScrollSelectNew(levelnum, scrollpath, RECORD.sel_recname, [sqlstr [, bindvars]] [, turbo])
Where scrollpath is:
[Record.level1_recname, level1_row, [Record.level2_recname, level2_row, ] Record.target_recname
where bindvars is an arbitrary-length list of bind variables in the form:
binvar1 [, bindvar2]. . .
To prevent ambiguous references, you can use Scroll. scrollname , where scrollname is the same as the ...
RTrim
Syntax
RTrim(string[, trim_string])
Description
Use the RTrim function to remove characters, usually trailing blanks, from the right of a string.
If you need to trim
a quotation mark, you need to escape it with a single
"
. For example
&TRIMMED = RTrim(&NAME, """");Parameters
|
Field or Control |
Definition |
|---|---|
| string |
A String ... |
ScheduleProcess
Syntax
ScheduleProcess(process_type, process_name [, run_location] [, run_cntl_id] [, process_instance] [, run_dttm] [, recurrence_name] [, server_name])
Description
Use the ScheduleProcess function to schedule a process or job, writing a row of data to the Process Request table (PSPRCSRQST).
Note: This function is no longer supported. Use the CreateProcessRequest function instead.
ScrollFlush
Syntax
ScrollFlush(scrollpath)
Where scrollpath is:
[RECORD.level1_recname, level1_row, [RECORD.level2_recname, level2_row, ]RECORD.target_recname
To prevent ambiguous references, you can use SCROLL. scrollname, where scrollname is the same as the scroll levelâs primary record name.
Description
Use the ScrollFlush function to remove all rows inside the target scroll area ...
ScrollSelect
Syntax
ScrollSelect(levelnum, [Record.level1_recname, [Record.level2_recname,]] Record.target_recname, Record.sel_recname [, sqlstr [, bindvars]] [, turbo])
where bindvars is an arbitrary-length list of bind variables in the form:
bindvar1 [, bindvar2]. . .
Description
The ScrollSelect function, like the related ScrollSelect functions (ScrollSelectNew, RowScrollSelect, and RowScrollSelectNew) reads data from database tables or views into a ...
ScrollSelectNew
Syntax
ScrollSelectNew(levelnum, [Record.level1_recname, [Record.level2_recname, ]] Record.target_recname, Record.sel_recname [, sqlstr [, bindvars]] [, turbo])
and where bindvars is an arbitrary-length list of bind variables in the form:
bindvar1 [, bindvar2]. . .
Description
The ScrollSelectNew function is similar to ScrollSelect, except that all rows read into the work scroll are marked new so ...