PACKAGE: APPS.CSI_A_LOCATIONS_PKG

Source

1 PACKAGE CSI_A_LOCATIONS_PKG AUTHID CURRENT_USER as
2 /* $Header: csitlocs.pls 115.7 2002/11/12 00:23:03 rmamidip noship $ */
3 
4 
5 PROCEDURE Insert_Row(
6           px_ASSET_LOCATION_ID   IN OUT NOCOPY NUMBER,
7           p_FA_LOCATION_ID    NUMBER,
8           p_LOCATION_TABLE    VARCHAR2,
9           p_LOCATION_ID    NUMBER,
10           p_ACTIVE_START_DATE    DATE,
11           p_ACTIVE_END_DATE    DATE,
12           p_CREATED_BY    NUMBER,
13           p_CREATION_DATE    DATE,
14           p_LAST_UPDATED_BY    NUMBER,
15           p_LAST_UPDATE_DATE    DATE,
16           p_LAST_UPDATE_LOGIN    NUMBER,
17           p_OBJECT_VERSION_NUMBER    NUMBER);
18 
19 PROCEDURE Update_Row(
20           p_ASSET_LOCATION_ID    NUMBER,
21           p_FA_LOCATION_ID    NUMBER,
22           p_LOCATION_TABLE    VARCHAR2,
23           p_LOCATION_ID    NUMBER,
24           p_ACTIVE_START_DATE    DATE,
25           p_ACTIVE_END_DATE    DATE,
26           p_CREATED_BY    NUMBER,
27           p_CREATION_DATE    DATE,
28           p_LAST_UPDATED_BY    NUMBER,
29           p_LAST_UPDATE_DATE    DATE,
30           p_LAST_UPDATE_LOGIN    NUMBER,
31           p_OBJECT_VERSION_NUMBER    NUMBER);
32 
33 PROCEDURE Lock_Row(
34           p_ASSET_LOCATION_ID    NUMBER,
35           p_FA_LOCATION_ID    NUMBER,
36           p_LOCATION_TABLE    VARCHAR2,
37           p_LOCATION_ID    NUMBER,
38           p_ACTIVE_START_DATE    DATE,
39           p_ACTIVE_END_DATE    DATE,
40           p_CREATED_BY    NUMBER,
41           p_CREATION_DATE    DATE,
42           p_LAST_UPDATED_BY    NUMBER,
43           p_LAST_UPDATE_DATE    DATE,
44           p_LAST_UPDATE_LOGIN    NUMBER,
45           p_OBJECT_VERSION_NUMBER    NUMBER);
46 
47 PROCEDURE Delete_Row(
48     p_ASSET_LOCATION_ID  NUMBER);
49 End CSI_A_LOCATIONS_PKG;
50