DBA Data[Home] [Help]

APPS.IGI_CIS_UPDC dependencies on IGI_CIS_GET_PROFILE

Line 164: WHERE tax_name = IGI_CIS_GET_PROFILE.Cis_Tax_Code

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
168: SELECT tax_rate_id , ni_number

Line 175: WHERE tax_name = IGI_CIS_GET_PROFILE.Cis_Tax_Code

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
179: AND ( ( start_date <= c_start_date AND end_date >= c_end_date) OR

Line 350: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);

346:
347: Fnd_message.set_name('IGI','IGI_CIS_UPDATED_CERT');
348: Fnd_message.set_token('vendor_name',l_vendor_name);
349: Fnd_message.set_token('vendor_site',l_vendor_site_code);
350: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
351: Fnd_message.set_token('tax_name',l_certificate.tax_name);
352: Fnd_message.set_token('cert_type',l_certificate.certificate_type);
353: Fnd_message.set_token('cert_number',l_certificate.certificate_number);
354: Fnd_message.set_token ('tax_rate',l_certificate.tax_rate ) ;

Line 449: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE.Cis_Tax_group);

445:
446: Fnd_message.set_name('IGI','IGI_CIS_UPDATED_CERT');
447: Fnd_message.set_token('vendor_name',l_vendor_name);
448: Fnd_message.set_token('vendor_site',l_vendor_site_code);
449: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE.Cis_Tax_group);
450: Fnd_message.set_token('tax_name',l_certificate.tax_name);
451: Fnd_message.set_token('cert_type',l_certificate_type);
452: Fnd_message.set_token('cert_number' ,l_certificate.certificate_number);
453: Fnd_message.set_token('tax_rate' ,l_tax_rate);

Line 505: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);

501: Fnd_message.set_name('IGI','IGI_CIS_UPDATED_CERT');
502:
503: Fnd_message.set_token('vendor_name',l_vendor_name);
504: Fnd_message.set_token('vendor_site' ,l_vendor_site_code);
505: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
506: Fnd_message.set_token('tax_name',l_certificate.tax_name);
507: Fnd_message.set_token( 'cert_type',l_certificate_type);
508: Fnd_message.set_token( 'cert_number',l_certificate.certificate_number);
509: Fnd_message.set_token('tax_rate',l_tax_rate);

Line 558: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);

554: WHEN UNPROCESSED THEN
555: Fnd_message.set_name('IGI','IGI_CIS_REC_NOT_PROCESSED');
556: Fnd_message.set_token('vendor_name',l_vendor_name);
557: Fnd_message.set_token('vendor_site',l_vendor_site_code);
558: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
559: Fnd_message.set_token('tax_name',l_certificate.tax_name);
560: Fnd_message.set_token('cert_type',l_certificate.certificate_type);
561: Fnd_message.set_token('cert_number' ,l_certificate.certificate_number);
562: Fnd_message.set_token('tax_rate',l_certificate.tax_rate);