APPS.OCM_ADD_DATA_POINTS SQL Statements

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

Line: 45

    	AR_CMGT_CONTROLS.UPDATE_CF_ADP_DETAILS (
    		p_case_folder_id		=> p_case_folder_id,
        	p_data_point_id     	=> p_data_point_id,
        	p_sequence_number   	=> p_sequence_number,
        	p_parent_data_point_id  => p_parent_data_point_id,
        	p_parent_cf_detail_id   => p_parent_cf_detail_id,
        	p_data_point_value      => p_data_point_value,
        	p_score                 => p_score,
        	p_included_in_checklist => p_included_in_checklist,
        	p_case_folder_detail_id => p_case_folder_detail_id,
        	x_errmsg                => p_errmsg,
        	x_resultout             => p_resultout );

Line: 82

		pg_ocm_dp_values_tbl.delete;

Line: 133

		SELECT data_point_id, package_name, function_name,
                       parent_data_point_id,
                       return_data_type, return_date_format
		FROM   ar_cmgt_data_points_vl
		where  enabled_flag = 'Y'
		start with    parent_data_point_id = p_parent_data_point_id
		connect by prior data_point_id = parent_data_point_id
		order by level;

Line: 144

		SELECT case_folder_detail_id, case_folder_id,
		       data_point_id, data_point_value, sequence_number,
                       data_point_value_id
		FROM   ar_cmgt_cf_dtls
		WHERE  case_folder_id = l_case_folder_id
		AND    data_point_id =  l_parent_data_point_id;

Line: 246

			     -- first insert all the values to table
        		     FOR i in 1 .. pg_ocm_dp_values_tbl.count
			     LOOP
				GenarateCaseFolderDetails (
				   p_case_folder_id       =>  pg_ocm_add_dp_param_rec.p_case_folder_id,
    				   p_data_point_id        =>  getChildDataPointsRec.data_point_id,
        			   p_sequence_number      =>  pg_ocm_dp_values_tbl(i).p_sequence_number,
        			   p_parent_data_point_id =>  getChildDataPointsRec.parent_data_point_id,
        			   p_parent_cf_detail_id  =>  getAllParentValuesRec.case_folder_detail_id,
        			   p_data_point_value     =>  pg_ocm_dp_values_tbl(i).p_data_point_value,
        			   p_mode		  =>  p_mode,
        			   p_score                     =>  NULL,
        			   p_included_in_checklist     =>  'N',
        			   p_data_point_value_id       =>  pg_ocm_dp_values_tbl(i).p_data_point_value_id,
        			   p_case_folder_detail_id     =>  l_case_folder_detail_id,
        			   p_errmsg                    =>  p_error_msg,
        			   p_resultout                 =>  p_resultout );

Line: 286

		SELECT data_point_id,package_name, function_name, scorable_flag,
			   application_id, return_data_type, return_date_format
		FROM   ar_cmgt_data_points_vl
		where  enabled_flag = 'Y'
		and    data_point_category = 'ADDITIONAL'
		and    parent_data_point_id IS NULL
		and    ( application_id = pg_ocm_add_dp_param_rec.p_SOURCE_RESP_APPLN_ID
            OR   application_id = 222 );

Line: 296

		SELECT case_folder_detail_id, case_folder_id,
		       data_point_id,
		       data_point_value, sequence_number
		FROM   ar_cmgt_cf_dtls
		WHERE  case_folder_id = l_case_folder_id
		AND    data_point_id =  l_data_point_id;

Line: 321

      		pg_ocm_dp_values_tbl.delete;

Line: 386

		  -- first insert all the values to table
        	  FOR i in 1 .. pg_ocm_dp_values_tbl.count
                  LOOP
			GenarateCaseFolderDetails (
				p_case_folder_id =>  pg_ocm_add_dp_param_rec.p_case_folder_id,
        			p_data_point_id  =>  getParentDataPointsRec.data_point_id,
        			p_sequence_number  =>  pg_ocm_dp_values_tbl(i).p_sequence_number,
        			p_parent_data_point_id      =>  NULL,
        			p_parent_cf_detail_id       =>  NULL,
        			p_data_point_value          =>  pg_ocm_dp_values_tbl(i).p_data_point_value,
        			p_mode			    =>  p_mode,
        			p_score                     => 	NULL,
        			p_included_in_checklist     =>  'N',
        			p_data_point_value_id	    =>  pg_ocm_dp_values_tbl(i).p_data_point_value_id,
        			p_case_folder_detail_id     =>  l_case_folder_detail_id,
        			p_errmsg                    =>  p_error_msg,
        			p_resultout                 =>  p_resultout );

Line: 443

		SELECT *
		FROM   ar_cmgt_credit_requests
		WHERE  credit_request_id = p_credit_request_id;

Line: 480

		SELECT default_exchange_rate_type
		INTO   l_exchange_rate_type
		FROM   ar_cmgt_setup_options;

Line: 493

	-- then first delete all the muliple records in case_folder details
	-- table. This logic is required because there is no way we will identify a
	-- unique record for updation.
	IF p_mode = 'REFRESH' OR p_mode = 'CREATE'
	THEN
		BEGIN
			DELETE FROM ar_cmgt_cf_dtls
			WHERE  case_folder_id = p_case_folder_id
			AND    data_point_id >= 20000;