APPS.OPI_EDW_OPMCOGS_F_C dependencies on OPI_EDW_OPMCOGS_INC_S

Line 398: select OPI_EDW_OPMCOGS_INC_S.nextval into l_seq_id from dual;

394: l_status VARCHAR2(30);
395: l_industry VARCHAR2(30);
396: BEGIN
397: p_count := 0;
398: select OPI_EDW_OPMCOGS_INC_S.nextval into l_seq_id from dual;
399: IF p_view_id = 1 THEN
400: INSERT /*+ parallel(OPI_EDW_OPMCOGS_INC) */
401: into OPI_EDW_OPMCOGS_INC (LINE_ID,view_id,seq_id)
402: SELECT

Line 422: UPDATE OPI_EDW_OPMCOGS_INC set SEQ_Id=l_SEQ_ID

418: (select LINE_ID from OPI_EDW_OPMCOGS_INC
419: WHERE VIEW_ID = 1 AND SEQ_ID is NULL);
420: p_count := sql%rowcount;
421:
422: UPDATE OPI_EDW_OPMCOGS_INC set SEQ_Id=l_SEQ_ID
423: WHERE VIEW_ID=1 AND SEQ_ID is NULL;
424:
425: p_count := P_count+sql%rowcount;
426:

Line 451: UPDATE OPI_EDW_OPMCOGS_INC set SEQ_Id=l_SEQ_ID

447: (select LINE_ID from OPI_EDW_OPMCOGS_INC
448: WHERE VIEW_ID = 2 AND SEQ_ID is NULL);
449: p_count := sql%rowcount;
450:
451: UPDATE OPI_EDW_OPMCOGS_INC set SEQ_Id=l_SEQ_ID
452: WHERE VIEW_ID=2 AND SEQ_ID is NULL;
453: p_count := P_count+sql%rowcount;
454: END IF;
455: