Define Function Window

[waqashassan26]

I am new in HRMS Functional but I have good technical knowledge. Somethings are confusing me:

<b>1. Define Function:</b>
a. Should parameter name on Define Function window and the PLSQL Function or Procedure parameter name must be same?

b. What is the purpose of context usages on Define Function window ? How we use it? We do not pass the context usages parameter
in function then how PLSQL understands its value?

<b>Answer:</b>

I have seen the GET_TABLE_VALUE function and I got the answer, please guide me.

Parameters Order:
1. In PL/SQL function, first we give context usages parameters, parameter names might be different but the order must be same.
2. In PL/SQL function, second we give the formula function parameters, parameter names might be different but the order must be same.

For Example:
function get_table_value (
-- context usages parameter
p_bus_group_id in number,
-- formula function parameters
p_table_name in varchar2,
p_col_name in varchar2,
p_row_value in varchar2,
p_effective_date in date default null
) return varchar2;

Is that true?