1 package CSR_WIN_PROMIS_PKG as
2 /*$Header: CSRSIPWS.pls 120.1 2006/03/30 21:04:24 venjayar noship $
3 +========================================================================+
4 | Copyright (c) 1999 Oracle Corporation |
5 | Redwood Shores, California, USA |
6 | All rights reserved. |
7 +========================================================================+
8 Name
9 ----
10 CSR_WIN_PROMIS_PKG
11
12 Purpose
13 -------
14 Insert, update, delete or lock tables belonging to view CSR_WIN_PROMIS_V:
15 - base table CSR_WIN_PROMIS_ALL_B, and
16 - translation table CSR_WIN_PROMIS_ALL_TL.
17 Check uniqueness of columns NAME and START/END_TIME combinations. Restore
18 data integrity to a corrupted base/translation pair.
19
20 History
21 -------
22 10-DEC-1999 E.Kerkhoven First creation
23 13-NOV-2002 J. van Grondelle Bug 2664009.
24 Added NOCOPY hint to procedure
25 out-parameters.
26 +========================================================================+
27 */
28 procedure check_unique
29 (
30 p_win_promis_id IN varchar2
31 , p_name IN varchar2
32 , p_start_time IN date
33 , p_end_time IN date
34 );
35
36 procedure insert_row
37 (
38 p_row_id IN OUT NOCOPY varchar2
39 , p_win_promis_id IN OUT NOCOPY number
40 , p_name IN varchar2
41 , p_description IN varchar2
42 , p_start_time IN date
43 , p_end_time IN date
44 , p_created_by IN OUT NOCOPY number
45 , p_creation_date IN OUT NOCOPY date
46 , p_last_updated_by IN OUT NOCOPY number
47 , p_last_update_date IN OUT NOCOPY date
48 , p_last_update_login IN OUT NOCOPY number
49 , p_attribute1 IN varchar2
50 , p_attribute2 IN varchar2
51 , p_attribute3 IN varchar2
52 , p_attribute4 IN varchar2
53 , p_attribute5 IN varchar2
54 , p_attribute6 IN varchar2
55 , p_attribute7 IN varchar2
56 , p_attribute8 IN varchar2
57 , p_attribute9 IN varchar2
58 , p_attribute10 IN varchar2
59 , p_attribute11 IN varchar2
60 , p_attribute12 IN varchar2
61 , p_attribute13 IN varchar2
62 , p_attribute14 IN varchar2
63 , p_attribute15 IN varchar2
64 , p_attribute_category IN varchar2
65 , p_org_id IN number
66 );
67
68 procedure lock_row
69 (
70 p_win_promis_id IN number
71 , p_name IN varchar2
72 , p_description IN varchar2
73 , p_start_time IN date
74 , p_end_time IN date
75 , p_attribute1 IN varchar2
76 , p_attribute2 IN varchar2
77 , p_attribute3 IN varchar2
78 , p_attribute4 IN varchar2
79 , p_attribute5 IN varchar2
80 , p_attribute6 IN varchar2
81 , p_attribute7 IN varchar2
82 , p_attribute8 IN varchar2
83 , p_attribute9 IN varchar2
84 , p_attribute10 IN varchar2
85 , p_attribute11 IN varchar2
86 , p_attribute12 IN varchar2
87 , p_attribute13 IN varchar2
88 , p_attribute14 IN varchar2
89 , p_attribute15 IN varchar2
90 , p_attribute_category IN varchar2
91 );
92
93 procedure update_row
94 (
95 p_win_promis_id IN number
96 , p_name IN varchar2
97 , p_description IN varchar2
98 , p_start_time IN date
99 , p_end_time IN date
100 , p_last_updated_by IN OUT NOCOPY number
101 , p_last_update_date IN OUT NOCOPY date
102 , p_last_update_login IN OUT NOCOPY number
103 , p_attribute1 IN varchar2
104 , p_attribute2 IN varchar2
105 , p_attribute3 IN varchar2
106 , p_attribute4 IN varchar2
107 , p_attribute5 IN varchar2
108 , p_attribute6 IN varchar2
109 , p_attribute7 IN varchar2
110 , p_attribute8 IN varchar2
111 , p_attribute9 IN varchar2
112 , p_attribute10 IN varchar2
113 , p_attribute11 IN varchar2
114 , p_attribute12 IN varchar2
115 , p_attribute13 IN varchar2
116 , p_attribute14 IN varchar2
117 , p_attribute15 IN varchar2
118 , p_attribute_category IN varchar2
119 );
120
121 procedure delete_row
122 (
123 p_win_promis_id IN number
124 );
125
126 procedure add_language;
127
128 procedure translate_row
129 (
130 p_win_promis_id IN varchar2
131 , p_name IN varchar2
132 , p_description IN varchar2
133 , p_owner IN varchar2
134 );
135
136 procedure load_row
137 (
138 p_win_promis_id IN varchar2
139 , p_name IN varchar2
140 , p_description IN varchar2
141 , p_start_time IN varchar2
142 , p_end_time In varchar2
143 , p_owner IN varchar2
144 , p_attribute1 IN varchar2
145 , p_attribute2 IN varchar2
146 , p_attribute3 IN varchar2
147 , p_attribute4 IN varchar2
148 , p_attribute5 IN varchar2
149 , p_attribute6 IN varchar2
150 , p_attribute7 IN varchar2
151 , p_attribute8 IN varchar2
152 , p_attribute9 IN varchar2
153 , p_attribute10 IN varchar2
154 , p_attribute11 IN varchar2
155 , p_attribute12 IN varchar2
156 , p_attribute13 IN varchar2
157 , p_attribute14 IN varchar2
158 , p_attribute15 IN varchar2
159 , p_attribute_category IN varchar2
160 , p_org_id IN varchar2
161 );
162
163 end CSR_WIN_PROMIS_PKG;