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_FIN_PLAN_ADJ_LINES_PKG dependencies on PA_FIN_PLAN_ADJ_LINES

Line 15: (px_fin_plan_adj_line_id IN OUT NOCOPY pa_fin_plan_adj_lines.fin_plan_adj_line_id%TYPE --File.Sql.39 bug 4440895

11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PA_FP_FIN_PLAN_ADJ_LINES_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pafpaltb.pls';
13:
14: PROCEDURE Insert_Row
15: (px_fin_plan_adj_line_id IN OUT NOCOPY pa_fin_plan_adj_lines.fin_plan_adj_line_id%TYPE --File.Sql.39 bug 4440895
16: ,p_adj_element_id IN pa_fin_plan_adj_lines.adj_element_id%TYPE
17: := FND_API.G_MISS_NUM
18: ,p_project_id IN pa_fin_plan_adj_lines.project_id%TYPE
19: := FND_API.G_MISS_NUM

Line 16: ,p_adj_element_id IN pa_fin_plan_adj_lines.adj_element_id%TYPE

12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pafpaltb.pls';
13:
14: PROCEDURE Insert_Row
15: (px_fin_plan_adj_line_id IN OUT NOCOPY pa_fin_plan_adj_lines.fin_plan_adj_line_id%TYPE --File.Sql.39 bug 4440895
16: ,p_adj_element_id IN pa_fin_plan_adj_lines.adj_element_id%TYPE
17: := FND_API.G_MISS_NUM
18: ,p_project_id IN pa_fin_plan_adj_lines.project_id%TYPE
19: := FND_API.G_MISS_NUM
20: ,p_task_id IN pa_fin_plan_adj_lines.task_id%TYPE

Line 18: ,p_project_id IN pa_fin_plan_adj_lines.project_id%TYPE

14: PROCEDURE Insert_Row
15: (px_fin_plan_adj_line_id IN OUT NOCOPY pa_fin_plan_adj_lines.fin_plan_adj_line_id%TYPE --File.Sql.39 bug 4440895
16: ,p_adj_element_id IN pa_fin_plan_adj_lines.adj_element_id%TYPE
17: := FND_API.G_MISS_NUM
18: ,p_project_id IN pa_fin_plan_adj_lines.project_id%TYPE
19: := FND_API.G_MISS_NUM
20: ,p_task_id IN pa_fin_plan_adj_lines.task_id%TYPE
21: := FND_API.G_MISS_NUM
22: ,p_budget_version_id IN pa_fin_plan_adj_lines.budget_version_id%TYPE

Line 20: ,p_task_id IN pa_fin_plan_adj_lines.task_id%TYPE

16: ,p_adj_element_id IN pa_fin_plan_adj_lines.adj_element_id%TYPE
17: := FND_API.G_MISS_NUM
18: ,p_project_id IN pa_fin_plan_adj_lines.project_id%TYPE
19: := FND_API.G_MISS_NUM
20: ,p_task_id IN pa_fin_plan_adj_lines.task_id%TYPE
21: := FND_API.G_MISS_NUM
22: ,p_budget_version_id IN pa_fin_plan_adj_lines.budget_version_id%TYPE
23: := FND_API.G_MISS_NUM
24: ,p_resource_assignment_id IN

Line 22: ,p_budget_version_id IN pa_fin_plan_adj_lines.budget_version_id%TYPE

18: ,p_project_id IN pa_fin_plan_adj_lines.project_id%TYPE
19: := FND_API.G_MISS_NUM
20: ,p_task_id IN pa_fin_plan_adj_lines.task_id%TYPE
21: := FND_API.G_MISS_NUM
22: ,p_budget_version_id IN pa_fin_plan_adj_lines.budget_version_id%TYPE
23: := FND_API.G_MISS_NUM
24: ,p_resource_assignment_id IN
25: pa_fin_plan_adj_lines.resource_assignment_id%TYPE
26: := FND_API.G_MISS_NUM

Line 25: pa_fin_plan_adj_lines.resource_assignment_id%TYPE

21: := FND_API.G_MISS_NUM
22: ,p_budget_version_id IN pa_fin_plan_adj_lines.budget_version_id%TYPE
23: := FND_API.G_MISS_NUM
24: ,p_resource_assignment_id IN
25: pa_fin_plan_adj_lines.resource_assignment_id%TYPE
26: := FND_API.G_MISS_NUM
27: ,p_period_name IN
28: pa_fin_plan_adj_lines.period_name%TYPE
29: := FND_API.G_MISS_CHAR

Line 28: pa_fin_plan_adj_lines.period_name%TYPE

24: ,p_resource_assignment_id IN
25: pa_fin_plan_adj_lines.resource_assignment_id%TYPE
26: := FND_API.G_MISS_NUM
27: ,p_period_name IN
28: pa_fin_plan_adj_lines.period_name%TYPE
29: := FND_API.G_MISS_CHAR
30: ,p_start_date IN pa_fin_plan_adj_lines.start_date%TYPE
31: := FND_API.G_MISS_DATE
32: ,p_end_date IN pa_fin_plan_adj_lines.end_date%TYPE

Line 30: ,p_start_date IN pa_fin_plan_adj_lines.start_date%TYPE

26: := FND_API.G_MISS_NUM
27: ,p_period_name IN
28: pa_fin_plan_adj_lines.period_name%TYPE
29: := FND_API.G_MISS_CHAR
30: ,p_start_date IN pa_fin_plan_adj_lines.start_date%TYPE
31: := FND_API.G_MISS_DATE
32: ,p_end_date IN pa_fin_plan_adj_lines.end_date%TYPE
33: := FND_API.G_MISS_DATE
34: ,p_raw_cost_adjustment IN pa_fin_plan_adj_lines.raw_cost_adjustment%TYPE

Line 32: ,p_end_date IN pa_fin_plan_adj_lines.end_date%TYPE

28: pa_fin_plan_adj_lines.period_name%TYPE
29: := FND_API.G_MISS_CHAR
30: ,p_start_date IN pa_fin_plan_adj_lines.start_date%TYPE
31: := FND_API.G_MISS_DATE
32: ,p_end_date IN pa_fin_plan_adj_lines.end_date%TYPE
33: := FND_API.G_MISS_DATE
34: ,p_raw_cost_adjustment IN pa_fin_plan_adj_lines.raw_cost_adjustment%TYPE
35: := FND_API.G_MISS_NUM
36: ,p_burdened_cost_adjustment IN

Line 34: ,p_raw_cost_adjustment IN pa_fin_plan_adj_lines.raw_cost_adjustment%TYPE

30: ,p_start_date IN pa_fin_plan_adj_lines.start_date%TYPE
31: := FND_API.G_MISS_DATE
32: ,p_end_date IN pa_fin_plan_adj_lines.end_date%TYPE
33: := FND_API.G_MISS_DATE
34: ,p_raw_cost_adjustment IN pa_fin_plan_adj_lines.raw_cost_adjustment%TYPE
35: := FND_API.G_MISS_NUM
36: ,p_burdened_cost_adjustment IN
37: pa_fin_plan_adj_lines.burdened_cost_adjustment%TYPE
38: := FND_API.G_MISS_NUM

Line 37: pa_fin_plan_adj_lines.burdened_cost_adjustment%TYPE

33: := FND_API.G_MISS_DATE
34: ,p_raw_cost_adjustment IN pa_fin_plan_adj_lines.raw_cost_adjustment%TYPE
35: := FND_API.G_MISS_NUM
36: ,p_burdened_cost_adjustment IN
37: pa_fin_plan_adj_lines.burdened_cost_adjustment%TYPE
38: := FND_API.G_MISS_NUM
39: ,p_revenue_adjustment IN pa_fin_plan_adj_lines.revenue_adjustment%TYPE
40: := FND_API.G_MISS_NUM
41: ,p_utilization_adjustment IN

Line 39: ,p_revenue_adjustment IN pa_fin_plan_adj_lines.revenue_adjustment%TYPE

35: := FND_API.G_MISS_NUM
36: ,p_burdened_cost_adjustment IN
37: pa_fin_plan_adj_lines.burdened_cost_adjustment%TYPE
38: := FND_API.G_MISS_NUM
39: ,p_revenue_adjustment IN pa_fin_plan_adj_lines.revenue_adjustment%TYPE
40: := FND_API.G_MISS_NUM
41: ,p_utilization_adjustment IN
42: pa_fin_plan_adj_lines.utilization_adjustment%TYPE
43: := FND_API.G_MISS_NUM

Line 42: pa_fin_plan_adj_lines.utilization_adjustment%TYPE

38: := FND_API.G_MISS_NUM
39: ,p_revenue_adjustment IN pa_fin_plan_adj_lines.revenue_adjustment%TYPE
40: := FND_API.G_MISS_NUM
41: ,p_utilization_adjustment IN
42: pa_fin_plan_adj_lines.utilization_adjustment%TYPE
43: := FND_API.G_MISS_NUM
44: ,p_head_count_adjustment IN pa_fin_plan_adj_lines.head_count_adjustment%TYPE
45: := FND_API.G_MISS_NUM
46: ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895

Line 44: ,p_head_count_adjustment IN pa_fin_plan_adj_lines.head_count_adjustment%TYPE

40: := FND_API.G_MISS_NUM
41: ,p_utilization_adjustment IN
42: pa_fin_plan_adj_lines.utilization_adjustment%TYPE
43: := FND_API.G_MISS_NUM
44: ,p_head_count_adjustment IN pa_fin_plan_adj_lines.head_count_adjustment%TYPE
45: := FND_API.G_MISS_NUM
46: ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
47: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
48: IS

Line 49: CURSOR C2 IS select pa_fin_plan_adj_lines_s.nextval FROM sys.dual;

45: := FND_API.G_MISS_NUM
46: ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
47: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
48: IS
49: CURSOR C2 IS select pa_fin_plan_adj_lines_s.nextval FROM sys.dual;
50: BEGIN
51: If (px_fin_plan_adj_line_id IS NULL) OR (px_fin_plan_adj_line_id = FND_API.G_MISS_NUM) then
52: OPEN C2;
53: FETCH C2 INTO px_fin_plan_adj_line_id;

Line 56: INSERT INTO PA_FIN_PLAN_ADJ_LINES(

52: OPEN C2;
53: FETCH C2 INTO px_fin_plan_adj_line_id;
54: CLOSE C2;
55: End If;
56: INSERT INTO PA_FIN_PLAN_ADJ_LINES(
57: fin_plan_adj_line_id
58: ,creation_date
59: ,created_by
60: ,last_update_login

Line 116: ( p_fin_plan_adj_line_id IN pa_fin_plan_adj_lines.fin_plan_adj_line_id%TYPE

112: RAISE;
113: END Insert_Row;
114:
115: PROCEDURE Update_Row
116: ( p_fin_plan_adj_line_id IN pa_fin_plan_adj_lines.fin_plan_adj_line_id%TYPE
117: := FND_API.G_MISS_NUM
118: ,p_adj_element_id IN pa_fin_plan_adj_lines.adj_element_id%TYPE
119: := FND_API.G_MISS_NUM
120: ,p_project_id IN pa_fin_plan_adj_lines.project_id%TYPE

Line 118: ,p_adj_element_id IN pa_fin_plan_adj_lines.adj_element_id%TYPE

114:
115: PROCEDURE Update_Row
116: ( p_fin_plan_adj_line_id IN pa_fin_plan_adj_lines.fin_plan_adj_line_id%TYPE
117: := FND_API.G_MISS_NUM
118: ,p_adj_element_id IN pa_fin_plan_adj_lines.adj_element_id%TYPE
119: := FND_API.G_MISS_NUM
120: ,p_project_id IN pa_fin_plan_adj_lines.project_id%TYPE
121: := FND_API.G_MISS_NUM
122: ,p_task_id IN pa_fin_plan_adj_lines.task_id%TYPE

Line 120: ,p_project_id IN pa_fin_plan_adj_lines.project_id%TYPE

116: ( p_fin_plan_adj_line_id IN pa_fin_plan_adj_lines.fin_plan_adj_line_id%TYPE
117: := FND_API.G_MISS_NUM
118: ,p_adj_element_id IN pa_fin_plan_adj_lines.adj_element_id%TYPE
119: := FND_API.G_MISS_NUM
120: ,p_project_id IN pa_fin_plan_adj_lines.project_id%TYPE
121: := FND_API.G_MISS_NUM
122: ,p_task_id IN pa_fin_plan_adj_lines.task_id%TYPE
123: := FND_API.G_MISS_NUM
124: ,p_budget_version_id IN pa_fin_plan_adj_lines.budget_version_id%TYPE

Line 122: ,p_task_id IN pa_fin_plan_adj_lines.task_id%TYPE

118: ,p_adj_element_id IN pa_fin_plan_adj_lines.adj_element_id%TYPE
119: := FND_API.G_MISS_NUM
120: ,p_project_id IN pa_fin_plan_adj_lines.project_id%TYPE
121: := FND_API.G_MISS_NUM
122: ,p_task_id IN pa_fin_plan_adj_lines.task_id%TYPE
123: := FND_API.G_MISS_NUM
124: ,p_budget_version_id IN pa_fin_plan_adj_lines.budget_version_id%TYPE
125: := FND_API.G_MISS_NUM
126: ,p_resource_assignment_id IN

Line 124: ,p_budget_version_id IN pa_fin_plan_adj_lines.budget_version_id%TYPE

120: ,p_project_id IN pa_fin_plan_adj_lines.project_id%TYPE
121: := FND_API.G_MISS_NUM
122: ,p_task_id IN pa_fin_plan_adj_lines.task_id%TYPE
123: := FND_API.G_MISS_NUM
124: ,p_budget_version_id IN pa_fin_plan_adj_lines.budget_version_id%TYPE
125: := FND_API.G_MISS_NUM
126: ,p_resource_assignment_id IN
127: pa_fin_plan_adj_lines.resource_assignment_id%TYPE
128: := FND_API.G_MISS_NUM

Line 127: pa_fin_plan_adj_lines.resource_assignment_id%TYPE

123: := FND_API.G_MISS_NUM
124: ,p_budget_version_id IN pa_fin_plan_adj_lines.budget_version_id%TYPE
125: := FND_API.G_MISS_NUM
126: ,p_resource_assignment_id IN
127: pa_fin_plan_adj_lines.resource_assignment_id%TYPE
128: := FND_API.G_MISS_NUM
129: ,p_period_name IN
130: pa_fin_plan_adj_lines.period_name%TYPE
131: := FND_API.G_MISS_CHAR

Line 130: pa_fin_plan_adj_lines.period_name%TYPE

126: ,p_resource_assignment_id IN
127: pa_fin_plan_adj_lines.resource_assignment_id%TYPE
128: := FND_API.G_MISS_NUM
129: ,p_period_name IN
130: pa_fin_plan_adj_lines.period_name%TYPE
131: := FND_API.G_MISS_CHAR
132: ,p_start_date IN pa_fin_plan_adj_lines.start_date%TYPE
133: := FND_API.G_MISS_DATE
134: ,p_end_date IN pa_fin_plan_adj_lines.end_date%TYPE

Line 132: ,p_start_date IN pa_fin_plan_adj_lines.start_date%TYPE

128: := FND_API.G_MISS_NUM
129: ,p_period_name IN
130: pa_fin_plan_adj_lines.period_name%TYPE
131: := FND_API.G_MISS_CHAR
132: ,p_start_date IN pa_fin_plan_adj_lines.start_date%TYPE
133: := FND_API.G_MISS_DATE
134: ,p_end_date IN pa_fin_plan_adj_lines.end_date%TYPE
135: := FND_API.G_MISS_DATE
136: ,p_raw_cost_adjustment IN pa_fin_plan_adj_lines.raw_cost_adjustment%TYPE

Line 134: ,p_end_date IN pa_fin_plan_adj_lines.end_date%TYPE

130: pa_fin_plan_adj_lines.period_name%TYPE
131: := FND_API.G_MISS_CHAR
132: ,p_start_date IN pa_fin_plan_adj_lines.start_date%TYPE
133: := FND_API.G_MISS_DATE
134: ,p_end_date IN pa_fin_plan_adj_lines.end_date%TYPE
135: := FND_API.G_MISS_DATE
136: ,p_raw_cost_adjustment IN pa_fin_plan_adj_lines.raw_cost_adjustment%TYPE
137: := FND_API.G_MISS_NUM
138: ,p_burdened_cost_adjustment IN

Line 136: ,p_raw_cost_adjustment IN pa_fin_plan_adj_lines.raw_cost_adjustment%TYPE

132: ,p_start_date IN pa_fin_plan_adj_lines.start_date%TYPE
133: := FND_API.G_MISS_DATE
134: ,p_end_date IN pa_fin_plan_adj_lines.end_date%TYPE
135: := FND_API.G_MISS_DATE
136: ,p_raw_cost_adjustment IN pa_fin_plan_adj_lines.raw_cost_adjustment%TYPE
137: := FND_API.G_MISS_NUM
138: ,p_burdened_cost_adjustment IN
139: pa_fin_plan_adj_lines.burdened_cost_adjustment%TYPE
140: := FND_API.G_MISS_NUM

Line 139: pa_fin_plan_adj_lines.burdened_cost_adjustment%TYPE

135: := FND_API.G_MISS_DATE
136: ,p_raw_cost_adjustment IN pa_fin_plan_adj_lines.raw_cost_adjustment%TYPE
137: := FND_API.G_MISS_NUM
138: ,p_burdened_cost_adjustment IN
139: pa_fin_plan_adj_lines.burdened_cost_adjustment%TYPE
140: := FND_API.G_MISS_NUM
141: ,p_revenue_adjustment IN pa_fin_plan_adj_lines.revenue_adjustment%TYPE
142: := FND_API.G_MISS_NUM
143: ,p_utilization_adjustment IN

Line 141: ,p_revenue_adjustment IN pa_fin_plan_adj_lines.revenue_adjustment%TYPE

137: := FND_API.G_MISS_NUM
138: ,p_burdened_cost_adjustment IN
139: pa_fin_plan_adj_lines.burdened_cost_adjustment%TYPE
140: := FND_API.G_MISS_NUM
141: ,p_revenue_adjustment IN pa_fin_plan_adj_lines.revenue_adjustment%TYPE
142: := FND_API.G_MISS_NUM
143: ,p_utilization_adjustment IN
144: pa_fin_plan_adj_lines.utilization_adjustment%TYPE
145: := FND_API.G_MISS_NUM

Line 144: pa_fin_plan_adj_lines.utilization_adjustment%TYPE

140: := FND_API.G_MISS_NUM
141: ,p_revenue_adjustment IN pa_fin_plan_adj_lines.revenue_adjustment%TYPE
142: := FND_API.G_MISS_NUM
143: ,p_utilization_adjustment IN
144: pa_fin_plan_adj_lines.utilization_adjustment%TYPE
145: := FND_API.G_MISS_NUM
146: ,p_head_count_adjustment IN pa_fin_plan_adj_lines.head_count_adjustment%TYPE
147: := FND_API.G_MISS_NUM
148: ,p_row_id IN ROWID

Line 146: ,p_head_count_adjustment IN pa_fin_plan_adj_lines.head_count_adjustment%TYPE

142: := FND_API.G_MISS_NUM
143: ,p_utilization_adjustment IN
144: pa_fin_plan_adj_lines.utilization_adjustment%TYPE
145: := FND_API.G_MISS_NUM
146: ,p_head_count_adjustment IN pa_fin_plan_adj_lines.head_count_adjustment%TYPE
147: := FND_API.G_MISS_NUM
148: ,p_row_id IN ROWID
149: := NULL
150: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 153: UPDATE pa_fin_plan_adj_lines

149: := NULL
150: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
151: IS
152: BEGIN
153: UPDATE pa_fin_plan_adj_lines
154: SET
155: last_update_login = fnd_global.login_id
156: ,last_updated_by = fnd_global.user_id
157: ,last_update_date = sysdate

Line 213: ( p_fin_plan_adj_line_id IN pa_fin_plan_adj_lines.fin_plan_adj_line_id%TYPE

209: RAISE;
210: END Update_Row;
211:
212: PROCEDURE Lock_Row
213: ( p_fin_plan_adj_line_id IN pa_fin_plan_adj_lines.fin_plan_adj_line_id%TYPE
214: := FND_API.G_MISS_NUM
215: ,p_row_id IN ROWID
216: := NULL
217: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 224: FROM pa_fin_plan_adj_lines

220: l_rowid ROWID;
221:
222: BEGIN
223: SELECT rowid into l_rowid
224: FROM pa_fin_plan_adj_lines
225: WHERE fin_plan_adj_line_id = p_fin_plan_adj_line_id
226: OR rowid = p_row_id
227: FOR UPDATE NOWAIT;
228:

Line 246: ( p_fin_plan_adj_line_id IN pa_fin_plan_adj_lines.fin_plan_adj_line_id%TYPE

242: RAISE;
243: END Lock_Row;
244:
245: PROCEDURE Delete_Row
246: ( p_fin_plan_adj_line_id IN pa_fin_plan_adj_lines.fin_plan_adj_line_id%TYPE
247: ,p_row_id IN ROWID
248: := NULL
249: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
250: IS

Line 257: DELETE FROM pa_fin_plan_adj_lines

253:
254: IF (p_fin_plan_adj_line_id IS NOT NULL AND
255: p_fin_plan_adj_line_id <> FND_API.G_MISS_NUM) THEN
256:
257: DELETE FROM pa_fin_plan_adj_lines
258: WHERE fin_plan_adj_line_id = p_fin_plan_adj_line_id;
259: ELSIF (p_row_id IS NOT NULL ) THEN
260: DELETE FROM pa_fin_plan_adj_lines
261: WHERE rowid = p_row_id;

Line 260: DELETE FROM pa_fin_plan_adj_lines

256:
257: DELETE FROM pa_fin_plan_adj_lines
258: WHERE fin_plan_adj_line_id = p_fin_plan_adj_line_id;
259: ELSIF (p_row_id IS NOT NULL ) THEN
260: DELETE FROM pa_fin_plan_adj_lines
261: WHERE rowid = p_row_id;
262: END IF;
263:
264: IF (SQL%NOTFOUND) THEN