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_IE_P35_MAGTAPE dependencies on PAY_IE_P35

Line 1: PACKAGE BODY pay_ie_p35_magtape AS

1: PACKAGE BODY pay_ie_p35_magtape AS
2: /* $Header: pyiep35m.pkb 120.10.12010000.1 2008/07/27 22:50:06 appldev ship $ */
3: --
4: -- Constants
5: --

Line 6: l_package CONSTANT VARCHAR2 (31) := 'pay_ie_p35_magtape.';

2: /* $Header: pyiep35m.pkb 120.10.12010000.1 2008/07/27 22:50:06 appldev ship $ */
3: --
4: -- Constants
5: --
6: l_package CONSTANT VARCHAR2 (31) := 'pay_ie_p35_magtape.';
7: --------------------------------------------------------------------------------+
8:
9: FUNCTION get_parameter (
10: p_payroll_action_id IN NUMBER,

Line 78: pay_ie_p35.get_parameter (

74: FROM pay_payroll_actions ppa
75: WHERE ppa.report_type = 'IEP35'
76: AND ppa.action_status = 'C'
77: AND TO_DATE (
78: pay_ie_p35.get_parameter (
79: ppa.payroll_action_id,
80: 'END_DATE'
81: ),
82: 'YYYY/MM/DD'

Line 89: pay_ie_p35.get_parameter (

85:
86: BEGIN
87: --hr_utility.trace_on(null,'MAGTRC');
88: l_out_var :=
89: pay_ie_p35.get_parameter (
90: p_payroll_action_id=> p_payroll_action_id,
91: p_token_name=> 'END_DATE'
92: );
93: l_end_date := TO_DATE (l_out_var, 'YYYY/MM/DD');

Line 95: pay_ie_p35.get_parameter (

91: p_token_name=> 'END_DATE'
92: );
93: l_end_date := TO_DATE (l_out_var, 'YYYY/MM/DD');
94: l_out_var :=
95: pay_ie_p35.get_parameter (
96: p_payroll_action_id=> p_payroll_action_id,
97: p_token_name=> 'START_DATE'
98: );
99: l_start_date := TO_DATE (l_out_var, 'YYYY/MM/DD');

Line 101: pay_ie_p35.get_parameter (

97: p_token_name=> 'START_DATE'
98: );
99: l_start_date := TO_DATE (l_out_var, 'YYYY/MM/DD');
100: l_out_var :=
101: pay_ie_p35.get_parameter (
102: p_payroll_action_id=> p_payroll_action_id,
103: p_token_name=> 'BG_ID'
104: );
105: l_bg_id := TO_NUMBER (l_out_var);

Line 211: pay_ie_p35.get_parameter (

207: AND paaf.person_id BETWEEN stperson AND endperson
208: AND paaf.effective_start_date <= l_end_date
209: AND paaf.effective_end_date >= l_start_date
210: AND TO_DATE (
211: pay_ie_p35.get_parameter (
212: ppa.payroll_action_id,
213: 'END_DATE'
214: ),
215: 'YYYY/MM/DD'

Line 226: --AND PAY_IE_P35.check_assignment_in_set(paa.assignment_id,l_assignment_set_id,l_bg_id)=1;

222: and a.effective_start_date<= l_end_date
223: and a.effective_end_date>= l_start_date)
224: OR l_payroll_id IS NULL)
225: --AND (ppf.payroll_id =l_payroll_id or l_payroll_id is null)
226: --AND PAY_IE_P35.check_assignment_in_set(paa.assignment_id,l_assignment_set_id,l_bg_id)=1;
227: AND ((l_assignment_set_id IS NOT NULL
228: AND (l_set_flag ='I' AND EXISTS(SELECT 1
229: FROM hr_assignment_set_amendments hasa
230: , hr_assignment_sets has

Line 269: pay_ie_p35.get_parameter (

265: pay_action_interlocks plock
266: WHERE ppa_p35.report_type = 'IEP35MAG'
267: AND paa_p35.action_status = 'C'
268: AND TO_DATE (
269: pay_ie_p35.get_parameter (
270: ppa_p35.payroll_action_id,
271: 'END_DATE'
272: ),
273: 'YYYY/MM/DD'

Line 297: -- l_end_date := pay_ie_p35.get_end_date;

293: hr_utility.set_location ('endperson passed to action creation::'||endperson,930);
294: hr_utility.set_location ('CHUNK passed to action creation::'||CHUNK ,940);
295: hr_utility.set_location (l_proc_name, 10);
296:
297: -- l_end_date := pay_ie_p35.get_end_date;
298:
299:
300: l_out_var :=
301: pay_ie_p35.get_parameter (

Line 301: pay_ie_p35.get_parameter (

297: -- l_end_date := pay_ie_p35.get_end_date;
298:
299:
300: l_out_var :=
301: pay_ie_p35.get_parameter (
302: p_payroll_action_id=> pactid,
303: p_token_name=> 'END_DATE'
304: );
305: l_end_date := TO_DATE (l_out_var, 'YYYY/MM/DD'); --4641756

Line 307: l_start_date := pay_ie_p35.get_start_date;

303: p_token_name=> 'END_DATE'
304: );
305: l_end_date := TO_DATE (l_out_var, 'YYYY/MM/DD'); --4641756
306:
307: l_start_date := pay_ie_p35.get_start_date;
308:
309: l_out_var := pay_ie_p35.get_parameter (
310: p_payroll_action_id=> pactid,
311: p_token_name=> 'BG_ID'

Line 309: l_out_var := pay_ie_p35.get_parameter (

305: l_end_date := TO_DATE (l_out_var, 'YYYY/MM/DD'); --4641756
306:
307: l_start_date := pay_ie_p35.get_start_date;
308:
309: l_out_var := pay_ie_p35.get_parameter (
310: p_payroll_action_id=> pactid,
311: p_token_name=> 'BG_ID'
312: );
313:

Line 325: l_segment4 := pay_ie_p35.get_parameter( p_payroll_action_id=> pactid,

321: || TO_CHAR (l_bg_id), 13);
322:
323:
324: --
325: l_segment4 := pay_ie_p35.get_parameter( p_payroll_action_id=> pactid,
326: p_token_name=> 'EMP_NO');
327: l_out_var := pay_ie_p35.get_parameter (
328: p_payroll_action_id=> pactid,
329: p_token_name=> 'ASSIGNMENT_SET_ID'

Line 327: l_out_var := pay_ie_p35.get_parameter (

323:
324: --
325: l_segment4 := pay_ie_p35.get_parameter( p_payroll_action_id=> pactid,
326: p_token_name=> 'EMP_NO');
327: l_out_var := pay_ie_p35.get_parameter (
328: p_payroll_action_id=> pactid,
329: p_token_name=> 'ASSIGNMENT_SET_ID'
330: );
331: l_assignment_set_id := to_number(l_out_var);

Line 333: l_out_var := pay_ie_p35.get_parameter (

329: p_token_name=> 'ASSIGNMENT_SET_ID'
330: );
331: l_assignment_set_id := to_number(l_out_var);
332: --bug 6642916
333: l_out_var := pay_ie_p35.get_parameter (
334: p_payroll_action_id=> pactid,
335: p_token_name=> 'PAYROLL'
336: );
337: l_payroll_id := to_number(l_out_var);

Line 394: AND fpo.profile_option_name = 'PAY_IE_P35_REPORTING_YEAR'

390: INTO l_start_date
391: FROM fnd_profile_option_values fpov, fnd_profile_options fpo
392: WHERE fpo.profile_option_id = fpov.profile_option_id
393: AND fpo.application_id = fpov.application_id
394: AND fpo.profile_option_name = 'PAY_IE_P35_REPORTING_YEAR'
395: AND fpov.level_id = 10001
396: AND fpov.level_value = 0;
397:
398: RETURN l_start_date;

Line 416: AND fpo.profile_option_name = 'PAY_IE_P35_REPORTING_YEAR'

412: INTO l_end_date
413: FROM fnd_profile_option_values fpov, fnd_profile_options fpo
414: WHERE fpo.profile_option_id = fpov.profile_option_id
415: AND fpo.application_id = fpov.application_id
416: AND fpo.profile_option_name = 'PAY_IE_P35_REPORTING_YEAR'
417: AND fpov.level_id = 10001
418: AND fpov.level_value = 0;
419:
420: RETURN l_end_date;

Line 518: END pay_ie_p35_magtape;

514:
515: RETURN l_string;
516: END ;
517:
518: END pay_ie_p35_magtape;