183: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset_num' || p_from_asset_num);
184: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset_num ' || p_to_asset_num);
185: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_request_id' || p_request_id);
186:
187: l_login_id := NVL(to_number(fnd_profile.value('LOGIN_ID')),-1);
188: l_user_id := NVL(to_number(fnd_profile.value('USER_ID' )),-1);
189:
190: IF get_flex_segments (p_bookType) AND get_period_name (p_bookType, p_period) THEN
191: IF p_categoryId IS NULL THEN
184: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset_num ' || p_to_asset_num);
185: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_request_id' || p_request_id);
186:
187: l_login_id := NVL(to_number(fnd_profile.value('LOGIN_ID')),-1);
188: l_user_id := NVL(to_number(fnd_profile.value('USER_ID' )),-1);
189:
190: IF get_flex_segments (p_bookType) AND get_period_name (p_bookType, p_period) THEN
191: IF p_categoryId IS NULL THEN
192: l_finalCategoryId := 'cf.category_id'; -- Do all categories