APPS.OPI_DBI_WMS_RTP_F_C dependencies on OPI_DBI_WMS_RTP_F

Line 1: PACKAGE BODY OPI_DBI_WMS_RTP_F_C AS

1: PACKAGE BODY OPI_DBI_WMS_RTP_F_C AS
2: /* $Header: OPIDEWMSRTPB.pls 120.0 2005/05/24 17:14:27 appldev noship $ */
3: g_init boolean := false;
4:
5: /* PUBLIC PROCEDURE */

Line 16: l_stmt := 'TRUNCATE TABLE ' || l_opi_schema || '.OPI_DBI_WMS_RTP_F';

12:
13: l_stmt VARCHAR2(4000);
14: BEGIN
15: IF (FND_INSTALLATION.GET_APP_INFO('OPI', l_status, l_industry, l_opi_schema)) THEN
16: l_stmt := 'TRUNCATE TABLE ' || l_opi_schema || '.OPI_DBI_WMS_RTP_F';
17: EXECUTE IMMEDIATE l_stmt;
18: g_init := true;
19: populate_rtp_fact (errbuf, retcode);
20: END IF;

Line 228: INSERT /*+ APPEND PARALLEL(t) */ INTO opi_dbi_wms_rtp_f t (

224:
225: IF (g_init) THEN
226:
227: bis_collection_utilities.log('Initial Load - populate base fact. '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
228: INSERT /*+ APPEND PARALLEL(t) */ INTO opi_dbi_wms_rtp_f t (
229: task_id,
230: transaction_id,
231: organization_id,
232: subinventory_code,

Line 318: merge INTO opi_dbi_wms_rtp_f T

314: and (wdth.last_update_date is null or wdth.last_update_date <= d_end_date) );
315: COMMIT;
316: else
317: /*incremental branch*/
318: merge INTO opi_dbi_wms_rtp_f T
319: using (
320: select /*+ leading(wdth) */
321: wdth.task_id,
322: wdth.transaction_id,

Line 451: END OPI_DBI_WMS_RTP_F_C;

447: RAISE;
448: END populate_rtp_fact;
449:
450:
451: END OPI_DBI_WMS_RTP_F_C;