DBA Data[Home] [Help]

PACKAGE: APPS.CSR_COSTS_PKG

Source


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;