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.PSB_POSITIONS_PVT dependencies on FND_API

Line 22: p_select_date in date := fnd_api.g_miss_date);

18:
19: PROCEDURE Initialize_View ( p_worksheet_id in number,
20: p_start_date in date,
21: p_end_date in date,
22: p_select_date in date := fnd_api.g_miss_date);
23:
24: PROCEDURE Define_Worksheet_Values (
25: p_api_version in number,
26: p_init_msg_list in varchar2 := fnd_api.g_false,

Line 26: p_init_msg_list in varchar2 := fnd_api.g_false,

22: p_select_date in date := fnd_api.g_miss_date);
23:
24: PROCEDURE Define_Worksheet_Values (
25: p_api_version in number,
26: p_init_msg_list in varchar2 := fnd_api.g_false,
27: p_commit in varchar2 := fnd_api.g_false,
28: p_validation_level in number := fnd_api.g_valid_level_full,
29: p_return_status OUT NOCOPY varchar2,
30: p_msg_count OUT NOCOPY number,

Line 27: p_commit in varchar2 := fnd_api.g_false,

23:
24: PROCEDURE Define_Worksheet_Values (
25: p_api_version in number,
26: p_init_msg_list in varchar2 := fnd_api.g_false,
27: p_commit in varchar2 := fnd_api.g_false,
28: p_validation_level in number := fnd_api.g_valid_level_full,
29: p_return_status OUT NOCOPY varchar2,
30: p_msg_count OUT NOCOPY number,
31: p_msg_data OUT NOCOPY varchar2,

Line 28: p_validation_level in number := fnd_api.g_valid_level_full,

24: PROCEDURE Define_Worksheet_Values (
25: p_api_version in number,
26: p_init_msg_list in varchar2 := fnd_api.g_false,
27: p_commit in varchar2 := fnd_api.g_false,
28: p_validation_level in number := fnd_api.g_valid_level_full,
29: p_return_status OUT NOCOPY varchar2,
30: p_msg_count OUT NOCOPY number,
31: p_msg_data OUT NOCOPY varchar2,
32: p_worksheet_id in number,

Line 34: p_pos_effective_start_date in date := FND_API.G_MISS_DATE,

30: p_msg_count OUT NOCOPY number,
31: p_msg_data OUT NOCOPY varchar2,
32: p_worksheet_id in number,
33: p_position_id in number,
34: p_pos_effective_start_date in date := FND_API.G_MISS_DATE,
35: p_pos_effective_end_date in date := FND_API.G_MISS_DATE,
36: p_budget_source in varchar2:= FND_API.G_MISS_CHAR,
37: p_out_worksheet_id OUT NOCOPY number,
38: p_out_start_date OUT NOCOPY date,

Line 35: p_pos_effective_end_date in date := FND_API.G_MISS_DATE,

31: p_msg_data OUT NOCOPY varchar2,
32: p_worksheet_id in number,
33: p_position_id in number,
34: p_pos_effective_start_date in date := FND_API.G_MISS_DATE,
35: p_pos_effective_end_date in date := FND_API.G_MISS_DATE,
36: p_budget_source in varchar2:= FND_API.G_MISS_CHAR,
37: p_out_worksheet_id OUT NOCOPY number,
38: p_out_start_date OUT NOCOPY date,
39: p_out_end_date OUT NOCOPY date);

Line 36: p_budget_source in varchar2:= FND_API.G_MISS_CHAR,

32: p_worksheet_id in number,
33: p_position_id in number,
34: p_pos_effective_start_date in date := FND_API.G_MISS_DATE,
35: p_pos_effective_end_date in date := FND_API.G_MISS_DATE,
36: p_budget_source in varchar2:= FND_API.G_MISS_CHAR,
37: p_out_worksheet_id OUT NOCOPY number,
38: p_out_start_date OUT NOCOPY date,
39: p_out_end_date OUT NOCOPY date);
40:

Line 63: p_init_msg_list in varchar2 := fnd_api.g_false,

59: --
60:
61: PROCEDURE Insert_Row (
62: p_api_version in number,
63: p_init_msg_list in varchar2 := fnd_api.g_false,
64: p_commit in varchar2 := fnd_api.g_false,
65: p_validation_level in number := fnd_api.g_valid_level_full,
66: p_return_status OUT NOCOPY varchar2,
67: p_msg_count OUT NOCOPY number,

Line 64: p_commit in varchar2 := fnd_api.g_false,

60:
61: PROCEDURE Insert_Row (
62: p_api_version in number,
63: p_init_msg_list in varchar2 := fnd_api.g_false,
64: p_commit in varchar2 := fnd_api.g_false,
65: p_validation_level in number := fnd_api.g_valid_level_full,
66: p_return_status OUT NOCOPY varchar2,
67: p_msg_count OUT NOCOPY number,
68: p_msg_data OUT NOCOPY varchar2,

Line 65: p_validation_level in number := fnd_api.g_valid_level_full,

61: PROCEDURE Insert_Row (
62: p_api_version in number,
63: p_init_msg_list in varchar2 := fnd_api.g_false,
64: p_commit in varchar2 := fnd_api.g_false,
65: p_validation_level in number := fnd_api.g_valid_level_full,
66: p_return_status OUT NOCOPY varchar2,
67: p_msg_count OUT NOCOPY number,
68: p_msg_data OUT NOCOPY varchar2,
69: p_rowid in OUT NOCOPY varchar2,

Line 76: p_hr_employee_id in number := fnd_api.g_miss_num ,

72: p_organization_id in number := NULL,
73: p_data_extract_id in number,
74: p_position_definition_id in number,
75: p_hr_position_id in number,
76: p_hr_employee_id in number := fnd_api.g_miss_num ,
77: p_business_group_id in number,
78: p_budget_group_id in number := fnd_api.g_miss_num ,
79: p_effective_start_date in date,
80: p_effective_end_date in date,

Line 78: p_budget_group_id in number := fnd_api.g_miss_num ,

74: p_position_definition_id in number,
75: p_hr_position_id in number,
76: p_hr_employee_id in number := fnd_api.g_miss_num ,
77: p_business_group_id in number,
78: p_budget_group_id in number := fnd_api.g_miss_num ,
79: p_effective_start_date in date,
80: p_effective_end_date in date,
81: p_set_of_books_id in number,
82: p_vacant_position_flag in varchar2,

Line 83: p_availability_status in varchar2 := fnd_api.g_miss_char ,

79: p_effective_start_date in date,
80: p_effective_end_date in date,
81: p_set_of_books_id in number,
82: p_vacant_position_flag in varchar2,
83: p_availability_status in varchar2 := fnd_api.g_miss_char ,
84: p_transaction_id in number := fnd_api.g_miss_num ,
85: p_transaction_status in varchar2 := fnd_api.g_miss_char ,
86: p_new_position_flag in varchar2 := fnd_api.g_miss_char ,
87: p_attribute1 in varchar2,

Line 84: p_transaction_id in number := fnd_api.g_miss_num ,

80: p_effective_end_date in date,
81: p_set_of_books_id in number,
82: p_vacant_position_flag in varchar2,
83: p_availability_status in varchar2 := fnd_api.g_miss_char ,
84: p_transaction_id in number := fnd_api.g_miss_num ,
85: p_transaction_status in varchar2 := fnd_api.g_miss_char ,
86: p_new_position_flag in varchar2 := fnd_api.g_miss_char ,
87: p_attribute1 in varchar2,
88: p_attribute2 in varchar2,

Line 85: p_transaction_status in varchar2 := fnd_api.g_miss_char ,

81: p_set_of_books_id in number,
82: p_vacant_position_flag in varchar2,
83: p_availability_status in varchar2 := fnd_api.g_miss_char ,
84: p_transaction_id in number := fnd_api.g_miss_num ,
85: p_transaction_status in varchar2 := fnd_api.g_miss_char ,
86: p_new_position_flag in varchar2 := fnd_api.g_miss_char ,
87: p_attribute1 in varchar2,
88: p_attribute2 in varchar2,
89: p_attribute3 in varchar2,

Line 86: p_new_position_flag in varchar2 := fnd_api.g_miss_char ,

82: p_vacant_position_flag in varchar2,
83: p_availability_status in varchar2 := fnd_api.g_miss_char ,
84: p_transaction_id in number := fnd_api.g_miss_num ,
85: p_transaction_status in varchar2 := fnd_api.g_miss_char ,
86: p_new_position_flag in varchar2 := fnd_api.g_miss_char ,
87: p_attribute1 in varchar2,
88: p_attribute2 in varchar2,
89: p_attribute3 in varchar2,
90: p_attribute4 in varchar2,

Line 117: p_init_msg_list in varchar2 := fnd_api.g_false,

113: --
114:
115: PROCEDURE LOCK_ROW (
116: p_api_version in number,
117: p_init_msg_list in varchar2 := fnd_api.g_false,
118: p_commit in varchar2 := fnd_api.g_false,
119: p_validation_level in number := fnd_api.g_valid_level_full,
120: p_return_status OUT NOCOPY varchar2,
121: p_msg_count OUT NOCOPY number,

Line 118: p_commit in varchar2 := fnd_api.g_false,

114:
115: PROCEDURE LOCK_ROW (
116: p_api_version in number,
117: p_init_msg_list in varchar2 := fnd_api.g_false,
118: p_commit in varchar2 := fnd_api.g_false,
119: p_validation_level in number := fnd_api.g_valid_level_full,
120: p_return_status OUT NOCOPY varchar2,
121: p_msg_count OUT NOCOPY number,
122: p_msg_data OUT NOCOPY varchar2,

Line 119: p_validation_level in number := fnd_api.g_valid_level_full,

115: PROCEDURE LOCK_ROW (
116: p_api_version in number,
117: p_init_msg_list in varchar2 := fnd_api.g_false,
118: p_commit in varchar2 := fnd_api.g_false,
119: p_validation_level in number := fnd_api.g_valid_level_full,
120: p_return_status OUT NOCOPY varchar2,
121: p_msg_count OUT NOCOPY number,
122: p_msg_data OUT NOCOPY varchar2,
123: p_row_locked OUT NOCOPY varchar2,

Line 162: p_init_msg_list in varchar2 := fnd_api.g_false,

158: --
159: --
160: PROCEDURE Update_Row (
161: p_api_version in number,
162: p_init_msg_list in varchar2 := fnd_api.g_false,
163: p_commit in varchar2 := fnd_api.g_false,
164: p_validation_level in number := fnd_api.g_valid_level_full,
165: p_return_status OUT NOCOPY varchar2,
166: p_msg_count OUT NOCOPY number,

Line 163: p_commit in varchar2 := fnd_api.g_false,

159: --
160: PROCEDURE Update_Row (
161: p_api_version in number,
162: p_init_msg_list in varchar2 := fnd_api.g_false,
163: p_commit in varchar2 := fnd_api.g_false,
164: p_validation_level in number := fnd_api.g_valid_level_full,
165: p_return_status OUT NOCOPY varchar2,
166: p_msg_count OUT NOCOPY number,
167: p_msg_data OUT NOCOPY varchar2,

Line 164: p_validation_level in number := fnd_api.g_valid_level_full,

160: PROCEDURE Update_Row (
161: p_api_version in number,
162: p_init_msg_list in varchar2 := fnd_api.g_false,
163: p_commit in varchar2 := fnd_api.g_false,
164: p_validation_level in number := fnd_api.g_valid_level_full,
165: p_return_status OUT NOCOPY varchar2,
166: p_msg_count OUT NOCOPY number,
167: p_msg_data OUT NOCOPY varchar2,
168: p_position_id in number,

Line 174: p_hr_employee_id in number := fnd_api.g_miss_num ,

170: p_organization_id in number := NULL,
171: p_data_extract_id in number,
172: p_position_definition_id in number,
173: p_hr_position_id in number,
174: p_hr_employee_id in number := fnd_api.g_miss_num ,
175: p_business_group_id in number,
176: p_budget_group_id in number := fnd_api.g_miss_num ,
177: p_effective_start_date in date,
178: p_effective_end_date in date,

Line 176: p_budget_group_id in number := fnd_api.g_miss_num ,

172: p_position_definition_id in number,
173: p_hr_position_id in number,
174: p_hr_employee_id in number := fnd_api.g_miss_num ,
175: p_business_group_id in number,
176: p_budget_group_id in number := fnd_api.g_miss_num ,
177: p_effective_start_date in date,
178: p_effective_end_date in date,
179: p_set_of_books_id in number,
180: p_vacant_position_flag in varchar2,

Line 181: p_availability_status in varchar2 := fnd_api.g_miss_char ,

177: p_effective_start_date in date,
178: p_effective_end_date in date,
179: p_set_of_books_id in number,
180: p_vacant_position_flag in varchar2,
181: p_availability_status in varchar2 := fnd_api.g_miss_char ,
182: p_transaction_id in number := fnd_api.g_miss_num ,
183: p_transaction_status in varchar2 := fnd_api.g_miss_char ,
184: p_new_position_flag in varchar2 := fnd_api.g_miss_char ,
185: p_attribute1 in varchar2,

Line 182: p_transaction_id in number := fnd_api.g_miss_num ,

178: p_effective_end_date in date,
179: p_set_of_books_id in number,
180: p_vacant_position_flag in varchar2,
181: p_availability_status in varchar2 := fnd_api.g_miss_char ,
182: p_transaction_id in number := fnd_api.g_miss_num ,
183: p_transaction_status in varchar2 := fnd_api.g_miss_char ,
184: p_new_position_flag in varchar2 := fnd_api.g_miss_char ,
185: p_attribute1 in varchar2,
186: p_attribute2 in varchar2,

Line 183: p_transaction_status in varchar2 := fnd_api.g_miss_char ,

179: p_set_of_books_id in number,
180: p_vacant_position_flag in varchar2,
181: p_availability_status in varchar2 := fnd_api.g_miss_char ,
182: p_transaction_id in number := fnd_api.g_miss_num ,
183: p_transaction_status in varchar2 := fnd_api.g_miss_char ,
184: p_new_position_flag in varchar2 := fnd_api.g_miss_char ,
185: p_attribute1 in varchar2,
186: p_attribute2 in varchar2,
187: p_attribute3 in varchar2,

Line 184: p_new_position_flag in varchar2 := fnd_api.g_miss_char ,

180: p_vacant_position_flag in varchar2,
181: p_availability_status in varchar2 := fnd_api.g_miss_char ,
182: p_transaction_id in number := fnd_api.g_miss_num ,
183: p_transaction_status in varchar2 := fnd_api.g_miss_char ,
184: p_new_position_flag in varchar2 := fnd_api.g_miss_char ,
185: p_attribute1 in varchar2,
186: p_attribute2 in varchar2,
187: p_attribute3 in varchar2,
188: p_attribute4 in varchar2,

Line 215: p_init_msg_list in varchar2 := fnd_api.g_false,

211: --
212: --
213: PROCEDURE ADD_ROW (
214: p_api_version in number,
215: p_init_msg_list in varchar2 := fnd_api.g_false,
216: p_commit in varchar2 := fnd_api.g_false,
217: p_validation_level in number := fnd_api.g_valid_level_full,
218: p_return_status OUT NOCOPY varchar2,
219: p_msg_count OUT NOCOPY number,

Line 216: p_commit in varchar2 := fnd_api.g_false,

212: --
213: PROCEDURE ADD_ROW (
214: p_api_version in number,
215: p_init_msg_list in varchar2 := fnd_api.g_false,
216: p_commit in varchar2 := fnd_api.g_false,
217: p_validation_level in number := fnd_api.g_valid_level_full,
218: p_return_status OUT NOCOPY varchar2,
219: p_msg_count OUT NOCOPY number,
220: p_msg_data OUT NOCOPY varchar2,

Line 217: p_validation_level in number := fnd_api.g_valid_level_full,

213: PROCEDURE ADD_ROW (
214: p_api_version in number,
215: p_init_msg_list in varchar2 := fnd_api.g_false,
216: p_commit in varchar2 := fnd_api.g_false,
217: p_validation_level in number := fnd_api.g_valid_level_full,
218: p_return_status OUT NOCOPY varchar2,
219: p_msg_count OUT NOCOPY number,
220: p_msg_data OUT NOCOPY varchar2,
221: p_rowid in OUT NOCOPY varchar2,

Line 262: p_init_msg_list in varchar2 := fnd_api.g_false,

258: --
259: --
260: PROCEDURE Delete_Row (
261: p_api_version in number,
262: p_init_msg_list in varchar2 := fnd_api.g_false,
263: p_commit in varchar2 := fnd_api.g_false,
264: p_validation_level in number := fnd_api.g_valid_level_full,
265: p_return_status OUT NOCOPY varchar2,
266: p_msg_count OUT NOCOPY number,

Line 263: p_commit in varchar2 := fnd_api.g_false,

259: --
260: PROCEDURE Delete_Row (
261: p_api_version in number,
262: p_init_msg_list in varchar2 := fnd_api.g_false,
263: p_commit in varchar2 := fnd_api.g_false,
264: p_validation_level in number := fnd_api.g_valid_level_full,
265: p_return_status OUT NOCOPY varchar2,
266: p_msg_count OUT NOCOPY number,
267: p_msg_data OUT NOCOPY varchar2,

Line 264: p_validation_level in number := fnd_api.g_valid_level_full,

260: PROCEDURE Delete_Row (
261: p_api_version in number,
262: p_init_msg_list in varchar2 := fnd_api.g_false,
263: p_commit in varchar2 := fnd_api.g_false,
264: p_validation_level in number := fnd_api.g_valid_level_full,
265: p_return_status OUT NOCOPY varchar2,
266: p_msg_count OUT NOCOPY number,
267: p_msg_data OUT NOCOPY varchar2,
268: p_position_id in number

Line 273: p_init_msg_list in varchar2 := fnd_api.g_false,

269: );
270: --
271: PROCEDURE Delete_Assignments (
272: p_api_version in number,
273: p_init_msg_list in varchar2 := fnd_api.g_false,
274: p_commit in varchar2 := fnd_api.g_false,
275: p_validation_level in number := fnd_api.g_valid_level_full,
276: p_return_status OUT NOCOPY varchar2,
277: p_msg_count OUT NOCOPY number,

Line 274: p_commit in varchar2 := fnd_api.g_false,

270: --
271: PROCEDURE Delete_Assignments (
272: p_api_version in number,
273: p_init_msg_list in varchar2 := fnd_api.g_false,
274: p_commit in varchar2 := fnd_api.g_false,
275: p_validation_level in number := fnd_api.g_valid_level_full,
276: p_return_status OUT NOCOPY varchar2,
277: p_msg_count OUT NOCOPY number,
278: p_msg_data OUT NOCOPY varchar2,

Line 275: p_validation_level in number := fnd_api.g_valid_level_full,

271: PROCEDURE Delete_Assignments (
272: p_api_version in number,
273: p_init_msg_list in varchar2 := fnd_api.g_false,
274: p_commit in varchar2 := fnd_api.g_false,
275: p_validation_level in number := fnd_api.g_valid_level_full,
276: p_return_status OUT NOCOPY varchar2,
277: p_msg_count OUT NOCOPY number,
278: p_msg_data OUT NOCOPY varchar2,
279: p_worksheet_id in number

Line 285: p_init_msg_list in varchar2 := fnd_api.g_false,

281: --
282: --
283: PROCEDURE Delete_Assignment_Employees (
284: p_api_version in number,
285: p_init_msg_list in varchar2 := fnd_api.g_false,
286: p_commit in varchar2 := fnd_api.g_false,
287: p_validation_level in number := fnd_api.g_valid_level_full,
288: p_return_status OUT NOCOPY varchar2,
289: p_msg_count OUT NOCOPY number,

Line 286: p_commit in varchar2 := fnd_api.g_false,

282: --
283: PROCEDURE Delete_Assignment_Employees (
284: p_api_version in number,
285: p_init_msg_list in varchar2 := fnd_api.g_false,
286: p_commit in varchar2 := fnd_api.g_false,
287: p_validation_level in number := fnd_api.g_valid_level_full,
288: p_return_status OUT NOCOPY varchar2,
289: p_msg_count OUT NOCOPY number,
290: p_msg_data OUT NOCOPY varchar2,

Line 287: p_validation_level in number := fnd_api.g_valid_level_full,

283: PROCEDURE Delete_Assignment_Employees (
284: p_api_version in number,
285: p_init_msg_list in varchar2 := fnd_api.g_false,
286: p_commit in varchar2 := fnd_api.g_false,
287: p_validation_level in number := fnd_api.g_valid_level_full,
288: p_return_status OUT NOCOPY varchar2,
289: p_msg_count OUT NOCOPY number,
290: p_msg_data OUT NOCOPY varchar2,
291: p_data_extract_id in number

Line 298: p_init_msg_list in varchar2 := fnd_api.g_false,

294: -- Modify_assignment used for insert/modify assignments
295: --
296: PROCEDURE Modify_Assignment
297: ( p_api_version in number,
298: p_init_msg_list in varchar2 := fnd_api.g_false,
299: p_commit in varchar2 := fnd_api.g_false,
300: p_validation_level in number := fnd_api.g_valid_level_full,
301: p_return_status OUT NOCOPY varchar2,
302: p_msg_count OUT NOCOPY number,

Line 299: p_commit in varchar2 := fnd_api.g_false,

295: --
296: PROCEDURE Modify_Assignment
297: ( p_api_version in number,
298: p_init_msg_list in varchar2 := fnd_api.g_false,
299: p_commit in varchar2 := fnd_api.g_false,
300: p_validation_level in number := fnd_api.g_valid_level_full,
301: p_return_status OUT NOCOPY varchar2,
302: p_msg_count OUT NOCOPY number,
303: p_msg_data OUT NOCOPY varchar2,

Line 300: p_validation_level in number := fnd_api.g_valid_level_full,

296: PROCEDURE Modify_Assignment
297: ( p_api_version in number,
298: p_init_msg_list in varchar2 := fnd_api.g_false,
299: p_commit in varchar2 := fnd_api.g_false,
300: p_validation_level in number := fnd_api.g_valid_level_full,
301: p_return_status OUT NOCOPY varchar2,
302: p_msg_count OUT NOCOPY number,
303: p_msg_data OUT NOCOPY varchar2,
304: p_position_assignment_id in OUT NOCOPY number,

Line 333: p_init_msg_list in varchar2 := fnd_api.g_false,

329: --
330: --
331: PROCEDURE Validate_Salary
332: ( p_api_version in number,
333: p_init_msg_list in varchar2 := fnd_api.g_false,
334: p_commit in varchar2 := fnd_api.g_false,
335: p_validation_level in number := fnd_api.g_valid_level_full,
336: p_return_status OUT NOCOPY varchar2,
337: p_msg_count OUT NOCOPY number,

Line 334: p_commit in varchar2 := fnd_api.g_false,

330: --
331: PROCEDURE Validate_Salary
332: ( p_api_version in number,
333: p_init_msg_list in varchar2 := fnd_api.g_false,
334: p_commit in varchar2 := fnd_api.g_false,
335: p_validation_level in number := fnd_api.g_valid_level_full,
336: p_return_status OUT NOCOPY varchar2,
337: p_msg_count OUT NOCOPY number,
338: p_msg_data OUT NOCOPY varchar2,

Line 335: p_validation_level in number := fnd_api.g_valid_level_full,

331: PROCEDURE Validate_Salary
332: ( p_api_version in number,
333: p_init_msg_list in varchar2 := fnd_api.g_false,
334: p_commit in varchar2 := fnd_api.g_false,
335: p_validation_level in number := fnd_api.g_valid_level_full,
336: p_return_status OUT NOCOPY varchar2,
337: p_msg_count OUT NOCOPY number,
338: p_msg_data OUT NOCOPY varchar2,
339: p_worksheet_id in number,

Line 352: p_init_msg_list in varchar2 := fnd_api.g_false,

348: --added the parameter p_validation_mode as part of bug fix 3247574
349:
350: PROCEDURE Position_WS_Validation
351: ( p_api_version in number,
352: p_init_msg_list in varchar2 := fnd_api.g_false,
353: p_commit in varchar2 := fnd_api.g_false,
354: p_validation_level in number := fnd_api.g_valid_level_full,
355: p_return_status OUT NOCOPY varchar2,
356: p_msg_count OUT NOCOPY number,

Line 353: p_commit in varchar2 := fnd_api.g_false,

349:
350: PROCEDURE Position_WS_Validation
351: ( p_api_version in number,
352: p_init_msg_list in varchar2 := fnd_api.g_false,
353: p_commit in varchar2 := fnd_api.g_false,
354: p_validation_level in number := fnd_api.g_valid_level_full,
355: p_return_status OUT NOCOPY varchar2,
356: p_msg_count OUT NOCOPY number,
357: p_msg_data OUT NOCOPY varchar2,

Line 354: p_validation_level in number := fnd_api.g_valid_level_full,

350: PROCEDURE Position_WS_Validation
351: ( p_api_version in number,
352: p_init_msg_list in varchar2 := fnd_api.g_false,
353: p_commit in varchar2 := fnd_api.g_false,
354: p_validation_level in number := fnd_api.g_valid_level_full,
355: p_return_status OUT NOCOPY varchar2,
356: p_msg_count OUT NOCOPY number,
357: p_msg_data OUT NOCOPY varchar2,
358: p_worksheet_id in number ,

Line 369: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

365: -- added the extra parameter p_ruleset_id for passing the
366: -- id for the default ruleset
367: PROCEDURE Create_Default_Assignments
368: ( p_api_version IN NUMBER,
369: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
370: p_commit IN VARCHAR2 := FND_API.G_FALSE,
371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372: p_return_status OUT NOCOPY VARCHAR2,
373: p_msg_count OUT NOCOPY NUMBER,

Line 370: p_commit IN VARCHAR2 := FND_API.G_FALSE,

366: -- id for the default ruleset
367: PROCEDURE Create_Default_Assignments
368: ( p_api_version IN NUMBER,
369: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
370: p_commit IN VARCHAR2 := FND_API.G_FALSE,
371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372: p_return_status OUT NOCOPY VARCHAR2,
373: p_msg_count OUT NOCOPY NUMBER,
374: p_msg_data OUT NOCOPY VARCHAR2,

Line 371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

367: PROCEDURE Create_Default_Assignments
368: ( p_api_version IN NUMBER,
369: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
370: p_commit IN VARCHAR2 := FND_API.G_FALSE,
371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372: p_return_status OUT NOCOPY VARCHAR2,
373: p_msg_count OUT NOCOPY NUMBER,
374: p_msg_data OUT NOCOPY VARCHAR2,
375: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

Line 375: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372: p_return_status OUT NOCOPY VARCHAR2,
373: p_msg_count OUT NOCOPY NUMBER,
374: p_msg_data OUT NOCOPY VARCHAR2,
375: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
376: p_data_extract_id IN NUMBER,
377: p_position_id IN NUMBER := FND_API.G_MISS_NUM,
378: p_position_start_date IN DATE := FND_API.G_MISS_DATE,
379: p_position_end_date IN DATE := FND_API.G_MISS_DATE,

Line 377: p_position_id IN NUMBER := FND_API.G_MISS_NUM,

373: p_msg_count OUT NOCOPY NUMBER,
374: p_msg_data OUT NOCOPY VARCHAR2,
375: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
376: p_data_extract_id IN NUMBER,
377: p_position_id IN NUMBER := FND_API.G_MISS_NUM,
378: p_position_start_date IN DATE := FND_API.G_MISS_DATE,
379: p_position_end_date IN DATE := FND_API.G_MISS_DATE,
380: p_ruleset_id IN NUMBER := NULL
381: );

Line 378: p_position_start_date IN DATE := FND_API.G_MISS_DATE,

374: p_msg_data OUT NOCOPY VARCHAR2,
375: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
376: p_data_extract_id IN NUMBER,
377: p_position_id IN NUMBER := FND_API.G_MISS_NUM,
378: p_position_start_date IN DATE := FND_API.G_MISS_DATE,
379: p_position_end_date IN DATE := FND_API.G_MISS_DATE,
380: p_ruleset_id IN NUMBER := NULL
381: );
382: --

Line 379: p_position_end_date IN DATE := FND_API.G_MISS_DATE,

375: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
376: p_data_extract_id IN NUMBER,
377: p_position_id IN NUMBER := FND_API.G_MISS_NUM,
378: p_position_start_date IN DATE := FND_API.G_MISS_DATE,
379: p_position_end_date IN DATE := FND_API.G_MISS_DATE,
380: p_ruleset_id IN NUMBER := NULL
381: );
382: --
383: --

Line 387: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

383: --
384: --
385: FUNCTION Rev_Check_Allowed
386: ( p_api_version IN NUMBER,
387: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
388: p_startdate_pp IN DATE,
389: p_enddate_cy IN DATE,
390: p_worksheet_id IN NUMBER,
391: p_position_budget_group_id IN NUMBER

Line 434: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

430: /* Bug 4273099 made the following api public */
431: -- Bug 4545909 added the parameter p_worksheet_id
432: PROCEDURE Apply_Position_Default_Rules
433: ( p_api_version IN NUMBER,
434: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
435: p_commit IN VARCHAR2 := FND_API.G_FALSE,
436: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
437: x_return_status OUT NOCOPY VARCHAR2,
438: x_msg_count OUT NOCOPY NUMBER,

Line 435: p_commit IN VARCHAR2 := FND_API.G_FALSE,

431: -- Bug 4545909 added the parameter p_worksheet_id
432: PROCEDURE Apply_Position_Default_Rules
433: ( p_api_version IN NUMBER,
434: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
435: p_commit IN VARCHAR2 := FND_API.G_FALSE,
436: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
437: x_return_status OUT NOCOPY VARCHAR2,
438: x_msg_count OUT NOCOPY NUMBER,
439: x_msg_data OUT NOCOPY VARCHAR2,

Line 436: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

432: PROCEDURE Apply_Position_Default_Rules
433: ( p_api_version IN NUMBER,
434: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
435: p_commit IN VARCHAR2 := FND_API.G_FALSE,
436: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
437: x_return_status OUT NOCOPY VARCHAR2,
438: x_msg_count OUT NOCOPY NUMBER,
439: x_msg_data OUT NOCOPY VARCHAR2,
440: p_position_assignment_id IN OUT NOCOPY NUMBER,