APPS.AHL_MC_MASTERCONFIG_PUB SQL Statements

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

Line: 27

		SELECT 	item_group_id
		FROM 	ahl_item_groups_b
		WHERE 	upper(name) = upper (p_ig_name) AND
			source_item_group_id IS NULL;

Line: 77

	-- IF (p_module_type = 'JSP' AND p_x_mc_header_rec.operation_flag <> G_DML_DELETE)
	IF (p_x_mc_header_rec.operation_flag <> G_DML_DELETE)
	THEN
		-- Validate header status code
		-- This field is represented in UI with a dropdown, hence need to check for validity of the code only
		IF (p_x_mc_header_rec.config_status_code IS NULL)
		THEN
			-- This is a mandatory field, hence throw error
			FND_MESSAGE.Set_Name('AHL','AHL_MC_STATUS_NULL');

Line: 335

  	ELSIF (p_x_mc_header_rec.operation_flag = G_DML_DELETE)
  	THEN
  		AHL_MC_MasterConfig_PVT.Delete_Master_Config
		(
			p_api_version 		=> 1.0,
			p_init_msg_list 	=> FND_API.G_FALSE,
			p_commit 		=> FND_API.G_FALSE,
			p_validation_level 	=> FND_API.G_VALID_LEVEL_FULL,
			x_return_status 	=> l_return_status,
			x_msg_count 		=> l_msg_count,
			x_msg_data 		=> l_msg_data,
			p_mc_header_id 		=> p_x_mc_header_rec.mc_header_id,
			p_object_ver_num	=> p_x_mc_header_rec.object_version_number
		);

Line: 352

  	ELSIF (p_x_mc_header_rec.operation_flag = G_DML_UPDATE)
  	THEN

		AHL_MC_MasterConfig_PVT.Modify_Master_Config
		(
			p_api_version 		=> 1.0,
			p_init_msg_list 	=> FND_API.G_FALSE,
			p_commit 		=> FND_API.G_FALSE,
			p_validation_level 	=> FND_API.G_VALID_LEVEL_FULL,
			x_return_status 	=> l_return_status,
			x_msg_count 		=> l_msg_count,
			x_msg_data 		=> l_msg_data,
			p_x_mc_header_rec 	=> p_x_mc_header_rec,
			p_x_node_rec 		=> p_x_node_rec
		);