APPS.PSA_MFAR_ADJUSTMENT_COVER_PKG dependencies on PSA_MF_ADJ_DIST_ALL

Line 15: From PSA_MF_ADJ_DIST_ALL

11: X_COMMENTS IN VARCHAR2,
12: X_MODE IN VARCHAR2 DEFAULT 'R' ) IS
13:
14: Cursor C Is Select ROWID
15: From PSA_MF_ADJ_DIST_ALL
16: Where ADJUSTMENT_ID = X_ADJUSTMENT_ID
17: And CUST_TRX_LINE_GL_DIST_ID = X_CUST_TRX_LINE_GL_DIST_ID;
18:
19: X_LAST_UPDATE_DATE DATE;

Line 44: Insert into PSA_MF_ADJ_DIST_ALL( ADJUSTMENT_ID,

40: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
41: app_exception.raise_exception;
42: end if;
43:
44: Insert into PSA_MF_ADJ_DIST_ALL( ADJUSTMENT_ID,
45: CUST_TRX_LINE_GL_DIST_ID,
46: MF_ADJUSTMENT_CCID,
47: AMOUNT,
48: PERCENT,

Line 92: From PSA_MF_ADJ_DIST_ALL

88: AMOUNT,
89: PERCENT,
90: PREV_CUST_TRX_LINE_ID,
91: COMMENTS
92: From PSA_MF_ADJ_DIST_ALL
93: Where ADJUSTMENT_ID = X_ADJUSTMENT_ID
94: And CUST_TRX_LINE_GL_DIST_ID = X_CUST_TRX_LINE_GL_DIST_ID
95: FOR UPDATE OF ADJUSTMENT_ID NOWAIT;
96:

Line 160: UPDATE PSA_MF_ADJ_DIST_ALL set

156: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
157: app_exception.raise_exception;
158: end if;
159:
160: UPDATE PSA_MF_ADJ_DIST_ALL set
161: MF_ADJUSTMENT_CCID = X_MF_ADJUSTMENT_CCID,
162: AMOUNT = X_AMOUNT,
163: PERCENT = X_PERCENT,
164: PREV_CUST_TRX_LINE_ID = X_PREV_CUST_TRX_LINE_ID,

Line 188: from PSA_MF_ADJ_DIST_ALL

184: X_COMMENTS IN VARCHAR2,
185: X_MODE IN VARCHAR2 default 'R') IS
186:
187: cursor c1 is select rowid
188: from PSA_MF_ADJ_DIST_ALL
189: where ADJUSTMENT_ID = X_ADJUSTMENT_ID
190: and CUST_TRX_LINE_GL_DIST_ID = X_CUST_TRX_LINE_GL_DIST_ID;
191:
192: dummy c1%rowtype;

Line 225: DELETE FROM PSA_MF_ADJ_DIST_ALL

221: PROCEDURE DELETE_ROW ( X_ADJUSTMENT_ID IN NUMBER,
222: X_CUST_TRX_LINE_GL_DIST_ID IN NUMBER ) IS
223: BEGIN
224:
225: DELETE FROM PSA_MF_ADJ_DIST_ALL
226: WHERE ADJUSTMENT_ID = X_ADJUSTMENT_ID
227: AND CUST_TRX_LINE_GL_DIST_ID = X_CUST_TRX_LINE_GL_DIST_ID;
228:
229: if (sql%notfound) then