1 PACKAGE ASO_QUOTE_ACCESSES_PKG AUTHID CURRENT_USER AS
2 /* $Header: asotqacs.pls 120.1 2005/06/29 12:40:20 appldev ship $ */
3
4 procedure INSERT_ROW (
5 PX_ACCESS_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
6 P_QUOTE_NUMBER in NUMBER,
7 P_RESOURCE_ID in NUMBER,
8 P_RESOURCE_GRP_ID in NUMBER,
9 P_CREATED_BY in NUMBER,
10 P_CREATION_DATE in DATE,
11 P_LAST_UPDATED_BY in NUMBER,
12 P_LAST_UPDATE_LOGIN in NUMBER,
13 P_LAST_UPDATE_DATE in DATE,
14 P_REQUEST_ID in NUMBER,
15 P_PROGRAM_APPLICATION_ID NUMBER,
16 P_PROGRAM_ID NUMBER,
17 P_PROGRAM_UPDATE_DATE DATE,
18 P_KEEP_FLAG in VARCHAR2,
19 P_UPDATE_ACCESS_FLAG in VARCHAR2,
20 P_CREATED_BY_TAP_FLAG in VARCHAR2,
21 P_TERRITORY_ID in NUMBER,
22 P_TERRITORY_SOURCE_FLAG in VARCHAR2,
23 P_ROLE_ID in NUMBER,
24 P_ATTRIBUTE_CATEGORY in VARCHAR2,
25 P_ATTRIBUTE1 in VARCHAR2,
26 P_ATTRIBUTE2 in VARCHAR2,
27 P_ATTRIBUTE3 in VARCHAR2,
28 P_ATTRIBUTE4 in VARCHAR2,
29 P_ATTRIBUTE5 in VARCHAR2,
30 P_ATTRIBUTE6 in VARCHAR2,
31 P_ATTRIBUTE7 in VARCHAR2,
32 P_ATTRIBUTE8 in VARCHAR2,
33 P_ATTRIBUTE9 in VARCHAR2,
34 P_ATTRIBUTE10 in VARCHAR2,
35 P_ATTRIBUTE11 in VARCHAR2,
36 P_ATTRIBUTE12 in VARCHAR2,
37 P_ATTRIBUTE13 in VARCHAR2,
38 P_ATTRIBUTE14 in VARCHAR2,
39 P_ATTRIBUTE15 in VARCHAR2,
40 p_ATTRIBUTE16 VARCHAR2,
41 p_ATTRIBUTE17 VARCHAR2,
42 p_ATTRIBUTE18 VARCHAR2,
43 p_ATTRIBUTE19 VARCHAR2,
44 p_ATTRIBUTE20 VARCHAR2,
45 p_OBJECT_VERSION_NUMBER NUMBER
46 );
47
48
49 procedure UPDATE_ROW (
50 P_ACCESS_ID in NUMBER,
51 P_QUOTE_NUMBER in NUMBER,
52 P_RESOURCE_ID in NUMBER,
53 P_RESOURCE_GRP_ID in NUMBER,
54 P_CREATED_BY in NUMBER,
55 P_CREATION_DATE in DATE,
56 P_LAST_UPDATED_BY in NUMBER,
57 P_LAST_UPDATE_LOGIN in NUMBER,
58 P_LAST_UPDATE_DATE in DATE,
59 P_REQUEST_ID in NUMBER,
60 P_PROGRAM_APPLICATION_ID NUMBER,
61 P_PROGRAM_ID NUMBER,
62 P_PROGRAM_UPDATE_DATE DATE,
63 P_KEEP_FLAG in VARCHAR2,
64 P_UPDATE_ACCESS_FLAG in VARCHAR2,
65 P_CREATED_BY_TAP_FLAG in VARCHAR2,
66 P_TERRITORY_ID in NUMBER,
67 P_TERRITORY_SOURCE_FLAG in VARCHAR2,
68 P_ROLE_ID in NUMBER,
69 P_ATTRIBUTE_CATEGORY in VARCHAR2,
70 P_ATTRIBUTE1 in VARCHAR2,
71 P_ATTRIBUTE2 in VARCHAR2,
72 P_ATTRIBUTE3 in VARCHAR2,
73 P_ATTRIBUTE4 in VARCHAR2,
74 P_ATTRIBUTE5 in VARCHAR2,
75 P_ATTRIBUTE6 in VARCHAR2,
76 P_ATTRIBUTE7 in VARCHAR2,
77 P_ATTRIBUTE8 in VARCHAR2,
78 P_ATTRIBUTE9 in VARCHAR2,
79 P_ATTRIBUTE10 in VARCHAR2,
80 P_ATTRIBUTE11 in VARCHAR2,
81 P_ATTRIBUTE12 in VARCHAR2,
82 P_ATTRIBUTE13 in VARCHAR2,
83 P_ATTRIBUTE14 in VARCHAR2,
84 P_ATTRIBUTE15 in VARCHAR2,
85 p_ATTRIBUTE16 VARCHAR2,
86 p_ATTRIBUTE17 VARCHAR2,
87 p_ATTRIBUTE18 VARCHAR2,
88 p_ATTRIBUTE19 VARCHAR2,
89 p_ATTRIBUTE20 VARCHAR2,
90 p_OBJECT_VERSION_NUMBER NUMBER
91 );
92
93
94 procedure DELETE_ROW (
95 P_ACCESS_ID in NUMBER
96 );
97
98
99 procedure LOCK_ROW (
100 P_ACCESS_ID in NUMBER,
101 P_QUOTE_NUMBER in NUMBER,
102 P_RESOURCE_ID in NUMBER,
103 P_RESOURCE_GRP_ID in NUMBER,
104 P_CREATED_BY in NUMBER,
105 P_CREATION_DATE in DATE,
106 P_LAST_UPDATED_BY in NUMBER,
107 P_LAST_UPDATE_LOGIN in NUMBER,
108 P_LAST_UPDATE_DATE in DATE,
109 P_REQUEST_ID in NUMBER,
110 P_PROGRAM_APPLICATION_ID NUMBER,
111 P_PROGRAM_ID NUMBER,
112 P_PROGRAM_UPDATE_DATE DATE,
113 P_KEEP_FLAG in VARCHAR2,
114 P_UPDATE_ACCESS_FLAG in VARCHAR2,
115 P_CREATED_BY_TAP_FLAG in VARCHAR2,
116 P_TERRITORY_ID in NUMBER,
117 P_TERRITORY_SOURCE_FLAG in VARCHAR2,
118 P_ROLE_ID in NUMBER,
119 P_ATTRIBUTE_CATEGORY in VARCHAR2,
120 P_ATTRIBUTE1 in VARCHAR2,
121 P_ATTRIBUTE2 in VARCHAR2,
122 P_ATTRIBUTE3 in VARCHAR2,
123 P_ATTRIBUTE4 in VARCHAR2,
124 P_ATTRIBUTE5 in VARCHAR2,
125 P_ATTRIBUTE6 in VARCHAR2,
126 P_ATTRIBUTE7 in VARCHAR2,
127 P_ATTRIBUTE8 in VARCHAR2,
128 P_ATTRIBUTE9 in VARCHAR2,
129 P_ATTRIBUTE10 in VARCHAR2,
130 P_ATTRIBUTE11 in VARCHAR2,
131 P_ATTRIBUTE12 in VARCHAR2,
132 P_ATTRIBUTE13 in VARCHAR2,
133 P_ATTRIBUTE14 in VARCHAR2,
134 P_ATTRIBUTE15 in VARCHAR2
135 );
136
137
138 end ASO_QUOTE_ACCESSES_PKG;