APPS.CS_CHG_SUB_REST_PKG SQL Statements

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

Line: 4

   PROCEDURE INSERT_ROW (
      PX_RESTRICTION_ID         IN OUT NOCOPY NUMBER,
      P_RESTRICTION_TYPE        IN VARCHAR2,
      P_CONDITION             	IN VARCHAR2,
      P_VALUE_OBJECT_ID 	IN NUMBER,
      P_VALUE_AMOUNT       	IN NUMBER,
      P_CURRENCY_CODE         	IN VARCHAR2,
      P_START_DATE_ACTIVE 	IN DATE,
      P_END_DATE_ACTIVE 	IN DATE,
      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,
      P_ATTRIBUTE1              IN VARCHAR2,
      P_ATTRIBUTE2              IN VARCHAR2,
      P_ATTRIBUTE3              IN VARCHAR2,
      P_ATTRIBUTE4              IN VARCHAR2,
      P_ATTRIBUTE5              IN VARCHAR2,
      P_ATTRIBUTE6              IN VARCHAR2,
      P_ATTRIBUTE7              IN VARCHAR2,
      P_ATTRIBUTE8              IN VARCHAR2,
      P_ATTRIBUTE9              IN VARCHAR2,
      P_ATTRIBUTE10             IN VARCHAR2,
      P_ATTRIBUTE11             IN VARCHAR2,
      P_ATTRIBUTE12             IN VARCHAR2,
      P_ATTRIBUTE13             IN VARCHAR2,
      P_ATTRIBUTE14             IN VARCHAR2,
      P_ATTRIBUTE15             IN VARCHAR2,
      P_CONTEXT                 IN VARCHAR2,
      P_OBJECT_VERSION_NUMBER   IN NUMBER,
      P_SECURITY_GROUP_ID       IN NUMBER)
IS
   cursor c1 is
   select cs_chg_sub_restrictions_s.nextval
   from dual;

Line: 48

   insert into CS_CHG_SUB_RESTRICTIONS (
      RESTRICTION_ID,		RESTRICTION_TYPE,	CONDITION,
      VALUE_OBJECT_ID,		VALUE_AMOUNT, 		CURRENCY_CODE,
      START_DATE_ACTIVE, 	END_DATE_ACTIVE, 	CREATION_DATE,
      CREATED_BY,		LAST_UPDATE_DATE, 	LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,	ATTRIBUTE1,             ATTRIBUTE2,
      ATTRIBUTE3, 		ATTRIBUTE4, 		ATTRIBUTE5,
      ATTRIBUTE6, 		ATTRIBUTE7, 		ATTRIBUTE8,
      ATTRIBUTE9, 		ATTRIBUTE10, 		ATTRIBUTE11,
      ATTRIBUTE12, 		ATTRIBUTE13, 		ATTRIBUTE14,
      ATTRIBUTE15,		CONTEXT, 		OBJECT_VERSION_NUMBER,
      SECURITY_GROUP_ID)
   VALUES (
      PX_RESTRICTION_ID,	P_RESTRICTION_TYPE,	P_CONDITION,
      P_VALUE_OBJECT_ID,	P_VALUE_AMOUNT, 	P_CURRENCY_CODE,
      P_START_DATE_ACTIVE, 	P_END_DATE_ACTIVE, 	P_CREATION_DATE,
      P_CREATED_BY,		P_LAST_UPDATE_DATE, 	P_LAST_UPDATED_BY,
      P_LAST_UPDATE_LOGIN,	P_ATTRIBUTE1, 		P_ATTRIBUTE2,
      P_ATTRIBUTE3, 		P_ATTRIBUTE4, 		P_ATTRIBUTE5,
      P_ATTRIBUTE6, 		P_ATTRIBUTE7, 		P_ATTRIBUTE8,
      P_ATTRIBUTE9, 		P_ATTRIBUTE10,          P_ATTRIBUTE11,
      P_ATTRIBUTE12, 		P_ATTRIBUTE13,          P_ATTRIBUTE14,
      P_ATTRIBUTE15,		P_CONTEXT, 		P_OBJECT_VERSION_NUMBER,
      P_SECURITY_GROUP_ID);

Line: 74

END INSERT_ROW;

Line: 82

   select 1
   from   cs_chg_sub_restrictions
   where  restriction_id          = p_restriction_id
   and    object_version_number = p_object_version_number
   for    update nowait;

Line: 94

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

Line: 102

PROCEDURE UPDATE_ROW (
      P_RESTRICTION_ID         	IN NUMBER,
      P_RESTRICTION_TYPE        IN VARCHAR2,
      P_CONDITION             	IN VARCHAR2,
      P_VALUE_OBJECT_ID 	IN NUMBER,
      P_VALUE_AMOUNT       	IN NUMBER,
      P_CURRENCY_CODE         	IN VARCHAR2,
      P_START_DATE_ACTIVE 	IN DATE,
      P_END_DATE_ACTIVE 	IN DATE,
      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,
      P_ATTRIBUTE1              IN VARCHAR2,
      P_ATTRIBUTE2              IN VARCHAR2,
      P_ATTRIBUTE3              IN VARCHAR2,
      P_ATTRIBUTE4              IN VARCHAR2,
      P_ATTRIBUTE5              IN VARCHAR2,
      P_ATTRIBUTE6              IN VARCHAR2,
      P_ATTRIBUTE7              IN VARCHAR2,
      P_ATTRIBUTE8              IN VARCHAR2,
      P_ATTRIBUTE9              IN VARCHAR2,
      P_ATTRIBUTE10             IN VARCHAR2,
      P_ATTRIBUTE11             IN VARCHAR2,
      P_ATTRIBUTE12             IN VARCHAR2,
      P_ATTRIBUTE13             IN VARCHAR2,
      P_ATTRIBUTE14             IN VARCHAR2,
      P_ATTRIBUTE15             IN VARCHAR2,
      P_CONTEXT                 IN VARCHAR2,
      P_OBJECT_VERSION_NUMBER   IN NUMBER,
      P_SECURITY_GROUP_ID       IN NUMBER)
IS

BEGIN

      UPDATE 	CS_CHG_SUB_RESTRICTIONS
      SET 	RESTRICTION_ID		= P_RESTRICTION_ID,
		RESTRICTION_TYPE	= P_RESTRICTION_TYPE,
		CONDITION		= P_CONDITION,
      		VALUE_OBJECT_ID		= P_VALUE_OBJECT_ID,
		VALUE_AMOUNT		= P_VALUE_AMOUNT,
		CURRENCY_CODE		= P_CURRENCY_CODE,
      		START_DATE_ACTIVE	= P_START_DATE_ACTIVE,
		END_DATE_ACTIVE		= P_END_DATE_ACTIVE,
		CREATION_DATE		= P_CREATION_DATE,
      		CREATED_BY		= P_CREATED_BY,
		LAST_UPDATE_DATE	= P_LAST_UPDATE_DATE,
		LAST_UPDATED_BY		= P_LAST_UPDATED_BY,
      		LAST_UPDATE_LOGIN	= P_LAST_UPDATE_LOGIN,
		ATTRIBUTE1		= P_ATTRIBUTE1,
      		ATTRIBUTE2		= P_ATTRIBUTE2,
		ATTRIBUTE3		= P_ATTRIBUTE3,
		ATTRIBUTE4		= P_ATTRIBUTE4,
      		ATTRIBUTE5		= P_ATTRIBUTE5,
		ATTRIBUTE6		= P_ATTRIBUTE6,
		ATTRIBUTE7		= P_ATTRIBUTE7,
      		ATTRIBUTE8		= P_ATTRIBUTE8,
		ATTRIBUTE9		= P_ATTRIBUTE9,
 		ATTRIBUTE10		= P_ATTRIBUTE10,
      		ATTRIBUTE11		= P_ATTRIBUTE11,
		ATTRIBUTE12		= P_ATTRIBUTE12,
		ATTRIBUTE13		= P_ATTRIBUTE13,
      		ATTRIBUTE14		= P_ATTRIBUTE14,
		ATTRIBUTE15		= P_ATTRIBUTE15,
		CONTEXT			= P_CONTEXT,
      		OBJECT_VERSION_NUMBER	= P_OBJECT_VERSION_NUMBER,
		SECURITY_GROUP_ID	= P_SECURITY_GROUP_ID
	WHERE  RESTRICTION_ID = P_RESTRICTION_ID;

Line: 176

END UPDATE_ROW;

Line: 178

PROCEDURE DELETE_ROW (
  P_RESTRICTION_ID in NUMBER)
IS
BEGIN

   DELETE FROM cs_chg_sub_restrictions
   WHERE restriction_id = p_restriction_id;

Line: 190

END DELETE_ROW;

Line: 203

      P_LAST_UPDATE_DATE        IN DATE,
      P_LAST_UPDATED_BY		IN NUMBER,
      P_LAST_UPDATE_LOGIN	IN NUMBER,
      P_ATTRIBUTE1              IN VARCHAR2,
      P_ATTRIBUTE2              IN VARCHAR2,
      P_ATTRIBUTE3              IN VARCHAR2,
      P_ATTRIBUTE4              IN VARCHAR2,
      P_ATTRIBUTE5              IN VARCHAR2,
      P_ATTRIBUTE6              IN VARCHAR2,
      P_ATTRIBUTE7              IN VARCHAR2,
      P_ATTRIBUTE8              IN VARCHAR2,
      P_ATTRIBUTE9              IN VARCHAR2,
      P_ATTRIBUTE10             IN VARCHAR2,
      P_ATTRIBUTE11             IN VARCHAR2,
      P_ATTRIBUTE12             IN VARCHAR2,
      P_ATTRIBUTE13             IN VARCHAR2,
      P_ATTRIBUTE14             IN VARCHAR2,
      P_ATTRIBUTE15             IN VARCHAR2,
      P_CONTEXT                 IN VARCHAR2,
      P_OBJECT_VERSION_NUMBER   IN NUMBER,
      P_SECURITY_GROUP_ID	IN NUMBER)
IS

 -- Out local variables for the update / insert row procedures.
   lx_object_version_number  NUMBER := 0;

Line: 242

  UPDATE_ROW(P_RESTRICTION_ID => l_RESTRICTION_ID,
      	     P_RESTRICTION_TYPE => P_RESTRICTION_TYPE,
      	     P_CONDITION  => P_CONDITION,
      	     P_VALUE_OBJECT_ID 	=> P_VALUE_OBJECT_ID,
      	     P_VALUE_AMOUNT     => P_VALUE_AMOUNT,
      	     P_CURRENCY_CODE    => P_CURRENCY_CODE,
      	     P_START_DATE_ACTIVE => P_START_DATE_ACTIVE,
      	     P_END_DATE_ACTIVE 	=> P_END_DATE_ACTIVE,
      	     P_CREATION_DATE    => P_CREATION_DATE,
      	     P_CREATED_BY       => P_CREATED_BY,
      	     P_LAST_UPDATE_DATE => P_LAST_UPDATE_DATE,
      	     P_LAST_UPDATED_BY =>  P_LAST_UPDATED_BY,
      	     P_LAST_UPDATE_LOGIN => P_LAST_UPDATE_LOGIN,
      	     P_ATTRIBUTE1        => P_ATTRIBUTE1,
      	     P_ATTRIBUTE2        => P_ATTRIBUTE2,
      	     P_ATTRIBUTE3        => P_ATTRIBUTE3,
      	     P_ATTRIBUTE4        => P_ATTRIBUTE4,
      	     P_ATTRIBUTE5        => P_ATTRIBUTE5,
      	     P_ATTRIBUTE6        => P_ATTRIBUTE6,
      	     P_ATTRIBUTE7        => P_ATTRIBUTE7,
      	     P_ATTRIBUTE8        => P_ATTRIBUTE8,
      	     P_ATTRIBUTE9        => P_ATTRIBUTE9,
      	     P_ATTRIBUTE10        => P_ATTRIBUTE10,
      	     P_ATTRIBUTE11        => P_ATTRIBUTE11,
      	     P_ATTRIBUTE12        => P_ATTRIBUTE12,
      	     P_ATTRIBUTE13        => P_ATTRIBUTE13,
      	     P_ATTRIBUTE14        => P_ATTRIBUTE14,
      	     P_ATTRIBUTE15        => P_ATTRIBUTE15,
      	     P_CONTEXT            => P_CONTEXT,
      	     P_OBJECT_VERSION_NUMBER   => P_OBJECT_VERSION_NUMBER,
             P_SECURITY_GROUP_ID       => P_SECURITY_GROUP_ID);

Line: 277

  INSERT_ROW(PX_RESTRICTION_ID => l_RESTRICTION_ID,
      	     P_RESTRICTION_TYPE => P_RESTRICTION_TYPE,
      	     P_CONDITION  => P_CONDITION,
      	     P_VALUE_OBJECT_ID 	=> P_VALUE_OBJECT_ID,
      	     P_VALUE_AMOUNT     => P_VALUE_AMOUNT,
      	     P_CURRENCY_CODE    => P_CURRENCY_CODE,
      	     P_START_DATE_ACTIVE => P_START_DATE_ACTIVE,
      	     P_END_DATE_ACTIVE 	=> P_END_DATE_ACTIVE,
      	     P_CREATION_DATE    => P_CREATION_DATE,
      	     P_CREATED_BY       => P_CREATED_BY,
      	     P_LAST_UPDATE_DATE => P_LAST_UPDATE_DATE,
      	     P_LAST_UPDATED_BY =>  P_LAST_UPDATED_BY,
      	     P_LAST_UPDATE_LOGIN => P_LAST_UPDATE_LOGIN,
      	     P_ATTRIBUTE1        => P_ATTRIBUTE1,
      	     P_ATTRIBUTE2        => P_ATTRIBUTE2,
      	     P_ATTRIBUTE3        => P_ATTRIBUTE3,
      	     P_ATTRIBUTE4        => P_ATTRIBUTE4,
      	     P_ATTRIBUTE5        => P_ATTRIBUTE5,
      	     P_ATTRIBUTE6        => P_ATTRIBUTE6,
      	     P_ATTRIBUTE7        => P_ATTRIBUTE7,
      	     P_ATTRIBUTE8        => P_ATTRIBUTE8,
      	     P_ATTRIBUTE9        => P_ATTRIBUTE9,
      	     P_ATTRIBUTE10        => P_ATTRIBUTE10,
      	     P_ATTRIBUTE11        => P_ATTRIBUTE11,
      	     P_ATTRIBUTE12        => P_ATTRIBUTE12,
      	     P_ATTRIBUTE13        => P_ATTRIBUTE13,
      	     P_ATTRIBUTE14        => P_ATTRIBUTE14,
      	     P_ATTRIBUTE15        => P_ATTRIBUTE15,
      	     P_CONTEXT            => P_CONTEXT,
      	     P_OBJECT_VERSION_NUMBER   => P_OBJECT_VERSION_NUMBER,
      	     P_SECURITY_GROUP_ID   => P_SECURITY_GROUP_ID);