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