[Home] [Help]
143: l_effective_start_date date;
144: l_effective_end_date date;
145: --
146: begin
147: hr_utility.set_location('Entering:'|| l_proc, 10);
148: --
149: -- Issue a savepoint
150: --
151: savepoint create_element_link;
273: ,p_hook_type => 'BP'
274: );
275: end;
276:
277: hr_utility.set_location(l_proc, 20);
278: --
279: -- The main creation process has been moved to pypelbsi.pkb.
280: --
281: pay_element_link_internal.create_element_link
563: p_object_version_number := l_object_version_number;
564: p_effective_start_date := l_effective_start_date;
565: p_effective_end_date := l_effective_end_date;
566:
567: hr_utility.set_location(' Leaving:'||l_proc, 70);
568: exception
569: when hr_api.validate_enabled then
570: --
571: -- As the Validate_Enabled exception has been raised
580: p_element_link_id := null;
581: p_object_version_number := null;
582:
583:
584: hr_utility.set_location(' Leaving:'||l_proc, 80);
585: when others then
586: --
587: -- A validation or unexpected error has occured
588: --
586: --
587: -- A validation or unexpected error has occured
588: --
589: rollback to create_element_link;
590: hr_utility.set_location(' Leaving:'||l_proc, 90);
591: raise;
592: end create_element_link;
593: -- ----------------------------------------------------------------------------
594: -- |--------------------------
740: --
741: l_element_link_rec csr_bg_et%rowtype;
742: --
743: begin
744: hr_utility.set_location('Entering:'|| l_proc, 10);
745: --
746: -- Issue a savepoint
747: --
748: savepoint update_element_link;
746: -- Issue a savepoint
747: --
748: savepoint update_element_link;
749: --
750: hr_utility.set_location('Entering:'|| l_proc, 20);
751: --
752: -- Truncate the time portion from all IN date parameters
753: --
754: l_effective_date := trunc(p_effective_date);
873:
874: if (p_costable_type = 'D' or p_costable_type = 'C'
875: or p_costable_type = 'F') then
876:
877: hr_utility.set_location('Entering:'|| l_proc, 30);
878:
879: -- Get the structure number for the business_group id supplied
880: open csr_Flexnum(l_element_link_rec.business_group_id);
881: fetch csr_Flexnum into l_flex_num;
880: open csr_Flexnum(l_element_link_rec.business_group_id);
881: fetch csr_Flexnum into l_flex_num;
882: if csr_Flexnum%notfound then
883: close csr_Flexnum;
884: hr_utility.set_message(801,'HR_7471_FLEX_PEA_INVALID_ID');
885: hr_utility.raise_error;
886: end if;
887:
888: hr_kflex_utility.upd_or_sel_keyflex_comb
881: fetch csr_Flexnum into l_flex_num;
882: if csr_Flexnum%notfound then
883: close csr_Flexnum;
884: hr_utility.set_message(801,'HR_7471_FLEX_PEA_INVALID_ID');
885: hr_utility.raise_error;
886: end if;
887:
888: hr_kflex_utility.upd_or_sel_keyflex_comb
889: (p_appl_short_name => 'PAY'
1202: --
1203: p_cost_allocation_keyflex_id := l_cost_allocation_id;
1204: p_balancing_keyflex_id := l_bal_allocation_id;
1205:
1206: hr_utility.set_location(' Leaving:'||l_proc, 70);
1207: exception
1208: when hr_api.validate_enabled then
1209: --
1210: -- As the Validate_Enabled exception has been raised
1217: -- when validation only mode is being used.)
1218: --
1219: p_object_version_number := null;
1220:
1221: hr_utility.set_location(' Leaving:'||l_proc, 80);
1222: when others then
1223: --
1224: -- A validation or unexpected error has occured
1225: --
1223: --
1224: -- A validation or unexpected error has occured
1225: --
1226: rollback to update_element_link;
1227: hr_utility.set_location(' Leaving:'||l_proc, 90);
1228: raise;
1229: end update_element_link;
1230: --
1231: -- ----------------------------------------------------------------------------
1297: where element_link_id = p_element_link_id
1298: ;
1299: --
1300: begin
1301: hr_utility.set_location('Entering:'||l_proc, 5);
1302: --
1303: -- Process Logic
1304: --
1305: -- 1) Lock the element link and identify the validation date range.
1315: --
1316: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_delete_mode);
1317:
1318:
1319: hr_utility.set_location(l_proc, 10);
1320: --
1321: -- 1) Lock the element link and identify the validation date range.
1322: --
1323: pay_pel_shd.lck
1344: open csr_link_date_range;
1345: fetch csr_link_date_range into l_old_min_esd, l_old_max_eed;
1346: close csr_link_date_range;
1347:
1348: hr_utility.set_location(l_proc, 20);
1349: --
1350: -- 2) Validation in addition to the row handler.
1351: --
1352: -- Check to see if this delete is allowed.
1358: ,p_delete_mode => p_datetrack_delete_mode
1359: ,p_validation_start_date => l_validation_start_date
1360: );
1361:
1362: hr_utility.set_location(l_proc, 30);
1363: --
1364: -- 3) Delete non datetrack child rows.
1365: -- Bug 5512101. Batch Element Link support.
1366: --
1378: ,p_object_id => p_element_link_id
1379: );
1380: end if;
1381:
1382: hr_utility.set_location(l_proc, 40);
1383: --
1384: -- 4) ZAP or End Date child rows.
1385: --
1386: if p_datetrack_delete_mode in (hr_api.g_zap, hr_api.g_delete) then
1424: );
1425:
1426: end if;
1427:
1428: hr_utility.set_location(l_proc, 80);
1429: --
1430: -- 5) Delete the element link.
1431: --
1432: pay_pel_del.del
1438: ,p_effective_end_date => l_effective_end_date
1439: ,p_warning => l_entries_warning
1440: );
1441:
1442: hr_utility.set_location(l_proc, 90);
1443: --
1444: -- 6) Next Change or Future Change child rows.
1445: --
1446: if p_datetrack_delete_mode in (hr_api.g_delete_next_change
1511: p_effective_start_date := l_effective_start_date;
1512: p_effective_end_date := l_effective_end_date;
1513: p_entries_warning := l_entries_warning;
1514: --
1515: hr_utility.set_location(' Leaving:'||l_proc, 100);
1516: end delete_element_link_int;
1517: --
1518: -- ----------------------------------------------------------------------------
1519: -- |--------------------------
1535: l_proc varchar2(72) := g_package||'delete_element_link';
1536: l_effective_date date;
1537:
1538: begin
1539: hr_utility.set_location('Entering:'|| l_proc, 10);
1540: --
1541: -- Issue a savepoint
1542: --
1543: savepoint delete_element_link;
1607: if p_validate then
1608: raise hr_api.validate_enabled;
1609: end if;
1610:
1611: hr_utility.set_location(' Leaving:'||l_proc, 70);
1612: exception
1613: when hr_api.validate_enabled then
1614: --
1615: -- As the Validate_Enabled exception has been raised
1621: -- (Any key or derived arguments must be set to null
1622: -- when validation only mode is being used.)
1623: --
1624:
1625: hr_utility.set_location(' Leaving:'||l_proc, 80);
1626: when others then
1627: --
1628: -- A validation or unexpected error has occured
1629: --
1627: --
1628: -- A validation or unexpected error has occured
1629: --
1630: rollback to delete_element_link;
1631: hr_utility.set_location(' Leaving:'||l_proc, 90);
1632: raise;
1633: end delete_element_link;
1634: --
1635: