APPS.AHL_PC_NODE_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 53

				IF (p_x_nodes_tbl(i).operation_flag <> G_DML_DELETE)
				THEN
					p_x_nodes_tbl(i).name := TRIM(p_x_nodes_tbl(i).name);

Line: 95

				ELSIF (p_x_nodes_tbl(i).operation_flag = G_DML_UPDATE)
				THEN
					IF G_DEBUG='Y' THEN
		  				AHL_DEBUG_PUB.debug('PCN -- PUB -- Calling UPDATE_NODE for ID='||p_x_nodes_tbl(i).pc_node_id);

Line: 101

					AHL_PC_NODE_PVT.UPDATE_NODE(
						p_api_version           => l_api_version,
						p_init_msg_list		=> FND_API.G_FALSE,
						p_commit		=> FND_API.G_FALSE,
						p_validation_level 	=> p_validation_level,
                              			p_x_node_rec		=> p_x_nodes_tbl(i),
						x_return_status         => x_return_status,
						x_msg_count             => x_msg_count,
						x_msg_data              => x_msg_data
					);

Line: 111

				ELSIF (p_x_nodes_tbl(i).operation_flag = G_DML_DELETE)
				THEN
					IF G_DEBUG='Y' THEN
		  				AHL_DEBUG_PUB.debug('PCN -- PUB -- Calling DELETE_NODE for ID='||p_x_nodes_tbl(i).pc_node_id);

Line: 117

					AHL_PC_NODE_PVT.DELETE_NODES(
						p_api_version           => l_api_version,
						p_init_msg_list		=> FND_API.G_FALSE,
						p_commit		=> FND_API.G_FALSE,
						p_validation_level 	=> p_validation_level,
                              			p_x_node_rec		=> p_x_nodes_tbl(i),
						x_return_status         => x_return_status,
						x_msg_count             => x_msg_count,
						x_msg_data              => x_msg_data
					);