1 Package JTF_TERRITORY_GLOBAL_PUB AUTHID CURRENT_USER AS
2 /* $Header: jtfxstrs.pls 120.0 2005/06/02 18:23:20 appldev ship $ */
3 /*===========================================================================+
4 | Copyright (c) 1999 Oracle Corporation |
5 | Redwood Shores, California, USA |
6 | All rights reserved. |
7 +===========================================================================*/
8 -- Start of Comments
9 -- ---------------------------------------------------
10 -- PACKAGE NAME: JTF_TERRITORY_GLOBAL_PUB
11 -- ---------------------------------------------------
12 -- PURPOSE
13 -- Joint task force core territory manager public api's.
14 -- This package is used to return a list of winning Territories.
15 -- Reason to go with this approach is because of limitation in
16 -- pl/sql wrt binding user defined data types to return a list
17 -- of winning Territories
18 --
19 -- Procedures:
20 -- (see below for specification)
21 --
22 -- NOTES
23 -- This package is publicly available for use
24 --
25 -- HISTORY
26 -- 06/09/99 VNEDUNGA Created
27 -- 02/24/00 VNEDUNGA Overloading add record for the new
28 -- Terr Engine
29 -- 09/15/00 jdochert BUG#1408610 FIX
30 -- 09/15/00 jdochert Removed obsolete overloaded Add_Record procedure
31 -- that had 2 parameters
32 --
33 -- End of Comments
34 --
35 --*******************************************************
36 -- Start of Comments
37 --*******************************************************
38 -- Store the winning territory records
39 G_WinningTerr_Tbl JTF_TERRITORY_PUB.WinningTerr_Tbl_type;
40
41 -- Current table location pointer
42 g_TblIndex NUMBER := 1;
43
44 /* JDOCHERT 09/15: BUG#1408610 FIX */
45 g_num_winners NUMBER := 0;
46
47
48 /* JDOCHERT 11/10 */
49 g_party_id NUMBER;
50 g_party_site_id NUMBER;
51
52 -- Resets the table
53 FUNCTION reset return BOOLEAN;
54
55
56 FUNCTION get_RecordCount return NUMBER;
57
58 /* Add record to the global table */
59 PROCEDURE Add_Record( p_WinningTerr_Rec IN JTF_TERRITORY_PUB.WinningTerr_rec_type,
60 p_Number_Of_Winners IN NUMBER,
61 X_Return_Status OUT NOCOPY VARCHAR2);
62
63 END JTF_TERRITORY_GLOBAL_PUB;