[Home] [Help]
19: hr_utility.set_location('p_effective_start_date '||p_effective_start_date,10);
20: hr_utility.set_location('p_effective_end_date '||p_effective_end_date,10);
21: hr_utility.set_location('p_effective_date '||p_effective_date,10);
22: --
23: if p_effective_end_date <> hr_api.g_eot then
24: --
25: if p_dml_operation = 'INSERT' then
26: --
27: l_datetrack_mode := hr_api.g_update;
23: if p_effective_end_date <> hr_api.g_eot then
24: --
25: if p_dml_operation = 'INSERT' then
26: --
27: l_datetrack_mode := hr_api.g_update;
28: l_update := true;
29: --
30: elsif l_datetrack_mode in ('CORRECTION') then
31: --
28: l_update := true;
29: --
30: elsif l_datetrack_mode in ('CORRECTION') then
31: --
32: l_datetrack_mode := hr_api.g_correction ;
33: l_update := true;
34: --
35: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
36: --
34: --
35: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
36: --
37: if p_effective_date = p_effective_start_date then
38: l_datetrack_mode := hr_api.g_correction ;
39: l_update := true;
40: else
41: --
42: if l_datetrack_mode in ('UPDATE_OVERRIDE') then
40: else
41: --
42: if l_datetrack_mode in ('UPDATE_OVERRIDE') then
43: --
44: l_datetrack_mode := hr_api.g_update_override ;
45: l_update := false ;
46: --
47: elsif l_datetrack_mode in ('UPDATE') then
48: --
45: l_update := false ;
46: --
47: elsif l_datetrack_mode in ('UPDATE') then
48: --
49: l_datetrack_mode := hr_api.g_update;
50: --
51: end if;
52: --
53: end if;
54: --
55: elsif l_datetrack_mode in ('UPDATE_CHANGE_INSERT') then
56: --
57: if p_effective_date = p_effective_start_date then
58: l_datetrack_mode := hr_api.g_correction ;
59: l_update := true;
60: else
61: l_datetrack_mode := hr_api.g_update_change_insert ;
62: l_update := true;
57: if p_effective_date = p_effective_start_date then
58: l_datetrack_mode := hr_api.g_correction ;
59: l_update := true;
60: else
61: l_datetrack_mode := hr_api.g_update_change_insert ;
62: l_update := true;
63: end if;
64: --
65: else
63: end if;
64: --
65: else
66: --
67: l_datetrack_mode := hr_api.g_update;
68: l_update := false;
69: --
70: end if;
71: --
72: else
73: --
74: if p_dml_operation = 'INSERT' then
75: --
76: l_datetrack_mode := hr_api.g_update;
77: l_update := false;
78: --
79: elsif l_datetrack_mode in ('CORRECTION') then
80: --
77: l_update := false;
78: --
79: elsif l_datetrack_mode in ('CORRECTION') then
80: --
81: l_datetrack_mode := hr_api.g_correction ;
82: l_update := false;
83: --
84: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
85: --
83: --
84: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
85: --
86: if p_effective_date = p_effective_start_date then
87: l_datetrack_mode := hr_api.g_correction ;
88: l_update := true;
89: else
90: l_datetrack_mode := hr_api.g_update ;
91: l_update := false ;
86: if p_effective_date = p_effective_start_date then
87: l_datetrack_mode := hr_api.g_correction ;
88: l_update := true;
89: else
90: l_datetrack_mode := hr_api.g_update ;
91: l_update := false ;
92: end if;
93: --
94: elsif l_datetrack_mode in ('UPDATE_CHANGE_INSERT') then
93: --
94: elsif l_datetrack_mode in ('UPDATE_CHANGE_INSERT') then
95: --
96: if p_effective_date = p_effective_start_date then
97: l_datetrack_mode := hr_api.g_correction ;
98: l_update := false;
99: else
100: l_datetrack_mode := hr_api.g_update ;
101: l_update := false;
96: if p_effective_date = p_effective_start_date then
97: l_datetrack_mode := hr_api.g_correction ;
98: l_update := false;
99: else
100: l_datetrack_mode := hr_api.g_update ;
101: l_update := false;
102: end if;
103: --
104: else
102: end if;
103: --
104: else
105: --
106: l_datetrack_mode := hr_api.g_update;
107: l_update := false;
108: --
109: end if;
110: --
301: --
302: --UPD START
303: --
304: l_update boolean := false ;
305: l_datetrack_mode varchar2(80) := hr_api.g_update;
306: l_process_date date;
307: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
308: --
309: --UPD END
645: end if;
646: --
647: -- Delete the row if it is end dated.
648: --
649: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
650: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
651: trunc(l_max_eed) = r_PRB.information3) then
652: --
653: BEN_PLAN_REGULATORY_BODY_API.delete_PLAN_REGULATORY_BODY(
657: ,p_effective_start_date => l_effective_start_date
658: ,p_effective_end_date => l_effective_end_date
659: ,p_object_version_number => l_object_version_number
660: ,p_effective_date => l_max_eed
661: ,p_datetrack_mode => hr_api.g_delete
662: --
663: );
664: --
665: end if;
780: --
781: --UPD START
782: --
783: l_update boolean := false ;
784: l_datetrack_mode varchar2(80) := hr_api.g_update;
785: l_process_date date;
786: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
787: --
788: --UPD END
1108: end if;
1109: --
1110: -- Delete the row if it is end dated.
1111: --
1112: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
1113: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
1114: trunc(l_max_eed) = r_SAZ.information3) then
1115: --
1116: BEN_SVC_AREA_PSTL_ZIP_RNG_API.delete_SVC_AREA_PSTL_ZIP_RNG(
1120: ,p_effective_start_date => l_effective_start_date
1121: ,p_effective_end_date => l_effective_end_date
1122: ,p_object_version_number => l_object_version_number
1123: ,p_effective_date => l_max_eed
1124: ,p_datetrack_mode => hr_api.g_delete
1125: --
1126: );
1127: --
1128: end if;
1244: --
1245: --UPD START
1246: --
1247: l_update boolean := false ;
1248: l_datetrack_mode varchar2(80) := hr_api.g_update;
1249: l_process_date date;
1250: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
1251: --
1252: --UPD END
1596: end if;
1597: --
1598: -- Delete the row if it is end dated.
1599: --
1600: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
1601: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
1602: trunc(l_max_eed) = r_PCX.information3) then
1603: --
1604: BEN_PLAN_BENEFICIARY_CTFN_API.delete_PLAN_BENEFICIARY_CTFN(
1608: ,p_effective_start_date => l_effective_start_date
1609: ,p_effective_end_date => l_effective_end_date
1610: ,p_object_version_number => l_object_version_number
1611: ,p_effective_date => l_max_eed
1612: ,p_datetrack_mode => hr_api.g_delete
1613: --
1614: );
1615: --
1616: end if;
1725: --
1726: --UPD START
1727: --
1728: l_update boolean := false ;
1729: l_datetrack_mode varchar2(80) := hr_api.g_update;
1730: l_process_date date;
1731: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
1732: --
1733: --UPD END
2070: end if;
2071: --
2072: -- Delete the row if it is end dated.
2073: --
2074: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
2075: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
2076: trunc(l_max_eed) = r_PND.information3) then
2077: --
2078: BEN_PLAN_DPNT_CVG_CTFN_API.delete_PLAN_DPNT_CVG_CTFN(
2082: ,p_effective_start_date => l_effective_start_date
2083: ,p_effective_end_date => l_effective_end_date
2084: ,p_object_version_number => l_object_version_number
2085: ,p_effective_date => l_max_eed
2086: ,p_datetrack_mode => hr_api.g_delete
2087: --
2088: );
2089: --
2090: end if;
2203: --
2204: --UPD START
2205: --
2206: l_update boolean := false ;
2207: l_datetrack_mode varchar2(80) := hr_api.g_update;
2208: l_process_date date;
2209: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
2210: --
2211: --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_LPE.information3) then
2565: --
2566: BEN_LER_CHG_PL_NIP_ENRT_API.delete_LER_CHG_PL_NIP_ENRT(
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;
2691: --
2692: --UPD START
2693: --
2694: l_update boolean := false ;
2695: l_datetrack_mode varchar2(80) := hr_api.g_update;
2696: l_process_date date;
2697: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
2698: --
2699: --UPD END
3039: end if;
3040: --
3041: -- Delete the row if it is end dated.
3042: --
3043: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
3044: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
3045: trunc(l_max_eed) = r_LOP.information3) then
3046: --
3047: BEN_LER_CHG_OIPL_ENRT_API.delete_LER_CHG_OIPL_ENRT(
3051: ,p_effective_start_date => l_effective_start_date
3052: ,p_effective_end_date => l_effective_end_date
3053: ,p_object_version_number => l_object_version_number
3054: ,p_effective_date => l_max_eed
3055: ,p_datetrack_mode => hr_api.g_delete
3056: --
3057: );
3058: --
3059: end if;
3171: --
3172: --UPD START
3173: --
3174: l_update boolean := false ;
3175: l_datetrack_mode varchar2(80) := hr_api.g_update;
3176: l_process_date date;
3177: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
3178: --
3179: --UPD END
3514: end if;
3515: --
3516: -- Delete the row if it is end dated.
3517: --
3518: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
3519: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
3520: trunc(l_max_eed) = r_LNC.information3) then
3521: --
3522: BEN_LER_ENRT_CTFN_API.delete_LER_ENRT_CTFN(
3526: ,p_effective_start_date => l_effective_start_date
3527: ,p_effective_end_date => l_effective_end_date
3528: ,p_object_version_number => l_object_version_number
3529: ,p_effective_date => l_max_eed
3530: ,p_datetrack_mode => hr_api.g_delete
3531: --
3532: );
3533: --
3534: end if;
3649: --
3650: --UPD START
3651: --
3652: l_update boolean := false ;
3653: l_datetrack_mode varchar2(80) := hr_api.g_update;
3654: l_process_date date;
3655: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
3656: --
3657: --UPD END
4003: end if;
4004: --
4005: -- Delete the row if it is end dated.
4006: --
4007: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
4008: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
4009: trunc(l_max_eed) = r_LRE.information3) then
4010: --
4011: BEN_LER_RQRS_ENRT_CTFN_API.delete_LER_RQRS_ENRT_CTFN(
4015: ,p_effective_start_date => l_effective_start_date
4016: ,p_effective_end_date => l_effective_end_date
4017: ,p_object_version_number => l_object_version_number
4018: ,p_effective_date => l_max_eed
4019: ,p_datetrack_mode => hr_api.g_delete
4020: --
4021: );
4022: --
4023: end if;
4136: --
4137: --UPD START
4138: --
4139: l_update boolean := false ;
4140: l_datetrack_mode varchar2(80) := hr_api.g_update;
4141: l_process_date date;
4142: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
4143: --
4144: --UPD END
4477: end if;
4478: --
4479: -- Delete the row if it is end dated.
4480: --
4481: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
4482: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
4483: trunc(l_max_eed) = r_LBC.information3) then
4484: --
4485: BEN_LER_BNFT_RSTRN_CTFN_API.delete_LER_BNFT_RSTRN_CTFN(
4489: ,p_effective_start_date => l_effective_start_date
4490: ,p_effective_end_date => l_effective_end_date
4491: ,p_object_version_number => l_object_version_number
4492: ,p_effective_date => l_max_eed
4493: ,p_datetrack_mode => hr_api.g_delete
4494: --
4495: );
4496: --
4497: end if;
4610: --
4611: --UPD START
4612: --
4613: l_update boolean := false ;
4614: l_datetrack_mode varchar2(80) := hr_api.g_update;
4615: l_process_date date;
4616: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
4617: --
4618: --UPD END
4944: end if;
4945: --
4946: -- Delete the row if it is end dated.
4947: --
4948: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
4949: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
4950: trunc(l_max_eed) = r_BRC.information3) then
4951: --
4952: BEN_BNFT_RSTRN_CTFN_API.delete_BNFT_RSTRN_CTFN(
4956: ,p_effective_start_date => l_effective_start_date
4957: ,p_effective_end_date => l_effective_end_date
4958: ,p_object_version_number => l_object_version_number
4959: ,p_effective_date => l_max_eed
4960: ,p_datetrack_mode => hr_api.g_delete
4961: --
4962: );
4963: --
4964: end if;
5077: --
5078: --UPD START
5079: --
5080: l_update boolean := false ;
5081: l_datetrack_mode varchar2(80) := hr_api.g_update;
5082: l_process_date date;
5083: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
5084: --
5085: --UPD END
5423: end if;
5424: --
5425: -- Delete the row if it is end dated.
5426: --
5427: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
5428: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
5429: trunc(l_max_eed) = r_WCN.information3) then
5430: --
5431: BEN_WV_PRTN_RSN_CTFN_PL_API.delete_WV_PRTN_RSN_CTFN_PL(
5435: ,p_effective_start_date => l_effective_start_date
5436: ,p_effective_end_date => l_effective_end_date
5437: ,p_object_version_number => l_object_version_number
5438: ,p_effective_date => l_max_eed
5439: ,p_datetrack_mode => hr_api.g_delete
5440: --
5441: );
5442: --
5443: end if;
5555: --
5556: --UPD START
5557: --
5558: l_update boolean := false ;
5559: l_datetrack_mode varchar2(80) := hr_api.g_update;
5560: l_process_date date;
5561: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
5562: --
5563: --UPD END
5893: end if;
5894: --
5895: -- Delete the row if it is end dated.
5896: --
5897: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
5898: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
5899: trunc(l_max_eed) = r_WPN.information3) then
5900: --
5901: BEN_WV_PRTN_REASON_PL_API.delete_WV_PRTN_REASON_PL(
5905: ,p_effective_start_date => l_effective_start_date
5906: ,p_effective_end_date => l_effective_end_date
5907: ,p_object_version_number => l_object_version_number
5908: ,p_effective_date => l_max_eed
5909: ,p_datetrack_mode => hr_api.g_delete
5910: --
5911: );
5912: --
5913: end if;
6024: --
6025: --UPD START
6026: --
6027: l_update boolean := false ;
6028: l_datetrack_mode varchar2(80) := hr_api.g_update;
6029: l_process_date date;
6030: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6031: --
6032: --UPD END
6359: end if;
6360: --
6361: -- Delete the row if it is end dated.
6362: --
6363: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
6364: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
6365: trunc(l_max_eed) = r_VRP.information3) then
6366: --
6367: BEN_VALD_RLSHP_FOR_REIMB_API.delete_VALD_RLSHP_FOR_REIMB(
6371: ,p_effective_start_date => l_effective_start_date
6372: ,p_effective_end_date => l_effective_end_date
6373: ,p_object_version_number => l_object_version_number
6374: ,p_effective_date => l_max_eed
6375: ,p_datetrack_mode => hr_api.g_delete
6376: --
6377: );
6378: --
6379: end if;
6493: --
6494: --UPD START
6495: --
6496: l_update boolean := false ;
6497: l_datetrack_mode varchar2(80) := hr_api.g_update;
6498: l_process_date date;
6499: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6500: --
6501: --UPD END
6840: end if;
6841: --
6842: -- Delete the row if it is end dated.
6843: --
6844: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
6845: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
6846: trunc(l_max_eed) = r_PCT.information3) then
6847: --
6848: BEN_PLAN_GOODS_SERV_CERT_API.delete_PLAN_GOODS_SERV_CERT(
6852: ,p_effective_start_date => l_effective_start_date
6853: ,p_effective_end_date => l_effective_end_date
6854: ,p_object_version_number => l_object_version_number
6855: ,p_effective_date => l_max_eed
6856: ,p_datetrack_mode => hr_api.g_delete
6857: --
6858: );
6859: --
6860: end if;
6971: --
6972: --UPD START
6973: --
6974: l_update boolean := false ;
6975: l_datetrack_mode varchar2(80) := hr_api.g_update;
6976: l_process_date date;
6977: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6978: --
6979: --UPD END
7308: --
7309: ,P_EFFECTIVE_START_DATE => l_effective_start_date
7310: ,P_EFFECTIVE_END_DATE => l_effective_end_date
7311: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
7312: ,P_DATETRACK_MODE => hr_api.g_update
7313: );
7314: --
7315: end if;
7316: --
7315: end if;
7316: --
7317: -- Delete the row if it is end dated.
7318: --
7319: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
7320: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
7321: trunc(l_max_eed) = r_VGS.information3) then
7322: --
7323: BEN_PLAN_GOODS_SERVICES_API.delete_PLAN_GOODS_SERVICES(
7454: --
7455: --UPD START
7456: --
7457: l_update boolean := false ;
7458: l_datetrack_mode varchar2(80) := hr_api.g_update;
7459: l_process_date date;
7460: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
7461: --
7462: --UPD END
7837: end if;
7838: --
7839: -- Delete the row if it is end dated.
7840: --
7841: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
7842: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
7843: trunc(l_max_eed) = r_LBR.information3) then
7844: --
7845: BEN_LER_BNFT_RSTRN_API.delete_LER_BNFT_RSTRN(
7849: ,p_effective_start_date => l_effective_start_date
7850: ,p_effective_end_date => l_effective_end_date
7851: ,p_object_version_number => l_object_version_number
7852: ,p_effective_date => l_max_eed
7853: ,p_datetrack_mode => hr_api.g_delete
7854: --
7855: );
7856: --
7857:
7972: --
7973: --UPD START
7974: --
7975: l_update boolean := false ;
7976: l_datetrack_mode varchar2(80) := hr_api.g_update;
7977: l_process_date date;
7978: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
7979: --
7980: --UPD END
8329: end if;
8330: --
8331: -- Delete the row if it is end dated.
8332: --
8333: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
8334: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
8335: trunc(l_max_eed) = r_LPR1.information3) then
8336: --
8337: BEN_LER_CHG_PLAN_ENRT_API.delete_LER_CHG_PLAN_ENRT(
8341: ,p_effective_start_date => l_effective_start_date
8342: ,p_effective_end_date => l_effective_end_date
8343: ,p_object_version_number => l_object_version_number
8344: ,p_effective_date => l_max_eed
8345: ,p_datetrack_mode => hr_api.g_delete
8346: --
8347: );
8348: --
8349: end if;
8477: --
8478: --UPD START
8479: --
8480: l_update boolean := false ;
8481: l_datetrack_mode varchar2(80) := hr_api.g_update;
8482: l_process_date date;
8483: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
8484: --
8485: --UPD END
8933: end if;
8934: --
8935: -- Delete the row if it is end dated.
8936: --
8937: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
8938: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
8939: trunc(l_max_eed) = r_CPP.information3) then
8940: --
8941: BEN_PLAN_IN_PROGRAM_API.delete_PLAN_IN_PROGRAM(
8945: ,p_effective_start_date => l_effective_start_date
8946: ,p_effective_end_date => l_effective_end_date
8947: ,p_object_version_number => l_object_version_number
8948: ,p_effective_date => l_max_eed
8949: ,p_datetrack_mode => hr_api.g_delete
8950: --
8951: );
8952: --
8953: end if;
9070: --
9071: --UPD START
9072: --
9073: l_update boolean := false ;
9074: l_datetrack_mode varchar2(80) := hr_api.g_update;
9075: l_process_date date;
9076: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
9077: --
9078: --UPD END
9419: end if;
9420: --
9421: -- Delete the row if it is end dated.
9422: --
9423: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
9424: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
9425: trunc(l_max_eed) = r_PYD.information3) then
9426: --
9427: BEN_PTIP_DPNT_CVG_CTFN_API.delete_PTIP_DPNT_CVG_CTFN(
9431: ,p_effective_start_date => l_effective_start_date
9432: ,p_effective_end_date => l_effective_end_date
9433: ,p_object_version_number => l_object_version_number
9434: ,p_effective_date => l_max_eed
9435: ,p_datetrack_mode => hr_api.g_delete
9436: --
9437: );
9438: --
9439: end if;
9552: --
9553: --UPD START
9554: --
9555: l_update boolean := false ;
9556: l_datetrack_mode varchar2(80) := hr_api.g_update;
9557: l_process_date date;
9558: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
9559: --
9560: --UPD END
9915: end if;
9916: --
9917: -- Delete the row if it is end dated.
9918: --
9919: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
9920: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
9921: trunc(l_max_eed) = r_LCT.information3) then
9922: --
9923: BEN_LER_CHG_PTIP_ENRT_API.delete_LER_CHG_PTIP_ENRT(
9927: ,p_effective_start_date => l_effective_start_date
9928: ,p_effective_end_date => l_effective_end_date
9929: ,p_object_version_number => l_object_version_number
9930: ,p_effective_date => l_max_eed
9931: ,p_datetrack_mode => hr_api.g_delete
9932: --
9933: );
9934: --
9935: end if;
10047: --
10048: --UPD START
10049: --
10050: l_update boolean := false ;
10051: l_datetrack_mode varchar2(80) := hr_api.g_update;
10052: l_process_date date;
10053: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
10054: --
10055: --UPD END
10393: end if;
10394: --
10395: -- Delete the row if it is end dated.
10396: --
10397: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
10398: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
10399: trunc(l_max_eed) = r_WCT.information3) then
10400: --
10401: BEN_WV_PRTN_RSN_CTFN_PTIP_API.delete_WV_PRTN_RSN_CTFN_PTIP(
10405: ,p_effective_start_date => l_effective_start_date
10406: ,p_effective_end_date => l_effective_end_date
10407: ,p_object_version_number => l_object_version_number
10408: ,p_effective_date => l_max_eed
10409: ,p_datetrack_mode => hr_api.g_delete
10410: --
10411: );
10412: --
10413: end if;
10525: --
10526: --UPD START
10527: --
10528: l_update boolean := false ;
10529: l_datetrack_mode varchar2(80) := hr_api.g_update;
10530: l_process_date date;
10531: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
10532: --
10533: --UPD END
10863: end if;
10864: --
10865: -- Delete the row if it is end dated.
10866: --
10867: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
10868: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
10869: trunc(l_max_eed) = r_WPT.information3) then
10870: --
10871: BEN_WV_PRTN_RSN_PTIP_API.delete_WV_PRTN_RSN_PTIP(
10875: ,p_effective_start_date => l_effective_start_date
10876: ,p_effective_end_date => l_effective_end_date
10877: ,p_object_version_number => l_object_version_number
10878: ,p_effective_date => l_max_eed
10879: ,p_datetrack_mode => hr_api.g_delete
10880: --
10881: );
10882: --
10883: end if;
11018: --
11019: --UPD START
11020: --
11021: l_update boolean := false ;
11022: l_datetrack_mode varchar2(80) := hr_api.g_update;
11023: l_process_date date;
11024: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
11025: --
11026: --UPD END
11521: end if;
11522: --
11523: -- Delete the row if it is end dated.
11524: --
11525: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
11526: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
11527: trunc(l_max_eed) = r_CTP.information3) then
11528: --
11529: BEN_PLAN_TYPE_IN_PROGRAM_API.delete_PLAN_TYPE_IN_PROGRAM(
11533: ,p_effective_start_date => l_effective_start_date
11534: ,p_effective_end_date => l_effective_end_date
11535: ,p_object_version_number => l_object_version_number
11536: ,p_effective_date => l_max_eed
11537: ,p_datetrack_mode => hr_api.g_delete
11538: --
11539: );
11540: --
11541: end if;
11654: --
11655: --UPD START
11656: --
11657: l_update boolean := false ;
11658: l_datetrack_mode varchar2(80) := hr_api.g_update;
11659: l_process_date date;
11660: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
11661: --
11662: --UPD END
11999: end if;
12000: --
12001: -- Delete the row if it is end dated.
12002: --
12003: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
12004: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
12005: trunc(l_max_eed) = r_LCC.information3) then
12006: --
12007: BEN_LER_CHG_DPNT_CVG_CTF_API.delete_LER_CHG_DPNT_CVG_CTF(
12011: ,p_effective_start_date => l_effective_start_date
12012: ,p_effective_end_date => l_effective_end_date
12013: ,p_object_version_number => l_object_version_number
12014: ,p_effective_date => l_max_eed
12015: ,p_datetrack_mode => hr_api.g_delete
12016: --
12017: );
12018: --
12019: end if;
12130: --
12131: --UPD START
12132: --
12133: l_update boolean := false ;
12134: l_datetrack_mode varchar2(80) := hr_api.g_update;
12135: l_process_date date;
12136: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
12137: --
12138: --UPD END
12471: end if;
12472: --
12473: -- Delete the row if it is end dated.
12474: --
12475: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
12476: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
12477: trunc(l_max_eed) = r_cer.information3) then
12478: --
12479: BEN_ELIGIBILITY_RULE_API.delete_ELIGIBILITY_RULE(
12483: ,p_effective_start_date => l_effective_start_date
12484: ,p_effective_end_date => l_effective_end_date
12485: ,p_object_version_number => l_object_version_number
12486: ,p_effective_date => l_max_eed
12487: ,p_datetrack_mode => hr_api.g_delete
12488: --
12489: );
12490: --
12491: end if;
12602: --
12603: --UPD START
12604: --
12605: l_update boolean := false ;
12606: l_datetrack_mode varchar2(80) := hr_api.g_update;
12607: l_process_date date;
12608: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
12609: --
12610: --UPD END
12941: end if;
12942: --
12943: -- Delete the row if it is end dated.
12944: --
12945: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
12946: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
12947: trunc(l_max_eed) = r_CEP.information3) then
12948: --
12949: BEN_PRTN_ELIG_PRFL_API.delete_PRTN_ELIG_PRFL(
12953: ,p_effective_start_date => l_effective_start_date
12954: ,p_effective_end_date => l_effective_end_date
12955: ,p_object_version_number => l_object_version_number
12956: ,p_effective_date => l_max_eed
12957: ,p_datetrack_mode => hr_api.g_delete
12958: --
12959: );
12960: --
12961: end if;
13077: --
13078: --UPD START
13079: --
13080: l_update boolean := false ;
13081: l_datetrack_mode varchar2(80) := hr_api.g_update;
13082: l_process_date date;
13083: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13084: --
13085: --UPD END
13419: end if;
13420: --
13421: -- Delete the row if it is end dated.
13422: --
13423: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
13424: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
13425: trunc(l_max_eed) = r_CPR.information3) then
13426: --
13427: BEN_POPL_ORG_ROLE_API.delete_POPL_ORG_ROLE(
13431: ,p_effective_start_date => l_effective_start_date
13432: ,p_effective_end_date => l_effective_end_date
13433: ,p_object_version_number => l_object_version_number
13434: ,p_effective_date => l_max_eed
13435: ,p_datetrack_mode => hr_api.g_delete
13436: --
13437: );
13438: --
13439: end if;
13557: --
13558: --UPD START
13559: --
13560: l_update boolean := false ;
13561: l_datetrack_mode varchar2(80) := hr_api.g_update;
13562: l_process_date date;
13563: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13564: --
13565: --UPD END
13934: end if;
13935: --
13936: -- Delete the row if it is end dated.
13937: --
13938: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
13939: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
13940: trunc(l_max_eed) = r_CPO.information3) then
13941: --
13942: BEN_POPL_ORG_API.delete_POPL_ORG(
13946: ,p_effective_start_date => l_effective_start_date
13947: ,p_effective_end_date => l_effective_end_date
13948: ,p_object_version_number => l_object_version_number
13949: ,p_effective_date => l_max_eed
13950: ,p_datetrack_mode => hr_api.g_delete
13951: --
13952: );
13953: --
13954: end if;
14087: --
14088: --UPD START
14089: --
14090: l_update boolean := false ;
14091: l_datetrack_mode varchar2(80) := hr_api.g_update;
14092: l_process_date date;
14093: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
14094: --
14095: --UPD END
14467: end if;
14468: --
14469: -- Delete the row if it is end dated.
14470: --
14471: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
14472: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
14473: trunc(l_max_eed) = r_PRG.information3) then
14474: --
14475: BEN_PLAN_REGULATION_API.delete_PLAN_REGULATION(
14479: ,p_effective_start_date => l_effective_start_date
14480: ,p_effective_end_date => l_effective_end_date
14481: ,p_object_version_number => l_object_version_number
14482: ,p_effective_date => l_max_eed
14483: ,p_datetrack_mode => hr_api.g_delete
14484: --
14485: );
14486: --
14487: end if;
14603: --
14604: --UPD START
14605: --
14606: l_update boolean := false ;
14607: l_datetrack_mode varchar2(80) := hr_api.g_update;
14608: l_process_date date;
14609: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
14610: --
14611: --UPD END
14947: end if;
14948: --
14949: -- Delete the row if it is end dated.
14950: --
14951: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
14952: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
14953: trunc(l_max_eed) = r_RGR.information3) then
14954: --
14955: BEN_POPL_RPTG_GRP_API.delete_POPL_RPTG_GRP(
14959: ,p_effective_start_date => l_effective_start_date
14960: ,p_effective_end_date => l_effective_end_date
14961: ,p_object_version_number => l_object_version_number
14962: ,p_effective_date => l_max_eed
14963: ,p_datetrack_mode => hr_api.g_delete
14964: --
14965: );
14966: --
14967: end if;
15085: --
15086: --UPD START
15087: --
15088: l_update boolean := false ;
15089: l_datetrack_mode varchar2(80) := hr_api.g_update;
15090: l_process_date date;
15091: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
15092: --
15093: --UPD END
15427: end if;
15428: --
15429: -- Delete the row if it is end dated.
15430: --
15431: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
15432: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
15433: trunc(l_max_eed) = r_ECF.information3) then
15434: --
15435: BEN_ENRT_CTFN_API.delete_ENRT_CTFN(
15439: ,p_effective_start_date => l_effective_start_date
15440: ,p_effective_end_date => l_effective_end_date
15441: ,p_object_version_number => l_object_version_number
15442: ,p_effective_date => l_max_eed
15443: ,p_datetrack_mode => hr_api.g_delete
15444: --
15445: );
15446: --
15447: end if;
15576: --
15577: --UPD START
15578: --
15579: l_update boolean := false ;
15580: l_datetrack_mode varchar2(80) := hr_api.g_update;
15581: l_process_date date;
15582: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
15583: --
15584: --UPD END
15955: end if;
15956: --
15957: -- Delete the row if it is end dated.
15958: --
15959: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
15960: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
15961: trunc(l_max_eed) = r_EPA.information3) then
15962: --
15963: BEN_PARTICIPATION_ELIG_API.delete_PARTICIPATION_ELIG(
15967: ,p_effective_start_date => l_effective_start_date
15968: ,p_effective_end_date => l_effective_end_date
15969: ,p_object_version_number => l_object_version_number
15970: ,p_effective_date => l_max_eed
15971: ,p_datetrack_mode => hr_api.g_delete
15972: --
15973: );
15974: --
15975: end if;
16062: --
16063: --UPD START
16064: --
16065: l_update boolean := false ;
16066: l_datetrack_mode varchar2(80) := hr_api.g_update;
16067: l_process_date date;
16068: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
16069: --
16070: --UPD END
16435: --
16436: --UPD START
16437: --
16438: l_update boolean := false ;
16439: l_datetrack_mode varchar2(80) := hr_api.g_update;
16440: l_process_date date;
16441: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
16442: --
16443: --UPD END
16769: end if;
16770: --
16771: -- Delete the row if it is end dated.
16772: --
16773: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
16774: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
16775: trunc(l_max_eed) = r_PET.information3) then
16776: --
16777: BEN_POPL_ENRT_TYP_CYCL_API.delete_POPL_ENRT_TYP_CYCL(
16781: ,p_effective_start_date => l_effective_start_date
16782: ,p_effective_end_date => l_effective_end_date
16783: ,p_object_version_number => l_object_version_number
16784: ,p_effective_date => l_max_eed
16785: ,p_datetrack_mode => hr_api.g_delete
16786: --
16787: );
16788: --
16789: end if;
16885: --
16886: --UPD START
16887: --
16888: l_update boolean := false ;
16889: l_datetrack_mode varchar2(80) := hr_api.g_update;
16890: l_process_date date;
16891: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
16892: --
16893: --UPD END
17368: --
17369: --UPD START
17370: --
17371: l_update boolean := false ;
17372: l_datetrack_mode varchar2(80) := hr_api.g_update;
17373: l_process_date date;
17374: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
17375: --
17376: --UPD END
17755: end if;
17756: --
17757: -- Delete the row if it is end dated.
17758: --
17759: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
17760: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
17761: trunc(l_max_eed) = r_LEN.information3) then
17762: --
17763: BEN_LIFE_EVENT_ENROLL_RSN_API.delete_LIFE_EVENT_ENROLL_RSN(
17767: ,p_effective_start_date => l_effective_start_date
17768: ,p_effective_end_date => l_effective_end_date
17769: ,p_object_version_number => l_object_version_number
17770: ,p_effective_date => l_max_eed
17771: ,p_datetrack_mode => hr_api.g_delete
17772: --
17773: );
17774: --
17775: end if;
17893: --
17894: --UPD START
17895: --
17896: l_update boolean := false ;
17897: l_datetrack_mode varchar2(80) := hr_api.g_update;
17898: l_process_date date;
17899: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
17900: --
17901: --UPD END
18253: end if;
18254: --
18255: -- Delete the row if it is end dated.
18256: --
18257: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
18258: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
18259: trunc(l_max_eed) = r_ERP.information3) then
18260: --
18261: BEN_ENRT_PERD_FOR_PL_API.delete_ENRT_PERD_FOR_PL(
18265: ,p_effective_start_date => l_effective_start_date
18266: ,p_effective_end_date => l_effective_end_date
18267: ,p_object_version_number => l_object_version_number
18268: ,p_effective_date => l_max_eed
18269: ,p_datetrack_mode => hr_api.g_delete
18270: --
18271: );
18272: --
18273: end if;
18381: --
18382: --UPD START
18383: --
18384: l_update boolean := false ;
18385: l_datetrack_mode varchar2(80) := hr_api.g_update;
18386: l_process_date date;
18387: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
18388: --
18389: --UPD END
18717: end if;
18718: --
18719: -- Delete the row if it is end dated.
18720: --
18721: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
18722: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
18723: trunc(l_max_eed) = r_SER.information3) then
18724: --
18725: BEN_SCHEDD_ENROLLMENT_RL_API.delete_SCHEDD_ENROLLMENT_RL(
18729: ,p_effective_start_date => l_effective_start_date
18730: ,p_effective_end_date => l_effective_end_date
18731: ,p_object_version_number => l_object_version_number
18732: ,p_effective_date => l_max_eed
18733: ,p_datetrack_mode => hr_api.g_delete
18734: --
18735: );
18736: --
18737: end if;
18844: --
18845: --UPD START
18846: --
18847: l_update boolean := false ;
18848: l_datetrack_mode varchar2(80) := hr_api.g_update;
18849: l_process_date date;
18850: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
18851: --
18852: --UPD END
19180: end if;
19181: --
19182: -- Delete the row if it is end dated.
19183: --
19184: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
19185: trunc(l_max_eed) = r_LRR.information3) then
19186: --
19187: BEN_LEE_RSN_RL_API.delete_LEE_RSN_RL(
19188: --
19191: ,p_effective_start_date => l_effective_start_date
19192: ,p_effective_end_date => l_effective_end_date
19193: ,p_object_version_number => l_object_version_number
19194: ,p_effective_date => l_max_eed
19195: ,p_datetrack_mode => hr_api.g_delete
19196: --
19197: );
19198: --
19199: end if;
19315: --
19316: --UPD START
19317: --
19318: l_update boolean := false ;
19319: l_datetrack_mode varchar2(80) := hr_api.g_update;
19320: l_process_date date;
19321: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
19322: --
19323: --UPD END
19660: end if;
19661: --
19662: -- Delete the row if it is end dated.
19663: --
19664: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
19665: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
19666: trunc(l_max_eed) = r_ADE.information3) then
19667: --
19668: BEN_APLD_DPNT_CVG_PRFL_API.delete_APLD_DPNT_CVG_PRFL(
19672: ,p_effective_start_date => l_effective_start_date
19673: ,p_effective_end_date => l_effective_end_date
19674: ,p_object_version_number => l_object_version_number
19675: ,p_effective_date => l_max_eed
19676: ,p_datetrack_mode => hr_api.g_delete
19677: --
19678: );
19679: --
19680: end if;
19789: --
19790: --UPD START
19791: --
19792: l_update boolean := false ;
19793: l_datetrack_mode varchar2(80) := hr_api.g_update;
19794: l_process_date date;
19795: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
19796: --
19797: --UPD END
20134: end if;
20135: --
20136: -- Delete the row if it is end dated.
20137: --
20138: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
20139: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
20140: trunc(l_max_eed) = r_PGC.information3) then
20141: --
20142: BEN_PROGRAM_DPNT_CVG_CTFN_API.delete_PROGRAM_DPNT_CVG_CTFN(
20146: ,p_effective_start_date => l_effective_start_date
20147: ,p_effective_end_date => l_effective_end_date
20148: ,p_object_version_number => l_object_version_number
20149: ,p_effective_date => l_max_eed
20150: ,p_datetrack_mode => hr_api.g_delete
20151: --
20152: );
20153: --
20154: end if;
20264: --
20265: --UPD START
20266: --
20267: l_update boolean := false ;
20268: l_datetrack_mode varchar2(80) := hr_api.g_update;
20269: l_process_date date;
20270: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
20271: --
20272: --UPD END
20619: end if;
20620: --
20621: -- Delete the row if it is end dated.
20622: --
20623: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
20624: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
20625: trunc(l_max_eed) = r_LGE.information3) then
20626: --
20627: BEN_LER_CHG_PGM_ENRT_API.delete_LER_CHG_PGM_ENRT(
20631: ,p_effective_start_date => l_effective_start_date
20632: ,p_effective_end_date => l_effective_end_date
20633: ,p_object_version_number => l_object_version_number
20634: ,p_effective_date => l_max_eed
20635: ,p_datetrack_mode => hr_api.g_delete
20636: --
20637: );
20638: --
20639: end if;
20758: --
20759: --UPD START
20760: --
20761: l_update boolean := false ;
20762: l_datetrack_mode varchar2(80) := hr_api.g_update;
20763: l_process_date date;
20764: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
20765: --
20766: --UPD END
21122: end if;
21123: --
21124: -- Delete the row if it is end dated.
21125: --
21126: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
21127: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
21128: trunc(l_max_eed) = r_LDC.information3) then
21129: --
21130: BEN_LER_CHG_DEPENDENT_CVG_API.delete_LER_CHG_DEPENDENT_CVG(
21134: ,p_effective_start_date => l_effective_start_date
21135: ,p_effective_end_date => l_effective_end_date
21136: ,p_object_version_number => l_object_version_number
21137: ,p_effective_date => l_max_eed
21138: ,p_datetrack_mode => hr_api.g_delete
21139: --
21140: );
21141: --
21142: end if;
21250: --
21251: --UPD START
21252: --
21253: l_update boolean := false ;
21254: l_datetrack_mode varchar2(80) := hr_api.g_update;
21255: l_process_date date;
21256: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
21257: --
21258: --UPD END
21601: end if;
21602: --
21603: -- Delete the row if it is end dated.
21604: --
21605: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
21606: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
21607: trunc(l_max_eed) = r_PAT.information3) then
21608: --
21609: BEN_POPL_ACTION_TYPE_API.delete_POPL_ACTION_TYPE(
21613: ,p_effective_start_date => l_effective_start_date
21614: ,p_effective_end_date => l_effective_end_date
21615: ,p_object_version_number => l_object_version_number
21616: ,p_effective_date => l_max_eed
21617: ,p_datetrack_mode => hr_api.g_delete
21618: --
21619: );
21620: --
21621: end if;
21753: --
21754: --UPD START
21755: --
21756: l_update boolean := false ;
21757: l_datetrack_mode varchar2(80) := hr_api.g_update;
21758: l_process_date date;
21759: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
21760: --
21761: --UPD END
22154: end if;
22155: --
22156: -- Delete the row if it is end dated.
22157: --
22158: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
22159: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
22160: trunc(l_max_eed) = r_PEO.information3) then
22161: --
22162: BEN_ELIG_TO_PRTE_REASON_API.delete_ELIG_TO_PRTE_REASON(
22166: ,p_effective_start_date => l_effective_start_date
22167: ,p_effective_end_date => l_effective_end_date
22168: ,p_object_version_number => l_object_version_number
22169: ,p_effective_date => l_max_eed
22170: ,p_datetrack_mode => hr_api.g_delete
22171: --
22172: );
22173: --
22174: end if;
22260: --
22261: --UPD START
22262: --
22263: l_update boolean := false ;
22264: l_datetrack_mode varchar2(80) := hr_api.g_update;
22265: l_process_date date;
22266: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
22267: --
22268: --UPD END
22797: --
22798: --UPD START
22799: --
22800: l_update boolean := false ;
22801: l_datetrack_mode varchar2(80) := hr_api.g_update;
22802: l_process_date date;
22803: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
22804: --
22805: --UPD END
23219: --
23220: --UPD START
23221: --
23222: l_update boolean := false ;
23223: l_datetrack_mode varchar2(80) := hr_api.g_update;
23224: l_process_date date;
23225: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
23226: --
23227: --UPD END
23633: end if;
23634: --
23635: -- Delete the row if it is end dated.
23636: --
23637: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
23638: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
23639: trunc(l_max_eed) = r_COP.information3) then
23640: --
23641: BEN_OPTION_IN_PLAN_API.delete_OPTION_IN_PLAN(
23645: ,p_effective_start_date => l_effective_start_date
23646: ,p_effective_end_date => l_effective_end_date
23647: ,p_object_version_number => l_object_version_number
23648: ,p_effective_date => l_max_eed
23649: ,p_datetrack_mode => hr_api.g_delete
23650: --
23651: );
23652: --
23653: end if;
23773: --
23774: --UPD START
23775: --
23776: l_update boolean := false ;
23777: l_datetrack_mode varchar2(80) := hr_api.g_update;
23778: l_process_date date;
23779: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
23780: --
23781: --UPD END
24128: end if;
24129: --
24130: -- Delete the row if it is end dated.
24131: --
24132: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
24133: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
24134: trunc(l_max_eed) = r_DDR.information3) then
24135: --
24136: BEN_DESIGN_RQMT_API.delete_DESIGN_RQMT(
24140: ,p_effective_start_date => l_effective_start_date
24141: ,p_effective_end_date => l_effective_end_date
24142: ,p_object_version_number => l_object_version_number
24143: ,p_effective_date => l_max_eed
24144: ,p_datetrack_mode => hr_api.g_delete
24145: --
24146: );
24147: --
24148: end if;
24234: --
24235: --UPD START
24236: --
24237: l_update boolean := false ;
24238: l_datetrack_mode varchar2(80) := hr_api.g_update;
24239: l_process_date date;
24240: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
24241: --
24242: --UPD END
24859: --
24860: ,P_EFFECTIVE_START_DATE => l_effective_start_date
24861: ,P_EFFECTIVE_END_DATE => l_effective_end_date
24862: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
24863: ,P_DATETRACK_MODE => hr_api.g_update
24864: );
24865: --
24866: end if;
24867: --
24866: end if;
24867: --
24868: -- Delete the row if it is end dated.
24869: --
24870: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
24871: trunc(l_max_eed) = r_OPP.information3) then
24872: --
24873: BEN_OPTION_IN_PLAN_IN_PGM_API.delete_OPTION_IN_PLAN_IN_PGM(
24874: --
24877: ,p_effective_start_date => l_effective_start_date
24878: ,p_effective_end_date => l_effective_end_date
24879: ,p_object_version_number => l_object_version_number
24880: ,p_effective_date => l_max_eed
24881: ,p_datetrack_mode => hr_api.g_delete
24882: --
24883: );
24884: --
24885: end if;
25261: --
25262: ,P_EFFECTIVE_START_DATE => l_effective_start_date
25263: ,P_EFFECTIVE_END_DATE => l_effective_end_date
25264: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
25265: ,P_DATETRACK_MODE => hr_api.g_update
25266: );
25267: --
25268: end if;
25269: --
25268: end if;
25269: --
25270: -- Delete the row if it is end dated.
25271: --
25272: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
25273: trunc(l_max_eed) = r_OTP.information3) then
25274: --
25275: BEN_OPT_PLTYP_IN_PGM_API.delete_OPT_PLTYP_IN_PGM(
25276: --
25279: ,p_effective_start_date => l_effective_start_date
25280: ,p_effective_end_date => l_effective_end_date
25281: ,p_object_version_number => l_object_version_number
25282: ,p_effective_date => l_max_eed
25283: ,p_datetrack_mode => hr_api.g_delete
25284: --
25285: );
25286: --
25287: end if;
25388: --
25389: --UPD START
25390: --
25391: l_update boolean := false ;
25392: l_datetrack_mode varchar2(80) := hr_api.g_update;
25393: l_process_date date;
25394: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
25395: --
25396: --UPD END
25762: --
25763: --UPD START
25764: --
25765: l_update boolean := false ;
25766: l_datetrack_mode varchar2(80) := hr_api.g_update;
25767: l_process_date date;
25768: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
25769: --
25770: --UPD END
26102: end if;
26103: --
26104: -- Delete the row if it is end dated.
26105: --
26106: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
26107: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
26108: trunc(l_max_eed) = r_PRP.information3) then
26109: --
26110: BEN_REGULATORY_PURPOSE_API.delete_REGULATORY_PURPOSE(
26114: ,p_effective_start_date => l_effective_start_date
26115: ,p_effective_end_date => l_effective_end_date
26116: ,p_object_version_number => l_object_version_number
26117: ,p_effective_date => l_max_eed
26118: ,p_datetrack_mode => hr_api.g_delete
26119: --
26120: );
26121: --
26122: end if;
26288: --
26289: --UPD START
26290: --
26291: l_update boolean := false ;
26292: l_datetrack_mode varchar2(80) := hr_api.g_update;
26293: l_process_date date;
26294: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
26295: --
26296: --UPD END
26740: end if;
26741: --
26742: -- Delete the row if it is end dated.
26743: --
26744: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
26745: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
26746: trunc(l_max_eed) = r_BPP.information3) then
26747: --
26748: BEN_BENEFIT_PRVDR_POOL_API.delete_BENEFIT_PRVDR_POOL(
26752: ,p_effective_start_date => l_effective_start_date
26753: ,p_effective_end_date => l_effective_end_date
26754: ,p_object_version_number => l_object_version_number
26755: ,p_effective_date => l_max_eed
26756: ,p_datetrack_mode => hr_api.g_delete
26757: --
26758: );
26759: --
26760: end if;
26864: */
26865: --UPD START
26866: --
26867: l_update boolean := false ;
26868: l_datetrack_mode varchar2(80) := hr_api.g_update;
26869: l_process_date date;
26870: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
26871: --
26872: --UPD END
27210: --
27211: --
27212: -- Delete the row if it is end dated.
27213: --
27214: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
27215: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
27216: trunc(l_max_eed) = r_ACP.information3) then
27217: --
27218: BEN_ACRS_PTIP_CVG_API.delete_ACRS_PTIP_CVG(
27222: ,p_effective_start_date => l_effective_start_date
27223: ,p_effective_end_date => l_effective_end_date
27224: ,p_object_version_number => l_object_version_number
27225: ,p_effective_date => l_max_eed
27226: ,p_datetrack_mode => hr_api.g_delete
27227: --
27228: );
27229: --
27230: end if;