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