[Home] [Help]
PACKAGE: APPS.AHL_PC_NODE_PUB
Source
1 PACKAGE AHL_PC_NODE_PUB AS
2 /* $Header: AHLPPCNS.pls 120.0 2005/05/26 11:00:56 appldev noship $ */
3 /*#
4 * This is the public interface to Create /Modify and Delete Product Classification Nodes
5 * depending on the flag that is being passed
6 * @rep:scope public
7 * @rep:product AHL
8 * @rep:displayname Product Classification Nodes
9 * @rep:lifecycle active
10 * @rep:category BUSINESS_ENTITY AHL_PROD_CLASS
11 */
12
13 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PC_NODE_PUB';
14
15 G_DML_CREATE CONSTANT VARCHAR2(1) := 'C';
16 G_DML_UPDATE CONSTANT VARCHAR2(1) := 'U';
17 G_DML_DELETE CONSTANT VARCHAR2(1) := 'D';
18 G_DML_COPY CONSTANT VARCHAR2(1) := 'X';
19 G_DML_ASSIGN CONSTANT VARCHAR2(1) := 'A';
20 G_DML_LINK CONSTANT VARCHAR2(1) := 'L';
21
22 -----------------------------------------------------------------
23 -- Define Record Type for Product Classification Node Record --
24 -----------------------------------------------------------------
25 TYPE PC_NODE_REC IS RECORD (
26 PC_NODE_ID NUMBER := NULL,
27 OBJECT_VERSION_NUMBER NUMBER := NULL,
28 NAME VARCHAR2(240) := NULL,
29 DESCRIPTION VARCHAR2(2000) := NULL,
30 PC_HEADER_ID NUMBER := NULL,
31 PARENT_NODE_ID NUMBER := NULL,
32 CHILD_COUNT NUMBER := NULL,
33 OPERATION_STATUS_FLAG VARCHAR2(1) := NULL,
34 DRAFT_FLAG VARCHAR2(1) := NULL,
35 LINK_TO_NODE_ID NUMBER := NULL,
36 ATTRIBUTE_CATEGORY VARCHAR2(30) := NULL,
37 ATTRIBUTE1 VARCHAR2(150) := NULL,
38 ATTRIBUTE2 VARCHAR2(150) := NULL,
39 ATTRIBUTE3 VARCHAR2(150) := NULL,
40 ATTRIBUTE4 VARCHAR2(150) := NULL,
41 ATTRIBUTE5 VARCHAR2(150) := NULL,
42 ATTRIBUTE6 VARCHAR2(150) := NULL,
43 ATTRIBUTE7 VARCHAR2(150) := NULL,
44 ATTRIBUTE8 VARCHAR2(150) := NULL,
45 ATTRIBUTE9 VARCHAR2(150) := NULL,
46 ATTRIBUTE10 VARCHAR2(150) := NULL,
47 ATTRIBUTE11 VARCHAR2(150) := NULL,
48 ATTRIBUTE12 VARCHAR2(150) := NULL,
49 ATTRIBUTE13 VARCHAR2(150) := NULL,
50 ATTRIBUTE14 VARCHAR2(150) := NULL,
51 ATTRIBUTE15 VARCHAR2(150) := NULL,
52 OPERATION_FLAG VARCHAR2(1) := NULL
53 );
54
55 ---------------------------------
56 -- Define Table Type for Node --
57 ---------------------------------
58 TYPE PC_NODE_TBL IS TABLE OF AHL_PC_NODE_PUB.PC_NODE_REC INDEX BY BINARY_INTEGER;
59
60 ------------------------
61 -- Declare Procedures --
62 ------------------------
63 -- Start of Comments --
64 --
65 -- Procedure name : PROCESS_NODES
66 -- Type : Public
67 -- Function : Processes Product Classification Nodes.
68 -- Pre-reqs :
69 --
70 -- Standard IN Parameters :
71 -- p_api_version IN NUMBER 1.0 Required
72 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
73 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
74 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
75 --
76 -- Standard OUT Parameters :
77 -- x_return_status OUT VARCHAR2 Required
78 -- x_msg_count OUT NUMBER Required
79 -- x_msg_data OUT VARCHAR2 Required
80 --
81 -- PROCESS_TEMP_NODES Parameters :
82 -- p_x_node_tbl IN OUT PC_NODE_TBL Required
83 -- For every node record in the node table :
84 -- PC_HEADER_ID Required and existing in AHL_PC_HEADERS_VL
85 -- PC_NODE_ID Required / Optional depending on operation
86 -- PC_PARENT_NODE_ID Required [Optional for root node]
87 -- PC_NODE_NAME Required
88 -- PC_NODE_DESCRIPTION Optional
89 -- NODE_CHILD_COUNT Required for Update, Default 0 for Create
90 -- OPERATION_FLAG Required, C - Create, U - Update, D - Delete, X - Copy, A - Assign, L - Link
91 --
92 -- Version :
93 -- Initial Version 1.0
94 --
95 -- End of Comments --
96 /*#
97 * It Creates,Modifies and Deletes Product Classification Nodes.
98 * @param p_api_version Api Version Number
99 * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
100 * @param p_commit To decide whether to commit the transaction, default value FND_API.G_FALSE
101 * @param p_validation_level Validation level, default value FND_API.G_VALID_LEVEL_FULL
102 * @param p_module_type whether 'API'or 'JSP', default value NULL
103 * @param p_x_nodes_tbl Product Classification table of type PC_NODE_TBL
104 * @param x_return_status Return status,Standard API parameter
105 * @param x_msg_count Return message count,Standard API parameter
106 * @param x_msg_data Return message data,Standard API parameter
107 * @rep:scope public
108 * @rep:lifecycle active
109 * @rep:displayname Process PC Nodes
110 */
111 PROCEDURE PROCESS_NODES (
112 p_api_version IN NUMBER,
113 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
114 p_commit IN VARCHAR2 := FND_API.G_FALSE,
115 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
116 p_module_type IN VARCHAR2 := NULL,
117 p_x_nodes_tbl IN OUT NOCOPY AHL_PC_NODE_PUB.PC_NODE_TBL,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2
121 );
122
123
124 END AHL_PC_NODE_PUB;