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_SOE dependencies on PAY_DK_SOE

Line 1: PACKAGE BODY pay_dk_soe AS

1: PACKAGE BODY pay_dk_soe AS
2: /* $Header: pydksoe.pkb 120.0.12000000.2 2007/03/05 09:43:17 nprasath noship $ */
3: --
4: --
5: g_debug boolean := hr_utility.debug_enabled;

Line 25: OPEN pay_dk_soe.csr_get_cvr_number (p_assignment_id,p_effective_date);

21: BEGIN
22:
23: IF p_org_information_context = 'DK_LEGAL_ENTITY_DETAILS'
24: THEN
25: OPEN pay_dk_soe.csr_get_cvr_number (p_assignment_id,p_effective_date);
26: FETCH pay_dk_soe.csr_get_cvr_number INTO l_cvr_number;
27:
28: IF pay_dk_soe.csr_get_cvr_number%NOTFOUND
29: THEN l_cvr_number := NULL;

Line 26: FETCH pay_dk_soe.csr_get_cvr_number INTO l_cvr_number;

22:
23: IF p_org_information_context = 'DK_LEGAL_ENTITY_DETAILS'
24: THEN
25: OPEN pay_dk_soe.csr_get_cvr_number (p_assignment_id,p_effective_date);
26: FETCH pay_dk_soe.csr_get_cvr_number INTO l_cvr_number;
27:
28: IF pay_dk_soe.csr_get_cvr_number%NOTFOUND
29: THEN l_cvr_number := NULL;
30: END IF;

Line 28: IF pay_dk_soe.csr_get_cvr_number%NOTFOUND

24: THEN
25: OPEN pay_dk_soe.csr_get_cvr_number (p_assignment_id,p_effective_date);
26: FETCH pay_dk_soe.csr_get_cvr_number INTO l_cvr_number;
27:
28: IF pay_dk_soe.csr_get_cvr_number%NOTFOUND
29: THEN l_cvr_number := NULL;
30: END IF;
31:
32: CLOSE pay_dk_soe.csr_get_cvr_number;

Line 32: CLOSE pay_dk_soe.csr_get_cvr_number;

28: IF pay_dk_soe.csr_get_cvr_number%NOTFOUND
29: THEN l_cvr_number := NULL;
30: END IF;
31:
32: CLOSE pay_dk_soe.csr_get_cvr_number;
33: l_return_value := to_char(l_cvr_number);
34:
35: ELSIF p_org_information_context = 'DK_PENSION_PROVIDER_DETAILS'
36: THEN

Line 37: OPEN pay_dk_soe.csr_get_pension_provider (p_assignment_id,p_effective_date);

33: l_return_value := to_char(l_cvr_number);
34:
35: ELSIF p_org_information_context = 'DK_PENSION_PROVIDER_DETAILS'
36: THEN
37: OPEN pay_dk_soe.csr_get_pension_provider (p_assignment_id,p_effective_date);
38: FETCH pay_dk_soe.csr_get_pension_provider INTO l_pension_provider;
39:
40: IF pay_dk_soe.csr_get_pension_provider%NOTFOUND
41: THEN l_pension_provider := NULL;

Line 38: FETCH pay_dk_soe.csr_get_pension_provider INTO l_pension_provider;

34:
35: ELSIF p_org_information_context = 'DK_PENSION_PROVIDER_DETAILS'
36: THEN
37: OPEN pay_dk_soe.csr_get_pension_provider (p_assignment_id,p_effective_date);
38: FETCH pay_dk_soe.csr_get_pension_provider INTO l_pension_provider;
39:
40: IF pay_dk_soe.csr_get_pension_provider%NOTFOUND
41: THEN l_pension_provider := NULL;
42: END IF;

Line 40: IF pay_dk_soe.csr_get_pension_provider%NOTFOUND

36: THEN
37: OPEN pay_dk_soe.csr_get_pension_provider (p_assignment_id,p_effective_date);
38: FETCH pay_dk_soe.csr_get_pension_provider INTO l_pension_provider;
39:
40: IF pay_dk_soe.csr_get_pension_provider%NOTFOUND
41: THEN l_pension_provider := NULL;
42: END IF;
43:
44: CLOSE pay_dk_soe.csr_get_pension_provider;

Line 44: CLOSE pay_dk_soe.csr_get_pension_provider;

40: IF pay_dk_soe.csr_get_pension_provider%NOTFOUND
41: THEN l_pension_provider := NULL;
42: END IF;
43:
44: CLOSE pay_dk_soe.csr_get_pension_provider;
45: l_return_value := l_pension_provider;
46:
47: END IF;
48:

Line 159: ,nvl(pay_dk_soe.get_cvr_or_pension(:assignment_id,:effective_date,''DK_LEGAL_ENTITY_DETAILS''), '''') COL17

155: ,nvl(ppb1.salary,''0'') COL13
156: ,peo.FIRST_NAME COL14
157: ,peo.MIDDLE_NAMES COL15
158: ,peo.LAST_NAME COL16
159: ,nvl(pay_dk_soe.get_cvr_or_pension(:assignment_id,:effective_date,''DK_LEGAL_ENTITY_DETAILS''), '''') COL17
160: ,nvl(pay_dk_soe.get_cvr_or_pension(:assignment_id,:effective_date,''DK_PENSION_PROVIDER_DETAILS''), '''') COL18
161: ,nvl(pay_dk_soe.get_union_membership(:assignment_id,:effective_date), '''') COL19
162: from per_all_people_f peo
163: ,per_all_assignments_f asg

Line 160: ,nvl(pay_dk_soe.get_cvr_or_pension(:assignment_id,:effective_date,''DK_PENSION_PROVIDER_DETAILS''), '''') COL18

156: ,peo.FIRST_NAME COL14
157: ,peo.MIDDLE_NAMES COL15
158: ,peo.LAST_NAME COL16
159: ,nvl(pay_dk_soe.get_cvr_or_pension(:assignment_id,:effective_date,''DK_LEGAL_ENTITY_DETAILS''), '''') COL17
160: ,nvl(pay_dk_soe.get_cvr_or_pension(:assignment_id,:effective_date,''DK_PENSION_PROVIDER_DETAILS''), '''') COL18
161: ,nvl(pay_dk_soe.get_union_membership(:assignment_id,:effective_date), '''') COL19
162: from per_all_people_f peo
163: ,per_all_assignments_f asg
164: ,hr_all_organization_units_vl org

Line 161: ,nvl(pay_dk_soe.get_union_membership(:assignment_id,:effective_date), '''') COL19

157: ,peo.MIDDLE_NAMES COL15
158: ,peo.LAST_NAME COL16
159: ,nvl(pay_dk_soe.get_cvr_or_pension(:assignment_id,:effective_date,''DK_LEGAL_ENTITY_DETAILS''), '''') COL17
160: ,nvl(pay_dk_soe.get_cvr_or_pension(:assignment_id,:effective_date,''DK_PENSION_PROVIDER_DETAILS''), '''') COL18
161: ,nvl(pay_dk_soe.get_union_membership(:assignment_id,:effective_date), '''') COL19
162: from per_all_people_f peo
163: ,per_all_assignments_f asg
164: ,hr_all_organization_units_vl org
165: ,per_jobs_vl job

Line 328: ,nvl(pay_dk_soe.get_bank_reg_number(ppm.external_account_id), '''') COL05

324: ,ppm.external_account_id
325: ,''BANK_ACCOUNT_NUMBER''
326: ,fnd_profile.value(''HR_MASK_CHARACTERS'')) COL03
327: ,to_char(pp.value,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
328: ,nvl(pay_dk_soe.get_bank_reg_number(ppm.external_account_id), '''') COL05
329: from pay_pre_payments pp
330: , pay_personal_payment_methods_f ppm
331: , pay_org_payment_methods_f opm
332: , pay_payment_types_tl pt

Line 410: ,''Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )''

406: l_sql :=
407: 'select /*+ ORDERED */ nvl(ettl.reporting_name,et.element_type_id) COL01
408: , nvl(ettl.reporting_name,ettl.element_name)||
409: decode( nvl(ettl.reporting_name,ettl.element_name)
410: ,''Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )''
411: ,''Employer Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )''
412: ,''Retro Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )''
413: ,''Retro Employer Pension'','' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )'') COL02
414: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16

Line 411: ,''Employer Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )''

407: 'select /*+ ORDERED */ nvl(ettl.reporting_name,et.element_type_id) COL01
408: , nvl(ettl.reporting_name,ettl.element_name)||
409: decode( nvl(ettl.reporting_name,ettl.element_name)
410: ,''Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )''
411: ,''Employer Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )''
412: ,''Retro Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )''
413: ,''Retro Employer Pension'','' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )'') COL02
414: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
415: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator

Line 412: ,''Retro Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )''

408: , nvl(ettl.reporting_name,ettl.element_name)||
409: decode( nvl(ettl.reporting_name,ettl.element_name)
410: ,''Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )''
411: ,''Employer Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )''
412: ,''Retro Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )''
413: ,''Retro Employer Pension'','' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )'') COL02
414: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
415: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
416: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18

Line 413: ,''Retro Employer Pension'','' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )'') COL02

409: decode( nvl(ettl.reporting_name,ettl.element_name)
410: ,''Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )''
411: ,''Employer Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )''
412: ,''Retro Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )''
413: ,''Retro Employer Pension'','' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )'') COL02
414: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
415: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
416: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
417: from pay_assignment_actions aa

Line 454: ,''Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,rr.run_result_id)||'' )''

450: ,nvl(ettl.reporting_name,et.element_type_id)
451: /*Changed for Pension provider break up */
452: , nvl(ettl.reporting_name,ettl.element_name)||
453: decode( nvl(ettl.reporting_name,ettl.element_name)
454: ,''Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,rr.run_result_id)||'' )''
455: ,''Employer Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,rr.run_result_id)||'' )''
456: ,''Retro Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,rr.run_result_id)||'' )''
457: ,''Retro Employer Pension'','' ( ''||pay_dk_soe.get_pp_name(:effective_date,rr.run_result_id)||'' )'')
458: order by nvl(ettl.reporting_name,ettl.element_name)';

Line 455: ,''Employer Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,rr.run_result_id)||'' )''

451: /*Changed for Pension provider break up */
452: , nvl(ettl.reporting_name,ettl.element_name)||
453: decode( nvl(ettl.reporting_name,ettl.element_name)
454: ,''Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,rr.run_result_id)||'' )''
455: ,''Employer Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,rr.run_result_id)||'' )''
456: ,''Retro Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,rr.run_result_id)||'' )''
457: ,''Retro Employer Pension'','' ( ''||pay_dk_soe.get_pp_name(:effective_date,rr.run_result_id)||'' )'')
458: order by nvl(ettl.reporting_name,ettl.element_name)';
459:

Line 456: ,''Retro Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,rr.run_result_id)||'' )''

452: , nvl(ettl.reporting_name,ettl.element_name)||
453: decode( nvl(ettl.reporting_name,ettl.element_name)
454: ,''Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,rr.run_result_id)||'' )''
455: ,''Employer Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,rr.run_result_id)||'' )''
456: ,''Retro Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,rr.run_result_id)||'' )''
457: ,''Retro Employer Pension'','' ( ''||pay_dk_soe.get_pp_name(:effective_date,rr.run_result_id)||'' )'')
458: order by nvl(ettl.reporting_name,ettl.element_name)';
459:
460:

Line 457: ,''Retro Employer Pension'','' ( ''||pay_dk_soe.get_pp_name(:effective_date,rr.run_result_id)||'' )'')

453: decode( nvl(ettl.reporting_name,ettl.element_name)
454: ,''Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,rr.run_result_id)||'' )''
455: ,''Employer Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,rr.run_result_id)||'' )''
456: ,''Retro Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,rr.run_result_id)||'' )''
457: ,''Retro Employer Pension'','' ( ''||pay_dk_soe.get_pp_name(:effective_date,rr.run_result_id)||'' )'')
458: order by nvl(ettl.reporting_name,ettl.element_name)';
459:
460:
461:

Line 511: Text : Modified version of pay_dk_soe.getBalances with ORG_ID support

507:
508: /* ---------------------------------------------------------------------
509: Function : getBalances
510:
511: Text : Modified version of pay_dk_soe.getBalances with ORG_ID support
512: and customized display of values for Pension Provider balances in DK.
513: ------------------------------------------------------------------------ */
514: function getBalances(p_assignment_action_id number
515: ) return long is

Line 670: hr_utility.set_location('Entering pay_dk_soe.getBalances', 10);

666: begin
667: --
668:
669: if g_debug then
670: hr_utility.set_location('Entering pay_dk_soe.getBalances', 10);
671: end if;
672: --
673: open getAction;
674: fetch getAction into l_payroll_id,

Line 688: hr_utility.set_location('pay_dk_soe.getBalances', 20);

684: --
685: i := 0;
686: --
687: if g_debug then
688: hr_utility.set_location('pay_dk_soe.getBalances', 20);
689: end if;
690: --
691: for db in getDBal loop
692: i := i + 1;

Line 721: hr_utility.set_location('pay_dk_soe.getBalances', 30);

717: --
718: i := 0;
719: if l_save_asg_run_bal = 'Y' then
720: if g_debug then
721: hr_utility.set_location('pay_dk_soe.getBalances', 30);
722: end if;
723: for ctx in getRBContexts loop
724: i := i + 1;
725: l_context_lst(i).TAX_UNIT_ID := ctx.TAX_UNIT_ID;

Line 734: hr_utility.set_location('pay_dk_soe.getBalances', 40);

730: l_context_lst(i).SOURCE_TEXT2 := ctx.SOURCE_TEXT2;
731: end loop;
732: else
733: if g_debug then
734: hr_utility.set_location('pay_dk_soe.getBalances', 40);
735: end if;
736: -- Check whether the SOURCE_ID, SOURCE_TEXT contexts are used.
737: l_si_needed_chr := 'N';
738: l_st_needed_chr := 'N';

Line 801: hr_utility.set_location('pay_dk_soe.getBalances', 50);

797: end if;
798: --
799: --
800: if g_debug then
801: hr_utility.set_location('pay_dk_soe.getBalances', 50);
802: end if;
803: --
804: pay_balance_pkg.get_value (p_assignment_action_id => p_assignment_action_id
805: ,p_defined_balance_lst => l_defined_balance_lst

Line 815: hr_utility.set_location('pay_dk_soe.getBalances', 60);

811: balCount := 0;
812: if l_output_table.count > 0 then
813: --
814: if g_debug then
815: hr_utility.set_location('pay_dk_soe.getBalances', 60);
816: end if;
817: --
818:
819: /* Sort the data in PL/SQL table according to organization_id */

Line 894: END pay_dk_soe;

890:
891: --
892: -- End of the Package
893:
894: END pay_dk_soe;