APPS.JTF_RS_DYNAMIC_GROUPS_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 6

   create, update and delete Dynamic Groups.
   Its main procedures are as following:
   Create Dynamic Groups
   Update Dynamic Groups
   Delete Dynamic Groups
   This package valoidates the input parameters to these procedures and then
   to do business validations and to do actual inserts, updates and deletes into tables.
   ******************************************************************************************/

  /* Package variables. */

  G_PKG_NAME         CONSTANT VARCHAR2(30) := 'JTF_RS_DYNAMIC_GROUPS_PUB';

Line: 194

  /* Procedure to update the Dynamic Groups
	based on input values passed by calling routines. */

  PROCEDURE  update_dynamic_groups
  (P_API_VERSION          IN   NUMBER,
   P_INIT_MSG_LIST        IN   VARCHAR2,
   P_COMMIT               IN   VARCHAR2,
   P_GROUP_ID    	  IN   JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
   P_GROUP_NUMBER    	  IN   JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
   P_GROUP_NAME 	  IN   JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
   P_GROUP_DESC 	  IN   JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE,
   P_USAGE    	  	  IN   JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
   P_START_DATE_ACTIVE    IN   JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
   P_END_DATE_ACTIVE      IN   JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE,
   P_SQL_TEXT             IN   JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
   P_OBJECT_VERSION_NUMBER	IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
   X_RETURN_STATUS        OUT NOCOPY  VARCHAR2,
   X_MSG_COUNT            OUT NOCOPY  NUMBER,
   X_MSG_DATA             OUT NOCOPY  VARCHAR2
  ) IS

  l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_DYNAMIC_GROUPS';

Line: 280

   jtf_rs_dynamic_groups_pvt.update_dynamic_groups(
                  P_API_VERSION        => 1.0,
                  P_INIT_MSG_LIST      => p_init_msg_list,
                  P_COMMIT             => null,
                  P_GROUP_ID           => l_group_id,
                  P_GROUP_NUMBER       => l_group_number,
                  P_GROUP_NAME 	       => l_group_name,
                  P_GROUP_DESC 	       => l_group_desc,
                  P_USAGE    	       => l_usage,
                  P_START_DATE_ACTIVE  => l_start_date_active,
                  P_END_DATE_ACTIVE    => l_end_date_active,
                  P_SQL_TEXT           => l_sql_text,
                  P_OBJECT_VERSION_NUMBER => p_object_version_number,
                  X_RETURN_STATUS      => l_return_status,
                  X_MSG_COUNT          => l_msg_count,
                  X_MSG_DATA           => l_msg_data
                 );

Line: 309

     fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_UPDATE_ERR');

Line: 352

  END update_dynamic_groups;

Line: 355

  /* Procedure to delete the Dynamic Groups. */

  PROCEDURE  delete_dynamic_groups
  (P_API_VERSION          IN   NUMBER,
   P_INIT_MSG_LIST        IN   VARCHAR2,
   P_COMMIT               IN   VARCHAR2,
   P_GROUP_ID    	  IN   JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
   P_OBJECT_VERSION_NUMBER	IN JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
   X_RETURN_STATUS        OUT NOCOPY  VARCHAR2,
   X_MSG_COUNT            OUT NOCOPY  NUMBER,
   X_MSG_DATA             OUT NOCOPY  VARCHAR2
  ) IS
  l_api_name CONSTANT VARCHAR2(30) := 'DELETE_DYNAMIC_GROUPS';

Line: 414

   jtf_rs_dynamic_groups_pvt.delete_dynamic_groups(
                  P_API_VERSION        => 1.0,
                  P_INIT_MSG_LIST      => p_init_msg_list,
                  P_COMMIT             => null,
                  P_GROUP_ID           => l_group_id,
                  P_OBJECT_VERSION_NUMBER => p_object_version_number,
                  X_RETURN_STATUS      => l_return_status,
                  X_MSG_COUNT          => l_msg_count,
                  X_MSG_DATA           => l_msg_data
                 );

Line: 436

     fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_DELETE_ERR');

Line: 479

  END delete_dynamic_groups;