[Home] [Help]
18: hr_utility.set_location('p_effective_start_date '||p_effective_start_date,10);
19: hr_utility.set_location('p_effective_end_date '||p_effective_end_date,10);
20: hr_utility.set_location('p_effective_date '||p_effective_date,10);
21: --
22: if p_effective_end_date <> hr_api.g_eot then
23: --
24: if p_dml_operation = 'INSERT' then
25: --
26: l_datetrack_mode := hr_api.g_update;
22: if p_effective_end_date <> hr_api.g_eot then
23: --
24: if p_dml_operation = 'INSERT' then
25: --
26: l_datetrack_mode := hr_api.g_update;
27: l_update := true;
28: --
29: elsif l_datetrack_mode in ('CORRECTION') then
30: --
27: l_update := true;
28: --
29: elsif l_datetrack_mode in ('CORRECTION') then
30: --
31: l_datetrack_mode := hr_api.g_correction ;
32: l_update := true;
33: --
34: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
35: --
33: --
34: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
35: --
36: if p_effective_date = p_effective_start_date then
37: l_datetrack_mode := hr_api.g_correction ;
38: l_update := true;
39: else
40: --
41: if l_datetrack_mode in ('UPDATE_OVERRIDE') then
39: else
40: --
41: if l_datetrack_mode in ('UPDATE_OVERRIDE') then
42: --
43: l_datetrack_mode := hr_api.g_update_override ;
44: l_update := false ;
45: --
46: elsif l_datetrack_mode in ('UPDATE') then
47: --
44: l_update := false ;
45: --
46: elsif l_datetrack_mode in ('UPDATE') then
47: --
48: l_datetrack_mode := hr_api.g_update;
49: --
50: end if;
51: --
52: end if;
53: --
54: elsif l_datetrack_mode in ('UPDATE_CHANGE_INSERT') then
55: --
56: if p_effective_date = p_effective_start_date then
57: l_datetrack_mode := hr_api.g_correction ;
58: l_update := true;
59: else
60: l_datetrack_mode := hr_api.g_update_change_insert ;
61: l_update := true;
56: if p_effective_date = p_effective_start_date then
57: l_datetrack_mode := hr_api.g_correction ;
58: l_update := true;
59: else
60: l_datetrack_mode := hr_api.g_update_change_insert ;
61: l_update := true;
62: end if;
63: --
64: else
62: end if;
63: --
64: else
65: --
66: l_datetrack_mode := hr_api.g_update;
67: l_update := false;
68: --
69: end if;
70: --
71: else
72: --
73: if p_dml_operation = 'INSERT' then
74: --
75: l_datetrack_mode := hr_api.g_update;
76: l_update := false;
77: --
78: elsif l_datetrack_mode in ('CORRECTION') then
79: --
76: l_update := false;
77: --
78: elsif l_datetrack_mode in ('CORRECTION') then
79: --
80: l_datetrack_mode := hr_api.g_correction ;
81: l_update := false;
82: --
83: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
84: --
82: --
83: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
84: --
85: if p_effective_date = p_effective_start_date then
86: l_datetrack_mode := hr_api.g_correction ;
87: l_update := true;
88: else
89: l_datetrack_mode := hr_api.g_update ;
90: l_update := false ;
85: if p_effective_date = p_effective_start_date then
86: l_datetrack_mode := hr_api.g_correction ;
87: l_update := true;
88: else
89: l_datetrack_mode := hr_api.g_update ;
90: l_update := false ;
91: end if;
92: --
93: elsif l_datetrack_mode in ('UPDATE_CHANGE_INSERT') then
92: --
93: elsif l_datetrack_mode in ('UPDATE_CHANGE_INSERT') then
94: --
95: if p_effective_date = p_effective_start_date then
96: l_datetrack_mode := hr_api.g_correction ;
97: l_update := false;
98: else
99: l_datetrack_mode := hr_api.g_update ;
100: l_update := false;
95: if p_effective_date = p_effective_start_date then
96: l_datetrack_mode := hr_api.g_correction ;
97: l_update := false;
98: else
99: l_datetrack_mode := hr_api.g_update ;
100: l_update := false;
101: end if;
102: --
103: else
101: end if;
102: --
103: else
104: --
105: l_datetrack_mode := hr_api.g_update;
106: l_update := false;
107: --
108: end if;
109: --
327: l_current_pk_id number := null ;
328: --UPD START
329: --
330: l_update boolean := false ;
331: l_datetrack_mode varchar2(80) := hr_api.g_update;
332: l_process_date date;
333: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
334: --
335: --UPD END
676: end if;
677: --
678: -- Delete the row if it is end dated.
679: --
680: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
681: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
682: trunc(l_max_eed) = r_JRT.information3) then
683: --
684: BEN_JOB_RT_API.delete_JOB_RT(
688: ,p_effective_start_date => l_effective_start_date
689: ,p_effective_end_date => l_effective_end_date
690: ,p_object_version_number => l_object_version_number
691: ,p_effective_date => l_max_eed
692: ,p_datetrack_mode => hr_api.g_delete
693: --
694: );
695: --
696: end if;
816: l_current_pk_id number := null ;
817: --UPD START
818: --
819: l_update boolean := false ;
820: l_datetrack_mode varchar2(80) := hr_api.g_update;
821: l_process_date date;
822: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
823: --
824: --UPD END
1143: end if;
1144: --
1145: -- Delete the row if it is end dated.
1146: --
1147: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
1148: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
1149: trunc(l_max_eed) = r_HSR.information3) then
1150: --
1151: BEN_HRLY_SALARY_RATE_API.delete_HRLY_SALARY_RATE(
1155: ,p_effective_start_date => l_effective_start_date
1156: ,p_effective_end_date => l_effective_end_date
1157: ,p_object_version_number => l_object_version_number
1158: ,p_effective_date => l_max_eed
1159: ,p_datetrack_mode => hr_api.g_delete
1160: --
1161: );
1162: --
1163: end if;
1281: l_current_pk_id number := null ;
1282: --UPD START
1283: --
1284: l_update boolean := false ;
1285: l_datetrack_mode varchar2(80) := hr_api.g_update;
1286: l_process_date date;
1287: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
1288: --
1289: --UPD END
1626: end if;
1627: --
1628: -- Delete the row if it is end dated.
1629: --
1630: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
1631: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
1632: trunc(l_max_eed) = r_GRR.information3) then
1633: --
1634: BEN_GRADE_RATE_API.delete_GRADE_RATE(
1638: ,p_effective_start_date => l_effective_start_date
1639: ,p_effective_end_date => l_effective_end_date
1640: ,p_object_version_number => l_object_version_number
1641: ,p_effective_date => l_max_eed
1642: ,p_datetrack_mode => hr_api.g_delete
1643: --
1644: );
1645: --
1646: end if;
1766: l_current_pk_id number := null ;
1767: --UPD START
1768: --
1769: l_update boolean := false ;
1770: l_datetrack_mode varchar2(80) := hr_api.g_update;
1771: l_process_date date;
1772: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
1773: --
1774: --UPD END
2094: end if;
2095: --
2096: -- Delete the row if it is end dated.
2097: --
2098: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
2099: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
2100: trunc(l_max_eed) = r_FTR.information3) then
2101: --
2102: BEN_FULL_PRT_TIME_RATE_API.delete_FULL_PRT_TIME_RATE(
2106: ,p_effective_start_date => l_effective_start_date
2107: ,p_effective_end_date => l_effective_end_date
2108: ,p_object_version_number => l_object_version_number
2109: ,p_effective_date => l_max_eed
2110: ,p_datetrack_mode => hr_api.g_delete
2111: --
2112: );
2113: --
2114: end if;
2231: l_current_pk_id number := null ;
2232: --UPD START
2233: --
2234: l_update boolean := false ;
2235: l_datetrack_mode varchar2(80) := hr_api.g_update;
2236: l_process_date date;
2237: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
2238: --
2239: --UPD END
2558: end if;
2559: --
2560: -- Delete the row if it is end dated.
2561: --
2562: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
2563: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
2564: trunc(l_max_eed) = r_BUR.information3) then
2565: --
2566: BEN_BARGAINING_UNIT_RT_API.delete_BARGAINING_UNIT_RT(
2570: ,p_effective_start_date => l_effective_start_date
2571: ,p_effective_end_date => l_effective_end_date
2572: ,p_object_version_number => l_object_version_number
2573: ,p_effective_date => l_max_eed
2574: ,p_datetrack_mode => hr_api.g_delete
2575: --
2576: );
2577: --
2578: end if;
2696: l_current_pk_id number := null ;
2697: --UPD START
2698: --
2699: l_update boolean := false ;
2700: l_datetrack_mode varchar2(80) := hr_api.g_update;
2701: l_process_date date;
2702: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
2703: --
2704: --UPD END
3038: end if;
3039: --
3040: -- Delete the row if it is end dated.
3041: --
3042: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
3043: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
3044: trunc(l_max_eed) = r_ESR.information3) then
3045: --
3046: BEN_EMPLOYEE_STATUS_RT_API.delete_EMPLOYEE_STATUS_RT(
3050: ,p_effective_start_date => l_effective_start_date
3051: ,p_effective_end_date => l_effective_end_date
3052: ,p_object_version_number => l_object_version_number
3053: ,p_effective_date => l_max_eed
3054: ,p_datetrack_mode => hr_api.g_delete
3055: --
3056: );
3057: --
3058: end if;
3178: l_current_pk_id number := null ;
3179: --UPD START
3180: --
3181: l_update boolean := false ;
3182: l_datetrack_mode varchar2(80) := hr_api.g_update;
3183: l_process_date date;
3184: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
3185: --
3186: --UPD END
3519: end if;
3520: --
3521: -- Delete the row if it is end dated.
3522: --
3523: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
3524: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
3525: trunc(l_max_eed) = r_ASR.information3) then
3526: --
3527: BEN_ASSIGNMENT_SET_RATE_API.delete_ASSIGNMENT_SET_RATE(
3531: ,p_effective_start_date => l_effective_start_date
3532: ,p_effective_end_date => l_effective_end_date
3533: ,p_object_version_number => l_object_version_number
3534: ,p_effective_date => l_max_eed
3535: ,p_datetrack_mode => hr_api.g_delete
3536: --
3537: );
3538: --
3539: end if;
3659: l_current_pk_id number := null ;
3660: --UPD START
3661: --
3662: l_update boolean := false ;
3663: l_datetrack_mode varchar2(80) := hr_api.g_update;
3664: l_process_date date;
3665: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
3666: --
3667: --UPD END
3988: end if;
3989: --
3990: -- Delete the row if it is end dated.
3991: --
3992: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
3993: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
3994: trunc(l_max_eed) = r_TUR.information3) then
3995: --
3996: BEN_TOBACCO_USE_RATE_API.delete_TOBACCO_USE_RATE(
4000: ,p_effective_start_date => l_effective_start_date
4001: ,p_effective_end_date => l_effective_end_date
4002: ,p_object_version_number => l_object_version_number
4003: ,p_effective_date => l_max_eed
4004: ,p_datetrack_mode => hr_api.g_delete
4005: --
4006: );
4007: --
4008: end if;
4126: l_current_pk_id number := null ;
4127: --UPD START
4128: --
4129: l_update boolean := false ;
4130: l_datetrack_mode varchar2(80) := hr_api.g_update;
4131: l_process_date date;
4132: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
4133: --
4134: --UPD END
4453: end if;
4454: --
4455: -- Delete the row if it is end dated.
4456: --
4457: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
4458: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
4459: trunc(l_max_eed) = r_SAR.information3) then
4460: --
4461: BEN_SERVICE_AREA_RATE_API.delete_SERVICE_AREA_RATE(
4465: ,p_effective_start_date => l_effective_start_date
4466: ,p_effective_end_date => l_effective_end_date
4467: ,p_object_version_number => l_object_version_number
4468: ,p_effective_date => l_max_eed
4469: ,p_datetrack_mode => hr_api.g_delete
4470: --
4471: );
4472: --
4473: end if;
4591: l_current_pk_id number := null ;
4592: --UPD START
4593: --
4594: l_update boolean := false ;
4595: l_datetrack_mode varchar2(80) := hr_api.g_update;
4596: l_process_date date;
4597: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
4598: --
4599: --UPD END
4933: end if;
4934: --
4935: -- Delete the row if it is end dated.
4936: --
4937: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
4938: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
4939: trunc(l_max_eed) = r_QTR.information3) then
4940: --
4941: BEN_QUAL_TITL_RT_API.delete_QUAL_TITL_RT(
4945: ,p_effective_start_date => l_effective_start_date
4946: ,p_effective_end_date => l_effective_end_date
4947: ,p_object_version_number => l_object_version_number
4948: ,p_effective_date => l_max_eed
4949: ,p_datetrack_mode => hr_api.g_delete
4950: --
4951: );
4952: --
4953: end if;
5073: l_current_pk_id number := null ;
5074: --UPD START
5075: --
5076: l_update boolean := false ;
5077: l_datetrack_mode varchar2(80) := hr_api.g_update;
5078: l_process_date date;
5079: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
5080: --
5081: --UPD END
5400: end if;
5401: --
5402: -- Delete the row if it is end dated.
5403: --
5404: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
5405: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
5406: trunc(l_max_eed) = r_PZR.information3) then
5407: --
5408: BEN_POSTAL_ZIP_RATE_API.delete_POSTAL_ZIP_RATE(
5412: ,p_effective_start_date => l_effective_start_date
5413: ,p_effective_end_date => l_effective_end_date
5414: ,p_object_version_number => l_object_version_number
5415: ,p_effective_date => l_max_eed
5416: ,p_datetrack_mode => hr_api.g_delete
5417: --
5418: );
5419: --
5420: end if;
5538: l_current_pk_id number := null ;
5539: --UPD START
5540: --
5541: l_update boolean := false ;
5542: l_datetrack_mode varchar2(80) := hr_api.g_update;
5543: l_process_date date;
5544: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
5545: --
5546: --UPD END
5881: end if;
5882: --
5883: -- Delete the row if it is end dated.
5884: --
5885: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
5886: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
5887: trunc(l_max_eed) = r_PTR.information3) then
5888: --
5889: BEN_PERSON_TYPE_RATE_API.delete_PERSON_TYPE_RATE(
5893: ,p_effective_start_date => l_effective_start_date
5894: ,p_effective_end_date => l_effective_end_date
5895: ,p_object_version_number => l_object_version_number
5896: ,p_effective_date => l_max_eed
5897: ,p_datetrack_mode => hr_api.g_delete
5898: --
5899: );
5900: --
5901: end if;
6018: l_current_pk_id number := null ;
6019: --UPD START
6020: --
6021: l_update boolean := false ;
6022: l_datetrack_mode varchar2(80) := hr_api.g_update;
6023: l_process_date date;
6024: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6025: --
6026: --UPD END
6345: end if;
6346: --
6347: -- Delete the row if it is end dated.
6348: --
6349: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
6350: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
6351: trunc(l_max_eed) = r_GNR.information3) then
6352: --
6353: BEN_GENDER_RATE_API.delete_GENDER_RATE(
6357: ,p_effective_start_date => l_effective_start_date
6358: ,p_effective_end_date => l_effective_end_date
6359: ,p_object_version_number => l_object_version_number
6360: ,p_effective_date => l_max_eed
6361: ,p_datetrack_mode => hr_api.g_delete
6362: --
6363: );
6364: --
6365: end if;
6483: l_current_pk_id number := null ;
6484: --UPD START
6485: --
6486: l_update boolean := false ;
6487: l_datetrack_mode varchar2(80) := hr_api.g_update;
6488: l_process_date date;
6489: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6490: --
6491: --UPD END
6810: end if;
6811: --
6812: -- Delete the row if it is end dated.
6813: --
6814: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
6815: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
6816: trunc(l_max_eed) = r_DBR.information3) then
6817: --
6818: BEN_DSBLD_RT_API.delete_DSBLD_RT(
6822: ,p_effective_start_date => l_effective_start_date
6823: ,p_effective_end_date => l_effective_end_date
6824: ,p_object_version_number => l_object_version_number
6825: ,p_effective_date => l_max_eed
6826: ,p_datetrack_mode => hr_api.g_delete
6827: --
6828: );
6829: --
6830: end if;
6952: l_current_pk_id number := null ;
6953: --UPD START
6954: --
6955: l_update boolean := false ;
6956: l_datetrack_mode varchar2(80) := hr_api.g_update;
6957: l_process_date date;
6958: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6959: --
6960: --UPD END
7308: end if;
7309: --
7310: -- Delete the row if it is end dated.
7311: --
7312: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
7313: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
7314: trunc(l_max_eed) = r_CTY.information3) then
7315: --
7316: BEN_COMPTNCY_RT_API.delete_COMPTNCY_RT(
7320: ,p_effective_start_date => l_effective_start_date
7321: ,p_effective_end_date => l_effective_end_date
7322: ,p_object_version_number => l_object_version_number
7323: ,p_effective_date => l_max_eed
7324: ,p_datetrack_mode => hr_api.g_delete
7325: --
7326: );
7327: --
7328: end if;
7442: l_current_pk_id number := null ;
7443: --UPD START
7444: --
7445: l_update boolean := false ;
7446: l_datetrack_mode varchar2(80) := hr_api.g_update;
7447: l_process_date date;
7448: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
7449: --
7450: --UPD END
7768: end if;
7769: --
7770: -- Delete the row if it is end dated.
7771: --
7772: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
7773: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
7774: trunc(l_max_eed) = r_LMM.information3) then
7775: --
7776: BEN_LABOR_MEMBER_RATE_API.delete_LABOR_MEMBER_RATE(
7780: ,p_effective_start_date => l_effective_start_date
7781: ,p_effective_end_date => l_effective_end_date
7782: ,p_object_version_number => l_object_version_number
7783: ,p_effective_date => l_max_eed
7784: ,p_datetrack_mode => hr_api.g_delete
7785: --
7786: );
7787: --
7788: end if;
7904: l_current_pk_id number := null ;
7905: --UPD START
7906: --
7907: l_update boolean := false ;
7908: l_datetrack_mode varchar2(80) := hr_api.g_update;
7909: l_process_date date;
7910: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
7911: --
7912: --UPD END
8257: end if;
8258: --
8259: -- Delete the row if it is end dated.
8260: --
8261: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
8262: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
8263: trunc(l_max_eed) = r_LAR.information3) then
8264: --
8265: BEN_LOA_REASON_RATE_API.delete_LOA_REASON_RATE(
8269: ,p_effective_start_date => l_effective_start_date
8270: ,p_effective_end_date => l_effective_end_date
8271: ,p_object_version_number => l_object_version_number
8272: ,p_effective_date => l_max_eed
8273: ,p_datetrack_mode => hr_api.g_delete
8274: --
8275: );
8276: --
8277: end if;
8392: l_current_pk_id number := null ;
8393: --UPD START
8394: --
8395: l_update boolean := false ;
8396: l_datetrack_mode varchar2(80) := hr_api.g_update;
8397: l_process_date date;
8398: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
8399: --
8400: --UPD END
8734: end if;
8735: --
8736: -- Delete the row if it is end dated.
8737: --
8738: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
8739: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
8740: trunc(l_max_eed) = r_OUR.information3) then
8741: --
8742: BEN_ORG_UNIT_RATE_API.delete_ORG_UNIT_RATE(
8746: ,p_effective_start_date => l_effective_start_date
8747: ,p_effective_end_date => l_effective_end_date
8748: ,p_object_version_number => l_object_version_number
8749: ,p_effective_date => l_max_eed
8750: ,p_datetrack_mode => hr_api.g_delete
8751: --
8752: );
8753: --
8754: end if;
8867: l_current_pk_id number := null ;
8868: --UPD START
8869: --
8870: l_update boolean := false ;
8871: l_datetrack_mode varchar2(80) := hr_api.g_update;
8872: l_process_date date;
8873: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
8874: --
8875: --UPD END
9209: end if;
9210: --
9211: -- Delete the row if it is end dated.
9212: --
9213: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
9214: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
9215: trunc(l_max_eed) = r_LER1.information3) then
9216: --
9217: BEN_LEGAL_ENTITY_RATE_API.delete_LEGAL_ENTITY_RATE(
9221: ,p_effective_start_date => l_effective_start_date
9222: ,p_effective_end_date => l_effective_end_date
9223: ,p_object_version_number => l_object_version_number
9224: ,p_effective_date => l_max_eed
9225: ,p_datetrack_mode => hr_api.g_delete
9226: --
9227: );
9228: --
9229: end if;
9342: l_current_pk_id number := null ;
9343: --UPD START
9344: --
9345: l_update boolean := false ;
9346: l_datetrack_mode varchar2(80) := hr_api.g_update;
9347: l_process_date date;
9348: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
9349: --
9350: --UPD END
9683: end if;
9684: --
9685: -- Delete the row if it is end dated.
9686: --
9687: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
9688: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
9689: trunc(l_max_eed) = r_PR_.information3) then
9690: --
9691: BEN_PAYROLL_RATE_API.delete_PAYROLL_RATE(
9695: ,p_effective_start_date => l_effective_start_date
9696: ,p_effective_end_date => l_effective_end_date
9697: ,p_object_version_number => l_object_version_number
9698: ,p_effective_date => l_max_eed
9699: ,p_datetrack_mode => hr_api.g_delete
9700: --
9701: );
9702: --
9703: end if;
9817: l_current_pk_id number := null ;
9818: --UPD START
9819: --
9820: l_update boolean := false ;
9821: l_datetrack_mode varchar2(80) := hr_api.g_update;
9822: l_process_date date;
9823: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
9824: --
9825: --UPD END
10158: end if;
10159: --
10160: -- Delete the row if it is end dated.
10161: --
10162: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
10163: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
10164: trunc(l_max_eed) = r_PBR.information3) then
10165: --
10166: BEN_PAY_BASIS_RATE_API.delete_PAY_BASIS_RATE(
10170: ,p_effective_start_date => l_effective_start_date
10171: ,p_effective_end_date => l_effective_end_date
10172: ,p_object_version_number => l_object_version_number
10173: ,p_effective_date => l_max_eed
10174: ,p_datetrack_mode => hr_api.g_delete
10175: --
10176: );
10177: --
10178: end if;
10298: l_current_pk_id number := null ;
10299: --UPD START
10300: --
10301: l_update boolean := false ;
10302: l_datetrack_mode varchar2(80) := hr_api.g_update;
10303: l_process_date date;
10304: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
10305: --
10306: --UPD END
10632: end if;
10633: --
10634: -- Delete the row if it is end dated.
10635: --
10636: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
10637: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
10638: trunc(l_max_eed) = r_CQR.information3) then
10639: --
10640: BEN_CBR_QUALD_BNF_RT_API.delete_CBR_QUALD_BNF_RT(
10644: ,p_effective_start_date => l_effective_start_date
10645: ,p_effective_end_date => l_effective_end_date
10646: ,p_object_version_number => l_object_version_number
10647: ,p_effective_date => l_max_eed
10648: ,p_datetrack_mode => hr_api.g_delete
10649: --
10650: );
10651: --
10652: end if;
10763: l_current_pk_id number := null ;
10764: --UPD START
10765: --
10766: l_update boolean := false ;
10767: l_datetrack_mode varchar2(80) := hr_api.g_update;
10768: l_process_date date;
10769: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
10770: --
10771: --UPD END
11089: end if;
11090: --
11091: -- Delete the row if it is end dated.
11092: --
11093: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
11094: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
11095: trunc(l_max_eed) = r_BRG.information3) then
11096: --
11097: BEN_BENEFIT_GRP_RATE_API.delete_BENEFIT_GRP_RATE(
11101: ,p_effective_start_date => l_effective_start_date
11102: ,p_effective_end_date => l_effective_end_date
11103: ,p_object_version_number => l_object_version_number
11104: ,p_effective_date => l_max_eed
11105: ,p_datetrack_mode => hr_api.g_delete
11106: --
11107: );
11108: --
11109: end if;
11220: l_current_pk_id number := null ;
11221: --UPD START
11222: --
11223: l_update boolean := false ;
11224: l_datetrack_mode varchar2(80) := hr_api.g_update;
11225: l_process_date date;
11226: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
11227: --
11228: --UPD END
11545: end if;
11546: --
11547: -- Delete the row if it is end dated.
11548: --
11549: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
11550: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
11551: trunc(l_max_eed) = r_CMR.information3) then
11552: --
11553: BEN_CMBN_AGE_LOS_RT_API.delete_CMBN_AGE_LOS_RT(
11557: ,p_effective_start_date => l_effective_start_date
11558: ,p_effective_end_date => l_effective_end_date
11559: ,p_object_version_number => l_object_version_number
11560: ,p_effective_date => l_max_eed
11561: ,p_datetrack_mode => hr_api.g_delete
11562: --
11563: );
11564: --
11565: end if;
11677: l_current_pk_id number := null ;
11678: --UPD START
11679: --
11680: l_update boolean := false ;
11681: l_datetrack_mode varchar2(80) := hr_api.g_update;
11682: l_process_date date;
11683: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
11684: --
11685: --UPD END
12022: end if;
12023: --
12024: -- Delete the row if it is end dated.
12025: --
12026: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
12027: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
12028: trunc(l_max_eed) = r_VMR.information3) then
12029: --
12030: BEN_VRBL_MATCHING_RATE_API.delete_VRBL_MATCHING_RATE(
12034: ,p_effective_start_date => l_effective_start_date
12035: ,p_effective_end_date => l_effective_end_date
12036: ,p_object_version_number => l_object_version_number
12037: ,p_effective_date => l_max_eed
12038: ,p_datetrack_mode => hr_api.g_delete
12039: --
12040: );
12041: --
12042: end if;
12153: l_current_pk_id number := null ;
12154: --UPD START
12155: --
12156: l_update boolean := false ;
12157: l_datetrack_mode varchar2(80) := hr_api.g_update;
12158: l_process_date date;
12159: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
12160: --
12161: --UPD END
12482: end if;
12483: --
12484: -- Delete the row if it is end dated.
12485: --
12486: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
12487: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
12488: trunc(l_max_eed) = r_PAP.information3) then
12489: --
12490: BEN_PRTT_ANTHR_PL_RT_API.delete_PRTT_ANTHR_PL_RT(
12494: ,p_effective_start_date => l_effective_start_date
12495: ,p_effective_end_date => l_effective_end_date
12496: ,p_object_version_number => l_object_version_number
12497: ,p_effective_date => l_max_eed
12498: ,p_datetrack_mode => hr_api.g_delete
12499: --
12500: );
12501: --
12502: end if;
12613: l_current_pk_id number := null ;
12614: --UPD START
12615: --
12616: l_update boolean := false ;
12617: l_datetrack_mode varchar2(80) := hr_api.g_update;
12618: l_process_date date;
12619: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
12620: --
12621: --UPD END
12943: end if;
12944: --
12945: -- Delete the row if it is end dated.
12946: --
12947: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
12948: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
12949: trunc(l_max_eed) = r_OPR.information3) then
12950: --
12951: BEN_OTHR_PTIP_RT_API.delete_OTHR_PTIP_RT(
12955: ,p_effective_start_date => l_effective_start_date
12956: ,p_effective_end_date => l_effective_end_date
12957: ,p_object_version_number => l_object_version_number
12958: ,p_effective_date => l_max_eed
12959: ,p_datetrack_mode => hr_api.g_delete
12960: --
12961: );
12962: --
12963: end if;
13074: l_current_pk_id number := null ;
13075: --UPD START
13076: --
13077: l_update boolean := false ;
13078: l_datetrack_mode varchar2(80) := hr_api.g_update;
13079: l_process_date date;
13080: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13081: --
13082: --UPD END
13396: end if;
13397: --
13398: -- Delete the row if it is end dated.
13399: --
13400: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
13401: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
13402: trunc(l_max_eed) = r_NOC.information3) then
13403: --
13404: BEN_NO_OTHR_CVG_RT_API.delete_NO_OTHR_CVG_RT(
13408: ,p_effective_start_date => l_effective_start_date
13409: ,p_effective_end_date => l_effective_end_date
13410: ,p_object_version_number => l_object_version_number
13411: ,p_effective_date => l_max_eed
13412: ,p_datetrack_mode => hr_api.g_delete
13413: --
13414: );
13415: --
13416: end if;
13527: l_current_pk_id number := null ;
13528: --UPD START
13529: --
13530: l_update boolean := false ;
13531: l_datetrack_mode varchar2(80) := hr_api.g_update;
13532: l_process_date date;
13533: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13534: --
13535: --UPD END
13850: end if;
13851: --
13852: -- Delete the row if it is end dated.
13853: --
13854: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
13855: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
13856: trunc(l_max_eed) = r_OMR.information3) then
13857: --
13858: BEN_OPTD_MDCR_RT_API.delete_OPTD_MDCR_RT(
13862: ,p_effective_start_date => l_effective_start_date
13863: ,p_effective_end_date => l_effective_end_date
13864: ,p_object_version_number => l_object_version_number
13865: ,p_effective_date => l_max_eed
13866: ,p_datetrack_mode => hr_api.g_delete
13867: --
13868: );
13869: --
13870: end if;
13981: l_current_pk_id number := null ;
13982: --UPD START
13983: --
13984: l_update boolean := false ;
13985: l_datetrack_mode varchar2(80) := hr_api.g_update;
13986: l_process_date date;
13987: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13988: --
13989: --UPD END
14311: end if;
14312: --
14313: -- Delete the row if it is end dated.
14314: --
14315: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
14316: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
14317: trunc(l_max_eed) = r_EPM.information3) then
14318: --
14319: BEN_ENRLD_ANTHR_PGM_RT_API.delete_ENRLD_ANTHR_PGM_RT(
14323: ,p_effective_start_date => l_effective_start_date
14324: ,p_effective_end_date => l_effective_end_date
14325: ,p_object_version_number => l_object_version_number
14326: ,p_effective_date => l_max_eed
14327: ,p_datetrack_mode => hr_api.g_delete
14328: --
14329: );
14330: --
14331: end if;
14442: l_current_pk_id number := null ;
14443: --UPD START
14444: --
14445: l_update boolean := false ;
14446: l_datetrack_mode varchar2(80) := hr_api.g_update;
14447: l_process_date date;
14448: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
14449: --
14450: --UPD END
14774: end if;
14775: --
14776: -- Delete the row if it is end dated.
14777: --
14778: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
14779: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
14780: trunc(l_max_eed) = r_ENT.information3) then
14781: --
14782: BEN_ENRLD_ANTHR_PTIP_RT_API.delete_ENRLD_ANTHR_PTIP_RT(
14786: ,p_effective_start_date => l_effective_start_date
14787: ,p_effective_end_date => l_effective_end_date
14788: ,p_object_version_number => l_object_version_number
14789: ,p_effective_date => l_max_eed
14790: ,p_datetrack_mode => hr_api.g_delete
14791: --
14792: );
14793: --
14794: end if;
14905: l_current_pk_id number := null ;
14906: --UPD START
14907: --
14908: l_update boolean := false ;
14909: l_datetrack_mode varchar2(80) := hr_api.g_update;
14910: l_process_date date;
14911: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
14912: --
14913: --UPD END
15235: end if;
15236: --
15237: -- Delete the row if it is end dated.
15238: --
15239: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
15240: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
15241: trunc(l_max_eed) = r_ENL.information3) then
15242: --
15243: BEN_ENRLD_ANTHR_PL_RT_API.delete_ENRLD_ANTHR_PL_RT(
15247: ,p_effective_start_date => l_effective_start_date
15248: ,p_effective_end_date => l_effective_end_date
15249: ,p_object_version_number => l_object_version_number
15250: ,p_effective_date => l_max_eed
15251: ,p_datetrack_mode => hr_api.g_delete
15252: --
15253: );
15254: --
15255: end if;
15366: l_current_pk_id number := null ;
15367: --UPD START
15368: --
15369: l_update boolean := false ;
15370: l_datetrack_mode varchar2(80) := hr_api.g_update;
15371: l_process_date date;
15372: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
15373: --
15374: --UPD END
15696: end if;
15697: --
15698: -- Delete the row if it is end dated.
15699: --
15700: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
15701: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
15702: trunc(l_max_eed) = r_EAR.information3) then
15703: --
15704: BEN_ENRLD_ANTHR_PLIP_RT_API.delete_ENRLD_ANTHR_PLIP_RT(
15708: ,p_effective_start_date => l_effective_start_date
15709: ,p_effective_end_date => l_effective_end_date
15710: ,p_object_version_number => l_object_version_number
15711: ,p_effective_date => l_max_eed
15712: ,p_datetrack_mode => hr_api.g_delete
15713: --
15714: );
15715: --
15716: end if;
15827: l_current_pk_id number := null ;
15828: --UPD START
15829: --
15830: l_update boolean := false ;
15831: l_datetrack_mode varchar2(80) := hr_api.g_update;
15832: l_process_date date;
15833: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
15834: --
15835: --UPD END
16157: end if;
16158: --
16159: -- Delete the row if it is end dated.
16160: --
16161: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
16162: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
16163: trunc(l_max_eed) = r_EAO.information3) then
16164: --
16165: BEN_ENRLD_ANTHR_OIPL_RT_API.delete_ENRLD_ANTHR_OIPL_RT(
16169: ,p_effective_start_date => l_effective_start_date
16170: ,p_effective_end_date => l_effective_end_date
16171: ,p_object_version_number => l_object_version_number
16172: ,p_effective_date => l_max_eed
16173: ,p_datetrack_mode => hr_api.g_delete
16174: --
16175: );
16176: --
16177: end if;
16288: l_current_pk_id number := null ;
16289: --UPD START
16290: --
16291: l_update boolean := false ;
16292: l_datetrack_mode varchar2(80) := hr_api.g_update;
16293: l_process_date date;
16294: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
16295: --
16296: --UPD END
16616: end if;
16617: --
16618: -- Delete the row if it is end dated.
16619: --
16620: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
16621: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
16622: trunc(l_max_eed) = r_DOT.information3) then
16623: --
16624: BEN_DPNT_OTHR_PTIP_RT_API.delete_DPNT_OTHR_PTIP_RT(
16628: ,p_effective_start_date => l_effective_start_date
16629: ,p_effective_end_date => l_effective_end_date
16630: ,p_object_version_number => l_object_version_number
16631: ,p_effective_date => l_max_eed
16632: ,p_datetrack_mode => hr_api.g_delete
16633: --
16634: );
16635: --
16636: end if;
16747: l_current_pk_id number := null ;
16748: --UPD START
16749: --
16750: l_update boolean := false ;
16751: l_datetrack_mode varchar2(80) := hr_api.g_update;
16752: l_process_date date;
16753: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
16754: --
16755: --UPD END
17079: end if;
17080: --
17081: -- Delete the row if it is end dated.
17082: --
17083: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
17084: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
17085: trunc(l_max_eed) = r_DOP.information3) then
17086: --
17087: BEN_DPNT_CVRD_OTHR_PGM_RT_API.delete_DPNT_CVRD_OTHR_PGM_RT(
17091: ,p_effective_start_date => l_effective_start_date
17092: ,p_effective_end_date => l_effective_end_date
17093: ,p_object_version_number => l_object_version_number
17094: ,p_effective_date => l_max_eed
17095: ,p_datetrack_mode => hr_api.g_delete
17096: --
17097: );
17098: --
17099: end if;
17210: l_current_pk_id number := null ;
17211: --UPD START
17212: --
17213: l_update boolean := false ;
17214: l_datetrack_mode varchar2(80) := hr_api.g_update;
17215: l_process_date date;
17216: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
17217: --
17218: --UPD END
17540: end if;
17541: --
17542: -- Delete the row if it is end dated.
17543: --
17544: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
17545: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
17546: trunc(l_max_eed) = r_DCP.information3) then
17547: --
17548: BEN_DPNT_CVRD_PLIP_RT_API.delete_DPNT_CVRD_PLIP_RT(
17552: ,p_effective_start_date => l_effective_start_date
17553: ,p_effective_end_date => l_effective_end_date
17554: ,p_object_version_number => l_object_version_number
17555: ,p_effective_date => l_max_eed
17556: ,p_datetrack_mode => hr_api.g_delete
17557: --
17558: );
17559: --
17560: end if;
17671: l_current_pk_id number := null ;
17672: --UPD START
17673: --
17674: l_update boolean := false ;
17675: l_datetrack_mode varchar2(80) := hr_api.g_update;
17676: l_process_date date;
17677: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
17678: --
17679: --UPD END
18003: end if;
18004: --
18005: -- Delete the row if it is end dated.
18006: --
18007: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
18008: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
18009: trunc(l_max_eed) = r_DCO.information3) then
18010: --
18011: BEN_DPNT_CVD_O_PTIP_RT_API.delete_DPNT_CVD_O_PTIP_RT(
18015: ,p_effective_start_date => l_effective_start_date
18016: ,p_effective_end_date => l_effective_end_date
18017: ,p_object_version_number => l_object_version_number
18018: ,p_effective_date => l_max_eed
18019: ,p_datetrack_mode => hr_api.g_delete
18020: --
18021: );
18022: --
18023: end if;
18134: l_current_pk_id number := null ;
18135: --UPD START
18136: --
18137: l_update boolean := false ;
18138: l_datetrack_mode varchar2(80) := hr_api.g_update;
18139: l_process_date date;
18140: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
18141: --
18142: --UPD END
18464: end if;
18465: --
18466: -- Delete the row if it is end dated.
18467: --
18468: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
18469: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
18470: trunc(l_max_eed) = r_DCL.information3) then
18471: --
18472: BEN_DPNT_CVRD_OTHR_PL_RT_API.delete_DPNT_CVRD_OTHR_PL_RT(
18476: ,p_effective_start_date => l_effective_start_date
18477: ,p_effective_end_date => l_effective_end_date
18478: ,p_object_version_number => l_object_version_number
18479: ,p_effective_date => l_max_eed
18480: ,p_datetrack_mode => hr_api.g_delete
18481: --
18482: );
18483: --
18484: end if;
18620: l_current_pk_id number := null ;
18621: --UPD START
18622: --
18623: l_update boolean := false ;
18624: l_datetrack_mode varchar2(80) := hr_api.g_update;
18625: l_process_date date;
18626: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
18627: --
18628: --UPD END
18963: end if;
18964: --
18965: -- Delete the row if it is end dated.
18966: --
18967: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
18968: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
18969: trunc(l_max_eed) = r_TTP.information3) then
18970: --
18971: BEN_TTL_PRTT_RT_API.delete_TTL_PRTT_RT(
18975: ,p_effective_start_date => l_effective_start_date
18976: ,p_effective_end_date => l_effective_end_date
18977: ,p_object_version_number => l_object_version_number
18978: ,p_effective_date => l_max_eed
18979: ,p_datetrack_mode => hr_api.g_delete
18980: --
18981: );
18982: --
18983: end if;
19120: l_current_pk_id number := null ;
19121: --UPD START
19122: --
19123: l_update boolean := false ;
19124: l_datetrack_mode varchar2(80) := hr_api.g_update;
19125: l_process_date date;
19126: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
19127: --
19128: --UPD END
19461: end if;
19462: --
19463: -- Delete the row if it is end dated.
19464: --
19465: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
19466: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
19467: trunc(l_max_eed) = r_TCV.information3) then
19468: --
19469: BEN_TTL_CVG_VOL_RT_API.delete_TTL_CVG_VOL_RT(
19473: ,p_effective_start_date => l_effective_start_date
19474: ,p_effective_end_date => l_effective_end_date
19475: ,p_object_version_number => l_object_version_number
19476: ,p_effective_date => l_max_eed
19477: ,p_datetrack_mode => hr_api.g_delete
19478: --
19479: );
19480: --
19481: end if;
19592: l_current_pk_id number := null ;
19593: --UPD START
19594: --
19595: l_update boolean := false ;
19596: l_datetrack_mode varchar2(80) := hr_api.g_update;
19597: l_process_date date;
19598: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
19599: --
19600: --UPD END
19917: end if;
19918: --
19919: -- Delete the row if it is end dated.
19920: --
19921: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
19922: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
19923: trunc(l_max_eed) = r_VPR.information3) then
19924: --
19925: BEN_VRBL_RT_PRFL_RULE_API.delete_VRBL_RT_PRFL_RULE(
19929: ,p_effective_start_date => l_effective_start_date
19930: ,p_effective_end_date => l_effective_end_date
19931: ,p_object_version_number => l_object_version_number
19932: ,p_effective_date => l_max_eed
19933: ,p_datetrack_mode => hr_api.g_delete
19934: --
19935: );
19936: --
19937: end if;
20073: l_current_pk_id number := null ;
20074: --UPD START
20075: --
20076: l_update boolean := false ;
20077: l_datetrack_mode varchar2(80) := hr_api.g_update;
20078: l_process_date date;
20079: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
20080: --
20081: --UPD END
20414: end if;
20415: --
20416: -- Delete the row if it is end dated.
20417: --
20418: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
20419: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
20420: trunc(l_max_eed) = r_PRT.information3) then
20421: --
20422: BEN_POE_RT_API.delete_POE_RT(
20426: ,p_effective_start_date => l_effective_start_date
20427: ,p_effective_end_date => l_effective_end_date
20428: ,p_object_version_number => l_object_version_number
20429: ,p_effective_date => l_max_eed
20430: ,p_datetrack_mode => hr_api.g_delete
20431: --
20432: );
20433: --
20434: end if;
20549: l_current_pk_id number := null ;
20550: --UPD START
20551: --
20552: l_update boolean := false ;
20553: l_datetrack_mode varchar2(80) := hr_api.g_update;
20554: l_process_date date;
20555: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
20556: --
20557: --UPD END
20880: end if;
20881: --
20882: -- Delete the row if it is end dated.
20883: --
20884: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
20885: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
20886: trunc(l_max_eed) = r_CPN.information3) then
20887: --
20888: BEN_CNTNG_PRTN_PRFL_RT_API.delete_CNTNG_PRTN_PRFL_RT(
20892: ,p_effective_start_date => l_effective_start_date
20893: ,p_effective_end_date => l_effective_end_date
20894: ,p_object_version_number => l_object_version_number
20895: ,p_effective_date => l_max_eed
20896: ,p_datetrack_mode => hr_api.g_delete
20897: --
20898: );
20899: --
20900: end if;
21018: l_current_pk_id number := null ;
21019: --UPD START
21020: --
21021: l_update boolean := false ;
21022: l_datetrack_mode varchar2(80) := hr_api.g_update;
21023: l_process_date date;
21024: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
21025: --
21026: --UPD END
21363: end if;
21364: --
21365: -- Delete the row if it is end dated.
21366: --
21367: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
21368: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
21369: trunc(l_max_eed) = r_PST.information3) then
21370: --
21371: BEN_PSTN_RT_API.delete_PSTN_RT(
21375: ,p_effective_start_date => l_effective_start_date
21376: ,p_effective_end_date => l_effective_end_date
21377: ,p_object_version_number => l_object_version_number
21378: ,p_effective_date => l_max_eed
21379: ,p_datetrack_mode => hr_api.g_delete
21380: --
21381: );
21382: --
21383: end if;
21498: l_current_pk_id number := null ;
21499: --UPD START
21500: --
21501: l_update boolean := false ;
21502: l_datetrack_mode varchar2(80) := hr_api.g_update;
21503: l_process_date date;
21504: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
21505: --
21506: --UPD END
21841: end if;
21842: --
21843: -- Delete the row if it is end dated.
21844: --
21845: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
21846: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
21847: trunc(l_max_eed) = r_WLR.information3) then
21848: --
21849: BEN_WORK_LOC_RATE_API.delete_WORK_LOC_RATE(
21853: ,p_effective_start_date => l_effective_start_date
21854: ,p_effective_end_date => l_effective_end_date
21855: ,p_object_version_number => l_object_version_number
21856: ,p_effective_date => l_max_eed
21857: ,p_datetrack_mode => hr_api.g_delete
21858: --
21859: );
21860: --
21861: end if;
21980: l_current_pk_id number := null ;
21981: --UPD START
21982: --
21983: l_update boolean := false ;
21984: l_datetrack_mode varchar2(80) := hr_api.g_update;
21985: l_process_date date;
21986: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
21987: --
21988: --UPD END
22306: end if;
22307: --
22308: -- Delete the row if it is end dated.
22309: --
22310: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
22311: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
22312: trunc(l_max_eed) = r_PFR.information3) then
22313: --
22314: BEN_PCT_FULL_TIME_RATE_API.delete_PCT_FULL_TIME_RATE(
22318: ,p_effective_start_date => l_effective_start_date
22319: ,p_effective_end_date => l_effective_end_date
22320: ,p_object_version_number => l_object_version_number
22321: ,p_effective_date => l_max_eed
22322: ,p_datetrack_mode => hr_api.g_delete
22323: --
22324: );
22325: --
22326: end if;
22443: l_current_pk_id number := null ;
22444: --UPD START
22445: --
22446: l_update boolean := false ;
22447: l_datetrack_mode varchar2(80) := hr_api.g_update;
22448: l_process_date date;
22449: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
22450: --
22451: --UPD END
22770: end if;
22771: --
22772: -- Delete the row if it is end dated.
22773: --
22774: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
22775: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
22776: trunc(l_max_eed) = r_HWR.information3) then
22777: --
22778: BEN_HRS_WKD_IN_PERIOD_RT_API.delete_HRS_WKD_IN_PERIOD_RT(
22782: ,p_effective_start_date => l_effective_start_date
22783: ,p_effective_end_date => l_effective_end_date
22784: ,p_object_version_number => l_object_version_number
22785: ,p_effective_date => l_max_eed
22786: ,p_datetrack_mode => hr_api.g_delete
22787: --
22788: );
22789: --
22790: end if;
22907: l_current_pk_id number := null ;
22908: --UPD START
22909: --
22910: l_update boolean := false ;
22911: l_datetrack_mode varchar2(80) := hr_api.g_update;
22912: l_process_date date;
22913: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
22914: --
22915: --UPD END
23235: end if;
23236: --
23237: -- Delete the row if it is end dated.
23238: --
23239: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
23240: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
23241: trunc(l_max_eed) = r_CLR.information3) then
23242: --
23243: BEN_COMP_LEVEL_RATE_API.delete_COMP_LEVEL_RATE(
23247: ,p_effective_start_date => l_effective_start_date
23248: ,p_effective_end_date => l_effective_end_date
23249: ,p_object_version_number => l_object_version_number
23250: ,p_effective_date => l_max_eed
23251: ,p_datetrack_mode => hr_api.g_delete
23252: --
23253: );
23254: --
23255: end if;
23366: l_current_pk_id number := null ;
23367: --UPD START
23368: --
23369: l_update boolean := false ;
23370: l_datetrack_mode varchar2(80) := hr_api.g_update;
23371: l_process_date date;
23372: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
23373: --
23374: --UPD END
23691: end if;
23692: --
23693: -- Delete the row if it is end dated.
23694: --
23695: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
23696: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
23697: trunc(l_max_eed) = r_LSR.information3) then
23698: --
23699: BEN_LENGTH_OF_SVC_RATE_API.delete_LENGTH_OF_SVC_RATE(
23703: ,p_effective_start_date => l_effective_start_date
23704: ,p_effective_end_date => l_effective_end_date
23705: ,p_object_version_number => l_object_version_number
23706: ,p_effective_date => l_max_eed
23707: ,p_datetrack_mode => hr_api.g_delete
23708: --
23709: );
23710: --
23711: end if;
23822: l_current_pk_id number := null ;
23823: --UPD START
23824: --
23825: l_update boolean := false ;
23826: l_datetrack_mode varchar2(80) := hr_api.g_update;
23827: l_process_date date;
23828: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
23829: --
23830: --UPD END
24147: end if;
24148: --
24149: -- Delete the row if it is end dated.
24150: --
24151: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
24152: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
24153: trunc(l_max_eed) = r_LRN.information3) then
24154: --
24155: BEN_LVG_RSN_RT_API.delete_LVG_RSN_RT(
24159: ,p_effective_start_date => l_effective_start_date
24160: ,p_effective_end_date => l_effective_end_date
24161: ,p_object_version_number => l_object_version_number
24162: ,p_effective_date => l_max_eed
24163: ,p_datetrack_mode => hr_api.g_delete
24164: --
24165: );
24166: --
24167: end if;
24284: l_current_pk_id number := null ;
24285: --UPD START
24286: --
24287: l_update boolean := false ;
24288: l_datetrack_mode varchar2(80) := hr_api.g_update;
24289: l_process_date date;
24290: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
24291: --
24292: --UPD END
24611: end if;
24612: --
24613: -- Delete the row if it is end dated.
24614: --
24615: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
24616: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
24617: trunc(l_max_eed) = r_ART.information3) then
24618: --
24619: BEN_AGE_RATES_API.delete_AGE_RATES(
24623: ,p_effective_start_date => l_effective_start_date
24624: ,p_effective_end_date => l_effective_end_date
24625: ,p_object_version_number => l_object_version_number
24626: ,p_effective_date => l_max_eed
24627: ,p_datetrack_mode => hr_api.g_delete
24628: --
24629: );
24630: --
24631: end if;
24777: l_current_pk_id number := null ;
24778: --UPD START
24779: --
24780: l_update boolean := false ;
24781: l_datetrack_mode varchar2(80) := hr_api.g_update;
24782: l_process_date date;
24783: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
24784: --
24785: --UPD END
25125: end if;
25126: --
25127: -- Delete the row if it is end dated.
25128: --
25129: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
25130: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
25131: trunc(l_max_eed) = r_SHR.information3) then
25132: --
25133: BEN_SCHEDD_HRS_RATE_API.delete_SCHEDD_HRS_RATE(
25137: ,p_effective_start_date => l_effective_start_date
25138: ,p_effective_end_date => l_effective_end_date
25139: ,p_object_version_number => l_object_version_number
25140: ,p_effective_date => l_max_eed
25141: ,p_datetrack_mode => hr_api.g_delete
25142: --
25143: );
25144: --
25145: end if;
25263: l_current_pk_id number := null ;
25264: --UPD START
25265: --
25266: l_update boolean := false ;
25267: l_datetrack_mode varchar2(80) := hr_api.g_update;
25268: l_process_date date;
25269: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
25270: --
25271: --UPD END
25590: end if;
25591: --
25592: -- Delete the row if it is end dated.
25593: --
25594: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
25595: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
25596: trunc(l_max_eed) = r_QIG.information3) then
25597: --
25598: BEN_QUA_IN_GR_RT_API.delete_QUA_IN_GR_RT(
25602: ,p_effective_start_date => l_effective_start_date
25603: ,p_effective_end_date => l_effective_end_date
25604: ,p_object_version_number => l_object_version_number
25605: ,p_effective_date => l_max_eed
25606: ,p_datetrack_mode => hr_api.g_delete
25607: --
25608: );
25609: --
25610: end if;
25731: l_current_pk_id number := null ;
25732: --UPD START
25733: --
25734: l_update boolean := false ;
25735: l_datetrack_mode varchar2(80) := hr_api.g_update;
25736: l_process_date date;
25737: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
25738: --
25739: --UPD END
26061: end if;
26062: --
26063: -- Delete the row if it is end dated.
26064: --
26065: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
26066: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
26067: trunc(l_max_eed) = r_PRR.information3) then
26068: --
26069: BEN_PERF_RTNG_RT_API.delete_PERF_RTNG_RT(
26073: ,p_effective_start_date => l_effective_start_date
26074: ,p_effective_end_date => l_effective_end_date
26075: ,p_object_version_number => l_object_version_number
26076: ,p_effective_date => l_max_eed
26077: ,p_datetrack_mode => hr_api.g_delete
26078: --
26079: );
26080: --
26081: end if;
26193: l_current_pk_id number := null ;
26194: --UPD START
26195: --
26196: l_update boolean := false ;
26197: l_datetrack_mode varchar2(80) := hr_api.g_update;
26198: l_process_date date;
26199: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
26200: --
26201: --UPD END
26518: end if;
26519: --
26520: -- Delete the row if it is end dated.
26521: --
26522: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
26523: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
26524: trunc(l_max_eed) = r_PGR.information3) then
26525: --
26526: BEN_PEOPLE_GROUP_RATE_API.delete_PEOPLE_GROUP_RATE(
26530: ,p_effective_start_date => l_effective_start_date
26531: ,p_effective_end_date => l_effective_end_date
26532: ,p_object_version_number => l_object_version_number
26533: ,p_effective_date => l_max_eed
26534: ,p_datetrack_mode => hr_api.g_delete
26535: --
26536: );
26537: --
26538: end if;