[Home] [Help]
PACKAGE: APPS.HZ_STYLE_FMT_LAYOUT_V2PUB
Source
1 PACKAGE HZ_STYLE_FMT_LAYOUT_V2PUB AUTHID CURRENT_USER AS
2 /*$Header: ARH2FLSS.pls 115.3 2002/11/21 06:05:10 sponnamb noship $ */
3
4 --------------------------------------
5 -- declaration of record type
6 --------------------------------------
7
8 TYPE style_fmt_layout_rec_type IS RECORD (
9 style_fmt_layout_id NUMBER,
10 style_format_code VARCHAR2(30),
11 variation_number NUMBER,
12 attribute_code VARCHAR2(30),
13 attribute_application_id NUMBER,
14 line_number NUMBER,
15 position NUMBER,
16 mandatory_flag VARCHAR2(1),
17 use_initial_flag VARCHAR2(1),
18 uppercase_flag VARCHAR2(1),
19 transform_function VARCHAR2(100),
20 delimiter_before VARCHAR2(20),
21 delimiter_after VARCHAR2(20),
22 blank_lines_before NUMBER,
23 blank_lines_after NUMBER,
24 prompt VARCHAR2(30),
25 start_date_active DATE,
26 end_date_active DATE
27 );
28
29 --------------------------------------
30 -- declaration of public procedures and functions
31 --------------------------------------
32
33 /**
34 * PROCEDURE create_style_fmt_layout
35 *
36 * DESCRIPTION
37 * Creates style_fmt_layout.
38 *
39 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
40 *
41 * ARGUMENTS
42 * IN:
43 * p_init_msg_list Initialize message stack if it is set to
44 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
45 * p_style_fmt_layout_rec Style record.
46 * IN/OUT:
47 * OUT:
48 * p_style_fmt_layout_id style_fmt_layout id
49 * x_return_status Return status after the call. The status can
50 * be FND_API.G_RET_STS_SUCCESS (success),
51 * FND_API.G_RET_STS_ERROR (error),
52 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
53 * x_msg_count Number of messages in message stack.
54 * x_msg_data Message text if x_msg_count is 1.
55 *
56 * NOTES
57 *
58 * MODIFICATION HISTORY
59 *
60 * 17-Jul-2002 Kate Shan o Created.
61 *
62 */
63
64 PROCEDURE create_style_fmt_layout (
65 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
66 p_style_fmt_layout_rec IN STYLE_FMT_LAYOUT_REC_TYPE,
67 x_style_fmt_layout_id OUT NOCOPY NUMBER,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2
71 );
72
73 /**
74 * PROCEDURE update_style_fmt_layout
75 *
76 * DESCRIPTION
77 * Updates style_fmt_layout.
78 *
79 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
80 *
81 * ARGUMENTS
82 * IN:
83 * p_init_msg_list Initialize message stack if it is set to
84 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
85 * p_style_fmt_layout_rec Style record.
86 * IN/OUT:
87 * p_object_version_number Used for locking the being updated record.
88 * OUT:
89 * x_return_status Return status after the call. The status can
90 * be FND_API.G_RET_STS_SUCCESS (success),
91 * FND_API.G_RET_STS_ERROR (error),
92 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
93 * x_msg_count Number of messages in message stack.
94 * x_msg_data Message text if x_msg_count is 1.
95 *
96 * NOTES
97 *
98 * MODIFICATION HISTORY
99 *
100 * 17-Jul-2002 Kate Shan o Created.
101 *
102 */
103
104 PROCEDURE update_style_fmt_layout (
105 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
106 p_style_fmt_layout_rec IN STYLE_FMT_LAYOUT_REC_TYPE,
107 p_object_version_number IN OUT NOCOPY NUMBER,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2
111 );
112
113
114 /**
115 * PROCEDURE get_style_fmt_layout_rec
116 *
117 * DESCRIPTION
118 * Gets style_fmt_layout record.
119 *
120 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
121 *
122 * ARGUMENTS
123 * IN:
124 * p_init_msg_list Initialize message stack if it is set to
125 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
126 * p_style_fmt_layout_code Style Code.
127 * IN/OUT:
128 * OUT:
129 * x_style_fmt_layout_rec Style record.
130 * x_return_status Return status after the call. The status can
131 * be FND_API.G_RET_STS_SUCCESS (success),
132 * FND_API.G_RET_STS_ERROR (error),
133 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
134 * x_msg_count Number of messages in message stack.
135 * x_msg_data Message text if x_msg_count is 1.
136 *
137 * NOTES
138 *
139 * MODIFICATION HISTORY
140 *
141 * 17-Jul-2002 Kate Shan o Created.
142 *
143 */
144
145 PROCEDURE get_style_fmt_layout_rec (
146 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
147 p_style_fmt_layout_id IN NUMBER,
148 x_style_fmt_layout_rec OUT NOCOPY STYLE_FMT_LAYOUT_REC_TYPE,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2
152 );
153
154 END HZ_STYLE_FMT_LAYOUT_V2PUB;