APPS.OKS_UPGRADE_PRECHECK dependencies on CS_BUSINESS_PROCESSES

Line 389: FROM cs_business_processes

385: x_Return_Msg := NULL;
386:
387: SELECT count(*)
388: INTO l_busproc_cnt
389: FROM cs_business_processes
390: WHERE UPPER(name) = UPPER('SERVICE_CONTRACTS_UPGRADE_BP');
391:
392: IF l_busproc_cnt <> 0
393: THEN

Line 398: FROM cs_business_processes;

394: NULL;
395: ELSE
396: SELECT max(BUSINESS_PROCESS_ID)+1
397: INTO l_busproc_id
398: FROM cs_business_processes;
399:
400:
401: INSERT into cs_business_processes(
402: BUSINESS_PROCESS_ID ,

Line 401: INSERT into cs_business_processes(

397: INTO l_busproc_id
398: FROM cs_business_processes;
399:
400:
401: INSERT into cs_business_processes(
402: BUSINESS_PROCESS_ID ,
403: ORDER_TYPE_ID ,
404: NAME ,
405: LAST_UPDATE_DATE ,

Line 575: FROM CS_BUSINESS_PROCESSES

571: x_Return_Msg OUT NOCOPY Varchar2)
572: IS
573: CURSOR Cur_bus_proc IS
574: SELECT business_process_id
575: FROM CS_BUSINESS_PROCESSES
576: WHERE NAME = 'SERVICE_CONTRACTS_UPGRADE_BP';
577:
578: L_ROWID varchar2(2000) :=null;
579: L_BUSINESS_PROCESS_ID NUMBER :=null;