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_RBC_UTILITY dependencies on BEN_ELIGY_CRITERIA

Line 349: cursor c1 is select short_code from ben_eligy_criteria

345:
346: procedure check_criteria_in_busgrp(p_eligy_criteria_id_std in number,p_business_group_id in number,p_eligy_criteria_id_new out nocopy number) is
347: l_short_code varchar2(240);
348: l_eligy_criteria_id_new number;
349: cursor c1 is select short_code from ben_eligy_criteria
350: where eligy_criteria_id = p_eligy_criteria_id_std
351: and business_group_id is null;
352:
353: cursor c2(p_short_code varchar2) is

Line 354: select eligy_criteria_id from ben_eligy_criteria

350: where eligy_criteria_id = p_eligy_criteria_id_std
351: and business_group_id is null;
352:
353: cursor c2(p_short_code varchar2) is
354: select eligy_criteria_id from ben_eligy_criteria
355: where short_code = p_short_code
356: and business_group_id = p_business_group_id;
357:
358: begin

Line 390: cursor c1 is select * from ben_eligy_criteria

386: p_copy_entity_result_id out nocopy number,
387: p_copy_entity_result_ovn out nocopy number) is
388:
389: l_flex_value_set_name varchar2(80);
390: cursor c1 is select * from ben_eligy_criteria
391: where eligy_criteria_id = p_eligy_criteria_id;
392:
393: l_egl_tr_id number;
394: l_egl_tr_name varchar2(80);

Line 397: l_ben_eligy_criteria number;

393: l_egl_tr_id number;
394: l_egl_tr_name varchar2(80);
395: l_egl_cer_id number;
396: l_egl_ovn number;
397: l_ben_eligy_criteria number;
398: begin
399: -- get new ben_eligy_criteria sequence --NOT NEEDED BCOZ WE USE API TO CREATE
400:
401: select BEN_ELIGY_CRITERIA_S.NEXTVAL into l_ben_eligy_criteria from dual;

Line 399: -- get new ben_eligy_criteria sequence --NOT NEEDED BCOZ WE USE API TO CREATE

395: l_egl_cer_id number;
396: l_egl_ovn number;
397: l_ben_eligy_criteria number;
398: begin
399: -- get new ben_eligy_criteria sequence --NOT NEEDED BCOZ WE USE API TO CREATE
400:
401: select BEN_ELIGY_CRITERIA_S.NEXTVAL into l_ben_eligy_criteria from dual;
402:
403: pqh_gsp_hr_to_stage.get_table_route_details

Line 401: select BEN_ELIGY_CRITERIA_S.NEXTVAL into l_ben_eligy_criteria from dual;

397: l_ben_eligy_criteria number;
398: begin
399: -- get new ben_eligy_criteria sequence --NOT NEEDED BCOZ WE USE API TO CREATE
400:
401: select BEN_ELIGY_CRITERIA_S.NEXTVAL into l_ben_eligy_criteria from dual;
402:
403: pqh_gsp_hr_to_stage.get_table_route_details
404: (p_table_alias => 'EGL',
405: p_table_route_id => l_egl_tr_id,

Line 431: p_information1 => l_ben_eligy_criteria, -- get from sequence number

427: p_number_of_copies => 1,
428: p_table_route_id => l_egl_tr_id,
429: p_table_alias => 'EGL',
430: p_dml_operation => 'CREATE',
431: p_information1 => l_ben_eligy_criteria, -- get from sequence number
432: p_information4 => p_business_group_id, -- add our business group
433: p_information5 => l_egl_rec.name,
434: p_information11 => l_egl_rec.short_code,
435: p_information12 => l_egl_rec.criteria_type,

Line 509: cursor c1 is select * from ben_eligy_criteria

505: p_copy_entity_result_id out nocopy number,
506: p_copy_entity_result_ovn out nocopy number) is
507:
508: l_flex_value_set_name varchar2(80);
509: cursor c1 is select * from ben_eligy_criteria
510: where eligy_criteria_id = p_eligy_criteria_id;
511:
512: l_egl_tr_id number;
513: l_egl_tr_name varchar2(80);

Line 637: l_created_by ben_eligy_criteria.created_by%type;

633: ,p_legislation_code in varchar2
634: ) is
635:
636: l_ovn number := 1;
637: l_created_by ben_eligy_criteria.created_by%type;
638: l_last_updated_by ben_eligy_criteria.last_updated_by%type;
639: l_creation_date ben_eligy_criteria.creation_date%type;
640: l_last_update_date ben_eligy_criteria.last_update_date%type;
641: l_last_update_login ben_eligy_criteria.last_update_login%type;

Line 638: l_last_updated_by ben_eligy_criteria.last_updated_by%type;

634: ) is
635:
636: l_ovn number := 1;
637: l_created_by ben_eligy_criteria.created_by%type;
638: l_last_updated_by ben_eligy_criteria.last_updated_by%type;
639: l_creation_date ben_eligy_criteria.creation_date%type;
640: l_last_update_date ben_eligy_criteria.last_update_date%type;
641: l_last_update_login ben_eligy_criteria.last_update_login%type;
642:

Line 639: l_creation_date ben_eligy_criteria.creation_date%type;

635:
636: l_ovn number := 1;
637: l_created_by ben_eligy_criteria.created_by%type;
638: l_last_updated_by ben_eligy_criteria.last_updated_by%type;
639: l_creation_date ben_eligy_criteria.creation_date%type;
640: l_last_update_date ben_eligy_criteria.last_update_date%type;
641: l_last_update_login ben_eligy_criteria.last_update_login%type;
642:
643: l_col1_value_set_id ben_eligy_criteria.col1_value_set_id%type;

Line 640: l_last_update_date ben_eligy_criteria.last_update_date%type;

636: l_ovn number := 1;
637: l_created_by ben_eligy_criteria.created_by%type;
638: l_last_updated_by ben_eligy_criteria.last_updated_by%type;
639: l_creation_date ben_eligy_criteria.creation_date%type;
640: l_last_update_date ben_eligy_criteria.last_update_date%type;
641: l_last_update_login ben_eligy_criteria.last_update_login%type;
642:
643: l_col1_value_set_id ben_eligy_criteria.col1_value_set_id%type;
644: l_col2_value_set_id ben_eligy_criteria.col2_value_set_id%type;

Line 641: l_last_update_login ben_eligy_criteria.last_update_login%type;

637: l_created_by ben_eligy_criteria.created_by%type;
638: l_last_updated_by ben_eligy_criteria.last_updated_by%type;
639: l_creation_date ben_eligy_criteria.creation_date%type;
640: l_last_update_date ben_eligy_criteria.last_update_date%type;
641: l_last_update_login ben_eligy_criteria.last_update_login%type;
642:
643: l_col1_value_set_id ben_eligy_criteria.col1_value_set_id%type;
644: l_col2_value_set_id ben_eligy_criteria.col2_value_set_id%type;
645:

Line 643: l_col1_value_set_id ben_eligy_criteria.col1_value_set_id%type;

639: l_creation_date ben_eligy_criteria.creation_date%type;
640: l_last_update_date ben_eligy_criteria.last_update_date%type;
641: l_last_update_login ben_eligy_criteria.last_update_login%type;
642:
643: l_col1_value_set_id ben_eligy_criteria.col1_value_set_id%type;
644: l_col2_value_set_id ben_eligy_criteria.col2_value_set_id%type;
645:
646: l_eligy_criteria_id ben_eligy_criteria.eligy_criteria_id%type;
647:

Line 644: l_col2_value_set_id ben_eligy_criteria.col2_value_set_id%type;

640: l_last_update_date ben_eligy_criteria.last_update_date%type;
641: l_last_update_login ben_eligy_criteria.last_update_login%type;
642:
643: l_col1_value_set_id ben_eligy_criteria.col1_value_set_id%type;
644: l_col2_value_set_id ben_eligy_criteria.col2_value_set_id%type;
645:
646: l_eligy_criteria_id ben_eligy_criteria.eligy_criteria_id%type;
647:
648:

Line 646: l_eligy_criteria_id ben_eligy_criteria.eligy_criteria_id%type;

642:
643: l_col1_value_set_id ben_eligy_criteria.col1_value_set_id%type;
644: l_col2_value_set_id ben_eligy_criteria.col2_value_set_id%type;
645:
646: l_eligy_criteria_id ben_eligy_criteria.eligy_criteria_id%type;
647:
648:
649: cursor csr_fvs(p_valset_name in varchar2) is
650: select flex_value_set_id

Line 656: from ben_eligy_criteria

652: where flex_value_set_name = p_valset_name;
653: --
654: cursor csr_bec is
655: select eligy_criteria_id
656: from ben_eligy_criteria
657: where short_code = p_short_code and business_group_id is null and criteria_type='STD';
658: --
659: cursor csr_bg_bec is
660: select eligy_criteria_id

Line 661: from ben_eligy_criteria

657: where short_code = p_short_code and business_group_id is null and criteria_type='STD';
658: --
659: cursor csr_bg_bec is
660: select eligy_criteria_id
661: from ben_eligy_criteria
662: where short_code = p_short_code and business_group_id is not null and criteria_type='STD';
663: --
664: l_data_migrator_mode varchar2(10);
665: --

Line 691: update ben_eligy_criteria set

687: close csr_fvs;
688:
689: if l_eligy_criteria_id is not null then
690: --
691: update ben_eligy_criteria set
692: name = p_name,
693: description = p_description,
694: crit_col1_val_type_cd = p_crit_col1_val_type_cd,
695: crit_col1_datatype = p_crit_col1_datatype,

Line 721: update ben_eligy_criteria set

717: -- Update any BG specific rows that were created.
718: --
719: For bg_crit_rec in csr_bg_bec loop
720: --
721: update ben_eligy_criteria set
722: name = p_name,
723: description = p_description,
724: crit_col1_val_type_cd = p_crit_col1_val_type_cd,
725: crit_col1_datatype = p_crit_col1_datatype,

Line 750: insert into ben_eligy_criteria

746: End loop;
747:
748: else
749: --
750: insert into ben_eligy_criteria
751: (
752: eligy_criteria_id,
753: short_code,
754: name,

Line 783: ben_eligy_criteria_s.nextval,

779: object_version_number
780: )
781: values
782: (
783: ben_eligy_criteria_s.nextval,
784: p_short_code,
785: p_name,
786: p_description,
787: p_crit_col1_val_type_cd,

Line 931: ben_eligy_criteria_api.update_eligy_criteria(

927: hr_utility.set_location('going for update operation ',10);
928: l_eligy_ovn := r_egl.information265;
929: l_eligy_criteria_id := r_egl.information1;
930:
931: ben_eligy_criteria_api.update_eligy_criteria(
932: p_validate => FALSE,
933: p_eligy_criteria_id => l_eligy_criteria_id,
934: p_name => r_egl.information170,
935: p_short_code => r_egl.information11,

Line 1003: ben_eligy_criteria_api.create_eligy_criteria(

999: );
1000: elsif r_egl.dml_operation = 'CREATE' then
1001: hr_utility.set_location('going for create operation ',10);
1002:
1003: ben_eligy_criteria_api.create_eligy_criteria(
1004: p_validate => FALSE,
1005: p_eligy_criteria_id => l_eligy_criteria_id,
1006: p_name => r_egl.information170,
1007: p_short_code => r_egl.information11,