DBA Data[Home] [Help]

PACKAGE: APPS.HZ_NAME_ADDRESS_FMT_VALIDATE

Source


1 PACKAGE HZ_NAME_ADDRESS_FMT_VALIDATE AUTHID CURRENT_USER AS
2 /*$Header: ARH2FMVS.pls 115.2 2002/11/21 06:12:16 sponnamb noship $ */
3 
4   --------------------------------------
5   -- declaration of public procedures and functions
6   --------------------------------------
7 
8   --
9   -- PROCEDURE validate_style
10   --
11   -- DESCRIPTION
12   --     Validates style record. Checks for
13   --         uniqueness
14   --         mandatory columns
15   --         non-updateable fields
16   --         foreign key validations
17   --         other validations
18   --
19   -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
20   --
21   -- ARGUMENTS
22   --   IN:
23   --     p_create_update_flag     Create update flag. 'C' = create. 'U' = update.
24   --     p_style_rec              Style record.
25   --     p_rowid                  Rowid of the record (used only in update mode).
26   --   IN/OUT:
27   --     x_return_status          Return status after the call. The status can
28   --                              be FND_API.G_RET_STS_SUCCESS (success),
29   --                              FND_API.G_RET_STS_ERROR (error),
30   --                              FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
31   --
32   -- NOTES
33   --
34   -- MODIFICATION HISTORY
35   --
36   --   18-JUL-2002    Kate Shan           o Created.
37   --
38   --
39 
40   PROCEDURE validate_style(
41       p_create_update_flag             IN     VARCHAR2,
42       p_style_rec                      IN     HZ_STYLE_V2PUB.STYLE_REC_TYPE,
43       p_rowid                          IN     ROWID DEFAULT NULL,
44       x_return_status                  IN OUT NOCOPY VARCHAR2
45   );
46 
47   --
48   -- PROCEDURE validate_style_format
49   --
50   -- DESCRIPTION
51   --     Validates style record. Checks for
52   --         uniqueness
53   --         mandatory columns
54   --         non-updateable fields
55   --         foreign key validations
56   --         other validations
57   --
58   -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
59   --
60   -- ARGUMENTS
61   --   IN:
62   --     p_create_update_flag     Create update flag. 'C' = create. 'U' = update.
63   --     p_style_format_rec       Style Format record.
64   --     p_rowid                  Rowid of the record (used only in update mode).
65   --   IN/OUT:
66   --     x_return_status          Return status after the call. The status can
67   --                              be FND_API.G_RET_STS_SUCCESS (success),
68   --                              FND_API.G_RET_STS_ERROR (error),
69   --                              FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
70   --
71   -- NOTES
72   --
73   -- MODIFICATION HISTORY
74   --
75   --   18-JUL-2002    Kate Shan           o Created.
76   --
77   --
78 
79   PROCEDURE validate_style_format(
80       p_create_update_flag             IN     VARCHAR2,
81       p_style_format_rec               IN     HZ_STYLE_FORMAT_V2PUB.STYLE_FORMAT_REC_TYPE,
82       p_rowid                          IN     ROWID DEFAULT NULL,
83       x_return_status                  IN OUT NOCOPY VARCHAR2
84   );
85 
86 
87   --
88   -- PROCEDURE validate_style_fmt_locale
89   --
90   -- DESCRIPTION
91   --     Validates style record. Checks for
92   --         uniqueness
93   --         mandatory columns
94   --         non-updateable fields
95   --         foreign key validations
96   --         other validations
97   --
98   -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
99   --
100   -- ARGUMENTS
101   --   IN:
102   --     p_create_update_flag     Create update flag. 'C' = create. 'U' = update.
103   --     p_style_fmt_locale_rec   Style Locale record.
104   --     p_rowid                  Rowid of the record (used only in update mode).
105   --   IN/OUT:
106   --     x_return_status          Return status after the call. The status can
107   --                              be FND_API.G_RET_STS_SUCCESS (success),
108   --                              FND_API.G_RET_STS_ERROR (error),
109   --                              FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
110   --
111   -- NOTES
112   --
113   -- MODIFICATION HISTORY
114   --
115   --   18-JUL-2002    Kate Shan           o Created.
116   --
117   --
118 
119   PROCEDURE validate_style_fmt_locale(
120       p_create_update_flag             IN     VARCHAR2,
121       p_style_fmt_locale_rec           IN     HZ_STYLE_FMT_LOCALE_V2PUB.STYLE_FMT_LOCALE_REC_TYPE,
122       p_rowid                          IN     ROWID DEFAULT NULL,
123       x_return_status                  IN OUT NOCOPY VARCHAR2
124   );
125 
126 
127   --
128   -- PROCEDURE validate_style_fmt_variation
129   --
130   -- DESCRIPTION
131   --     Validates style record. Checks for
132   --         uniqueness
133   --         mandatory columns
134   --         non-updateable fields
135   --         foreign key validations
136   --         other validations
137   --
138   -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
139   --
140   -- ARGUMENTS
141   --   IN:
142   --     p_create_update_flag       Create update flag. 'C' = create. 'U' = update.
143   --     p_style_fmt_variation_rec  Style Locale record.
144   --     p_rowid                    Rowid of the record (used only in update mode).
145   --   IN/OUT:
146   --     x_return_status            Return status after the call. The status can
147   --                                be FND_API.G_RET_STS_SUCCESS (success),
148   --                                FND_API.G_RET_STS_ERROR (error),
149   --                                FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
150   --
151   -- NOTES
152   --
153   -- MODIFICATION HISTORY
154   --
155   --   18-JUL-2002    Kate Shan           o Created.
156   --
157   --
158 
159   PROCEDURE validate_style_fmt_variation(
160       p_create_update_flag             IN     VARCHAR2,
161       p_style_fmt_variation_rec        IN     HZ_STYLE_FMT_VARIATION_V2PUB.STYLE_FMT_VARIATION_REC_TYPE,
162       p_rowid                          IN     ROWID DEFAULT NULL,
163       x_return_status                  IN OUT NOCOPY VARCHAR2
164   );
165 
166 
167   --
168   -- PROCEDURE validate_style_fmt_layout
169   --
170   -- DESCRIPTION
171   --     Validates style record. Checks for
172   --         uniqueness
173   --         mandatory columns
174   --         non-updateable fields
175   --         foreign key validations
176   --         other validations
177   --
178   -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
179   --
180   -- ARGUMENTS
181   --   IN:
182   --     p_create_update_flag       Create update flag. 'C' = create. 'U' = update.
183   --     p_style_fmt_layout_rec     Style Locale record.
184   --     p_rowid                    Rowid of the record (used only in update mode).
185   --   IN/OUT:
186   --     x_return_status            Return status after the call. The status can
187   --                                be FND_API.G_RET_STS_SUCCESS (success),
188   --                                FND_API.G_RET_STS_ERROR (error),
189   --                                FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
190   --
191   -- NOTES
192   --
193   -- MODIFICATION HISTORY
194   --
195   --   18-JUL-2002    Kate Shan           o Created.
196   --
197   --
198 
199   PROCEDURE validate_style_fmt_layout(
200       p_create_update_flag             IN     VARCHAR2,
201       p_style_fmt_layout_rec           IN     HZ_STYLE_FMT_LAYOUT_V2PUB.STYLE_FMT_LAYOUT_REC_TYPE,
202       p_rowid                          IN     ROWID DEFAULT NULL,
203       x_return_status                  IN OUT NOCOPY VARCHAR2
204   );
205 
206 END HZ_NAME_ADDRESS_FMT_VALIDATE;