eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECTS_UPDATE_PKG dependencies on PA_PROJECTS_UPDATE_TEMP

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

2: /* $Header: PAYRPK2B.pls 120.2 2005/08/19 17:24:19 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: IS

Line 35: INSERT INTO pa_projects_update_temp

31: BEGIN
32:
33: x_return_status := FND_API.G_RET_STS_SUCCESS;
34:
35: INSERT INTO pa_projects_update_temp
36: (project_name ,
37: project_number ,
38: project_status_name ,
39: old_probability ,