DBA Data[Home] [Help]

APPS.IEU_UWQM_AUDIT_LOG_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
P_ACTION_KEY			IN VARCHAR2,
P_EVENT_KEY			IN VARCHAR2,
P_MODULE			IN VARCHAR2,
P_WS_CODE			IN VARCHAR2,
P_APPLICATION_ID		IN VARCHAR2,
P_WORKITEM_PK_ID		IN VARCHAR2,
P_WORKITEM_OBJ_CODE		IN VARCHAR2,
P_WORK_ITEM_STATUS_PREV		IN VARCHAR2,
P_WORK_ITEM_STATUS_CURR		IN VARCHAR2,
P_OWNER_ID_PREV			IN NUMBER,
P_OWNER_ID_CURR			IN NUMBER,
P_OWNER_TYPE_PREV		IN VARCHAR2,
P_OWNER_TYPE_CURR		IN VARCHAR2,
P_ASSIGNEE_ID_PREV		IN NUMBER,
P_ASSIGNEE_ID_CURR		IN NUMBER,
P_ASSIGNEE_TYPE_PREV		IN VARCHAR2,
P_ASSIGNEE_TYPE_CURR		IN VARCHAR2,
P_SOURCE_OBJECT_ID_PREV		IN NUMBER,
P_SOURCE_OBJECT_ID_CURR		IN NUMBER,
P_SOURCE_OBJECT_TYPE_CODE_PREV  IN VARCHAR2,
P_SOURCE_OBJECT_TYPE_CODE_CURR  IN VARCHAR2,
P_PARENT_WORKITEM_STATUS_PREV	IN VARCHAR2,
P_PARENT_WORKITEM_STATUS_CURR	IN VARCHAR2,
P_PARENT_DIST_STATUS_PREV	IN VARCHAR2,
P_PARENT_DIST_STATUS_CURR	IN VARCHAR2,
P_WORKITEM_DIST_STATUS_PREV	IN VARCHAR2,
P_WORKITEM_DIST_STATUS_CURR	IN VARCHAR2,
P_PRIORITY_PREV			IN VARCHAR2,
P_PRIORITY_CURR			IN VARCHAR2,
P_DUE_DATE_PREV			IN DATE,
P_DUE_DATE_CURR			IN DATE,
P_RESCHEDULE_TIME_PREV		IN DATE,
P_RESCHEDULE_TIME_CURR		IN DATE,
P_IEU_COMMENT_CODE1		IN VARCHAR2,
P_IEU_COMMENT_CODE2		IN VARCHAR2,
P_IEU_COMMENT_CODE3		IN VARCHAR2,
P_IEU_COMMENT_CODE4		IN VARCHAR2,
P_IEU_COMMENT_CODE5		IN VARCHAR2,
P_WORKITEM_COMMENT_CODE1	IN VARCHAR2,
P_WORKITEM_COMMENT_CODE2	IN VARCHAR2,
P_WORKITEM_COMMENT_CODE3	IN VARCHAR2,
P_WORKITEM_COMMENT_CODE4	IN VARCHAR2,
P_WORKITEM_COMMENT_CODE5	IN VARCHAR2,
P_STATUS			IN VARCHAR2,
P_ERROR_CODE			IN VARCHAR2,
X_AUDIT_LOG_ID			OUT NOCOPY NUMBER,
x_msg_data			OUT NOCOPY VARCHAR2,
x_return_status			OUT NOCOPY VARCHAR2

) is

l_work_item_number VARCHAR2(100);
Line: 64

    SELECT WORK_ITEM_NUMBER
    INTO   L_WORK_ITEM_NUMBER
    FROM   IEU_UWQM_ITEMS
    WHERE  WORKITEM_PK_ID = P_WORKITEM_PK_ID
    AND    WORKITEM_OBJ_CODE = P_WORKITEM_OBJ_CODE;
Line: 75

  insert into IEU_UWQM_AUDIT_LOG
  (	AUDIT_LOG_ID,
        OBJECT_VERSION_NUMBER,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
	ACTION_KEY,
	EVENT_KEY,
	MODULE,
	WS_CODE,
	APPLICATION_ID,
	WORKITEM_PK_ID,
	WORKITEM_OBJ_CODE,
	WORK_ITEM_NUMBER,
	WORKITEM_STATUS_ID_PREV,
	WORKITEM_STATUS_ID_CURR,
	OWNER_ID_PREV,
	OWNER_ID_CURR,
	OWNER_TYPE_PREV,
	OWNER_TYPE_CURR,
	ASSIGNEE_ID_PREV,
	ASSIGNEE_ID_CURR,
	ASSIGNEE_TYPE_PREV,
	ASSIGNEE_TYPE_CURR,
	SOURCE_OBJECT_ID_PREV,
	SOURCE_OBJECT_ID_CURR,
	SOURCE_OBJECT_TYPE_CODE_PREV,
	SOURCE_OBJECT_TYPE_CODE_CURR,
	PARENT_WORKITEM_STATUS_ID_PREV,
	PARENT_WORKITEM_STATUS_ID_CURR,
	PARENT_DIST_STATUS_ID_PREV,
	PARENT_DIST_STATUS_ID_CURR,
	WORKITEM_DIST_STATUS_ID_PREV,
	WORKITEM_DIST_STATUS_ID_CURR,
	PRIORITY_ID_PREV,
	PRIORITY_ID_CURR,
	DUE_DATE_PREV,
	DUE_DATE_CURR,
	RESCHEDULE_TIME_PREV,
	RESCHEDULE_TIME_CURR,
	IEU_COMMENT_CODE1,
	IEU_COMMENT_CODE2,
	IEU_COMMENT_CODE3,
	IEU_COMMENT_CODE4,
	IEU_COMMENT_CODE5,
	WORKITEM_COMMENT_CODE1,
	WORKITEM_COMMENT_CODE2,
	WORKITEM_COMMENT_CODE3,
	WORKITEM_COMMENT_CODE4,
	WORKITEM_COMMENT_CODE5,
	RETURN_STATUS,
	ERROR_CODE,
	LOGGING_LEVEL)
  values
	(
	IEU_UWQM_AUDIT_LOG_S1.NEXTVAL,
        1,
        FND_GLOBAL.USER_ID,
        SYSDATE,
        FND_GLOBAL.USER_ID,
        SYSDATE,
        FND_GLOBAL.LOGIN_ID,
	P_ACTION_KEY,
	P_EVENT_KEY,
	P_MODULE,
	P_WS_CODE,
	P_APPLICATION_ID,
	P_WORKITEM_PK_ID,
	P_WORKITEM_OBJ_CODE,
	L_WORK_ITEM_NUMBER,
	P_WORK_ITEM_STATUS_PREV,
	P_WORK_ITEM_STATUS_CURR,
	P_OWNER_ID_PREV,
	P_OWNER_ID_CURR,
	P_OWNER_TYPE_PREV,
	P_OWNER_TYPE_CURR,
	P_ASSIGNEE_ID_PREV,
	P_ASSIGNEE_ID_CURR,
	P_ASSIGNEE_TYPE_PREV,
	P_ASSIGNEE_TYPE_CURR,
	P_SOURCE_OBJECT_ID_PREV,
	P_SOURCE_OBJECT_ID_CURR,
	P_SOURCE_OBJECT_TYPE_CODE_PREV,
	P_SOURCE_OBJECT_TYPE_CODE_CURR,
	P_PARENT_WORKITEM_STATUS_PREV,
	P_PARENT_WORKITEM_STATUS_CURR,
	P_PARENT_DIST_STATUS_PREV,
	P_PARENT_DIST_STATUS_CURR,
	P_WORKITEM_DIST_STATUS_PREV,
	P_WORKITEM_DIST_STATUS_CURR,
	P_PRIORITY_PREV,
	P_PRIORITY_CURR,
	P_DUE_DATE_PREV,
	P_DUE_DATE_CURR,
	P_RESCHEDULE_TIME_PREV,
	P_RESCHEDULE_TIME_CURR,
	P_IEU_COMMENT_CODE1,
	P_IEU_COMMENT_CODE2,
	P_IEU_COMMENT_CODE3,
	P_IEU_COMMENT_CODE4,
	P_IEU_COMMENT_CODE5,
	P_WORKITEM_COMMENT_CODE1,
	P_WORKITEM_COMMENT_CODE2,
	P_WORKITEM_COMMENT_CODE3,
	P_WORKITEM_COMMENT_CODE4,
	P_WORKITEM_COMMENT_CODE5,
	P_STATUS,
	P_ERROR_CODE,
	l_audit_log_val) RETURNING AUDIT_LOG_ID INTO X_AUDIT_LOG_ID;
Line: 188

end INSERT_ROW;
Line: 190

procedure UPDATE_ROW (
P_AUDIT_LOG_ID			IN NUMBER,
P_ACTION_KEY			IN VARCHAR2,
P_EVENT_KEY			IN VARCHAR2,
P_MODULE			IN VARCHAR2,
P_WS_CODE			IN VARCHAR2,
P_APPLICATION_ID		IN VARCHAR2,
P_WORKITEM_PK_ID		IN VARCHAR2,
P_WORKITEM_OBJ_CODE		IN VARCHAR2,
P_WORK_ITEM_STATUS_PREV		IN VARCHAR2,
P_WORK_ITEM_STATUS_CURR		IN VARCHAR2,
P_OWNER_ID_PREV			IN NUMBER,
P_OWNER_ID_CURR			IN NUMBER,
P_OWNER_TYPE_PREV		IN VARCHAR2,
P_OWNER_TYPE_CURR		IN VARCHAR2,
P_ASSIGNEE_ID_PREV		IN NUMBER,
P_ASSIGNEE_ID_CURR		IN NUMBER,
P_ASSIGNEE_TYPE_PREV		IN VARCHAR2,
P_ASSIGNEE_TYPE_CURR		IN VARCHAR2,
P_SOURCE_OBJECT_ID_PREV		IN NUMBER,
P_SOURCE_OBJECT_ID_CURR		IN NUMBER,
P_SOURCE_OBJECT_TYPE_CODE_PREV  IN VARCHAR2,
P_SOURCE_OBJECT_TYPE_CODE_CURR  IN VARCHAR2,
P_PARENT_WORKITEM_STATUS_PREV	IN VARCHAR2,
P_PARENT_WORKITEM_STATUS_CURR	IN VARCHAR2,
P_PARENT_DIST_STATUS_PREV	IN VARCHAR2,
P_PARENT_DIST_STATUS_CURR	IN VARCHAR2,
P_WORKITEM_DIST_STATUS_PREV	IN VARCHAR2,
P_WORKITEM_DIST_STATUS_CURR	IN VARCHAR2,
P_PRIORITY_PREV			IN VARCHAR2,
P_PRIORITY_CURR			IN VARCHAR2,
P_DUE_DATE_PREV			IN DATE,
P_DUE_DATE_CURR			IN DATE,
P_RESCHEDULE_TIME_PREV		IN DATE,
P_RESCHEDULE_TIME_CURR		IN DATE,
P_IEU_COMMENT_CODE1		IN VARCHAR2,
P_IEU_COMMENT_CODE2		IN VARCHAR2,
P_IEU_COMMENT_CODE3		IN VARCHAR2,
P_IEU_COMMENT_CODE4		IN VARCHAR2,
P_IEU_COMMENT_CODE5		IN VARCHAR2,
P_WORKITEM_COMMENT_CODE1	IN VARCHAR2,
P_WORKITEM_COMMENT_CODE2	IN VARCHAR2,
P_WORKITEM_COMMENT_CODE3	IN VARCHAR2,
P_WORKITEM_COMMENT_CODE4	IN VARCHAR2,
P_WORKITEM_COMMENT_CODE5	IN VARCHAR2,
P_STATUS			IN VARCHAR2,
P_ERROR_CODE			IN VARCHAR2
) is

l_audit_log_val VARCHAR2(100);
Line: 245

  UPDATE IEU_UWQM_AUDIT_LOG
  SET
        CREATED_BY		    =   FND_GLOBAL.USER_ID,
        CREATION_DATE		    =   SYSDATE,
        LAST_UPDATED_BY		    =   FND_GLOBAL.USER_ID,
        LAST_UPDATE_DATE	    =   SYSDATE,
        LAST_UPDATE_LOGIN	    =   FND_GLOBAL.LOGIN_ID,
        OBJECT_VERSION_NUMBER	    =   OBJECT_VERSION_NUMBER + 1,
	ACTION_KEY                  =   P_ACTION_KEY,
	EVENT_KEY                   =   P_EVENT_KEY,
	MODULE                      =   P_MODULE,
	WS_CODE                     =   P_WS_CODE,
	APPLICATION_ID              =   P_APPLICATION_ID,
	WORKITEM_STATUS_ID_PREV     =   P_WORK_ITEM_STATUS_PREV,
	WORKITEM_STATUS_ID_CURR     =   P_WORK_ITEM_STATUS_CURR,
	OWNER_ID_PREV               =   P_OWNER_ID_PREV	,
	OWNER_ID_CURR               =   P_OWNER_ID_CURR,
	OWNER_TYPE_PREV             =   P_OWNER_TYPE_PREV,
	OWNER_TYPE_CURR             =   P_OWNER_TYPE_CURR,
	ASSIGNEE_ID_PREV            =   P_ASSIGNEE_ID_PREV,
	ASSIGNEE_ID_CURR            =   P_ASSIGNEE_ID_CURR,
	ASSIGNEE_TYPE_PREV          =   P_ASSIGNEE_TYPE_PREV,
	ASSIGNEE_TYPE_CURR          =   P_ASSIGNEE_TYPE_CURR,
	SOURCE_OBJECT_ID_PREV       =   P_SOURCE_OBJECT_ID_PREV,
	SOURCE_OBJECT_ID_CURR       =   P_SOURCE_OBJECT_ID_CURR,
	SOURCE_OBJECT_TYPE_CODE_PREV =   P_SOURCE_OBJECT_TYPE_CODE_PREV,
	SOURCE_OBJECT_TYPE_CODE_CURR =   P_SOURCE_OBJECT_TYPE_CODE_CURR,
	PARENT_WORKITEM_STATUS_ID_PREV =   P_PARENT_WORKITEM_STATUS_PREV,
	PARENT_WORKITEM_STATUS_ID_CURR =   P_PARENT_WORKITEM_STATUS_CURR,
	PARENT_DIST_STATUS_ID_PREV  =   P_PARENT_DIST_STATUS_PREV,
	PARENT_DIST_STATUS_ID_CURR  =   P_PARENT_DIST_STATUS_CURR,
	WORKITEM_DIST_STATUS_ID_PREV   =   P_WORKITEM_DIST_STATUS_PREV,
	WORKITEM_DIST_STATUS_ID_CURR   =   P_WORKITEM_DIST_STATUS_CURR,
	PRIORITY_ID_PREV               =   P_PRIORITY_PREV,
	PRIORITY_ID_CURR               =   P_PRIORITY_CURR,
	DUE_DATE_PREV               =   P_DUE_DATE_PREV,
	DUE_DATE_CURR               =   P_DUE_DATE_CURR,
	RESCHEDULE_TIME_PREV        =   P_RESCHEDULE_TIME_PREV,
	RESCHEDULE_TIME_CURR        =   P_RESCHEDULE_TIME_CURR,
	IEU_COMMENT_CODE1           =   P_IEU_COMMENT_CODE1,
	IEU_COMMENT_CODE2           =   P_IEU_COMMENT_CODE2,
	IEU_COMMENT_CODE3           =   P_IEU_COMMENT_CODE3,
	IEU_COMMENT_CODE4           =   P_IEU_COMMENT_CODE4,
	IEU_COMMENT_CODE5           =   P_IEU_COMMENT_CODE5,
	WORKITEM_COMMENT_CODE1      =   P_WORKITEM_COMMENT_CODE1,
	WORKITEM_COMMENT_CODE2      =   P_WORKITEM_COMMENT_CODE2,
	WORKITEM_COMMENT_CODE3      =   P_WORKITEM_COMMENT_CODE3,
	WORKITEM_COMMENT_CODE4      =   P_WORKITEM_COMMENT_CODE4,
	WORKITEM_COMMENT_CODE5      =   P_WORKITEM_COMMENT_CODE5,
	RETURN_STATUS               =   P_STATUS,
	ERROR_CODE                  =   P_ERROR_CODE,
	LOGGING_LEVEL		    =   L_AUDIT_LOG_VAL
   WHERE
        AUDIT_LOG_ID		    =   P_AUDIT_LOG_ID
   AND	WORKITEM_PK_ID              =   P_WORKITEM_PK_ID
   AND  WORKITEM_OBJ_CODE	    =   P_WORKITEM_OBJ_CODE;
Line: 305

end UPDATE_ROW;
Line: 361

   UPDATE_ROW(
	P_AUDIT_LOG_ID,
	P_ACTION_KEY,
	P_EVENT_KEY,
	P_MODULE,
	P_WS_CODE,
	P_APPLICATION_ID,
	P_WORKITEM_PK_ID,
	P_WORKITEM_OBJ_CODE,
	P_WORK_ITEM_STATUS_PREV,
	P_WORK_ITEM_STATUS_CURR,
	P_OWNER_ID_PREV,
	P_OWNER_ID_CURR,
	P_OWNER_TYPE_PREV,
	P_OWNER_TYPE_CURR,
	P_ASSIGNEE_ID_PREV,
	P_ASSIGNEE_ID_CURR,
	P_ASSIGNEE_TYPE_PREV,
	P_ASSIGNEE_TYPE_CURR,
	P_SOURCE_OBJECT_ID_PREV,
	P_SOURCE_OBJECT_ID_CURR,
	P_SOURCE_OBJECT_TYPE_CODE_PREV,
	P_SOURCE_OBJECT_TYPE_CODE_CURR,
	P_PARENT_WORKITEM_STATUS_PREV,
	P_PARENT_WORKITEM_STATUS_CURR,
	P_PARENT_DIST_STATUS_PREV,
	P_PARENT_DIST_STATUS_CURR,
	P_WORKITEM_DIST_STATUS_PREV,
	P_WORKITEM_DIST_STATUS_CURR,
	P_PRIORITY_PREV,
	P_PRIORITY_CURR,
	P_DUE_DATE_PREV,
	P_DUE_DATE_CURR,
	P_RESCHEDULE_TIME_PREV,
	P_RESCHEDULE_TIME_CURR,
	P_IEU_COMMENT_CODE1,
	P_IEU_COMMENT_CODE2,
	P_IEU_COMMENT_CODE3,
	P_IEU_COMMENT_CODE4,
	P_IEU_COMMENT_CODE5,
	P_WORKITEM_COMMENT_CODE1,
	P_WORKITEM_COMMENT_CODE2,
	P_WORKITEM_COMMENT_CODE3,
	P_WORKITEM_COMMENT_CODE4,
	P_WORKITEM_COMMENT_CODE5,
	P_STATUS,
	P_ERROR_CODE
	);
Line: 415

   INSERT_ROW(
	P_ACTION_KEY,
	P_EVENT_KEY,
	P_MODULE,
	P_WS_CODE,
	P_APPLICATION_ID,
	P_WORKITEM_PK_ID,
	P_WORKITEM_OBJ_CODE,
	P_WORK_ITEM_STATUS_PREV,
	P_WORK_ITEM_STATUS_CURR,
	P_OWNER_ID_PREV,
	P_OWNER_ID_CURR,
	P_OWNER_TYPE_PREV,
	P_OWNER_TYPE_CURR,
	P_ASSIGNEE_ID_PREV,
	P_ASSIGNEE_ID_CURR,
	P_ASSIGNEE_TYPE_PREV,
	P_ASSIGNEE_TYPE_CURR,
	P_SOURCE_OBJECT_ID_PREV,
	P_SOURCE_OBJECT_ID_CURR,
	P_SOURCE_OBJECT_TYPE_CODE_PREV,
	P_SOURCE_OBJECT_TYPE_CODE_CURR,
	P_PARENT_WORKITEM_STATUS_PREV,
	P_PARENT_WORKITEM_STATUS_CURR,
	P_PARENT_DIST_STATUS_PREV,
	P_PARENT_DIST_STATUS_CURR,
	P_WORKITEM_DIST_STATUS_PREV,
	P_WORKITEM_DIST_STATUS_CURR,
	P_PRIORITY_PREV,
	P_PRIORITY_CURR,
	P_DUE_DATE_PREV,
	P_DUE_DATE_CURR,
	P_RESCHEDULE_TIME_PREV,
	P_RESCHEDULE_TIME_CURR,
	P_IEU_COMMENT_CODE1,
	P_IEU_COMMENT_CODE2,
	P_IEU_COMMENT_CODE3,
	P_IEU_COMMENT_CODE4,
	P_IEU_COMMENT_CODE5,
	P_WORKITEM_COMMENT_CODE1,
	P_WORKITEM_COMMENT_CODE2,
	P_WORKITEM_COMMENT_CODE3,
	P_WORKITEM_COMMENT_CODE4,
	P_WORKITEM_COMMENT_CODE5,
	P_STATUS,
	P_ERROR_CODE,
	L_AUDIT_LOG_ID,
	x_msg_data,
        x_return_status
	);
Line: 468

procedure DELETE_ROW (
 P_WS_CODE IN VARCHAR2
) is
begin
  delete from IEU_UWQM_AUDIT_LOG
  where WS_CODE = P_WS_CODE;
Line: 479

end DELETE_ROW;