[Home] [Help]
1571: open csr_delete_existing_entries (l_element_entry_id,l_element_type_id);
1572: fetch csr_delete_existing_entries into l_del_effective_start_date, l_del_objection_version_number;
1573: close csr_delete_existing_entries;
1574:
1575: pay_element_entry_api.delete_element_entry
1576: (p_validate => FALSE
1577: ,p_datetrack_delete_mode => hr_api.g_zap
1578: ,p_effective_date => l_del_effective_start_date
1579: ,p_element_entry_id => l_element_entry_id
1596: -- Bug 12808748
1597: l_effective_date := add_months(pay_in_utils.next_tax_year(l_effective_date),-12);
1598: l_effective_date := greatest(l_effective_date,l_assgn_start_date);
1599:
1600: pay_element_entry_api.create_element_entry
1601: (p_effective_date => l_effective_date
1602: ,p_business_group_id => l_business_group_id
1603: ,p_assignment_id => p_assignment_id
1604: ,p_element_link_id => l_element_link_id
1690: end if;
1691:
1692: if get_update_mode(l_element_entry_id,l_effective_date) <> 'CORRECTION' then
1693:
1694: pay_element_entry_api.update_element_entry
1695: (p_datetrack_update_mode => get_update_mode(l_element_entry_id
1696: ,l_effective_date)
1697: ,p_effective_date => l_effective_date
1698: ,p_business_group_id => l_business_group_id
1741: end if;
1742:
1743: for i in csr_element_entries (l_element_entry_id,l_element_type_id,l_change_date) loop
1744:
1745: pay_element_entry_api.update_element_entry
1746: (p_datetrack_update_mode => 'CORRECTION'
1747: ,p_effective_date => i.effective_start_date
1748: ,p_business_group_id => l_business_group_id
1749: ,p_element_entry_id => l_element_entry_id
1976: -- In this case, we would have to create an element entry to the
1977: -- assignment and return the entry id, the rest would be handled
1978: -- by the update command in the calling procedure.
1979: --
1980: pay_element_entry_api.create_element_entry
1981: (p_effective_date => l_effective_date
1982: ,p_business_group_id => l_business_group_id
1983: ,p_assignment_id => p_assignment_id
1984: ,p_element_link_id => l_element_link_id
2046: --
2047: -- An element entry for this element already exists we have to
2048: -- update the element entry with the newly submitted date.
2049: --
2050: pay_element_entry_api.update_element_entry
2051: (p_datetrack_update_mode => get_update_mode(l_element_entry_id
2052: ,l_effective_date)
2053: ,p_effective_date => l_effective_date
2054: ,p_business_group_id => l_business_group_id
2105: --
2106: --
2107: pay_in_utils.set_location(g_debug, l_procedure, 80);
2108: --
2109: pay_element_entry_api.update_element_entry
2110: (p_datetrack_update_mode => get_update_mode(l_element_entry_id
2111: ,l_endation_date)
2112: ,p_effective_date => l_endation_date
2113: ,p_business_group_id => l_business_group_id
2391: -- In this case, we would have to create an element entry to the
2392: -- assignment and return the entry id, the rest would be handled
2393: -- by the update command in the calling procedure.
2394: --
2395: pay_element_entry_api.create_element_entry
2396: (p_effective_date => l_effective_date
2397: ,p_business_group_id => l_business_group_id
2398: ,p_assignment_id => p_assignment_id
2399: ,p_element_link_id => l_element_link_id
2441: --
2442: -- An element entry for this element already exists we have to
2443: -- update the element entry with the newly submitted date.
2444: --
2445: pay_element_entry_api.update_element_entry
2446: (p_datetrack_update_mode => get_update_mode(l_element_entry_id
2447: ,l_effective_date)
2448: ,p_effective_date => l_effective_date
2449: ,p_business_group_id => l_business_group_id
2678: -- In this case, we would have to create an element entry to the
2679: -- assignment and return the entry id, the rest would be handled
2680: -- by the update command in the calling procedure.
2681: hr_utility.trace('Disability Type= '||p_disability_type);
2682: pay_element_entry_api.create_element_entry
2683: (p_effective_date => l_effective_date
2684: ,p_business_group_id => l_business_group_id
2685: ,p_assignment_id => p_assignment_id
2686: ,p_element_link_id => l_element_link_id
2732: --
2733: -- An element entry for this element already exists we have to
2734: -- update the element entry with the newly submitted date.
2735: --
2736: pay_element_entry_api.update_element_entry
2737: (p_datetrack_update_mode => get_update_mode(p_element_entry_id
2738: ,l_effective_date)
2739: ,p_effective_date => l_effective_date
2740: ,p_business_group_id => l_business_group_id
2965: --
2966: -- In this case, we would have to create an element entry to the
2967: -- assignment and return the entry id, the rest would be handled
2968: -- by the update command in the calling procedure.
2969: pay_element_entry_api.create_element_entry
2970: (p_effective_date => l_effective_date
2971: ,p_business_group_id => l_business_group_id
2972: ,p_assignment_id => p_assignment_id
2973: ,p_element_link_id => l_element_link_id
3016: --
3017: -- An element entry for this element already exists we have to
3018: -- update the element entry with the newly submitted date.
3019: --
3020: pay_element_entry_api.update_element_entry
3021: (p_datetrack_update_mode => get_update_mode(p_element_entry_id
3022: ,l_effective_date)
3023: ,p_effective_date => l_effective_date
3024: ,p_business_group_id => l_business_group_id
3239: --
3240: -- In this case, we would have to create an element entry to the
3241: -- assignment and return the entry id, the rest would be handled
3242: -- by the update command in the calling procedure.
3243: pay_element_entry_api.create_element_entry
3244: (p_effective_date => l_effective_date
3245: ,p_business_group_id => l_business_group_id
3246: ,p_assignment_id => p_assignment_id
3247: ,p_element_link_id => l_element_link_id
3299: --
3300: -- An element entry for this element already exists we have to
3301: -- update the element entry with the newly submitted date.
3302: --
3303: pay_element_entry_api.update_element_entry
3304: (p_datetrack_update_mode => get_update_mode(p_element_entry_id
3305: ,l_effective_date)
3306: ,p_effective_date => l_effective_date
3307: ,p_business_group_id => l_business_group_id
3468: -- assignment and return the entry id, the rest would be handled
3469: -- by the update command in the calling procedure.
3470: --
3471: IF (p_ee_vol_pf_amount > 0 OR p_ee_vol_pf_percent > 0) THEN
3472: pay_element_entry_api.create_element_entry
3473: (p_effective_date => l_effective_date
3474: ,p_business_group_id => l_business_group_id
3475: ,p_assignment_id => p_assignment_id
3476: ,p_element_link_id => l_element_link_id
3506: -- An element entry for this element already exists we have to
3507: -- update the element entry with the newly submitted date.
3508: --
3509: IF (p_ee_vol_pf_amount > 0 OR p_ee_vol_pf_percent > 0) THEN
3510: pay_element_entry_api.update_element_entry
3511: (p_datetrack_update_mode => get_update_mode(l_element_entry_id
3512: ,l_effective_date)
3513: ,p_effective_date => l_effective_date
3514: ,p_business_group_id => l_business_group_id
3872: OPEN c_check_entry(l_element_name,l_effective_date);
3873: FETCH c_check_entry INTO l_ele_entry_id,l_ovn,l_entry_value;
3874: IF c_check_entry%FOUND THEN
3875:
3876: pay_element_entry_api.update_element_entry
3877: (p_datetrack_update_mode => get_update_mode(l_ele_entry_id
3878: ,l_effective_date)
3879: ,p_effective_date => l_effective_date
3880: ,p_business_group_id => l_business_group_id
3907: --
3908: -- In this case, we would have to create an element entry to the
3909: -- assignment and return the entry id, the rest would be handled
3910: -- by the update command in the calling procedure.
3911: pay_element_entry_api.create_element_entry
3912: (p_effective_date => l_effective_date
3913: ,p_business_group_id => l_business_group_id
3914: ,p_assignment_id => p_assignment_id
3915: ,p_element_link_id => l_element_link_id
3961: --
3962: -- An element entry for this element already exists we have to
3963: -- update the element entry with the newly submitted date.
3964: --
3965: pay_element_entry_api.update_element_entry
3966: (p_datetrack_update_mode => get_update_mode(p_element_entry_id
3967: ,l_effective_date)
3968: ,p_effective_date => l_effective_date
3969: ,p_business_group_id => l_business_group_id
4108: -- In this case, we would have to create an element entry to the
4109: -- assignment and return the entry id, the rest would be handled
4110: -- by the update command in the calling procedure.
4111: --
4112: pay_element_entry_api.create_element_entry
4113: (p_effective_date => l_effective_date
4114: ,p_business_group_id => l_business_group_id
4115: ,p_assignment_id => p_assignment_id
4116: ,p_element_link_id => l_element_link_id
4145: --
4146: -- An element entry for this element already exists we have to
4147: -- update the element entry with the newly submitted date.
4148: --
4149: pay_element_entry_api.update_element_entry
4150: (p_datetrack_update_mode => get_update_mode(l_element_entry_id
4151: ,l_effective_date)
4152: ,p_effective_date => l_effective_date
4153: ,p_business_group_id => l_business_group_id
4286: -- In this case, we would have to create an element entry to the
4287: -- assignment and return the entry id, the rest would be handled
4288: -- by the update command in the calling procedure.
4289: --
4290: pay_element_entry_api.create_element_entry
4291: (p_effective_date => l_effective_date
4292: ,p_business_group_id => l_business_group_id
4293: ,p_assignment_id => p_assignment_id
4294: ,p_element_link_id => l_element_link_id
4325: -- update the element entry with the newly submitted date.
4326: --
4327: IF p_higher_education_loan_80e > 0 THEN
4328:
4329: pay_element_entry_api.update_element_entry
4330: (p_datetrack_update_mode => get_update_mode(l_element_entry_id
4331: ,l_effective_date)
4332: ,p_effective_date => l_effective_date
4333: ,p_business_group_id => l_business_group_id
4478: -- In this case, we would have to create an element entry to the
4479: -- assignment and return the entry id, the rest would be handled
4480: -- by the update command in the calling procedure.
4481: --
4482: pay_element_entry_api.create_element_entry
4483: (p_effective_date => l_effective_date
4484: ,p_business_group_id => l_business_group_id
4485: ,p_assignment_id => p_assignment_id
4486: ,p_element_link_id => l_element_link_id
4517: -- update the element entry with the newly submitted date.
4518: --
4519: IF p_infrastructure_bonds_80ccf > 0 THEN
4520:
4521: pay_element_entry_api.update_element_entry
4522: (p_datetrack_update_mode => get_update_mode(l_element_entry_id
4523: ,l_effective_date)
4524: ,p_effective_date => l_effective_date
4525: ,p_business_group_id => l_business_group_id
4671: -- In this case, we would have to create an element entry to the
4672: -- assignment and return the entry id, the rest would be handled
4673: -- by the update command in the calling procedure.
4674: --
4675: pay_element_entry_api.create_element_entry
4676: (p_effective_date => l_effective_date
4677: ,p_business_group_id => l_business_group_id
4678: ,p_assignment_id => p_assignment_id
4679: ,p_element_link_id => l_element_link_id
4711: -- update the element entry with the newly submitted date.
4712: --
4713: IF p_investment_amt_80ccg > 0 THEN
4714:
4715: pay_element_entry_api.update_element_entry
4716: (p_datetrack_update_mode => get_update_mode(l_element_entry_id
4717: ,l_effective_date)
4718: ,p_effective_date => l_effective_date
4719: ,p_business_group_id => l_business_group_id
4867: -- In this case, we would have to create an element entry to the
4868: -- assignment and return the entry id, the rest would be handled
4869: -- by the update command in the calling procedure.
4870: --
4871: pay_element_entry_api.create_element_entry
4872: (p_effective_date => l_effective_date
4873: ,p_business_group_id => l_business_group_id
4874: ,p_assignment_id => p_assignment_id
4875: ,p_element_link_id => l_element_link_id
4906: -- update the element entry with the newly submitted date.
4907: --
4908: IF p_donation_for_research_80gga > 0 THEN
4909:
4910: pay_element_entry_api.update_element_entry
4911: (p_datetrack_update_mode => get_update_mode(l_element_entry_id
4912: ,l_effective_date)
4913: ,p_effective_date => l_effective_date
4914: ,p_business_group_id => l_business_group_id
5067: -- In this case, we would have to create an element entry to the
5068: -- assignment and return the entry id, the rest would be handled
5069: -- by the update command in the calling procedure.
5070: --
5071: pay_element_entry_api.create_element_entry
5072: (p_effective_date => l_effective_date
5073: ,p_business_group_id => l_business_group_id
5074: ,p_assignment_id => p_assignment_id
5075: ,p_element_link_id => l_element_link_id
5116: -- update the element entry with the newly submitted date.
5117: --
5118:
5119:
5120: pay_element_entry_api.update_element_entry
5121: (p_datetrack_update_mode => get_update_mode(l_element_entry_id
5122: ,l_effective_date)
5123: ,p_effective_date => l_effective_date
5124: ,p_business_group_id => l_business_group_id
5270: -- In this case, we would have to create an element entry to the
5271: -- assignment and return the entry id, the rest would be handled
5272: -- by the update command in the calling procedure.
5273: --
5274: pay_element_entry_api.create_element_entry
5275: (p_effective_date => l_effective_date
5276: ,p_business_group_id => l_business_group_id
5277: ,p_assignment_id => p_assignment_id
5278: ,p_element_link_id => l_element_link_id
5312: --
5313:
5314: IF p_disease_treatment_80ddb > 0 THEN
5315:
5316: pay_element_entry_api.update_element_entry
5317: (p_datetrack_update_mode => get_update_mode(l_element_entry_id
5318: ,l_effective_date)
5319: ,p_effective_date => l_effective_date
5320: ,p_business_group_id => l_business_group_id
5465: -- In this case, we would have to create an element entry to the
5466: -- assignment and return the entry id, the rest would be handled
5467: -- by the update command in the calling procedure.
5468: --
5469: pay_element_entry_api.create_element_entry
5470: (p_effective_date => l_effective_date
5471: ,p_business_group_id => l_business_group_id
5472: ,p_assignment_id => p_assignment_id
5473: ,p_element_link_id => l_element_link_id
5951: /* 13105285 Starts*/
5952:
5953: IF (p_deletion_mode IS NOT NULL and upper(p_deletion_mode) ='PURGE' ) THEN
5954: pay_in_utils.trace('Inside If:',l_effective_date);
5955: pay_element_entry_api.delete_element_entry
5956: (p_validate => FALSE
5957: ,p_datetrack_delete_mode => hr_api.g_zap
5958: ,p_effective_date => l_effective_date
5959: ,p_element_entry_id => p_element_entry_id
5963: ,p_delete_warning => l_warnings
5964: );
5965: ELSE
5966: pay_in_utils.trace('Inside Else:',l_effective_date);
5967: pay_element_entry_api.delete_element_entry
5968: (p_validate => FALSE
5969: ,p_datetrack_delete_mode => hr_api.g_delete
5970: ,p_effective_date => l_effective_date
5971: ,p_element_entry_id => p_element_entry_id