1 Package JTF_TERR_OKS_PUB AUTHID CURRENT_USER AS
2 /* $Header: jtfptscs.pls 120.0 2005/06/02 18:20:58 appldev ship $ */
3 ---------------------------------------------------------
4 -- Start of Comments
5 -- ---------------------------------------------------
6 -- PACKAGE NAME: JTF_TERR_OKS_PUB
7 -- ---------------------------------------------------
8 -- PURPOSE
9 -- Joint task force core Oracle Service Contracts 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 -- 09/19/00 EIHSU Created
21 -- 05/04/01 JDOCHERT Removed GetWinningTerritories API
22 --
23 -- End of Comments
24 --
25 -- ***************************************************
26 -- GLOBAL VARIABLES
27 -- ***************************************************
28 --
29
30 -- ***************************************************
31 -- start of comments
32 -- ***************************************************
33 -- api name : Get_WinningTerrMembers
34 -- type : public.
35 -- function : Get winning territories members for a Contract Renewal
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_TerrAccount_Rec IN JTF_TERRITORY_PUB.JTF_Account_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_TerrKRen_Rec IN JTF_TERRITORY_PUB.JTF_KRen_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
79 --
80 END JTF_TERR_OKS_PUB;
[Home] [Help]