[Home] [Help]
68: -- the calculations also takes into account when the assignment is on a
69: -- payroll to ensure that a balance adjustment could be made at that point
70: -- if it were required.
71:
72: hr_utility.trace('Entering pay_no_bal_upload.expiry_date');
73:
74: IF p_dimension_name IN ('ASSIGNMENT ELEMENT CODE PERIOD TO DATE')
75: THEN
76:
120: END IF;
121:
122: RETURN l_expiry_date;
123:
124: hr_utility.trace('Leaving pay_no_bal_upload.expiry_date ');
125:
126: EXCEPTION
127: WHEN no_data_found THEN
128: l_expiry_date := END_OF_TIME;
151: (p_dimension_name varchar2)
152: RETURN number IS
153:
154: BEGIN
155: hr_utility.trace('Entering pay_no_bal_upload.is_supported');
156:
157: IF p_dimension_name in ('ASSIGNMENT ELEMENT CODE PERIOD TO DATE'
158: ,'ASSIGNMENT ELEMENT CODE YEAR TO DATE'
159: ,'ASSIGNMENT BI-MONTHLY TO DATE') THEN
160: RETURN 1;
161: ELSE
162: RETURN 0;
163: END IF;
164: hr_utility.trace('Leaving pay_no_bal_upload.is_supported ');
165: END is_supported;
166:
167: --------------------------------------------------------------------------
168: -- Name : INCLUDE_ADJUSTMENT
213: l_include_adj Number := 1 ; -- True
214: v_cur_bal_adj_st1 csr_bal_adj%ROWTYPE;
215:
216: BEGIN
217: hr_utility.trace(' Entering pay_no_bal_upload.include_adjustment ');
218:
219: -- When not to allow adjustment
220: -- Suppose,we want _ASG_ELE_CODE_PTD (Source_text 'test1' and balance value 7000)
221: -- _ASG_ELE_CODE_PTD (Source_text 'test2' and balance value 4000)
246: ELSE
247: NULL;
248: END IF;
249:
250: hr_utility.trace(' Leaving pay_no_bal_upload.include_adjustment' );
251: RETURN l_include_adj;
252:
253: END include_adjustment;
254: