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 3158: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

3154: ,p_calendar_id IN jtf_calendars_tl.calendar_id%TYPE := FND_API.G_MISS_NUM
3155: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
3156: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
3157: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
3158: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
3159: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
3160: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
3161: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
3162: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

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

3155: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
3156: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
3157: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
3158: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
3159: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
3160: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
3161: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
3162: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
3163: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM

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

3439: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
3440: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
3441: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
3442: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
3443: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
3444: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
3445: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
3446: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
3447: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR

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

3440: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
3441: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
3442: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
3443: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
3444: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
3445: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
3446: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
3447: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
3448: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR

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

5455: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
5456: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
5457: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
5458: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
5459: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
5460: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
5461: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
5462: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
5463: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR

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

5456: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
5457: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
5458: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
5459: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
5460: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
5461: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
5462: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
5463: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
5464: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR

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

5749: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
5750: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
5751: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
5752: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
5753: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
5754: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
5755: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
5756: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
5757: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR

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

5750: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
5751: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
5752: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
5753: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
5754: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
5755: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
5756: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
5757: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
5758: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR

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

5970: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
5971: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
5972: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
5973: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
5974: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
5975: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
5976: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
5977: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
5978: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

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

5971: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
5972: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
5973: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
5974: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
5975: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
5976: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
5977: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
5978: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
5979: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM

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

6214: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
6215: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
6216: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
6217: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
6218: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
6219: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
6220: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
6221: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
6222: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

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

6215: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
6216: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
6217: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
6218: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
6219: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
6220: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
6221: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
6222: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
6223: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM

Line 6282: l_expenditure_org_name per_organization_units.name%TYPE;

6278: l_expenditure_org_id pa_project_assignments.expenditure_org_id%TYPE;
6279: l_expenditure_organization_id pa_project_assignments.expenditure_organization_id%TYPE;
6280: l_fcst_job_name per_jobs.name%TYPE;
6281: l_fcst_job_group_name per_job_groups.displayed_name%TYPE;
6282: l_expenditure_org_name per_organization_units.name%TYPE;
6283: l_exp_organization_name per_organization_units.name%TYPE;
6284: l_fcst_tp_amount_type pa_project_assignments.fcst_tp_amount_type%TYPE;
6285: l_req_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
6286: l_req_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;

Line 6283: l_exp_organization_name per_organization_units.name%TYPE;

6279: l_expenditure_organization_id pa_project_assignments.expenditure_organization_id%TYPE;
6280: l_fcst_job_name per_jobs.name%TYPE;
6281: l_fcst_job_group_name per_job_groups.displayed_name%TYPE;
6282: l_expenditure_org_name per_organization_units.name%TYPE;
6283: l_exp_organization_name per_organization_units.name%TYPE;
6284: l_fcst_tp_amount_type pa_project_assignments.fcst_tp_amount_type%TYPE;
6285: l_req_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
6286: l_req_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
6287: l_resource_id pa_resources.resource_id%TYPE;

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

6611: ,p_calendar_id IN jtf_calendars_tl.calendar_id%TYPE := FND_API.G_MISS_NUM
6612: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
6613: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
6614: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
6615: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
6616: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
6617: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
6618: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
6619: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

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

6612: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
6613: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
6614: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
6615: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
6616: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
6617: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
6618: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
6619: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
6620: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM