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 FND_API

Line 16: := FND_API.G_MISS_NUM

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
20: := FND_API.G_MISS_NUM

Line 18: := FND_API.G_MISS_NUM

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
22: := FND_API.G_MISS_NUM

Line 20: := FND_API.G_MISS_NUM

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
24: := FND_API.G_MISS_CHAR

Line 22: := FND_API.G_MISS_NUM

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
26: := FND_API.G_MISS_CHAR

Line 24: := FND_API.G_MISS_CHAR

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
28: := FND_API.G_MISS_NUM

Line 26: := FND_API.G_MISS_CHAR

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
30: := FND_API.G_MISS_NUM

Line 28: := FND_API.G_MISS_NUM

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
32: := FND_API.G_MISS_NUM

Line 30: := FND_API.G_MISS_NUM

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
34: := FND_API.G_MISS_NUM

Line 32: := FND_API.G_MISS_NUM

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
36: := FND_API.G_MISS_CHAR

Line 34: := FND_API.G_MISS_NUM

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
38: := FND_API.G_MISS_NUM

Line 36: := FND_API.G_MISS_CHAR

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
40: := FND_API.G_MISS_NUM

Line 38: := FND_API.G_MISS_NUM

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
42: := FND_API.G_MISS_NUM

Line 40: := FND_API.G_MISS_NUM

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
44: := FND_API.G_MISS_NUM

Line 42: := FND_API.G_MISS_NUM

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
46: := FND_API.G_MISS_NUM

Line 44: := FND_API.G_MISS_NUM

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
48: := FND_API.G_MISS_NUM

Line 46: := FND_API.G_MISS_NUM

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
50: := FND_API.G_MISS_NUM

Line 48: := FND_API.G_MISS_NUM

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
52: := FND_API.G_MISS_NUM

Line 50: := FND_API.G_MISS_NUM

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
54: := FND_API.G_MISS_NUM

Line 52: := FND_API.G_MISS_NUM

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
56: := FND_API.G_MISS_NUM

Line 54: := FND_API.G_MISS_NUM

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
58: := FND_API.G_MISS_NUM

Line 56: := FND_API.G_MISS_NUM

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
60: := FND_API.G_MISS_NUM

Line 58: := FND_API.G_MISS_NUM

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
62: := FND_API.G_MISS_NUM

Line 60: := FND_API.G_MISS_NUM

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
64: := FND_API.G_MISS_NUM

Line 62: := FND_API.G_MISS_NUM

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
66: := FND_API.G_MISS_NUM

Line 64: := FND_API.G_MISS_NUM

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
68: := FND_API.G_MISS_NUM

Line 66: := FND_API.G_MISS_NUM

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
70: := FND_API.G_MISS_NUM

Line 68: := FND_API.G_MISS_NUM

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
72: := FND_API.G_MISS_NUM

Line 70: := FND_API.G_MISS_NUM

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
74: := FND_API.G_MISS_NUM

Line 72: := FND_API.G_MISS_NUM

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
76: := FND_API.G_MISS_NUM

Line 74: := FND_API.G_MISS_NUM

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
78: := FND_API.G_MISS_CHAR

Line 76: := FND_API.G_MISS_NUM

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
80: ,p_total_project_raw_cost IN pa_resource_assignments.total_project_raw_cost%TYPE

Line 78: := FND_API.G_MISS_CHAR

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
82: ,p_total_project_burdened_cost IN pa_resource_assignments.total_project_burdened_cost%TYPE

Line 81: := 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
85: := FND_API.G_MISS_NUM

Line 83: := FND_API.G_MISS_NUM

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
87: := FND_API.G_MISS_NUM

Line 85: := FND_API.G_MISS_NUM

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
89: ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895

Line 87: := FND_API.G_MISS_NUM

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

Line 94: := FND_API.G_MISS_NUM

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
98: := FND_API.G_MISS_NUM

Line 96: := FND_API.G_MISS_NUM

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
100: := FND_API.G_MISS_NUM

Line 98: := FND_API.G_MISS_NUM

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
102: := FND_API.G_MISS_NUM

Line 100: := FND_API.G_MISS_NUM

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
104: := FND_API.G_MISS_CHAR

Line 102: := FND_API.G_MISS_NUM

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
106: := FND_API.G_MISS_CHAR

Line 104: := FND_API.G_MISS_CHAR

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
108: := FND_API.G_MISS_NUM

Line 106: := FND_API.G_MISS_CHAR

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
110: := FND_API.G_MISS_NUM

Line 108: := FND_API.G_MISS_NUM

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
112: := FND_API.G_MISS_NUM

Line 110: := FND_API.G_MISS_NUM

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
114: := FND_API.G_MISS_NUM

Line 112: := FND_API.G_MISS_NUM

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
116: := FND_API.G_MISS_CHAR

Line 114: := FND_API.G_MISS_NUM

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
118: := FND_API.G_MISS_NUM

Line 116: := FND_API.G_MISS_CHAR

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
120: := FND_API.G_MISS_NUM

Line 118: := FND_API.G_MISS_NUM

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
122: := FND_API.G_MISS_NUM

Line 120: := FND_API.G_MISS_NUM

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
124: := FND_API.G_MISS_NUM

Line 122: := FND_API.G_MISS_NUM

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
126: := FND_API.G_MISS_NUM

Line 124: := FND_API.G_MISS_NUM

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
128: := FND_API.G_MISS_NUM

Line 126: := FND_API.G_MISS_NUM

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
130: := FND_API.G_MISS_NUM

Line 128: := FND_API.G_MISS_NUM

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
132: := FND_API.G_MISS_NUM

Line 130: := FND_API.G_MISS_NUM

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
134: := FND_API.G_MISS_NUM

Line 132: := FND_API.G_MISS_NUM

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
136: := FND_API.G_MISS_NUM

Line 134: := FND_API.G_MISS_NUM

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
138: := FND_API.G_MISS_NUM

Line 136: := FND_API.G_MISS_NUM

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
140: := FND_API.G_MISS_NUM

Line 138: := FND_API.G_MISS_NUM

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
142: := FND_API.G_MISS_NUM

Line 140: := FND_API.G_MISS_NUM

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
144: := FND_API.G_MISS_NUM

Line 142: := FND_API.G_MISS_NUM

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
146: := FND_API.G_MISS_NUM

Line 144: := FND_API.G_MISS_NUM

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
148: := FND_API.G_MISS_NUM

Line 146: := FND_API.G_MISS_NUM

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
150: := FND_API.G_MISS_NUM

Line 148: := FND_API.G_MISS_NUM

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
152: := FND_API.G_MISS_NUM

Line 150: := FND_API.G_MISS_NUM

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
154: := FND_API.G_MISS_NUM

Line 152: := FND_API.G_MISS_NUM

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
156: := FND_API.G_MISS_NUM

Line 154: := FND_API.G_MISS_NUM

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
158: := FND_API.G_MISS_CHAR

Line 156: := FND_API.G_MISS_NUM

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
160: ,p_total_project_raw_cost IN pa_resource_assignments.total_project_raw_cost%TYPE

Line 158: := FND_API.G_MISS_CHAR

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
162: ,p_total_project_burdened_cost IN pa_resource_assignments.total_project_burdened_cost%TYPE

Line 161: := 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
165: := FND_API.G_MISS_NUM

Line 163: := FND_API.G_MISS_NUM

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
167: := FND_API.G_MISS_NUM

Line 165: := FND_API.G_MISS_NUM

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
169: ,p_row_id IN ROWID

Line 167: := FND_API.G_MISS_NUM

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
171: ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 175: := FND_API.G_MISS_NUM

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

Line 182: := FND_API.G_MISS_NUM

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