eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on HR_API

Line 23: if p_effective_end_date <> hr_api.g_eot then

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;

Line 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: --

Line 32: l_datetrack_mode := hr_api.g_correction ;

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: --

Line 38: l_datetrack_mode := hr_api.g_correction ;

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

Line 44: l_datetrack_mode := hr_api.g_update_override ;

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: --

Line 49: l_datetrack_mode := hr_api.g_update;

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;

Line 58: l_datetrack_mode := hr_api.g_correction ;

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;

Line 61: l_datetrack_mode := hr_api.g_update_change_insert ;

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

Line 67: l_datetrack_mode := hr_api.g_update;

63: end if;
64: --
65: else
66: --
67: l_datetrack_mode := hr_api.g_update;
68: l_update := false;
69: --
70: end if;
71: --

Line 76: l_datetrack_mode := hr_api.g_update;

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: --

Line 81: l_datetrack_mode := hr_api.g_correction ;

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: --

Line 87: l_datetrack_mode := hr_api.g_correction ;

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 ;

Line 90: l_datetrack_mode := hr_api.g_update ;

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

Line 97: l_datetrack_mode := hr_api.g_correction ;

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;

Line 100: l_datetrack_mode := hr_api.g_update ;

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

Line 106: l_datetrack_mode := hr_api.g_update;

102: end if;
103: --
104: else
105: --
106: l_datetrack_mode := hr_api.g_update;
107: l_update := false;
108: --
109: end if;
110: --

Line 307: l_datetrack_mode varchar2(80) := hr_api.g_update;

303:
304: --UPD START
305: --
306: l_update boolean := false ;
307: l_datetrack_mode varchar2(80) := hr_api.g_update;
308: l_process_date date;
309: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
310: --
311: --UPD END

Line 695: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

691: end if;
692: --
693: -- Delete the row if it is end dated.
694: --
695: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
696: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
697: trunc(l_max_eed) = trunc(r_EAN.information3)) then
698: --
699: BEN_ELIG_ASNT_SET_PRTE_API.delete_ELIG_ASNT_SET_PRTE(

Line 707: ,p_datetrack_mode => hr_api.g_delete

703: ,p_effective_start_date => l_effective_start_date
704: ,p_effective_end_date => l_effective_end_date
705: ,p_object_version_number => l_object_version_number
706: ,p_effective_date => l_max_eed
707: ,p_datetrack_mode => hr_api.g_delete
708: --
709: );
710: --
711: end if;

Line 846: l_datetrack_mode varchar2(80) := hr_api.g_update;

842: --l_current_pk_id number := null ;
843: --UPD START
844: --
845: l_update boolean := false ;
846: l_datetrack_mode varchar2(80) := hr_api.g_update;
847: l_process_date date;
848: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
849: --
850: --UPD END

Line 1209: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

1205: end if;
1206: --
1207: -- Delete the row if it is end dated.
1208: --
1209: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
1210: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
1211: trunc(l_max_eed) = trunc(r_CGP.information3)) then
1212: --
1213: BEN_CNTNG_PRTN_ELIG_PRFL_API.delete_CNTNG_PRTN_ELIG_PRFL(

Line 1221: ,p_datetrack_mode => hr_api.g_delete

1217: ,p_effective_start_date => l_effective_start_date
1218: ,p_effective_end_date => l_effective_end_date
1219: ,p_object_version_number => l_object_version_number
1220: ,p_effective_date => l_max_eed
1221: ,p_datetrack_mode => hr_api.g_delete
1222: --
1223: );
1224: --
1225: end if;

Line 1342: l_datetrack_mode varchar2(80) := hr_api.g_update;

1338: --l_current_pk_id number := null ;
1339: --UPD START
1340: --
1341: l_update boolean := false ;
1342: l_datetrack_mode varchar2(80) := hr_api.g_update;
1343: l_process_date date;
1344: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
1345: --
1346: --UPD END

Line 1701: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

1697: end if;
1698: --
1699: -- Delete the row if it is end dated.
1700: --
1701: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
1702: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
1703: trunc(l_max_eed) = trunc(r_EAP.information3)) then
1704: --
1705: BEN_ELIG_AGE_PRTE_API.delete_ELIG_AGE_PRTE(

Line 1713: ,p_datetrack_mode => hr_api.g_delete

1709: ,p_effective_start_date => l_effective_start_date
1710: ,p_effective_end_date => l_effective_end_date
1711: ,p_object_version_number => l_object_version_number
1712: ,p_effective_date => l_max_eed
1713: ,p_datetrack_mode => hr_api.g_delete
1714: --
1715: );
1716: --
1717: end if;

Line 1833: l_datetrack_mode varchar2(80) := hr_api.g_update;

1829:
1830: --UPD START
1831: --
1832: l_update boolean := false ;
1833: l_datetrack_mode varchar2(80) := hr_api.g_update;
1834: l_process_date date;
1835: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
1836: --
1837: --UPD END

Line 2191: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

2187: end if;
2188: --
2189: -- Delete the row if it is end dated.
2190: --
2191: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
2192: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
2193: trunc(l_max_eed) = trunc(r_EBN.information3)) then
2194: --
2195: BEN_ELIG_BENFTS_GRP_PRTE_API.delete_ELIG_BENFTS_GRP_PRTE(

Line 2203: ,p_datetrack_mode => hr_api.g_delete

2199: ,p_effective_start_date => l_effective_start_date
2200: ,p_effective_end_date => l_effective_end_date
2201: ,p_object_version_number => l_object_version_number
2202: ,p_effective_date => l_max_eed
2203: ,p_datetrack_mode => hr_api.g_delete
2204: --
2205: );
2206: --
2207: end if;

Line 2324: l_datetrack_mode varchar2(80) := hr_api.g_update;

2320:
2321: --UPD START
2322: --
2323: l_update boolean := false ;
2324: l_datetrack_mode varchar2(80) := hr_api.g_update;
2325: l_process_date date;
2326: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
2327: --
2328: --UPD END

Line 2684: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

2680: end if;
2681: --
2682: -- Delete the row if it is end dated.
2683: --
2684: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
2685: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
2686: trunc(l_max_eed) = trunc(r_EBU.information3)) then
2687: --
2688: BEN_ELIG_BRGNG_UNIT_PRTE_API.delete_ELIG_BRGNG_UNIT_PRTE(

Line 2696: ,p_datetrack_mode => hr_api.g_delete

2692: ,p_effective_start_date => l_effective_start_date
2693: ,p_effective_end_date => l_effective_end_date
2694: ,p_object_version_number => l_object_version_number
2695: ,p_effective_date => l_max_eed
2696: ,p_datetrack_mode => hr_api.g_delete
2697: --
2698: );
2699: --
2700: end if;

Line 2816: l_datetrack_mode varchar2(80) := hr_api.g_update;

2812:
2813: --UPD START
2814: --
2815: l_update boolean := false ;
2816: l_datetrack_mode varchar2(80) := hr_api.g_update;
2817: l_process_date date;
2818: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
2819: --
2820: --UPD END

Line 3174: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

3170: end if;
3171: --
3172: -- Delete the row if it is end dated.
3173: --
3174: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
3175: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
3176: trunc(l_max_eed) = trunc(r_ECL.information3)) then
3177: --
3178: BEN_ELIG_COMP_LVL_PRTE_API.delete_ELIG_COMP_LVL_PRTE(

Line 3186: ,p_datetrack_mode => hr_api.g_delete

3182: ,p_effective_start_date => l_effective_start_date
3183: ,p_effective_end_date => l_effective_end_date
3184: ,p_object_version_number => l_object_version_number
3185: ,p_effective_date => l_max_eed
3186: ,p_datetrack_mode => hr_api.g_delete
3187: --
3188: );
3189: --
3190: end if;

Line 3306: l_datetrack_mode varchar2(80) := hr_api.g_update;

3302:
3303: --UPD START
3304: --
3305: l_update boolean := false ;
3306: l_datetrack_mode varchar2(80) := hr_api.g_update;
3307: l_process_date date;
3308: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
3309: --
3310: --UPD END

Line 3669: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

3665: end if;
3666: --
3667: -- Delete the row if it is end dated.
3668: --
3669: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
3670: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
3671: trunc(l_max_eed) = trunc(r_ECP.information3)) then
3672: --
3673: BEN_ELIG_CMBN_AGE_LOS_API.delete_ELIG_CMBN_AGE_LOS(

Line 3681: ,p_datetrack_mode => hr_api.g_delete

3677: ,p_effective_start_date => l_effective_start_date
3678: ,p_effective_end_date => l_effective_end_date
3679: ,p_object_version_number => l_object_version_number
3680: ,p_effective_date => l_max_eed
3681: ,p_datetrack_mode => hr_api.g_delete
3682: --
3683: );
3684: --
3685: end if;

Line 3805: l_datetrack_mode varchar2(80) := hr_api.g_update;

3801:
3802: --UPD START
3803: --
3804: l_update boolean := false ;
3805: l_datetrack_mode varchar2(80) := hr_api.g_update;
3806: l_process_date date;
3807: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
3808: --
3809: --UPD END

Line 4180: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

4176: end if;
4177: --
4178: -- Delete the row if it is end dated.
4179: --
4180: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
4181: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
4182: trunc(l_max_eed) = trunc(r_ECQ.information3)) then
4183: --
4184: BEN_ELIG_CBR_QUALD_BNF_API.delete_ELIG_CBR_QUALD_BNF(

Line 4192: ,p_datetrack_mode => hr_api.g_delete

4188: ,p_effective_start_date => l_effective_start_date
4189: ,p_effective_end_date => l_effective_end_date
4190: ,p_object_version_number => l_object_version_number
4191: ,p_effective_date => l_max_eed
4192: ,p_datetrack_mode => hr_api.g_delete
4193: --
4194: );
4195: --
4196: end if;

Line 4316: l_datetrack_mode varchar2(80) := hr_api.g_update;

4312:
4313: --UPD START
4314: --
4315: l_update boolean := false ;
4316: l_datetrack_mode varchar2(80) := hr_api.g_update;
4317: l_process_date date;
4318: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
4319: --
4320: --UPD END

Line 4720: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

4716: end if; /* l_first_rec and not l_update */
4717: --
4718: -- Delete the row if it is end dated.
4719: --
4720: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
4721: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
4722: trunc(l_max_eed) = trunc(r_ECY.information3)) then
4723: --
4724: BEN_ELIG_COMPTNCY_PRTE_API.delete_ELIG_COMPTNCY_PRTE(

Line 4732: ,p_datetrack_mode => hr_api.g_delete

4728: ,p_effective_start_date => l_effective_start_date
4729: ,p_effective_end_date => l_effective_end_date
4730: ,p_object_version_number => l_object_version_number
4731: ,p_effective_date => l_max_eed
4732: ,p_datetrack_mode => hr_api.g_delete
4733: --
4734: );
4735: --
4736: end if;

Line 4937: l_datetrack_mode varchar2(80) := hr_api.g_update;

4933:
4934: --UPD START
4935: --
4936: l_update boolean := false ;
4937: l_datetrack_mode varchar2(80) := hr_api.g_update;
4938: l_process_date date;
4939: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
4940: --
4941: --UPD END

Line 5304: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

5300: end if;
5301: --
5302: -- Delete the row if it is end dated.
5303: --
5304: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
5305: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
5306: trunc(l_max_eed) = trunc(r_EDG.information3)) then
5307: --
5308: BEN_ELIG_DPNT_CVRD_O_PGM_API.delete_ELIG_DPNT_CVRD_O_PGM(

Line 5316: ,p_datetrack_mode => hr_api.g_delete

5312: ,p_effective_start_date => l_effective_start_date
5313: ,p_effective_end_date => l_effective_end_date
5314: ,p_object_version_number => l_object_version_number
5315: ,p_effective_date => l_max_eed
5316: ,p_datetrack_mode => hr_api.g_delete
5317: --
5318: );
5319: --
5320: end if;

Line 5440: l_datetrack_mode varchar2(80) := hr_api.g_update;

5436:
5437: --UPD START
5438: --
5439: l_update boolean := false ;
5440: l_datetrack_mode varchar2(80) := hr_api.g_update;
5441: l_process_date date;
5442: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
5443: --
5444: --UPD END

Line 5808: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

5804: end if;
5805: --
5806: -- Delete the row if it is end dated.
5807: --
5808: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
5809: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
5810: trunc(l_max_eed) = trunc(r_EDI.information3)) then
5811: --
5812: BEN_ELIG_DPNT_CVRD_PLIP_API.delete_ELIG_DPNT_CVRD_PLIP(

Line 5820: ,p_datetrack_mode => hr_api.g_delete

5816: ,p_effective_start_date => l_effective_start_date
5817: ,p_effective_end_date => l_effective_end_date
5818: ,p_object_version_number => l_object_version_number
5819: ,p_effective_date => l_max_eed
5820: ,p_datetrack_mode => hr_api.g_delete
5821: --
5822: );
5823: --
5824: end if;

Line 5943: l_datetrack_mode varchar2(80) := hr_api.g_update;

5939:
5940: --UPD START
5941: --
5942: l_update boolean := false ;
5943: l_datetrack_mode varchar2(80) := hr_api.g_update;
5944: l_process_date date;
5945: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
5946: --
5947: --UPD END

Line 6307: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

6303: end if;
6304: --
6305: -- Delete the row if it is end dated.
6306: --
6307: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
6308: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
6309: trunc(l_max_eed) = trunc(r_EDP.information3)) then
6310: --
6311: BEN_ELIG_DPNT_CVD_OTHR_PL_API.delete_ELIG_DPNT_CVD_OTHR_PL(

Line 6319: ,p_datetrack_mode => hr_api.g_delete

6315: ,p_effective_start_date => l_effective_start_date
6316: ,p_effective_end_date => l_effective_end_date
6317: ,p_object_version_number => l_object_version_number
6318: ,p_effective_date => l_max_eed
6319: ,p_datetrack_mode => hr_api.g_delete
6320: --
6321: );
6322: --
6323: end if;

Line 6442: l_datetrack_mode varchar2(80) := hr_api.g_update;

6438:
6439: --UPD START
6440: --
6441: l_update boolean := false ;
6442: l_datetrack_mode varchar2(80) := hr_api.g_update;
6443: l_process_date date;
6444: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6445: --
6446: --UPD END

Line 6807: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

6803: end if;
6804: --
6805: -- Delete the row if it is end dated.
6806: --
6807: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
6808: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
6809: trunc(l_max_eed) = trunc(r_EDT.information3)) then
6810: --
6811: BEN_ELIG_DPNT_CVRD_O_PTIP_API.delete_ELIG_DPNT_CVRD_O_PTIP(

Line 6819: ,p_datetrack_mode => hr_api.g_delete

6815: ,p_effective_start_date => l_effective_start_date
6816: ,p_effective_end_date => l_effective_end_date
6817: ,p_object_version_number => l_object_version_number
6818: ,p_effective_date => l_max_eed
6819: ,p_datetrack_mode => hr_api.g_delete
6820: --
6821: );
6822: --
6823: end if;

Line 6942: l_datetrack_mode varchar2(80) := hr_api.g_update;

6938:
6939: --UPD START
6940: --
6941: l_update boolean := false ;
6942: l_datetrack_mode varchar2(80) := hr_api.g_update;
6943: l_process_date date;
6944: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6945: --
6946: --UPD END

Line 7307: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

7303: end if;
7304: --
7305: -- Delete the row if it is end dated.
7306: --
7307: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
7308: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
7309: trunc(l_max_eed) = trunc(r_ERL.information3)) then
7310: --
7311: BEN_ELIGY_PROFILE_RULE_API.delete_ELIGY_PROFILE_RULE(

Line 7319: ,p_datetrack_mode => hr_api.g_delete

7315: ,p_effective_start_date => l_effective_start_date
7316: ,p_effective_end_date => l_effective_end_date
7317: ,p_object_version_number => l_object_version_number
7318: ,p_effective_date => l_max_eed
7319: ,p_datetrack_mode => hr_api.g_delete
7320: --
7321: );
7322: --
7323: end if;

Line 7439: l_datetrack_mode varchar2(80) := hr_api.g_update;

7435:
7436: --UPD START
7437: --
7438: l_update boolean := false ;
7439: l_datetrack_mode varchar2(80) := hr_api.g_update;
7440: l_process_date date;
7441: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
7442: --
7443: --UPD END

Line 7799: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

7795: end if;
7796: --
7797: -- Delete the row if it is end dated.
7798: --
7799: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
7800: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
7801: trunc(l_max_eed) = trunc(r_EHW.information3)) then
7802: --
7803: BEN_ELIG_HRS_WKD_PRTE_API.delete_ELIG_HRS_WKD_PRTE(

Line 7811: ,p_datetrack_mode => hr_api.g_delete

7807: ,p_effective_start_date => l_effective_start_date
7808: ,p_effective_end_date => l_effective_end_date
7809: ,p_object_version_number => l_object_version_number
7810: ,p_effective_date => l_max_eed
7811: ,p_datetrack_mode => hr_api.g_delete
7812: --
7813: );
7814: --
7815: end if;

Line 7936: l_datetrack_mode varchar2(80) := hr_api.g_update;

7932:
7933: --UPD START
7934: --
7935: l_update boolean := false ;
7936: l_datetrack_mode varchar2(80) := hr_api.g_update;
7937: l_process_date date;
7938: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
7939: --
7940: --UPD END

Line 8315: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

8311: end if;
8312: --
8313: -- Delete the row if it is end dated.
8314: --
8315: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
8316: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
8317: trunc(l_max_eed) = trunc(r_EJP.information3)) then
8318: --
8319: BEN_ELIGY_JOB_PRTE_API.delete_ELIGY_JOB_PRTE(

Line 8327: ,p_datetrack_mode => hr_api.g_delete

8323: ,p_effective_start_date => l_effective_start_date
8324: ,p_effective_end_date => l_effective_end_date
8325: ,p_object_version_number => l_object_version_number
8326: ,p_effective_date => l_max_eed
8327: ,p_datetrack_mode => hr_api.g_delete
8328: --
8329: );
8330: --
8331: end if;

Line 8450: l_datetrack_mode varchar2(80) := hr_api.g_update;

8446:
8447: --UPD START
8448: --
8449: l_update boolean := false ;
8450: l_datetrack_mode varchar2(80) := hr_api.g_update;
8451: l_process_date date;
8452: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
8453: --
8454: --UPD END

Line 8807: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

8803: end if;
8804: --
8805: -- Delete the row if it is end dated.
8806: --
8807: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
8808: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
8809: trunc(l_max_eed) = trunc(r_ELU.information3)) then
8810: --
8811: BEN_ELIG_LBR_MMBR_PRTE_API.delete_ELIG_LBR_MMBR_PRTE(

Line 8819: ,p_datetrack_mode => hr_api.g_delete

8815: ,p_effective_start_date => l_effective_start_date
8816: ,p_effective_end_date => l_effective_end_date
8817: ,p_object_version_number => l_object_version_number
8818: ,p_effective_date => l_max_eed
8819: ,p_datetrack_mode => hr_api.g_delete
8820: --
8821: );
8822: --
8823: end if;

Line 8939: l_datetrack_mode varchar2(80) := hr_api.g_update;

8935:
8936: --UPD START
8937: --
8938: l_update boolean := false ;
8939: l_datetrack_mode varchar2(80) := hr_api.g_update;
8940: l_process_date date;
8941: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
8942: --
8943: --UPD END

Line 9321: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

9317: end if;
9318: --
9319: -- Delete the row if it is end dated.
9320: --
9321: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
9322: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
9323: trunc(l_max_eed) = trunc(r_ELN.information3)) then
9324: --
9325: BEN_ELIG_LGL_ENTY_PRTE_API.delete_ELIG_LGL_ENTY_PRTE(

Line 9333: ,p_datetrack_mode => hr_api.g_delete

9329: ,p_effective_start_date => l_effective_start_date
9330: ,p_effective_end_date => l_effective_end_date
9331: ,p_object_version_number => l_object_version_number
9332: ,p_effective_date => l_max_eed
9333: ,p_datetrack_mode => hr_api.g_delete
9334: --
9335: );
9336: --
9337: end if;

Line 9459: l_datetrack_mode varchar2(80) := hr_api.g_update;

9455:
9456: --UPD START
9457: --
9458: l_update boolean := false ;
9459: l_datetrack_mode varchar2(80) := hr_api.g_update;
9460: l_process_date date;
9461: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
9462: --
9463: --UPD END

Line 9873: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

9869: end if;
9870: --
9871: -- Delete the row if it is end dated.
9872: --
9873: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
9874: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
9875: trunc(l_max_eed) = trunc(r_ELR.information3)) then
9876: --
9877: BEN_ELIG_LOA_RSN_PRTE_API.delete_ELIG_LOA_RSN_PRTE(

Line 9885: ,p_datetrack_mode => hr_api.g_delete

9881: ,p_effective_start_date => l_effective_start_date
9882: ,p_effective_end_date => l_effective_end_date
9883: ,p_object_version_number => l_object_version_number
9884: ,p_effective_date => l_max_eed
9885: ,p_datetrack_mode => hr_api.g_delete
9886: --
9887: );
9888: --
9889: end if;

Line 10010: l_datetrack_mode varchar2(80) := hr_api.g_update;

10006:
10007: --UPD START
10008: --
10009: l_update boolean := false ;
10010: l_datetrack_mode varchar2(80) := hr_api.g_update;
10011: l_process_date date;
10012: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
10013: --
10014: --UPD END

Line 10371: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

10367: end if;
10368: --
10369: -- Delete the row if it is end dated.
10370: --
10371: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
10372: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
10373: trunc(l_max_eed) = trunc(r_ELS.information3)) then
10374: --
10375: BEN_ELIG_LOS_PRTE_API.delete_ELIG_LOS_PRTE(

Line 10383: ,p_datetrack_mode => hr_api.g_delete

10379: ,p_effective_start_date => l_effective_start_date
10380: ,p_effective_end_date => l_effective_end_date
10381: ,p_object_version_number => l_object_version_number
10382: ,p_effective_date => l_max_eed
10383: ,p_datetrack_mode => hr_api.g_delete
10384: --
10385: );
10386: --
10387: end if;

Line 10504: l_datetrack_mode varchar2(80) := hr_api.g_update;

10500:
10501: --UPD START
10502: --
10503: l_update boolean := false ;
10504: l_datetrack_mode varchar2(80) := hr_api.g_update;
10505: l_process_date date;
10506: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
10507: --
10508: --UPD END

Line 10866: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

10862: end if;
10863: --
10864: -- Delete the row if it is end dated.
10865: --
10866: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
10867: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
10868: trunc(l_max_eed) = trunc(r_ELV.information3)) then
10869: --
10870: BEN_ELIG_LVG_RSN_PRTE_API.delete_ELIG_LVG_RSN_PRTE(

Line 10878: ,p_datetrack_mode => hr_api.g_delete

10874: ,p_effective_start_date => l_effective_start_date
10875: ,p_effective_end_date => l_effective_end_date
10876: ,p_object_version_number => l_object_version_number
10877: ,p_effective_date => l_max_eed
10878: ,p_datetrack_mode => hr_api.g_delete
10879: --
10880: );
10881: --
10882: end if;

Line 11000: l_datetrack_mode varchar2(80) := hr_api.g_update;

10996:
10997: --UPD START
10998: --
10999: l_update boolean := false ;
11000: l_datetrack_mode varchar2(80) := hr_api.g_update;
11001: l_process_date date;
11002: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
11003: --
11004: --UPD END

Line 11360: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

11356: end if;
11357: --
11358: -- Delete the row if it is end dated.
11359: --
11360: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
11361: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
11362: trunc(l_max_eed) = trunc(r_EMP.information3)) then
11363: --
11364: BEN_ELIG_MRTL_STS_PRTE_API.delete_ELIG_MRTL_STS_PRTE(

Line 11372: ,p_datetrack_mode => hr_api.g_delete

11368: ,p_effective_start_date => l_effective_start_date
11369: ,p_effective_end_date => l_effective_end_date
11370: ,p_object_version_number => l_object_version_number
11371: ,p_effective_date => l_max_eed
11372: ,p_datetrack_mode => hr_api.g_delete
11373: --
11374: );
11375: --
11376: end if;

Line 11494: l_datetrack_mode varchar2(80) := hr_api.g_update;

11490:
11491: --UPD START
11492: --
11493: l_update boolean := false ;
11494: l_datetrack_mode varchar2(80) := hr_api.g_update;
11495: l_process_date date;
11496: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
11497: --
11498: --UPD END

Line 11846: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

11842: end if;
11843: --
11844: -- Delete the row if it is end dated.
11845: --
11846: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
11847: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
11848: trunc(l_max_eed) = trunc(r_ENO.information3)) then
11849: --
11850: BEN_ELIG_NO_OTHR_CVG_PRTE_API.delete_ELIG_NO_OTHR_CVG_PRTE(

Line 11858: ,p_datetrack_mode => hr_api.g_delete

11854: ,p_effective_start_date => l_effective_start_date
11855: ,p_effective_end_date => l_effective_end_date
11856: ,p_object_version_number => l_object_version_number
11857: ,p_effective_date => l_max_eed
11858: ,p_datetrack_mode => hr_api.g_delete
11859: --
11860: );
11861: --
11862: end if;

Line 11979: l_datetrack_mode varchar2(80) := hr_api.g_update;

11975:
11976: --UPD START
11977: --
11978: l_update boolean := false ;
11979: l_datetrack_mode varchar2(80) := hr_api.g_update;
11980: l_process_date date;
11981: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
11982: --
11983: --UPD END

Line 12334: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

12330: end if;
12331: --
12332: -- Delete the row if it is end dated.
12333: --
12334: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
12335: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
12336: trunc(l_max_eed) = trunc(r_EOM.information3)) then
12337: --
12338: BEN_ELIG_OPTD_MDCR_PRTE_API.delete_ELIG_OPTD_MDCR_PRTE(

Line 12346: ,p_datetrack_mode => hr_api.g_delete

12342: ,p_effective_start_date => l_effective_start_date
12343: ,p_effective_end_date => l_effective_end_date
12344: ,p_object_version_number => l_object_version_number
12345: ,p_effective_date => l_max_eed
12346: ,p_datetrack_mode => hr_api.g_delete
12347: --
12348: );
12349: --
12350: end if;

Line 12464: l_datetrack_mode varchar2(80) := hr_api.g_update;

12460:
12461: --UPD START
12462: --
12463: l_update boolean := false ;
12464: l_datetrack_mode varchar2(80) := hr_api.g_update;
12465: l_process_date date;
12466: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
12467: --
12468: --UPD END

Line 12848: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

12844: end if;
12845: --
12846: -- Delete the row if it is end dated.
12847: --
12848: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
12849: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
12850: trunc(l_max_eed) = trunc(r_EOU.information3)) then
12851: --
12852: BEN_ELIG_ORG_UNIT_PRTE_API.delete_ELIG_ORG_UNIT_PRTE(

Line 12860: ,p_datetrack_mode => hr_api.g_delete

12856: ,p_effective_start_date => l_effective_start_date
12857: ,p_effective_end_date => l_effective_end_date
12858: ,p_object_version_number => l_object_version_number
12859: ,p_effective_date => l_max_eed
12860: ,p_datetrack_mode => hr_api.g_delete
12861: --
12862: );
12863: --
12864: end if;

Line 12984: l_datetrack_mode varchar2(80) := hr_api.g_update;

12980:
12981: --UPD START
12982: --
12983: l_update boolean := false ;
12984: l_datetrack_mode varchar2(80) := hr_api.g_update;
12985: l_process_date date;
12986: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
12987: --
12988: --UPD END

Line 13346: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

13342: end if;
13343: --
13344: -- Delete the row if it is end dated.
13345: --
13346: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
13347: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
13348: trunc(l_max_eed) = trunc(r_EOY.information3)) then
13349: --
13350: BEN_ELIG_OTHR_PTIP_PRTE_API.delete_ELIG_OTHR_PTIP_PRTE(

Line 13358: ,p_datetrack_mode => hr_api.g_delete

13354: ,p_effective_start_date => l_effective_start_date
13355: ,p_effective_end_date => l_effective_end_date
13356: ,p_object_version_number => l_object_version_number
13357: ,p_effective_date => l_max_eed
13358: ,p_datetrack_mode => hr_api.g_delete
13359: --
13360: );
13361: --
13362: end if;

Line 13483: l_datetrack_mode varchar2(80) := hr_api.g_update;

13479:
13480: --UPD START
13481: --
13482: l_update boolean := false ;
13483: l_datetrack_mode varchar2(80) := hr_api.g_update;
13484: l_process_date date;
13485: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13486: --
13487: --UPD END

Line 13845: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

13841: end if;
13842: --
13843: -- Delete the row if it is end dated.
13844: --
13845: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
13846: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
13847: trunc(l_max_eed) = trunc(r_EPF.information3)) then
13848: --
13849: BEN_ELIG_PCT_FL_TM_PRTE_API.delete_ELIG_PCT_FL_TM_PRTE(

Line 13857: ,p_datetrack_mode => hr_api.g_delete

13853: ,p_effective_start_date => l_effective_start_date
13854: ,p_effective_end_date => l_effective_end_date
13855: ,p_object_version_number => l_object_version_number
13856: ,p_effective_date => l_max_eed
13857: ,p_datetrack_mode => hr_api.g_delete
13858: --
13859: );
13860: --
13861: end if;

Line 13980: l_datetrack_mode varchar2(80) := hr_api.g_update;

13976:
13977: --UPD START
13978: --
13979: l_update boolean := false ;
13980: l_datetrack_mode varchar2(80) := hr_api.g_update;
13981: l_process_date date;
13982: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13983: --
13984: --UPD END

Line 14369: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

14365: end if;
14366: --
14367: -- Delete the row if it is end dated.
14368: --
14369: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
14370: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
14371: trunc(l_max_eed) = trunc(r_EPT.information3)) then
14372: --
14373: BEN_ELIG_PER_TYP_PRTE_API.delete_ELIG_PER_TYP_PRTE(

Line 14381: ,p_datetrack_mode => hr_api.g_delete

14377: ,p_effective_start_date => l_effective_start_date
14378: ,p_effective_end_date => l_effective_end_date
14379: ,p_object_version_number => l_object_version_number
14380: ,p_effective_date => l_max_eed
14381: ,p_datetrack_mode => hr_api.g_delete
14382: --
14383: );
14384: --
14385: end if;

Line 14506: l_datetrack_mode varchar2(80) := hr_api.g_update;

14502:
14503: --UPD START
14504: --
14505: l_update boolean := false ;
14506: l_datetrack_mode varchar2(80) := hr_api.g_update;
14507: l_process_date date;
14508: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
14509: --
14510: --UPD END

Line 14876: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

14872: end if;
14873: --
14874: -- Delete the row if it is end dated.
14875: --
14876: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
14877: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
14878: trunc(l_max_eed) = trunc(r_EPG.information3)) then
14879: --
14880: BEN_ELIG_PPL_GRP_PRTE_API.delete_ELIG_PPL_GRP_PRTE(

Line 14888: ,p_datetrack_mode => hr_api.g_delete

14884: ,p_effective_start_date => l_effective_start_date
14885: ,p_effective_end_date => l_effective_end_date
14886: ,p_object_version_number => l_object_version_number
14887: ,p_effective_date => l_max_eed
14888: ,p_datetrack_mode => hr_api.g_delete
14889: --
14890: );
14891: --
14892: end if;

Line 15009: l_datetrack_mode varchar2(80) := hr_api.g_update;

15005:
15006: --UPD START
15007: --
15008: l_update boolean := false ;
15009: l_datetrack_mode varchar2(80) := hr_api.g_update;
15010: l_process_date date;
15011: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
15012: --
15013: --UPD END

Line 15388: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

15384: end if;
15385: --
15386: -- Delete the row if it is end dated.
15387: --
15388: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
15389: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
15390: trunc(l_max_eed) = trunc(r_EPB.information3)) then
15391: --
15392: BEN_ELIG_PY_BSS_PRTE_API.delete_ELIG_PY_BSS_PRTE(

Line 15400: ,p_datetrack_mode => hr_api.g_delete

15396: ,p_effective_start_date => l_effective_start_date
15397: ,p_effective_end_date => l_effective_end_date
15398: ,p_object_version_number => l_object_version_number
15399: ,p_effective_date => l_max_eed
15400: ,p_datetrack_mode => hr_api.g_delete
15401: --
15402: );
15403: --
15404: end if;

Line 15530: l_datetrack_mode varchar2(80) := hr_api.g_update;

15526:
15527: --UPD START
15528: --
15529: l_update boolean := false ;
15530: l_datetrack_mode varchar2(80) := hr_api.g_update;
15531: l_process_date date;
15532: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
15533: --
15534: --UPD END

Line 15897: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

15893: end if;
15894: --
15895: -- Delete the row if it is end dated.
15896: --
15897: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
15898: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
15899: trunc(l_max_eed) = trunc(r_EPN.information3)) then
15900: --
15901: BEN_ELIG_PRBTN_PERD_PRTE_API.delete_ELIG_PRBTN_PERD_PRTE(

Line 15909: ,p_datetrack_mode => hr_api.g_delete

15905: ,p_effective_start_date => l_effective_start_date
15906: ,p_effective_end_date => l_effective_end_date
15907: ,p_object_version_number => l_object_version_number
15908: ,p_effective_date => l_max_eed
15909: ,p_datetrack_mode => hr_api.g_delete
15910: --
15911: );
15912: --
15913: end if;

Line 16031: l_datetrack_mode varchar2(80) := hr_api.g_update;

16027:
16028: --UPD START
16029: --
16030: l_update boolean := false ;
16031: l_datetrack_mode varchar2(80) := hr_api.g_update;
16032: l_process_date date;
16033: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
16034: --
16035: --UPD END

Line 16390: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

16386: end if;
16387: --
16388: -- Delete the row if it is end dated.
16389: --
16390: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
16391: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
16392: trunc(l_max_eed) = trunc(r_EPP.information3)) then
16393: --
16394: BEN_ELG_PRT_ANTHR_PL_PT_API.delete_ELG_PRT_ANTHR_PL_PT(

Line 16402: ,p_datetrack_mode => hr_api.g_delete

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_effective_date => l_max_eed
16402: ,p_datetrack_mode => hr_api.g_delete
16403: --
16404: );
16405: --
16406: end if;

Line 16521: l_datetrack_mode varchar2(80) := hr_api.g_update;

16517:
16518: --UPD START
16519: --
16520: l_update boolean := false ;
16521: l_datetrack_mode varchar2(80) := hr_api.g_update;
16522: l_process_date date;
16523: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
16524: --
16525: --UPD END

Line 16904: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

16900: end if;
16901: --
16902: -- Delete the row if it is end dated.
16903: --
16904: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
16905: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
16906: trunc(l_max_eed) = trunc(r_EPS.information3)) then
16907: --
16908: BEN_ELIG_PSTN_PRTE_API.delete_ELIG_PSTN_PRTE(

Line 16916: ,p_datetrack_mode => hr_api.g_delete

16912: ,p_effective_start_date => l_effective_start_date
16913: ,p_effective_end_date => l_effective_end_date
16914: ,p_object_version_number => l_object_version_number
16915: ,p_effective_date => l_max_eed
16916: ,p_datetrack_mode => hr_api.g_delete
16917: --
16918: );
16919: --
16920: end if;

Line 17037: l_datetrack_mode varchar2(80) := hr_api.g_update;

17033:
17034: --UPD START
17035: --
17036: l_update boolean := false ;
17037: l_datetrack_mode varchar2(80) := hr_api.g_update;
17038: l_process_date date;
17039: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
17040: --
17041: --UPD END

Line 17417: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

17413: end if;
17414: --
17415: -- Delete the row if it is end dated.
17416: --
17417: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
17418: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
17419: trunc(l_max_eed) = trunc(r_EPY.information3)) then
17420: --
17421: BEN_ELIG_PYRL_PRTE_API.delete_ELIG_PYRL_PRTE(

Line 17429: ,p_datetrack_mode => hr_api.g_delete

17425: ,p_effective_start_date => l_effective_start_date
17426: ,p_effective_end_date => l_effective_end_date
17427: ,p_object_version_number => l_object_version_number
17428: ,p_effective_date => l_max_eed
17429: ,p_datetrack_mode => hr_api.g_delete
17430: --
17431: );
17432: --
17433: end if;

Line 17550: l_datetrack_mode varchar2(80) := hr_api.g_update;

17546:
17547: --UPD START
17548: --
17549: l_update boolean := false ;
17550: l_datetrack_mode varchar2(80) := hr_api.g_update;
17551: l_process_date date;
17552: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
17553: --
17554: --UPD END

Line 17903: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

17899: end if;
17900: --
17901: -- Delete the row if it is end dated.
17902: --
17903: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
17904: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
17905: trunc(l_max_eed) = trunc(r_EPZ.information3)) then
17906: --
17907: BEN_ELIG_PSTL_CD_RNG_PRTE_API.delete_ELIG_PSTL_CD_RNG_PRTE(

Line 17915: ,p_datetrack_mode => hr_api.g_delete

17911: ,p_effective_start_date => l_effective_start_date
17912: ,p_effective_end_date => l_effective_end_date
17913: ,p_object_version_number => l_object_version_number
17914: ,p_effective_date => l_max_eed
17915: ,p_datetrack_mode => hr_api.g_delete
17916: --
17917: );
17918: --
17919: end if;

Line 18034: l_datetrack_mode varchar2(80) := hr_api.g_update;

18030:
18031: --UPD START
18032: --
18033: l_update boolean := false ;
18034: l_datetrack_mode varchar2(80) := hr_api.g_update;
18035: l_process_date date;
18036: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
18037: --
18038: --UPD END

Line 18416: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

18412: end if;
18413: --
18414: -- Delete the row if it is end dated.
18415: --
18416: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
18417: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
18418: trunc(l_max_eed) = trunc(r_EQT.information3)) then
18419: --
18420: BEN_ELIG_QUAL_TITL_PRTE_API.delete_ELIG_QUAL_TITL_PRTE(

Line 18428: ,p_datetrack_mode => hr_api.g_delete

18424: ,p_effective_start_date => l_effective_start_date
18425: ,p_effective_end_date => l_effective_end_date
18426: ,p_object_version_number => l_object_version_number
18427: ,p_effective_date => l_max_eed
18428: ,p_datetrack_mode => hr_api.g_delete
18429: --
18430: );
18431: --
18432: end if;

Line 18553: l_datetrack_mode varchar2(80) := hr_api.g_update;

18549:
18550: --UPD START
18551: --
18552: l_update boolean := false ;
18553: l_datetrack_mode varchar2(80) := hr_api.g_update;
18554: l_process_date date;
18555: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
18556: --
18557: --UPD END

Line 18924: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

18920: end if;
18921: --
18922: -- Delete the row if it is end dated.
18923: --
18924: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
18925: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
18926: trunc(l_max_eed) = trunc(r_ESA.information3)) then
18927: --
18928: BEN_ELIG_SVC_AREA_PRTE_API.delete_ELIG_SVC_AREA_PRTE(

Line 18936: ,p_datetrack_mode => hr_api.g_delete

18932: ,p_effective_start_date => l_effective_start_date
18933: ,p_effective_end_date => l_effective_end_date
18934: ,p_object_version_number => l_object_version_number
18935: ,p_effective_date => l_max_eed
18936: ,p_datetrack_mode => hr_api.g_delete
18937: --
18938: );
18939: --
18940: end if;

Line 19088: l_datetrack_mode varchar2(80) := hr_api.g_update;

19084:
19085: --UPD START
19086: --
19087: l_update boolean := false ;
19088: l_datetrack_mode varchar2(80) := hr_api.g_update;
19089: l_process_date date;
19090: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
19091: --
19092: --UPD END

Line 19479: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

19475: end if;
19476: --
19477: -- Delete the row if it is end dated.
19478: --
19479: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
19480: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
19481: trunc(l_max_eed) = trunc(r_ESH.information3)) then
19482: --
19483: BEN_ELIG_SCHEDD_HRS_PRTE_API.delete_ELIG_SCHEDD_HRS_PRTE(

Line 19491: ,p_datetrack_mode => hr_api.g_delete

19487: ,p_effective_start_date => l_effective_start_date
19488: ,p_effective_end_date => l_effective_end_date
19489: ,p_object_version_number => l_object_version_number
19490: ,p_effective_date => l_max_eed
19491: ,p_datetrack_mode => hr_api.g_delete
19492: --
19493: );
19494: --
19495: end if;

Line 19613: l_datetrack_mode varchar2(80) := hr_api.g_update;

19609:
19610: --UPD START
19611: --
19612: l_update boolean := false ;
19613: l_datetrack_mode varchar2(80) := hr_api.g_update;
19614: l_process_date date;
19615: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
19616: --
19617: --UPD END

Line 19998: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

19994: end if;
19995: --
19996: -- Delete the row if it is end dated.
19997: --
19998: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
19999: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
20000: trunc(l_max_eed) = trunc(r_ESP.information3)) then
20001: --
20002: BEN_ELIG_SP_CLNG_PRG_PRTE_API.delete_ELIG_SP_CLNG_PRG_PRTE(

Line 20010: ,p_datetrack_mode => hr_api.g_delete

20006: ,p_effective_start_date => l_effective_start_date
20007: ,p_effective_end_date => l_effective_end_date
20008: ,p_object_version_number => l_object_version_number
20009: ,p_effective_date => l_max_eed
20010: ,p_datetrack_mode => hr_api.g_delete
20011: --
20012: );
20013: --
20014: end if;

Line 20135: l_datetrack_mode varchar2(80) := hr_api.g_update;

20131:
20132: --UPD START
20133: --
20134: l_update boolean := false ;
20135: l_datetrack_mode varchar2(80) := hr_api.g_update;
20136: l_process_date date;
20137: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
20138: --
20139: --UPD END

Line 20523: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

20519: end if;
20520: --
20521: -- Delete the row if it is end dated.
20522: --
20523: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
20524: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
20525: trunc(l_max_eed) = trunc(r_EST.information3)) then
20526: --
20527: BEN_ELIG_SUPPL_ROLE_PRTE_API.delete_ELIG_SUPPL_ROLE_PRTE(

Line 20535: ,p_datetrack_mode => hr_api.g_delete

20531: ,p_effective_start_date => l_effective_start_date
20532: ,p_effective_end_date => l_effective_end_date
20533: ,p_object_version_number => l_object_version_number
20534: ,p_effective_date => l_max_eed
20535: ,p_datetrack_mode => hr_api.g_delete
20536: --
20537: );
20538: --
20539: end if;

Line 20656: l_datetrack_mode varchar2(80) := hr_api.g_update;

20652:
20653: --UPD START
20654: --
20655: l_update boolean := false ;
20656: l_datetrack_mode varchar2(80) := hr_api.g_update;
20657: l_process_date date;
20658: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
20659: --
20660: --UPD END

Line 21038: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

21034: end if;
21035: --
21036: -- Delete the row if it is end dated.
21037: --
21038: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
21039: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
21040: trunc(l_max_eed) = trunc(r_EWL.information3)) then
21041: --
21042: BEN_ELIG_WK_LOC_PRTE_API.delete_ELIG_WK_LOC_PRTE(

Line 21050: ,p_datetrack_mode => hr_api.g_delete

21046: ,p_effective_start_date => l_effective_start_date
21047: ,p_effective_end_date => l_effective_end_date
21048: ,p_object_version_number => l_object_version_number
21049: ,p_effective_date => l_max_eed
21050: ,p_datetrack_mode => hr_api.g_delete
21051: --
21052: );
21053: --
21054: end if;

Line 21177: l_datetrack_mode varchar2(80) := hr_api.g_update;

21173:
21174: --UPD START
21175: --
21176: l_update boolean := false ;
21177: l_datetrack_mode varchar2(80) := hr_api.g_update;
21178: l_process_date date;
21179: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
21180: --
21181: --UPD END

Line 21545: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

21541: end if;
21542: --
21543: -- Delete the row if it is end dated.
21544: --
21545: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
21546: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
21547: trunc(l_max_eed) = trunc(r_ETD.information3)) then
21548: --
21549: BEN_ELIG_DPNT_OTHR_PTIP_API.delete_ELIG_DPNT_OTHR_PTIP(

Line 21557: ,p_datetrack_mode => hr_api.g_delete

21553: ,p_effective_start_date => l_effective_start_date
21554: ,p_effective_end_date => l_effective_end_date
21555: ,p_object_version_number => l_object_version_number
21556: ,p_effective_date => l_max_eed
21557: ,p_datetrack_mode => hr_api.g_delete
21558: --
21559: );
21560: --
21561: end if;

Line 21685: l_datetrack_mode varchar2(80) := hr_api.g_update;

21681:
21682: --UPD START
21683: --
21684: l_update boolean := false ;
21685: l_datetrack_mode varchar2(80) := hr_api.g_update;
21686: l_process_date date;
21687: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
21688: --
21689: --UPD END

Line 22050: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

22046: end if;
22047: --
22048: -- Delete the row if it is end dated.
22049: --
22050: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
22051: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
22052: trunc(l_max_eed) = trunc(r_ECT.information3)) then
22053: --
22054: BEN_ELIG_DSBLTY_CTG_PRTE_API.delete_ELIG_DSBLTY_CTG_PRTE(

Line 22062: ,p_datetrack_mode => hr_api.g_delete

22058: ,p_effective_start_date => l_effective_start_date
22059: ,p_effective_end_date => l_effective_end_date
22060: ,p_object_version_number => l_object_version_number
22061: ,p_effective_date => l_max_eed
22062: ,p_datetrack_mode => hr_api.g_delete
22063: --
22064: );
22065: --
22066: end if;

Line 22191: l_datetrack_mode varchar2(80) := hr_api.g_update;

22187:
22188: --UPD START
22189: --
22190: l_update boolean := false ;
22191: l_datetrack_mode varchar2(80) := hr_api.g_update;
22192: l_process_date date;
22193: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
22194: --
22195: --UPD END

Line 22558: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

22554: end if;
22555: --
22556: -- Delete the row if it is end dated.
22557: --
22558: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
22559: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
22560: trunc(l_max_eed) = trunc(r_EDD.information3)) then
22561: --
22562: BEN_ELIG_DSBLTY_DGR_PRTE_API.delete_ELIG_DSBLTY_DGR_PRTE(

Line 22570: ,p_datetrack_mode => hr_api.g_delete

22566: ,p_effective_start_date => l_effective_start_date
22567: ,p_effective_end_date => l_effective_end_date
22568: ,p_object_version_number => l_object_version_number
22569: ,p_effective_date => l_max_eed
22570: ,p_datetrack_mode => hr_api.g_delete
22571: --
22572: );
22573: --
22574: end if;

Line 22700: l_datetrack_mode varchar2(80) := hr_api.g_update;

22696:
22697: --UPD START
22698: --
22699: l_update boolean := false ;
22700: l_datetrack_mode varchar2(80) := hr_api.g_update;
22701: l_process_date date;
22702: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
22703: --
22704: --UPD END

Line 23088: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

23084: end if;
23085: --
23086: -- Delete the row if it is end dated.
23087: --
23088: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
23089: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
23090: trunc(l_max_eed) = trunc(r_EDR.information3)) then
23091: --
23092: BEN_ELIG_DSBLTY_RSN_PRTE_API.delete_ELIG_DSBLTY_RSN_PRTE(

Line 23100: ,p_datetrack_mode => hr_api.g_delete

23096: ,p_effective_start_date => l_effective_start_date
23097: ,p_effective_end_date => l_effective_end_date
23098: ,p_object_version_number => l_object_version_number
23099: ,p_effective_date => l_max_eed
23100: ,p_datetrack_mode => hr_api.g_delete
23101: --
23102: );
23103: --
23104: end if;

Line 23219: l_datetrack_mode varchar2(80) := hr_api.g_update;

23215:
23216: --UPD START
23217: --
23218: l_update boolean := false ;
23219: l_datetrack_mode varchar2(80) := hr_api.g_update;
23220: l_process_date date;
23221: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
23222: --
23223: --UPD END

Line 23600: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

23596: end if;
23597: --
23598: -- Delete the row if it is end dated.
23599: --
23600: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
23601: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
23602: trunc(l_max_eed) = trunc(r_EES.information3)) then
23603: --
23604: BEN_ELIG_EE_STAT_PRTE_API.delete_ELIG_EE_STAT_PRTE(

Line 23612: ,p_datetrack_mode => hr_api.g_delete

23608: ,p_effective_start_date => l_effective_start_date
23609: ,p_effective_end_date => l_effective_end_date
23610: ,p_object_version_number => l_object_version_number
23611: ,p_effective_date => l_max_eed
23612: ,p_datetrack_mode => hr_api.g_delete
23613: --
23614: );
23615: --
23616: end if;

Line 23733: l_datetrack_mode varchar2(80) := hr_api.g_update;

23729:
23730: --UPD START
23731: --
23732: l_update boolean := false ;
23733: l_datetrack_mode varchar2(80) := hr_api.g_update;
23734: l_process_date date;
23735: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
23736: --
23737: --UPD END

Line 24096: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

24092: end if;
24093: --
24094: -- Delete the row if it is end dated.
24095: --
24096: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
24097: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
24098: trunc(l_max_eed) = trunc(r_EEI.information3)) then
24099: --
24100: BEN_ELIG_ENRLD_ANTHR_OIPL_API.delete_ELIG_ENRLD_ANTHR_OIPL(

Line 24108: ,p_datetrack_mode => hr_api.g_delete

24104: ,p_effective_start_date => l_effective_start_date
24105: ,p_effective_end_date => l_effective_end_date
24106: ,p_object_version_number => l_object_version_number
24107: ,p_effective_date => l_max_eed
24108: ,p_datetrack_mode => hr_api.g_delete
24109: --
24110: );
24111: --
24112: end if;

Line 24227: l_datetrack_mode varchar2(80) := hr_api.g_update;

24223:
24224: --UPD START
24225: --
24226: l_update boolean := false ;
24227: l_datetrack_mode varchar2(80) := hr_api.g_update;
24228: l_process_date date;
24229: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
24230: --
24231: --UPD END

Line 24590: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

24586: end if;
24587: --
24588: -- Delete the row if it is end dated.
24589: --
24590: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
24591: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
24592: trunc(l_max_eed) = trunc(r_EEG.information3)) then
24593: --
24594: BEN_ELIG_ENRLD_ANTHR_PGM_API.delete_ELIG_ENRLD_ANTHR_PGM(

Line 24602: ,p_datetrack_mode => hr_api.g_delete

24598: ,p_effective_start_date => l_effective_start_date
24599: ,p_effective_end_date => l_effective_end_date
24600: ,p_object_version_number => l_object_version_number
24601: ,p_effective_date => l_max_eed
24602: ,p_datetrack_mode => hr_api.g_delete
24603: --
24604: );
24605: --
24606: end if;

Line 24721: l_datetrack_mode varchar2(80) := hr_api.g_update;

24717:
24718: --UPD START
24719: --
24720: l_update boolean := false ;
24721: l_datetrack_mode varchar2(80) := hr_api.g_update;
24722: l_process_date date;
24723: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
24724: --
24725: --UPD END

Line 25083: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

25079: end if;
25080: --
25081: -- Delete the row if it is end dated.
25082: --
25083: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
25084: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
25085: trunc(l_max_eed) = trunc(r_EAI.information3)) then
25086: --
25087: BEN_ELIG_ENRLD_ANTHR_PLIP_API.delete_ELIG_ENRLD_ANTHR_PLIP(

Line 25095: ,p_datetrack_mode => hr_api.g_delete

25091: ,p_effective_start_date => l_effective_start_date
25092: ,p_effective_end_date => l_effective_end_date
25093: ,p_object_version_number => l_object_version_number
25094: ,p_effective_date => l_max_eed
25095: ,p_datetrack_mode => hr_api.g_delete
25096: --
25097: );
25098: --
25099: end if;

Line 25214: l_datetrack_mode varchar2(80) := hr_api.g_update;

25210:
25211: --UPD START
25212: --
25213: l_update boolean := false ;
25214: l_datetrack_mode varchar2(80) := hr_api.g_update;
25215: l_process_date date;
25216: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
25217: --
25218: --UPD END

Line 25574: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

25570: end if;
25571: --
25572: -- Delete the row if it is end dated.
25573: --
25574: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
25575: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
25576: trunc(l_max_eed) = trunc(r_EEP.information3)) then
25577: --
25578: BEN_ELIG_ENRLD_ANTHR_PL_API.delete_ELIG_ENRLD_ANTHR_PL(

Line 25586: ,p_datetrack_mode => hr_api.g_delete

25582: ,p_effective_start_date => l_effective_start_date
25583: ,p_effective_end_date => l_effective_end_date
25584: ,p_object_version_number => l_object_version_number
25585: ,p_effective_date => l_max_eed
25586: ,p_datetrack_mode => hr_api.g_delete
25587: --
25588: );
25589: --
25590: end if;

Line 25705: l_datetrack_mode varchar2(80) := hr_api.g_update;

25701:
25702: --UPD START
25703: --
25704: l_update boolean := false ;
25705: l_datetrack_mode varchar2(80) := hr_api.g_update;
25706: l_process_date date;
25707: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
25708: --
25709: --UPD END

Line 26072: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

26068: end if;
26069: --
26070: -- Delete the row if it is end dated.
26071: --
26072: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
26073: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
26074: trunc(l_max_eed) = trunc(r_EET.information3)) then
26075: --
26076: BEN_ELIG_ENRLD_ANTHR_PTIP_API.delete_ELIG_ENRLD_ANTHR_PTIP(

Line 26084: ,p_datetrack_mode => hr_api.g_delete

26080: ,p_effective_start_date => l_effective_start_date
26081: ,p_effective_end_date => l_effective_end_date
26082: ,p_object_version_number => l_object_version_number
26083: ,p_effective_date => l_max_eed
26084: ,p_datetrack_mode => hr_api.g_delete
26085: --
26086: );
26087: --
26088: end if;

Line 26210: l_datetrack_mode varchar2(80) := hr_api.g_update;

26206:
26207: --UPD START
26208: --
26209: l_update boolean := false ;
26210: l_datetrack_mode varchar2(80) := hr_api.g_update;
26211: l_process_date date;
26212: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
26213: --
26214: --UPD END

Line 26574: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

26570: end if;
26571: --
26572: -- Delete the row if it is end dated.
26573: --
26574: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
26575: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
26576: trunc(l_max_eed) = trunc(r_EFP.information3)) then
26577: --
26578: BEN_ELIG_FL_TM_PT_TM_PRTE_API.delete_ELIG_FL_TM_PT_TM_PRTE(

Line 26586: ,p_datetrack_mode => hr_api.g_delete

26582: ,p_effective_start_date => l_effective_start_date
26583: ,p_effective_end_date => l_effective_end_date
26584: ,p_object_version_number => l_object_version_number
26585: ,p_effective_date => l_max_eed
26586: ,p_datetrack_mode => hr_api.g_delete
26587: --
26588: );
26589: --
26590: end if;

Line 26716: l_datetrack_mode varchar2(80) := hr_api.g_update;

26712:
26713: --UPD START
26714: --
26715: l_update boolean := false ;
26716: l_datetrack_mode varchar2(80) := hr_api.g_update;
26717: l_process_date date;
26718: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
26719: --
26720: --UPD END

Line 27103: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

27099: end if;
27100: --
27101: -- Delete the row if it is end dated.
27102: --
27103: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
27104: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
27105: trunc(l_max_eed) = trunc(r_EGR.information3)) then
27106: --
27107: BEN_ELIG_GRD_PRTE_API.delete_ELIG_GRD_PRTE(

Line 27115: ,p_datetrack_mode => hr_api.g_delete

27111: ,p_effective_start_date => l_effective_start_date
27112: ,p_effective_end_date => l_effective_end_date
27113: ,p_object_version_number => l_object_version_number
27114: ,p_effective_date => l_max_eed
27115: ,p_datetrack_mode => hr_api.g_delete
27116: --
27117: );
27118: --
27119: end if;

Line 27242: l_datetrack_mode varchar2(80) := hr_api.g_update;

27238:
27239: --UPD START
27240: --
27241: l_update boolean := false ;
27242: l_datetrack_mode varchar2(80) := hr_api.g_update;
27243: l_process_date date;
27244: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
27245: --
27246: --UPD END

Line 27605: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

27601: end if;
27602: --
27603: -- Delete the row if it is end dated.
27604: --
27605: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
27606: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
27607: trunc(l_max_eed) = trunc(r_EHS.information3)) then
27608: --
27609: BEN_ELIG_HRLY_SLRD_PRTE_API.delete_ELIG_HRLY_SLRD_PRTE(

Line 27617: ,p_datetrack_mode => hr_api.g_delete

27613: ,p_effective_start_date => l_effective_start_date
27614: ,p_effective_end_date => l_effective_end_date
27615: ,p_object_version_number => l_object_version_number
27616: ,p_effective_date => l_max_eed
27617: ,p_datetrack_mode => hr_api.g_delete
27618: --
27619: );
27620: --
27621: end if;

Line 27745: l_datetrack_mode varchar2(80) := hr_api.g_update;

27741:
27742: --UPD START
27743: --
27744: l_update boolean := false ;
27745: l_datetrack_mode varchar2(80) := hr_api.g_update;
27746: l_process_date date;
27747: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
27748: --
27749: --UPD END

Line 28110: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

28106: end if;
28107: --
28108: -- Delete the row if it is end dated.
28109: --
28110: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
28111: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
28112: trunc(l_max_eed) = trunc(r_ERG.information3)) then
28113: --
28114: BEN_ELIG_PERF_RTNG_PRTE_API.delete_ELIG_PERF_RTNG_PRTE(

Line 28122: ,p_datetrack_mode => hr_api.g_delete

28118: ,p_effective_start_date => l_effective_start_date
28119: ,p_effective_end_date => l_effective_end_date
28120: ,p_object_version_number => l_object_version_number
28121: ,p_effective_date => l_max_eed
28122: ,p_datetrack_mode => hr_api.g_delete
28123: --
28124: );
28125: --
28126: end if;

Line 28246: l_datetrack_mode varchar2(80) := hr_api.g_update;

28242:
28243: --UPD START
28244: --
28245: l_update boolean := false ;
28246: l_datetrack_mode varchar2(80) := hr_api.g_update;
28247: l_process_date date;
28248: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
28249: --
28250: --UPD END

Line 28607: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

28603: end if;
28604: --
28605: -- Delete the row if it is end dated.
28606: --
28607: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
28608: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
28609: trunc(l_max_eed) = trunc(r_EQG.information3)) then
28610: --
28611: BEN_ELIG_QUA_IN_GR_PRTE_API.delete_ELIG_QUA_IN_GR_PRTE(

Line 28619: ,p_datetrack_mode => hr_api.g_delete

28615: ,p_effective_start_date => l_effective_start_date
28616: ,p_effective_end_date => l_effective_end_date
28617: ,p_object_version_number => l_object_version_number
28618: ,p_effective_date => l_max_eed
28619: ,p_datetrack_mode => hr_api.g_delete
28620: --
28621: );
28622: --
28623: end if;

Line 28742: l_datetrack_mode varchar2(80) := hr_api.g_update;

28738:
28739: --UPD START
28740: --
28741: l_update boolean := false ;
28742: l_datetrack_mode varchar2(80) := hr_api.g_update;
28743: l_process_date date;
28744: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
28745: --
28746: --UPD END

Line 29105: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

29101: end if;
29102: --
29103: -- Delete the row if it is end dated.
29104: --
29105: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
29106: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
29107: trunc(l_max_eed) = trunc(r_EGN.information3)) then
29108: --
29109: BEN_ELIG_GNDR_PRTE_API.delete_ELIG_GNDR_PRTE(

Line 29117: ,p_datetrack_mode => hr_api.g_delete

29113: ,p_effective_start_date => l_effective_start_date
29114: ,p_effective_end_date => l_effective_end_date
29115: ,p_object_version_number => l_object_version_number
29116: ,p_effective_date => l_max_eed
29117: ,p_datetrack_mode => hr_api.g_delete
29118: --
29119: );
29120: --
29121: end if;

Line 29237: l_datetrack_mode varchar2(80) := hr_api.g_update;

29233:
29234: --UPD START
29235: --
29236: l_update boolean := false ;
29237: l_datetrack_mode varchar2(80) := hr_api.g_update;
29238: l_process_date date;
29239: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
29240: --
29241: --UPD END

Line 29596: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

29592: end if;
29593: --
29594: -- Delete the row if it is end dated.
29595: --
29596: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
29597: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
29598: trunc(l_max_eed) = trunc(r_ETU.information3)) then
29599: --
29600: BEN_ELIG_TBCO_USE_PRTE_API.delete_ELIG_TBCO_USE_PRTE(

Line 29608: ,p_datetrack_mode => hr_api.g_delete

29604: ,p_effective_start_date => l_effective_start_date
29605: ,p_effective_end_date => l_effective_end_date
29606: ,p_object_version_number => l_object_version_number
29607: ,p_effective_date => l_max_eed
29608: ,p_datetrack_mode => hr_api.g_delete
29609: --
29610: );
29611: --
29612: end if;

Line 29728: l_datetrack_mode varchar2(80) := hr_api.g_update;

29724:
29725: --UPD START
29726: --
29727: l_update boolean := false ;
29728: l_datetrack_mode varchar2(80) := hr_api.g_update;
29729: l_process_date date;
29730: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
29731: --
29732: --UPD END

Line 30088: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

30084: end if;
30085: --
30086: -- Delete the row if it is end dated.
30087: --
30088: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
30089: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
30090: trunc(l_max_eed) = trunc(r_EDB.information3)) then
30091: --
30092: BEN_ELIG_DSBLD_PRTE_API.delete_ELIG_DSBLD_PRTE(

Line 30100: ,p_datetrack_mode => hr_api.g_delete

30096: ,p_effective_start_date => l_effective_start_date
30097: ,p_effective_end_date => l_effective_end_date
30098: ,p_object_version_number => l_object_version_number
30099: ,p_effective_date => l_max_eed
30100: ,p_datetrack_mode => hr_api.g_delete
30101: --
30102: );
30103: --
30104: end if;

Line 30240: l_datetrack_mode varchar2(80) := hr_api.g_update;

30236:
30237: --UPD START
30238: --
30239: l_update boolean := false ;
30240: l_datetrack_mode varchar2(80) := hr_api.g_update;
30241: l_process_date date;
30242: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
30243: --
30244: --UPD END

Line 30618: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

30614: end if;
30615: --
30616: -- Delete the row if it is end dated.
30617: --
30618: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
30619: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
30620: trunc(l_max_eed) = trunc(r_ETP.information3)) then
30621: --
30622: BEN_ELIG_TTL_PRTT_PRTE_API.delete_ELIG_TTL_PRTT_PRTE(

Line 30630: ,p_datetrack_mode => hr_api.g_delete

30626: ,p_effective_start_date => l_effective_start_date
30627: ,p_effective_end_date => l_effective_end_date
30628: ,p_object_version_number => l_object_version_number
30629: ,p_effective_date => l_max_eed
30630: ,p_datetrack_mode => hr_api.g_delete
30631: --
30632: );
30633: --
30634: end if;

Line 30770: l_datetrack_mode varchar2(80) := hr_api.g_update;

30766:
30767: --UPD START
30768: --
30769: l_update boolean := false ;
30770: l_datetrack_mode varchar2(80) := hr_api.g_update;
30771: l_process_date date;
30772: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
30773: --
30774: --UPD END

Line 31149: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

31145: end if;
31146: --
31147: -- Delete the row if it is end dated.
31148: --
31149: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
31150: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
31151: trunc(l_max_eed) = trunc(r_ETC.information3)) then
31152: --
31153: BEN_ELIG_TTL_CVG_VOL_PRTE_API.delete_ELIG_TTL_CVG_VOL_PRTE(

Line 31161: ,p_datetrack_mode => hr_api.g_delete

31157: ,p_effective_start_date => l_effective_start_date
31158: ,p_effective_end_date => l_effective_end_date
31159: ,p_object_version_number => l_object_version_number
31160: ,p_effective_date => l_max_eed
31161: ,p_datetrack_mode => hr_api.g_delete
31162: --
31163: );
31164: --
31165: end if;

Line 31283: l_datetrack_mode varchar2(80) := hr_api.g_update;

31279:
31280: --UPD START
31281: --
31282: l_update boolean := false ;
31283: l_datetrack_mode varchar2(80) := hr_api.g_update;
31284: l_process_date date;
31285: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
31286: --
31287: --UPD END

Line 31647: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

31643: end if;
31644: --
31645: -- Delete the row if it is end dated.
31646: --
31647: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
31648: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
31649: trunc(l_max_eed) = trunc(r_EHC.information3)) then
31650: --
31651: BEN_ELIG_HLTH_CVG_PRTE_API.delete_ELIG_HLTH_CVG_PRTE(

Line 31659: ,p_datetrack_mode => hr_api.g_delete

31655: ,p_effective_start_date => l_effective_start_date
31656: ,p_effective_end_date => l_effective_end_date
31657: ,p_object_version_number => l_object_version_number
31658: ,p_effective_date => l_max_eed
31659: ,p_datetrack_mode => hr_api.g_delete
31660: --
31661: );
31662: --
31663: end if;

Line 31777: l_datetrack_mode varchar2(80) := hr_api.g_update;

31773:
31774: --UPD START
31775: --
31776: l_update boolean := false ;
31777: l_datetrack_mode varchar2(80) := hr_api.g_update;
31778: l_process_date date;
31779: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
31780: --
31781: --UPD END

Line 32132: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and

32128: end if;
32129: --
32130: -- Delete the row if it is end dated.
32131: --
32132: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
32133: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
32134: trunc(l_max_eed) = trunc(r_EOP.information3)) then
32135: --
32136: BEN_ELIG_ANTHR_PL_PRTE_API.delete_ELIG_ANTHR_PL_PRTE(

Line 32144: ,p_datetrack_mode => hr_api.g_delete

32140: ,p_effective_start_date => l_effective_start_date
32141: ,p_effective_end_date => l_effective_end_date
32142: ,p_object_version_number => l_object_version_number
32143: ,p_effective_date => l_max_eed
32144: ,p_datetrack_mode => hr_api.g_delete
32145: --
32146: );
32147: --
32148: end if;

Line 32497: l_datetrack_mode VARCHAR2 (80) := hr_api.g_update;

32493: AND information1 = p_parent_pk_id;
32494: --
32495: l_dt_rec_found BOOLEAN;
32496: l_update BOOLEAN := FALSE;
32497: l_datetrack_mode VARCHAR2 (80) := hr_api.g_update;
32498: l_process_date DATE;
32499: l_dml_operation ben_copy_entity_results.dml_operation%TYPE;
32500: l_current_pk_id NUMBER := NULL;
32501: l_prev_pk_id NUMBER := NULL;

Line 32998: IF ( TRUNC (l_max_eed) <> TRUNC (hr_api.g_eot)

32994: --
32995: --
32996: -- Delete the row if it is end dated.
32997: --
32998: IF ( TRUNC (l_max_eed) <> TRUNC (hr_api.g_eot)
32999: AND TRUNC (l_max_eed) <> l_effective_end_date /* Bug 4302963 */
33000: AND TRUNC (l_max_eed) = TRUNC (r_ecv.information3)
33001: )
33002: THEN

Line 33012: p_datetrack_mode => hr_api.g_delete

33008: p_effective_start_date => l_effective_start_date,
33009: p_effective_end_date => l_effective_end_date,
33010: p_object_version_number => l_object_version_number,
33011: p_effective_date => l_max_eed,
33012: p_datetrack_mode => hr_api.g_delete
33013: );
33014: --
33015: END IF;
33016: --