APPS.HZ_SEED_CLASS_CAT_PKG dependencies on HZ_CLASS_CATEGORIES

Line 13: WHERE table_name = 'HZ_CLASS_CATEGORIES'

9: IS
10: CURSOR c1(l_schema IN VARCHAR2) IS
11: SELECT 'Y'
12: FROM sys.all_tab_columns
13: WHERE table_name = 'HZ_CLASS_CATEGORIES'
14: AND column_name = 'ALLOW_LEAF_NODE_ONLY_FLAG'
15: AND owner = l_schema;
16:
17: lyn VARCHAR2(1);

Line 23: FROM hz_class_categories

19: no_data_found2 exception;
20:
21: CURSOR c2 (l_cat IN VARCHAR2) IS
22: SELECT 'Y'
23: FROM hz_class_categories
24: WHERE class_category = l_cat;
25: lyn2 VARCHAR2(1);
26:
27: l_str VARCHAR2(2000);

Line 65: l_str :=' update HZ_CLASS_CATEGORIES set '||

61:
62: IF lyn = 'Y' THEN
63: IF lyn2 = 'Y' THEN
64:
65: l_str :=' update HZ_CLASS_CATEGORIES set '||
66: ' ALLOW_MULTI_ASSIGN_FLAG = '''||l_allow_maf||''', '||
67: ' ALLOW_MULTI_PARENT_FLAG = '''||l_allow_mpf||''', '||
68: ' ALLOW_LEAF_NODE_ONLY_FLAG = '''||l_allow_lnof||''', '||
69: ' LAST_UPDATED_BY = '''||TO_CHAR(p_user_id)||''', '||

Line 75: l_str :=' insert into HZ_CLASS_CATEGORIES( '||

71: ' LAST_UPDATE_LOGIN = 0 '||
72: ' where CLASS_CATEGORY = '''||l_class_cat||'''';
73: ELSE
74:
75: l_str :=' insert into HZ_CLASS_CATEGORIES( '||
76: ' CLASS_CATEGORY, '||
77: ' ALLOW_MULTI_ASSIGN_FLAG, '||
78: ' ALLOW_MULTI_PARENT_FLAG, '||
79: ' ALLOW_LEAF_NODE_ONLY_FLAG, '||

Line 104: l_str := ' update HZ_CLASS_CATEGORIES set '||

100: ELSE
101:
102: IF lyn2 = 'Y' THEN
103:
104: l_str := ' update HZ_CLASS_CATEGORIES set '||
105: ' ALLOW_MULTI_ASSIGN_FLAG = '''||l_allow_maf||''', '||
106: ' ALLOW_MULTI_PARENT_FLAG = '''||l_allow_mpf||''', '||
107: ' LAST_UPDATED_BY = '''||TO_CHAR(p_user_id)||''', '||
108: ' LAST_UPDATE_DATE = '''|| TO_CHAR(SYSDATE)||''', '||

Line 113: l_str :=' insert into HZ_CLASS_CATEGORIES( '||

109: ' LAST_UPDATE_LOGIN = 0 '||
110: ' where CLASS_CATEGORY = '''||l_class_cat||'''';
111: ELSE
112:
113: l_str :=' insert into HZ_CLASS_CATEGORIES( '||
114: ' CLASS_CATEGORY, '||
115: ' ALLOW_MULTI_ASSIGN_FLAG, '||
116: ' ALLOW_MULTI_PARENT_FLAG, '||
117: ' DELIMITER, ' ||