APPS.OPI_DBI_WIP_COMP_OPM_PKG dependencies on OPI_DBI_RUN_LOG_CURR

Line 95: opi_dbi_run_log_curr log

91: TRUNC(sub.gl_trans_date) gl_trans_date,
92: SUM(sub.amount_base * sub.debit_credit_sign) amount_base
93: FROM
94: gl_subr_led sub,
95: opi_dbi_run_log_curr log
96: WHERE
97: sub.gl_trans_date >= p_global_start_date
98: AND sub.acct_ttl_type = 1500
99: AND sub.doc_type = 'PROD'

Line 136: from opi_dbi_run_log_curr

132: -- If prior were allowed to be truncated when current was already truncated by an
133: -- aborted but committed previous attempt, then the prior data would be lost.
134:
135: select stop_reason_code into l_prior_populated -- get state of prior table from log
136: from opi_dbi_run_log_curr
137: where etl_id = 1
138: and source = 2;
139:
140: if NVL(l_prior_populated, 0) <> 9999 --if state = successful

Line 149: update opi_dbi_run_log_curr -- state = prior populated and current truncated

145: (orgn_code, item_id, gl_trans_date, trans_qty, amount_base)
146: SELECT orgn_code, item_id, gl_trans_date, trans_qty, amount_base
147: FROM opi_dbi_opm_wip_tst_current;
148:
149: update opi_dbi_run_log_curr -- state = prior populated and current truncated
150: set
151: stop_reason_code = 9999, -- flag to indicate prior tst table has been populated
152: last_update_date = sysdate,
153: last_updated_by = s_user_id,

Line 385: -- Report success to OPI_DBI_RUN_LOG_CURR.

381: -- Sum up WIP Completions, join in other needed tables
382: l_stmt_id := 50;
383: collect_init_opm_stg;
384:
385: -- Report success to OPI_DBI_RUN_LOG_CURR.
386: l_stmt_id := 60;
387: IF (NOT (opi_dbi_common_mod_incr_pkg.etl_report_success
388: (WIP_COMPLETION_ETL, OPM_SOURCE))) THEN
389: RAISE could_not_log_success;

Line 601: -- Report success to OPI_DBI_RUN_LOG_CURR.

597: -- Sum up WIP Completions, join in other needed tables
598: l_stmt_id := 50;
599: collect_incr_opm_stg;
600:
601: -- Report success to OPI_DBI_RUN_LOG_CURR.
602: l_stmt_id := 60;
603: IF (NOT (opi_dbi_common_mod_incr_pkg.etl_report_success
604: (WIP_COMPLETION_ETL, OPM_SOURCE))) THEN
605: RAISE could_not_log_success;

Line 610: update opi_dbi_run_log_curr -- state = successful

606: END IF;
607:
608: -- Added 11/13/03 by CDALY
609: -- set stop_reason_code in log to NULL to indicate to capture_opm_tst_prior that prior table is no longer needed
610: update opi_dbi_run_log_curr -- state = successful
611: set
612: stop_reason_code = NULL, -- flag to indicate prior tst table has been populated
613: last_update_date = sysdate,
614: last_updated_by = s_user_id,