APPS.POA_DBI_NEG_F_C dependencies on POA_DBI_NEG_F

Line 1: PACKAGE BODY POA_DBI_NEG_F_C AS

1: PACKAGE BODY POA_DBI_NEG_F_C AS
2: /* $Header: poadbinegfrefb.pls 120.11.12000000.2 2007/02/27 14:41:15 sriswami ship $ */
3: g_init boolean := false;
4:
5: /* PUBLIC PROCEDURE */

Line 17: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_NEG_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_NEG_F';
18: EXECUTE immediate l_stmt;
19:
20: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_NEG_INC';
21: EXECUTE immediate l_stmt;

Line 314: INSERT /*+ append parallel(t) */ INTO poa_dbi_neg_f t (

310: dbms_application_info.set_action('collect');
311: IF (l_no_batch is NOT NULL) then
312: IF (g_init) THEN
313: bis_collection_utilities.log('Initial Load - using one batch approach, populate base fact. '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
314: INSERT /*+ append parallel(t) */ INTO poa_dbi_neg_f t (
315: t.auction_header_id , /* Auction Header ID */
316: t.auction_line_number, /* Auction Line Number */
317: t.bid_number, /* Awarded Bid Number */
318: t.bid_line_number, /* Awarded Bid Line Number */

Line 563: MERGE INTO poa_dbi_neg_f t using

559: bis_collection_utilities.log('incremental collection');
560: FOR v_batch_no IN 1..l_no_batch LOOP
561: bis_collection_utilities.log('batch no='||v_batch_no || ' Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 1);
562:
563: MERGE INTO poa_dbi_neg_f t using
564: ( SELECT /*+ cardinality(inc,1) */
565: ponh_multi.auction_header_id,
566: ponip.line_number auction_line_number,
567: ponbh.bid_number bid_number,

Line 1017: bis_collection_utilities.wrapup(TRUE, l_count, 'POA_DBI_NEG_F COLLECTION SUCEEDED', to_date(l_start_date, '''YYYY/MM/DD HH24:MI:SS'''), To_date(l_end_date, '''YYYY/MM/DD HH24:MI:SS'''));

1013: END LOOP;
1014: END IF;
1015: END IF;
1016: bis_collection_utilities.log('Collection complete '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
1017: bis_collection_utilities.wrapup(TRUE, l_count, 'POA_DBI_NEG_F COLLECTION SUCEEDED', to_date(l_start_date, '''YYYY/MM/DD HH24:MI:SS'''), To_date(l_end_date, '''YYYY/MM/DD HH24:MI:SS'''));
1018: g_init := false;
1019: dbms_application_info.set_module(null, null);
1020: EXCEPTION
1021: WHEN others THEN

Line 1030: END POA_DBI_NEG_F_C;

1026: 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'''));
1027: RAISE;
1028: END populate_neg_facts;
1029:
1030: END POA_DBI_NEG_F_C;