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_ORG_FORECAST_LINES_PKG dependencies on PA_ORG_FORECAST_LINES

Line 15: ( px_forecast_line_id IN OUT NOCOPY pa_org_forecast_lines.forecast_line_id%TYPE --File.Sql.39 bug 4440895

11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PA_FP_ORG_FORECAST_LINES_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pafpfltb.pls';
13:
14: PROCEDURE Insert_Row
15: ( px_forecast_line_id IN OUT NOCOPY pa_org_forecast_lines.forecast_line_id%TYPE --File.Sql.39 bug 4440895
16: ,p_forecast_element_id IN pa_org_forecast_lines.forecast_element_id%TYPE
17: := FND_API.G_MISS_NUM
18: ,p_budget_version_id IN pa_org_forecast_lines.budget_version_id%TYPE
19: := FND_API.G_MISS_NUM

Line 16: ,p_forecast_element_id IN pa_org_forecast_lines.forecast_element_id%TYPE

12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pafpfltb.pls';
13:
14: PROCEDURE Insert_Row
15: ( px_forecast_line_id IN OUT NOCOPY pa_org_forecast_lines.forecast_line_id%TYPE --File.Sql.39 bug 4440895
16: ,p_forecast_element_id IN pa_org_forecast_lines.forecast_element_id%TYPE
17: := FND_API.G_MISS_NUM
18: ,p_budget_version_id IN pa_org_forecast_lines.budget_version_id%TYPE
19: := FND_API.G_MISS_NUM
20: ,p_project_id IN pa_org_forecast_lines.project_id%TYPE

Line 18: ,p_budget_version_id IN pa_org_forecast_lines.budget_version_id%TYPE

14: PROCEDURE Insert_Row
15: ( px_forecast_line_id IN OUT NOCOPY pa_org_forecast_lines.forecast_line_id%TYPE --File.Sql.39 bug 4440895
16: ,p_forecast_element_id IN pa_org_forecast_lines.forecast_element_id%TYPE
17: := FND_API.G_MISS_NUM
18: ,p_budget_version_id IN pa_org_forecast_lines.budget_version_id%TYPE
19: := FND_API.G_MISS_NUM
20: ,p_project_id IN pa_org_forecast_lines.project_id%TYPE
21: := FND_API.G_MISS_NUM
22: ,p_task_id IN pa_org_forecast_lines.task_id%TYPE

Line 20: ,p_project_id IN pa_org_forecast_lines.project_id%TYPE

16: ,p_forecast_element_id IN pa_org_forecast_lines.forecast_element_id%TYPE
17: := FND_API.G_MISS_NUM
18: ,p_budget_version_id IN pa_org_forecast_lines.budget_version_id%TYPE
19: := FND_API.G_MISS_NUM
20: ,p_project_id IN pa_org_forecast_lines.project_id%TYPE
21: := FND_API.G_MISS_NUM
22: ,p_task_id IN pa_org_forecast_lines.task_id%TYPE
23: := FND_API.G_MISS_NUM
24: ,p_period_name IN pa_org_forecast_lines.period_name%TYPE

Line 22: ,p_task_id IN pa_org_forecast_lines.task_id%TYPE

18: ,p_budget_version_id IN pa_org_forecast_lines.budget_version_id%TYPE
19: := FND_API.G_MISS_NUM
20: ,p_project_id IN pa_org_forecast_lines.project_id%TYPE
21: := FND_API.G_MISS_NUM
22: ,p_task_id IN pa_org_forecast_lines.task_id%TYPE
23: := FND_API.G_MISS_NUM
24: ,p_period_name IN pa_org_forecast_lines.period_name%TYPE
25: := FND_API.G_MISS_CHAR
26: ,p_start_date IN pa_org_forecast_lines.start_date%TYPE

Line 24: ,p_period_name IN pa_org_forecast_lines.period_name%TYPE

20: ,p_project_id IN pa_org_forecast_lines.project_id%TYPE
21: := FND_API.G_MISS_NUM
22: ,p_task_id IN pa_org_forecast_lines.task_id%TYPE
23: := FND_API.G_MISS_NUM
24: ,p_period_name IN pa_org_forecast_lines.period_name%TYPE
25: := FND_API.G_MISS_CHAR
26: ,p_start_date IN pa_org_forecast_lines.start_date%TYPE
27: := FND_API.G_MISS_DATE
28: ,p_end_date IN pa_org_forecast_lines.end_date%TYPE

Line 26: ,p_start_date IN pa_org_forecast_lines.start_date%TYPE

22: ,p_task_id IN pa_org_forecast_lines.task_id%TYPE
23: := FND_API.G_MISS_NUM
24: ,p_period_name IN pa_org_forecast_lines.period_name%TYPE
25: := FND_API.G_MISS_CHAR
26: ,p_start_date IN pa_org_forecast_lines.start_date%TYPE
27: := FND_API.G_MISS_DATE
28: ,p_end_date IN pa_org_forecast_lines.end_date%TYPE
29: := FND_API.G_MISS_DATE
30: ,p_quantity IN pa_org_forecast_lines.quantity%TYPE

Line 28: ,p_end_date IN pa_org_forecast_lines.end_date%TYPE

24: ,p_period_name IN pa_org_forecast_lines.period_name%TYPE
25: := FND_API.G_MISS_CHAR
26: ,p_start_date IN pa_org_forecast_lines.start_date%TYPE
27: := FND_API.G_MISS_DATE
28: ,p_end_date IN pa_org_forecast_lines.end_date%TYPE
29: := FND_API.G_MISS_DATE
30: ,p_quantity IN pa_org_forecast_lines.quantity%TYPE
31: := FND_API.G_MISS_NUM
32: ,p_raw_cost IN pa_org_forecast_lines.raw_cost%TYPE

Line 30: ,p_quantity IN pa_org_forecast_lines.quantity%TYPE

26: ,p_start_date IN pa_org_forecast_lines.start_date%TYPE
27: := FND_API.G_MISS_DATE
28: ,p_end_date IN pa_org_forecast_lines.end_date%TYPE
29: := FND_API.G_MISS_DATE
30: ,p_quantity IN pa_org_forecast_lines.quantity%TYPE
31: := FND_API.G_MISS_NUM
32: ,p_raw_cost IN pa_org_forecast_lines.raw_cost%TYPE
33: := FND_API.G_MISS_NUM
34: ,p_burdened_cost IN pa_org_forecast_lines.burdened_cost%TYPE

Line 32: ,p_raw_cost IN pa_org_forecast_lines.raw_cost%TYPE

28: ,p_end_date IN pa_org_forecast_lines.end_date%TYPE
29: := FND_API.G_MISS_DATE
30: ,p_quantity IN pa_org_forecast_lines.quantity%TYPE
31: := FND_API.G_MISS_NUM
32: ,p_raw_cost IN pa_org_forecast_lines.raw_cost%TYPE
33: := FND_API.G_MISS_NUM
34: ,p_burdened_cost IN pa_org_forecast_lines.burdened_cost%TYPE
35: := FND_API.G_MISS_NUM
36: ,p_tp_cost_in IN pa_org_forecast_lines.tp_cost_in%TYPE

Line 34: ,p_burdened_cost IN pa_org_forecast_lines.burdened_cost%TYPE

30: ,p_quantity IN pa_org_forecast_lines.quantity%TYPE
31: := FND_API.G_MISS_NUM
32: ,p_raw_cost IN pa_org_forecast_lines.raw_cost%TYPE
33: := FND_API.G_MISS_NUM
34: ,p_burdened_cost IN pa_org_forecast_lines.burdened_cost%TYPE
35: := FND_API.G_MISS_NUM
36: ,p_tp_cost_in IN pa_org_forecast_lines.tp_cost_in%TYPE
37: := FND_API.G_MISS_NUM
38: ,p_tp_cost_out IN pa_org_forecast_lines.tp_cost_out%TYPE

Line 36: ,p_tp_cost_in IN pa_org_forecast_lines.tp_cost_in%TYPE

32: ,p_raw_cost IN pa_org_forecast_lines.raw_cost%TYPE
33: := FND_API.G_MISS_NUM
34: ,p_burdened_cost IN pa_org_forecast_lines.burdened_cost%TYPE
35: := FND_API.G_MISS_NUM
36: ,p_tp_cost_in IN pa_org_forecast_lines.tp_cost_in%TYPE
37: := FND_API.G_MISS_NUM
38: ,p_tp_cost_out IN pa_org_forecast_lines.tp_cost_out%TYPE
39: := FND_API.G_MISS_NUM
40: ,p_revenue IN pa_org_forecast_lines.revenue%TYPE

Line 38: ,p_tp_cost_out IN pa_org_forecast_lines.tp_cost_out%TYPE

34: ,p_burdened_cost IN pa_org_forecast_lines.burdened_cost%TYPE
35: := FND_API.G_MISS_NUM
36: ,p_tp_cost_in IN pa_org_forecast_lines.tp_cost_in%TYPE
37: := FND_API.G_MISS_NUM
38: ,p_tp_cost_out IN pa_org_forecast_lines.tp_cost_out%TYPE
39: := FND_API.G_MISS_NUM
40: ,p_revenue IN pa_org_forecast_lines.revenue%TYPE
41: := FND_API.G_MISS_NUM
42: ,p_tp_revenue_in IN pa_org_forecast_lines.tp_revenue_in%TYPE

Line 40: ,p_revenue IN pa_org_forecast_lines.revenue%TYPE

36: ,p_tp_cost_in IN pa_org_forecast_lines.tp_cost_in%TYPE
37: := FND_API.G_MISS_NUM
38: ,p_tp_cost_out IN pa_org_forecast_lines.tp_cost_out%TYPE
39: := FND_API.G_MISS_NUM
40: ,p_revenue IN pa_org_forecast_lines.revenue%TYPE
41: := FND_API.G_MISS_NUM
42: ,p_tp_revenue_in IN pa_org_forecast_lines.tp_revenue_in%TYPE
43: := FND_API.G_MISS_NUM
44: ,p_tp_revenue_out IN pa_org_forecast_lines.tp_revenue_out%TYPE

Line 42: ,p_tp_revenue_in IN pa_org_forecast_lines.tp_revenue_in%TYPE

38: ,p_tp_cost_out IN pa_org_forecast_lines.tp_cost_out%TYPE
39: := FND_API.G_MISS_NUM
40: ,p_revenue IN pa_org_forecast_lines.revenue%TYPE
41: := FND_API.G_MISS_NUM
42: ,p_tp_revenue_in IN pa_org_forecast_lines.tp_revenue_in%TYPE
43: := FND_API.G_MISS_NUM
44: ,p_tp_revenue_out IN pa_org_forecast_lines.tp_revenue_out%TYPE
45: := FND_API.G_MISS_NUM
46: ,p_borrowed_revenue IN pa_org_forecast_lines.borrowed_revenue%TYPE

Line 44: ,p_tp_revenue_out IN pa_org_forecast_lines.tp_revenue_out%TYPE

40: ,p_revenue IN pa_org_forecast_lines.revenue%TYPE
41: := FND_API.G_MISS_NUM
42: ,p_tp_revenue_in IN pa_org_forecast_lines.tp_revenue_in%TYPE
43: := FND_API.G_MISS_NUM
44: ,p_tp_revenue_out IN pa_org_forecast_lines.tp_revenue_out%TYPE
45: := FND_API.G_MISS_NUM
46: ,p_borrowed_revenue IN pa_org_forecast_lines.borrowed_revenue%TYPE
47: := FND_API.G_MISS_NUM
48: ,p_lent_resource_cost IN pa_org_forecast_lines.lent_resource_cost%TYPE

Line 46: ,p_borrowed_revenue IN pa_org_forecast_lines.borrowed_revenue%TYPE

42: ,p_tp_revenue_in IN pa_org_forecast_lines.tp_revenue_in%TYPE
43: := FND_API.G_MISS_NUM
44: ,p_tp_revenue_out IN pa_org_forecast_lines.tp_revenue_out%TYPE
45: := FND_API.G_MISS_NUM
46: ,p_borrowed_revenue IN pa_org_forecast_lines.borrowed_revenue%TYPE
47: := FND_API.G_MISS_NUM
48: ,p_lent_resource_cost IN pa_org_forecast_lines.lent_resource_cost%TYPE
49: := FND_API.G_MISS_NUM
50: ,p_unassigned_time_cost IN pa_org_forecast_lines.unassigned_time_cost%TYPE

Line 48: ,p_lent_resource_cost IN pa_org_forecast_lines.lent_resource_cost%TYPE

44: ,p_tp_revenue_out IN pa_org_forecast_lines.tp_revenue_out%TYPE
45: := FND_API.G_MISS_NUM
46: ,p_borrowed_revenue IN pa_org_forecast_lines.borrowed_revenue%TYPE
47: := FND_API.G_MISS_NUM
48: ,p_lent_resource_cost IN pa_org_forecast_lines.lent_resource_cost%TYPE
49: := FND_API.G_MISS_NUM
50: ,p_unassigned_time_cost IN pa_org_forecast_lines.unassigned_time_cost%TYPE
51: := FND_API.G_MISS_NUM
52: ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895

Line 50: ,p_unassigned_time_cost IN pa_org_forecast_lines.unassigned_time_cost%TYPE

46: ,p_borrowed_revenue IN pa_org_forecast_lines.borrowed_revenue%TYPE
47: := FND_API.G_MISS_NUM
48: ,p_lent_resource_cost IN pa_org_forecast_lines.lent_resource_cost%TYPE
49: := FND_API.G_MISS_NUM
50: ,p_unassigned_time_cost IN pa_org_forecast_lines.unassigned_time_cost%TYPE
51: := FND_API.G_MISS_NUM
52: ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
53: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
54: IS

Line 55: CURSOR C2 IS SELECT pa_org_forecast_lines_s.nextval FROM sys.dual;

51: := FND_API.G_MISS_NUM
52: ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
53: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
54: IS
55: CURSOR C2 IS SELECT pa_org_forecast_lines_s.nextval FROM sys.dual;
56: BEGIN
57: IF (px_forecast_line_id IS NULL) OR
58: (px_forecast_line_id = FND_API.G_MISS_NUM) THEN
59: OPEN C2;

Line 63: insert into pa_org_forecast_lines(

59: OPEN C2;
60: FETCH C2 INTO px_forecast_line_id;
61: CLOSE C2;
62: END IF;
63: insert into pa_org_forecast_lines(
64: forecast_line_id
65: ,record_version_number
66: ,creation_date
67: ,created_by

Line 128: ( p_forecast_line_id IN pa_org_forecast_lines.forecast_line_id%TYPE

124: RAISE;
125: END Insert_Row;
126:
127: PROCEDURE Update_Row
128: ( p_forecast_line_id IN pa_org_forecast_lines.forecast_line_id%TYPE
129: := FND_API.G_MISS_NUM
130: ,p_record_version_number IN NUMBER
131: := NULL
132: ,p_forecast_element_id IN pa_org_forecast_lines.forecast_element_id%TYPE

Line 132: ,p_forecast_element_id IN pa_org_forecast_lines.forecast_element_id%TYPE

128: ( p_forecast_line_id IN pa_org_forecast_lines.forecast_line_id%TYPE
129: := FND_API.G_MISS_NUM
130: ,p_record_version_number IN NUMBER
131: := NULL
132: ,p_forecast_element_id IN pa_org_forecast_lines.forecast_element_id%TYPE
133: := FND_API.G_MISS_NUM
134: ,p_budget_version_id IN pa_org_forecast_lines.budget_version_id%TYPE
135: := FND_API.G_MISS_NUM
136: ,p_project_id IN pa_org_forecast_lines.project_id%TYPE

Line 134: ,p_budget_version_id IN pa_org_forecast_lines.budget_version_id%TYPE

130: ,p_record_version_number IN NUMBER
131: := NULL
132: ,p_forecast_element_id IN pa_org_forecast_lines.forecast_element_id%TYPE
133: := FND_API.G_MISS_NUM
134: ,p_budget_version_id IN pa_org_forecast_lines.budget_version_id%TYPE
135: := FND_API.G_MISS_NUM
136: ,p_project_id IN pa_org_forecast_lines.project_id%TYPE
137: := FND_API.G_MISS_NUM
138: ,p_task_id IN pa_org_forecast_lines.task_id%TYPE

Line 136: ,p_project_id IN pa_org_forecast_lines.project_id%TYPE

132: ,p_forecast_element_id IN pa_org_forecast_lines.forecast_element_id%TYPE
133: := FND_API.G_MISS_NUM
134: ,p_budget_version_id IN pa_org_forecast_lines.budget_version_id%TYPE
135: := FND_API.G_MISS_NUM
136: ,p_project_id IN pa_org_forecast_lines.project_id%TYPE
137: := FND_API.G_MISS_NUM
138: ,p_task_id IN pa_org_forecast_lines.task_id%TYPE
139: := FND_API.G_MISS_NUM
140: ,p_period_name IN pa_org_forecast_lines.period_name%TYPE

Line 138: ,p_task_id IN pa_org_forecast_lines.task_id%TYPE

134: ,p_budget_version_id IN pa_org_forecast_lines.budget_version_id%TYPE
135: := FND_API.G_MISS_NUM
136: ,p_project_id IN pa_org_forecast_lines.project_id%TYPE
137: := FND_API.G_MISS_NUM
138: ,p_task_id IN pa_org_forecast_lines.task_id%TYPE
139: := FND_API.G_MISS_NUM
140: ,p_period_name IN pa_org_forecast_lines.period_name%TYPE
141: := FND_API.G_MISS_CHAR
142: ,p_start_date IN pa_org_forecast_lines.start_date%TYPE

Line 140: ,p_period_name IN pa_org_forecast_lines.period_name%TYPE

136: ,p_project_id IN pa_org_forecast_lines.project_id%TYPE
137: := FND_API.G_MISS_NUM
138: ,p_task_id IN pa_org_forecast_lines.task_id%TYPE
139: := FND_API.G_MISS_NUM
140: ,p_period_name IN pa_org_forecast_lines.period_name%TYPE
141: := FND_API.G_MISS_CHAR
142: ,p_start_date IN pa_org_forecast_lines.start_date%TYPE
143: := FND_API.G_MISS_DATE
144: ,p_end_date IN pa_org_forecast_lines.end_date%TYPE

Line 142: ,p_start_date IN pa_org_forecast_lines.start_date%TYPE

138: ,p_task_id IN pa_org_forecast_lines.task_id%TYPE
139: := FND_API.G_MISS_NUM
140: ,p_period_name IN pa_org_forecast_lines.period_name%TYPE
141: := FND_API.G_MISS_CHAR
142: ,p_start_date IN pa_org_forecast_lines.start_date%TYPE
143: := FND_API.G_MISS_DATE
144: ,p_end_date IN pa_org_forecast_lines.end_date%TYPE
145: := FND_API.G_MISS_DATE
146: ,p_quantity IN pa_org_forecast_lines.quantity%TYPE

Line 144: ,p_end_date IN pa_org_forecast_lines.end_date%TYPE

140: ,p_period_name IN pa_org_forecast_lines.period_name%TYPE
141: := FND_API.G_MISS_CHAR
142: ,p_start_date IN pa_org_forecast_lines.start_date%TYPE
143: := FND_API.G_MISS_DATE
144: ,p_end_date IN pa_org_forecast_lines.end_date%TYPE
145: := FND_API.G_MISS_DATE
146: ,p_quantity IN pa_org_forecast_lines.quantity%TYPE
147: := FND_API.G_MISS_NUM
148: ,p_raw_cost IN pa_org_forecast_lines.raw_cost%TYPE

Line 146: ,p_quantity IN pa_org_forecast_lines.quantity%TYPE

142: ,p_start_date IN pa_org_forecast_lines.start_date%TYPE
143: := FND_API.G_MISS_DATE
144: ,p_end_date IN pa_org_forecast_lines.end_date%TYPE
145: := FND_API.G_MISS_DATE
146: ,p_quantity IN pa_org_forecast_lines.quantity%TYPE
147: := FND_API.G_MISS_NUM
148: ,p_raw_cost IN pa_org_forecast_lines.raw_cost%TYPE
149: := FND_API.G_MISS_NUM
150: ,p_burdened_cost IN pa_org_forecast_lines.burdened_cost%TYPE

Line 148: ,p_raw_cost IN pa_org_forecast_lines.raw_cost%TYPE

144: ,p_end_date IN pa_org_forecast_lines.end_date%TYPE
145: := FND_API.G_MISS_DATE
146: ,p_quantity IN pa_org_forecast_lines.quantity%TYPE
147: := FND_API.G_MISS_NUM
148: ,p_raw_cost IN pa_org_forecast_lines.raw_cost%TYPE
149: := FND_API.G_MISS_NUM
150: ,p_burdened_cost IN pa_org_forecast_lines.burdened_cost%TYPE
151: := FND_API.G_MISS_NUM
152: ,p_tp_cost_in IN pa_org_forecast_lines.tp_cost_in%TYPE

Line 150: ,p_burdened_cost IN pa_org_forecast_lines.burdened_cost%TYPE

146: ,p_quantity IN pa_org_forecast_lines.quantity%TYPE
147: := FND_API.G_MISS_NUM
148: ,p_raw_cost IN pa_org_forecast_lines.raw_cost%TYPE
149: := FND_API.G_MISS_NUM
150: ,p_burdened_cost IN pa_org_forecast_lines.burdened_cost%TYPE
151: := FND_API.G_MISS_NUM
152: ,p_tp_cost_in IN pa_org_forecast_lines.tp_cost_in%TYPE
153: := FND_API.G_MISS_NUM
154: ,p_tp_cost_out IN pa_org_forecast_lines.tp_cost_out%TYPE

Line 152: ,p_tp_cost_in IN pa_org_forecast_lines.tp_cost_in%TYPE

148: ,p_raw_cost IN pa_org_forecast_lines.raw_cost%TYPE
149: := FND_API.G_MISS_NUM
150: ,p_burdened_cost IN pa_org_forecast_lines.burdened_cost%TYPE
151: := FND_API.G_MISS_NUM
152: ,p_tp_cost_in IN pa_org_forecast_lines.tp_cost_in%TYPE
153: := FND_API.G_MISS_NUM
154: ,p_tp_cost_out IN pa_org_forecast_lines.tp_cost_out%TYPE
155: := FND_API.G_MISS_NUM
156: ,p_revenue IN pa_org_forecast_lines.revenue%TYPE

Line 154: ,p_tp_cost_out IN pa_org_forecast_lines.tp_cost_out%TYPE

150: ,p_burdened_cost IN pa_org_forecast_lines.burdened_cost%TYPE
151: := FND_API.G_MISS_NUM
152: ,p_tp_cost_in IN pa_org_forecast_lines.tp_cost_in%TYPE
153: := FND_API.G_MISS_NUM
154: ,p_tp_cost_out IN pa_org_forecast_lines.tp_cost_out%TYPE
155: := FND_API.G_MISS_NUM
156: ,p_revenue IN pa_org_forecast_lines.revenue%TYPE
157: := FND_API.G_MISS_NUM
158: ,p_tp_revenue_in IN pa_org_forecast_lines.tp_revenue_in%TYPE

Line 156: ,p_revenue IN pa_org_forecast_lines.revenue%TYPE

152: ,p_tp_cost_in IN pa_org_forecast_lines.tp_cost_in%TYPE
153: := FND_API.G_MISS_NUM
154: ,p_tp_cost_out IN pa_org_forecast_lines.tp_cost_out%TYPE
155: := FND_API.G_MISS_NUM
156: ,p_revenue IN pa_org_forecast_lines.revenue%TYPE
157: := FND_API.G_MISS_NUM
158: ,p_tp_revenue_in IN pa_org_forecast_lines.tp_revenue_in%TYPE
159: := FND_API.G_MISS_NUM
160: ,p_tp_revenue_out IN pa_org_forecast_lines.tp_revenue_out%TYPE

Line 158: ,p_tp_revenue_in IN pa_org_forecast_lines.tp_revenue_in%TYPE

154: ,p_tp_cost_out IN pa_org_forecast_lines.tp_cost_out%TYPE
155: := FND_API.G_MISS_NUM
156: ,p_revenue IN pa_org_forecast_lines.revenue%TYPE
157: := FND_API.G_MISS_NUM
158: ,p_tp_revenue_in IN pa_org_forecast_lines.tp_revenue_in%TYPE
159: := FND_API.G_MISS_NUM
160: ,p_tp_revenue_out IN pa_org_forecast_lines.tp_revenue_out%TYPE
161: := FND_API.G_MISS_NUM
162: ,p_borrowed_revenue IN pa_org_forecast_lines.borrowed_revenue%TYPE

Line 160: ,p_tp_revenue_out IN pa_org_forecast_lines.tp_revenue_out%TYPE

156: ,p_revenue IN pa_org_forecast_lines.revenue%TYPE
157: := FND_API.G_MISS_NUM
158: ,p_tp_revenue_in IN pa_org_forecast_lines.tp_revenue_in%TYPE
159: := FND_API.G_MISS_NUM
160: ,p_tp_revenue_out IN pa_org_forecast_lines.tp_revenue_out%TYPE
161: := FND_API.G_MISS_NUM
162: ,p_borrowed_revenue IN pa_org_forecast_lines.borrowed_revenue%TYPE
163: := FND_API.G_MISS_NUM
164: ,p_lent_resource_cost IN pa_org_forecast_lines.lent_resource_cost%TYPE

Line 162: ,p_borrowed_revenue IN pa_org_forecast_lines.borrowed_revenue%TYPE

158: ,p_tp_revenue_in IN pa_org_forecast_lines.tp_revenue_in%TYPE
159: := FND_API.G_MISS_NUM
160: ,p_tp_revenue_out IN pa_org_forecast_lines.tp_revenue_out%TYPE
161: := FND_API.G_MISS_NUM
162: ,p_borrowed_revenue IN pa_org_forecast_lines.borrowed_revenue%TYPE
163: := FND_API.G_MISS_NUM
164: ,p_lent_resource_cost IN pa_org_forecast_lines.lent_resource_cost%TYPE
165: := FND_API.G_MISS_NUM
166: ,p_unassigned_time_cost IN pa_org_forecast_lines.unassigned_time_cost%TYPE

Line 164: ,p_lent_resource_cost IN pa_org_forecast_lines.lent_resource_cost%TYPE

160: ,p_tp_revenue_out IN pa_org_forecast_lines.tp_revenue_out%TYPE
161: := FND_API.G_MISS_NUM
162: ,p_borrowed_revenue IN pa_org_forecast_lines.borrowed_revenue%TYPE
163: := FND_API.G_MISS_NUM
164: ,p_lent_resource_cost IN pa_org_forecast_lines.lent_resource_cost%TYPE
165: := FND_API.G_MISS_NUM
166: ,p_unassigned_time_cost IN pa_org_forecast_lines.unassigned_time_cost%TYPE
167: := FND_API.G_MISS_NUM
168: ,p_row_id IN ROWID

Line 166: ,p_unassigned_time_cost IN pa_org_forecast_lines.unassigned_time_cost%TYPE

162: ,p_borrowed_revenue IN pa_org_forecast_lines.borrowed_revenue%TYPE
163: := FND_API.G_MISS_NUM
164: ,p_lent_resource_cost IN pa_org_forecast_lines.lent_resource_cost%TYPE
165: := FND_API.G_MISS_NUM
166: ,p_unassigned_time_cost IN pa_org_forecast_lines.unassigned_time_cost%TYPE
167: := FND_API.G_MISS_NUM
168: ,p_row_id IN ROWID
169: := NULL
170: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 173: UPDATE pa_org_forecast_lines

169: := NULL
170: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
171: IS
172: BEGIN
173: UPDATE pa_org_forecast_lines
174: SET
175: record_version_number = nvl(record_version_number,0) +1
176: ,last_update_login = fnd_global.login_id
177: ,last_updated_by = fnd_global.user_id

Line 231: ( p_forecast_line_id IN pa_org_forecast_lines.forecast_line_id%TYPE

227: RAISE;
228: END Update_Row;
229:
230: PROCEDURE Lock_Row
231: ( p_forecast_line_id IN pa_org_forecast_lines.forecast_line_id%TYPE
232: := FND_API.G_MISS_NUM
233: ,p_record_version_number IN NUMBER
234: := NULL
235: ,p_row_id IN ROWID

Line 242: FROM pa_org_forecast_lines

238: IS
239: l_row_id ROWID;
240: BEGIN
241: SELECT rowid into l_row_id
242: FROM pa_org_forecast_lines
243: WHERE forecast_line_id = p_forecast_line_id
244: OR rowid = p_row_id
245: FOR UPDATE NOWAIT;
246: EXCEPTION

Line 257: ( p_forecast_line_id IN pa_org_forecast_lines.forecast_line_id%TYPE

253: RAISE;
254: END Lock_Row;
255:
256: PROCEDURE Delete_Row
257: ( p_forecast_line_id IN pa_org_forecast_lines.forecast_line_id%TYPE
258: := FND_API.G_MISS_NUM
259: ,p_record_version_number IN NUMBER
260: := NULL
261: ,p_row_id IN ROWID

Line 269: DELETE FROM pa_org_forecast_lines

265: BEGIN
266: IF (p_forecast_line_id IS NOT NULL AND p_forecast_line_id <>
267: FND_API.G_MISS_NUM) THEN
268:
269: DELETE FROM pa_org_forecast_lines
270: WHERE forecast_line_id = p_forecast_line_id
271: AND nvl(p_record_version_number, nvl(record_version_number,0))
272: = nvl(record_version_number,0);
273: ELSIF (p_row_id IS NOT NULL) THEN

Line 274: DELETE FROM pa_org_forecast_lines

270: WHERE forecast_line_id = p_forecast_line_id
271: AND nvl(p_record_version_number, nvl(record_version_number,0))
272: = nvl(record_version_number,0);
273: ELSIF (p_row_id IS NOT NULL) THEN
274: DELETE FROM pa_org_forecast_lines
275: WHERE rowid = p_row_id
276: AND nvl(p_record_version_number, nvl(record_version_number,0))
277: = nvl(record_version_number,0);
278: END IF;