DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on PER_JOBS

Line 64: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

60: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
61: ,p_location_country_code IN pa_locations.country_code%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

Line 3156: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

3152: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
3153: ,p_calendar_name IN jtf_calendars_tl.calendar_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

Line 3441: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

3437: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
3438: ,p_location_country_name IN fnd_territories_tl.territory_short_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

Line 5457: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

5453: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
5454: ,p_location_country_code IN pa_locations.country_code%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

Line 5751: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

5747: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
5748: ,p_location_country_code IN pa_locations.country_code%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

Line 5972: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

5968: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
5969: ,p_location_country_name IN fnd_territories_tl.territory_short_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

Line 6216: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

6212: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
6213: ,p_location_country_name IN fnd_territories_tl.territory_short_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

Line 6280: l_fcst_job_name per_jobs.name%TYPE;

6276: l_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
6277: l_fcst_job_group_id pa_project_assignments.fcst_job_group_id%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;

Line 6613: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

6609: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
6610: ,p_calendar_name IN jtf_calendars_tl.calendar_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