PACKAGE: APPS.CSI_I_ASSETS_PKG

Source

1 PACKAGE CSI_I_ASSETS_PKG AUTHID CURRENT_USER as
2 /* $Header: csitinas.pls 120.2 2005/06/08 13:52:14 appldev  $ */
3 
4 PROCEDURE Insert_Row(
5           px_INSTANCE_ASSET_ID   IN OUT NOCOPY NUMBER,
6           p_INSTANCE_ID    NUMBER,
7           p_FA_ASSET_ID    NUMBER,
8           p_FA_BOOK_TYPE_CODE    VARCHAR2,
9           p_FA_LOCATION_ID    NUMBER,
10           p_ASSET_QUANTITY    NUMBER,
11           p_UPDATE_STATUS    VARCHAR2,
12           P_FA_SYNC_FLAG    VARCHAR2,
13           P_FA_MASS_ADDITION_ID    NUMBER,
14           P_CREATION_COMPLETE_FLAG    VARCHAR2,
15           p_CREATED_BY    NUMBER,
16           p_CREATION_DATE    DATE,
17           p_LAST_UPDATED_BY    NUMBER,
18           p_LAST_UPDATE_DATE    DATE,
19           p_LAST_UPDATE_LOGIN    NUMBER,
20           p_OBJECT_VERSION_NUMBER    NUMBER,
21           p_ACTIVE_START_DATE    DATE,
22           p_ACTIVE_END_DATE    DATE);
23 
24 PROCEDURE Update_Row(
25           p_INSTANCE_ASSET_ID    NUMBER,
26           p_INSTANCE_ID    NUMBER,
27           p_FA_ASSET_ID    NUMBER,
28           p_FA_BOOK_TYPE_CODE    VARCHAR2,
29           p_FA_LOCATION_ID    NUMBER,
30           p_ASSET_QUANTITY    NUMBER,
31           p_UPDATE_STATUS    VARCHAR2,
32           P_FA_SYNC_FLAG   VARCHAR2,
33           P_FA_MASS_ADDITION_ID    NUMBER,
34           P_CREATION_COMPLETE_FLAG    VARCHAR2,
35           p_CREATED_BY    NUMBER,
36           p_CREATION_DATE    DATE,
37           p_LAST_UPDATED_BY    NUMBER,
38           p_LAST_UPDATE_DATE    DATE,
39           p_LAST_UPDATE_LOGIN    NUMBER,
40           p_OBJECT_VERSION_NUMBER    NUMBER,
41           p_ACTIVE_START_DATE    DATE,
42           p_ACTIVE_END_DATE    DATE);
43 
44 PROCEDURE Lock_Row(
45           p_INSTANCE_ASSET_ID    NUMBER,
46           p_INSTANCE_ID    NUMBER,
47           p_FA_ASSET_ID    NUMBER,
48           p_FA_BOOK_TYPE_CODE    VARCHAR2,
49           p_FA_LOCATION_ID    NUMBER,
50           p_ASSET_QUANTITY    NUMBER,
51           p_UPDATE_STATUS    VARCHAR2,
52           P_FA_SYNC_FLAG   VARCHAR2,
53           P_FA_MASS_ADDITION_ID    NUMBER,
54           P_CREATION_COMPLETE_FLAG    VARCHAR2,
55           p_CREATED_BY    NUMBER,
56           p_CREATION_DATE    DATE,
57           p_LAST_UPDATED_BY    NUMBER,
58           p_LAST_UPDATE_DATE    DATE,
59           p_LAST_UPDATE_LOGIN    NUMBER,
60           p_OBJECT_VERSION_NUMBER    NUMBER,
61           p_ACTIVE_START_DATE    DATE,
62           p_ACTIVE_END_DATE    DATE);
63 
64 PROCEDURE Delete_Row(
65     p_INSTANCE_ASSET_ID  NUMBER);
66 
67 End CSI_I_ASSETS_PKG;
68