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_ASSIGNMENTS_HISTORY_PKG dependencies on PA_ASSIGNMENTS_HISTORY_S

Line 12: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR

8: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
9: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
10: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
11: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM

Line 13: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

9: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
10: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
11: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
17: ,p_resource_id IN pa_assignments_history.resource_id%TYPE := FND_API.G_MISS_NUM

Line 14: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM

10: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
11: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
17: ,p_resource_id IN pa_assignments_history.resource_id%TYPE := FND_API.G_MISS_NUM
18: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM

Line 22: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE

18: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
19: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
20: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
21: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
22: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
23: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
24: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
25: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
26: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM

Line 26: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM

22: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
23: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
24: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
25: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
26: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
27: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
28: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
29: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
30: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR

Line 55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM

51: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
52: ,p_comp_match_weighting IN pa_assignments_history.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
53: ,p_avail_match_weighting IN pa_assignments_history.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
54: ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM
56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR
57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM
58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

Line 56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR

52: ,p_comp_match_weighting IN pa_assignments_history.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
53: ,p_avail_match_weighting IN pa_assignments_history.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
54: ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM
56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR
57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM
58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
60: ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE

Line 57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM

53: ,p_avail_match_weighting IN pa_assignments_history.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
54: ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM
56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR
57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM
58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
60: ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE
61: ,p_enable_auto_cand_nom_flag IN pa_assignments_history.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR

Line 58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM

54: ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM
56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR
57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM
58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
60: ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE
61: ,p_enable_auto_cand_nom_flag IN pa_assignments_history.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
62: ,p_mass_wf_in_progress_flag IN pa_assignments_history.mass_wf_in_progress_flag%TYPE := FND_API.G_MISS_CHAR

Line 59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM
56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR
57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM
58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
60: ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE
61: ,p_enable_auto_cand_nom_flag IN pa_assignments_history.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
62: ,p_mass_wf_in_progress_flag IN pa_assignments_history.mass_wf_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
63: ,p_bill_rate_override IN pa_assignments_history.bill_rate_override%TYPE := FND_API.G_MISS_NUM

Line 201: pa_assignments_history_s.NEXTVAL,

197: DECODE(p_assignment_name, FND_API.G_MISS_CHAR, NULL, p_assignment_name),
198: DECODE(p_assignment_type, FND_API.G_MISS_CHAR, NULL, p_assignment_type),
199: DECODE(p_multiple_status_flag, FND_API.G_MISS_CHAR, NULL, p_multiple_status_flag),
200: DECODE(p_record_version_number, FND_API.G_MISS_NUM, NULL, p_record_version_number),
201: pa_assignments_history_s.NEXTVAL,
202: DECODE(p_apprvl_status_code, FND_API.G_MISS_CHAR, NULL, p_apprvl_status_code),
203: DECODE(p_status_code, FND_API.G_MISS_CHAR, NULL, p_status_code),
204: DECODE(p_staffing_priority_code, FND_API.G_MISS_CHAR, NULL, p_staffing_priority_code),
205: DECODE(p_staffing_owner_person_id, FND_API.G_MISS_NUM, NULL, p_staffing_owner_person_id),

Line 311: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR

307: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
308: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
309: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
310: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
311: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
312: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
313: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
314: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
315: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM

Line 312: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

308: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
309: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
310: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
311: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
312: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
313: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
314: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
315: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
316: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM

Line 313: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM

309: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
310: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
311: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
312: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
313: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
314: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
315: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
316: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
317: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM

Line 320: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE

316: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
317: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
318: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
319: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
320: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
321: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
322: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
323: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
324: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM

Line 324: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM

320: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
321: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
322: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
323: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
324: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
325: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
326: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
327: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
328: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM