APPS.CCT_CLASS_ENGINE_UPG dependencies on CCT_PLSQL_FUNCTIONS

Line 44: insert into cct_plsql_functions (function_id, function, function_name, package,appdb,

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');
44: insert into cct_plsql_functions (function_id, function, function_name, package,appdb,
45: dburl, dbdriver, return_type,seeded,LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
46: CREATED_BY)
47: select cct_plsql_functions_s.nextval,substr(classification, instr(classification,'.',1)+1),
48: classification,substr(classification,1, instr(classification,'.',1)-1),

Line 47: select cct_plsql_functions_s.nextval,substr(classification, instr(classification,'.',1)+1),

43: --dbms_output.put_line('Classification Values is Upgraded');
44: insert into cct_plsql_functions (function_id, function, function_name, package,appdb,
45: dburl, dbdriver, return_type,seeded,LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
46: CREATED_BY)
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

Line 93: from cct_plsql_functions b

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,
97: a.Rule_Chaining = nvl(a.Rule_Chaining,'AND')