783: owner_id_num zx_fc_types_b.owner_id_num%type);
784:
785:
786: Type zx_product_options_rec_type is record(
787: APPLICATION_ID zx_product_options_all.APPLICATION_ID%type,
788: ORG_ID zx_product_options_all.ORG_ID%type,
789: TAX_METHOD_CODE zx_product_options_all.TAX_METHOD_CODE%type,
790: DEF_OPTION_HIER_1_CODE zx_product_options_all.DEF_OPTION_HIER_1_CODE%type,
791: DEF_OPTION_HIER_2_CODE zx_product_options_all.DEF_OPTION_HIER_2_CODE%type,
784:
785:
786: Type zx_product_options_rec_type is record(
787: APPLICATION_ID zx_product_options_all.APPLICATION_ID%type,
788: ORG_ID zx_product_options_all.ORG_ID%type,
789: TAX_METHOD_CODE zx_product_options_all.TAX_METHOD_CODE%type,
790: DEF_OPTION_HIER_1_CODE zx_product_options_all.DEF_OPTION_HIER_1_CODE%type,
791: DEF_OPTION_HIER_2_CODE zx_product_options_all.DEF_OPTION_HIER_2_CODE%type,
792: DEF_OPTION_HIER_3_CODE zx_product_options_all.DEF_OPTION_HIER_3_CODE%type,
785:
786: Type zx_product_options_rec_type is record(
787: APPLICATION_ID zx_product_options_all.APPLICATION_ID%type,
788: ORG_ID zx_product_options_all.ORG_ID%type,
789: TAX_METHOD_CODE zx_product_options_all.TAX_METHOD_CODE%type,
790: DEF_OPTION_HIER_1_CODE zx_product_options_all.DEF_OPTION_HIER_1_CODE%type,
791: DEF_OPTION_HIER_2_CODE zx_product_options_all.DEF_OPTION_HIER_2_CODE%type,
792: DEF_OPTION_HIER_3_CODE zx_product_options_all.DEF_OPTION_HIER_3_CODE%type,
793: DEF_OPTION_HIER_4_CODE zx_product_options_all.DEF_OPTION_HIER_4_CODE%type,
786: Type zx_product_options_rec_type is record(
787: APPLICATION_ID zx_product_options_all.APPLICATION_ID%type,
788: ORG_ID zx_product_options_all.ORG_ID%type,
789: TAX_METHOD_CODE zx_product_options_all.TAX_METHOD_CODE%type,
790: DEF_OPTION_HIER_1_CODE zx_product_options_all.DEF_OPTION_HIER_1_CODE%type,
791: DEF_OPTION_HIER_2_CODE zx_product_options_all.DEF_OPTION_HIER_2_CODE%type,
792: DEF_OPTION_HIER_3_CODE zx_product_options_all.DEF_OPTION_HIER_3_CODE%type,
793: DEF_OPTION_HIER_4_CODE zx_product_options_all.DEF_OPTION_HIER_4_CODE%type,
794: DEF_OPTION_HIER_5_CODE zx_product_options_all.DEF_OPTION_HIER_5_CODE%type,
787: APPLICATION_ID zx_product_options_all.APPLICATION_ID%type,
788: ORG_ID zx_product_options_all.ORG_ID%type,
789: TAX_METHOD_CODE zx_product_options_all.TAX_METHOD_CODE%type,
790: DEF_OPTION_HIER_1_CODE zx_product_options_all.DEF_OPTION_HIER_1_CODE%type,
791: DEF_OPTION_HIER_2_CODE zx_product_options_all.DEF_OPTION_HIER_2_CODE%type,
792: DEF_OPTION_HIER_3_CODE zx_product_options_all.DEF_OPTION_HIER_3_CODE%type,
793: DEF_OPTION_HIER_4_CODE zx_product_options_all.DEF_OPTION_HIER_4_CODE%type,
794: DEF_OPTION_HIER_5_CODE zx_product_options_all.DEF_OPTION_HIER_5_CODE%type,
795: DEF_OPTION_HIER_6_CODE zx_product_options_all.DEF_OPTION_HIER_6_CODE%type,
788: ORG_ID zx_product_options_all.ORG_ID%type,
789: TAX_METHOD_CODE zx_product_options_all.TAX_METHOD_CODE%type,
790: DEF_OPTION_HIER_1_CODE zx_product_options_all.DEF_OPTION_HIER_1_CODE%type,
791: DEF_OPTION_HIER_2_CODE zx_product_options_all.DEF_OPTION_HIER_2_CODE%type,
792: DEF_OPTION_HIER_3_CODE zx_product_options_all.DEF_OPTION_HIER_3_CODE%type,
793: DEF_OPTION_HIER_4_CODE zx_product_options_all.DEF_OPTION_HIER_4_CODE%type,
794: DEF_OPTION_HIER_5_CODE zx_product_options_all.DEF_OPTION_HIER_5_CODE%type,
795: DEF_OPTION_HIER_6_CODE zx_product_options_all.DEF_OPTION_HIER_6_CODE%type,
796: DEF_OPTION_HIER_7_CODE zx_product_options_all.DEF_OPTION_HIER_7_CODE%type,
789: TAX_METHOD_CODE zx_product_options_all.TAX_METHOD_CODE%type,
790: DEF_OPTION_HIER_1_CODE zx_product_options_all.DEF_OPTION_HIER_1_CODE%type,
791: DEF_OPTION_HIER_2_CODE zx_product_options_all.DEF_OPTION_HIER_2_CODE%type,
792: DEF_OPTION_HIER_3_CODE zx_product_options_all.DEF_OPTION_HIER_3_CODE%type,
793: DEF_OPTION_HIER_4_CODE zx_product_options_all.DEF_OPTION_HIER_4_CODE%type,
794: DEF_OPTION_HIER_5_CODE zx_product_options_all.DEF_OPTION_HIER_5_CODE%type,
795: DEF_OPTION_HIER_6_CODE zx_product_options_all.DEF_OPTION_HIER_6_CODE%type,
796: DEF_OPTION_HIER_7_CODE zx_product_options_all.DEF_OPTION_HIER_7_CODE%type,
797: TAX_CLASSIFICATION_CODE zx_product_options_all.TAX_CLASSIFICATION_CODE%type,
790: DEF_OPTION_HIER_1_CODE zx_product_options_all.DEF_OPTION_HIER_1_CODE%type,
791: DEF_OPTION_HIER_2_CODE zx_product_options_all.DEF_OPTION_HIER_2_CODE%type,
792: DEF_OPTION_HIER_3_CODE zx_product_options_all.DEF_OPTION_HIER_3_CODE%type,
793: DEF_OPTION_HIER_4_CODE zx_product_options_all.DEF_OPTION_HIER_4_CODE%type,
794: DEF_OPTION_HIER_5_CODE zx_product_options_all.DEF_OPTION_HIER_5_CODE%type,
795: DEF_OPTION_HIER_6_CODE zx_product_options_all.DEF_OPTION_HIER_6_CODE%type,
796: DEF_OPTION_HIER_7_CODE zx_product_options_all.DEF_OPTION_HIER_7_CODE%type,
797: TAX_CLASSIFICATION_CODE zx_product_options_all.TAX_CLASSIFICATION_CODE%type,
798: INCLUSIVE_TAX_USED_FLAG zx_product_options_all.INCLUSIVE_TAX_USED_FLAG%type,
791: DEF_OPTION_HIER_2_CODE zx_product_options_all.DEF_OPTION_HIER_2_CODE%type,
792: DEF_OPTION_HIER_3_CODE zx_product_options_all.DEF_OPTION_HIER_3_CODE%type,
793: DEF_OPTION_HIER_4_CODE zx_product_options_all.DEF_OPTION_HIER_4_CODE%type,
794: DEF_OPTION_HIER_5_CODE zx_product_options_all.DEF_OPTION_HIER_5_CODE%type,
795: DEF_OPTION_HIER_6_CODE zx_product_options_all.DEF_OPTION_HIER_6_CODE%type,
796: DEF_OPTION_HIER_7_CODE zx_product_options_all.DEF_OPTION_HIER_7_CODE%type,
797: TAX_CLASSIFICATION_CODE zx_product_options_all.TAX_CLASSIFICATION_CODE%type,
798: INCLUSIVE_TAX_USED_FLAG zx_product_options_all.INCLUSIVE_TAX_USED_FLAG%type,
799: TAX_USE_CUSTOMER_EXEMPT_FLAG zx_product_options_all.TAX_USE_CUSTOMER_EXEMPT_FLAG%type,
792: DEF_OPTION_HIER_3_CODE zx_product_options_all.DEF_OPTION_HIER_3_CODE%type,
793: DEF_OPTION_HIER_4_CODE zx_product_options_all.DEF_OPTION_HIER_4_CODE%type,
794: DEF_OPTION_HIER_5_CODE zx_product_options_all.DEF_OPTION_HIER_5_CODE%type,
795: DEF_OPTION_HIER_6_CODE zx_product_options_all.DEF_OPTION_HIER_6_CODE%type,
796: DEF_OPTION_HIER_7_CODE zx_product_options_all.DEF_OPTION_HIER_7_CODE%type,
797: TAX_CLASSIFICATION_CODE zx_product_options_all.TAX_CLASSIFICATION_CODE%type,
798: INCLUSIVE_TAX_USED_FLAG zx_product_options_all.INCLUSIVE_TAX_USED_FLAG%type,
799: TAX_USE_CUSTOMER_EXEMPT_FLAG zx_product_options_all.TAX_USE_CUSTOMER_EXEMPT_FLAG%type,
800: TAX_USE_PRODUCT_EXEMPT_FLAG zx_product_options_all.TAX_USE_PRODUCT_EXEMPT_FLAG%type,
793: DEF_OPTION_HIER_4_CODE zx_product_options_all.DEF_OPTION_HIER_4_CODE%type,
794: DEF_OPTION_HIER_5_CODE zx_product_options_all.DEF_OPTION_HIER_5_CODE%type,
795: DEF_OPTION_HIER_6_CODE zx_product_options_all.DEF_OPTION_HIER_6_CODE%type,
796: DEF_OPTION_HIER_7_CODE zx_product_options_all.DEF_OPTION_HIER_7_CODE%type,
797: TAX_CLASSIFICATION_CODE zx_product_options_all.TAX_CLASSIFICATION_CODE%type,
798: INCLUSIVE_TAX_USED_FLAG zx_product_options_all.INCLUSIVE_TAX_USED_FLAG%type,
799: TAX_USE_CUSTOMER_EXEMPT_FLAG zx_product_options_all.TAX_USE_CUSTOMER_EXEMPT_FLAG%type,
800: TAX_USE_PRODUCT_EXEMPT_FLAG zx_product_options_all.TAX_USE_PRODUCT_EXEMPT_FLAG%type,
801: TAX_USE_LOC_EXC_RATE_FLAG zx_product_options_all.TAX_USE_LOC_EXC_RATE_FLAG%type,
794: DEF_OPTION_HIER_5_CODE zx_product_options_all.DEF_OPTION_HIER_5_CODE%type,
795: DEF_OPTION_HIER_6_CODE zx_product_options_all.DEF_OPTION_HIER_6_CODE%type,
796: DEF_OPTION_HIER_7_CODE zx_product_options_all.DEF_OPTION_HIER_7_CODE%type,
797: TAX_CLASSIFICATION_CODE zx_product_options_all.TAX_CLASSIFICATION_CODE%type,
798: INCLUSIVE_TAX_USED_FLAG zx_product_options_all.INCLUSIVE_TAX_USED_FLAG%type,
799: TAX_USE_CUSTOMER_EXEMPT_FLAG zx_product_options_all.TAX_USE_CUSTOMER_EXEMPT_FLAG%type,
800: TAX_USE_PRODUCT_EXEMPT_FLAG zx_product_options_all.TAX_USE_PRODUCT_EXEMPT_FLAG%type,
801: TAX_USE_LOC_EXC_RATE_FLAG zx_product_options_all.TAX_USE_LOC_EXC_RATE_FLAG%type,
802: TAX_ALLOW_COMPOUND_FLAG zx_product_options_all.TAX_ALLOW_COMPOUND_FLAG%type,
795: DEF_OPTION_HIER_6_CODE zx_product_options_all.DEF_OPTION_HIER_6_CODE%type,
796: DEF_OPTION_HIER_7_CODE zx_product_options_all.DEF_OPTION_HIER_7_CODE%type,
797: TAX_CLASSIFICATION_CODE zx_product_options_all.TAX_CLASSIFICATION_CODE%type,
798: INCLUSIVE_TAX_USED_FLAG zx_product_options_all.INCLUSIVE_TAX_USED_FLAG%type,
799: TAX_USE_CUSTOMER_EXEMPT_FLAG zx_product_options_all.TAX_USE_CUSTOMER_EXEMPT_FLAG%type,
800: TAX_USE_PRODUCT_EXEMPT_FLAG zx_product_options_all.TAX_USE_PRODUCT_EXEMPT_FLAG%type,
801: TAX_USE_LOC_EXC_RATE_FLAG zx_product_options_all.TAX_USE_LOC_EXC_RATE_FLAG%type,
802: TAX_ALLOW_COMPOUND_FLAG zx_product_options_all.TAX_ALLOW_COMPOUND_FLAG%type,
803: USE_TAX_CLASSIFICATION_FLAG zx_product_options_all.USE_TAX_CLASSIFICATION_FLAG%type,
796: DEF_OPTION_HIER_7_CODE zx_product_options_all.DEF_OPTION_HIER_7_CODE%type,
797: TAX_CLASSIFICATION_CODE zx_product_options_all.TAX_CLASSIFICATION_CODE%type,
798: INCLUSIVE_TAX_USED_FLAG zx_product_options_all.INCLUSIVE_TAX_USED_FLAG%type,
799: TAX_USE_CUSTOMER_EXEMPT_FLAG zx_product_options_all.TAX_USE_CUSTOMER_EXEMPT_FLAG%type,
800: TAX_USE_PRODUCT_EXEMPT_FLAG zx_product_options_all.TAX_USE_PRODUCT_EXEMPT_FLAG%type,
801: TAX_USE_LOC_EXC_RATE_FLAG zx_product_options_all.TAX_USE_LOC_EXC_RATE_FLAG%type,
802: TAX_ALLOW_COMPOUND_FLAG zx_product_options_all.TAX_ALLOW_COMPOUND_FLAG%type,
803: USE_TAX_CLASSIFICATION_FLAG zx_product_options_all.USE_TAX_CLASSIFICATION_FLAG%type,
804: ALLOW_TAX_ROUNDING_OVRD_FLAG zx_product_options_all.ALLOW_TAX_ROUNDING_OVRD_FLAG%type,
797: TAX_CLASSIFICATION_CODE zx_product_options_all.TAX_CLASSIFICATION_CODE%type,
798: INCLUSIVE_TAX_USED_FLAG zx_product_options_all.INCLUSIVE_TAX_USED_FLAG%type,
799: TAX_USE_CUSTOMER_EXEMPT_FLAG zx_product_options_all.TAX_USE_CUSTOMER_EXEMPT_FLAG%type,
800: TAX_USE_PRODUCT_EXEMPT_FLAG zx_product_options_all.TAX_USE_PRODUCT_EXEMPT_FLAG%type,
801: TAX_USE_LOC_EXC_RATE_FLAG zx_product_options_all.TAX_USE_LOC_EXC_RATE_FLAG%type,
802: TAX_ALLOW_COMPOUND_FLAG zx_product_options_all.TAX_ALLOW_COMPOUND_FLAG%type,
803: USE_TAX_CLASSIFICATION_FLAG zx_product_options_all.USE_TAX_CLASSIFICATION_FLAG%type,
804: ALLOW_TAX_ROUNDING_OVRD_FLAG zx_product_options_all.ALLOW_TAX_ROUNDING_OVRD_FLAG%type,
805: HOME_COUNTRY_DEFAULT_FLAG zx_product_options_all.HOME_COUNTRY_DEFAULT_FLAG%type,
798: INCLUSIVE_TAX_USED_FLAG zx_product_options_all.INCLUSIVE_TAX_USED_FLAG%type,
799: TAX_USE_CUSTOMER_EXEMPT_FLAG zx_product_options_all.TAX_USE_CUSTOMER_EXEMPT_FLAG%type,
800: TAX_USE_PRODUCT_EXEMPT_FLAG zx_product_options_all.TAX_USE_PRODUCT_EXEMPT_FLAG%type,
801: TAX_USE_LOC_EXC_RATE_FLAG zx_product_options_all.TAX_USE_LOC_EXC_RATE_FLAG%type,
802: TAX_ALLOW_COMPOUND_FLAG zx_product_options_all.TAX_ALLOW_COMPOUND_FLAG%type,
803: USE_TAX_CLASSIFICATION_FLAG zx_product_options_all.USE_TAX_CLASSIFICATION_FLAG%type,
804: ALLOW_TAX_ROUNDING_OVRD_FLAG zx_product_options_all.ALLOW_TAX_ROUNDING_OVRD_FLAG%type,
805: HOME_COUNTRY_DEFAULT_FLAG zx_product_options_all.HOME_COUNTRY_DEFAULT_FLAG%type,
806: TAX_ROUNDING_RULE zx_product_options_all.TAX_ROUNDING_RULE%type,
799: TAX_USE_CUSTOMER_EXEMPT_FLAG zx_product_options_all.TAX_USE_CUSTOMER_EXEMPT_FLAG%type,
800: TAX_USE_PRODUCT_EXEMPT_FLAG zx_product_options_all.TAX_USE_PRODUCT_EXEMPT_FLAG%type,
801: TAX_USE_LOC_EXC_RATE_FLAG zx_product_options_all.TAX_USE_LOC_EXC_RATE_FLAG%type,
802: TAX_ALLOW_COMPOUND_FLAG zx_product_options_all.TAX_ALLOW_COMPOUND_FLAG%type,
803: USE_TAX_CLASSIFICATION_FLAG zx_product_options_all.USE_TAX_CLASSIFICATION_FLAG%type,
804: ALLOW_TAX_ROUNDING_OVRD_FLAG zx_product_options_all.ALLOW_TAX_ROUNDING_OVRD_FLAG%type,
805: HOME_COUNTRY_DEFAULT_FLAG zx_product_options_all.HOME_COUNTRY_DEFAULT_FLAG%type,
806: TAX_ROUNDING_RULE zx_product_options_all.TAX_ROUNDING_RULE%type,
807: TAX_PRECISION zx_product_options_all.TAX_PRECISION%type,
800: TAX_USE_PRODUCT_EXEMPT_FLAG zx_product_options_all.TAX_USE_PRODUCT_EXEMPT_FLAG%type,
801: TAX_USE_LOC_EXC_RATE_FLAG zx_product_options_all.TAX_USE_LOC_EXC_RATE_FLAG%type,
802: TAX_ALLOW_COMPOUND_FLAG zx_product_options_all.TAX_ALLOW_COMPOUND_FLAG%type,
803: USE_TAX_CLASSIFICATION_FLAG zx_product_options_all.USE_TAX_CLASSIFICATION_FLAG%type,
804: ALLOW_TAX_ROUNDING_OVRD_FLAG zx_product_options_all.ALLOW_TAX_ROUNDING_OVRD_FLAG%type,
805: HOME_COUNTRY_DEFAULT_FLAG zx_product_options_all.HOME_COUNTRY_DEFAULT_FLAG%type,
806: TAX_ROUNDING_RULE zx_product_options_all.TAX_ROUNDING_RULE%type,
807: TAX_PRECISION zx_product_options_all.TAX_PRECISION%type,
808: TAX_MINIMUM_ACCOUNTABLE_UNIT zx_product_options_all.TAX_MINIMUM_ACCOUNTABLE_UNIT%type);
801: TAX_USE_LOC_EXC_RATE_FLAG zx_product_options_all.TAX_USE_LOC_EXC_RATE_FLAG%type,
802: TAX_ALLOW_COMPOUND_FLAG zx_product_options_all.TAX_ALLOW_COMPOUND_FLAG%type,
803: USE_TAX_CLASSIFICATION_FLAG zx_product_options_all.USE_TAX_CLASSIFICATION_FLAG%type,
804: ALLOW_TAX_ROUNDING_OVRD_FLAG zx_product_options_all.ALLOW_TAX_ROUNDING_OVRD_FLAG%type,
805: HOME_COUNTRY_DEFAULT_FLAG zx_product_options_all.HOME_COUNTRY_DEFAULT_FLAG%type,
806: TAX_ROUNDING_RULE zx_product_options_all.TAX_ROUNDING_RULE%type,
807: TAX_PRECISION zx_product_options_all.TAX_PRECISION%type,
808: TAX_MINIMUM_ACCOUNTABLE_UNIT zx_product_options_all.TAX_MINIMUM_ACCOUNTABLE_UNIT%type);
809:
802: TAX_ALLOW_COMPOUND_FLAG zx_product_options_all.TAX_ALLOW_COMPOUND_FLAG%type,
803: USE_TAX_CLASSIFICATION_FLAG zx_product_options_all.USE_TAX_CLASSIFICATION_FLAG%type,
804: ALLOW_TAX_ROUNDING_OVRD_FLAG zx_product_options_all.ALLOW_TAX_ROUNDING_OVRD_FLAG%type,
805: HOME_COUNTRY_DEFAULT_FLAG zx_product_options_all.HOME_COUNTRY_DEFAULT_FLAG%type,
806: TAX_ROUNDING_RULE zx_product_options_all.TAX_ROUNDING_RULE%type,
807: TAX_PRECISION zx_product_options_all.TAX_PRECISION%type,
808: TAX_MINIMUM_ACCOUNTABLE_UNIT zx_product_options_all.TAX_MINIMUM_ACCOUNTABLE_UNIT%type);
809:
810: type zx_product_options_tbl_type is table of zx_product_options_rec_type index by binary_integer;
803: USE_TAX_CLASSIFICATION_FLAG zx_product_options_all.USE_TAX_CLASSIFICATION_FLAG%type,
804: ALLOW_TAX_ROUNDING_OVRD_FLAG zx_product_options_all.ALLOW_TAX_ROUNDING_OVRD_FLAG%type,
805: HOME_COUNTRY_DEFAULT_FLAG zx_product_options_all.HOME_COUNTRY_DEFAULT_FLAG%type,
806: TAX_ROUNDING_RULE zx_product_options_all.TAX_ROUNDING_RULE%type,
807: TAX_PRECISION zx_product_options_all.TAX_PRECISION%type,
808: TAX_MINIMUM_ACCOUNTABLE_UNIT zx_product_options_all.TAX_MINIMUM_ACCOUNTABLE_UNIT%type);
809:
810: type zx_product_options_tbl_type is table of zx_product_options_rec_type index by binary_integer;
811:
804: ALLOW_TAX_ROUNDING_OVRD_FLAG zx_product_options_all.ALLOW_TAX_ROUNDING_OVRD_FLAG%type,
805: HOME_COUNTRY_DEFAULT_FLAG zx_product_options_all.HOME_COUNTRY_DEFAULT_FLAG%type,
806: TAX_ROUNDING_RULE zx_product_options_all.TAX_ROUNDING_RULE%type,
807: TAX_PRECISION zx_product_options_all.TAX_PRECISION%type,
808: TAX_MINIMUM_ACCOUNTABLE_UNIT zx_product_options_all.TAX_MINIMUM_ACCOUNTABLE_UNIT%type);
809:
810: type zx_product_options_tbl_type is table of zx_product_options_rec_type index by binary_integer;
811:
812: -- This strucure is used to store information whether a template contains parameters