APPS.CCT_CLASS_ENGINE_UPG dependencies on CCT_CLASSIFICATION_VALUES_S

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 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 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'