APPS.JTF_IH_MEDIA_LC_TY_SEED_PVT SQL Statements

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

Line: 3

     PROCEDURE insert_row(
          x_rowid                          IN OUT VARCHAR2
        , x_milcs_type_id                    NUMBER
        , x_object_version_number            NUMBER
        , x_created_by                       NUMBER
        , x_creation_date                    DATE
        , x_last_updated_by                  NUMBER
        , x_last_update_date                 DATE
        , x_last_update_login                NUMBER
        , x_milcs_code                       VARCHAR2
        , x_short_description                VARCHAR2
     ) IS
        CURSOR l_insert IS
          SELECT ROWID
          FROM jtf_ih_media_itm_lc_seg_tys
          WHERE milcs_type_id = x_milcs_type_id;

Line: 20

        INSERT INTO jtf_ih_media_itm_lc_seg_tys (
          milcs_type_id
        , object_version_number
        , created_by
        , creation_date
        , last_updated_by
        , last_update_date
        , last_update_login
        , milcs_code
        , short_description
        ) VALUES (
          x_milcs_type_id
        , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
        , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
        , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
        , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
        , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
        , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
        , DECODE(x_milcs_code,FND_API.G_MISS_CHAR,NULL,x_milcs_code)
        , DECODE(x_short_description,FND_API.G_MISS_CHAR,NULL,x_short_description)
        );

Line: 42

        OPEN l_insert;

Line: 43

        FETCH l_insert INTO x_rowid;

Line: 44

        IF (l_insert%NOTFOUND) THEN
            CLOSE l_insert;

Line: 48

     END insert_row;

Line: 50

     PROCEDURE delete_row(
        x_milcs_type_id                    NUMBER
     ) IS
     BEGIN
        DELETE FROM jtf_ih_media_itm_lc_seg_tys
        WHERE milcs_type_id = x_milcs_type_id;

Line: 59

     END delete_row;

Line: 61

     PROCEDURE update_row(
          x_milcs_type_id                  NUMBER
        , x_object_version_number          NUMBER
        , x_last_updated_by                NUMBER
        , x_last_update_date               DATE
        , x_last_update_login              NUMBER
        , x_milcs_code                     VARCHAR2
        , x_short_description              VARCHAR2
     ) IS
     BEGIN
        UPDATE jtf_ih_media_itm_lc_seg_tys
        SET
          milcs_type_id=DECODE(x_milcs_type_id,FND_API.G_MISS_NUM,NULL,x_milcs_type_id)
        , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
        , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
        , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
        , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
        , milcs_code=DECODE(x_milcs_code,FND_API.G_MISS_CHAR,NULL,x_milcs_code)
        , short_description=DECODE(x_short_description,FND_API.G_MISS_CHAR,NULL,x_short_description)
        WHERE milcs_type_id = x_milcs_type_id;

Line: 84

     END update_row;

Line: 92

        , x_last_updated_by                NUMBER
        , x_last_update_date               DATE
        , x_last_update_login              NUMBER
        , x_milcs_code                     VARCHAR2
        , x_short_description              VARCHAR2
     ) IS
        CURSOR l_lock IS
          SELECT *
          FROM jtf_ih_media_itm_lc_seg_tys
          WHERE rowid = x_rowid
          FOR UPDATE OF milcs_type_id NOWAIT;

Line: 109

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

Line: 126

          AND           ((l_table_rec.last_updated_by = x_last_updated_by)
            OR ((l_table_rec.last_updated_by IS NULL)
                AND ( x_last_updated_by IS NULL)))
          AND           ((l_table_rec.last_update_date = x_last_update_date)
            OR ((l_table_rec.last_update_date IS NULL)
                AND ( x_last_update_date IS NULL)))
          AND           ((l_table_rec.last_update_login = x_last_update_login)
            OR ((l_table_rec.last_update_login IS NULL)
                AND ( x_last_update_login IS NULL)))
          AND           ((l_table_rec.milcs_code = x_milcs_code)
            OR ((l_table_rec.milcs_code IS NULL)
                AND ( x_milcs_code IS NULL)))
          AND           ((l_table_rec.short_description = x_short_description)
            OR ((l_table_rec.short_description IS NULL)
                AND ( x_short_description IS NULL)))
        ) THEN
          RETURN;

Line: 144

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

Line: 171

	l_last_update_date	DATE;

Line: 172

	l_last_updated_by	NUMBER;

Line: 173

	l_last_update_login	NUMBER;

Line: 185

	l_last_update_date := sysdate;

Line: 186

	l_last_updated_by := user_id;

Line: 187

	l_last_update_login := 0;

Line: 190

	UPDATE_ROW(
  			X_MILCS_TYPE_ID => l_milcs_type_id,
			X_OBJECT_VERSION_NUMBER => l_object_version_number,
  			X_MILCS_CODE => l_milcs_code,
  			X_SHORT_DESCRIPTION => l_short_description,
  			X_LAST_UPDATE_DATE => l_last_update_date,
  			X_LAST_UPDATED_BY => l_last_updated_by,
  			X_LAST_UPDATE_LOGIN => l_last_update_login);

Line: 202

			INSERT_ROW(
			row_id,
  			X_MILCS_TYPE_ID => l_milcs_type_id,
  			X_OBJECT_VERSION_NUMBER => l_object_version_number,
  			X_MILCS_CODE => l_milcs_code,
  			X_SHORT_DESCRIPTION => l_short_description,
			X_CREATION_DATE => l_creation_date,
			X_CREATED_BY => l_created_by,
  			X_LAST_UPDATE_DATE => l_last_update_date,
  			X_LAST_UPDATED_BY => l_last_updated_by,
  			X_LAST_UPDATE_LOGIN => l_last_update_login);