1 PACKAGE OKE_APPROVAL_STEPS_PKG AS
2 /* $Header: OKEAPVES.pls 120.1 2005/06/02 12:03:59 appldev $ */
3
4 PROCEDURE INSERT_ROW
5 ( X_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6 , X_APPROVAL_PATH_ID IN NUMBER
7 , X_APPROVAL_SEQUENCE IN NUMBER
8 , X_APPROVER_ROLE_ID IN NUMBER
9 , X_REQUIRED_FLAG IN VARCHAR2
10 , X_CREATION_DATE IN DATE
11 , X_CREATED_BY IN NUMBER
12 , X_LAST_UPDATE_DATE IN DATE
13 , X_LAST_UPDATED_BY IN NUMBER
14 , X_LAST_UPDATE_LOGIN IN NUMBER
15 , X_RECORD_VERSION_NUMBER IN OUT NOCOPY /* file.sql.39 change */ NUMBER
16 );
17
18 PROCEDURE LOCK_ROW
19 ( X_APPROVAL_PATH_ID IN NUMBER
20 , X_APPROVAL_SEQUENCE IN NUMBER
21 , X_RECORD_VERSION_NUMBER IN NUMBER
22 );
23
24 PROCEDURE UPDATE_ROW
25 ( X_APPROVAL_PATH_ID IN NUMBER
26 , X_APPROVAL_SEQUENCE IN NUMBER
27 , X_APPROVER_ROLE_ID IN NUMBER
28 , X_REQUIRED_FLAG IN VARCHAR2
29 , X_LAST_UPDATE_DATE IN DATE
30 , X_LAST_UPDATED_BY IN NUMBER
31 , X_LAST_UPDATE_LOGIN IN NUMBER
32 , X_RECORD_VERSION_NUMBER IN OUT NOCOPY /* file.sql.39 change */ NUMBER
33 );
34
35 PROCEDURE DELETE_ROW
36 ( X_APPROVAL_PATH_ID IN NUMBER
37 , X_APPROVAL_SEQUENCE IN NUMBER
38 );
39
40 PROCEDURE LOAD_ROW
41 ( X_APPROVAL_PATH_ID IN NUMBER
42 , X_APPROVAL_SEQUENCE IN NUMBER
43 , X_APPROVER_ROLE_ID IN NUMBER
44 , X_REQUIRED_FLAG IN VARCHAR2
45 , X_LAST_UPDATE_DATE IN DATE
46 , X_LAST_UPDATED_BY IN NUMBER
47 );
48
49 END OKE_APPROVAL_STEPS_PKG;