APPS.PA_ASSIGNMENTS_PUB dependencies on PER_ORGANIZATION_UNITS

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

301: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
302: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
303: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
304: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
305: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
306: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
307: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
308: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
309: ,p_adv_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR

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

302: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
303: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
304: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
305: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
306: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
307: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
308: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
309: ,p_adv_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
310: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM

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

1015: ,p_calendar_id IN jtf_calendars_tl.calendar_id%TYPE := FND_API.G_MISS_NUM
1016: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1017: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1018: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1019: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1020: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1021: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
1022: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
1023: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

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

1016: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1017: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1018: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1019: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1020: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1021: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
1022: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
1023: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
1024: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM

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

1248: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1249: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1250: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1251: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1252: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1253: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1254: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1255: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
1256: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR

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

1249: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1250: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1251: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1252: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1253: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1254: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
1255: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
1256: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1257: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR

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

1452: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1453: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1454: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1455: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1456: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1457: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1458: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
1459: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
1460: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR

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

1453: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1454: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1455: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1456: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1457: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1458: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
1459: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
1460: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
1461: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR

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

1537: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1538: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1539: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1540: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1541: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1542: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1543: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
1544: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
1545: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR

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

1538: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1539: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1540: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1541: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1542: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1543: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
1544: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
1545: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
1546: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR

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

1605: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1606: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1607: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1608: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1609: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1610: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1611: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
1612: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
1613: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

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

1606: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1607: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1608: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1609: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1610: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1611: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
1612: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
1613: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
1614: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM

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

1685: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1686: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1687: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1688: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1689: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1690: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1691: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
1692: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
1693: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

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

1686: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1687: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1688: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1689: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1690: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1691: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
1692: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
1693: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
1694: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM

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

1787: ,p_calendar_id IN jtf_calendars_tl.calendar_id%TYPE := FND_API.G_MISS_NUM
1788: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1789: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1790: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1791: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1792: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1793: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
1794: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
1795: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

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

1788: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
1789: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
1790: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
1791: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1792: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
1793: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
1794: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
1795: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
1796: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM