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: --
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 :
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
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
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
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
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,
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,
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,
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 :
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
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
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
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
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
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,
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,
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