APPS.IGI_CIS_UPDC dependencies on AP_AWT_TAX_RATES

Line 93: SELECT ap_awt_tax_rates_s.NEXTVAL FROM SYS.DUAL;

89: END validate_dates;
90:
91: PROCEDURE GENERATE_TAX_RATE_ID (p_tax_rate_id OUT NOCOPY NUMBER) IS
92: CURSOR c_gen_id IS
93: SELECT ap_awt_tax_rates_s.NEXTVAL FROM SYS.DUAL;
94: INVALIDSEQ Exception;
95: l_message varchar2(100) ;
96: BEGIN
97: OPEN c_gen_id;

Line 163: FROM ap_awt_tax_rates

159: attribute13,
160: attribute14,
161: attribute15,
162: org_id
163: FROM ap_awt_tax_rates
164: WHERE tax_name = IGI_CIS_GET_PROFILE.Cis_Tax_Code
165: AND certificate_type = p_current_certificate_type ;
166:
167: CURSOR c1 ( c_tax_rate_id number )IS

Line 174: SELECT 'X' from ap_awt_tax_rates

170: WHERE TAX_RATE_ID = c_tax_rate_id ;
171:
172:
173: CURSOR c2 (c_start_date date, c_end_date date , c_vendor_id number , c_tax_rate_id number ) is
174: SELECT 'X' from ap_awt_tax_rates
175: WHERE tax_name = IGI_CIS_GET_PROFILE.Cis_Tax_Code
176: AND ((certificate_type = decode(p_mode , 'Percentages' , p_current_certificate_type , p_new_certificate_type)) OR (certificate_type = p_current_certificate_type))
177: AND vendor_id = c_vendor_id
178: AND tax_rate_id <> c_tax_rate_id

Line 343: UPDATE ap_awt_tax_rates

339:
340: Generate_tax_rate_id(l_tax_rate_id);
341:
342:
343: UPDATE ap_awt_tax_rates
344: SET end_date = l_curr_end_date
345: WHERE rowid = l_certificate.rowid;
346:
347: Fnd_message.set_name('IGI','IGI_CIS_UPDATED_CERT');

Line 369: INSERT INTO ap_awt_tax_rates

365: END IF; -------------------------------------(61)
366:
367:
368:
369: INSERT INTO ap_awt_tax_rates
370: (tax_rate_id,
371: tax_name,
372: tax_rate,
373: rate_type,

Line 461: SELECT rowid into l_row_id FROM ap_awt_tax_rates WHERE tax_rate_id=l_tax_rate_id ;

457: Debug(l_state_level, 'upd_cis_cert_type_perc.msg1', l_message);
458:
459: /* Prepare a new record for the new percentage/new certificate type */
460:
461: SELECT rowid into l_row_id FROM ap_awt_tax_rates WHERE tax_rate_id=l_tax_rate_id ;
462: /* Modified the cursor parameter value to take the old tax rate id for retrieving the ni number
463: instead of the current tax rate id Bug 2443964 solakshm*/
464: OPEN c1(l_certificate.tax_rate_id);
465: FETCH c1 INTO l1;

Line 486: /* End of insert into ap_awt_tax_rates and igi_cis_ni_numbers_all*/

482:
483: END IF; ------------------------------------------------------------------------------------(3)
484:
485:
486: /* End of insert into ap_awt_tax_rates and igi_cis_ni_numbers_all*/
487:
488: /* If the effective date does not break a period then update the certificate for future active certificates*/
489:
490: IF l_certificate.start_date >= p_effective_date THEN ------------------------(4)

Line 493: UPDATE ap_awt_tax_rates

489:
490: IF l_certificate.start_date >= p_effective_date THEN ------------------------(4)
491:
492:
493: UPDATE ap_awt_tax_rates
494: SET tax_rate = l_tax_rate,
495: Certificate_type= l_certificate_type
496: WHERE rowid= l_certificate.rowid;
497: