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 300: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);

296: l_tax_year_start_date := to_date('01-01-'||l_year,'DD-MM-YYYY');
297: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
298: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');
299:
300: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
301: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);
302:
303: if p_agg_flag = 'Y' THEN
304: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','Y');

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

297: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
298: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');
299:
300: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
301: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);
302:
303: if p_agg_flag = 'Y' THEN
304: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','Y');
305: else

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

314: where ppa.report_qualifier='NL'
315: and ppa.business_group_id=p_bg_id
316: and ppa.report_type='NL_TAXOFFICE_ARCHIVE'
317: and ppa.report_category='ARCHIVE'
318: and pay_nl_taxoffice_archive.get_parameter(ppa.legislative_parameters,'EMPLOYER_ID')=to_char(p_employer_id)
319: and effective_date between l_tax_year_start_date and l_effective_date;
320:
321: EXCEPTION
322:

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

1924: l_tax_year_start_date := to_date('01-01-'||l_year,'DD-MM-YYYY');
1925: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
1926: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');
1927:
1928: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
1929: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);
1930:
1931: if p_agg_flag = 'Y' THEN
1932: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','Y');

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

1925: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
1926: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');
1927:
1928: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
1929: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);
1930:
1931: if p_agg_flag = 'Y' THEN
1932: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','Y');
1933: else

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

1942: where ppa.report_qualifier='NL'
1943: and ppa.business_group_id=p_bg_id
1944: and ppa.report_type='NL_TAXOFFICE_ARCHIVE'
1945: and ppa.report_category='ARCHIVE'
1946: and pay_nl_taxoffice_archive.get_parameter(ppa.legislative_parameters,'EMPLOYER_ID')=to_char(p_employer_id)
1947: and effective_date between l_tax_year_start_date and l_effective_date;
1948:
1949: EXCEPTION
1950:

Line 3320: 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

3316: lCtr := 0;
3317:
3318: hr_utility.set_location('Entered populate_UserBalVal',10);
3319:
3320: 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
3321:
3322: IF p_agg_flag='N' THEN
3323:
3324: --hr_utility.set_location('Agg flag N in function',20);

Line 3325: --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);

3321:
3322: IF p_agg_flag='N' THEN
3323:
3324: --hr_utility.set_location('Agg flag N in function',20);
3325: --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);
3326:
3327: FOR lCtr IN PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.FIRST .. PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.LAST LOOP
3328:
3329: l_end := instr(p_User_Bal_String,'|',l_start,1);

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

3323:
3324: --hr_utility.set_location('Agg flag N in function',20);
3325: --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);
3326:
3327: FOR lCtr IN PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.FIRST .. PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.LAST LOOP
3328:
3329: l_end := instr(p_User_Bal_String,'|',l_start,1);
3330:
3331: vUserBalVal(lCtr).BalValue := fnd_number.canonical_to_number(substr(p_User_Bal_String,l_start,l_end-l_start));

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

3328:
3329: l_end := instr(p_User_Bal_String,'|',l_start,1);
3330:
3331: vUserBalVal(lCtr).BalValue := fnd_number.canonical_to_number(substr(p_User_Bal_String,l_start,l_end-l_start));
3332: vUserBalVal(lCtr).TagName := PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable(lCtr).TagName;
3333:
3334: hr_utility.set_location('tag-'||vUserBalVal(lCtr).TagName,13);
3335: hr_utility.set_location('bal-'||vUserBalVal(lCtr).BalValue,23);
3336:

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

3339: END LOOP;
3340:
3341: ELSIF p_agg_flag='Y' THEN
3342:
3343: FOR lCtr IN PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.FIRST .. PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.LAST LOOP
3344:
3345: l_end := instr(p_User_Bal_String,'|',l_start,1);
3346:
3347: vUserBalVal(lCtr).BalValue := vUserBalVal(lCtr).BalValue + fnd_number.canonical_to_number(substr(p_User_Bal_String,l_start,l_end-l_start));

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

3344:
3345: l_end := instr(p_User_Bal_String,'|',l_start,1);
3346:
3347: vUserBalVal(lCtr).BalValue := vUserBalVal(lCtr).BalValue + fnd_number.canonical_to_number(substr(p_User_Bal_String,l_start,l_end-l_start));
3348: vUserBalVal(lCtr).TagName := PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable(lCtr).TagName;
3349:
3350: l_start := l_end + 1;
3351:
3352: END LOOP;