APPS.PAY_NO_BAL_UPLOAD dependencies on PAY_NO_BAL_UPLOAD

Line 1: PACKAGE BODY PAY_NO_BAL_UPLOAD AS

1: PACKAGE BODY PAY_NO_BAL_UPLOAD AS
2: /* $Header: pynobalupl.pkb 120.0.12000000.1 2007/05/22 06:14:46 rajesrin noship $ */
3:
4: -- Date Constants
5: START_OF_TIME constant date := to_date('01/01/0001','DD/MM/YYYY');

Line 72: hr_utility.trace('Entering pay_no_bal_upload.expiry_date');

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:

Line 124: hr_utility.trace('Leaving pay_no_bal_upload.expiry_date ');

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;

Line 155: hr_utility.trace('Entering pay_no_bal_upload.is_supported');

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

Line 164: hr_utility.trace('Leaving pay_no_bal_upload.is_supported ');

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

Line 217: hr_utility.trace(' Entering pay_no_bal_upload.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)

Line 250: hr_utility.trace(' Leaving pay_no_bal_upload.include_adjustment' );

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:

Line 260: END PAY_NO_BAL_UPLOAD;

256: BEGIN
257: null;
258: END;
259:
260: END PAY_NO_BAL_UPLOAD;