DBA Data[Home] [Help]

APPS.PA_PROJECTS_UPDATE_PKG dependencies on PA_PROJECTS_UPDATE_TEMP

Line 6: -- Purpose : Create Row in PA_PROJECTS_UPDATE_TEMP.

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,

Line 10: ( p_project_name IN pa_projects_update_temp.project_name%TYPE,

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,

Line 11: p_project_number IN pa_projects_update_temp.project_number%TYPE,

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,

Line 12: p_project_status_name IN pa_projects_update_temp.project_status_name%TYPE,

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,

Line 13: p_old_probability IN pa_projects_update_temp.old_probability%TYPE,

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,

Line 14: p_new_probability IN pa_projects_update_temp.new_probability%TYPE,

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,

Line 15: p_old_value IN pa_projects_update_temp.old_value%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,

Line 16: p_new_value IN pa_projects_update_temp.new_value%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,

Line 17: p_old_value_currency IN pa_projects_update_temp.old_value_currency%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

Line 18: p_new_value_currency IN pa_projects_update_temp.new_value_currency%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

Line 19: p_old_exp_proj_apprvl_date IN pa_projects_update_temp.old_expected_proj_apprvl_date%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

Line 20: p_new_exp_proj_apprvl_date IN pa_projects_update_temp.new_expected_proj_apprvl_date%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: