[Home] [Help]
PACKAGE: APPS.OKC_OPPORTUNITY_PVT
Source
1 PACKAGE OKC_OPPORTUNITY_PVT AS
2 /* $Header: OKCROPPS.pls 120.0 2005/05/25 19:46:58 appldev noship $ */
3
4 -- GLOBAL VARIABLES
5 ---------------------------------------------------------------------------
6 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
7 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
8 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
9 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
10 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_OPPORTUNITY_PVT';
11 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
12 ---------------------------------------------------------------------------
13
14 PROCEDURE CREATE_OPPORTUNITY(p_api_version IN NUMBER DEFAULT 1.0,
15 p_context IN VARCHAR2,
16 p_contract_id IN NUMBER,
17 p_win_probability IN NUMBER,
18 p_expected_close_days IN NUMBER,
19 x_lead_id OUT NOCOPY NUMBER,
20 p_init_msg_list IN VARCHAR2,
21 x_msg_data OUT NOCOPY VARCHAR2,
22 x_msg_count OUT NOCOPY NUMBER,
23 x_return_status OUT NOCOPY VARCHAR2);
24
25 PROCEDURE CREATE_OPP_HEADER(p_api_version IN NUMBER DEFAULT 1.0,
26 p_context IN VARCHAR2,
27 p_contract_id IN NUMBER,
28 p_win_probability IN NUMBER,
29 p_expected_close_days IN NUMBER,
30 x_lead_id OUT NOCOPY NUMBER,
31 p_init_msg_list IN VARCHAR2,
32 x_msg_data OUT NOCOPY VARCHAR2,
33 x_msg_count OUT NOCOPY NUMBER,
34 x_return_status OUT NOCOPY VARCHAR2);
35
36 PROCEDURE CREATE_OPP_LINES(p_api_version IN NUMBER DEFAULT 1.0,
37 p_context IN VARCHAR2,
38 p_contract_id IN NUMBER,
39 p_lead_id IN NUMBER,
40 p_init_msg_list IN VARCHAR2,
41 x_msg_data OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_return_status OUT NOCOPY VARCHAR2);
44
45 PROCEDURE IS_OPP_CREATION_ALLOWED(p_context IN VARCHAR2,
46 p_contract_id IN NUMBER,
47 x_return_status OUT NOCOPY VARCHAR2);
48
49 PROCEDURE GET_OPP_DEFAULTS(p_context IN VARCHAR2,
50 p_contract_id IN NUMBER,
51 x_win_probability IN OUT NOCOPY NUMBER,
52 x_closing_date_days IN OUT NOCOPY NUMBER,
53 x_return_status OUT NOCOPY VARCHAR2);
54 END OKC_OPPORTUNITY_PVT;