APPS.PSA_RECEIVABLES_TRX_ALL_PKG dependencies on PSA_RECEIVABLES_TRX_ALL

Line 1: package body PSA_RECEIVABLES_TRX_ALL_PKG AS

1: package body PSA_RECEIVABLES_TRX_ALL_PKG AS
2: /* $Header: PSAMFRXB.pls 120.5 2006/09/13 13:48:30 agovil ship $ */
3:
4: --===========================FND_LOG.START=====================================
5: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 11: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFRXB.PSA_RECEIVABLES_TRX_ALL_PKG.';

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

Line 35: cursor C is select ROWID from PSA_RECEIVABLES_TRX_ALL

31: X_ATTRIBUTE14 in VARCHAR2,
32: X_ATTRIBUTE15 in VARCHAR2,
33: X_MODE in VARCHAR2
34: ) is
35: cursor C is select ROWID from PSA_RECEIVABLES_TRX_ALL
36: where PSA_RECEIVABLES_TRX_ID = X_PSA_RECEIVABLES_TRX_ID;
37: X_LAST_UPDATE_DATE DATE;
38: X_LAST_UPDATED_BY NUMBER;
39: X_LAST_UPDATE_LOGIN NUMBER;

Line 64: insert into PSA_RECEIVABLES_TRX_ALL (

60: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
61: -- ========================= FND LOG ===========================
62: app_exception.raise_exception;
63: end if;
64: insert into PSA_RECEIVABLES_TRX_ALL (
65: PSA_RECEIVABLES_TRX_ID,
66: ATTRIBUTE_CATEGORY,
67: ATTRIBUTE1,
68: ATTRIBUTE2,

Line 158: from PSA_RECEIVABLES_TRX_ALL

154: ATTRIBUTE12,
155: ATTRIBUTE13,
156: ATTRIBUTE14,
157: ATTRIBUTE15
158: from PSA_RECEIVABLES_TRX_ALL
159: where PSA_RECEIVABLES_TRX_ID = X_PSA_RECEIVABLES_TRX_ID
160: for update of PSA_RECEIVABLES_TRX_ID nowait;
161: tlinfo c1%rowtype;
162: -- ========================= FND LOG ===========================

Line 286: update PSA_RECEIVABLES_TRX_ALL set

282: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
283: -- ========================= FND LOG ===========================
284: app_exception.raise_exception;
285: end if;
286: update PSA_RECEIVABLES_TRX_ALL set
287: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
288: ATTRIBUTE1 = X_ATTRIBUTE1,
289: ATTRIBUTE2 = X_ATTRIBUTE2,
290: ATTRIBUTE3 = X_ATTRIBUTE3,

Line 334: cursor c1 is select rowid from PSA_RECEIVABLES_TRX_ALL

330: X_ATTRIBUTE14 in VARCHAR2,
331: X_ATTRIBUTE15 in VARCHAR2,
332: X_MODE in VARCHAR2
333: ) is
334: cursor c1 is select rowid from PSA_RECEIVABLES_TRX_ALL
335: where PSA_RECEIVABLES_TRX_ID = X_PSA_RECEIVABLES_TRX_ID
336: ;
337: dummy c1%rowtype;
338: begin

Line 391: delete from PSA_RECEIVABLES_TRX_ALL

387: procedure DELETE_ROW (
388: X_PSA_RECEIVABLES_TRX_ID in NUMBER
389: ) is
390: begin
391: delete from PSA_RECEIVABLES_TRX_ALL
392: where PSA_RECEIVABLES_TRX_ID = X_PSA_RECEIVABLES_TRX_ID;
393: if (sql%notfound) then
394: raise no_data_found;
395: end if;

Line 398: end PSA_RECEIVABLES_TRX_ALL_PKG;

394: raise no_data_found;
395: end if;
396: end DELETE_ROW;
397:
398: end PSA_RECEIVABLES_TRX_ALL_PKG;