APPS.OPI_DBI_WMS_STORAGE_UTZ_PKG dependencies on OPI_DBI_CONC_PROG_RUN_LOG

Line 322: UPDATE opi_dbi_conc_prog_run_log

318: l_stmt_id := 10;
319:
320: -- Update the row for this ETL. It is assumed that there is only
321: -- one such row.
322: UPDATE opi_dbi_conc_prog_run_log
323: SET last_run_date = p_run_date,
324: last_update_date = sysdate,
325: last_updated_by = s_user_id,
326: last_update_login = s_login_id,

Line 571: Clean up the run log table, OPI_DBI_CONC_PROG_RUN_LOG

567: Truncate the following tables:
568: 1. opi_dbi_wms_stor_item_conv_f
569: 2. opi_dbi_wms_stor_item_conv_stg
570:
571: Clean up the run log table, OPI_DBI_CONC_PROG_RUN_LOG
572: and seed in a new row.
573:
574:
575: History:

Line 609: FROM opi_dbi_conc_prog_run_log

605:
606: l_stmt_id := 30;
607: -- Delete all rows from the log table for this ETL.
608: DELETE
609: FROM opi_dbi_conc_prog_run_log
610: WHERE etl_type = C_ETL_TYPE;
611:
612: l_stmt_id := 40;
613: -- Record the delete

Line 619: INSERT INTO opi_dbi_conc_prog_run_log (

615:
616: l_stmt_id := 50;
617: -- Create a new row for the ETL in the run log, with a last
618: -- run date set to a very log time ago.
619: INSERT INTO opi_dbi_conc_prog_run_log (
620: etl_type,
621: last_run_date,
622: created_by,
623: creation_date,

Line 1180: FROM opi_dbi_conc_prog_run_log

1176: l_stmt_id := 20;
1177: -- Check all rows for this ETL from the log table
1178: SELECT count (1)
1179: INTO l_cnt
1180: FROM opi_dbi_conc_prog_run_log
1181: WHERE etl_type = C_ETL_TYPE;
1182:
1183:
1184: l_stmt_id := 30;