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

Line 1106: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);

1102:
1103: IF l_cont_area IS NULL THEN
1104: -- Check the assignment's Contribution area is same as the concurrent parameter
1105: -- Set the contexts
1106: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);
1107: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
1108:
1109: -- Run the DBI
1110: l_cont_area := pay_balance_pkg.run_db_item('SCL_ASG_CN_SIC_AREA',p_business_group_id,'CN');

Line 1107: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));

1103: IF l_cont_area IS NULL THEN
1104: -- Check the assignment's Contribution area is same as the concurrent parameter
1105: -- Set the contexts
1106: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);
1107: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
1108:
1109: -- Run the DBI
1110: l_cont_area := pay_balance_pkg.run_db_item('SCL_ASG_CN_SIC_AREA',p_business_group_id,'CN');
1111:

Line 1110: l_cont_area := pay_balance_pkg.run_db_item('SCL_ASG_CN_SIC_AREA',p_business_group_id,'CN');

1106: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);
1107: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
1108:
1109: -- Run the DBI
1110: l_cont_area := pay_balance_pkg.run_db_item('SCL_ASG_CN_SIC_AREA',p_business_group_id,'CN');
1111:
1112: hr_utility.set_location('China : l_cont_area -> '|| l_cont_area, 80);
1113:
1114: END IF;

Line 1340: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);

1336:
1337: IF l_cont_area IS NULL THEN
1338: -- Check the assignment's Contribution area is same as the concurrent parameter
1339: -- Set the contexts
1340: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);
1341: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
1342:
1343: -- Run the DBI
1344: l_cont_area := pay_balance_pkg.run_db_item('SCL_ASG_CN_SIC_AREA',p_business_group_id,'CN');

Line 1341: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));

1337: IF l_cont_area IS NULL THEN
1338: -- Check the assignment's Contribution area is same as the concurrent parameter
1339: -- Set the contexts
1340: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);
1341: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
1342:
1343: -- Run the DBI
1344: l_cont_area := pay_balance_pkg.run_db_item('SCL_ASG_CN_SIC_AREA',p_business_group_id,'CN');
1345:

Line 1344: l_cont_area := pay_balance_pkg.run_db_item('SCL_ASG_CN_SIC_AREA',p_business_group_id,'CN');

1340: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);
1341: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
1342:
1343: -- Run the DBI
1344: l_cont_area := pay_balance_pkg.run_db_item('SCL_ASG_CN_SIC_AREA',p_business_group_id,'CN');
1345:
1346: hr_utility.set_location('China : l_cont_area -> '|| l_cont_area, 80);
1347:
1348: END IF;

Line 1642: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);

1638:
1639: IF l_cont_area IS NULL THEN
1640: -- Check the assignment's Contribution area is same as the concurrent parameter
1641: -- Set the contexts
1642: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);
1643: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
1644:
1645: -- Run the DBI
1646: l_cont_area := pay_balance_pkg.run_db_item('SCL_ASG_CN_SIC_AREA',p_business_group_id,'CN');

Line 1643: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));

1639: IF l_cont_area IS NULL THEN
1640: -- Check the assignment's Contribution area is same as the concurrent parameter
1641: -- Set the contexts
1642: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);
1643: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
1644:
1645: -- Run the DBI
1646: l_cont_area := pay_balance_pkg.run_db_item('SCL_ASG_CN_SIC_AREA',p_business_group_id,'CN');
1647:

Line 1646: l_cont_area := pay_balance_pkg.run_db_item('SCL_ASG_CN_SIC_AREA',p_business_group_id,'CN');

1642: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);
1643: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
1644:
1645: -- Run the DBI
1646: l_cont_area := pay_balance_pkg.run_db_item('SCL_ASG_CN_SIC_AREA',p_business_group_id,'CN');
1647:
1648: hr_utility.set_location('China : l_cont_area -> '|| l_cont_area, 70);
1649:
1650: END IF;

Line 2720: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_date_earned));

2716:
2717: hr_utility.set_location('China : Date Earned ->' || l_date_earned, 60);
2718:
2719: -- Set context
2720: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_date_earned));
2721:
2722: -- Get the value
2723: l_bal_value := pay_balance_pkg.get_value ( p_defined_balance_id => l_defined_balance_id
2724: , p_assignment_action_id => l_assignment_action_id);

Line 2723: l_bal_value := pay_balance_pkg.get_value ( p_defined_balance_id => l_defined_balance_id

2719: -- Set context
2720: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_date_earned));
2721:
2722: -- Get the value
2723: l_bal_value := pay_balance_pkg.get_value ( p_defined_balance_id => l_defined_balance_id
2724: , p_assignment_action_id => l_assignment_action_id);
2725:
2726: ELSE
2727: hr_utility.set_location('China : Assignment action id -> ' || l_assignment_action_id, 55);

Line 2762: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_date_earned));

2758:
2759: hr_utility.set_location('China : Date Earned ->', 60);
2760:
2761: -- Set context
2762: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_date_earned));
2763:
2764: -- Get the value
2765: l_bal_value := pay_balance_pkg.get_value ( p_defined_balance_id => l_defined_balance_id
2766: , p_assignment_action_id => l_assignment_action_id);

Line 2765: l_bal_value := pay_balance_pkg.get_value ( p_defined_balance_id => l_defined_balance_id

2761: -- Set context
2762: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_date_earned));
2763:
2764: -- Get the value
2765: l_bal_value := pay_balance_pkg.get_value ( p_defined_balance_id => l_defined_balance_id
2766: , p_assignment_action_id => l_assignment_action_id);
2767:
2768: -- Set Assignment ID Context
2769: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);

Line 2769: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);

2765: l_bal_value := pay_balance_pkg.get_value ( p_defined_balance_id => l_defined_balance_id
2766: , p_assignment_action_id => l_assignment_action_id);
2767:
2768: -- Set Assignment ID Context
2769: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);
2770:
2771: -- Fetch Number of runs in Previous Year
2772: --
2773: l_no_of_runs := pay_balance_pkg.run_db_item('CN_PAYROLL_RUN_MONTHS_PREV_YEAR',p_business_group_id,'CN');

Line 2773: l_no_of_runs := pay_balance_pkg.run_db_item('CN_PAYROLL_RUN_MONTHS_PREV_YEAR',p_business_group_id,'CN');

2769: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);
2770:
2771: -- Fetch Number of runs in Previous Year
2772: --
2773: l_no_of_runs := pay_balance_pkg.run_db_item('CN_PAYROLL_RUN_MONTHS_PREV_YEAR',p_business_group_id,'CN');
2774: hr_utility.set_location('China : Balance Prev Year ->' || l_bal_value, 120);
2775: hr_utility.set_location('China : Number of runs ->' || l_no_of_runs, 120);
2776: l_bal_value := l_bal_value/l_no_of_runs;
2777: --