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