APPS.OPI_DBI_RPT_UTIL_PKG dependencies on OPI_DBI_CONC_PROG_RUN_LOG

Line 3685: log table viz. OPI_DBI_CONC_PROG_RUN_LOG.

3681: Parameters : p_inv_migration_date (OUT parameter)
3682: Purpose : This procedure is called by DBI ETL's in the areas of
3683: Manufacturing and Inventory to get the R12 migration date,
3684: which was inserted by the 'set'procedure into one of DBI
3685: log table viz. OPI_DBI_CONC_PROG_RUN_LOG.
3686: If such date is not found in the log table, we look at
3687: the max of the last update in the Inventory Balances Table
3688: viz. IC_LOCT_INV.
3689: For a new customer directly going into R12, the above 2

Line 3716: OPI_DBI_CONC_PROG_RUN_LOG

3712: l_stmt_id := 10;
3713: SELECT count (*)
3714: INTO l_rowcount
3715: FROM
3716: OPI_DBI_CONC_PROG_RUN_LOG
3717: WHERE
3718: ETL_TYPE = 'R12_MIGRATION';
3719:
3720: --get the R12 Convergence Date from the Log Table

Line 3729: opi_dbi_conc_prog_run_log

3725: last_run_date
3726: INTO
3727: l_inv_migration_date
3728: FROM
3729: opi_dbi_conc_prog_run_log
3730: WHERE
3731: etl_type = 'R12_MIGRATION';
3732: p_inv_migration_date := l_inv_migration_date;
3733: --}

Line 3823: MERGE INTO OPI_DBI_CONC_PROG_RUN_LOG log

3819: l_program_application_id := nvl (fnd_global.prog_appl_id, -1);
3820: l_request_id := nvl (fnd_global.conc_request_id, -1);
3821:
3822: l_stmt_id := 10;
3823: MERGE INTO OPI_DBI_CONC_PROG_RUN_LOG log
3824: USING (
3825: SELECT
3826: 'R12_MIGRATION' ETL_TYPE,
3827: p_migration_date LAST_RUN_DATE , -- R12 migration date