The following lines contain the word 'select', 'insert', 'update' or 'delete':
* Description: This function calls the certificate insertion logic
* for the supplier if CIS is enabled
*
* Note: This procedure is called from package AP_VENDORS_PKG (apvndhrb.pls)
* Care should be taken while modifying this package
*/
PROCEDURE SUPPLIER_UPDATE(
p_vendor_id IN ap_suppliers.vendor_id%TYPE,
p_tax_grp_id IN ap_awt_group_taxes_all.group_id%TYPE,
p_pay_tax_grp_id IN ap_awt_group_taxes_all.group_id%TYPE /* Bug 7218825 */
)
IS
l_cis_installed number;
SELECT count(1)
INTO l_cis_installed
FROM igi_gcc_inst_options_all
WHERE option_name = 'CIS'
AND status_flag = 'Y';
* Description: This function calls the certificate insertion logic
* for supplier site if CIS is enabled
*
* Note: This procedure is called from package AP_VENDOR_SITES_PKG (apvndsib.pls)
* Care should be taken while modifying this package
*/
PROCEDURE SUPPLIER_SITE_UPDATE(
p_vendor_id IN ap_suppliers.vendor_id%TYPE,
p_vendor_site_id IN ap_supplier_sites_all.vendor_site_id%TYPE,
p_tax_grp_id IN ap_awt_group_taxes_all.group_id%TYPE,
p_pay_tax_grp_id IN ap_awt_group_taxes_all.group_id%TYPE /* Bug 7218825 */
)
IS
BEGIN
IF igi_gen.is_req_installed('CIS',mo_global.get_current_org_id) = 'Y' THEN
IGI_CIS2007_TAX_EFF_DATE.main (
p_vendor_id => p_vendor_id,
p_vendor_site_id => p_vendor_site_id,
p_tax_grp_id => p_tax_grp_id,
p_pay_tax_grp_id => p_pay_tax_grp_id, /* Bug 7218825 */
p_source => 'VENDOR SITE FORM',
p_effective_date => sysdate
);
select org_id,awt_group_id,pay_awt_group_id
into l_org_id,l_awt_group_id_pvs,l_pay_awt_group_id_pvs
from ap_supplier_sites_all
where
vendor_id = l_vendor_id and
vendor_site_id = l_vendor_site_id and
upper(allow_awt_flag) = 'Y';
select CREATE_AWT_DISTS_TYPE
into l_create_awt_dists_type
from ap_system_parameters_all
where
org_id = l_org_id and
upper(allow_awt_flag) = 'Y';
select awt_group_id,pay_awt_group_id
into l_awt_group_id_po,l_pay_awt_group_id_po
from ap_suppliers
where
vendor_id = l_vendor_id;