[Home] [Help]
23: hr_utility.set_location('p_effective_start_date '||p_effective_start_date,10);
24: hr_utility.set_location('p_effective_end_date '||p_effective_end_date,10);
25: hr_utility.set_location('p_effective_date '||p_effective_date,10);
26: --
27: if p_effective_end_date <> hr_api.g_eot then
28: --
29: if p_dml_operation = 'INSERT' then
30: --
31: l_datetrack_mode := hr_api.g_update;
27: if p_effective_end_date <> hr_api.g_eot then
28: --
29: if p_dml_operation = 'INSERT' then
30: --
31: l_datetrack_mode := hr_api.g_update;
32: l_update := true;
33: --
34: elsif l_datetrack_mode in ('CORRECTION') then
35: --
32: l_update := true;
33: --
34: elsif l_datetrack_mode in ('CORRECTION') then
35: --
36: l_datetrack_mode := hr_api.g_correction ;
37: l_update := true;
38: --
39: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
40: --
38: --
39: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
40: --
41: if p_effective_date = p_effective_start_date then
42: l_datetrack_mode := hr_api.g_correction ;
43: l_update := true;
44: else
45: --
46: if l_datetrack_mode in ('UPDATE_OVERRIDE') then
44: else
45: --
46: if l_datetrack_mode in ('UPDATE_OVERRIDE') then
47: --
48: l_datetrack_mode := hr_api.g_update_override ;
49: l_update := false ;
50: --
51: elsif l_datetrack_mode in ('UPDATE') then
52: --
49: l_update := false ;
50: --
51: elsif l_datetrack_mode in ('UPDATE') then
52: --
53: l_datetrack_mode := hr_api.g_update;
54: --
55: end if;
56: --
57: end if;
58: --
59: elsif l_datetrack_mode in ('UPDATE_CHANGE_INSERT') then
60: --
61: if p_effective_date = p_effective_start_date then
62: l_datetrack_mode := hr_api.g_correction ;
63: l_update := true;
64: else
65: l_datetrack_mode := hr_api.g_update_change_insert ;
66: l_update := true;
61: if p_effective_date = p_effective_start_date then
62: l_datetrack_mode := hr_api.g_correction ;
63: l_update := true;
64: else
65: l_datetrack_mode := hr_api.g_update_change_insert ;
66: l_update := true;
67: end if;
68: --
69: else
67: end if;
68: --
69: else
70: --
71: l_datetrack_mode := hr_api.g_update;
72: l_update := false;
73: --
74: end if;
75: --
76: else
77: --
78: if p_dml_operation = 'INSERT' then
79: --
80: l_datetrack_mode := hr_api.g_update;
81: l_update := false;
82: --
83: elsif l_datetrack_mode in ('CORRECTION') then
84: --
81: l_update := false;
82: --
83: elsif l_datetrack_mode in ('CORRECTION') then
84: --
85: l_datetrack_mode := hr_api.g_correction ;
86: l_update := false;
87: --
88: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
89: --
87: --
88: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
89: --
90: if p_effective_date = p_effective_start_date then
91: l_datetrack_mode := hr_api.g_correction ;
92: l_update := true;
93: else
94: l_datetrack_mode := hr_api.g_update ;
95: l_update := false ;
90: if p_effective_date = p_effective_start_date then
91: l_datetrack_mode := hr_api.g_correction ;
92: l_update := true;
93: else
94: l_datetrack_mode := hr_api.g_update ;
95: l_update := false ;
96: end if;
97: --
98: elsif l_datetrack_mode in ('UPDATE_CHANGE_INSERT') then
97: --
98: elsif l_datetrack_mode in ('UPDATE_CHANGE_INSERT') then
99: --
100: if p_effective_date = p_effective_start_date then
101: l_datetrack_mode := hr_api.g_correction ;
102: l_update := false;
103: else
104: l_datetrack_mode := hr_api.g_update ;
105: l_update := false;
100: if p_effective_date = p_effective_start_date then
101: l_datetrack_mode := hr_api.g_correction ;
102: l_update := false;
103: else
104: l_datetrack_mode := hr_api.g_update ;
105: l_update := false;
106: end if;
107: --
108: else
106: end if;
107: --
108: else
109: --
110: l_datetrack_mode := hr_api.g_update;
111: l_update := false;
112: --
113: end if;
114: --
973: IS
974: BEGIN
975: hr_utility.set_location ('Entering procedure create_or_update_ff creation ',10);
976:
977: IF p_dml_operation = hr_api.g_insert
978: THEN
979: hr_utility.set_location (' p_dml_operation' || p_dml_operation, 10);
980: hr_utility.set_location (' p_datetrack_mode' || p_datetrack_mode, 10);
981: hr_utility.set_location (' p_formula_id' || p_formula_id, 10);
1002: );
1003: -- Record created successfully
1004: END IF;
1005:
1006: IF p_dml_operation = hr_api.g_update
1007: THEN
1008: hr_utility.set_location (' p_dml_operation' || p_dml_operation, 10);
1009: hr_utility.set_location (' p_datetrack_mode' || p_datetrack_mode, 10);
1010: hr_utility.set_location (' p_formula_id' || p_formula_id, 10);
1011: hr_utility.set_location (' p_process_date' || p_process_date, 10);
1012: hr_utility.set_location (' p_effective_start_date' || p_effective_start_date,10);
1013: hr_utility.set_location (' p_effective_end_date' || p_effective_end_date,10);
1014:
1015: IF p_datetrack_mode = hr_api.g_update
1016: THEN
1017: UPDATE ff_formulas_f
1018: SET effective_end_date = (p_process_date - 1),
1019: last_update_date = p_last_update_date,
1042: p_last_update_login, p_created_by, p_creation_date
1043: );
1044: END IF;
1045:
1046: IF p_datetrack_mode = hr_api.g_correction
1047: THEN
1048: UPDATE ff_formulas_f
1049: SET legislation_code = p_legislation_code,
1050: formula_type_id = p_formula_type_id,
1063: AND effective_end_date = p_effective_end_date
1064: AND business_group_id = p_business_group_id;
1065: END IF;
1066:
1067: IF p_datetrack_mode = hr_api.g_update_override
1068: THEN
1069: UPDATE ff_formulas_f
1070: SET effective_end_date = (p_process_date - 1),
1071: last_update_date = p_last_update_date,
1091: last_update_date, last_updated_by,
1092: last_update_login, created_by, creation_date
1093: )
1094: VALUES (p_formula_id, p_process_date, -- l_min_esd,
1095: hr_api.g_eot, -- CHANGED FROM HARD-CODED DATE TO HR_API VARIABLE..
1096: p_legislation_code, p_formula_type_id, p_formula_name,
1097: p_description, p_formula_text, p_sticky_flag,
1098: p_compile_flag, p_business_group_id,
1099: p_last_update_date, p_last_updated_by,
1100: p_last_update_login, p_created_by, p_creation_date
1101: );
1102: END IF;
1103:
1104: IF p_datetrack_mode = hr_api.g_update_change_insert
1105: THEN
1106: UPDATE ff_formulas_f
1107: SET effective_end_date = (p_process_date - 1),
1108: last_update_date = p_last_update_date,
1228: l_current_pk_id NUMBER := NULL;
1229: --UPD START
1230: --
1231: l_update BOOLEAN := FALSE;
1232: l_datetrack_mode VARCHAR2 (80) := hr_api.g_update;
1233: l_process_date DATE;
1234: l_dml_operation ben_copy_entity_results.dml_operation%TYPE;
1235: --
1236: --UPD END
1733: l_current_pk_id number := null ;
1734: --UPD START
1735: --
1736: l_update boolean := false ;
1737: l_datetrack_mode varchar2(80) := hr_api.g_update;
1738: l_process_date date;
1739: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
1740: --
1741: --UPD END
2036: l_current_pk_id number := null ;
2037: --UPD START
2038: --
2039: l_update boolean := false ;
2040: l_datetrack_mode varchar2(80) := hr_api.g_update;
2041: l_process_date date;
2042: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
2043: --
2044: --UPD END
2402: end if;
2403: --
2404: -- Delete the row if it is end dated.
2405: --
2406: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
2407: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
2408: trunc(l_max_eed) = r_CPL.information3) then
2409: --
2410: BEN_CMBN_PLIP_API.delete_CMBN_PLIP(
2414: ,p_effective_start_date => l_effective_start_date
2415: ,p_effective_end_date => l_effective_end_date
2416: ,p_object_version_number => l_object_version_number
2417: ,p_effective_date => l_max_eed
2418: ,p_datetrack_mode => hr_api.g_delete
2419: --
2420: );
2421: --
2422: end if;
2553: l_current_pk_id number := null ;
2554: --UPD START
2555: --
2556: l_update boolean := false ;
2557: l_datetrack_mode varchar2(80) := hr_api.g_update;
2558: l_process_date date;
2559: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
2560: --
2561: --UPD END
2877: end if;
2878: --
2879: -- Delete the row if it is end dated.
2880: --
2881: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
2882: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
2883: trunc(l_max_eed) = r_CBP.information3) then
2884: --
2885: BEN_CMBN_PTIP_API.delete_CMBN_PTIP(
2889: ,p_effective_start_date => l_effective_start_date
2890: ,p_effective_end_date => l_effective_end_date
2891: ,p_object_version_number => l_object_version_number
2892: ,p_effective_date => l_max_eed
2893: ,p_datetrack_mode => hr_api.g_delete
2894: --
2895: );
2896: --
2897: end if;
3034: l_current_pk_id number := null ;
3035: --UPD START
3036: --
3037: l_update boolean := false ;
3038: l_datetrack_mode varchar2(80) := hr_api.g_update;
3039: l_process_date date;
3040: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
3041: --
3042: --UPD END
3387: end if;
3388: --
3389: -- Delete the row if it is end dated.
3390: --
3391: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
3392: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
3393: trunc(l_max_eed) = r_CPT.information3) then
3394: --
3395: BEN_CMBN_PTIP_OPT_API.delete_CMBN_PTIP_OPT(
3399: ,p_effective_start_date => l_effective_start_date
3400: ,p_effective_end_date => l_effective_end_date
3401: ,p_object_version_number => l_object_version_number
3402: ,p_effective_date => l_max_eed
3403: ,p_datetrack_mode => hr_api.g_delete
3404: --
3405: );
3406: --
3407: end if;
3534: --
3535: --UPD START
3536: --
3537: l_update boolean := false ;
3538: l_datetrack_mode varchar2(80) := hr_api.g_update;
3539: l_process_date date;
3540: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
3541: --
3542: --UPD END
3882: end if;
3883: --
3884: -- Delete the row if it is end dated.
3885: --
3886: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
3887: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
3888: trunc(l_max_eed) = r_BNB.information3) then
3889: --
3890: BEN_BENEFITS_BALANCE_API.delete_BENEFITS_BALANCE(
3894: ,p_effective_start_date => l_effective_start_date
3895: ,p_effective_end_date => l_effective_end_date
3896: ,p_object_version_number => l_object_version_number
3897: ,p_effective_date => l_max_eed
3898: ,p_datetrack_mode => hr_api.g_delete
3899: --
3900: );
3901: --
3902: end if;
3986: l_current_pk_id number := null ;
3987: --UPD START
3988: --
3989: l_update boolean := false ;
3990: l_datetrack_mode varchar2(80) := hr_api.g_update;
3991: l_process_date date;
3992: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
3993: --
3994: --UPD END
4422: l_current_pk_id number := null ;
4423: --UPD START
4424: --
4425: l_update boolean := false ;
4426: l_datetrack_mode varchar2(80) := hr_api.g_update;
4427: l_process_date date;
4428: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
4429: --
4430: --UPD END
4839: l_current_pk_id number := null ;
4840: --UPD START
4841: --
4842: l_update boolean := false ;
4843: l_datetrack_mode varchar2(80) := hr_api.g_update;
4844: l_process_date date;
4845: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
4846: --
4847: --UPD END
5205: l_current_pk_id number := null ;
5206: --UPD START
5207: --
5208: l_update boolean := false ;
5209: l_datetrack_mode varchar2(80) := hr_api.g_update;
5210: l_process_date date;
5211: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
5212: --
5213: --UPD END
5569: l_current_pk_id number := null ;
5570: --UPD START
5571: --
5572: l_update boolean := false ;
5573: l_datetrack_mode varchar2(80) := hr_api.g_update;
5574: l_process_date date;
5575: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
5576: --
5577: --UPD END
5913: l_current_pk_id number := null ;
5914: --UPD START
5915: --
5916: l_update boolean := false ;
5917: l_datetrack_mode varchar2(80) := hr_api.g_update;
5918: l_process_date date;
5919: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
5920: --
5921: --UPD END
6280: l_current_pk_id number := null ;
6281: --UPD START
6282: --
6283: l_update boolean := false ;
6284: l_datetrack_mode varchar2(80) := hr_api.g_update;
6285: l_process_date date;
6286: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6287: --
6288: --UPD END
6631: --
6632: --
6633: -- Delete the row if it is end dated.
6634: --
6635: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
6636: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
6637: trunc(l_max_eed) = r_PTP.information3) then
6638: --
6639: BEN_PLAN_TYPE_API.delete_PLAN_TYPE(
6643: ,p_effective_start_date => l_effective_start_date
6644: ,p_effective_end_date => l_effective_end_date
6645: ,p_object_version_number => l_object_version_number
6646: ,p_effective_date => l_max_eed
6647: ,p_datetrack_mode => hr_api.g_delete
6648: --
6649: );
6650: --
6651: end if;
6756: l_current_pk_id number := null ;
6757: --UPD START
6758: --
6759: l_update boolean := false ;
6760: l_datetrack_mode varchar2(80) := hr_api.g_update;
6761: l_process_date date;
6762: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6763: --
6764: --UPD END
7295: end if;
7296: --
7297: -- Delete the row if it is end dated.
7298: --
7299: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
7300: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
7301: trunc(l_max_eed) = r_PGM.information3) then
7302: --
7303: BEN_PROGRAM_API.delete_PROGRAM(
7307: ,p_effective_start_date => l_effective_start_date
7308: ,p_effective_end_date => l_effective_end_date
7309: ,p_object_version_number => l_object_version_number
7310: ,p_effective_date => l_max_eed
7311: ,p_datetrack_mode => hr_api.g_delete
7312: --
7313: );
7314: --
7315: end if;
7419: l_current_pk_id number := null ;
7420: --UPD START
7421: --
7422: l_update boolean := false ;
7423: l_datetrack_mode varchar2(80) := hr_api.g_update;
7424: l_process_date date;
7425: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
7426: --
7427: --UPD END
7689: end if;
7690: --
7691: -- Delete the row if it is end dated.
7692: --
7693: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
7694: trunc(l_max_eed) = r_REG.information3) then
7695: --
7696: BEN_REGULATIONS_API.delete_REGULATIONS(
7697: --
7700: ,p_effective_start_date => l_effective_start_date
7701: ,p_effective_end_date => l_effective_end_date
7702: ,p_object_version_number => l_object_version_number
7703: ,p_effective_date => l_max_eed
7704: ,p_datetrack_mode => hr_api.g_delete
7705: --
7706: );
7707: --
7708: end if;
7817: l_current_pk_id number := null ;
7818: --UPD START
7819: --
7820: l_update boolean := false ;
7821: l_datetrack_mode varchar2(80) := hr_api.g_update;
7822: l_process_date date;
7823: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
7824: --
7825: --UPD END
8146: end if;
8147: --
8148: -- Delete the row if it is end dated.
8149: --
8150: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
8151: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
8152: trunc(l_max_eed) = r_RZR.information3) then
8153: --
8154: BEN_POSTAL_ZIP_RANGE_API.delete_POSTAL_ZIP_RANGE(
8158: ,p_effective_start_date => l_effective_start_date
8159: ,p_effective_end_date => l_effective_end_date
8160: ,p_object_version_number => l_object_version_number
8161: ,p_effective_date => l_max_eed
8162: ,p_datetrack_mode => hr_api.g_delete
8163: --
8164: );
8165: --
8166: end if;
8251: l_current_pk_id number := null ;
8252: --UPD START
8253: --
8254: l_update boolean := false ;
8255: l_datetrack_mode varchar2(80) := hr_api.g_update;
8256: l_process_date date;
8257: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
8258: --
8259: --UPD END
8612: l_current_pk_id number := null ;
8613: --UPD START
8614: --
8615: l_update boolean := false ;
8616: l_datetrack_mode varchar2(80) := hr_api.g_update;
8617: l_process_date date;
8618: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
8619: --
8620: --UPD END
8945: end if;
8946: --
8947: -- Delete the row if it is end dated.
8948: --
8949: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
8950: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
8951: trunc(l_max_eed) = r_RCL.information3) then
8952: --
8953: BEN_RLTD_PER_CHG_CS_LER_API.delete_RLTD_PER_CHG_CS_LER(
8957: ,p_effective_start_date => l_effective_start_date
8958: ,p_effective_end_date => l_effective_end_date
8959: ,p_object_version_number => l_object_version_number
8960: ,p_effective_date => l_max_eed
8961: ,p_datetrack_mode => hr_api.g_delete
8962: --
8963: );
8964: --
8965: end if;
9090: l_current_pk_id number := null ;
9091: --UPD START
9092: --
9093: l_update boolean := false ;
9094: l_datetrack_mode varchar2(80) := hr_api.g_update;
9095: l_process_date date;
9096: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
9097: --
9098: --UPD END
9487: end if;
9488: --
9489: -- Delete the row if it is end dated.
9490: --
9491: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
9492: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
9493: trunc(l_max_eed) = r_OPT.information3) then
9494: --
9495: BEN_OPTION_DEFINITION_API.delete_OPTION_DEFINITION(
9499: ,p_effective_start_date => l_effective_start_date
9500: ,p_effective_end_date => l_effective_end_date
9501: ,p_object_version_number => l_object_version_number
9502: ,p_effective_date => l_max_eed
9503: ,p_datetrack_mode => hr_api.g_delete
9504: --
9505: );
9506: --
9507: end if;
9677: l_current_pk_id number := null ;
9678: --UPD START
9679: --
9680: l_update boolean := false ;
9681: l_datetrack_mode varchar2(80) := hr_api.g_update;
9682: l_process_date date;
9683: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
9684: --
9685: --UPD END
10131: end if;
10132: --
10133: -- Delete the row if it is end dated.
10134: --
10135: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
10136: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
10137: trunc(l_max_eed) = r_LER.information3) then
10138: --
10139: BEN_LIFE_EVENT_REASON_API.delete_LIFE_EVENT_REASON(
10143: ,p_effective_start_date => l_effective_start_date
10144: ,p_effective_end_date => l_effective_end_date
10145: ,p_object_version_number => l_object_version_number
10146: ,p_effective_date => l_max_eed
10147: ,p_datetrack_mode => hr_api.g_delete
10148: --
10149: );
10150: --
10151: end if;
10263: l_current_pk_id number := null ;
10264: --UPD START
10265: --
10266: l_update boolean := false ;
10267: l_datetrack_mode varchar2(80) := hr_api.g_update;
10268: l_process_date date;
10269: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
10270: --
10271: --UPD END
10600: end if;
10601: --
10602: -- Delete the row if it is end dated.
10603: --
10604: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
10605: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
10606: trunc(l_max_eed) = r_LPL.information3) then
10607: --
10608: BEN_LER_PER_INFO_CS_LER_API.delete_LER_PER_INFO_CS_LER(
10612: ,p_effective_start_date => l_effective_start_date
10613: ,p_effective_end_date => l_effective_end_date
10614: ,p_object_version_number => l_object_version_number
10615: ,p_effective_date => l_max_eed
10616: ,p_datetrack_mode => hr_api.g_delete
10617: --
10618: );
10619: --
10620: end if;
10725: l_current_pk_id number := null ;
10726: --UPD START
10727: --
10728: l_update boolean := false ;
10729: l_datetrack_mode varchar2(80) := hr_api.g_update;
10730: l_process_date date;
10731: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
10732: --
10733: --UPD END
11187: end if;
11188: --
11189: -- Delete the row if it is end dated.
11190: --
11191: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
11192: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
11193: trunc(l_max_eed) = r_ELP.information3) then
11194: --
11195: BEN_ELIGY_PROFILE_API.delete_ELIGY_PROFILE(
11199: ,p_effective_start_date => l_effective_start_date
11200: ,p_effective_end_date => l_effective_end_date
11201: ,p_object_version_number => l_object_version_number
11202: ,p_effective_date => l_max_eed
11203: ,p_datetrack_mode => hr_api.g_delete
11204: --
11205: );
11206: --
11207: end if;
11311: l_current_pk_id number := null ;
11312: --UPD START
11313: --
11314: l_update boolean := false ;
11315: l_datetrack_mode varchar2(80) := hr_api.g_update;
11316: l_process_date date;
11317: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
11318: --
11319: --UPD END
11666: end if;
11667: --
11668: -- Delete the row if it is end dated.
11669: --
11670: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
11671: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
11672: trunc(l_max_eed) = r_DCE.information3) then
11673: --
11674: BEN_DPNT_CVG_ELIG_PRFL_API.delete_DPNT_CVG_ELIG_PRFL(
11678: ,p_effective_start_date => l_effective_start_date
11679: ,p_effective_end_date => l_effective_end_date
11680: ,p_object_version_number => l_object_version_number
11681: ,p_effective_date => l_max_eed
11682: ,p_datetrack_mode => hr_api.g_delete
11683: --
11684: );
11685: --
11686: end if;
11770: l_current_pk_id number := null ;
11771: --UPD START
11772: --
11773: l_update boolean := false ;
11774: l_datetrack_mode varchar2(80) := hr_api.g_update;
11775: l_process_date date;
11776: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
11777: --
11778: --UPD END
12099: l_current_pk_id number := null ;
12100: --UPD START
12101: --
12102: l_update boolean := false ;
12103: l_datetrack_mode varchar2(80) := hr_api.g_update;
12104: l_process_date date;
12105: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
12106: --
12107: --UPD END
12424: from BEN_PER_INFO_CHG_CS_LER_F PSL
12425: where ( PSL.name = c_PSL_name OR
12426: ( PSL.source_table = l_source_table
12427: and PSL.source_column = l_source_column
12428: and PSL.new_val = nvl(l_new_val,hr_api.g_varchar2)
12429: and PSL.old_val = nvl(l_old_val,hr_api.g_varchar2) ))
12430: and PSL.business_group_id = c_business_group_id
12431: and PSL.per_info_chg_cs_ler_id <> c_new_pk_id
12432: --TEMPIK
12425: where ( PSL.name = c_PSL_name OR
12426: ( PSL.source_table = l_source_table
12427: and PSL.source_column = l_source_column
12428: and PSL.new_val = nvl(l_new_val,hr_api.g_varchar2)
12429: and PSL.old_val = nvl(l_old_val,hr_api.g_varchar2) ))
12430: and PSL.business_group_id = c_business_group_id
12431: and PSL.per_info_chg_cs_ler_id <> c_new_pk_id
12432: --TEMPIK
12433: and c_effective_start_date between effective_start_date
12438: from BEN_PER_INFO_CHG_CS_LER_F PSL1
12439: where (PSL1.name = c_PSL_name OR
12440: ( PSL1.source_table = l_source_table
12441: and PSL1.source_column = l_source_column
12442: --and PSL1.new_val = nvl(l_new_val,hr_api.g_varchar2)
12443: --and PSL1.old_val = nvl(l_old_val,hr_api.g_varchar2)
12444: ))
12445: and PSL1.business_group_id = c_business_group_id
12446: and PSL1.effective_start_date <= c_effective_start_date )
12439: where (PSL1.name = c_PSL_name OR
12440: ( PSL1.source_table = l_source_table
12441: and PSL1.source_column = l_source_column
12442: --and PSL1.new_val = nvl(l_new_val,hr_api.g_varchar2)
12443: --and PSL1.old_val = nvl(l_old_val,hr_api.g_varchar2)
12444: ))
12445: and PSL1.business_group_id = c_business_group_id
12446: and PSL1.effective_start_date <= c_effective_start_date )
12447: and exists ( select null
12448: from BEN_PER_INFO_CHG_CS_LER_F PSL2
12449: where ( PSL2.name = c_PSL_name OR
12450: ( PSL2.source_table = l_source_table
12451: and PSL2.source_column = l_source_column
12452: --and PSL2.new_val = nvl(l_new_val,hr_api.g_varchar2)
12453: --and PSL2.old_val = nvl(l_old_val,hr_api.g_varchar2)
12454: ))
12455: and PSL2.business_group_id = c_business_group_id
12456: and PSL2.effective_end_date >= c_effective_end_date )
12449: where ( PSL2.name = c_PSL_name OR
12450: ( PSL2.source_table = l_source_table
12451: and PSL2.source_column = l_source_column
12452: --and PSL2.new_val = nvl(l_new_val,hr_api.g_varchar2)
12453: --and PSL2.old_val = nvl(l_old_val,hr_api.g_varchar2)
12454: ))
12455: and PSL2.business_group_id = c_business_group_id
12456: and PSL2.effective_end_date >= c_effective_end_date )
12457: ;
12484: l_current_pk_id number := null ;
12485: --UPD START
12486: --
12487: l_update boolean := false ;
12488: l_datetrack_mode varchar2(80) := hr_api.g_update;
12489: l_process_date date;
12490: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
12491: --
12492: --UPD END
12876: end if;
12877: --
12878: -- Delete the row if it is end dated.
12879: --
12880: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
12881: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
12882: trunc(l_max_eed) = r_PSL.information3) then
12883: --
12884: BEN_PERSON_CHANGE_CS_LER_API.delete_PERSON_CHANGE_CS_LER(
12888: ,p_effective_start_date => l_effective_start_date
12889: ,p_effective_end_date => l_effective_end_date
12890: ,p_object_version_number => l_object_version_number
12891: ,p_effective_date => l_max_eed
12892: ,p_datetrack_mode => hr_api.g_delete
12893: --
12894: );
12895: --
12896: end if;
13001: l_current_pk_id number := null ;
13002: --UPD START
13003: --
13004: l_update boolean := false ;
13005: l_datetrack_mode varchar2(80) := hr_api.g_update;
13006: l_process_date date;
13007: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13008: --
13009: --UPD END
13355: end if;
13356: --
13357: -- Delete the row if it is end dated.
13358: --
13359: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
13360: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
13361: trunc(l_max_eed) = r_CCT.information3) then
13362: --
13363: BEN_COMP_COMM_TYPES_API.delete_COMP_COMM_TYPES(
13367: ,p_effective_start_date => l_effective_start_date
13368: ,p_effective_end_date => l_effective_end_date
13369: ,p_object_version_number => l_object_version_number
13370: ,p_effective_date => l_max_eed
13371: ,p_datetrack_mode => hr_api.g_delete
13372: --
13373: );
13374: --
13375: end if;
13480: l_current_pk_id number := null ;
13481: --UPD START
13482: --
13483: l_update boolean := false ;
13484: l_datetrack_mode varchar2(80) := hr_api.g_update;
13485: l_process_date date;
13486: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13487: --
13488: --UPD END
13824: end if;
13825: --
13826: -- Delete the row if it is end dated.
13827: --
13828: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
13829: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
13830: trunc(l_max_eed) = r_PDL.information3) then
13831: --
13832: BEN_PERIOD_LIMIT_API.delete_PERIOD_LIMIT(
13836: ,p_effective_start_date => l_effective_start_date
13837: ,p_effective_end_date => l_effective_end_date
13838: ,p_object_version_number => l_object_version_number
13839: ,p_effective_date => l_max_eed
13840: ,p_datetrack_mode => hr_api.g_delete
13841: --
13842: );
13843: --
13844: end if;
13928: l_current_pk_id number := null ;
13929: --UPD START
13930: --
13931: l_update boolean := false ;
13932: l_datetrack_mode varchar2(80) := hr_api.g_update;
13933: l_process_date date;
13934: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13935: --
13936: --UPD END
14273: l_current_pk_id number := null ;
14274: --UPD START
14275: --
14276: l_update boolean := false ;
14277: l_datetrack_mode varchar2(80) := hr_api.g_update;
14278: l_process_date date;
14279: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
14280: --
14281: --UPD END
14646: l_current_pk_id number := null ;
14647: --UPD START
14648: --
14649: l_update boolean := false ;
14650: l_datetrack_mode varchar2(80) := hr_api.g_update;
14651: l_process_date date;
14652: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
14653: --
14654: --UPD END
15454: end if;
15455: --
15456: -- Delete the row if it is end dated.
15457: --
15458: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
15459: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
15460: trunc(l_max_eed) = r_PLN.information3) then
15461: --
15462: BEN_PLAN_API.delete_PLAN(
15466: ,p_effective_start_date => l_effective_start_date
15467: ,p_effective_end_date => l_effective_end_date
15468: ,p_object_version_number => l_object_version_number
15469: ,p_effective_date => l_max_eed
15470: ,p_datetrack_mode => hr_api.g_delete
15471: --
15472: );
15473: --
15474: end if;
15579: l_current_pk_id number := null ;
15580: --UPD START
15581: --
15582: l_update boolean := false ;
15583: l_datetrack_mode varchar2(80) := hr_api.g_update;
15584: l_process_date date;
15585: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
15586: --
15587: --UPD END
15905: end if;
15906: --
15907: -- Delete the row if it is end dated.
15908: --
15909: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
15910: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
15911: trunc(l_max_eed) = r_SVA.information3) then
15912: --
15913: BEN_SERVICE_AREA_API.delete_SERVICE_AREA(
15917: ,p_effective_start_date => l_effective_start_date
15918: ,p_effective_end_date => l_effective_end_date
15919: ,p_object_version_number => l_object_version_number
15920: ,p_effective_date => l_max_eed
15921: ,p_datetrack_mode => hr_api.g_delete
15922: --
15923: );
15924: --
15925: end if;
16037: l_current_pk_id number := null ;
16038: --UPD START
16039: --
16040: l_update boolean := false ;
16041: l_datetrack_mode varchar2(80) := hr_api.g_update;
16042: l_process_date date;
16043: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
16044: --
16045: --UPD END
16377: end if;
16378: --
16379: -- Delete the row if it is end dated.
16380: --
16381: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
16382: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
16383: trunc(l_max_eed) = r_PON.information3) then
16384: --
16385: BEN_PLAN_TYPE_OPTION_TYPE_API.delete_PLAN_TYPE_OPTION_TYPE(
16389: ,p_effective_start_date => l_effective_start_date
16390: ,p_effective_end_date => l_effective_end_date
16391: ,p_object_version_number => l_object_version_number
16392: ,p_effective_date => l_max_eed
16393: ,p_datetrack_mode => hr_api.g_delete
16394: --
16395: );
16396: --
16397: end if;
16606: WHERE copy_entity_Txn_id = p_copy_entity_txn_id;
16607: --
16608: l_current_pk_id NUMBER := NULL;
16609: l_update BOOLEAN := FALSE;
16610: l_datetrack_mode VARCHAR2 (80) := hr_api.g_update;
16611: l_process_date DATE;
16612: l_dml_operation ben_copy_entity_results.dml_operation%TYPE;
16613: l_prev_pk_id NUMBER := NULL;
16614: l_first_rec BOOLEAN := TRUE;