APPS.PA_ASSIGNMENTS_PUB dependencies on PA_PROJECTS_ALL

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

284: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
285: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
286: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
287: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
288: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
289: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
290: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
291: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
292: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

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

285: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
286: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
287: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
288: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
289: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
290: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
291: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
292: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
293: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

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

432: PROCEDURE Create_Assignment
433: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
434: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
435: -- ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
436: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
437: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
438: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
439: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
440: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

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

433: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
434: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
435: -- ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
436: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
437: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
438: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
439: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
440: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
441: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

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

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

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

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

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

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

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

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

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

998: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
999: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
1000: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1001: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1002: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR/*2386679*/
1003: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
1004: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1005: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1006: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

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

1132: --
1133: PROCEDURE Update_Assignment
1134: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
1135: ,p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
1136: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR/*bug2386679*/
1137: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
1138: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1139: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1140: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

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

1339: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1340: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
1341: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
1342: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
1343: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
1344: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
1345: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1346: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1347: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

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

1340: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
1341: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
1342: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
1343: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
1344: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
1345: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1346: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1347: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1348: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

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

1424: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1425: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
1426: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
1427: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
1428: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
1429: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
1430: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1431: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1432: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

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

1425: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
1426: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
1427: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
1428: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
1429: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
1430: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1431: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1432: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1433: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

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

1672: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
1673: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
1674: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1675: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1676: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR /* Bug 1851096 */
1677: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
1678: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1679: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1680: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR