PACKAGE: APPS.ASO_BI_LINE_FACT_PVT

Source

1 PACKAGE  ASO_BI_LINE_FACT_PVT AUTHID CURRENT_USER AS
2  /* $Header: asovbiqlins.pls 120.0 2005/05/31 01:26:06 appldev noship $ */
3 
4   -- This deletes quote lines that have got updated in date range
5   -- This is done to remove quote lines that belonged to older versions
6   -- of the quote
7   PROCEDURE Cleanup_Line_Data;
8 
9   -- Inserts Records into ASO_BI_QUOTE_LINES_ALL reading from
10   -- ASO_BI_QUOTE_LINES_STG table
11   PROCEDURE Populate_Line_Data;
12 
13   -- Inserts the quote lines id into ASO_BI_LINE_IDS table
14   -- corresponding the quotes that got changed in the given window
15   -- of dates
16   PROCEDURE initLoad_Quote_Line_ids;
17 
18   -- Inserts the updated quote line ids into ASO_BI_LINE_IDS table
19   PROCEDURE Populate_Quote_Line_Ids;
20 
21   -- Inserts records into ASO_BI_QUOTE_FACT_JOBS as many as the batches
22   PROCEDURE Register_Line_Jobs;
23 
24   -- Inserts records into ASO_BI_QUOTE_LINES_STG for all Quotes in the
25   -- ASO_BI_LINE_IDS table for Initial Load
26   Procedure InitiLoad_QotLineStg;
27 
28   -- This procedure is called as a part of incremental load of quote lines.
29   -- Populates ASO_BI_QUOTE_LINES_STG table
30   Procedure Line_Worker(
31    Errbuf   IN OUT NOCOPY VARCHAR2,
32    Retcode  IN OUT NOCOPY NUMBER,
33    p_worker_no IN NUMBER) ;
34 
35   -- Initial Load of ASO_BI_QUOTE_LINES_ALL
36   -- Called as a part of initial load of quote lines
37   Procedure InitiLoad_QotLine;
38 
39 END  ASO_BI_LINE_FACT_PVT ;