eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FI_BAL_UPLOAD dependencies on HR_UTILITY

Line 99: hr_utility.trace('Entering pay_ip_bal_upload.expiry_date');

95: --l_oe_start_date date;
96: l_holiday_year date;
97: BEGIN
98:
99: hr_utility.trace('Entering pay_ip_bal_upload.expiry_date');
100:
101: --
102: -- Get the ITD start date.
103: --

Line 110: hr_utility.trace('Asg Start Date='||l_itd_start_date);

106: ,p_upload_date => p_upload_date
107: ,p_itd_start_date => l_itd_start_date
108: );
109: --
110: hr_utility.trace('Asg Start Date='||l_itd_start_date);
111:
112: IF p_dimension_name IN ('ASSIGNMENT HOLIDAY PERIOD TO DATE') THEN
113:
114: open csr_start_of_date(p_assignment_id, p_upload_date);

Line 117: hr_utility.trace('Period Start Date=' || l_expiry_date);

113:
114: open csr_start_of_date(p_assignment_id, p_upload_date);
115: fetch csr_start_of_date into l_expiry_date;
116: close csr_start_of_date;
117: hr_utility.trace('Period Start Date=' || l_expiry_date);
118:
119: ELSIF p_dimension_name IN ('ASSIGNMENT EMPLOYMENT TYPE LEGAL EMPLOYER INCEPTION TO DATE') THEN
120: l_expiry_date := l_itd_start_date;
121: hr_utility.trace('Asg Start Date=' || l_expiry_date);

Line 121: hr_utility.trace('Asg Start Date=' || l_expiry_date);

117: hr_utility.trace('Period Start Date=' || l_expiry_date);
118:
119: ELSIF p_dimension_name IN ('ASSIGNMENT EMPLOYMENT TYPE LEGAL EMPLOYER INCEPTION TO DATE') THEN
120: l_expiry_date := l_itd_start_date;
121: hr_utility.trace('Asg Start Date=' || l_expiry_date);
122:
123: ELSIF p_dimension_name IN ('ASSIGNMENT HOLIDAY MONTH TO DATE') THEN
124: l_expiry_date := TRUNC(p_upload_date,'MM');
125: hr_utility.trace('Mth Start Date=' || l_expiry_date);

Line 125: hr_utility.trace('Mth Start Date=' || l_expiry_date);

121: hr_utility.trace('Asg Start Date=' || l_expiry_date);
122:
123: ELSIF p_dimension_name IN ('ASSIGNMENT HOLIDAY MONTH TO DATE') THEN
124: l_expiry_date := TRUNC(p_upload_date,'MM');
125: hr_utility.trace('Mth Start Date=' || l_expiry_date);
126:
127: ELSIF p_dimension_name IN ('ASSIGNMENT EMPLOYMENT TYPE LEGAL EMPLOYER YEAR TO DATE') THEN
128: l_expiry_date := TRUNC(p_upload_date,'Y');
129: hr_utility.trace('Year Start Date=' || l_expiry_date);

Line 129: hr_utility.trace('Year Start Date=' || l_expiry_date);

125: hr_utility.trace('Mth Start Date=' || l_expiry_date);
126:
127: ELSIF p_dimension_name IN ('ASSIGNMENT EMPLOYMENT TYPE LEGAL EMPLOYER YEAR TO DATE') THEN
128: l_expiry_date := TRUNC(p_upload_date,'Y');
129: hr_utility.trace('Year Start Date=' || l_expiry_date);
130:
131: ELSIF p_dimension_name IN ('ASSIGNMENT HOLIDAY YEAR TO DATE') THEN
132:
133: SELECT TO_DATE('0104'||TO_CHAR(p_upload_date,'YYYY'),'DD/MM/YYYY')

Line 143: hr_utility.trace('HY Start Date=' || l_expiry_date);

139: ELSE
140: l_expiry_date := ADD_MONTHS(l_holiday_year , -12);
141: END IF;
142:
143: hr_utility.trace('HY Start Date=' || l_expiry_date);
144:
145: ELSE
146: --
147: -- Dimension not supported.

Line 150: hr_utility.trace('Dimension Not Supported. ' || p_dimension_name);

146: --
147: -- Dimension not supported.
148: --
149: l_expiry_date := END_OF_TIME;
150: hr_utility.trace('Dimension Not Supported. ' || p_dimension_name);
151:
152: END IF;
153:
154: l_expiry_date := nvl(greatest(l_itd_start_date

Line 159: hr_utility.trace('Expiry date is later than upload_date! expiry_date='||l_expiry_date);

155: ,l_expiry_date
156: ), END_OF_TIME);
157:
158: if (l_expiry_date <> END_OF_TIME) and (l_expiry_date > p_upload_date) then
159: hr_utility.trace('Expiry date is later than upload_date! expiry_date='||l_expiry_date);
160: --
161: l_expiry_date := END_OF_TIME;
162: end if;
163:

Line 164: hr_utility.trace('Exiting pay_ip_bal_upload.expiry_date');

160: --
161: l_expiry_date := END_OF_TIME;
162: end if;
163:
164: hr_utility.trace('Exiting pay_ip_bal_upload.expiry_date');
165:
166: RETURN l_expiry_date;
167:
168: END expiry_date;

Line 197: hr_utility.trace('Exiting pay_fi_bal_upload.is_supported stub');

193: RETURN 1;
194: ELSE
195: RETURN 0;
196: END IF;
197: hr_utility.trace('Exiting pay_fi_bal_upload.is_supported stub');
198: END is_supported;
199: -----------------------------------------------------------------------------
200: -- NAME
201: -- include_adjustment

Line 242: hr_utility.trace('Entering pay_fi_bal_upload.include_adjustment stub');

238: l_include_adj BOOLEAN := TRUE ;
239: v_cur_bal_adj_st1 csr_bal_adj_st1%ROWTYPE;
240:
241: BEGIN
242: hr_utility.trace('Entering pay_fi_bal_upload.include_adjustment stub');
243:
244: IF p_dimension_name IN ('ASSIGNMENT HOLIDAY PERIOD TO DATE',
245: 'ASSIGNMENT HOLIDAY MONTH TO DATE',
246: 'ASSIGNMENT HOLIDAY YEAR TO DATE') THEN

Line 269: hr_utility.trace('Exiting pay_fi_bal_upload.include_adjustment');

265: NULL;
266:
267: END IF;
268:
269: hr_utility.trace('Exiting pay_fi_bal_upload.include_adjustment');
270:
271: if l_include_adj then
272: RETURN 1;
273: else

Line 292: hr_utility.trace('Entering pay_fi_bal_upload.validate_batch_lines stub');

288: -----------------------------------------------------------------------------
289: --
290: PROCEDURE validate_batch_lines(p_batch_id NUMBER) IS
291: BEGIN
292: hr_utility.trace('Entering pay_fi_bal_upload.validate_batch_lines stub');
293: hr_utility.trace('Exiting pay_fi_bal_upload.validate_batch_lines stub' );
294: END validate_batch_lines;
295:
296: END pay_fi_bal_upload;

Line 293: hr_utility.trace('Exiting pay_fi_bal_upload.validate_batch_lines stub' );

289: --
290: PROCEDURE validate_batch_lines(p_batch_id NUMBER) IS
291: BEGIN
292: hr_utility.trace('Entering pay_fi_bal_upload.validate_batch_lines stub');
293: hr_utility.trace('Exiting pay_fi_bal_upload.validate_batch_lines stub' );
294: END validate_batch_lines;
295:
296: END pay_fi_bal_upload;