[Home] [Help]
PACKAGE: APPS.PA_OPPORTUNITY_MGT_PVT
Source
1 PACKAGE PA_OPPORTUNITY_MGT_PVT AUTHID CURRENT_USER as
2 /* $Header: PAYOPVTS.pls 120.1 2005/08/19 17:23:53 mwasowic noship $ */
3
4 --
5 -- Procedure : debug
6 -- Purpose :
7 --
8 --
9 PROCEDURE debug(p_msg IN VARCHAR2);
10
11 --
12 -- Procedure : modify_project_attributes
13 -- Purpose :
14 --
15 --
16 PROCEDURE modify_project_attributes
17 ( p_project_id IN NUMBER ,
18 p_opportunity_value IN NUMBER ,
19 p_opp_value_currency_code IN VARCHAR2 ,
20 p_expected_approval_date IN DATE ,
21 p_update_project IN VARCHAR2 := 'N',
22 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
23 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
24 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
25
26
27 --
28 -- Procedure : copy_project_attributes
29 -- Purpose :
30 --
31 --
32 PROCEDURE copy_project_attributes
33 ( p_source_project_id IN NUMBER ,
34 p_dest_project_id IN NUMBER ,
35 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
36 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
37 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
38
39
40 --
41 -- Procedure : create_project_attributes
42 -- Purpose :
43 --
44 --
45 PROCEDURE create_project_attributes
46 ( p_project_id IN NUMBER ,
47 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
48 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
49 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
50
51
52 --
53 -- Procedure : delete_project_attributes
54 -- Purpose :
55 --
56 --
57 PROCEDURE delete_project_attributes
58 ( p_project_id IN NUMBER ,
59 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
60 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
61 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
62
63
64 --
65 -- Procedure : validate_value_fields
66 -- Purpose :
67 --
68 --
69 PROCEDURE validate_value_fields
70 ( p_opportunity_value IN NUMBER := NULL,
71 p_opp_value_currency_code IN VARCHAR2 := NULL,
72 p_projfunc_currency_code IN VARCHAR2 ,
73 p_project_currency_code IN VARCHAR2 ,
74 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
75 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
76 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
77
78
79 --
80 -- Procedure : get_opp_multi_currency_setup
81 -- Purpose :
82 --
83 --
84 PROCEDURE get_opp_multi_currency_setup
85 ( x_default_rate_type OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
86 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
87 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
88 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
89
90
91 --
92 -- Procedure : get_opp_multi_currency_setup (overloaded)
93 -- Purpose :
94 --
95 --
96 PROCEDURE get_opp_multi_currency_setup
97 ( p_org_id IN NUMBER ,
98 x_default_rate_type OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
99 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
100 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
101 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
102
103
104 --
105 -- Function : is_opp_multi_currency_setup
106 -- Purpose :
107 --
108 --
109 FUNCTION is_opp_multi_currency_setup RETURN VARCHAR2;
110
111
112 --
113 -- Function : is_opp_multi_currency_setup (overloaded)
114 -- Purpose :
115 --
116 --
117 FUNCTION is_opp_multi_currency_setup (p_org_id IN NUMBER) RETURN VARCHAR2;
118
119
120 --
121 -- Function : is_proj_opp_associated
122 -- Purpose : Check whether a project has association with an opportunity.
123 --
124 --
125 FUNCTION is_proj_opp_associated(p_project_id IN NUMBER) RETURN VARCHAR2;
126
127
128 END PA_OPPORTUNITY_MGT_PVT;