[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;