APPS.PSA_TRX_TYPES_ALL_PKG dependencies on PSA_TRX_TYPES_ALL

Line 1: package body PSA_TRX_TYPES_ALL_PKG AS

1: package body PSA_TRX_TYPES_ALL_PKG AS
2: /* $Header: PSAMFTTB.pls 120.5 2006/09/13 13:57:31 agovil ship $ */
3:
4: --===========================FND_LOG.START=====================================
5: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 11: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFTTB.PSA_TRX_TYPES_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.PSAMFTTB.PSA_TRX_TYPES_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_TRX_TYPES_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_TRX_TYPES_ALL
36: where PSA_TRX_TYPE_ID = X_PSA_TRX_TYPE_ID;
37: X_LAST_UPDATE_DATE DATE;
38: X_LAST_UPDATED_BY NUMBER;
39: X_LAST_UPDATE_LOGIN NUMBER;

Line 43: FROM psa_trx_types_all

39: X_LAST_UPDATE_LOGIN NUMBER;
40:
41: CURSOR c_check_dup(l_trx_type_id NUMBER) IS
42: SELECT 'Exist'
43: FROM psa_trx_types_all
44: WHERE psa_trx_type_id = l_trx_type_id;
45: l_exist VARCHAR2(60);
46: -- ========================= FND LOG ===========================
47: l_full_path VARCHAR2(100) := g_path || 'INSERT_ROW';

Line 90: insert into PSA_TRX_TYPES_ALL (

86: IF (c_check_dup%ISOPEN) THEN
87: CLOSE c_check_dup;
88: END IF;
89:
90: insert into PSA_TRX_TYPES_ALL (
91: PSA_TRX_TYPE_ID,
92: ATTRIBUTE_CATEGORY,
93: ATTRIBUTE1,
94: ATTRIBUTE2,

Line 184: from PSA_TRX_TYPES_ALL

180: ATTRIBUTE12,
181: ATTRIBUTE13,
182: ATTRIBUTE14,
183: ATTRIBUTE15
184: from PSA_TRX_TYPES_ALL
185: where PSA_TRX_TYPE_ID = X_PSA_TRX_TYPE_ID
186: for update of PSA_TRX_TYPE_ID nowait;
187: tlinfo c1%rowtype;
188: -- ========================= FND LOG ===========================

Line 313: update PSA_TRX_TYPES_ALL set

309: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
310: -- ========================= FND LOG ===========================
311: app_exception.raise_exception;
312: end if;
313: update PSA_TRX_TYPES_ALL set
314: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
315: ATTRIBUTE1 = X_ATTRIBUTE1,
316: ATTRIBUTE2 = X_ATTRIBUTE2,
317: ATTRIBUTE3 = X_ATTRIBUTE3,

Line 357: delete from PSA_TRX_TYPES_ALL

353: begin
354: open c2;
355: fetch c2 into num;
356: if (c2%notfound) then
357: delete from PSA_TRX_TYPES_ALL
358: where PSA_TRX_TYPE_ID = X_PSA_TRX_TYPE_ID;
359:
360: else
361:

Line 374: end PSA_TRX_TYPES_ALL_PKG;

370: end if;
371: close c2;
372: end DELETE_ROW;
373:
374: end PSA_TRX_TYPES_ALL_PKG;