APPS.PSA_MFAR_TRANSACTION_COVER_PKG SQL Statements

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

Line: 14

PROCEDURE INSERT_ROW (	X_ROWID 			IN OUT NOCOPY VARCHAR2,
			X_CUST_TRX_LINE_GL_DIST_ID 	IN NUMBER,
			X_RECEIVABLES_CCID 		IN NUMBER,
			X_PREV_MF_RECEIVABLES_CCID	IN NUMBER,
			X_ATTRIBUTE_CATEGORY            IN VARCHAR2,
			X_ATTRIBUTE1			IN VARCHAR2,
			X_ATTRIBUTE2			IN VARCHAR2,
			X_ATTRIBUTE3			IN VARCHAR2,
			X_ATTRIBUTE4			IN VARCHAR2,
			X_ATTRIBUTE5			IN VARCHAR2,
			X_ATTRIBUTE6			IN VARCHAR2,
			X_ATTRIBUTE7			IN VARCHAR2,
			X_ATTRIBUTE8			IN VARCHAR2,
			X_ATTRIBUTE9			IN VARCHAR2,
			X_ATTRIBUTE10			IN VARCHAR2,
			X_ATTRIBUTE11			IN VARCHAR2,
			X_ATTRIBUTE12			IN VARCHAR2,
			X_ATTRIBUTE13			IN VARCHAR2,
			X_ATTRIBUTE14			IN VARCHAR2,
			X_ATTRIBUTE15			IN VARCHAR2,
			X_MODE 				IN VARCHAR2
         ) IS

    cursor C is select ROWID from PSA_MF_TRX_DIST_ALL
      where CUST_TRX_LINE_GL_DIST_ID = X_CUST_TRX_LINE_GL_DIST_ID;

Line: 40

    X_LAST_UPDATE_DATE DATE;

Line: 41

    X_LAST_UPDATED_BY NUMBER;

Line: 42

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 44

    l_full_path VARCHAR2(100) := g_path || 'INSERT_ROW';

Line: 47

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 49

    X_LAST_UPDATED_BY := 1;

Line: 50

    X_LAST_UPDATE_LOGIN := 0;

Line: 52

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 53

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 56

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 57

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 68

  insert into PSA_MF_TRX_DIST_ALL( CUST_TRX_LINE_GL_DIST_ID,
				   MF_RECEIVABLES_CCID,
				   CREATION_DATE,
				   CREATED_BY,
				   LAST_UPDATE_DATE,
				   LAST_UPDATED_BY,
				   LAST_UPDATE_LOGIN,
				   PREV_MF_RECEIVABLES_CCID,
				   ATTRIBUTE_CATEGORY,
				   ATTRIBUTE1,
				   ATTRIBUTE2,
				   ATTRIBUTE3,
				   ATTRIBUTE4,
				   ATTRIBUTE5,
				   ATTRIBUTE6,
				   ATTRIBUTE7,
				   ATTRIBUTE8,
				   ATTRIBUTE9,
				   ATTRIBUTE10,
				   ATTRIBUTE11,
				   ATTRIBUTE12,
				   ATTRIBUTE13,
				   ATTRIBUTE14,
				   ATTRIBUTE15
				 ) values
				 ( X_CUST_TRX_LINE_GL_DIST_ID,
				   X_RECEIVABLES_CCID,
				   X_LAST_UPDATE_DATE,
				   X_LAST_UPDATED_BY,
				   X_LAST_UPDATE_DATE,
    				   X_LAST_UPDATED_BY,
				   X_LAST_UPDATE_LOGIN,
				   X_PREV_MF_RECEIVABLES_CCID,
				   X_ATTRIBUTE_CATEGORY,
				   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
				 );

Line: 127

END INSERT_ROW;

Line: 132

  cursor c1 is select
      MF_RECEIVABLES_CCID
    from PSA_MF_TRX_DIST_ALL
    where CUST_TRX_LINE_GL_DIST_ID = X_CUST_TRX_LINE_GL_DIST_ID
    for update of CUST_TRX_LINE_GL_DIST_ID nowait;

Line: 170

PROCEDURE UPDATE_ROW (  X_CUST_TRX_LINE_GL_DIST_ID 	in NUMBER,
			X_RECEIVABLES_CCID 		in NUMBER,
			X_PREV_MF_RECEIVABLES_CCID	IN NUMBER,
			X_ATTRIBUTE_CATEGORY            IN VARCHAR2,
			X_ATTRIBUTE1			IN VARCHAR2,
			X_ATTRIBUTE2			IN VARCHAR2,
			X_ATTRIBUTE3			IN VARCHAR2,
			X_ATTRIBUTE4			IN VARCHAR2,
			X_ATTRIBUTE5			IN VARCHAR2,
			X_ATTRIBUTE6			IN VARCHAR2,
			X_ATTRIBUTE7			IN VARCHAR2,
			X_ATTRIBUTE8			IN VARCHAR2,
			X_ATTRIBUTE9			IN VARCHAR2,
			X_ATTRIBUTE10			IN VARCHAR2,
			X_ATTRIBUTE11			IN VARCHAR2,
			X_ATTRIBUTE12			IN VARCHAR2,
			X_ATTRIBUTE13			IN VARCHAR2,
			X_ATTRIBUTE14			IN VARCHAR2,
			X_ATTRIBUTE15			IN VARCHAR2,
			X_MODE 				in VARCHAR2) is

    X_LAST_UPDATE_DATE DATE;

Line: 192

    X_LAST_UPDATED_BY NUMBER;

Line: 193

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 195

    l_full_path VARCHAR2(100) := g_path || 'UPDATE_ROW';

Line: 198

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 200

    X_LAST_UPDATED_BY := 1;

Line: 201

    X_LAST_UPDATE_LOGIN := 0;

Line: 203

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 204

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 207

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 208

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 219

  update PSA_MF_TRX_DIST_ALL set
    MF_RECEIVABLES_CCID 	 = X_RECEIVABLES_CCID,
    LAST_UPDATE_DATE 		 = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY 		 = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN 		 = X_LAST_UPDATE_LOGIN,
    PREV_MF_RECEIVABLES_CCID     = X_PREV_MF_RECEIVABLES_CCID,
    ATTRIBUTE_CATEGORY 		= X_ATTRIBUTE_CATEGORY,
    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
  where CUST_TRX_LINE_GL_DIST_ID = X_CUST_TRX_LINE_GL_DIST_ID;

Line: 246

end UPDATE_ROW;

Line: 248

PROCEDURE  DELETE_ROW (X_CUST_TRX_LINE_GL_DIST_ID IN NUMBER ) is
begin
  delete from PSA_MF_TRX_DIST_ALL
  where CUST_TRX_LINE_GL_DIST_ID = X_CUST_TRX_LINE_GL_DIST_ID;

Line: 255

END DELETE_ROW;