APPS.QPR_REPORT_TYPE_LINES_PKG SQL Statements

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

Line: 21

l_met_insert_clob clob;

Line: 24

l_opt_insert_clob clob;

Line: 27

l_mod_insert_clob clob;

Line: 65

l_met_insert_clob := null;

Line: 66

l_opt_insert_clob := null;

Line: 67

l_mod_insert_clob := null;

Line: 70

dbms_lob.createtemporary(l_met_insert_clob,true);

Line: 71

dbms_lob.open(l_met_insert_clob,dbms_lob.lob_readwrite);

Line: 74

   l_met_insert_clob := l_met_clob1;

Line: 79

   dbms_lob.append(l_met_insert_clob,l_met_clob2);

Line: 84

   dbms_lob.append(l_met_insert_clob,l_met_clob3);

Line: 89

   dbms_lob.append(l_met_insert_clob,l_met_clob4);

Line: 93

dbms_lob.createtemporary(l_opt_insert_clob,true);

Line: 94

dbms_lob.open(l_opt_insert_clob,dbms_lob.lob_readwrite);

Line: 97

   l_opt_insert_clob := l_opt_clob1;

Line: 102

   dbms_lob.append(l_opt_insert_clob,l_opt_clob2);

Line: 106

dbms_lob.createtemporary(l_mod_insert_clob,true);

Line: 107

dbms_lob.open(l_mod_insert_clob,dbms_lob.lob_readwrite);

Line: 110

   l_mod_insert_clob := l_mod_clob1;

Line: 115

   dbms_lob.append(l_mod_insert_clob,l_mod_clob2);

Line: 118

           update qpr_report_type_lines
              set
    	        report_type_line_name = P_REPORT_TYPE_LINE_NAME,
		report_metadata = l_met_insert_clob,
		report_modifiers = l_mod_insert_clob,
                report_options = l_opt_insert_clob,
		aspect_ratio = to_number(P_ASPECT_RATIO),
		report_type_line_code = P_REPORT_TYPE_LINE_CODE,
		width = to_number(P_WIDTH),
              last_update_date =sysdate,
              last_updated_by = l_user_id,
              last_update_login = 0
           where report_type_line_id = to_number(P_REPORT_TYPE_LINE_ID);

Line: 133

             insert into qpr_report_type_lines
               (REPORT_TYPE_LINE_ID,
                REPORT_TYPE_LINE_NAME,
		REPORT_TYPE_LINE_CODE,
		ASPECT_RATIO,
		WIDTH,
                CREATION_DATE,
                CREATED_BY,
                LAST_UPDATE_DATE,
                LAST_UPDATED_BY,
                LAST_UPDATE_LOGIN,
		REPORT_OPTIONS,
		REPORT_METADATA,
		REPORT_MODIFIERS
		)
            values
                (to_number(P_REPORT_TYPE_LINE_ID),
                P_REPORT_TYPE_LINE_NAME,
		P_REPORT_TYPE_LINE_CODE,
		to_number(P_ASPECT_RATIO),
		to_number(P_WIDTH),
                sysdate,
                l_user_id,
                sysdate,
                l_user_id,
                0,
		l_opt_insert_clob,
                l_met_insert_clob,
                l_mod_insert_clob
		);

Line: 168

  dbms_lob.close(l_met_insert_clob);

Line: 171

  dbms_lob.close(l_opt_insert_clob);

Line: 174

  dbms_lob.close(l_mod_insert_clob);