1 PACKAGE PV_Partner_Contracts_PVT AUTHID CURRENT_USER AS
2 /* $Header: pvxvpcos.pls 120.1 2005/08/19 13:34:37 appldev ship $ */
3
4 -- ===============================================================
5 -- Start of Comments
6 -- Package name
7 -- PV_Partner_Contracts_PVT
8 -- Purpose
9 --
10 -- History
11 -- 01-APR-2004 Karen.Tsao Fixed for bug 3540615. Added API Is_Contract_Exists.
12 -- 09-DEC-2004 Karen.Tsao Modified for 11.5.11.
13 -- 02-MAY-2004 Karen.Tsao Took out Is_Contract_Exists() because it is not used.
14 --
15 -- NOTE
16 --
17 -- ===============================================================
18 -- Default number of records fetch per call
19 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
20 --===================================================================
21
22 -- ==============================================================================
23 -- Start of Comments
24 -- ==============================================================================
25 -- API Name
26 -- Get_Appropriate_Contract
27 -- Type
28 -- Private
29 -- Pre-Req
30 --
31 -- Parameters
32 --
33 -- IN
34 -- p_partner_party_id IN NUMBER
35 -- p_program_id IN NUMBER
36 --
37 -- OUT
38 -- x_contract_id OUT NUMBER
39 -- Version : Current version 1.0
40 --
41 -- End of Comments
42 -- ==============================================================================
43 --
44 function get_contract_response_options( p_geo_hierarchy_id in varchar2 )
45 return varchar2;
46
47 PROCEDURE Is_Contract_Exist_Then_Create(
48 p_api_version_number IN NUMBER
49 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
50
51 ,x_return_status OUT NOCOPY VARCHAR2
52 ,x_msg_count OUT NOCOPY NUMBER
53 ,x_msg_data OUT NOCOPY VARCHAR2
54
55 ,p_program_id IN NUMBER
56 ,p_partner_id IN NUMBER
57 ,p_enrl_request_id IN NUMBER
58
59 ,x_exist OUT NOCOPY VARCHAR2
60 );
61
62 PROCEDURE Get_Contract_Response_Options(
63 p_partner_party_id IN NUMBER
64 ,x_cntr_resp_opt_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_200
65 );
66
67 END PV_Partner_Contracts_PVT;