APPS.HZ_CLASS_VALIDATE_V2PUB dependencies on HZ_CLASS_CATEGORY_USES

Line 1156: -- Validation for Hz_Class_Category_Uses --

1152:
1153:
1154:
1155: /*-------------------------------------------
1156: -- Validation for Hz_Class_Category_Uses --
1157: -------------------------------------------*/
1158: FUNCTION existence_couple_clacat_owntab
1159: ( p_create_update_flag IN VARCHAR2,
1160: p_class_category IN VARCHAR2,

Line 1169: FROM hz_class_category_uses

1165: p_class_category IN VARCHAR2,
1166: p_owner_table IN VARCHAR2)
1167: IS
1168: SELECT COUNT(1)
1169: FROM hz_class_category_uses
1170: WHERE class_category = p_class_category
1171: AND owner_table = p_owner_table;
1172: l_count NUMBER;
1173: result VARCHAR2(1);

Line 1199: l_created_by_module hz_class_category_uses.created_by_module%TYPE;

1195: l_end_date DATE := NULL;
1196: l_count NUMBER := 0;
1197: l_yn VARCHAR2(1);
1198: xx_obj varchar2(1) := NULL;
1199: l_created_by_module hz_class_category_uses.created_by_module%TYPE;
1200:
1201: CURSOR c_uses IS
1202: select created_by_module
1203: from hz_class_category_uses

Line 1203: from hz_class_category_uses

1199: l_created_by_module hz_class_category_uses.created_by_module%TYPE;
1200:
1201: CURSOR c_uses IS
1202: select created_by_module
1203: from hz_class_category_uses
1204: where class_category = p_in_rec.class_category
1205: and owner_table = p_in_rec.owner_table;
1206:
1207: BEGIN

Line 1564: FROM hz_class_category_uses

1560: CURSOR c0
1561: IS
1562: SELECT column_name,
1563: additional_where_clause
1564: FROM hz_class_category_uses
1565: WHERE upper(class_category) = upper(p_class_category)
1566: AND upper(owner_table) = upper(p_owner_table_name);
1567: l_column_name VARCHAR2(240);
1568: l_add_where_clause VARCHAR2(4000);

Line 2218: -- Also, code assignment UI should look against HZ_CLASS_CATEGORY_USES

2214:
2215:
2216:
2217: -- Removing this validation as per discussions with Dylan
2218: -- Also, code assignment UI should look against HZ_CLASS_CATEGORY_USES
2219: -- and not go against this lookup.
2220:
2221: --Check for lookup type validations.
2222: -- validate_fnd_lookup(