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_ORG dependencies on PAY_DK_PR_ORG

Line 1: PACKAGE BODY PAY_DK_PR_ORG AS

1: PACKAGE BODY PAY_DK_PR_ORG AS
2: /* $Header: pydkprorg.pkb 120.13 2012/01/19 09:08:43 rpahune ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5: l_business_group_id NUMBER;

Line 77: fnd_date.canonical_to_date(PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'FROM_DATE'))

73:
74:
75: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
76: SELECT
77: fnd_date.canonical_to_date(PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
78: ,fnd_date.canonical_to_date(PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'TO_DATE'))
79: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
80: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'ORGANIZATION_ID')
81: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'ELEMENT_SET_ID')

Line 78: ,fnd_date.canonical_to_date(PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'TO_DATE'))

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

Line 79: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')

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

Line 80: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'ORGANIZATION_ID')

76: SELECT
77: fnd_date.canonical_to_date(PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
78: ,fnd_date.canonical_to_date(PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'TO_DATE'))
79: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
80: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'ORGANIZATION_ID')
81: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'ELEMENT_SET_ID')
82: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
83: ,effective_date
84: ,business_group_id

Line 81: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'ELEMENT_SET_ID')

77: fnd_date.canonical_to_date(PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
78: ,fnd_date.canonical_to_date(PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'TO_DATE'))
79: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
80: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'ORGANIZATION_ID')
81: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'ELEMENT_SET_ID')
82: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
83: ,effective_date
84: ,business_group_id
85: FROM pay_payroll_actions

Line 82: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'ARCHIVE')

78: ,fnd_date.canonical_to_date(PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'TO_DATE'))
79: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
80: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'ORGANIZATION_ID')
81: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'ELEMENT_SET_ID')
82: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
83: ,effective_date
84: ,business_group_id
85: FROM pay_payroll_actions
86: WHERE payroll_action_id = p_payroll_action_id;

Line 202: SUM (pay_balance_pkg.get_value(pay_dk_pr_org.get_defined_balance_id

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

Line 279: ,pay_dk_pr_org.costed_code(prr.run_result_id,pivf.input_value_id) costed_code

275: ,ppf.payroll_id payroll_id
276: ,petf.element_type_id ele_type_id
277: ,petf.processing_priority ele_proc_prior
278: ,NVL(petf.reporting_name,petf.element_name) ele_name
279: ,pay_dk_pr_org.costed_code(prr.run_result_id,pivf.input_value_id) costed_code
280: ,pivf.input_value_id input_value_id
281: ,to_char(ppa1.date_earned,'DD-MON-RRRR') date_earned
282: ,pay_balance_pkg.get_value(pay_dk_pr_org.get_defined_balance_id
283: (pivf.input_value_id,'_ASG_RUN')

Line 282: ,pay_balance_pkg.get_value(pay_dk_pr_org.get_defined_balance_id

278: ,NVL(petf.reporting_name,petf.element_name) ele_name
279: ,pay_dk_pr_org.costed_code(prr.run_result_id,pivf.input_value_id) costed_code
280: ,pivf.input_value_id input_value_id
281: ,to_char(ppa1.date_earned,'DD-MON-RRRR') date_earned
282: ,pay_balance_pkg.get_value(pay_dk_pr_org.get_defined_balance_id
283: (pivf.input_value_id,'_ASG_RUN')
284: ,paa1.assignment_action_id) pay_value
285: /* ,pay_balance_pkg.get_value(pay_dk_pr_org.get_defined_balance_id
286: (pivf.input_value_id,'_ASG_YTD'),

Line 285: /* ,pay_balance_pkg.get_value(pay_dk_pr_org.get_defined_balance_id

281: ,to_char(ppa1.date_earned,'DD-MON-RRRR') date_earned
282: ,pay_balance_pkg.get_value(pay_dk_pr_org.get_defined_balance_id
283: (pivf.input_value_id,'_ASG_RUN')
284: ,paa1.assignment_action_id) pay_value
285: /* ,pay_balance_pkg.get_value(pay_dk_pr_org.get_defined_balance_id
286: (pivf.input_value_id,'_ASG_YTD'),
287: paa1.assignment_action_id) balance_amount*/
288:
289: FROM

Line 377: ,pay_dk_pr_org.costed_code(prr.run_result_id,pivf.input_value_id) costed_code

373: ,ppf.payroll_id payroll_id
374: ,petf.element_type_id ele_type_id
375: ,petf.processing_priority ele_proc_prior
376: ,NVL(petf.reporting_name,petf.element_name) ele_name
377: ,pay_dk_pr_org.costed_code(prr.run_result_id,pivf.input_value_id) costed_code
378: ,pivf.input_value_id input_value_id
379: ,to_char(ppa1.date_earned,'DD-MON-RRRR') date_earned
380: ,pay_balance_pkg.get_value(pay_dk_pr_org.get_defined_balance_id
381: (pivf.input_value_id,'_ASG_RUN')

Line 380: ,pay_balance_pkg.get_value(pay_dk_pr_org.get_defined_balance_id

376: ,NVL(petf.reporting_name,petf.element_name) ele_name
377: ,pay_dk_pr_org.costed_code(prr.run_result_id,pivf.input_value_id) costed_code
378: ,pivf.input_value_id input_value_id
379: ,to_char(ppa1.date_earned,'DD-MON-RRRR') date_earned
380: ,pay_balance_pkg.get_value(pay_dk_pr_org.get_defined_balance_id
381: (pivf.input_value_id,'_ASG_RUN')
382: ,paa1.assignment_action_id) pay_value
383: /* ,pay_balance_pkg.get_value(pay_dk_pr_org.get_defined_balance_id
384: (pivf.input_value_id,'_ASG_YTD'),

Line 383: /* ,pay_balance_pkg.get_value(pay_dk_pr_org.get_defined_balance_id

379: ,to_char(ppa1.date_earned,'DD-MON-RRRR') date_earned
380: ,pay_balance_pkg.get_value(pay_dk_pr_org.get_defined_balance_id
381: (pivf.input_value_id,'_ASG_RUN')
382: ,paa1.assignment_action_id) pay_value
383: /* ,pay_balance_pkg.get_value(pay_dk_pr_org.get_defined_balance_id
384: (pivf.input_value_id,'_ASG_YTD'),
385: paa1.assignment_action_id) balance_amount*/
386:
387: FROM

Line 475: PAY_DK_PR_ORG.GET_ALL_PARAMETERS(

471: AND ppa.business_group_id = ppf.business_group_id
472: ORDER BY ppf.person_id';
473:
474: -- fetch the input parameter values
475: PAY_DK_PR_ORG.GET_ALL_PARAMETERS(
476: pactid
477: ,l_business_group_id
478: ,l_effective_date
479: ,l_archive

Line 874: END PAY_DK_PR_ORG;

870: p_xml:=p_xml||'';
871: END IF;
872:
873: END POPULATE_DETAILS;
874: END PAY_DK_PR_ORG;