1 PACKAGE OKE_APPROVAL_PATHS_PKG AS
2 /* $Header: OKEAPVPS.pls 120.1 2005/06/02 12:04:08 appldev $ */
3
4 --
5 -- Table Handler Procedures
6 --
7 PROCEDURE INSERT_ROW
8 ( X_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
9 , X_APPROVAL_PATH_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER
10 , X_SIGNATURE_REQUIRED_FLAG IN VARCHAR2
11 , X_SIGNATORY_ROLE_ID IN NUMBER
12 , X_NAME IN VARCHAR2
13 , X_DESCRIPTION IN VARCHAR2
14 , X_START_DATE_ACTIVE IN DATE
15 , X_END_DATE_ACTIVE IN DATE
16 , X_CREATION_DATE IN DATE
17 , X_CREATED_BY IN NUMBER
18 , X_LAST_UPDATE_DATE IN DATE
19 , X_LAST_UPDATED_BY IN NUMBER
20 , X_LAST_UPDATE_LOGIN IN NUMBER
21 , X_RECORD_VERSION_NUMBER IN OUT NOCOPY /* file.sql.39 change */ NUMBER
22 );
23
24 PROCEDURE LOCK_ROW
25 ( X_APPROVAL_PATH_ID IN NUMBER
26 , X_RECORD_VERSION_NUMBER IN NUMBER
27 );
28
29 PROCEDURE UPDATE_ROW
30 ( X_APPROVAL_PATH_ID IN NUMBER
31 , X_SIGNATURE_REQUIRED_FLAG IN VARCHAR2
32 , X_SIGNATORY_ROLE_ID IN NUMBER
33 , X_NAME IN VARCHAR2
34 , X_DESCRIPTION IN VARCHAR2
35 , X_START_DATE_ACTIVE IN DATE
36 , X_END_DATE_ACTIVE IN DATE
37 , X_LAST_UPDATE_DATE IN DATE
38 , X_LAST_UPDATED_BY IN NUMBER
39 , X_LAST_UPDATE_LOGIN IN NUMBER
40 , X_RECORD_VERSION_NUMBER OUT NOCOPY /* file.sql.39 change */ NUMBER
41 );
42
43 PROCEDURE DELETE_ROW
44 ( X_APPROVAL_PATH_ID IN NUMBER
45 );
46
47 PROCEDURE LOAD_ROW
48 ( X_APPROVAL_PATH_ID IN NUMBER
49 , X_NAME IN VARCHAR2
50 , X_DESCRIPTION IN VARCHAR2
51 , X_SIGNATURE_REQUIRED_FLAG IN VARCHAR2
52 , X_SIGNATORY_ROLE_ID IN NUMBER
53 , X_START_DATE_ACTIVE IN DATE
54 , X_END_DATE_ACTIVE IN DATE
55 , X_LAST_UPDATE_DATE IN DATE
56 , X_LAST_UPDATED_BY IN NUMBER
57 , X_CUSTOM_MODE IN VARCHAR2
58 );
59
60 PROCEDURE TRANSLATE_ROW
61 ( X_APPROVAL_PATH_ID IN NUMBER
62 , X_NAME IN VARCHAR2
63 , X_DESCRIPTION IN VARCHAR2
64 , X_LAST_UPDATE_DATE IN DATE
65 , X_LAST_UPDATED_BY IN NUMBER
66 , X_CUSTOM_MODE IN VARCHAR2
67 );
68
69 PROCEDURE ADD_LANGUAGE;
70
71 --
72 -- Utility Functions and Procedures
73 --
74 FUNCTION Approval_Steps
75 ( ApprovalPath IN NUMBER
76 ) RETURN VARCHAR2;
77
78 PROCEDURE Next_Approval_Step
79 ( ApprovalSteps IN VARCHAR2
80 , LastApprovalSeq IN NUMBER
81 , ApprovalSeq OUT NOCOPY /* file.sql.39 change */ NUMBER
82 , ApproverRole OUT NOCOPY /* file.sql.39 change */ NUMBER
83 );
84
85 END OKE_APPROVAL_PATHS_PKG;