APPS.IEU_UWQM_PUB SQL Statements

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

Line: 62

  l_status_update_user_id  NUMBER;

Line: 72

PROCEDURE UPDATE_UWQM_ITEM
( p_api_version               IN NUMBER,
  p_init_msg_list             IN VARCHAR2,
  p_commit                    IN VARCHAR2,
  p_workitem_obj_code 	      IN VARCHAR2,
  p_workitem_pk_id            IN NUMBER,
  p_title		              IN VARCHAR2,
  p_party_id    	          IN NUMBER,
  p_priority_code             IN VARCHAR2,
  p_due_date		          IN DATE,
  p_owner_id                  IN NUMBER,
  p_owner_type     	          IN VARCHAR2,
  p_assignee_id               IN NUMBER,
  p_assignee_type             IN VARCHAR2,
  p_source_object_id          IN NUMBER,
  p_source_object_type_code   IN VARCHAR2,
  p_application_id            IN NUMBER,
  p_user_id                   IN NUMBER,
  p_login_id                  IN NUMBER,
--  p_ieu_enum_type_uuid        IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
  x_msg_count                 OUT NOCOPY NUMBER,
  x_msg_data                  OUT NOCOPY VARCHAR2,
  x_return_status             OUT NOCOPY VARCHAR2) AS

  l_api_version  NUMBER        := 1.0;

Line: 97

  l_api_name     VARCHAR2(30)  := 'UPDATE_UWQM_ITEM';

Line: 127

END UPDATE_UWQM_ITEM;

Line: 153

  l_status_update_user_id VARCHAR2(30);

Line: 186

  l_status_update_user_id     NUMBER;

Line: 217

  l_old_status_update_user_id NUMBER;

Line: 218

  l_new_status_update_user_id NUMBER;

Line: 250

  l_status_update_user_id     NUMBER;

Line: 258

PROCEDURE DELETE_UWQM_ITEM
( p_api_version               IN NUMBER,
  p_init_msg_list             IN VARCHAR2,
  p_commit                    IN VARCHAR2,
  p_workitem_obj_code         IN VARCHAR2,
  p_workitem_pk_id            IN NUMBER,
  p_user_id                   IN NUMBER,
  p_login_id                  IN NUMBER,
  x_msg_count                 OUT NOCOPY NUMBER,
  x_msg_data                  OUT NOCOPY VARCHAR2,
  x_return_status             OUT NOCOPY VARCHAR2) AS

  l_api_version  CONSTANT NUMBER        := 1.0;

Line: 271

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

Line: 280

  l_status_update_user_id     NUMBER;

Line: 284

END DELETE_UWQM_ITEM;

Line: 312

  l_old_status_update_user_id NUMBER;

Line: 313

  l_new_status_update_user_id NUMBER;