APPS.OCM_RECOMMENDATIONS_PUB SQL Statements

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

Line: 29

            SELECT recommendation_id,
                   case_folder_id,
                   credit_request_id,
                   credit_recommendation,
                   recommendation_value1,
                   recommendation_value2,
                   status,
                   credit_type,
                   recommendation_name,
                   appealed_flag
            FROM   ar_cmgt_cf_recommends
            WHERE  credit_request_id = nvl(p_credit_request_id, credit_request_id)
            AND    nvl(appealed_flag, 'N') = p_appealed_flag
            AND    case_folder_id = nvl(p_case_folder_id, case_folder_id );

Line: 129

            SELECT  credit_request_id, case_folder_id
            INTO    l_credit_request_id, l_case_folder_id
            FROM    ar_cmgt_case_folders
            WHERE   case_folder_id = nvl(p_case_folder_id, case_folder_id )
            AND     credit_request_id = nvl(p_credit_request_id, credit_request_id)
            AND     type = 'CASE'
            AND     status = 'CLOSED';

Line: 153

            UPDATE ar_cmgt_cf_recommends
            SET    appealed_flag = NULL
            WHERE  case_folder_id = l_case_folder_id;

Line: 180

                    UPDATE ar_cmgt_cf_recommends
                    SET appealed_flag = 'Y'
                    WHERE recommendation_id = p_appealing_reco_tbl(i).recommendation_id;

Line: 185

        ELSE -- table is not pupoltaed. Update all of the recommendations
            -- first updates all of
            UPDATE ar_cmgt_cf_recommends
               SET appealed_flag = 'Y'
            WHERE case_folder_id = l_case_folder_id;