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_ASSIGNMENT_APPROVAL_PUB dependencies on PA_NUM_TBL_TYPE

Line 22: prm_empty_num_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

18: g_req_resub CONSTANT VARCHAR2(24) := 'ASGMT_APPRVL_REQ_RESUB';
19: g_canceled CONSTANT VARCHAR2(24) := 'ASGMT_APPRVL_CANCELED';
20:
21: --Empty tables for mass assignment approval
22: prm_empty_num_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
23: prm_empty_varchar2_1_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
24: prm_empty_varchar2_30_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
25: prm_empty_varchar2_240_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
26:

Line 130: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

126: ,p_requirement_status_code IN VARCHAR2 := NULL
127: ,p_assignment_status_code IN VARCHAR2 := NULL
128: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
129: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
130: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
131: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
132: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
133: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
134: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 131: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

127: ,p_assignment_status_code IN VARCHAR2 := NULL
128: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
129: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
130: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
131: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
132: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
133: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
134: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
135: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 132: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

128: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
129: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
130: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
131: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
132: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
133: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
134: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
135: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
136: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 133: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

129: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
130: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
131: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
132: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
133: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
134: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
135: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
136: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
137: ,p_non_working_day_flag IN VARCHAR2 := 'N'

Line 134: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

130: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
131: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
132: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
133: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
134: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
135: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
136: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
137: ,p_non_working_day_flag IN VARCHAR2 := 'N'
138: ,p_change_hours_type_code IN VARCHAR2 := NULL

Line 135: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

131: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
132: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
133: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
134: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
135: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
136: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
137: ,p_non_working_day_flag IN VARCHAR2 := 'N'
138: ,p_change_hours_type_code IN VARCHAR2 := NULL
139: ,p_hrs_per_day IN NUMBER := NULL

Line 136: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

132: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
133: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
134: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
135: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
136: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
137: ,p_non_working_day_flag IN VARCHAR2 := 'N'
138: ,p_change_hours_type_code IN VARCHAR2 := NULL
139: ,p_hrs_per_day IN NUMBER := NULL
140: ,p_calendar_percent IN NUMBER := NULL

Line 212: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

208:
209: PROCEDURE mass_submit_for_asgmt_aprvl
210: (p_mode IN VARCHAR2
211: ,p_action IN VARCHAR2
212: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
213: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
214: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
215: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
216: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR

Line 213: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

209: PROCEDURE mass_submit_for_asgmt_aprvl
210: (p_mode IN VARCHAR2
211: ,p_action IN VARCHAR2
212: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
213: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
214: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
215: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
216: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
217: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR

Line 284: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

280: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
281: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
282: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
283: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
284: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
285: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
286: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
287: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
288: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 285: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

281: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
282: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
283: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
284: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
285: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
286: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
287: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
288: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
289: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 286: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

282: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
283: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
284: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
285: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
286: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
287: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
288: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
289: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
290: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 287: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

283: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
284: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
285: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
286: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
287: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
288: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
289: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
290: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
291: ,p_non_working_day_flag IN VARCHAR2 := 'N'

Line 288: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

284: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
285: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
286: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
287: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
288: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
289: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
290: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
291: ,p_non_working_day_flag IN VARCHAR2 := 'N'
292: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 289: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

285: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
286: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
287: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
288: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
289: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
290: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
291: ,p_non_working_day_flag IN VARCHAR2 := 'N'
292: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
293: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM

Line 290: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

286: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
287: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
288: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
289: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
290: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
291: ,p_non_working_day_flag IN VARCHAR2 := 'N'
292: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
293: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
294: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM

Line 301: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

297: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
298: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
299: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
300: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
301: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
302: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
303: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
304: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
305: ,p_appr_over_auth_flag IN VARCHAR2 := 'N'

Line 303: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

299: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
300: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
301: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
302: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
303: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
304: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
305: ,p_appr_over_auth_flag IN VARCHAR2 := 'N'
306: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
307: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

Line 307: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

303: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
304: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
305: ,p_appr_over_auth_flag IN VARCHAR2 := 'N'
306: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
307: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
308: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
309: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
310: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
311: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := prm_empty_varchar2_1_tbl

Line 310: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

306: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
307: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
308: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
309: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
310: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
311: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := prm_empty_varchar2_1_tbl
312: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
313: ,p_api_version IN NUMBER := 1.0
314: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

Line 325: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

321:
322: PROCEDURE mass_assignment_approval
323: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
324: ,p_mode IN VARCHAR2
325: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
326: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
327: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
328: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
329: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

Line 326: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

322: PROCEDURE mass_assignment_approval
323: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
324: ,p_mode IN VARCHAR2
325: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
326: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
327: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
328: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
329: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
330: ,p_overriding_authority_flag IN VARCHAR2 := 'N'

Line 328: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

324: ,p_mode IN VARCHAR2
325: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
326: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
327: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
328: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
329: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
330: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
331: ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM
332: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 348: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

344:
345: PROCEDURE mass_process_approval_result
346: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
347: ,p_mode IN VARCHAR2
348: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
349: ,p_approval_status_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
350: ,p_group_id IN NUMBER
351: ,p_approver_group_id IN NUMBER
352: ,p_routing_order IN NUMBER