1 PACKAGE AMS_Party_Seg_Loader_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvcecs.pls 115.5 2002/11/22 02:24:32 jieli noship $ */
3
4
5 /******************************************************************************/
6 --PL\SQL table to hold the Partyids returned by execution for dbms_sql
7 /******************************************************************************/
8
9 TYPE t_party_tab is TABLE OF NUMBER
10 INDEX BY BINARY_INTEGER;
11
12 /*****************************************************************************/
13 -- Procedure
14 -- load_party_seg
15 -- Purpose
16 -- load ams_party_market_segments
17 --
18 -- Note
19 -- 1. The process will execute the ams_cells_pvt.get_comp_sql for a given
20 -- cell to get its sql and its ancestors, then excute the sql to get
21 -- the parties that belong to that sql.
22 -- 2. If cell_id is passed into, then only that cell will be refreshed or
23 -- else all the cells will be refreshed.
24 -- History
25 -- 01/26/2001 yxliu created
26 -------------------------------------------------------------------------------
27 PROCEDURE Load_Party_Seg
28 (
29 p_cell_id IN NUMBER DEFAULT NULL,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2
33 );
34
35 /*****************************************************************************/
36 -- Procedure
37 -- Refresh_Party_Segment
38 --
39 -- PURPOSE
40 -- This procedure is created to as a concurrent program which
41 -- will call the load_party_seg and will return errors if any
42 --
43 -- NOTES
44 --
45 --
46 -- HISTORY
47 -- 01/26/2001 yxliu created
48 -- End of Comments
49 -------------------------------------------------------------------------------
50
51 PROCEDURE Refresh_Party_Segment
52 (errbuf OUT NOCOPY VARCHAR2,
53 retcode OUT NOCOPY NUMBER,
54 p_cell_id IN NUMBER DEFAULT NULL);
55
56 END AMS_Party_Seg_Loader_PVT;