APPS.PA_FP_RESOURCE_ASSIGNMENTS_PKG dependencies on FND_API

Line 20: := FND_API.G_MISS_NUM

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

Line 22: := FND_API.G_MISS_NUM

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

Line 24: := FND_API.G_MISS_NUM

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

Line 26: := FND_API.G_MISS_NUM

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

Line 28: := FND_API.G_MISS_CHAR

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

Line 30: := FND_API.G_MISS_CHAR

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

Line 32: := FND_API.G_MISS_NUM

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

Line 34: := FND_API.G_MISS_NUM

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

Line 36: := FND_API.G_MISS_NUM

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

Line 38: := FND_API.G_MISS_NUM

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

Line 40: := FND_API.G_MISS_CHAR

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

Line 42: := FND_API.G_MISS_NUM

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

Line 44: := FND_API.G_MISS_NUM

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

Line 46: := FND_API.G_MISS_NUM

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

Line 48: := FND_API.G_MISS_NUM

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

Line 50: := FND_API.G_MISS_NUM

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

Line 52: := FND_API.G_MISS_NUM

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

Line 54: := FND_API.G_MISS_NUM

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

Line 56: := FND_API.G_MISS_NUM

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

Line 58: := FND_API.G_MISS_NUM

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

Line 60: := FND_API.G_MISS_NUM

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

Line 62: := FND_API.G_MISS_NUM

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

Line 64: := FND_API.G_MISS_NUM

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

Line 66: := FND_API.G_MISS_NUM

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

Line 68: := FND_API.G_MISS_NUM

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

Line 70: := FND_API.G_MISS_NUM

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

Line 72: := FND_API.G_MISS_NUM

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

Line 74: := FND_API.G_MISS_NUM

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

Line 76: := FND_API.G_MISS_NUM

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

Line 78: := FND_API.G_MISS_NUM

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

Line 80: := FND_API.G_MISS_NUM

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

Line 82: := FND_API.G_MISS_CHAR

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

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

Line 87: := FND_API.G_MISS_NUM

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

Line 89: := FND_API.G_MISS_NUM

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

Line 91: := FND_API.G_MISS_NUM

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
95: IS

Line 98: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
101: (px_resource_assignment_id = FND_API.G_MISS_NUM) then
102: OPEN C2;

Line 101: (px_resource_assignment_id = FND_API.G_MISS_NUM) then

97: BEGIN
98: x_return_status := FND_API.G_RET_STS_SUCCESS;
99:
100: IF (px_resource_assignment_id IS NULL) OR
101: (px_resource_assignment_id = FND_API.G_MISS_NUM) then
102: OPEN C2;
103: FETCH C2 INTO px_resource_assignment_id;
104: CLOSE C2;
105: END IF;

Line 154: ,DECODE( p_budget_version_id, FND_API.G_MISS_NUM, NULL, p_budget_version_id)

150: ,parent_assignment_id
151: -- end of changes of Bug:- 2634900
152: ) values (
153: px_resource_assignment_id
154: ,DECODE( p_budget_version_id, FND_API.G_MISS_NUM, NULL, p_budget_version_id)
155: ,DECODE( p_project_id, FND_API.G_MISS_NUM, NULL, p_project_id)
156: ,DECODE( p_task_id, FND_API.G_MISS_NUM, NULL, p_task_id)
157: ,DECODE( p_resource_list_member_id, FND_API.G_MISS_NUM, NULL,
158: p_resource_list_member_id)

Line 155: ,DECODE( p_project_id, FND_API.G_MISS_NUM, NULL, p_project_id)

151: -- end of changes of Bug:- 2634900
152: ) values (
153: px_resource_assignment_id
154: ,DECODE( p_budget_version_id, FND_API.G_MISS_NUM, NULL, p_budget_version_id)
155: ,DECODE( p_project_id, FND_API.G_MISS_NUM, NULL, p_project_id)
156: ,DECODE( p_task_id, FND_API.G_MISS_NUM, NULL, p_task_id)
157: ,DECODE( p_resource_list_member_id, FND_API.G_MISS_NUM, NULL,
158: p_resource_list_member_id)
159: ,sysdate

Line 156: ,DECODE( p_task_id, FND_API.G_MISS_NUM, NULL, p_task_id)

152: ) values (
153: px_resource_assignment_id
154: ,DECODE( p_budget_version_id, FND_API.G_MISS_NUM, NULL, p_budget_version_id)
155: ,DECODE( p_project_id, FND_API.G_MISS_NUM, NULL, p_project_id)
156: ,DECODE( p_task_id, FND_API.G_MISS_NUM, NULL, p_task_id)
157: ,DECODE( p_resource_list_member_id, FND_API.G_MISS_NUM, NULL,
158: p_resource_list_member_id)
159: ,sysdate
160: ,fnd_global.user_id

Line 157: ,DECODE( p_resource_list_member_id, FND_API.G_MISS_NUM, NULL,

153: px_resource_assignment_id
154: ,DECODE( p_budget_version_id, FND_API.G_MISS_NUM, NULL, p_budget_version_id)
155: ,DECODE( p_project_id, FND_API.G_MISS_NUM, NULL, p_project_id)
156: ,DECODE( p_task_id, FND_API.G_MISS_NUM, NULL, p_task_id)
157: ,DECODE( p_resource_list_member_id, FND_API.G_MISS_NUM, NULL,
158: p_resource_list_member_id)
159: ,sysdate
160: ,fnd_global.user_id
161: ,sysdate

Line 164: ,DECODE( p_unit_of_measure, FND_API.G_MISS_CHAR, NULL, p_unit_of_measure)

160: ,fnd_global.user_id
161: ,sysdate
162: ,fnd_global.user_id
163: ,fnd_global.login_id
164: ,DECODE( p_unit_of_measure, FND_API.G_MISS_CHAR, NULL, p_unit_of_measure)
165: ,DECODE( p_track_as_labor_flag, FND_API.G_MISS_CHAR, NULL,
166: p_track_as_labor_flag)
167: ,DECODE( p_standard_bill_rate, FND_API.G_MISS_NUM, NULL,
168: p_standard_bill_rate)

Line 165: ,DECODE( p_track_as_labor_flag, FND_API.G_MISS_CHAR, NULL,

161: ,sysdate
162: ,fnd_global.user_id
163: ,fnd_global.login_id
164: ,DECODE( p_unit_of_measure, FND_API.G_MISS_CHAR, NULL, p_unit_of_measure)
165: ,DECODE( p_track_as_labor_flag, FND_API.G_MISS_CHAR, NULL,
166: p_track_as_labor_flag)
167: ,DECODE( p_standard_bill_rate, FND_API.G_MISS_NUM, NULL,
168: p_standard_bill_rate)
169: ,DECODE( p_average_bill_rate, FND_API.G_MISS_NUM, NULL, p_average_bill_rate)

Line 167: ,DECODE( p_standard_bill_rate, FND_API.G_MISS_NUM, NULL,

163: ,fnd_global.login_id
164: ,DECODE( p_unit_of_measure, FND_API.G_MISS_CHAR, NULL, p_unit_of_measure)
165: ,DECODE( p_track_as_labor_flag, FND_API.G_MISS_CHAR, NULL,
166: p_track_as_labor_flag)
167: ,DECODE( p_standard_bill_rate, FND_API.G_MISS_NUM, NULL,
168: p_standard_bill_rate)
169: ,DECODE( p_average_bill_rate, FND_API.G_MISS_NUM, NULL, p_average_bill_rate)
170: ,DECODE( p_average_cost_rate, FND_API.G_MISS_NUM, NULL, p_average_cost_rate)
171: ,DECODE( p_project_assignment_id, FND_API.G_MISS_NUM, NULL,

Line 169: ,DECODE( p_average_bill_rate, FND_API.G_MISS_NUM, NULL, p_average_bill_rate)

165: ,DECODE( p_track_as_labor_flag, FND_API.G_MISS_CHAR, NULL,
166: p_track_as_labor_flag)
167: ,DECODE( p_standard_bill_rate, FND_API.G_MISS_NUM, NULL,
168: p_standard_bill_rate)
169: ,DECODE( p_average_bill_rate, FND_API.G_MISS_NUM, NULL, p_average_bill_rate)
170: ,DECODE( p_average_cost_rate, FND_API.G_MISS_NUM, NULL, p_average_cost_rate)
171: ,DECODE( p_project_assignment_id, FND_API.G_MISS_NUM, NULL,
172: p_project_assignment_id)
173: ,DECODE( p_plan_error_code, FND_API.G_MISS_CHAR, NULL, p_plan_error_code)

Line 170: ,DECODE( p_average_cost_rate, FND_API.G_MISS_NUM, NULL, p_average_cost_rate)

166: p_track_as_labor_flag)
167: ,DECODE( p_standard_bill_rate, FND_API.G_MISS_NUM, NULL,
168: p_standard_bill_rate)
169: ,DECODE( p_average_bill_rate, FND_API.G_MISS_NUM, NULL, p_average_bill_rate)
170: ,DECODE( p_average_cost_rate, FND_API.G_MISS_NUM, NULL, p_average_cost_rate)
171: ,DECODE( p_project_assignment_id, FND_API.G_MISS_NUM, NULL,
172: p_project_assignment_id)
173: ,DECODE( p_plan_error_code, FND_API.G_MISS_CHAR, NULL, p_plan_error_code)
174: ,DECODE( p_total_plan_revenue, FND_API.G_MISS_NUM, NULL,

Line 171: ,DECODE( p_project_assignment_id, FND_API.G_MISS_NUM, NULL,

167: ,DECODE( p_standard_bill_rate, FND_API.G_MISS_NUM, NULL,
168: p_standard_bill_rate)
169: ,DECODE( p_average_bill_rate, FND_API.G_MISS_NUM, NULL, p_average_bill_rate)
170: ,DECODE( p_average_cost_rate, FND_API.G_MISS_NUM, NULL, p_average_cost_rate)
171: ,DECODE( p_project_assignment_id, FND_API.G_MISS_NUM, NULL,
172: p_project_assignment_id)
173: ,DECODE( p_plan_error_code, FND_API.G_MISS_CHAR, NULL, p_plan_error_code)
174: ,DECODE( p_total_plan_revenue, FND_API.G_MISS_NUM, NULL,
175: p_total_plan_revenue)

Line 173: ,DECODE( p_plan_error_code, FND_API.G_MISS_CHAR, NULL, p_plan_error_code)

169: ,DECODE( p_average_bill_rate, FND_API.G_MISS_NUM, NULL, p_average_bill_rate)
170: ,DECODE( p_average_cost_rate, FND_API.G_MISS_NUM, NULL, p_average_cost_rate)
171: ,DECODE( p_project_assignment_id, FND_API.G_MISS_NUM, NULL,
172: p_project_assignment_id)
173: ,DECODE( p_plan_error_code, FND_API.G_MISS_CHAR, NULL, p_plan_error_code)
174: ,DECODE( p_total_plan_revenue, FND_API.G_MISS_NUM, NULL,
175: p_total_plan_revenue)
176: ,DECODE( p_total_plan_raw_cost, FND_API.G_MISS_NUM, NULL,
177: p_total_plan_raw_cost)

Line 174: ,DECODE( p_total_plan_revenue, FND_API.G_MISS_NUM, NULL,

170: ,DECODE( p_average_cost_rate, FND_API.G_MISS_NUM, NULL, p_average_cost_rate)
171: ,DECODE( p_project_assignment_id, FND_API.G_MISS_NUM, NULL,
172: p_project_assignment_id)
173: ,DECODE( p_plan_error_code, FND_API.G_MISS_CHAR, NULL, p_plan_error_code)
174: ,DECODE( p_total_plan_revenue, FND_API.G_MISS_NUM, NULL,
175: p_total_plan_revenue)
176: ,DECODE( p_total_plan_raw_cost, FND_API.G_MISS_NUM, NULL,
177: p_total_plan_raw_cost)
178: ,DECODE( p_total_plan_burdened_cost, FND_API.G_MISS_NUM, NULL,

Line 176: ,DECODE( p_total_plan_raw_cost, FND_API.G_MISS_NUM, NULL,

172: p_project_assignment_id)
173: ,DECODE( p_plan_error_code, FND_API.G_MISS_CHAR, NULL, p_plan_error_code)
174: ,DECODE( p_total_plan_revenue, FND_API.G_MISS_NUM, NULL,
175: p_total_plan_revenue)
176: ,DECODE( p_total_plan_raw_cost, FND_API.G_MISS_NUM, NULL,
177: p_total_plan_raw_cost)
178: ,DECODE( p_total_plan_burdened_cost, FND_API.G_MISS_NUM, NULL,
179: p_total_plan_burdened_cost)
180: ,DECODE( p_total_plan_quantity, FND_API.G_MISS_NUM, NULL,

Line 178: ,DECODE( p_total_plan_burdened_cost, FND_API.G_MISS_NUM, NULL,

174: ,DECODE( p_total_plan_revenue, FND_API.G_MISS_NUM, NULL,
175: p_total_plan_revenue)
176: ,DECODE( p_total_plan_raw_cost, FND_API.G_MISS_NUM, NULL,
177: p_total_plan_raw_cost)
178: ,DECODE( p_total_plan_burdened_cost, FND_API.G_MISS_NUM, NULL,
179: p_total_plan_burdened_cost)
180: ,DECODE( p_total_plan_quantity, FND_API.G_MISS_NUM, NULL,
181: p_total_plan_quantity)
182: ,DECODE( p_average_discount_percentage, FND_API.G_MISS_NUM, NULL,

Line 180: ,DECODE( p_total_plan_quantity, FND_API.G_MISS_NUM, NULL,

176: ,DECODE( p_total_plan_raw_cost, FND_API.G_MISS_NUM, NULL,
177: p_total_plan_raw_cost)
178: ,DECODE( p_total_plan_burdened_cost, FND_API.G_MISS_NUM, NULL,
179: p_total_plan_burdened_cost)
180: ,DECODE( p_total_plan_quantity, FND_API.G_MISS_NUM, NULL,
181: p_total_plan_quantity)
182: ,DECODE( p_average_discount_percentage, FND_API.G_MISS_NUM, NULL,
183: p_average_discount_percentage)
184: ,DECODE( p_total_borrowed_revenue, FND_API.G_MISS_NUM, NULL,

Line 182: ,DECODE( p_average_discount_percentage, FND_API.G_MISS_NUM, NULL,

178: ,DECODE( p_total_plan_burdened_cost, FND_API.G_MISS_NUM, NULL,
179: p_total_plan_burdened_cost)
180: ,DECODE( p_total_plan_quantity, FND_API.G_MISS_NUM, NULL,
181: p_total_plan_quantity)
182: ,DECODE( p_average_discount_percentage, FND_API.G_MISS_NUM, NULL,
183: p_average_discount_percentage)
184: ,DECODE( p_total_borrowed_revenue, FND_API.G_MISS_NUM, NULL,
185: p_total_borrowed_revenue)
186: ,DECODE( p_total_tp_revenue_in, FND_API.G_MISS_NUM, NULL,

Line 184: ,DECODE( p_total_borrowed_revenue, FND_API.G_MISS_NUM, NULL,

180: ,DECODE( p_total_plan_quantity, FND_API.G_MISS_NUM, NULL,
181: p_total_plan_quantity)
182: ,DECODE( p_average_discount_percentage, FND_API.G_MISS_NUM, NULL,
183: p_average_discount_percentage)
184: ,DECODE( p_total_borrowed_revenue, FND_API.G_MISS_NUM, NULL,
185: p_total_borrowed_revenue)
186: ,DECODE( p_total_tp_revenue_in, FND_API.G_MISS_NUM, NULL,
187: p_total_tp_revenue_in)
188: ,DECODE( p_total_tp_revenue_out, FND_API.G_MISS_NUM, NULL,

Line 186: ,DECODE( p_total_tp_revenue_in, FND_API.G_MISS_NUM, NULL,

182: ,DECODE( p_average_discount_percentage, FND_API.G_MISS_NUM, NULL,
183: p_average_discount_percentage)
184: ,DECODE( p_total_borrowed_revenue, FND_API.G_MISS_NUM, NULL,
185: p_total_borrowed_revenue)
186: ,DECODE( p_total_tp_revenue_in, FND_API.G_MISS_NUM, NULL,
187: p_total_tp_revenue_in)
188: ,DECODE( p_total_tp_revenue_out, FND_API.G_MISS_NUM, NULL,
189: p_total_tp_revenue_out)
190: ,DECODE( p_total_revenue_adj, FND_API.G_MISS_NUM, NULL, p_total_revenue_adj)

Line 188: ,DECODE( p_total_tp_revenue_out, FND_API.G_MISS_NUM, NULL,

184: ,DECODE( p_total_borrowed_revenue, FND_API.G_MISS_NUM, NULL,
185: p_total_borrowed_revenue)
186: ,DECODE( p_total_tp_revenue_in, FND_API.G_MISS_NUM, NULL,
187: p_total_tp_revenue_in)
188: ,DECODE( p_total_tp_revenue_out, FND_API.G_MISS_NUM, NULL,
189: p_total_tp_revenue_out)
190: ,DECODE( p_total_revenue_adj, FND_API.G_MISS_NUM, NULL, p_total_revenue_adj)
191: ,DECODE( p_total_lent_resource_cost, FND_API.G_MISS_NUM, NULL,
192: p_total_lent_resource_cost)

Line 190: ,DECODE( p_total_revenue_adj, FND_API.G_MISS_NUM, NULL, p_total_revenue_adj)

186: ,DECODE( p_total_tp_revenue_in, FND_API.G_MISS_NUM, NULL,
187: p_total_tp_revenue_in)
188: ,DECODE( p_total_tp_revenue_out, FND_API.G_MISS_NUM, NULL,
189: p_total_tp_revenue_out)
190: ,DECODE( p_total_revenue_adj, FND_API.G_MISS_NUM, NULL, p_total_revenue_adj)
191: ,DECODE( p_total_lent_resource_cost, FND_API.G_MISS_NUM, NULL,
192: p_total_lent_resource_cost)
193: ,DECODE( p_total_tp_cost_in, FND_API.G_MISS_NUM, NULL, p_total_tp_cost_in)
194: ,DECODE( p_total_tp_cost_out, FND_API.G_MISS_NUM, NULL, p_total_tp_cost_out)

Line 191: ,DECODE( p_total_lent_resource_cost, FND_API.G_MISS_NUM, NULL,

187: p_total_tp_revenue_in)
188: ,DECODE( p_total_tp_revenue_out, FND_API.G_MISS_NUM, NULL,
189: p_total_tp_revenue_out)
190: ,DECODE( p_total_revenue_adj, FND_API.G_MISS_NUM, NULL, p_total_revenue_adj)
191: ,DECODE( p_total_lent_resource_cost, FND_API.G_MISS_NUM, NULL,
192: p_total_lent_resource_cost)
193: ,DECODE( p_total_tp_cost_in, FND_API.G_MISS_NUM, NULL, p_total_tp_cost_in)
194: ,DECODE( p_total_tp_cost_out, FND_API.G_MISS_NUM, NULL, p_total_tp_cost_out)
195: ,DECODE( p_total_cost_adj, FND_API.G_MISS_NUM, NULL, p_total_cost_adj)

Line 193: ,DECODE( p_total_tp_cost_in, FND_API.G_MISS_NUM, NULL, p_total_tp_cost_in)

189: p_total_tp_revenue_out)
190: ,DECODE( p_total_revenue_adj, FND_API.G_MISS_NUM, NULL, p_total_revenue_adj)
191: ,DECODE( p_total_lent_resource_cost, FND_API.G_MISS_NUM, NULL,
192: p_total_lent_resource_cost)
193: ,DECODE( p_total_tp_cost_in, FND_API.G_MISS_NUM, NULL, p_total_tp_cost_in)
194: ,DECODE( p_total_tp_cost_out, FND_API.G_MISS_NUM, NULL, p_total_tp_cost_out)
195: ,DECODE( p_total_cost_adj, FND_API.G_MISS_NUM, NULL, p_total_cost_adj)
196: ,DECODE( p_total_unassigned_time_cost, FND_API.G_MISS_NUM, NULL,
197: p_total_unassigned_time_cost)

Line 194: ,DECODE( p_total_tp_cost_out, FND_API.G_MISS_NUM, NULL, p_total_tp_cost_out)

190: ,DECODE( p_total_revenue_adj, FND_API.G_MISS_NUM, NULL, p_total_revenue_adj)
191: ,DECODE( p_total_lent_resource_cost, FND_API.G_MISS_NUM, NULL,
192: p_total_lent_resource_cost)
193: ,DECODE( p_total_tp_cost_in, FND_API.G_MISS_NUM, NULL, p_total_tp_cost_in)
194: ,DECODE( p_total_tp_cost_out, FND_API.G_MISS_NUM, NULL, p_total_tp_cost_out)
195: ,DECODE( p_total_cost_adj, FND_API.G_MISS_NUM, NULL, p_total_cost_adj)
196: ,DECODE( p_total_unassigned_time_cost, FND_API.G_MISS_NUM, NULL,
197: p_total_unassigned_time_cost)
198: ,DECODE( p_total_utilization_percent, FND_API.G_MISS_NUM, NULL,

Line 195: ,DECODE( p_total_cost_adj, FND_API.G_MISS_NUM, NULL, p_total_cost_adj)

191: ,DECODE( p_total_lent_resource_cost, FND_API.G_MISS_NUM, NULL,
192: p_total_lent_resource_cost)
193: ,DECODE( p_total_tp_cost_in, FND_API.G_MISS_NUM, NULL, p_total_tp_cost_in)
194: ,DECODE( p_total_tp_cost_out, FND_API.G_MISS_NUM, NULL, p_total_tp_cost_out)
195: ,DECODE( p_total_cost_adj, FND_API.G_MISS_NUM, NULL, p_total_cost_adj)
196: ,DECODE( p_total_unassigned_time_cost, FND_API.G_MISS_NUM, NULL,
197: p_total_unassigned_time_cost)
198: ,DECODE( p_total_utilization_percent, FND_API.G_MISS_NUM, NULL,
199: p_total_utilization_percent)

Line 196: ,DECODE( p_total_unassigned_time_cost, FND_API.G_MISS_NUM, NULL,

192: p_total_lent_resource_cost)
193: ,DECODE( p_total_tp_cost_in, FND_API.G_MISS_NUM, NULL, p_total_tp_cost_in)
194: ,DECODE( p_total_tp_cost_out, FND_API.G_MISS_NUM, NULL, p_total_tp_cost_out)
195: ,DECODE( p_total_cost_adj, FND_API.G_MISS_NUM, NULL, p_total_cost_adj)
196: ,DECODE( p_total_unassigned_time_cost, FND_API.G_MISS_NUM, NULL,
197: p_total_unassigned_time_cost)
198: ,DECODE( p_total_utilization_percent, FND_API.G_MISS_NUM, NULL,
199: p_total_utilization_percent)
200: ,DECODE( p_total_utilization_hours, FND_API.G_MISS_NUM, NULL,

Line 198: ,DECODE( p_total_utilization_percent, FND_API.G_MISS_NUM, NULL,

194: ,DECODE( p_total_tp_cost_out, FND_API.G_MISS_NUM, NULL, p_total_tp_cost_out)
195: ,DECODE( p_total_cost_adj, FND_API.G_MISS_NUM, NULL, p_total_cost_adj)
196: ,DECODE( p_total_unassigned_time_cost, FND_API.G_MISS_NUM, NULL,
197: p_total_unassigned_time_cost)
198: ,DECODE( p_total_utilization_percent, FND_API.G_MISS_NUM, NULL,
199: p_total_utilization_percent)
200: ,DECODE( p_total_utilization_hours, FND_API.G_MISS_NUM, NULL,
201: p_total_utilization_hours)
202: ,DECODE( p_total_utilization_adj, FND_API.G_MISS_NUM, NULL,

Line 200: ,DECODE( p_total_utilization_hours, FND_API.G_MISS_NUM, NULL,

196: ,DECODE( p_total_unassigned_time_cost, FND_API.G_MISS_NUM, NULL,
197: p_total_unassigned_time_cost)
198: ,DECODE( p_total_utilization_percent, FND_API.G_MISS_NUM, NULL,
199: p_total_utilization_percent)
200: ,DECODE( p_total_utilization_hours, FND_API.G_MISS_NUM, NULL,
201: p_total_utilization_hours)
202: ,DECODE( p_total_utilization_adj, FND_API.G_MISS_NUM, NULL,
203: p_total_utilization_adj)
204: ,DECODE( p_total_capacity, FND_API.G_MISS_NUM, NULL, p_total_capacity)

Line 202: ,DECODE( p_total_utilization_adj, FND_API.G_MISS_NUM, NULL,

198: ,DECODE( p_total_utilization_percent, FND_API.G_MISS_NUM, NULL,
199: p_total_utilization_percent)
200: ,DECODE( p_total_utilization_hours, FND_API.G_MISS_NUM, NULL,
201: p_total_utilization_hours)
202: ,DECODE( p_total_utilization_adj, FND_API.G_MISS_NUM, NULL,
203: p_total_utilization_adj)
204: ,DECODE( p_total_capacity, FND_API.G_MISS_NUM, NULL, p_total_capacity)
205: ,DECODE( p_total_head_count, FND_API.G_MISS_NUM, NULL, p_total_head_count)
206: ,DECODE( p_total_head_count_adj, FND_API.G_MISS_NUM, NULL,

Line 204: ,DECODE( p_total_capacity, FND_API.G_MISS_NUM, NULL, p_total_capacity)

200: ,DECODE( p_total_utilization_hours, FND_API.G_MISS_NUM, NULL,
201: p_total_utilization_hours)
202: ,DECODE( p_total_utilization_adj, FND_API.G_MISS_NUM, NULL,
203: p_total_utilization_adj)
204: ,DECODE( p_total_capacity, FND_API.G_MISS_NUM, NULL, p_total_capacity)
205: ,DECODE( p_total_head_count, FND_API.G_MISS_NUM, NULL, p_total_head_count)
206: ,DECODE( p_total_head_count_adj, FND_API.G_MISS_NUM, NULL,
207: p_total_head_count_adj)
208: ,DECODE( p_resource_assignment_type, FND_API.G_MISS_CHAR, NULL,

Line 205: ,DECODE( p_total_head_count, FND_API.G_MISS_NUM, NULL, p_total_head_count)

201: p_total_utilization_hours)
202: ,DECODE( p_total_utilization_adj, FND_API.G_MISS_NUM, NULL,
203: p_total_utilization_adj)
204: ,DECODE( p_total_capacity, FND_API.G_MISS_NUM, NULL, p_total_capacity)
205: ,DECODE( p_total_head_count, FND_API.G_MISS_NUM, NULL, p_total_head_count)
206: ,DECODE( p_total_head_count_adj, FND_API.G_MISS_NUM, NULL,
207: p_total_head_count_adj)
208: ,DECODE( p_resource_assignment_type, FND_API.G_MISS_CHAR, NULL,
209: p_resource_assignment_type)

Line 206: ,DECODE( p_total_head_count_adj, FND_API.G_MISS_NUM, NULL,

202: ,DECODE( p_total_utilization_adj, FND_API.G_MISS_NUM, NULL,
203: p_total_utilization_adj)
204: ,DECODE( p_total_capacity, FND_API.G_MISS_NUM, NULL, p_total_capacity)
205: ,DECODE( p_total_head_count, FND_API.G_MISS_NUM, NULL, p_total_head_count)
206: ,DECODE( p_total_head_count_adj, FND_API.G_MISS_NUM, NULL,
207: p_total_head_count_adj)
208: ,DECODE( p_resource_assignment_type, FND_API.G_MISS_CHAR, NULL,
209: p_resource_assignment_type)
210: -- start of changes of Bug:- 2634900

Line 208: ,DECODE( p_resource_assignment_type, FND_API.G_MISS_CHAR, NULL,

204: ,DECODE( p_total_capacity, FND_API.G_MISS_NUM, NULL, p_total_capacity)
205: ,DECODE( p_total_head_count, FND_API.G_MISS_NUM, NULL, p_total_head_count)
206: ,DECODE( p_total_head_count_adj, FND_API.G_MISS_NUM, NULL,
207: p_total_head_count_adj)
208: ,DECODE( p_resource_assignment_type, FND_API.G_MISS_CHAR, NULL,
209: p_resource_assignment_type)
210: -- start of changes of Bug:- 2634900
211: ,DECODE( p_total_project_raw_cost, FND_API.G_MISS_NUM , NULL,
212: p_total_project_raw_cost)

Line 211: ,DECODE( p_total_project_raw_cost, FND_API.G_MISS_NUM , NULL,

207: p_total_head_count_adj)
208: ,DECODE( p_resource_assignment_type, FND_API.G_MISS_CHAR, NULL,
209: p_resource_assignment_type)
210: -- start of changes of Bug:- 2634900
211: ,DECODE( p_total_project_raw_cost, FND_API.G_MISS_NUM , NULL,
212: p_total_project_raw_cost)
213: ,DECODE( p_total_project_burdened_cost, FND_API.G_MISS_NUM , NULL,
214: p_total_project_burdened_cost)
215: ,DECODE( p_total_project_revenue, FND_API.G_MISS_NUM , NULL,

Line 213: ,DECODE( p_total_project_burdened_cost, FND_API.G_MISS_NUM , NULL,

209: p_resource_assignment_type)
210: -- start of changes of Bug:- 2634900
211: ,DECODE( p_total_project_raw_cost, FND_API.G_MISS_NUM , NULL,
212: p_total_project_raw_cost)
213: ,DECODE( p_total_project_burdened_cost, FND_API.G_MISS_NUM , NULL,
214: p_total_project_burdened_cost)
215: ,DECODE( p_total_project_revenue, FND_API.G_MISS_NUM , NULL,
216: p_total_project_revenue)
217: ,DECODE( p_parent_assignment_id, FND_API.G_MISS_NUM , NULL,

Line 215: ,DECODE( p_total_project_revenue, FND_API.G_MISS_NUM , NULL,

211: ,DECODE( p_total_project_raw_cost, FND_API.G_MISS_NUM , NULL,
212: p_total_project_raw_cost)
213: ,DECODE( p_total_project_burdened_cost, FND_API.G_MISS_NUM , NULL,
214: p_total_project_burdened_cost)
215: ,DECODE( p_total_project_revenue, FND_API.G_MISS_NUM , NULL,
216: p_total_project_revenue)
217: ,DECODE( p_parent_assignment_id, FND_API.G_MISS_NUM , NULL,
218: p_parent_assignment_id)
219: -- end of changes of Bug:- 2634900

Line 217: ,DECODE( p_parent_assignment_id, FND_API.G_MISS_NUM , NULL,

213: ,DECODE( p_total_project_burdened_cost, FND_API.G_MISS_NUM , NULL,
214: p_total_project_burdened_cost)
215: ,DECODE( p_total_project_revenue, FND_API.G_MISS_NUM , NULL,
216: p_total_project_revenue)
217: ,DECODE( p_parent_assignment_id, FND_API.G_MISS_NUM , NULL,
218: p_parent_assignment_id)
219: -- end of changes of Bug:- 2634900
220: );
221:

Line 228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

224: FND_MSG_PUB.add_exc_msg( p_pkg_name
225: => 'PA_FP_RESOURCE_ASSIGNMENTS_PKG.Insert_Row',
226: p_procedure_name
227: => PA_DEBUG.G_Err_Stack);
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: RAISE;
230: End Insert_Row;
231:
232: PROCEDURE Update_Row

Line 234: := FND_API.G_MISS_NUM

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

Line 236: := FND_API.G_MISS_NUM

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

Line 238: := FND_API.G_MISS_NUM

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

Line 240: := FND_API.G_MISS_NUM

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

Line 242: := FND_API.G_MISS_NUM

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

Line 244: := FND_API.G_MISS_CHAR

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

Line 246: := FND_API.G_MISS_CHAR

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

Line 248: := FND_API.G_MISS_NUM

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

Line 250: := FND_API.G_MISS_NUM

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

Line 252: := FND_API.G_MISS_NUM

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

Line 254: := FND_API.G_MISS_NUM

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

Line 256: := FND_API.G_MISS_CHAR

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

Line 258: := FND_API.G_MISS_NUM

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

Line 260: := FND_API.G_MISS_NUM

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

Line 262: := FND_API.G_MISS_NUM

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

Line 264: := FND_API.G_MISS_NUM

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

Line 266: := FND_API.G_MISS_NUM

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

Line 268: := FND_API.G_MISS_NUM

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

Line 270: := FND_API.G_MISS_NUM

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

Line 272: := FND_API.G_MISS_NUM

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

Line 274: := FND_API.G_MISS_NUM

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

Line 276: := FND_API.G_MISS_NUM

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

Line 278: := FND_API.G_MISS_NUM

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

Line 280: := FND_API.G_MISS_NUM

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

Line 282: := FND_API.G_MISS_NUM

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

Line 284: := FND_API.G_MISS_NUM

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

Line 286: := FND_API.G_MISS_NUM

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

Line 288: := FND_API.G_MISS_NUM

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

Line 290: := FND_API.G_MISS_NUM

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

Line 292: := FND_API.G_MISS_NUM

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

Line 294: := FND_API.G_MISS_NUM

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

Line 296: := FND_API.G_MISS_NUM

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

Line 298: := FND_API.G_MISS_CHAR

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

Line 301: := 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
305: := FND_API.G_MISS_NUM

Line 303: := FND_API.G_MISS_NUM

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

Line 305: := FND_API.G_MISS_NUM

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

Line 307: := FND_API.G_MISS_NUM

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

Line 316: budget_version_id = DECODE( p_budget_version_id, FND_API.G_MISS_NUM,

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,
319: p_project_id)
320: ,task_id = DECODE( p_task_id, FND_API.G_MISS_NUM, task_id, p_task_id)

Line 318: ,project_id = DECODE( p_project_id, FND_API.G_MISS_NUM, project_id,

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,
319: p_project_id)
320: ,task_id = DECODE( p_task_id, FND_API.G_MISS_NUM, task_id, p_task_id)
321: ,resource_list_member_id = DECODE( p_resource_list_member_id,
322: FND_API.G_MISS_NUM,

Line 320: ,task_id = DECODE( p_task_id, FND_API.G_MISS_NUM, task_id, p_task_id)

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,
319: p_project_id)
320: ,task_id = DECODE( p_task_id, FND_API.G_MISS_NUM, task_id, p_task_id)
321: ,resource_list_member_id = DECODE( p_resource_list_member_id,
322: FND_API.G_MISS_NUM,
323: resource_list_member_id,
324: p_resource_list_member_id)

Line 322: FND_API.G_MISS_NUM,

318: ,project_id = DECODE( p_project_id, FND_API.G_MISS_NUM, project_id,
319: p_project_id)
320: ,task_id = DECODE( p_task_id, FND_API.G_MISS_NUM, task_id, p_task_id)
321: ,resource_list_member_id = DECODE( p_resource_list_member_id,
322: FND_API.G_MISS_NUM,
323: resource_list_member_id,
324: p_resource_list_member_id)
325: ,last_update_date = sysdate
326: ,last_updated_by = fnd_global.user_id

Line 328: ,unit_of_measure = DECODE( p_unit_of_measure, FND_API.G_MISS_CHAR,

324: p_resource_list_member_id)
325: ,last_update_date = sysdate
326: ,last_updated_by = fnd_global.user_id
327: ,last_update_login = fnd_global.login_id
328: ,unit_of_measure = DECODE( p_unit_of_measure, FND_API.G_MISS_CHAR,
329: unit_of_measure, p_unit_of_measure)
330: ,track_as_labor_flag = DECODE( p_track_as_labor_flag, FND_API.G_MISS_CHAR,
331: track_as_labor_flag, p_track_as_labor_flag)
332: ,standard_bill_rate = DECODE( p_standard_bill_rate, FND_API.G_MISS_NUM,

Line 330: ,track_as_labor_flag = DECODE( p_track_as_labor_flag, FND_API.G_MISS_CHAR,

326: ,last_updated_by = fnd_global.user_id
327: ,last_update_login = fnd_global.login_id
328: ,unit_of_measure = DECODE( p_unit_of_measure, FND_API.G_MISS_CHAR,
329: unit_of_measure, p_unit_of_measure)
330: ,track_as_labor_flag = DECODE( p_track_as_labor_flag, FND_API.G_MISS_CHAR,
331: track_as_labor_flag, p_track_as_labor_flag)
332: ,standard_bill_rate = DECODE( p_standard_bill_rate, FND_API.G_MISS_NUM,
333: standard_bill_rate, p_standard_bill_rate)
334: ,average_bill_rate = DECODE( p_average_bill_rate, FND_API.G_MISS_NUM,

Line 332: ,standard_bill_rate = DECODE( p_standard_bill_rate, FND_API.G_MISS_NUM,

328: ,unit_of_measure = DECODE( p_unit_of_measure, FND_API.G_MISS_CHAR,
329: unit_of_measure, p_unit_of_measure)
330: ,track_as_labor_flag = DECODE( p_track_as_labor_flag, FND_API.G_MISS_CHAR,
331: track_as_labor_flag, p_track_as_labor_flag)
332: ,standard_bill_rate = DECODE( p_standard_bill_rate, FND_API.G_MISS_NUM,
333: standard_bill_rate, p_standard_bill_rate)
334: ,average_bill_rate = DECODE( p_average_bill_rate, FND_API.G_MISS_NUM,
335: average_bill_rate, p_average_bill_rate)
336: ,average_cost_rate = DECODE( p_average_cost_rate, FND_API.G_MISS_NUM,

Line 334: ,average_bill_rate = DECODE( p_average_bill_rate, FND_API.G_MISS_NUM,

330: ,track_as_labor_flag = DECODE( p_track_as_labor_flag, FND_API.G_MISS_CHAR,
331: track_as_labor_flag, p_track_as_labor_flag)
332: ,standard_bill_rate = DECODE( p_standard_bill_rate, FND_API.G_MISS_NUM,
333: standard_bill_rate, p_standard_bill_rate)
334: ,average_bill_rate = DECODE( p_average_bill_rate, FND_API.G_MISS_NUM,
335: average_bill_rate, p_average_bill_rate)
336: ,average_cost_rate = DECODE( p_average_cost_rate, FND_API.G_MISS_NUM,
337: average_cost_rate, p_average_cost_rate)
338: ,project_assignment_id = DECODE( p_project_assignment_id,

Line 336: ,average_cost_rate = DECODE( p_average_cost_rate, FND_API.G_MISS_NUM,

332: ,standard_bill_rate = DECODE( p_standard_bill_rate, FND_API.G_MISS_NUM,
333: standard_bill_rate, p_standard_bill_rate)
334: ,average_bill_rate = DECODE( p_average_bill_rate, FND_API.G_MISS_NUM,
335: average_bill_rate, p_average_bill_rate)
336: ,average_cost_rate = DECODE( p_average_cost_rate, FND_API.G_MISS_NUM,
337: average_cost_rate, p_average_cost_rate)
338: ,project_assignment_id = DECODE( p_project_assignment_id,
339: FND_API.G_MISS_NUM, project_assignment_id,
340: p_project_assignment_id)

Line 339: FND_API.G_MISS_NUM, project_assignment_id,

335: average_bill_rate, p_average_bill_rate)
336: ,average_cost_rate = DECODE( p_average_cost_rate, FND_API.G_MISS_NUM,
337: average_cost_rate, p_average_cost_rate)
338: ,project_assignment_id = DECODE( p_project_assignment_id,
339: FND_API.G_MISS_NUM, project_assignment_id,
340: p_project_assignment_id)
341: ,plan_error_code = DECODE( p_plan_error_code, FND_API.G_MISS_CHAR,
342: plan_error_code, p_plan_error_code)
343: ,total_plan_revenue = DECODE( p_total_plan_revenue, FND_API.G_MISS_NUM,

Line 341: ,plan_error_code = DECODE( p_plan_error_code, FND_API.G_MISS_CHAR,

337: average_cost_rate, p_average_cost_rate)
338: ,project_assignment_id = DECODE( p_project_assignment_id,
339: FND_API.G_MISS_NUM, project_assignment_id,
340: p_project_assignment_id)
341: ,plan_error_code = DECODE( p_plan_error_code, FND_API.G_MISS_CHAR,
342: plan_error_code, p_plan_error_code)
343: ,total_plan_revenue = DECODE( p_total_plan_revenue, FND_API.G_MISS_NUM,
344: total_plan_revenue, p_total_plan_revenue)
345: ,total_plan_raw_cost = DECODE( p_total_plan_raw_cost, FND_API.G_MISS_NUM,

Line 343: ,total_plan_revenue = DECODE( p_total_plan_revenue, FND_API.G_MISS_NUM,

339: FND_API.G_MISS_NUM, project_assignment_id,
340: p_project_assignment_id)
341: ,plan_error_code = DECODE( p_plan_error_code, FND_API.G_MISS_CHAR,
342: plan_error_code, p_plan_error_code)
343: ,total_plan_revenue = DECODE( p_total_plan_revenue, FND_API.G_MISS_NUM,
344: total_plan_revenue, p_total_plan_revenue)
345: ,total_plan_raw_cost = DECODE( p_total_plan_raw_cost, FND_API.G_MISS_NUM,
346: total_plan_raw_cost, p_total_plan_raw_cost)
347: ,total_plan_burdened_cost = DECODE( p_total_plan_burdened_cost,

Line 345: ,total_plan_raw_cost = DECODE( p_total_plan_raw_cost, FND_API.G_MISS_NUM,

341: ,plan_error_code = DECODE( p_plan_error_code, FND_API.G_MISS_CHAR,
342: plan_error_code, p_plan_error_code)
343: ,total_plan_revenue = DECODE( p_total_plan_revenue, FND_API.G_MISS_NUM,
344: total_plan_revenue, p_total_plan_revenue)
345: ,total_plan_raw_cost = DECODE( p_total_plan_raw_cost, FND_API.G_MISS_NUM,
346: total_plan_raw_cost, p_total_plan_raw_cost)
347: ,total_plan_burdened_cost = DECODE( p_total_plan_burdened_cost,
348: FND_API.G_MISS_NUM,
349: total_plan_burdened_cost,

Line 348: FND_API.G_MISS_NUM,

344: total_plan_revenue, p_total_plan_revenue)
345: ,total_plan_raw_cost = DECODE( p_total_plan_raw_cost, FND_API.G_MISS_NUM,
346: total_plan_raw_cost, p_total_plan_raw_cost)
347: ,total_plan_burdened_cost = DECODE( p_total_plan_burdened_cost,
348: FND_API.G_MISS_NUM,
349: total_plan_burdened_cost,
350: p_total_plan_burdened_cost)
351: ,total_plan_quantity = DECODE( p_total_plan_quantity, FND_API.G_MISS_NUM,
352: total_plan_quantity, p_total_plan_quantity)

Line 351: ,total_plan_quantity = DECODE( p_total_plan_quantity, FND_API.G_MISS_NUM,

347: ,total_plan_burdened_cost = DECODE( p_total_plan_burdened_cost,
348: FND_API.G_MISS_NUM,
349: total_plan_burdened_cost,
350: p_total_plan_burdened_cost)
351: ,total_plan_quantity = DECODE( p_total_plan_quantity, FND_API.G_MISS_NUM,
352: total_plan_quantity, p_total_plan_quantity)
353: ,average_discount_percentage = DECODE( p_average_discount_percentage,
354: FND_API.G_MISS_NUM,
355: average_discount_percentage,

Line 354: FND_API.G_MISS_NUM,

350: p_total_plan_burdened_cost)
351: ,total_plan_quantity = DECODE( p_total_plan_quantity, FND_API.G_MISS_NUM,
352: total_plan_quantity, p_total_plan_quantity)
353: ,average_discount_percentage = DECODE( p_average_discount_percentage,
354: FND_API.G_MISS_NUM,
355: average_discount_percentage,
356: p_average_discount_percentage)
357: ,total_borrowed_revenue = DECODE( p_total_borrowed_revenue,
358: FND_API.G_MISS_NUM,

Line 358: FND_API.G_MISS_NUM,

354: FND_API.G_MISS_NUM,
355: average_discount_percentage,
356: p_average_discount_percentage)
357: ,total_borrowed_revenue = DECODE( p_total_borrowed_revenue,
358: FND_API.G_MISS_NUM,
359: total_borrowed_revenue,
360: p_total_borrowed_revenue)
361: ,total_tp_revenue_in = DECODE( p_total_tp_revenue_in, FND_API.G_MISS_NUM,
362: total_tp_revenue_in, p_total_tp_revenue_in)

Line 361: ,total_tp_revenue_in = DECODE( p_total_tp_revenue_in, FND_API.G_MISS_NUM,

357: ,total_borrowed_revenue = DECODE( p_total_borrowed_revenue,
358: FND_API.G_MISS_NUM,
359: total_borrowed_revenue,
360: p_total_borrowed_revenue)
361: ,total_tp_revenue_in = DECODE( p_total_tp_revenue_in, FND_API.G_MISS_NUM,
362: total_tp_revenue_in, p_total_tp_revenue_in)
363: ,total_tp_revenue_out = DECODE( p_total_tp_revenue_out, FND_API.G_MISS_NUM,
364: total_tp_revenue_out,
365: p_total_tp_revenue_out)

Line 363: ,total_tp_revenue_out = DECODE( p_total_tp_revenue_out, FND_API.G_MISS_NUM,

359: total_borrowed_revenue,
360: p_total_borrowed_revenue)
361: ,total_tp_revenue_in = DECODE( p_total_tp_revenue_in, FND_API.G_MISS_NUM,
362: total_tp_revenue_in, p_total_tp_revenue_in)
363: ,total_tp_revenue_out = DECODE( p_total_tp_revenue_out, FND_API.G_MISS_NUM,
364: total_tp_revenue_out,
365: p_total_tp_revenue_out)
366: ,total_revenue_adj = DECODE( p_total_revenue_adj, FND_API.G_MISS_NUM,
367: total_revenue_adj, p_total_revenue_adj)

Line 366: ,total_revenue_adj = DECODE( p_total_revenue_adj, FND_API.G_MISS_NUM,

362: total_tp_revenue_in, p_total_tp_revenue_in)
363: ,total_tp_revenue_out = DECODE( p_total_tp_revenue_out, FND_API.G_MISS_NUM,
364: total_tp_revenue_out,
365: p_total_tp_revenue_out)
366: ,total_revenue_adj = DECODE( p_total_revenue_adj, FND_API.G_MISS_NUM,
367: total_revenue_adj, p_total_revenue_adj)
368: ,total_lent_resource_cost = DECODE( p_total_lent_resource_cost,
369: FND_API.G_MISS_NUM,
370: total_lent_resource_cost,

Line 369: FND_API.G_MISS_NUM,

365: p_total_tp_revenue_out)
366: ,total_revenue_adj = DECODE( p_total_revenue_adj, FND_API.G_MISS_NUM,
367: total_revenue_adj, p_total_revenue_adj)
368: ,total_lent_resource_cost = DECODE( p_total_lent_resource_cost,
369: FND_API.G_MISS_NUM,
370: total_lent_resource_cost,
371: p_total_lent_resource_cost)
372: ,total_tp_cost_in = DECODE( p_total_tp_cost_in, FND_API.G_MISS_NUM,
373: total_tp_cost_in, p_total_tp_cost_in)

Line 372: ,total_tp_cost_in = DECODE( p_total_tp_cost_in, FND_API.G_MISS_NUM,

368: ,total_lent_resource_cost = DECODE( p_total_lent_resource_cost,
369: FND_API.G_MISS_NUM,
370: total_lent_resource_cost,
371: p_total_lent_resource_cost)
372: ,total_tp_cost_in = DECODE( p_total_tp_cost_in, FND_API.G_MISS_NUM,
373: total_tp_cost_in, p_total_tp_cost_in)
374: ,total_tp_cost_out = DECODE( p_total_tp_cost_out, FND_API.G_MISS_NUM,
375: total_tp_cost_out, p_total_tp_cost_out)
376: ,total_cost_adj = DECODE( p_total_cost_adj, FND_API.G_MISS_NUM,

Line 374: ,total_tp_cost_out = DECODE( p_total_tp_cost_out, FND_API.G_MISS_NUM,

370: total_lent_resource_cost,
371: p_total_lent_resource_cost)
372: ,total_tp_cost_in = DECODE( p_total_tp_cost_in, FND_API.G_MISS_NUM,
373: total_tp_cost_in, p_total_tp_cost_in)
374: ,total_tp_cost_out = DECODE( p_total_tp_cost_out, FND_API.G_MISS_NUM,
375: total_tp_cost_out, p_total_tp_cost_out)
376: ,total_cost_adj = DECODE( p_total_cost_adj, FND_API.G_MISS_NUM,
377: total_cost_adj, p_total_cost_adj)
378: ,total_unassigned_time_cost = DECODE( p_total_unassigned_time_cost,

Line 376: ,total_cost_adj = DECODE( p_total_cost_adj, FND_API.G_MISS_NUM,

372: ,total_tp_cost_in = DECODE( p_total_tp_cost_in, FND_API.G_MISS_NUM,
373: total_tp_cost_in, p_total_tp_cost_in)
374: ,total_tp_cost_out = DECODE( p_total_tp_cost_out, FND_API.G_MISS_NUM,
375: total_tp_cost_out, p_total_tp_cost_out)
376: ,total_cost_adj = DECODE( p_total_cost_adj, FND_API.G_MISS_NUM,
377: total_cost_adj, p_total_cost_adj)
378: ,total_unassigned_time_cost = DECODE( p_total_unassigned_time_cost,
379: FND_API.G_MISS_NUM,
380: total_unassigned_time_cost,

Line 379: FND_API.G_MISS_NUM,

375: total_tp_cost_out, p_total_tp_cost_out)
376: ,total_cost_adj = DECODE( p_total_cost_adj, FND_API.G_MISS_NUM,
377: total_cost_adj, p_total_cost_adj)
378: ,total_unassigned_time_cost = DECODE( p_total_unassigned_time_cost,
379: FND_API.G_MISS_NUM,
380: total_unassigned_time_cost,
381: p_total_unassigned_time_cost)
382: ,total_utilization_percent = DECODE( p_total_utilization_percent,
383: FND_API.G_MISS_NUM,

Line 383: FND_API.G_MISS_NUM,

379: FND_API.G_MISS_NUM,
380: total_unassigned_time_cost,
381: p_total_unassigned_time_cost)
382: ,total_utilization_percent = DECODE( p_total_utilization_percent,
383: FND_API.G_MISS_NUM,
384: total_utilization_percent,
385: p_total_utilization_percent)
386: ,total_utilization_hours = DECODE( p_total_utilization_hours,
387: FND_API.G_MISS_NUM,

Line 387: FND_API.G_MISS_NUM,

383: FND_API.G_MISS_NUM,
384: total_utilization_percent,
385: p_total_utilization_percent)
386: ,total_utilization_hours = DECODE( p_total_utilization_hours,
387: FND_API.G_MISS_NUM,
388: total_utilization_hours,
389: p_total_utilization_hours)
390: ,total_utilization_adj = DECODE( p_total_utilization_adj,
391: FND_API.G_MISS_NUM, total_utilization_adj,

Line 391: FND_API.G_MISS_NUM, total_utilization_adj,

387: FND_API.G_MISS_NUM,
388: total_utilization_hours,
389: p_total_utilization_hours)
390: ,total_utilization_adj = DECODE( p_total_utilization_adj,
391: FND_API.G_MISS_NUM, total_utilization_adj,
392: p_total_utilization_adj)
393: ,total_capacity = DECODE( p_total_capacity, FND_API.G_MISS_NUM,
394: total_capacity, p_total_capacity)
395: ,total_head_count = DECODE( p_total_head_count, FND_API.G_MISS_NUM,

Line 393: ,total_capacity = DECODE( p_total_capacity, FND_API.G_MISS_NUM,

389: p_total_utilization_hours)
390: ,total_utilization_adj = DECODE( p_total_utilization_adj,
391: FND_API.G_MISS_NUM, total_utilization_adj,
392: p_total_utilization_adj)
393: ,total_capacity = DECODE( p_total_capacity, FND_API.G_MISS_NUM,
394: total_capacity, p_total_capacity)
395: ,total_head_count = DECODE( p_total_head_count, FND_API.G_MISS_NUM,
396: total_head_count, p_total_head_count)
397: ,total_head_count_adj = DECODE( p_total_head_count_adj, FND_API.G_MISS_NUM,

Line 395: ,total_head_count = DECODE( p_total_head_count, FND_API.G_MISS_NUM,

391: FND_API.G_MISS_NUM, total_utilization_adj,
392: p_total_utilization_adj)
393: ,total_capacity = DECODE( p_total_capacity, FND_API.G_MISS_NUM,
394: total_capacity, p_total_capacity)
395: ,total_head_count = DECODE( p_total_head_count, FND_API.G_MISS_NUM,
396: total_head_count, p_total_head_count)
397: ,total_head_count_adj = DECODE( p_total_head_count_adj, FND_API.G_MISS_NUM,
398: total_head_count_adj,
399: p_total_head_count_adj)

Line 397: ,total_head_count_adj = DECODE( p_total_head_count_adj, FND_API.G_MISS_NUM,

393: ,total_capacity = DECODE( p_total_capacity, FND_API.G_MISS_NUM,
394: total_capacity, p_total_capacity)
395: ,total_head_count = DECODE( p_total_head_count, FND_API.G_MISS_NUM,
396: total_head_count, p_total_head_count)
397: ,total_head_count_adj = DECODE( p_total_head_count_adj, FND_API.G_MISS_NUM,
398: total_head_count_adj,
399: p_total_head_count_adj)
400: ,resource_assignment_type = DECODE( p_resource_assignment_type,
401: FND_API.G_MISS_CHAR,

Line 401: FND_API.G_MISS_CHAR,

397: ,total_head_count_adj = DECODE( p_total_head_count_adj, FND_API.G_MISS_NUM,
398: total_head_count_adj,
399: p_total_head_count_adj)
400: ,resource_assignment_type = DECODE( p_resource_assignment_type,
401: FND_API.G_MISS_CHAR,
402: resource_assignment_type,
403: p_resource_assignment_type)
404: -- start of changes of Bug:- 2634900
405: ,total_project_raw_cost = DECODE( p_total_project_raw_cost,

Line 406: FND_API.G_MISS_NUM ,

402: resource_assignment_type,
403: p_resource_assignment_type)
404: -- start of changes of Bug:- 2634900
405: ,total_project_raw_cost = DECODE( p_total_project_raw_cost,
406: FND_API.G_MISS_NUM ,
407: total_project_raw_cost,
408: p_total_project_raw_cost)
409: ,total_project_burdened_cost = DECODE( p_total_project_burdened_cost,
410: FND_API.G_MISS_NUM ,

Line 410: FND_API.G_MISS_NUM ,

406: FND_API.G_MISS_NUM ,
407: total_project_raw_cost,
408: p_total_project_raw_cost)
409: ,total_project_burdened_cost = DECODE( p_total_project_burdened_cost,
410: FND_API.G_MISS_NUM ,
411: total_project_burdened_cost,
412: p_total_project_burdened_cost)
413: ,total_project_revenue = DECODE( p_total_project_revenue,
414: FND_API.G_MISS_NUM ,

Line 414: FND_API.G_MISS_NUM ,

410: FND_API.G_MISS_NUM ,
411: total_project_burdened_cost,
412: p_total_project_burdened_cost)
413: ,total_project_revenue = DECODE( p_total_project_revenue,
414: FND_API.G_MISS_NUM ,
415: total_project_revenue,
416: p_total_project_revenue)
417: ,parent_assignment_id = DECODE( p_parent_assignment_id,
418: FND_API.G_MISS_NUM ,

Line 418: FND_API.G_MISS_NUM ,

414: FND_API.G_MISS_NUM ,
415: total_project_revenue,
416: p_total_project_revenue)
417: ,parent_assignment_id = DECODE( p_parent_assignment_id,
418: FND_API.G_MISS_NUM ,
419: parent_assignment_id,
420: p_parent_assignment_id)
421: -- end of changes of Bug:- 2634900
422: WHERE resource_assignment_id = p_resource_assignment_id;

Line 427: x_return_status := FND_API.G_RET_STS_ERROR;

423:
424: IF (SQL%NOTFOUND) THEN
425: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
426: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: END IF;
429:
430:
431: EXCEPTION

Line 437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

433: FND_MSG_PUB.add_exc_msg( p_pkg_name
434: => 'PA_FP_RESOURCE_ASSIGNMENTS_PKG.Update_Row',
435: p_procedure_name
436: => PA_DEBUG.G_Err_Stack);
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
438: RAISE;
439: END Update_Row;
440:
441: PROCEDURE Lock_Row

Line 443: := FND_API.G_MISS_NUM

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

Line 465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

461: FND_MSG_PUB.add_exc_msg( p_pkg_name
462: => 'PA_FP_RESOURCE_ASSIGNMENTS_PKG.Lock_Row',
463: p_procedure_name
464: => PA_DEBUG.G_Err_Stack);
465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
466: RAISE;
467: END Lock_Row;
468:
469: PROCEDURE Delete_Row

Line 471: := FND_API.G_MISS_NUM

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
475: IS

Line 478: FND_API.G_MISS_NUM) THEN

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

Line 489: x_return_status := FND_API.G_RET_STS_ERROR;

485:
486: IF (SQL%NOTFOUND) THEN
487: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
488: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: END IF;
491:
492: EXCEPTION
493: WHEN OTHERS THEN

Line 498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

494: FND_MSG_PUB.add_exc_msg( p_pkg_name
495: => 'PA_FP_RESOURCE_ASSIGNMENTS_PKG.Delete_Row',
496: p_procedure_name
497: => PA_DEBUG.G_Err_Stack);
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
499: RAISE;
500: END Delete_Row;
501:
502: END pa_fp_resource_assignments_pkg;