APPS.PSA_MF_ACCOUNT_MAPPING_ALL_PKG dependencies on PSA_MF_ACCOUNT_MAPPING_ALL

Line 1: package body PSA_MF_ACCOUNT_MAPPING_ALL_PKG AS

1: package body PSA_MF_ACCOUNT_MAPPING_ALL_PKG AS
2: /* $Header: PSAMFAMB.pls 120.5 2006/09/13 12:26:08 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.PSAMFAMB.PSA_MF_ACCOUNT_MAPPING_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.PSAMFAMB.PSA_MF_ACCOUNT_MAPPING_ALL_PKG.';
11: --===========================FND_LOG.END=======================================
12:
13: procedure INSERT_ROW (
14: X_ROWID in out NOCOPY VARCHAR2,

Line 39: cursor C is select ROWID from PSA_MF_ACCOUNT_MAPPING_ALL

35: X_ATTRIBUTE5 in VARCHAR2,
36: X_ATTRIBUTE6 in VARCHAR2,
37: X_MODE in VARCHAR2
38: ) is
39: cursor C is select ROWID from PSA_MF_ACCOUNT_MAPPING_ALL
40: where PSA_MF_ACCT_MAP_ID = X_PSA_MF_ACCT_MAP_ID;
41: X_LAST_UPDATE_DATE DATE;
42: X_LAST_UPDATED_BY NUMBER;
43: X_LAST_UPDATE_LOGIN NUMBER;

Line 68: insert into PSA_MF_ACCOUNT_MAPPING_ALL (

64: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
65: -- ========================= FND LOG ===========================
66: app_exception.raise_exception;
67: end if;
68: insert into PSA_MF_ACCOUNT_MAPPING_ALL (
69: ATTRIBUTE7,
70: ATTRIBUTE8,
71: ATTRIBUTE9,
72: ATTRIBUTE10,

Line 182: from PSA_MF_ACCOUNT_MAPPING_ALL

178: ATTRIBUTE3,
179: ATTRIBUTE4,
180: ATTRIBUTE5,
181: ATTRIBUTE6
182: from PSA_MF_ACCOUNT_MAPPING_ALL
183: where PSA_MF_ACCT_MAP_ID = X_PSA_MF_ACCT_MAP_ID
184: for update of PSA_MF_ACCT_MAP_ID nowait;
185: tlinfo c1%rowtype;
186: -- ========================= FND LOG ===========================

Line 323: update PSA_MF_ACCOUNT_MAPPING_ALL set

319: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
320: -- ========================= FND LOG ===========================
321: app_exception.raise_exception;
322: end if;
323: update PSA_MF_ACCOUNT_MAPPING_ALL set
324: ATTRIBUTE7 = X_ATTRIBUTE7,
325: ATTRIBUTE8 = X_ATTRIBUTE8,
326: ATTRIBUTE9 = X_ATTRIBUTE9,
327: ATTRIBUTE10 = X_ATTRIBUTE10,

Line 381: cursor c1 is select rowid from PSA_MF_ACCOUNT_MAPPING_ALL

377: X_ATTRIBUTE5 in VARCHAR2,
378: X_ATTRIBUTE6 in VARCHAR2,
379: X_MODE in VARCHAR2
380: ) is
381: cursor c1 is select rowid from PSA_MF_ACCOUNT_MAPPING_ALL
382: where PSA_MF_ACCT_MAP_ID = X_PSA_MF_ACCT_MAP_ID
383: ;
384: dummy c1%rowtype;
385: begin

Line 448: delete from PSA_MF_ACCOUNT_MAPPING_ALL

444: procedure DELETE_ROW (
445: X_PSA_MF_ACCT_MAP_ID in NUMBER
446: ) is
447: begin
448: delete from PSA_MF_ACCOUNT_MAPPING_ALL
449: where PSA_MF_ACCT_MAP_ID = X_PSA_MF_ACCT_MAP_ID;
450: if (sql%notfound) then
451: raise no_data_found;
452: end if;

Line 455: end PSA_MF_ACCOUNT_MAPPING_ALL_PKG;

451: raise no_data_found;
452: end if;
453: end DELETE_ROW;
454:
455: end PSA_MF_ACCOUNT_MAPPING_ALL_PKG;