APPS.OPI_DBI_REP_UOM_STD_CONV_PKG dependencies on OPI_DBI_CONC_PROG_RUN_LOG

Line 514: UPDATE opi_dbi_conc_prog_run_log

510: l_stmt_id := 10;
511:
512: -- Update the row for this ETL. It is assumed that there is only
513: -- one such row.
514: UPDATE opi_dbi_conc_prog_run_log
515: SET last_run_date = p_run_date,
516: last_update_date = sysdate,
517: last_updated_by = s_user_id,
518: last_update_login = s_login_id,

Line 552: 1. Rows from OPI_DBI_CONC_PROG_RUN_LOG where row type = REP_UOM.

548: 1. OPI_DBI_REP_UOM_STD_CONV_F
549: 2. OPI_DBI_REP_UOM_CONV_STG
550:
551: Deletes:
552: 1. Rows from OPI_DBI_CONC_PROG_RUN_LOG where row type = REP_UOM.
553:
554: Inserts:
555: 1. Row into OPI_DBI_CONC_PROG_RUN_LOG where row type = REP_UOM with a
556: last run date that is very old (e.g. 1st Jan, 1950);

Line 555: 1. Row into OPI_DBI_CONC_PROG_RUN_LOG where row type = REP_UOM with a

551: Deletes:
552: 1. Rows from OPI_DBI_CONC_PROG_RUN_LOG where row type = REP_UOM.
553:
554: Inserts:
555: 1. Row into OPI_DBI_CONC_PROG_RUN_LOG where row type = REP_UOM with a
556: last run date that is very old (e.g. 1st Jan, 1950);
557:
558: History:
559: Date Author Action

Line 588: FROM opi_dbi_conc_prog_run_log

584:
585: l_stmt_id := 30;
586: -- Delete all rows for this ETL from the log table
587: DELETE
588: FROM opi_dbi_conc_prog_run_log
589: WHERE etl_type = C_ETL_TYPE;
590:
591: l_stmt_id := 40;
592: commit;

Line 596: INSERT INTO opi_dbi_conc_prog_run_log (

592: commit;
593:
594: l_stmt_id := 50;
595: -- insert a row into the run log with a very old run date.
596: INSERT INTO opi_dbi_conc_prog_run_log (
597: etl_type,
598: last_run_date,
599: created_by,
600: creation_date,

Line 936: FROM opi_dbi_conc_prog_run_log

932: l_stmt_id := 20;
933: -- Delete all rows for this ETL from the log table
934: SELECT count (1)
935: INTO l_cnt
936: FROM opi_dbi_conc_prog_run_log
937: WHERE etl_type = C_ETL_TYPE;
938:
939:
940: l_stmt_id := 30;