APPS.POA_DBI_REQ_F_C dependencies on POA_DBI_REQ_F

Line 1: PACKAGE BODY POA_DBI_REQ_F_C AS

1: PACKAGE BODY POA_DBI_REQ_F_C AS
2: /* $Header: poadbireqfrefb.pls 120.10 2006/07/24 11:34:11 sdiwakar noship $ */
3: g_init boolean := false;
4:
5: /* PUBLIC PROCEDURE */

Line 17: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_REQ_F';

13: l_industry VARCHAR2(30);
14: l_stmt VARCHAR2(4000);
15: BEGIN
16: IF (fnd_installation.get_app_info('POA', l_status, l_industry, l_poa_schema)) THEN
17: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_REQ_F';
18: EXECUTE immediate l_stmt;
19:
20: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_REQ_INC';
21: EXECUTE immediate l_stmt;

Line 678: INSERT /*+ append parallel(t) */ INTO poa_dbi_req_f t (

674: dbms_application_info.set_action('collect');
675: if (l_no_batch is NOT NULL) then
676: IF (g_init) THEN
677: bis_collection_utilities.log('Initial Load - using one batch approach, populate base fact. '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
678: INSERT /*+ append parallel(t) */ INTO poa_dbi_req_f t (
679: t.req_line_id ,
680: t.req_header_id ,
681: t.po_line_location_id ,
682: t.req_creation_ou_id,

Line 1142: MERGE INTO poa_dbi_req_f t using

1138: -- Incremental load (process in batches)
1139: bis_collection_utilities.log('incremental collection');
1140: FOR v_batch_no IN 1..l_no_batch LOOP
1141: bis_collection_utilities.log('batch no='||v_batch_no || ' Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 1);
1142: MERGE INTO poa_dbi_req_f t using
1143: (
1144: SELECT
1145: req_line_id,
1146: req_header_id,

Line 1760: END POA_DBI_REQ_F_C;

1756: bis_collection_utilities.wrapup(FALSE, l_count, errbuf||':'||retcode, to_date(l_start_date, '''YYYY/MM/DD HH24:MI:SS'''), to_date(l_end_date, '''YYYY/MM/DD HH24:MI:SS'''));
1757: RAISE;
1758: END populate_req_facts;
1759:
1760: END POA_DBI_REQ_F_C;