1 PACKAGE CS_SYSTEM_OPTIONS_PKG AUTHID CURRENT_USER AS
2 /* $Header: cstsyops.pls 120.0 2005/08/12 15:27:08 aneemuch noship $ */
3
4 PROCEDURE INSERT_ROW (
5 P_SYSTEM_OPTION_ID IN NUMBER,
6 P_SR_AGENT_SECURITY IN VARCHAR2,
7 P_SS_SRTYPE_RESTRICT IN VARCHAR2,
8 P_CREATION_DATE IN DATE,
9 P_CREATED_BY IN NUMBER,
10 P_LAST_UPDATE_DATE IN DATE,
11 P_LAST_UPDATED_BY IN NUMBER,
12 P_LAST_UPDATE_LOGIN IN NUMBER,
13 P_ATTRIBUTE1 IN VARCHAR2,
14 P_ATTRIBUTE2 IN VARCHAR2,
15 P_ATTRIBUTE3 IN VARCHAR2,
16 P_ATTRIBUTE4 IN VARCHAR2,
17 P_ATTRIBUTE5 IN VARCHAR2,
18 P_ATTRIBUTE6 IN VARCHAR2,
19 P_ATTRIBUTE7 IN VARCHAR2,
20 P_ATTRIBUTE8 IN VARCHAR2,
21 P_ATTRIBUTE9 IN VARCHAR2,
22 P_ATTRIBUTE10 IN VARCHAR2,
23 P_ATTRIBUTE11 IN VARCHAR2,
24 P_ATTRIBUTE12 IN VARCHAR2,
25 P_ATTRIBUTE13 IN VARCHAR2,
26 P_ATTRIBUTE14 IN VARCHAR2,
27 P_ATTRIBUTE15 IN VARCHAR2,
28 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
29 P_OBJECT_VERSION_NUMBER IN NUMBER );
30
31
32 PROCEDURE LOCK_ROW (
33 P_SYSTEM_OPTION_ID IN NUMBER,
34 P_OBJECT_VERSION_NUMBER IN NUMBER );
35
36
37 PROCEDURE UPDATE_ROW (
38 P_SYSTEM_OPTION_ID IN NUMBER,
39 P_SR_AGENT_SECURITY IN VARCHAR2,
40 P_SS_SRTYPE_RESTRICT IN VARCHAR2,
41 P_LAST_UPDATE_DATE IN DATE,
42 P_LAST_UPDATED_BY IN NUMBER,
43 P_LAST_UPDATE_LOGIN IN NUMBER,
44 P_ATTRIBUTE1 IN VARCHAR2,
45 P_ATTRIBUTE2 IN VARCHAR2,
46 P_ATTRIBUTE3 IN VARCHAR2,
47 P_ATTRIBUTE4 IN VARCHAR2,
48 P_ATTRIBUTE5 IN VARCHAR2,
49 P_ATTRIBUTE6 IN VARCHAR2,
50 P_ATTRIBUTE7 IN VARCHAR2,
51 P_ATTRIBUTE8 IN VARCHAR2,
52 P_ATTRIBUTE9 IN VARCHAR2,
53 P_ATTRIBUTE10 IN VARCHAR2,
54 P_ATTRIBUTE11 IN VARCHAR2,
55 P_ATTRIBUTE12 IN VARCHAR2,
56 P_ATTRIBUTE13 IN VARCHAR2,
57 P_ATTRIBUTE14 IN VARCHAR2,
58 P_ATTRIBUTE15 IN VARCHAR2,
59 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
60 P_OBJECT_VERSION_NUMBER IN NUMBER );
61
62
63 PROCEDURE DELETE_ROW (
64 P_SYSTEM_OPTION_ID IN NUMBER );
65
66 PROCEDURE LOAD_ROW (
67 P_SYSTEM_OPTION_ID IN NUMBER,
68 P_SR_AGENT_SECURITY IN VARCHAR2,
69 P_SS_SRTYPE_RESTRICT IN VARCHAR2,
70 P_CREATION_DATE IN VARCHAR2,
71 P_CREATED_BY IN NUMBER,
72 P_LAST_UPDATE_DATE IN VARCHAR2,
73 P_LAST_UPDATED_BY IN NUMBER,
74 P_LAST_UPDATE_LOGIN IN NUMBER,
75 P_OWNER IN VARCHAR2,
76 P_ATTRIBUTE1 IN VARCHAR2,
77 P_ATTRIBUTE2 IN VARCHAR2,
78 P_ATTRIBUTE3 IN VARCHAR2,
79 P_ATTRIBUTE4 IN VARCHAR2,
80 P_ATTRIBUTE5 IN VARCHAR2,
81 P_ATTRIBUTE6 IN VARCHAR2,
82 P_ATTRIBUTE7 IN VARCHAR2,
83 P_ATTRIBUTE8 IN VARCHAR2,
84 P_ATTRIBUTE9 IN VARCHAR2,
85 P_ATTRIBUTE10 IN VARCHAR2,
86 P_ATTRIBUTE11 IN VARCHAR2,
87 P_ATTRIBUTE12 IN VARCHAR2,
88 P_ATTRIBUTE13 IN VARCHAR2,
89 P_ATTRIBUTE14 IN VARCHAR2,
90 P_ATTRIBUTE15 IN VARCHAR2,
91 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
92 P_OBJECT_VERSION_NUMBER IN NUMBER );
93
94 END CS_SYSTEM_OPTIONS_PKG;