80: hr_utility.set_location('p_effective_start_date '||p_effective_start_date,10);
81: hr_utility.set_location('p_effective_end_date '||p_effective_end_date,10);
82: hr_utility.set_location('p_effective_date '||p_effective_date,10);
83: --
84: if p_effective_end_date <> hr_api.g_eot then
85: --
86: if p_dml_operation = 'INSERT' then
87: --
88: l_datetrack_mode := hr_api.g_update;
84: if p_effective_end_date <> hr_api.g_eot then
85: --
86: if p_dml_operation = 'INSERT' then
87: --
88: l_datetrack_mode := hr_api.g_update;
89: l_update := true;
90: --
91: elsif l_datetrack_mode in ('CORRECTION') then
92: --
89: l_update := true;
90: --
91: elsif l_datetrack_mode in ('CORRECTION') then
92: --
93: l_datetrack_mode := hr_api.g_correction ;
94: l_update := true;
95: --
96: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
97: --
95: --
96: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
97: --
98: if p_effective_date = p_effective_start_date then
99: l_datetrack_mode := hr_api.g_correction ;
100: l_update := true;
101: else
102: --
103: if l_datetrack_mode in ('UPDATE_OVERRIDE') then
101: else
102: --
103: if l_datetrack_mode in ('UPDATE_OVERRIDE') then
104: --
105: l_datetrack_mode := hr_api.g_update_override ;
106: l_update := false ;
107: --
108: elsif l_datetrack_mode in ('UPDATE') then
109: --
106: l_update := false ;
107: --
108: elsif l_datetrack_mode in ('UPDATE') then
109: --
110: l_datetrack_mode := hr_api.g_update;
111: --
112: end if;
113: --
114: end if;
115: --
116: elsif l_datetrack_mode in ('UPDATE_CHANGE_INSERT') then
117: --
118: if p_effective_date = p_effective_start_date then
119: l_datetrack_mode := hr_api.g_correction ;
120: l_update := true;
121: else
122: l_datetrack_mode := hr_api.g_update_change_insert ;
123: l_update := true;
118: if p_effective_date = p_effective_start_date then
119: l_datetrack_mode := hr_api.g_correction ;
120: l_update := true;
121: else
122: l_datetrack_mode := hr_api.g_update_change_insert ;
123: l_update := true;
124: end if;
125: --
126: else
124: end if;
125: --
126: else
127: --
128: l_datetrack_mode := hr_api.g_update;
129: l_update := false;
130: --
131: end if;
132: --
133: else
134: --
135: if p_dml_operation = 'INSERT' then
136: --
137: l_datetrack_mode := hr_api.g_update;
138: l_update := false;
139: --
140: elsif l_datetrack_mode in ('CORRECTION') then
141: --
138: l_update := false;
139: --
140: elsif l_datetrack_mode in ('CORRECTION') then
141: --
142: l_datetrack_mode := hr_api.g_correction ;
143: l_update := false;
144: --
145: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
146: --
144: --
145: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
146: --
147: if p_effective_date = p_effective_start_date then
148: l_datetrack_mode := hr_api.g_correction ;
149: l_update := true;
150: else
151: l_datetrack_mode := hr_api.g_update ;
152: l_update := false ;
147: if p_effective_date = p_effective_start_date then
148: l_datetrack_mode := hr_api.g_correction ;
149: l_update := true;
150: else
151: l_datetrack_mode := hr_api.g_update ;
152: l_update := false ;
153: end if;
154: --
155: elsif l_datetrack_mode in ('UPDATE_CHANGE_INSERT') then
154: --
155: elsif l_datetrack_mode in ('UPDATE_CHANGE_INSERT') then
156: --
157: if p_effective_date = p_effective_start_date then
158: l_datetrack_mode := hr_api.g_correction ;
159: l_update := false;
160: else
161: l_datetrack_mode := hr_api.g_update ;
162: l_update := false;
157: if p_effective_date = p_effective_start_date then
158: l_datetrack_mode := hr_api.g_correction ;
159: l_update := false;
160: else
161: l_datetrack_mode := hr_api.g_update ;
162: l_update := false;
163: end if;
164: --
165: else
163: end if;
164: --
165: else
166: --
167: l_datetrack_mode := hr_api.g_update;
168: l_update := false;
169: --
170: end if;
171: --
357:
358: --UPD START
359: --
360: l_update boolean := false ;
361: l_datetrack_mode varchar2(80) := hr_api.g_update;
362: l_process_date date;
363: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
364: --
365: --UPD END
724: ,P_EFFECTIVE_START_DATE => l_effective_start_date
725: ,P_EFFECTIVE_END_DATE => l_effective_end_date
726: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
727: --UPD START
728: --,P_DATETRACK_MODE => hr_api.g_update
729: ,P_DATETRACK_MODE => l_DATETRACK_MODE
730:
731: );
732: --
736: end if;
737: --
738: -- Delete the row if it is end dated.
739: --
740: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
741: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
742: trunc(l_max_eed) = r_CTU.information3) then
743: --
744: BEN_CM_TYP_USG_API.delete_CM_TYP_USG(
748: ,p_effective_start_date => l_effective_start_date
749: ,p_effective_end_date => l_effective_end_date
750: ,p_object_version_number => l_object_version_number
751: ,p_effective_date => l_max_eed
752: ,p_datetrack_mode => hr_api.g_delete
753: --
754: );
755: --
756: end if;
871:
872: --UPD START
873: --
874: l_update boolean := false ;
875: l_datetrack_mode varchar2(80) := hr_api.g_update;
876: l_process_date date;
877: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
878: --
879: --UPD END
1212: ,P_EFFECTIVE_START_DATE => l_effective_start_date
1213: ,P_EFFECTIVE_END_DATE => l_effective_end_date
1214: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1215: -- UPD START
1216: --,P_DATETRACK_MODE => hr_api.g_update
1217: ,P_DATETRACK_MODE => l_datetrack_mode
1218: -- UPD END
1219: );
1220: -- UPD START
1225: --
1226: --
1227: -- Delete the row if it is end dated.
1228: --
1229: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
1230: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
1231: trunc(l_max_eed) = r_CTT.information3) then
1232: --
1233: BEN_CM_TYP_TRGR_API.delete_CM_TYP_TRGR(
1237: ,p_effective_start_date => l_effective_start_date
1238: ,p_effective_end_date => l_effective_end_date
1239: ,p_object_version_number => l_object_version_number
1240: ,p_effective_date => l_max_eed
1241: ,p_datetrack_mode => hr_api.g_delete
1242: --
1243: );
1244: --
1245: end if;
1333: --
1334: --UPD START
1335: --
1336: l_update boolean := false ;
1337: l_datetrack_mode varchar2(80) := hr_api.g_update;
1338: l_process_date date;
1339: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
1340: --
1341: --UPD END
1703:
1704: --UPD START
1705: --
1706: l_update boolean := false ;
1707: l_datetrack_mode varchar2(80) := hr_api.g_update;
1708: l_process_date date;
1709: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
1710: --
1711: --UPD END
2242:
2243: --UPD START
2244: --
2245: l_update boolean := false ;
2246: l_datetrack_mode varchar2(80) := hr_api.g_update;
2247: l_process_date date;
2248: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
2249: --
2250: --UPD END
2974: ,P_SUB_ACTY_TYP_CD => r_ABR.information55
2975: --
2976: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
2977: -- UPD START
2978: --,P_DATETRACK_MODE => hr_api.g_update
2979: ,P_DATETRACK_MODE => l_datetrack_mode
2980: --UPD END
2981: );
2982: --
2985: --
2986: --
2987: -- Delete the row if it is end dated.
2988: --
2989: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
2990: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
2991: trunc(l_max_eed) = r_ABR.information3) then
2992: --
2993: BEN_ACTY_BASE_RATE_API.delete_ACTY_BASE_RATE(
2997: ,p_effective_start_date => l_effective_start_date
2998: ,p_effective_end_date => l_effective_end_date
2999: ,p_object_version_number => l_object_version_number
3000: ,p_effective_date => l_max_eed
3001: ,p_datetrack_mode => hr_api.g_delete
3002: --
3003: );
3004: --
3005: end if;
3120:
3121: --UPD START
3122: --
3123: l_update boolean := false ;
3124: l_datetrack_mode varchar2(80) := hr_api.g_update;
3125: l_process_date date;
3126: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
3127: --
3128: --UPD END
3489: ,P_EFFECTIVE_START_DATE => l_effective_start_date
3490: ,P_EFFECTIVE_END_DATE => l_effective_end_date
3491: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
3492: ,P_DATETRACK_MODE => l_datetrack_mode
3493: --,P_DATETRACK_MODE => hr_api.g_update
3494: );
3495:
3496: end if; -- l_update
3497:
3499: --
3500: --
3501: -- Delete the row if it is end dated.
3502: --
3503: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
3504: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
3505: trunc(l_max_eed) = r_MTR.information3) then
3506: --
3507: BEN_MATCHING_RATES_API.delete_MATCHING_RATES(
3511: ,p_effective_start_date => l_effective_start_date
3512: ,p_effective_end_date => l_effective_end_date
3513: ,p_object_version_number => l_object_version_number
3514: ,p_effective_date => l_max_eed
3515: ,p_datetrack_mode => hr_api.g_delete
3516: --
3517: );
3518: --
3519: end if;
3633:
3634: --UPD START
3635: --
3636: l_update boolean := false ;
3637: l_datetrack_mode varchar2(80) := hr_api.g_update;
3638: l_process_date date;
3639: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
3640: --
3641: --UPD END
3973: ,P_EFFECTIVE_START_DATE => l_effective_start_date
3974: ,P_EFFECTIVE_END_DATE => l_effective_end_date
3975: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
3976: -- UPD START
3977: -- ,P_DATETRACK_MODE => hr_api.g_update
3978: ,P_DATETRACK_MODE => l_datetrack_mode
3979: -- UPD END
3980: );
3981: end if; -- l_update
3983: --
3984: --
3985: -- Delete the row if it is end dated.
3986: --
3987: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
3988: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
3989: trunc(l_max_eed) = r_APL1.information3) then
3990: --
3991: BEN_ACTY_RT_PTD_LMT_API.delete_ACTY_RT_PTD_LMT(
3995: ,p_effective_start_date => l_effective_start_date
3996: ,p_effective_end_date => l_effective_end_date
3997: ,p_object_version_number => l_object_version_number
3998: ,p_effective_date => l_max_eed
3999: ,p_datetrack_mode => hr_api.g_delete
4000: --
4001: );
4002: --
4003: end if;
4161:
4162: --UPD START
4163: --
4164: l_update boolean := false ;
4165: l_datetrack_mode varchar2(80) := hr_api.g_update;
4166: l_process_date date;
4167: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
4168: --
4169: --UPD END
4608: ,P_EFFECTIVE_START_DATE => l_effective_start_date
4609: ,P_EFFECTIVE_END_DATE => l_effective_end_date
4610: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
4611: -- UPD START
4612: --,P_DATETRACK_MODE => hr_api.g_update
4613: ,P_DATETRACK_MODE => l_datetrack_mode
4614: -- UPD END
4615: );
4616: end if; -- l_update
4618: --
4619: --
4620: -- Delete the row if it is end dated.
4621: --
4622: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
4623: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
4624: trunc(l_max_eed) = r_APR.information3) then
4625: --
4626: BEN_ACTUAL_PREMIUM_API.delete_ACTUAL_PREMIUM(
4630: ,p_effective_start_date => l_effective_start_date
4631: ,p_effective_end_date => l_effective_end_date
4632: ,p_object_version_number => l_object_version_number
4633: ,p_effective_date => l_max_eed
4634: ,p_datetrack_mode => hr_api.g_delete
4635: --
4636: );
4637: --
4638: end if;
4752:
4753: --UPD START
4754: --
4755: l_update boolean := false ;
4756: l_datetrack_mode varchar2(80) := hr_api.g_update;
4757: l_process_date date;
4758: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
4759: --
4760: --UPD END
5094: ,P_EFFECTIVE_START_DATE => l_effective_start_date
5095: ,P_EFFECTIVE_END_DATE => l_effective_end_date
5096: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
5097: -- UPD START
5098: --,P_DATETRACK_MODE => hr_api.g_update
5099: ,P_DATETRACK_MODE => l_datetrack_mode
5100: -- UPD END
5101: );
5102: -- UPD START
5106: --
5107: --
5108: -- Delete the row if it is end dated.
5109: --
5110: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
5111: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
5112: trunc(l_max_eed) = r_AVR.information3) then
5113: --
5114: BEN_ACTY_VRBL_RATE_API.delete_ACTY_VRBL_RATE(
5118: ,p_effective_start_date => l_effective_start_date
5119: ,p_effective_end_date => l_effective_end_date
5120: ,p_object_version_number => l_object_version_number
5121: ,p_effective_date => l_max_eed
5122: ,p_datetrack_mode => hr_api.g_delete
5123: --
5124: );
5125: --
5126: end if;
5247: --
5248: --UPD START
5249: --
5250: l_update boolean := false ;
5251: l_datetrack_mode varchar2(80) := hr_api.g_update;
5252: l_process_date date;
5253: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
5254: --
5255: --UPD END
5791: ,P_EFFECTIVE_START_DATE => l_effective_start_date
5792: ,P_EFFECTIVE_END_DATE => l_effective_end_date
5793: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
5794: -- UPD START
5795: --,P_DATETRACK_MODE => hr_api.g_update
5796: ,P_DATETRACK_MODE => l_datetrack_mode
5797: -- UPD END
5798: );
5799:
5803: --
5804: --
5805: -- Delete the row if it is end dated.
5806: --
5807: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
5808: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
5809: trunc(l_max_eed) = r_VPF.information3) then
5810: --
5811: BEN_VRBL_RATE_PROFILE_API.delete_VRBL_RATE_PROFILE(
5815: ,p_effective_start_date => l_effective_start_date
5816: ,p_effective_end_date => l_effective_end_date
5817: ,p_object_version_number => l_object_version_number
5818: ,p_effective_date => l_max_eed
5819: ,p_datetrack_mode => hr_api.g_delete
5820: --
5821: );
5822: --
5823: end if;
5976:
5977: --UPD START
5978: --
5979: l_update boolean := false ;
5980: l_datetrack_mode varchar2(80) := hr_api.g_update;
5981: l_process_date date;
5982: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
5983: --
5984: --UPD END
6402: ,P_EFFECTIVE_START_DATE => l_effective_start_date
6403: ,P_EFFECTIVE_END_DATE => l_effective_end_date
6404: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
6405: ,P_DATETRACK_MODE => l_datetrack_mode
6406: --,P_DATETRACK_MODE => hr_api.g_update
6407: );
6408: end if; -- l_update
6409: end if;
6410: --
6410: --
6411: --
6412: -- Delete the row if it is end dated.
6413: --
6414: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
6415: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
6416: trunc(l_max_eed) = r_CCM.information3) then
6417: --
6418: BEN_CVG_AMT_CALC_API.delete_CVG_AMT_CALC(
6422: ,p_effective_start_date => l_effective_start_date
6423: ,p_effective_end_date => l_effective_end_date
6424: ,p_object_version_number => l_object_version_number
6425: ,p_effective_date => l_max_eed
6426: ,p_datetrack_mode => hr_api.g_delete
6427: --
6428: );
6429: --
6430: end if;
6547: --
6548: --UPD START
6549: --
6550: l_update boolean := false ;
6551: l_datetrack_mode varchar2(80) := hr_api.g_update;
6552: l_process_date date;
6553: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6554: --
6555: --UPD END
6879: --
6880: ,P_EFFECTIVE_START_DATE => l_effective_start_date
6881: ,P_EFFECTIVE_END_DATE => l_effective_end_date
6882: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
6883: --,P_DATETRACK_MODE => hr_api.g_update
6884: ,P_DATETRACK_MODE => l_datetrack_mode
6885: );
6886: end if; -- l_update
6887: end if;
6888: --
6889: --
6890: -- Delete the row if it is end dated.
6891: --
6892: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
6893: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
6894: trunc(l_max_eed) = r_BVR1.information3) then
6895: --
6896: BEN_BNFT_VRBL_RT_API.delete_BNFT_VRBL_RT(
6900: ,p_effective_start_date => l_effective_start_date
6901: ,p_effective_end_date => l_effective_end_date
6902: ,p_object_version_number => l_object_version_number
6903: ,p_effective_date => l_max_eed
6904: ,p_datetrack_mode => hr_api.g_delete
6905: --
6906: );
6907: --
6908: end if;
7021:
7022: --UPD START
7023: --
7024: l_update boolean := false ;
7025: l_datetrack_mode varchar2(80) := hr_api.g_update;
7026: l_process_date date;
7027: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
7028: --
7029: --UPD END
7349: --
7350: ,P_EFFECTIVE_START_DATE => l_effective_start_date
7351: ,P_EFFECTIVE_END_DATE => l_effective_end_date
7352: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
7353: --,P_DATETRACK_MODE => hr_api.g_update
7354: ,P_DATETRACK_MODE => l_datetrack_mode
7355: );
7356: end if; -- l_update
7357: end if;
7358: --
7359: --
7360: -- Delete the row if it is end dated.
7361: --
7362: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
7363: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
7364: trunc(l_max_eed) = r_BRR.information3) then
7365: --
7366: BEN_BNFT_VRBL_RT_RL_API.delete_BNFT_VRBL_RT_RL(
7370: ,p_effective_start_date => l_effective_start_date
7371: ,p_effective_end_date => l_effective_end_date
7372: ,p_object_version_number => l_object_version_number
7373: ,p_effective_date => l_max_eed
7374: ,p_datetrack_mode => hr_api.g_delete
7375: --
7376: );
7377: --
7378: end if;
7492: --
7493: --UPD START
7494: --
7495: l_update boolean := false ;
7496: l_datetrack_mode varchar2(80) := hr_api.g_update;
7497: l_process_date date;
7498: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
7499: --
7500: --UPD END
7818: --
7819: ,P_EFFECTIVE_START_DATE => l_effective_start_date
7820: ,P_EFFECTIVE_END_DATE => l_effective_end_date
7821: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
7822: --,P_DATETRACK_MODE => hr_api.g_update
7823: ,P_DATETRACK_MODE => l_datetrack_mode
7824: );
7825: end if; -- l_update
7826: end if;
7827: --
7828: --
7829: -- Delete the row if it is end dated.
7830: --
7831: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
7832: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
7833: trunc(l_max_eed) = r_APV.information3) then
7834: --
7835: BEN_ACTUAL_PREMIUM_RATE_API.delete_ACTUAL_PREMIUM_RATE(
7839: ,p_effective_start_date => l_effective_start_date
7840: ,p_effective_end_date => l_effective_end_date
7841: ,p_object_version_number => l_object_version_number
7842: ,p_effective_date => l_max_eed
7843: ,p_datetrack_mode => hr_api.g_delete
7844: --
7845: );
7846: --
7847: end if;
7960: --
7961: --UPD START
7962: --
7963: l_update boolean := false ;
7964: l_datetrack_mode varchar2(80) := hr_api.g_update;
7965: l_process_date date;
7966: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
7967: --
7968: --UPD END
8303: ,P_EFFECTIVE_START_DATE => l_effective_start_date
8304: ,P_EFFECTIVE_END_DATE => l_effective_end_date
8305: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
8306: ,P_DATETRACK_MODE => l_datetrack_mode
8307: --,P_DATETRACK_MODE => hr_api.g_update
8308: );
8309:
8310: end if; -- l_update
8311: end if;
8312: --
8313: --
8314: -- Delete the row if it is end dated.
8315: --
8316: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
8317: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
8318: trunc(l_max_eed) = r_AVA.information3) then
8319: --
8320: BEN_ACTUAL_PREMIUM_RULE_API.delete_ACTUAL_PREMIUM_RULE(
8324: ,p_effective_start_date => l_effective_start_date
8325: ,p_effective_end_date => l_effective_end_date
8326: ,p_object_version_number => l_object_version_number
8327: ,p_effective_date => l_max_eed
8328: ,p_datetrack_mode => hr_api.g_delete
8329: --
8330: );
8331: --
8332: end if;
8443:
8444: --UPD START
8445: --
8446: l_update boolean := false ;
8447: l_datetrack_mode varchar2(80) := hr_api.g_update;
8448: l_process_date date;
8449: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
8450: --
8451: --UPD END
8783: ,P_EFFECTIVE_START_DATE => l_effective_start_date
8784: ,P_EFFECTIVE_END_DATE => l_effective_end_date
8785: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
8786: ,P_DATETRACK_MODE => l_datetrack_mode
8787: --,P_DATETRACK_MODE => hr_api.g_update
8788: );
8789: end if; -- l_update
8790: end if;
8791: --
8791: --
8792: --
8793: -- Delete the row if it is end dated.
8794: --
8795: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
8796: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
8797: trunc(l_max_eed) = r_ABP.information3) then
8798: --
8799: BEN_APLCN_TO_BENEFIT_POOL_API.delete_APLCN_TO_BENEFIT_POOL(
8803: ,p_effective_start_date => l_effective_start_date
8804: ,p_effective_end_date => l_effective_end_date
8805: ,p_object_version_number => l_object_version_number
8806: ,p_effective_date => l_max_eed
8807: ,p_datetrack_mode => hr_api.g_delete
8808: --
8809: );
8810: --
8811: end if;
8928: --
8929: --UPD START
8930: --
8931: l_update boolean := false ;
8932: l_datetrack_mode varchar2(80) := hr_api.g_update;
8933: l_process_date date;
8934: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
8935: --
8936: --UPD END
9306: ,P_EFFECTIVE_START_DATE => l_effective_start_date
9307: ,P_EFFECTIVE_END_DATE => l_effective_end_date
9308: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
9309: -- upd start
9310: --,P_DATETRACK_MODE => hr_api.g_update
9311: ,P_DATETRACK_MODE => l_datetrack_mode
9312: -- upd end
9313: );
9314: end if; -- l_update
9316: --
9317: --
9318: -- Delete the row if it is end dated.
9319: --
9320: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
9321: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
9322: trunc(l_max_eed) = r_BPR.information3) then
9323: --
9324: BEN_BNFT_POOL_RLOVR_RQMT_API.delete_BNFT_POOL_RLOVR_RQMT(
9328: ,p_effective_start_date => l_effective_start_date
9329: ,p_effective_end_date => l_effective_end_date
9330: ,p_object_version_number => l_object_version_number
9331: ,p_effective_date => l_max_eed
9332: ,p_datetrack_mode => hr_api.g_delete
9333: --
9334: );
9335: --
9336: end if;
9452: --
9453: --UPD START
9454: --
9455: l_update boolean := false ;
9456: l_datetrack_mode varchar2(80) := hr_api.g_update;
9457: l_process_date date;
9458: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
9459: --
9460: --UPD END
9795: --
9796: ,P_EFFECTIVE_START_DATE => l_effective_start_date
9797: ,P_EFFECTIVE_END_DATE => l_effective_end_date
9798: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
9799: --,P_DATETRACK_MODE => hr_api.g_update
9800: ,P_DATETRACK_MODE => l_datetrack_mode
9801: );
9802: end if; -- l_update
9803: end if;
9804: --
9805: --
9806: -- Delete the row if it is end dated.
9807: --
9808: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
9809: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
9810: trunc(l_max_eed) = r_DCR.information3) then
9811: --
9812: BEN_DPNT_CVG_RQD_RLSHP_API.delete_DPNT_CVG_RQD_RLSHP(
9816: ,p_effective_start_date => l_effective_start_date
9817: ,p_effective_end_date => l_effective_end_date
9818: ,p_object_version_number => l_object_version_number
9819: ,p_effective_date => l_max_eed
9820: ,p_datetrack_mode => hr_api.g_delete
9821: --
9822: );
9823: --
9824: end if;
9938: --
9939: --UPD START
9940: --
9941: l_update boolean := false ;
9942: l_datetrack_mode varchar2(80) := hr_api.g_update;
9943: l_process_date date;
9944: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
9945: --
9946: --UPD END
10271: ,P_EFFECTIVE_START_DATE => l_effective_start_date
10272: ,P_EFFECTIVE_END_DATE => l_effective_end_date
10273: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
10274: ,P_DATETRACK_MODE => l_datetrack_mode
10275: --,P_DATETRACK_MODE => hr_api.g_update
10276: );
10277: end if; -- l_update
10278: end if;
10279: --
10279: --
10280: --
10281: -- Delete the row if it is end dated.
10282: --
10283: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
10284: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
10285: trunc(l_max_eed) = r_DEC.information3) then
10286: --
10287: BEN_DSGNTR_ENRLD_CVG_API.delete_DSGNTR_ENRLD_CVG(
10291: ,p_effective_start_date => l_effective_start_date
10292: ,p_effective_end_date => l_effective_end_date
10293: ,p_object_version_number => l_object_version_number
10294: ,p_effective_date => l_max_eed
10295: ,p_datetrack_mode => hr_api.g_delete
10296: --
10297: );
10298: --
10299: end if;
10411: --
10412: --UPD START
10413: --
10414: l_update boolean := false ;
10415: l_datetrack_mode varchar2(80) := hr_api.g_update;
10416: l_process_date date;
10417: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
10418: --
10419: --UPD END
10755: --
10756: ,P_EFFECTIVE_START_DATE => l_effective_start_date
10757: ,P_EFFECTIVE_END_DATE => l_effective_end_date
10758: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
10759: --,P_DATETRACK_MODE => hr_api.g_update
10760: ,P_DATETRACK_MODE => l_datetrack_mode
10761: );
10762: end if; -- l_update
10763: end if;
10764: --
10765: --
10766: -- Delete the row if it is end dated.
10767: --
10768: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
10769: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
10770: trunc(l_max_eed) = r_DPC.information3) then
10771: --
10772: BEN_DPNT_CVD_ANTHR_PL_CVG_API.delete_DPNT_CVD_ANTHR_PL_CVG(
10776: ,p_effective_start_date => l_effective_start_date
10777: ,p_effective_end_date => l_effective_end_date
10778: ,p_object_version_number => l_object_version_number
10779: ,p_effective_date => l_max_eed
10780: ,p_datetrack_mode => hr_api.g_delete
10781: --
10782: );
10783: --
10784: end if;
10899: --
10900: --UPD START
10901: --
10902: l_update boolean := false ;
10903: l_datetrack_mode varchar2(80) := hr_api.g_update;
10904: l_process_date date;
10905: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
10906: --
10907: --UPD END
11244: --
11245: ,P_EFFECTIVE_START_DATE => l_effective_start_date
11246: ,P_EFFECTIVE_END_DATE => l_effective_end_date
11247: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
11248: --,P_DATETRACK_MODE => hr_api.g_update
11249: ,P_DATETRACK_MODE => l_datetrack_mode
11250: );
11251: end if; -- l_update
11252: end if;
11253: --
11254: --
11255: -- Delete the row if it is end dated.
11256: --
11257: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
11258: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
11259: trunc(l_max_eed) = r_EAC.information3) then
11260: --
11261: BEN_ELIG_AGE_CVG_API.delete_ELIG_AGE_CVG(
11265: ,p_effective_start_date => l_effective_start_date
11266: ,p_effective_end_date => l_effective_end_date
11267: ,p_object_version_number => l_object_version_number
11268: ,p_effective_date => l_max_eed
11269: ,p_datetrack_mode => hr_api.g_delete
11270: --
11271: );
11272: --
11273: end if;
11388: --
11389: --UPD START
11390: --
11391: l_update boolean := false ;
11392: l_datetrack_mode varchar2(80) := hr_api.g_update;
11393: l_process_date date;
11394: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
11395: --
11396: --UPD END
11721: --
11722: ,P_EFFECTIVE_START_DATE => l_effective_start_date
11723: ,P_EFFECTIVE_END_DATE => l_effective_end_date
11724: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
11725: --,P_DATETRACK_MODE => hr_api.g_update
11726: ,P_DATETRACK_MODE => l_DATETRACK_MODE
11727: );
11728: end if; -- l_update
11729: end if;
11730: --
11731: --
11732: -- Delete the row if it is end dated.
11733: --
11734: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
11735: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
11736: trunc(l_max_eed) = r_EDC.information3) then
11737: --
11738: BEN_ELIG_DSBLD_STAT_CVG_API.delete_ELIG_DSBLD_STAT_CVG(
11742: ,p_effective_start_date => l_effective_start_date
11743: ,p_effective_end_date => l_effective_end_date
11744: ,p_object_version_number => l_object_version_number
11745: ,p_effective_date => l_max_eed
11746: ,p_datetrack_mode => hr_api.g_delete
11747: --
11748: );
11749: --
11750: end if;
11863: --END TEMPIK
11864: --UPD START
11865: --
11866: l_update boolean := false ;
11867: l_datetrack_mode varchar2(80) := hr_api.g_update;
11868: l_process_date date;
11869: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
11870: --
11871: --UPD END
12204: --
12205: ,P_EFFECTIVE_START_DATE => l_effective_start_date
12206: ,P_EFFECTIVE_END_DATE => l_effective_end_date
12207: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
12208: --,P_DATETRACK_MODE => hr_api.g_update
12209: ,P_DATETRACK_MODE => l_datetrack_mode
12210: );
12211: end if; -- l_update
12212: end if;
12213: --
12214: --
12215: -- Delete the row if it is end dated.
12216: --
12217: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
12218: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
12219: trunc(l_max_eed) = r_EMC.information3) then
12220: --
12221: BEN_ELIG_MLTRY_STAT_CVG_API.delete_ELIG_MLTRY_STAT_CVG(
12225: ,p_effective_start_date => l_effective_start_date
12226: ,p_effective_end_date => l_effective_end_date
12227: ,p_object_version_number => l_object_version_number
12228: ,p_effective_date => l_max_eed
12229: ,p_datetrack_mode => hr_api.g_delete
12230: --
12231: );
12232: --
12233: end if;
12348: --
12349: --UPD START
12350: --
12351: l_update boolean := false ;
12352: l_datetrack_mode varchar2(80) := hr_api.g_update;
12353: l_process_date date;
12354: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
12355: --
12356: --UPD END
12691: --
12692: ,P_EFFECTIVE_START_DATE => l_effective_start_date
12693: ,P_EFFECTIVE_END_DATE => l_effective_end_date
12694: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
12695: --,P_DATETRACK_MODE => hr_api.g_update
12696: ,P_DATETRACK_MODE => l_datetrack_mode
12697: );
12698: end if; -- l_update
12699: end if;
12700: --
12701: --
12702: -- Delete the row if it is end dated.
12703: --
12704: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
12705: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
12706: trunc(l_max_eed) = r_EMS.information3) then
12707: --
12708: BEN_ELIG_MRTL_STAT_CVG_API.delete_ELIG_MRTL_STAT_CVG(
12712: ,p_effective_start_date => l_effective_start_date
12713: ,p_effective_end_date => l_effective_end_date
12714: ,p_object_version_number => l_object_version_number
12715: ,p_effective_date => l_max_eed
12716: ,p_datetrack_mode => hr_api.g_delete
12717: --
12718: );
12719: --
12720: end if;
12833: --
12834: --UPD START
12835: --
12836: l_update boolean := false ;
12837: l_datetrack_mode varchar2(80) := hr_api.g_update;
12838: l_process_date date;
12839: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
12840: --
12841: --UPD END
13157: --
13158: ,P_EFFECTIVE_START_DATE => l_effective_start_date
13159: ,P_EFFECTIVE_END_DATE => l_effective_end_date
13160: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
13161: --,P_DATETRACK_MODE => hr_api.g_update
13162: ,P_DATETRACK_MODE => l_datetrack_mode
13163: );
13164: end if; -- l_update
13165: end if;
13166: --
13167: --
13168: -- Delete the row if it is end dated.
13169: --
13170: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
13171: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
13172: trunc(l_max_eed) = r_EPL.information3) then
13173: --
13174: BEN_ELIG_PSTL_CD_CVG_API.delete_ELIG_PSTL_CD_CVG(
13178: ,p_effective_start_date => l_effective_start_date
13179: ,p_effective_end_date => l_effective_end_date
13180: ,p_object_version_number => l_object_version_number
13181: ,p_effective_date => l_max_eed
13182: ,p_datetrack_mode => hr_api.g_delete
13183: --
13184: );
13185: --
13186: --
13301: --
13302: --UPD START
13303: --
13304: l_update boolean := false ;
13305: l_datetrack_mode varchar2(80) := hr_api.g_update;
13306: l_process_date date;
13307: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13308: --
13309: --UPD END
13642: --
13643: ,P_EFFECTIVE_START_DATE => l_effective_start_date
13644: ,P_EFFECTIVE_END_DATE => l_effective_end_date
13645: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
13646: --,P_DATETRACK_MODE => hr_api.g_update
13647: ,P_DATETRACK_MODE => l_datetrack_mode
13648: );
13649: end if; -- l_update
13650: end if;
13651: --
13652: --
13653: -- Delete the row if it is end dated.
13654: --
13655: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
13656: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
13657: trunc(l_max_eed) = r_ESC.information3) then
13658: --
13659: BEN_ELIG_STDNT_STAT_CVG_API.delete_ELIG_STDNT_STAT_CVG(
13663: ,p_effective_start_date => l_effective_start_date
13664: ,p_effective_end_date => l_effective_end_date
13665: ,p_object_version_number => l_object_version_number
13666: ,p_effective_date => l_max_eed
13667: ,p_datetrack_mode => hr_api.g_delete
13668: --
13669: );
13670: --
13671: end if;
13784: --
13785: --UPD START
13786: --
13787: l_update boolean := false ;
13788: l_datetrack_mode varchar2(80) := hr_api.g_update;
13789: l_process_date date;
13790: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13791: --
13792: --UPD END
14193: --
14194: --UPD START
14195: --
14196: l_update boolean := false ;
14197: l_datetrack_mode varchar2(80) := hr_api.g_update;
14198: l_process_date date;
14199: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
14200: --
14201: --UPD END
14576:
14577: --UPD START
14578: --
14579: l_update boolean := false ;
14580: l_datetrack_mode varchar2(80) := hr_api.g_update;
14581: l_process_date date;
14582: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
14583: --
14584: --UPD END
14911: ,P_EFFECTIVE_START_DATE => l_effective_start_date
14912: ,P_EFFECTIVE_END_DATE => l_effective_end_date
14913: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
14914: ,P_DATETRACK_MODE => l_datetrack_mode
14915: --,P_DATETRACK_MODE => hr_api.g_update
14916: );
14917: end if ;
14918: end if;
14919: --
14919: --
14920: --
14921: -- Delete the row if it is end dated.
14922: --
14923: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
14924: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
14925: trunc(l_max_eed) = trunc(r_APF.information3)) then
14926: --
14927: BEN_ACTY_RT_PYMT_SCHED_API.delete_ACTY_RT_PYMT_SCHED(
14931: ,p_effective_start_date => l_effective_start_date
14932: ,p_effective_end_date => l_effective_end_date
14933: ,p_object_version_number => l_object_version_number
14934: ,p_effective_date => l_max_eed
14935: ,p_datetrack_mode => hr_api.g_delete
14936: --
14937: );
14938: --
14939: end if;
15053: --
15054: --UPD START
15055: --
15056: l_update boolean := false ;
15057: l_datetrack_mode varchar2(80) := hr_api.g_update;
15058: l_process_date date;
15059: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
15060: --
15061: --UPD END
15392: --
15393: ,P_EFFECTIVE_START_DATE => l_effective_start_date
15394: ,P_EFFECTIVE_END_DATE => l_effective_end_date
15395: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
15396: --,P_DATETRACK_MODE => hr_api.g_update
15397: ,P_DATETRACK_MODE => l_datetrack_mode
15398: );
15399: end if; -- l_update
15400: end if;
15401: --
15402: --
15403: -- Delete the row if it is end dated.
15404: --
15405: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
15406: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
15407: trunc(l_max_eed) = trunc(r_ABC.information3)) then
15408: --
15409: BEN_ACTY_BASE_RT_CTFN_API.delete_ACTY_BASE_RT_CTFN(
15413: ,p_effective_start_date => l_effective_start_date
15414: ,p_effective_end_date => l_effective_end_date
15415: ,p_object_version_number => l_object_version_number
15416: ,p_effective_date => l_max_eed
15417: ,p_datetrack_mode => hr_api.g_delete
15418: --
15419: );
15420: --
15421: end if;
15567: --
15568: --UPD START
15569: --
15570: l_update boolean := false ;
15571: l_datetrack_mode varchar2(80) := hr_api.g_update;
15572: l_process_date date;
15573: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
15574: --
15575: --UPD END
15928: --
15929: ,P_EFFECTIVE_START_DATE => l_effective_start_date
15930: ,P_EFFECTIVE_END_DATE => l_effective_end_date
15931: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
15932: --,P_DATETRACK_MODE => hr_api.g_update
15933: ,P_DATETRACK_MODE => l_datetrack_mode
15934: );
15935: end if; -- l_update
15936: end if;
15937: --
15938: --
15939: -- Delete the row if it is end dated.
15940: --
15941: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
15942: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
15943: trunc(l_max_eed) = r_PMRPV.information3) then
15944: --
15945: BEN_PRTL_MO_RT_PRTN_VAL_API.delete_PRTL_MO_RT_PRTN_VAL(
15949: ,p_effective_start_date => l_effective_start_date
15950: ,p_effective_end_date => l_effective_end_date
15951: ,p_object_version_number => l_object_version_number
15952: ,p_effective_date => l_max_eed
15953: ,p_datetrack_mode => hr_api.g_delete
15954: --
15955: );
15956: --
15957: end if;
16065: --
16066: --UPD START
16067: --
16068: l_update boolean := false ;
16069: l_datetrack_mode varchar2(80) := hr_api.g_update;
16070: l_process_date date;
16071: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
16072: --
16073: --UPD END
16397: --
16398: ,P_EFFECTIVE_START_DATE => l_effective_start_date
16399: ,P_EFFECTIVE_END_DATE => l_effective_end_date
16400: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
16401: --,P_DATETRACK_MODE => hr_api.g_update
16402: ,P_DATETRACK_MODE => l_datetrack_mode
16403: );
16404: end if; -- l_update
16405: --
16404: end if; -- l_update
16405: --
16406: -- Delete the row if it is end dated.
16407: --
16408: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
16409: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
16410: trunc(l_max_eed) = r_VEP.information3) then
16411: --
16412: BEN_VRBL_RT_ELIG_PRFL_API.delete_VRBL_RT_ELIG_PRFL(
16417: ,p_effective_start_date => l_effective_start_date
16418: ,p_effective_end_date => l_effective_end_date
16419: ,p_object_version_number => l_object_version_number
16420: ,p_effective_date => l_max_eed
16421: ,p_datetrack_mode => hr_api.g_delete
16422: --
16423: );
16424: --
16425: end if;