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 193: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_result_id%TYPE

189: --
190:
191: FUNCTION chk_grade_exist_in_gl
192: (
193: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_result_id%TYPE
194: )
195: RETURN VARCHAR2 IS
196: /*
197: Author : mvankada

Line 211: From ben_copy_entity_results

207:
208: CURSOR csr_grade_in_gl
209: IS
210: Select copy_entity_result_id
211: From ben_copy_entity_results
212: Where Copy_Entity_Txn_Id = p_copy_entity_txn_id
213: AND Table_Alias = 'CPP'
214: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
215: AND nvl(Information104,'PPP') <> 'UNLINK';

Line 245: p_Grade_Result_Id IN ben_copy_entity_results.copy_entity_result_id%TYPE,

241: --
242:
243: Procedure remove_grade_from_grdldr
244: (
245: p_Grade_Result_Id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
246: p_Copy_Entity_Txn_Id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,
247: p_Business_Group_Id IN Number,
248: p_Effective_Date IN Date,
249: p_Rec_Exists OUT NOCOPY Varchar2

Line 246: p_Copy_Entity_Txn_Id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,

242:
243: Procedure remove_grade_from_grdldr
244: (
245: p_Grade_Result_Id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
246: p_Copy_Entity_Txn_Id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,
247: p_Business_Group_Id IN Number,
248: p_Effective_Date IN Date,
249: p_Rec_Exists OUT NOCOPY Varchar2
250: ) IS

Line 268: l_grade_name Ben_Copy_Entity_Results.Information5%Type;

264: l_pgm_id Number;
265: l_grade_id Number;
266: l_assg_id Number;
267: l_dummy Char(1);
268: l_grade_name Ben_Copy_Entity_Results.Information5%Type;
269: l_proc varchar2(72) := g_package||'remove_grade_from_grdldr';
270: l_message_type varchar2(10) := 'W';
271: l_warnings_rec pqh_utility.warnings_rec;
272: l_business_area varchar2(50) := 'PQH_GSP_TASK_LIST';

Line 281: From Ben_Copy_Entity_Results grdldr

277: -- To Get Pgm_Id of PGM based on Txn_id
278: Cursor csr_pgm_id
279: IS
280: Select grdldr.Information1
281: From Ben_Copy_Entity_Results grdldr
282: Where grdldr.Table_Alias = 'PGM'
283: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
284: And grdldr.Copy_Entity_Txn_Id = p_Copy_Entity_Txn_Id
285: And Information4 = p_Business_Group_Id;

Line 292: From Ben_Copy_Entity_Results grdldr

288:
289: Cursor csr_corps_id
290: IS
291: Select grdldr.Information1
292: From Ben_Copy_Entity_Results grdldr
293: Where grdldr.Table_Alias = 'CPD'
294: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
295: And grdldr.Copy_Entity_Txn_Id = p_Copy_Entity_Txn_Id
296: And Information4 = p_Business_Group_Id;

Line 305: From Ben_Copy_Entity_Results grd

301: Cursor csr_grade_id
302: IS
303: Select grd.Information253,
304: grd.Information5
305: From Ben_Copy_Entity_Results grd
306: Where grd.Table_Alias = 'CPP'
307: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
308: And grd.Copy_Entity_Result_Id = p_Grade_Result_Id;
309:

Line 510: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

506: if p_gsp_node = '1' then
507: st_icon := 'Y';
508: else
509: select nvl(pa.decode_function_name, '99') into prev_task from
510: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
511: where
512: bcer.table_route_id = ptr.table_route_id
513: and ptr.table_route_id = pa.master_table_route_id
514: and ptr.table_alias = l_table_alias

Line 566: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

562:
563: End If;
564: if p_gsp_node = '1' then
565: select bcer.information100 into st_icon from
566: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
567: where
568: bcer.table_route_id = ptr.table_route_id
569: and ptr.table_route_id = pa.master_table_route_id
570: and ptr.table_alias = l_table_alias

Line 575: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

571: and pa.attribute_name = p_gsp_node
572: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
573: elsif p_gsp_node = '2' then
574: select bcer.information101 into st_icon from
575: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
576: where
577: bcer.table_route_id = ptr.table_route_id
578: and ptr.table_route_id = pa.master_table_route_id
579: and ptr.table_alias = l_table_alias

Line 584: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

580: and pa.attribute_name = p_gsp_node
581: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
582: elsif p_gsp_node = '3' then
583: select bcer.information102 into st_icon from
584: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
585: where
586: bcer.table_route_id = ptr.table_route_id
587: and ptr.table_route_id = pa.master_table_route_id
588: and ptr.table_alias = l_table_alias

Line 593: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

589: and pa.attribute_name = p_gsp_node
590: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
591: elsif p_gsp_node = '4'then
592: select bcer.information103 into st_icon from
593: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
594: where
595: bcer.table_route_id = ptr.table_route_id
596: and ptr.table_route_id = pa.master_table_route_id
597: and ptr.table_alias = l_table_alias

Line 602: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

598: and pa.attribute_name = p_gsp_node
599: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
600: elsif p_gsp_node = '5' then
601: select bcer.information104 into st_icon from
602: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
603: where
604: bcer.table_route_id = ptr.table_route_id
605: and ptr.table_route_id = pa.master_table_route_id
606: and ptr.table_alias = l_table_alias

Line 611: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

607: and pa.attribute_name = p_gsp_node
608: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
609: elsif p_gsp_node = '6' then
610: select bcer.information105 into st_icon from
611: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
612: where
613: bcer.table_route_id = ptr.table_route_id
614: and ptr.table_route_id = pa.master_table_route_id
615: and ptr.table_alias = l_table_alias

Line 620: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

616: and pa.attribute_name = p_gsp_node
617: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
618: elsif p_gsp_node = '7' then
619: select bcer.information106 into st_icon from
620: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
621: where
622: bcer.table_route_id = ptr.table_route_id
623: and ptr.table_route_id = pa.master_table_route_id
624: and ptr.table_alias = l_table_alias

Line 658: FROM Ben_Copy_Entity_Results grdldr

654:
655: Cursor csr_use_points
656: IS
657: Select Decode(nvl(grdldr.INFORMATION18,'N'),'Y','POINT','STEP') /* INFORMATION18 -> Use Progression Points */
658: FROM Ben_Copy_Entity_Results grdldr
659: WHERE grdldr.Copy_Entity_Txn_Id = p_copy_entity_txn_id
660: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
661: AND grdldr.Table_Alias = 'PGM';
662:

Line 696: p_step_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,

692: ---------------------------remove_step_from_grade-----------------------------
693: --
694: Procedure remove_step_from_grade
695: (
696: p_step_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
697: p_copy_entity_txn_id IN number,
698: p_effective_date IN Date,
699: p_use_points IN varchar2,
700: p_step_id IN ben_copy_entity_results.information1%TYPE,

Line 700: p_step_id IN ben_copy_entity_results.information1%TYPE,

696: p_step_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
697: p_copy_entity_txn_id IN number,
698: p_effective_date IN Date,
699: p_use_points IN varchar2,
700: p_step_id IN ben_copy_entity_results.information1%TYPE,
701: p_celing_step_flag IN varchar2,
702: p_rec_exists OUT NOCOPY Varchar2
703: ) IS
704:

Line 737: From Ben_Copy_Entity_Results grdldr

733: -- To Get information1 (Pgm_ID) of PGM, based on TXN_ID
734: Cursor csr_pgm_id
735: IS
736: Select grdldr.information1 -- PGM_ID
737: From Ben_Copy_Entity_Results grdldr
738: Where grdldr.Copy_Entity_Txn_Id = p_copy_entity_txn_id
739: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
740: AND grdldr.Table_Alias = 'PGM';
741:

Line 747: From Ben_Copy_Entity_Results grdldr

743:
744: Cursor csr_corps_id
745: IS
746: Select grdldr.Information1
747: From Ben_Copy_Entity_Results grdldr
748: Where grdldr.Table_Alias = 'CPD'
749: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
750: And grdldr.Copy_Entity_Txn_Id = p_Copy_Entity_Txn_Id;
751:

Line 756: From Ben_Copy_Entity_Results grd

752: -- To Get information253 (Grade_id) of CPP, based on Step Result Id
753: Cursor csr_grade_id
754: IS
755: Select grd.information253
756: From Ben_Copy_Entity_Results grd
757: Where grd.Table_Alias = 'CPP'
758: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
759: AND grd.copy_entity_result_id = (Select step.gs_parent_entity_result_id
760: From Ben_Copy_Entity_Results step

Line 760: From Ben_Copy_Entity_Results step

756: From Ben_Copy_Entity_Results grd
757: Where grd.Table_Alias = 'CPP'
758: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
759: AND grd.copy_entity_result_id = (Select step.gs_parent_entity_result_id
760: From Ben_Copy_Entity_Results step
761: Where step.Copy_Entity_Result_Id= p_step_result_id
762: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
763: AND step.Table_Alias = 'COP');
764:

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

869: ---------------------------CHK_PROFILE_EXISTS-----------------------------
870: --
871:
872: FUNCTION CHK_PROFILE_EXISTS
873: ( p_copy_entity_result_id IN Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type,
874: p_copy_entity_txn_id IN Ben_Copy_Entity_Results.Copy_Entity_Txn_Id%Type
875: )
876: RETURN varchar2 IS
877:

Line 874: p_copy_entity_txn_id IN Ben_Copy_Entity_Results.Copy_Entity_Txn_Id%Type

870: --
871:
872: FUNCTION CHK_PROFILE_EXISTS
873: ( p_copy_entity_result_id IN Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type,
874: p_copy_entity_txn_id IN Ben_Copy_Entity_Results.Copy_Entity_Txn_Id%Type
875: )
876: RETURN varchar2 IS
877:
878: /* Author : mvankada

Line 886: From Ben_Copy_Entity_Results

882:
883: Cursor csr_profile_count
884: IS
885: Select '1'
886: From Ben_Copy_Entity_Results
887: Where Table_Alias = 'ELP'
888: And Gs_Parent_Entity_Result_Id = p_Copy_Entity_Result_Id
889: And Copy_Entity_Txn_Id = p_copy_entity_txn_id
890: And Result_type_Cd = 'DISPLAY'

Line 930: p_Table_Alias IN Ben_Copy_Entity_Results.Table_Alias%Type,

926: --
927:
928: FUNCTION DISPLAY_ICON
929: (p_page IN Varchar2,
930: p_Table_Alias IN Ben_Copy_Entity_Results.Table_Alias%Type,
931: p_action IN Varchar2,
932: p_copy_entity_txn_id IN Ben_Copy_Entity_Results.Copy_Entity_Txn_Id%Type,
933: p_copy_entity_result_id IN Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type
934: ) RETURN varchar2

Line 932: p_copy_entity_txn_id IN Ben_Copy_Entity_Results.Copy_Entity_Txn_Id%Type,

928: FUNCTION DISPLAY_ICON
929: (p_page IN Varchar2,
930: p_Table_Alias IN Ben_Copy_Entity_Results.Table_Alias%Type,
931: p_action IN Varchar2,
932: p_copy_entity_txn_id IN Ben_Copy_Entity_Results.Copy_Entity_Txn_Id%Type,
933: p_copy_entity_result_id IN Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type
934: ) RETURN varchar2
935: IS
936:

Line 933: p_copy_entity_result_id IN Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type

929: (p_page IN Varchar2,
930: p_Table_Alias IN Ben_Copy_Entity_Results.Table_Alias%Type,
931: p_action IN Varchar2,
932: p_copy_entity_txn_id IN Ben_Copy_Entity_Results.Copy_Entity_Txn_Id%Type,
933: p_copy_entity_result_id IN Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type
934: ) RETURN varchar2
935: IS
936:
937: /*

Line 968: From Ben_COpy_Entity_Results

964:
965: Cursor Csr_steps_exists
966: IS
967: Select Null
968: From Ben_COpy_Entity_Results
969: Where Gs_Parent_Entity_Result_Id = p_copy_entity_result_id
970: And table_alias ='COP'
971: And Copy_Entity_Txn_Id = p_copy_entity_txn_id
972: And result_type_cd = 'DISPLAY'

Line 1182: From Ben_Copy_Entity_Results oipl

1178: IS
1179: Select oipl.Information262, -- Point Cer Id
1180: oipl.Information259, -- Pay Scale Cer Id
1181: oipl.Gs_Parent_Entity_Result_id -- Grade Cer_id
1182: From Ben_Copy_Entity_Results oipl
1183: Where oipl.Copy_Entity_Result_Id = p_copy_entity_result_id
1184: And oipl.Copy_Entity_Txn_Id = p_copy_entity_Txn_id
1185: AND nvl(oipl.result_type_cd,'DISPLAY') = 'DISPLAY'
1186: And oipl.Table_Alias = 'COP';

Line 1192: From Ben_Copy_Entity_Results opt1,

1188:
1189: 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)
1190: IS
1191: Select count(*)
1192: From Ben_Copy_Entity_Results opt1,
1193: Ben_Copy_Entity_Results opt2,
1194: Ben_Copy_Entity_Results oipl
1195: Where oipl.Information262 = opt2.copy_entity_result_id
1196: And opt1.Information253 >= opt2.Information253

Line 1193: Ben_Copy_Entity_Results opt2,

1189: 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)
1190: IS
1191: Select count(*)
1192: From Ben_Copy_Entity_Results opt1,
1193: Ben_Copy_Entity_Results opt2,
1194: Ben_Copy_Entity_Results oipl
1195: Where oipl.Information262 = opt2.copy_entity_result_id
1196: And opt1.Information253 >= opt2.Information253
1197: And opt1.copy_entity_result_id = l_opt_cer_id

Line 1194: Ben_Copy_Entity_Results oipl

1190: IS
1191: Select count(*)
1192: From Ben_Copy_Entity_Results opt1,
1193: Ben_Copy_Entity_Results opt2,
1194: Ben_Copy_Entity_Results oipl
1195: Where oipl.Information262 = opt2.copy_entity_result_id
1196: And opt1.Information253 >= opt2.Information253
1197: And opt1.copy_entity_result_id = l_opt_cer_id
1198: And oipl.Information259 = l_pay_scale_cer_id -- Information259 is Pay Scale Cer Id

Line 1208: from ben_copy_entity_results

1204:
1205: Cursor csr_starting_step
1206: IS
1207: select information228
1208: from ben_copy_entity_results
1209: where copy_entity_result_id = l_grd_cer_id;
1210:
1211: BEGIN
1212: if g_debug then

Line 1257: p_Table_Alias in ben_copy_entity_results.Table_Alias%Type,

1253: --
1254:
1255: FUNCTION GET_STEP_PRG_RULE_HGRID_NAME( p_copy_entity_result_id in Number,
1256: p_copy_entity_txn_id in Number,
1257: p_Table_Alias in ben_copy_entity_results.Table_Alias%Type,
1258: p_hgrid in Varchar Default NULL)
1259: RETURN varchar2 IS
1260: /*
1261: Author : mvankada

Line 1275: From Ben_Copy_Entity_Results grdldr

1271: -- Grade Ladder : PGM information5 -- Name
1272:
1273: Cursor csr_grdldr_name IS
1274: Select grdldr.information5
1275: From Ben_Copy_Entity_Results grdldr
1276: Where grdldr.Copy_Entity_Result_Id = p_copy_entity_result_id
1277: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
1278: AND grdldr.Table_Alias= p_Table_Alias;
1279:

Line 1283: From Ben_Copy_Entity_Results grd

1279:
1280: -- Grade : CPP information5 -- Grade Name, information98 -- PayScale Name
1281: Cursor csr_grd_name IS
1282: Select grd.information5,information98
1283: From Ben_Copy_Entity_Results grd
1284: Where grd.Copy_Entity_Result_Id = p_copy_entity_result_id
1285: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
1286: AND grd.Table_Alias = p_Table_Alias;
1287:

Line 1291: From Ben_Copy_Entity_Results step

1287:
1288: -- Step : COP information5 -- Step Name, information99 -- Point Name
1289: Cursor csr_step_name IS
1290: Select step.information5 , information99
1291: From Ben_Copy_Entity_Results step
1292: Where step.Copy_Entity_Result_Id = p_copy_entity_result_id
1293: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
1294: AND step.Table_Alias = p_Table_Alias;
1295:

Line 1299: From Ben_Copy_Entity_Results elig

1295:
1296: -- Eligibility Profile : ELP information5 -- Profile Name
1297: Cursor csr_elig_name IS
1298: Select elig.information5
1299: From Ben_Copy_Entity_Results elig
1300: Where elig.Copy_Entity_Result_Id = p_copy_entity_result_id
1301: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
1302: AND elig.Table_Alias = p_Table_Alias;
1303:

Line 1306: From Ben_Copy_Entity_Results Opt

1302: AND elig.Table_Alias = p_Table_Alias;
1303:
1304: Cursor csr_corps_gross_index IS
1305: Select to_number(opt.information173)
1306: From Ben_Copy_Entity_Results Opt
1307: Where opt.Table_Alias = 'OPT'
1308: AND opt.Copy_Entity_Txn_id = p_copy_entity_txn_id
1309: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
1310: And opt.Copy_Entity_Result_Id = ( Select oipl.Information262 -- Point Cer Id

Line 1311: From Ben_Copy_Entity_Results oipl

1307: Where opt.Table_Alias = 'OPT'
1308: AND opt.Copy_Entity_Txn_id = p_copy_entity_txn_id
1309: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
1310: And opt.Copy_Entity_Result_Id = ( Select oipl.Information262 -- Point Cer Id
1311: From Ben_Copy_Entity_Results oipl
1312: Where Copy_Entity_Result_Id = p_copy_entity_result_id
1313: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
1314: And Copy_Entity_Txn_id = p_copy_entity_txn_id
1315: And Table_Alias = 'COP');

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

1466: p_name IN per_grades.name%TYPE,
1467: p_short_name IN per_grades.short_name%TYPE,
1468: p_business_group_id IN per_grades.business_group_id%TYPE,
1469: p_grade_id IN per_grades.grade_id%TYPE default NULL,
1470: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE default NULL,
1471: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,
1472: p_status OUT NOCOPY VARCHAR
1473: )
1474: IS

Line 1471: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,

1467: p_short_name IN per_grades.short_name%TYPE,
1468: p_business_group_id IN per_grades.business_group_id%TYPE,
1469: p_grade_id IN per_grades.grade_id%TYPE default NULL,
1470: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE default NULL,
1471: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,
1472: p_status OUT NOCOPY VARCHAR
1473: )
1474: IS
1475:

Line 1485: From ben_copy_entity_results

1481: And business_group_id = p_business_group_id
1482: And grade_id <> nvl(p_grade_id,-1)
1483: Union ALL
1484: Select null
1485: From ben_copy_entity_results
1486: Where
1487: information5 = p_name
1488: And information4 = p_business_group_id
1489: And table_alias = 'PLN'

Line 1503: From ben_copy_entity_results

1499: And business_group_id = p_business_group_id
1500: And grade_id <> nvl(p_grade_id,-1)
1501: Union ALL
1502: Select null
1503: From ben_copy_entity_results
1504: Where information102 = p_short_name
1505: And information4 = p_business_group_id
1506: And table_alias='PLN'
1507: And result_type_cd = 'DISPLAY'

Line 1566: From ben_copy_entity_results std

1562: RETURN number is
1563: --
1564: Cursor csr_std_rate is
1565: Select information98
1566: From ben_copy_entity_results std
1567: Where std.gs_parent_entity_result_id = p_copy_entity_result_id
1568: And std.table_alias = 'ABR'
1569: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
1570: AND p_effective_date between information2 and nvl(information3,to_date('31/12/4712','dd/mm/RRRR'));

Line 1604: delete from ben_copy_entity_results where copy_entity_txn_id = p_pqh_copy_entity_txn_id;

1600: (p_pqh_copy_entity_txn_id IN pqh_copy_entity_txns.copy_entity_txn_id%TYPE) IS
1601:
1602: begin
1603: delete from pqh_copy_entity_attribs where copy_entity_txn_id = p_pqh_copy_entity_txn_id;
1604: delete from ben_copy_entity_results where copy_entity_txn_id = p_pqh_copy_entity_txn_id;
1605: end del_gl_details_from_stage;
1606:
1607: --
1608: ---------------------------enddate_grade_ladder-----------------------------

Line 1619: (select copy_entity_txn_id from ben_copy_entity_results

1615: 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;
1616:
1617: Cursor c2 is
1618: select copy_entity_txn_id from pqh_copy_entity_txns where copy_entity_txn_id in
1619: (select copy_entity_txn_id from ben_copy_entity_results
1620: where information1 = p_ben_pgm_id and table_alias = 'PGM' and information_category = 'GRADE_LADDER'
1621: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY')
1622: and status = 'SFL';
1623:

Line 1918: select information5 grade_ladder_name from ben_copy_entity_results

1914: Function get_grade_ladder_name_from_txn
1915: (p_pqh_copy_entity_txn_id IN pqh_copy_entity_txns.copy_entity_txn_id%TYPE)
1916: Return Varchar2 is
1917: cursor c1 is
1918: select information5 grade_ladder_name from ben_copy_entity_results
1919: where copy_entity_txn_id = p_pqh_copy_entity_txn_id
1920: and table_alias = 'PGM'
1921: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
1922: and information_category = 'GRADE_LADDER';

Line 2037: l_copy_entity_result_id Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type;

2033: are added to all the Grades.
2034: */
2035:
2036: l_proc varchar2(72) := g_package|| 'chk_add_steps_in_all_grades';
2037: l_copy_entity_result_id Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type;
2038: l_grade_name Ben_Copy_Entity_Results.Information5%type;
2039: l_dummy Varchar2(10);
2040: l_no_step_grades Varchar2(2000) := null;
2041: l_no_ceil_grades Varchar2(2000) := null;

Line 2038: l_grade_name Ben_Copy_Entity_Results.Information5%type;

2034: */
2035:
2036: l_proc varchar2(72) := g_package|| 'chk_add_steps_in_all_grades';
2037: l_copy_entity_result_id Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type;
2038: l_grade_name Ben_Copy_Entity_Results.Information5%type;
2039: l_dummy Varchar2(10);
2040: l_no_step_grades Varchar2(2000) := null;
2041: l_no_ceil_grades Varchar2(2000) := null;
2042: l_found1 Boolean := FALSE;

Line 2050: FROM BEN_COPY_ENTITY_RESULTS step

2046:
2047: Cursor csr_steps_exists
2048: IS
2049: Select Null
2050: FROM BEN_COPY_ENTITY_RESULTS step
2051: WHERE step.copy_entity_txn_id = p_copy_entity_txn_id
2052: AND step.TABLE_ALIAS ='COP'
2053: And nvl(step.INFORMATION104,'PPP') <> 'UNLINK'
2054: AND step.result_type_cd = 'DISPLAY';

Line 2059: From Ben_Copy_Entity_Results grd

2055:
2056:
2057: Cursor csr_grades IS
2058: Select grd.Copy_Entity_Result_Id, grd.Information5
2059: From Ben_Copy_Entity_Results grd
2060: Where grd.Copy_Entity_txn_Id = p_copy_entity_txn_id
2061: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
2062: And nvl(grd.Information104,'PPP') <> 'UNLINK'
2063: And grd.Table_Alias = 'CPP'

Line 2069: From Ben_Copy_Entity_Results step

2065:
2066:
2067: Cursor csr_steps(p_copy_entity_result_id in number) IS
2068: Select Null
2069: From Ben_Copy_Entity_Results step
2070: Where step.Copy_Entity_txn_Id = p_copy_entity_txn_id
2071: And step.Gs_Parent_Entity_Result_Id = p_copy_entity_result_id
2072: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
2073: And step.Table_Alias = 'COP'

Line 2080: From Ben_Copy_Entity_Results ceiling

2076:
2077:
2078: Cursor csr_celing_step(p_copy_entity_result_id in number) IS
2079: Select Null
2080: From Ben_Copy_Entity_Results ceiling
2081: Where ceiling.Copy_Entity_txn_Id = p_copy_entity_txn_id
2082: And ceiling.Gs_Parent_Entity_Result_Id = p_copy_entity_result_id
2083: And ceiling.Table_Alias = 'COP'
2084: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'

Line 2175: l_dummy Ben_Copy_Entity_Results.Information5%Type;

2171: grade ladder effective date
2172: */
2173:
2174: l_proc varchar2(72) := g_package|| 'chk_valid_grd_in_grdldr';
2175: l_dummy Ben_Copy_Entity_Results.Information5%Type;
2176: l_grades Varchar2(2000);
2177: l_found Boolean := FALSE;
2178:
2179: -- This cursor checks the newly created grades

Line 2190: From Ben_Copy_Entity_Results grd

2186: Cursor csr_grades IS
2187: Select grd.Information5 ,
2188: grd.Information306,
2189: grd.Information307
2190: From Ben_Copy_Entity_Results grd
2191: Where grd.Copy_Entity_txn_Id = p_copy_entity_txn_id
2192: AND grd.Table_Alias = 'CPP'
2193: AND nvl(grd.Information104,'PPP') <> 'UNLINK'
2194: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'

Line 2417: From Ben_Copy_Entity_Results grdldr

2413: -- To Get Pgm_Id of PGM based on Txn_id
2414: Cursor csr_pgm_id
2415: IS
2416: Select grdldr.Information1
2417: From Ben_Copy_Entity_Results grdldr
2418: Where grdldr.Table_Alias = 'PGM'
2419: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
2420: And grdldr.Copy_Entity_Txn_Id = p_Copy_Entity_Txn_Id;
2421:

Line 2426: From Ben_Copy_Entity_Results grd

2422: -- To Get Grade_Id (information253) of CPP based on Result_id of CPP
2423: Cursor csr_grade_id
2424: IS
2425: Select grd.Information253
2426: From Ben_Copy_Entity_Results grd
2427: Where grd.Table_Alias = 'CPP'
2428: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
2429: And grd.Copy_Entity_Result_Id = p_Grade_Result_Id;
2430:

Line 2435: From Ben_Copy_Entity_Results pln

2431: -- Get Plan Record
2432: Cursor csr_plan_result_id
2433: IS
2434: Select pln.Copy_Entity_Result_Id
2435: From Ben_Copy_Entity_Results pln
2436: Where pln.Gs_Mirror_Src_Entity_Result_Id = p_grade_result_id
2437: And pln.Copy_Entity_Txn_Id = p_copy_entity_txn_id
2438: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
2439: And pln.Table_Alias = 'PLN';

Line 2445: From Ben_Copy_Entity_Results

2441:
2442: Cursor csr_ovn (l_result_id in Number)
2443: IS
2444: Select Object_Version_Number
2445: From Ben_Copy_Entity_Results
2446: Where Copy_Entity_Result_Id = l_result_id;
2447:
2448: l_pgm_id Number;
2449: l_grade_id Number;

Line 2490: ben_copy_entity_results_api.update_copy_entity_results(

2486: Open csr_ovn(p_grade_result_id);
2487: Fetch csr_ovn into l_ovn;
2488: Close csr_ovn;
2489:
2490: ben_copy_entity_results_api.update_copy_entity_results(
2491: p_copy_entity_result_id => p_grade_result_id,
2492: p_effective_date => p_effective_date,
2493: p_information104 => 'UNLINK',
2494: p_object_version_number => l_ovn,

Line 2513: ben_copy_entity_results_api.update_copy_entity_results(

2509: Open csr_ovn(l_pln_result_id);
2510: Fetch csr_ovn into l_ovn;
2511: Close csr_ovn;
2512:
2513: ben_copy_entity_results_api.update_copy_entity_results(
2514: p_copy_entity_result_id => l_pln_result_id,
2515: p_effective_date => p_effective_date,
2516: p_Gs_Mr_Src_Entity_Result_Id => NULL,
2517: p_object_version_number => l_ovn,

Line 2527: ben_copy_entity_results_api.delete_copy_entity_results(

2523: Open csr_ovn(p_grade_result_id);
2524: Fetch csr_ovn into l_ovn;
2525: Close csr_ovn;
2526:
2527: ben_copy_entity_results_api.delete_copy_entity_results(
2528: p_copy_entity_result_id => p_grade_result_id,
2529: p_effective_date => p_effective_date,
2530: p_object_version_number => l_ovn);
2531: end if;

Line 2574: From Ben_Copy_Entity_Results grdldr

2570: -- To Get information1 (Pgm_ID) of PGM, based on TXN_ID
2571: Cursor csr_pgm_id
2572: IS
2573: Select grdldr.information1 -- PGM_ID
2574: From Ben_Copy_Entity_Results grdldr
2575: Where grdldr.Copy_Entity_Txn_Id = p_copy_entity_txn_id
2576: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
2577: AND grdldr.Table_Alias = 'PGM';
2578:

Line 2583: From Ben_Copy_Entity_Results grd

2579: -- To Get information253 (Grade_id) of CPP, based on Step Result Id
2580: Cursor csr_grade_id
2581: IS
2582: Select grd.information253
2583: From Ben_Copy_Entity_Results grd
2584: Where grd.Table_Alias = 'CPP'
2585: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
2586: AND grd.copy_entity_result_id = (Select step.gs_parent_entity_result_id
2587: From Ben_Copy_Entity_Results step

Line 2587: From Ben_Copy_Entity_Results step

2583: From Ben_Copy_Entity_Results grd
2584: Where grd.Table_Alias = 'CPP'
2585: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
2586: AND grd.copy_entity_result_id = (Select step.gs_parent_entity_result_id
2587: From Ben_Copy_Entity_Results step
2588: Where step.Copy_Entity_Result_Id= p_step_result_id
2589: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
2590: AND step.Table_Alias = 'COP');
2591:

Line 2595: From Ben_Copy_Entity_Results

2591:
2592: Cursor csr_ovn (l_result_id in Number)
2593: IS
2594: Select Object_Version_Number
2595: From Ben_Copy_Entity_Results
2596: Where Copy_Entity_Result_Id = l_result_id;
2597:
2598:
2599: l_pgm_id Number;

Line 2650: ben_copy_entity_results_api.update_copy_entity_results(

2646:
2647: Open csr_ovn(p_point_result_id);
2648: Fetch csr_ovn into l_ovn;
2649: Close csr_ovn;
2650: ben_copy_entity_results_api.update_copy_entity_results(
2651: p_copy_entity_result_id => p_point_result_id,
2652: p_effective_date => p_effective_date,
2653: p_information104 => 'UNLINK',
2654: p_object_version_number => l_ovn,

Line 2668: ben_copy_entity_results_api.update_copy_entity_results(

2664:
2665: Open csr_ovn(p_step_result_id);
2666: Fetch csr_ovn into l_ovn;
2667: Close csr_ovn;
2668: ben_copy_entity_results_api.update_copy_entity_results(
2669: p_copy_entity_result_id => p_step_result_id,
2670: p_effective_date => p_effective_date,
2671: p_information104 => 'UNLINK',
2672: p_object_version_number => l_ovn,

Line 2689: ben_copy_entity_results_api.delete_copy_entity_results(

2685:
2686: Open csr_ovn(p_point_result_id);
2687: Fetch csr_ovn into l_ovn;
2688: Close csr_ovn;
2689: ben_copy_entity_results_api.delete_copy_entity_results(
2690: p_copy_entity_result_id => p_point_result_id,
2691: p_effective_date => p_effective_date,
2692: p_object_version_number => l_ovn);
2693: end if;

Line 2704: ben_copy_entity_results_api.delete_copy_entity_results(

2700:
2701: Open csr_ovn(p_step_result_id);
2702: Fetch csr_ovn into l_ovn;
2703: Close csr_ovn;
2704: ben_copy_entity_results_api.delete_copy_entity_results(
2705: p_copy_entity_result_id => p_step_result_id,
2706: p_effective_date => p_effective_date,
2707: p_object_version_number => l_ovn);
2708: end if;

Line 2734: from ben_copy_entity_results oipl,

2730: CURSOR csr_points
2731: IS
2732: select oipl.copy_entity_result_id,
2733: oipl.object_version_number
2734: from ben_copy_entity_results oipl,
2735: ben_copy_entity_results opt
2736: where nvl(oipl.information104,'PPP') <> 'UNLINK'
2737: AND nvl(oipl.result_type_cd,'DISPLAY') = 'DISPLAY'
2738: AND nvl(opt.result_type_cd,'DISPLAY') = 'DISPLAY'

Line 2735: ben_copy_entity_results opt

2731: IS
2732: select oipl.copy_entity_result_id,
2733: oipl.object_version_number
2734: from ben_copy_entity_results oipl,
2735: ben_copy_entity_results opt
2736: where nvl(oipl.information104,'PPP') <> 'UNLINK'
2737: AND nvl(oipl.result_type_cd,'DISPLAY') = 'DISPLAY'
2738: AND nvl(opt.result_type_cd,'DISPLAY') = 'DISPLAY'
2739: and oipl.table_alias = 'COP'

Line 2755: ben_copy_entity_results_api.update_copy_entity_results(

2751: hr_utility.set_location('p_grd_result_id:'||p_grd_result_id, 30);
2752: end if;
2753: for i in csr_points loop
2754: stepnum :=stepnum+1;
2755: ben_copy_entity_results_api.update_copy_entity_results(
2756: p_copy_entity_result_id => i.copy_entity_result_id,
2757: p_effective_date => p_effective_start_date,
2758: p_copy_entity_txn_id => p_copy_entity_txn_id,
2759: p_information5 => fnd_message.get_string('PQH','PQH_GSP_STEP_PROMPT')||stepnum,

Line 2794: From Ben_Copy_Entity_Results

2790: Cursor csr_grades
2791: IS
2792: Select Information253, -- Grade Id
2793: Information5 -- Grade Name
2794: From Ben_Copy_Entity_Results
2795: Where Copy_Entity_Txn_Id = p_copy_entity_txn_id
2796: And Table_Alias = 'CPP'
2797: And Information253 IS NOT NULL
2798: AND Nvl(Information104,'PPP') = 'UNLINK'

Line 2943: From Ben_Copy_Entity_Results

2939: IS
2940: Select Information253, -- Step Id
2941: Information5 -- Step Name
2942: INFORMATION98 -- Ceiling Flag
2943: From Ben_Copy_Entity_Results
2944: Where Copy_Entity_Txn_Id = p_copy_entity_txn_id
2945: And Table_Alias = 'COP'
2946: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
2947: And Information253 IS NOT NULL

Line 3210: from Ben_Copy_Entity_Results

3206: -- fix for bug 7114098
3207: l_pgm_id number;
3208: cursor csr_pgm_val is
3209: select information1
3210: from Ben_Copy_Entity_Results
3211: where Copy_Entity_Txn_Id = p_copy_entity_txn_id
3212: and Information4 = p_business_group_id
3213: and table_alias = 'PGM' ;
3214:

Line 3223: From Ben_Copy_Entity_Results

3219: IS
3220: Select Copy_Entity_Result_Id,
3221: Information50, -- Currency_Code
3222: Information41 -- Rate_Period
3223: From Ben_Copy_Entity_Results
3224: Where Copy_Entity_Txn_Id = p_copy_entity_txn_id
3225: AND Table_Alias = 'PGM'
3226: AND Result_Type_Cd = 'DISPLAY'
3227: AND Nvl(Information104,'PPP') <> 'UNLINK'

Line 3236: From Ben_Copy_Entity_Results

3232: Cursor csr_grade_ids(l_grdldr_result_id IN Number)
3233: IS
3234: Select Information253, -- Grade Id
3235: Information5 -- Grade Name
3236: From Ben_Copy_Entity_Results
3237: Where Gs_Parent_Entity_Result_Id = l_grdldr_result_id
3238: And Copy_Entity_Txn_Id = p_copy_entity_txn_id
3239: And Table_Alias = 'CPP'
3240: AND Nvl(Information104,'PPP') <> 'UNLINK'

Line 3273: l_curr_gl_currency Ben_Copy_Entity_Results.Information50%Type;

3269: and l_pgm_id <> pgm.pgm_id; -- added for bug 7114098
3270:
3271: l_proc varchar2(72) := g_package|| 'chk_grdldr_grd_curreny_rate';
3272: l_curr_gl_result_id Number;
3273: l_curr_gl_currency Ben_Copy_Entity_Results.Information50%Type;
3274: l_curr_gl_period Ben_Copy_Entity_Results.Information41%Type;
3275:
3276: l_target_currency Ben_Pgm_F.PGM_UOM%Type;
3277: l_target_period Ben_Pgm_F.ACTY_REF_PERD_CD%Type;

Line 3274: l_curr_gl_period Ben_Copy_Entity_Results.Information41%Type;

3270:
3271: l_proc varchar2(72) := g_package|| 'chk_grdldr_grd_curreny_rate';
3272: l_curr_gl_result_id Number;
3273: l_curr_gl_currency Ben_Copy_Entity_Results.Information50%Type;
3274: l_curr_gl_period Ben_Copy_Entity_Results.Information41%Type;
3275:
3276: l_target_currency Ben_Pgm_F.PGM_UOM%Type;
3277: l_target_period Ben_Pgm_F.ACTY_REF_PERD_CD%Type;
3278:

Line 3366: from ben_copy_entity_results

3362: -- Select all crsets in the txn which are not equal to current crset
3363: --
3364: cursor csr_crset is
3365: select *
3366: from ben_copy_entity_results
3367: where copy_entity_txn_id = p_copy_entity_txn_id
3368: and table_alias = 'CRSET'
3369: and p_effective_date between information2 and nvl(information3, to_date('31/12/4712','dd/mm/RRRR'))
3370: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'

Line 3421: from ben_copy_entity_results

3417: is
3418: --
3419: cursor csr_crset is
3420: select *
3421: from ben_copy_entity_results
3422: where copy_entity_txn_id = p_copy_entity_txn_id
3423: and table_alias = 'CRSET'
3424: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
3425: and dml_operation in ('INSERT','UPDATE') -- Check only insert/ updates crset

Line 3570: From Ben_Copy_Entity_Results

3566:
3567: Cursor csr_grdldr_date
3568: IS
3569: Select Information2 EFFECTIVE_START_DATE
3570: From Ben_Copy_Entity_Results
3571: Where Copy_Entity_Txn_id = p_copy_entity_txn_id
3572: And Information4 = p_business_group_id
3573: And Table_Alias = 'PGM'
3574: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'

Line 3762: FROM BEN_COPY_ENTITY_RESULTS

3758: Function get_which_rates (p_copy_entity_txn_id in Number) Return Varchar2 is
3759: cursor c1 is
3760: select 1 from dual where exists (
3761: select 1
3762: FROM BEN_COPY_ENTITY_RESULTS
3763: WHERE NVL(INFORMATION104,'PPP') NOT IN ('UNLINK')
3764: AND TABLE_ALIAS ='COP'
3765: AND copy_entity_txn_id = p_copy_entity_txn_id
3766: AND result_type_cd = 'DISPLAY'

Line 3802: select 1 from ben_copy_entity_results

3798: l_icon varchar2(20) := 'NONE';
3799: cnt number := 0;
3800: cursor c1 is
3801: select 1 from dual where exists (
3802: select 1 from ben_copy_entity_results
3803: where copy_entity_txn_id = p_copy_entity_txn_id
3804: and gs_parent_entity_result_id = p_copy_entity_result_id);
3805: l_proc varchar2(72) := g_package||'.get_rates_icon_enabled';
3806: begin

Line 3987: from ben_copy_entity_results

3983: is
3984: cursor csr_steps_for_point
3985: is
3986: select null
3987: from ben_copy_entity_results
3988: where copy_entity_txn_id = p_copy_entity_txn_id
3989: and information262 = p_points_result_id
3990: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
3991: and information104 = 'LINK';

Line 4014: from ben_copy_entity_results

4010: is
4011: cursor csr_scale_name
4012: is
4013: select null
4014: from ben_copy_entity_results
4015: where copy_entity_txn_id = p_copy_entity_txn_id
4016: and copy_entity_result_id <> p_copy_entity_result_id
4017: and information98 = p_name
4018: and table_alias = 'SCALE'

Line 4029: from ben_copy_entity_results

4025:
4026: Cursor plip_details
4027: is
4028: select information98,copy_entity_result_id,dml_operation
4029: from ben_copy_entity_results
4030: where copy_entity_txn_id = p_copy_entity_txn_id
4031: and table_alias = 'CPP'
4032: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
4033: and information258 = p_copy_entity_result_id;

Line 4042: update ben_copy_entity_results

4038: if(csr_scale_name%NOTFOUND) then
4039: p_status := 'Y';
4040: for i in plip_details loop
4041: if i.information98<>p_name THEN
4042: update ben_copy_entity_results
4043: set information98 = p_name,
4044: dml_operation = get_dml_operation(i.dml_operation)
4045: where copy_entity_result_id = i.copy_entity_result_id;
4046:

Line 4251: from ben_copy_entity_results

4247:
4248: cursor csr_steps_in_grade
4249: is
4250: select count(*) cnt
4251: from ben_copy_entity_results
4252: where table_alias = 'COP'
4253: and copy_entity_txn_id = p_copy_entity_txn_id
4254: and gs_parent_entity_result_id in
4255: (select gs_mirror_src_entity_result_id

Line 4256: from ben_copy_entity_results

4252: where table_alias = 'COP'
4253: and copy_entity_txn_id = p_copy_entity_txn_id
4254: and gs_parent_entity_result_id in
4255: (select gs_mirror_src_entity_result_id
4256: from ben_copy_entity_results
4257: where table_alias = 'PLN' and copy_entity_txn_id = p_copy_entity_txn_id
4258: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY' and copy_entity_result_id = p_grade_cer_id)
4259: And result_type_cd = 'DISPLAY'
4260: And Nvl(Information104,'PPP') <> 'UNLINK';

Line 4292: From ben_copy_entity_results

4288: -- Local variables
4289: --
4290: Cursor csr_dflt_point_rate is
4291: Select information297
4292: From ben_copy_entity_results
4293: Where copy_entity_txn_id = p_copy_entity_txn_id
4294: and INFORMATION278 = p_point_cer_id
4295: and p_effective_date between information2 and information3
4296: and table_alias = 'HRRATE'

Line 4417: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,

4413:
4414: -------------------------------------------------------------------
4415: procedure update_oipl_records(
4416: p_effective_date IN DATE,
4417: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
4418: p_point_name IN ben_copy_entity_results.information99%TYPE,
4419: p_sequence IN ben_copy_entity_results.information263%TYPE,
4420: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE
4421: )

Line 4418: p_point_name IN ben_copy_entity_results.information99%TYPE,

4414: -------------------------------------------------------------------
4415: procedure update_oipl_records(
4416: p_effective_date IN DATE,
4417: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
4418: p_point_name IN ben_copy_entity_results.information99%TYPE,
4419: p_sequence IN ben_copy_entity_results.information263%TYPE,
4420: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE
4421: )
4422: IS

Line 4419: p_sequence IN ben_copy_entity_results.information263%TYPE,

4415: procedure update_oipl_records(
4416: p_effective_date IN DATE,
4417: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
4418: p_point_name IN ben_copy_entity_results.information99%TYPE,
4419: p_sequence IN ben_copy_entity_results.information263%TYPE,
4420: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE
4421: )
4422: IS
4423:

Line 4420: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE

4416: p_effective_date IN DATE,
4417: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
4418: p_point_name IN ben_copy_entity_results.information99%TYPE,
4419: p_sequence IN ben_copy_entity_results.information263%TYPE,
4420: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE
4421: )
4422: IS
4423:
4424:

Line 4428: from ben_copy_entity_results

4424:
4425: cursor csr_oipl_records
4426: is
4427: select copy_entity_result_id,object_version_number,dml_operation
4428: from ben_copy_entity_results
4429: where table_alias = 'COP'
4430: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
4431: and information262 = p_copy_entity_result_id
4432: and copy_entity_txn_id = p_copy_entity_txn_id;

Line 4439: ben_copy_entity_results_api.update_copy_entity_results(

4435: begin
4436: for r_oipl_record in csr_oipl_records loop
4437:
4438: l_ovn := r_oipl_record.object_version_number;
4439: ben_copy_entity_results_api.update_copy_entity_results(
4440: p_effective_date => p_effective_date,
4441: p_copy_entity_result_id => r_oipl_record.copy_entity_result_id,
4442: p_information99 => p_point_name,
4443: p_information263 => p_sequence,

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

4612: --------- get_dml_operation -----------
4613: --
4614:
4615: FUNCTION GET_DML_OPERATION
4616: (p_in_dml_operation IN ben_copy_entity_results.dml_operation%TYPE)
4617: return VARCHAR2
4618: is
4619: p_out_dml_operation ben_copy_entity_results.dml_operation%TYPE;
4620:

Line 4619: p_out_dml_operation ben_copy_entity_results.dml_operation%TYPE;

4615: FUNCTION GET_DML_OPERATION
4616: (p_in_dml_operation IN ben_copy_entity_results.dml_operation%TYPE)
4617: return VARCHAR2
4618: is
4619: p_out_dml_operation ben_copy_entity_results.dml_operation%TYPE;
4620:
4621: begin
4622: IF p_in_dml_operation = 'REUSE' THEN
4623: p_out_dml_operation := 'UPDATE';

Line 4715: FROM ben_copy_entity_results

4711:
4712: CURSOR csr_grade_id
4713: IS
4714: SELECT information253
4715: FROM ben_copy_entity_results
4716: WHERE copy_entity_result_id = p_grade_cer_id
4717: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY';
4718:
4719: CURSOR csr_gspine_id (p_grade_id IN NUMBER)

Line 4766: UPDATE ben_copy_entity_results

4762:
4763: PROCEDURE unlink_step_or_point (p_copy_entity_result_id IN NUMBER)
4764: IS
4765: BEGIN
4766: UPDATE ben_copy_entity_results
4767: SET information104 = 'UNLINK'
4768: WHERE copy_entity_result_id = p_copy_entity_result_id;
4769: END unlink_step_or_point;
4770: --------------------------------------------------------------------------

Line 4783: FROM ben_copy_entity_results

4779: IS
4780: CURSOR csr_steps_for_point
4781: IS
4782: SELECT NULL
4783: FROM ben_copy_entity_results
4784: WHERE copy_entity_txn_id = p_copy_entity_txn_id
4785: AND information262 = p_opt_cer_id
4786: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
4787: AND information104 = 'LINK';

Line 4830: FROM ben_copy_entity_results

4826: */
4827: CURSOR csr_init_step
4828: IS
4829: SELECT object_version_number, dml_operation
4830: FROM ben_copy_entity_results
4831: WHERE copy_entity_result_id = p_initial_ceiling_id;
4832:
4833: CURSOR csr_final_step
4834: IS

Line 4837: FROM ben_copy_entity_results

4833: CURSOR csr_final_step
4834: IS
4835: SELECT object_version_number, dml_operation, information253,
4836: information255, information263
4837: FROM ben_copy_entity_results
4838: WHERE copy_entity_result_id = p_final_ceiling_id;
4839:
4840: CURSOR csr_grade
4841: IS

Line 4843: FROM ben_copy_entity_results

4839:
4840: CURSOR csr_grade
4841: IS
4842: SELECT object_version_number, dml_operation
4843: FROM ben_copy_entity_results
4844: WHERE copy_entity_result_id = p_grade_result_id;
4845:
4846: l_initial_step csr_init_step%ROWTYPE;
4847: l_final_step csr_final_step%ROWTYPE;

Line 4885: ben_copy_entity_results_api.update_copy_entity_results (

4881: p_gspine_id => l_gspine_id,
4882: p_new_ceil => l_final_step.information263
4883: );
4884: END IF;
4885: ben_copy_entity_results_api.update_copy_entity_results (
4886: p_copy_entity_result_id => p_final_ceiling_id,
4887: p_effective_date => p_effective_date,
4888: p_copy_entity_txn_id => p_copy_entity_txn_id,
4889: p_information98 => 'Y',

Line 4909: ben_copy_entity_results_api.update_copy_entity_results (

4905: FETCH csr_init_step INTO l_initial_step;
4906:
4907: IF (csr_init_step%FOUND)
4908: THEN
4909: ben_copy_entity_results_api.update_copy_entity_results (
4910: p_copy_entity_result_id => p_initial_ceiling_id,
4911: p_effective_date => p_effective_date,
4912: p_copy_entity_txn_id => p_copy_entity_txn_id,
4913: p_information98 => 'N',

Line 4926: ben_copy_entity_results_api.update_copy_entity_results (

4922: CLOSE csr_init_step;
4923: OPEN csr_grade;
4924: FETCH csr_grade INTO l_grade;
4925: CLOSE csr_grade;
4926: ben_copy_entity_results_api.update_copy_entity_results (
4927: p_copy_entity_result_id => p_grade_result_id,
4928: p_effective_date => p_effective_date,
4929: p_copy_entity_txn_id => p_copy_entity_txn_id,
4930: p_information103 => 'Y',

Line 4966: FROM ben_copy_entity_results

4962: */
4963: CURSOR csr_steps_in_grade
4964: IS
4965: SELECT NULL
4966: FROM ben_copy_entity_results
4967: WHERE table_alias = 'COP'
4968: AND copy_entity_txn_id = p_copy_entity_txn_id
4969: AND gs_parent_entity_result_id = p_grade_result_id
4970: AND result_type_cd = 'DISPLAY'

Line 4976: FROM ben_copy_entity_results

4972:
4973: CURSOR csr_grade_scale_dets
4974: IS
4975: SELECT information253, information255
4976: FROM ben_copy_entity_results
4977: WHERE copy_entity_result_id = p_grade_result_id;
4978:
4979:
4980: cursor c1(p_pspine_id IN Number,

Line 5074: select copy_entity_txn_id, information297 from ben_copy_entity_results

5070: dflt_sal_rate Number := null;
5071:
5072:
5073: cursor grd_rates(l_action_dt in date) is
5074: select copy_entity_txn_id, information297 from ben_copy_entity_results
5075: where
5076: copy_entity_txn_id = p_copy_entity_txn_id
5077: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
5078: and information277 in (

Line 5080: from ben_copy_entity_results

5076: copy_entity_txn_id = p_copy_entity_txn_id
5077: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
5078: and information277 in (
5079: select copy_entity_result_id
5080: from ben_copy_entity_results
5081: where table_alias ='PLN'
5082: and result_type_cd = 'DISPLAY'
5083: and gs_mirror_src_entity_result_id = p_copy_entity_result_id)
5084: and table_alias = 'HRRATE' and l_action_dt

Line 5093: select information262 from ben_copy_entity_results

5089: From Pqh_Copy_Entity_txns
5090: Where Copy_Entity_Txn_id = p_copy_entity_txn_id;
5091:
5092: cursor point_cer is
5093: select information262 from ben_copy_entity_results
5094: where
5095: copy_entity_txn_id = p_copy_entity_txn_id
5096: and
5097: copy_entity_result_id = p_copy_entity_result_id;

Line 5100: select copy_entity_Txn_id, information297 from ben_copy_entity_results

5096: and
5097: copy_entity_result_id = p_copy_entity_result_id;
5098:
5099: cursor pnt_rates(point_cer_id number,l_action_dt in date) is
5100: select copy_entity_Txn_id, information297 from ben_copy_entity_results
5101: where
5102: copy_entity_txn_id = p_copy_entity_txn_id
5103: and information278 = point_cer_id
5104: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'

Line 5275: from ben_copy_entity_results

5271: IS
5272: Cursor csr_is_steps
5273: Is
5274: select information18
5275: from ben_copy_entity_results
5276: where table_alias = 'PGM'
5277: and copy_entity_txn_id = p_copy_entity_txn_id
5278: and result_type_cd = 'DISPLAY';
5279: Cursor csr_crrate

Line 5282: from ben_copy_entity_results

5278: and result_type_cd = 'DISPLAY';
5279: Cursor csr_crrate
5280: is
5281: select null
5282: from ben_copy_entity_results
5283: where information160 = p_crset_id
5284: and table_alias = 'CRRATE'
5285: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
5286: and copy_entity_txn_id = p_copy_entity_txn_id

Line 5289: from ben_copy_entity_results

5285: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
5286: and copy_entity_txn_id = p_copy_entity_txn_id
5287: and information169 in
5288: (select copy_entity_result_id
5289: from ben_copy_entity_results
5290: where table_alias = 'OPT'
5291: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
5292: and information256 = p_scale_cer_id
5293: and copy_entity_txn_id = p_copy_entity_txn_id);

Line 5322: from ben_copy_entity_results

5318: is
5319: Cursor csr_is_steps
5320: Is
5321: select information18
5322: from ben_copy_entity_results
5323: where table_alias = 'PGM'
5324: and copy_entity_txn_id = p_copy_entity_txn_id
5325: and result_type_cd = 'DISPLAY';
5326:

Line 5330: from ben_copy_entity_results

5326:
5327: Cursor csr_plan_dtls
5328: Is
5329: select Gs_Mirror_Src_Entity_Result_Id,object_version_number
5330: from ben_copy_entity_results
5331: where copy_entity_result_id = p_pl_cer_id
5332: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
5333: and copy_entity_txn_id = p_copy_entity_txn_id
5334: and table_alias = 'PLN';

Line 5339: from ben_copy_entity_results

5335:
5336: Cursor csr_plip_dtls(p_plip_cer_id in number)
5337: Is
5338: select information258,copy_entity_result_id,dml_operation
5339: from ben_copy_entity_results
5340: where table_alias = 'CPP'
5341: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
5342: and copy_entity_txn_id = p_copy_entity_txn_id
5343: and copy_entity_result_id = p_plip_cer_id;

Line 5348: from ben_copy_entity_results

5344:
5345: Cursor csr_scale_dtls(p_scale_cer_id in number)
5346: Is
5347: Select Information98,copy_entity_result_id,dml_operation
5348: from ben_copy_entity_results
5349: where copy_entity_result_id = p_scale_cer_id
5350: and table_alias = 'SCALE'
5351: and copy_entity_txn_id = p_copy_entity_txn_id;
5352:

Line 5392: update ben_copy_entity_results

5388: return;
5389: else
5390: hr_utility.set_location('Got some work to do..',55);
5391:
5392: update ben_copy_entity_results
5393: set information98 = p_short_name
5394: , dml_operation = get_dml_operation(l_scale_dtls.dml_operation)
5395: where copy_entity_result_id = l_scale_dtls.copy_entity_result_id;
5396:

Line 5397: update ben_copy_entity_results

5393: set information98 = p_short_name
5394: , dml_operation = get_dml_operation(l_scale_dtls.dml_operation)
5395: where copy_entity_result_id = l_scale_dtls.copy_entity_result_id;
5396:
5397: update ben_copy_entity_results
5398: set information98 = p_short_name
5399: ,dml_operation = get_dml_operation(l_plip_dtls.dml_operation)
5400: where copy_entity_result_id = l_plip_dtls.copy_entity_result_id;
5401:

Line 5415: FROM ben_copy_entity_results

5411: CURSOR csr_steps_in_grade
5412: IS
5413: SELECT copy_entity_result_id,
5414: dml_operation
5415: FROM ben_copy_entity_results
5416: WHERE table_alias = 'COP'
5417: AND copy_entity_txn_id = p_copy_entity_txn_id
5418: AND gs_parent_entity_result_id = p_grade_result_id
5419: AND result_type_cd = 'DISPLAY'

Line 5436: /* update ben_copy_entity_results

5432: Close Csr_Action_Dt;
5433:
5434: for rec_steps in csr_steps_in_grade loop
5435:
5436: /* update ben_copy_entity_results
5437: set copy_entity_result_id = rec_steps.copy_entity_result_id,
5438: information104 = 'UNLINK',
5439: dml_operation = get_dml_operation(rec_steps.dml_operation)
5440: where copy_entity_result_id = rec_steps.copy_entity_result_id; */

Line 5455: from ben_copy_entity_results

5451: is
5452: Cursor csr_plan_dtls
5453: Is
5454: select information307
5455: from ben_copy_entity_results
5456: where copy_entity_result_id = p_pl_cer_id
5457: and copy_entity_txn_id = p_copy_entity_txn_id
5458: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
5459: and table_alias = 'PLN';

Line 5464: from ben_copy_entity_results

5460:
5461: Cursor Csr_rate_details(p_plan_old_date in date)
5462: is
5463: select information2,information3,copy_entity_result_id
5464: from ben_copy_entity_results
5465: where information277 =p_pl_cer_id
5466: and nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
5467: and table_alias in ('HRRATE','ABR')
5468: and information2 = p_plan_old_date

Line 5509: update ben_copy_entity_results

5505: hr_utility.set_message(8302,'PER_289567_GRADE_DATE_FROM');
5506: hr_utility.raise_error;
5507: end if;
5508:
5509: update ben_copy_entity_results
5510: set information2 = p_start_date
5511: where copy_entity_result_id = i.copy_entity_result_id;
5512: if g_debug then
5513: hr_utility.set_location('Updated record with cer_id:'||i.copy_entity_result_id,60);

Line 5535: FROM Ben_Copy_Entity_Results grdldr

5531:
5532: Cursor csr_currency_code
5533: IS
5534: Select nvl(grdldr.INFORMATION50,'USD') /* INFORMATION50 -> Currency Code */
5535: FROM Ben_Copy_Entity_Results grdldr
5536: WHERE grdldr.Copy_Entity_Txn_Id = p_copy_entity_txn_id
5537: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY'
5538: AND grdldr.Table_Alias = 'PGM';
5539:

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

5566: END GET_CURRENCY_CODE;
5567:
5568: --
5569: FUNCTION get_grd_start_date
5570: (p_copy_entity_result_id in ben_copy_entity_results.copy_entity_result_id%TYPE)
5571: RETURN DATE
5572: IS
5573: l_grd_start_date DATE;
5574:

Line 5579: from ben_copy_entity_results

5575: begin
5576:
5577: select information307
5578: into l_grd_start_date
5579: from ben_copy_entity_results
5580: where copy_entity_result_id = p_copy_entity_result_id;
5581:
5582:
5583: RETURN l_grd_start_date;

Line 5594: from ben_copy_entity_results

5590: is
5591: Cursor csr_indicator
5592: is
5593: select information103
5594: from ben_copy_entity_results
5595: where copy_entity_result_id =p_grade_result_id;
5596: l_indicator varchar2(10);
5597: begin
5598: open csr_indicator;

Line 5608: update ben_copy_entity_results

5604: l_indicator := 'S';
5605: end if;
5606:
5607:
5608: update ben_copy_entity_results
5609: set information228 = p_final_start_step
5610: ,information103 = l_indicator
5611: where copy_entity_result_id = p_grade_result_id;
5612: end change_start_step;

Line 5784: update ben_copy_entity_results

5780: PROCEDURE upd_ceiling_info(p_grade_cer_id IN NUMBER, p_step_id IN number)
5781: IS
5782: BEGIN
5783:
5784: update ben_copy_entity_results
5785: set information259 = p_step_id,
5786: information103 = 'Y'
5787: where copy_entity_result_id = p_grade_cer_id
5788: and table_alias = 'CPP';