[Home] [Help]
8451: l_count_current number := 0;
8452: l_action_id number := 0;
8453: l_dummy number := 0;
8454:
8455: l_func_params_tbl ego_FN_Param_Obj_Tbl_Type := ego_FN_Param_Obj_Tbl_Type();
8456: l_count_frm_ego_maps NUMBER := 0;
8457: l_count_frm_func_params NUMBER := 0;
8458: l_token_table ERROR_HANDLER.Token_Tbl_Type;
8459: l_entity_code VARCHAR2(30);
8754: , item_catalog_name
8755: , function_name
8756: , min(transaction_id) transaction_id
8757: , count(1) as count
8758: from table ( cast (l_func_params_tbl as ego_FN_Param_Obj_Tbl_Type))
8759: where process_status = G_RET_STS_SUCCESS
8760: group by item_catalog_group_id , function_id , item_catalog_name, function_name
8761: ) LOOP
8762: --- For every icc and function_id in params table