DBA Data[Home] [Help]

APPS.PAY_CN_EXT dependencies on FND_DATE

Line 889: l_filling_date:=fnd_date.canonical_to_date(p_filling_date);

885: --
886: END IF;
887: --
888: -- Bug 3448316 caused this change
889: l_filling_date:=fnd_date.canonical_to_date(p_filling_date);
890: --
891:
892: hr_utility.set_location('China : p_extract_def_id -> ' || l_extract_def_id , 40);
893: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 40);

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 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 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 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 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);