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_NL_WAGE_REPORT_PKG dependencies on HR_GENERAL

Line 2190: ,hr_general.end_of_time)

2186: AND org_information_context = 'NL_ORG_WR_PREV_YR_CORRECTION'
2187: AND org_information6 = c_payroll_type
2188: AND c_balance_date BETWEEN fnd_date.canonical_to_date (org_information1)
2189: AND nvl (fnd_date.canonical_to_date (org_information2)
2190: ,hr_general.end_of_time)
2191: ORDER BY fnd_date.canonical_to_date (org_information1);
2192: --Bug 14125837 end
2193: CURSOR csr_get_no_pay_period(c_payroll_type VARCHAR2) IS
2194: SELECT number_per_fiscal_year

Line 2743: IF csr_rec.org_information3 = '8' AND p_balance_date BETWEEN csr_rec.start_date AND NVL(csr_rec.end_date,hr_general.end_of_time) THEN

2739: END IF;
2740: --10370520
2741:
2742: --Changes for Employer Tax High Wages 16514249
2743: IF csr_rec.org_information3 = '8' AND p_balance_date BETWEEN csr_rec.start_date AND NVL(csr_rec.end_date,hr_general.end_of_time) THEN
2744: l_employer_tax_high_wages := csr_rec.amount;
2745: END IF;
2746: --16514249
2747:

Line 2776: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotLnLbPh'));

2772: --bug 14125837 end
2773: --
2774: p_collXMLTable(y).TagName := 'TotLnLbPh'; -- 1..5
2775: p_collXMLTable(y).Mandatory:= 'Y';
2776: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotLnLbPh'));
2777: p_collXMLTable(y).Tagvalue := 0;
2778: FOR i in 1..5 LOOP
2779: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
2780: + g_col_bal_def_table(i).balance_value2;

Line 2789: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotLnSV'));

2785: --
2786: y:= y+1;
2787: p_collXMLTable(y).TagName := 'TotLnSV'; -- 6..11
2788: p_collXMLTable(y).Mandatory:= 'Y';
2789: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotLnSV'));
2790: p_collXMLTable(y).Tagvalue := 0;
2791: FOR i in 6..11 LOOP
2792: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
2793: + g_col_bal_def_table(i).balance_value2;

Line 2805: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof'));

2801: y:= y+1;
2802: p_collXMLTable(y).TagName := 'PrLnWAOAof'; --12..13
2803: p_collXMLTable(y).Mandatory:= 'Y';
2804: IF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
2805: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof'));
2806: ELSE
2807: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof_2006'));
2808: END IF;
2809: p_collXMLTable(y).Tagvalue := 0;

Line 2807: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof_2006'));

2803: p_collXMLTable(y).Mandatory:= 'Y';
2804: IF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
2805: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof'));
2806: ELSE
2807: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof_2006'));
2808: END IF;
2809: p_collXMLTable(y).Tagvalue := 0;
2810: FOR i in 12..13 LOOP
2811: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value

Line 2822: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWaoPma'));

2818: IF p_effective_date >= to_date('01012010','DDMMYYYY') THEN
2819: y:= y+1;
2820: p_collXMLTable(y).TagName := 'PrLnWaoPma'; -- 88..89
2821: p_collXMLTable(y).Mandatory:= 'Y';
2822: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWaoPma'));
2823: p_collXMLTable(y).Tagvalue:=0;
2824: FOR i in 88..89 LOOP
2825: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
2826: + g_col_bal_def_table(i).balance_value2;

Line 2841: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrLnWgaWhk'));

2837: p_collXMLTable(y).TagName := 'TotPrLnWgaWhk'; -- 14..15
2838: END IF;
2839: p_collXMLTable(y).Mandatory:= 'Y';
2840: IF p_effective_date >= to_date('01012012','DDMMYYYY') THEN
2841: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrLnWgaWhk'));
2842: ELSIF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
2843: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok'));
2844: ELSE
2845: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok_2006'));

Line 2843: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok'));

2839: p_collXMLTable(y).Mandatory:= 'Y';
2840: IF p_effective_date >= to_date('01012012','DDMMYYYY') THEN
2841: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrLnWgaWhk'));
2842: ELSIF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
2843: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok'));
2844: ELSE
2845: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok_2006'));
2846: END IF;
2847: p_collXMLTable(y).Tagvalue:=0;

Line 2845: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok_2006'));

2841: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrLnWgaWhk'));
2842: ELSIF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
2843: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok'));
2844: ELSE
2845: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok_2006'));
2846: END IF;
2847: p_collXMLTable(y).Tagvalue:=0;
2848: --IF g_public_org_flag <> 'N' OR g_risk_cover_flag <> 'Y' THEN
2849: ELSE

Line 2858: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrLnWgaWhk'));

2854: p_collXMLTable(y).TagName := 'TotPrLnWgaWhk'; -- 14..15
2855: END IF;
2856: p_collXMLTable(y).Mandatory:= 'Y';
2857: IF p_effective_date >= to_date('01012012','DDMMYYYY') THEN
2858: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrLnWgaWhk'));
2859: ELSIF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
2860: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok'));
2861: ELSE
2862: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok_2006'));

Line 2860: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok'));

2856: p_collXMLTable(y).Mandatory:= 'Y';
2857: IF p_effective_date >= to_date('01012012','DDMMYYYY') THEN
2858: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrLnWgaWhk'));
2859: ELSIF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
2860: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok'));
2861: ELSE
2862: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok_2006'));
2863: END IF;
2864: p_collXMLTable(y).Tagvalue:=0;

Line 2862: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok_2006'));

2858: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrLnWgaWhk'));
2859: ELSIF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
2860: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok'));
2861: ELSE
2862: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok_2006'));
2863: END IF;
2864: p_collXMLTable(y).Tagvalue:=0;
2865: FOR i in 14..15 LOOP
2866: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value

Line 2877: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnAWF'));

2873: IF g_public_org_flag = 'N' THEN
2874: y:= y+1;
2875: p_collXMLTable(y).TagName := 'PrLnAWF'; -- 16..17
2876: p_collXMLTable(y).Mandatory:= 'Y';
2877: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnAWF'));
2878: p_collXMLTable(y).Tagvalue:=0;
2879: FOR i in 16..17 LOOP
2880: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
2881: + g_col_bal_def_table(i).balance_value2;

Line 2887: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnAWF'));

2883: ELSE
2884: y:= y+1;
2885: p_collXMLTable(y).TagName := 'PrLnAWF'; -- 16..17
2886: p_collXMLTable(y).Mandatory:= 'Y';
2887: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnAWF'));
2888: p_collXMLTable(y).Tagvalue:=0;
2889: END IF;
2890: p_collXMLTable(y).Tagvalue := p_collXMLTable(y).Tagvalue + NVL(l_co_col_PrLnWwAwf,0); --10100628
2891:

Line 2896: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotVergZvw'));

2892: --
2893: y:= y+1;
2894: p_collXMLTable(y).TagName := 'TotVergZvw'; --20..27
2895: p_collXMLTable(y).Mandatory:= 'Y';
2896: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotVergZvw'));
2897: p_collXMLTable(y).Tagvalue:=0;
2898: FOR i in 20..27 LOOP
2899: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
2900: + g_col_bal_def_table(i).balance_value2;

Line 2911: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnUFO'));

2907: --IF g_public_org_flag = 'Y' THEN
2908: y:= y+1;
2909: p_collXMLTable(y).TagName := 'PrLnUFO'; --18..19
2910: p_collXMLTable(y).Mandatory:= 'Y';
2911: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnUFO'));
2912: p_collXMLTable(y).Tagvalue:=0;
2913: FOR i in 18..19 LOOP
2914: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
2915: + g_col_bal_def_table(i).balance_value2;

Line 2927: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('IngLbPh'));

2923: --
2924: y:= y+1;
2925: p_collXMLTable(y).TagName := 'IngLbPh'; --28..32
2926: p_collXMLTable(y).Mandatory:= 'Y';
2927: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('IngLbPh'));
2928: p_collXMLTable(y).Tagvalue:=0;
2929: FOR i in 28..32 LOOP
2930: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
2931: + g_col_bal_def_table(i).balance_value2;

Line 2948: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHPubUitk'));

2944: --
2945: y:= y+1;
2946: p_collXMLTable(y).TagName := 'EHPubUitk'; -- 33..34
2947: p_collXMLTable(y).Mandatory:= 'N';
2948: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHPubUitk'));
2949: p_collXMLTable(y).Tagvalue:= l_major_issue_flat_rate; -- Bug# 5754707
2950: /* FOR i in 33..34 LOOP
2951: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
2952: + g_col_bal_def_table(i).balance_value2;

Line 2959: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHLnBestKar'));

2955: --
2956: y:= y+1;
2957: p_collXMLTable(y).TagName := 'EHLnBestKar'; --35..36
2958: p_collXMLTable(y).Mandatory:= 'N';
2959: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHLnBestKar'));
2960: p_collXMLTable(y).Tagvalue:=0;
2961: --bug 14125837 begin
2962: IF l_corr_ehlnbestkar IS NOT NULL THEN
2963: p_collXMLTable(y).Tagvalue:=l_corr_ehlnbestkar;

Line 2977: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHSpLn'));

2973: --LC 2012 changes begin. Tag is obsolete
2974: y:= y+1;
2975: p_collXMLTable(y).TagName := 'EHSpLn'; -- 37..38
2976: p_collXMLTable(y).Mandatory:= 'N';
2977: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHSpLn'));
2978: p_collXMLTable(y).Tagvalue:=0;
2979: IF p_effective_date < to_date('01012012','DDMMYYYY') THEN
2980: FOR i in 37..38 LOOP
2981: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value

Line 2991: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHSpPr'));

2987: --
2988: y:= y+1;
2989: p_collXMLTable(y).TagName := 'EHSpPr'; --39..40
2990: p_collXMLTable(y).Mandatory:= 'N';
2991: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHSpPr'));
2992: p_collXMLTable(y).Tagvalue:=0;
2993:
2994: IF p_effective_date < to_date('01012008','DDMMYYYY') THEN
2995: FOR i in 39..40 LOOP --Dutch Year End Changes 08 This Tag is obsolete as of 08 Wage Report

Line 3005: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHLnNat'));

3001: --
3002: y:= y+1;
3003: p_collXMLTable(y).TagName := 'EHLnNat'; --41-44
3004: p_collXMLTable(y).Mandatory:= 'N';
3005: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHLnNat'));
3006: p_collXMLTable(y).Tagvalue:= l_single_rate_exp_pay; -- Bug# 5754707
3007: /*FOR i in 41..44 LOOP
3008: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
3009: + g_col_bal_def_table(i).balance_value2;

Line 3016: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHFeest'));

3012: --
3013: y:= y+1;
3014: p_collXMLTable(y).TagName := 'EHFeest'; -- 45..46
3015: p_collXMLTable(y).Mandatory:= 'N';
3016: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHFeest'));
3017: p_collXMLTable(y).Tagvalue:=0;
3018: p_collXMLTable(y).Tagvalue := l_flat_tax_holidays; /*** Bug 6610259 ***/
3019: /*FOR i in 45..46 LOOP
3020: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value

Line 3028: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHBmVerg'));

3024: --
3025: y:= y+1;
3026: p_collXMLTable(y).TagName := 'EHBmVerg'; --47..48
3027: p_collXMLTable(y).Mandatory:= 'N';
3028: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHBmVerg'));
3029: p_collXMLTable(y).Tagvalue:=0;
3030: --bug 14125837 begin
3031: IF l_corr_ehbmverg IS NOT NULL THEN
3032: p_collXMLTable(y).Tagvalue:=l_corr_ehbmverg;

Line 3046: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHGebrAuto'));

3042: IF p_effective_date >= TO_DATE('01012007','DDMMYYYY') THEN
3043: y:= y+1;
3044: p_collXMLTable(y).TagName := 'EHGebrAuto';
3045: p_collXMLTable(y).Mandatory:= 'N';
3046: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHGebrAuto'));
3047: p_collXMLTable(y).Tagvalue:= l_flat_rate_taxation;
3048: p_emp_total := p_emp_total + ROUND(p_collXMLTable(y).Tagvalue); --13722974
3049: END IF;
3050: --

Line 3054: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHVUT'));

3050: --
3051: y:= y+1;
3052: p_collXMLTable(y).TagName := 'EHVUT'; -- 49..50
3053: p_collXMLTable(y).Mandatory:= 'N';
3054: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHVUT'));
3055: p_collXMLTable(y).Tagvalue:=0;
3056: p_collXMLTable(y).Tagvalue := l_flat_tax_pre_pension; /* 7533686 */
3057: /*
3058: FOR i in 49..50 LOOP

Line 3080: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EhOvsFrfWrkkstrg'));

3076:
3077: y:= y+1;
3078: p_collXMLTable(y).TagName := 'EhOvsFrfWrkkstrg';
3079: p_collXMLTable(y).Mandatory:= 'N';
3080: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EhOvsFrfWrkkstrg'));
3081: p_collXMLTable(y).Tagvalue:=0;
3082: p_collXMLTable(y).Tagvalue := l_flat_tax_lca;
3083: p_emp_total := p_emp_total + ROUND(p_collXMLTable(y).Tagvalue);
3084: --

Line 3092: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PsehHgLn'));

3088: IF p_effective_date >= TO_DATE('01012013','DDMMYYYY') AND NVL(l_employer_tax_high_wages,0) <> 0 THEN
3089: y:= y+1;
3090: p_collXMLTable(y).TagName := 'PsehHgLn';
3091: p_collXMLTable(y).Mandatory:= 'N';
3092: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PsehHgLn'));
3093: p_collXMLTable(y).Tagvalue := NVL(l_employer_tax_high_wages,0);
3094: p_emp_total := p_emp_total + ROUND(p_collXMLTable(y).Tagvalue);
3095: END IF;
3096: --End of Employer High Wage Tax Changes 16514249

Line 3102: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVBetOV'));

3098: IF p_effective_date < TO_DATE('01012007','DDMMYYYY') THEN
3099: y:= y+1;
3100: p_collXMLTable(y).TagName := 'AVBetOV'; -- 51..52
3101: p_collXMLTable(y).Mandatory:= 'N';
3102: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVBetOV'));
3103: p_collXMLTable(y).Tagvalue:=0;
3104: FOR i in 51..52 LOOP
3105: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
3106: + g_col_bal_def_table(i).balance_value2;

Line 3114: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVLgdWerkl'));

3110: --
3111: y:= y+1;
3112: p_collXMLTable(y).TagName := 'AVLgdWerkl'; -- 53..54
3113: p_collXMLTable(y).Mandatory:= 'N';
3114: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVLgdWerkl'));
3115: p_collXMLTable(y).Tagvalue:=0;
3116: FOR i in 53..54 LOOP
3117: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
3118: + g_col_bal_def_table(i).balance_value2;

Line 3127: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVArboNP'));

3123: --
3124: y:= y+1;
3125: p_collXMLTable(y).TagName := 'AVArboNP'; -- 55
3126: p_collXMLTable(y).Mandatory:= 'N';
3127: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVArboNP'));
3128: p_collXMLTable(y).Tagvalue:=0;
3129: IF p_effective_date < to_date('01012008','DDMMYYYY') THEN
3130: p_collXMLTable(y).Tagvalue:= g_col_bal_def_table(55).balance_value ;
3131: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue * -1;

Line 3138: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVZeev'));

3134: --
3135: y:= y+1;
3136: p_collXMLTable(y).TagName := 'AVZeev'; -- 56
3137: p_collXMLTable(y).Mandatory:= 'N';
3138: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVZeev'));
3139: p_collXMLTable(y).Tagvalue:=0;
3140: p_collXMLTable(y).Tagvalue:= g_col_bal_def_table(56).balance_value ;
3141: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue * -1;
3142: p_emp_total := p_emp_total - ROUND(p_collXMLTable(y).Tagvalue);

Line 3146: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVOnd'));

3142: p_emp_total := p_emp_total - ROUND(p_collXMLTable(y).Tagvalue);
3143: y:= y+1;
3144: p_collXMLTable(y).TagName := 'AVOnd'; -- 57..58
3145: p_collXMLTable(y).Mandatory:= 'N';
3146: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVOnd'));
3147: p_collXMLTable(y).Tagvalue:=0;
3148: --bug 14125837 begin
3149: IF l_corr_avond IS NOT NULL THEN
3150: p_collXMLTable(y).Tagvalue:=l_corr_avond;

Line 3178: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('VrlAVSO'));

3174: --
3175: y:= y+1;
3176: p_collXMLTable(y).TagName := 'VrlAVSO'; --59
3177: p_collXMLTable(y).Mandatory:= 'N';
3178: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('VrlAVSO'));
3179: p_collXMLTable(y).Tagvalue:=l_wage_tax_subsidy; -- Bug# 5754707
3180: --p_collXMLTable(y).Tagvalue:= g_col_bal_def_table(59).balance_value ; -- Bug# 5754707
3181: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue * -1;
3182: p_emp_total := p_emp_total - ROUND(p_collXMLTable(y).Tagvalue);

Line 3188: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof'));

3184: y:= y+1;
3185: p_collXMLTable(y).TagName := 'PrWAOAof'; -- 60..65 WAOB WGA IVA
3186: p_collXMLTable(y).Mandatory:= 'N';
3187: IF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
3188: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof'));
3189: ELSE
3190: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof_2006'));
3191: END IF;
3192: p_collXMLTable(y).Tagvalue:=0;

Line 3190: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof_2006'));

3186: p_collXMLTable(y).Mandatory:= 'N';
3187: IF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
3188: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof'));
3189: ELSE
3190: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof_2006'));
3191: END IF;
3192: p_collXMLTable(y).Tagvalue:=0;
3193: p_collXMLTable(y).Tagvalue := p_collXMLTable(y).Tagvalue + NVL(l_co_col_PrWAOAof,0); --10100628
3194:

Line 3211: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrWgaWhk'));

3207: p_collXMLTable(y).TagName := 'TotPrWgaWhk';
3208: END IF;
3209: p_collXMLTable(y).Mandatory:= 'Y';
3210: IF p_effective_date >= to_date('01012012','DDMMYYYY') THEN
3211: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrWgaWhk'));
3212: ELSIF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
3213: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));
3214: ELSE
3215: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));

Line 3213: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));

3209: p_collXMLTable(y).Mandatory:= 'Y';
3210: IF p_effective_date >= to_date('01012012','DDMMYYYY') THEN
3211: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrWgaWhk'));
3212: ELSIF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
3213: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));
3214: ELSE
3215: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));
3216: END IF;
3217: p_collXMLTable(y).Tagvalue:=0;

Line 3215: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));

3211: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrWgaWhk'));
3212: ELSIF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
3213: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));
3214: ELSE
3215: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));
3216: END IF;
3217: p_collXMLTable(y).Tagvalue:=0;
3218: ELSIF g_public_org_flag = 'N' AND g_risk_cover_flag = 'Y' THEN
3219: y:= y+1;

Line 3227: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrWgaWhk'));

3223: p_collXMLTable(y).TagName := 'TotPrWgaWhk';
3224: END IF;
3225: p_collXMLTable(y).Mandatory:= 'Y';
3226: IF p_effective_date >= to_date('01012012','DDMMYYYY') THEN
3227: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrWgaWhk'));
3228: ELSIF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
3229: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));
3230: ELSE
3231: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));

Line 3229: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));

3225: p_collXMLTable(y).Mandatory:= 'Y';
3226: IF p_effective_date >= to_date('01012012','DDMMYYYY') THEN
3227: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrWgaWhk'));
3228: ELSIF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
3229: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));
3230: ELSE
3231: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));
3232: END IF;
3233: p_collXMLTable(y).Tagvalue:=0;

Line 3231: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));

3227: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrWgaWhk'));
3228: ELSIF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
3229: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));
3230: ELSE
3231: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));
3232: END IF;
3233: p_collXMLTable(y).Tagvalue:=0;
3234: ELSE
3235: y:= y+1;

Line 3243: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrWgaWhk'));

3239: p_collXMLTable(y).TagName := 'TotPrWgaWhk';
3240: END IF;
3241: p_collXMLTable(y).Mandatory:= 'N';
3242: IF p_effective_date >= to_date('01012012','DDMMYYYY') THEN
3243: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrWgaWhk'));
3244: ELSIF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
3245: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));
3246: ELSE
3247: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));

Line 3245: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));

3241: p_collXMLTable(y).Mandatory:= 'N';
3242: IF p_effective_date >= to_date('01012012','DDMMYYYY') THEN
3243: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrWgaWhk'));
3244: ELSIF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
3245: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));
3246: ELSE
3247: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));
3248: END IF;
3249: p_collXMLTable(y).Tagvalue:=0;

Line 3247: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));

3243: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrWgaWhk'));
3244: ELSIF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
3245: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));
3246: ELSE
3247: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));
3248: END IF;
3249: p_collXMLTable(y).Tagvalue:=0;
3250: FOR i in 66..67 LOOP
3251: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value

Line 3263: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrAWF'));

3259: IF g_public_org_flag = 'N' THEN
3260: y:= y+1;
3261: p_collXMLTable(y).TagName := 'PrAWF'; -- 68..69 WEWE
3262: p_collXMLTable(y).Mandatory:= 'N';
3263: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrAWF'));
3264: p_collXMLTable(y).Tagvalue:=0;
3265: FOR i in 68..69 LOOP
3266: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
3267: + g_col_bal_def_table(i).balance_value2;

Line 3279: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrUFO'));

3275: IF g_public_org_flag = 'Y' THEN
3276: y:= y+1;
3277: p_collXMLTable(y).TagName := 'PrUFO'; -- 70..71 UFO
3278: p_collXMLTable(y).Mandatory:= 'N';
3279: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrUFO'));
3280: p_collXMLTable(y).Tagvalue:=0;
3281: FOR i in 70..71 LOOP
3282: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
3283: + g_col_bal_def_table(i).balance_value2;

Line 3297: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('IngBijdrZvw'));

3293: --
3294: y:= y+1;
3295: p_collXMLTable(y).TagName := 'IngBijdrZvw'; -- 72..73 ZVW
3296: p_collXMLTable(y).Mandatory:= 'N';
3297: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('IngBijdrZvw'));
3298: p_collXMLTable(y).Tagvalue:=0;
3299: FOR i in 72..73 LOOP
3300: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
3301: + g_col_bal_def_table(i).balance_value2;

Line 3312: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('IngBijdrZvw'));

3308: --
3309: y:= y+1;
3310: p_collXMLTable(y).TagName := 'IngBijdrZvw'; -- 90..91 ZVWL
3311: p_collXMLTable(y).Mandatory:= 'Y';
3312: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('IngBijdrZvw'));
3313: p_collXMLTable(y).Tagvalue:=0;
3314: FOR i in 90..91 LOOP
3315: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
3316: + g_col_bal_def_table(i).balance_value2;

Line 3325: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotWghZvw'));

3321: y:= y+1;
3322: hr_utility.set_location(y,2);
3323: p_collXMLTable(y).TagName := 'TotWghZvw'; -- 92..93 ZVWS
3324: p_collXMLTable(y).Mandatory:= 'Y';
3325: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotWghZvw'));
3326: p_collXMLTable(y).Tagvalue:=0;
3327: FOR i in 92..93 LOOP
3328: hr_utility.set_location(g_col_bal_def_table(i).balance_value || ' '||+ g_col_bal_def_table(i).balance_value2,100.01);
3329: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value

Line 3345: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PkAgh'));

3341:
3342: y:= y+1;
3343: p_collXMLTable(y).TagName := 'PkAgh'; -- 82..83
3344: p_collXMLTable(y).Mandatory:= 'N';
3345: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PkAgh'));
3346: p_collXMLTable(y).Tagvalue:=0;
3347: --bug 14125837 begin
3348: IF l_corr_pkagh IS NOT NULL THEN
3349: p_collXMLTable(y).Tagvalue:=l_corr_pkagh;

Line 3364: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PkNwArbvOudWn'));

3360:
3361: y:= y+1;
3362: p_collXMLTable(y).TagName := 'PkNwArbvOudWn'; -- 84..85
3363: p_collXMLTable(y).Mandatory:= 'N';
3364: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PkNwArbvOudWn'));
3365: p_collXMLTable(y).Tagvalue:=0;
3366: --bug 14125837 begin
3367: IF l_corr_pknwarbvoudwn IS NOT NULL THEN
3368: p_collXMLTable(y).Tagvalue:=l_corr_pknwarbvoudwn;

Line 3385: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PkInDnstOudWn'));

3381: IF p_effective_date < to_date('01012013','DDMMYYYY') then
3382: y:= y+1;
3383: p_collXMLTable(y).TagName := 'PkInDnstOudWn'; -- 86..87
3384: p_collXMLTable(y).Mandatory:= 'N';
3385: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PkInDnstOudWn'));
3386: p_collXMLTable(y).Tagvalue:=0;
3387: --bug 14125837 begin
3388: IF l_corr_pkindnstoudwn IS NOT NULL THEN
3389: p_collXMLTable(y).Tagvalue:=l_corr_pkindnstoudwn;

Line 3405: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AGHKort'));

3401: ELSE
3402: y:= y+1;
3403: p_collXMLTable(y).TagName := 'AGHKort'; -- 74..75
3404: p_collXMLTable(y).Mandatory:= 'N';
3405: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AGHKort'));
3406: p_collXMLTable(y).Tagvalue:=0;
3407: FOR i in 74..75 LOOP
3408: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
3409: + g_col_bal_def_table(i).balance_value2;

Line 3419: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotTeBet'));

3415: --
3416: y:= y+1;
3417: p_collXMLTable(y).TagName := 'TotTeBet';
3418: p_collXMLTable(y).Mandatory:= 'Y';
3419: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotTeBet'));
3420: p_collXMLTable(y).Tagvalue:= p_emp_total;
3421: --
3422: --
3423: --FOR i in p_collXMLTable.first..p_collXMLTable.last LOOP

Line 5324: , p_action_information5 => HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('Saldo'))

5320: , p_action_information1 => 'CORR_BALANCE'
5321: , p_action_information2 => 'Saldo'
5322: , p_action_information3 => fnd_date.date_to_canonical(l_ret_cor_period.start_date)
5323: , p_action_information4 => fnd_date.date_to_canonical(l_ret_cor_period.End_date)
5324: , p_action_information5 => HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('Saldo'))
5325: , p_action_information6 => fnd_number.number_to_canonical(ROUND(l_corr_bal)));
5326: /*
5327: --abraghun--7668628-- Validation Data Capture --Check0011 -Begins
5328: l_CR_Saldo_Sum := fnd_number.number_to_canonical(

Line 5351: ,p_action_information5 => HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotGen')) -- TAG DESCRIPTION

5347: ,p_action_information1 => 'TOTAL'
5348: ,p_action_information2 => 'TotGen' -- TAG NAME
5349: ,p_action_information3 => l_period_dates_rec.start_date
5350: ,p_action_information4 => l_period_dates_rec.End_date
5351: ,p_action_information5 => HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotGen')) -- TAG DESCRIPTION
5352: ,p_action_information6 => fnd_number.number_to_canonical(ROUND(l_emp_total)));
5353: /*
5354: --abraghun--7668628-- Validataion Data Capture --Check0011 -Begins
5355: l_CR_TotGen := fnd_number.number_to_canonical(ROUND(l_emp_total));

Line 6043: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotLnLbPh'));

6039: --
6040: y:= 1;
6041: collXMLTable(y).TagName := 'TotLnLbPh';
6042: collXMLTable(y).Mandatory:= 'Y';
6043: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotLnLbPh'));
6044: collXMLTable(y).Tagvalue := 0;
6045: --
6046: y:= y+1;
6047: collXMLTable(y).TagName := 'TotLnSV';

Line 6049: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotLnSV'));

6045: --
6046: y:= y+1;
6047: collXMLTable(y).TagName := 'TotLnSV';
6048: collXMLTable(y).Mandatory:= 'Y';
6049: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotLnSV'));
6050: collXMLTable(y).Tagvalue := 0;
6051: --
6052: y:= y+1;
6053: collXMLTable(y).TagName := 'PrLnWAOAof';

Line 6056: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof'));

6052: y:= y+1;
6053: collXMLTable(y).TagName := 'PrLnWAOAof';
6054: collXMLTable(y).Mandatory:= 'Y';
6055: IF l_end_date >= to_date('01012007','DDMMYYYY') THEN
6056: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof'));
6057: ELSE
6058: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof_2006'));
6059: END IF;
6060: collXMLTable(y).Tagvalue := 0;

Line 6058: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof_2006'));

6054: collXMLTable(y).Mandatory:= 'Y';
6055: IF l_end_date >= to_date('01012007','DDMMYYYY') THEN
6056: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof'));
6057: ELSE
6058: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof_2006'));
6059: END IF;
6060: collXMLTable(y).Tagvalue := 0;
6061: --
6062: y:= y+1;

Line 6071: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrLnWgaWhk'));

6067: collXMLTable(y).TagName := 'TotPrLnWgaWhk';
6068: END IF;
6069: collXMLTable(y).Mandatory:= 'Y';
6070: IF l_end_date >= to_date('01012012', 'DDMMYYYY') THEN
6071: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrLnWgaWhk'));
6072: ELSIF l_end_date >= to_date('01012007','DDMMYYYY') THEN
6073: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok'));
6074: ELSE
6075: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok_2006'));

Line 6073: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok'));

6069: collXMLTable(y).Mandatory:= 'Y';
6070: IF l_end_date >= to_date('01012012', 'DDMMYYYY') THEN
6071: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrLnWgaWhk'));
6072: ELSIF l_end_date >= to_date('01012007','DDMMYYYY') THEN
6073: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok'));
6074: ELSE
6075: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok_2006'));
6076: END IF;
6077: --LC 2012 end.

Line 6075: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok_2006'));

6071: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrLnWgaWhk'));
6072: ELSIF l_end_date >= to_date('01012007','DDMMYYYY') THEN
6073: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok'));
6074: ELSE
6075: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok_2006'));
6076: END IF;
6077: --LC 2012 end.
6078: collXMLTable(y).Tagvalue := 0;
6079: --

Line 6083: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnAWF'));

6079: --
6080: y:= y+1;
6081: collXMLTable(y).TagName := 'PrLnAWF';
6082: collXMLTable(y).Mandatory:= 'Y';
6083: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnAWF'));
6084: collXMLTable(y).Tagvalue := 0;
6085: --
6086: y:= y+1;
6087: collXMLTable(y).TagName := 'PrLnUFO';

Line 6089: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnUFO'));

6085: --
6086: y:= y+1;
6087: collXMLTable(y).TagName := 'PrLnUFO';
6088: collXMLTable(y).Mandatory:= 'Y';
6089: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnUFO'));
6090: collXMLTable(y).Tagvalue := 0;
6091: --
6092: y:= y+1;
6093: collXMLTable(y).TagName := 'TotVergZvw';

Line 6095: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotVergZvw'));

6091: --
6092: y:= y+1;
6093: collXMLTable(y).TagName := 'TotVergZvw';
6094: collXMLTable(y).Mandatory:= 'Y';
6095: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotVergZvw'));
6096: collXMLTable(y).Tagvalue := 0;
6097: --
6098: y:= y+1;
6099: collXMLTable(y).TagName := 'IngLbPh';

Line 6101: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('IngLbPh'));

6097: --
6098: y:= y+1;
6099: collXMLTable(y).TagName := 'IngLbPh';
6100: collXMLTable(y).Mandatory:= 'Y';
6101: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('IngLbPh'));
6102: collXMLTable(y).Tagvalue := 0;
6103: --
6104: y:= y+1;
6105: collXMLTable(y).TagName := 'EHPubUitk';

Line 6107: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHPubUitk'));

6103: --
6104: y:= y+1;
6105: collXMLTable(y).TagName := 'EHPubUitk';
6106: collXMLTable(y).Mandatory:= 'N';
6107: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHPubUitk'));
6108: collXMLTable(y).Tagvalue := 0;
6109: --
6110: y:= y+1;
6111: collXMLTable(y).TagName := 'EHLnBestKar';

Line 6113: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHLnBestKar'));

6109: --
6110: y:= y+1;
6111: collXMLTable(y).TagName := 'EHLnBestKar';
6112: collXMLTable(y).Mandatory:= 'N';
6113: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHLnBestKar'));
6114: collXMLTable(y).Tagvalue := 0;
6115: --
6116: y:= y+1;
6117: collXMLTable(y).TagName := 'EHSpLn';

Line 6119: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHSpLn'));

6115: --
6116: y:= y+1;
6117: collXMLTable(y).TagName := 'EHSpLn';
6118: collXMLTable(y).Mandatory:= 'N';
6119: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHSpLn'));
6120: collXMLTable(y).Tagvalue := 0;
6121: --
6122: y:= y+1;
6123: collXMLTable(y).TagName := 'EHSpPr';

Line 6125: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHSpPr'));

6121: --
6122: y:= y+1;
6123: collXMLTable(y).TagName := 'EHSpPr';
6124: collXMLTable(y).Mandatory:= 'N';
6125: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHSpPr'));
6126: collXMLTable(y).Tagvalue := 0;
6127: --
6128: y:= y+1;
6129: collXMLTable(y).TagName := 'EHLnNat';

Line 6131: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHLnNat'));

6127: --
6128: y:= y+1;
6129: collXMLTable(y).TagName := 'EHLnNat';
6130: collXMLTable(y).Mandatory:= 'N';
6131: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHLnNat'));
6132: collXMLTable(y).Tagvalue := 0;
6133: --
6134: y:= y+1;
6135: collXMLTable(y).TagName := 'EHFeest';

Line 6137: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHFeest'));

6133: --
6134: y:= y+1;
6135: collXMLTable(y).TagName := 'EHFeest';
6136: collXMLTable(y).Mandatory:= 'N';
6137: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHFeest'));
6138: collXMLTable(y).Tagvalue := 0;
6139: --
6140: y:= y+1;
6141: collXMLTable(y).TagName := 'EHBmVerg';

Line 6143: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHBmVerg'));

6139: --
6140: y:= y+1;
6141: collXMLTable(y).TagName := 'EHBmVerg';
6142: collXMLTable(y).Mandatory:= 'N';
6143: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHBmVerg'));
6144: collXMLTable(y).Tagvalue := 0;
6145: --
6146: y:= y+1; -- new added
6147: collXMLTable(y).TagName := 'EHGebrAuto';

Line 6149: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHGebrAuto'));

6145: --
6146: y:= y+1; -- new added
6147: collXMLTable(y).TagName := 'EHGebrAuto';
6148: collXMLTable(y).Mandatory:= 'N';
6149: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHGebrAuto'));
6150: collXMLTable(y).Tagvalue := 0;
6151: --
6152: y:= y+1;
6153: collXMLTable(y).TagName := 'EHVUT';

Line 6155: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHVUT'));

6151: --
6152: y:= y+1;
6153: collXMLTable(y).TagName := 'EHVUT';
6154: collXMLTable(y).Mandatory:= 'N';
6155: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHVUT'));
6156: collXMLTable(y).Tagvalue := 0;
6157: --
6158: y:= y+1;
6159: collXMLTable(y).TagName := 'AVBetOV';

Line 6161: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVBetOV'));

6157: --
6158: y:= y+1;
6159: collXMLTable(y).TagName := 'AVBetOV';
6160: collXMLTable(y).Mandatory:= 'N';
6161: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVBetOV'));
6162: collXMLTable(y).Tagvalue := 0;
6163: --
6164: y:= y+1;
6165: collXMLTable(y).TagName := 'AVLgdWerkl';

Line 6167: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVLgdWerkl'));

6163: --
6164: y:= y+1;
6165: collXMLTable(y).TagName := 'AVLgdWerkl';
6166: collXMLTable(y).Mandatory:= 'N';
6167: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVLgdWerkl'));
6168: collXMLTable(y).Tagvalue := 0;
6169: --
6170: y:= y+1;
6171: collXMLTable(y).TagName := 'AVArboNP';

Line 6173: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVArboNP'));

6169: --
6170: y:= y+1;
6171: collXMLTable(y).TagName := 'AVArboNP';
6172: collXMLTable(y).Mandatory:= 'N';
6173: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVArboNP'));
6174: collXMLTable(y).Tagvalue := 0;
6175: --
6176: y:= y+1;
6177: collXMLTable(y).TagName := 'AVZeev';

Line 6179: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVZeev'));

6175: --
6176: y:= y+1;
6177: collXMLTable(y).TagName := 'AVZeev';
6178: collXMLTable(y).Mandatory:= 'N';
6179: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVZeev'));
6180: collXMLTable(y).Tagvalue := 0;
6181: --
6182: y:= y+1;
6183: collXMLTable(y).TagName := 'AVOnd';

Line 6185: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVOnd'));

6181: --
6182: y:= y+1;
6183: collXMLTable(y).TagName := 'AVOnd';
6184: collXMLTable(y).Mandatory:= 'N';
6185: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVOnd'));
6186: collXMLTable(y).Tagvalue := 0;
6187: --
6188: y:= y+1;
6189: collXMLTable(y).TagName := 'VrlAVSO';

Line 6191: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('VrlAVSO'));

6187: --
6188: y:= y+1;
6189: collXMLTable(y).TagName := 'VrlAVSO';
6190: collXMLTable(y).Mandatory:= 'N';
6191: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('VrlAVSO'));
6192: collXMLTable(y).Tagvalue := 0;
6193: --
6194: y:= y+1;
6195: collXMLTable(y).TagName := 'PrWAOAof';

Line 6198: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof'));

6194: y:= y+1;
6195: collXMLTable(y).TagName := 'PrWAOAof';
6196: collXMLTable(y).Mandatory:= 'N';
6197: IF l_end_date >= to_date('01012007','DDMMYYYY') THEN
6198: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof'));
6199: ELSE
6200: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof_2006'));
6201: END IF;
6202: collXMLTable(y).Tagvalue := 0;

Line 6200: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof_2006'));

6196: collXMLTable(y).Mandatory:= 'N';
6197: IF l_end_date >= to_date('01012007','DDMMYYYY') THEN
6198: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof'));
6199: ELSE
6200: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof_2006'));
6201: END IF;
6202: collXMLTable(y).Tagvalue := 0;
6203: --
6204: y:= y+1;

Line 6213: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrWgaWhk'));

6209: collXMLTable(y).TagName := 'TotPrWgaWhk';
6210: END IF;
6211: collXMLTable(y).Mandatory:= 'Y';
6212: IF l_end_date >= to_date('01012012' ,'DDMMYYYY') THEN
6213: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrWgaWhk'));
6214: ELSIF l_end_date >= to_date('01012007','DDMMYYYY') THEN
6215: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));
6216: ELSE
6217: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));

Line 6215: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));

6211: collXMLTable(y).Mandatory:= 'Y';
6212: IF l_end_date >= to_date('01012012' ,'DDMMYYYY') THEN
6213: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrWgaWhk'));
6214: ELSIF l_end_date >= to_date('01012007','DDMMYYYY') THEN
6215: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));
6216: ELSE
6217: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));
6218: END IF;
6219: --LC 2012 end.

Line 6217: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));

6213: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotPrWgaWhk'));
6214: ELSIF l_end_date >= to_date('01012007','DDMMYYYY') THEN
6215: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));
6216: ELSE
6217: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));
6218: END IF;
6219: --LC 2012 end.
6220: collXMLTable(y).Tagvalue := 0;
6221: --

Line 6225: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrAWF'));

6221: --
6222: y:= y+1;
6223: collXMLTable(y).TagName := 'PrAWF';
6224: collXMLTable(y).Mandatory:= 'N';
6225: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrAWF'));
6226: collXMLTable(y).Tagvalue := 0;
6227: --
6228: y:= y+1;
6229: collXMLTable(y).TagName := 'PrUFO';

Line 6231: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrUFO'));

6227: --
6228: y:= y+1;
6229: collXMLTable(y).TagName := 'PrUFO';
6230: collXMLTable(y).Mandatory:= 'N';
6231: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrUFO'));
6232: collXMLTable(y).Tagvalue := 0;
6233: --
6234: y:= y+1;
6235: collXMLTable(y).TagName := 'IngBijdrZvw';

Line 6237: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('IngBijdrZvw'));

6233: --
6234: y:= y+1;
6235: collXMLTable(y).TagName := 'IngBijdrZvw';
6236: collXMLTable(y).Mandatory:= 'N';
6237: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('IngBijdrZvw'));
6238: collXMLTable(y).Tagvalue := 0;
6239: --
6240: y:= y+1;
6241: collXMLTable(y).TagName := 'AGHKort';

Line 6243: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AGHKort'));

6239: --
6240: y:= y+1;
6241: collXMLTable(y).TagName := 'AGHKort';
6242: collXMLTable(y).Mandatory:= 'N';
6243: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AGHKort'));
6244: collXMLTable(y).Tagvalue := 0;
6245: --
6246: y:= y+1;
6247: collXMLTable(y).TagName := 'TotTeBet';

Line 6249: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotTeBet'));

6245: --
6246: y:= y+1;
6247: collXMLTable(y).TagName := 'TotTeBet';
6248: collXMLTable(y).Mandatory:= 'Y';
6249: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotTeBet'));
6250: collXMLTable(y).Tagvalue := 0;
6251: --
6252: END IF;
6253: --

Line 6433: ,p_action_information5 => HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotGen')) -- TAG DESCRIPTION

6429: ,p_action_information1 => 'TOTAL'
6430: ,p_action_information2 => 'TotGen' -- TAG NAME
6431: ,p_action_information3 => fnd_date.date_to_canonical(l_start_date)
6432: ,p_action_information4 => fnd_date.date_to_canonical(l_end_date)
6433: ,p_action_information5 => HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotGen')) -- TAG DESCRIPTION
6434: ,p_action_information6 => fnd_number.number_to_canonical(ROUND(l_emp_total)));
6435: --
6436: END IF;
6437: --abraghun--7668628--Validation Procedure

Line 7117: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',80,'-') || rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION_REPORT'),20,' ') || rpad('-',80,'-'));

7113:
7114: --abraghun--7668628-- Validation Procedure - Check and Raise Exceptions Ends--
7115:
7116: --# Exception Report
7117: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',80,'-') || rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION_REPORT'),20,' ') || rpad('-',80,'-'));
7118: FND_FILE.PUT_LINE(fnd_file.output,rpad(' ',180,' '));
7119: --
7120: FOR csr_excpetion_rec IN csr_get_PA_exception_info(p_actid) LOOP
7121: --

Line 7127: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EMPLOYER_NAME'),32,' ') ||

7123: --
7124: IF empr_flag = 'N' THEN
7125: --
7126: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
7127: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EMPLOYER_NAME'),32,' ') ||
7128: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),148,' '));
7129: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
7130: empr_flag :='Y';
7131: END IF;

Line 7128: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),148,' '));

7124: IF empr_flag = 'N' THEN
7125: --
7126: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
7127: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EMPLOYER_NAME'),32,' ') ||
7128: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),148,' '));
7129: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
7130: empr_flag :='Y';
7131: END IF;
7132: --

Line 7144: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_ASSIGNMENT_NUMBER'),22,' ') ||

7140: --
7141: IF empe_flag = 'N' THEN
7142: --
7143: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
7144: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_ASSIGNMENT_NUMBER'),22,' ') ||
7145: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_NAME'),32,' ') ||
7146: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_DATE'),13,' ') ||
7147: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),113,' '));
7148: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));

Line 7145: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_NAME'),32,' ') ||

7141: IF empe_flag = 'N' THEN
7142: --
7143: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
7144: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_ASSIGNMENT_NUMBER'),22,' ') ||
7145: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_NAME'),32,' ') ||
7146: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_DATE'),13,' ') ||
7147: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),113,' '));
7148: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
7149: empe_flag := 'Y';

Line 7146: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_DATE'),13,' ') ||

7142: --
7143: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
7144: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_ASSIGNMENT_NUMBER'),22,' ') ||
7145: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_NAME'),32,' ') ||
7146: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_DATE'),13,' ') ||
7147: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),113,' '));
7148: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
7149: empe_flag := 'Y';
7150: END IF;

Line 7147: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),113,' '));

7143: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
7144: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_ASSIGNMENT_NUMBER'),22,' ') ||
7145: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_NAME'),32,' ') ||
7146: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_DATE'),13,' ') ||
7147: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),113,' '));
7148: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
7149: empe_flag := 'Y';
7150: END IF;
7151: --

Line 7157: FND_FILE.PUT_LINE(fnd_file.output , hr_general.decode_lookup('NL_FORM_LABELS','WR_NO_VALIDATION_ERRORS'));

7153: --
7154: END LOOP;
7155: --
7156: IF l_exception_flag = 'N' THEN
7157: FND_FILE.PUT_LINE(fnd_file.output , hr_general.decode_lookup('NL_FORM_LABELS','WR_NO_VALIDATION_ERRORS'));
7158: END IF;
7159: --Fnd_file.put_line(FND_FILE.LOG,' Leaving Deinit Code');
7160: --#
7161: EXCEPTION

Line 14876: l_return_string := l_return_string ||'- '||rpad(HR_GENERAL.decode_lookup('NL_WR_PERIOD_TYPE',l_payroll_type),40);

14872: FETCH csr_chk_exception INTO l_exception;
14873: CLOSE csr_chk_exception;
14874: --
14875: l_return_string := rpad(fnd_date.date_to_displaydate(l_start_date),15)||'- '||rpad(fnd_date.date_to_displaydate(l_end_date),15);
14876: l_return_string := l_return_string ||'- '||rpad(HR_GENERAL.decode_lookup('NL_WR_PERIOD_TYPE',l_payroll_type),40);
14877: l_return_string := l_return_string ||'- '||rpad(l_tax_rep_name,40);
14878: l_return_string := l_return_string ||'- '||rpad(HR_GENERAL.decode_lookup('NL_FORM_LABELS',l_exception),25);
14879: --
14880: RETURN(l_return_string);

Line 14878: l_return_string := l_return_string ||'- '||rpad(HR_GENERAL.decode_lookup('NL_FORM_LABELS',l_exception),25);

14874: --
14875: l_return_string := rpad(fnd_date.date_to_displaydate(l_start_date),15)||'- '||rpad(fnd_date.date_to_displaydate(l_end_date),15);
14876: l_return_string := l_return_string ||'- '||rpad(HR_GENERAL.decode_lookup('NL_WR_PERIOD_TYPE',l_payroll_type),40);
14877: l_return_string := l_return_string ||'- '||rpad(l_tax_rep_name,40);
14878: l_return_string := l_return_string ||'- '||rpad(HR_GENERAL.decode_lookup('NL_FORM_LABELS',l_exception),25);
14879: --
14880: RETURN(l_return_string);
14881: --
14882: END get_archive_details;