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 22682: from BEN_CUSTOM_REGION_ITEMS CRI

22678: c_new_information13 varchar2,
22679: c_new_information14 varchar2) is
22680: select
22681: CRI.REGION_CODE ,cri.CUSTOM_KEY ,cri.CUSTOM_TYPE ,cri.item_name ,cri.label
22682: from BEN_CUSTOM_REGION_ITEMS CRI
22683: where CRI.region_code = c_new_information11
22684: and CRI.CUSTOM_KEY = c_new_information12
22685: and CRI.CUSTOM_TYPE = c_new_information13
22686: and CRI.item_name = c_new_information14;

Line 22692: l_debug_item_name ben_custom_region_items.item_name%type;

22688: --
22689: --
22690: l_update boolean := false ;
22691: l_process_date date;
22692: l_debug_item_name ben_custom_region_items.item_name%type;
22693: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
22694: r_find_CRI_in_target c_find_CRI_in_target%rowtype;
22695: r_CRI c_CRI%rowtype;
22696: --

Line 22701: l_custom_key ben_custom_region_items.custom_key%type;

22697: --UPD END
22698:
22699: l_object_version_number number ;
22700: l_object_found_in_target boolean := false ;
22701: l_custom_key ben_custom_region_items.custom_key%type;
22702: l_fk_cwb_wksht_grp_id ben_cwb_wksht_grp.cwb_wksht_grp_id%type;
22703: --
22704: begin
22705:

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

22711: hr_utility.set_location( 'r_CRI_unique.information13 '||r_CRI_unique.information13,10);
22712: hr_utility.set_location( 'r_CRI_unique.information14 '||r_CRI_unique.information14,10);
22713:
22714: -- AS the Only operations that are performed on the table
22715: -- BEN_CUSTOM_REGION_ITEMS are REUSE/INSERT we need not worry about t
22716: -- the l_dml_operation.
22717:
22718: -- We first check for the presence of any BEN_CUSTOM_REGION_ITEMS record
22719: -- based on the target cwb_wksht_grp_id and if any records are found

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

22714: -- AS the Only operations that are performed on the table
22715: -- BEN_CUSTOM_REGION_ITEMS are REUSE/INSERT we need not worry about t
22716: -- the l_dml_operation.
22717:
22718: -- We first check for the presence of any BEN_CUSTOM_REGION_ITEMS record
22719: -- based on the target cwb_wksht_grp_id and if any records are found
22720: -- we reuse them or we create new records as seen in the CPE table
22721:
22722: l_dml_operation := r_CRI_unique.dml_operation ;

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

22745: hr_utility.set_location(' r_find_CRI_in_target.CUSTOM_KEY ' || r_find_CRI_in_target.CUSTOM_KEY ,20 );
22746: hr_utility.set_location( 'r_find_CRI_in_target.CUSTOM_TYPE ' || r_find_CRI_in_target.CUSTOM_TYPE,20 );
22747: hr_utility.set_location( 'r_find_CRI_in_target.ITEM_NAME ' || r_find_CRI_in_target.ITEM_NAME ,20 );
22748: hr_utility.set_location( 'r_find_CRI_in_target.LABEL ' || r_find_CRI_in_target.LABEL ,20 );
22749: hr_utility.set_location( 'RKG A record of ben_custom_region_items',202);
22750: hr_utility.set_location( 'with the same cwb_wksht_grp_id as custom_key already exists and hence reused. ',202);
22751:
22752: --8985766
22753: hr_utility.set_location('Before plsql table ',111);

Line 22775: insert into BEN_CUSTOM_REGION_ITEMS(

22771: --
22772: close c_CRI ;
22773: --
22774:
22775: insert into BEN_CUSTOM_REGION_ITEMS(
22776: REGION_CODE ,
22777: CUSTOM_KEY ,
22778: CUSTOM_TYPE ,
22779: ITEM_NAME ,