APPS.WMS_SAVE_QUERY_PVT SQL Statements

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

Line: 4

PROCEDURE insert_query_row(p_query_type  wms_saved_queries.query_type%TYPE,
			   p_query_name  wms_saved_queries.query_name%TYPE,
			   p_org_id      wms_saved_queries.organization_id%TYPE,
			   p_user_id     wms_saved_queries.user_id%TYPE,
			   p_login_id    wms_saved_queries.last_update_login%TYPE,
			   p_table       save_query_table,
			   x_return_status OUT NOCOPY varchar2)
  IS
     l_user_id   NUMBER(15);

Line: 20

      INSERT INTO wms_saved_queries
	(query_type,
	 query_name,
	 field_name,
	 field_type,
	 field_value,
	 last_update_date,
	 last_updated_by,
	 last_update_login,
	 creation_date,
	 created_by,
	 organization_id,
	 user_id)
	VALUES
	(p_query_type,
	 p_query_name,
	 p_table(i).field_name,
	 p_table(i).field_type,
	 p_table(i).field_value,
	 l_sysdate,
	 p_user_id,
	 p_login_id,
	 l_sysdate,
	 p_user_id,
	 p_org_id,
	 p_user_id);

Line: 53

END insert_query_row;

Line: 55

PROCEDURE update_query_row(p_query_type  wms_saved_queries.query_type%TYPE,
			   p_query_name  wms_saved_queries.query_name%TYPE,
			   p_org_id      wms_saved_queries.organization_id%TYPE,
			   p_user_id     wms_saved_queries.user_id%TYPE,
			   p_login_id    wms_saved_queries.last_update_login%TYPE,
			   p_table       save_query_table,
			   x_return_status OUT NOCOPY varchar2) IS
BEGIN
   x_return_status := 'S';

Line: 66

      UPDATE wms_saved_queries
	SET field_value = p_table(i).field_value,
	    field_type = p_table(i).field_type
	WHERE query_type = p_query_type
	and query_name = p_query_name
	and field_name = p_table(i).field_name
	AND organization_id = p_org_id
	AND user_id = p_user_id;

Line: 82

PROCEDURE update_query_row(p_query_type   wms_saved_queries.query_type%TYPE,
			   p_query_name   wms_saved_queries.query_name%TYPE,
			   p_field_name   wms_saved_queries.field_name%TYPE,
			   p_field_value  wms_saved_queries.field_value%TYPE,
			   p_field_type   wms_saved_queries.field_type%TYPE,
			   p_org_id       wms_saved_queries.organization_id%TYPE,
			   p_user_id      wms_saved_queries.user_id%TYPE,
			   x_return_status OUT NOCOPY VARCHAR2)
IS
BEGIN
   x_return_status := 'S';

Line: 94

   UPDATE WMS_SAVED_QUERIES
     SET field_value = p_field_value, field_type = p_field_type
     WHERE query_type = p_query_type
     and query_name = p_query_name
     and field_name = p_field_name
     AND organization_id = p_org_id
     AND user_id = p_user_id;

Line: 107

END update_query_row;

Line: 109

PROCEDURE delete_query_row(p_query_type   wms_saved_queries.query_type%TYPE,
			   p_query_name   wms_saved_queries.query_name%TYPE,
			   p_field_name   wms_saved_queries.field_name%TYPE,
			   p_org_id       wms_saved_queries.organization_id%TYPE,
			   p_user_id      wms_saved_queries.user_id%TYPE,
			   x_return_status OUT NOCOPY VARCHAR2)
IS
BEGIN
   x_return_status := 'S';

Line: 119

   DELETE
     FROM WMS_SAVED_QUERIES
     WHERE query_type = p_query_type
     and query_name = p_query_name
     and field_name = p_field_name
     AND organization_id = p_org_id
     AND user_id = p_user_id;

Line: 132

END delete_query_row;

Line: 134

PROCEDURE delete_query(p_query_type   wms_saved_queries.query_type%TYPE,
		       p_query_name   wms_saved_queries.query_name%TYPE,
		       p_org_id       wms_saved_queries.organization_id%TYPE,
		       p_user_id      wms_saved_queries.user_id%TYPE,
		       x_return_status OUT NOCOPY VARCHAR2)
  IS
BEGIN
   x_return_status := 'S';

Line: 143

   DELETE
     FROM WMS_SAVED_QUERIES
     WHERE query_type = p_query_type
     and query_name = p_query_name
     AND organization_id = p_org_id
     AND user_id = p_user_id;

Line: 155

END delete_query;