APPS.HZ_SEED_CLASS_CAT_PKG dependencies on HZ_CLASS_CATEGORIES

Line 14: WHERE table_name = 'HZ_CLASS_CATEGORIES'

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

Line 23: where syn.synonym_name = 'HZ_CLASS_CATEGORIES'

19: select 'Y'
20: from
21: user_synonyms syn
22: , dba_tab_columns col
23: where syn.synonym_name = 'HZ_CLASS_CATEGORIES'
24: and col.owner = syn.table_owner
25: and col.table_name = syn.table_name
26: and col.column_name = 'ALLOW_LEAF_NODE_ONLY_FLAG';
27:

Line 34: FROM hz_class_categories

30: no_data_found2 exception;
31:
32: CURSOR c2 (l_cat IN VARCHAR2) IS
33: SELECT 'Y'
34: FROM hz_class_categories
35: WHERE class_category = l_cat;
36: lyn2 VARCHAR2(1);
37:
38: l_str VARCHAR2(2000);

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

72:
73: IF lyn = 'Y' THEN
74: IF lyn2 = 'Y' THEN
75:
76: l_str :=' update HZ_CLASS_CATEGORIES set '||
77: ' ALLOW_MULTI_ASSIGN_FLAG = '''||l_allow_maf||''', '||
78: ' ALLOW_MULTI_PARENT_FLAG = '''||l_allow_mpf||''', '||
79: ' ALLOW_LEAF_NODE_ONLY_FLAG = '''||l_allow_lnof||''', '||
80: ' LAST_UPDATED_BY = '''||TO_CHAR(p_user_id)||''', '||

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

82: ' LAST_UPDATE_LOGIN = 0 '||
83: ' where CLASS_CATEGORY = '''||l_class_cat||'''';
84: ELSE
85:
86: l_str :=' insert into HZ_CLASS_CATEGORIES( '||
87: ' CLASS_CATEGORY, '||
88: ' ALLOW_MULTI_ASSIGN_FLAG, '||
89: ' ALLOW_MULTI_PARENT_FLAG, '||
90: ' ALLOW_LEAF_NODE_ONLY_FLAG, '||

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

111: ELSE
112:
113: IF lyn2 = 'Y' THEN
114:
115: l_str := ' update HZ_CLASS_CATEGORIES set '||
116: ' ALLOW_MULTI_ASSIGN_FLAG = '''||l_allow_maf||''', '||
117: ' ALLOW_MULTI_PARENT_FLAG = '''||l_allow_mpf||''', '||
118: ' LAST_UPDATED_BY = '''||TO_CHAR(p_user_id)||''', '||
119: ' LAST_UPDATE_DATE = '''|| TO_CHAR(SYSDATE)||''', '||

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

120: ' LAST_UPDATE_LOGIN = 0 '||
121: ' where CLASS_CATEGORY = '''||l_class_cat||'''';
122: ELSE
123:
124: l_str :=' insert into HZ_CLASS_CATEGORIES( '||
125: ' CLASS_CATEGORY, '||
126: ' ALLOW_MULTI_ASSIGN_FLAG, '||
127: ' ALLOW_MULTI_PARENT_FLAG, '||
128: ' DELIMITER, ' ||