[Home] [Help]
PACKAGE BODY: APPS.HZ_PARTY_USG_ASSIGNMENT_PUB
Source
1 PACKAGE BODY HZ_PARTY_USG_ASSIGNMENT_PUB AS
2 /*$Header: ARHPUASB.pls 120.0 2005/05/23 22:22:04 jhuang noship $ */
3
4 --------------------------------------
5 -- private global variable
6 --------------------------------------
7
8 G_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'HZ_PARTY_USG_ASSIGNMENT_PUB';
9
10 --------------------------------------
11 -- public procedures and functions
12 --------------------------------------
13
14 /**
15 * PROCEDURE assign_party_usage
16 *
17 * DESCRIPTION
18 * Creates party usage assignment.
19 *
20 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
21 *
22 * ARGUMENTS
23 * IN:
24 * p_init_msg_list Initialize message stack if it is set to
25 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
26 * p_party_usg_assignment_rec Party usage assignment record.
27 * IN/OUT:
28 * OUT:
29 * x_return_status Return status after the call. The status can
30 * be FND_API.G_RET_STS_SUCCESS (success),
31 * FND_API.G_RET_STS_ERROR (error),
32 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
33 * x_msg_count Number of messages in message stack.
34 * x_msg_data Message text if x_msg_count is 1.
35 *
36 * NOTES
37 *
38 * MODIFICATION HISTORY
39 *
40 * 05/01/05 Jianying Huang o Created.
41 *
42 */
43
44 PROCEDURE assign_party_usage (
45 p_init_msg_list IN VARCHAR2,
46 p_party_usg_assignment_rec IN HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2
50 ) IS
51
52 BEGIN
53
54 HZ_PARTY_USG_ASSIGNMENT_PVT.set_calling_api(G_PACKAGE_NAME);
55
56 HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage (
57 p_init_msg_list => p_init_msg_list,
58 p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_FULL,
59 p_party_usg_assignment_rec => p_party_usg_assignment_rec,
60 x_return_status => x_return_status,
61 x_msg_count => x_msg_count,
62 x_msg_data => x_msg_data
63 );
64
65 END assign_party_usage;
66
67
68 /**
69 * PROCEDURE inactivate_usg_assignment
70 *
71 * DESCRIPTION
72 * Inactivates party usage assignment.
73 *
74 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
75 *
76 * ARGUMENTS
77 * IN:
78 * p_init_msg_list Initialize message stack if it is set to
79 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
80 * p_party_usg_assignment_id Party usage assignment Id.
81 * p_party_id Party Id
82 * p_party_usage_code Party usage code
83 * IN/OUT:
84 * OUT:
85 * x_return_status Return status after the call. The status can
86 * be FND_API.G_RET_STS_SUCCESS (success),
87 * FND_API.G_RET_STS_ERROR (error),
88 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
89 * x_msg_count Number of messages in message stack.
90 * x_msg_data Message text if x_msg_count is 1.
91 *
92 * NOTES
93 *
94 * MODIFICATION HISTORY
95 *
96 * 05/01/05 Jianying Huang o Created.
97 *
98 */
99
100 PROCEDURE inactivate_usg_assignment (
101 p_init_msg_list IN VARCHAR2,
102 p_party_usg_assignment_id IN NUMBER,
103 p_party_id IN NUMBER,
104 p_party_usage_code IN VARCHAR2,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2
108 ) IS
109
110 BEGIN
111
112 HZ_PARTY_USG_ASSIGNMENT_PVT.set_calling_api(G_PACKAGE_NAME);
113
114 HZ_PARTY_USG_ASSIGNMENT_PVT.inactivate_usg_assignment (
115 p_init_msg_list => p_init_msg_list,
116 p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_FULL,
117 p_party_id => p_party_id,
118 p_party_usage_code => p_party_usage_code,
119 x_return_status => x_return_status,
120 x_msg_count => x_msg_count,
121 x_msg_data => x_msg_data
122 );
123
124 END inactivate_usg_assignment;
125
126
127 /**
128 * PROCEDURE update_usg_assignment
129 *
130 * DESCRIPTION
131 * Update party usage assignment.
132 *
133 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
134 *
135 * ARGUMENTS
136 * IN:
137 * p_init_msg_list Initialize message stack if it is set to
138 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
139 * p_party_usg_assignment_rec Party usage assignment record.
140 * IN/OUT:
141 * OUT:
142 * x_return_status Return status after the call. The status can
143 * be FND_API.G_RET_STS_SUCCESS (success),
144 * FND_API.G_RET_STS_ERROR (error),
145 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
146 * x_msg_count Number of messages in message stack.
147 * x_msg_data Message text if x_msg_count is 1.
148 *
149 * NOTES
150 *
151 * MODIFICATION HISTORY
152 *
153 * 05/01/05 Jianying Huang o Created.
154 *
155 */
156
157 PROCEDURE update_usg_assignment (
158 p_init_msg_list IN VARCHAR2,
159 p_party_usg_assignment_id IN NUMBER,
160 p_party_usg_assignment_rec IN HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2
164 ) IS
165
166 BEGIN
167
168 HZ_PARTY_USG_ASSIGNMENT_PVT.set_calling_api(G_PACKAGE_NAME);
169
170 HZ_PARTY_USG_ASSIGNMENT_PVT.update_usg_assignment (
171 p_init_msg_list => p_init_msg_list,
172 p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_FULL,
173 p_party_usg_assignment_id => p_party_usg_assignment_id,
174 p_party_usg_assignment_rec => p_party_usg_assignment_rec,
175 x_return_status => x_return_status,
176 x_msg_count => x_msg_count,
177 x_msg_data => x_msg_data
178 );
179
180 END update_usg_assignment;
181
182
183 END HZ_PARTY_USG_ASSIGNMENT_PUB;