[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'
1195: --
1196: p_cost_allocation_keyflex_id := l_cost_allocation_id;
1197: p_balancing_keyflex_id := l_bal_allocation_id;
1198:
1199: hr_utility.set_location(' Leaving:'||l_proc, 70);
1200: exception
1201: when hr_api.validate_enabled then
1202: --
1203: -- As the Validate_Enabled exception has been raised
1210: -- when validation only mode is being used.)
1211: --
1212: p_object_version_number := null;
1213:
1214: hr_utility.set_location(' Leaving:'||l_proc, 80);
1215: when others then
1216: --
1217: -- A validation or unexpected error has occured
1218: --
1216: --
1217: -- A validation or unexpected error has occured
1218: --
1219: rollback to update_element_link;
1220: hr_utility.set_location(' Leaving:'||l_proc, 90);
1221: raise;
1222: end update_element_link;
1223: --
1224: -- ----------------------------------------------------------------------------
1290: where element_link_id = p_element_link_id
1291: ;
1292: --
1293: begin
1294: hr_utility.set_location('Entering:'||l_proc, 5);
1295: --
1296: -- Process Logic
1297: --
1298: -- 1) Lock the element link and identify the validation date range.
1308: --
1309: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_delete_mode);
1310:
1311:
1312: hr_utility.set_location(l_proc, 10);
1313: --
1314: -- 1) Lock the element link and identify the validation date range.
1315: --
1316: pay_pel_shd.lck
1337: open csr_link_date_range;
1338: fetch csr_link_date_range into l_old_min_esd, l_old_max_eed;
1339: close csr_link_date_range;
1340:
1341: hr_utility.set_location(l_proc, 20);
1342: --
1343: -- 2) Validation in addition to the row handler.
1344: --
1345: -- Check to see if this delete is allowed.
1351: ,p_delete_mode => p_datetrack_delete_mode
1352: ,p_validation_start_date => l_validation_start_date
1353: );
1354:
1355: hr_utility.set_location(l_proc, 30);
1356: --
1357: -- 3) Delete non datetrack child rows.
1358: -- Bug 5512101. Batch Element Link support.
1359: --
1371: ,p_object_id => p_element_link_id
1372: );
1373: end if;
1374:
1375: hr_utility.set_location(l_proc, 40);
1376: --
1377: -- 4) ZAP or End Date child rows.
1378: --
1379: if p_datetrack_delete_mode in (hr_api.g_zap, hr_api.g_delete) then
1417: );
1418:
1419: end if;
1420:
1421: hr_utility.set_location(l_proc, 80);
1422: --
1423: -- 5) Delete the element link.
1424: --
1425: pay_pel_del.del
1431: ,p_effective_end_date => l_effective_end_date
1432: ,p_warning => l_entries_warning
1433: );
1434:
1435: hr_utility.set_location(l_proc, 90);
1436: --
1437: -- 6) Next Change or Future Change child rows.
1438: --
1439: if p_datetrack_delete_mode in (hr_api.g_delete_next_change
1504: p_effective_start_date := l_effective_start_date;
1505: p_effective_end_date := l_effective_end_date;
1506: p_entries_warning := l_entries_warning;
1507: --
1508: hr_utility.set_location(' Leaving:'||l_proc, 100);
1509: end delete_element_link_int;
1510: --
1511: -- ----------------------------------------------------------------------------
1512: -- |--------------------------
1528: l_proc varchar2(72) := g_package||'delete_element_link';
1529: l_effective_date date;
1530:
1531: begin
1532: hr_utility.set_location('Entering:'|| l_proc, 10);
1533: --
1534: -- Issue a savepoint
1535: --
1536: savepoint delete_element_link;
1600: if p_validate then
1601: raise hr_api.validate_enabled;
1602: end if;
1603:
1604: hr_utility.set_location(' Leaving:'||l_proc, 70);
1605: exception
1606: when hr_api.validate_enabled then
1607: --
1608: -- As the Validate_Enabled exception has been raised
1614: -- (Any key or derived arguments must be set to null
1615: -- when validation only mode is being used.)
1616: --
1617:
1618: hr_utility.set_location(' Leaving:'||l_proc, 80);
1619: when others then
1620: --
1621: -- A validation or unexpected error has occured
1622: --
1620: --
1621: -- A validation or unexpected error has occured
1622: --
1623: rollback to delete_element_link;
1624: hr_utility.set_location(' Leaving:'||l_proc, 90);
1625: raise;
1626: end delete_element_link;
1627: --
1628: