APPS.CE_CASHFLOW_HIST_PKG dependencies on CE_CASHFLOW_ACCT_H

Line 23: UPDATE CE_CASHFLOW_ACCT_H

19:
20:
21: PROCEDURE update_current_record_flag(p_cashflow number) IS
22: BEGIN
23: UPDATE CE_CASHFLOW_ACCT_H
24: SET CURRENT_RECORD_FLAG = 'N'
25: WHERE cashflow_id = p_cashflow;
26:
27: EXCEPTION

Line 62: CURSOR C IS SELECT ROWID FROM CE_CASHFLOW_ACCT_H

58: X_LAST_UPDATE_LOGIN NUMBER
59: ) IS
60:
61:
62: CURSOR C IS SELECT ROWID FROM CE_CASHFLOW_ACCT_H
63: WHERE EVENT_ID = X_EVENT_ID;
64:
65: BEGIN
66: -- update the current record flag to N for all the respective cashflows

Line 69: INSERT INTO CE_CASHFLOW_ACCT_H

65: BEGIN
66: -- update the current record flag to N for all the respective cashflows
67: update_current_record_flag(X_CASHFLOW_ID);
68:
69: INSERT INTO CE_CASHFLOW_ACCT_H
70: ( CASHFLOW_ID,
71: EVENT_ID,
72: EVENT_TYPE,
73: ACCOUNTING_DATE,

Line 151: UPDATE CE_CASHFLOW_ACCT_H

147: X_LAST_UPDATE_LOGIN NUMBER,
148: X_OBJECT_VERSION_NUMBER NUMBER ) IS
149: BEGIN
150:
151: UPDATE CE_CASHFLOW_ACCT_H
152: SET
153: CASHFLOW_ID = X_CASHFLOW_ID,
154: EVENT_ID = X_EVENT_ID,
155: EVENT_TYPE = X_EVENT_TYPE,

Line 186: DELETE FROM CE_CASHFLOW_ACCT_H

182: END UPDATE_ROW;
183:
184: PROCEDURE Delete_Row( X_Row_id VARCHAR2 ) IS
185: BEGIN
186: DELETE FROM CE_CASHFLOW_ACCT_H
187: WHERE rowid = X_Row_Id;
188: IF (SQL%NOTFOUND) THEN
189: Raise NO_DATA_FOUND;
190: END IF;