APPS.CN_PLANCOPY_UTIL_PVT SQL Statements

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

Line: 47

    select substr(to_char(abs(dbms_random.random)),1,RAND_NUM_LENGTH) into l_unique_identifier from dual;

Line: 48

    select fnd_message.get_string('CN','CN_COPY_MSG') into l_msg_copy from dual;

Line: 59

       SELECT SUBSTRB(NAME,1,(30-l_length)),LENGTHB(NAME) into l_obj_name,l_obj_length from cn_comp_plans_all where org_id = p_org_id and comp_plan_id = p_id;

Line: 61

       SELECT SUBSTRB(NAME,1,(80-l_length)),LENGTHB(NAME) into l_obj_name,l_obj_length from cn_quotas_all where org_id = p_org_id and quota_id = p_id;

Line: 63

       SELECT SUBSTRB(NAME,1,(30-l_length)),LENGTHB(NAME) into l_obj_name,l_obj_length from cn_calc_sql_exps_all where org_id = p_org_id and CALC_SQL_EXP_ID = p_id;

Line: 65

      SELECT SUBSTRB(NAME,1,(80-l_length)),LENGTHB(NAME) into l_obj_name,l_obj_length from cn_rate_schedules_all where org_id = p_org_id and RATE_SCHEDULE_ID = p_id;

Line: 67

      SELECT SUBSTRB(NAME,1,(30-l_length)),LENGTHB(NAME) into l_obj_name,l_obj_length from cn_rate_dimensions_all where org_id = p_org_id and RATE_DIMENSION_ID = p_id;

Line: 69

      SELECT SUBSTRB(NAME,1,(30-l_length)),LENGTHB(NAME) into l_obj_name,l_obj_length from cn_calc_formulas_all where org_id = p_org_id and CALC_FORMULA_ID = p_id;

Line: 71

       SELECT SUBSTRB(NAME,1,(80-l_length)),LENGTHB(NAME) into l_obj_name,l_obj_length from cn_scenarios_all where org_id = p_org_id and scenario_id = p_id;

Line: 73

       SELECT SUBSTRB(NAME,1,(80-l_length_expscn)),LENGTHB(NAME) into l_obj_name,l_obj_length from cn_scenarios_all where org_id = p_org_id and scenario_id = p_id;

Line: 191

     select file_content_blob into l_blob from cn_copy_requests_all
     where EXP_IMP_REQUEST_ID = p_exp_imp_id;

Line: 197

     update cn_copy_requests_all set file_content_clob = l_clob where EXP_IMP_REQUEST_ID = p_exp_imp_id;

Line: 285

     select file_content_clob into l_clob from cn_copy_requests_all
     where EXP_IMP_REQUEST_ID = p_exp_imp_id;

Line: 290

     update cn_copy_requests_all set file_content_xmltype = l_xmltype where EXP_IMP_REQUEST_ID = p_exp_imp_id;

Line: 494

       SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;

Line: 496

       SELECT SUBSTRB(l_temp_str,1,80) into l_return_str FROM DUAL;

Line: 498

       SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;

Line: 500

      SELECT SUBSTRB(l_temp_str,1,80) into l_return_str FROM DUAL;

Line: 502

      SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;

Line: 504

      SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;