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_TWO 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 305: l_datetrack_mode varchar2(80) := hr_api.g_update;

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

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

645: end if;
646: --
647: -- Delete the row if it is end dated.
648: --
649: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
650: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
651: trunc(l_max_eed) = r_PRB.information3) then
652: --
653: BEN_PLAN_REGULATORY_BODY_API.delete_PLAN_REGULATORY_BODY(

Line 661: ,p_datetrack_mode => hr_api.g_delete

657: ,p_effective_start_date => l_effective_start_date
658: ,p_effective_end_date => l_effective_end_date
659: ,p_object_version_number => l_object_version_number
660: ,p_effective_date => l_max_eed
661: ,p_datetrack_mode => hr_api.g_delete
662: --
663: );
664: --
665: end if;

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

780: --
781: --UPD START
782: --
783: l_update boolean := false ;
784: l_datetrack_mode varchar2(80) := hr_api.g_update;
785: l_process_date date;
786: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
787: --
788: --UPD END

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

1108: end if;
1109: --
1110: -- Delete the row if it is end dated.
1111: --
1112: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
1113: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
1114: trunc(l_max_eed) = r_SAZ.information3) then
1115: --
1116: BEN_SVC_AREA_PSTL_ZIP_RNG_API.delete_SVC_AREA_PSTL_ZIP_RNG(

Line 1124: ,p_datetrack_mode => hr_api.g_delete

1120: ,p_effective_start_date => l_effective_start_date
1121: ,p_effective_end_date => l_effective_end_date
1122: ,p_object_version_number => l_object_version_number
1123: ,p_effective_date => l_max_eed
1124: ,p_datetrack_mode => hr_api.g_delete
1125: --
1126: );
1127: --
1128: end if;

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

1244: --
1245: --UPD START
1246: --
1247: l_update boolean := false ;
1248: l_datetrack_mode varchar2(80) := hr_api.g_update;
1249: l_process_date date;
1250: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
1251: --
1252: --UPD END

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

1596: end if;
1597: --
1598: -- Delete the row if it is end dated.
1599: --
1600: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
1601: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
1602: trunc(l_max_eed) = r_PCX.information3) then
1603: --
1604: BEN_PLAN_BENEFICIARY_CTFN_API.delete_PLAN_BENEFICIARY_CTFN(

Line 1612: ,p_datetrack_mode => hr_api.g_delete

1608: ,p_effective_start_date => l_effective_start_date
1609: ,p_effective_end_date => l_effective_end_date
1610: ,p_object_version_number => l_object_version_number
1611: ,p_effective_date => l_max_eed
1612: ,p_datetrack_mode => hr_api.g_delete
1613: --
1614: );
1615: --
1616: end if;

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

1725: --
1726: --UPD START
1727: --
1728: l_update boolean := false ;
1729: l_datetrack_mode varchar2(80) := hr_api.g_update;
1730: l_process_date date;
1731: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
1732: --
1733: --UPD END

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

2070: end if;
2071: --
2072: -- Delete the row if it is end dated.
2073: --
2074: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
2075: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
2076: trunc(l_max_eed) = r_PND.information3) then
2077: --
2078: BEN_PLAN_DPNT_CVG_CTFN_API.delete_PLAN_DPNT_CVG_CTFN(

Line 2086: ,p_datetrack_mode => hr_api.g_delete

2082: ,p_effective_start_date => l_effective_start_date
2083: ,p_effective_end_date => l_effective_end_date
2084: ,p_object_version_number => l_object_version_number
2085: ,p_effective_date => l_max_eed
2086: ,p_datetrack_mode => hr_api.g_delete
2087: --
2088: );
2089: --
2090: end if;

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

2203: --
2204: --UPD START
2205: --
2206: l_update boolean := false ;
2207: l_datetrack_mode varchar2(80) := hr_api.g_update;
2208: l_process_date date;
2209: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
2210: --
2211: --UPD END

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

2558: end if;
2559: --
2560: -- Delete the row if it is end dated.
2561: --
2562: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
2563: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
2564: trunc(l_max_eed) = r_LPE.information3) then
2565: --
2566: BEN_LER_CHG_PL_NIP_ENRT_API.delete_LER_CHG_PL_NIP_ENRT(

Line 2574: ,p_datetrack_mode => hr_api.g_delete

2570: ,p_effective_start_date => l_effective_start_date
2571: ,p_effective_end_date => l_effective_end_date
2572: ,p_object_version_number => l_object_version_number
2573: ,p_effective_date => l_max_eed
2574: ,p_datetrack_mode => hr_api.g_delete
2575: --
2576: );
2577: --
2578: end if;

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

2691: --
2692: --UPD START
2693: --
2694: l_update boolean := false ;
2695: l_datetrack_mode varchar2(80) := hr_api.g_update;
2696: l_process_date date;
2697: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
2698: --
2699: --UPD END

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

3039: end if;
3040: --
3041: -- Delete the row if it is end dated.
3042: --
3043: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
3044: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
3045: trunc(l_max_eed) = r_LOP.information3) then
3046: --
3047: BEN_LER_CHG_OIPL_ENRT_API.delete_LER_CHG_OIPL_ENRT(

Line 3055: ,p_datetrack_mode => hr_api.g_delete

3051: ,p_effective_start_date => l_effective_start_date
3052: ,p_effective_end_date => l_effective_end_date
3053: ,p_object_version_number => l_object_version_number
3054: ,p_effective_date => l_max_eed
3055: ,p_datetrack_mode => hr_api.g_delete
3056: --
3057: );
3058: --
3059: end if;

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

3171: --
3172: --UPD START
3173: --
3174: l_update boolean := false ;
3175: l_datetrack_mode varchar2(80) := hr_api.g_update;
3176: l_process_date date;
3177: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
3178: --
3179: --UPD END

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

3514: end if;
3515: --
3516: -- Delete the row if it is end dated.
3517: --
3518: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
3519: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
3520: trunc(l_max_eed) = r_LNC.information3) then
3521: --
3522: BEN_LER_ENRT_CTFN_API.delete_LER_ENRT_CTFN(

Line 3530: ,p_datetrack_mode => hr_api.g_delete

3526: ,p_effective_start_date => l_effective_start_date
3527: ,p_effective_end_date => l_effective_end_date
3528: ,p_object_version_number => l_object_version_number
3529: ,p_effective_date => l_max_eed
3530: ,p_datetrack_mode => hr_api.g_delete
3531: --
3532: );
3533: --
3534: end if;

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

3649: --
3650: --UPD START
3651: --
3652: l_update boolean := false ;
3653: l_datetrack_mode varchar2(80) := hr_api.g_update;
3654: l_process_date date;
3655: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
3656: --
3657: --UPD END

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

4003: end if;
4004: --
4005: -- Delete the row if it is end dated.
4006: --
4007: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
4008: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
4009: trunc(l_max_eed) = r_LRE.information3) then
4010: --
4011: BEN_LER_RQRS_ENRT_CTFN_API.delete_LER_RQRS_ENRT_CTFN(

Line 4019: ,p_datetrack_mode => hr_api.g_delete

4015: ,p_effective_start_date => l_effective_start_date
4016: ,p_effective_end_date => l_effective_end_date
4017: ,p_object_version_number => l_object_version_number
4018: ,p_effective_date => l_max_eed
4019: ,p_datetrack_mode => hr_api.g_delete
4020: --
4021: );
4022: --
4023: end if;

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

4136: --
4137: --UPD START
4138: --
4139: l_update boolean := false ;
4140: l_datetrack_mode varchar2(80) := hr_api.g_update;
4141: l_process_date date;
4142: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
4143: --
4144: --UPD END

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

4477: end if;
4478: --
4479: -- Delete the row if it is end dated.
4480: --
4481: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
4482: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
4483: trunc(l_max_eed) = r_LBC.information3) then
4484: --
4485: BEN_LER_BNFT_RSTRN_CTFN_API.delete_LER_BNFT_RSTRN_CTFN(

Line 4493: ,p_datetrack_mode => hr_api.g_delete

4489: ,p_effective_start_date => l_effective_start_date
4490: ,p_effective_end_date => l_effective_end_date
4491: ,p_object_version_number => l_object_version_number
4492: ,p_effective_date => l_max_eed
4493: ,p_datetrack_mode => hr_api.g_delete
4494: --
4495: );
4496: --
4497: end if;

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

4610: --
4611: --UPD START
4612: --
4613: l_update boolean := false ;
4614: l_datetrack_mode varchar2(80) := hr_api.g_update;
4615: l_process_date date;
4616: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
4617: --
4618: --UPD END

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

4944: end if;
4945: --
4946: -- Delete the row if it is end dated.
4947: --
4948: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
4949: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
4950: trunc(l_max_eed) = r_BRC.information3) then
4951: --
4952: BEN_BNFT_RSTRN_CTFN_API.delete_BNFT_RSTRN_CTFN(

Line 4960: ,p_datetrack_mode => hr_api.g_delete

4956: ,p_effective_start_date => l_effective_start_date
4957: ,p_effective_end_date => l_effective_end_date
4958: ,p_object_version_number => l_object_version_number
4959: ,p_effective_date => l_max_eed
4960: ,p_datetrack_mode => hr_api.g_delete
4961: --
4962: );
4963: --
4964: end if;

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

5077: --
5078: --UPD START
5079: --
5080: l_update boolean := false ;
5081: l_datetrack_mode varchar2(80) := hr_api.g_update;
5082: l_process_date date;
5083: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
5084: --
5085: --UPD END

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

5423: end if;
5424: --
5425: -- Delete the row if it is end dated.
5426: --
5427: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
5428: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
5429: trunc(l_max_eed) = r_WCN.information3) then
5430: --
5431: BEN_WV_PRTN_RSN_CTFN_PL_API.delete_WV_PRTN_RSN_CTFN_PL(

Line 5439: ,p_datetrack_mode => hr_api.g_delete

5435: ,p_effective_start_date => l_effective_start_date
5436: ,p_effective_end_date => l_effective_end_date
5437: ,p_object_version_number => l_object_version_number
5438: ,p_effective_date => l_max_eed
5439: ,p_datetrack_mode => hr_api.g_delete
5440: --
5441: );
5442: --
5443: end if;

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

5555: --
5556: --UPD START
5557: --
5558: l_update boolean := false ;
5559: l_datetrack_mode varchar2(80) := hr_api.g_update;
5560: l_process_date date;
5561: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
5562: --
5563: --UPD END

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

5893: end if;
5894: --
5895: -- Delete the row if it is end dated.
5896: --
5897: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
5898: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
5899: trunc(l_max_eed) = r_WPN.information3) then
5900: --
5901: BEN_WV_PRTN_REASON_PL_API.delete_WV_PRTN_REASON_PL(

Line 5909: ,p_datetrack_mode => hr_api.g_delete

5905: ,p_effective_start_date => l_effective_start_date
5906: ,p_effective_end_date => l_effective_end_date
5907: ,p_object_version_number => l_object_version_number
5908: ,p_effective_date => l_max_eed
5909: ,p_datetrack_mode => hr_api.g_delete
5910: --
5911: );
5912: --
5913: end if;

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

6024: --
6025: --UPD START
6026: --
6027: l_update boolean := false ;
6028: l_datetrack_mode varchar2(80) := hr_api.g_update;
6029: l_process_date date;
6030: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6031: --
6032: --UPD END

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

6359: end if;
6360: --
6361: -- Delete the row if it is end dated.
6362: --
6363: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
6364: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
6365: trunc(l_max_eed) = r_VRP.information3) then
6366: --
6367: BEN_VALD_RLSHP_FOR_REIMB_API.delete_VALD_RLSHP_FOR_REIMB(

Line 6375: ,p_datetrack_mode => hr_api.g_delete

6371: ,p_effective_start_date => l_effective_start_date
6372: ,p_effective_end_date => l_effective_end_date
6373: ,p_object_version_number => l_object_version_number
6374: ,p_effective_date => l_max_eed
6375: ,p_datetrack_mode => hr_api.g_delete
6376: --
6377: );
6378: --
6379: end if;

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

6493: --
6494: --UPD START
6495: --
6496: l_update boolean := false ;
6497: l_datetrack_mode varchar2(80) := hr_api.g_update;
6498: l_process_date date;
6499: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6500: --
6501: --UPD END

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

6840: end if;
6841: --
6842: -- Delete the row if it is end dated.
6843: --
6844: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
6845: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
6846: trunc(l_max_eed) = r_PCT.information3) then
6847: --
6848: BEN_PLAN_GOODS_SERV_CERT_API.delete_PLAN_GOODS_SERV_CERT(

Line 6856: ,p_datetrack_mode => hr_api.g_delete

6852: ,p_effective_start_date => l_effective_start_date
6853: ,p_effective_end_date => l_effective_end_date
6854: ,p_object_version_number => l_object_version_number
6855: ,p_effective_date => l_max_eed
6856: ,p_datetrack_mode => hr_api.g_delete
6857: --
6858: );
6859: --
6860: end if;

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

6971: --
6972: --UPD START
6973: --
6974: l_update boolean := false ;
6975: l_datetrack_mode varchar2(80) := hr_api.g_update;
6976: l_process_date date;
6977: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6978: --
6979: --UPD END

Line 7312: ,P_DATETRACK_MODE => hr_api.g_update

7308: --
7309: ,P_EFFECTIVE_START_DATE => l_effective_start_date
7310: ,P_EFFECTIVE_END_DATE => l_effective_end_date
7311: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
7312: ,P_DATETRACK_MODE => hr_api.g_update
7313: );
7314: --
7315: end if;
7316: --

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

7315: end if;
7316: --
7317: -- Delete the row if it is end dated.
7318: --
7319: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
7320: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
7321: trunc(l_max_eed) = r_VGS.information3) then
7322: --
7323: BEN_PLAN_GOODS_SERVICES_API.delete_PLAN_GOODS_SERVICES(

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

7454: --
7455: --UPD START
7456: --
7457: l_update boolean := false ;
7458: l_datetrack_mode varchar2(80) := hr_api.g_update;
7459: l_process_date date;
7460: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
7461: --
7462: --UPD END

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

7837: end if;
7838: --
7839: -- Delete the row if it is end dated.
7840: --
7841: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
7842: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
7843: trunc(l_max_eed) = r_LBR.information3) then
7844: --
7845: BEN_LER_BNFT_RSTRN_API.delete_LER_BNFT_RSTRN(

Line 7853: ,p_datetrack_mode => hr_api.g_delete

7849: ,p_effective_start_date => l_effective_start_date
7850: ,p_effective_end_date => l_effective_end_date
7851: ,p_object_version_number => l_object_version_number
7852: ,p_effective_date => l_max_eed
7853: ,p_datetrack_mode => hr_api.g_delete
7854: --
7855: );
7856: --
7857:

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

7972: --
7973: --UPD START
7974: --
7975: l_update boolean := false ;
7976: l_datetrack_mode varchar2(80) := hr_api.g_update;
7977: l_process_date date;
7978: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
7979: --
7980: --UPD END

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

8329: end if;
8330: --
8331: -- Delete the row if it is end dated.
8332: --
8333: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
8334: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
8335: trunc(l_max_eed) = r_LPR1.information3) then
8336: --
8337: BEN_LER_CHG_PLAN_ENRT_API.delete_LER_CHG_PLAN_ENRT(

Line 8345: ,p_datetrack_mode => hr_api.g_delete

8341: ,p_effective_start_date => l_effective_start_date
8342: ,p_effective_end_date => l_effective_end_date
8343: ,p_object_version_number => l_object_version_number
8344: ,p_effective_date => l_max_eed
8345: ,p_datetrack_mode => hr_api.g_delete
8346: --
8347: );
8348: --
8349: end if;

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

8477: --
8478: --UPD START
8479: --
8480: l_update boolean := false ;
8481: l_datetrack_mode varchar2(80) := hr_api.g_update;
8482: l_process_date date;
8483: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
8484: --
8485: --UPD END

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

8933: end if;
8934: --
8935: -- Delete the row if it is end dated.
8936: --
8937: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
8938: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
8939: trunc(l_max_eed) = r_CPP.information3) then
8940: --
8941: BEN_PLAN_IN_PROGRAM_API.delete_PLAN_IN_PROGRAM(

Line 8949: ,p_datetrack_mode => hr_api.g_delete

8945: ,p_effective_start_date => l_effective_start_date
8946: ,p_effective_end_date => l_effective_end_date
8947: ,p_object_version_number => l_object_version_number
8948: ,p_effective_date => l_max_eed
8949: ,p_datetrack_mode => hr_api.g_delete
8950: --
8951: );
8952: --
8953: end if;

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

9070: --
9071: --UPD START
9072: --
9073: l_update boolean := false ;
9074: l_datetrack_mode varchar2(80) := hr_api.g_update;
9075: l_process_date date;
9076: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
9077: --
9078: --UPD END

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

9419: end if;
9420: --
9421: -- Delete the row if it is end dated.
9422: --
9423: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
9424: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
9425: trunc(l_max_eed) = r_PYD.information3) then
9426: --
9427: BEN_PTIP_DPNT_CVG_CTFN_API.delete_PTIP_DPNT_CVG_CTFN(

Line 9435: ,p_datetrack_mode => hr_api.g_delete

9431: ,p_effective_start_date => l_effective_start_date
9432: ,p_effective_end_date => l_effective_end_date
9433: ,p_object_version_number => l_object_version_number
9434: ,p_effective_date => l_max_eed
9435: ,p_datetrack_mode => hr_api.g_delete
9436: --
9437: );
9438: --
9439: end if;

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

9552: --
9553: --UPD START
9554: --
9555: l_update boolean := false ;
9556: l_datetrack_mode varchar2(80) := hr_api.g_update;
9557: l_process_date date;
9558: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
9559: --
9560: --UPD END

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

9915: end if;
9916: --
9917: -- Delete the row if it is end dated.
9918: --
9919: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
9920: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
9921: trunc(l_max_eed) = r_LCT.information3) then
9922: --
9923: BEN_LER_CHG_PTIP_ENRT_API.delete_LER_CHG_PTIP_ENRT(

Line 9931: ,p_datetrack_mode => hr_api.g_delete

9927: ,p_effective_start_date => l_effective_start_date
9928: ,p_effective_end_date => l_effective_end_date
9929: ,p_object_version_number => l_object_version_number
9930: ,p_effective_date => l_max_eed
9931: ,p_datetrack_mode => hr_api.g_delete
9932: --
9933: );
9934: --
9935: end if;

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

10047: --
10048: --UPD START
10049: --
10050: l_update boolean := false ;
10051: l_datetrack_mode varchar2(80) := hr_api.g_update;
10052: l_process_date date;
10053: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
10054: --
10055: --UPD END

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

10393: end if;
10394: --
10395: -- Delete the row if it is end dated.
10396: --
10397: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
10398: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
10399: trunc(l_max_eed) = r_WCT.information3) then
10400: --
10401: BEN_WV_PRTN_RSN_CTFN_PTIP_API.delete_WV_PRTN_RSN_CTFN_PTIP(

Line 10409: ,p_datetrack_mode => hr_api.g_delete

10405: ,p_effective_start_date => l_effective_start_date
10406: ,p_effective_end_date => l_effective_end_date
10407: ,p_object_version_number => l_object_version_number
10408: ,p_effective_date => l_max_eed
10409: ,p_datetrack_mode => hr_api.g_delete
10410: --
10411: );
10412: --
10413: end if;

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

10525: --
10526: --UPD START
10527: --
10528: l_update boolean := false ;
10529: l_datetrack_mode varchar2(80) := hr_api.g_update;
10530: l_process_date date;
10531: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
10532: --
10533: --UPD END

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

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

Line 10879: ,p_datetrack_mode => hr_api.g_delete

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

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

11018: --
11019: --UPD START
11020: --
11021: l_update boolean := false ;
11022: l_datetrack_mode varchar2(80) := hr_api.g_update;
11023: l_process_date date;
11024: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
11025: --
11026: --UPD END

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

11521: end if;
11522: --
11523: -- Delete the row if it is end dated.
11524: --
11525: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
11526: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
11527: trunc(l_max_eed) = r_CTP.information3) then
11528: --
11529: BEN_PLAN_TYPE_IN_PROGRAM_API.delete_PLAN_TYPE_IN_PROGRAM(

Line 11537: ,p_datetrack_mode => hr_api.g_delete

11533: ,p_effective_start_date => l_effective_start_date
11534: ,p_effective_end_date => l_effective_end_date
11535: ,p_object_version_number => l_object_version_number
11536: ,p_effective_date => l_max_eed
11537: ,p_datetrack_mode => hr_api.g_delete
11538: --
11539: );
11540: --
11541: end if;

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

11654: --
11655: --UPD START
11656: --
11657: l_update boolean := false ;
11658: l_datetrack_mode varchar2(80) := hr_api.g_update;
11659: l_process_date date;
11660: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
11661: --
11662: --UPD END

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

11999: end if;
12000: --
12001: -- Delete the row if it is end dated.
12002: --
12003: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
12004: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
12005: trunc(l_max_eed) = r_LCC.information3) then
12006: --
12007: BEN_LER_CHG_DPNT_CVG_CTF_API.delete_LER_CHG_DPNT_CVG_CTF(

Line 12015: ,p_datetrack_mode => hr_api.g_delete

12011: ,p_effective_start_date => l_effective_start_date
12012: ,p_effective_end_date => l_effective_end_date
12013: ,p_object_version_number => l_object_version_number
12014: ,p_effective_date => l_max_eed
12015: ,p_datetrack_mode => hr_api.g_delete
12016: --
12017: );
12018: --
12019: end if;

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

12130: --
12131: --UPD START
12132: --
12133: l_update boolean := false ;
12134: l_datetrack_mode varchar2(80) := hr_api.g_update;
12135: l_process_date date;
12136: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
12137: --
12138: --UPD END

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

12471: end if;
12472: --
12473: -- Delete the row if it is end dated.
12474: --
12475: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
12476: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
12477: trunc(l_max_eed) = r_cer.information3) then
12478: --
12479: BEN_ELIGIBILITY_RULE_API.delete_ELIGIBILITY_RULE(

Line 12487: ,p_datetrack_mode => hr_api.g_delete

12483: ,p_effective_start_date => l_effective_start_date
12484: ,p_effective_end_date => l_effective_end_date
12485: ,p_object_version_number => l_object_version_number
12486: ,p_effective_date => l_max_eed
12487: ,p_datetrack_mode => hr_api.g_delete
12488: --
12489: );
12490: --
12491: end if;

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

12602: --
12603: --UPD START
12604: --
12605: l_update boolean := false ;
12606: l_datetrack_mode varchar2(80) := hr_api.g_update;
12607: l_process_date date;
12608: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
12609: --
12610: --UPD END

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

12941: end if;
12942: --
12943: -- Delete the row if it is end dated.
12944: --
12945: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
12946: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
12947: trunc(l_max_eed) = r_CEP.information3) then
12948: --
12949: BEN_PRTN_ELIG_PRFL_API.delete_PRTN_ELIG_PRFL(

Line 12957: ,p_datetrack_mode => hr_api.g_delete

12953: ,p_effective_start_date => l_effective_start_date
12954: ,p_effective_end_date => l_effective_end_date
12955: ,p_object_version_number => l_object_version_number
12956: ,p_effective_date => l_max_eed
12957: ,p_datetrack_mode => hr_api.g_delete
12958: --
12959: );
12960: --
12961: end if;

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

13077: --
13078: --UPD START
13079: --
13080: l_update boolean := false ;
13081: l_datetrack_mode varchar2(80) := hr_api.g_update;
13082: l_process_date date;
13083: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13084: --
13085: --UPD END

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

13419: end if;
13420: --
13421: -- Delete the row if it is end dated.
13422: --
13423: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
13424: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
13425: trunc(l_max_eed) = r_CPR.information3) then
13426: --
13427: BEN_POPL_ORG_ROLE_API.delete_POPL_ORG_ROLE(

Line 13435: ,p_datetrack_mode => hr_api.g_delete

13431: ,p_effective_start_date => l_effective_start_date
13432: ,p_effective_end_date => l_effective_end_date
13433: ,p_object_version_number => l_object_version_number
13434: ,p_effective_date => l_max_eed
13435: ,p_datetrack_mode => hr_api.g_delete
13436: --
13437: );
13438: --
13439: end if;

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

13557: --
13558: --UPD START
13559: --
13560: l_update boolean := false ;
13561: l_datetrack_mode varchar2(80) := hr_api.g_update;
13562: l_process_date date;
13563: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13564: --
13565: --UPD END

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

13934: end if;
13935: --
13936: -- Delete the row if it is end dated.
13937: --
13938: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
13939: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
13940: trunc(l_max_eed) = r_CPO.information3) then
13941: --
13942: BEN_POPL_ORG_API.delete_POPL_ORG(

Line 13950: ,p_datetrack_mode => hr_api.g_delete

13946: ,p_effective_start_date => l_effective_start_date
13947: ,p_effective_end_date => l_effective_end_date
13948: ,p_object_version_number => l_object_version_number
13949: ,p_effective_date => l_max_eed
13950: ,p_datetrack_mode => hr_api.g_delete
13951: --
13952: );
13953: --
13954: end if;

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

14087: --
14088: --UPD START
14089: --
14090: l_update boolean := false ;
14091: l_datetrack_mode varchar2(80) := hr_api.g_update;
14092: l_process_date date;
14093: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
14094: --
14095: --UPD END

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

14467: end if;
14468: --
14469: -- Delete the row if it is end dated.
14470: --
14471: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
14472: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
14473: trunc(l_max_eed) = r_PRG.information3) then
14474: --
14475: BEN_PLAN_REGULATION_API.delete_PLAN_REGULATION(

Line 14483: ,p_datetrack_mode => hr_api.g_delete

14479: ,p_effective_start_date => l_effective_start_date
14480: ,p_effective_end_date => l_effective_end_date
14481: ,p_object_version_number => l_object_version_number
14482: ,p_effective_date => l_max_eed
14483: ,p_datetrack_mode => hr_api.g_delete
14484: --
14485: );
14486: --
14487: end if;

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

14603: --
14604: --UPD START
14605: --
14606: l_update boolean := false ;
14607: l_datetrack_mode varchar2(80) := hr_api.g_update;
14608: l_process_date date;
14609: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
14610: --
14611: --UPD END

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

14947: end if;
14948: --
14949: -- Delete the row if it is end dated.
14950: --
14951: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
14952: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
14953: trunc(l_max_eed) = r_RGR.information3) then
14954: --
14955: BEN_POPL_RPTG_GRP_API.delete_POPL_RPTG_GRP(

Line 14963: ,p_datetrack_mode => hr_api.g_delete

14959: ,p_effective_start_date => l_effective_start_date
14960: ,p_effective_end_date => l_effective_end_date
14961: ,p_object_version_number => l_object_version_number
14962: ,p_effective_date => l_max_eed
14963: ,p_datetrack_mode => hr_api.g_delete
14964: --
14965: );
14966: --
14967: end if;

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

15085: --
15086: --UPD START
15087: --
15088: l_update boolean := false ;
15089: l_datetrack_mode varchar2(80) := hr_api.g_update;
15090: l_process_date date;
15091: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
15092: --
15093: --UPD END

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

15427: end if;
15428: --
15429: -- Delete the row if it is end dated.
15430: --
15431: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
15432: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
15433: trunc(l_max_eed) = r_ECF.information3) then
15434: --
15435: BEN_ENRT_CTFN_API.delete_ENRT_CTFN(

Line 15443: ,p_datetrack_mode => hr_api.g_delete

15439: ,p_effective_start_date => l_effective_start_date
15440: ,p_effective_end_date => l_effective_end_date
15441: ,p_object_version_number => l_object_version_number
15442: ,p_effective_date => l_max_eed
15443: ,p_datetrack_mode => hr_api.g_delete
15444: --
15445: );
15446: --
15447: end if;

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

15576: --
15577: --UPD START
15578: --
15579: l_update boolean := false ;
15580: l_datetrack_mode varchar2(80) := hr_api.g_update;
15581: l_process_date date;
15582: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
15583: --
15584: --UPD END

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

15955: end if;
15956: --
15957: -- Delete the row if it is end dated.
15958: --
15959: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
15960: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
15961: trunc(l_max_eed) = r_EPA.information3) then
15962: --
15963: BEN_PARTICIPATION_ELIG_API.delete_PARTICIPATION_ELIG(

Line 15971: ,p_datetrack_mode => hr_api.g_delete

15967: ,p_effective_start_date => l_effective_start_date
15968: ,p_effective_end_date => l_effective_end_date
15969: ,p_object_version_number => l_object_version_number
15970: ,p_effective_date => l_max_eed
15971: ,p_datetrack_mode => hr_api.g_delete
15972: --
15973: );
15974: --
15975: end if;

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

16114: --
16115: --UPD START
16116: --
16117: l_update boolean := false ;
16118: l_datetrack_mode varchar2(80) := hr_api.g_update;
16119: l_process_date date;
16120: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
16121: --
16122: --UPD END

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

16522: --
16523: --UPD START
16524: --
16525: l_update boolean := false ;
16526: l_datetrack_mode varchar2(80) := hr_api.g_update;
16527: l_process_date date;
16528: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
16529: --
16530: --UPD END

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

16856: end if;
16857: --
16858: -- Delete the row if it is end dated.
16859: --
16860: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
16861: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
16862: trunc(l_max_eed) = r_PET.information3) then
16863: --
16864: BEN_POPL_ENRT_TYP_CYCL_API.delete_POPL_ENRT_TYP_CYCL(

Line 16872: ,p_datetrack_mode => hr_api.g_delete

16868: ,p_effective_start_date => l_effective_start_date
16869: ,p_effective_end_date => l_effective_end_date
16870: ,p_object_version_number => l_object_version_number
16871: ,p_effective_date => l_max_eed
16872: ,p_datetrack_mode => hr_api.g_delete
16873: --
16874: );
16875: --
16876: end if;

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

16972: --
16973: --UPD START
16974: --
16975: l_update boolean := false ;
16976: l_datetrack_mode varchar2(80) := hr_api.g_update;
16977: l_process_date date;
16978: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
16979: --
16980: --UPD END

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

17455: --
17456: --UPD START
17457: --
17458: l_update boolean := false ;
17459: l_datetrack_mode varchar2(80) := hr_api.g_update;
17460: l_process_date date;
17461: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
17462: --
17463: --UPD END

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

17842: end if;
17843: --
17844: -- Delete the row if it is end dated.
17845: --
17846: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
17847: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
17848: trunc(l_max_eed) = r_LEN.information3) then
17849: --
17850: BEN_LIFE_EVENT_ENROLL_RSN_API.delete_LIFE_EVENT_ENROLL_RSN(

Line 17858: ,p_datetrack_mode => hr_api.g_delete

17854: ,p_effective_start_date => l_effective_start_date
17855: ,p_effective_end_date => l_effective_end_date
17856: ,p_object_version_number => l_object_version_number
17857: ,p_effective_date => l_max_eed
17858: ,p_datetrack_mode => hr_api.g_delete
17859: --
17860: );
17861: --
17862: end if;

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

17980: --
17981: --UPD START
17982: --
17983: l_update boolean := false ;
17984: l_datetrack_mode varchar2(80) := hr_api.g_update;
17985: l_process_date date;
17986: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
17987: --
17988: --UPD END

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

18340: end if;
18341: --
18342: -- Delete the row if it is end dated.
18343: --
18344: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
18345: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
18346: trunc(l_max_eed) = r_ERP.information3) then
18347: --
18348: BEN_ENRT_PERD_FOR_PL_API.delete_ENRT_PERD_FOR_PL(

Line 18356: ,p_datetrack_mode => hr_api.g_delete

18352: ,p_effective_start_date => l_effective_start_date
18353: ,p_effective_end_date => l_effective_end_date
18354: ,p_object_version_number => l_object_version_number
18355: ,p_effective_date => l_max_eed
18356: ,p_datetrack_mode => hr_api.g_delete
18357: --
18358: );
18359: --
18360: end if;

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

18468: --
18469: --UPD START
18470: --
18471: l_update boolean := false ;
18472: l_datetrack_mode varchar2(80) := hr_api.g_update;
18473: l_process_date date;
18474: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
18475: --
18476: --UPD END

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

18804: end if;
18805: --
18806: -- Delete the row if it is end dated.
18807: --
18808: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
18809: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
18810: trunc(l_max_eed) = r_SER.information3) then
18811: --
18812: BEN_SCHEDD_ENROLLMENT_RL_API.delete_SCHEDD_ENROLLMENT_RL(

Line 18820: ,p_datetrack_mode => hr_api.g_delete

18816: ,p_effective_start_date => l_effective_start_date
18817: ,p_effective_end_date => l_effective_end_date
18818: ,p_object_version_number => l_object_version_number
18819: ,p_effective_date => l_max_eed
18820: ,p_datetrack_mode => hr_api.g_delete
18821: --
18822: );
18823: --
18824: end if;

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

18931: --
18932: --UPD START
18933: --
18934: l_update boolean := false ;
18935: l_datetrack_mode varchar2(80) := hr_api.g_update;
18936: l_process_date date;
18937: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
18938: --
18939: --UPD END

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

19267: end if;
19268: --
19269: -- Delete the row if it is end dated.
19270: --
19271: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
19272: trunc(l_max_eed) = r_LRR.information3) then
19273: --
19274: BEN_LEE_RSN_RL_API.delete_LEE_RSN_RL(
19275: --

Line 19282: ,p_datetrack_mode => hr_api.g_delete

19278: ,p_effective_start_date => l_effective_start_date
19279: ,p_effective_end_date => l_effective_end_date
19280: ,p_object_version_number => l_object_version_number
19281: ,p_effective_date => l_max_eed
19282: ,p_datetrack_mode => hr_api.g_delete
19283: --
19284: );
19285: --
19286: end if;

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

19402: --
19403: --UPD START
19404: --
19405: l_update boolean := false ;
19406: l_datetrack_mode varchar2(80) := hr_api.g_update;
19407: l_process_date date;
19408: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
19409: --
19410: --UPD END

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

19747: end if;
19748: --
19749: -- Delete the row if it is end dated.
19750: --
19751: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
19752: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
19753: trunc(l_max_eed) = r_ADE.information3) then
19754: --
19755: BEN_APLD_DPNT_CVG_PRFL_API.delete_APLD_DPNT_CVG_PRFL(

Line 19763: ,p_datetrack_mode => hr_api.g_delete

19759: ,p_effective_start_date => l_effective_start_date
19760: ,p_effective_end_date => l_effective_end_date
19761: ,p_object_version_number => l_object_version_number
19762: ,p_effective_date => l_max_eed
19763: ,p_datetrack_mode => hr_api.g_delete
19764: --
19765: );
19766: --
19767: end if;

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

19876: --
19877: --UPD START
19878: --
19879: l_update boolean := false ;
19880: l_datetrack_mode varchar2(80) := hr_api.g_update;
19881: l_process_date date;
19882: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
19883: --
19884: --UPD END

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

20221: end if;
20222: --
20223: -- Delete the row if it is end dated.
20224: --
20225: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
20226: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
20227: trunc(l_max_eed) = r_PGC.information3) then
20228: --
20229: BEN_PROGRAM_DPNT_CVG_CTFN_API.delete_PROGRAM_DPNT_CVG_CTFN(

Line 20237: ,p_datetrack_mode => hr_api.g_delete

20233: ,p_effective_start_date => l_effective_start_date
20234: ,p_effective_end_date => l_effective_end_date
20235: ,p_object_version_number => l_object_version_number
20236: ,p_effective_date => l_max_eed
20237: ,p_datetrack_mode => hr_api.g_delete
20238: --
20239: );
20240: --
20241: end if;

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

20351: --
20352: --UPD START
20353: --
20354: l_update boolean := false ;
20355: l_datetrack_mode varchar2(80) := hr_api.g_update;
20356: l_process_date date;
20357: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
20358: --
20359: --UPD END

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

20706: end if;
20707: --
20708: -- Delete the row if it is end dated.
20709: --
20710: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
20711: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
20712: trunc(l_max_eed) = r_LGE.information3) then
20713: --
20714: BEN_LER_CHG_PGM_ENRT_API.delete_LER_CHG_PGM_ENRT(

Line 20722: ,p_datetrack_mode => hr_api.g_delete

20718: ,p_effective_start_date => l_effective_start_date
20719: ,p_effective_end_date => l_effective_end_date
20720: ,p_object_version_number => l_object_version_number
20721: ,p_effective_date => l_max_eed
20722: ,p_datetrack_mode => hr_api.g_delete
20723: --
20724: );
20725: --
20726: end if;

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

20845: --
20846: --UPD START
20847: --
20848: l_update boolean := false ;
20849: l_datetrack_mode varchar2(80) := hr_api.g_update;
20850: l_process_date date;
20851: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
20852: --
20853: --UPD END

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

21209: end if;
21210: --
21211: -- Delete the row if it is end dated.
21212: --
21213: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
21214: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
21215: trunc(l_max_eed) = r_LDC.information3) then
21216: --
21217: BEN_LER_CHG_DEPENDENT_CVG_API.delete_LER_CHG_DEPENDENT_CVG(

Line 21225: ,p_datetrack_mode => hr_api.g_delete

21221: ,p_effective_start_date => l_effective_start_date
21222: ,p_effective_end_date => l_effective_end_date
21223: ,p_object_version_number => l_object_version_number
21224: ,p_effective_date => l_max_eed
21225: ,p_datetrack_mode => hr_api.g_delete
21226: --
21227: );
21228: --
21229: end if;

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

21337: --
21338: --UPD START
21339: --
21340: l_update boolean := false ;
21341: l_datetrack_mode varchar2(80) := hr_api.g_update;
21342: l_process_date date;
21343: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
21344: --
21345: --UPD END

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

21688: end if;
21689: --
21690: -- Delete the row if it is end dated.
21691: --
21692: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
21693: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
21694: trunc(l_max_eed) = r_PAT.information3) then
21695: --
21696: BEN_POPL_ACTION_TYPE_API.delete_POPL_ACTION_TYPE(

Line 21704: ,p_datetrack_mode => hr_api.g_delete

21700: ,p_effective_start_date => l_effective_start_date
21701: ,p_effective_end_date => l_effective_end_date
21702: ,p_object_version_number => l_object_version_number
21703: ,p_effective_date => l_max_eed
21704: ,p_datetrack_mode => hr_api.g_delete
21705: --
21706: );
21707: --
21708: end if;

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

21840: --
21841: --UPD START
21842: --
21843: l_update boolean := false ;
21844: l_datetrack_mode varchar2(80) := hr_api.g_update;
21845: l_process_date date;
21846: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
21847: --
21848: --UPD END

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

22241: end if;
22242: --
22243: -- Delete the row if it is end dated.
22244: --
22245: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
22246: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
22247: trunc(l_max_eed) = r_PEO.information3) then
22248: --
22249: BEN_ELIG_TO_PRTE_REASON_API.delete_ELIG_TO_PRTE_REASON(

Line 22257: ,p_datetrack_mode => hr_api.g_delete

22253: ,p_effective_start_date => l_effective_start_date
22254: ,p_effective_end_date => l_effective_end_date
22255: ,p_object_version_number => l_object_version_number
22256: ,p_effective_date => l_max_eed
22257: ,p_datetrack_mode => hr_api.g_delete
22258: --
22259: );
22260: --
22261: end if;

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

22347: --
22348: --UPD START
22349: --
22350: l_update boolean := false ;
22351: l_datetrack_mode varchar2(80) := hr_api.g_update;
22352: l_process_date date;
22353: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
22354: --
22355: --UPD END

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

22899: --
22900: --UPD START
22901: --
22902: l_update boolean := false ;
22903: l_datetrack_mode varchar2(80) := hr_api.g_update;
22904: l_process_date date;
22905: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
22906: --
22907: --UPD END

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

23321: --
23322: --UPD START
23323: --
23324: l_update boolean := false ;
23325: l_datetrack_mode varchar2(80) := hr_api.g_update;
23326: l_process_date date;
23327: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
23328: --
23329: --UPD END

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

23735: end if;
23736: --
23737: -- Delete the row if it is end dated.
23738: --
23739: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
23740: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
23741: trunc(l_max_eed) = r_COP.information3) then
23742: --
23743: BEN_OPTION_IN_PLAN_API.delete_OPTION_IN_PLAN(

Line 23751: ,p_datetrack_mode => hr_api.g_delete

23747: ,p_effective_start_date => l_effective_start_date
23748: ,p_effective_end_date => l_effective_end_date
23749: ,p_object_version_number => l_object_version_number
23750: ,p_effective_date => l_max_eed
23751: ,p_datetrack_mode => hr_api.g_delete
23752: --
23753: );
23754: --
23755: end if;

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

23875: --
23876: --UPD START
23877: --
23878: l_update boolean := false ;
23879: l_datetrack_mode varchar2(80) := hr_api.g_update;
23880: l_process_date date;
23881: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
23882: --
23883: --UPD END

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

24230: end if;
24231: --
24232: -- Delete the row if it is end dated.
24233: --
24234: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
24235: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
24236: trunc(l_max_eed) = r_DDR.information3) then
24237: --
24238: BEN_DESIGN_RQMT_API.delete_DESIGN_RQMT(

Line 24246: ,p_datetrack_mode => hr_api.g_delete

24242: ,p_effective_start_date => l_effective_start_date
24243: ,p_effective_end_date => l_effective_end_date
24244: ,p_object_version_number => l_object_version_number
24245: ,p_effective_date => l_max_eed
24246: ,p_datetrack_mode => hr_api.g_delete
24247: --
24248: );
24249: --
24250: end if;

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

24336: --
24337: --UPD START
24338: --
24339: l_update boolean := false ;
24340: l_datetrack_mode varchar2(80) := hr_api.g_update;
24341: l_process_date date;
24342: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
24343: --
24344: --UPD END

Line 24965: ,P_DATETRACK_MODE => hr_api.g_update

24961: --
24962: ,P_EFFECTIVE_START_DATE => l_effective_start_date
24963: ,P_EFFECTIVE_END_DATE => l_effective_end_date
24964: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
24965: ,P_DATETRACK_MODE => hr_api.g_update
24966: );
24967: --
24968: end if;
24969: --

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

24968: end if;
24969: --
24970: -- Delete the row if it is end dated.
24971: --
24972: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
24973: trunc(l_max_eed) = r_OPP.information3) then
24974: --
24975: BEN_OPTION_IN_PLAN_IN_PGM_API.delete_OPTION_IN_PLAN_IN_PGM(
24976: --

Line 24983: ,p_datetrack_mode => hr_api.g_delete

24979: ,p_effective_start_date => l_effective_start_date
24980: ,p_effective_end_date => l_effective_end_date
24981: ,p_object_version_number => l_object_version_number
24982: ,p_effective_date => l_max_eed
24983: ,p_datetrack_mode => hr_api.g_delete
24984: --
24985: );
24986: --
24987: end if;

Line 25367: ,P_DATETRACK_MODE => hr_api.g_update

25363: --
25364: ,P_EFFECTIVE_START_DATE => l_effective_start_date
25365: ,P_EFFECTIVE_END_DATE => l_effective_end_date
25366: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
25367: ,P_DATETRACK_MODE => hr_api.g_update
25368: );
25369: --
25370: end if;
25371: --

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

25370: end if;
25371: --
25372: -- Delete the row if it is end dated.
25373: --
25374: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
25375: trunc(l_max_eed) = r_OTP.information3) then
25376: --
25377: BEN_OPT_PLTYP_IN_PGM_API.delete_OPT_PLTYP_IN_PGM(
25378: --

Line 25385: ,p_datetrack_mode => hr_api.g_delete

25381: ,p_effective_start_date => l_effective_start_date
25382: ,p_effective_end_date => l_effective_end_date
25383: ,p_object_version_number => l_object_version_number
25384: ,p_effective_date => l_max_eed
25385: ,p_datetrack_mode => hr_api.g_delete
25386: --
25387: );
25388: --
25389: end if;

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

25490: --
25491: --UPD START
25492: --
25493: l_update boolean := false ;
25494: l_datetrack_mode varchar2(80) := hr_api.g_update;
25495: l_process_date date;
25496: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
25497: --
25498: --UPD END

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

25864: --
25865: --UPD START
25866: --
25867: l_update boolean := false ;
25868: l_datetrack_mode varchar2(80) := hr_api.g_update;
25869: l_process_date date;
25870: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
25871: --
25872: --UPD END

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

26204: end if;
26205: --
26206: -- Delete the row if it is end dated.
26207: --
26208: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
26209: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
26210: trunc(l_max_eed) = r_PRP.information3) then
26211: --
26212: BEN_REGULATORY_PURPOSE_API.delete_REGULATORY_PURPOSE(

Line 26220: ,p_datetrack_mode => hr_api.g_delete

26216: ,p_effective_start_date => l_effective_start_date
26217: ,p_effective_end_date => l_effective_end_date
26218: ,p_object_version_number => l_object_version_number
26219: ,p_effective_date => l_max_eed
26220: ,p_datetrack_mode => hr_api.g_delete
26221: --
26222: );
26223: --
26224: end if;

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

26390: --
26391: --UPD START
26392: --
26393: l_update boolean := false ;
26394: l_datetrack_mode varchar2(80) := hr_api.g_update;
26395: l_process_date date;
26396: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
26397: --
26398: --UPD END

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

26842: end if;
26843: --
26844: -- Delete the row if it is end dated.
26845: --
26846: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
26847: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
26848: trunc(l_max_eed) = r_BPP.information3) then
26849: --
26850: BEN_BENEFIT_PRVDR_POOL_API.delete_BENEFIT_PRVDR_POOL(

Line 26858: ,p_datetrack_mode => hr_api.g_delete

26854: ,p_effective_start_date => l_effective_start_date
26855: ,p_effective_end_date => l_effective_end_date
26856: ,p_object_version_number => l_object_version_number
26857: ,p_effective_date => l_max_eed
26858: ,p_datetrack_mode => hr_api.g_delete
26859: --
26860: );
26861: --
26862: end if;

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

26966: */
26967: --UPD START
26968: --
26969: l_update boolean := false ;
26970: l_datetrack_mode varchar2(80) := hr_api.g_update;
26971: l_process_date date;
26972: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
26973: --
26974: --UPD END

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

27312: --
27313: --
27314: -- Delete the row if it is end dated.
27315: --
27316: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
27317: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
27318: trunc(l_max_eed) = r_ACP.information3) then
27319: --
27320: BEN_ACRS_PTIP_CVG_API.delete_ACRS_PTIP_CVG(

Line 27328: ,p_datetrack_mode => hr_api.g_delete

27324: ,p_effective_start_date => l_effective_start_date
27325: ,p_effective_end_date => l_effective_end_date
27326: ,p_object_version_number => l_object_version_number
27327: ,p_effective_date => l_max_eed
27328: ,p_datetrack_mode => hr_api.g_delete
27329: --
27330: );
27331: --
27332: end if;