[Home] [Help]
PACKAGE: APPS.AHL_PC_ASSOCIATION_PUB
Source
1 PACKAGE AHL_PC_ASSOCIATION_PUB AUTHID CURRENT_USER AS
2 /* $Header: AHLPPCAS.pls 120.0 2005/05/26 01:47:48 appldev noship $ */
3 /*#
4 * This is the public interface to associate the Product Classification with Units/Parts
5 * @rep:scope public
6 * @rep:product AHL
7 * @rep:displayname Units/Parts Association
8 * @rep:lifecycle active
9 * @rep:category BUSINESS_ENTITY AHL_PROD_CLASS
10 */
11
12 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PC_ASSOCIATION_PUB';
13
14 -----------------------------------------------------------------
15 -- Define Record Type for Product Classification Node Record --
16 -----------------------------------------------------------------
17 TYPE PC_ASSOS_REC IS RECORD (
18 PC_ASSOCIATION_ID NUMBER := NULL,
19 OBJECT_VERSION_NUMBER NUMBER := NULL,
20 PC_NODE_ID NUMBER := NULL,
21 UNIT_ITEM_ID NUMBER := NULL,
22 UNIT_ITEM_NAME VARCHAR2(240) := NULL,
23 ASSOCIATION_TYPE_FLAG VARCHAR2(1) := NULL,
24 OPERATION_STATUS_FLAG VARCHAR2(1) := NULL,
25 DRAFT_FLAG VARCHAR2(1) := NULL,
26 INVENTORY_ORG_ID NUMBER := NULL,
27 LINK_TO_ASSOCIATION_ID NUMBER := NULL,
28 ATTRIBUTE_CATEGORY VARCHAR2(30) := NULL,
29 ATTRIBUTE1 VARCHAR2(150) := NULL,
30 ATTRIBUTE2 VARCHAR2(150) := NULL,
31 ATTRIBUTE3 VARCHAR2(150) := NULL,
32 ATTRIBUTE4 VARCHAR2(150) := NULL,
33 ATTRIBUTE5 VARCHAR2(150) := NULL,
34 ATTRIBUTE6 VARCHAR2(150) := NULL,
35 ATTRIBUTE7 VARCHAR2(150) := NULL,
36 ATTRIBUTE8 VARCHAR2(150) := NULL,
37 ATTRIBUTE9 VARCHAR2(150) := NULL,
38 ATTRIBUTE10 VARCHAR2(150) := NULL,
39 ATTRIBUTE11 VARCHAR2(150) := NULL,
40 ATTRIBUTE12 VARCHAR2(150) := NULL,
41 ATTRIBUTE13 VARCHAR2(150) := NULL,
42 ATTRIBUTE14 VARCHAR2(150) := NULL,
43 ATTRIBUTE15 VARCHAR2(150) := NULL,
44 OPERATION_FLAG VARCHAR2(1) := NULL
45 );
46
47 ---------------------------------
48 -- Define Table Type for Node --
49 ---------------------------------
50 TYPE PC_ASSOS_TBL IS TABLE OF AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC INDEX BY BINARY_INTEGER;
51
52 ------------------------
53 -- Declare Procedures --
54 ------------------------
55 -- Start of Comments --
56 --
57 -- Procedure name : PROCESS_ASSOCIATION
58 -- Type : Public
59 -- Function : Processes Product Classification Associations with Units/Parts.
60 -- Pre-reqs :
61 --
62 -- Standard IN Parameters :
63 -- p_api_version IN NUMBER Required
64 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
65 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
66 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
67 --
68 -- Standard OUT Parameters :
69 -- x_return_status OUT VARCHAR2 Required
70 -- x_msg_count OUT NUMBER Required
71 -- x_msg_data OUT VARCHAR2 Required
72 --
73 -- PROCESS_TEMP_NODES Parameters :
74 -- p_x_assos_tbl IN OUT PC_ASSOS_TBL Required
75 -- For every node record in the node table :
76 --
77 -- Version :
78 -- Initial Version 1.0
79 --
80 -- End of Comments --
81
82 /*#
83 * It allows association of Units/Parts to the Product Classification
84 * @param p_api_version Api Version Number
85 * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
86 * @param p_commit To decide whether to commit the transaction, default value FND_API.G_FALSE
87 * @param p_validation_level Validation level, default value FND_API.G_VALID_LEVEL_FULL
88 * @param p_module_type whether 'API'or 'JSP', default value NULL
89 * @param p_x_assos_tbl Product Classification table of type PC_ASSOS_TBL
90 * @param x_return_status Return status,,Standard API parameter
91 * @param x_msg_count Return message count,Standard API parameter
92 * @param x_msg_data Return message data,Standard API parameter
93 * @rep:scope public
94 * @rep:lifecycle active
95 * @rep:displayname Process Units/Parts Association
96 */
97 PROCEDURE PROCESS_ASSOCIATIONS (
98 p_api_version IN NUMBER,
99 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
100 p_commit IN VARCHAR2 := FND_API.G_FALSE,
101 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
102 p_module_type IN VARCHAR2 := NULL,
103 p_x_assos_tbl IN OUT NOCOPY AHL_PC_ASSOCIATION_PUB.PC_ASSOS_TBL,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2
107 );
108
109 -- Start of Comments --
110 --
111 -- Procedure name : PROCESS_DOCUMENT
112 -- Type : Private
113 -- Function : Creates/Modifies a document association with a PC node.
114 -- Pre-reqs :
115 --
116 -- Standard IN Parameters :
117 -- p_api_version IN NUMBER Required
118 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
119 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
120 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
121 --
122 -- Standard OUT Parameters :
123 -- x_return_status OUT VARCHAR2 Required
124 -- x_msg_count OUT NUMBER Required
125 -- x_msg_data OUT VARCHAR2 Required
126 --
127 -- PROCESS_DOCUMENT Parameters :
128 -- p_x_assos_tbl IN OUT AHL_DI_ASSO_DOC_GEN_PUB.association_tbl Required
129 --
130 -- Version :
131 -- Initial Version 1.0
132 --
133 -- End of Comments --
134
135 PROCEDURE PROCESS_DOCUMENT (
136 p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138 p_commit IN VARCHAR2 := FND_API.G_FALSE,
139 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140 p_module_type IN VARCHAR2 := NULL,
141 p_x_assos_tbl IN OUT NOCOPY AHL_DI_ASSO_DOC_GEN_PUB.association_tbl,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2
145 );
146
147 END AHL_PC_ASSOCIATION_PUB;