[Home] [Help]
PACKAGE: APPS.AHL_PC_ASSOCIATION_PVT
Source
1 PACKAGE AHL_PC_ASSOCIATION_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVPCAS.pls 115.6 2003/07/29 10:09:59 rroy noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PC_ASSOCIATION_PVT';
5
6 G_USER_ID CONSTANT NUMBER := TO_NUMBER(FND_GLOBAL.LOGIN_ID);
7
8 G_DML_CREATE CONSTANT VARCHAR2(1) := 'C';
9 G_DML_UPDATE CONSTANT VARCHAR2(1) := 'U';
10 G_DML_DELETE CONSTANT VARCHAR2(1) := 'D';
11 G_DML_COPY CONSTANT VARCHAR2(1) := 'X';
12 G_DML_ASSIGN CONSTANT VARCHAR2(1) := 'A';
13 G_DML_LINK CONSTANT VARCHAR2(1) := 'L';
14
15 G_UNIT CONSTANT VARCHAR2(1) := 'U';
16 G_PART CONSTANT VARCHAR2(1) := 'I';
17
18 ------------------------
19 -- Declare Procedures --
20 ------------------------
21 -- Start of Comments --
22 --
23 -- Procedure name : ATTACH_UNIT
24 -- Type : Private
25 -- Function : Attached a Unit to a Product Classification Node.
26 -- Pre-reqs :
27 --
28 -- Standard IN Parameters :
29 -- p_api_version IN NUMBER Required
30 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
31 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
32 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
33 --
34 -- Standard OUT Parameters :
35 -- x_return_status OUT VARCHAR2 Required
36 -- x_msg_count OUT NUMBER Required
37 -- x_msg_data OUT VARCHAR2 Required
38 --
39 -- CREATE_ASSOCIATIONS Parameters :
40 -- p_x_assos_rec IN OUT PC_ASSOS_REC Required
41 --
42 -- Version :
43 -- Initial Version 1.0
44 --
45 -- End of Comments --
46 PROCEDURE ATTACH_UNIT (
47 p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49 p_commit IN VARCHAR2 := FND_API.G_FALSE,
50 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51 p_x_assos_rec IN OUT NOCOPY AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2
55 );
56
57 -- Start of Comments --
58 --
59 -- Procedure name : DETACH_UNIT
60 -- Type : Private
61 -- Function : Detaches a Unit from a Product Classification Node.
62 -- Pre-reqs :
63 --
64 -- Standard IN Parameters :
65 -- p_api_version IN NUMBER Required
66 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
67 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
68 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
69 --
70 -- Standard OUT Parameters :
71 -- x_return_status OUT VARCHAR2 Required
72 -- x_msg_count OUT NUMBER Required
73 -- x_msg_data OUT VARCHAR2 Required
74 --
75 -- UPDATE_ASSOCIATIONS Parameters :
76 -- p_x_assos_rec IN OUT PC_ASSOS_REC Required
77 --
78 -- Version :
79 -- Initial Version 1.0
80 --
81 -- End of Comments --
82 PROCEDURE DETACH_UNIT (
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85 p_commit IN VARCHAR2 := FND_API.G_FALSE,
86 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87 p_x_assos_rec IN OUT NOCOPY AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2
91 );
92
93 -- Start of Comments --
94 --
95 -- Procedure name : ATTACH_ITEM
96 -- Type : Private
97 -- Function : Attaches an Item to a Product Classification Node.
98 -- Pre-reqs :
99 --
100 -- Standard IN Parameters :
101 -- p_api_version IN NUMBER Required
102 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
103 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
104 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
105 --
106 -- Standard OUT Parameters :
107 -- x_return_status OUT VARCHAR2 Required
108 -- x_msg_count OUT NUMBER Required
109 -- x_msg_data OUT VARCHAR2 Required
110 --
111 -- DELETE_ASSOCIATIONS Parameters :
112 -- p_x_assos_rec IN OUT PC_ASSOS_REC Required
113 --
114 -- Version :
115 -- Initial Version 1.0
116 --
117 -- End of Comments --
118 PROCEDURE ATTACH_ITEM (
119 p_api_version IN NUMBER,
120 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
121 p_commit IN VARCHAR2 := FND_API.G_FALSE,
122 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
123 p_x_assos_rec IN OUT NOCOPY AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2
127 );
128
129 -- Start of Comments --
130 --
131 -- Procedure name : DETACH_ITEM
132 -- Type : Private
133 -- Function : Detaches an Item from a Product Classification Node.
134 -- Pre-reqs :
135 --
136 -- Standard IN Parameters :
137 -- p_api_version IN NUMBER Required
138 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
139 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
140 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
141 --
142 -- Standard OUT Parameters :
143 -- x_return_status OUT VARCHAR2 Required
144 -- x_msg_count OUT NUMBER Required
145 -- x_msg_data OUT VARCHAR2 Required
146 --
147 -- DELETE_ASSOCIATIONS Parameters :
148 -- p_x_assos_rec IN OUT PC_ASSOS_REC Required
149 --
150 -- Version :
151 -- Initial Version 1.0
152 --
153 -- End of Comments --
154 PROCEDURE DETACH_ITEM (
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
157 p_commit IN VARCHAR2 := FND_API.G_FALSE,
158 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159 p_x_assos_rec IN OUT NOCOPY AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC,
160 x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2
163 );
164
165 -- Start of Comments --
166 --
167 -- Procedure name : PROCESS_DOCUMENT
168 -- Type : Private
169 -- Function : Creates/Modifies a document association with a PC node.
170 -- Pre-reqs :
171 --
172 -- Standard IN Parameters :
173 -- p_api_version IN NUMBER Required
174 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
175 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
176 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
177 --
178 -- Standard OUT Parameters :
179 -- x_return_status OUT VARCHAR2 Required
180 -- x_msg_count OUT NUMBER Required
181 -- x_msg_data OUT VARCHAR2 Required
182 --
183 -- PROCESS_DOCUMENT Parameters :
184 -- p_x_assos_tblc IN OUT AHL_DI_ASSO_DOC_ASO_PUB.association_tbl Required
185 -- p_x_assos_tblm IN OUT AHL_DI_ASSO_DOC_ASO_PUB.association_tbl Required
186 --
187 -- Version :
188 -- Initial Version 1.0
189 --
190 -- End of Comments --
191 PROCEDURE PROCESS_DOCUMENT (
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
194 p_commit IN VARCHAR2 := FND_API.G_FALSE,
195 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
196 p_module_type IN VARCHAR2 := NULL,
197 p_x_assos_tbl IN OUT NOCOPY AHL_DI_ASSO_DOC_GEN_PUB.association_tbl,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2
201 );
202
203 END AHL_PC_ASSOCIATION_PVT;