[Home] [Help]
PACKAGE: APPS.HZ_STYLE_FMT_VARIATION_V2PUB
Source
1 PACKAGE HZ_STYLE_FMT_VARIATION_V2PUB AUTHID CURRENT_USER AS
2 /*$Header: ARH2SVSS.pls 115.2 2002/11/21 06:10:51 sponnamb noship $ */
3
4 --------------------------------------
5 -- declaration of record type
6 --------------------------------------
7
8 TYPE style_fmt_variation_rec_type IS RECORD (
9 style_format_code VARCHAR2(30),
10 variation_number NUMBER,
11 variation_rank NUMBER,
12 selection_condition VARCHAR2(240) ,
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_variation
23 *
24 * DESCRIPTION
25 * Creates style_fmt_variation.
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_variation_rec Style record.
34 * IN/OUT:
35 * OUT:
36 * p_style_fmt_variation_id style_fmt_variation 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_variation (
53 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54 p_style_fmt_variation_rec IN STYLE_FMT_VARIATION_REC_TYPE,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2
58 );
59
60 /**
61 * PROCEDURE update_style_fmt_variation
62 *
63 * DESCRIPTION
64 * Updates style_fmt_variation.
65 *
66 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
67 *
68 * ARGUMENTS
69 * IN:
70 * p_init_msg_list Initialize message stack if it is set to
71 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
72 * p_style_fmt_variation_rec Style record.
73 * IN/OUT:
74 * p_object_version_number Used for locking the being updated record.
75 * OUT:
76 * x_return_status Return status after the call. The status can
77 * be FND_API.G_RET_STS_SUCCESS (success),
78 * FND_API.G_RET_STS_ERROR (error),
79 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
80 * x_msg_count Number of messages in message stack.
81 * x_msg_data Message text if x_msg_count is 1.
82 *
83 * NOTES
84 *
85 * MODIFICATION HISTORY
86 *
87 * 17-Jul-2002 Kate Shan o Created.
88 *
89 */
90
91 PROCEDURE update_style_fmt_variation (
92 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
93 p_style_fmt_variation_rec IN STYLE_FMT_VARIATION_REC_TYPE,
94 p_object_version_number IN OUT NOCOPY NUMBER,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2
98 );
99
100 /**
101 * PROCEDURE get_style_fmt_variation_rec
102 *
103 * DESCRIPTION
104 * Gets style_fmt_variation record.
105 *
106 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
107 *
108 * ARGUMENTS
109 * IN:
110 * p_init_msg_list Initialize message stack if it is set to
111 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
112 * p_style_fmt_variation_code Style Code.
113 * IN/OUT:
114 * OUT:
115 * x_style_fmt_variation_rec Style record.
116 * x_return_status Return status after the call. The status can
117 * be FND_API.G_RET_STS_SUCCESS (success),
118 * FND_API.G_RET_STS_ERROR (error),
119 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
120 * x_msg_count Number of messages in message stack.
121 * x_msg_data Message text if x_msg_count is 1.
122 *
123 * NOTES
124 *
125 * MODIFICATION HISTORY
126 *
127 * 17-Jul-2002 Kate Shan o Created.
128 *
129 */
130
131 PROCEDURE get_style_fmt_variation_rec (
132 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133 p_style_format_code IN VARCHAR2,
134 p_variation_number IN NUMBER,
135 x_style_fmt_variation_rec OUT NOCOPY STYLE_FMT_VARIATION_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
142 END HZ_STYLE_FMT_VARIATION_V2PUB;