APPS.PAY_MX_UTILITY dependencies on PAY_PAYROLL_ACTIONS

Line 983: ** legislation_parameters column of pay_payroll_actions

979: /**********************************************************************
980: ** Type : Function
981: ** Name : get_parameter
982: ** Purpose : This function gets Paramter Value from
983: ** legislation_parameters column of pay_payroll_actions
984: ** WHENEVER TWO PARAMETERS ARE SEPARATED BY A SPACE
985: **
986: ** WARNING : IF THERE IS A PIPE (OTHER THAN A SPACE)IN THE VALUE
987: ** THEN DONOT USE THIS FUNCTION

Line 996: par_value pay_payroll_actions.legislative_parameters%type;

992: FUNCTION get_parameter(name IN VARCHAR2,
993: parameter_list IN VARCHAR2)
994: RETURN VARCHAR2 IS
995:
996: par_value pay_payroll_actions.legislative_parameters%type;
997:
998: BEGIN
999:
1000: par_value := get_legi_param_val(name

Line 1013: ** legislation_parameters column of pay_payroll_actions

1009: /**********************************************************************
1010: ** Type : Function
1011: ** Name : get_legi_param_val
1012: ** Purpose : This function gets Paramter Value from
1013: ** legislation_parameters column of pay_payroll_actions
1014: ** WHENEVER TWO PARAMETERS ARE SEPARATED BY A PIPE (|)
1015: **
1016: ** WARNING : IF THERE IS A SPACE IN THE VALUE
1017: ** THEN DONOT USE THIS FUNCTION

Line 1026: par_value pay_payroll_actions.legislative_parameters%type;

1022: FUNCTION get_legi_param_val(name IN VARCHAR2,
1023: parameter_list IN VARCHAR2)
1024: RETURN VARCHAR2 IS
1025:
1026: par_value pay_payroll_actions.legislative_parameters%type;
1027:
1028: BEGIN
1029:
1030: par_value := get_legi_param_val(name

Line 1042: ** from legislation_parameters column of pay_payroll_actions

1038: /*************************************************************************
1039: ** Type : Function
1040: ** Name : get_legi_param_val
1041: ** Purpose : This is an overloaded function that gets paramter Value
1042: ** from legislation_parameters column of pay_payroll_actions
1043: ** WHENEVER TWO PARAMETERS ARE SEPARATED BY EITHER A PIPE (|)
1044: ** OR A SPACE.
1045: **
1046: ** Arguments :

Line 1056: token_val pay_payroll_actions.legislative_parameters%type;

1052: RETURN VARCHAR2 IS
1053:
1054: start_ptr number;
1055: end_ptr number;
1056: token_val pay_payroll_actions.legislative_parameters%type;
1057: par_value pay_payroll_actions.legislative_parameters%type;
1058:
1059: BEGIN
1060:

Line 1057: par_value pay_payroll_actions.legislative_parameters%type;

1053:
1054: start_ptr number;
1055: end_ptr number;
1056: token_val pay_payroll_actions.legislative_parameters%type;
1057: par_value pay_payroll_actions.legislative_parameters%type;
1058:
1059: BEGIN
1060:
1061: token_val := name||'=';

Line 1097: l_legislation_parameters pay_payroll_actions.legislative_parameters%type;

1093: p_parameter_name IN VARCHAR2)
1094: RETURN VARCHAR2 IS
1095:
1096:
1097: l_legislation_parameters pay_payroll_actions.legislative_parameters%type;
1098: par_value pay_payroll_actions.legislative_parameters%type;
1099:
1100: CURSOR c_get_parameter_value IS
1101: SELECT legislative_parameters

Line 1098: par_value pay_payroll_actions.legislative_parameters%type;

1094: RETURN VARCHAR2 IS
1095:
1096:
1097: l_legislation_parameters pay_payroll_actions.legislative_parameters%type;
1098: par_value pay_payroll_actions.legislative_parameters%type;
1099:
1100: CURSOR c_get_parameter_value IS
1101: SELECT legislative_parameters
1102: FROM pay_payroll_actions

Line 1102: FROM pay_payroll_actions

1098: par_value pay_payroll_actions.legislative_parameters%type;
1099:
1100: CURSOR c_get_parameter_value IS
1101: SELECT legislative_parameters
1102: FROM pay_payroll_actions
1103: WHERE payroll_action_id = p_cntx_payroll_action_id;
1104:
1105: BEGIN
1106: