DBA Data[Home] [Help]

APPS.PA_PROJECT_ASSIGNMENTS_PKG dependencies on PA_PROJECT_ASSIGNMENTS_S

Line 10: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR

6: ( p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
7: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
8: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
9: ,p_apprvl_status_code IN pa_project_assignments.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
10: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
13: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
14: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM

Line 11: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

7: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
8: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
9: ,p_apprvl_status_code IN pa_project_assignments.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
10: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
13: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
14: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
15: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM

Line 19: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE

15: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
17: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
18: ,p_note_to_approver IN pa_project_assignments.note_to_approver%TYPE := FND_API.G_MISS_CHAR
19: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
20: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
21: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
22: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
23: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM

Line 23: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM

19: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
20: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
21: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
22: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
23: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
24: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
25: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
26: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
27: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM

Line 49: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM

45: ,p_no_of_active_candidates IN pa_project_assignments.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
46: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
47: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
48: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
49: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
50: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
52: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
53: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

Line 50: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR

46: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
47: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
48: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
49: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
50: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
52: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
53: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
54: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR

Line 51: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM

47: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
48: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
49: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
50: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
52: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
53: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
54: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
55: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM

Line 52: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM

48: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
49: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
50: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
52: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
53: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
54: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
55: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
56: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR

Line 53: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

49: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
50: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
52: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
53: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
54: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
55: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
56: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
57: ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM

Line 64: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM -- FP.L Development

60: ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM
61: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
62: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
63: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
64: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM -- FP.L Development
65: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM -- FP.M Development
66: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
67: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
68: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR

Line 111: TYPE status_code IS TABLE OF pa_project_assignments.status_code%TYPE

107: l_multiple_status_flag multiple_status_flag;
108: TYPE apprvl_status_code IS TABLE OF pa_project_assignments.apprvl_status_code%TYPE
109: INDEX BY BINARY_INTEGER;
110: l_apprvl_status_code apprvl_status_code;
111: TYPE status_code IS TABLE OF pa_project_assignments.status_code%TYPE
112: INDEX BY BINARY_INTEGER;
113: l_status_code status_code;
114: TYPE staffing_priority_code IS TABLE OF pa_project_assignments.staffing_priority_code%TYPE
115: INDEX BY BINARY_INTEGER;

Line 114: TYPE staffing_priority_code IS TABLE OF pa_project_assignments.staffing_priority_code%TYPE

110: l_apprvl_status_code apprvl_status_code;
111: TYPE status_code IS TABLE OF pa_project_assignments.status_code%TYPE
112: INDEX BY BINARY_INTEGER;
113: l_status_code status_code;
114: TYPE staffing_priority_code IS TABLE OF pa_project_assignments.staffing_priority_code%TYPE
115: INDEX BY BINARY_INTEGER;
116: l_staffing_priority_code staffing_priority_code;
117: TYPE project_id IS TABLE OF pa_project_assignments.project_id%TYPE
118: INDEX BY BINARY_INTEGER;

Line 138: TYPE start_date IS TABLE OF pa_project_assignments.start_date%TYPE

134: l_description description;
135: TYPE note_to_approver IS TABLE OF pa_project_assignments.note_to_approver%TYPE
136: INDEX BY BINARY_INTEGER;
137: l_note_to_approver note_to_approver;
138: TYPE start_date IS TABLE OF pa_project_assignments.start_date%TYPE
139: INDEX BY BINARY_INTEGER;
140: l_start_date start_date;
141: TYPE end_date IS TABLE OF pa_project_assignments.end_date%TYPE
142: INDEX BY BINARY_INTEGER;

Line 150: TYPE source_assignment_id IS TABLE OF pa_project_assignments.source_assignment_id%TYPE

146: l_assignment_effort assignment_effort;
147: TYPE extension_possible IS TABLE OF pa_project_assignments.extension_possible%TYPE
148: INDEX BY BINARY_INTEGER;
149: l_extension_possible extension_possible;
150: TYPE source_assignment_id IS TABLE OF pa_project_assignments.source_assignment_id%TYPE
151: INDEX BY BINARY_INTEGER;
152: l_source_assignment_id source_assignment_id;
153: TYPE min_resource_job_level IS TABLE OF pa_project_assignments.min_resource_job_level%TYPE
154: INDEX BY BINARY_INTEGER;

Line 234: TYPE search_min_availability IS TABLE OF pa_project_assignments.search_min_availability%TYPE

230: TYPE job_level_match_weighting IS TABLE OF pa_project_assignments.job_level_match_weighting%TYPE
231: INDEX BY BINARY_INTEGER;
232: l_job_level_match_weighting job_level_match_weighting;
233:
234: TYPE search_min_availability IS TABLE OF pa_project_assignments.search_min_availability%TYPE
235: INDEX BY BINARY_INTEGER;
236: l_search_min_availability search_min_availability;
237:
238: TYPE search_country_code IS TABLE OF pa_project_assignments.search_country_code%TYPE

Line 238: TYPE search_country_code IS TABLE OF pa_project_assignments.search_country_code%TYPE

234: TYPE search_min_availability IS TABLE OF pa_project_assignments.search_min_availability%TYPE
235: INDEX BY BINARY_INTEGER;
236: l_search_min_availability search_min_availability;
237:
238: TYPE search_country_code IS TABLE OF pa_project_assignments.search_country_code%TYPE
239: INDEX BY BINARY_INTEGER;
240: l_search_country_code search_country_code;
241:
242: TYPE search_exp_org_struct_ver_id IS TABLE OF pa_project_assignments.search_exp_org_struct_ver_id%TYPE

Line 242: TYPE search_exp_org_struct_ver_id IS TABLE OF pa_project_assignments.search_exp_org_struct_ver_id%TYPE

238: TYPE search_country_code IS TABLE OF pa_project_assignments.search_country_code%TYPE
239: INDEX BY BINARY_INTEGER;
240: l_search_country_code search_country_code;
241:
242: TYPE search_exp_org_struct_ver_id IS TABLE OF pa_project_assignments.search_exp_org_struct_ver_id%TYPE
243: INDEX BY BINARY_INTEGER;
244: l_search_exp_org_struct_ver_id search_exp_org_struct_ver_id;
245:
246: TYPE search_exp_start_org_id IS TABLE OF pa_project_assignments.search_exp_start_org_id%TYPE

Line 246: TYPE search_exp_start_org_id IS TABLE OF pa_project_assignments.search_exp_start_org_id%TYPE

242: TYPE search_exp_org_struct_ver_id IS TABLE OF pa_project_assignments.search_exp_org_struct_ver_id%TYPE
243: INDEX BY BINARY_INTEGER;
244: l_search_exp_org_struct_ver_id search_exp_org_struct_ver_id;
245:
246: TYPE search_exp_start_org_id IS TABLE OF pa_project_assignments.search_exp_start_org_id%TYPE
247: INDEX BY BINARY_INTEGER;
248: l_search_exp_start_org_id search_exp_start_org_id;
249:
250: TYPE search_min_candidate_score IS TABLE OF pa_project_assignments.search_min_candidate_score%TYPE

Line 250: TYPE search_min_candidate_score IS TABLE OF pa_project_assignments.search_min_candidate_score%TYPE

246: TYPE search_exp_start_org_id IS TABLE OF pa_project_assignments.search_exp_start_org_id%TYPE
247: INDEX BY BINARY_INTEGER;
248: l_search_exp_start_org_id search_exp_start_org_id;
249:
250: TYPE search_min_candidate_score IS TABLE OF pa_project_assignments.search_min_candidate_score%TYPE
251: INDEX BY BINARY_INTEGER;
252: l_search_min_candidate_score search_min_candidate_score;
253:
254: TYPE enable_auto_cand_nom_flag IS TABLE OF pa_project_assignments.enable_auto_cand_nom_flag%TYPE

Line 299: TYPE staffing_owner_person_id IS TABLE OF pa_project_assignments.staffing_owner_person_id%TYPE

295: INDEX BY BINARY_INTEGER;
296: l_tp_percent_applied_override tp_percent_applied_override;
297:
298: -- FP.L Development
299: TYPE staffing_owner_person_id IS TABLE OF pa_project_assignments.staffing_owner_person_id%TYPE
300: INDEX BY BINARY_INTEGER;
301: l_staffing_owner_person_id staffing_owner_person_id;
302:
303: -- FP.M Development

Line 575: ( pa_project_assignments_s.NEXTVAL,

571: last_update_login,
572: transfer_price_rate, --For bug 3051110
573: transfer_pr_rate_curr)
574: VALUES
575: ( pa_project_assignments_s.NEXTVAL,
576: DECODE(l_assignment_name(i), FND_API.G_MISS_CHAR, NULL, l_assignment_name(i)),
577: DECODE(l_assignment_type(i), FND_API.G_MISS_CHAR, NULL, l_assignment_type(i)),
578: DECODE(l_multiple_status_flag(i), FND_API.G_MISS_CHAR, NULL, l_multiple_status_flag(i)),
579: 1,

Line 703: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR

699: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
700: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
701: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
702: ,p_apprvl_status_code IN pa_project_assignments.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
703: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
704: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
705: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
706: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
707: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM

Line 704: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

700: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
701: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
702: ,p_apprvl_status_code IN pa_project_assignments.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
703: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
704: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
705: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
706: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
707: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
708: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM

Line 712: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE

708: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM
709: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
710: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
711: ,p_note_to_approver IN pa_project_assignments.note_to_approver%TYPE := FND_API.G_MISS_CHAR
712: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
713: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
714: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
715: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
716: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM

Line 716: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM

712: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
713: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
714: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
715: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
716: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
717: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
718: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
719: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
720: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR

Line 744: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM

740: ,p_no_of_active_candidates IN pa_project_assignments.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
741: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
742: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
743: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
744: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
745: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
746: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
747: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
748: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

Line 745: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR

741: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
742: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
743: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
744: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
745: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
746: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
747: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
748: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
749: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR

Line 746: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM

742: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
743: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
744: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
745: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
746: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
747: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
748: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
749: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
750: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM

Line 747: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM

743: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
744: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
745: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
746: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
747: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
748: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
749: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
750: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
751: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR

Line 748: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

744: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
745: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
746: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
747: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
748: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
749: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
750: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
751: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
752: ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM

Line 759: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM

755: ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM
756: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
757: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
758: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
759: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
760: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM -- FP.M Development
761: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
762: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
763: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR