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_UTILITY dependencies on BEN_COPY_ENTITY_RESULTS

Line 29: from ben_copy_entity_results

25: then
26: begin
27: select information308
28: into l_plan_type_date
29: from ben_copy_entity_results
30: where copy_entity_txn_id = p_copy_entity_txn_id
31: and table_alias = 'PGM';
32: hr_utility.set_location('Plan Type date is :'|| l_plan_type_date, 30);
33: exception

Line 74: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_result_id%TYPE

70: --
71:
72: FUNCTION chk_grade_exist_in_gl
73: (
74: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_result_id%TYPE
75: )
76: RETURN VARCHAR2 IS
77: /*
78: Author : mvankada

Line 92: From ben_copy_entity_results

88:
89: CURSOR csr_grade_in_gl
90: IS
91: Select copy_entity_result_id
92: From ben_copy_entity_results
93: Where Copy_Entity_Txn_Id = p_copy_entity_txn_id
94: AND Table_Alias = 'CPP'
95: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
96: AND nvl(Information104,'PPP') <> 'UNLINK';

Line 126: p_Grade_Result_Id IN ben_copy_entity_results.copy_entity_result_id%TYPE,

122: --
123:
124: Procedure remove_grade_from_grdldr
125: (
126: p_Grade_Result_Id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
127: p_Copy_Entity_Txn_Id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,
128: p_Business_Group_Id IN Number,
129: p_Effective_Date IN Date,
130: p_Rec_Exists OUT NOCOPY Varchar2

Line 127: p_Copy_Entity_Txn_Id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,

123:
124: Procedure remove_grade_from_grdldr
125: (
126: p_Grade_Result_Id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
127: p_Copy_Entity_Txn_Id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,
128: p_Business_Group_Id IN Number,
129: p_Effective_Date IN Date,
130: p_Rec_Exists OUT NOCOPY Varchar2
131: ) IS

Line 149: l_grade_name Ben_Copy_Entity_Results.Information5%Type;

145: l_pgm_id Number;
146: l_grade_id Number;
147: l_assg_id Number;
148: l_dummy Char(1);
149: l_grade_name Ben_Copy_Entity_Results.Information5%Type;
150: l_proc varchar2(72) := g_package||'remove_grade_from_grdldr';
151: l_message_type varchar2(10) := 'W';
152: l_warnings_rec pqh_utility.warnings_rec;
153: l_business_area varchar2(50) := 'PQH_GSP_TASK_LIST';

Line 162: From Ben_Copy_Entity_Results grdldr

158: -- To Get Pgm_Id of PGM based on Txn_id
159: Cursor csr_pgm_id
160: IS
161: Select grdldr.Information1
162: From Ben_Copy_Entity_Results grdldr
163: Where grdldr.Table_Alias = 'PGM'
164: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
165: And grdldr.Copy_Entity_Txn_Id = p_Copy_Entity_Txn_Id
166: And Information4 = p_Business_Group_Id;

Line 173: From Ben_Copy_Entity_Results grdldr

169:
170: Cursor csr_corps_id
171: IS
172: Select grdldr.Information1
173: From Ben_Copy_Entity_Results grdldr
174: Where grdldr.Table_Alias = 'CPD'
175: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
176: And grdldr.Copy_Entity_Txn_Id = p_Copy_Entity_Txn_Id
177: And Information4 = p_Business_Group_Id;

Line 186: From Ben_Copy_Entity_Results grd

182: Cursor csr_grade_id
183: IS
184: Select grd.Information253,
185: grd.Information5
186: From Ben_Copy_Entity_Results grd
187: Where grd.Table_Alias = 'CPP'
188: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
189: And grd.Copy_Entity_Result_Id = p_Grade_Result_Id;
190:

Line 391: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

387: if p_gsp_node = '1' then
388: st_icon := 'Y';
389: else
390: select nvl(pa.decode_function_name, '99') into prev_task from
391: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
392: where
393: bcer.table_route_id = ptr.table_route_id
394: and ptr.table_route_id = pa.master_table_route_id
395: and ptr.table_alias = l_table_alias

Line 447: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

443:
444: End If;
445: if p_gsp_node = '1' then
446: select bcer.information100 into st_icon from
447: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
448: where
449: bcer.table_route_id = ptr.table_route_id
450: and ptr.table_route_id = pa.master_table_route_id
451: and ptr.table_alias = l_table_alias

Line 456: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

452: and pa.attribute_name = p_gsp_node
453: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
454: elsif p_gsp_node = '2' then
455: select bcer.information101 into st_icon from
456: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
457: where
458: bcer.table_route_id = ptr.table_route_id
459: and ptr.table_route_id = pa.master_table_route_id
460: and ptr.table_alias = l_table_alias

Line 465: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

461: and pa.attribute_name = p_gsp_node
462: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
463: elsif p_gsp_node = '3' then
464: select bcer.information102 into st_icon from
465: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
466: where
467: bcer.table_route_id = ptr.table_route_id
468: and ptr.table_route_id = pa.master_table_route_id
469: and ptr.table_alias = l_table_alias

Line 474: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

470: and pa.attribute_name = p_gsp_node
471: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
472: elsif p_gsp_node = '4'then
473: select bcer.information103 into st_icon from
474: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
475: where
476: bcer.table_route_id = ptr.table_route_id
477: and ptr.table_route_id = pa.master_table_route_id
478: and ptr.table_alias = l_table_alias

Line 483: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

479: and pa.attribute_name = p_gsp_node
480: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
481: elsif p_gsp_node = '5' then
482: select bcer.information104 into st_icon from
483: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
484: where
485: bcer.table_route_id = ptr.table_route_id
486: and ptr.table_route_id = pa.master_table_route_id
487: and ptr.table_alias = l_table_alias

Line 492: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

488: and pa.attribute_name = p_gsp_node
489: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
490: elsif p_gsp_node = '6' then
491: select bcer.information105 into st_icon from
492: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
493: where
494: bcer.table_route_id = ptr.table_route_id
495: and ptr.table_route_id = pa.master_table_route_id
496: and ptr.table_alias = l_table_alias

Line 501: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

497: and pa.attribute_name = p_gsp_node
498: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
499: elsif p_gsp_node = '7' then
500: select bcer.information106 into st_icon from
501: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
502: where
503: bcer.table_route_id = ptr.table_route_id
504: and ptr.table_route_id = pa.master_table_route_id
505: and ptr.table_alias = l_table_alias

Line 539: FROM Ben_Copy_Entity_Results grdldr

535:
536: Cursor csr_use_points
537: IS
538: Select Decode(nvl(grdldr.INFORMATION18,'N'),'Y','POINT','STEP') /* INFORMATION18 -> Use Progression Points */
539: FROM Ben_Copy_Entity_Results grdldr
540: WHERE grdldr.Copy_Entity_Txn_Id = p_copy_entity_txn_id
541: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
542: AND grdldr.Table_Alias = 'PGM';
543:

Line 577: p_step_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,

573: ---------------------------remove_step_from_grade-----------------------------
574: --
575: Procedure remove_step_from_grade
576: (
577: p_step_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
578: p_copy_entity_txn_id IN number,
579: p_effective_date IN Date,
580: p_use_points IN varchar2,
581: p_step_id IN ben_copy_entity_results.information1%TYPE,

Line 581: p_step_id IN ben_copy_entity_results.information1%TYPE,

577: p_step_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
578: p_copy_entity_txn_id IN number,
579: p_effective_date IN Date,
580: p_use_points IN varchar2,
581: p_step_id IN ben_copy_entity_results.information1%TYPE,
582: p_celing_step_flag IN varchar2,
583: p_rec_exists OUT NOCOPY Varchar2
584: ) IS
585:

Line 618: From Ben_Copy_Entity_Results grdldr

614: -- To Get information1 (Pgm_ID) of PGM, based on TXN_ID
615: Cursor csr_pgm_id
616: IS
617: Select grdldr.information1 -- PGM_ID
618: From Ben_Copy_Entity_Results grdldr
619: Where grdldr.Copy_Entity_Txn_Id = p_copy_entity_txn_id
620: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
621: AND grdldr.Table_Alias = 'PGM';
622:

Line 628: From Ben_Copy_Entity_Results grdldr

624:
625: Cursor csr_corps_id
626: IS
627: Select grdldr.Information1
628: From Ben_Copy_Entity_Results grdldr
629: Where grdldr.Table_Alias = 'CPD'
630: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
631: And grdldr.Copy_Entity_Txn_Id = p_Copy_Entity_Txn_Id;
632:

Line 637: From Ben_Copy_Entity_Results grd

633: -- To Get information253 (Grade_id) of CPP, based on Step Result Id
634: Cursor csr_grade_id
635: IS
636: Select grd.information253
637: From Ben_Copy_Entity_Results grd
638: Where grd.Table_Alias = 'CPP'
639: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
640: AND grd.copy_entity_result_id = (Select step.gs_parent_entity_result_id
641: From Ben_Copy_Entity_Results step

Line 641: From Ben_Copy_Entity_Results step

637: From Ben_Copy_Entity_Results grd
638: Where grd.Table_Alias = 'CPP'
639: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
640: AND grd.copy_entity_result_id = (Select step.gs_parent_entity_result_id
641: From Ben_Copy_Entity_Results step
642: Where step.Copy_Entity_Result_Id= p_step_result_id
643: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
644: AND step.Table_Alias = 'COP');
645:

Line 754: ( p_copy_entity_result_id IN Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type,

750: ---------------------------CHK_PROFILE_EXISTS-----------------------------
751: --
752:
753: FUNCTION CHK_PROFILE_EXISTS
754: ( p_copy_entity_result_id IN Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type,
755: p_copy_entity_txn_id IN Ben_Copy_Entity_Results.Copy_Entity_Txn_Id%Type
756: )
757: RETURN varchar2 IS
758:

Line 755: p_copy_entity_txn_id IN Ben_Copy_Entity_Results.Copy_Entity_Txn_Id%Type

751: --
752:
753: FUNCTION CHK_PROFILE_EXISTS
754: ( p_copy_entity_result_id IN Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type,
755: p_copy_entity_txn_id IN Ben_Copy_Entity_Results.Copy_Entity_Txn_Id%Type
756: )
757: RETURN varchar2 IS
758:
759: /* Author : mvankada

Line 767: From Ben_Copy_Entity_Results

763:
764: Cursor csr_profile_count
765: IS
766: Select '1'
767: From Ben_Copy_Entity_Results
768: Where Table_Alias = 'ELP'
769: And Gs_Parent_Entity_Result_Id = p_Copy_Entity_Result_Id
770: And Copy_Entity_Txn_Id = p_copy_entity_txn_id
771: And Result_type_Cd = 'DISPLAY'

Line 811: p_Table_Alias IN Ben_Copy_Entity_Results.Table_Alias%Type,

807: --
808:
809: FUNCTION DISPLAY_ICON
810: (p_page IN Varchar2,
811: p_Table_Alias IN Ben_Copy_Entity_Results.Table_Alias%Type,
812: p_action IN Varchar2,
813: p_copy_entity_txn_id IN Ben_Copy_Entity_Results.Copy_Entity_Txn_Id%Type,
814: p_copy_entity_result_id IN Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type
815: ) RETURN varchar2

Line 813: p_copy_entity_txn_id IN Ben_Copy_Entity_Results.Copy_Entity_Txn_Id%Type,

809: FUNCTION DISPLAY_ICON
810: (p_page IN Varchar2,
811: p_Table_Alias IN Ben_Copy_Entity_Results.Table_Alias%Type,
812: p_action IN Varchar2,
813: p_copy_entity_txn_id IN Ben_Copy_Entity_Results.Copy_Entity_Txn_Id%Type,
814: p_copy_entity_result_id IN Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type
815: ) RETURN varchar2
816: IS
817:

Line 814: p_copy_entity_result_id IN Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type

810: (p_page IN Varchar2,
811: p_Table_Alias IN Ben_Copy_Entity_Results.Table_Alias%Type,
812: p_action IN Varchar2,
813: p_copy_entity_txn_id IN Ben_Copy_Entity_Results.Copy_Entity_Txn_Id%Type,
814: p_copy_entity_result_id IN Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type
815: ) RETURN varchar2
816: IS
817:
818: /*

Line 849: From Ben_COpy_Entity_Results

845:
846: Cursor Csr_steps_exists
847: IS
848: Select Null
849: From Ben_COpy_Entity_Results
850: Where Gs_Parent_Entity_Result_Id = p_copy_entity_result_id
851: And table_alias ='COP'
852: And Copy_Entity_Txn_Id = p_copy_entity_txn_id
853: And result_type_cd = 'DISPLAY'

Line 1063: From Ben_Copy_Entity_Results oipl

1059: IS
1060: Select oipl.Information262, -- Point Cer Id
1061: oipl.Information259, -- Pay Scale Cer Id
1062: oipl.Gs_Parent_Entity_Result_id -- Grade Cer_id
1063: From Ben_Copy_Entity_Results oipl
1064: Where oipl.Copy_Entity_Result_Id = p_copy_entity_result_id
1065: And oipl.Copy_Entity_Txn_Id = p_copy_entity_Txn_id
1066: AND nvl(oipl.result_type_cd,'DISPLAY') = 'DISPLAY'
1067: And oipl.Table_Alias = 'COP';

Line 1073: From Ben_Copy_Entity_Results opt1,

1069:
1070: Cursor Csr_Step_No (l_opt_cer_id IN Number,l_pay_scale_cer_id IN Number,l_grd_cer_id IN Number,l_cet_id in number)
1071: IS
1072: Select count(*)
1073: From Ben_Copy_Entity_Results opt1,
1074: Ben_Copy_Entity_Results opt2,
1075: Ben_Copy_Entity_Results oipl
1076: Where oipl.Information262 = opt2.copy_entity_result_id
1077: And opt1.Information253 >= opt2.Information253

Line 1074: Ben_Copy_Entity_Results opt2,

1070: Cursor Csr_Step_No (l_opt_cer_id IN Number,l_pay_scale_cer_id IN Number,l_grd_cer_id IN Number,l_cet_id in number)
1071: IS
1072: Select count(*)
1073: From Ben_Copy_Entity_Results opt1,
1074: Ben_Copy_Entity_Results opt2,
1075: Ben_Copy_Entity_Results oipl
1076: Where oipl.Information262 = opt2.copy_entity_result_id
1077: And opt1.Information253 >= opt2.Information253
1078: And opt1.copy_entity_result_id = l_opt_cer_id

Line 1075: Ben_Copy_Entity_Results oipl

1071: IS
1072: Select count(*)
1073: From Ben_Copy_Entity_Results opt1,
1074: Ben_Copy_Entity_Results opt2,
1075: Ben_Copy_Entity_Results oipl
1076: Where oipl.Information262 = opt2.copy_entity_result_id
1077: And opt1.Information253 >= opt2.Information253
1078: And opt1.copy_entity_result_id = l_opt_cer_id
1079: And oipl.Information259 = l_pay_scale_cer_id -- Information259 is Pay Scale Cer Id

Line 1089: from ben_copy_entity_results

1085:
1086: Cursor csr_starting_step
1087: IS
1088: select information228
1089: from ben_copy_entity_results
1090: where copy_entity_result_id = l_grd_cer_id;
1091:
1092: BEGIN
1093: if g_debug then

Line 1138: p_Table_Alias in ben_copy_entity_results.Table_Alias%Type,

1134: --
1135:
1136: FUNCTION GET_STEP_PRG_RULE_HGRID_NAME( p_copy_entity_result_id in Number,
1137: p_copy_entity_txn_id in Number,
1138: p_Table_Alias in ben_copy_entity_results.Table_Alias%Type,
1139: p_hgrid in Varchar Default NULL)
1140: RETURN varchar2 IS
1141: /*
1142: Author : mvankada

Line 1156: From Ben_Copy_Entity_Results grdldr

1152: -- Grade Ladder : PGM information5 -- Name
1153:
1154: Cursor csr_grdldr_name IS
1155: Select grdldr.information5
1156: From Ben_Copy_Entity_Results grdldr
1157: Where grdldr.Copy_Entity_Result_Id = p_copy_entity_result_id
1158: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
1159: AND grdldr.Table_Alias= p_Table_Alias;
1160:

Line 1164: From Ben_Copy_Entity_Results grd

1160:
1161: -- Grade : CPP information5 -- Grade Name, information98 -- PayScale Name
1162: Cursor csr_grd_name IS
1163: Select grd.information5,information98
1164: From Ben_Copy_Entity_Results grd
1165: Where grd.Copy_Entity_Result_Id = p_copy_entity_result_id
1166: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
1167: AND grd.Table_Alias = p_Table_Alias;
1168:

Line 1172: From Ben_Copy_Entity_Results step

1168:
1169: -- Step : COP information5 -- Step Name, information99 -- Point Name
1170: Cursor csr_step_name IS
1171: Select step.information5 , information99
1172: From Ben_Copy_Entity_Results step
1173: Where step.Copy_Entity_Result_Id = p_copy_entity_result_id
1174: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
1175: AND step.Table_Alias = p_Table_Alias;
1176:

Line 1180: From Ben_Copy_Entity_Results elig

1176:
1177: -- Eligibility Profile : ELP information5 -- Profile Name
1178: Cursor csr_elig_name IS
1179: Select elig.information5
1180: From Ben_Copy_Entity_Results elig
1181: Where elig.Copy_Entity_Result_Id = p_copy_entity_result_id
1182: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
1183: AND elig.Table_Alias = p_Table_Alias;
1184:

Line 1187: From Ben_Copy_Entity_Results Opt

1183: AND elig.Table_Alias = p_Table_Alias;
1184:
1185: Cursor csr_corps_gross_index IS
1186: Select to_number(opt.information173)
1187: From Ben_Copy_Entity_Results Opt
1188: Where opt.Table_Alias = 'OPT'
1189: AND opt.Copy_Entity_Txn_id = p_copy_entity_txn_id
1190: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
1191: And opt.Copy_Entity_Result_Id = ( Select oipl.Information262 -- Point Cer Id

Line 1192: From Ben_Copy_Entity_Results oipl

1188: Where opt.Table_Alias = 'OPT'
1189: AND opt.Copy_Entity_Txn_id = p_copy_entity_txn_id
1190: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
1191: And opt.Copy_Entity_Result_Id = ( Select oipl.Information262 -- Point Cer Id
1192: From Ben_Copy_Entity_Results oipl
1193: Where Copy_Entity_Result_Id = p_copy_entity_result_id
1194: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
1195: And Copy_Entity_Txn_id = p_copy_entity_txn_id
1196: And Table_Alias = 'COP');

Line 1351: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE default NULL,

1347: p_name IN per_grades.name%TYPE,
1348: p_short_name IN per_grades.short_name%TYPE,
1349: p_business_group_id IN per_grades.business_group_id%TYPE,
1350: p_grade_id IN per_grades.grade_id%TYPE default NULL,
1351: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE default NULL,
1352: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,
1353: p_status OUT NOCOPY VARCHAR
1354: )
1355: IS

Line 1352: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,

1348: p_short_name IN per_grades.short_name%TYPE,
1349: p_business_group_id IN per_grades.business_group_id%TYPE,
1350: p_grade_id IN per_grades.grade_id%TYPE default NULL,
1351: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE default NULL,
1352: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,
1353: p_status OUT NOCOPY VARCHAR
1354: )
1355: IS
1356:

Line 1366: From ben_copy_entity_results

1362: And business_group_id = p_business_group_id
1363: And grade_id <> nvl(p_grade_id,-1)
1364: Union ALL
1365: Select null
1366: From ben_copy_entity_results
1367: Where
1368: information5 = p_name
1369: And information4 = p_business_group_id
1370: And table_alias = 'PLN'

Line 1384: From ben_copy_entity_results

1380: And business_group_id = p_business_group_id
1381: And grade_id <> nvl(p_grade_id,-1)
1382: Union ALL
1383: Select null
1384: From ben_copy_entity_results
1385: Where information102 = p_short_name
1386: And information4 = p_business_group_id
1387: And table_alias='PLN'
1388: And result_type_cd = 'DISPLAY'

Line 1447: From ben_copy_entity_results std

1443: RETURN number is
1444: --
1445: Cursor csr_std_rate is
1446: Select information98
1447: From ben_copy_entity_results std
1448: Where std.gs_parent_entity_result_id = p_copy_entity_result_id
1449: And std.table_alias = 'ABR'
1450: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
1451: AND p_effective_date between information2 and nvl(information3,to_date('31/12/4712','dd/mm/RRRR'));

Line 1485: delete from ben_copy_entity_results where copy_entity_txn_id = p_pqh_copy_entity_txn_id;

1481: (p_pqh_copy_entity_txn_id IN pqh_copy_entity_txns.copy_entity_txn_id%TYPE) IS
1482:
1483: begin
1484: delete from pqh_copy_entity_attribs where copy_entity_txn_id = p_pqh_copy_entity_txn_id;
1485: delete from ben_copy_entity_results where copy_entity_txn_id = p_pqh_copy_entity_txn_id;
1486: end del_gl_details_from_stage;
1487:
1488: --
1489: ---------------------------enddate_grade_ladder-----------------------------

Line 1500: (select copy_entity_txn_id from ben_copy_entity_results

1496: select pgm_id, object_version_number from ben_pgm_f where pgm_id = p_ben_pgm_id and effective_end_date = hr_general.end_of_time;
1497:
1498: Cursor c2 is
1499: select copy_entity_txn_id from pqh_copy_entity_txns where copy_entity_txn_id in
1500: (select copy_entity_txn_id from ben_copy_entity_results
1501: where information1 = p_ben_pgm_id and table_alias = 'PGM' and information_category = 'GRADE_LADDER'
1502: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY')
1503: and status = 'SFL';
1504:

Line 1799: select information5 grade_ladder_name from ben_copy_entity_results

1795: Function get_grade_ladder_name_from_txn
1796: (p_pqh_copy_entity_txn_id IN pqh_copy_entity_txns.copy_entity_txn_id%TYPE)
1797: Return Varchar2 is
1798: cursor c1 is
1799: select information5 grade_ladder_name from ben_copy_entity_results
1800: where copy_entity_txn_id = p_pqh_copy_entity_txn_id
1801: and table_alias = 'PGM'
1802: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
1803: and information_category = 'GRADE_LADDER';

Line 1918: l_copy_entity_result_id Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type;

1914: are added to all the Grades.
1915: */
1916:
1917: l_proc varchar2(72) := g_package|| 'chk_add_steps_in_all_grades';
1918: l_copy_entity_result_id Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type;
1919: l_grade_name Ben_Copy_Entity_Results.Information5%type;
1920: l_dummy Varchar2(10);
1921: l_no_step_grades Varchar2(2000) := null;
1922: l_no_ceil_grades Varchar2(2000) := null;

Line 1919: l_grade_name Ben_Copy_Entity_Results.Information5%type;

1915: */
1916:
1917: l_proc varchar2(72) := g_package|| 'chk_add_steps_in_all_grades';
1918: l_copy_entity_result_id Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type;
1919: l_grade_name Ben_Copy_Entity_Results.Information5%type;
1920: l_dummy Varchar2(10);
1921: l_no_step_grades Varchar2(2000) := null;
1922: l_no_ceil_grades Varchar2(2000) := null;
1923: l_found1 Boolean := FALSE;

Line 1931: FROM BEN_COPY_ENTITY_RESULTS step

1927:
1928: Cursor csr_steps_exists
1929: IS
1930: Select Null
1931: FROM BEN_COPY_ENTITY_RESULTS step
1932: WHERE step.copy_entity_txn_id = p_copy_entity_txn_id
1933: AND step.TABLE_ALIAS ='COP'
1934: And nvl(step.INFORMATION104,'PPP') <> 'UNLINK'
1935: AND step.result_type_cd = 'DISPLAY';

Line 1940: From Ben_Copy_Entity_Results grd

1936:
1937:
1938: Cursor csr_grades IS
1939: Select grd.Copy_Entity_Result_Id, grd.Information5
1940: From Ben_Copy_Entity_Results grd
1941: Where grd.Copy_Entity_txn_Id = p_copy_entity_txn_id
1942: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
1943: And nvl(grd.Information104,'PPP') <> 'UNLINK'
1944: And grd.Table_Alias = 'CPP'

Line 1950: From Ben_Copy_Entity_Results step

1946:
1947:
1948: Cursor csr_steps(p_copy_entity_result_id in number) IS
1949: Select Null
1950: From Ben_Copy_Entity_Results step
1951: Where step.Copy_Entity_txn_Id = p_copy_entity_txn_id
1952: And step.Gs_Parent_Entity_Result_Id = p_copy_entity_result_id
1953: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
1954: And step.Table_Alias = 'COP'

Line 1961: From Ben_Copy_Entity_Results ceiling

1957:
1958:
1959: Cursor csr_celing_step(p_copy_entity_result_id in number) IS
1960: Select Null
1961: From Ben_Copy_Entity_Results ceiling
1962: Where ceiling.Copy_Entity_txn_Id = p_copy_entity_txn_id
1963: And ceiling.Gs_Parent_Entity_Result_Id = p_copy_entity_result_id
1964: And ceiling.Table_Alias = 'COP'
1965: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'

Line 2056: l_dummy Ben_Copy_Entity_Results.Information5%Type;

2052: grade ladder effective date
2053: */
2054:
2055: l_proc varchar2(72) := g_package|| 'chk_valid_grd_in_grdldr';
2056: l_dummy Ben_Copy_Entity_Results.Information5%Type;
2057: l_grades Varchar2(2000);
2058: l_found Boolean := FALSE;
2059:
2060: -- This cursor checks the newly created grades

Line 2071: From Ben_Copy_Entity_Results grd

2067: Cursor csr_grades IS
2068: Select grd.Information5 ,
2069: grd.Information306,
2070: grd.Information307
2071: From Ben_Copy_Entity_Results grd
2072: Where grd.Copy_Entity_txn_Id = p_copy_entity_txn_id
2073: AND grd.Table_Alias = 'CPP'
2074: AND nvl(grd.Information104,'PPP') <> 'UNLINK'
2075: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'

Line 2298: From Ben_Copy_Entity_Results grdldr

2294: -- To Get Pgm_Id of PGM based on Txn_id
2295: Cursor csr_pgm_id
2296: IS
2297: Select grdldr.Information1
2298: From Ben_Copy_Entity_Results grdldr
2299: Where grdldr.Table_Alias = 'PGM'
2300: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
2301: And grdldr.Copy_Entity_Txn_Id = p_Copy_Entity_Txn_Id;
2302:

Line 2307: From Ben_Copy_Entity_Results grd

2303: -- To Get Grade_Id (information253) of CPP based on Result_id of CPP
2304: Cursor csr_grade_id
2305: IS
2306: Select grd.Information253
2307: From Ben_Copy_Entity_Results grd
2308: Where grd.Table_Alias = 'CPP'
2309: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
2310: And grd.Copy_Entity_Result_Id = p_Grade_Result_Id;
2311:

Line 2316: From Ben_Copy_Entity_Results pln

2312: -- Get Plan Record
2313: Cursor csr_plan_result_id
2314: IS
2315: Select pln.Copy_Entity_Result_Id
2316: From Ben_Copy_Entity_Results pln
2317: Where pln.Gs_Mirror_Src_Entity_Result_Id = p_grade_result_id
2318: And pln.Copy_Entity_Txn_Id = p_copy_entity_txn_id
2319: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
2320: And pln.Table_Alias = 'PLN';

Line 2326: From Ben_Copy_Entity_Results

2322:
2323: Cursor csr_ovn (l_result_id in Number)
2324: IS
2325: Select Object_Version_Number
2326: From Ben_Copy_Entity_Results
2327: Where Copy_Entity_Result_Id = l_result_id;
2328:
2329: l_pgm_id Number;
2330: l_grade_id Number;

Line 2371: ben_copy_entity_results_api.update_copy_entity_results(

2367: Open csr_ovn(p_grade_result_id);
2368: Fetch csr_ovn into l_ovn;
2369: Close csr_ovn;
2370:
2371: ben_copy_entity_results_api.update_copy_entity_results(
2372: p_copy_entity_result_id => p_grade_result_id,
2373: p_effective_date => p_effective_date,
2374: p_information104 => 'UNLINK',
2375: p_object_version_number => l_ovn,

Line 2394: ben_copy_entity_results_api.update_copy_entity_results(

2390: Open csr_ovn(l_pln_result_id);
2391: Fetch csr_ovn into l_ovn;
2392: Close csr_ovn;
2393:
2394: ben_copy_entity_results_api.update_copy_entity_results(
2395: p_copy_entity_result_id => l_pln_result_id,
2396: p_effective_date => p_effective_date,
2397: p_Gs_Mr_Src_Entity_Result_Id => NULL,
2398: p_object_version_number => l_ovn,

Line 2408: ben_copy_entity_results_api.delete_copy_entity_results(

2404: Open csr_ovn(p_grade_result_id);
2405: Fetch csr_ovn into l_ovn;
2406: Close csr_ovn;
2407:
2408: ben_copy_entity_results_api.delete_copy_entity_results(
2409: p_copy_entity_result_id => p_grade_result_id,
2410: p_effective_date => p_effective_date,
2411: p_object_version_number => l_ovn);
2412: end if;

Line 2455: From Ben_Copy_Entity_Results grdldr

2451: -- To Get information1 (Pgm_ID) of PGM, based on TXN_ID
2452: Cursor csr_pgm_id
2453: IS
2454: Select grdldr.information1 -- PGM_ID
2455: From Ben_Copy_Entity_Results grdldr
2456: Where grdldr.Copy_Entity_Txn_Id = p_copy_entity_txn_id
2457: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
2458: AND grdldr.Table_Alias = 'PGM';
2459:

Line 2464: From Ben_Copy_Entity_Results grd

2460: -- To Get information253 (Grade_id) of CPP, based on Step Result Id
2461: Cursor csr_grade_id
2462: IS
2463: Select grd.information253
2464: From Ben_Copy_Entity_Results grd
2465: Where grd.Table_Alias = 'CPP'
2466: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
2467: AND grd.copy_entity_result_id = (Select step.gs_parent_entity_result_id
2468: From Ben_Copy_Entity_Results step

Line 2468: From Ben_Copy_Entity_Results step

2464: From Ben_Copy_Entity_Results grd
2465: Where grd.Table_Alias = 'CPP'
2466: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
2467: AND grd.copy_entity_result_id = (Select step.gs_parent_entity_result_id
2468: From Ben_Copy_Entity_Results step
2469: Where step.Copy_Entity_Result_Id= p_step_result_id
2470: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
2471: AND step.Table_Alias = 'COP');
2472:

Line 2476: From Ben_Copy_Entity_Results

2472:
2473: Cursor csr_ovn (l_result_id in Number)
2474: IS
2475: Select Object_Version_Number
2476: From Ben_Copy_Entity_Results
2477: Where Copy_Entity_Result_Id = l_result_id;
2478:
2479:
2480: l_pgm_id Number;

Line 2531: ben_copy_entity_results_api.update_copy_entity_results(

2527:
2528: Open csr_ovn(p_point_result_id);
2529: Fetch csr_ovn into l_ovn;
2530: Close csr_ovn;
2531: ben_copy_entity_results_api.update_copy_entity_results(
2532: p_copy_entity_result_id => p_point_result_id,
2533: p_effective_date => p_effective_date,
2534: p_information104 => 'UNLINK',
2535: p_object_version_number => l_ovn,

Line 2549: ben_copy_entity_results_api.update_copy_entity_results(

2545:
2546: Open csr_ovn(p_step_result_id);
2547: Fetch csr_ovn into l_ovn;
2548: Close csr_ovn;
2549: ben_copy_entity_results_api.update_copy_entity_results(
2550: p_copy_entity_result_id => p_step_result_id,
2551: p_effective_date => p_effective_date,
2552: p_information104 => 'UNLINK',
2553: p_object_version_number => l_ovn,

Line 2570: ben_copy_entity_results_api.delete_copy_entity_results(

2566:
2567: Open csr_ovn(p_point_result_id);
2568: Fetch csr_ovn into l_ovn;
2569: Close csr_ovn;
2570: ben_copy_entity_results_api.delete_copy_entity_results(
2571: p_copy_entity_result_id => p_point_result_id,
2572: p_effective_date => p_effective_date,
2573: p_object_version_number => l_ovn);
2574: end if;

Line 2585: ben_copy_entity_results_api.delete_copy_entity_results(

2581:
2582: Open csr_ovn(p_step_result_id);
2583: Fetch csr_ovn into l_ovn;
2584: Close csr_ovn;
2585: ben_copy_entity_results_api.delete_copy_entity_results(
2586: p_copy_entity_result_id => p_step_result_id,
2587: p_effective_date => p_effective_date,
2588: p_object_version_number => l_ovn);
2589: end if;

Line 2615: from ben_copy_entity_results oipl,

2611: CURSOR csr_points
2612: IS
2613: select oipl.copy_entity_result_id,
2614: oipl.object_version_number
2615: from ben_copy_entity_results oipl,
2616: ben_copy_entity_results opt
2617: where nvl(oipl.information104,'PPP') <> 'UNLINK'
2618: AND nvl(oipl.result_type_cd,'DISPLAY') = 'DISPLAY'
2619: AND nvl(opt.result_type_cd,'DISPLAY') = 'DISPLAY'

Line 2616: ben_copy_entity_results opt

2612: IS
2613: select oipl.copy_entity_result_id,
2614: oipl.object_version_number
2615: from ben_copy_entity_results oipl,
2616: ben_copy_entity_results opt
2617: where nvl(oipl.information104,'PPP') <> 'UNLINK'
2618: AND nvl(oipl.result_type_cd,'DISPLAY') = 'DISPLAY'
2619: AND nvl(opt.result_type_cd,'DISPLAY') = 'DISPLAY'
2620: and oipl.table_alias = 'COP'

Line 2636: ben_copy_entity_results_api.update_copy_entity_results(

2632: hr_utility.set_location('p_grd_result_id:'||p_grd_result_id, 30);
2633: end if;
2634: for i in csr_points loop
2635: stepnum :=stepnum+1;
2636: ben_copy_entity_results_api.update_copy_entity_results(
2637: p_copy_entity_result_id => i.copy_entity_result_id,
2638: p_effective_date => p_effective_start_date,
2639: p_copy_entity_txn_id => p_copy_entity_txn_id,
2640: p_information5 => fnd_message.get_string('PQH','PQH_GSP_STEP_PROMPT')||stepnum,

Line 2675: From Ben_Copy_Entity_Results

2671: Cursor csr_grades
2672: IS
2673: Select Information253, -- Grade Id
2674: Information5 -- Grade Name
2675: From Ben_Copy_Entity_Results
2676: Where Copy_Entity_Txn_Id = p_copy_entity_txn_id
2677: And Table_Alias = 'CPP'
2678: And Information253 IS NOT NULL
2679: AND Nvl(Information104,'PPP') = 'UNLINK'

Line 2824: From Ben_Copy_Entity_Results

2820: IS
2821: Select Information253, -- Step Id
2822: Information5 -- Step Name
2823: INFORMATION98 -- Ceiling Flag
2824: From Ben_Copy_Entity_Results
2825: Where Copy_Entity_Txn_Id = p_copy_entity_txn_id
2826: And Table_Alias = 'COP'
2827: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
2828: And Information253 IS NOT NULL

Line 3091: from Ben_Copy_Entity_Results

3087: -- fix for bug 7114098
3088: l_pgm_id number;
3089: cursor csr_pgm_val is
3090: select information1
3091: from Ben_Copy_Entity_Results
3092: where Copy_Entity_Txn_Id = p_copy_entity_txn_id
3093: and Information4 = p_business_group_id
3094: and table_alias = 'PGM' ;
3095:

Line 3104: From Ben_Copy_Entity_Results

3100: IS
3101: Select Copy_Entity_Result_Id,
3102: Information50, -- Currency_Code
3103: Information41 -- Rate_Period
3104: From Ben_Copy_Entity_Results
3105: Where Copy_Entity_Txn_Id = p_copy_entity_txn_id
3106: AND Table_Alias = 'PGM'
3107: AND Result_Type_Cd = 'DISPLAY'
3108: AND Nvl(Information104,'PPP') <> 'UNLINK'

Line 3117: From Ben_Copy_Entity_Results

3113: Cursor csr_grade_ids(l_grdldr_result_id IN Number)
3114: IS
3115: Select Information253, -- Grade Id
3116: Information5 -- Grade Name
3117: From Ben_Copy_Entity_Results
3118: Where Gs_Parent_Entity_Result_Id = l_grdldr_result_id
3119: And Copy_Entity_Txn_Id = p_copy_entity_txn_id
3120: And Table_Alias = 'CPP'
3121: AND Nvl(Information104,'PPP') <> 'UNLINK'

Line 3154: l_curr_gl_currency Ben_Copy_Entity_Results.Information50%Type;

3150: and l_pgm_id <> pgm.pgm_id; -- added for bug 7114098
3151:
3152: l_proc varchar2(72) := g_package|| 'chk_grdldr_grd_curreny_rate';
3153: l_curr_gl_result_id Number;
3154: l_curr_gl_currency Ben_Copy_Entity_Results.Information50%Type;
3155: l_curr_gl_period Ben_Copy_Entity_Results.Information41%Type;
3156:
3157: l_target_currency Ben_Pgm_F.PGM_UOM%Type;
3158: l_target_period Ben_Pgm_F.ACTY_REF_PERD_CD%Type;

Line 3155: l_curr_gl_period Ben_Copy_Entity_Results.Information41%Type;

3151:
3152: l_proc varchar2(72) := g_package|| 'chk_grdldr_grd_curreny_rate';
3153: l_curr_gl_result_id Number;
3154: l_curr_gl_currency Ben_Copy_Entity_Results.Information50%Type;
3155: l_curr_gl_period Ben_Copy_Entity_Results.Information41%Type;
3156:
3157: l_target_currency Ben_Pgm_F.PGM_UOM%Type;
3158: l_target_period Ben_Pgm_F.ACTY_REF_PERD_CD%Type;
3159:

Line 3247: from ben_copy_entity_results

3243: -- Select all crsets in the txn which are not equal to current crset
3244: --
3245: cursor csr_crset is
3246: select *
3247: from ben_copy_entity_results
3248: where copy_entity_txn_id = p_copy_entity_txn_id
3249: and table_alias = 'CRSET'
3250: and p_effective_date between information2 and nvl(information3, to_date('31/12/4712','dd/mm/RRRR'))
3251: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'

Line 3302: from ben_copy_entity_results

3298: is
3299: --
3300: cursor csr_crset is
3301: select *
3302: from ben_copy_entity_results
3303: where copy_entity_txn_id = p_copy_entity_txn_id
3304: and table_alias = 'CRSET'
3305: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
3306: and dml_operation in ('INSERT','UPDATE') -- Check only insert/ updates crset

Line 3451: From Ben_Copy_Entity_Results

3447:
3448: Cursor csr_grdldr_date
3449: IS
3450: Select Information2 EFFECTIVE_START_DATE
3451: From Ben_Copy_Entity_Results
3452: Where Copy_Entity_Txn_id = p_copy_entity_txn_id
3453: And Information4 = p_business_group_id
3454: And Table_Alias = 'PGM'
3455: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'

Line 3643: FROM BEN_COPY_ENTITY_RESULTS

3639: Function get_which_rates (p_copy_entity_txn_id in Number) Return Varchar2 is
3640: cursor c1 is
3641: select 1 from dual where exists (
3642: select 1
3643: FROM BEN_COPY_ENTITY_RESULTS
3644: WHERE NVL(INFORMATION104,'PPP') NOT IN ('UNLINK')
3645: AND TABLE_ALIAS ='COP'
3646: AND copy_entity_txn_id = p_copy_entity_txn_id
3647: AND result_type_cd = 'DISPLAY'

Line 3683: select 1 from ben_copy_entity_results

3679: l_icon varchar2(20) := 'NONE';
3680: cnt number := 0;
3681: cursor c1 is
3682: select 1 from dual where exists (
3683: select 1 from ben_copy_entity_results
3684: where copy_entity_txn_id = p_copy_entity_txn_id
3685: and gs_parent_entity_result_id = p_copy_entity_result_id);
3686: l_proc varchar2(72) := g_package||'.get_rates_icon_enabled';
3687: begin

Line 3868: from ben_copy_entity_results

3864: is
3865: cursor csr_steps_for_point
3866: is
3867: select null
3868: from ben_copy_entity_results
3869: where copy_entity_txn_id = p_copy_entity_txn_id
3870: and information262 = p_points_result_id
3871: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
3872: and information104 = 'LINK';

Line 3895: from ben_copy_entity_results

3891: is
3892: cursor csr_scale_name
3893: is
3894: select null
3895: from ben_copy_entity_results
3896: where copy_entity_txn_id = p_copy_entity_txn_id
3897: and copy_entity_result_id <> p_copy_entity_result_id
3898: and information98 = p_name
3899: and table_alias = 'SCALE'

Line 3910: from ben_copy_entity_results

3906:
3907: Cursor plip_details
3908: is
3909: select information98,copy_entity_result_id,dml_operation
3910: from ben_copy_entity_results
3911: where copy_entity_txn_id = p_copy_entity_txn_id
3912: and table_alias = 'CPP'
3913: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
3914: and information258 = p_copy_entity_result_id;

Line 3923: update ben_copy_entity_results

3919: if(csr_scale_name%NOTFOUND) then
3920: p_status := 'Y';
3921: for i in plip_details loop
3922: if i.information98<>p_name THEN
3923: update ben_copy_entity_results
3924: set information98 = p_name,
3925: dml_operation = get_dml_operation(i.dml_operation)
3926: where copy_entity_result_id = i.copy_entity_result_id;
3927:

Line 4132: from ben_copy_entity_results

4128:
4129: cursor csr_steps_in_grade
4130: is
4131: select count(*) cnt
4132: from ben_copy_entity_results
4133: where table_alias = 'COP'
4134: and copy_entity_txn_id = p_copy_entity_txn_id
4135: and gs_parent_entity_result_id in
4136: (select gs_mirror_src_entity_result_id

Line 4137: from ben_copy_entity_results

4133: where table_alias = 'COP'
4134: and copy_entity_txn_id = p_copy_entity_txn_id
4135: and gs_parent_entity_result_id in
4136: (select gs_mirror_src_entity_result_id
4137: from ben_copy_entity_results
4138: where table_alias = 'PLN' and copy_entity_txn_id = p_copy_entity_txn_id
4139: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY' and copy_entity_result_id = p_grade_cer_id)
4140: And result_type_cd = 'DISPLAY'
4141: And Nvl(Information104,'PPP') <> 'UNLINK';

Line 4173: From ben_copy_entity_results

4169: -- Local variables
4170: --
4171: Cursor csr_dflt_point_rate is
4172: Select information297
4173: From ben_copy_entity_results
4174: Where copy_entity_txn_id = p_copy_entity_txn_id
4175: and INFORMATION278 = p_point_cer_id
4176: and p_effective_date between information2 and information3
4177: and table_alias = 'HRRATE'

Line 4298: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,

4294:
4295: -------------------------------------------------------------------
4296: procedure update_oipl_records(
4297: p_effective_date IN DATE,
4298: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
4299: p_point_name IN ben_copy_entity_results.information99%TYPE,
4300: p_sequence IN ben_copy_entity_results.information263%TYPE,
4301: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE
4302: )

Line 4299: p_point_name IN ben_copy_entity_results.information99%TYPE,

4295: -------------------------------------------------------------------
4296: procedure update_oipl_records(
4297: p_effective_date IN DATE,
4298: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
4299: p_point_name IN ben_copy_entity_results.information99%TYPE,
4300: p_sequence IN ben_copy_entity_results.information263%TYPE,
4301: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE
4302: )
4303: IS

Line 4300: p_sequence IN ben_copy_entity_results.information263%TYPE,

4296: procedure update_oipl_records(
4297: p_effective_date IN DATE,
4298: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
4299: p_point_name IN ben_copy_entity_results.information99%TYPE,
4300: p_sequence IN ben_copy_entity_results.information263%TYPE,
4301: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE
4302: )
4303: IS
4304:

Line 4301: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE

4297: p_effective_date IN DATE,
4298: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
4299: p_point_name IN ben_copy_entity_results.information99%TYPE,
4300: p_sequence IN ben_copy_entity_results.information263%TYPE,
4301: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE
4302: )
4303: IS
4304:
4305:

Line 4309: from ben_copy_entity_results

4305:
4306: cursor csr_oipl_records
4307: is
4308: select copy_entity_result_id,object_version_number,dml_operation
4309: from ben_copy_entity_results
4310: where table_alias = 'COP'
4311: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
4312: and information262 = p_copy_entity_result_id
4313: and copy_entity_txn_id = p_copy_entity_txn_id;

Line 4320: ben_copy_entity_results_api.update_copy_entity_results(

4316: begin
4317: for r_oipl_record in csr_oipl_records loop
4318:
4319: l_ovn := r_oipl_record.object_version_number;
4320: ben_copy_entity_results_api.update_copy_entity_results(
4321: p_effective_date => p_effective_date,
4322: p_copy_entity_result_id => r_oipl_record.copy_entity_result_id,
4323: p_information99 => p_point_name,
4324: p_information263 => p_sequence,

Line 4497: (p_in_dml_operation IN ben_copy_entity_results.dml_operation%TYPE)

4493: --------- get_dml_operation -----------
4494: --
4495:
4496: FUNCTION GET_DML_OPERATION
4497: (p_in_dml_operation IN ben_copy_entity_results.dml_operation%TYPE)
4498: return VARCHAR2
4499: is
4500: p_out_dml_operation ben_copy_entity_results.dml_operation%TYPE;
4501:

Line 4500: p_out_dml_operation ben_copy_entity_results.dml_operation%TYPE;

4496: FUNCTION GET_DML_OPERATION
4497: (p_in_dml_operation IN ben_copy_entity_results.dml_operation%TYPE)
4498: return VARCHAR2
4499: is
4500: p_out_dml_operation ben_copy_entity_results.dml_operation%TYPE;
4501:
4502: begin
4503: IF p_in_dml_operation = 'REUSE' THEN
4504: p_out_dml_operation := 'UPDATE';

Line 4596: FROM ben_copy_entity_results

4592:
4593: CURSOR csr_grade_id
4594: IS
4595: SELECT information253
4596: FROM ben_copy_entity_results
4597: WHERE copy_entity_result_id = p_grade_cer_id
4598: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY';
4599:
4600: CURSOR csr_gspine_id (p_grade_id IN NUMBER)

Line 4647: UPDATE ben_copy_entity_results

4643:
4644: PROCEDURE unlink_step_or_point (p_copy_entity_result_id IN NUMBER)
4645: IS
4646: BEGIN
4647: UPDATE ben_copy_entity_results
4648: SET information104 = 'UNLINK'
4649: WHERE copy_entity_result_id = p_copy_entity_result_id;
4650: END unlink_step_or_point;
4651: --------------------------------------------------------------------------

Line 4664: FROM ben_copy_entity_results

4660: IS
4661: CURSOR csr_steps_for_point
4662: IS
4663: SELECT NULL
4664: FROM ben_copy_entity_results
4665: WHERE copy_entity_txn_id = p_copy_entity_txn_id
4666: AND information262 = p_opt_cer_id
4667: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
4668: AND information104 = 'LINK';

Line 4711: FROM ben_copy_entity_results

4707: */
4708: CURSOR csr_init_step
4709: IS
4710: SELECT object_version_number, dml_operation
4711: FROM ben_copy_entity_results
4712: WHERE copy_entity_result_id = p_initial_ceiling_id;
4713:
4714: CURSOR csr_final_step
4715: IS

Line 4718: FROM ben_copy_entity_results

4714: CURSOR csr_final_step
4715: IS
4716: SELECT object_version_number, dml_operation, information253,
4717: information255, information263
4718: FROM ben_copy_entity_results
4719: WHERE copy_entity_result_id = p_final_ceiling_id;
4720:
4721: CURSOR csr_grade
4722: IS

Line 4724: FROM ben_copy_entity_results

4720:
4721: CURSOR csr_grade
4722: IS
4723: SELECT object_version_number, dml_operation
4724: FROM ben_copy_entity_results
4725: WHERE copy_entity_result_id = p_grade_result_id;
4726:
4727: l_initial_step csr_init_step%ROWTYPE;
4728: l_final_step csr_final_step%ROWTYPE;

Line 4766: ben_copy_entity_results_api.update_copy_entity_results (

4762: p_gspine_id => l_gspine_id,
4763: p_new_ceil => l_final_step.information263
4764: );
4765: END IF;
4766: ben_copy_entity_results_api.update_copy_entity_results (
4767: p_copy_entity_result_id => p_final_ceiling_id,
4768: p_effective_date => p_effective_date,
4769: p_copy_entity_txn_id => p_copy_entity_txn_id,
4770: p_information98 => 'Y',

Line 4790: ben_copy_entity_results_api.update_copy_entity_results (

4786: FETCH csr_init_step INTO l_initial_step;
4787:
4788: IF (csr_init_step%FOUND)
4789: THEN
4790: ben_copy_entity_results_api.update_copy_entity_results (
4791: p_copy_entity_result_id => p_initial_ceiling_id,
4792: p_effective_date => p_effective_date,
4793: p_copy_entity_txn_id => p_copy_entity_txn_id,
4794: p_information98 => 'N',

Line 4807: ben_copy_entity_results_api.update_copy_entity_results (

4803: CLOSE csr_init_step;
4804: OPEN csr_grade;
4805: FETCH csr_grade INTO l_grade;
4806: CLOSE csr_grade;
4807: ben_copy_entity_results_api.update_copy_entity_results (
4808: p_copy_entity_result_id => p_grade_result_id,
4809: p_effective_date => p_effective_date,
4810: p_copy_entity_txn_id => p_copy_entity_txn_id,
4811: p_information103 => 'Y',

Line 4847: FROM ben_copy_entity_results

4843: */
4844: CURSOR csr_steps_in_grade
4845: IS
4846: SELECT NULL
4847: FROM ben_copy_entity_results
4848: WHERE table_alias = 'COP'
4849: AND copy_entity_txn_id = p_copy_entity_txn_id
4850: AND gs_parent_entity_result_id = p_grade_result_id
4851: AND result_type_cd = 'DISPLAY'

Line 4857: FROM ben_copy_entity_results

4853:
4854: CURSOR csr_grade_scale_dets
4855: IS
4856: SELECT information253, information255
4857: FROM ben_copy_entity_results
4858: WHERE copy_entity_result_id = p_grade_result_id;
4859:
4860:
4861: cursor c1(p_pspine_id IN Number,

Line 4955: select copy_entity_txn_id, information297 from ben_copy_entity_results

4951: dflt_sal_rate Number := null;
4952:
4953:
4954: cursor grd_rates(l_action_dt in date) is
4955: select copy_entity_txn_id, information297 from ben_copy_entity_results
4956: where
4957: copy_entity_txn_id = p_copy_entity_txn_id
4958: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
4959: and information277 in (

Line 4961: from ben_copy_entity_results

4957: copy_entity_txn_id = p_copy_entity_txn_id
4958: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
4959: and information277 in (
4960: select copy_entity_result_id
4961: from ben_copy_entity_results
4962: where table_alias ='PLN'
4963: and result_type_cd = 'DISPLAY'
4964: and gs_mirror_src_entity_result_id = p_copy_entity_result_id)
4965: and table_alias = 'HRRATE' and l_action_dt

Line 4974: select information262 from ben_copy_entity_results

4970: From Pqh_Copy_Entity_txns
4971: Where Copy_Entity_Txn_id = p_copy_entity_txn_id;
4972:
4973: cursor point_cer is
4974: select information262 from ben_copy_entity_results
4975: where
4976: copy_entity_txn_id = p_copy_entity_txn_id
4977: and
4978: copy_entity_result_id = p_copy_entity_result_id;

Line 4981: select copy_entity_Txn_id, information297 from ben_copy_entity_results

4977: and
4978: copy_entity_result_id = p_copy_entity_result_id;
4979:
4980: cursor pnt_rates(point_cer_id number,l_action_dt in date) is
4981: select copy_entity_Txn_id, information297 from ben_copy_entity_results
4982: where
4983: copy_entity_txn_id = p_copy_entity_txn_id
4984: and information278 = point_cer_id
4985: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'

Line 5156: from ben_copy_entity_results

5152: IS
5153: Cursor csr_is_steps
5154: Is
5155: select information18
5156: from ben_copy_entity_results
5157: where table_alias = 'PGM'
5158: and copy_entity_txn_id = p_copy_entity_txn_id
5159: and result_type_cd = 'DISPLAY';
5160: Cursor csr_crrate

Line 5163: from ben_copy_entity_results

5159: and result_type_cd = 'DISPLAY';
5160: Cursor csr_crrate
5161: is
5162: select null
5163: from ben_copy_entity_results
5164: where information160 = p_crset_id
5165: and table_alias = 'CRRATE'
5166: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
5167: and copy_entity_txn_id = p_copy_entity_txn_id

Line 5170: from ben_copy_entity_results

5166: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
5167: and copy_entity_txn_id = p_copy_entity_txn_id
5168: and information169 in
5169: (select copy_entity_result_id
5170: from ben_copy_entity_results
5171: where table_alias = 'OPT'
5172: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
5173: and information256 = p_scale_cer_id
5174: and copy_entity_txn_id = p_copy_entity_txn_id);

Line 5203: from ben_copy_entity_results

5199: is
5200: Cursor csr_is_steps
5201: Is
5202: select information18
5203: from ben_copy_entity_results
5204: where table_alias = 'PGM'
5205: and copy_entity_txn_id = p_copy_entity_txn_id
5206: and result_type_cd = 'DISPLAY';
5207:

Line 5211: from ben_copy_entity_results

5207:
5208: Cursor csr_plan_dtls
5209: Is
5210: select Gs_Mirror_Src_Entity_Result_Id,object_version_number
5211: from ben_copy_entity_results
5212: where copy_entity_result_id = p_pl_cer_id
5213: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
5214: and copy_entity_txn_id = p_copy_entity_txn_id
5215: and table_alias = 'PLN';

Line 5220: from ben_copy_entity_results

5216:
5217: Cursor csr_plip_dtls(p_plip_cer_id in number)
5218: Is
5219: select information258,copy_entity_result_id,dml_operation
5220: from ben_copy_entity_results
5221: where table_alias = 'CPP'
5222: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
5223: and copy_entity_txn_id = p_copy_entity_txn_id
5224: and copy_entity_result_id = p_plip_cer_id;

Line 5229: from ben_copy_entity_results

5225:
5226: Cursor csr_scale_dtls(p_scale_cer_id in number)
5227: Is
5228: Select Information98,copy_entity_result_id,dml_operation
5229: from ben_copy_entity_results
5230: where copy_entity_result_id = p_scale_cer_id
5231: and table_alias = 'SCALE'
5232: and copy_entity_txn_id = p_copy_entity_txn_id;
5233:

Line 5273: update ben_copy_entity_results

5269: return;
5270: else
5271: hr_utility.set_location('Got some work to do..',55);
5272:
5273: update ben_copy_entity_results
5274: set information98 = p_short_name
5275: , dml_operation = get_dml_operation(l_scale_dtls.dml_operation)
5276: where copy_entity_result_id = l_scale_dtls.copy_entity_result_id;
5277:

Line 5278: update ben_copy_entity_results

5274: set information98 = p_short_name
5275: , dml_operation = get_dml_operation(l_scale_dtls.dml_operation)
5276: where copy_entity_result_id = l_scale_dtls.copy_entity_result_id;
5277:
5278: update ben_copy_entity_results
5279: set information98 = p_short_name
5280: ,dml_operation = get_dml_operation(l_plip_dtls.dml_operation)
5281: where copy_entity_result_id = l_plip_dtls.copy_entity_result_id;
5282:

Line 5296: FROM ben_copy_entity_results

5292: CURSOR csr_steps_in_grade
5293: IS
5294: SELECT copy_entity_result_id,
5295: dml_operation
5296: FROM ben_copy_entity_results
5297: WHERE table_alias = 'COP'
5298: AND copy_entity_txn_id = p_copy_entity_txn_id
5299: AND gs_parent_entity_result_id = p_grade_result_id
5300: AND result_type_cd = 'DISPLAY'

Line 5317: /* update ben_copy_entity_results

5313: Close Csr_Action_Dt;
5314:
5315: for rec_steps in csr_steps_in_grade loop
5316:
5317: /* update ben_copy_entity_results
5318: set copy_entity_result_id = rec_steps.copy_entity_result_id,
5319: information104 = 'UNLINK',
5320: dml_operation = get_dml_operation(rec_steps.dml_operation)
5321: where copy_entity_result_id = rec_steps.copy_entity_result_id; */

Line 5336: from ben_copy_entity_results

5332: is
5333: Cursor csr_plan_dtls
5334: Is
5335: select information307
5336: from ben_copy_entity_results
5337: where copy_entity_result_id = p_pl_cer_id
5338: and copy_entity_txn_id = p_copy_entity_txn_id
5339: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
5340: and table_alias = 'PLN';

Line 5345: from ben_copy_entity_results

5341:
5342: Cursor Csr_rate_details(p_plan_old_date in date)
5343: is
5344: select information2,information3,copy_entity_result_id
5345: from ben_copy_entity_results
5346: where information277 =p_pl_cer_id
5347: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
5348: and table_alias in ('HRRATE','ABR')
5349: and information2 = p_plan_old_date

Line 5390: update ben_copy_entity_results

5386: hr_utility.set_message(8302,'PER_289567_GRADE_DATE_FROM');
5387: hr_utility.raise_error;
5388: end if;
5389:
5390: update ben_copy_entity_results
5391: set information2 = p_start_date
5392: where copy_entity_result_id = i.copy_entity_result_id;
5393: if g_debug then
5394: hr_utility.set_location('Updated record with cer_id:'||i.copy_entity_result_id,60);

Line 5416: FROM Ben_Copy_Entity_Results grdldr

5412:
5413: Cursor csr_currency_code
5414: IS
5415: Select nvl(grdldr.INFORMATION50,'USD') /* INFORMATION50 -> Currency Code */
5416: FROM Ben_Copy_Entity_Results grdldr
5417: WHERE grdldr.Copy_Entity_Txn_Id = p_copy_entity_txn_id
5418: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
5419: AND grdldr.Table_Alias = 'PGM';
5420:

Line 5451: (p_copy_entity_result_id in ben_copy_entity_results.copy_entity_result_id%TYPE)

5447: END GET_CURRENCY_CODE;
5448:
5449: --
5450: FUNCTION get_grd_start_date
5451: (p_copy_entity_result_id in ben_copy_entity_results.copy_entity_result_id%TYPE)
5452: RETURN DATE
5453: IS
5454: l_grd_start_date DATE;
5455:

Line 5460: from ben_copy_entity_results

5456: begin
5457:
5458: select information307
5459: into l_grd_start_date
5460: from ben_copy_entity_results
5461: where copy_entity_result_id = p_copy_entity_result_id;
5462:
5463:
5464: RETURN l_grd_start_date;

Line 5475: from ben_copy_entity_results

5471: is
5472: Cursor csr_indicator
5473: is
5474: select information103
5475: from ben_copy_entity_results
5476: where copy_entity_result_id =p_grade_result_id;
5477: l_indicator varchar2(10);
5478: begin
5479: open csr_indicator;

Line 5489: update ben_copy_entity_results

5485: l_indicator := 'S';
5486: end if;
5487:
5488:
5489: update ben_copy_entity_results
5490: set information228 = p_final_start_step
5491: ,information103 = l_indicator
5492: where copy_entity_result_id = p_grade_result_id;
5493: end change_start_step;

Line 5665: update ben_copy_entity_results

5661: PROCEDURE upd_ceiling_info(p_grade_cer_id IN NUMBER, p_step_id IN number)
5662: IS
5663: BEGIN
5664:
5665: update ben_copy_entity_results
5666: set information259 = p_step_id,
5667: information103 = 'Y'
5668: where copy_entity_result_id = p_grade_cer_id
5669: and table_alias = 'CPP';