APPS.OCM_ADD_DATA_POINTS SQL Statements

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

Line: 46

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

		pg_ocm_dp_values_tbl.delete;

Line: 144

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

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

	    SELECT 'Y'
		FROM ar_cmgt_cf_dtls
		WHERE case_folder_id = l_case_folder_id
		AND    data_point_id =  p_data_point_id;

Line: 295

					-- first insert all the values to table
        			FOR i in 1 .. pg_ocm_dp_values_tbl.count
				LOOP
                                   IF pg_wf_debug = 'Y'
                                   THEN
                                      ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
                                      '  return_value(' || i || ') = ' ||
                                      pg_ocm_dp_values_tbl(i).p_data_point_value);

Line: 354

		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 = 206					-- Added for bug 10304146
	    OR   application_id = pg_ocm_add_dp_param_rec.p_SOURCE_RESP_APPLN_ID
            OR   application_id = 222 );

Line: 365

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

      		pg_ocm_dp_values_tbl.delete;

Line: 477

                        SELECT 'Y'
                        INTO   l_dp_exists
                        FROM   ar_cmgt_cf_dtls cfd
                        WHERE  cfd.case_folder_id =
                             pg_ocm_add_dp_param_rec.p_case_folder_id
                        AND    cfd.data_point_id =
                             getParentDataPointsRec.data_point_id;

Line: 524

		-- first insert all the values to table
                FOR i in 1 .. pg_ocm_dp_values_tbl.count
		LOOP

                  IF pg_wf_debug = 'Y'
                  THEN
                    ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
                                      '  return_value(' || i || ') = ' ||
                                pg_ocm_dp_values_tbl(i).p_data_point_value);

Line: 606

		SELECT *
		FROM   ar_cmgt_credit_requests
		WHERE  credit_request_id = p_credit_request_id;

Line: 670

		SELECT default_exchange_rate_type
		INTO   l_exchange_rate_type
		FROM   ar_cmgt_setup_options;

Line: 683

	-- 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
                  /* 7416921 - preserve non-function ADPs if
                      then are already visible from the checklist */
                        DELETE FROM ar_cmgt_cf_dtls cfd
			WHERE  cfd.case_folder_id = p_case_folder_id
			AND    cfd.data_point_id >= 20000
                        AND   (cfd.included_in_checklist = 'N' OR
                              (cfd.included_in_checklist = 'Y' AND
                               NOT EXISTS
                                 (SELECT 'populated NF/ADP'
                                  FROM   AR_CMGT_DATA_POINTS_B dp
                                  WHERE  dp.data_point_id = cfd.data_point_id
                                  AND    dp.function_name IS NULL)));