eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_CIS_CI36_DATA_PKG dependencies on IGI_CIS_CI36_EXTRACT

Line 132: select count(*) from igi_cis_ci36_extract;

128:
129:
130: /* Cursors for the log */
131: Cursor cur_log1 is
132: select count(*) from igi_cis_ci36_extract;
133:
134: Cursor cur_log2 is
135: select count(*) from igi_cis_ci36_payments;
136:

Line 180: ' from igi_cis_ci36_extract : ' || l_count1);

176: close cur_log2;
177:
178:
179: Debug(l_state_level, 'Extract_data',' No. of records selected for deletion' ||
180: ' from igi_cis_ci36_extract : ' || l_count1);
181: Debug(l_state_level, 'Extract_data',' No. of records selected for deletion' ||
182: ' from igi_cis_ci36_payments : ' || l_count2);
183:
184: /***************** This is for the log file ******************/

Line 186: DELETE FROM igi_cis_ci36_extract;

182: ' from igi_cis_ci36_payments : ' || l_count2);
183:
184: /***************** This is for the log file ******************/
185:
186: DELETE FROM igi_cis_ci36_extract;
187: DELETE FROM igi_cis_ci36_payments;
188:
189: COMMIT;
190:

Line 379: Debug(l_state_level, 'Extract_data',' Inserting certificate details in igi_cis_ci36_extract table ');

375: END IF;
376:
377: END LOOP;
378:
379: Debug(l_state_level, 'Extract_data',' Inserting certificate details in igi_cis_ci36_extract table ');
380:
381:
382: /* Bug 2938921 rgopalan 25.6.2003 START*/
383:

Line 392: INSERT INTO igi_cis_ci36_extract (

388:
389: FOR I IN cur_insert_into_extract (J.invoice_id)
390: LOOP
391:
392: INSERT INTO igi_cis_ci36_extract (
393: invoice_num,
394: Segment1,
395: check_number,
396: check_date,

Line 458: Debug(l_state_level, 'Extract_data',' No. of records Inserted into igi_cis_ci36_extract table : ' || l_count1);

454:
455: /***************** This is for the log file ******************/
456:
457:
458: Debug(l_state_level, 'Extract_data',' No. of records Inserted into igi_cis_ci36_extract table : ' || l_count1);
459: Debug(l_state_level, 'Extract_data',' ');
460: Debug(l_state_level, 'Extract_data',' Placing a request for the report ' || x_cis_report);
461:
462: