DBA Data[Home] [Help]

APPS.JL_ZZ_AP_MONOTRIB_AWT_PKG dependencies on JL_ZZ_AP_AWT_DEFAULT_PKG

Line 785: IF ( JL_ZZ_AP_AWT_DEFAULT_PKG.Company_Agent(db_reg.awt_type_code,p_Invoice_Id)) THEN

781: -- The cursor verify the Supplier Withholding Applicability
782: -- Each Supp Withholding Type in the Cursor needs to be check.
783: -- Company Agent says if the company have to withhold by this Withholding Type.
784: ---------------------------------------------------------------------------------
785: IF ( JL_ZZ_AP_AWT_DEFAULT_PKG.Company_Agent(db_reg.awt_type_code,p_Invoice_Id)) THEN
786: FND_FILE.put_line( FND_FILE.LOG, 'INSIDE "Monotrib_Wh_Def_Line" PROCEDURE - Company validation success');
787: ----------------------------------------------------------------------------
788: -- Validate the withholding type is according to distribution line.
789: ----------------------------------------------------------------------------

Line 790: IF JL_ZZ_AP_AWT_DEFAULT_PKG.Validate_Line_Type(p_line_type, db_reg.tax_id) THEN

786: FND_FILE.put_line( FND_FILE.LOG, 'INSIDE "Monotrib_Wh_Def_Line" PROCEDURE - Company validation success');
787: ----------------------------------------------------------------------------
788: -- Validate the withholding type is according to distribution line.
789: ----------------------------------------------------------------------------
790: IF JL_ZZ_AP_AWT_DEFAULT_PKG.Validate_Line_Type(p_line_type, db_reg.tax_id) THEN
791: FND_FILE.put_line( FND_FILE.LOG, 'INSIDE "Monotrib_Wh_Def_Line" PROCEDURE - LineType Validation Success');
792: -----------------------------------------------------------------------
793: -- Get the information from Zone, Province and City
794: -----------------------------------------------------------------------

Line 795: JL_ZZ_AP_AWT_DEFAULT_PKG.Province_Zone_City

791: FND_FILE.put_line( FND_FILE.LOG, 'INSIDE "Monotrib_Wh_Def_Line" PROCEDURE - LineType Validation Success');
792: -----------------------------------------------------------------------
793: -- Get the information from Zone, Province and City
794: -----------------------------------------------------------------------
795: JL_ZZ_AP_AWT_DEFAULT_PKG.Province_Zone_City
796: (p_ship_to_loc -- IN
797: ,v_hr_zone -- OUT NOCOPY
798: ,v_hr_province -- OUT NOCOPY
799: ,v_hr_city ); -- OUT NOCOPY

Line 808: IF JL_ZZ_AP_AWT_DEFAULT_PKG.Ver_Territorial_Flag (db_reg.province_code) THEN

804: IF ( db_reg.jurisdiction_type = 'PROVINCIAL') THEN
805: --------------------------------------------------------------------
806: -- Verify if the Withholding Tax for the Province is TERRITORY
807: --------------------------------------------------------------------
808: IF JL_ZZ_AP_AWT_DEFAULT_PKG.Ver_Territorial_Flag (db_reg.province_code) THEN
809: FND_FILE.put_line( FND_FILE.LOG, 'INSIDE "Monotrib_Wh_Def_Line" PROCEDURE - WTax is TERRITORY');
810: -----------------------------------------------------------------
811: -- Validate if the Ship to Location from Inv Dis Line is in the province.
812: -----------------------------------------------------------------

Line 815: JL_ZZ_AP_AWT_DEFAULT_PKG.Insert_AWT_Default

811: -- Validate if the Ship to Location from Inv Dis Line is in the province.
812: -----------------------------------------------------------------
813: IF db_reg.province_code = v_hr_province THEN
814: FND_FILE.put_line( FND_FILE.LOG, 'INSIDE "Monotrib_Wh_Def_Line" PROCEDURE - PROVINCIAL Before Insert');
815: JL_ZZ_AP_AWT_DEFAULT_PKG.Insert_AWT_Default
816: (p_Invoice_Id
817: , p_inv_dist_id
818: , db_reg. supp_awt_code_id
819: , p_calling_sequence

Line 826: JL_ZZ_AP_AWT_DEFAULT_PKG.Insert_AWT_Default

822: END IF;
823: ELSE -- v_territorial_flag = 'N' is Country Wide
824: FND_FILE.put_line( FND_FILE.LOG, 'INSIDE "Monotrib_Wh_Def_Line" PROCEDURE - WTax is NOT TERRITORY');
825: FND_FILE.put_line( FND_FILE.LOG, 'INSIDE "Monotrib_Wh_Def_Line" PROCEDURE - PROVINCIAL Before Insert');
826: JL_ZZ_AP_AWT_DEFAULT_PKG.Insert_AWT_Default
827: (p_Invoice_Id
828: , p_inv_dist_id
829: , db_reg. supp_awt_code_id
830: , p_calling_sequence

Line 840: JL_ZZ_AP_AWT_DEFAULT_PKG.Insert_AWT_Default

836: -- The name of the zone is taken from AP_TAX_CODES Global Att 7
837: ---------------------------------------------------------------
838: IF db_reg.global_attribute7 = v_hr_zone THEN
839: FND_FILE.put_line( FND_FILE.LOG, 'INSIDE "Monotrib_Wh_Def_Line" PROCEDURE - ZONAL Before Insert');
840: JL_ZZ_AP_AWT_DEFAULT_PKG.Insert_AWT_Default
841: (p_Invoice_Id
842: , p_inv_dist_id
843: , db_reg. supp_awt_code_id
844: , p_calling_sequence

Line 855: JL_ZZ_AP_AWT_DEFAULT_PKG.Insert_AWT_Default

851: -- Compare the Withholding Type City with the city in the line
852: ---------------------------------------------------------------
853: IF db_reg.city_code = v_hr_city THEN
854: FND_FILE.put_line( FND_FILE.LOG, 'INSIDE "Monotrib_Wh_Def_Line" PROCEDURE - MUNICIPAL Before Insert');
855: JL_ZZ_AP_AWT_DEFAULT_PKG.Insert_AWT_Default
856: (p_Invoice_Id
857: , p_inv_dist_id
858: , db_reg. supp_awt_code_id
859: , p_calling_sequence

Line 866: JL_ZZ_AP_AWT_DEFAULT_PKG.Insert_AWT_Default

862: END IF;
863:
864: ELSE -- db_reg.jurisdiction_type = 'FEDERAL'
865:
866: JL_ZZ_AP_AWT_DEFAULT_PKG.Insert_AWT_Default
867: (p_Invoice_Id
868: , p_inv_dist_id
869: , db_reg. supp_awt_code_id
870: , p_calling_sequence