375: -----------------------------------------------------*/
376:
377: FUNCTION Validate_Line_Type
378: (v_dist_type varchar2
379: ,v_tax_id ap_tax_codes_all.tax_id%type)
380: return boolean is
381: v_item_type ap_tax_codes_all.global_attribute8%type;
382: v_freight_type ap_tax_codes_all.global_attribute9%type;
383: v_misc_type ap_tax_codes_all.global_attribute10%type;
377: FUNCTION Validate_Line_Type
378: (v_dist_type varchar2
379: ,v_tax_id ap_tax_codes_all.tax_id%type)
380: return boolean is
381: v_item_type ap_tax_codes_all.global_attribute8%type;
382: v_freight_type ap_tax_codes_all.global_attribute9%type;
383: v_misc_type ap_tax_codes_all.global_attribute10%type;
384: v_tax_type ap_tax_codes_all.global_attribute11%type;
385: find_type boolean;
378: (v_dist_type varchar2
379: ,v_tax_id ap_tax_codes_all.tax_id%type)
380: return boolean is
381: v_item_type ap_tax_codes_all.global_attribute8%type;
382: v_freight_type ap_tax_codes_all.global_attribute9%type;
383: v_misc_type ap_tax_codes_all.global_attribute10%type;
384: v_tax_type ap_tax_codes_all.global_attribute11%type;
385: find_type boolean;
386:
379: ,v_tax_id ap_tax_codes_all.tax_id%type)
380: return boolean is
381: v_item_type ap_tax_codes_all.global_attribute8%type;
382: v_freight_type ap_tax_codes_all.global_attribute9%type;
383: v_misc_type ap_tax_codes_all.global_attribute10%type;
384: v_tax_type ap_tax_codes_all.global_attribute11%type;
385: find_type boolean;
386:
387: CURSOR cur_validate_line_type is
380: return boolean is
381: v_item_type ap_tax_codes_all.global_attribute8%type;
382: v_freight_type ap_tax_codes_all.global_attribute9%type;
383: v_misc_type ap_tax_codes_all.global_attribute10%type;
384: v_tax_type ap_tax_codes_all.global_attribute11%type;
385: find_type boolean;
386:
387: CURSOR cur_validate_line_type is
388: SELECT global_attribute8, -- Type ITEM
388: SELECT global_attribute8, -- Type ITEM
389: global_attribute9, -- Type FREIGHT
390: global_attribute10,-- Type MISCELLANEOUS
391: global_attribute11 -- Type TAX
392: FROM ap_tax_codes
393: WHERE tax_id =v_tax_id;
394:
395: BEGIN
396: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
569: awt.province_code,
570: awt.city_code
571: FROM jl_zz_ap_supp_awt_types swt,
572: jl_zz_ap_sup_awt_cd swc,
573: ap_tax_codes_ALL tca, -- Add _ALL for MOAC
574: jl_zz_ap_awt_types awt
575: WHERE swt.vendor_id = C_vendor_id -- Select only for this Supplier
576: AND swt.wh_subject_flag = 'Y' -- Supp subject to the withholding tax type
577: AND swc.supp_awt_type_id = swt.supp_awt_type_id -- Join
737: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
738: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Supp_Wh_Def_Line','Inside ELSIF db_reg.jurisdiction_type = ZONAL THEN');
739: END IF;
740: ---------------------------------------------------------------
741: -- The name of the zone is taken from AP_TAX_CODES Global Att 7
742: ---------------------------------------------------------------
743: IF db_reg.global_attribute7 = v_hr_zone THEN
744: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
745: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Supp_Wh_Def_Line','Inside IF db_reg.global_attribute7 = v_hr_zone THEN');