850: DECLARE
851: --
852: CURSOR L_CCHeader_Csr(ID NUMBER, NAME VARCHAR2) IS
853: SELECT *
854: FROM mtl_cycle_count_headers
855: WHERE
856: (cycle_count_header_id = ID
857: OR cycle_count_header_name= NAME);
858: --
855: WHERE
856: (cycle_count_header_id = ID
857: OR cycle_count_header_name= NAME);
858: --
859: L_Cycle_Count_Header_ID MTL_CYCLE_COUNT_HEADERS.Cycle_Count_Header_ID%type;
860: L_Cycle_Count_Header_Name
861: MTL_CYCLE_COUNT_HEADERS.Cycle_Count_Header_Name%type;
862: rec_counter integer := 0;
863: --
857: OR cycle_count_header_name= NAME);
858: --
859: L_Cycle_Count_Header_ID MTL_CYCLE_COUNT_HEADERS.Cycle_Count_Header_ID%type;
860: L_Cycle_Count_Header_Name
861: MTL_CYCLE_COUNT_HEADERS.Cycle_Count_Header_Name%type;
862: rec_counter integer := 0;
863: --
864: L_api_version CONSTANT NUMBER := 0.9;
865: L_api_name CONSTANT VARCHAR2(30) := 'Validate_CountHeader';