DBA Data[Home] [Help]

APPS.PA_FP_VIEW_PLANS_UTIL dependencies on PA_RESOURCE_ASSIGNMENTS

Line 13: p_project_id IN pa_resource_assignments.project_id%TYPE,

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:

Line 14: p_task_id IN pa_resource_assignments.task_id%TYPE,

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

Line 15: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)

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,

Line 20: p_project_id IN pa_resource_assignments.project_id%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:

Line 21: p_task_id IN pa_resource_assignments.task_id%TYPE,

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

Line 22: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)

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,

Line 31: (p_project_id IN pa_resource_assignments.project_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:

Line 32: p_task_id IN pa_resource_assignments.task_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:
36: function assign_parent_element

Line 33: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)

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,

Line 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:

Line 38: p_task_id IN pa_resource_assignments.task_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:
42: function assign_element_name

Line 39: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)

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,

Line 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:

Line 44: p_task_id IN pa_resource_assignments.task_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:
48: function assign_element_level

Line 45: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)

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,

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

Line 50: p_budget_version_id IN pa_resource_assignments.budget_version_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;
54:

Line 51: p_task_id IN pa_resource_assignments.task_id%TYPE,

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

Line 52: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)

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,

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

Line 57: p_task_id IN pa_resource_assignments.task_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;
61:

Line 58: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,

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

Line 103: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,

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