eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_CLASS_VALIDATE_V2PUB dependencies on HZ_CLASS_CATEGORIES

Line 347: from hz_class_categories

343: varchar2) return varchar2 is
344:
345: cursor get_invalid_meaning_csr is
346: select 'x'
347: from hz_class_categories
348: where class_category = p_class_category
349: and instrb(p_meaning,delimiter)>0;
350:
351: l_tmp varchar2(1);

Line 371: FROM hz_class_categories

367: IS
368: CURSOR c_exist_class_category(p_class_category IN VARCHAR2)
369: IS
370: SELECT 'Y'
371: FROM hz_class_categories
372: WHERE class_category = p_class_category
373: AND ROWNUM = 1;
374: l_exist VARCHAR2(1);
375: BEGIN

Line 382: fnd_message.set_token('TABLE','hz_class_categories');

378: IF c_exist_class_category%NOTFOUND THEN
379: fnd_message.set_name('AR','HZ_API_INVALID_FK');
380: fnd_message.set_token('FK','class_category');
381: fnd_message.set_token('COLUMN','class_category');
382: fnd_message.set_token('TABLE','hz_class_categories');
383: fnd_msg_pub.add;
384: x_return_status := fnd_api.g_ret_sts_error;
385: END IF;
386: CLOSE c_exist_class_category;

Line 559: -- Validation for Hz_Class_Categories --

555: END;
556: */
557:
558: /*----------------------------------------
559: -- Validation for Hz_Class_Categories --
560: ----------------------------------------*/
561: FUNCTION exist_code_ass_not_node
562: -- This function answer to the question:
563: -- Return 'Y' if the category has one or more Non-Leaf-node Class Codes associated with instances of entities

Line 828: FROM hz_class_categories

824: IS
825: CURSOR c0
826: IS
827: SELECT 'Y'
828: FROM hz_class_categories
829: WHERE class_category = p_class_category;
830: l_yn VARCHAR2(1);
831: result VARCHAR2(1);
832: BEGIN

Line 944: l_created_by_module hz_class_categories.created_by_module%TYPE := NULL;

940: create_update_flag IN VARCHAR2,
941: x_return_status IN OUT NOCOPY VARCHAR2
942: ) IS
943: l_count NUMBER;
944: l_created_by_module hz_class_categories.created_by_module%TYPE := NULL;
945:
946: CURSOR cu_lookup_type IS
947: SELECT 1
948: FROM fnd_lookup_types

Line 954: from hz_class_categories

950: AND rownum = 1;
951:
952: CURSOR c_categories IS
953: select created_by_module
954: from hz_class_categories
955: where class_category = p_class_cat_rec.class_category;
956:
957: BEGIN
958:

Line 1425: FROM hz_class_categories

1421: IS
1422: CURSOR c0
1423: IS
1424: SELECT allow_leaf_node_only_flag
1425: FROM hz_class_categories
1426: WHERE class_category = p_class_category;
1427: l_yn VARCHAR2(1);
1428: result VARCHAR2(1);
1429: BEGIN

Line 1450: FROM hz_class_categories

1446: IS
1447: CURSOR c0
1448: IS
1449: SELECT allow_multi_assign_flag
1450: FROM hz_class_categories
1451: WHERE class_category = p_class_category;
1452: result VARCHAR2(1);
1453: l_flag VARCHAR2(1);
1454: BEGIN

Line 2309: FROM hz_class_categories

2305: /*
2306: IF create_update_flag = 'C'
2307: THEN
2308: SELECT COUNT(1) INTO l_count
2309: FROM hz_class_categories
2310: WHERE class_category = p_in_rec.class_category;
2311:
2312: IF l_count = 0 THEN
2313: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

Line 2316: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_class_categories');

2312: IF l_count = 0 THEN
2313: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
2314: FND_MESSAGE.SET_TOKEN('FK', 'class_category');
2315: FND_MESSAGE.SET_TOKEN('COLUMN', 'class_category');
2316: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_class_categories');
2317: FND_MSG_PUB.ADD;
2318: x_return_status := FND_API.G_RET_STS_ERROR;
2319:
2320: RAISE G_EX_INVALID_PARAM;

Line 2333: from hz_class_categories where

2329:
2330: -- Check if the flag is set to 'N'
2331:
2332: select ALLOW_MULTI_ASSIGN_FLAG into l_allow_multi_assign_flag
2333: from hz_class_categories where
2334: -- Bug 3941471
2335: class_category = nvl(p_in_rec.class_category,l_class_category);
2336:
2337: Exception

Line 2342: fnd_message.set_token('TABLE','hz_class_categories');

2338: When no_data_found then
2339: fnd_message.set_name('AR','HZ_API_INVALID_FK');
2340: fnd_message.set_token('FK','class_category');
2341: fnd_message.set_token('COLUMN','class_category');
2342: fnd_message.set_token('TABLE','hz_class_categories');
2343: fnd_msg_pub.add;
2344: x_return_status := fnd_api.g_ret_sts_error;
2345: end;
2346:

Line 2520: , hz_class_categories c_cate

2516: BEGIN
2517: select decode(sign(count(*)-1),0,null,'Y')
2518: into allow_leaf_error
2519: from hz_class_code_relations c_rel
2520: , hz_class_categories c_cate
2521: where c_cate.class_category=c_rel.class_category and
2522: allow_leaf_node_only_flag = 'Y' and
2523: --owner_table_name = nvl(p_in_rec.owner_table_name, l_owner_table_name) AND
2524: --owner_table_id = nvl(p_in_rec.owner_table_id, l_owner_table_id) AND

Line 2555: from hz_class_code_relations c_rel, hz_class_categories c_cate

2551:
2552: -- START validation
2553: Begin
2554: select 'Y' into allow_leaf_error
2555: from hz_class_code_relations c_rel, hz_class_categories c_cate
2556: where c_cate.class_category=c_rel.class_category and
2557: allow_leaf_node_only_flag = 'Y' and
2558: c_cate.class_category = nvl(p_in_rec.class_category, l_class_category) AND
2559: class_code = nvl(p_in_rec.class_code, l_class_code) AND

Line 3123: FROM hz_class_categories

3119: IS
3120: CURSOR c0
3121: IS
3122: SELECT allow_multi_parent_flag
3123: FROM hz_class_categories
3124: WHERE class_category = p_class_category;
3125: result VARCHAR2(1);
3126: l_flag VARCHAR2(1);
3127: BEGIN