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.PQH_GSP_PRGRULES dependencies on BEN_COPY_ENTITY_RESULTS

Line 7: p_bcer_rec ben_copy_entity_results%rowtype

3:
4: type TabCerType is table of number ;
5:
6: function create_bcer_rec (
7: p_bcer_rec ben_copy_entity_results%rowtype
8: )
9: return number ;
10:
11:

Line 16: update ben_copy_entity_results

12:
13: procedure update_child(p_child_cer_id in number,p_master_cer_id in number)
14: is
15: begin
16: update ben_copy_entity_results
17: set gs_parent_entity_result_id = p_master_cer_id
18: ,parent_entity_result_id = p_master_cer_id
19: where copy_entity_result_id = p_child_cer_id;
20: end update_child;

Line 34: update ben_copy_entity_results

30: is
31: begin
32: -- nullify info1 of duplicate records.
33: forall i in 1..p_cerTab.COUNT
34: update ben_copy_entity_results
35: set information101 = information1
36: ,information1 = null
37: ,information263 = null
38: where copy_entity_result_id = p_cerTab(i);

Line 45: update ben_copy_entity_results

41: procedure upd_info1(p_cer_id in number)
42: is
43: begin
44: -- nullify info1 of duplicate records.
45: update ben_copy_entity_results
46: set information101 = information1
47: ,information1 = null
48: ,information263 = null
49: where copy_entity_result_id = p_cer_id;

Line 69: from ben_copy_entity_results

65: is
66: -- get the elp record
67: cursor cur_elp is
68: select copy_entity_result_id
69: from ben_copy_entity_results
70: where copy_entity_result_id = p_copy_entity_result_id;
71:
72: -- get the elp child records to be info1 nulled
73: cursor cur_elp_child(p_parent_cer_id number) is

Line 75: from ben_copy_entity_results

71:
72: -- get the elp child records to be info1 nulled
73: cursor cur_elp_child(p_parent_cer_id number) is
74: select copy_entity_result_id
75: from ben_copy_entity_results
76: where parent_entity_result_id = p_parent_cer_id
77: and copy_entity_txn_id = p_copy_entity_txn_id;
78:
79: -- get one more level down for EAP-AGF,ECP-CLA,ECL-CLF

Line 83: from ben_copy_entity_results

79: -- get one more level down for EAP-AGF,ECP-CLA,ECL-CLF
80: -- ,EHW-HWF,ELS-LSF,EPF-PFF
81: cursor cur_drv_fct (p_parent_cer_id number) is
82: select copy_entity_result_id
83: from ben_copy_entity_results
84: where parent_entity_result_id = p_parent_cer_id
85: and copy_entity_txn_id = p_copy_entity_txn_id;
86:
87: begin

Line 123: from ben_copy_entity_results

119:
120: -- get all elp records
121: cursor cur_elp is
122: select information1, copy_entity_result_id
123: from ben_copy_entity_results
124: where table_alias = 'ELP'
125: and copy_entity_txn_id = p_copy_entity_txn_id
126: and information1 is not null
127: order by information1 ;

Line 133: from ben_copy_entity_results

129:
130: -- get the elp child records to be info1 nulled
131: cursor cur_elp_child(p_parent_cer_id number) is
132: select *
133: from ben_copy_entity_results
134: where parent_entity_result_id = p_parent_cer_id
135: and copy_entity_txn_id = p_copy_entity_txn_id;
136:
137: -- get one more level down for EAP-AGF,ECP-CLA,ECL-CLF

Line 141: from ben_copy_entity_results

137: -- get one more level down for EAP-AGF,ECP-CLA,ECL-CLF
138: -- ,EHW-HWF,ELS-LSF,EPF-PFF
139: cursor cur_drv_fct (p_parent_cer_id number) is
140: select *
141: from ben_copy_entity_results
142: where parent_entity_result_id = p_parent_cer_id
143: and copy_entity_txn_id = p_copy_entity_txn_id;
144:
145: prev_info1 number ;

Line 190: from ben_copy_entity_results

186:
187: -- get the elp record to be duplicated
188: cursor cur_elp is
189: select *
190: from ben_copy_entity_results
191: where table_alias = 'ELP'
192: and copy_entity_txn_id = p_copy_entity_txn_id
193: and information1 = p_eligy_prfl_id;
194:

Line 198: from ben_copy_entity_results

194:
195: -- get the elp child records to be duplicated
196: cursor cur_elp_child(p_parent_cer_id number) is
197: select *
198: from ben_copy_entity_results
199: where parent_entity_result_id = p_parent_cer_id
200: and copy_entity_txn_id = p_copy_entity_txn_id;
201:
202: -- get one more level down for EAP-AGF,ECP-CLA,ECL-CLF

Line 206: from ben_copy_entity_results

202: -- get one more level down for EAP-AGF,ECP-CLA,ECL-CLF
203: -- ,EHW-HWF,ELS-LSF,EPF-PFF
204: cursor cur_drv_fct (p_parent_cer_id number) is
205: select *
206: from ben_copy_entity_results
207: where parent_entity_result_id = p_parent_cer_id
208: and copy_entity_txn_id = p_copy_entity_txn_id;
209:
210: begin

Line 221: update ben_copy_entity_results

217: -- create duplicate ELP record
218: l_elp_cerid := create_bcer_rec(rec_elp);
219: upd_info1(l_elp_cerid);
220:
221: update ben_copy_entity_results
222: set gs_parent_entity_result_id = p_gs_per_id
223: ,parent_entity_result_id = p_per_id
224: ,Gs_Mirror_Src_Entity_Result_id = p_gm_ser_id
225: where copy_entity_result_id = l_elp_cerid;

Line 252: from ben_copy_entity_results

248: ,p_copy_entity_result_id number
249: ) is
250: cursor cur_elp is
251: select copy_entity_result_id
252: from ben_copy_entity_results
253: where copy_entity_result_id = p_copy_entity_result_id ;
254:
255: -- get the elp child records to be deleted
256: cursor cur_elp_child(p_parent_cer_id number) is

Line 258: from ben_copy_entity_results

254:
255: -- get the elp child records to be deleted
256: cursor cur_elp_child(p_parent_cer_id number) is
257: select copy_entity_result_id
258: from ben_copy_entity_results
259: where gs_parent_entity_result_id = p_parent_cer_id
260: and copy_entity_txn_id = p_copy_entity_txn_id
261: and information1 is null;
262:

Line 267: from ben_copy_entity_results

263: -- get one more level down to delete EAP-AGF,ECP-CLA,ECL-CLF
264: -- ,EHW-HWF,ELS-LSF,EPF-PFF
265: cursor cur_drv_fct (p_parent_cer_id number) is
266: select copy_entity_result_id
267: from ben_copy_entity_results
268: where parent_entity_result_id = p_parent_cer_id
269: and copy_entity_txn_id = p_copy_entity_txn_id
270: and information1 is null;
271:

Line 294: delete from ben_copy_entity_results

290: end loop;
291: end loop ;
292:
293: forall i in 1..tab_cer.COUNT
294: delete from ben_copy_entity_results
295: where copy_entity_result_id = tab_cer(i);
296:
297: end purge_dup_elp_tree;
298:

Line 312: from ben_copy_entity_results

308: ,p_eligy_prfl_id number
309: ) is
310: cursor cur_dup_elp is
311: select *
312: from ben_copy_entity_results
313: where table_alias = 'ELP'
314: and copy_entity_txn_id = p_copy_entity_txn_id
315: and information1 is null
316: and information101 = p_eligy_prfl_id;

Line 320: from ben_copy_entity_results

316: and information101 = p_eligy_prfl_id;
317:
318: cursor cur_org_elp is
319: select 'Y'
320: from ben_copy_entity_results
321: where table_alias = 'ELP'
322: and copy_entity_txn_id = p_copy_entity_txn_id
323: and information1 = p_eligy_prfl_id;
324:

Line 403: from ben_copy_entity_results

399:
400: -- get the elp record to be duplicated
401: cursor cur_elp is
402: select *
403: from ben_copy_entity_results
404: where table_alias = 'ELP'
405: and copy_entity_txn_id = p_copy_entity_txn_id
406: and information1 = p_eligy_prfl_id;
407:

Line 411: from ben_copy_entity_results

407:
408: -- get the elp child records to be duplicated
409: cursor cur_elp_child(p_parent_cer_id number) is
410: select *
411: from ben_copy_entity_results
412: where parent_entity_result_id = p_parent_cer_id
413: and copy_entity_txn_id = p_copy_entity_txn_id;
414:
415: -- get one more level down for EAP-AGF,ECP-CLA,ECL-CLF

Line 419: from ben_copy_entity_results

415: -- get one more level down for EAP-AGF,ECP-CLA,ECL-CLF
416: -- ,EHW-HWF,ELS-LSF,EPF-PFF
417: cursor cur_drv_fct (p_parent_cer_id number) is
418: select *
419: from ben_copy_entity_results
420: where parent_entity_result_id = p_parent_cer_id
421: and copy_entity_txn_id = p_copy_entity_txn_id;
422:
423: begin

Line 480: -- from ben_copy_entity_results

476: -- Duplicate ELP and its child will have info1 as null and not null info101
477:
478: --cursor cur_elp is
479: --select copy_entity_result_id
480: -- from ben_copy_entity_results
481: -- where copy_entity_result_id = p_copy_entity_result_id ;
482:
483: cursor cur_elp is
484: select copy_entity_result_id

Line 485: from ben_copy_entity_results

481: -- where copy_entity_result_id = p_copy_entity_result_id ;
482:
483: cursor cur_elp is
484: select copy_entity_result_id
485: from ben_copy_entity_results
486: where table_alias = 'ELP'
487: and copy_entity_txn_id = p_copy_entity_txn_id
488: and information1 is null
489: and nvl(p_eligy_prfl_id,information101) = information101

Line 495: from ben_copy_entity_results

491:
492: -- get the elp child records to be deleted
493: cursor cur_elp_child(p_parent_cer_id number) is
494: select copy_entity_result_id
495: from ben_copy_entity_results
496: where gs_parent_entity_result_id = p_parent_cer_id
497: and copy_entity_txn_id = p_copy_entity_txn_id
498: and information1 is null;
499:

Line 504: from ben_copy_entity_results

500: -- get one more level down to delete EAP-AGF,ECP-CLA,ECL-CLF
501: -- ,EHW-HWF,ELS-LSF,EPF-PFF
502: cursor cur_drv_fct (p_parent_cer_id number) is
503: select copy_entity_result_id
504: from ben_copy_entity_results
505: where parent_entity_result_id = p_parent_cer_id
506: and copy_entity_txn_id = p_copy_entity_txn_id
507: and information1 is null;
508:

Line 531: delete from ben_copy_entity_results

527: end loop;
528: end loop ;
529:
530: forall i in 1..tab_cer.COUNT
531: delete from ben_copy_entity_results
532: where copy_entity_result_id = tab_cer(i);
533:
534: end purge_duplicate_elp_tree;
535:

Line 544: p_bcer_rec ben_copy_entity_results%rowtype

540: -- return - return cerid of the newly created bcer record
541: --<------------------------------------------>
542:
543: function create_bcer_rec (
544: p_bcer_rec ben_copy_entity_results%rowtype
545: )
546: return number
547: is
548: l_grr_cer_id number;

Line 551: bcer_rec ben_copy_entity_results%rowtype ;

547: is
548: l_grr_cer_id number;
549: l_grr_cer_ovn number;
550: l_effective_date date; -- ask GANESH
551: bcer_rec ben_copy_entity_results%rowtype ;
552: begin
553: hr_utility.set_location('Entering creating bcer rec', 10);
554: bcer_rec := p_bcer_rec ;
555: ben_copy_entity_results_api.create_copy_entity_results(

Line 555: ben_copy_entity_results_api.create_copy_entity_results(

551: bcer_rec ben_copy_entity_results%rowtype ;
552: begin
553: hr_utility.set_location('Entering creating bcer rec', 10);
554: bcer_rec := p_bcer_rec ;
555: ben_copy_entity_results_api.create_copy_entity_results(
556: p_effective_date => l_effective_date
557: ,p_copy_entity_txn_id => bcer_rec.copy_entity_txn_id
558: ,p_result_type_cd => bcer_rec.result_type_cd
559: ,p_src_copy_entity_result_id => bcer_rec.src_copy_entity_result_id

Line 939: From ben_Copy_Entity_Results

935: Return Varchar2 Is
936:
937: Cursor Ref_level is
938: Select Table_Alias
939: From ben_Copy_Entity_Results
940: Where Copy_Entity_Result_id in
941: (Select EPA.Gs_Mirror_Src_Entity_Result_id
942: From Ben_Copy_Entity_Results Elp,
943: Ben_Copy_Entity_Results Cep,

Line 942: From Ben_Copy_Entity_Results Elp,

938: Select Table_Alias
939: From ben_Copy_Entity_Results
940: Where Copy_Entity_Result_id in
941: (Select EPA.Gs_Mirror_Src_Entity_Result_id
942: From Ben_Copy_Entity_Results Elp,
943: Ben_Copy_Entity_Results Cep,
944: Ben_Copy_Entity_Results EPA
945: Where Elp.Gs_Parent_Entity_Result_id = P_Parent_Cer_Id
946: and Elp.Table_Alias = 'ELP'

Line 943: Ben_Copy_Entity_Results Cep,

939: From ben_Copy_Entity_Results
940: Where Copy_Entity_Result_id in
941: (Select EPA.Gs_Mirror_Src_Entity_Result_id
942: From Ben_Copy_Entity_Results Elp,
943: Ben_Copy_Entity_Results Cep,
944: Ben_Copy_Entity_Results EPA
945: Where Elp.Gs_Parent_Entity_Result_id = P_Parent_Cer_Id
946: and Elp.Table_Alias = 'ELP'
947: and Cep.Copy_Entity_Result_id = Elp.Gs_Mirror_Src_Entity_Result_id

Line 944: Ben_Copy_Entity_Results EPA

940: Where Copy_Entity_Result_id in
941: (Select EPA.Gs_Mirror_Src_Entity_Result_id
942: From Ben_Copy_Entity_Results Elp,
943: Ben_Copy_Entity_Results Cep,
944: Ben_Copy_Entity_Results EPA
945: Where Elp.Gs_Parent_Entity_Result_id = P_Parent_Cer_Id
946: and Elp.Table_Alias = 'ELP'
947: and Cep.Copy_Entity_Result_id = Elp.Gs_Mirror_Src_Entity_Result_id
948: and Cep.Table_Alias = 'CEP'

Line 975: From ben_Copy_Entity_Results

971: Return Varchar2 Is
972:
973: Cursor Exist_Rec is
974: Select Information1
975: From ben_Copy_Entity_Results
976: Where Copy_Entity_Result_id = P_Copy_Entity_Result_Id;
977:
978: L_Information1 Ben_Copy_Entity_Results.Information1%TYPE;
979: L_Dml_operation Varchar2(15);

Line 978: L_Information1 Ben_Copy_Entity_Results.Information1%TYPE;

974: Select Information1
975: From ben_Copy_Entity_Results
976: Where Copy_Entity_Result_id = P_Copy_Entity_Result_Id;
977:
978: L_Information1 Ben_Copy_Entity_Results.Information1%TYPE;
979: L_Dml_operation Varchar2(15);
980:
981: Begin
982:

Line 1010: from ben_copy_entity_results

1006: is
1007: Cursor csr_elpro_in_stage
1008: is
1009: select null
1010: from ben_copy_entity_results
1011: where table_alias = 'ELP'
1012: and copy_entity_txn_id = p_copy_entity_txn_id
1013: and information1 = p_eligy_prfl_id;
1014: l_dummy varchar2(1);

Line 1034: from ben_copy_entity_results

1030: is
1031: Cursor csr_eligy_prfl_in_txn
1032: is
1033: select copy_entity_result_id
1034: from ben_copy_entity_results
1035: where copy_entity_txn_id =p_copy_entity_txn_id
1036: and table_alias = 'ELP'
1037: and information1 = p_eligy_prfl_id
1038: and dml_operation <> 'REUSE';

Line 1065: from ben_copy_entity_results

1061: is
1062: Cursor csr_eligy_prfl_cer
1063: is
1064: select copy_entity_result_id eligy_prfl_cer_id
1065: from ben_copy_entity_results
1066: where copy_entity_txn_id = p_copy_entity_txn_id
1067: and table_alias = 'ELP'
1068: and information1 is not null;
1069: Cursor csr_criteria(p_eligy_prfl_cer_id in number)

Line 1072: from ben_copy_entity_results

1068: and information1 is not null;
1069: Cursor csr_criteria(p_eligy_prfl_cer_id in number)
1070: is
1071: select copy_entity_result_id crit_cer_id
1072: from ben_copy_entity_results
1073: where copy_entity_txn_id = p_copy_entity_txn_id
1074: and parent_entity_result_id =p_eligy_prfl_cer_id
1075: and gs_parent_entity_result_id is null;
1076:

Line 1082: update ben_copy_entity_results

1078:
1079: for i in csr_eligy_prfl_cer loop
1080:
1081: for j in csr_criteria(i.eligy_prfl_cer_id) loop
1082: update ben_copy_entity_results
1083: set gs_parent_entity_result_id = i.eligy_prfl_cer_id,
1084: GS_MIRROR_SRC_ENTITY_RESULT_ID = i.eligy_prfl_cer_id
1085: where copy_entity_result_id = j.crit_cer_id;
1086:

Line 1106: L_PRTN_COPY_ENTITY_RSLT_ID BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;

1102: P_Req_opt In Varchar2,
1103: P_Ref_level In Varchar2,
1104: P_Compute_Score_Flag In Varchar2) Is
1105:
1106: L_PRTN_COPY_ENTITY_RSLT_ID BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1107: L_DELPRTN_COPY_ENTITY_RSLT_ID BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1108: l_Copy_Entity_Rslt_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1109: l_PrtnPrfl_Copy_Entity_Rslt_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1110: l_Object_version_number BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;

Line 1107: L_DELPRTN_COPY_ENTITY_RSLT_ID BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;

1103: P_Ref_level In Varchar2,
1104: P_Compute_Score_Flag In Varchar2) Is
1105:
1106: L_PRTN_COPY_ENTITY_RSLT_ID BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1107: L_DELPRTN_COPY_ENTITY_RSLT_ID BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1108: l_Copy_Entity_Rslt_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1109: l_PrtnPrfl_Copy_Entity_Rslt_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1110: l_Object_version_number BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;
1111: l_Prtn_Elig_Ovn BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;

Line 1108: l_Copy_Entity_Rslt_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;

1104: P_Compute_Score_Flag In Varchar2) Is
1105:
1106: L_PRTN_COPY_ENTITY_RSLT_ID BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1107: L_DELPRTN_COPY_ENTITY_RSLT_ID BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1108: l_Copy_Entity_Rslt_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1109: l_PrtnPrfl_Copy_Entity_Rslt_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1110: l_Object_version_number BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;
1111: l_Prtn_Elig_Ovn BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;
1112: l_Prtn_Elig_Prfl_Ovn BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;

Line 1109: l_PrtnPrfl_Copy_Entity_Rslt_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;

1105:
1106: L_PRTN_COPY_ENTITY_RSLT_ID BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1107: L_DELPRTN_COPY_ENTITY_RSLT_ID BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1108: l_Copy_Entity_Rslt_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1109: l_PrtnPrfl_Copy_Entity_Rslt_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1110: l_Object_version_number BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;
1111: l_Prtn_Elig_Ovn BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;
1112: l_Prtn_Elig_Prfl_Ovn BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;
1113: L_PRTN_ELIG_PRFL_ID Ben_Prtn_Elig_Prfl_f.Prtn_Elig_Prfl_Id%TYPE;

Line 1110: l_Object_version_number BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;

1106: L_PRTN_COPY_ENTITY_RSLT_ID BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1107: L_DELPRTN_COPY_ENTITY_RSLT_ID BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1108: l_Copy_Entity_Rslt_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1109: l_PrtnPrfl_Copy_Entity_Rslt_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1110: l_Object_version_number BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;
1111: l_Prtn_Elig_Ovn BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;
1112: l_Prtn_Elig_Prfl_Ovn BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;
1113: L_PRTN_ELIG_PRFL_ID Ben_Prtn_Elig_Prfl_f.Prtn_Elig_Prfl_Id%TYPE;
1114: l_Table_Route_Id BEN_COPY_ENTITY_RESULTS.Table_Route_Id%TYPE;

Line 1111: l_Prtn_Elig_Ovn BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;

1107: L_DELPRTN_COPY_ENTITY_RSLT_ID BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1108: l_Copy_Entity_Rslt_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1109: l_PrtnPrfl_Copy_Entity_Rslt_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1110: l_Object_version_number BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;
1111: l_Prtn_Elig_Ovn BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;
1112: l_Prtn_Elig_Prfl_Ovn BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;
1113: L_PRTN_ELIG_PRFL_ID Ben_Prtn_Elig_Prfl_f.Prtn_Elig_Prfl_Id%TYPE;
1114: l_Table_Route_Id BEN_COPY_ENTITY_RESULTS.Table_Route_Id%TYPE;
1115: L_Table_Name Pqh_Table_Route.Display_Name%TYPE;

Line 1112: l_Prtn_Elig_Prfl_Ovn BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;

1108: l_Copy_Entity_Rslt_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1109: l_PrtnPrfl_Copy_Entity_Rslt_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1110: l_Object_version_number BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;
1111: l_Prtn_Elig_Ovn BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;
1112: l_Prtn_Elig_Prfl_Ovn BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;
1113: L_PRTN_ELIG_PRFL_ID Ben_Prtn_Elig_Prfl_f.Prtn_Elig_Prfl_Id%TYPE;
1114: l_Table_Route_Id BEN_COPY_ENTITY_RESULTS.Table_Route_Id%TYPE;
1115: L_Table_Name Pqh_Table_Route.Display_Name%TYPE;
1116: l_Prtn_Elig_id Pqh_Copy_Entity_Results.Copy_Entity_Result_Id%TYPE;

Line 1114: l_Table_Route_Id BEN_COPY_ENTITY_RESULTS.Table_Route_Id%TYPE;

1110: l_Object_version_number BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;
1111: l_Prtn_Elig_Ovn BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;
1112: l_Prtn_Elig_Prfl_Ovn BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;
1113: L_PRTN_ELIG_PRFL_ID Ben_Prtn_Elig_Prfl_f.Prtn_Elig_Prfl_Id%TYPE;
1114: l_Table_Route_Id BEN_COPY_ENTITY_RESULTS.Table_Route_Id%TYPE;
1115: L_Table_Name Pqh_Table_Route.Display_Name%TYPE;
1116: l_Prtn_Elig_id Pqh_Copy_Entity_Results.Copy_Entity_Result_Id%TYPE;
1117: l_DelPrtn_Elig_id Pqh_Copy_Entity_Results.Copy_Entity_Result_Id%TYPE;
1118: l_InsYN Varchar2(1) := 'N';

Line 1125: l_Ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;

1121: L_PLIP_ID Ben_PLIP_F.Plip_Id%TYPE;
1122: L_OIPL_ID Ben_OIPL_F.Oipl_Id%TYPE;
1123: L_PGM_ID Ben_Pgm_F.Pgm_Id%TYPE;
1124: L_PL_ID Ben_Pl_F.Pl_Id%TYPE;
1125: l_Ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1126: l_Prtn_ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1127: l_DelPrtn_ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1128: L_Prtn_Mirror_result_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1129: l_Pl_Cer_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;

Line 1126: l_Prtn_ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;

1122: L_OIPL_ID Ben_OIPL_F.Oipl_Id%TYPE;
1123: L_PGM_ID Ben_Pgm_F.Pgm_Id%TYPE;
1124: L_PL_ID Ben_Pl_F.Pl_Id%TYPE;
1125: l_Ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1126: l_Prtn_ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1127: l_DelPrtn_ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1128: L_Prtn_Mirror_result_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1129: l_Pl_Cer_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1130: l_Ref_Level Varchar2(5);

Line 1127: l_DelPrtn_ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;

1123: L_PGM_ID Ben_Pgm_F.Pgm_Id%TYPE;
1124: L_PL_ID Ben_Pl_F.Pl_Id%TYPE;
1125: l_Ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1126: l_Prtn_ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1127: l_DelPrtn_ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1128: L_Prtn_Mirror_result_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1129: l_Pl_Cer_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1130: l_Ref_Level Varchar2(5);
1131: l_Count Number;

Line 1128: L_Prtn_Mirror_result_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;

1124: L_PL_ID Ben_Pl_F.Pl_Id%TYPE;
1125: l_Ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1126: l_Prtn_ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1127: l_DelPrtn_ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1128: L_Prtn_Mirror_result_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1129: l_Pl_Cer_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1130: l_Ref_Level Varchar2(5);
1131: l_Count Number;
1132: L_Del_Parent_Entity_Result_Id BEN_COPY_ENTITY_RESULTS.Parent_Entity_Result_Id%TYPE;

Line 1129: l_Pl_Cer_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;

1125: l_Ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1126: l_Prtn_ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1127: l_DelPrtn_ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1128: L_Prtn_Mirror_result_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1129: l_Pl_Cer_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1130: l_Ref_Level Varchar2(5);
1131: l_Count Number;
1132: L_Del_Parent_Entity_Result_Id BEN_COPY_ENTITY_RESULTS.Parent_Entity_Result_Id%TYPE;
1133: L_Del_Cer_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;

Line 1132: L_Del_Parent_Entity_Result_Id BEN_COPY_ENTITY_RESULTS.Parent_Entity_Result_Id%TYPE;

1128: L_Prtn_Mirror_result_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1129: l_Pl_Cer_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1130: l_Ref_Level Varchar2(5);
1131: l_Count Number;
1132: L_Del_Parent_Entity_Result_Id BEN_COPY_ENTITY_RESULTS.Parent_Entity_Result_Id%TYPE;
1133: L_Del_Cer_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1134: l_Dml_Opr Varchar2(30);
1135: L_DML_OPERATION BEN_COPY_ENTITY_RESULTS.DML_OPERATION%TYPE;
1136: L_DML BEN_COPY_ENTITY_RESULTS.DML_OPERATION%TYPE;

Line 1133: L_Del_Cer_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;

1129: l_Pl_Cer_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1130: l_Ref_Level Varchar2(5);
1131: l_Count Number;
1132: L_Del_Parent_Entity_Result_Id BEN_COPY_ENTITY_RESULTS.Parent_Entity_Result_Id%TYPE;
1133: L_Del_Cer_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1134: l_Dml_Opr Varchar2(30);
1135: L_DML_OPERATION BEN_COPY_ENTITY_RESULTS.DML_OPERATION%TYPE;
1136: L_DML BEN_COPY_ENTITY_RESULTS.DML_OPERATION%TYPE;
1137: l_Elp_Cer_id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;

Line 1135: L_DML_OPERATION BEN_COPY_ENTITY_RESULTS.DML_OPERATION%TYPE;

1131: l_Count Number;
1132: L_Del_Parent_Entity_Result_Id BEN_COPY_ENTITY_RESULTS.Parent_Entity_Result_Id%TYPE;
1133: L_Del_Cer_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1134: l_Dml_Opr Varchar2(30);
1135: L_DML_OPERATION BEN_COPY_ENTITY_RESULTS.DML_OPERATION%TYPE;
1136: L_DML BEN_COPY_ENTITY_RESULTS.DML_OPERATION%TYPE;
1137: l_Elp_Cer_id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1138: l_Cer_id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1139: l_Elp_ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;

Line 1136: L_DML BEN_COPY_ENTITY_RESULTS.DML_OPERATION%TYPE;

1132: L_Del_Parent_Entity_Result_Id BEN_COPY_ENTITY_RESULTS.Parent_Entity_Result_Id%TYPE;
1133: L_Del_Cer_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1134: l_Dml_Opr Varchar2(30);
1135: L_DML_OPERATION BEN_COPY_ENTITY_RESULTS.DML_OPERATION%TYPE;
1136: L_DML BEN_COPY_ENTITY_RESULTS.DML_OPERATION%TYPE;
1137: l_Elp_Cer_id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1138: l_Cer_id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1139: l_Elp_ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1140: L_Business_Area Varchar2(255) := 'PQH_GSP_TASK_LIST';

Line 1137: l_Elp_Cer_id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;

1133: L_Del_Cer_Id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1134: l_Dml_Opr Varchar2(30);
1135: L_DML_OPERATION BEN_COPY_ENTITY_RESULTS.DML_OPERATION%TYPE;
1136: L_DML BEN_COPY_ENTITY_RESULTS.DML_OPERATION%TYPE;
1137: l_Elp_Cer_id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1138: l_Cer_id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1139: l_Elp_ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1140: L_Business_Area Varchar2(255) := 'PQH_GSP_TASK_LIST';
1141: l_elp_count number ;

Line 1138: l_Cer_id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;

1134: l_Dml_Opr Varchar2(30);
1135: L_DML_OPERATION BEN_COPY_ENTITY_RESULTS.DML_OPERATION%TYPE;
1136: L_DML BEN_COPY_ENTITY_RESULTS.DML_OPERATION%TYPE;
1137: l_Elp_Cer_id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1138: l_Cer_id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1139: l_Elp_ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1140: L_Business_Area Varchar2(255) := 'PQH_GSP_TASK_LIST';
1141: l_elp_count number ;
1142:

Line 1139: l_Elp_ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;

1135: L_DML_OPERATION BEN_COPY_ENTITY_RESULTS.DML_OPERATION%TYPE;
1136: L_DML BEN_COPY_ENTITY_RESULTS.DML_OPERATION%TYPE;
1137: l_Elp_Cer_id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1138: l_Cer_id BEN_COPY_ENTITY_RESULTS.Copy_Entity_Result_Id%TYPE;
1139: l_Elp_ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1140: L_Business_Area Varchar2(255) := 'PQH_GSP_TASK_LIST';
1141: l_elp_count number ;
1142:
1143: Cursor BusArea is

Line 1156: from Ben_Copy_Entity_Results

1152: Where table_alias = p_table_alias;
1153:
1154: Cursor Ovn is
1155: Select object_version_Number
1156: from Ben_Copy_Entity_Results
1157: where Copy_Entity_Result_id = l_Copy_Entity_Rslt_Id;
1158:
1159: Cursor Csr_Dml_Operation(p_elp_id In number) is
1160: Select DML_OPERATION,copy_entity_result_id

Line 1161: from Ben_Copy_Entity_Results

1157: where Copy_Entity_Result_id = l_Copy_Entity_Rslt_Id;
1158:
1159: Cursor Csr_Dml_Operation(p_elp_id In number) is
1160: Select DML_OPERATION,copy_entity_result_id
1161: from Ben_Copy_Entity_Results
1162: where Information1 = p_elp_id
1163: and table_alias = 'ELP'
1164: and copy_entity_txn_id = p_copy_entity_txn_id;
1165:

Line 1168: from Ben_Copy_Entity_Results

1164: and copy_entity_txn_id = p_copy_entity_txn_id;
1165:
1166: Cursor Prtn(P_Mirror_result_Id In Number) Is
1167: Select Information1, Copy_Entity_Result_Id, Object_version_NUmber, DML_OPERATION
1168: from Ben_Copy_Entity_Results
1169: where Copy_Entity_Txn_Id = p_Copy_Entity_txn_Id
1170: and GS_MIRROR_SRC_ENTITY_RESULT_ID = P_Mirror_result_Id
1171: and Table_alias = 'EPA'
1172: and Nvl(Dml_operation,'XX') <> 'DELETE';

Line 1177: From BEN_Copy_Entity_Results CEP,

1173:
1174: Cursor PrtnElig Is
1175: Select Cep.Copy_Entity_Result_id, Cep.Object_version_Number,
1176: Elp.Copy_Entity_Result_id, Elp.Object_Version_Number
1177: From BEN_Copy_Entity_Results CEP,
1178: Ben_Copy_Entity_Results ELP
1179: Where Elp.Copy_Entity_Txn_Id = p_Copy_Entity_txn_Id
1180: and elp.Table_alias = 'ELP'
1181: and elp.Gs_Parent_Entity_Result_Id = P_gs_Parent_Entity_Result_Id

Line 1178: Ben_Copy_Entity_Results ELP

1174: Cursor PrtnElig Is
1175: Select Cep.Copy_Entity_Result_id, Cep.Object_version_Number,
1176: Elp.Copy_Entity_Result_id, Elp.Object_Version_Number
1177: From BEN_Copy_Entity_Results CEP,
1178: Ben_Copy_Entity_Results ELP
1179: Where Elp.Copy_Entity_Txn_Id = p_Copy_Entity_txn_Id
1180: and elp.Table_alias = 'ELP'
1181: and elp.Gs_Parent_Entity_Result_Id = P_gs_Parent_Entity_Result_Id
1182: and Elp.Gs_Mirror_Src_Entity_Result_id = Cep.Copy_Entity_Result_id

Line 1188: From Ben_Copy_Entity_Results Plan

1184: and Nvl(Cep.Dml_Operation,'XX') <> 'DELETE';
1185:
1186: Cursor Plip_Dtls is
1187: Select Plan.Copy_Entity_Result_Id
1188: From Ben_Copy_Entity_Results Plan
1189: where PLan.Gs_Mirror_Src_Entity_Result_id = P_Gs_Parent_Entity_Result_Id
1190: and Plan.table_Alias = 'PLN'
1191: and plan.copy_entity_txn_id = p_copy_entity_txn_id;
1192:

Line 1195: from Ben_Copy_Entity_Results Prtn,

1191: and plan.copy_entity_txn_id = p_copy_entity_txn_id;
1192:
1193: Cursor PrflCnt(P_Parent_Entity_Result_Id In Number) is
1194: Select Count(*)
1195: from Ben_Copy_Entity_Results Prtn,
1196: Ben_Copy_Entity_Results PrtnElig
1197: where Prtn.Copy_Entity_Txn_Id = p_Copy_Entity_txn_Id
1198: and Prtn.GS_Mirror_Src_ENTITY_RESULT_ID = P_Parent_Entity_Result_Id
1199: and Prtn.Table_alias = 'EPA'

Line 1196: Ben_Copy_Entity_Results PrtnElig

1192:
1193: Cursor PrflCnt(P_Parent_Entity_Result_Id In Number) is
1194: Select Count(*)
1195: from Ben_Copy_Entity_Results Prtn,
1196: Ben_Copy_Entity_Results PrtnElig
1197: where Prtn.Copy_Entity_Txn_Id = p_Copy_Entity_txn_Id
1198: and Prtn.GS_Mirror_Src_ENTITY_RESULT_ID = P_Parent_Entity_Result_Id
1199: and Prtn.Table_alias = 'EPA'
1200: and PrtnElig.Copy_Entity_Txn_Id = Prtn.Copy_Entity_Txn_Id

Line 1206: from Ben_Copy_Entity_Results

1202: and PrtnElig.INFORMATION263 <> P_Prfl_Id;
1203:
1204: Cursor Csr_is_elp_present(p_elp_id In number) is
1205: Select Count(*)
1206: from Ben_Copy_Entity_Results
1207: where Information1 = p_elp_id
1208: and table_alias = 'ELP'
1209: and copy_entity_txn_id = p_copy_entity_txn_id;
1210:

Line 1309: Ben_Copy_Entity_Results_Api.DELETE_COPY_ENTITY_RESULTS

1305: l_Dml_Opr := NULL;
1306: L_Dml_Opr := Get_Dml_Operation(l_PrtnPrfl_Copy_Entity_Rslt_Id, 'D');
1307:
1308: if L_Dml_Opr = 'PURGE' then
1309: Ben_Copy_Entity_Results_Api.DELETE_COPY_ENTITY_RESULTS
1310: (P_COPY_ENTITY_RESULT_ID => l_PrtnPrfl_Copy_Entity_Rslt_Id,
1311: P_OBJECT_VERSION_NUMBER => l_Prtn_Elig_Prfl_ovn,
1312: P_EFFECTIVE_DATE => P_Effective_Date);
1313: Else

Line 1314: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS

1310: (P_COPY_ENTITY_RESULT_ID => l_PrtnPrfl_Copy_Entity_Rslt_Id,
1311: P_OBJECT_VERSION_NUMBER => l_Prtn_Elig_Prfl_ovn,
1312: P_EFFECTIVE_DATE => P_Effective_Date);
1313: Else
1314: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS
1315: (P_EFFECTIVE_DATE => P_Effective_Date,
1316: P_COPY_ENTITY_TXN_ID => p_Copy_Entity_txn_Id,
1317: P_DML_OPERATION => 'DELETE',
1318: P_INFORMATION323 => NULL,

Line 1330: Ben_Copy_Entity_Results_Api.DELETE_COPY_ENTITY_RESULTS

1326: l_Dml_Opr := NULL;
1327: L_Dml_Opr := Get_Dml_Operation(l_DelPrtn_Copy_Entity_Rslt_Id, 'D');
1328:
1329: If L_Dml_Opr = 'PURGE' then
1330: Ben_Copy_Entity_Results_Api.DELETE_COPY_ENTITY_RESULTS
1331: (P_COPY_ENTITY_RESULT_ID => l_DelPrtn_Copy_Entity_Rslt_Id,
1332: P_OBJECT_VERSION_NUMBER => l_DelPrtn_ovn,
1333: P_EFFECTIVE_DATE => P_Effective_Date);
1334: Else

Line 1335: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS

1331: (P_COPY_ENTITY_RESULT_ID => l_DelPrtn_Copy_Entity_Rslt_Id,
1332: P_OBJECT_VERSION_NUMBER => l_DelPrtn_ovn,
1333: P_EFFECTIVE_DATE => P_Effective_Date);
1334: Else
1335: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS
1336: (P_EFFECTIVE_DATE => P_Effective_Date,
1337: P_COPY_ENTITY_TXN_ID => p_Copy_Entity_txn_Id,
1338: P_DML_OPERATION => 'DELETE',
1339: P_INFORMATION323 => NULL,

Line 1358: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS

1354: Fetch Prtn into l_Prtn_Elig_id, l_Prtn_Copy_Entity_Rslt_Id, l_Prtn_ovn, L_DML_OPERATION;
1355: If Prtn%FOUND Then
1356: l_InsYN := 'N';
1357: If L_DML_OPERATION = 'DELETE' Then
1358: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS
1359: (P_EFFECTIVE_DATE => P_Effective_Date,
1360: P_COPY_ENTITY_TXN_ID => p_Copy_Entity_txn_Id,
1361: P_COPY_ENTITY_RESULT_ID => l_Prtn_Copy_Entity_Rslt_Id,
1362: P_DML_OPeration => 'UPDATE',

Line 1392: update ben_copy_entity_results

1388: p_copy_entity_txn_id => p_Copy_Entity_txn_Id
1389: ,p_business_group_id => P_Business_Group_Id
1390: ,p_eligy_prfl_id => P_Prfl_Id
1391: );
1392: update ben_copy_entity_results
1393: set gs_parent_entity_result_id = P_gs_Parent_Entity_Result_Id
1394: ,parent_entity_result_id = P_gs_Parent_Entity_Result_Id
1395: where copy_entity_result_id = l_Copy_Entity_Rslt_Id;
1396: else

Line 1421: Ben_Copy_Entity_Results_Api.CREATE_COPY_ENTITY_RESULTS

1417:
1418: /* This Insert Links the Ben Object with the Eligibility Profiles (CEP) */
1419: hr_utility.set_location('Inserting EPA .. L_Prtn_Mirror_result_Id ' || L_Prtn_Mirror_result_Id , 80);
1420:
1421: Ben_Copy_Entity_Results_Api.CREATE_COPY_ENTITY_RESULTS
1422: (P_EFFECTIVE_DATE => P_Effective_Date,
1423: P_COPY_ENTITY_TXN_ID => p_Copy_Entity_txn_Id,
1424: P_RESULT_TYPE_CD => 'DISPLAY',
1425: P_NUMBER_OF_COPIES => 1,

Line 1457: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS

1453:
1454: If PrtnElig%FOUND Then
1455: hr_utility.set_location('Inserting CEP ..l_Prtn_Copy_Entity_Rslt_Id ' || l_Prtn_Copy_Entity_Rslt_Id , 90);
1456:
1457: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS
1458: (P_EFFECTIVE_DATE => P_Effective_Date,
1459: P_COPY_ENTITY_TXN_ID => p_Copy_Entity_txn_Id,
1460: P_RESULT_TYPE_CD => 'DISPLAY',
1461: P_NUMBER_OF_COPIES => 1,

Line 1486: Ben_Copy_Entity_Results_Api.CREATE_COPY_ENTITY_RESULTS

1482: Else
1483:
1484: hr_utility.set_location('Updating CEP ..l_Prtn_Copy_Entity_Rslt_Id ' || l_Prtn_Copy_Entity_Rslt_Id , 90);
1485:
1486: Ben_Copy_Entity_Results_Api.CREATE_COPY_ENTITY_RESULTS
1487: (P_EFFECTIVE_DATE => P_Effective_Date,
1488: P_COPY_ENTITY_TXN_ID => p_Copy_Entity_txn_Id,
1489: P_RESULT_TYPE_CD => 'DISPLAY',
1490: P_NUMBER_OF_COPIES => 1,

Line 1512: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS

1508: P_GS_MR_SRC_ENTITY_RESULT_ID => l_Prtn_Copy_Entity_Rslt_Id,
1509: P_OBJECT_VERSION_NUMBER => l_Prtn_Elig_Prfl_Ovn);
1510:
1511: If p_Txn_Mode <> 'I' Then
1512: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS
1513: (P_EFFECTIVE_DATE => P_Effective_Date,
1514: P_COPY_ENTITY_TXN_ID => p_Copy_Entity_txn_Id,
1515: P_Gs_Parent_Entity_Result_Id => P_Gs_Parent_Entity_Result_Id,
1516: P_GS_MR_SRC_ENTITY_RESULT_ID => l_PrtnPrfl_Copy_Entity_Rslt_Id,

Line 1534: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS

1530: Open ovn;
1531: Fetch ovn into l_ovn;
1532: Close ovn;
1533:
1534: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS
1535: (P_EFFECTIVE_DATE => P_Effective_Date,
1536: P_COPY_ENTITY_TXN_ID => p_Copy_Entity_txn_Id,
1537: P_Gs_Parent_Entity_Result_Id => P_Gs_Parent_Entity_Result_Id,
1538: P_GS_MR_SRC_ENTITY_RESULT_ID => l_PrtnPrfl_Copy_Entity_Rslt_Id,

Line 1573: L_Cep_Cer_Id Ben_Copy_Entity_Results.Copy_Entity_Result_Id%TYPE;

1569: Procedure Delete_Eligibility
1570: (P_Copy_Entity_txn_id IN Number
1571: ,P_Copy_Entity_result_id IN NUmber) Is
1572:
1573: L_Cep_Cer_Id Ben_Copy_Entity_Results.Copy_Entity_Result_Id%TYPE;
1574: L_Cep_Ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1575: L_Epa_Cer_Id Ben_Copy_Entity_Results.Copy_Entity_Result_Id%TYPE;
1576: L_Epa_Ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1577: L_Dml_Opr Varchar2(30);

Line 1574: L_Cep_Ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;

1570: (P_Copy_Entity_txn_id IN Number
1571: ,P_Copy_Entity_result_id IN NUmber) Is
1572:
1573: L_Cep_Cer_Id Ben_Copy_Entity_Results.Copy_Entity_Result_Id%TYPE;
1574: L_Cep_Ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1575: L_Epa_Cer_Id Ben_Copy_Entity_Results.Copy_Entity_Result_Id%TYPE;
1576: L_Epa_Ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1577: L_Dml_Opr Varchar2(30);
1578: L_EligPrfl_ID Ben_Eligy_Prfl_f.Eligy_Prfl_Id%TYPE;

Line 1575: L_Epa_Cer_Id Ben_Copy_Entity_Results.Copy_Entity_Result_Id%TYPE;

1571: ,P_Copy_Entity_result_id IN NUmber) Is
1572:
1573: L_Cep_Cer_Id Ben_Copy_Entity_Results.Copy_Entity_Result_Id%TYPE;
1574: L_Cep_Ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1575: L_Epa_Cer_Id Ben_Copy_Entity_Results.Copy_Entity_Result_Id%TYPE;
1576: L_Epa_Ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1577: L_Dml_Opr Varchar2(30);
1578: L_EligPrfl_ID Ben_Eligy_Prfl_f.Eligy_Prfl_Id%TYPE;
1579: L_Cnt Number(15);

Line 1576: L_Epa_Ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;

1572:
1573: L_Cep_Cer_Id Ben_Copy_Entity_Results.Copy_Entity_Result_Id%TYPE;
1574: L_Cep_Ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1575: L_Epa_Cer_Id Ben_Copy_Entity_Results.Copy_Entity_Result_Id%TYPE;
1576: L_Epa_Ovn Ben_Copy_Entity_Results.Object_Version_Number%TYPE;
1577: L_Dml_Opr Varchar2(30);
1578: L_EligPrfl_ID Ben_Eligy_Prfl_f.Eligy_Prfl_Id%TYPE;
1579: L_Cnt Number(15);
1580:

Line 1583: from Ben_Copy_Entity_Results

1579: L_Cnt Number(15);
1580:
1581: Cursor Del_Elp is
1582: Select Copy_Entity_Result_Id, Object_Version_Number
1583: from Ben_Copy_Entity_Results
1584: where Copy_Entity_txn_Id = P_Copy_Entity_Txn_Id
1585: Start With Copy_Entity_Result_Id = P_Copy_Entity_Result_Id
1586: Connect By Gs_Parent_Entity_Result_Id = Prior Copy_Entity_Result_Id;
1587:

Line 1590: From Ben_Copy_Entity_results

1586: Connect By Gs_Parent_Entity_Result_Id = Prior Copy_Entity_Result_Id;
1587:
1588: Cursor Cep_id is
1589: Select Gs_Mirror_Src_Entity_Result_id, INFORMATION1
1590: From Ben_Copy_Entity_results
1591: Where Copy_Entity_Result_Id = P_Copy_Entity_result_id;
1592:
1593: Cursor EPA_Id is
1594: Select Gs_Mirror_Src_Entity_Result_id

Line 1595: from Ben_Copy_Entity_Results

1591: Where Copy_Entity_Result_Id = P_Copy_Entity_result_id;
1592:
1593: Cursor EPA_Id is
1594: Select Gs_Mirror_Src_Entity_Result_id
1595: from Ben_Copy_Entity_Results
1596: Where Copy_Entity_Result_Id = L_Cep_Cer_Id;
1597:
1598: Cursor Ovn_Dtls (P_Cer_id IN Number) Is
1599: Select Object_Version_Number

Line 1600: From Ben_Copy_Entity_Results

1596: Where Copy_Entity_Result_Id = L_Cep_Cer_Id;
1597:
1598: Cursor Ovn_Dtls (P_Cer_id IN Number) Is
1599: Select Object_Version_Number
1600: From Ben_Copy_Entity_Results
1601: Where Copy_Entity_Result_Id = P_Cer_id;
1602:
1603: Begin
1604:

Line 1622: from Ben_Copy_Entity_Results Prtn,

1618: Fetch Ovn_Dtls into L_Epa_Ovn;
1619: Close Ovn_Dtls;
1620:
1621: Select Count(*) into L_Cnt
1622: from Ben_Copy_Entity_Results Prtn,
1623: Ben_Copy_Entity_Results PrtnElig
1624: where Prtn.Copy_Entity_Txn_Id = p_Copy_Entity_txn_Id
1625: and Prtn.Copy_ENTITY_RESULT_ID = L_Epa_Cer_Id
1626: and Prtn.Table_alias = 'EPA'

Line 1623: Ben_Copy_Entity_Results PrtnElig

1619: Close Ovn_Dtls;
1620:
1621: Select Count(*) into L_Cnt
1622: from Ben_Copy_Entity_Results Prtn,
1623: Ben_Copy_Entity_Results PrtnElig
1624: where Prtn.Copy_Entity_Txn_Id = p_Copy_Entity_txn_Id
1625: and Prtn.Copy_ENTITY_RESULT_ID = L_Epa_Cer_Id
1626: and Prtn.Table_alias = 'EPA'
1627: and PrtnElig.Copy_Entity_Txn_Id = Prtn.Copy_Entity_Txn_Id

Line 1636: Ben_Copy_Entity_Results_Api.DELETE_COPY_ENTITY_RESULTS

1632: If L_Cnt = 0 then
1633: L_Dml_Opr := Get_Dml_Operation(L_Epa_Cer_Id, 'D');
1634:
1635: If L_Dml_Opr = 'PURGE' then
1636: Ben_Copy_Entity_Results_Api.DELETE_COPY_ENTITY_RESULTS
1637: (P_COPY_ENTITY_RESULT_ID => L_Epa_Cer_Id,
1638: P_OBJECT_VERSION_NUMBER => L_Epa_Ovn,
1639: P_EFFECTIVE_DATE => Trunc(Sysdate));
1640: Else

Line 1641: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS

1637: (P_COPY_ENTITY_RESULT_ID => L_Epa_Cer_Id,
1638: P_OBJECT_VERSION_NUMBER => L_Epa_Ovn,
1639: P_EFFECTIVE_DATE => Trunc(Sysdate));
1640: Else
1641: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS
1642: (P_EFFECTIVE_DATE => Trunc(Sysdate),
1643: P_COPY_ENTITY_TXN_ID => p_Copy_Entity_txn_Id,
1644: P_DML_OPERATION => 'DELETE',
1645: P_INFORMATION323 => NULL,

Line 1655: Ben_Copy_Entity_Results_Api.DELETE_COPY_ENTITY_RESULTS

1651: l_Dml_opr := NULL;
1652: L_Dml_Opr := Get_Dml_Operation(L_Cep_Cer_Id, 'D');
1653:
1654: If L_Dml_Opr = 'PURGE' then
1655: Ben_Copy_Entity_Results_Api.DELETE_COPY_ENTITY_RESULTS
1656: (P_COPY_ENTITY_RESULT_ID => L_Cep_Cer_Id,
1657: P_OBJECT_VERSION_NUMBER => L_Cep_Ovn,
1658: P_EFFECTIVE_DATE => Trunc(Sysdate));
1659: Else

Line 1660: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS

1656: (P_COPY_ENTITY_RESULT_ID => L_Cep_Cer_Id,
1657: P_OBJECT_VERSION_NUMBER => L_Cep_Ovn,
1658: P_EFFECTIVE_DATE => Trunc(Sysdate));
1659: Else
1660: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS
1661: (P_EFFECTIVE_DATE => Trunc(Sysdate),
1662: P_COPY_ENTITY_TXN_ID => p_Copy_Entity_txn_Id,
1663: P_DML_OPERATION => 'DELETE',
1664: P_INFORMATION323 => NULL,

Line 1671: Ben_Copy_Entity_Results_Api.DELETE_COPY_ENTITY_RESULTS

1667: End If;
1668:
1669: For Del_Elp_rec in Del_Elp
1670: Loop
1671: Ben_Copy_Entity_Results_Api.DELETE_COPY_ENTITY_RESULTS
1672: (P_COPY_ENTITY_RESULT_ID => Del_Elp_rec.Copy_Entity_result_id,
1673: P_OBJECT_VERSION_NUMBER => Del_Elp_rec.Object_version_number,
1674: P_EFFECTIVE_DATE => Trunc(Sysdate));
1675: End Loop;

Line 1693: from ben_copy_entity_results

1689:
1690: Cursor csr_elp_orignal_in_stage
1691: is
1692: select null
1693: from ben_copy_entity_results
1694: where copy_entity_txn_id = p_copy_entity_txn_id
1695: and table_alias = 'ELP'
1696: and information1 = p_eligy_prfl_id;
1697:

Line 1745: update ben_copy_entity_results a

1741: -- attribute FUTURE_DATA_EXISTS properly set so that they can properly
1742: -- set the datetrack_mode and dml_operation
1743: -- The following code is copied from BEN_PDW_COPY_BEN_TO_STG.mark_future_data_exists
1744:
1745: update ben_copy_entity_results a
1746: set future_data_exists ='Y'
1747: where a.copy_entity_txn_id = p_copy_entity_txn_id
1748: and a.future_data_exists is null
1749: and a.information3 < to_date('4712/12/31','YYYY/MM/DD')

Line 1751: ( select 'Y' from ben_copy_entity_results b

1747: where a.copy_entity_txn_id = p_copy_entity_txn_id
1748: and a.future_data_exists is null
1749: and a.information3 < to_date('4712/12/31','YYYY/MM/DD')
1750: and exists
1751: ( select 'Y' from ben_copy_entity_results b
1752: where b.copy_entity_txn_id = a.copy_entity_txn_id
1753: and b.table_alias = a.table_alias
1754: and b.information1 = a.information1
1755: and b.information2 = a.information3+1);

Line 1769: update ben_copy_entity_results

1765: is
1766: l_rows number;
1767: begin
1768: hr_utility.set_location('Inside upd_alias_of_dup',10);
1769: update ben_copy_entity_results
1770: set table_alias = table_alias||'-DUP'
1771: where copy_entity_txn_id = p_copy_entity_txn_id
1772: and information1 is null
1773: and table_alias in ('ELP'

Line 1795: update ben_copy_entity_results

1791: is
1792: l_rows number;
1793: begin
1794: hr_utility.set_location('Inside reset_alias_of_dup',10);
1795: update ben_copy_entity_results
1796: set table_alias = replace(table_alias,'-DUP',null)
1797: where copy_entity_txn_id = p_copy_entity_txn_id
1798: and information1 is null;
1799:

Line 1814: from ben_copy_entity_results

1810:
1811: -- get all Derieved factor records
1812: cursor cur_drv_fctr is
1813: select information101, copy_entity_result_id
1814: from ben_copy_entity_results
1815: where table_alias in ('AGF','CLA','CLF','HWF','LSF','PFF','SVA','RZR','BNG','EGL' )
1816: and copy_entity_txn_id = p_copy_entity_txn_id
1817: and (information1 is null or information1 = information101)
1818: and information101 is not null

Line 1834: update ben_copy_entity_results

1830: -- update all but one
1831: if (rec_drv_fctr.information101 <> prev_info101)
1832: then
1833:
1834: update ben_copy_entity_results
1835: set information1 = information101
1836: where copy_entity_result_id = rec_drv_fctr.copy_entity_result_id;
1837:
1838: end if;