[Home] [Help]
PACKAGE: APPS.JTY_TERR_SPARES_PVT
Source
1 PACKAGE JTY_TERR_SPARES_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtftsprmgs.pls 120.2 2010/09/21 11:04:15 sseshaiy noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30):='JTY_ASSIGN_REALTIME_PUB';
5
6 -- Start of Comments
7 -- ---------------------------------------------------
8 -- PACKAGE NAME: JTY_TERR_SPARES_PVT
9 -- PURPOSE : Creation of seeded data and wrapper procedure for Spares use
10 --
11 -- Procedures:
12 -- (see below for specification)
13 --
14 --
15 -- NOTES
16 --
17 --
18 --
19 -- HISTORY
20 -- 03/03/2010 RAJUKUM CREATED
21 --
22 --
23 -- End of Comments
24 --
25
26
27 Procedure run_r12_seeded_terr_for_spares;
28
29 -- ***************************************************
30 -- API Specifications
31 -- ***************************************************
32 -- api name : Process_match_terr_spares
33 -- type : public.
34 -- function : Called by spares APIs
35 -- pre-reqs : Territories needs to be setup first
36 -- notes :
37 --
38 PROCEDURE process_match_terr_spares
39 ( p_api_version_number IN number,
40 p_init_msg_list IN varchar2 := fnd_api.g_false,
41 p_TerrServReq_Rec IN JTF_TERRITORY_PUB.JTF_Serv_Req_rec_type,
42 p_Resource_Type IN varchar2,
43 p_Role IN varchar2,
44 p_plan_start_date IN DATE DEFAULT NULL,
45 p_plan_end_date IN DATE DEFAULT NULL,
46 x_return_status OUT NOCOPY varchar2,
47 x_msg_count OUT NOCOPY number,
48 X_msg_data OUT NOCOPY varchar2
49 );
50
51
52 END JTY_TERR_SPARES_PVT;