DBA Data[Home] [Help]

PACKAGE: APPS.PA_PROJECTS_UPDATE_PKG

Source


1 PACKAGE PA_PROJECTS_UPDATE_PKG AUTHID CURRENT_USER as
2 /* $Header: PAYRPK2S.pls 120.1 2005/08/19 17:24:24 mwasowic noship $ */
3 
4 --
5 -- Procedure     : Insert_row
6 -- Purpose       : Create Row in PA_PROJECTS_UPDATE_TEMP.
7 --
8 --
9 PROCEDURE insert_row
10       ( p_project_name                    IN pa_projects_update_temp.project_name%TYPE,
11 	      p_project_number		              IN pa_projects_update_temp.project_number%TYPE,
12         p_project_status_name             IN pa_projects_update_temp.project_status_name%TYPE,
13         p_old_probability                 IN pa_projects_update_temp.old_probability%TYPE,
14         p_new_probability		              IN pa_projects_update_temp.new_probability%TYPE,
15         p_old_value                       IN pa_projects_update_temp.old_value%TYPE,
16         p_new_value			                  IN pa_projects_update_temp.new_value%TYPE,
17         p_old_value_currency              IN pa_projects_update_temp.old_value_currency%TYPE,
18         p_new_value_currency              IN pa_projects_update_temp.new_value_currency%TYPE,
19         p_old_exp_proj_apprvl_date        IN pa_projects_update_temp.old_expected_proj_apprvl_date%TYPE,
20         p_new_exp_proj_apprvl_date        IN pa_projects_update_temp.new_expected_proj_apprvl_date%TYPE,
21         x_return_status                   OUT  NOCOPY VARCHAR2                          ,  --File.Sql.39 bug 4440895
22         x_msg_count                       OUT  NOCOPY NUMBER                            ,  --File.Sql.39 bug 4440895
23         x_msg_data                        OUT  NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
24 
25 END PA_PROJECTS_UPDATE_PKG;