1 PACKAGE PV_Partner_Geo_Match_PVT AUTHID CURRENT_USER AS
2 /* $Header: pvxvpgms.pls 115.1 2003/10/03 23:01:59 ktsao ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_Partner_Geo_Match_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- ===============================================================
14
15 -- Default number of records fetch per call
16 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
17 --===================================================================
18
19 -- ==============================================================================
20 -- Start of Comments
21 -- ==============================================================================
22 -- API Name
23 -- Get_Matched_Geo_Hierarchy_Id
24 -- Type
25 -- Private
26 -- Pre-Req
27 --
28 -- Parameters
29 --
30 -- IN
31 -- p_api_version_number IN NUMBER Required
32 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
33 --
34 -- OUT
35 -- x_return_status OUT VARCHAR2
36 -- x_msg_count OUT NUMBER
37 -- x_msg_data OUT VARCHAR2
38 -- Version : Current version 1.0
39 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
40 -- and basic operation, developer must manually add parameters and business logic as necessary.
41 --
42 -- End of Comments
43 -- ==============================================================================
44 --
45 PROCEDURE Get_Matched_Geo_Hierarchy_Id(
46 p_api_version_number IN NUMBER
47 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
48
49 ,x_return_status OUT NOCOPY VARCHAR2
50 ,x_msg_count OUT NOCOPY NUMBER
51 ,x_msg_data OUT NOCOPY VARCHAR2
52
53 ,p_partner_party_id IN NUMBER
54 ,p_geo_hierarchy_id IN JTF_NUMBER_TABLE
55 ,x_geo_hierarchy_id OUT NOCOPY NUMBER
56 );
57
58 PROCEDURE Get_Ptnr_Matched_Geo_Id (
59 p_api_version_number IN NUMBER
60 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
61
62 ,x_return_status OUT NOCOPY VARCHAR2
63 ,x_msg_count OUT NOCOPY NUMBER
64 ,x_msg_data OUT NOCOPY VARCHAR2
65
66 ,p_partner_id IN NUMBER
67 ,p_geo_hierarchy_id IN JTF_NUMBER_TABLE
68 ,x_geo_hierarchy_id OUT NOCOPY NUMBER
69 );
70
71 PROCEDURE Get_Ptnr_Org_Matched_Geo_Id (
72 p_api_version_number IN NUMBER
73 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
74
75 ,x_return_status OUT NOCOPY VARCHAR2
76 ,x_msg_count OUT NOCOPY NUMBER
77 ,x_msg_data OUT NOCOPY VARCHAR2
78
79 ,p_party_id IN NUMBER
80 ,p_geo_hierarchy_id IN JTF_NUMBER_TABLE
81 ,x_geo_hierarchy_id OUT NOCOPY NUMBER
82 );
83
84 END PV_Partner_Geo_Match_PVT;