DBA Data[Home] [Help]

APPS.OM_TAX_UTIL dependencies on ZX_PRODUCT_TYPES_DEF_V

Line 247: l_product_type zx_product_types_def_v.classification_code%TYPE;

243: l_msg_count NUMBER;
244: l_msg_data VARCHAR2(1000);
245: om_tax_info_rec_tbl om_tax_rec_tab_type;
246: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
247: l_product_type zx_product_types_def_v.classification_code%TYPE;
248: l_trx_date DATE;
249: l_product_code VARCHAR2(1000);
250: BEGIN
251: SELECT FND_PROFILE.VALUE('ONT_SOURCE_CODE') INTO l_dummy FROM DUAL;

Line 729: -- this should be GOODS/SERVICES based on zx_product_types_def_v.

725: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(k) := l_uom_code;
726: IF l_inventory_item_id IS NULL THEN
727: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(k) := NULL;
728: ELSE
729: -- this should be GOODS/SERVICES based on zx_product_types_def_v.
730: -- to be changed when zx_product_types_def_v is available.
731: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(k) := l_product_type;
732: END IF;
733: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CODE(k) := l_product_code;

Line 730: -- to be changed when zx_product_types_def_v is available.

726: IF l_inventory_item_id IS NULL THEN
727: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(k) := NULL;
728: ELSE
729: -- this should be GOODS/SERVICES based on zx_product_types_def_v.
730: -- to be changed when zx_product_types_def_v is available.
731: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(k) := l_product_type;
732: END IF;
733: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CODE(k) := l_product_code;
734: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CATEGORY(k) := NULL;

Line 1145: -- this should be GOODS/SERVICES based on zx_product_types_def_v.

1141: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(k) := l_uom_code;
1142: IF l_inventory_item_id IS NULL THEN
1143: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(k) := NULL;
1144: ELSE
1145: -- this should be GOODS/SERVICES based on zx_product_types_def_v.
1146: -- to be changed when zx_product_types_def_v is available.
1147: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(k) := l_product_type;
1148: END IF;
1149: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CODE(k) := l_product_code;

Line 1146: -- to be changed when zx_product_types_def_v is available.

1142: IF l_inventory_item_id IS NULL THEN
1143: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(k) := NULL;
1144: ELSE
1145: -- this should be GOODS/SERVICES based on zx_product_types_def_v.
1146: -- to be changed when zx_product_types_def_v is available.
1147: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(k) := l_product_type;
1148: END IF;
1149: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CODE(k) := l_product_code;
1150: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CATEGORY(k) := NULL;

Line 1600: -- this should be GOODS/SERVICES based on zx_product_types_def_v.

1596: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(k) := l_uom_code;
1597: IF l_inventory_item_id IS NULL THEN
1598: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(k) := NULL;
1599: ELSE
1600: -- this should be GOODS/SERVICES based on zx_product_types_def_v.
1601: -- to be changed when zx_product_types_def_v is available.
1602: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(k) := l_product_type;
1603: END IF;
1604: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CODE(k) := l_product_code;

Line 1601: -- to be changed when zx_product_types_def_v is available.

1597: IF l_inventory_item_id IS NULL THEN
1598: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(k) := NULL;
1599: ELSE
1600: -- this should be GOODS/SERVICES based on zx_product_types_def_v.
1601: -- to be changed when zx_product_types_def_v is available.
1602: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(k) := l_product_type;
1603: END IF;
1604: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CODE(k) := l_product_code;
1605: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CATEGORY(k) := NULL;