34: RETURN NUMBER;
35: -- pragma restrict_references(GET_BALANCE_VALUE_ASG_RUN,WNDS,WNPS);
36: --
37: FUNCTION GET_RESULT_VALUE_PAY_VALUE(
38: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
39: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
40: RETURN NUMBER;
41: -- pragma restrict_references(GET_RESULT_VALUE_PAY_VALUE,WNDS,WNPS);
42: --
47: RETURN NUMBER;
48: -- pragma restrict_references(GET_RESULT_VALUE_PAY_VALUE,WNDS,WNPS);
49: --
50: FUNCTION GET_RESULT_VALUE_CHAR(
51: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
52: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
53: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
54: RETURN VARCHAR2;
55: -- pragma restrict_references(GET_RESULT_VALUE_CHAR,WNDS,WNPS);
62: RETURN VARCHAR2;
63: -- pragma restrict_references(GET_RESULT_VALUE_CHAR,WNDS,WNPS);
64: --
65: FUNCTION GET_RESULT_VALUE_NUMBER(
66: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
67: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
68: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
69: RETURN NUMBER;
70: -- pragma restrict_references(GET_RESULT_VALUE_NUMBER,WNDS,WNPS);
77: RETURN NUMBER;
78: -- pragma restrict_references(GET_RESULT_VALUE_NUMBER,WNDS,WNPS);
79: --
80: FUNCTION GET_RESULT_VALUE_DATE(
81: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
82: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
83: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
84: RETURN DATE;
85: -- pragma restrict_references(GET_RESULT_VALUE_DATE,WNDS,WNPS);
92: RETURN DATE;
93: -- pragma restrict_references(GET_RESULT_VALUE_DATE,WNDS,WNPS);
94: --
95: FUNCTION GET_ENTRY_VALUE_CHAR(
96: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
97: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
98: P_ASSIGNMENT_ID IN PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,
99: P_EFFECTIVE_DATE IN DATE)
100: RETURN VARCHAR2;
107: RETURN VARCHAR2;
108: -- pragma restrict_references(GET_ENTRY_VALUE_CHAR,WNDS,WNPS);
109: --
110: FUNCTION GET_ENTRY_VALUE_NUMBER(
111: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
112: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
113: P_ASSIGNMENT_ID IN PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,
114: P_EFFECTIVE_DATE IN DATE)
115: RETURN NUMBER;
122: RETURN NUMBER;
123: -- pragma restrict_references(GET_ENTRY_VALUE_NUMBER,WNDS,WNPS);
124: --
125: FUNCTION GET_ENTRY_VALUE_DATE(
126: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
127: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
128: P_ASSIGNMENT_ID IN PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,
129: P_EFFECTIVE_DATE IN DATE)
130: RETURN DATE;
137: RETURN DATE;
138: -- pragma restrict_references(GET_ENTRY_VALUE_DATE,WNDS,WNPS);
139: --
140: FUNCTION GET_ELEMENT_TYPE_ID(
141: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
142: P_BUSINESS_GROUP_ID IN NUMBER,
143: P_LEGISLATION_CODE IN PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE)
144: RETURN NUMBER;
145: -- pragma restrict_references(GET_ELEMENT_TYPE_ID,WNDS,WNPS);
144: RETURN NUMBER;
145: -- pragma restrict_references(GET_ELEMENT_TYPE_ID,WNDS,WNPS);
146: --
147: PROCEDURE get_element_input_id(
148: p_element_name IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
149: p_input_value_name IN PAY_INPUT_VALUES_F.NAME%TYPE,
150: p_business_group_id IN PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE,
151: p_element_type_id IN OUT NOCOPY NUMBER,
152: p_input_value_id IN OUT NOCOPY NUMBER);
158: RETURN NUMBER;
159: -- pragma restrict_references(GET_INPUT_VALUE_ID,WNDS,WNPS);
160: --
161: FUNCTION GET_INPUT_VALUE_ID(
162: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
163: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
164: P_BUSINESS_GROUP_ID IN NUMBER,
165: P_LEGISLATION_CODE IN PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE)
166: RETURN NUMBER;
166: RETURN NUMBER;
167: -- pragma restrict_references(GET_INPUT_VALUE_ID,WNDS,WNPS);
168: --
169: FUNCTION get_loc_uni_seq_input_value_id(
170: p_element_name in pay_element_types_f.element_name%type,
171: p_input_value_disp_seq in pay_input_values_f.display_sequence%type,
172: p_business_group_id in number,
173: p_legislation_code in per_business_groups.legislation_code%type)
174: RETURN number;