DBA Data[Home] [Help]

PACKAGE: APPS.AHL_MC_NODE_PUB

Source


1 PACKAGE AHL_MC_Node_PUB AS
2 /* $Header: AHLPNODS.pls 120.0 2005/05/25 23:39:12 appldev noship $ */
3 /*#
4  * This is the public package that handles creation/modification/deletion of Master Configurations Nodes
5  * @rep:scope public
6  * @rep:product AHL
7  * @rep:displayname Master Configuration
8  * @rep:lifecycle active
9  * @rep:category BUSINESS_ENTITY AHL_MASTER_CONFIG
10  */
11 
12 G_PKG_NAME 	CONSTANT 	VARCHAR2(30) 	:= 'AHL_MC_Node_PUB';
13 
14 G_DML_CREATE 	CONSTANT 	VARCHAR2(1) 	:= 'C';
15 G_DML_UPDATE 	CONSTANT 	VARCHAR2(1) 	:= 'U';
16 G_DML_DELETE 	CONSTANT 	VARCHAR2(1) 	:= 'D';
17 
18 -----------------------
19 -- Define procedures --
20 -----------------------
21 --  Start of Comments  --
22 --
23 --  Procedure name    	: Process_Node
24 --  Type        	: Public
25 --  Function    	: Handles creation, updation and deletion of Master Configuration nodes
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 --	p_module_type		IN	VARCHAR2	Default 'JSP'
34 --
35 --  Standard OUT Parameters :
36 --      x_return_status		OUT     VARCHAR2	Required
37 --      x_msg_count		OUT     NUMBER		Required
38 --      x_msg_data		OUT     VARCHAR2	Required
39 --
40 --  Process_Node Parameters :
41 --      p_x_node_rec		IN	AHL_MC_Node_PVT.Node_Rec_Type
42 --	p_x_counter_rules_tbl	IN	AHL_MC_Node_PVT.Counter_Rules_Tbl_Type
43 --	p_x_subconfig_tbl	IN	AHL_MC_Node_PVT.SubConfig_Tbl_Type
44 --
45 --  Version :
46 --  	Initial Version   	1.0
47 --
48 --  End of Comments  --
49 /*#
50  * It handles creation , updation and deletion of Master Configurations nodes.
51  * @param p_api_version Api Version Number
52  * @param p_init_msg_list Initialize the message stack, default value FND_API.G_FALSE
53  * @param p_commit To decide whether to commit the transaction, default value FND_API.G_FALSE
54  * @param p_validation_level Validation level, default value FND_API.G_VALID_LEVEL_FULL
55  * @param p_module_type For Internal use only, default value 'JSP'
56  * @param x_return_status Return status,Standard API parameter
57  * @param x_msg_count Return message count,Standard API parameter
58  * @param x_msg_data Return message data,Standard API parameter
59  * @param p_x_node_rec Master Configuration record of type AHL_MC_Node_PVT.Node_Rec_Type
60  * @param p_x_counter_rules_tbl Node Rule record of type AHL_MC_Node_PVT.Counter_Rules_Tbl_Type
61  * @param p_x_subconfig_tbl Sub-Configuration node record of type AHL_MC_Node_PVT.SubConfig_Tbl_Type
62  * @rep:scope public
63  * @rep:lifecycle active
64  * @rep:displayname Process Master Configuration Node
65  */
66 PROCEDURE Process_Node
67 (
68 	p_api_version		IN 		NUMBER,
69 	p_init_msg_list       	IN 		VARCHAR2	:= FND_API.G_FALSE,
70 	p_commit              	IN 		VARCHAR2 	:= FND_API.G_FALSE,
71 	p_validation_level    	IN 		NUMBER 		:= FND_API.G_VALID_LEVEL_FULL,
72 	p_module_type		IN		VARCHAR2	:= 'JSP',
73 	x_return_status       	OUT 	NOCOPY  VARCHAR2,
74 	x_msg_count           	OUT 	NOCOPY  NUMBER,
75 	x_msg_data            	OUT 	NOCOPY  VARCHAR2,
76 	p_x_node_rec 	    	IN OUT 	NOCOPY 	AHL_MC_Node_PVT.Node_Rec_Type,
77 	p_x_counter_rules_tbl  	IN OUT 	NOCOPY 	AHL_MC_Node_PVT.Counter_Rules_Tbl_Type,
78 	p_x_subconfig_tbl     	IN OUT 	NOCOPY 	AHL_MC_Node_PVT.SubConfig_Tbl_Type
79 );
80 
81 --  Start of Comments  --
82 --
83 --  Procedure name    	: Delete_Nodes
84 --  Type        	: Private
85 --  Function    	: Deletes Master Configuration nodes
86 --  Pre-reqs    	:
87 --
88 --  Standard IN  Parameters :
89 --      p_api_version		IN	NUMBER                	Required
90 --      p_init_msg_list		IN      VARCHAR2     	Default FND_API.G_FALSE
91 --      p_commit		IN      VARCHAR2     	Default FND_API.G_FALSE
92 --      p_validation_level	IN      NUMBER       	Default FND_API.G_VALID_LEVEL_FULL
93 --
94 --  Standard OUT Parameters :
95 --      x_return_status		OUT     VARCHAR2	Required
96 --      x_msg_count		OUT     NUMBER		Required
97 --      x_msg_data		OUT     VARCHAR2	Required
98 --
99 --  Create_Node Parameters :
100 --      p_node_tbl		IN	AHL_MC_Node_PVT.Node_Tbl_Type
101 --
102 --  Version :
103 --  	Initial Version   	1.0
104 --
105 --  End of Comments  --
106 /*#
107  * It handles deletion of Master Configurations nodes.
108  * @param p_api_version Api Version Number
109  * @param p_init_msg_list Initialize the message stack, default value FND_API.G_FALSE
110  * @param p_commit To decide whether to commit the transaction, default value FND_API.G_FALSE
111  * @param p_validation_level Validation level, default value FND_API.G_VALID_LEVEL_FULL
112  * @param x_return_status Return status,Standard API parameter
113  * @param x_msg_count Return message count,Standard API parameter
114  * @param x_msg_data Return message data,Standard API parameter
115  * @param p_nodes_tbl Master Configuration record of type AHL_MC_Node_PVT.Node_Rec_Type
116  * @rep:scope public
117  * @rep:lifecycle active
118  * @rep:displayname Delete Master Configuration Node
119  */
120 PROCEDURE Delete_Nodes
121 (
122 	p_api_version		IN 		NUMBER,
123 	p_init_msg_list       	IN 		VARCHAR2	:= FND_API.G_FALSE,
124 	p_commit              	IN 		VARCHAR2 	:= FND_API.G_FALSE,
125 	p_validation_level    	IN 		NUMBER 		:= FND_API.G_VALID_LEVEL_FULL,
126 	x_return_status       	OUT 	NOCOPY  VARCHAR2,
127 	x_msg_count           	OUT 	NOCOPY  NUMBER,
128 	x_msg_data            	OUT 	NOCOPY  VARCHAR2,
129 	p_nodes_tbl		IN		AHL_MC_Node_PVT.Node_Tbl_Type
130 );
131 
132 End AHL_MC_Node_PUB;