[Home] [Help]
PACKAGE: APPS.HZ_STYLE_FMT_LOCALE_V2PUB
Source
1 PACKAGE HZ_STYLE_FMT_LOCALE_V2PUB AUTHID CURRENT_USER AS
2 /*$Header: ARH2SLSS.pls 115.2 2002/11/21 06:08:28 sponnamb noship $ */
3
4 --------------------------------------
5 -- declaration of record type
6 --------------------------------------
7
8 TYPE style_fmt_locale_rec_type IS RECORD (
9 style_fmt_locale_id NUMBER,
10 style_format_code VARCHAR2(30),
11 language_code VARCHAR2(4),
12 territory_code VARCHAR2(2),
13 start_date_active DATE,
14 end_date_active DATE
15 );
16
17 --------------------------------------
18 -- declaration of public procedures and functions
19 --------------------------------------
20
21 /**
22 * PROCEDURE create_style_fmt_locale
23 *
24 * DESCRIPTION
25 * Creates style_fmt_locale.
26 *
27 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
28 *
29 * ARGUMENTS
30 * IN:
31 * p_init_msg_list Initialize message stack if it is set to
32 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
33 * p_style_fmt_locale_rec Style record.
34 * IN/OUT:
35 * OUT:
36 * p_style_fmt_locale_id style_fmt_locale id
37 * x_return_status Return status after the call. The status can
38 * be FND_API.G_RET_STS_SUCCESS (success),
39 * FND_API.G_RET_STS_ERROR (error),
40 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
41 * x_msg_count Number of messages in message stack.
42 * x_msg_data Message text if x_msg_count is 1.
43 *
44 * NOTES
45 *
46 * MODIFICATION HISTORY
47 *
48 * 17-Jul-2002 Kate Shan o Created.
49 *
50 */
51
52 PROCEDURE create_style_fmt_locale (
53 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54 p_style_fmt_locale_rec IN STYLE_FMT_LOCALE_REC_TYPE,
55 p_style_fmt_locale_id OUT NOCOPY NUMBER,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2
59 );
60
61 /**
62 * PROCEDURE update_style_fmt_locale
63 *
64 * DESCRIPTION
65 * Updates style_fmt_locale.
66 *
67 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
68 *
69 * ARGUMENTS
70 * IN:
71 * p_init_msg_list Initialize message stack if it is set to
72 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
73 * p_style_fmt_locale_rec Style format locale record.
74 * IN/OUT:
75 * p_object_version_number Used for locking the being updated record.
76 * OUT:
77 * x_return_status Return status after the call. The status can
78 * be FND_API.G_RET_STS_SUCCESS (success),
79 * FND_API.G_RET_STS_ERROR (error),
80 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
81 * x_msg_count Number of messages in message stack.
82 * x_msg_data Message text if x_msg_count is 1.
83 *
84 * NOTES
85 *
86 * MODIFICATION HISTORY
87 *
88 * 17-Jul-2002 Kate Shan o Created.
89 *
90 */
91
92 PROCEDURE update_style_fmt_locale (
93 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
94 p_style_fmt_locale_rec IN STYLE_FMT_LOCALE_REC_TYPE,
95 p_object_version_number IN OUT NOCOPY NUMBER,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2
99 );
100
101 /**
102 * PROCEDURE get_style_fmt_locale_rec
103 *
104 * DESCRIPTION
105 * Gets style_fmt_locale record.
106 *
107 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
108 *
109 * ARGUMENTS
110 * IN:
111 * p_init_msg_list Initialize message stack if it is set to
112 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
113 * p_style_fmt_locale_code Style Code.
114 * IN/OUT:
115 * OUT:
116 * x_style_fmt_locale_rec Style format local record.
117 * x_return_status Return status after the call. The status can
118 * be FND_API.G_RET_STS_SUCCESS (success),
119 * FND_API.G_RET_STS_ERROR (error),
120 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
121 * x_msg_count Number of messages in message stack.
122 * x_msg_data Message text if x_msg_count is 1.
123 *
124 * NOTES
125 *
126 * MODIFICATION HISTORY
127 *
128 * 17-Jul-2002 Kate Shan o Created.
129 *
130 */
131
132 PROCEDURE get_style_fmt_locale_rec (
133 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
134 p_style_fmt_locale_id IN NUMBER,
135 x_style_fmt_locale_rec OUT NOCOPY STYLE_FMT_LOCALE_REC_TYPE,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_data OUT NOCOPY VARCHAR2
139 );
140
141 END HZ_STYLE_FMT_LOCALE_V2PUB;