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_PAYMENTS

Line 45: FROM igi_cis_ci36_payments;

41: SELECT Invoice_id , Invoice_num, Invoice_payment_id, Amount, Pmt_vch_number, Pmt_vch_amount,
42: Pmt_vch_description, Check_number, Check_date, Vendor_id, Vendor_name, Vendor_site_id,
43: Vendor_site_code, Group_id, Certificate_type, Certificate_number, Certificate_description,
44: Ni_number
45: FROM igi_cis_ci36_payments;
46:
47: /* Modified the AND condition to include nvl check for icatr1.end_date Bug Bug#2443887 -solakshm*/
48: CURSOR c_cis_awt_tax_rates (P_vendor_id igi_cis_awt_tax_rates.vendor_id%TYPE,
49: P_vendor_site_id igi_cis_awt_tax_rates.vendor_site_id%TYPE,

Line 50: P_check_date igi_cis_ci36_payments.Check_date%TYPE )

46:
47: /* Modified the AND condition to include nvl check for icatr1.end_date Bug Bug#2443887 -solakshm*/
48: CURSOR c_cis_awt_tax_rates (P_vendor_id igi_cis_awt_tax_rates.vendor_id%TYPE,
49: P_vendor_site_id igi_cis_awt_tax_rates.vendor_site_id%TYPE,
50: P_check_date igi_cis_ci36_payments.Check_date%TYPE )
51: IS
52: SELECT icatr1.certificate_type , icatr1.certificate_number ,
53: Substr(icatr1.comments,1,50) "comments", icatr1.ni_number
54: FROM igi_cis_awt_tax_rates icatr1

Line 93: igi_cis_ci36_payments icip

89: SUM (NVL (DECODE (line_type_lookup_code,'AWT',-aid.amount,0),0)) cis_amount,
90: (NVL (icip.Amount,0) - SUM (NVL (DECODE (line_type_lookup_code, 'TAX', aid.amount, 0), 0))) net_amount
91: FROM
92: ap_invoice_distributions aid,
93: igi_cis_ci36_payments icip
94: WHERE
95: aid.invoice_id = icip.invoice_id
96: AND aid.invoice_id = p_invoice_id
97: GROUP BY

Line 125: ap_invoices ai, igi_cis_ci36_payments icip

121: icip.address_line3,
122: icip.zip,
123: icip.pmt_vch_received_date
124: FROM
125: ap_invoices ai, igi_cis_ci36_payments icip
126: WHERE
127: ai.invoice_id = icip.invoice_id;
128:
129:

Line 135: select count(*) from igi_cis_ci36_payments;

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:
137: l_invoice_num igi_cis_ci36_payments.invoice_num%TYPE;
138: l_certificate_type igi_cis_awt_tax_rates.certificate_type%TYPE;
139: l_certificate_number igi_cis_awt_tax_rates.certificate_number%TYPE;

Line 137: l_invoice_num igi_cis_ci36_payments.invoice_num%TYPE;

133:
134: Cursor cur_log2 is
135: select count(*) from igi_cis_ci36_payments;
136:
137: l_invoice_num igi_cis_ci36_payments.invoice_num%TYPE;
138: l_certificate_type igi_cis_awt_tax_rates.certificate_type%TYPE;
139: l_certificate_number igi_cis_awt_tax_rates.certificate_number%TYPE;
140: l_certificate_description Varchar2(50);
141: l_ni_number igi_cis_awt_tax_rates.ni_number%TYPE;

Line 182: ' from igi_cis_ci36_payments : ' || l_count2);

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 ******************/
185:
186: DELETE FROM igi_cis_ci36_extract;

Line 187: DELETE FROM igi_cis_ci36_payments;

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:
191: /***************** This is for the log file ******************/

Line 196: Debug(l_state_level, 'Extract_data',' Inserting records into igi_cis_ci36_payments Table ');

192: /***************** This is for the log file ******************/
193:
194: Debug(l_state_level, 'Extract_data',' all rows deleted ');
195: Debug(l_state_level, 'Extract_data',' ');
196: Debug(l_state_level, 'Extract_data',' Inserting records into igi_cis_ci36_payments Table ');
197:
198:
199:
200: INSERT INTO igi_cis_ci36_payments (

Line 200: INSERT INTO igi_cis_ci36_payments (

196: Debug(l_state_level, 'Extract_data',' Inserting records into igi_cis_ci36_payments Table ');
197:
198:
199:
200: INSERT INTO igi_cis_ci36_payments (
201: INVOICE_PAYMENT_ID,
202: INVOICE_ID,
203: PMT_VCH_NUMBER,
204: PMT_VCH_AMOUNT,

Line 257: ' vendors from igi_cis_ci36_payments ');

253:
254: Debug(l_state_level, 'Extract_data',' No. of records inserted : ' || l_count1);
255: Debug(l_state_level, 'Extract_data',' ');
256: Debug(l_state_level, 'Extract_data',' deleting all black listed' ||
257: ' vendors from igi_cis_ci36_payments ');
258:
259:
260:
261:

Line 265: DELETE FROM igi_cis_ci36_payments a

261:
262: /***************** This is for the log file ******************/
263:
264: /* deleting all black listed vendors */
265: DELETE FROM igi_cis_ci36_payments a
266: WHERE EXISTS (SELECT 'x' FROM po_vendors b
267: WHERE b.vendor_id = a.vendor_id
268: AND nvl(b.enabled_flag,'N') <> 'Y');
269:

Line 280: ' for the corresponding vendor id in igi_cis_ci36_payments ');

276: Debug(l_state_level, 'Extract_data',' No. of records deleted : '
277: || (nvl(l_count1,0) - nvl(l_count2,0)));
278: Debug(l_state_level, 'Extract_data',' ');
279: Debug(l_state_level, 'Extract_data',' Updating the vendor name' ||
280: ' for the corresponding vendor id in igi_cis_ci36_payments ');
281:
282:
283: /***************** This is for the log file ******************/
284:

Line 287: UPDATE igi_cis_ci36_payments a

283: /***************** This is for the log file ******************/
284:
285: /* updating the vendor name for the corresponding vendor id */
286:
287: UPDATE igi_cis_ci36_payments a
288: SET (a.vendor_name,a.segment1) =
289: (SELECT vendor_name,segment1 FROM po_vendors
290: WHERE vendor_id = a.vendor_id);
291: COMMIT;

Line 298: ' tax from igi_cis_ci36_payments ');

294:
295:
296: Debug(l_state_level, 'Extract_data',' Removing the vendor sites which' ||
297: ' does not have automatic withholding'||
298: ' tax from igi_cis_ci36_payments ');
299:
300:
301:
302:

Line 311: DELETE FROM igi_cis_ci36_payments a

307: /***************** This is for the log file ******************/
308:
309:
310: /* remove the vendor sites which does not have automatic withholding tax */
311: DELETE FROM igi_cis_ci36_payments a
312: WHERE EXISTS (SELECT 'x' FROM po_vendor_sites b
313: WHERE b.vendor_site_id = a.vendor_site_id
314: AND ( nvl(b.allow_awt_flag,'N') <> 'Y'
315: OR b.awt_group_id <> a.group_id));

Line 331: ' in igi_cis_ci36_payments ');

327: || (nvl(l_count1,0) - nvl(l_count2,0)));
328: Debug(l_state_level, 'Extract_data',' ');
329: Debug(l_state_level, 'Extract_data',' Updating with proper vendor site code' ||
330: ' for the corresponding vendor site id' ||
331: ' in igi_cis_ci36_payments ');
332:
333:
334:
335: /* updating with proper vendor site code for the corresponding vendor site id */

Line 336: UPDATE igi_cis_ci36_payments a

332:
333:
334:
335: /* updating with proper vendor site code for the corresponding vendor site id */
336: UPDATE igi_cis_ci36_payments a
337: SET (a.vendor_site_code,a.address_line1,A.address_line2,A.address_line3,a.zip ) =
338: (SELECT vendor_site_code,address_line1,address_line2,address_line3,zip
339: FROM po_vendor_sites b
340: WHERE b.vendor_site_id = a.vendor_site_id );

Line 344: Debug(l_state_level, 'Extract_data',' Updating certificate details in igi_cis_ci36_payments ');

340: WHERE b.vendor_site_id = a.vendor_site_id );
341: COMMIT;
342:
343:
344: Debug(l_state_level, 'Extract_data',' Updating certificate details in igi_cis_ci36_payments ');
345:
346: FOR cur_cis_payments in c_cis_payments
347: LOOP
348:

Line 360: UPDATE igi_cis_ci36_payments

356: l_ni_number;
357:
358: IF (c_cis_awt_tax_rates%FOUND) THEN
359:
360: UPDATE igi_cis_ci36_payments
361: SET certificate_type = l_certificate_type,
362: certificate_number = l_certificate_number,
363: certificate_description = l_certificate_description,
364: ni_number = l_ni_number