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_KW_MONTHLY_REPORTS dependencies on PAY_BALANCE_PKG

Line 286: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_effective_date));

282:
283:
284:
285: /*Set Contexts and then fetch the balance values*/
286: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_effective_date));
287: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);
288: l_basic_si_base_val := pay_balance_pkg.get_value(l_basic_si_base_id,NULL);
289: l_fm_basic_si_base_val := to_char(l_basic_si_base_val,lg_format_mask);
290:

Line 287: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);

283:
284:
285: /*Set Contexts and then fetch the balance values*/
286: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_effective_date));
287: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);
288: l_basic_si_base_val := pay_balance_pkg.get_value(l_basic_si_base_id,NULL);
289: l_fm_basic_si_base_val := to_char(l_basic_si_base_val,lg_format_mask);
290:
291: vXMLTable(vCtr).TagName := 'R166-B-BASE-D';

Line 288: l_basic_si_base_val := pay_balance_pkg.get_value(l_basic_si_base_id,NULL);

284:
285: /*Set Contexts and then fetch the balance values*/
286: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_effective_date));
287: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);
288: l_basic_si_base_val := pay_balance_pkg.get_value(l_basic_si_base_id,NULL);
289: l_fm_basic_si_base_val := to_char(l_basic_si_base_val,lg_format_mask);
290:
291: vXMLTable(vCtr).TagName := 'R166-B-BASE-D';
292: --vXMLTable(vCtr).TagValue := TRUNC(l_basic_si_base_val);

Line 300: l_supp_si_base_val := pay_balance_pkg.get_value(l_supp_si_base_id,NULL);

296: --vXMLTable(vCtr).TagValue := l_basic_si_base_val - TRUNC(l_basic_si_base_val);
297: vXMLTable(vCtr).TagValue := substr(l_fm_basic_si_base_val,length(l_fm_basic_si_base_val)-2);
298: vctr := vctr + 1;
299:
300: l_supp_si_base_val := pay_balance_pkg.get_value(l_supp_si_base_id,NULL);
301: l_fm_supp_si_base_val := to_char(l_supp_si_base_val,lg_format_mask);
302: vXMLTable(vCtr).TagName := 'R166-S-BASE-D';
303: --vXMLTable(vCtr).TagValue := TRUNC(l_supp_si_base_val);
304: vXMLTable(vCtr).TagValue := substr(l_fm_supp_si_base_val,1,length(l_fm_supp_si_base_val)-4);

Line 311: l_ee_pf_val := pay_balance_pkg.get_value(l_ee_pf_id,NULL);

307: --vXMLTable(vCtr).TagValue := l_supp_si_base_val - TRUNC(l_supp_si_base_val);
308: vXMLTable(vCtr).TagValue := substr(l_fm_supp_si_base_val,length(l_fm_supp_si_base_val)-2);
309: vctr := vctr + 1;
310:
311: l_ee_pf_val := pay_balance_pkg.get_value(l_ee_pf_id,NULL);
312: l_fm_ee_pf_val := to_char(l_ee_pf_val,lg_format_mask);
313: vXMLTable(vCtr).TagName := 'R166-EE-PF-D';
314: --vXMLTable(vCtr).TagValue := TRUNC(l_ee_pf_val);
315: vXMLTable(vCtr).TagValue := substr(l_fm_ee_pf_val,1,length(l_fm_ee_pf_val)-4);

Line 322: l_er_pf_val := pay_balance_pkg.get_value(l_er_pf_id,NULL);

318: --vXMLTable(vCtr).TagValue := l_ee_pf_val - TRUNC(l_ee_pf_val);
319: vXMLTable(vCtr).TagValue := substr(l_fm_ee_pf_val,length(l_fm_ee_pf_val)-2);
320: vctr := vctr + 1;
321:
322: l_er_pf_val := pay_balance_pkg.get_value(l_er_pf_id,NULL);
323: l_fm_er_pf_val := to_char(l_er_pf_val,lg_format_mask);
324: vXMLTable(vCtr).TagName := 'R166-ER-PF-D';
325: --vXMLTable(vCtr).TagValue := TRUNC(l_er_pf_val);
326: vXMLTable(vCtr).TagValue := substr(l_fm_er_pf_val,1,length(l_fm_er_pf_val)-4);

Line 333: /*l_ee_basic_si_val := pay_balance_pkg.get_value(l_ee_basic_si_id,NULL);

329: --vXMLTable(vCtr).TagValue := l_er_pf_val - TRUNC(l_er_pf_val);
330: vXMLTable(vCtr).TagValue := substr(l_fm_er_pf_val,length(l_fm_er_pf_val)-2);
331: vctr := vctr + 1;
332:
333: /*l_ee_basic_si_val := pay_balance_pkg.get_value(l_ee_basic_si_id,NULL);
334: l_ee_supp_si_val := pay_balance_pkg.get_value(l_ee_supp_si_id,NULL);*/
335:
336: l_ee_basic_si_val := pay_balance_pkg.get_value(l_ee_basic_si_id,NULL) + pay_balance_pkg.get_value(l_ee_b_arr_id,NULL);
337: l_ee_supp_si_val := pay_balance_pkg.get_value(l_ee_supp_si_id,NULL) + pay_balance_pkg.get_value(l_ee_s_arr_id,NULL);

Line 334: l_ee_supp_si_val := pay_balance_pkg.get_value(l_ee_supp_si_id,NULL);*/

330: vXMLTable(vCtr).TagValue := substr(l_fm_er_pf_val,length(l_fm_er_pf_val)-2);
331: vctr := vctr + 1;
332:
333: /*l_ee_basic_si_val := pay_balance_pkg.get_value(l_ee_basic_si_id,NULL);
334: l_ee_supp_si_val := pay_balance_pkg.get_value(l_ee_supp_si_id,NULL);*/
335:
336: l_ee_basic_si_val := pay_balance_pkg.get_value(l_ee_basic_si_id,NULL) + pay_balance_pkg.get_value(l_ee_b_arr_id,NULL);
337: l_ee_supp_si_val := pay_balance_pkg.get_value(l_ee_supp_si_id,NULL) + pay_balance_pkg.get_value(l_ee_s_arr_id,NULL);
338:

Line 336: l_ee_basic_si_val := pay_balance_pkg.get_value(l_ee_basic_si_id,NULL) + pay_balance_pkg.get_value(l_ee_b_arr_id,NULL);

332:
333: /*l_ee_basic_si_val := pay_balance_pkg.get_value(l_ee_basic_si_id,NULL);
334: l_ee_supp_si_val := pay_balance_pkg.get_value(l_ee_supp_si_id,NULL);*/
335:
336: l_ee_basic_si_val := pay_balance_pkg.get_value(l_ee_basic_si_id,NULL) + pay_balance_pkg.get_value(l_ee_b_arr_id,NULL);
337: l_ee_supp_si_val := pay_balance_pkg.get_value(l_ee_supp_si_id,NULL) + pay_balance_pkg.get_value(l_ee_s_arr_id,NULL);
338:
339: IF l_ee_basic_si_val <> 0 THEN
340: l_ee_b := l_ee_basic_si_val - ((l_ee_basic_si_val/(l_ee_basic_si_val+l_ee_supp_si_val))*l_ee_pf_val);

Line 337: l_ee_supp_si_val := pay_balance_pkg.get_value(l_ee_supp_si_id,NULL) + pay_balance_pkg.get_value(l_ee_s_arr_id,NULL);

333: /*l_ee_basic_si_val := pay_balance_pkg.get_value(l_ee_basic_si_id,NULL);
334: l_ee_supp_si_val := pay_balance_pkg.get_value(l_ee_supp_si_id,NULL);*/
335:
336: l_ee_basic_si_val := pay_balance_pkg.get_value(l_ee_basic_si_id,NULL) + pay_balance_pkg.get_value(l_ee_b_arr_id,NULL);
337: l_ee_supp_si_val := pay_balance_pkg.get_value(l_ee_supp_si_id,NULL) + pay_balance_pkg.get_value(l_ee_s_arr_id,NULL);
338:
339: IF l_ee_basic_si_val <> 0 THEN
340: l_ee_b := l_ee_basic_si_val - ((l_ee_basic_si_val/(l_ee_basic_si_val+l_ee_supp_si_val))*l_ee_pf_val);
341: ELSE

Line 370: l_er_basic_si_val := pay_balance_pkg.get_value(l_er_basic_si_id,NULL);

366: --vXMLTable(vCtr).TagValue := l_ee_s - TRUNC(l_ee_s);
367: vXMLTable(vCtr).TagValue := substr(l_fm_ee_s,length(l_fm_ee_s)-2);
368: vctr := vctr + 1;
369:
370: l_er_basic_si_val := pay_balance_pkg.get_value(l_er_basic_si_id,NULL);
371: l_er_supp_si_val := pay_balance_pkg.get_value(l_er_supp_si_id,NULL);
372:
373: IF l_er_basic_si_val <> 0 THEN
374: l_er_b := l_er_basic_si_val - ((l_er_basic_si_val/(l_er_basic_si_val+l_er_supp_si_val))*l_er_pf_val);

Line 371: l_er_supp_si_val := pay_balance_pkg.get_value(l_er_supp_si_id,NULL);

367: vXMLTable(vCtr).TagValue := substr(l_fm_ee_s,length(l_fm_ee_s)-2);
368: vctr := vctr + 1;
369:
370: l_er_basic_si_val := pay_balance_pkg.get_value(l_er_basic_si_id,NULL);
371: l_er_supp_si_val := pay_balance_pkg.get_value(l_er_supp_si_id,NULL);
372:
373: IF l_er_basic_si_val <> 0 THEN
374: l_er_b := l_er_basic_si_val - ((l_er_basic_si_val/(l_er_basic_si_val+l_er_supp_si_val))*l_er_pf_val);
375: ELSE

Line 404: l_add_si_val := pay_balance_pkg.get_value(l_add_si_id,NULL) + pay_balance_pkg.get_value(l_add_arr_id,NULL);

400: --vXMLTable(vCtr).TagValue := l_er_s - TRUNC(l_er_s);
401: vXMLTable(vCtr).TagValue := substr(l_fm_er_s,length(l_fm_er_s)-2);
402: vctr := vctr + 1;
403:
404: l_add_si_val := pay_balance_pkg.get_value(l_add_si_id,NULL) + pay_balance_pkg.get_value(l_add_arr_id,NULL);
405:
406:
407: /*Code added to sum the total of Report167 as per the enhancement to Report167*/
408: DECLARE

Line 760: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_effective_date));

756: FETCH csr_get_def_bal_id INTO l_add_si_arr_id;
757: CLOSE csr_get_def_bal_id;
758:
759: /*Set Contexts and then fetch the balance values*/
760: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_effective_date));
761: l_total_amount := 0;
762: l_add_si_val := 0;
763: i := 0;
764:

Line 770: l_add_si_val := pay_balance_pkg.get_value(l_add_si_id,rec_get_emp.assignment_action_id) +

766: LOOP
767: FETCH csr_get_emp INTO rec_get_emp;
768: EXIT WHEN csr_get_emp%NOTFOUND;
769: l_add_si_val := 0;
770: l_add_si_val := pay_balance_pkg.get_value(l_add_si_id,rec_get_emp.assignment_action_id) +
771: pay_balance_pkg.get_value(l_add_si_arr_id,rec_get_emp.assignment_action_id);
772: IF l_add_si_val > 0 THEN
773:
774: i := i + 1;

Line 771: pay_balance_pkg.get_value(l_add_si_arr_id,rec_get_emp.assignment_action_id);

767: FETCH csr_get_emp INTO rec_get_emp;
768: EXIT WHEN csr_get_emp%NOTFOUND;
769: l_add_si_val := 0;
770: l_add_si_val := pay_balance_pkg.get_value(l_add_si_id,rec_get_emp.assignment_action_id) +
771: pay_balance_pkg.get_value(l_add_si_arr_id,rec_get_emp.assignment_action_id);
772: IF l_add_si_val > 0 THEN
773:
774: i := i + 1;
775: l_full_name := NULL;

Line 1278: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_effective_date));

1274: FETCH csr_get_def_bal_id INTO l_add_si_arr_id;
1275: CLOSE csr_get_def_bal_id;*/
1276:
1277: /*Set Contexts and then fetch the balance values*/
1278: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_effective_date));
1279: l_total_amount := 0;
1280: l_add_si_val := 0;
1281: i := 0;
1282:

Line 1288: /*l_add_si_val := pay_balance_pkg.get_value(l_add_si_id,rec_get_emp.assignment_action_id) +

1284: LOOP
1285: FETCH csr_get_emp INTO rec_get_emp;
1286: EXIT WHEN csr_get_emp%NOTFOUND;
1287: l_add_si_val := 0;
1288: /*l_add_si_val := pay_balance_pkg.get_value(l_add_si_id,rec_get_emp.assignment_action_id) +
1289: pay_balance_pkg.get_value(l_add_si_arr_id,rec_get_emp.assignment_action_id);*/
1290: l_emp_tot_val := 0;
1291: l_jps_b_val := 0;
1292: l_ul_b_val := 0;

Line 1289: pay_balance_pkg.get_value(l_add_si_arr_id,rec_get_emp.assignment_action_id);*/

1285: FETCH csr_get_emp INTO rec_get_emp;
1286: EXIT WHEN csr_get_emp%NOTFOUND;
1287: l_add_si_val := 0;
1288: /*l_add_si_val := pay_balance_pkg.get_value(l_add_si_id,rec_get_emp.assignment_action_id) +
1289: pay_balance_pkg.get_value(l_add_si_arr_id,rec_get_emp.assignment_action_id);*/
1290: l_emp_tot_val := 0;
1291: l_jps_b_val := 0;
1292: l_ul_b_val := 0;
1293: l_ci_b_val := 0;

Line 1921: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,rec_get_cha_emp.assignment_action_id);

1917: FETCH csr_get_cha_emp INTO rec_get_cha_emp;
1918: EXIT WHEN csr_get_cha_emp%NOTFOUND;
1919: l_diff_exist := 0;
1920: l_subject_si_val := 0;
1921: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,rec_get_cha_emp.assignment_action_id);
1922: l_salary_effective_date := rec_get_cha_emp.date_earned;
1923: OPEN csr_get_salary_date (rec_get_cha_emp.person_id);
1924: LOOP
1925: FETCH csr_get_salary_date INTO rec_get_salary_date;

Line 1927: l_prev_salary := pay_balance_pkg.get_value(l_subject_si_id,rec_get_salary_date.assignment_action_id);

1923: OPEN csr_get_salary_date (rec_get_cha_emp.person_id);
1924: LOOP
1925: FETCH csr_get_salary_date INTO rec_get_salary_date;
1926: EXIT WHEN csr_get_salary_date%NOTFOUND;
1927: l_prev_salary := pay_balance_pkg.get_value(l_subject_si_id,rec_get_salary_date.assignment_action_id);
1928: IF l_prev_salary <> l_subject_si_val THEN
1929: l_diff_exist := 1;
1930: EXIT;
1931: END IF;

Line 1973: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,t_new_store_assact(j).assignment_action_id);

1969: l_new_count := 0;
1970: WHILE j <= i LOOP
1971:
1972: l_subject_si_val := 0;
1973: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,t_new_store_assact(j).assignment_action_id);
1974: l_civil_id := NULL;
1975: l_full_name := NULL;
1976: OPEN csr_get_emp_name(t_new_store_assact(j).person_id);
1977: FETCH csr_get_emp_name INTO /*l_full_name,*/ l_civil_id;

Line 2027: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,t_ter_store_assact(l).assignment_action_id);

2023: --Writing data for terminated employees
2024: l_new_count := 0;
2025: WHILE l <= k LOOP
2026: l_subject_si_val := 0;
2027: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,t_ter_store_assact(l).assignment_action_id);
2028: l_civil_id := NULL;
2029: l_full_name := NULL;
2030: OPEN csr_get_emp_name(t_ter_store_assact(l).person_id);
2031: FETCH csr_get_emp_name INTO /*l_full_name,*/ l_civil_id;

Line 2070: l_prev_salary := pay_balance_pkg.get_value(l_subject_si_id,rec_get_salary_date.assignment_action_id);

2066: OPEN csr_get_salary_date (t_ter_store_assact(l).person_id);
2067: LOOP
2068: FETCH csr_get_salary_date INTO rec_get_salary_date;
2069: EXIT WHEN csr_get_salary_date%NOTFOUND;
2070: l_prev_salary := pay_balance_pkg.get_value(l_subject_si_id,rec_get_salary_date.assignment_action_id);
2071: IF l_prev_salary <> l_subject_si_val THEN
2072: EXIT;
2073: ELSE
2074: l_salary_effective_date := rec_get_salary_date.date_earned;

Line 2097: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,t_cha_store_assact(n).assignment_action_id);

2093: --Writing data for employees with changed salary
2094: l_new_count := 0;
2095: WHILE n <= m LOOP
2096: l_subject_si_val := 0;
2097: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,t_cha_store_assact(n).assignment_action_id);
2098: l_civil_id := NULL;
2099: l_full_name := NULL;
2100: OPEN csr_get_emp_name(t_cha_store_assact(n).person_id);
2101: FETCH csr_get_emp_name INTO /*l_full_name,*/ l_civil_id;