APPS.BSC_UPDATE dependencies on BSC_DB_PROCESS_ID_S

Line 2006: SELECT BSC_DB_PROCESS_ID_S.NEXTVAL

2002: -- Create a new process with same parameters as given one
2003: -- BSC_DB_PROCESS_CONTROL
2004:
2005: --LOCKING: get the sequence nextval here and then use it
2006: SELECT BSC_DB_PROCESS_ID_S.NEXTVAL
2007: INTO h_process_id
2008: FROM DUAL;
2009:
2010: INSERT INTO BSC_DB_PROCESS_CONTROL (

Line 4879: SELECT bsc_db_process_id_s.nextval

4875: END IF;
4876:
4877: -- Create a new process in BSC_DB_PROCESS_CONTROL
4878: --LOCKING: get the sequence nextval here and then use it
4879: SELECT bsc_db_process_id_s.nextval
4880: INTO h_process_id
4881: FROM DUAL;
4882:
4883: INSERT INTO bsc_db_process_control (process_id, process_name,

Line 5193: SELECT bsc_db_process_id_s.nextval

5189: RETURN;
5190: END IF;
5191:
5192: --LOCKING: get the sequence nextval here and then use it
5193: SELECT bsc_db_process_id_s.nextval
5194: INTO h_process_id
5195: FROM DUAL;
5196:
5197: -- Create a new process in BSC_DB_PROCESS_CONTROL

Line 5420: SELECT bsc_db_process_id_s.nextval

5416: RETURN;
5417: END IF;
5418:
5419: -- LOCKING: get the sequence next val here and then use it
5420: SELECT bsc_db_process_id_s.nextval
5421: INTO h_process_id
5422: FROM DUAL;
5423:
5424: -- Create a new process in BSC_DB_PROCESS_CONTROL