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.BEN_EXTRACT_SEED dependencies on HR_UTILITY

Line 35: hr_utility.set_location(' Entering ' || l_proc, 10);

31: l_proc varchar2(100) := 'BEN_EXT_SEED.delete_crit_adv_conditon' ;
32: l_object_version_number number ;
33:
34: Begin
35: hr_utility.set_location(' Entering ' || l_proc, 10);
36:
37: for i in c1
38: Loop
39:

Line 64: hr_utility.set_location(' Leaving ' || l_proc, 10);

60: end Loop ;
61:
62: --- delete the global collection
63: g_Ext_adv_crit_cmbn.delete ;
64: hr_utility.set_location(' Leaving ' || l_proc, 10);
65: end ;
66:
67:
68: procedure set_adv_cond_cmbn

Line 76: hr_utility.set_location(' Entering ' || l_proc, 10);

72: l_count number ;
73: l_found varchar2(1) ;
74: l_proc varchar2(100) := 'BEN_EXT_SEED.set_adv_cond_cmbn' ;
75: Begin
76: hr_utility.set_location(' Entering ' || l_proc, 10);
77:
78: l_found := 'N' ;
79: l_count := 0 ;
80: if p_old_ext_crit_val_id is not null and p_new_ext_crit_val_id is not null then

Line 2038: hr_utility.set_location(' Entering ' || l_proc, 10);

2034: l_proc varchar2(100) := 'BEN_EXT_SEED.load_extract' ;
2035:
2036: --
2037: BEGIN
2038: hr_utility.set_location(' Entering ' || l_proc, 10);
2039: l_legislation_code := p_legislation_code;
2040:
2041: g_group_record := p_ext_group_record ;
2042: g_group_elmt1 := p_ext_group_elmt1 ;

Line 2120: hr_utility.set_location(' Leaving ' || l_proc, 10);

2116: );
2117: WHEN OTHERS THEN
2118: RAISE;
2119: END;
2120: hr_utility.set_location(' Leaving ' || l_proc, 10);
2121: END load_extract;
2122: --
2123: PROCEDURE load_record(p_record_name IN VARCHAR2
2124: ,p_owner IN VARCHAR2

Line 2146: hr_utility.set_location(' Entering ' || l_proc, 10);

2142: l_rcd_type_cd ben_ext_rcd.RCD_TYPE_CD%type ;
2143: l_low_lvl_cd ben_ext_rcd.LOW_LVL_CD%type ;
2144: l_proc varchar2(100) := 'BEN_EXT_SEED.load_record' ;
2145: BEGIN
2146: hr_utility.set_location(' Entering ' || l_proc, 10);
2147: get_who_values(p_owner => p_owner
2148: ,p_last_update_vc => p_last_update_date
2149: ,p_last_update_date => l_last_update_date
2150: ,p_last_updated_by => l_last_updated_by

Line 2209: hr_utility.set_location(' Leaving ' || l_proc, 10);

2205: ,p_xml_tag_name => p_xml_tag_name );
2206: WHEN OTHERS THEN
2207: RAISE;
2208: END;
2209: hr_utility.set_location(' Leaving ' || l_proc, 10);
2210: END load_record;
2211:
2212:
2213:

Line 2268: hr_utility.set_location(' Entering ' || l_proc, 10);

2264:
2265:
2266: l_proc varchar2(100) := 'BEN_EXT_SEED.load_record_in_file' ;
2267: BEGIN
2268: hr_utility.set_location(' Entering ' || l_proc, 10);
2269:
2270:
2271: get_who_values(p_owner => p_owner
2272: ,p_last_update_vc => p_last_update_date

Line 2489: hr_utility.set_location(' Leaving ' || l_proc, 10);

2485: ,p_object_version_number => l_object_version_number);
2486: WHEN OTHERS THEN
2487: RAISE;
2488: END ;
2489: hr_utility.set_location(' Leaving ' || l_proc, 10);
2490: END load_record_in_file;
2491:
2492:
2493: PROCEDURE load_ext_data_elmt(p_data_elemt_name IN VARCHAR2

Line 2544: hr_utility.set_location(' Entering ' || l_proc, 10);

2540: AND nvl(l_last_update_date,trunc(sysdate)) BETWEEN effective_start_date and effective_end_date ;
2541: --
2542: l_proc varchar2(100) := 'BEN_EXT_SEED.load_ext_data_elmt' ;
2543: BEGIN
2544: hr_utility.set_location(' Entering ' || l_proc, 10);
2545:
2546: get_who_values(p_owner => p_owner
2547: ,p_last_update_vc => p_last_update_date
2548: ,p_last_update_date => l_last_update_date

Line 3014: hr_utility.set_location(' Leaving ' || l_proc, 10);

3010: WHEN OTHERS THEN
3011: RAISE;
3012: END;
3013: END IF;
3014: hr_utility.set_location(' Leaving ' || l_proc, 10);
3015: END load_ext_data_elmt;
3016:
3017: --
3018: PROCEDURE load_ext_data_elmt_in_rcd(p_data_element_name IN VARCHAR2

Line 3050: hr_utility.set_location(' Entering ' || l_proc, 10);

3046: l_RQD_FLAG ben_ext_data_elmt_in_rcd.RQD_FLAG%type ;
3047: l_sprs_cd ben_ext_data_elmt_in_rcd.sprs_cd%type ;
3048: l_proc varchar2(100) := 'BEN_EXT_SEED.load_ext_data_elmt_in_rcd' ;
3049: BEGIN
3050: hr_utility.set_location(' Entering ' || l_proc, 10);
3051: get_who_values(p_owner => p_owner
3052: ,p_last_update_vc => p_last_update_date
3053: ,p_last_update_date => l_last_update_date
3054: ,p_last_updated_by => l_last_updated_by

Line 3240: hr_utility.set_location(' Leaving ' || l_proc, 10);

3236: ,p_last_updated_by => l_last_updated_by
3237: ,p_object_version_number => l_object_version_number);
3238:
3239: END;
3240: hr_utility.set_location(' Leaving ' || l_proc, 10);
3241: END load_ext_data_elmt_in_rcd;
3242:
3243: PROCEDURE load_ext_where_clause(p_data_elmt_name IN VARCHAR2
3244: ,p_record_name IN VARCHAR2

Line 3275: hr_utility.set_location(' Entering ' || l_proc, 10);

3271: l_record_data_elmt_name varchar2(600) ;
3272:
3273: l_proc varchar2(100) := 'BEN_EXT_SEED.load_ext_where_clause' ;
3274: BEGIN
3275: hr_utility.set_location(' Entering ' || l_proc, 10);
3276: get_who_values(p_owner => p_owner
3277: ,p_last_update_vc => p_last_update_date
3278: ,p_last_update_date => l_last_update_date
3279: ,p_last_updated_by => l_last_updated_by

Line 3515: hr_utility.set_location(' Leaving ' || l_proc, 10);

3511: ,p_object_version_number => l_object_version_number);
3512: WHEN OTHERS THEN
3513: RAISE;
3514: END;
3515: hr_utility.set_location(' Leaving ' || l_proc, 10);
3516: END load_ext_where_clause;
3517:
3518:
3519:

Line 3560: hr_utility.set_location(' Entering ' || l_proc, 10);

3556: l_proc varchar2(100) := 'BEN_EXT_SEED.load_incl_chgs' ;
3557: l_new_business_group_id number ;
3558: l_chg_evt_cd varchar2(80) ;
3559: BEGIN
3560: hr_utility.set_location(' Entering ' || l_proc, 10);
3561: l_chg_evt_cd := p_chg_evt_cd ;
3562: get_who_values(p_owner => p_owner
3563: ,p_last_update_vc => p_last_update_date
3564: ,p_last_update_date => l_last_update_date

Line 3714: hr_utility.set_location('calling ins for ' || l_chg_evt_cd , 10);

3710:
3711: end loop ;
3712:
3713: l_object_version_number := null ;
3714: hr_utility.set_location('calling ins for ' || l_chg_evt_cd , 10);
3715: ben_xic_ins.ins(p_effective_date => l_last_update_date
3716: ,p_ext_incl_chg_id => l_ext_incl_chg_id
3717: ,p_chg_evt_cd => l_chg_evt_cd
3718: ,p_ext_rcd_in_file_id => l_ext_rcd_in_file_id

Line 3734: hr_utility.set_location('calling ins for ' || l_chg_evt_cd , 10);

3730: end ;
3731:
3732:
3733: WHEN NO_DATA_FOUND THEN
3734: hr_utility.set_location('calling ins for ' || l_chg_evt_cd , 10);
3735: ben_xic_ins.ins(p_effective_date => l_last_update_date
3736: ,p_ext_incl_chg_id => l_ext_incl_chg_id
3737: ,p_chg_evt_cd => l_chg_evt_cd
3738: ,p_ext_rcd_in_file_id => l_ext_rcd_in_file_id

Line 3762: hr_utility.set_location(' Leaving ' || l_proc, 10);

3758: --END IF ;
3759:
3760:
3761: END IF ;
3762: hr_utility.set_location(' Leaving ' || l_proc, 10);
3763:
3764: END load_incl_chgs;
3765:
3766:

Line 3787: hr_utility.set_location(' Entering ' || l_proc, 10);

3783: l_new_business_group_id number ;
3784: l_proc varchar2(100) := 'BEN_EXT_SEED.load_profile' ;
3785: BEGIN
3786:
3787: hr_utility.set_location(' Entering ' || l_proc, 10);
3788: get_who_values(p_owner => p_owner
3789: ,p_last_update_vc => p_last_update_date
3790: ,p_last_update_date => l_last_update_date
3791: ,p_last_updated_by => l_last_updated_by

Line 3823: hr_utility.set_location(' Leaving ' || l_proc, 10);

3819: END;
3820: --- delete the advace citeria and cmbn value
3821: delete_crit_adv_conditon
3822: (p_ext_crit_prfl_id => l_ext_prfl_id ) ;
3823: hr_utility.set_location(' Leaving ' || l_proc, 10);
3824: END load_profile;
3825:
3826:
3827: PROCEDURE load_criteria_type(p_profile_name IN VARCHAR2

Line 3847: hr_utility.set_location(' Entering ' || l_proc, 10);

3843: l_last_updated_by NUMBER;
3844: l_new_business_group_id number ;
3845: l_proc varchar2(100) := 'BEN_EXT_SEED.load_criteria_type' ;
3846: BEGIN
3847: hr_utility.set_location(' Entering ' || l_proc, 10);
3848: --- for advance criteria once the issues is fixed remove the condition
3849: /*
3850: if p_type_code = 'ADV' then
3851: write_err

Line 3907: hr_utility.set_location(' Leaving ' || l_proc, 10);

3903: ,p_object_version_number => l_object_version_number);
3904: WHEN OTHERS THEN
3905: RAISE;
3906: END;
3907: hr_utility.set_location(' Leaving ' || l_proc, 10);
3908: END load_criteria_type;
3909: --
3910: PROCEDURE load_criteria_val(p_profile_name IN VARCHAR2
3911: ,p_type_code IN VARCHAR2

Line 3957: hr_utility.set_location(' Entering ' || l_proc, 10);

3953: if p_type_code = 'ADV' then
3954: return ;
3955: end if ;
3956: */
3957: hr_utility.set_location(' Entering ' || l_proc, 10);
3958:
3959: get_who_values(p_owner => p_owner
3960: ,p_last_update_vc => p_last_update_date
3961: ,p_last_update_date => l_last_update_date

Line 4130: hr_utility.set_location(' Leaving ' || l_proc, 10);

4126:
4127: WHEN OTHERS THEN
4128: RAISE;
4129: END;
4130: hr_utility.set_location(' Leaving ' || l_proc, 10);
4131: end load_criteria_val;
4132: --
4133: PROCEDURE load_combination(p_profile_name IN VARCHAR2
4134: ,p_type_code IN VARCHAR2

Line 4173: hr_utility.set_location(' Entering ' || l_proc, 10);

4169: if p_type_code = 'ADV' then
4170: return ;
4171: end if ;
4172: */
4173: hr_utility.set_location(' Entering ' || l_proc, 10);
4174: ---
4175: get_who_values(p_owner => p_owner
4176: ,p_last_update_vc => p_last_update_date
4177: ,p_last_update_date => l_last_update_date

Line 4309: hr_utility.set_location(' Leaving ' || l_proc, 10);

4305: ,p_object_version_number => l_object_version_number);
4306: WHEN OTHERS THEN
4307: RAISE;
4308: END;
4309: hr_utility.set_location(' Leaving ' || l_proc, 10);
4310: END load_combination;
4311: --
4312: PROCEDURE load_definition(p_definition_name IN VARCHAR2
4313: ,p_file_name IN VARCHAR2

Line 4356: hr_utility.set_location(' Entering ' || l_proc, 10);

4352: l_template_id number ;
4353: l_proc varchar2(100) := 'BEN_EXT_SEED.load_definition' ;
4354: BEGIN
4355:
4356: hr_utility.set_location(' Entering ' || l_proc, 10);
4357: get_who_values(p_owner => p_owner
4358: ,p_last_update_vc => p_last_update_date
4359: ,p_last_update_date => l_last_update_date
4360: ,p_last_updated_by => l_last_updated_by

Line 4543: hr_utility.set_location(' Leaving ' || l_proc, 10);

4539: );
4540: WHEN OTHERS THEN
4541: RAISE;
4542: END;
4543: hr_utility.set_location(' Leaving ' || l_proc, 10);
4544: END load_definition;
4545: --
4546: PROCEDURE load_decode(p_element_name IN VARCHAR2
4547: ,p_owner IN VARCHAR2