APPS.PAY_MWS_RPDEF SQL Statements

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

Line: 205

   /* Delete existing block and record definitions for the MWS Report */

   hr_utility.trace('Insert definition for ' || l_report_format);

Line: 212

   delete from PAY_MAGNETIC_RECORDS
   where  MAGNETIC_BLOCK_ID in
	(select mgb.MAGNETIC_BLOCK_ID
	 from   PAY_MAGNETIC_BLOCKS mgb
	 where  mgb.REPORT_FORMAT = l_report_format);

Line: 220

    delete from PAY_MAGNETIC_BLOCKS mgb
   	  where  mgb.REPORT_FORMAT = l_report_format;

Line: 225

    delete from PAY_REPORT_FORMAT_MAPPINGS_F rfm
    	 where  rfm.REPORT_FORMAT = l_report_format;

Line: 228

    /* Insert into pay_report_format_mappings_f  */

         hr_utility.trace('Inserting the report qualifier : '||
			 l_report_qualifier);

Line: 233

         insert into PAY_REPORT_FORMAT_MAPPINGS_F
	        ( REPORT_TYPE,
	          REPORT_QUALIFIER,
                  REPORT_CATEGORY,
	          REPORT_FORMAT,
	          EFFECTIVE_START_DATE,
	          EFFECTIVE_END_DATE )
         values ( l_report_type,
	          l_report_qualifier,
                  'RT',
	          l_report_format,
	          c_start_date,
	          c_end_date );

Line: 247

     /* Insert blocks into PAY_MAGNETIC_BLOCKS and get the magnetic block id
	for each of the block in lt_B_mag_block_id */

     for l_block_count IN 1..l_block_total loop

       hr_utility.trace('Inserting block ' || lt_B_block_name(l_block_count));

Line: 253

       l_message := 'Error inserting block ' || lt_B_block_name(l_block_count);

Line: 271

     /* Insert Formulas into PAY_MAGNETIC_RECORDS */

     for l_formula_count in 1..l_record_total loop

         hr_utility.trace('Inserting record def. for formula '
                           || lt_F_formula_name(l_formula_count));

Line: 278

         l_message:='Error inserting record def. for formula '
                           || lt_F_formula_name(l_formula_count);