DBA Data[Home] [Help]

APPS.ZX_UPGRADE_CONTROL_PKG dependencies on ZX_REGISTRATIONS

Line 376: ZX_REGISTRATIONS(

372: ,FND_GLOBAL.CONC_LOGIN_ID); -- Who Columns
373:
374:
375: INSERT INTO
376: ZX_REGISTRATIONS(
377: Registration_Id,
378: Registration_Type_Code,
379: Registration_Number,
380: Registration_Status_Code,

Line 405: ZX_REGISTRATIONS_S.NEXTVAL

401: Last_Updated_By,
402: Last_Update_Date,
403: Last_Update_Login)
404: (SELECT
405: ZX_REGISTRATIONS_S.NEXTVAL
406: ,Null -- Type
407: ,decode(p_GLOBAL_ATTRIBUTE_CATEGORY,
408: 'JL.AR.APXVDMVD.SUPPLIERS',p_Global_Attribute12,
409: 'JL.CL.APXVDMVD.SUPPLIERS',p_Global_Attribute12,

Line 489: UPDATE ZX_REGISTRATIONS

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
490: SET Registration_Number = decode(p_GLOBAL_ATTRIBUTE_CATEGORY,
491: 'JL.AR.APXVDMVD.SUPPLIERS',p_Global_Attribute12,
492: 'JL.CL.APXVDMVD.SUPPLIERS',p_Global_Attribute12,
493: 'JL.CO.APXVDMVD.SUPPLIERS',p_Global_Attribute12,

Line 805: INSERT INTO ZX_REGISTRATIONS(

801: AND p_vendor_id = pv.vendor_id
802: AND pv.VENDOR_TYPE_LOOKUP_CODE <> 'TAX AUTHORITY';
803:
804:
805: INSERT INTO ZX_REGISTRATIONS(
806: Registration_Id,
807: Registration_Type_Code,
808: Registration_Number,
809: Registration_Status_Code,

Line 834: ZX_REGISTRATIONS_S.NEXTVAL

830: Last_Updated_By,
831: Last_Update_Date,
832: Last_Update_Login)
833: (SELECT
834: ZX_REGISTRATIONS_S.NEXTVAL
835: ,NULL -- Registration type code
836: ,P_Vat_Registration_Num --Reg Number
837: ,'REGISTERED' -- Registration_Status_code
838: ,'EXPLICIT' -- Registration_Source_Code

Line 951: INSERT INTO ZX_REGISTRATIONS(

947: IF (p_GLOBAL_ATTRIBUTE_CATEGORY = 'JL.BR.APXVDMVD.SITES') THEN
948:
949: -- Inserts Records for CNPJ
950:
951: INSERT INTO ZX_REGISTRATIONS(
952: Registration_Id,
953: Registration_Type_Code,
954: Registration_Number,
955: Registration_Status_Code,

Line 980: ZX_REGISTRATIONS_S.NEXTVAL

976: Last_Updated_By,
977: Last_Update_Date,
978: Last_Update_Login)
979: (SELECT
980: ZX_REGISTRATIONS_S.NEXTVAL
981: ,'CNPJ' -- Type
982: ,p_Global_Attribute10 ||' / '|| p_Global_Attribute11 ||' / '|| p_Global_Attribute12 --Reg Number
983: ,'REGISTERED' -- Registration_Status_code
984: ,'EXPLICIT'

Line 1017: INSERT INTO ZX_REGISTRATIONS(

1013:
1014:
1015: -- Inserts Records for State Inscription
1016:
1017: INSERT INTO ZX_REGISTRATIONS(
1018: Registration_Id,
1019: Registration_Type_Code,
1020: Registration_Number,
1021: Registration_Status_Code,

Line 1046: ZX_REGISTRATIONS_S.NEXTVAL

1042: Last_Updated_By,
1043: Last_Update_Date,
1044: Last_Update_Login)
1045: SELECT
1046: ZX_REGISTRATIONS_S.NEXTVAL
1047: ,'STATE INSCRIPTION' -- Type
1048: ,p_Global_Attribute13 -- State Registration Num
1049: ,'REGISTERED' -- Registration_Status_Code
1050: ,'EXPLICIT'

Line 1081: INSERT INTO ZX_REGISTRATIONS(

1077: AND p_Vendor_ID = PV.Vendor_ID;
1078:
1079: -- Inserts Records for Municipal Inscription
1080:
1081: INSERT INTO ZX_REGISTRATIONS(
1082: Registration_Id,
1083: Registration_Type_Code,
1084: Registration_Number,
1085: Registration_Status_Code,

Line 1110: ZX_REGISTRATIONS_S.NEXTVAL

1106: Last_Updated_By,
1107: Last_Update_Date,
1108: Last_Update_Login)
1109: (SELECT
1110: ZX_REGISTRATIONS_S.NEXTVAL
1111: ,'CITY INSCRIPTION' -- Type
1112: ,p_Global_Attribute14 -- City Registration Num
1113: ,'REGISTERED' -- Registration_Status_Code
1114: ,'EXPLICIT'

Line 1181: UPDATE ZX_REGISTRATIONS

1177: FROM ap_suppliers
1178: WHERE vendor_id=p_Vendor_id;
1179:
1180:
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,

Line 1240: UPDATE ZX_REGISTRATIONS

1236: IF (p_GLOBAL_ATTRIBUTE_CATEGORY = 'JL.BR.APXVDMVD.SITES') THEN
1237:
1238: -- Updates Records for CNPJ
1239:
1240: UPDATE ZX_REGISTRATIONS
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'),

Line 1255: UPDATE ZX_REGISTRATIONS

1251:
1252:
1253: -- Updates Records for State Inscription
1254:
1255: UPDATE ZX_REGISTRATIONS
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'),

Line 1270: UPDATE ZX_REGISTRATIONS

1266:
1267:
1268: -- Updates Records for Municipal Inscription
1269:
1270: UPDATE ZX_REGISTRATIONS
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'),