4 -- This procedure will validate the status of project request for project creation.
1 PACKAGE PA_PROJECT_REQUEST_PVT AUTHID CURRENT_USER as
2 /* $Header: PAYRPVTS.pls 120.1 2005/08/19 17:25:13 mwasowic noship $ */
3
5 -- Users are not allowed to create a project from a project request having system
6 -- Status of 'PROJ_REQ_CLOSED' OR 'PROJ_REQ_CANCELED'.
7 --
8 -- Input parameters
9 -- Parameters Type
10 -- p_request_sys_status pa_project_statuses.project_system_status_code%TYPE
11 --
12
13 PROCEDURE create_project_validation
14 (p_request_sys_status IN pa_project_statuses.project_system_status_code%TYPE,
15 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
16 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
17 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
18
19 --
20 -- Procedure : get_object_info
21 -- Purpose : Get all the attributes of an object.
22 --
23 --
24 PROCEDURE get_object_info
25 ( p_object_type IN VARCHAR2 ,
26 p_object_id1 IN VARCHAR2 ,
27 p_object_id2 IN VARCHAR2 ,
28 p_object_id3 IN VARCHAR2 ,
29 p_object_id4 IN VARCHAR2 ,
30 p_object_id5 IN VARCHAR2 ,
31 x_object_name OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
32 x_object_number OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
33 x_object_type_name OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
34 x_object_subtype OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
35 x_status_name OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
36 x_description OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
37 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
38 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
39 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
40
41
42 --
43 -- Procedure : populate_associations_temp
44 -- Purpose : Insert data into PA_PROJ_REQ_ASSOCIATIONS_TEMP that is used to display
45 -- the associations on the Relationships page.
46 --
47 --
48 PROCEDURE populate_associations_temp
49 ( p_object_type_from IN VARCHAR2,
50 p_object_id_from1 IN VARCHAR2,
51 p_object_id_from2 IN VARCHAR2,
52 p_object_id_from3 IN VARCHAR2,
53 p_object_id_from4 IN VARCHAR2,
54 p_object_id_from5 IN VARCHAR2,
55 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
56 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
60 PROCEDURE debug(p_msg IN VARCHAR2);
57 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
58
59
61
62 PROCEDURE close_project_request
63 (p_request_id IN pa_project_requests.request_id%TYPE,
64 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
65 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
66 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
67
68 --Procedure: get_quick_entry_defaults
69 --Purpose: Defaults the quick entry, when create a project from a selected request.
70 --Note: In parameter template_id is not used currently
71
72 PROCEDURE get_quick_entry_defaults (
73 p_request_id IN NUMBER,
74 p_template_id IN NUMBER,
75 x_field_names OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE, --File.Sql.39 bug 4440895
76 x_field_values OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE, --File.Sql.39 bug 4440895
77 x_field_types OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE, --File.Sql.39 bug 4440895
78 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
79 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
80 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
81
82 --Procedure: manage_project_requests
83 --Purpose: This procedure is called by concurrent program. It calls
84 --Procedure create_project_requests and update_projects.
85
86 PROCEDURE manage_project_requests
87 (p_run_mode IN VARCHAR2,
88 p_source_application_id IN NUMBER,
89 p_request_type IN VARCHAR2,
90 p_probability_from IN NUMBER,
91 p_probability_to IN NUMBER,
92 p_closed_date_within_days IN NUMBER,
93 p_status IN VARCHAR2,
94 p_sales_stage_id IN NUMBER,
95 p_value_from IN NUMBER,
96 p_value_to IN NUMBER,
97 p_currency_code IN VARCHAR2,
98 p_classification IN VARCHAR2,
99 p_calling_module IN VARCHAR2, -- added 3632760
100 p_update_probability IN VARCHAR2,
101 p_update_value IN VARCHAR2,
102 p_update_exp_appr_date IN VARCHAR2,
103 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
104 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
105 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
106
107 --Procedure: create_project_requests
108 --Purpose: This procedure is called by manage_project_requests.
109 -- It creats the project requests for the user specified
110 -- opportunities
111
112 PROCEDURE create_project_requests
113 (p_source_application_id IN NUMBER,
114 p_request_type IN VARCHAR2,
115 p_probability_from IN NUMBER,
116 p_probability_to IN NUMBER,
117 p_closed_date_within_days IN NUMBER,
118 p_status IN VARCHAR2,
119 p_sales_stage_id IN NUMBER,
120 p_value_from IN NUMBER,
121 p_value_to IN NUMBER,
122 p_currency_code IN VARCHAR2,
123 p_classification IN VARCHAR2,
124 p_is_profile_defined IN VARCHAR2, -- added 3632760
125 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
126 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
127 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
128
129
130 --Procedure: update_projects
131 --Purpose: This procedure is called by manage_project_requests.
132 -- It updates the opportunity related project specified
133 -- by users.
134
135 PROCEDURE update_projects
136 (p_source_application_id IN NUMBER,
137 p_request_type IN VARCHAR2,
138 p_probability_from IN NUMBER,
139 p_probability_to IN NUMBER,
140 p_closed_date_within_days IN NUMBER,
141 p_status IN VARCHAR2,
142 p_sales_stage_id IN NUMBER,
143 p_value_from IN NUMBER,
144 p_value_to IN NUMBER,
145 p_currency_code IN VARCHAR2,
146 p_classification IN VARCHAR2,
147 p_is_profile_defined IN VARCHAR2, -- added 3632760
148 p_update_probability IN VARCHAR2,
149 p_update_value IN VARCHAR2,
150 p_update_exp_appr_date IN VARCHAR2,
151 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
152 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
153 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
154
155 --Procedure: post_create_project
156 --Purpose: This procedure is to build the two ways relationship
157 -- between the project request and the project created.
158 -- And close the project request after the project is created.
159
160
161 PROCEDURE post_create_project
162 (p_request_id IN pa_project_requests.request_id%TYPE,
163 p_project_id IN pa_projects_all.project_id%TYPE,
164 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
165 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
166 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
167
168 PROCEDURE Req_Name_Duplicate
169 (p_request_name IN VARCHAR2,
170 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
171 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
172 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
173
174 G_ORG_ID pa_projects_all.org_id%type ; -- Added for bug#3807805
175
176 END PA_PROJECT_REQUEST_PVT;