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