1 Package JTF_TERR_TASK_PUB AUTHID CURRENT_USER AS
2 /* $Header: jtfpttss.pls 120.0 2005/06/02 18:21:02 appldev ship $ */
3
4 ---------------------------------------------------------------------
5 -- Start of Comments
6 -- ---------------------------------------------------
7 -- PACKAGE NAME: JTF_TERR_TASK_PUB
8 -- ---------------------------------------------------
9 -- PURPOSE
10 -- Joint task force core Sales territory manager public api's.
11 -- This package is a public API for getting winning territories
12 -- or territory resources.
13 --
14 -- Procedures:
15 -- (see below for specification)
16 --
17 -- NOTES
18 -- This package is publicly available for use
19 --
20 -- HISTORY
21 -- 11/14/99 VNEDUNGA Created
22 -- 05/07/01 EIHSU GetWinningTerritories removed
23 --
24 -- End of Comments
25 --
26 -- ***************************************************
27 -- GLOBAL VARIABLES
28 -- ***************************************************
29
30 -- ***************************************************
31 -- start of comments
32 -- ***************************************************
33 -- api name : Get_WinningTerrMembers
34 -- type : public.
35 -- function : Get winning territories members for an TASK
36 -- pre-reqs : Territories needs to be setup first
37 -- parameters :
38 --
39 -- IN:
40 -- p_api_version_number IN number required
41 -- p_init_msg_list IN varchar2 optional --default = fnd_api.g_false
42 -- p_commit IN varchar2 optional --default = fnd_api.g_false
43 -- p_Org_Id IN number required
44 -- p_TerrTask_Rec IN JTF_ServiceReqst_rec_type
45 -- p_Resource_Type IN varchar2
46 -- p_Role IN varchar2
47 --
48 -- out:
49 -- x_return_status out varchar2(1)
50 -- x_msg_count out number
51 -- x_msg_data out varchar2(2000)
52 -- x_TerrRes_tbl out TerrRes_tbl_type
53 --
54 -- requirements :
55 -- business rules :
56
57 -- version : current version 1.0
58 -- initial version: initial version 1.0
59 --
60 -- notes: Public API for retreving a set of winning
61 -- territories resources. This is an overloaded
62 -- procedure for accounts,lead, oppor, service
63 -- requests, and collections.
64 --
65 -- end of comments
66 procedure Get_WinningTerrMembers
67 ( p_api_version_number IN number,
68 p_init_msg_list IN varchar2 := fnd_api.g_false,
69 p_TerrTask_Rec IN JTF_TERRITORY_PUB.JTF_Task_rec_type,
70 p_Resource_Type IN varchar2,
71 p_Role IN varchar2,
72 x_return_status OUT NOCOPY varchar2,
73 x_msg_count OUT NOCOPY number,
74 X_msg_data OUT NOCOPY varchar2,
75 x_TerrResource_tbl OUT NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type
76 );
77
78 END JTF_TERR_TASK_PUB;