eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_UPGRADE_CONTROL_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 302: FROM ap_suppliers POV , ZX_PARTY_TAX_PROFILE PTP

298: P_bank_charge_bearer IN VARCHAR2) IS
299:
300: CURSOR C_SUPPLIER_TYPE IS
301: SELECT POV.VENDOR_ID
302: FROM ap_suppliers POV , ZX_PARTY_TAX_PROFILE PTP
303: WHERE POV.VENDOR_ID = PTP.PARTY_ID
304: AND POV.VENDOR_ID = p_vendor_id
305: AND PTP.PARTY_TYPE_CODE = 'SUPPLIER'
306: AND VENDOR_TYPE_LOOKUP_CODE is not null

Line 309: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type;

305: AND PTP.PARTY_TYPE_CODE = 'SUPPLIER'
306: AND VENDOR_TYPE_LOOKUP_CODE is not null
307: AND VENDOR_TYPE_LOOKUP_CODE <> 'TAX AUTHORITY';
308:
309: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type;
310: l_status fnd_module_installations.status%TYPE;
311: l_db_status fnd_module_installations.DB_STATUS%TYPE;
312:
313: BEGIN

Line 319: ZX_PARTY_TAX_PROFILE(

315: IF P_DML_TYPE = 'I' THEN
316: arp_util_tax.debug(' Insert of SYNC SUPPLIERS(+) ' );
317:
318: INSERT INTO
319: ZX_PARTY_TAX_PROFILE(
320: Party_Tax_Profile_Id
321: ,Party_Id
322: ,Party_Type_code
323: ,Customer_Flag

Line 347: ZX_PARTY_TAX_PROFILE_S.NEXTVAL

343: ,Last_Updated_By
344: ,Last_Update_Date
345: ,Last_Update_Login)
346: VALUES(
347: ZX_PARTY_TAX_PROFILE_S.NEXTVAL
348: ,P_VENDOR_ID -- Party ID
349: ,'SUPPLIER' -- Party Type
350: ,'N' -- Customer_Flag
351: ,'N' -- First Party

Line 439: FROM zx_party_tax_profile ptp

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:
443: arp_util_tax.debug(' Now calling SUPPLIER_TYPE_EXTRACT ' );

Line 447: FROM ZX_PARTY_TAX_PROFILE PTP

443: arp_util_tax.debug(' Now calling SUPPLIER_TYPE_EXTRACT ' );
444:
445: SELECT PTP.PARTY_TAX_PROFILE_ID
446: INTO l_party_tax_profile_id
447: FROM ZX_PARTY_TAX_PROFILE PTP
448: WHERE PTP.PARTY_ID= P_VENDOR_ID
449: AND PTP.PARTY_TYPE_CODE = 'SUPPLIER'
450: AND P_Vendor_Type_Lookup_Code is not null
451: AND P_Vendor_Type_Lookup_Code <> 'TAX AUTHORITY' ;

Line 455: (p_party_source=>'ZX_PARTY_TAX_PROFILE',

451: AND P_Vendor_Type_Lookup_Code <> 'TAX AUTHORITY' ;
452:
453:
454: ZX_PTP_MIGRATE_PKG.Party_Assoc_Extract
455: (p_party_source=>'ZX_PARTY_TAX_PROFILE',
456: p_party_tax_profile_id => l_party_tax_profile_id,
457: p_fiscal_class_type_code=> 'SUPPLIER_TYPE',
458: p_fiscal_classification_code=>P_Vendor_Type_Lookup_Code,
459: p_dml_type =>'I');

Line 470: UPDATE ZX_PARTY_TAX_PROFILE

466:
467: arp_util_tax.debug(' Update of SYNC SUPPLIERS (+) ' );
468:
469:
470: UPDATE ZX_PARTY_TAX_PROFILE
471: SET Rounding_Level_code =
472: decode(nvl(p_auto_tax_calc_flag,'L'),'L','LINE','H','HEADER','T','HEADER','LINE'),
473: Process_For_Applicability_Flag =
474: decode(nvl(p_auto_tax_calc_flag, 'N'), 'N', 'N', 'Y'),

Line 506: from zx_party_tax_profile where party_id

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:
509:
510: SELECT PTP.PARTY_TAX_PROFILE_ID

Line 512: FROM ZX_PARTY_TAX_PROFILE PTP

508:
509:
510: SELECT PTP.PARTY_TAX_PROFILE_ID
511: INTO l_party_tax_profile_id
512: FROM ZX_PARTY_TAX_PROFILE PTP
513: WHERE PTP.PARTY_ID= P_VENDOR_ID
514: AND PTP.PARTY_TYPE_CODE = 'SUPPLIER'
515: AND P_VENDOR_TYPE_LOOKUP_CODE is not null
516: AND P_VENDOR_TYPE_LOOKUP_CODE <> 'TAX AUTHORITY';

Line 520: (p_party_source=>'ZX_PARTY_TAX_PROFILE',

516: AND P_VENDOR_TYPE_LOOKUP_CODE <> 'TAX AUTHORITY';
517:
518:
519: ZX_PTP_MIGRATE_PKG.Party_Assoc_Extract
520: (p_party_source=>'ZX_PARTY_TAX_PROFILE',
521: p_party_tax_profile_id => l_party_tax_profile_id,
522: p_fiscal_class_type_code=> 'SUPPLIER_TYPE',
523: p_fiscal_classification_code=>P_Vendor_Type_Lookup_Code,
524: p_dml_type =>'U');

Line 744: INSERT INTO ZX_PARTY_TAX_PROFILE(

740:
741: IF P_DML_TYPE = 'I' THEN
742: arp_util_tax.debug(' SYNC_SUPPLIER_SITES(+) ' );
743:
744: INSERT INTO ZX_PARTY_TAX_PROFILE(
745: Party_Tax_Profile_Id
746: ,Party_Id
747: ,Party_Type_code
748: ,Customer_Flag

Line 772: ZX_PARTY_TAX_PROFILE_S.NEXTVAL

768: ,Last_Updated_By
769: ,Last_Update_Date
770: ,Last_Update_Login)
771: SELECT
772: ZX_PARTY_TAX_PROFILE_S.NEXTVAL
773: ,p_VENDOR_SITE_ID -- Party ID
774: ,'SUPPLIER_SITE' -- Party Type
775: ,'N' -- Customer_Flag
776: ,'N' -- First Party

Line 862: zx_party_tax_profile PTP

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
865: AND PTP.Party_Type_code = 'SUPPLIER_SITE'
866: AND P_Vendor_ID = PV.Vendor_ID);

Line 891: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE

887: LAST_UPDATE_DATE,
888: LAST_UPDATE_LOGIN)
889: (SELECT
890: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
891: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
892: ptp.Party_Tax_Profile_Id, --ENTITY_ID
893: REPORTING_TYPE_ID , --REPORTING_TYPE_ID
894: p_GLOBAL_ATTRIBUTE18, --REPORTING_CODE_CHAR_VALUE
895: null, --EXCEPTION_CODE

Line 903: FROM zx_party_tax_profile ptp ,

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
907: reporting_type_code = 'FISCAL PRINTER');

Line 927: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE

923: LAST_UPDATE_DATE,
924: LAST_UPDATE_LOGIN)
925: (SELECT
926: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
927: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
928: ptp.Party_Tax_Profile_Id, --ENTITY_ID
929: REPORTING_TYPE_ID, --REPORTING_TYPE_ID
930: p_GLOBAL_ATTRIBUTE19, --REPORTING_CODE_NUM_VALUE
931: null, --EXCEPTION_CODE

Line 939: FROM zx_party_tax_profile ptp ,

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
943: reporting_type_code = 'CAI NUMBER');

Line 1009: zx_party_tax_profile PTP

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
1011: AND PTP.Party_Type_code = 'SUPPLIER_SITE'
1012: AND p_Vendor_ID = PV.Vendor_ID);
1013:

Line 1074: zx_party_tax_profile PTP

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'
1077: AND p_Vendor_ID = PV.Vendor_ID;
1078:

Line 1139: zx_party_tax_profile PTP

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
1141: AND PTP.Party_Type_code = 'SUPPLIER_SITE'
1142: AND p_Vendor_ID = PV.Vendor_ID);
1143:

Line 1154: UPDATE ZX_PARTY_TAX_PROFILE

1150:
1151: arp_util_tax.debug(' Update of SYNC_SUPPLIER_SITES(+) ' );
1152:
1153:
1154: UPDATE ZX_PARTY_TAX_PROFILE
1155: SET
1156: Rounding_Level_code= decode(nvl(p_auto_tax_calc_flag,'L'),'L','LINE','H','HEADER','T','HEADER','LINE'),
1157: Process_For_Applicability_Flag =
1158: decode(nvl(p_auto_tax_calc_flag, 'N'), 'N', 'N', 'Y'),

Line 1189: from zx_party_tax_profile where party_id

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:
1192:
1193: -- Verify Argentina Installation

Line 1206: WHERE ENTITY_CODE = 'ZX_PARTY_TAX_PROFILE' AND

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')
1210: AND ENTITY_ID in (SELECT Party_Tax_Profile_Id

Line 1211: FROM zx_party_tax_profile ptp

1207: REPORTING_TYPE_ID = (SELECT REPORTING_TYPE_ID
1208: FROM ZX_REPORTING_TYPES_B
1209: WHERE REPORTING_TYPE_CODE ='FISCAL PRINTER')
1210: AND ENTITY_ID in (SELECT Party_Tax_Profile_Id
1211: FROM zx_party_tax_profile ptp
1212: WHERE ptp.party_id = p_vendor_site_id
1213: AND ptp.Party_Type_Code = 'SUPPLIER_SITE');
1214:
1215:

Line 1224: WHERE ENTITY_CODE = 'ZX_PARTY_TAX_PROFILE' AND

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')
1228: AND ENTITY_ID in (SELECT Party_Tax_Profile_Id

Line 1229: FROM zx_party_tax_profile ptp

1225: REPORTING_TYPE_ID = (SELECT REPORTING_TYPE_ID
1226: FROM ZX_REPORTING_TYPES_B
1227: WHERE REPORTING_TYPE_CODE ='CAI NUMBER')
1228: AND ENTITY_ID in (SELECT Party_Tax_Profile_Id
1229: FROM zx_party_tax_profile ptp
1230: WHERE ptp.party_id = p_vendor_site_id
1231: AND ptp.Party_Type_Code = 'SUPPLIER_SITE');
1232:
1233: END IF; -- end of Argentina Installation verification

Line 1249: from zx_party_tax_profile where party_id

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:
1252:
1253: -- Updates Records for State Inscription

Line 1264: from zx_party_tax_profile where party_id

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:
1267:
1268: -- Updates Records for Municipal Inscription

Line 1279: from zx_party_tax_profile where party_id

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:
1282:
1283: END IF; -- Brazil Localizations

Line 3336: FROM zx_party_tax_profile

3332: ) IS
3333:
3334: CURSOR pty_org_id_cur IS
3335: SELECT party_tax_profile_id
3336: FROM zx_party_tax_profile
3337: WHERE party_id = P_ORG_ID
3338: AND party_type_code = 'OU';
3339:
3340: CURSOR regm_id IS