DBA Data[Home] [Help]

APPS.IEU_SH_PUB SQL Statements

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

Line: 112

PROCEDURE UWQ_UPDATE_ACTIVITY
( P_API_VERSION               IN NUMBER,
  P_INIT_MSG_LIST             IN VARCHAR2 DEFAULT fnd_api.g_false,
  P_COMMIT                    IN VARCHAR2 DEFAULT fnd_api.g_false,
  P_ACTIVITY_ID               IN NUMBER,
  P_INTERMEDIATE_STATE_CODE   IN VARCHAR2 DEFAULT NULL,
  P_MEDIA_TYPE_ID             IN NUMBER   DEFAULT NULL,
  P_MEDIA_ID                  IN NUMBER   DEFAULT NULL,
  P_REASON_CODE               IN VARCHAR2 DEFAULT NULL,
  X_MSG_COUNT                 OUT NOCOPY NUMBER,
  X_MSG_DATA                  OUT NOCOPY VARCHAR2,
  X_RETURN_STATUS             OUT NOCOPY VARCHAR2) IS

BEGIN


        IEU_SH_PVT.UWQ_UPDATE_ACTIVITY
        ( P_API_VERSION,
          P_INIT_MSG_LIST,
          P_COMMIT,
          P_ACTIVITY_ID,
          P_INTERMEDIATE_STATE_CODE,
          P_MEDIA_TYPE_ID,
          P_MEDIA_ID,
          P_REASON_CODE,
          X_MSG_COUNT,
          X_MSG_DATA,
          X_RETURN_STATUS);
Line: 142

END UWQ_UPDATE_ACTIVITY;