[Home] [Help]
PACKAGE: APPS.OKC_OPPORTUNITY_PUB
Source
1 PACKAGE OKC_OPPORTUNITY_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKCPOPPS.pls 120.0 2005/05/25 19:21:06 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_PUB';
11 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
12 ---------------------------------------------------------------------------
13
14 /****************
15 PROCEDURE CREATE_OPPORTUNITY(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 x_return_status OUT NOCOPY VARCHAR2);
21 *************************/
22
23 PROCEDURE CREATE_OPPORTUNITY(p_api_version IN NUMBER DEFAULT 1.0,
24 p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
25 p_context IN VARCHAR2,
26 p_contract_id IN NUMBER,
27 p_win_probability IN NUMBER,
28 p_expected_close_days IN NUMBER,
29 -- x_lead_id OUT NOCOPY NUMBER,
30 p_init_msg_list IN VARCHAR2,
31 x_msg_data OUT NOCOPY VARCHAR2,
32 x_msg_count OUT NOCOPY NUMBER,
33 x_return_status OUT NOCOPY VARCHAR2);
34
35
36 PROCEDURE CREATE_OPPORTUNITY(p_api_version IN NUMBER DEFAULT 1.0,
37 p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
38 p_context IN VARCHAR2,
39 p_contract_id IN NUMBER,
40 p_win_probability IN NUMBER,
41 p_expected_close_days IN NUMBER,
42 x_lead_id OUT NOCOPY NUMBER,
43 p_init_msg_list IN VARCHAR2,
44 x_msg_data OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_return_status OUT NOCOPY VARCHAR2);
47
48
49 /*********************
50 PROCEDURE CREATE_OPP_HEADER(p_context IN VARCHAR2,
51 p_contract_id IN NUMBER,
52 p_win_probability IN NUMBER,
53 p_expected_close_days IN NUMBER,
54 x_lead_id OUT NOCOPY NUMBER,
55 x_return_status OUT NOCOPY VARCHAR2);
56 ************************/
57 PROCEDURE CREATE_OPP_HEADER(p_api_version IN NUMBER DEFAULT 1.0,
58 p_context IN VARCHAR2,
59 p_contract_id IN NUMBER,
60 p_win_probability IN NUMBER,
61 p_expected_close_days IN NUMBER,
62 x_lead_id OUT NOCOPY NUMBER,
63 p_init_msg_list IN VARCHAR2,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_return_status OUT NOCOPY VARCHAR2);
67
68
69 /*******************
70 PROCEDURE CREATE_OPP_LINES(p_context IN VARCHAR2,
71 p_contract_id IN NUMBER,
72 p_lead_id IN NUMBER,
73 x_return_status OUT NOCOPY VARCHAR2);
74 **********************/
75 PROCEDURE CREATE_OPP_LINES(p_api_version IN NUMBER DEFAULT 1.0,
76 p_context IN VARCHAR2,
77 p_contract_id IN NUMBER,
78 p_lead_id IN NUMBER,
79 p_init_msg_list IN VARCHAR2,
80 x_msg_data OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_return_status OUT NOCOPY VARCHAR2);
83
84
85 PROCEDURE IS_OPP_CREATION_ALLOWED(p_context IN VARCHAR2,
86 p_contract_id IN NUMBER,
87 x_return_status OUT NOCOPY VARCHAR2);
88
89 PROCEDURE GET_OPP_DEFAULTS(p_context IN VARCHAR2,
90 p_contract_id IN NUMBER,
91 x_win_probability IN OUT NOCOPY NUMBER,
92 x_closing_date_days IN OUT NOCOPY NUMBER,
93 x_return_status OUT NOCOPY VARCHAR2);
94 END OKC_OPPORTUNITY_PUB;