1 PACKAGE HZ_LOC_ASSIGNMENTS_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHTLATS.pls 115.2 2002/11/21 19:44:17 sponnamb ship $ */
3
4 PROCEDURE Insert_Row (
5 X_LOCATION_ID IN NUMBER,
6 X_LOC_ID IN NUMBER,
7 X_ORG_ID IN NUMBER,
8 X_OBJECT_VERSION_NUMBER IN NUMBER,
9 X_CREATED_BY_MODULE IN VARCHAR2,
10 X_APPLICATION_ID IN NUMBER
11 );
12
13 PROCEDURE Update_Row (
14 X_Rowid IN OUT NOCOPY VARCHAR2,
15 X_LOCATION_ID IN NUMBER,
16 X_LOC_ID IN NUMBER,
17 X_ORG_ID IN NUMBER,
18 X_OBJECT_VERSION_NUMBER IN NUMBER,
19 X_CREATED_BY_MODULE IN VARCHAR2,
20 X_APPLICATION_ID IN NUMBER
21 );
22
23 PROCEDURE Lock_Row (
24 X_Rowid IN OUT NOCOPY VARCHAR2,
25 X_LOCATION_ID IN NUMBER,
26 X_LOC_ID IN NUMBER,
27 X_ORG_ID IN NUMBER,
28 X_CREATED_BY IN NUMBER,
29 X_CREATION_DATE IN DATE,
30 X_LAST_UPDATE_LOGIN IN NUMBER,
31 X_LAST_UPDATE_DATE IN DATE,
32 X_LAST_UPDATED_BY IN NUMBER,
33 X_REQUEST_ID IN NUMBER,
34 X_PROGRAM_APPLICATION_ID IN NUMBER,
35 X_PROGRAM_ID IN NUMBER,
36 X_PROGRAM_UPDATE_DATE IN DATE,
37 X_OBJECT_VERSION_NUMBER IN NUMBER,
38 X_CREATED_BY_MODULE IN VARCHAR2,
39 X_APPLICATION_ID IN NUMBER
40 );
41
42 PROCEDURE Select_Row (
43 X_LOCATION_ID IN OUT NOCOPY NUMBER,
44 X_ORG_ID IN OUT NOCOPY NUMBER,
45 X_LOC_ID OUT NOCOPY NUMBER,
46 X_CREATED_BY_MODULE OUT NOCOPY VARCHAR2,
47 X_APPLICATION_ID OUT NOCOPY NUMBER
48 );
49
50 PROCEDURE Delete_Row (
51 X_LOCATION_ID IN NUMBER
52 );
53
54 END HZ_LOC_ASSIGNMENTS_PKG;
[Home] [Help]