[Home] [Help]
PACKAGE: APPS.AHL_PC_NODE_PVT
Source
1 PACKAGE AHL_PC_NODE_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVPCNS.pls 115.4 2002/12/02 14:31:01 pbarman noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PC_NODE_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 : CREATE_NODE
24 -- Type : Private
25 -- Function : Creates a new 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_NODES Parameters :
40 -- p_x_node_rec IN OUT PC_NODE_REC Required
41 --
42 -- Version :
43 -- Initial Version 1.0
44 --
45 -- End of Comments --
46 PROCEDURE CREATE_NODE (
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_node_rec IN OUT NOCOPY AHL_PC_NODE_PUB.PC_NODE_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 : UPDATE_NODE
60 -- Type : Private
61 -- Function : Updates an existing 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_NODES Parameters :
76 -- p_x_node_rec IN OUT PC_NODE_REC Required
77 --
78 -- Version :
79 -- Initial Version 1.0
80 --
81 -- End of Comments --
82 PROCEDURE UPDATE_NODE (
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_node_rec IN OUT NOCOPY AHL_PC_NODE_PUB.PC_NODE_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 : DELETE_NODES
96 -- Type : Private
97 -- Function : Deletes existing 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_NODES Parameters :
112 -- p_x_node_rec IN OUT PC_NODE_REC Required
113 --
114 -- Version :
115 -- Initial Version 1.0
116 --
117 -- End of Comments --
118 PROCEDURE DELETE_NODES (
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_node_rec IN OUT NOCOPY AHL_PC_NODE_PUB.PC_NODE_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 END AHL_PC_NODE_PVT;