APPS.CCT_CLASS_ENGINE_UPG dependencies on CCT_CLASSIFICATION_VALUES

Line 29: insert into cct_classification_values (classification_value_id, classification_value,seeded,

25: if (l_upgraded > 0) THEN
26: --dbms_output.put_line('Classification Schema is Already Upgraded');
27: return;
28: END IF;
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

Line 31: select cct_classification_values_s.nextval, classification,'N',

27: return;
28: END IF;
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';

Line 37: insert into cct_classification_values (classification_value_id, classification_value,

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,
38: seeded,LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)
39: select cct_classification_values_s.nextval, 'unClassified', 'Y',
40: TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1,
41: TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1 from dual;

Line 39: select cct_classification_values_s.nextval, 'unClassified', 'Y',

35: AND upper(classification) <> 'UNCLASSIFIED';
36:
37: insert into cct_classification_values (classification_value_id, classification_value,
38: seeded,LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)
39: select cct_classification_values_s.nextval, 'unClassified', 'Y',
40: TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1,
41: TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1 from dual;
42:
43: --dbms_output.put_line('Classification Values is Upgraded');

Line 63: select COUNT(*) into l_count from cct_classification_values where l_record.classification = classification_value

59: WHERE type = 'LITERAL' order by f_deletedflag desc)
60: LOOP
61: l_loop_count := l_loop_count + 1;
62: l_updated := 'N';
63: select COUNT(*) into l_count from cct_classification_values where l_record.classification = classification_value
64: and nvl(f_deletedflag,'N')<>'D';
65: select COUNT(*) into l_deleted_count from cct_classification_values where l_record.classification = classification_value
66: and nvl(f_deletedflag,'N')='D';
67: FOR l_classValue_record IN (select classification_value_id, nvl(f_deletedflag,'N') f_deletedflag

Line 65: select COUNT(*) into l_deleted_count from cct_classification_values where l_record.classification = classification_value

61: l_loop_count := l_loop_count + 1;
62: l_updated := 'N';
63: select COUNT(*) into l_count from cct_classification_values where l_record.classification = classification_value
64: and nvl(f_deletedflag,'N')<>'D';
65: select COUNT(*) into l_deleted_count from cct_classification_values where l_record.classification = classification_value
66: and nvl(f_deletedflag,'N')='D';
67: FOR l_classValue_record IN (select classification_value_id, nvl(f_deletedflag,'N') f_deletedflag
68: from cct_classification_values where l_record.classification = classification_value
69: OR (upper(l_record.classification)='UNCLASSIFIED' AND classification_value='unClassified'))

Line 68: from cct_classification_values where l_record.classification = classification_value

64: and nvl(f_deletedflag,'N')<>'D';
65: select COUNT(*) into l_deleted_count from cct_classification_values where l_record.classification = classification_value
66: and nvl(f_deletedflag,'N')='D';
67: FOR l_classValue_record IN (select classification_value_id, nvl(f_deletedflag,'N') f_deletedflag
68: from cct_classification_values where l_record.classification = classification_value
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';

Line 75: --want deleted classificaiton value to sit into cct_classification_values table (due to Business Intelligence req).

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'),
78: a.Priority = l_loop_count,
79: a.Rule_Chaining = nvl(a.Rule_Chaining,'AND')

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 190: -- newly inserted record in cct_classification_values table must have deletedflag set to 'D'.

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:
194: FOR l_record IN (

Line 199: select cct_classification_values_s.nextval into l_class_value_id from dual;

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;
200: insert into cct_classification_values (classification_value_id, classification_value,seeded,
201: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,f_deletedflag)
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'

Line 200: insert into cct_classification_values (classification_value_id, classification_value,seeded,

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;
200: insert into cct_classification_values (classification_value_id, classification_value,seeded,
201: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,f_deletedflag)
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;