1033: -- is referenced in various APIs that need to access party tax profile information
1034: -- Also referenced in zxccontrolb.pls/zxdiroundtaxpkgb.pls
1035:
1036: TYPE PARTY_TAX_PROF_INFO_REC_TYPE is record
1037: ( PARTY_TAX_PROFILE_ID zx_party_tax_profile.PARTY_TAX_PROFILE_ID%TYPE,
1038: PARTY_ID zx_party_tax_profile.PARTY_ID%TYPE,
1039: PARTY_TYPE_CODE zx_party_tax_profile.PARTY_TYPE_CODE%TYPE,
1040: SUPPLIER_FLAG zx_party_tax_profile.SUPPLIER_FLAG%TYPE,
1041: CUSTOMER_FLAG zx_party_tax_profile.CUSTOMER_FLAG%TYPE,
1034: -- Also referenced in zxccontrolb.pls/zxdiroundtaxpkgb.pls
1035:
1036: TYPE PARTY_TAX_PROF_INFO_REC_TYPE is record
1037: ( PARTY_TAX_PROFILE_ID zx_party_tax_profile.PARTY_TAX_PROFILE_ID%TYPE,
1038: PARTY_ID zx_party_tax_profile.PARTY_ID%TYPE,
1039: PARTY_TYPE_CODE zx_party_tax_profile.PARTY_TYPE_CODE%TYPE,
1040: SUPPLIER_FLAG zx_party_tax_profile.SUPPLIER_FLAG%TYPE,
1041: CUSTOMER_FLAG zx_party_tax_profile.CUSTOMER_FLAG%TYPE,
1042: SITE_FLAG zx_party_tax_profile.SITE_FLAG%TYPE,
1035:
1036: TYPE PARTY_TAX_PROF_INFO_REC_TYPE is record
1037: ( PARTY_TAX_PROFILE_ID zx_party_tax_profile.PARTY_TAX_PROFILE_ID%TYPE,
1038: PARTY_ID zx_party_tax_profile.PARTY_ID%TYPE,
1039: PARTY_TYPE_CODE zx_party_tax_profile.PARTY_TYPE_CODE%TYPE,
1040: SUPPLIER_FLAG zx_party_tax_profile.SUPPLIER_FLAG%TYPE,
1041: CUSTOMER_FLAG zx_party_tax_profile.CUSTOMER_FLAG%TYPE,
1042: SITE_FLAG zx_party_tax_profile.SITE_FLAG%TYPE,
1043: PROCESS_FOR_APPLICABILITY_FLAG zx_party_tax_profile.PROCESS_FOR_APPLICABILITY_FLAG%TYPE,
1036: TYPE PARTY_TAX_PROF_INFO_REC_TYPE is record
1037: ( PARTY_TAX_PROFILE_ID zx_party_tax_profile.PARTY_TAX_PROFILE_ID%TYPE,
1038: PARTY_ID zx_party_tax_profile.PARTY_ID%TYPE,
1039: PARTY_TYPE_CODE zx_party_tax_profile.PARTY_TYPE_CODE%TYPE,
1040: SUPPLIER_FLAG zx_party_tax_profile.SUPPLIER_FLAG%TYPE,
1041: CUSTOMER_FLAG zx_party_tax_profile.CUSTOMER_FLAG%TYPE,
1042: SITE_FLAG zx_party_tax_profile.SITE_FLAG%TYPE,
1043: PROCESS_FOR_APPLICABILITY_FLAG zx_party_tax_profile.PROCESS_FOR_APPLICABILITY_FLAG%TYPE,
1044: ROUNDING_LEVEL_CODE zx_party_tax_profile.ROUNDING_LEVEL_CODE%TYPE,
1037: ( PARTY_TAX_PROFILE_ID zx_party_tax_profile.PARTY_TAX_PROFILE_ID%TYPE,
1038: PARTY_ID zx_party_tax_profile.PARTY_ID%TYPE,
1039: PARTY_TYPE_CODE zx_party_tax_profile.PARTY_TYPE_CODE%TYPE,
1040: SUPPLIER_FLAG zx_party_tax_profile.SUPPLIER_FLAG%TYPE,
1041: CUSTOMER_FLAG zx_party_tax_profile.CUSTOMER_FLAG%TYPE,
1042: SITE_FLAG zx_party_tax_profile.SITE_FLAG%TYPE,
1043: PROCESS_FOR_APPLICABILITY_FLAG zx_party_tax_profile.PROCESS_FOR_APPLICABILITY_FLAG%TYPE,
1044: ROUNDING_LEVEL_CODE zx_party_tax_profile.ROUNDING_LEVEL_CODE%TYPE,
1045: WITHHOLDING_START_DATE zx_party_tax_profile.WITHHOLDING_START_DATE%TYPE,
1038: PARTY_ID zx_party_tax_profile.PARTY_ID%TYPE,
1039: PARTY_TYPE_CODE zx_party_tax_profile.PARTY_TYPE_CODE%TYPE,
1040: SUPPLIER_FLAG zx_party_tax_profile.SUPPLIER_FLAG%TYPE,
1041: CUSTOMER_FLAG zx_party_tax_profile.CUSTOMER_FLAG%TYPE,
1042: SITE_FLAG zx_party_tax_profile.SITE_FLAG%TYPE,
1043: PROCESS_FOR_APPLICABILITY_FLAG zx_party_tax_profile.PROCESS_FOR_APPLICABILITY_FLAG%TYPE,
1044: ROUNDING_LEVEL_CODE zx_party_tax_profile.ROUNDING_LEVEL_CODE%TYPE,
1045: WITHHOLDING_START_DATE zx_party_tax_profile.WITHHOLDING_START_DATE%TYPE,
1046: ALLOW_AWT_FLAG zx_party_tax_profile.ALLOW_AWT_FLAG%TYPE,
1039: PARTY_TYPE_CODE zx_party_tax_profile.PARTY_TYPE_CODE%TYPE,
1040: SUPPLIER_FLAG zx_party_tax_profile.SUPPLIER_FLAG%TYPE,
1041: CUSTOMER_FLAG zx_party_tax_profile.CUSTOMER_FLAG%TYPE,
1042: SITE_FLAG zx_party_tax_profile.SITE_FLAG%TYPE,
1043: PROCESS_FOR_APPLICABILITY_FLAG zx_party_tax_profile.PROCESS_FOR_APPLICABILITY_FLAG%TYPE,
1044: ROUNDING_LEVEL_CODE zx_party_tax_profile.ROUNDING_LEVEL_CODE%TYPE,
1045: WITHHOLDING_START_DATE zx_party_tax_profile.WITHHOLDING_START_DATE%TYPE,
1046: ALLOW_AWT_FLAG zx_party_tax_profile.ALLOW_AWT_FLAG%TYPE,
1047: USE_LE_AS_SUBSCRIBER_FLAG zx_party_tax_profile.USE_LE_AS_SUBSCRIBER_FLAG%TYPE,
1040: SUPPLIER_FLAG zx_party_tax_profile.SUPPLIER_FLAG%TYPE,
1041: CUSTOMER_FLAG zx_party_tax_profile.CUSTOMER_FLAG%TYPE,
1042: SITE_FLAG zx_party_tax_profile.SITE_FLAG%TYPE,
1043: PROCESS_FOR_APPLICABILITY_FLAG zx_party_tax_profile.PROCESS_FOR_APPLICABILITY_FLAG%TYPE,
1044: ROUNDING_LEVEL_CODE zx_party_tax_profile.ROUNDING_LEVEL_CODE%TYPE,
1045: WITHHOLDING_START_DATE zx_party_tax_profile.WITHHOLDING_START_DATE%TYPE,
1046: ALLOW_AWT_FLAG zx_party_tax_profile.ALLOW_AWT_FLAG%TYPE,
1047: USE_LE_AS_SUBSCRIBER_FLAG zx_party_tax_profile.USE_LE_AS_SUBSCRIBER_FLAG%TYPE,
1048: LEGAL_ESTABLISHMENT_FLAG zx_party_tax_profile.LEGAL_ESTABLISHMENT_FLAG%TYPE,
1041: CUSTOMER_FLAG zx_party_tax_profile.CUSTOMER_FLAG%TYPE,
1042: SITE_FLAG zx_party_tax_profile.SITE_FLAG%TYPE,
1043: PROCESS_FOR_APPLICABILITY_FLAG zx_party_tax_profile.PROCESS_FOR_APPLICABILITY_FLAG%TYPE,
1044: ROUNDING_LEVEL_CODE zx_party_tax_profile.ROUNDING_LEVEL_CODE%TYPE,
1045: WITHHOLDING_START_DATE zx_party_tax_profile.WITHHOLDING_START_DATE%TYPE,
1046: ALLOW_AWT_FLAG zx_party_tax_profile.ALLOW_AWT_FLAG%TYPE,
1047: USE_LE_AS_SUBSCRIBER_FLAG zx_party_tax_profile.USE_LE_AS_SUBSCRIBER_FLAG%TYPE,
1048: LEGAL_ESTABLISHMENT_FLAG zx_party_tax_profile.LEGAL_ESTABLISHMENT_FLAG%TYPE,
1049: FIRST_PARTY_LE_FLAG zx_party_tax_profile.FIRST_PARTY_LE_FLAG%TYPE,
1042: SITE_FLAG zx_party_tax_profile.SITE_FLAG%TYPE,
1043: PROCESS_FOR_APPLICABILITY_FLAG zx_party_tax_profile.PROCESS_FOR_APPLICABILITY_FLAG%TYPE,
1044: ROUNDING_LEVEL_CODE zx_party_tax_profile.ROUNDING_LEVEL_CODE%TYPE,
1045: WITHHOLDING_START_DATE zx_party_tax_profile.WITHHOLDING_START_DATE%TYPE,
1046: ALLOW_AWT_FLAG zx_party_tax_profile.ALLOW_AWT_FLAG%TYPE,
1047: USE_LE_AS_SUBSCRIBER_FLAG zx_party_tax_profile.USE_LE_AS_SUBSCRIBER_FLAG%TYPE,
1048: LEGAL_ESTABLISHMENT_FLAG zx_party_tax_profile.LEGAL_ESTABLISHMENT_FLAG%TYPE,
1049: FIRST_PARTY_LE_FLAG zx_party_tax_profile.FIRST_PARTY_LE_FLAG%TYPE,
1050: REPORTING_AUTHORITY_FLAG zx_party_tax_profile.REPORTING_AUTHORITY_FLAG%TYPE,
1043: PROCESS_FOR_APPLICABILITY_FLAG zx_party_tax_profile.PROCESS_FOR_APPLICABILITY_FLAG%TYPE,
1044: ROUNDING_LEVEL_CODE zx_party_tax_profile.ROUNDING_LEVEL_CODE%TYPE,
1045: WITHHOLDING_START_DATE zx_party_tax_profile.WITHHOLDING_START_DATE%TYPE,
1046: ALLOW_AWT_FLAG zx_party_tax_profile.ALLOW_AWT_FLAG%TYPE,
1047: USE_LE_AS_SUBSCRIBER_FLAG zx_party_tax_profile.USE_LE_AS_SUBSCRIBER_FLAG%TYPE,
1048: LEGAL_ESTABLISHMENT_FLAG zx_party_tax_profile.LEGAL_ESTABLISHMENT_FLAG%TYPE,
1049: FIRST_PARTY_LE_FLAG zx_party_tax_profile.FIRST_PARTY_LE_FLAG%TYPE,
1050: REPORTING_AUTHORITY_FLAG zx_party_tax_profile.REPORTING_AUTHORITY_FLAG%TYPE,
1051: COLLECTING_AUTHORITY_FLAG zx_party_tax_profile.COLLECTING_AUTHORITY_FLAG%TYPE,
1044: ROUNDING_LEVEL_CODE zx_party_tax_profile.ROUNDING_LEVEL_CODE%TYPE,
1045: WITHHOLDING_START_DATE zx_party_tax_profile.WITHHOLDING_START_DATE%TYPE,
1046: ALLOW_AWT_FLAG zx_party_tax_profile.ALLOW_AWT_FLAG%TYPE,
1047: USE_LE_AS_SUBSCRIBER_FLAG zx_party_tax_profile.USE_LE_AS_SUBSCRIBER_FLAG%TYPE,
1048: LEGAL_ESTABLISHMENT_FLAG zx_party_tax_profile.LEGAL_ESTABLISHMENT_FLAG%TYPE,
1049: FIRST_PARTY_LE_FLAG zx_party_tax_profile.FIRST_PARTY_LE_FLAG%TYPE,
1050: REPORTING_AUTHORITY_FLAG zx_party_tax_profile.REPORTING_AUTHORITY_FLAG%TYPE,
1051: COLLECTING_AUTHORITY_FLAG zx_party_tax_profile.COLLECTING_AUTHORITY_FLAG%TYPE,
1052: PROVIDER_TYPE_CODE zx_party_tax_profile.PROVIDER_TYPE_CODE%TYPE,
1045: WITHHOLDING_START_DATE zx_party_tax_profile.WITHHOLDING_START_DATE%TYPE,
1046: ALLOW_AWT_FLAG zx_party_tax_profile.ALLOW_AWT_FLAG%TYPE,
1047: USE_LE_AS_SUBSCRIBER_FLAG zx_party_tax_profile.USE_LE_AS_SUBSCRIBER_FLAG%TYPE,
1048: LEGAL_ESTABLISHMENT_FLAG zx_party_tax_profile.LEGAL_ESTABLISHMENT_FLAG%TYPE,
1049: FIRST_PARTY_LE_FLAG zx_party_tax_profile.FIRST_PARTY_LE_FLAG%TYPE,
1050: REPORTING_AUTHORITY_FLAG zx_party_tax_profile.REPORTING_AUTHORITY_FLAG%TYPE,
1051: COLLECTING_AUTHORITY_FLAG zx_party_tax_profile.COLLECTING_AUTHORITY_FLAG%TYPE,
1052: PROVIDER_TYPE_CODE zx_party_tax_profile.PROVIDER_TYPE_CODE%TYPE,
1053: CREATE_AWT_DISTS_TYPE_CODE zx_party_tax_profile.CREATE_AWT_DISTS_TYPE_CODE%TYPE,
1046: ALLOW_AWT_FLAG zx_party_tax_profile.ALLOW_AWT_FLAG%TYPE,
1047: USE_LE_AS_SUBSCRIBER_FLAG zx_party_tax_profile.USE_LE_AS_SUBSCRIBER_FLAG%TYPE,
1048: LEGAL_ESTABLISHMENT_FLAG zx_party_tax_profile.LEGAL_ESTABLISHMENT_FLAG%TYPE,
1049: FIRST_PARTY_LE_FLAG zx_party_tax_profile.FIRST_PARTY_LE_FLAG%TYPE,
1050: REPORTING_AUTHORITY_FLAG zx_party_tax_profile.REPORTING_AUTHORITY_FLAG%TYPE,
1051: COLLECTING_AUTHORITY_FLAG zx_party_tax_profile.COLLECTING_AUTHORITY_FLAG%TYPE,
1052: PROVIDER_TYPE_CODE zx_party_tax_profile.PROVIDER_TYPE_CODE%TYPE,
1053: CREATE_AWT_DISTS_TYPE_CODE zx_party_tax_profile.CREATE_AWT_DISTS_TYPE_CODE%TYPE,
1054: CREATE_AWT_INVOICES_TYPE_CODE zx_party_tax_profile.CREATE_AWT_INVOICES_TYPE_CODE%TYPE,
1047: USE_LE_AS_SUBSCRIBER_FLAG zx_party_tax_profile.USE_LE_AS_SUBSCRIBER_FLAG%TYPE,
1048: LEGAL_ESTABLISHMENT_FLAG zx_party_tax_profile.LEGAL_ESTABLISHMENT_FLAG%TYPE,
1049: FIRST_PARTY_LE_FLAG zx_party_tax_profile.FIRST_PARTY_LE_FLAG%TYPE,
1050: REPORTING_AUTHORITY_FLAG zx_party_tax_profile.REPORTING_AUTHORITY_FLAG%TYPE,
1051: COLLECTING_AUTHORITY_FLAG zx_party_tax_profile.COLLECTING_AUTHORITY_FLAG%TYPE,
1052: PROVIDER_TYPE_CODE zx_party_tax_profile.PROVIDER_TYPE_CODE%TYPE,
1053: CREATE_AWT_DISTS_TYPE_CODE zx_party_tax_profile.CREATE_AWT_DISTS_TYPE_CODE%TYPE,
1054: CREATE_AWT_INVOICES_TYPE_CODE zx_party_tax_profile.CREATE_AWT_INVOICES_TYPE_CODE%TYPE,
1055: ALLOW_OFFSET_TAX_FLAG zx_party_tax_profile.ALLOW_OFFSET_TAX_FLAG%TYPE,
1048: LEGAL_ESTABLISHMENT_FLAG zx_party_tax_profile.LEGAL_ESTABLISHMENT_FLAG%TYPE,
1049: FIRST_PARTY_LE_FLAG zx_party_tax_profile.FIRST_PARTY_LE_FLAG%TYPE,
1050: REPORTING_AUTHORITY_FLAG zx_party_tax_profile.REPORTING_AUTHORITY_FLAG%TYPE,
1051: COLLECTING_AUTHORITY_FLAG zx_party_tax_profile.COLLECTING_AUTHORITY_FLAG%TYPE,
1052: PROVIDER_TYPE_CODE zx_party_tax_profile.PROVIDER_TYPE_CODE%TYPE,
1053: CREATE_AWT_DISTS_TYPE_CODE zx_party_tax_profile.CREATE_AWT_DISTS_TYPE_CODE%TYPE,
1054: CREATE_AWT_INVOICES_TYPE_CODE zx_party_tax_profile.CREATE_AWT_INVOICES_TYPE_CODE%TYPE,
1055: ALLOW_OFFSET_TAX_FLAG zx_party_tax_profile.ALLOW_OFFSET_TAX_FLAG%TYPE,
1056: EFFECTIVE_FROM_USE_LE zx_party_tax_profile.EFFECTIVE_FROM_USE_LE%TYPE,
1049: FIRST_PARTY_LE_FLAG zx_party_tax_profile.FIRST_PARTY_LE_FLAG%TYPE,
1050: REPORTING_AUTHORITY_FLAG zx_party_tax_profile.REPORTING_AUTHORITY_FLAG%TYPE,
1051: COLLECTING_AUTHORITY_FLAG zx_party_tax_profile.COLLECTING_AUTHORITY_FLAG%TYPE,
1052: PROVIDER_TYPE_CODE zx_party_tax_profile.PROVIDER_TYPE_CODE%TYPE,
1053: CREATE_AWT_DISTS_TYPE_CODE zx_party_tax_profile.CREATE_AWT_DISTS_TYPE_CODE%TYPE,
1054: CREATE_AWT_INVOICES_TYPE_CODE zx_party_tax_profile.CREATE_AWT_INVOICES_TYPE_CODE%TYPE,
1055: ALLOW_OFFSET_TAX_FLAG zx_party_tax_profile.ALLOW_OFFSET_TAX_FLAG%TYPE,
1056: EFFECTIVE_FROM_USE_LE zx_party_tax_profile.EFFECTIVE_FROM_USE_LE%TYPE,
1057: REP_REGISTRATION_NUMBER zx_party_tax_profile.REP_REGISTRATION_NUMBER%TYPE,
1050: REPORTING_AUTHORITY_FLAG zx_party_tax_profile.REPORTING_AUTHORITY_FLAG%TYPE,
1051: COLLECTING_AUTHORITY_FLAG zx_party_tax_profile.COLLECTING_AUTHORITY_FLAG%TYPE,
1052: PROVIDER_TYPE_CODE zx_party_tax_profile.PROVIDER_TYPE_CODE%TYPE,
1053: CREATE_AWT_DISTS_TYPE_CODE zx_party_tax_profile.CREATE_AWT_DISTS_TYPE_CODE%TYPE,
1054: CREATE_AWT_INVOICES_TYPE_CODE zx_party_tax_profile.CREATE_AWT_INVOICES_TYPE_CODE%TYPE,
1055: ALLOW_OFFSET_TAX_FLAG zx_party_tax_profile.ALLOW_OFFSET_TAX_FLAG%TYPE,
1056: EFFECTIVE_FROM_USE_LE zx_party_tax_profile.EFFECTIVE_FROM_USE_LE%TYPE,
1057: REP_REGISTRATION_NUMBER zx_party_tax_profile.REP_REGISTRATION_NUMBER%TYPE,
1058: ROUNDING_RULE_CODE zx_party_tax_profile.ROUNDING_RULE_CODE%TYPE);
1051: COLLECTING_AUTHORITY_FLAG zx_party_tax_profile.COLLECTING_AUTHORITY_FLAG%TYPE,
1052: PROVIDER_TYPE_CODE zx_party_tax_profile.PROVIDER_TYPE_CODE%TYPE,
1053: CREATE_AWT_DISTS_TYPE_CODE zx_party_tax_profile.CREATE_AWT_DISTS_TYPE_CODE%TYPE,
1054: CREATE_AWT_INVOICES_TYPE_CODE zx_party_tax_profile.CREATE_AWT_INVOICES_TYPE_CODE%TYPE,
1055: ALLOW_OFFSET_TAX_FLAG zx_party_tax_profile.ALLOW_OFFSET_TAX_FLAG%TYPE,
1056: EFFECTIVE_FROM_USE_LE zx_party_tax_profile.EFFECTIVE_FROM_USE_LE%TYPE,
1057: REP_REGISTRATION_NUMBER zx_party_tax_profile.REP_REGISTRATION_NUMBER%TYPE,
1058: ROUNDING_RULE_CODE zx_party_tax_profile.ROUNDING_RULE_CODE%TYPE);
1059:
1052: PROVIDER_TYPE_CODE zx_party_tax_profile.PROVIDER_TYPE_CODE%TYPE,
1053: CREATE_AWT_DISTS_TYPE_CODE zx_party_tax_profile.CREATE_AWT_DISTS_TYPE_CODE%TYPE,
1054: CREATE_AWT_INVOICES_TYPE_CODE zx_party_tax_profile.CREATE_AWT_INVOICES_TYPE_CODE%TYPE,
1055: ALLOW_OFFSET_TAX_FLAG zx_party_tax_profile.ALLOW_OFFSET_TAX_FLAG%TYPE,
1056: EFFECTIVE_FROM_USE_LE zx_party_tax_profile.EFFECTIVE_FROM_USE_LE%TYPE,
1057: REP_REGISTRATION_NUMBER zx_party_tax_profile.REP_REGISTRATION_NUMBER%TYPE,
1058: ROUNDING_RULE_CODE zx_party_tax_profile.ROUNDING_RULE_CODE%TYPE);
1059:
1060:
1053: CREATE_AWT_DISTS_TYPE_CODE zx_party_tax_profile.CREATE_AWT_DISTS_TYPE_CODE%TYPE,
1054: CREATE_AWT_INVOICES_TYPE_CODE zx_party_tax_profile.CREATE_AWT_INVOICES_TYPE_CODE%TYPE,
1055: ALLOW_OFFSET_TAX_FLAG zx_party_tax_profile.ALLOW_OFFSET_TAX_FLAG%TYPE,
1056: EFFECTIVE_FROM_USE_LE zx_party_tax_profile.EFFECTIVE_FROM_USE_LE%TYPE,
1057: REP_REGISTRATION_NUMBER zx_party_tax_profile.REP_REGISTRATION_NUMBER%TYPE,
1058: ROUNDING_RULE_CODE zx_party_tax_profile.ROUNDING_RULE_CODE%TYPE);
1059:
1060:
1061: TYPE PARTY_TAX_PROF_INFO_TBL_TYPE is table of PARTY_TAX_PROF_INFO_REC_TYPE
1054: CREATE_AWT_INVOICES_TYPE_CODE zx_party_tax_profile.CREATE_AWT_INVOICES_TYPE_CODE%TYPE,
1055: ALLOW_OFFSET_TAX_FLAG zx_party_tax_profile.ALLOW_OFFSET_TAX_FLAG%TYPE,
1056: EFFECTIVE_FROM_USE_LE zx_party_tax_profile.EFFECTIVE_FROM_USE_LE%TYPE,
1057: REP_REGISTRATION_NUMBER zx_party_tax_profile.REP_REGISTRATION_NUMBER%TYPE,
1058: ROUNDING_RULE_CODE zx_party_tax_profile.ROUNDING_RULE_CODE%TYPE);
1059:
1060:
1061: TYPE PARTY_TAX_PROF_INFO_TBL_TYPE is table of PARTY_TAX_PROF_INFO_REC_TYPE
1062: index by BINARY_INTEGER;
1065: -- given the party_id and party_type_code. This structure is indexed by a hash
1066: -- value of party_type_code||party_id
1067:
1068: TYPE PARTY_TAX_PROF_ID_INFO_REC is record
1069: (pARTY_ID zx_party_tax_profile.PARTY_ID%TYPE,
1070: pARTY_TYPE_CODE zx_party_tax_profile.PARTY_TYPE_CODE%TYPE,
1071: pARTY_TAX_PROFILE_ID zx_party_tax_profile.PARTY_TAX_PROFILE_ID%TYPE);
1072:
1073: TYPE PARTY_TAX_PROF_ID_INFO_TBLTYPE is table of PARTY_TAX_PROF_ID_INFO_REC
1066: -- value of party_type_code||party_id
1067:
1068: TYPE PARTY_TAX_PROF_ID_INFO_REC is record
1069: (pARTY_ID zx_party_tax_profile.PARTY_ID%TYPE,
1070: pARTY_TYPE_CODE zx_party_tax_profile.PARTY_TYPE_CODE%TYPE,
1071: pARTY_TAX_PROFILE_ID zx_party_tax_profile.PARTY_TAX_PROFILE_ID%TYPE);
1072:
1073: TYPE PARTY_TAX_PROF_ID_INFO_TBLTYPE is table of PARTY_TAX_PROF_ID_INFO_REC
1074: index by BINARY_INTEGER;
1067:
1068: TYPE PARTY_TAX_PROF_ID_INFO_REC is record
1069: (pARTY_ID zx_party_tax_profile.PARTY_ID%TYPE,
1070: pARTY_TYPE_CODE zx_party_tax_profile.PARTY_TYPE_CODE%TYPE,
1071: pARTY_TAX_PROFILE_ID zx_party_tax_profile.PARTY_TAX_PROFILE_ID%TYPE);
1072:
1073: TYPE PARTY_TAX_PROF_ID_INFO_TBLTYPE is table of PARTY_TAX_PROF_ID_INFO_REC
1074: index by BINARY_INTEGER;
1075: