APPS.PA_ASSIGNMENTS_PUB dependencies on PA_PROJECTS_ALL

Line 289: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR

285: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
286: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
287: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
288: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
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

Line 290: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR

286: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
287: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
288: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
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

Line 437: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR

433: PROCEDURE Create_Assignment
434: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
435: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
436: -- ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
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

Line 438: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR

434: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
435: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
436: -- ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
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

Line 548: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR

544: ,p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
545: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
546: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := 'N'
547: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
548: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
549: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
550: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
551: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
552: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM

Line 549: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR

545: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
546: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := 'N'
547: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
548: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
549: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
550: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
551: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
552: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
553: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE

Line 634: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR

630: PROCEDURE Create_Assign_With_Def
631: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
632: ,p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
633: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
634: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
635: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
636: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
637: ,p_resource_source_id IN per_all_people_f.person_id%TYPE := FND_API.G_MISS_NUM
638: ,p_api_version IN NUMBER := 1.0

Line 635: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR

631: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
632: ,p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
633: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
634: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
635: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
636: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
637: ,p_resource_source_id IN per_all_people_f.person_id%TYPE := FND_API.G_MISS_NUM
638: ,p_api_version IN NUMBER := 1.0
639: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

Line 1003: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR/*2386679*/

999: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
1000: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
1001: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1002: ,p_expenditure_type IN pa_project_assignments.expenditure_type%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

Line 1234: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR/*bug2386679*/

1230: --
1231: PROCEDURE Update_Assignment
1232: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
1233: ,p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
1234: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR/*bug2386679*/
1235: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
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

Line 1442: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR

1438: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1439: ,p_calendar_type IN pa_project_assignments.calendar_type%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

Line 1443: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR

1439: ,p_calendar_type IN pa_project_assignments.calendar_type%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

Line 1527: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR

1523: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1524: ,p_calendar_type IN pa_project_assignments.calendar_type%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

Line 1528: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR

1524: ,p_calendar_type IN pa_project_assignments.calendar_type%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

Line 1775: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR /* Bug 1851096 */

1771: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
1772: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
1773: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1774: ,p_expenditure_type IN pa_project_assignments.expenditure_type%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