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_ATS_REPORT dependencies on PAY_NL_TAXOFFICE_ARCHIVE

Line 284: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);

280: l_tax_year_start_date := to_date('01-01-'||l_year,'DD-MM-YYYY');
281: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
282: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');
283:
284: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
285: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);
286:
287: if p_agg_flag = 'Y' THEN
288: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','Y');

Line 285: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);

281: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
282: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');
283:
284: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
285: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);
286:
287: if p_agg_flag = 'Y' THEN
288: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','Y');
289: else

Line 302: and pay_nl_taxoffice_archive.get_parameter(ppa.legislative_parameters,'EMPLOYER_ID')=to_char(p_employer_id)

298: where ppa.report_qualifier='NL'
299: and ppa.business_group_id=p_bg_id
300: and ppa.report_type='NL_TAXOFFICE_ARCHIVE'
301: and ppa.report_category='ARCHIVE'
302: and pay_nl_taxoffice_archive.get_parameter(ppa.legislative_parameters,'EMPLOYER_ID')=to_char(p_employer_id)
303: and effective_date between l_tax_year_start_date and l_effective_date;
304:
305: EXCEPTION
306:

Line 1881: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);

1877: l_tax_year_start_date := to_date('01-01-'||l_year,'DD-MM-YYYY');
1878: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
1879: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');
1880:
1881: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
1882: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);
1883:
1884: if p_agg_flag = 'Y' THEN
1885: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','Y');

Line 1882: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);

1878: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
1879: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');
1880:
1881: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
1882: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);
1883:
1884: if p_agg_flag = 'Y' THEN
1885: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','Y');
1886: else

Line 1899: and pay_nl_taxoffice_archive.get_parameter(ppa.legislative_parameters,'EMPLOYER_ID')=to_char(p_employer_id)

1895: where ppa.report_qualifier='NL'
1896: and ppa.business_group_id=p_bg_id
1897: and ppa.report_type='NL_TAXOFFICE_ARCHIVE'
1898: and ppa.report_category='ARCHIVE'
1899: and pay_nl_taxoffice_archive.get_parameter(ppa.legislative_parameters,'EMPLOYER_ID')=to_char(p_employer_id)
1900: and effective_date between l_tax_year_start_date and l_effective_date;
1901:
1902: EXCEPTION
1903:

Line 3258: IF PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.count > 0 AND instr(p_User_Bal_String,'|',1,PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.count)=length(p_User_Bal_String) THEN

3254: lCtr := 0;
3255:
3256: hr_utility.set_location('Entered populate_UserBalVal',10);
3257:
3258: IF PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.count > 0 AND instr(p_User_Bal_String,'|',1,PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.count)=length(p_User_Bal_String) THEN
3259:
3260: IF p_agg_flag='N' THEN
3261:
3262: --hr_utility.set_location('Agg flag N in function',20);

Line 3263: --hr_utility.set_location('User table first-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.FIRST||' last-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.LAST||' count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,20);

3259:
3260: IF p_agg_flag='N' THEN
3261:
3262: --hr_utility.set_location('Agg flag N in function',20);
3263: --hr_utility.set_location('User table first-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.FIRST||' last-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.LAST||' count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,20);
3264:
3265: FOR lCtr IN PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.FIRST .. PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.LAST LOOP
3266:
3267: l_end := instr(p_User_Bal_String,'|',l_start,1);

Line 3265: FOR lCtr IN PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.FIRST .. PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.LAST LOOP

3261:
3262: --hr_utility.set_location('Agg flag N in function',20);
3263: --hr_utility.set_location('User table first-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.FIRST||' last-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.LAST||' count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,20);
3264:
3265: FOR lCtr IN PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.FIRST .. PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.LAST LOOP
3266:
3267: l_end := instr(p_User_Bal_String,'|',l_start,1);
3268:
3269: vUserBalVal(lCtr).BalValue := fnd_number.canonical_to_number(substr(p_User_Bal_String,l_start,l_end-l_start));

Line 3270: vUserBalVal(lCtr).TagName := PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable(lCtr).TagName;

3266:
3267: l_end := instr(p_User_Bal_String,'|',l_start,1);
3268:
3269: vUserBalVal(lCtr).BalValue := fnd_number.canonical_to_number(substr(p_User_Bal_String,l_start,l_end-l_start));
3270: vUserBalVal(lCtr).TagName := PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable(lCtr).TagName;
3271:
3272: hr_utility.set_location('tag-'||vUserBalVal(lCtr).TagName,13);
3273: hr_utility.set_location('bal-'||vUserBalVal(lCtr).BalValue,23);
3274:

Line 3281: FOR lCtr IN PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.FIRST .. PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.LAST LOOP

3277: END LOOP;
3278:
3279: ELSIF p_agg_flag='Y' THEN
3280:
3281: FOR lCtr IN PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.FIRST .. PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.LAST LOOP
3282:
3283: l_end := instr(p_User_Bal_String,'|',l_start,1);
3284:
3285: vUserBalVal(lCtr).BalValue := vUserBalVal(lCtr).BalValue + fnd_number.canonical_to_number(substr(p_User_Bal_String,l_start,l_end-l_start));

Line 3286: vUserBalVal(lCtr).TagName := PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable(lCtr).TagName;

3282:
3283: l_end := instr(p_User_Bal_String,'|',l_start,1);
3284:
3285: vUserBalVal(lCtr).BalValue := vUserBalVal(lCtr).BalValue + fnd_number.canonical_to_number(substr(p_User_Bal_String,l_start,l_end-l_start));
3286: vUserBalVal(lCtr).TagName := PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable(lCtr).TagName;
3287:
3288: l_start := l_end + 1;
3289:
3290: END LOOP;