APPS.IBC_STYLESHEETS_PKG SQL Statements

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

Line: 16

PROCEDURE INSERT_ROW (
  x_ROWID OUT NOCOPY VARCHAR2,
  p_CONTENT_TYPE_CODE IN VARCHAR2,
  p_CONTENT_ITEM_ID IN NUMBER,
  p_OBJECT_VERSION_NUMBER IN NUMBER,
  p_default_stylesheet_flag IN VARCHAR2,
  p_CREATION_DATE IN DATE,
  p_CREATED_BY IN NUMBER,
  p_LAST_UPDATE_DATE IN DATE,
  p_LAST_UPDATED_BY IN NUMBER,
  p_LAST_UPDATE_LOGIN IN NUMBER
) IS
  CURSOR C IS SELECT ROWID FROM IBC_STYLESHEETS
    WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
    AND CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
    ;

Line: 33

  INSERT INTO IBC_STYLESHEETS (
    CONTENT_TYPE_CODE,
    CONTENT_ITEM_ID,
	default_stylesheet_flag,
    OBJECT_VERSION_NUMBER,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) VALUES (
    p_CONTENT_TYPE_CODE,
    p_CONTENT_ITEM_ID,
	p_default_stylesheet_flag,
    p_OBJECT_VERSION_NUMBER,
    DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
           p_creation_date),
    DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
           NULL, Fnd_Global.user_id, p_created_by),
    DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
           p_last_update_date),
    DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
           NULL, Fnd_Global.user_id, p_last_updated_by),
    DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
           NULL, Fnd_Global.login_id, p_last_update_login)
  );

Line: 68

END INSERT_ROW;

Line: 75

  CURSOR c IS SELECT
      OBJECT_VERSION_NUMBER
    FROM IBC_STYLESHEETS
    WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
    AND CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
    FOR UPDATE OF CONTENT_TYPE_CODE NOWAIT;

Line: 88

    Fnd_Message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 102

PROCEDURE UPDATE_ROW (
  p_CONTENT_ITEM_ID    IN  NUMBER,
  p_CONTENT_TYPE_CODE    IN  VARCHAR2,
  p_default_stylesheet_flag IN VARCHAR2,
  p_LAST_UPDATED_BY    IN  NUMBER,
  p_LAST_UPDATE_DATE    IN  DATE,
  p_LAST_UPDATE_LOGIN    IN  NUMBER,
  p_OBJECT_VERSION_NUMBER    IN  NUMBER
) IS
BEGIN
  UPDATE IBC_STYLESHEETS SET
   CONTENT_TYPE_CODE = DECODE(p_CONTENT_TYPE_CODE,Fnd_Api.G_MISS_CHAR,NULL,NULL,CONTENT_TYPE_CODE,p_CONTENT_TYPE_CODE),
   CONTENT_ITEM_ID = DECODE(p_CONTENT_ITEM_ID,Fnd_Api.G_MISS_NUM,NULL,NULL,CONTENT_ITEM_ID,p_CONTENT_ITEM_ID),
   default_stylesheet_flag = DECODE(p_default_stylesheet_flag,Fnd_Api.G_MISS_CHAR,'F',NULL,default_stylesheet_flag,p_default_stylesheet_flag),
   OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
   last_update_date = DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE,
                              NULL, SYSDATE, p_last_update_date),
   last_updated_by = DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM,
                             Fnd_Global.user_id, NULL, Fnd_Global.user_id,
                             p_last_updated_by),
   last_update_login = DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM,
                             Fnd_Global.login_id, NULL, Fnd_Global.login_id,
                             p_last_update_login)
  WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
  AND CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
  AND object_version_number = DECODE(p_object_version_number,
                                       Fnd_Api.G_MISS_NUM,object_version_number,
                                       NULL,object_version_number,
                                       p_object_version_number);

Line: 136

END UPDATE_ROW;

Line: 138

PROCEDURE DELETE_ROW (
  p_CONTENT_TYPE_CODE IN VARCHAR2,
  p_CONTENT_ITEM_ID IN NUMBER
) IS
BEGIN

  DELETE FROM IBC_STYLESHEETS
  WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
  AND CONTENT_ITEM_ID = p_CONTENT_ITEM_ID;

Line: 151

END DELETE_ROW;

Line: 159

  p_LAST_UPDATE_DATE IN VARCHAR2) IS
BEGIN
	IF (p_UPLOAD_MODE = 'NLS') THEN
		NULL;

Line: 170

			p_LAST_UPDATE_DATE => p_LAST_UPDATE_DATE );

Line: 181

  p_LAST_UPDATE_DATE IN VARCHAR2) IS

  l_default_stylesheet_flag	  CHAR(1);

Line: 193

	    l_last_update_date DATE;

Line: 196

	    db_last_update_date DATE;

Line: 199

		--get last updated by user id
		l_user_id := FND_LOAD_UTIL.OWNER_ID(p_OWNER);

Line: 202

		--translate data type VARCHAR2 to DATE for last_update_date
		l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);

Line: 205

		-- get updatedby  and update_date values if existing in db
		SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
		FROM IBC_STYLESHEETS
		WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
		AND CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
		AND object_version_number = DECODE(object_version_number,
						       Fnd_Api.G_MISS_NUM,object_version_number,
						       NULL,object_version_number,
						       object_version_number);

Line: 227

			SELECT count(*) INTO l_temp from IBC_STYLESHEETS
			WHERE content_type_code = p_CONTENT_TYPE_CODE
			and   CONTENT_ITEM_ID <> p_CONTENT_ITEM_ID
			and   default_stylesheet_flag = 'T';

Line: 242

		IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
			db_user_id, db_last_update_date, p_upload_mode )) THEN

			UPDATE_ROW (
			  p_CONTENT_ITEM_ID	=>	p_CONTENT_ITEM_ID,
			  p_CONTENT_TYPE_CODE	=>	p_CONTENT_TYPE_CODE,
			  p_default_stylesheet_flag => nvl(l_default_stylesheet_flag,FND_API.G_MISS_CHAR),
			  p_LAST_UPDATED_BY    	 => l_user_id,
			  p_LAST_UPDATE_DATE     => SYSDATE,
			  p_LAST_UPDATE_LOGIN    => 0,
			  p_OBJECT_VERSION_NUMBER	=> NULL );

Line: 257

	       INSERT_ROW (
		  X_ROWID => l_row_id,
		  p_CONTENT_ITEM_ID =>	p_CONTENT_ITEM_ID,
		  p_CONTENT_TYPE_CODE	=>	p_CONTENT_TYPE_CODE,
		  p_default_stylesheet_flag => 	p_default_stylesheet_flag,
		  p_OBJECT_VERSION_NUMBER	=>	1,
		  p_CREATION_DATE => SYSDATE,
		  p_CREATED_BY 	=> l_user_id,
		  p_LAST_UPDATE_DATE => SYSDATE,
		  p_LAST_UPDATED_BY => l_user_id,
		  p_LAST_UPDATE_LOGIN => 0);