APPS.EAM_ESTIMATE_ASSOCIATIONS_PKG SQL Statements

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

Line: 13

PROCEDURE INSERT_ROW(
          px_ESTIMATE_ASSOCIATION_ID  IN OUT NOCOPY NUMBER,
          p_ORGANIZATION_ID                         NUMBER,
          p_ESTIMATE_ID                             NUMBER,
          p_CU_ID                                   NUMBER,
          p_CU_QTY                                  NUMBER,
          p_ACCT_CLASS_CODE                         VARCHAR2,
          p_ACTIVITY_ID                             NUMBER,
          p_ACTIVITY_QTY                            NUMBER,
          p_DIFFICULTY_ID                           NUMBER,
          p_RESOURCE_MULTIPLIER                     NUMBER,
          p_CREATION_DATE                           DATE,
          p_CREATED_BY                              NUMBER,
          p_LAST_UPDATE_DATE                        DATE,
          p_LAST_UPDATED_BY                         NUMBER,
          p_LAST_UPDATE_LOGIN                       NUMBER
          )
IS
   CURSOR C IS SELECT EAM_ESTIMATE_ASSOCIATIONS_S.NEXTVAL FROM SYS.DUAL;

Line: 38

  INSERT INTO EAM_ESTIMATE_ASSOCIATIONS(
    ESTIMATE_ASSOCIATION_ID,
    ORGANIZATION_ID,
    ESTIMATE_ID,
    CU_ID,
    CU_QTY,
    ACCT_CLASS_CODE,
    ACTIVITY_ID,
    ACTIVITY_QTY,
    DIFFICULTY_ID,
    RESOURCE_MULTIPLIER,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) VALUES (
    px_ESTIMATE_ASSOCIATION_ID,
    decode(p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
    decode(P_ESTIMATE_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATE_ID),
    decode(p_CU_ID, FND_API.G_MISS_NUM, NULL, p_CU_ID),
    decode(p_CU_QTY, FND_API.G_MISS_NUM, NULL, p_CU_QTY),
    decode(p_ACCT_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, p_ACCT_CLASS_CODE),
    decode(p_ACTIVITY_ID, FND_API.G_MISS_NUM, NULL, p_ACTIVITY_ID),
    decode(p_ACTIVITY_QTY, FND_API.G_MISS_NUM, NULL, p_ACTIVITY_QTY),
    decode(p_DIFFICULTY_ID, FND_API.G_MISS_NUM, NULL, p_DIFFICULTY_ID),
    decode(p_RESOURCE_MULTIPLIER, FND_API.G_MISS_NUM, NULL, p_RESOURCE_MULTIPLIER),
    decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
    decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
    decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
    decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
    decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
  );

Line: 71

END INSERT_ROW;

Line: 73

PROCEDURE UPDATE_ROW(
          p_ESTIMATE_ASSOCIATION_ID                 NUMBER,
          p_ORGANIZATION_ID                         NUMBER,
          p_ESTIMATE_ID                             NUMBER,
          p_CU_ID                                   NUMBER,
          p_CU_QTY                                  NUMBER,
          p_ACCT_CLASS_CODE                         VARCHAR2,
          p_ACTIVITY_ID                             NUMBER,
          p_ACTIVITY_QTY                            NUMBER,
          p_DIFFICULTY_ID                           NUMBER,
          p_RESOURCE_MULTIPLIER                     NUMBER,
          p_CREATION_DATE                           DATE,
          p_CREATED_BY                              NUMBER,
          p_LAST_UPDATE_DATE                        DATE,
          p_LAST_UPDATED_BY                         NUMBER,
          p_LAST_UPDATE_LOGIN                       NUMBER
          )
IS
BEGIN
  UPDATE EAM_ESTIMATE_ASSOCIATIONS
  SET ORGANIZATION_ID = decode(p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
      ESTIMATE_ID = decode(p_ESTIMATE_ID, FND_API.G_MISS_NUM, ESTIMATE_ID, p_ESTIMATE_ID),
      CU_ID = decode(p_CU_ID, FND_API.G_MISS_NUM, CU_ID, p_CU_ID),
      CU_QTY = decode(p_CU_QTY, FND_API.G_MISS_NUM, CU_QTY, p_CU_QTY),
      ACCT_CLASS_CODE = decode(p_ACCT_CLASS_CODE, FND_API.G_MISS_CHAR, ACCT_CLASS_CODE, p_ACCT_CLASS_CODE),
      ACTIVITY_ID = decode(p_ACTIVITY_ID, FND_API.G_MISS_NUM, ACTIVITY_ID, p_ACTIVITY_ID),
      ACTIVITY_QTY = decode(p_ACTIVITY_QTY, FND_API.G_MISS_NUM, ACTIVITY_QTY, p_ACTIVITY_QTY),
      DIFFICULTY_ID = decode(p_DIFFICULTY_ID, FND_API.G_MISS_NUM, DIFFICULTY_ID, p_DIFFICULTY_ID),
      RESOURCE_MULTIPLIER = decode(p_RESOURCE_MULTIPLIER, FND_API.G_MISS_NUM, RESOURCE_MULTIPLIER, p_RESOURCE_MULTIPLIER),
      CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
      CREATED_BY = decode(p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
      LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
      LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
      LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
  WHERE ESTIMATE_ASSOCIATION_ID = p_ESTIMATE_ASSOCIATION_ID;

Line: 112

END UPDATE_ROW;

Line: 127

          p_LAST_UPDATE_DATE                        DATE,
          p_LAST_UPDATED_BY                         NUMBER,
          p_LAST_UPDATE_LOGIN                       NUMBER
          )
IS
  CURSOR C IS
    SELECT *
    FROM EAM_ESTIMATE_ASSOCIATIONS
    WHERE ESTIMATE_ASSOCIATION_ID =  p_ESTIMATE_ASSOCIATION_ID
    FOR UPDATE OF ESTIMATE_ASSOCIATION_ID NOWAIT;

Line: 143

    FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

Line: 160

    AND ((Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE) OR ((Recinfo.LAST_UPDATE_DATE IS NULL) AND (p_LAST_UPDATE_DATE IS NULL)))
    AND ((Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY) OR ((Recinfo.LAST_UPDATED_BY IS NULL) AND (p_LAST_UPDATED_BY IS NULL)))
    AND ((Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN) OR ((Recinfo.LAST_UPDATE_LOGIN IS NULL) AND (p_LAST_UPDATE_LOGIN IS NULL)))
    )
  THEN
    RETURN;

Line: 172

PROCEDURE DELETE_ROW(
          p_ESTIMATE_ASSOCIATION_ID                 NUMBER
          )
IS
BEGIN
  DELETE FROM EAM_ESTIMATE_ASSOCIATIONS
  WHERE ESTIMATE_ASSOCIATION_ID = p_ESTIMATE_ASSOCIATION_ID;

Line: 183

END DELETE_ROW;