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.CCT_CLASS_ENGINE_UPG dependencies on CCT_CLASSIFICATIONS

Line 15: FROM CCT_CLASSIFICATIONS

11: l_deleted_count INTEGER := 0;
12: BEGIN
13: BEGIN
14: SELECT Count(*) INTO l_upgraded
15: FROM CCT_CLASSIFICATIONS
16: WHERE CLASSIFICATION_VALUE_ID IS NOT NULL ;
17: --EXECUTE IMMEDIATE 'DROP SEQUENCE cct_upgclass_priority_s';
18: -- EXECUTE IMMEDIATE 'CREATE SEQUENCE cct_upgclass_priority_s START WITH 1';
19: EXCEPTION

Line 33: TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1,a.f_deletedflag from cct_classifications a

29: insert into cct_classification_values (classification_value_id, classification_value,seeded,
30: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,f_deletedflag)
31: select cct_classification_values_s.nextval, classification,'N',
32: TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1,
33: TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1,a.f_deletedflag from cct_classifications a
34: where (upper(type)= 'LITERAL') AND classification_value_id is null
35: AND upper(classification) <> 'UNCLASSIFIED';
36:
37: insert into cct_classification_values (classification_value_id, classification_value,

Line 51: from cct_classifications a

47: select cct_plsql_functions_s.nextval,substr(classification, instr(classification,'.',1)+1),
48: classification,substr(classification,1, instr(classification,'.',1)-1),
49: DECODE(db_driver, nvl(db_driver,'Y'),'N','Y'), dburl, db_driver, 'occtClassification',
50: 'N', TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1,TO_DATE ('01/01/1951', 'DD/MM/YYYY'),1
51: from cct_classifications a
52: where (upper(type)= 'DBPROC')
53: AND classification_value_id is null AND nvl(a.f_deletedflag,'N') <> 'D';
54:
55: --dbms_output.put_line(' PL/SQL Functions is Upgraded');

Line 58: SELECT classification_id, classification FROM cct_classifications

54:
55: --dbms_output.put_line(' PL/SQL Functions is Upgraded');
56:
57: FOR l_record IN (
58: SELECT classification_id, classification FROM cct_classifications
59: WHERE type = 'LITERAL' order by f_deletedflag desc)
60: LOOP
61: l_loop_count := l_loop_count + 1;
62: l_updated := 'N';

Line 73: --In case we have multiple classifications defined in cct_classifications table, We don't

69: OR (upper(l_record.classification)='UNCLASSIFIED' AND classification_value='unClassified'))
70: LOOP
71: IF ((l_count >= 1 OR l_deleted_count >= 1 OR upper(l_record.classification)='UNCLASSIFIED') AND l_updated = 'N') THEN
72: l_updated := 'Y';
73: --In case we have multiple classifications defined in cct_classifications table, We don't
74: --want to update cct_classification table with already deleted classification. Although we still
75: --want deleted classificaiton value to sit into cct_classification_values table (due to Business Intelligence req).
76: update cct_classifications a set a.classification_value_id = l_classValue_record.classification_value_id,
77: a.IsEnabled = nvl(a.IsEnabled,'YES'),

Line 76: update cct_classifications a set a.classification_value_id = l_classValue_record.classification_value_id,

72: l_updated := 'Y';
73: --In case we have multiple classifications defined in cct_classifications table, We don't
74: --want to update cct_classification table with already deleted classification. Although we still
75: --want deleted classificaiton value to sit into cct_classification_values table (due to Business Intelligence req).
76: update cct_classifications a set a.classification_value_id = l_classValue_record.classification_value_id,
77: a.IsEnabled = nvl(a.IsEnabled,'YES'),
78: a.Priority = l_loop_count,
79: a.Rule_Chaining = nvl(a.Rule_Chaining,'AND')
80: where a.classification_id = l_record.classification_id;

Line 81: --DBMS_OUTPUT.PUT_LINE('Inserted into cct_classifications table '||l_classValue_record.classification_value_id||' and '||l_record.classification);

77: a.IsEnabled = nvl(a.IsEnabled,'YES'),
78: a.Priority = l_loop_count,
79: a.Rule_Chaining = nvl(a.Rule_Chaining,'AND')
80: where a.classification_id = l_record.classification_id;
81: --DBMS_OUTPUT.PUT_LINE('Inserted into cct_classifications table '||l_classValue_record.classification_value_id||' and '||l_record.classification);
82: END IF;
83: END LOOP;
84: END LOOP;
85:

Line 88: SELECT classification_id, classification FROM cct_classifications

84: END LOOP;
85:
86:
87: FOR l_record IN (
88: SELECT classification_id, classification FROM cct_classifications
89: WHERE type = 'DBPROC' AND nvl(f_deletedflag,'N')<>'D')
90: LOOP
91: l_loop_count := l_loop_count + 1;
92: update cct_classifications a set a.classification_value_id = (select b.function_id

Line 92: update cct_classifications a set a.classification_value_id = (select b.function_id

88: SELECT classification_id, classification FROM cct_classifications
89: WHERE type = 'DBPROC' AND nvl(f_deletedflag,'N')<>'D')
90: LOOP
91: l_loop_count := l_loop_count + 1;
92: update cct_classifications a set a.classification_value_id = (select b.function_id
93: from cct_plsql_functions b
94: where l_record.classification = b.package||decode(b.package, '','','.')||b.function
95: AND nvl(b.f_deletedflag,'N')<>'D'), a.IsEnabled = nvl(a.IsEnabled,'YES'),
96: a.Priority = l_loop_count,

Line 101: --dbms_output.put_line(' Populate cct_classifications table with PL/SQL Function ids');

97: a.Rule_Chaining = nvl(a.Rule_Chaining,'AND')
98: where a.classification_id = l_record.classification_id;
99: END LOOP;
100:
101: --dbms_output.put_line(' Populate cct_classifications table with PL/SQL Function ids');
102: insert into cct_plsql_function_params (function_param_id,function_id,param,datatype,direction,
103: sequence,value,LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)
104: select cct_plsql_function_params_s.nextval,b.classification_value_id,a.param,
105: a.datatype,a.direction, a.sequence,a.value, TO_DATE ('01/01/1951', 'DD/MM/YYYY'),

Line 107: from cct_route_params a, cct_classifications b

103: sequence,value,LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)
104: select cct_plsql_function_params_s.nextval,b.classification_value_id,a.param,
105: a.datatype,a.direction, a.sequence,a.value, TO_DATE ('01/01/1951', 'DD/MM/YYYY'),
106: 1,TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1
107: from cct_route_params a, cct_classifications b
108: where a.classification_id=b.classification_id AND upper(b.type)='DBPROC'
109: AND nvl(a.f_deletedflag,'N')<>'D' AND nvl(b.f_deletedflag,'N')<>'D';
110:
111: --dbms_output.put_line('Populated pl/sql function params..');

Line 116: from ieo_svr_groups a, cct_classifications b

112: insert into cct_classification_sg_map (classification_sg_map_id, classification_id,
113: server_group_id, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)
114: select cct_classification_sg_map_s.nextval, b.classification_id, a.server_group_id,
115: TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1,TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1
116: from ieo_svr_groups a, cct_classifications b
117: where a.group_group_id is null AND nvl(b.f_deletedflag,'N')<>'D';
118:
119: --dbms_output.put_line(' Populate cct_sg_map table ');
120: insert into cct_classification_mt_map (classification_mt_map_id,

Line 126: 1 from cct_supported_media_types a, cct_classifications b

122: CREATION_DATE, CREATED_BY)
123: select cct_classification_mt_map_s.nextval, b.classification_id,
124: a.media_type_uuid, TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1,
125: TO_DATE ('01/01/1951', 'DD/MM/YYYY'),
126: 1 from cct_supported_media_types a, cct_classifications b
127: where nvl(b.f_deletedflag,'N')<>'D';
128:
129: --dbms_output.put_line(' Populate cct_mt_map table ');
130:

Line 143: FROM cct_classification_sg_map map,cct_classifications class

139: where nvl(f_deletedflag,'N')<>'D';
140:
141: CURSOR csr_classifications(p_server_group_id number) IS
142: SELECT map.classification_id
143: FROM cct_classification_sg_map map,cct_classifications class
144: where map.server_group_id=p_server_Group_id
145: and nvl(map.f_deletedflag,'N')<>'D'
146: and map.priority is null
147: and map.classification_id=class.classification_id

Line 189: -- Insert all deleted Classifications from cct_classifications table to a cct_classification_values table. This

185: procedure Upgrade_Class_BI
186: IS
187: l_class_value_id Number(15);
188: BEGIN
189: -- Insert all deleted Classifications from cct_classifications table to a cct_classification_values table. This
190: -- newly inserted record in cct_classification_values table must have deletedflag set to 'D'.
191: -- As 1158 upgrade script won't carry over deleted classifications and Business Intelligence team needs those.
192: -- Update cct_classifications table with this new classification_value_id.
193:

Line 192: -- Update cct_classifications table with this new classification_value_id.

188: BEGIN
189: -- Insert all deleted Classifications from cct_classifications table to a cct_classification_values table. This
190: -- newly inserted record in cct_classification_values table must have deletedflag set to 'D'.
191: -- As 1158 upgrade script won't carry over deleted classifications and Business Intelligence team needs those.
192: -- Update cct_classifications table with this new classification_value_id.
193:
194: FOR l_record IN (
195: SELECT classification, classification_id FROM cct_classifications
196: where (upper(type)= 'LITERAL') AND classification_value_id is null

Line 195: SELECT classification, classification_id FROM cct_classifications

191: -- As 1158 upgrade script won't carry over deleted classifications and Business Intelligence team needs those.
192: -- Update cct_classifications table with this new classification_value_id.
193:
194: FOR l_record IN (
195: SELECT classification, classification_id FROM cct_classifications
196: where (upper(type)= 'LITERAL') AND classification_value_id is null
197: AND nvl(f_deletedflag,'N')='D' AND upper(classification) <> 'UNCLASSIFIED')
198: LOOP
199: select cct_classification_values_s.nextval into l_class_value_id from dual;

Line 206: update cct_classifications a set a.classification_value_id = l_class_value_id

202: select l_class_value_id, l_record.classification,'N',
203: TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1, TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1,'D'
204: from dual;
205:
206: update cct_classifications a set a.classification_value_id = l_class_value_id
207: where a.classification_id = l_record.classification_id;
208:
209: --dbms_output.put_line('At End of UpgradeBI loop');
210: END LOOP;