1 PACKAGE ASO_BI_QUOTE_FACT_PVT AUTHID CURRENT_USER AS
2 /* $Header: asovbiqhds.pls 120.0 2005/05/31 01:25:53 appldev noship $ */
3
4
5 --This procedure is used for extracting the New Quote Ids for
6 --initial Load.
7 PROCEDURE InitLoad_Quote_Ids (
8 p_from_date IN Date,
9 p_to_date IN Date);
10
11
12 --This procedure is used for extracting the New Quote Ids for
13 --incremental Load.
14 PROCEDURE Populate_Quote_Ids(
15 p_from_date IN DATE,
16 p_to_date IN DATE) ;
17
18 --This procedure is used to register jobs for the subworkers
19 --in case of incremental load.
20 PROCEDURE Register_Jobs;
21
22 --This procedure populates the base fact table for Quote Headers
23 --in initial load.
24 Procedure InitiLoad_QotHdr ;
25
26 --This procedure populates the base fact table for Quote Headers
27 --in incremental load.
28 PROCEDURE Populate_Data;
29
30 --The subworker program called for incremental load.
31 Procedure Worker(
32 Errbuf IN OUT NOCOPY VARCHAR2,
33 Retcode IN OUT NOCOPY NUMBER,
34 p_worker_no IN NUMBER) ;
35
36 END ASO_BI_QUOTE_FACT_PVT ;