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_PD_COPY_TO_BEN_TWO dependencies on BEN_CUSTOM_REGION_ITEMS

Line 22595: from BEN_CUSTOM_REGION_ITEMS CRI

22591: c_new_information13 varchar2,
22592: c_new_information14 varchar2) is
22593: select
22594: CRI.REGION_CODE ,cri.CUSTOM_KEY ,cri.CUSTOM_TYPE ,cri.item_name ,cri.label
22595: from BEN_CUSTOM_REGION_ITEMS CRI
22596: where CRI.region_code = c_new_information11
22597: and CRI.CUSTOM_KEY = c_new_information12
22598: and CRI.CUSTOM_TYPE = c_new_information13
22599: and CRI.item_name = c_new_information14;

Line 22605: l_debug_item_name ben_custom_region_items.item_name%type;

22601: --
22602: --
22603: l_update boolean := false ;
22604: l_process_date date;
22605: l_debug_item_name ben_custom_region_items.item_name%type;
22606: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
22607: r_find_CRI_in_target c_find_CRI_in_target%rowtype;
22608: r_CRI c_CRI%rowtype;
22609: --

Line 22614: l_custom_key ben_custom_region_items.custom_key%type;

22610: --UPD END
22611:
22612: l_object_version_number number ;
22613: l_object_found_in_target boolean := false ;
22614: l_custom_key ben_custom_region_items.custom_key%type;
22615: l_fk_cwb_wksht_grp_id ben_cwb_wksht_grp.cwb_wksht_grp_id%type;
22616: --
22617: begin
22618:

Line 22628: -- BEN_CUSTOM_REGION_ITEMS are REUSE/INSERT we need not worry about t

22624: hr_utility.set_location( 'r_CRI_unique.information13 '||r_CRI_unique.information13,10);
22625: hr_utility.set_location( 'r_CRI_unique.information14 '||r_CRI_unique.information14,10);
22626:
22627: -- AS the Only operations that are performed on the table
22628: -- BEN_CUSTOM_REGION_ITEMS are REUSE/INSERT we need not worry about t
22629: -- the l_dml_operation.
22630:
22631: -- We first check for the presence of any BEN_CUSTOM_REGION_ITEMS record
22632: -- based on the target cwb_wksht_grp_id and if any records are found

Line 22631: -- We first check for the presence of any BEN_CUSTOM_REGION_ITEMS record

22627: -- AS the Only operations that are performed on the table
22628: -- BEN_CUSTOM_REGION_ITEMS are REUSE/INSERT we need not worry about t
22629: -- the l_dml_operation.
22630:
22631: -- We first check for the presence of any BEN_CUSTOM_REGION_ITEMS record
22632: -- based on the target cwb_wksht_grp_id and if any records are found
22633: -- we reuse them or we create new records as seen in the CPE table
22634:
22635: l_dml_operation := r_CRI_unique.dml_operation ;

Line 22662: hr_utility.set_location( 'RKG A record of ben_custom_region_items',202);

22658: hr_utility.set_location(' r_find_CRI_in_target.CUSTOM_KEY ' || r_find_CRI_in_target.CUSTOM_KEY ,20 );
22659: hr_utility.set_location( 'r_find_CRI_in_target.CUSTOM_TYPE ' || r_find_CRI_in_target.CUSTOM_TYPE,20 );
22660: hr_utility.set_location( 'r_find_CRI_in_target.ITEM_NAME ' || r_find_CRI_in_target.ITEM_NAME ,20 );
22661: hr_utility.set_location( 'r_find_CRI_in_target.LABEL ' || r_find_CRI_in_target.LABEL ,20 );
22662: hr_utility.set_location( 'RKG A record of ben_custom_region_items',202);
22663: hr_utility.set_location( 'with the same cwb_wksht_grp_id as custom_key already exists and hence reused. ',202);
22664:
22665: -- As the record in found in the target , reuse the record
22666: else

Line 22680: insert into BEN_CUSTOM_REGION_ITEMS(

22676: --
22677: close c_CRI ;
22678: --
22679:
22680: insert into BEN_CUSTOM_REGION_ITEMS(
22681: REGION_CODE ,
22682: CUSTOM_KEY ,
22683: CUSTOM_TYPE ,
22684: ITEM_NAME ,