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_FIVE dependencies on HR_API

Line 84: if p_effective_end_date <> hr_api.g_eot then

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;

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

Line 93: l_datetrack_mode := hr_api.g_correction ;

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

Line 99: l_datetrack_mode := hr_api.g_correction ;

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

Line 105: l_datetrack_mode := hr_api.g_update_override ;

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

Line 110: l_datetrack_mode := hr_api.g_update;

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;

Line 119: l_datetrack_mode := hr_api.g_correction ;

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;

Line 122: l_datetrack_mode := hr_api.g_update_change_insert ;

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

Line 128: l_datetrack_mode := hr_api.g_update;

124: end if;
125: --
126: else
127: --
128: l_datetrack_mode := hr_api.g_update;
129: l_update := false;
130: --
131: end if;
132: --

Line 137: l_datetrack_mode := hr_api.g_update;

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

Line 142: l_datetrack_mode := hr_api.g_correction ;

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

Line 148: l_datetrack_mode := hr_api.g_correction ;

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 ;

Line 151: l_datetrack_mode := hr_api.g_update ;

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

Line 158: l_datetrack_mode := hr_api.g_correction ;

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;

Line 161: l_datetrack_mode := hr_api.g_update ;

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

Line 167: l_datetrack_mode := hr_api.g_update;

163: end if;
164: --
165: else
166: --
167: l_datetrack_mode := hr_api.g_update;
168: l_update := false;
169: --
170: end if;
171: --

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

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

Line 728: --,P_DATETRACK_MODE => hr_api.g_update

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

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

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(

Line 752: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 1216: --,P_DATETRACK_MODE => hr_api.g_update

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

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

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(

Line 1241: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

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

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

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

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

Line 2978: --,P_DATETRACK_MODE => hr_api.g_update

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

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

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(

Line 3001: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 3493: --,P_DATETRACK_MODE => hr_api.g_update

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:

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

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(

Line 3515: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 3977: -- ,P_DATETRACK_MODE => hr_api.g_update

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

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

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(

Line 3999: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 4612: --,P_DATETRACK_MODE => hr_api.g_update

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

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

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(

Line 4634: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 5098: --,P_DATETRACK_MODE => hr_api.g_update

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

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

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(

Line 5122: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 5795: --,P_DATETRACK_MODE => hr_api.g_update

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:

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

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(

Line 5819: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 6406: --,P_DATETRACK_MODE => hr_api.g_update

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

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

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(

Line 6426: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 6883: --,P_DATETRACK_MODE => hr_api.g_update

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;

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

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(

Line 6904: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 7353: --,P_DATETRACK_MODE => hr_api.g_update

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;

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

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(

Line 7374: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 7822: --,P_DATETRACK_MODE => hr_api.g_update

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;

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

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(

Line 7843: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 8307: --,P_DATETRACK_MODE => hr_api.g_update

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;

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

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(

Line 8328: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 8787: --,P_DATETRACK_MODE => hr_api.g_update

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

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

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(

Line 8807: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 9310: --,P_DATETRACK_MODE => hr_api.g_update

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

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

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(

Line 9332: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 9799: --,P_DATETRACK_MODE => hr_api.g_update

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;

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

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(

Line 9820: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 10275: --,P_DATETRACK_MODE => hr_api.g_update

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

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

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(

Line 10295: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 10759: --,P_DATETRACK_MODE => hr_api.g_update

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;

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

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(

Line 10780: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 11248: --,P_DATETRACK_MODE => hr_api.g_update

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;

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

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(

Line 11269: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 11725: --,P_DATETRACK_MODE => hr_api.g_update

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;

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

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(

Line 11746: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 12208: --,P_DATETRACK_MODE => hr_api.g_update

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;

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

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(

Line 12229: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 12695: --,P_DATETRACK_MODE => hr_api.g_update

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;

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

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(

Line 12716: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 13161: --,P_DATETRACK_MODE => hr_api.g_update

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;

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

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(

Line 13182: ,p_datetrack_mode => hr_api.g_delete

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

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

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

Line 13646: --,P_DATETRACK_MODE => hr_api.g_update

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;

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

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(

Line 13667: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

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

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

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

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

Line 14915: --,P_DATETRACK_MODE => hr_api.g_update

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

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

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(

Line 14935: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 15396: --,P_DATETRACK_MODE => hr_api.g_update

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;

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

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(

Line 15417: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 15932: --,P_DATETRACK_MODE => hr_api.g_update

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;

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

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(

Line 15953: ,p_datetrack_mode => hr_api.g_delete

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;

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

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

Line 16401: --,P_DATETRACK_MODE => hr_api.g_update

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

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

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(

Line 16421: ,p_datetrack_mode => hr_api.g_delete

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;