APPS.HXC_RDB_ATT_SNAPSHOT SQL Statements

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

Line: 37

l_update_warning	VARCHAR2(1);

Line: 44

SELECT ROWIDTOCHAR(hld.rowid),
       hta.attribute_category,
       REPLACE(hta.attribute_category,'ELEMENT - '),--hta.attribute1,
       hta.attribute2,
       hta.attribute3,
       hta.attribute4,
       hta.attribute5,
       hta.attribute6,
       hta.attribute7,
       DECODE (TBB.DATE_TO, HR_GENERAL.end_of_time,  nvl (tbb.measure,
             						TO_NUMBER (tbb.stop_time - tbb.start_time) * 24 ) ,
             		  0 ) measure,
       hld.timecard_id
  FROM hxc_pay_latest_details hld,
       hxc_time_attribute_usages htau,
       hxc_time_attributes hta,
       hxc_bld_blk_info_types bld,
       hxc_time_building_blocks tbb
 WHERE htau.time_building_block_id = hld.time_building_block_id
   AND htau.time_building_block_ovn = hld.object_version_number
   AND tbb.time_building_block_id = hld.time_building_block_id
   AND tbb.object_version_number = hld.object_version_number
   AND (  hld.attribute_category is null
        OR hld.measure is null)
   AND hta.time_attribute_id = htau.time_attribute_id
   AND hta.bld_blk_info_type_id = bld.bld_blk_info_type_id
   AND bld.bld_blk_info_type = 'Dummy Element Context' -- 'PROJECTS'
   /*AND NOT EXISTS ( SELECT 1
                         FROM hxc_locks hlk
                        WHERE  (hlk.time_building_block_id = hld.timecard_id
                                OR
                                   (hlk.time_building_block_id = hld.time_building_block_id
                                    AND
                                    hlk.time_building_block_ovn = hld.object_version_number
                                   )
                               )
                          AND lock_date <= sysdate - ( 20 / (24*60) )
                  )*/
     ;

Line: 88

SELECT ROWIDTOCHAR(hld.rowid),
       hta.attribute_category,
       hta.attribute1,
       hta.attribute2,
       hta.attribute3,
       hta.attribute4,
       hta.attribute5,
       hta.attribute6,
       hta.attribute7,
       DECODE (TBB.DATE_TO, HR_GENERAL.end_of_time,  nvl (tbb.measure,
             						TO_NUMBER (tbb.stop_time - tbb.start_time) * 24 ) ,
             		  0 ) measure,
       hld.timecard_id
  FROM hxc_pa_latest_details hld,
       hxc_time_attribute_usages htau,
       hxc_time_attributes hta,
       hxc_bld_blk_info_types bld,
       hxc_time_building_blocks tbb
 WHERE htau.time_building_block_id = hld.time_building_block_id
   AND htau.time_building_block_ovn = hld.object_version_number
   AND tbb.time_building_block_id = hld.time_building_block_id
   AND tbb.object_version_number = hld.object_version_number
   AND (  hld.attribute_category is null
        OR hld.measure is null)
   AND hta.time_attribute_id = htau.time_attribute_id
   AND hta.bld_blk_info_type_id = bld.bld_blk_info_type_id
   AND bld.bld_blk_info_type = 'PROJECTS' -- 'PROJECTS'
   /*AND NOT EXISTS ( SELECT 1
                      FROM hxc_locks hlk
                     WHERE (hlk.time_building_block_id = hld.timecard_id
                            OR
                               (hlk.time_building_block_id = hld.time_building_block_id
                                AND
                                hlk.time_building_block_ovn = hld.object_version_number
                                )
                           )
                       AND lock_date <= sysdate - ( 20 / (24*60) )
                  )*/
    ;

Line: 164

	 SELECT
	        tc.timecard_id,
	        tc.timecard_ovn,
	        tc.resource_id,
	        tc.start_time,
	        tc.stop_time
	   FROM
	        hxc_timecard_summary tc
	  WHERE
	        tc.timecard_id = p_timecard_id;

Line: 225

				fnd_file.put_line (fnd_file.LOG,'The Timecard seems to be deleted. TC ID: '||p_lock_tcs_tab(i));

Line: 250

 	SELECT 'Y'
 	  INTO l_latest_details_upg
 	  FROM hxc_upgrade_definitions
 	 WHERE upg_type = 'LATEST_DETAILS'
 	   AND status = 'COMPLETE';

Line: 266

  	SELECT 'Y'
  	  INTO l_pay_upg
  	  FROM hxc_upgrade_definitions
  	 WHERE upg_type = 'RETRIEVAL_PAY'
  	   AND status = 'COMPLETE';

Line: 279

   	SELECT 'Y'
   	  INTO l_pa_upg
   	  FROM hxc_upgrade_definitions
   	 WHERE upg_type = 'RETRIEVAL_PA'
   	   AND status = 'COMPLETE';

Line: 304

	SELECT hxc_transactions_s.NEXTVAL
	  INTO g_lock_transaction_id
	  FROM SYS.DUAL;

Line: 357

			UPDATE hxc_pay_latest_details
			   SET ATTRIBUTE_CATEGORY = ATTRIBUTE_CATEGORY_TAB(i),
			       ATTRIBUTE1 = ATTRIBUTE1_TAB(i),
			       ATTRIBUTE2 = ATTRIBUTE2_TAB(i),
			       ATTRIBUTE3 = ATTRIBUTE3_TAB(i),
			       ATTRIBUTE4 = ATTRIBUTE4_TAB(i),
			       ATTRIBUTE5 = ATTRIBUTE5_TAB(i),
			       ATTRIBUTE6 = ATTRIBUTE6_TAB(i),
			       ATTRIBUTE7 = ATTRIBUTE7_TAB(i),
			       MEASURE = MEASURE_TAB(i)
			 WHERE rowid = CHARTOROWID (ROW_ID_TAB(i))
			   AND TIMECARD_ID_STATUS(i) = 'Y';

Line: 372

	        	l_update_warning:= 'Y';

Line: 416

			UPDATE hxc_pa_latest_details
			   SET ATTRIBUTE_CATEGORY = ATTRIBUTE_CATEGORY_TAB(i),
			       ATTRIBUTE1 = ATTRIBUTE1_TAB(i),
			       ATTRIBUTE2 = ATTRIBUTE2_TAB(i),
			       ATTRIBUTE3 = ATTRIBUTE3_TAB(i),
			       ATTRIBUTE4 = ATTRIBUTE4_TAB(i),
			       ATTRIBUTE5 = ATTRIBUTE5_TAB(i),
			       ATTRIBUTE6 = ATTRIBUTE6_TAB(i),
			       ATTRIBUTE7 = ATTRIBUTE7_TAB(i),
			       MEASURE = MEASURE_TAB(i)
			 WHERE rowid = CHARTOROWID (ROW_ID_TAB(i))
			 AND TIMECARD_ID_STATUS(i) = 'Y';

Line: 431

	         	l_update_warning:= 'Y';

Line: 481

if (l_update_warning = 'Y') then

retcode:= 1;