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_FP_RESOURCE_ASSIGNMENTS_PKG dependencies on PA_RESOURCE_ASSIGNMENTS

Line 14: ( px_resource_assignment_id IN OUT NOCOPY pa_resource_assignments.resource_assignment_id%TYPE --File.Sql.39 bug 4440895

10: -- NOTE :
11: -- End of Comments
12:
13: PROCEDURE Insert_Row
14: ( px_resource_assignment_id IN OUT NOCOPY pa_resource_assignments.resource_assignment_id%TYPE --File.Sql.39 bug 4440895
15: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
16: := FND_API.G_MISS_NUM
17: ,p_project_id IN pa_resource_assignments.project_id%TYPE
18: := FND_API.G_MISS_NUM

Line 15: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE

11: -- End of Comments
12:
13: PROCEDURE Insert_Row
14: ( px_resource_assignment_id IN OUT NOCOPY pa_resource_assignments.resource_assignment_id%TYPE --File.Sql.39 bug 4440895
15: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
16: := FND_API.G_MISS_NUM
17: ,p_project_id IN pa_resource_assignments.project_id%TYPE
18: := FND_API.G_MISS_NUM
19: ,p_task_id IN pa_resource_assignments.task_id%TYPE

Line 17: ,p_project_id IN pa_resource_assignments.project_id%TYPE

13: PROCEDURE Insert_Row
14: ( px_resource_assignment_id IN OUT NOCOPY pa_resource_assignments.resource_assignment_id%TYPE --File.Sql.39 bug 4440895
15: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
16: := FND_API.G_MISS_NUM
17: ,p_project_id IN pa_resource_assignments.project_id%TYPE
18: := FND_API.G_MISS_NUM
19: ,p_task_id IN pa_resource_assignments.task_id%TYPE
20: := FND_API.G_MISS_NUM
21: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE

Line 19: ,p_task_id IN pa_resource_assignments.task_id%TYPE

15: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
16: := FND_API.G_MISS_NUM
17: ,p_project_id IN pa_resource_assignments.project_id%TYPE
18: := FND_API.G_MISS_NUM
19: ,p_task_id IN pa_resource_assignments.task_id%TYPE
20: := FND_API.G_MISS_NUM
21: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
22: := FND_API.G_MISS_NUM
23: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE

Line 21: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE

17: ,p_project_id IN pa_resource_assignments.project_id%TYPE
18: := FND_API.G_MISS_NUM
19: ,p_task_id IN pa_resource_assignments.task_id%TYPE
20: := FND_API.G_MISS_NUM
21: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
22: := FND_API.G_MISS_NUM
23: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
24: := FND_API.G_MISS_CHAR
25: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE

Line 23: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE

19: ,p_task_id IN pa_resource_assignments.task_id%TYPE
20: := FND_API.G_MISS_NUM
21: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
22: := FND_API.G_MISS_NUM
23: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
24: := FND_API.G_MISS_CHAR
25: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE
26: := FND_API.G_MISS_CHAR
27: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE

Line 25: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE

21: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
22: := FND_API.G_MISS_NUM
23: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
24: := FND_API.G_MISS_CHAR
25: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE
26: := FND_API.G_MISS_CHAR
27: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE
28: := FND_API.G_MISS_NUM
29: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE

Line 27: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE

23: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
24: := FND_API.G_MISS_CHAR
25: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE
26: := FND_API.G_MISS_CHAR
27: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE
28: := FND_API.G_MISS_NUM
29: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE
30: := FND_API.G_MISS_NUM
31: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE

Line 29: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE

25: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE
26: := FND_API.G_MISS_CHAR
27: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE
28: := FND_API.G_MISS_NUM
29: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE
30: := FND_API.G_MISS_NUM
31: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE
32: := FND_API.G_MISS_NUM
33: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE

Line 31: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE

27: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE
28: := FND_API.G_MISS_NUM
29: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE
30: := FND_API.G_MISS_NUM
31: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE
32: := FND_API.G_MISS_NUM
33: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE
34: := FND_API.G_MISS_NUM
35: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE

Line 33: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE

29: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE
30: := FND_API.G_MISS_NUM
31: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE
32: := FND_API.G_MISS_NUM
33: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE
34: := FND_API.G_MISS_NUM
35: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE
36: := FND_API.G_MISS_CHAR
37: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE

Line 35: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE

31: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE
32: := FND_API.G_MISS_NUM
33: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE
34: := FND_API.G_MISS_NUM
35: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE
36: := FND_API.G_MISS_CHAR
37: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE
38: := FND_API.G_MISS_NUM
39: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE

Line 37: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE

33: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE
34: := FND_API.G_MISS_NUM
35: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE
36: := FND_API.G_MISS_CHAR
37: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE
38: := FND_API.G_MISS_NUM
39: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE
40: := FND_API.G_MISS_NUM
41: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE

Line 39: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE

35: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE
36: := FND_API.G_MISS_CHAR
37: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE
38: := FND_API.G_MISS_NUM
39: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE
40: := FND_API.G_MISS_NUM
41: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE
42: := FND_API.G_MISS_NUM
43: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE

Line 41: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE

37: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE
38: := FND_API.G_MISS_NUM
39: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE
40: := FND_API.G_MISS_NUM
41: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE
42: := FND_API.G_MISS_NUM
43: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE
44: := FND_API.G_MISS_NUM
45: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE

Line 43: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE

39: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE
40: := FND_API.G_MISS_NUM
41: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE
42: := FND_API.G_MISS_NUM
43: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE
44: := FND_API.G_MISS_NUM
45: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE
46: := FND_API.G_MISS_NUM
47: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE

Line 45: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE

41: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE
42: := FND_API.G_MISS_NUM
43: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE
44: := FND_API.G_MISS_NUM
45: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE
46: := FND_API.G_MISS_NUM
47: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE
48: := FND_API.G_MISS_NUM
49: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE

Line 47: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE

43: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE
44: := FND_API.G_MISS_NUM
45: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE
46: := FND_API.G_MISS_NUM
47: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE
48: := FND_API.G_MISS_NUM
49: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE
50: := FND_API.G_MISS_NUM
51: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE

Line 49: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE

45: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE
46: := FND_API.G_MISS_NUM
47: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE
48: := FND_API.G_MISS_NUM
49: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE
50: := FND_API.G_MISS_NUM
51: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE
52: := FND_API.G_MISS_NUM
53: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE

Line 51: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE

47: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE
48: := FND_API.G_MISS_NUM
49: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE
50: := FND_API.G_MISS_NUM
51: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE
52: := FND_API.G_MISS_NUM
53: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE
54: := FND_API.G_MISS_NUM
55: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE

Line 53: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE

49: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE
50: := FND_API.G_MISS_NUM
51: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE
52: := FND_API.G_MISS_NUM
53: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE
54: := FND_API.G_MISS_NUM
55: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE
56: := FND_API.G_MISS_NUM
57: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE

Line 55: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE

51: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE
52: := FND_API.G_MISS_NUM
53: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE
54: := FND_API.G_MISS_NUM
55: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE
56: := FND_API.G_MISS_NUM
57: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE
58: := FND_API.G_MISS_NUM
59: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE

Line 57: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE

53: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE
54: := FND_API.G_MISS_NUM
55: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE
56: := FND_API.G_MISS_NUM
57: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE
58: := FND_API.G_MISS_NUM
59: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE
60: := FND_API.G_MISS_NUM
61: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE

Line 59: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE

55: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE
56: := FND_API.G_MISS_NUM
57: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE
58: := FND_API.G_MISS_NUM
59: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE
60: := FND_API.G_MISS_NUM
61: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE
62: := FND_API.G_MISS_NUM
63: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE

Line 61: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE

57: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE
58: := FND_API.G_MISS_NUM
59: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE
60: := FND_API.G_MISS_NUM
61: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE
62: := FND_API.G_MISS_NUM
63: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE
64: := FND_API.G_MISS_NUM
65: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE

Line 63: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE

59: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE
60: := FND_API.G_MISS_NUM
61: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE
62: := FND_API.G_MISS_NUM
63: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE
64: := FND_API.G_MISS_NUM
65: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE
66: := FND_API.G_MISS_NUM
67: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE

Line 65: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE

61: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE
62: := FND_API.G_MISS_NUM
63: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE
64: := FND_API.G_MISS_NUM
65: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE
66: := FND_API.G_MISS_NUM
67: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE
68: := FND_API.G_MISS_NUM
69: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE

Line 67: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE

63: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE
64: := FND_API.G_MISS_NUM
65: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE
66: := FND_API.G_MISS_NUM
67: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE
68: := FND_API.G_MISS_NUM
69: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE
70: := FND_API.G_MISS_NUM
71: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE

Line 69: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE

65: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE
66: := FND_API.G_MISS_NUM
67: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE
68: := FND_API.G_MISS_NUM
69: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE
70: := FND_API.G_MISS_NUM
71: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE
72: := FND_API.G_MISS_NUM
73: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE

Line 71: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE

67: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE
68: := FND_API.G_MISS_NUM
69: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE
70: := FND_API.G_MISS_NUM
71: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE
72: := FND_API.G_MISS_NUM
73: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE
74: := FND_API.G_MISS_NUM
75: ,p_total_head_count_adj IN pa_resource_assignments.total_head_count_adj%TYPE

Line 73: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE

69: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE
70: := FND_API.G_MISS_NUM
71: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE
72: := FND_API.G_MISS_NUM
73: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE
74: := FND_API.G_MISS_NUM
75: ,p_total_head_count_adj IN pa_resource_assignments.total_head_count_adj%TYPE
76: := FND_API.G_MISS_NUM
77: ,p_resource_assignment_type IN pa_resource_assignments.resource_assignment_type%TYPE

Line 75: ,p_total_head_count_adj IN pa_resource_assignments.total_head_count_adj%TYPE

71: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE
72: := FND_API.G_MISS_NUM
73: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE
74: := FND_API.G_MISS_NUM
75: ,p_total_head_count_adj IN pa_resource_assignments.total_head_count_adj%TYPE
76: := FND_API.G_MISS_NUM
77: ,p_resource_assignment_type IN pa_resource_assignments.resource_assignment_type%TYPE
78: := FND_API.G_MISS_CHAR
79: -- start of changes of Bug:- 2634900

Line 77: ,p_resource_assignment_type IN pa_resource_assignments.resource_assignment_type%TYPE

73: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE
74: := FND_API.G_MISS_NUM
75: ,p_total_head_count_adj IN pa_resource_assignments.total_head_count_adj%TYPE
76: := FND_API.G_MISS_NUM
77: ,p_resource_assignment_type IN pa_resource_assignments.resource_assignment_type%TYPE
78: := FND_API.G_MISS_CHAR
79: -- start of changes of Bug:- 2634900
80: ,p_total_project_raw_cost IN pa_resource_assignments.total_project_raw_cost%TYPE
81: := FND_API.G_MISS_NUM

Line 80: ,p_total_project_raw_cost IN pa_resource_assignments.total_project_raw_cost%TYPE

76: := FND_API.G_MISS_NUM
77: ,p_resource_assignment_type IN pa_resource_assignments.resource_assignment_type%TYPE
78: := FND_API.G_MISS_CHAR
79: -- start of changes of Bug:- 2634900
80: ,p_total_project_raw_cost IN pa_resource_assignments.total_project_raw_cost%TYPE
81: := FND_API.G_MISS_NUM
82: ,p_total_project_burdened_cost IN pa_resource_assignments.total_project_burdened_cost%TYPE
83: := FND_API.G_MISS_NUM
84: ,p_total_project_revenue IN pa_resource_assignments.total_project_revenue%TYPE

Line 82: ,p_total_project_burdened_cost IN pa_resource_assignments.total_project_burdened_cost%TYPE

78: := FND_API.G_MISS_CHAR
79: -- start of changes of Bug:- 2634900
80: ,p_total_project_raw_cost IN pa_resource_assignments.total_project_raw_cost%TYPE
81: := FND_API.G_MISS_NUM
82: ,p_total_project_burdened_cost IN pa_resource_assignments.total_project_burdened_cost%TYPE
83: := FND_API.G_MISS_NUM
84: ,p_total_project_revenue IN pa_resource_assignments.total_project_revenue%TYPE
85: := FND_API.G_MISS_NUM
86: ,p_parent_assignment_id IN pa_resource_assignments.parent_assignment_id%TYPE

Line 84: ,p_total_project_revenue IN pa_resource_assignments.total_project_revenue%TYPE

80: ,p_total_project_raw_cost IN pa_resource_assignments.total_project_raw_cost%TYPE
81: := FND_API.G_MISS_NUM
82: ,p_total_project_burdened_cost IN pa_resource_assignments.total_project_burdened_cost%TYPE
83: := FND_API.G_MISS_NUM
84: ,p_total_project_revenue IN pa_resource_assignments.total_project_revenue%TYPE
85: := FND_API.G_MISS_NUM
86: ,p_parent_assignment_id IN pa_resource_assignments.parent_assignment_id%TYPE
87: := FND_API.G_MISS_NUM
88: -- end of changes of Bug :- 2634900

Line 86: ,p_parent_assignment_id IN pa_resource_assignments.parent_assignment_id%TYPE

82: ,p_total_project_burdened_cost IN pa_resource_assignments.total_project_burdened_cost%TYPE
83: := FND_API.G_MISS_NUM
84: ,p_total_project_revenue IN pa_resource_assignments.total_project_revenue%TYPE
85: := FND_API.G_MISS_NUM
86: ,p_parent_assignment_id IN pa_resource_assignments.parent_assignment_id%TYPE
87: := FND_API.G_MISS_NUM
88: -- end of changes of Bug :- 2634900
89: ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
90: ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 93: ( p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE

89: ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
90: ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
91:
92: PROCEDURE Update_Row
93: ( p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
94: := FND_API.G_MISS_NUM
95: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
96: := FND_API.G_MISS_NUM
97: ,p_project_id IN pa_resource_assignments.project_id%TYPE

Line 95: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE

91:
92: PROCEDURE Update_Row
93: ( p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
94: := FND_API.G_MISS_NUM
95: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
96: := FND_API.G_MISS_NUM
97: ,p_project_id IN pa_resource_assignments.project_id%TYPE
98: := FND_API.G_MISS_NUM
99: ,p_task_id IN pa_resource_assignments.task_id%TYPE

Line 97: ,p_project_id IN pa_resource_assignments.project_id%TYPE

93: ( p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
94: := FND_API.G_MISS_NUM
95: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
96: := FND_API.G_MISS_NUM
97: ,p_project_id IN pa_resource_assignments.project_id%TYPE
98: := FND_API.G_MISS_NUM
99: ,p_task_id IN pa_resource_assignments.task_id%TYPE
100: := FND_API.G_MISS_NUM
101: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE

Line 99: ,p_task_id IN pa_resource_assignments.task_id%TYPE

95: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
96: := FND_API.G_MISS_NUM
97: ,p_project_id IN pa_resource_assignments.project_id%TYPE
98: := FND_API.G_MISS_NUM
99: ,p_task_id IN pa_resource_assignments.task_id%TYPE
100: := FND_API.G_MISS_NUM
101: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
102: := FND_API.G_MISS_NUM
103: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE

Line 101: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE

97: ,p_project_id IN pa_resource_assignments.project_id%TYPE
98: := FND_API.G_MISS_NUM
99: ,p_task_id IN pa_resource_assignments.task_id%TYPE
100: := FND_API.G_MISS_NUM
101: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
102: := FND_API.G_MISS_NUM
103: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
104: := FND_API.G_MISS_CHAR
105: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE

Line 103: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE

99: ,p_task_id IN pa_resource_assignments.task_id%TYPE
100: := FND_API.G_MISS_NUM
101: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
102: := FND_API.G_MISS_NUM
103: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
104: := FND_API.G_MISS_CHAR
105: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE
106: := FND_API.G_MISS_CHAR
107: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE

Line 105: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE

101: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
102: := FND_API.G_MISS_NUM
103: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
104: := FND_API.G_MISS_CHAR
105: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE
106: := FND_API.G_MISS_CHAR
107: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE
108: := FND_API.G_MISS_NUM
109: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE

Line 107: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE

103: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
104: := FND_API.G_MISS_CHAR
105: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE
106: := FND_API.G_MISS_CHAR
107: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE
108: := FND_API.G_MISS_NUM
109: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE
110: := FND_API.G_MISS_NUM
111: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE

Line 109: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE

105: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE
106: := FND_API.G_MISS_CHAR
107: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE
108: := FND_API.G_MISS_NUM
109: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE
110: := FND_API.G_MISS_NUM
111: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE
112: := FND_API.G_MISS_NUM
113: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE

Line 111: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE

107: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE
108: := FND_API.G_MISS_NUM
109: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE
110: := FND_API.G_MISS_NUM
111: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE
112: := FND_API.G_MISS_NUM
113: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE
114: := FND_API.G_MISS_NUM
115: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE

Line 113: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE

109: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE
110: := FND_API.G_MISS_NUM
111: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE
112: := FND_API.G_MISS_NUM
113: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE
114: := FND_API.G_MISS_NUM
115: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE
116: := FND_API.G_MISS_CHAR
117: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE

Line 115: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE

111: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE
112: := FND_API.G_MISS_NUM
113: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE
114: := FND_API.G_MISS_NUM
115: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE
116: := FND_API.G_MISS_CHAR
117: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE
118: := FND_API.G_MISS_NUM
119: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE

Line 117: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE

113: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE
114: := FND_API.G_MISS_NUM
115: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE
116: := FND_API.G_MISS_CHAR
117: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE
118: := FND_API.G_MISS_NUM
119: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE
120: := FND_API.G_MISS_NUM
121: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE

Line 119: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE

115: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE
116: := FND_API.G_MISS_CHAR
117: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE
118: := FND_API.G_MISS_NUM
119: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE
120: := FND_API.G_MISS_NUM
121: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE
122: := FND_API.G_MISS_NUM
123: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE

Line 121: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE

117: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE
118: := FND_API.G_MISS_NUM
119: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE
120: := FND_API.G_MISS_NUM
121: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE
122: := FND_API.G_MISS_NUM
123: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE
124: := FND_API.G_MISS_NUM
125: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE

Line 123: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE

119: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE
120: := FND_API.G_MISS_NUM
121: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE
122: := FND_API.G_MISS_NUM
123: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE
124: := FND_API.G_MISS_NUM
125: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE
126: := FND_API.G_MISS_NUM
127: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE

Line 125: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE

121: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE
122: := FND_API.G_MISS_NUM
123: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE
124: := FND_API.G_MISS_NUM
125: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE
126: := FND_API.G_MISS_NUM
127: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE
128: := FND_API.G_MISS_NUM
129: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE

Line 127: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE

123: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE
124: := FND_API.G_MISS_NUM
125: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE
126: := FND_API.G_MISS_NUM
127: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE
128: := FND_API.G_MISS_NUM
129: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE
130: := FND_API.G_MISS_NUM
131: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE

Line 129: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE

125: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE
126: := FND_API.G_MISS_NUM
127: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE
128: := FND_API.G_MISS_NUM
129: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE
130: := FND_API.G_MISS_NUM
131: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE
132: := FND_API.G_MISS_NUM
133: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE

Line 131: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE

127: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE
128: := FND_API.G_MISS_NUM
129: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE
130: := FND_API.G_MISS_NUM
131: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE
132: := FND_API.G_MISS_NUM
133: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE
134: := FND_API.G_MISS_NUM
135: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE

Line 133: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE

129: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE
130: := FND_API.G_MISS_NUM
131: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE
132: := FND_API.G_MISS_NUM
133: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE
134: := FND_API.G_MISS_NUM
135: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE
136: := FND_API.G_MISS_NUM
137: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE

Line 135: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE

131: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE
132: := FND_API.G_MISS_NUM
133: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE
134: := FND_API.G_MISS_NUM
135: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE
136: := FND_API.G_MISS_NUM
137: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE
138: := FND_API.G_MISS_NUM
139: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE

Line 137: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE

133: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE
134: := FND_API.G_MISS_NUM
135: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE
136: := FND_API.G_MISS_NUM
137: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE
138: := FND_API.G_MISS_NUM
139: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE
140: := FND_API.G_MISS_NUM
141: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE

Line 139: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE

135: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE
136: := FND_API.G_MISS_NUM
137: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE
138: := FND_API.G_MISS_NUM
139: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE
140: := FND_API.G_MISS_NUM
141: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE
142: := FND_API.G_MISS_NUM
143: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE

Line 141: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE

137: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE
138: := FND_API.G_MISS_NUM
139: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE
140: := FND_API.G_MISS_NUM
141: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE
142: := FND_API.G_MISS_NUM
143: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE
144: := FND_API.G_MISS_NUM
145: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE

Line 143: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE

139: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE
140: := FND_API.G_MISS_NUM
141: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE
142: := FND_API.G_MISS_NUM
143: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE
144: := FND_API.G_MISS_NUM
145: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE
146: := FND_API.G_MISS_NUM
147: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE

Line 145: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE

141: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE
142: := FND_API.G_MISS_NUM
143: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE
144: := FND_API.G_MISS_NUM
145: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE
146: := FND_API.G_MISS_NUM
147: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE
148: := FND_API.G_MISS_NUM
149: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE

Line 147: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE

143: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE
144: := FND_API.G_MISS_NUM
145: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE
146: := FND_API.G_MISS_NUM
147: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE
148: := FND_API.G_MISS_NUM
149: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE
150: := FND_API.G_MISS_NUM
151: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE

Line 149: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE

145: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE
146: := FND_API.G_MISS_NUM
147: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE
148: := FND_API.G_MISS_NUM
149: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE
150: := FND_API.G_MISS_NUM
151: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE
152: := FND_API.G_MISS_NUM
153: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE

Line 151: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE

147: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE
148: := FND_API.G_MISS_NUM
149: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE
150: := FND_API.G_MISS_NUM
151: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE
152: := FND_API.G_MISS_NUM
153: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE
154: := FND_API.G_MISS_NUM
155: ,p_total_head_count_adj IN pa_resource_assignments.total_head_count_adj%TYPE

Line 153: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE

149: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE
150: := FND_API.G_MISS_NUM
151: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE
152: := FND_API.G_MISS_NUM
153: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE
154: := FND_API.G_MISS_NUM
155: ,p_total_head_count_adj IN pa_resource_assignments.total_head_count_adj%TYPE
156: := FND_API.G_MISS_NUM
157: ,p_resource_assignment_type IN pa_resource_assignments.resource_assignment_type%TYPE

Line 155: ,p_total_head_count_adj IN pa_resource_assignments.total_head_count_adj%TYPE

151: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE
152: := FND_API.G_MISS_NUM
153: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE
154: := FND_API.G_MISS_NUM
155: ,p_total_head_count_adj IN pa_resource_assignments.total_head_count_adj%TYPE
156: := FND_API.G_MISS_NUM
157: ,p_resource_assignment_type IN pa_resource_assignments.resource_assignment_type%TYPE
158: := FND_API.G_MISS_CHAR
159: -- start of changes of Bug:- 2634900

Line 157: ,p_resource_assignment_type IN pa_resource_assignments.resource_assignment_type%TYPE

153: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE
154: := FND_API.G_MISS_NUM
155: ,p_total_head_count_adj IN pa_resource_assignments.total_head_count_adj%TYPE
156: := FND_API.G_MISS_NUM
157: ,p_resource_assignment_type IN pa_resource_assignments.resource_assignment_type%TYPE
158: := FND_API.G_MISS_CHAR
159: -- start of changes of Bug:- 2634900
160: ,p_total_project_raw_cost IN pa_resource_assignments.total_project_raw_cost%TYPE
161: := FND_API.G_MISS_NUM

Line 160: ,p_total_project_raw_cost IN pa_resource_assignments.total_project_raw_cost%TYPE

156: := FND_API.G_MISS_NUM
157: ,p_resource_assignment_type IN pa_resource_assignments.resource_assignment_type%TYPE
158: := FND_API.G_MISS_CHAR
159: -- start of changes of Bug:- 2634900
160: ,p_total_project_raw_cost IN pa_resource_assignments.total_project_raw_cost%TYPE
161: := FND_API.G_MISS_NUM
162: ,p_total_project_burdened_cost IN pa_resource_assignments.total_project_burdened_cost%TYPE
163: := FND_API.G_MISS_NUM
164: ,p_total_project_revenue IN pa_resource_assignments.total_project_revenue%TYPE

Line 162: ,p_total_project_burdened_cost IN pa_resource_assignments.total_project_burdened_cost%TYPE

158: := FND_API.G_MISS_CHAR
159: -- start of changes of Bug:- 2634900
160: ,p_total_project_raw_cost IN pa_resource_assignments.total_project_raw_cost%TYPE
161: := FND_API.G_MISS_NUM
162: ,p_total_project_burdened_cost IN pa_resource_assignments.total_project_burdened_cost%TYPE
163: := FND_API.G_MISS_NUM
164: ,p_total_project_revenue IN pa_resource_assignments.total_project_revenue%TYPE
165: := FND_API.G_MISS_NUM
166: ,p_parent_assignment_id IN pa_resource_assignments.parent_assignment_id%TYPE

Line 164: ,p_total_project_revenue IN pa_resource_assignments.total_project_revenue%TYPE

160: ,p_total_project_raw_cost IN pa_resource_assignments.total_project_raw_cost%TYPE
161: := FND_API.G_MISS_NUM
162: ,p_total_project_burdened_cost IN pa_resource_assignments.total_project_burdened_cost%TYPE
163: := FND_API.G_MISS_NUM
164: ,p_total_project_revenue IN pa_resource_assignments.total_project_revenue%TYPE
165: := FND_API.G_MISS_NUM
166: ,p_parent_assignment_id IN pa_resource_assignments.parent_assignment_id%TYPE
167: := FND_API.G_MISS_NUM
168: -- end of changes of Bug:- 2634900

Line 166: ,p_parent_assignment_id IN pa_resource_assignments.parent_assignment_id%TYPE

162: ,p_total_project_burdened_cost IN pa_resource_assignments.total_project_burdened_cost%TYPE
163: := FND_API.G_MISS_NUM
164: ,p_total_project_revenue IN pa_resource_assignments.total_project_revenue%TYPE
165: := FND_API.G_MISS_NUM
166: ,p_parent_assignment_id IN pa_resource_assignments.parent_assignment_id%TYPE
167: := FND_API.G_MISS_NUM
168: -- end of changes of Bug:- 2634900
169: ,p_row_id IN ROWID
170: := NULL

Line 174: ( p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE

170: := NULL
171: ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
172:
173: PROCEDURE Lock_Row
174: ( p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
175: := FND_API.G_MISS_NUM
176: ,p_row_id IN ROWID
177: := NULL
178: ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 181: ( p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE

177: := NULL
178: ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
179:
180: PROCEDURE Delete_Row
181: ( p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
182: := FND_API.G_MISS_NUM
183: ,p_row_id IN ROWID
184: := NULL
185: ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895