9: */
10:
11: function calculate_gl_total
12: (p_amount_code IN pa_amount_types_b.amount_type_code%TYPE,
13: p_project_id IN pa_resource_assignments.project_id%TYPE,
14: p_task_id IN pa_resource_assignments.task_id%TYPE,
15: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
16: return NUMBER;
17:
10:
11: function calculate_gl_total
12: (p_amount_code IN pa_amount_types_b.amount_type_code%TYPE,
13: p_project_id IN pa_resource_assignments.project_id%TYPE,
14: p_task_id IN pa_resource_assignments.task_id%TYPE,
15: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
16: return NUMBER;
17:
18: function calculate_pa_total
11: function calculate_gl_total
12: (p_amount_code IN pa_amount_types_b.amount_type_code%TYPE,
13: p_project_id IN pa_resource_assignments.project_id%TYPE,
14: p_task_id IN pa_resource_assignments.task_id%TYPE,
15: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
16: return NUMBER;
17:
18: function calculate_pa_total
19: (p_amount_code IN pa_amount_types_b.amount_type_code%TYPE,
16: return NUMBER;
17:
18: function calculate_pa_total
19: (p_amount_code IN pa_amount_types_b.amount_type_code%TYPE,
20: p_project_id IN pa_resource_assignments.project_id%TYPE,
21: p_task_id IN pa_resource_assignments.task_id%TYPE,
22: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
23: return NUMBER;
24:
17:
18: function calculate_pa_total
19: (p_amount_code IN pa_amount_types_b.amount_type_code%TYPE,
20: p_project_id IN pa_resource_assignments.project_id%TYPE,
21: p_task_id IN pa_resource_assignments.task_id%TYPE,
22: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
23: return NUMBER;
24:
25: function check_compatible_pd_profiles
18: function calculate_pa_total
19: (p_amount_code IN pa_amount_types_b.amount_type_code%TYPE,
20: p_project_id IN pa_resource_assignments.project_id%TYPE,
21: p_task_id IN pa_resource_assignments.task_id%TYPE,
22: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
23: return NUMBER;
24:
25: function check_compatible_pd_profiles
26: (p_period_profile_id1 IN pa_proj_period_profiles.period_profile_id%TYPE,
27: p_period_profile_id2 IN pa_proj_period_profiles.period_profile_id%TYPE)
28: return VARCHAR2;
29:
30: function assign_row_level
31: (p_project_id IN pa_resource_assignments.project_id%TYPE,
32: p_task_id IN pa_resource_assignments.task_id%TYPE,
33: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
34: return NUMBER;
35:
28: return VARCHAR2;
29:
30: function assign_row_level
31: (p_project_id IN pa_resource_assignments.project_id%TYPE,
32: p_task_id IN pa_resource_assignments.task_id%TYPE,
33: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
34: return NUMBER;
35:
36: function assign_parent_element
29:
30: function assign_row_level
31: (p_project_id IN pa_resource_assignments.project_id%TYPE,
32: p_task_id IN pa_resource_assignments.task_id%TYPE,
33: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
34: return NUMBER;
35:
36: function assign_parent_element
37: (p_project_id IN pa_resource_assignments.project_id%TYPE,
33: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
34: return NUMBER;
35:
36: function assign_parent_element
37: (p_project_id IN pa_resource_assignments.project_id%TYPE,
38: p_task_id IN pa_resource_assignments.task_id%TYPE,
39: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
40: return VARCHAR2;
41:
34: return NUMBER;
35:
36: function assign_parent_element
37: (p_project_id IN pa_resource_assignments.project_id%TYPE,
38: p_task_id IN pa_resource_assignments.task_id%TYPE,
39: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
40: return VARCHAR2;
41:
42: function assign_element_name
35:
36: function assign_parent_element
37: (p_project_id IN pa_resource_assignments.project_id%TYPE,
38: p_task_id IN pa_resource_assignments.task_id%TYPE,
39: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
40: return VARCHAR2;
41:
42: function assign_element_name
43: (p_project_id IN pa_resource_assignments.project_id%TYPE,
39: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
40: return VARCHAR2;
41:
42: function assign_element_name
43: (p_project_id IN pa_resource_assignments.project_id%TYPE,
44: p_task_id IN pa_resource_assignments.task_id%TYPE,
45: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
46: return VARCHAR2;
47:
40: return VARCHAR2;
41:
42: function assign_element_name
43: (p_project_id IN pa_resource_assignments.project_id%TYPE,
44: p_task_id IN pa_resource_assignments.task_id%TYPE,
45: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
46: return VARCHAR2;
47:
48: function assign_element_level
41:
42: function assign_element_name
43: (p_project_id IN pa_resource_assignments.project_id%TYPE,
44: p_task_id IN pa_resource_assignments.task_id%TYPE,
45: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
46: return VARCHAR2;
47:
48: function assign_element_level
49: (p_project_id IN pa_resource_assignments.project_id%TYPE,
45: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
46: return VARCHAR2;
47:
48: function assign_element_level
49: (p_project_id IN pa_resource_assignments.project_id%TYPE,
50: p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE,
51: p_task_id IN pa_resource_assignments.task_id%TYPE,
52: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
53: return VARCHAR2;
46: return VARCHAR2;
47:
48: function assign_element_level
49: (p_project_id IN pa_resource_assignments.project_id%TYPE,
50: p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE,
51: p_task_id IN pa_resource_assignments.task_id%TYPE,
52: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
53: return VARCHAR2;
54:
47:
48: function assign_element_level
49: (p_project_id IN pa_resource_assignments.project_id%TYPE,
50: p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE,
51: p_task_id IN pa_resource_assignments.task_id%TYPE,
52: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
53: return VARCHAR2;
54:
55: FUNCTION assign_flat_element_names
48: function assign_element_level
49: (p_project_id IN pa_resource_assignments.project_id%TYPE,
50: p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE,
51: p_task_id IN pa_resource_assignments.task_id%TYPE,
52: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
53: return VARCHAR2;
54:
55: FUNCTION assign_flat_element_names
56: (p_project_id IN pa_resource_assignments.project_id%TYPE,
52: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
53: return VARCHAR2;
54:
55: FUNCTION assign_flat_element_names
56: (p_project_id IN pa_resource_assignments.project_id%TYPE,
57: p_task_id IN pa_resource_assignments.task_id%TYPE,
58: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
59: p_element_type IN VARCHAR2)
60: return VARCHAR2;
53: return VARCHAR2;
54:
55: FUNCTION assign_flat_element_names
56: (p_project_id IN pa_resource_assignments.project_id%TYPE,
57: p_task_id IN pa_resource_assignments.task_id%TYPE,
58: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
59: p_element_type IN VARCHAR2)
60: return VARCHAR2;
61:
54:
55: FUNCTION assign_flat_element_names
56: (p_project_id IN pa_resource_assignments.project_id%TYPE,
57: p_task_id IN pa_resource_assignments.task_id%TYPE,
58: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
59: p_element_type IN VARCHAR2)
60: return VARCHAR2;
61:
62: procedure assign_default_amount
99: -- FP L: used in View/Edit Plan page whenever navigation option to View/Edit
100: -- Plan Line page is chosen. If the resource assignment has been deleted by
101: -- WBS, an error needs to be displayed
102: procedure check_res_assignment_exists
103: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
104: x_res_assignment_exists OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
105: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
106: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
107: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895