APPS.PSA_MF_TRX_DIST_ALL_PKG dependencies on PSA_MF_TRX_DIST_ALL

Line 1: package body PSA_MF_TRX_DIST_ALL_PKG AS

1: package body PSA_MF_TRX_DIST_ALL_PKG AS
2: /* $Header: PSAMFTDB.pls 120.5 2006/09/13 13:51:32 agovil ship $ */
3: --===========================FND_LOG.START=====================================
4: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
5: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 10: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFTDB.PSA_MF_TRX_DIST_ALL_PKG.';

6: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
7: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
9: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFTDB.PSA_MF_TRX_DIST_ALL_PKG.';
11: --===========================FND_LOG.END=======================================
12:
13: procedure INSERT_ROW (
14: X_ROWID in out NOCOPY VARCHAR2,

Line 37: cursor C is select ROWID from PSA_MF_TRX_DIST_ALL

33: X_ATTRIBUTE14 in VARCHAR2,
34: X_ATTRIBUTE15 in VARCHAR2,
35: X_MODE in VARCHAR2
36: ) is
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: X_LAST_UPDATE_DATE DATE;
40: X_LAST_UPDATED_BY NUMBER;
41: X_LAST_UPDATE_LOGIN NUMBER;

Line 66: insert into PSA_MF_TRX_DIST_ALL (

62: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
63: -- ========================= FND LOG ===========================
64: app_exception.raise_exception;
65: end if;
66: insert into PSA_MF_TRX_DIST_ALL (
67: CUST_TRX_LINE_GL_DIST_ID,
68: MF_RECEIVABLES_CCID,
69: POSTING_CONTROL_ID,
70: PREV_MF_RECEIVABLES_CCID,

Line 172: from PSA_MF_TRX_DIST_ALL

168: ATTRIBUTE12,
169: ATTRIBUTE13,
170: ATTRIBUTE14,
171: ATTRIBUTE15
172: from PSA_MF_TRX_DIST_ALL
173: where CUST_TRX_LINE_GL_DIST_ID = X_CUST_TRX_LINE_GL_DIST_ID
174: for update of CUST_TRX_LINE_GL_DIST_ID nowait;
175: tlinfo c1%rowtype;
176: -- ========================= FND LOG ===========================

Line 310: update PSA_MF_TRX_DIST_ALL set

306: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
307: -- ========================= FND LOG ===========================
308: app_exception.raise_exception;
309: end if;
310: update PSA_MF_TRX_DIST_ALL set
311: MF_RECEIVABLES_CCID = X_MF_RECEIVABLES_CCID,
312: POSTING_CONTROL_ID = X_POSTING_CONTROL_ID,
313: PREV_MF_RECEIVABLES_CCID = X_PREV_MF_RECEIVABLES_CCID,
314: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,

Line 364: cursor c1 is select rowid from PSA_MF_TRX_DIST_ALL

360: X_ATTRIBUTE14 in VARCHAR2,
361: X_ATTRIBUTE15 in VARCHAR2,
362: X_MODE in VARCHAR2
363: ) is
364: cursor c1 is select rowid from PSA_MF_TRX_DIST_ALL
365: where CUST_TRX_LINE_GL_DIST_ID = X_CUST_TRX_LINE_GL_DIST_ID
366: ;
367: dummy c1%rowtype;
368: begin

Line 427: delete from PSA_MF_TRX_DIST_ALL

423: procedure DELETE_ROW (
424: X_CUST_TRX_LINE_GL_DIST_ID in NUMBER
425: ) is
426: begin
427: delete from PSA_MF_TRX_DIST_ALL
428: where CUST_TRX_LINE_GL_DIST_ID = X_CUST_TRX_LINE_GL_DIST_ID;
429: if (sql%notfound) then
430: raise no_data_found;
431: end if;

Line 434: end PSA_MF_TRX_DIST_ALL_PKG;

430: raise no_data_found;
431: end if;
432: end DELETE_ROW;
433:
434: end PSA_MF_TRX_DIST_ALL_PKG;