DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on PER_ORGANIZATION_UNITS

Line 66: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

62: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
63: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
64: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
65: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
66: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
67: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
68: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
69: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
70: ,p_adv_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR

Line 67: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

63: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
64: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
65: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
66: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
67: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
68: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
69: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
70: ,p_adv_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
71: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM

Line 3240: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

3236: ,p_calendar_id IN jtf_calendars_tl.calendar_id%TYPE := FND_API.G_MISS_NUM
3237: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
3238: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
3239: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
3240: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
3241: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
3242: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
3243: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
3244: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

Line 3241: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

3237: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
3238: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
3239: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
3240: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
3241: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
3242: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
3243: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
3244: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
3245: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM

Line 4370: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

4366: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
4367: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
4368: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
4369: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
4370: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
4371: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
4372: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
4373: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
4374: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR

Line 4371: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

4367: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
4368: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
4369: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
4370: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
4371: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
4372: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
4373: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
4374: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
4375: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR

Line 6435: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

6431: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
6432: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
6433: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
6434: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
6435: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
6436: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
6437: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
6438: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
6439: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR

Line 6436: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

6432: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
6433: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
6434: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
6435: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
6436: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
6437: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
6438: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
6439: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
6440: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR

Line 6729: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

6725: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
6726: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
6727: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
6728: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
6729: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
6730: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
6731: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
6732: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
6733: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR

Line 6730: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

6726: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
6727: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
6728: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
6729: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
6730: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
6731: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
6732: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
6733: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
6734: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR

Line 6950: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

6946: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
6947: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
6948: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
6949: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
6950: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
6951: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
6952: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
6953: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
6954: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

Line 6951: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

6947: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
6948: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
6949: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
6950: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
6951: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
6952: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
6953: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
6954: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
6955: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM

Line 7194: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

7190: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
7191: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
7192: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
7193: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
7194: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
7195: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
7196: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
7197: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
7198: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

Line 7195: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

7191: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
7192: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
7193: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
7194: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
7195: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
7196: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
7197: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
7198: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
7199: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM

Line 7258: l_expenditure_org_name per_organization_units.name%TYPE;

7254: l_expenditure_org_id pa_project_assignments.expenditure_org_id%TYPE;
7255: l_expenditure_organization_id pa_project_assignments.expenditure_organization_id%TYPE;
7256: l_fcst_job_name per_jobs.name%TYPE;
7257: l_fcst_job_group_name per_job_groups.displayed_name%TYPE;
7258: l_expenditure_org_name per_organization_units.name%TYPE;
7259: l_exp_organization_name per_organization_units.name%TYPE;
7260: l_fcst_tp_amount_type pa_project_assignments.fcst_tp_amount_type%TYPE;
7261: l_req_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
7262: l_req_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;

Line 7259: l_exp_organization_name per_organization_units.name%TYPE;

7255: l_expenditure_organization_id pa_project_assignments.expenditure_organization_id%TYPE;
7256: l_fcst_job_name per_jobs.name%TYPE;
7257: l_fcst_job_group_name per_job_groups.displayed_name%TYPE;
7258: l_expenditure_org_name per_organization_units.name%TYPE;
7259: l_exp_organization_name per_organization_units.name%TYPE;
7260: l_fcst_tp_amount_type pa_project_assignments.fcst_tp_amount_type%TYPE;
7261: l_req_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
7262: l_req_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
7263: l_resource_id pa_resources.resource_id%TYPE;

Line 7591: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

7587: ,p_calendar_id IN jtf_calendars_tl.calendar_id%TYPE := FND_API.G_MISS_NUM
7588: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
7589: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
7590: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
7591: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
7592: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
7593: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
7594: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
7595: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

Line 7592: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

7588: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
7589: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
7590: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
7591: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
7592: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
7593: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
7594: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
7595: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
7596: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM