1 Package JTF_TERR_SERVICE_PUB AUTHID CURRENT_USER AS
2 /* $Header: jtfptsvs.pls 120.2 2008/12/11 07:31:35 vpalle ship $ */
3 ---------------------------------------------------------
4 -- Start of Comments
5 -- ---------------------------------------------------
6 -- PACKAGE NAME: JTF_TERR_SERVICE_PUB
7 -- ---------------------------------------------------
8 -- PURPOSE
9 -- Joint task force core Sales territory manager public api's.
10 -- This package is a public API for getting winning territories
11 -- or territory resources.
12 --
13 -- Procedures:
14 -- (see below for specification)
15 --
16 -- NOTES
17 -- This package is publicly available for use
18 --
19 -- HISTORY
20 -- 11/14/99 VNEDUNGA Created
21 -- 12/22/99 VNEDUNGA Making changes to confirm to
22 -- new assignement manager requirement
23 -- 05/08/01 arpatel taken out Get_WinningTerritories for service requests.
24 -- 05/08/01 arpatel taken out Get_WinningTerritories for service requests/tasks.
25 --
26 -- End of Comments
27 --
28 -- ***************************************************
29 -- GLOBAL VARIABLES
30 -- ***************************************************
31 -- ***************************************************
32 -- start of comments
33 -- ***************************************************
34 -- api name : Get_WinningTerrMembers
35 -- type : public.
36 -- function : Get winning territories members for an SERVICE REQUEST
37 -- pre-reqs : Territories needs to be setup first
38 -- parameters :
39 --
40 -- IN:
41 -- p_api_version_number IN number required
42 -- p_init_msg_list IN varchar2 optional --default = fnd_api.g_false
43 -- p_commit IN varchar2 optional --default = fnd_api.g_false
44 -- p_Org_Id IN number required
45 -- p_TerrServReq_Rec IN JTF_TERRITORY_PUB.JTF_Service_Request_rec_type
46 -- p_Resource_Type IN varchar2
47 -- p_Role IN varchar2
48 -- p_plan_start_date IN DATE DEFAULT NULL
49 -- p_plan_end_date IN DATE DEFAULT NULL
50 --
51 -- out:
52 -- x_return_status out varchar2(1)
53 -- x_msg_count out number
54 -- x_msg_data out varchar2(2000)
55 -- x_TerrRes_tbl out TerrRes_tbl_type
56 --
57 -- requirements :
58 -- business rules :
59
60 -- version : current version 1.0
61 -- initial version: initial version 1.0
62 --
63 -- notes: Public API for retreving a set of winning
64 -- territories resources.
65 --
66 -- end of comments
67 procedure Get_WinningTerrMembers
68 ( p_api_version_number IN number,
69 p_init_msg_list IN varchar2 := fnd_api.g_false,
70 p_TerrServReq_Rec IN JTF_TERRITORY_PUB.JTF_Serv_Req_rec_type,
71 p_Resource_Type IN varchar2,
72 p_Role IN varchar2,
73 p_plan_start_date IN DATE DEFAULT NULL,
74 p_plan_end_date IN DATE DEFAULT NULL,
75 x_return_status OUT NOCOPY varchar2,
76 x_msg_count OUT NOCOPY number,
77 X_msg_data OUT NOCOPY varchar2,
78 x_TerrResource_tbl OUT NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type
79 );
80
81 -- ***************************************************
82 -- start of comments
83 -- ***************************************************
84 -- api name : Get_WinningTerrMembers
85 -- type : public.
86 -- function : Get winning territories members for
87 -- Service request/task combination
88 -- pre-reqs : Territories needs to be setup first
89 -- parameters :
90 --
91 -- IN:
92 -- p_api_version_number IN number required
93 -- p_init_msg_list IN varchar2 optional --default = fnd_api.g_false
94 -- p_commit IN varchar2 optional --default = fnd_api.g_false
95 -- p_Org_Id IN number required
96 -- p_TerrSrvTask_Rec IN JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type
97 -- p_Resource_Type IN varchar2
98 -- p_Role IN varchar2
99 -- p_plan_start_date IN DATE DEFAULT NULL
100 -- p_plan_end_date IN DATE DEFAULT NULL
101 --
102 -- out:
103 -- x_return_status OUT NOCOPY varchar2(1)
104 -- x_msg_count OUT NOCOPY number
105 -- x_msg_data OUT NOCOPY varchar2(2000)
106 -- x_TerrRes_tbl OUT NOCOPY TerrRes_tbl_type
107 --
108 -- requirements :
109 -- business rules :
110
111 -- version : current version 1.0
112 -- initial version: initial version 1.0
113 --
114 -- notes: Public API for retreving a set of winning
115 -- territories resources.
116 --
117 -- end of comments
118 procedure Get_WinningTerrMembers
119 ( p_api_version_number IN number,
120 p_init_msg_list IN varchar2 := fnd_api.g_false,
121 p_TerrSrvTask_Rec IN JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type,
122 p_Resource_Type IN varchar2,
123 p_Role IN varchar2,
124 p_plan_start_date IN DATE DEFAULT NULL,
125 p_plan_end_date IN DATE DEFAULT NULL,
126 x_return_status OUT NOCOPY varchar2,
127 x_msg_count OUT NOCOPY number,
128 X_msg_data OUT NOCOPY varchar2,
129 x_TerrResource_tbl OUT NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type
130 );
131
132 --
133 END JTF_TERR_SERVICE_PUB;