1 PACKAGE OKL_VP_JTF_PARTY_NAME_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPCTSS.pls 120.1 2005/09/08 12:48:41 sjalasut noship $ */
3 SUBTYPE party_tab_type IS OKL_VP_JTF_PARTY_NAME_PVT.party_tab_type;
4
5 --Start of Comments
6 --API Name : Get_Party
7 --Description : Fetches all parties attahced to a contract or line in a table
8 --End of Comments
9 PROCEDURE Get_Party (p_api_version IN NUMBER,
10 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
11 x_return_status OUT NOCOPY VARCHAR2,
12 x_msg_count OUT NOCOPY NUMBER,
13 x_msg_data OUT NOCOPY VARCHAR2,
14 p_chr_id IN VARCHAR2,
15 p_cle_id IN VARCHAR2,
16 p_role_code IN OKC_K_PARTY_ROLES_V.rle_code%TYPE,
17 p_intent IN VARCHAR2 DEFAULT 'S',
18 x_party_tab OUT NOCOPY party_tab_type);
19 --Start of Comments
20 --Procedure : Get_Party
21 --Description : Fetches Name, Description of a Party role for a given
22 -- object1_id1 and object2_id2
23 --End of comments
24 PROCEDURE Get_Party (p_api_version IN NUMBER,
25 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_count OUT NOCOPY NUMBER,
28 x_msg_data OUT NOCOPY VARCHAR2,
29 p_role_code IN VARCHAR2,
30 p_intent IN VARCHAR2,
31 p_id1 IN VARCHAR2,
32 p_id2 IN VARCHAR2,
33 x_id1 OUT NOCOPY VARCHAR2,
34 x_id2 OUT NOCOPY VARCHAR2,
35 x_name OUT NOCOPY VARCHAR2,
36 x_description OUT NOCOPY VARCHAR2);
37
38 PROCEDURE get_Contact (p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2,
43 p_rle_code IN VARCHAR2,
44 p_cro_code IN VARCHAR2,
45 p_intent IN VARCHAR2,
46 p_id1 IN VARCHAR2,
47 p_id2 IN VARCHAR2,
48 x_id1 OUT NOCOPY VARCHAR2,
49 x_id2 OUT NOCOPY VARCHAR2,
50 x_name OUT NOCOPY VARCHAR2,
51 x_description OUT NOCOPY VARCHAR2);
52
53 FUNCTION get_party_name (p_role_code IN VARCHAR2
54 ,p_intent IN VARCHAR2
55 ,p_id1 IN VARCHAR2
56 ,p_id2 IN VARCHAR2) RETURN VARCHAR2;
57
58 FUNCTION get_party_contact_name (p_rle_code IN VARCHAR2
59 ,p_cro_code IN VARCHAR2
60 ,p_intent IN VARCHAR2
61 ,p_id1 IN VARCHAR2
62 ,p_id2 IN VARCHAR2) RETURN VARCHAR2;
63
64 PROCEDURE get_party_lov_sql (p_role_code IN VARCHAR2
65 ,p_intent IN VARCHAR2
66 ,x_jtot_object_code OUT NOCOPY VARCHAR2
67 ,x_lov_sql OUT NOCOPY VARCHAR2);
68
69 PROCEDURE get_party_contact_lov_sql (p_rle_code IN VARCHAR2
70 ,p_cro_code IN VARCHAR2
71 ,p_intent IN VARCHAR2
72 ,x_jtot_object_code OUT NOCOPY VARCHAR2
73 ,x_lov_sql OUT NOCOPY VARCHAR2);
74
75 END; -- Package Specification OKL_VP_JTF_PARTY_NAME_PUB