918:
919: -- The structure below is used to cache party type info. This structure is indexed by hash value of
920: -- party_type_code and is being referenced by jurisdictions API.
921:
922: TYPE ZX_PARTY_TYPES_INFO_REC is record(
923: PARTY_TYPE_CODE zx_party_types.PARTY_TYPE_CODE%type,
924: PARTY_SOURCE_TABLE zx_party_types.PARTY_SOURCE_TABLE%type,
925: PARTY_SOURCE_COLUMN zx_party_types.PARTY_SOURCE_COLUMN%type,
926: APPLICABLE_TO_EVNT_CLS_FLAG zx_party_types.APPLICABLE_TO_EVNT_CLS_FLAG%type,
919: -- The structure below is used to cache party type info. This structure is indexed by hash value of
920: -- party_type_code and is being referenced by jurisdictions API.
921:
922: TYPE ZX_PARTY_TYPES_INFO_REC is record(
923: PARTY_TYPE_CODE zx_party_types.PARTY_TYPE_CODE%type,
924: PARTY_SOURCE_TABLE zx_party_types.PARTY_SOURCE_TABLE%type,
925: PARTY_SOURCE_COLUMN zx_party_types.PARTY_SOURCE_COLUMN%type,
926: APPLICABLE_TO_EVNT_CLS_FLAG zx_party_types.APPLICABLE_TO_EVNT_CLS_FLAG%type,
927: PARTY_SITE_TYPE zx_party_types.PARTY_SITE_TYPE%type,
920: -- party_type_code and is being referenced by jurisdictions API.
921:
922: TYPE ZX_PARTY_TYPES_INFO_REC is record(
923: PARTY_TYPE_CODE zx_party_types.PARTY_TYPE_CODE%type,
924: PARTY_SOURCE_TABLE zx_party_types.PARTY_SOURCE_TABLE%type,
925: PARTY_SOURCE_COLUMN zx_party_types.PARTY_SOURCE_COLUMN%type,
926: APPLICABLE_TO_EVNT_CLS_FLAG zx_party_types.APPLICABLE_TO_EVNT_CLS_FLAG%type,
927: PARTY_SITE_TYPE zx_party_types.PARTY_SITE_TYPE%type,
928: LOCATION_SOURCE_TABLE zx_party_types.LOCATION_SOURCE_TABLE%type,
921:
922: TYPE ZX_PARTY_TYPES_INFO_REC is record(
923: PARTY_TYPE_CODE zx_party_types.PARTY_TYPE_CODE%type,
924: PARTY_SOURCE_TABLE zx_party_types.PARTY_SOURCE_TABLE%type,
925: PARTY_SOURCE_COLUMN zx_party_types.PARTY_SOURCE_COLUMN%type,
926: APPLICABLE_TO_EVNT_CLS_FLAG zx_party_types.APPLICABLE_TO_EVNT_CLS_FLAG%type,
927: PARTY_SITE_TYPE zx_party_types.PARTY_SITE_TYPE%type,
928: LOCATION_SOURCE_TABLE zx_party_types.LOCATION_SOURCE_TABLE%type,
929: LOCATION_SOURCE_COLUMN zx_party_types.LOCATION_SOURCE_COLUMN%type);
922: TYPE ZX_PARTY_TYPES_INFO_REC is record(
923: PARTY_TYPE_CODE zx_party_types.PARTY_TYPE_CODE%type,
924: PARTY_SOURCE_TABLE zx_party_types.PARTY_SOURCE_TABLE%type,
925: PARTY_SOURCE_COLUMN zx_party_types.PARTY_SOURCE_COLUMN%type,
926: APPLICABLE_TO_EVNT_CLS_FLAG zx_party_types.APPLICABLE_TO_EVNT_CLS_FLAG%type,
927: PARTY_SITE_TYPE zx_party_types.PARTY_SITE_TYPE%type,
928: LOCATION_SOURCE_TABLE zx_party_types.LOCATION_SOURCE_TABLE%type,
929: LOCATION_SOURCE_COLUMN zx_party_types.LOCATION_SOURCE_COLUMN%type);
930:
923: PARTY_TYPE_CODE zx_party_types.PARTY_TYPE_CODE%type,
924: PARTY_SOURCE_TABLE zx_party_types.PARTY_SOURCE_TABLE%type,
925: PARTY_SOURCE_COLUMN zx_party_types.PARTY_SOURCE_COLUMN%type,
926: APPLICABLE_TO_EVNT_CLS_FLAG zx_party_types.APPLICABLE_TO_EVNT_CLS_FLAG%type,
927: PARTY_SITE_TYPE zx_party_types.PARTY_SITE_TYPE%type,
928: LOCATION_SOURCE_TABLE zx_party_types.LOCATION_SOURCE_TABLE%type,
929: LOCATION_SOURCE_COLUMN zx_party_types.LOCATION_SOURCE_COLUMN%type);
930:
931:
924: PARTY_SOURCE_TABLE zx_party_types.PARTY_SOURCE_TABLE%type,
925: PARTY_SOURCE_COLUMN zx_party_types.PARTY_SOURCE_COLUMN%type,
926: APPLICABLE_TO_EVNT_CLS_FLAG zx_party_types.APPLICABLE_TO_EVNT_CLS_FLAG%type,
927: PARTY_SITE_TYPE zx_party_types.PARTY_SITE_TYPE%type,
928: LOCATION_SOURCE_TABLE zx_party_types.LOCATION_SOURCE_TABLE%type,
929: LOCATION_SOURCE_COLUMN zx_party_types.LOCATION_SOURCE_COLUMN%type);
930:
931:
932: TYPE ZX_PARTY_TYPES_CACHE_TBLTYPE is table of ZX_PARTY_TYPES_INFO_REC index by binary_integer;
925: PARTY_SOURCE_COLUMN zx_party_types.PARTY_SOURCE_COLUMN%type,
926: APPLICABLE_TO_EVNT_CLS_FLAG zx_party_types.APPLICABLE_TO_EVNT_CLS_FLAG%type,
927: PARTY_SITE_TYPE zx_party_types.PARTY_SITE_TYPE%type,
928: LOCATION_SOURCE_TABLE zx_party_types.LOCATION_SOURCE_TABLE%type,
929: LOCATION_SOURCE_COLUMN zx_party_types.LOCATION_SOURCE_COLUMN%type);
930:
931:
932: TYPE ZX_PARTY_TYPES_CACHE_TBLTYPE is table of ZX_PARTY_TYPES_INFO_REC index by binary_integer;
933:
928: LOCATION_SOURCE_TABLE zx_party_types.LOCATION_SOURCE_TABLE%type,
929: LOCATION_SOURCE_COLUMN zx_party_types.LOCATION_SOURCE_COLUMN%type);
930:
931:
932: TYPE ZX_PARTY_TYPES_CACHE_TBLTYPE is table of ZX_PARTY_TYPES_INFO_REC index by binary_integer;
933:
934: ZX_PARTY_TYPES_CACHE ZX_PARTY_TYPES_CACHE_TBLTYPE;
935:
936:
930:
931:
932: TYPE ZX_PARTY_TYPES_CACHE_TBLTYPE is table of ZX_PARTY_TYPES_INFO_REC index by binary_integer;
933:
934: ZX_PARTY_TYPES_CACHE ZX_PARTY_TYPES_CACHE_TBLTYPE;
935:
936:
937: Type intended_use_tbl_info_rectype is RECORD
938: (owner_table_code zx_fc_types_b.owner_table_code%type,