APPS.FV_BUDGET_DISTRIBUTION_HDR_PKG SQL Statements

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

Line: 5

PROCEDURE Insert_Row(X_ROWID 	              IN OUT NOCOPY VARCHAR2,
		     X_DISTRIBUTION_ID        NUMBER,
                     X_FUND_VALUE             VARCHAR2,
		     X_SET_OF_BOOKS_ID        NUMBER,
		     X_LAST_UPDATE_DATE       DATE,
		     X_LAST_UPDATED_BY        NUMBER,
		     X_CREATION_DATE          DATE,
		     X_CREATED_BY             NUMBER,
		     X_LAST_UPDATE_LOGIN      NUMBER,
		     X_ATTRIBUTE1             VARCHAR2,
		     X_ATTRIBUTE2             VARCHAR2,
		     X_ATTRIBUTE3             VARCHAR2,
		     X_ATTRIBUTE4             VARCHAR2,
		     X_ATTRIBUTE5             VARCHAR2,
		     X_ATTRIBUTE6             VARCHAR2,
		     X_ATTRIBUTE7             VARCHAR2,
		     X_ATTRIBUTE8             VARCHAR2,
		     X_ATTRIBUTE9             VARCHAR2,
		     X_ATTRIBUTE10            VARCHAR2,
		     X_ATTRIBUTE11            VARCHAR2,
		     X_ATTRIBUTE12            VARCHAR2,
		     X_ATTRIBUTE13            VARCHAR2,
		     X_ATTRIBUTE14            VARCHAR2,
		     X_ATTRIBUTE15            VARCHAR2,
		     X_ATTRIBUTE_CATEGORY     VARCHAR2,
		     X_ORG_ID                 NUMBER,
		     X_FACTS_PRGM_SEGMENT     VARCHAR2,
		     X_TREASURY_SYMBOL_ID     NUMBER
		    ) IS
  l_module_name VARCHAR2(200) := g_module_name || 'Insert_Row';

Line: 37

	CURSOR C IS SELECT ROWID FROM FV_BUDGET_DISTRIBUTION_HDR
		    WHERE DISTRIBUTION_ID = X_DISTRIBUTION_ID;

Line: 40

	INSERT INTO FV_BUDGET_DISTRIBUTION_HDR(
			DISTRIBUTION_ID,
			FUND_VALUE ,
			SET_OF_BOOKS_ID ,
			LAST_UPDATE_DATE,
			LAST_UPDATED_BY ,
			CREATION_DATE,
			CREATED_BY  ,
			LAST_UPDATE_LOGIN     ,
			ATTRIBUTE1   ,
			ATTRIBUTE2   ,
			ATTRIBUTE3   ,
			ATTRIBUTE4   ,
			ATTRIBUTE5   ,
			ATTRIBUTE6    ,
			ATTRIBUTE7   ,
			ATTRIBUTE8   ,
			ATTRIBUTE9   ,
			ATTRIBUTE10  ,
			ATTRIBUTE11   ,
			ATTRIBUTE12  ,
			ATTRIBUTE13  ,
			ATTRIBUTE14   ,
			ATTRIBUTE15   ,
			ATTRIBUTE_CATEGORY ,
			ORG_ID ,
			FACTS_PRGM_SEGMENT ,
			TREASURY_SYMBOL_ID     )
	VALUES(
			X_DISTRIBUTION_ID ,
			X_FUND_VALUE ,
			X_SET_OF_BOOKS_ID ,
			X_LAST_UPDATE_DATE ,
			X_LAST_UPDATED_BY ,
			X_CREATION_DATE ,
			X_CREATED_BY   ,
			X_LAST_UPDATE_LOGIN  ,
			X_ATTRIBUTE1 ,
			X_ATTRIBUTE2 ,
			X_ATTRIBUTE3 ,
			X_ATTRIBUTE4 ,
			X_ATTRIBUTE5  ,
			X_ATTRIBUTE6  ,
			X_ATTRIBUTE7  ,
			X_ATTRIBUTE8  ,
			X_ATTRIBUTE9  ,
			X_ATTRIBUTE10 ,
			X_ATTRIBUTE11 ,
			X_ATTRIBUTE12 ,
			X_ATTRIBUTE13 ,
			X_ATTRIBUTE14  ,
			X_ATTRIBUTE15  ,
			X_ATTRIBUTE_CATEGORY ,
			X_ORG_ID  ,
			X_FACTS_PRGM_SEGMENT ,
			X_TREASURY_SYMBOL_ID
			);

Line: 109

END Insert_Row;

Line: 111

PROCEDURE Update_Row(X_ROWID 	              VARCHAR2,
		     X_DISTRIBUTION_ID        NUMBER,
                     X_FUND_VALUE             VARCHAR2,
		     X_SET_OF_BOOKS_ID        NUMBER,
		     X_LAST_UPDATE_DATE       DATE,
		     X_LAST_UPDATED_BY        NUMBER,
		     X_CREATION_DATE          DATE,
		     X_CREATED_BY             NUMBER,
		     X_LAST_UPDATE_LOGIN      NUMBER,
		     X_ATTRIBUTE1             VARCHAR2,
		     X_ATTRIBUTE2             VARCHAR2,
		     X_ATTRIBUTE3             VARCHAR2,
		     X_ATTRIBUTE4             VARCHAR2,
		     X_ATTRIBUTE5             VARCHAR2,
		     X_ATTRIBUTE6             VARCHAR2,
		     X_ATTRIBUTE7             VARCHAR2,
		     X_ATTRIBUTE8             VARCHAR2,
		     X_ATTRIBUTE9             VARCHAR2,
		     X_ATTRIBUTE10            VARCHAR2,
		     X_ATTRIBUTE11            VARCHAR2,
		     X_ATTRIBUTE12            VARCHAR2,
		     X_ATTRIBUTE13            VARCHAR2,
		     X_ATTRIBUTE14            VARCHAR2,
		     X_ATTRIBUTE15            VARCHAR2,
		     X_ATTRIBUTE_CATEGORY     VARCHAR2,
		     X_ORG_ID                 NUMBER,
		     X_FACTS_PRGM_SEGMENT     VARCHAR2,
		     X_TREASURY_SYMBOL_ID     NUMBER
		    ) IS
  l_module_name VARCHAR2(200) := g_module_name || 'Update_Row';

Line: 143

 UPDATE FV_BUDGET_DISTRIBUTION_HDR
 SET
	                DISTRIBUTION_ID    =    X_DISTRIBUTION_ID,
			FUND_VALUE         =    X_FUND_VALUE,
			SET_OF_BOOKS_ID    =    X_SET_OF_BOOKS_ID,
			LAST_UPDATE_DATE   =    X_LAST_UPDATE_DATE,
			LAST_UPDATED_BY    =    X_LAST_UPDATED_BY,
			CREATION_DATE      =    X_CREATION_DATE,
			CREATED_BY         =    X_CREATED_BY ,
			LAST_UPDATE_LOGIN  =    X_LAST_UPDATE_LOGIN ,
			ATTRIBUTE1         =    X_ATTRIBUTE1 ,
			ATTRIBUTE2         =    X_ATTRIBUTE2,
			ATTRIBUTE3         =    X_ATTRIBUTE3,
			ATTRIBUTE4         =    X_ATTRIBUTE4 ,
			ATTRIBUTE5         =    X_ATTRIBUTE5 ,
			ATTRIBUTE6         =    X_ATTRIBUTE6 ,
			ATTRIBUTE7         =    X_ATTRIBUTE7 ,
			ATTRIBUTE8         =    X_ATTRIBUTE8 ,
			ATTRIBUTE9         =    X_ATTRIBUTE9 ,
			ATTRIBUTE10        =    X_ATTRIBUTE10 ,
			ATTRIBUTE11        =    X_ATTRIBUTE11 ,
			ATTRIBUTE12        =    X_ATTRIBUTE12 ,
			ATTRIBUTE13        =    X_ATTRIBUTE13 ,
			ATTRIBUTE14        =    X_ATTRIBUTE14 ,
			ATTRIBUTE15        =    X_ATTRIBUTE15,
			ATTRIBUTE_CATEGORY =    X_ATTRIBUTE_CATEGORY,
			ORG_ID             =    X_ORG_ID ,
			FACTS_PRGM_SEGMENT =    X_FACTS_PRGM_SEGMENT ,
			TREASURY_SYMBOL_ID =    X_TREASURY_SYMBOL_ID
 WHERE ROWID = X_ROWID;

Line: 182

 END Update_Row;

Line: 197

		SELECT  distribution_id,
		        fund_value,
		        set_of_books_id,
		        attribute_category,
		        org_id,
		        facts_prgm_segment,
		        treasury_symbol_id
		FROM  FV_BUDGET_DISTRIBUTION_HDR
		WHERE ROWID = X_ROWID
		for UPDATE OF DISTRIBUTION_ID NOWAIT;

Line: 214

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

Line: 249

PROCEDURE Delete_Row(X_ROWID VARCHAR2) IS
  l_module_name VARCHAR2(200) := g_module_name || 'Delete_Row';

Line: 256

	SELECT distribution_id
	INTO   x_distribution_id
	FROM   FV_BUDGET_DISTRIBUTION_HDR
	WHERE  rowid = x_rowid;

Line: 261

	SELECT fund_value
	INTO   x_fund_value
	FROM   FV_BUDGET_DISTRIBUTION_HDR
	WHERE  rowid = x_rowid;

Line: 272

/* Delete FV_BUDGET_DISTRIBUTION_DTL - Master - Detail -  Detail Record */
  DELETE FROM FV_BUDGET_DISTRIBUTION_DTL
  WHERE fund_value IN
		(SELECT fund_value
		 FROM   FV_BUDGET_DISTRIBUTION_HDR
		 WHERE  fund_value = x_fund_value);

Line: 283

/* Delete FV_BUDGET_DISTRIBUTION_HDR - Master Record */
  DELETE FROM FV_BUDGET_DISTRIBUTION_HDR
  WHERE DISTRIBUTION_ID = X_DISTRIBUTION_ID ;

Line: 295

END DELETE_ROW;