APPS.OPI_DBI_WMS_WAA_PKG dependencies on OPI_DBI_CONC_PROG_RUN_LOG

Line 35: FROM opi_dbi_conc_prog_run_log

31: WHERE transaction_temp_id IS NOT NULL;
32: --
33: CURSOR c_wms_gsd IS
34: SELECT last_run_date
35: FROM opi_dbi_conc_prog_run_log
36: WHERE etl_type = 'WMS_WAA_GSD';
37: --
38: l_stmt_num NUMBER;
39: x_gsd DATE;

Line 70: UPDATE opi_dbi_conc_prog_run_log log

66: RAISE no_data_available;
67: ELSE
68: IF l_wms_gsd_available THEN
69: l_stmt_num := 40;
70: UPDATE opi_dbi_conc_prog_run_log log
71: SET log.last_run_date = x_gsd
72: ,log.last_update_date = sysdate
73: ,log.last_updated_by = g_user_id
74: ,log.last_update_login = g_login_id

Line 78: INSERT INTO opi_dbi_conc_prog_run_log log

74: ,log.last_update_login = g_login_id
75: WHERE log.etl_type = 'WMS_WAA_GSD';
76: l_stmt_num := 50;
77: ELSE
78: INSERT INTO opi_dbi_conc_prog_run_log log
79: (log.etl_type
80: ,log.last_run_date
81: ,log.created_by
82: ,log.creation_date

Line 145: INSERT INTO opi_dbi_conc_prog_run_log

141: --Initialize Local Variables
142: l_procedure := 'SET_LAST_RUN_DATE';
143: --
144: l_stmt_num := 10;
145: INSERT INTO opi_dbi_conc_prog_run_log
146: (etl_type
147: ,last_run_date
148: ,created_by
149: ,creation_date

Line 201: UPDATE opi_dbi_conc_prog_run_log

197: l_procedure := 'RESET_LAST_RUN_DATE';
198: --
199: l_stmt_num := 10;
200: --
201: UPDATE opi_dbi_conc_prog_run_log
202: SET last_run_date = g_last_run_date
203: ,last_update_date = SYSDATE
204: ,last_updated_by = g_user_id
205: ,last_update_login = g_login_id

Line 356: DELETE FROM opi_dbi_conc_prog_run_log

352: ,oracle_schema => l_schema) THEN
353: l_stmt_num := 20;
354: --Delete the Last Run Date from Log Table
355: BEGIN
356: DELETE FROM opi_dbi_conc_prog_run_log
357: WHERE ETL_TYPE = 'WMS_WAA';
358: END;
359: --Truncate Staging Tables
360: l_stmt_num := 30;

Line 614: FROM opi_dbi_conc_prog_run_log

610: PROCEDURE check_last_run_date(errbuf IN OUT NOCOPY VARCHAR2
611: ,retcode IN OUT NOCOPY VARCHAR2) IS
612: CURSOR c_last_run_date IS
613: SELECT last_run_date
614: FROM opi_dbi_conc_prog_run_log
615: WHERE etl_type = 'WMS_WAA';
616: --
617: l_stmt_num NUMBER;
618: l_last_run_date DATE;

Line 1237: ,opi_dbi_conc_prog_run_log log

1233: ,wdth.transaction_temp_id transaction_temp_id
1234: from wms_dispatched_tasks_history wdth
1235: ,mtl_system_items_b msi
1236: ,mtl_secondary_inventories sinv
1237: ,opi_dbi_conc_prog_run_log log
1238: where wdth.inventory_item_id = msi.inventory_item_id
1239: AND wdth.organization_id = msi.organization_id
1240: AND decode(wdth.task_type
1241: ,1,source_subinventory_code

Line 1312: ,opi_dbi_conc_prog_run_log log

1308: ,wopih.plan_execution_end_date plan_execution_end_date
1309: ,( wopih.plan_execution_end_date
1310: - wopih.plan_execution_start_date)*24 plan_elapsed_time
1311: FROM wms_dispatched_tasks_history wdth
1312: ,opi_dbi_conc_prog_run_log log
1313: ,wms_op_plan_instances_hist wopih
1314: ,wms_op_plans_b wop
1315: ,mtl_system_items_b msi
1316: ,mtl_secondary_inventories sinv