APPS.CSI_FA_TRANSACTIONS_PKG dependencies on CSI_FA_TRANSACTIONS

Line 1: package body CSI_FA_TRANSACTIONS_PKG as

1: package body CSI_FA_TRANSACTIONS_PKG as
2: /* $Header: csitfatb.pls 120.0 2005/06/17 15:06:59 brmanesh noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_INTERFACE_LINE_ID in NUMBER,

Line 28: insert into CSI_FA_TRANSACTIONS (

24: X_LAST_UPDATED_BY in NUMBER,
25: X_LAST_UPDATE_LOGIN in NUMBER
26: ) is
27: begin
28: insert into CSI_FA_TRANSACTIONS (
29: INTERFACE_HEADER_ID,
30: INTERFACE_LINE_ID,
31: TRANSACTION_SOURCE_TYPE,
32: DISTRIBUTION_ID,

Line 110: from CSI_FA_TRANSACTIONS

106: DATE_NOTIFIED,
107: ERROR_FLAG,
108: ERROR_TEXT,
109: TRANSACTION_SOURCE_TYPE
110: from CSI_FA_TRANSACTIONS
111: where INTERFACE_LINE_ID = X_INTERFACE_LINE_ID
112: for update of INTERFACE_LINE_ID nowait;
113: begin
114: for tlinfo in c1 loop

Line 170: update CSI_FA_TRANSACTIONS set

166: X_LAST_UPDATED_BY in NUMBER,
167: X_LAST_UPDATE_LOGIN in NUMBER
168: ) is
169: begin
170: update CSI_FA_TRANSACTIONS set
171: INTERFACE_HEADER_ID = X_INTERFACE_HEADER_ID,
172: DISTRIBUTION_ID = X_DISTRIBUTION_ID,
173: TRANSACTION_DATE = X_TRANSACTION_DATE,
174: TRANSACTION_UNITS = X_TRANSACTION_UNITS,

Line 200: delete from CSI_FA_TRANSACTIONS

196: procedure DELETE_ROW (
197: X_INTERFACE_LINE_ID in NUMBER
198: ) is
199: begin
200: delete from CSI_FA_TRANSACTIONS
201: where INTERFACE_LINE_ID = X_INTERFACE_LINE_ID;
202:
203: if (sql%notfound) then
204: raise no_data_found;

Line 209: end CSI_FA_TRANSACTIONS_PKG;

205: end if;
206:
207: end DELETE_ROW;
208:
209: end CSI_FA_TRANSACTIONS_PKG;