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 18: ( px_resource_assignment_id IN OUT NOCOPY pa_resource_assignments.resource_assignment_id%TYPE --File.Sql.39 bug 4440895

14: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PA_FP_RESOURCE_ASSIGNMENTS_PKG';
15: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pafpratb.pls';
16:
17: PROCEDURE Insert_Row
18: ( px_resource_assignment_id IN OUT NOCOPY pa_resource_assignments.resource_assignment_id%TYPE --File.Sql.39 bug 4440895
19: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
20: := FND_API.G_MISS_NUM
21: ,p_project_id IN pa_resource_assignments.project_id%TYPE
22: := FND_API.G_MISS_NUM

Line 19: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE

15: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pafpratb.pls';
16:
17: PROCEDURE Insert_Row
18: ( px_resource_assignment_id IN OUT NOCOPY pa_resource_assignments.resource_assignment_id%TYPE --File.Sql.39 bug 4440895
19: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
20: := FND_API.G_MISS_NUM
21: ,p_project_id IN pa_resource_assignments.project_id%TYPE
22: := FND_API.G_MISS_NUM
23: ,p_task_id IN pa_resource_assignments.task_id%TYPE

Line 21: ,p_project_id IN pa_resource_assignments.project_id%TYPE

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

Line 23: ,p_task_id IN pa_resource_assignments.task_id%TYPE

19: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
20: := FND_API.G_MISS_NUM
21: ,p_project_id IN pa_resource_assignments.project_id%TYPE
22: := FND_API.G_MISS_NUM
23: ,p_task_id IN pa_resource_assignments.task_id%TYPE
24: := FND_API.G_MISS_NUM
25: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
26: := FND_API.G_MISS_NUM
27: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE

Line 25: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE

21: ,p_project_id IN pa_resource_assignments.project_id%TYPE
22: := FND_API.G_MISS_NUM
23: ,p_task_id IN pa_resource_assignments.task_id%TYPE
24: := FND_API.G_MISS_NUM
25: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
26: := FND_API.G_MISS_NUM
27: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
28: := FND_API.G_MISS_CHAR
29: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE

Line 27: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE

23: ,p_task_id IN pa_resource_assignments.task_id%TYPE
24: := FND_API.G_MISS_NUM
25: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
26: := FND_API.G_MISS_NUM
27: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
28: := FND_API.G_MISS_CHAR
29: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE
30: := FND_API.G_MISS_CHAR
31: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE

Line 29: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE

25: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
26: := FND_API.G_MISS_NUM
27: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
28: := FND_API.G_MISS_CHAR
29: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE
30: := FND_API.G_MISS_CHAR
31: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE
32: := FND_API.G_MISS_NUM
33: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE

Line 31: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE

27: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
28: := FND_API.G_MISS_CHAR
29: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE
30: := FND_API.G_MISS_CHAR
31: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE
32: := FND_API.G_MISS_NUM
33: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE
34: := FND_API.G_MISS_NUM
35: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE

Line 33: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE

29: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE
30: := FND_API.G_MISS_CHAR
31: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE
32: := FND_API.G_MISS_NUM
33: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE
34: := FND_API.G_MISS_NUM
35: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE
36: := FND_API.G_MISS_NUM
37: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE

Line 35: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE

31: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE
32: := FND_API.G_MISS_NUM
33: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE
34: := FND_API.G_MISS_NUM
35: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE
36: := FND_API.G_MISS_NUM
37: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE
38: := FND_API.G_MISS_NUM
39: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE

Line 37: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE

33: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE
34: := FND_API.G_MISS_NUM
35: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE
36: := FND_API.G_MISS_NUM
37: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE
38: := FND_API.G_MISS_NUM
39: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE
40: := FND_API.G_MISS_CHAR
41: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE

Line 39: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE

35: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE
36: := FND_API.G_MISS_NUM
37: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE
38: := FND_API.G_MISS_NUM
39: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE
40: := FND_API.G_MISS_CHAR
41: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE
42: := FND_API.G_MISS_NUM
43: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE

Line 41: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE

37: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE
38: := FND_API.G_MISS_NUM
39: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE
40: := FND_API.G_MISS_CHAR
41: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE
42: := FND_API.G_MISS_NUM
43: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE
44: := FND_API.G_MISS_NUM
45: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE

Line 43: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE

39: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE
40: := FND_API.G_MISS_CHAR
41: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE
42: := FND_API.G_MISS_NUM
43: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE
44: := FND_API.G_MISS_NUM
45: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE
46: := FND_API.G_MISS_NUM
47: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE

Line 45: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE

41: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE
42: := FND_API.G_MISS_NUM
43: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE
44: := FND_API.G_MISS_NUM
45: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE
46: := FND_API.G_MISS_NUM
47: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE
48: := FND_API.G_MISS_NUM
49: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE

Line 47: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE

43: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE
44: := FND_API.G_MISS_NUM
45: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE
46: := FND_API.G_MISS_NUM
47: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE
48: := FND_API.G_MISS_NUM
49: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE
50: := FND_API.G_MISS_NUM
51: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE

Line 49: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE

45: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE
46: := FND_API.G_MISS_NUM
47: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE
48: := FND_API.G_MISS_NUM
49: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE
50: := FND_API.G_MISS_NUM
51: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE
52: := FND_API.G_MISS_NUM
53: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE

Line 51: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE

47: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE
48: := FND_API.G_MISS_NUM
49: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE
50: := FND_API.G_MISS_NUM
51: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE
52: := FND_API.G_MISS_NUM
53: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE
54: := FND_API.G_MISS_NUM
55: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE

Line 53: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE

49: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE
50: := FND_API.G_MISS_NUM
51: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE
52: := FND_API.G_MISS_NUM
53: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE
54: := FND_API.G_MISS_NUM
55: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE
56: := FND_API.G_MISS_NUM
57: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE

Line 55: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE

51: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE
52: := FND_API.G_MISS_NUM
53: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE
54: := FND_API.G_MISS_NUM
55: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE
56: := FND_API.G_MISS_NUM
57: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE
58: := FND_API.G_MISS_NUM
59: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE

Line 57: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE

53: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE
54: := FND_API.G_MISS_NUM
55: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE
56: := FND_API.G_MISS_NUM
57: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE
58: := FND_API.G_MISS_NUM
59: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE
60: := FND_API.G_MISS_NUM
61: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE

Line 59: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE

55: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE
56: := FND_API.G_MISS_NUM
57: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE
58: := FND_API.G_MISS_NUM
59: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE
60: := FND_API.G_MISS_NUM
61: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE
62: := FND_API.G_MISS_NUM
63: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE

Line 61: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE

57: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE
58: := FND_API.G_MISS_NUM
59: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE
60: := FND_API.G_MISS_NUM
61: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE
62: := FND_API.G_MISS_NUM
63: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE
64: := FND_API.G_MISS_NUM
65: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE

Line 63: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE

59: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE
60: := FND_API.G_MISS_NUM
61: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE
62: := FND_API.G_MISS_NUM
63: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE
64: := FND_API.G_MISS_NUM
65: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE
66: := FND_API.G_MISS_NUM
67: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE

Line 65: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE

61: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE
62: := FND_API.G_MISS_NUM
63: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE
64: := FND_API.G_MISS_NUM
65: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE
66: := FND_API.G_MISS_NUM
67: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE
68: := FND_API.G_MISS_NUM
69: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE

Line 67: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE

63: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE
64: := FND_API.G_MISS_NUM
65: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE
66: := FND_API.G_MISS_NUM
67: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE
68: := FND_API.G_MISS_NUM
69: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE
70: := FND_API.G_MISS_NUM
71: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE

Line 69: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE

65: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE
66: := FND_API.G_MISS_NUM
67: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE
68: := FND_API.G_MISS_NUM
69: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE
70: := FND_API.G_MISS_NUM
71: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE
72: := FND_API.G_MISS_NUM
73: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE

Line 71: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE

67: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE
68: := FND_API.G_MISS_NUM
69: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE
70: := FND_API.G_MISS_NUM
71: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE
72: := FND_API.G_MISS_NUM
73: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE
74: := FND_API.G_MISS_NUM
75: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE

Line 73: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE

69: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE
70: := FND_API.G_MISS_NUM
71: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE
72: := FND_API.G_MISS_NUM
73: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE
74: := FND_API.G_MISS_NUM
75: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE
76: := FND_API.G_MISS_NUM
77: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE

Line 75: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE

71: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE
72: := FND_API.G_MISS_NUM
73: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE
74: := FND_API.G_MISS_NUM
75: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE
76: := FND_API.G_MISS_NUM
77: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE
78: := FND_API.G_MISS_NUM
79: ,p_total_head_count_adj IN pa_resource_assignments.total_head_count_adj%TYPE

Line 77: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE

73: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE
74: := FND_API.G_MISS_NUM
75: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE
76: := FND_API.G_MISS_NUM
77: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE
78: := FND_API.G_MISS_NUM
79: ,p_total_head_count_adj IN pa_resource_assignments.total_head_count_adj%TYPE
80: := FND_API.G_MISS_NUM
81: ,p_resource_assignment_type IN pa_resource_assignments.resource_assignment_type%TYPE

Line 79: ,p_total_head_count_adj IN pa_resource_assignments.total_head_count_adj%TYPE

75: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE
76: := FND_API.G_MISS_NUM
77: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE
78: := FND_API.G_MISS_NUM
79: ,p_total_head_count_adj IN pa_resource_assignments.total_head_count_adj%TYPE
80: := FND_API.G_MISS_NUM
81: ,p_resource_assignment_type IN pa_resource_assignments.resource_assignment_type%TYPE
82: := FND_API.G_MISS_CHAR
83: -- start of changes of Bug:- 2634900

Line 81: ,p_resource_assignment_type IN pa_resource_assignments.resource_assignment_type%TYPE

77: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE
78: := FND_API.G_MISS_NUM
79: ,p_total_head_count_adj IN pa_resource_assignments.total_head_count_adj%TYPE
80: := FND_API.G_MISS_NUM
81: ,p_resource_assignment_type IN pa_resource_assignments.resource_assignment_type%TYPE
82: := FND_API.G_MISS_CHAR
83: -- start of changes of Bug:- 2634900
84: ,p_total_project_raw_cost IN pa_resource_assignments.total_project_raw_cost%TYPE
85: := FND_API.G_MISS_NUM

Line 84: ,p_total_project_raw_cost IN pa_resource_assignments.total_project_raw_cost%TYPE

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

Line 86: ,p_total_project_burdened_cost IN pa_resource_assignments.total_project_burdened_cost%TYPE

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

Line 88: ,p_total_project_revenue IN pa_resource_assignments.total_project_revenue%TYPE

84: ,p_total_project_raw_cost IN pa_resource_assignments.total_project_raw_cost%TYPE
85: := FND_API.G_MISS_NUM
86: ,p_total_project_burdened_cost IN pa_resource_assignments.total_project_burdened_cost%TYPE
87: := FND_API.G_MISS_NUM
88: ,p_total_project_revenue IN pa_resource_assignments.total_project_revenue%TYPE
89: := FND_API.G_MISS_NUM
90: ,p_parent_assignment_id IN pa_resource_assignments.parent_assignment_id%TYPE
91: := FND_API.G_MISS_NUM
92: -- end of changes of Bug:- 2634900

Line 90: ,p_parent_assignment_id IN pa_resource_assignments.parent_assignment_id%TYPE

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

Line 96: CURSOR C2 IS SELECT pa_resource_assignments_s.nextval FROM sys.dual;

92: -- end of changes of Bug:- 2634900
93: ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
94: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
95: IS
96: CURSOR C2 IS SELECT pa_resource_assignments_s.nextval FROM sys.dual;
97: BEGIN
98: x_return_status := FND_API.G_RET_STS_SUCCESS;
99:
100: IF (px_resource_assignment_id IS NULL) OR

Line 107: INSERT INTO pa_resource_assignments(

103: FETCH C2 INTO px_resource_assignment_id;
104: CLOSE C2;
105: END IF;
106:
107: INSERT INTO pa_resource_assignments(
108: resource_assignment_id
109: ,budget_version_id
110: ,project_id
111: ,task_id

Line 233: ( p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE

229: RAISE;
230: End Insert_Row;
231:
232: PROCEDURE Update_Row
233: ( p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
234: := FND_API.G_MISS_NUM
235: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
236: := FND_API.G_MISS_NUM
237: ,p_project_id IN pa_resource_assignments.project_id%TYPE

Line 235: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE

231:
232: PROCEDURE Update_Row
233: ( p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
234: := FND_API.G_MISS_NUM
235: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
236: := FND_API.G_MISS_NUM
237: ,p_project_id IN pa_resource_assignments.project_id%TYPE
238: := FND_API.G_MISS_NUM
239: ,p_task_id IN pa_resource_assignments.task_id%TYPE

Line 237: ,p_project_id IN pa_resource_assignments.project_id%TYPE

233: ( p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
234: := FND_API.G_MISS_NUM
235: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
236: := FND_API.G_MISS_NUM
237: ,p_project_id IN pa_resource_assignments.project_id%TYPE
238: := FND_API.G_MISS_NUM
239: ,p_task_id IN pa_resource_assignments.task_id%TYPE
240: := FND_API.G_MISS_NUM
241: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE

Line 239: ,p_task_id IN pa_resource_assignments.task_id%TYPE

235: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE
236: := FND_API.G_MISS_NUM
237: ,p_project_id IN pa_resource_assignments.project_id%TYPE
238: := FND_API.G_MISS_NUM
239: ,p_task_id IN pa_resource_assignments.task_id%TYPE
240: := FND_API.G_MISS_NUM
241: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
242: := FND_API.G_MISS_NUM
243: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE

Line 241: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE

237: ,p_project_id IN pa_resource_assignments.project_id%TYPE
238: := FND_API.G_MISS_NUM
239: ,p_task_id IN pa_resource_assignments.task_id%TYPE
240: := FND_API.G_MISS_NUM
241: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
242: := FND_API.G_MISS_NUM
243: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
244: := FND_API.G_MISS_CHAR
245: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE

Line 243: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE

239: ,p_task_id IN pa_resource_assignments.task_id%TYPE
240: := FND_API.G_MISS_NUM
241: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
242: := FND_API.G_MISS_NUM
243: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
244: := FND_API.G_MISS_CHAR
245: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE
246: := FND_API.G_MISS_CHAR
247: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE

Line 245: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE

241: ,p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE
242: := FND_API.G_MISS_NUM
243: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
244: := FND_API.G_MISS_CHAR
245: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE
246: := FND_API.G_MISS_CHAR
247: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE
248: := FND_API.G_MISS_NUM
249: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE

Line 247: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE

243: ,p_unit_of_measure IN pa_resource_assignments.unit_of_measure%TYPE
244: := FND_API.G_MISS_CHAR
245: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE
246: := FND_API.G_MISS_CHAR
247: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE
248: := FND_API.G_MISS_NUM
249: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE
250: := FND_API.G_MISS_NUM
251: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE

Line 249: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE

245: ,p_track_as_labor_flag IN pa_resource_assignments.track_as_labor_flag%TYPE
246: := FND_API.G_MISS_CHAR
247: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE
248: := FND_API.G_MISS_NUM
249: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE
250: := FND_API.G_MISS_NUM
251: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE
252: := FND_API.G_MISS_NUM
253: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE

Line 251: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE

247: ,p_standard_bill_rate IN pa_resource_assignments.standard_bill_rate%TYPE
248: := FND_API.G_MISS_NUM
249: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE
250: := FND_API.G_MISS_NUM
251: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE
252: := FND_API.G_MISS_NUM
253: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE
254: := FND_API.G_MISS_NUM
255: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE

Line 253: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE

249: ,p_average_bill_rate IN pa_resource_assignments.average_bill_rate%TYPE
250: := FND_API.G_MISS_NUM
251: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE
252: := FND_API.G_MISS_NUM
253: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE
254: := FND_API.G_MISS_NUM
255: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE
256: := FND_API.G_MISS_CHAR
257: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE

Line 255: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE

251: ,p_average_cost_rate IN pa_resource_assignments.average_cost_rate%TYPE
252: := FND_API.G_MISS_NUM
253: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE
254: := FND_API.G_MISS_NUM
255: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE
256: := FND_API.G_MISS_CHAR
257: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE
258: := FND_API.G_MISS_NUM
259: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE

Line 257: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE

253: ,p_project_assignment_id IN pa_resource_assignments.project_assignment_id%TYPE
254: := FND_API.G_MISS_NUM
255: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE
256: := FND_API.G_MISS_CHAR
257: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE
258: := FND_API.G_MISS_NUM
259: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE
260: := FND_API.G_MISS_NUM
261: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE

Line 259: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE

255: ,p_plan_error_code IN pa_resource_assignments.plan_error_code%TYPE
256: := FND_API.G_MISS_CHAR
257: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE
258: := FND_API.G_MISS_NUM
259: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE
260: := FND_API.G_MISS_NUM
261: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE
262: := FND_API.G_MISS_NUM
263: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE

Line 261: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE

257: ,p_total_plan_revenue IN pa_resource_assignments.total_plan_revenue%TYPE
258: := FND_API.G_MISS_NUM
259: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE
260: := FND_API.G_MISS_NUM
261: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE
262: := FND_API.G_MISS_NUM
263: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE
264: := FND_API.G_MISS_NUM
265: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE

Line 263: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE

259: ,p_total_plan_raw_cost IN pa_resource_assignments.total_plan_raw_cost%TYPE
260: := FND_API.G_MISS_NUM
261: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE
262: := FND_API.G_MISS_NUM
263: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE
264: := FND_API.G_MISS_NUM
265: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE
266: := FND_API.G_MISS_NUM
267: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE

Line 265: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE

261: ,p_total_plan_burdened_cost IN pa_resource_assignments.total_plan_burdened_cost%TYPE
262: := FND_API.G_MISS_NUM
263: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE
264: := FND_API.G_MISS_NUM
265: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE
266: := FND_API.G_MISS_NUM
267: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE
268: := FND_API.G_MISS_NUM
269: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE

Line 267: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE

263: ,p_total_plan_quantity IN pa_resource_assignments.total_plan_quantity%TYPE
264: := FND_API.G_MISS_NUM
265: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE
266: := FND_API.G_MISS_NUM
267: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE
268: := FND_API.G_MISS_NUM
269: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE
270: := FND_API.G_MISS_NUM
271: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE

Line 269: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE

265: ,p_average_discount_percentage IN pa_resource_assignments.average_discount_percentage%TYPE
266: := FND_API.G_MISS_NUM
267: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE
268: := FND_API.G_MISS_NUM
269: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE
270: := FND_API.G_MISS_NUM
271: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE
272: := FND_API.G_MISS_NUM
273: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE

Line 271: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE

267: ,p_total_borrowed_revenue IN pa_resource_assignments.total_borrowed_revenue%TYPE
268: := FND_API.G_MISS_NUM
269: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE
270: := FND_API.G_MISS_NUM
271: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE
272: := FND_API.G_MISS_NUM
273: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE
274: := FND_API.G_MISS_NUM
275: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE

Line 273: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE

269: ,p_total_tp_revenue_in IN pa_resource_assignments.total_tp_revenue_in%TYPE
270: := FND_API.G_MISS_NUM
271: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE
272: := FND_API.G_MISS_NUM
273: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE
274: := FND_API.G_MISS_NUM
275: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE
276: := FND_API.G_MISS_NUM
277: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE

Line 275: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE

271: ,p_total_tp_revenue_out IN pa_resource_assignments.total_tp_revenue_out%TYPE
272: := FND_API.G_MISS_NUM
273: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE
274: := FND_API.G_MISS_NUM
275: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE
276: := FND_API.G_MISS_NUM
277: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE
278: := FND_API.G_MISS_NUM
279: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE

Line 277: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE

273: ,p_total_revenue_adj IN pa_resource_assignments.total_revenue_adj%TYPE
274: := FND_API.G_MISS_NUM
275: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE
276: := FND_API.G_MISS_NUM
277: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE
278: := FND_API.G_MISS_NUM
279: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE
280: := FND_API.G_MISS_NUM
281: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE

Line 279: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE

275: ,p_total_lent_resource_cost IN pa_resource_assignments.total_lent_resource_cost%TYPE
276: := FND_API.G_MISS_NUM
277: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE
278: := FND_API.G_MISS_NUM
279: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE
280: := FND_API.G_MISS_NUM
281: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE
282: := FND_API.G_MISS_NUM
283: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE

Line 281: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE

277: ,p_total_tp_cost_in IN pa_resource_assignments.total_tp_cost_in%TYPE
278: := FND_API.G_MISS_NUM
279: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE
280: := FND_API.G_MISS_NUM
281: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE
282: := FND_API.G_MISS_NUM
283: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE
284: := FND_API.G_MISS_NUM
285: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE

Line 283: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE

279: ,p_total_tp_cost_out IN pa_resource_assignments.total_tp_cost_out%TYPE
280: := FND_API.G_MISS_NUM
281: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE
282: := FND_API.G_MISS_NUM
283: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE
284: := FND_API.G_MISS_NUM
285: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE
286: := FND_API.G_MISS_NUM
287: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE

Line 285: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE

281: ,p_total_cost_adj IN pa_resource_assignments.total_cost_adj%TYPE
282: := FND_API.G_MISS_NUM
283: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE
284: := FND_API.G_MISS_NUM
285: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE
286: := FND_API.G_MISS_NUM
287: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE
288: := FND_API.G_MISS_NUM
289: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE

Line 287: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE

283: ,p_total_unassigned_time_cost IN pa_resource_assignments.total_unassigned_time_cost%TYPE
284: := FND_API.G_MISS_NUM
285: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE
286: := FND_API.G_MISS_NUM
287: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE
288: := FND_API.G_MISS_NUM
289: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE
290: := FND_API.G_MISS_NUM
291: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE

Line 289: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE

285: ,p_total_utilization_percent IN pa_resource_assignments.total_utilization_percent%TYPE
286: := FND_API.G_MISS_NUM
287: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE
288: := FND_API.G_MISS_NUM
289: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE
290: := FND_API.G_MISS_NUM
291: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE
292: := FND_API.G_MISS_NUM
293: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE

Line 291: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE

287: ,p_total_utilization_hours IN pa_resource_assignments.total_utilization_hours%TYPE
288: := FND_API.G_MISS_NUM
289: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE
290: := FND_API.G_MISS_NUM
291: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE
292: := FND_API.G_MISS_NUM
293: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE
294: := FND_API.G_MISS_NUM
295: ,p_total_head_count_adj IN pa_resource_assignments.total_head_count_adj%TYPE

Line 293: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE

289: ,p_total_utilization_adj IN pa_resource_assignments.total_utilization_adj%TYPE
290: := FND_API.G_MISS_NUM
291: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE
292: := FND_API.G_MISS_NUM
293: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE
294: := FND_API.G_MISS_NUM
295: ,p_total_head_count_adj IN pa_resource_assignments.total_head_count_adj%TYPE
296: := FND_API.G_MISS_NUM
297: ,p_resource_assignment_type IN pa_resource_assignments.resource_assignment_type%TYPE

Line 295: ,p_total_head_count_adj IN pa_resource_assignments.total_head_count_adj%TYPE

291: ,p_total_capacity IN pa_resource_assignments.total_capacity%TYPE
292: := FND_API.G_MISS_NUM
293: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE
294: := FND_API.G_MISS_NUM
295: ,p_total_head_count_adj IN pa_resource_assignments.total_head_count_adj%TYPE
296: := FND_API.G_MISS_NUM
297: ,p_resource_assignment_type IN pa_resource_assignments.resource_assignment_type%TYPE
298: := FND_API.G_MISS_CHAR
299: -- start of changes of Bug:- 2634900

Line 297: ,p_resource_assignment_type IN pa_resource_assignments.resource_assignment_type%TYPE

293: ,p_total_head_count IN pa_resource_assignments.total_head_count%TYPE
294: := FND_API.G_MISS_NUM
295: ,p_total_head_count_adj IN pa_resource_assignments.total_head_count_adj%TYPE
296: := FND_API.G_MISS_NUM
297: ,p_resource_assignment_type IN pa_resource_assignments.resource_assignment_type%TYPE
298: := FND_API.G_MISS_CHAR
299: -- start of changes of Bug:- 2634900
300: ,p_total_project_raw_cost IN pa_resource_assignments.total_project_raw_cost%TYPE
301: := FND_API.G_MISS_NUM

Line 300: ,p_total_project_raw_cost IN pa_resource_assignments.total_project_raw_cost%TYPE

296: := FND_API.G_MISS_NUM
297: ,p_resource_assignment_type IN pa_resource_assignments.resource_assignment_type%TYPE
298: := FND_API.G_MISS_CHAR
299: -- start of changes of Bug:- 2634900
300: ,p_total_project_raw_cost IN pa_resource_assignments.total_project_raw_cost%TYPE
301: := FND_API.G_MISS_NUM
302: ,p_total_project_burdened_cost IN pa_resource_assignments.total_project_burdened_cost%TYPE
303: := FND_API.G_MISS_NUM
304: ,p_total_project_revenue IN pa_resource_assignments.total_project_revenue%TYPE

Line 302: ,p_total_project_burdened_cost IN pa_resource_assignments.total_project_burdened_cost%TYPE

298: := FND_API.G_MISS_CHAR
299: -- start of changes of Bug:- 2634900
300: ,p_total_project_raw_cost IN pa_resource_assignments.total_project_raw_cost%TYPE
301: := FND_API.G_MISS_NUM
302: ,p_total_project_burdened_cost IN pa_resource_assignments.total_project_burdened_cost%TYPE
303: := FND_API.G_MISS_NUM
304: ,p_total_project_revenue IN pa_resource_assignments.total_project_revenue%TYPE
305: := FND_API.G_MISS_NUM
306: ,p_parent_assignment_id IN pa_resource_assignments.parent_assignment_id%TYPE

Line 304: ,p_total_project_revenue IN pa_resource_assignments.total_project_revenue%TYPE

300: ,p_total_project_raw_cost IN pa_resource_assignments.total_project_raw_cost%TYPE
301: := FND_API.G_MISS_NUM
302: ,p_total_project_burdened_cost IN pa_resource_assignments.total_project_burdened_cost%TYPE
303: := FND_API.G_MISS_NUM
304: ,p_total_project_revenue IN pa_resource_assignments.total_project_revenue%TYPE
305: := FND_API.G_MISS_NUM
306: ,p_parent_assignment_id IN pa_resource_assignments.parent_assignment_id%TYPE
307: := FND_API.G_MISS_NUM
308: -- end of changes of Bug:- 2634900

Line 306: ,p_parent_assignment_id IN pa_resource_assignments.parent_assignment_id%TYPE

302: ,p_total_project_burdened_cost IN pa_resource_assignments.total_project_burdened_cost%TYPE
303: := FND_API.G_MISS_NUM
304: ,p_total_project_revenue IN pa_resource_assignments.total_project_revenue%TYPE
305: := FND_API.G_MISS_NUM
306: ,p_parent_assignment_id IN pa_resource_assignments.parent_assignment_id%TYPE
307: := FND_API.G_MISS_NUM
308: -- end of changes of Bug:- 2634900
309: ,p_row_id IN ROWID
310: := NULL

Line 314: UPDATE pa_resource_assignments

310: := NULL
311: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
312: IS
313: BEGIN
314: UPDATE pa_resource_assignments
315: SET
316: budget_version_id = DECODE( p_budget_version_id, FND_API.G_MISS_NUM,
317: budget_version_id, p_budget_version_id)
318: ,project_id = DECODE( p_project_id, FND_API.G_MISS_NUM, project_id,

Line 442: ( p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE

438: RAISE;
439: END Update_Row;
440:
441: PROCEDURE Lock_Row
442: ( p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
443: := FND_API.G_MISS_NUM
444: ,p_row_id IN ROWID
445: := NULL
446: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 454: FROM pa_resource_assignments

450:
451: BEGIN
452:
453: SELECT rowid into l_row_id
454: FROM pa_resource_assignments
455: WHERE resource_assignment_id = p_resource_assignment_id
456: OR rowid = p_row_id
457: FOR UPDATE NOWAIT;
458:

Line 470: ( p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE

466: RAISE;
467: END Lock_Row;
468:
469: PROCEDURE Delete_Row
470: ( p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
471: := FND_API.G_MISS_NUM
472: ,p_row_id IN ROWID
473: := NULL
474: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 479: DELETE FROM pa_resource_assignments

475: IS
476: BEGIN
477: IF (p_resource_assignment_id IS NOT NULL AND p_resource_assignment_id <>
478: FND_API.G_MISS_NUM) THEN
479: DELETE FROM pa_resource_assignments
480: WHERE resource_assignment_id = p_resource_assignment_id;
481: ELSIF (p_row_id IS NOT NULL) THEN
482: DELETE FROM pa_resource_assignments
483: WHERE rowid = p_row_id;

Line 482: DELETE FROM pa_resource_assignments

478: FND_API.G_MISS_NUM) THEN
479: DELETE FROM pa_resource_assignments
480: WHERE resource_assignment_id = p_resource_assignment_id;
481: ELSIF (p_row_id IS NOT NULL) THEN
482: DELETE FROM pa_resource_assignments
483: WHERE rowid = p_row_id;
484: END IF;
485:
486: IF (SQL%NOTFOUND) THEN