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 313: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_effective_date));

309:
310:
311:
312: /*Set Contexts and then fetch the balance values*/
313: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_effective_date));
314: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);
315: l_basic_si_base_val := pay_balance_pkg.get_value(l_basic_si_base_id,NULL);
316: l_fm_basic_si_base_val := to_char(l_basic_si_base_val,lg_format_mask);
317:

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

310:
311:
312: /*Set Contexts and then fetch the balance values*/
313: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_effective_date));
314: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);
315: l_basic_si_base_val := pay_balance_pkg.get_value(l_basic_si_base_id,NULL);
316: l_fm_basic_si_base_val := to_char(l_basic_si_base_val,lg_format_mask);
317:
318: vXMLTable(vCtr).TagName := 'R166-B-BASE-D';

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

311:
312: /*Set Contexts and then fetch the balance values*/
313: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_effective_date));
314: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);
315: l_basic_si_base_val := pay_balance_pkg.get_value(l_basic_si_base_id,NULL);
316: l_fm_basic_si_base_val := to_char(l_basic_si_base_val,lg_format_mask);
317:
318: vXMLTable(vCtr).TagName := 'R166-B-BASE-D';
319: --vXMLTable(vCtr).TagValue := TRUNC(l_basic_si_base_val);

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

323: --vXMLTable(vCtr).TagValue := l_basic_si_base_val - TRUNC(l_basic_si_base_val);
324: vXMLTable(vCtr).TagValue := substr(l_fm_basic_si_base_val,length(l_fm_basic_si_base_val)-2);
325: vctr := vctr + 1;
326:
327: l_supp_si_base_val := pay_balance_pkg.get_value(l_supp_si_base_id,NULL);
328: l_fm_supp_si_base_val := to_char(l_supp_si_base_val,lg_format_mask);
329: vXMLTable(vCtr).TagName := 'R166-S-BASE-D';
330: --vXMLTable(vCtr).TagValue := TRUNC(l_supp_si_base_val);
331: vXMLTable(vCtr).TagValue := substr(l_fm_supp_si_base_val,1,length(l_fm_supp_si_base_val)-4);

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

334: --vXMLTable(vCtr).TagValue := l_supp_si_base_val - TRUNC(l_supp_si_base_val);
335: vXMLTable(vCtr).TagValue := substr(l_fm_supp_si_base_val,length(l_fm_supp_si_base_val)-2);
336: vctr := vctr + 1;
337:
338: l_ee_pf_val := pay_balance_pkg.get_value(l_ee_pf_id,NULL);
339: l_fm_ee_pf_val := to_char(l_ee_pf_val,lg_format_mask);
340: vXMLTable(vCtr).TagName := 'R166-EE-PF-D';
341: --vXMLTable(vCtr).TagValue := TRUNC(l_ee_pf_val);
342: vXMLTable(vCtr).TagValue := substr(l_fm_ee_pf_val,1,length(l_fm_ee_pf_val)-4);

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

345: --vXMLTable(vCtr).TagValue := l_ee_pf_val - TRUNC(l_ee_pf_val);
346: vXMLTable(vCtr).TagValue := substr(l_fm_ee_pf_val,length(l_fm_ee_pf_val)-2);
347: vctr := vctr + 1;
348:
349: l_er_pf_val := pay_balance_pkg.get_value(l_er_pf_id,NULL);
350: l_fm_er_pf_val := to_char(l_er_pf_val,lg_format_mask);
351: vXMLTable(vCtr).TagName := 'R166-ER-PF-D';
352: --vXMLTable(vCtr).TagValue := TRUNC(l_er_pf_val);
353: vXMLTable(vCtr).TagValue := substr(l_fm_er_pf_val,1,length(l_fm_er_pf_val)-4);

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

371: vctr := vctr + 1;
372:
373: /* end 2012 */
374:
375: /*l_ee_basic_si_val := pay_balance_pkg.get_value(l_ee_basic_si_id,NULL);
376: l_ee_supp_si_val := pay_balance_pkg.get_value(l_ee_supp_si_id,NULL);*/
377:
378: 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);
379: 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 376: l_ee_supp_si_val := pay_balance_pkg.get_value(l_ee_supp_si_id,NULL);*/

372:
373: /* end 2012 */
374:
375: /*l_ee_basic_si_val := pay_balance_pkg.get_value(l_ee_basic_si_id,NULL);
376: l_ee_supp_si_val := pay_balance_pkg.get_value(l_ee_supp_si_id,NULL);*/
377:
378: 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);
379: 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);
380:

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

374:
375: /*l_ee_basic_si_val := pay_balance_pkg.get_value(l_ee_basic_si_id,NULL);
376: l_ee_supp_si_val := pay_balance_pkg.get_value(l_ee_supp_si_id,NULL);*/
377:
378: 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);
379: 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);
380:
381: IF l_ee_basic_si_val <> 0 THEN
382: 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 379: 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);

375: /*l_ee_basic_si_val := pay_balance_pkg.get_value(l_ee_basic_si_id,NULL);
376: l_ee_supp_si_val := pay_balance_pkg.get_value(l_ee_supp_si_id,NULL);*/
377:
378: 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);
379: 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);
380:
381: IF l_ee_basic_si_val <> 0 THEN
382: 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);
383: ELSE

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

408: --vXMLTable(vCtr).TagValue := l_ee_s - TRUNC(l_ee_s);
409: vXMLTable(vCtr).TagValue := substr(l_fm_ee_s,length(l_fm_ee_s)-2);
410: vctr := vctr + 1;
411:
412: l_er_basic_si_val := pay_balance_pkg.get_value(l_er_basic_si_id,NULL);
413: l_er_supp_si_val := pay_balance_pkg.get_value(l_er_supp_si_id,NULL);
414:
415: IF l_er_basic_si_val <> 0 THEN
416: 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 413: l_er_supp_si_val := pay_balance_pkg.get_value(l_er_supp_si_id,NULL);

409: vXMLTable(vCtr).TagValue := substr(l_fm_ee_s,length(l_fm_ee_s)-2);
410: vctr := vctr + 1;
411:
412: l_er_basic_si_val := pay_balance_pkg.get_value(l_er_basic_si_id,NULL);
413: l_er_supp_si_val := pay_balance_pkg.get_value(l_er_supp_si_id,NULL);
414:
415: IF l_er_basic_si_val <> 0 THEN
416: 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);
417: ELSE

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

468: vctr := vctr + 1;
469:
470: /* end 2012 */
471:
472: l_add_si_val := pay_balance_pkg.get_value(l_add_si_id,NULL) + pay_balance_pkg.get_value(l_add_arr_id,NULL);
473:
474:
475: /*Code added to sum the total of Report167 as per the enhancement to Report167*/
476: DECLARE

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

907: FETCH csr_get_def_bal_id INTO l_add_si_arr_id;
908: CLOSE csr_get_def_bal_id;
909:
910: /*Set Contexts and then fetch the balance values*/
911: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_effective_date));
912: l_total_amount := 0;
913: l_add_si_val := 0;
914: i := 0;
915:

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

917: LOOP
918: FETCH csr_get_emp INTO rec_get_emp;
919: EXIT WHEN csr_get_emp%NOTFOUND;
920: l_add_si_val := 0;
921: l_add_si_val := pay_balance_pkg.get_value(l_add_si_id,rec_get_emp.assignment_action_id) +
922: pay_balance_pkg.get_value(l_add_si_arr_id,rec_get_emp.assignment_action_id);
923: IF l_add_si_val > 0 THEN
924:
925: i := i + 1;

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

918: FETCH csr_get_emp INTO rec_get_emp;
919: EXIT WHEN csr_get_emp%NOTFOUND;
920: l_add_si_val := 0;
921: l_add_si_val := pay_balance_pkg.get_value(l_add_si_id,rec_get_emp.assignment_action_id) +
922: pay_balance_pkg.get_value(l_add_si_arr_id,rec_get_emp.assignment_action_id);
923: IF l_add_si_val > 0 THEN
924:
925: i := i + 1;
926: l_full_name := NULL;

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

1425: FETCH csr_get_def_bal_id INTO l_add_si_arr_id;
1426: CLOSE csr_get_def_bal_id;*/
1427:
1428: /*Set Contexts and then fetch the balance values*/
1429: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_effective_date));
1430: l_total_amount := 0;
1431: l_add_si_val := 0;
1432: i := 0;
1433:

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

1435: LOOP
1436: FETCH csr_get_emp INTO rec_get_emp;
1437: EXIT WHEN csr_get_emp%NOTFOUND;
1438: l_add_si_val := 0;
1439: /*l_add_si_val := pay_balance_pkg.get_value(l_add_si_id,rec_get_emp.assignment_action_id) +
1440: pay_balance_pkg.get_value(l_add_si_arr_id,rec_get_emp.assignment_action_id);*/
1441: l_emp_tot_val := 0;
1442: l_jps_b_val := 0;
1443: l_ul_b_val := 0;

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

1436: FETCH csr_get_emp INTO rec_get_emp;
1437: EXIT WHEN csr_get_emp%NOTFOUND;
1438: l_add_si_val := 0;
1439: /*l_add_si_val := pay_balance_pkg.get_value(l_add_si_id,rec_get_emp.assignment_action_id) +
1440: pay_balance_pkg.get_value(l_add_si_arr_id,rec_get_emp.assignment_action_id);*/
1441: l_emp_tot_val := 0;
1442: l_jps_b_val := 0;
1443: l_ul_b_val := 0;
1444: l_ci_b_val := 0;

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

2152: FETCH csr_get_cha_emp INTO rec_get_cha_emp;
2153: EXIT WHEN csr_get_cha_emp%NOTFOUND;
2154: l_diff_exist := 0;
2155: l_subject_si_val := 0;
2156: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,rec_get_cha_emp.assignment_action_id);
2157: l_salary_effective_date := rec_get_cha_emp.date_earned;
2158: OPEN csr_get_salary_date (rec_get_cha_emp.person_id);
2159: LOOP
2160: FETCH csr_get_salary_date INTO rec_get_salary_date;

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

2158: OPEN csr_get_salary_date (rec_get_cha_emp.person_id);
2159: LOOP
2160: FETCH csr_get_salary_date INTO rec_get_salary_date;
2161: EXIT WHEN csr_get_salary_date%NOTFOUND;
2162: l_prev_salary := pay_balance_pkg.get_value(l_subject_si_id,rec_get_salary_date.assignment_action_id);
2163: IF l_prev_salary <> l_subject_si_val THEN
2164: l_diff_exist := 1;
2165: EXIT;
2166: END IF;

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

2207: l_new_count := 0;
2208: WHILE j <= i LOOP
2209:
2210: l_subject_si_val := 0;
2211: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,t_new_store_assact(j).assignment_action_id);
2212: l_civil_id := NULL;
2213: l_full_name := NULL;
2214: OPEN csr_get_emp_name(t_new_store_assact(j).person_id);
2215: FETCH csr_get_emp_name INTO /*l_full_name,*/ l_civil_id;

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

2261: --Writing data for terminated employees
2262: l_new_count := 0;
2263: WHILE l <= k LOOP
2264: l_subject_si_val := 0;
2265: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,t_ter_store_assact(l).assignment_action_id);
2266: l_civil_id := NULL;
2267: l_full_name := NULL;
2268: OPEN csr_get_emp_name(t_ter_store_assact(l).person_id);
2269: FETCH csr_get_emp_name INTO /*l_full_name,*/ l_civil_id;

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

2306: OPEN csr_get_salary_date (t_ter_store_assact(l).person_id);
2307: LOOP
2308: FETCH csr_get_salary_date INTO rec_get_salary_date;
2309: EXIT WHEN csr_get_salary_date%NOTFOUND;
2310: l_prev_salary := pay_balance_pkg.get_value(l_subject_si_id,rec_get_salary_date.assignment_action_id);
2311: IF l_prev_salary <> l_subject_si_val THEN
2312: EXIT;
2313: ELSE
2314: l_salary_effective_date := rec_get_salary_date.date_earned;

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

2333: --Writing data for employees with changed salary
2334: l_new_count := 0;
2335: WHILE n <= m LOOP
2336: l_subject_si_val := 0;
2337: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,t_cha_store_assact(n).assignment_action_id);
2338: l_civil_id := NULL;
2339: l_full_name := NULL;
2340: OPEN csr_get_emp_name(t_cha_store_assact(n).person_id);
2341: FETCH csr_get_emp_name INTO /*l_full_name,*/ l_civil_id;

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

2386: l_new_count := 0;
2387: -- WHILE j <= i or l <= k LOOP /*loop for both new and terminated sicne now we report both in a single table */
2388: while j <= i loop
2389: l_subject_si_val := 0;
2390: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,t_new_store_assact(j).assignment_action_id);
2391: l_civil_id := NULL;
2392: l_full_name := NULL;
2393:
2394: hr_utility.set_location('l_subject_si_val'|| l_subject_si_val,30);

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

2454: EXIT;
2455: END IF;
2456:
2457: l_subject_si_val := 0;
2458: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,t_ter_store_assact(l).assignment_action_id);
2459: l_civil_id := NULL;
2460: l_full_name := NULL;
2461:
2462: OPEN csr_get_emp_name(t_ter_store_assact(l).person_id);

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

2507: OPEN csr_get_salary_date (t_ter_store_assact(l).person_id);
2508: LOOP
2509: FETCH csr_get_salary_date INTO rec_get_salary_date;
2510: EXIT WHEN csr_get_salary_date%NOTFOUND;
2511: l_prev_salary := pay_balance_pkg.get_value(l_subject_si_id,rec_get_salary_date.assignment_action_id);
2512: IF l_prev_salary <> l_subject_si_val THEN
2513: EXIT;
2514: ELSE
2515: l_salary_effective_date := rec_get_salary_date.date_earned;

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

2541: l_new_count := 0;
2542: WHILE n <= m LOOP
2543: hr_utility.set_location('BPK Writing data for employees with changed salary',30);
2544: l_subject_si_val := 0;
2545: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,t_cha_store_assact(n).assignment_action_id);
2546: l_civil_id := NULL;
2547: l_full_name := NULL;
2548: l_assact_one := null;
2549:

Line 2570: l_first_social := pay_balance_pkg.get_value(l_social_id,l_assact_one);

2566: hr_utility.set_location('l_social_id'|| l_social_id ,30);
2567: hr_utility.set_location('l_assact_one'|| l_assact_one ,30);
2568: If l_social_id is not null THEN
2569: If l_assact_one is not null then
2570: l_first_social := pay_balance_pkg.get_value(l_social_id,l_assact_one);
2571: Else
2572: l_first_social := 0;
2573: End If;
2574: Else