APPS.CE_CASHFLOWS_PKG dependencies on CE_CASHFLOWS

Line 1: PACKAGE BODY CE_CASHFLOWS_PKG as

1: PACKAGE BODY CE_CASHFLOWS_PKG as
2: /* $Header: cebtcthb.pls 120.0 2005/07/26 08:44:47 jikumar noship $ */
3:
4:
5:

Line 63: CURSOR C IS SELECT CE_CASHFLOWS_S.NEXTVAL FROM DUAL;

59: X_LAST_UPDATE_DATE DATE,
60: X_LAST_UPDATE_LOGIN NUMBER
61: ) IS
62:
63: CURSOR C IS SELECT CE_CASHFLOWS_S.NEXTVAL FROM DUAL;
64:
65: CURSOR C1 IS SELECT ROWID FROM CE_CASHFLOWS
66: WHERE CASHFLOW_ID = X_CASHFLOW_ID;
67: BEGIN

Line 65: CURSOR C1 IS SELECT ROWID FROM CE_CASHFLOWS

61: ) IS
62:
63: CURSOR C IS SELECT CE_CASHFLOWS_S.NEXTVAL FROM DUAL;
64:
65: CURSOR C1 IS SELECT ROWID FROM CE_CASHFLOWS
66: WHERE CASHFLOW_ID = X_CASHFLOW_ID;
67: BEGIN
68: IF ( X_CASHFLOW_ID ) IS NULL THEN
69: OPEN C;

Line 73: INSERT INTO CE_CASHFLOWS (

69: OPEN C;
70: FETCH C INTO X_CASHFLOW_ID;
71: CLOSE C;
72: END IF;
73: INSERT INTO CE_CASHFLOWS (
74: CASHFLOW_ID,
75: CASHFLOW_LEDGER_ID,
76: CASHFLOW_LEGAL_ENTITY_ID,
77: CASHFLOW_BANK_ACCOUNT_ID,

Line 209: UPDATE CE_CASHFLOWS

205: X_LAST_UPDATE_DATE DATE,
206: X_LAST_UPDATE_LOGIN NUMBER,
207: X_OBJECT_VERSION_NUMBER NUMBER ) IS
208: BEGIN
209: UPDATE CE_CASHFLOWS
210: SET
211: CASHFLOW_ID = X_CASHFLOW_ID,
212: CASHFLOW_LEDGER_ID = X_CASHFLOW_LEDGER_ID,
213: CASHFLOW_LEGAL_ENTITY_ID = X_CASHFLOW_LEGAL_ENTITY_ID,

Line 263: DELETE FROM CE_CASHFLOWS

259:
260: PROCEDURE Delete_Row( X_Row_id VARCHAR2 ) IS
261: BEGIN
262:
263: DELETE FROM CE_CASHFLOWS
264: WHERE rowid = X_Row_Id;
265:
266: IF (SQL%NOTFOUND) THEN
267: Raise NO_DATA_FOUND;

Line 273: END CE_CASHFLOWS_PKG;

269:
270: END Delete_Row;
271:
272:
273: END CE_CASHFLOWS_PKG;