OTL Create Timekeeper Groups, Link Timekeeper and Add Employees to Timekeeper Group

-- Create the new Timekeeper Group
            x_object_version_number := 1;

            SELECT hxc_tk_groups_s.NEXTVAL
              INTO l_tk_group_id
              FROM DUAL;

            INSERT INTO hxc_tk_groups
                        (tk_group_id, tk_group_name, tk_resource_id, object_version_number, business_group_id, creation_date, created_by, last_updated_by,
                         last_update_date, last_update_login
                        )
                 VALUES (l_tk_group_id, i.new_timekeeper_group_name, v_tk_resource_id, x_object_version_number, 571, SYSDATE, l_user_id, l_user_id,
                         SYSDATE, l_user_id
                        );

            SELECT hxc_tk_group_queries_s.NEXTVAL
              INTO l_tk_group_query_id
              FROM DUAL;

            INSERT INTO hxc_tk_group_queries
                        (tk_group_query_id, tk_group_id, group_query_name, include_exclude, system_user, object_version_number, creation_date, created_by,
                         last_updated_by, last_update_date, last_update_login
                        )
                 VALUES (l_tk_group_query_id, l_tk_group_id, 'System: Included Resources', 'I', 'S', x_object_version_number, SYSDATE, l_user_id,
                         l_user_id, SYSDATE, l_user_id
                        );

 
--How to Change the Timekeeper of the existing Group
               l_status := 'U';

               UPDATE hxc_tk_groups
                  SET tk_resource_id = v_tk_resource_id,
                      object_version_number = object_version_number + 1,
                      last_updated_by = l_user_id,
                      last_update_date = SYSDATE
                WHERE tk_group_name = i.new_timekeeper_group_name;



--Add employees to timekeeper group
        INSERT INTO hxc_tk_group_query_criteria
                     (tk_group_query_criteria_id, tk_group_query_id, criteria_type, criteria_id, object_version_number, creation_date, created_by,
                      last_updated_by, last_update_date, last_update_login
                     )
              VALUES (hxc_tk_group_query_criteria_s.NEXTVAL, v_new_tk_group_query_id, 'PERSON', v_person_id, 1, SYSDATE, l_user_id,
                      l_user_id, SYSDATE, l_user_id
                     );