APPS.CSI_FA_HEADERS_PKG dependencies on CSI_FA_HEADERS

Line 1: package body CSI_FA_HEADERS_PKG as

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

Line 17: insert into CSI_FA_HEADERS (

13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: begin
17: insert into CSI_FA_HEADERS (
18: INTERFACE_HEADER_ID,
19: FA_ASSET_ID,
20: FA_BOOK_TYPE_CODE,
21: FEEDER_SYSTEM_NAME,

Line 55: from CSI_FA_HEADERS

51: FA_ASSET_ID,
52: FEEDER_SYSTEM_NAME,
53: STATUS_CODE,
54: FA_BOOK_TYPE_CODE
55: from CSI_FA_HEADERS
56: where INTERFACE_HEADER_ID = X_INTERFACE_HEADER_ID
57: for update of INTERFACE_HEADER_ID nowait;
58: begin
59: for tlinfo in c1 loop

Line 86: update CSI_FA_HEADERS set

82: X_LAST_UPDATED_BY in NUMBER,
83: X_LAST_UPDATE_LOGIN in NUMBER
84: ) is
85: begin
86: update CSI_FA_HEADERS set
87: FA_ASSET_ID = X_FA_ASSET_ID,
88: FEEDER_SYSTEM_NAME = X_FEEDER_SYSTEM_NAME,
89: STATUS_CODE = X_STATUS_CODE,
90: FA_BOOK_TYPE_CODE = X_FA_BOOK_TYPE_CODE,

Line 106: delete from CSI_FA_HEADERS

102: procedure DELETE_ROW (
103: X_INTERFACE_HEADER_ID in NUMBER
104: ) is
105: begin
106: delete from CSI_FA_HEADERS
107: where INTERFACE_HEADER_ID = X_INTERFACE_HEADER_ID;
108:
109: if (sql%notfound) then
110: raise no_data_found;

Line 115: end CSI_FA_HEADERS_PKG;

111: end if;
112:
113: end DELETE_ROW;
114:
115: end CSI_FA_HEADERS_PKG;