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_DK_PR_LE dependencies on PAY_DK_PR_LE

Line 1: PACKAGE BODY PAY_DK_PR_LE AS

1: PACKAGE BODY PAY_DK_PR_LE AS
2: /* $Header: pydkprle.pkb 120.13 2012/01/19 09:07:59 rpahune ship $ */
3:
4:
5: g_debug boolean := hr_utility.debug_enabled;

Line 79: fnd_date.canonical_to_date(PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'FROM_DATE'))

75:
76:
77: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
78: SELECT
79: fnd_date.canonical_to_date(PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
80: ,fnd_date.canonical_to_date(PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'TO_DATE'))
81: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
82: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
83: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'ELEMENT_SET_ID')

Line 80: ,fnd_date.canonical_to_date(PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'TO_DATE'))

76:
77: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
78: SELECT
79: fnd_date.canonical_to_date(PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
80: ,fnd_date.canonical_to_date(PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'TO_DATE'))
81: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
82: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
83: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'ELEMENT_SET_ID')
84: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'ARCHIVE')

Line 81: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')

77: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
78: SELECT
79: fnd_date.canonical_to_date(PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
80: ,fnd_date.canonical_to_date(PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'TO_DATE'))
81: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
82: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
83: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'ELEMENT_SET_ID')
84: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'ARCHIVE')
85: ,effective_date

Line 82: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')

78: SELECT
79: fnd_date.canonical_to_date(PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
80: ,fnd_date.canonical_to_date(PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'TO_DATE'))
81: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
82: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
83: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'ELEMENT_SET_ID')
84: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'ARCHIVE')
85: ,effective_date
86: ,business_group_id

Line 83: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'ELEMENT_SET_ID')

79: fnd_date.canonical_to_date(PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
80: ,fnd_date.canonical_to_date(PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'TO_DATE'))
81: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
82: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
83: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'ELEMENT_SET_ID')
84: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'ARCHIVE')
85: ,effective_date
86: ,business_group_id
87: FROM pay_payroll_actions

Line 84: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'ARCHIVE')

80: ,fnd_date.canonical_to_date(PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'TO_DATE'))
81: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
82: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
83: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'ELEMENT_SET_ID')
84: ,PAY_DK_PR_LE.GET_PARAMETER(legislative_parameters,'ARCHIVE')
85: ,effective_date
86: ,business_group_id
87: FROM pay_payroll_actions
88: WHERE payroll_action_id = p_payroll_action_id;

Line 203: SUM (pay_balance_pkg.get_value(pay_dk_pr_le.get_defined_balance_id

199: ,p_from_date DATE
200: ,p_to_date DATE)
201: IS
202: SELECT
203: SUM (pay_balance_pkg.get_value(pay_dk_pr_le.get_defined_balance_id
204: (pivf.input_value_id,'_ASG_RUN')
205: ,paa1.assignment_action_id)) ele_ytd
206: FROM
207: per_all_assignments_f paaf

Line 285: ,pay_dk_pr_le.costed_code(prr.run_result_id,pivf.input_value_id) costed_code

281: ,ppf.payroll_id payroll_id
282: ,petf.element_type_id ele_type_id
283: ,petf.processing_priority ele_proc_prior
284: ,NVL(petf.reporting_name,petf.element_name) ele_name
285: ,pay_dk_pr_le.costed_code(prr.run_result_id,pivf.input_value_id) costed_code
286: ,pivf.input_value_id input_value_id
287: ,to_char(ppa1.date_earned,'DD-MON-RRRR') date_earned
288: ,pay_balance_pkg.get_value(pay_dk_pr_le.get_defined_balance_id
289: (pivf.input_value_id,'_ASG_RUN')

Line 288: ,pay_balance_pkg.get_value(pay_dk_pr_le.get_defined_balance_id

284: ,NVL(petf.reporting_name,petf.element_name) ele_name
285: ,pay_dk_pr_le.costed_code(prr.run_result_id,pivf.input_value_id) costed_code
286: ,pivf.input_value_id input_value_id
287: ,to_char(ppa1.date_earned,'DD-MON-RRRR') date_earned
288: ,pay_balance_pkg.get_value(pay_dk_pr_le.get_defined_balance_id
289: (pivf.input_value_id,'_ASG_RUN')
290: ,paa1.assignment_action_id) pay_value
291: /* ,pay_balance_pkg.get_value(pay_dk_pr_le.get_defined_balance_id
292: (pivf.input_value_id,'_ASG_YTD'),

Line 291: /* ,pay_balance_pkg.get_value(pay_dk_pr_le.get_defined_balance_id

287: ,to_char(ppa1.date_earned,'DD-MON-RRRR') date_earned
288: ,pay_balance_pkg.get_value(pay_dk_pr_le.get_defined_balance_id
289: (pivf.input_value_id,'_ASG_RUN')
290: ,paa1.assignment_action_id) pay_value
291: /* ,pay_balance_pkg.get_value(pay_dk_pr_le.get_defined_balance_id
292: (pivf.input_value_id,'_ASG_YTD'),
293: paa1.assignment_action_id) balance_amount*/
294: FROM
295: per_all_assignments_f paaf

Line 393: ,pay_dk_pr_le.costed_code(prr.run_result_id,pivf.input_value_id) costed_code

389: ,ppf.payroll_id payroll_id
390: ,petf.element_type_id ele_type_id
391: ,petf.processing_priority ele_proc_prior
392: ,NVL(petf.reporting_name,petf.element_name) ele_name
393: ,pay_dk_pr_le.costed_code(prr.run_result_id,pivf.input_value_id) costed_code
394: ,pivf.input_value_id input_value_id
395: ,to_char(ppa1.date_earned,'DD-MON-RRRR') date_earned
396: ,pay_balance_pkg.get_value(pay_dk_pr_le.get_defined_balance_id
397: (pivf.input_value_id,'_ASG_RUN')

Line 396: ,pay_balance_pkg.get_value(pay_dk_pr_le.get_defined_balance_id

392: ,NVL(petf.reporting_name,petf.element_name) ele_name
393: ,pay_dk_pr_le.costed_code(prr.run_result_id,pivf.input_value_id) costed_code
394: ,pivf.input_value_id input_value_id
395: ,to_char(ppa1.date_earned,'DD-MON-RRRR') date_earned
396: ,pay_balance_pkg.get_value(pay_dk_pr_le.get_defined_balance_id
397: (pivf.input_value_id,'_ASG_RUN')
398: ,paa1.assignment_action_id) pay_value
399: /* ,pay_balance_pkg.get_value(pay_dk_pr_le.get_defined_balance_id
400: (pivf.input_value_id,'_ASG_YTD'),

Line 399: /* ,pay_balance_pkg.get_value(pay_dk_pr_le.get_defined_balance_id

395: ,to_char(ppa1.date_earned,'DD-MON-RRRR') date_earned
396: ,pay_balance_pkg.get_value(pay_dk_pr_le.get_defined_balance_id
397: (pivf.input_value_id,'_ASG_RUN')
398: ,paa1.assignment_action_id) pay_value
399: /* ,pay_balance_pkg.get_value(pay_dk_pr_le.get_defined_balance_id
400: (pivf.input_value_id,'_ASG_YTD'),
401: paa1.assignment_action_id) balance_amount*/
402: FROM
403: per_all_assignments_f paaf

Line 495: PAY_DK_PR_LE.GET_ALL_PARAMETERS(

491: AND ppa.business_group_id = ppf.business_group_id
492: ORDER BY ppf.person_id';
493:
494: -- fetch the input parameter values
495: PAY_DK_PR_LE.GET_ALL_PARAMETERS(
496: pactid
497: ,l_business_group_id
498: ,l_effective_date
499: ,l_archive

Line 983: END PAY_DK_PR_LE;

979: ELSIF (l_flag = 0) THEN
980: p_xml:=p_xml||'';
981: END IF;
982: END POPULATE_DETAILS;
983: END PAY_DK_PR_LE;