APPS.HZ_CLASSIFICATION_V2PUB dependencies on HZ_CLASS_CATEGORIES

Line 107: WHERE owner_table_name = 'HZ_CLASS_CATEGORIES'

103:
104: CURSOR c_check_industrial_group (l_class_category VARCHAR2) IS
105: SELECT 'Y'
106: FROM hz_code_assignments
107: WHERE owner_table_name = 'HZ_CLASS_CATEGORIES'
108: AND class_category = 'CLASS_CATEGORY_GROUP'
109: AND class_code = 'INDUSTRIAL_GROUP'
110: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE+1)
111: AND NVL(status,'A') = 'A'

Line 189: update hz_class_categories

185: */
186: PROCEDURE set_frozen_flag(p_class_category in varchar2) is
187: begin
188:
189: update hz_class_categories
190: set frozen_flag = 'N'
191: where class_category = p_class_category
192: and (frozen_flag = 'Y' or frozen_flag is null);
193:

Line 245: HZ_CLASS_CATEGORIES_PKG.Insert_Row (

241: FND_MSG_PUB.ADD;
242: RAISE FND_API.G_EXC_ERROR;
243: end if;
244:
245: HZ_CLASS_CATEGORIES_PKG.Insert_Row (
246: X_CLASS_CATEGORY => p_class_cat_rec.class_category,
247: X_ALLOW_MULTI_PARENT_FLAG => p_class_cat_rec.allow_multi_parent_flag,
248: X_ALLOW_MULTI_ASSIGN_FLAG => p_class_cat_rec.allow_multi_assign_flag,
249: X_ALLOW_LEAF_NODE_ONLY_FLAG => p_class_cat_rec.allow_leaf_node_only_flag,

Line 305: FROM HZ_CLASS_CATEGORIES

301: SELECT OBJECT_VERSION_NUMBER,
302: ROWID, allow_leaf_node_only_flag,delimiter,allow_multi_parent_flag
303: INTO l_object_version_number,
304: l_rowid,l_allow_leaf_node_only_flag,l_delimiter,l_allow_multi_parent_flag
305: FROM HZ_CLASS_CATEGORIES
306: WHERE CLASS_CATEGORY = p_class_cat_rec.class_category
307: FOR UPDATE OF CLASS_CATEGORY NOWAIT;
308:
309: IF NOT ((p_object_version_number is null and l_object_version_number is null)

Line 313: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CLASS_CATEGORIES');

309: IF NOT ((p_object_version_number is null and l_object_version_number is null)
310: OR (p_object_version_number = l_object_version_number))
311: THEN
312: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
313: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CLASS_CATEGORIES');
314: FND_MSG_PUB.ADD;
315: RAISE FND_API.G_EXC_ERROR;
316: END IF;
317:

Line 322: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CATEGORIES');

318: p_object_version_number := nvl(l_object_version_number, 1) + 1;
319:
320: EXCEPTION WHEN NO_DATA_FOUND THEN
321: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
322: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CATEGORIES');
323: FND_MESSAGE.SET_TOKEN('VALUE', 'p_class_cat_rec.class_category');
324: FND_MSG_PUB.ADD;
325: RAISE FND_API.G_EXC_ERROR;
326: END;

Line 358: HZ_CLASS_CATEGORIES_PKG.Update_Row (

354: end if;
355:
356:
357: -- call to table-handler.
358: HZ_CLASS_CATEGORIES_PKG.Update_Row (
359: X_CLASS_CATEGORY => p_class_cat_rec.class_category,
360: X_ALLOW_MULTI_PARENT_FLAG => p_class_cat_rec.allow_multi_parent_flag,
361: X_ALLOW_MULTI_ASSIGN_FLAG => p_class_cat_rec.allow_multi_assign_flag,
362: X_ALLOW_LEAF_NODE_ONLY_FLAG => p_class_cat_rec.allow_leaf_node_only_flag,

Line 907: AND b.owner_table_name = 'HZ_CLASS_CATEGORIES'

903: and code_assignment_id < p_code_id
904: -- Added for Bug 6059383 (remove hard coding for industrial classification)
905: AND EXISTS (SELECT NULL FROM hz_code_assignments b
906: WHERE a.class_category = b.owner_table_key_1
907: AND b.owner_table_name = 'HZ_CLASS_CATEGORIES'
908: AND b.class_category = 'CLASS_CATEGORY_GROUP'
909: AND b.class_code = 'INDUSTRIAL_GROUP'
910: AND SYSDATE BETWEEN b.start_date_active AND NVL(b.end_date_active,SYSDATE+1)
911: AND NVL(b.status,'A') = 'A'

Line 2639: FROM hz_class_categories

2635: x_class_cat_rec.class_category,
2636: x_class_cat_rec.allow_multi_assign_flag,
2637: x_class_cat_rec.allow_multi_parent_flag,
2638: x_class_cat_rec.allow_leaf_node_only_flag
2639: FROM hz_class_categories
2640: WHERE class_category = p_class_category;
2641: END;
2642:
2643:

Line 2790: * HZ_CLASS_CATEGORIES_PKG.Select_Row

2786: * DESCRIPTION
2787: * Gets class category record.
2788: *
2789: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2790: * HZ_CLASS_CATEGORIES_PKG.Select_Row
2791: *
2792: * ARGUMENTS
2793: * IN:
2794: * p_init_msg_list Initialize message stack if it is set to

Line 2845: HZ_CLASS_CATEGORIES_PKG.Select_Row (

2841: END IF;
2842:
2843: x_class_category_rec.class_category := p_class_category;
2844:
2845: HZ_CLASS_CATEGORIES_PKG.Select_Row (
2846: X_CLASS_CATEGORY => x_class_category_rec.class_category,
2847: X_ALLOW_MULTI_PARENT_FLAG => x_class_category_rec.allow_multi_parent_flag,
2848: X_ALLOW_MULTI_ASSIGN_FLAG => x_class_category_rec.allow_multi_assign_flag,
2849: X_ALLOW_LEAF_NODE_ONLY_FLAG => x_class_category_rec.allow_leaf_node_only_flag,