PACKAGE: APPS.OZF_PARTY_MKT_SEG_LOADER_PVT

Source

1 PACKAGE OZF_Party_Mkt_Seg_Loader_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvldrs.pls 120.0 2005/06/01 00:56:54 appldev noship $ */
3 
4 
5 
6 /*****************************************************************************/
7 -- Define a PL sql table to hold the Discoverer SQL Query
8 -- Added by ptendulk on May03/2000
9 
10 TYPE sql_rec_type IS TABLE OF VARCHAR2(2000)
11 INDEX BY BINARY_INTEGER;
12 
13 /******************************************************************************/
14 --PL\SQL table to hold the Partyids returned by execution for dbms_sql
15 /******************************************************************************/
16 
17 TYPE t_party_tab is TABLE OF NUMBER
18 INDEX BY BINARY_INTEGER;
19 
20 
21 -- Start of Comments
22 
23 /*****************************************************************************
24  * NAME
25  *   LOAD_PARTIES_FOR_MARKET_QUALIFIERS
26  *
27  * PURPOSE
28  *   This procedure is a concurrent program to
29  *     generate party list that matches a given territory's qualifiers and buying group
30  *
31  * NOTES
32  *
33  * HISTORY
34  *   10/04/2001      yzhao    created
35 */
36 
37 PROCEDURE LOAD_PARTY_MARKET_QUALIFIER
38                         (errbuf        OUT NOCOPY    VARCHAR2,
39                          retcode       OUT NOCOPY    NUMBER,
40                          /* yzhao 07/17/2002 fix bug 2410322 - UPG1157:9I:OZF PACKAGE/PACKAGE BODY MISMATCHES
41                          p_terr_id     IN     NUMBER,
42                          p_bg_id       IN     NUMBER);
43                          */
44                          p_terr_id     IN     NUMBER      := NULL,
45                          p_bg_id       IN     NUMBER      := NULL);
46 
47 
48 END OZF_Party_Mkt_Seg_Loader_PVT;