APPS.PSA_MF_MISC_DIST_ALL_PKG dependencies on PSA_MF_MISC_DIST_ALL

Line 1: package body PSA_MF_MISC_DIST_ALL_PKG as

1: package body PSA_MF_MISC_DIST_ALL_PKG as
2: /* $Header: PSAMFMTB.pls 120.6 2006/09/13 13:34:22 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.PSAMFMTB.PSA_MF_MISC_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.PSAMFMTB.PSA_MF_MISC_DIST_ALL_PKG.';
11: --===========================FND_LOG.END=======================================
12:
13: procedure INSERT_ROW (
14: X_ROWID in out NOCOPY VARCHAR2,

Line 46: cursor C is select ROWID from PSA_MF_MISC_DIST_ALL

42: X_REFERENCE5 in VARCHAR2,
43: x_reversal_ccid IN NUMBER,
44: X_MODE in VARCHAR2
45: ) is
46: cursor C is select ROWID from PSA_MF_MISC_DIST_ALL
47: where MISC_MF_CASH_DIST_ID = X_MISC_MF_CASH_DIST_ID;
48: X_LAST_UPDATE_DATE DATE;
49: X_LAST_UPDATED_BY NUMBER;
50: X_LAST_UPDATE_LOGIN NUMBER;

Line 75: insert into PSA_MF_MISC_DIST_ALL (

71: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
72: -- ========================= FND LOG ===========================
73: app_exception.raise_exception;
74: end if;
75: insert into PSA_MF_MISC_DIST_ALL (
76: MISC_MF_CASH_DIST_ID,
77: MISC_CASH_DISTRIBUTION_ID,
78: DISTRIBUTION_CCID,
79: CASH_CCID,

Line 217: from PSA_MF_MISC_DIST_ALL

213: REFERENCE3,
214: REFERENCE4,
215: reference5,
216: reversal_ccid
217: from PSA_MF_MISC_DIST_ALL
218: where MISC_MF_CASH_DIST_ID = x_misc_mf_cash_dist_id
219: AND reference1 = x_reference1
220: for update of MISC_MF_CASH_DIST_ID nowait;
221: tlinfo c1%rowtype;

Line 388: update PSA_MF_MISC_DIST_ALL set

384: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
385: -- ========================= FND LOG ===========================
386: app_exception.raise_exception;
387: end if;
388: update PSA_MF_MISC_DIST_ALL set
389: MISC_CASH_DISTRIBUTION_ID = X_MISC_CASH_DISTRIBUTION_ID,
390: DISTRIBUTION_CCID = X_DISTRIBUTION_CCID,
391: CASH_CCID = X_CASH_CCID,
392: COMMENTS = X_COMMENTS,

Line 461: cursor c1 is select rowid from PSA_MF_MISC_DIST_ALL

457: X_REFERENCE5 in VARCHAR2,
458: x_reversal_ccid IN NUMBER,
459: X_MODE in VARCHAR2
460: ) is
461: cursor c1 is select rowid from PSA_MF_MISC_DIST_ALL
462: where MISC_MF_CASH_DIST_ID = X_MISC_MF_CASH_DIST_ID
463: ;
464: dummy c1%rowtype;
465: begin

Line 544: delete from PSA_MF_MISC_DIST_ALL

540: x_reference1 IN varchar2
541:
542: ) is
543: begin
544: delete from PSA_MF_MISC_DIST_ALL
545: where MISC_MF_CASH_DIST_ID = x_misc_mf_cash_dist_id AND
546: Nvl(reference5,'CLEARED') = x_reference1;
547: if (sql%notfound) then
548: raise no_data_found;

Line 552: end PSA_MF_MISC_DIST_ALL_PKG;

548: raise no_data_found;
549: end if;
550: end DELETE_ROW;
551:
552: end PSA_MF_MISC_DIST_ALL_PKG;