DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on PA_PROJECT_SUBTEAMS

Line 261: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

257: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
258: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
259: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
260: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
261: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
262: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
263: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
264: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
265: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM

Line 293: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

289: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
290: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
291: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
292: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
293: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
294: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
295: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
296: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
297: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

Line 441: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

437: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
438: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
439: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
440: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
441: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
442: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
443: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
444: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
445: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

Line 442: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

438: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
439: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
440: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
441: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
442: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
443: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
444: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
445: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
446: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

Line 978: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

974: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
975: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
976: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
977: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
978: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
979: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
980: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
981: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
982: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR

Line 1007: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

1003: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR/*2386679*/
1004: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
1005: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1006: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1007: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1008: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1009: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1010: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1011: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

Line 1240: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

1236: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1237: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1238: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1239: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1240: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
1241: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
1242: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1243: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1244: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

Line 1242: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

1238: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1239: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1240: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
1241: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
1242: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1243: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1244: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1245: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1246: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

Line 1414: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

1410: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
1411: ,p_resource_id_tbl IN system.pa_num_tbl_type := NULL
1412: ,p_resource_name_tbl IN system.pa_varchar2_240_tbl_type := NULL
1413: ,p_resource_source_id_tbl IN system.pa_num_tbl_type := NULL
1414: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
1415: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1416: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
1417: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
1418: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM

Line 1444: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

1440: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
1441: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
1442: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
1443: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
1444: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1445: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1446: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1447: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1448: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

Line 1499: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

1495: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
1496: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
1497: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
1498: ,p_resource_id_tbl IN system.pa_num_tbl_type
1499: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
1500: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1501: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
1502: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
1503: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM

Line 1529: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

1525: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
1526: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
1527: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
1528: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
1529: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1530: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1531: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1532: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1533: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

Line 1580: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

1576: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
1577: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1578: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1579: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1580: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
1581: ,p_append_description_flag IN VARCHAR2 := 'N'
1582: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1583: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
1584: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM

Line 1600: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

1596: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
1597: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
1598: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1599: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1600: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1601: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1602: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1603: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1604: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

Line 1660: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

1656: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
1657: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1658: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1659: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1660: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
1661: ,p_append_description_flag IN VARCHAR2 := 'N'
1662: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1663: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
1664: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM

Line 1680: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

1676: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
1677: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
1678: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1679: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1680: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1681: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1682: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1683: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1684: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

Line 1750: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

1746: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1747: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
1748: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
1749: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
1750: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
1751: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
1752: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1753: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
1754: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR

Line 1779: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

1775: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR /* Bug 1851096 */
1776: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
1777: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1778: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1779: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1780: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1781: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1782: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1783: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR