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 895: AND b.owner_table_name = 'HZ_CLASS_CATEGORIES'

891: and code_assignment_id < p_code_id
892: -- Added for Bug 6059383 (remove hard coding for industrial classification)
893: AND EXISTS (SELECT NULL FROM hz_code_assignments b
894: WHERE a.class_category = b.owner_table_key_1
895: AND b.owner_table_name = 'HZ_CLASS_CATEGORIES'
896: AND b.class_category = 'CLASS_CATEGORY_GROUP'
897: AND b.class_code = 'INDUSTRIAL_GROUP'
898: AND SYSDATE BETWEEN b.start_date_active AND NVL(b.end_date_active,SYSDATE+1)
899: AND NVL(b.status,'A') = 'A'

Line 2613: FROM hz_class_categories

2609: x_class_cat_rec.class_category,
2610: x_class_cat_rec.allow_multi_assign_flag,
2611: x_class_cat_rec.allow_multi_parent_flag,
2612: x_class_cat_rec.allow_leaf_node_only_flag
2613: FROM hz_class_categories
2614: WHERE class_category = p_class_category;
2615: END;
2616:
2617:

Line 2764: * HZ_CLASS_CATEGORIES_PKG.Select_Row

2760: * DESCRIPTION
2761: * Gets class category record.
2762: *
2763: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2764: * HZ_CLASS_CATEGORIES_PKG.Select_Row
2765: *
2766: * ARGUMENTS
2767: * IN:
2768: * p_init_msg_list Initialize message stack if it is set to

Line 2819: HZ_CLASS_CATEGORIES_PKG.Select_Row (

2815: END IF;
2816:
2817: x_class_category_rec.class_category := p_class_category;
2818:
2819: HZ_CLASS_CATEGORIES_PKG.Select_Row (
2820: X_CLASS_CATEGORY => x_class_category_rec.class_category,
2821: X_ALLOW_MULTI_PARENT_FLAG => x_class_category_rec.allow_multi_parent_flag,
2822: X_ALLOW_MULTI_ASSIGN_FLAG => x_class_category_rec.allow_multi_assign_flag,
2823: X_ALLOW_LEAF_NODE_ONLY_FLAG => x_class_category_rec.allow_leaf_node_only_flag,