364: ,'MIGRATED' -- Record Type
365: ,p_vat_code -- Tax Classification
366: ,'N' -- Self_Assess_Flag
367: ,nvl(p_offset_tax_flag,'N') -- Allow_Offset_Tax_Flag
368: ,fnd_global.user_id -- Who Columns
369: ,SYSDATE -- Who Columns
370: ,fnd_global.user_id -- Who Columns
371: ,SYSDATE -- Who Columns
372: ,FND_GLOBAL.CONC_LOGIN_ID); -- Who Columns
366: ,'N' -- Self_Assess_Flag
367: ,nvl(p_offset_tax_flag,'N') -- Allow_Offset_Tax_Flag
368: ,fnd_global.user_id -- Who Columns
369: ,SYSDATE -- Who Columns
370: ,fnd_global.user_id -- Who Columns
371: ,SYSDATE -- Who Columns
372: ,FND_GLOBAL.CONC_LOGIN_ID); -- Who Columns
373:
374:
368: ,fnd_global.user_id -- Who Columns
369: ,SYSDATE -- Who Columns
370: ,fnd_global.user_id -- Who Columns
371: ,SYSDATE -- Who Columns
372: ,FND_GLOBAL.CONC_LOGIN_ID); -- Who Columns
373:
374:
375: INSERT INTO
376: ZX_REGISTRATIONS(
430: ,NULL -- Rep_Party_Tax_Name
431: ,NULL -- Legal Registration_ID
432: ,'Y' -- Default Registration Flag
433: ,'MIGRATED' -- Record Type
434: ,fnd_global.user_id
435: ,SYSDATE
436: ,fnd_global.user_id
437: ,SYSDATE
438: ,FND_GLOBAL.CONC_LOGIN_ID
432: ,'Y' -- Default Registration Flag
433: ,'MIGRATED' -- Record Type
434: ,fnd_global.user_id
435: ,SYSDATE
436: ,fnd_global.user_id
437: ,SYSDATE
438: ,FND_GLOBAL.CONC_LOGIN_ID
439: FROM zx_party_tax_profile ptp
440: WHERE PTP.Party_ID = P_VENDOR_ID
434: ,fnd_global.user_id
435: ,SYSDATE
436: ,fnd_global.user_id
437: ,SYSDATE
438: ,FND_GLOBAL.CONC_LOGIN_ID
439: FROM zx_party_tax_profile ptp
440: WHERE PTP.Party_ID = P_VENDOR_ID
441: AND PTP.Party_Type_code = 'SUPPLIER');
442:
479: TAX_CLASSIFICATION_CODE=
480: p_vat_code, -- Tax Classification
481: Allow_Offset_Tax_Flag=
482: nvl(p_Offset_Tax_Flag,'N'), -- Allow_Offset_Tax_Flag,
483: Last_updated_By=fnd_global.user_id,
484: Last_update_Date=SYSDATE,
485: Last_update_Login=FND_GLOBAL.CONC_LOGIN_ID
486: WHERE party_tax_profile_id=p_vendor_id and
487: party_type_code ='SUPPLIER';
481: Allow_Offset_Tax_Flag=
482: nvl(p_Offset_Tax_Flag,'N'), -- Allow_Offset_Tax_Flag,
483: Last_updated_By=fnd_global.user_id,
484: Last_update_Date=SYSDATE,
485: Last_update_Login=FND_GLOBAL.CONC_LOGIN_ID
486: WHERE party_tax_profile_id=p_vendor_id and
487: party_type_code ='SUPPLIER';
488:
489: UPDATE ZX_REGISTRATIONS
498: ROUNDING_RULE_CODE = decode(nvl(p_auto_tax_calc_flag,'L'),'L','LINE','H','HEADER','T','HEADER','LINE'),
499: Inclusive_Tax_Flag = nvl(p_amount_includes_tax_flag,'N'),
500: Effective_From = nvl(p_start_date_active, Sysdate),
501: Effective_To = p_end_date_active,
502: Last_Updated_By = fnd_global.user_id,
503: Last_Update_Date = SYSDATE,
504: Last_Update_Login = FND_GLOBAL.CONC_LOGIN_ID
505: WHERE Party_tax_profile_id in (select party_tax_profile_id
506: from zx_party_tax_profile where party_id
500: Effective_From = nvl(p_start_date_active, Sysdate),
501: Effective_To = p_end_date_active,
502: Last_Updated_By = fnd_global.user_id,
503: Last_Update_Date = SYSDATE,
504: Last_Update_Login = FND_GLOBAL.CONC_LOGIN_ID
505: WHERE Party_tax_profile_id in (select party_tax_profile_id
506: from zx_party_tax_profile where party_id
507: = p_vendor_id and party_type_code = 'SUPPLIER');
508:
790: ,'MIGRATED' -- Record Type
791: ,p_vat_code -- Tax Classification
792: ,'N' -- Self_Assess_Flag
793: , nvl(pv.offset_tax_flag,'N') -- Allow_Offset_Tax_Flag
794: , fnd_global.user_id -- Who Columns
795: ,SYSDATE -- Who Columns
796: ,fnd_global.user_id -- Who Columns
797: ,SYSDATE -- Who Columns
798: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns
792: ,'N' -- Self_Assess_Flag
793: , nvl(pv.offset_tax_flag,'N') -- Allow_Offset_Tax_Flag
794: , fnd_global.user_id -- Who Columns
795: ,SYSDATE -- Who Columns
796: ,fnd_global.user_id -- Who Columns
797: ,SYSDATE -- Who Columns
798: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns
799: FROM ap_suppliers Pv
800: WHERE p_Vendor_Site_Id = nvl(P_vendor_site_Id,p_Vendor_site_Id)
794: , fnd_global.user_id -- Who Columns
795: ,SYSDATE -- Who Columns
796: ,fnd_global.user_id -- Who Columns
797: ,SYSDATE -- Who Columns
798: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns
799: FROM ap_suppliers Pv
800: WHERE p_Vendor_Site_Id = nvl(P_vendor_site_Id,p_Vendor_site_Id)
801: AND p_vendor_id = pv.vendor_id
802: AND pv.VENDOR_TYPE_LOOKUP_CODE <> 'TAX AUTHORITY';
852: ,NULL -- Rep_Party_Tax_Name
853: ,NULL -- Legal Registration_ID
854: ,'Y' -- Default Registration Flag
855: ,'MIGRATED' -- Record Type
856: ,fnd_global.user_id
857: ,SYSDATE
858: ,fnd_global.user_id
859: ,SYSDATE
860: ,FND_GLOBAL.CONC_LOGIN_ID
854: ,'Y' -- Default Registration Flag
855: ,'MIGRATED' -- Record Type
856: ,fnd_global.user_id
857: ,SYSDATE
858: ,fnd_global.user_id
859: ,SYSDATE
860: ,FND_GLOBAL.CONC_LOGIN_ID
861: FROM ap_suppliers PV,
862: zx_party_tax_profile PTP
856: ,fnd_global.user_id
857: ,SYSDATE
858: ,fnd_global.user_id
859: ,SYSDATE
860: ,FND_GLOBAL.CONC_LOGIN_ID
861: FROM ap_suppliers PV,
862: zx_party_tax_profile PTP
863: WHERE
864: P_vendor_site_id = PTP.Party_ID
894: p_GLOBAL_ATTRIBUTE18, --REPORTING_CODE_CHAR_VALUE
895: null, --EXCEPTION_CODE
896: sysdate, --EFFECTIVE_FROM
897: null, --EFFECTIVE_TO
898: fnd_global.user_id,
899: sysdate,
900: fnd_global.user_id,
901: sysdate,
902: fnd_global.conc_login_id
896: sysdate, --EFFECTIVE_FROM
897: null, --EFFECTIVE_TO
898: fnd_global.user_id,
899: sysdate,
900: fnd_global.user_id,
901: sysdate,
902: fnd_global.conc_login_id
903: FROM zx_party_tax_profile ptp ,
904: zx_reporting_types_b
898: fnd_global.user_id,
899: sysdate,
900: fnd_global.user_id,
901: sysdate,
902: fnd_global.conc_login_id
903: FROM zx_party_tax_profile ptp ,
904: zx_reporting_types_b
905: WHERE ptp.party_id = p_vendor_site_id and
906: ptp.Party_Type_Code = 'SUPPLIER_SITE' and
930: p_GLOBAL_ATTRIBUTE19, --REPORTING_CODE_NUM_VALUE
931: null, --EXCEPTION_CODE
932: sysdate, --EFFECTIVE_FROM
933: p_GLOBAL_ATTRIBUTE20, --EFFECTIVE_TO
934: fnd_global.user_id,
935: sysdate,
936: fnd_global.user_id,
937: sysdate,
938: fnd_global.conc_login_id
932: sysdate, --EFFECTIVE_FROM
933: p_GLOBAL_ATTRIBUTE20, --EFFECTIVE_TO
934: fnd_global.user_id,
935: sysdate,
936: fnd_global.user_id,
937: sysdate,
938: fnd_global.conc_login_id
939: FROM zx_party_tax_profile ptp ,
940: zx_reporting_types_b
934: fnd_global.user_id,
935: sysdate,
936: fnd_global.user_id,
937: sysdate,
938: fnd_global.conc_login_id
939: FROM zx_party_tax_profile ptp ,
940: zx_reporting_types_b
941: WHERE ptp.party_id = p_vendor_site_id and
942: ptp.Party_Type_Code = 'SUPPLIER_SITE' and
998: ,NULL -- Rep_Party_Tax_Name
999: ,NULL -- Legal Registration_ID
1000: ,'Y' -- Default Registration Flag
1001: ,'MIGRATED' -- Record Type
1002: ,fnd_global.user_id
1003: ,SYSDATE
1004: ,fnd_global.user_id
1005: ,SYSDATE
1006: ,FND_GLOBAL.CONC_LOGIN_ID
1000: ,'Y' -- Default Registration Flag
1001: ,'MIGRATED' -- Record Type
1002: ,fnd_global.user_id
1003: ,SYSDATE
1004: ,fnd_global.user_id
1005: ,SYSDATE
1006: ,FND_GLOBAL.CONC_LOGIN_ID
1007: FROM ap_supplier_sites_all PVS,
1008: ap_suppliers PV,
1002: ,fnd_global.user_id
1003: ,SYSDATE
1004: ,fnd_global.user_id
1005: ,SYSDATE
1006: ,FND_GLOBAL.CONC_LOGIN_ID
1007: FROM ap_supplier_sites_all PVS,
1008: ap_suppliers PV,
1009: zx_party_tax_profile PTP
1010: WHERE p_vendor_site_id = PTP.Party_ID
1064: ,NULL -- Rep_Party_Tax_Name
1065: ,NULL -- Legal Registration_ID
1066: ,'N' -- Default Registration Flag
1067: ,'MIGRATED' -- Record Type
1068: ,fnd_global.user_id
1069: ,SYSDATE
1070: ,fnd_global.user_id
1071: ,SYSDATE
1072: ,FND_GLOBAL.CONC_LOGIN_ID
1066: ,'N' -- Default Registration Flag
1067: ,'MIGRATED' -- Record Type
1068: ,fnd_global.user_id
1069: ,SYSDATE
1070: ,fnd_global.user_id
1071: ,SYSDATE
1072: ,FND_GLOBAL.CONC_LOGIN_ID
1073: FROM ap_suppliers PV,
1074: zx_party_tax_profile PTP
1068: ,fnd_global.user_id
1069: ,SYSDATE
1070: ,fnd_global.user_id
1071: ,SYSDATE
1072: ,FND_GLOBAL.CONC_LOGIN_ID
1073: FROM ap_suppliers PV,
1074: zx_party_tax_profile PTP
1075: WHERE p_vendor_site_id = PTP.Party_ID
1076: AND PTP.Party_Type_code = 'SUPPLIER_SITE'
1128: ,NULL -- Rep_Party_Tax_Name
1129: ,NULL -- Legal Registration_ID
1130: ,'N' -- Default Registration Flag
1131: ,'MIGRATED' -- Record Type
1132: ,fnd_global.user_id
1133: ,SYSDATE
1134: ,fnd_global.user_id
1135: ,SYSDATE
1136: ,FND_GLOBAL.CONC_LOGIN_ID
1130: ,'N' -- Default Registration Flag
1131: ,'MIGRATED' -- Record Type
1132: ,fnd_global.user_id
1133: ,SYSDATE
1134: ,fnd_global.user_id
1135: ,SYSDATE
1136: ,FND_GLOBAL.CONC_LOGIN_ID
1137: FROM ap_supplier_sites_all PVS,
1138: ap_suppliers PV,
1132: ,fnd_global.user_id
1133: ,SYSDATE
1134: ,fnd_global.user_id
1135: ,SYSDATE
1136: ,FND_GLOBAL.CONC_LOGIN_ID
1137: FROM ap_supplier_sites_all PVS,
1138: ap_suppliers PV,
1139: zx_party_tax_profile PTP
1140: WHERE p_vendor_site_id = PTP.Party_ID
1160: DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN', 'UP'),
1161: Inclusive_Tax_Flag=nvl(p_amount_includes_tax_flag, 'N'),
1162: TAX_CLASSIFICATION_CODE=p_vat_code, -- Tax Classification
1163: Allow_Offset_Tax_Flag =nvl(p_offset_tax_flag,'N'), -- Allow_Offset_Tax_Flag
1164: Last_Updated_By=fnd_global.user_id,
1165: Last_Update_Date=SYSDATE,
1166: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1167: WHERE party_tax_profile_id= p_VENDOR_SITE_ID
1168: and party_TYPE_CODE = 'SUPPLIER_SITE'
1162: TAX_CLASSIFICATION_CODE=p_vat_code, -- Tax Classification
1163: Allow_Offset_Tax_Flag =nvl(p_offset_tax_flag,'N'), -- Allow_Offset_Tax_Flag
1164: Last_Updated_By=fnd_global.user_id,
1165: Last_Update_Date=SYSDATE,
1166: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1167: WHERE party_tax_profile_id= p_VENDOR_SITE_ID
1168: and party_TYPE_CODE = 'SUPPLIER_SITE'
1169: and p_vendor_id in ( SELECT vendor_id
1170: FROM ap_suppliers
1181: UPDATE ZX_REGISTRATIONS
1182: SET Registration_Number = P_Vat_Registration_Num, -- Reg Number
1183: ROUNDING_RULE_CODE = DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN', 'UP'),
1184: Inclusive_Tax_Flag=nvl(p_amount_includes_tax_flag, 'N'),
1185: Last_Updated_By=fnd_global.user_id,
1186: Last_Update_Date=SYSDATE,
1187: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1188: WHERE Party_tax_profile_id in (select party_tax_profile_id
1189: from zx_party_tax_profile where party_id
1183: ROUNDING_RULE_CODE = DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN', 'UP'),
1184: Inclusive_Tax_Flag=nvl(p_amount_includes_tax_flag, 'N'),
1185: Last_Updated_By=fnd_global.user_id,
1186: Last_Update_Date=SYSDATE,
1187: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1188: WHERE Party_tax_profile_id in (select party_tax_profile_id
1189: from zx_party_tax_profile where party_id
1190: = p_vendor_site_id and party_type_code = 'SUPPLIER_SITE');
1191:
1199: -- Update the Fiscal Printer Codes into Association table
1200:
1201: UPDATE ZX_REPORT_CODES_ASSOC
1202: SET REPORTING_CODE_CHAR_VALUE = p_GLOBAL_ATTRIBUTE18,
1203: LAST_UPDATED_BY = fnd_global.user_id,
1204: LAST_UPDATE_DATE = sysdate,
1205: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
1206: WHERE ENTITY_CODE = 'ZX_PARTY_TAX_PROFILE' AND
1207: REPORTING_TYPE_ID = (SELECT REPORTING_TYPE_ID
1201: UPDATE ZX_REPORT_CODES_ASSOC
1202: SET REPORTING_CODE_CHAR_VALUE = p_GLOBAL_ATTRIBUTE18,
1203: LAST_UPDATED_BY = fnd_global.user_id,
1204: LAST_UPDATE_DATE = sysdate,
1205: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
1206: WHERE ENTITY_CODE = 'ZX_PARTY_TAX_PROFILE' AND
1207: REPORTING_TYPE_ID = (SELECT REPORTING_TYPE_ID
1208: FROM ZX_REPORTING_TYPES_B
1209: WHERE REPORTING_TYPE_CODE ='FISCAL PRINTER')
1217:
1218: UPDATE ZX_REPORT_CODES_ASSOC
1219: SET REPORTING_CODE_NUM_VALUE = p_GLOBAL_ATTRIBUTE19,
1220: EFFECTIVE_TO = p_GLOBAL_ATTRIBUTE20,
1221: LAST_UPDATED_BY = fnd_global.user_id,
1222: LAST_UPDATE_DATE = sysdate,
1223: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
1224: WHERE ENTITY_CODE = 'ZX_PARTY_TAX_PROFILE' AND
1225: REPORTING_TYPE_ID = (SELECT REPORTING_TYPE_ID
1219: SET REPORTING_CODE_NUM_VALUE = p_GLOBAL_ATTRIBUTE19,
1220: EFFECTIVE_TO = p_GLOBAL_ATTRIBUTE20,
1221: LAST_UPDATED_BY = fnd_global.user_id,
1222: LAST_UPDATE_DATE = sysdate,
1223: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
1224: WHERE ENTITY_CODE = 'ZX_PARTY_TAX_PROFILE' AND
1225: REPORTING_TYPE_ID = (SELECT REPORTING_TYPE_ID
1226: FROM ZX_REPORTING_TYPES_B
1227: WHERE REPORTING_TYPE_CODE ='CAI NUMBER')
1241: SET Registration_Number = p_Global_Attribute10||' / '||p_Global_Attribute11||' / '||p_Global_Attribute12, --Reg Num
1242: Tax_Regime_Code = 'BR-IPI',
1243: ROUNDING_RULE_CODE= DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN', 'UP'),
1244: Inclusive_Tax_Flag=nvl(p_amount_includes_tax_flag, 'N'),
1245: Last_Updated_By=fnd_global.user_id,
1246: Last_Update_Date=SYSDATE,
1247: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1248: WHERE Party_tax_profile_id in (select party_tax_profile_id
1249: from zx_party_tax_profile where party_id
1243: ROUNDING_RULE_CODE= DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN', 'UP'),
1244: Inclusive_Tax_Flag=nvl(p_amount_includes_tax_flag, 'N'),
1245: Last_Updated_By=fnd_global.user_id,
1246: Last_Update_Date=SYSDATE,
1247: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1248: WHERE Party_tax_profile_id in (select party_tax_profile_id
1249: from zx_party_tax_profile where party_id
1250: = p_vendor_site_id and party_type_code = 'SUPPLIER_SITE');
1251:
1256: SET Registration_Number = p_Global_Attribute13,-- State Registration Num,
1257: Tax_Regime_Code = 'BR-ICMS',
1258: ROUNDING_RULE_CODE = DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN', 'UP'),
1259: Inclusive_Tax_Flag =nvl(p_amount_includes_tax_flag, 'N'),
1260: Last_Updated_By=fnd_global.user_id,
1261: Last_Update_Date=SYSDATE,
1262: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1263: WHERE Party_tax_profile_id in (select party_tax_profile_id
1264: from zx_party_tax_profile where party_id
1258: ROUNDING_RULE_CODE = DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN', 'UP'),
1259: Inclusive_Tax_Flag =nvl(p_amount_includes_tax_flag, 'N'),
1260: Last_Updated_By=fnd_global.user_id,
1261: Last_Update_Date=SYSDATE,
1262: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1263: WHERE Party_tax_profile_id in (select party_tax_profile_id
1264: from zx_party_tax_profile where party_id
1265: = p_vendor_site_id and party_type_code = 'SUPPLIER_SITE');
1266:
1271: SET Registration_Number = p_Global_Attribute14,-- City Registration Num,
1272: Tax_Regime_Code = 'BR-ISS',
1273: ROUNDING_RULE_CODE = DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN', 'UP'),
1274: Inclusive_Tax_Flag =nvl(p_amount_includes_tax_flag, 'N'),
1275: Last_Updated_By=fnd_global.user_id,
1276: Last_Update_Date=SYSDATE,
1277: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1278: WHERE Party_tax_profile_id in (select party_tax_profile_id
1279: from zx_party_tax_profile where party_id
1273: ROUNDING_RULE_CODE = DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN', 'UP'),
1274: Inclusive_Tax_Flag =nvl(p_amount_includes_tax_flag, 'N'),
1275: Last_Updated_By=fnd_global.user_id,
1276: Last_Update_Date=SYSDATE,
1277: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1278: WHERE Party_tax_profile_id in (select party_tax_profile_id
1279: from zx_party_tax_profile where party_id
1280: = p_vendor_site_id and party_type_code = 'SUPPLIER_SITE');
1281: