APPS.PSA_MFAR_TRANSACTION_COVER_PKG dependencies on PSA_MF_TRX_DIST_ALL

Line 37: cursor C is select ROWID from PSA_MF_TRX_DIST_ALL

33: X_ATTRIBUTE15 IN VARCHAR2,
34: X_MODE IN VARCHAR2
35: ) IS
36:
37: cursor C is select ROWID from PSA_MF_TRX_DIST_ALL
38: where CUST_TRX_LINE_GL_DIST_ID = X_CUST_TRX_LINE_GL_DIST_ID;
39:
40: X_LAST_UPDATE_DATE DATE;
41: X_LAST_UPDATED_BY NUMBER;

Line 68: insert into PSA_MF_TRX_DIST_ALL( CUST_TRX_LINE_GL_DIST_ID,

64: -- ========================= FND LOG ===========================
65: app_exception.raise_exception;
66: end if;
67:
68: insert into PSA_MF_TRX_DIST_ALL( CUST_TRX_LINE_GL_DIST_ID,
69: MF_RECEIVABLES_CCID,
70: CREATION_DATE,
71: CREATED_BY,
72: LAST_UPDATE_DATE,

Line 134: from PSA_MF_TRX_DIST_ALL

130: X_RECEIVABLES_CCID IN NUMBER) IS
131:
132: cursor c1 is select
133: MF_RECEIVABLES_CCID
134: from PSA_MF_TRX_DIST_ALL
135: where CUST_TRX_LINE_GL_DIST_ID = X_CUST_TRX_LINE_GL_DIST_ID
136: for update of CUST_TRX_LINE_GL_DIST_ID nowait;
137:
138: tlinfo c1%rowtype;

Line 219: update PSA_MF_TRX_DIST_ALL set

215: -- ========================= FND LOG ===========================
216: app_exception.raise_exception;
217: end if;
218:
219: update PSA_MF_TRX_DIST_ALL set
220: MF_RECEIVABLES_CCID = X_RECEIVABLES_CCID,
221: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
222: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
223: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 250: delete from PSA_MF_TRX_DIST_ALL

246: end UPDATE_ROW;
247:
248: PROCEDURE DELETE_ROW (X_CUST_TRX_LINE_GL_DIST_ID IN NUMBER ) is
249: begin
250: delete from PSA_MF_TRX_DIST_ALL
251: where CUST_TRX_LINE_GL_DIST_ID = X_CUST_TRX_LINE_GL_DIST_ID;
252: if (sql%notfound) then
253: raise no_data_found;
254: end if;