[Home] [Help]
PACKAGE: APPS.PA_PROJ_OPP_ATTRS_PKG
Source
1 PACKAGE PA_PROJ_OPP_ATTRS_PKG AUTHID CURRENT_USER as
2 /* $Header: PAYOPKGS.pls 120.1 2005/08/19 17:23:43 mwasowic noship $ */
3
4 --
5 -- Procedure : Insert_row
6 -- Purpose : Create a Row in PA_PROJECT_OPP_ATTRS.
7 --
8 --
9 PROCEDURE insert_row
10 ( p_project_id IN NUMBER,
11 p_opportunity_value IN NUMBER,
12 p_opp_value_currency_code IN VARCHAR2,
13 p_projfunc_opp_value IN NUMBER,
14 p_projfunc_opp_rate_type IN VARCHAR2,
15 p_projfunc_opp_rate_date IN DATE,
16 p_project_opp_value IN NUMBER,
17 p_project_opp_rate_type IN VARCHAR2,
18 p_project_opp_rate_date IN DATE,
19 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
20 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
21 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
22
23
24 --
25 -- Procedure : delete_row
26 -- Purpose : Delete a row in pa_project_opp_attrs.
27 --
28 --
29 PROCEDURE delete_row
30 ( p_project_id IN NUMBER ,
31 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
32 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
33 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
34
35
36 --
37 -- Procedure : update_row
38 -- Purpose : Update a row in pa_project_opp_attrs.
39 --
40 --
41 PROCEDURE update_row
42 ( p_project_id IN NUMBER ,
43 p_opportunity_value IN NUMBER,
44 p_opp_value_currency_code IN VARCHAR2,
45 p_projfunc_opp_value IN NUMBER,
46 p_projfunc_opp_rate_type IN VARCHAR2,
47 p_projfunc_opp_rate_date IN DATE,
48 p_project_opp_value IN NUMBER,
49 p_project_opp_rate_type IN VARCHAR2,
50 p_project_opp_rate_date IN DATE,
51 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
52 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
53 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
54
55
56 END PA_PROJ_OPP_ATTRS_PKG;