eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ASSIGNMENTS_PUB dependencies on PA_PROJECTS_ALL

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

46: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
47: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
48: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
49: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
50: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
51: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
52: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
53: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
54: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

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

47: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
48: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
49: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
50: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
51: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
52: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
53: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
54: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
55: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

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

412: ,p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
413: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
414: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := 'N'
415: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
416: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
417: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
418: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
419: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
420: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM

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

413: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
414: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := 'N'
415: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
416: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
417: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
418: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
419: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
420: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
421: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE

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

536: PROCEDURE Create_Assign_With_Def
537: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
538: ,p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
539: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
540: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
541: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
542: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
543: ,p_resource_source_id IN per_all_people_f.person_id%TYPE := FND_API.G_MISS_NUM
544: ,p_api_version IN NUMBER := 1.0

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

537: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
538: ,p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
539: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
540: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
541: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
542: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
543: ,p_resource_source_id IN per_all_people_f.person_id%TYPE := FND_API.G_MISS_NUM
544: ,p_api_version IN NUMBER := 1.0
545: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

Line 589: FROM pa_projects_all ppa,pa_locations pl

585:
586: -- Start of Performance Fix 4898314 SQL ID 14905800
587: CURSOR get_project_defaults IS
588: SELECT ppa.work_type_id,ppa.calendar_id ,pl.location_id ,pl.country_code
589: FROM pa_projects_all ppa,pa_locations pl
590: WHERE project_id = l_assignment_rec.project_id
591: AND PPA.LOCATION_ID = PL.LOCATION_ID(+) ;
592: -- End of Performance Fix 4898314 SQL ID 14905800
593:

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

853:
854: PROCEDURE Create_Assignment
855: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
856: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
857: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
858: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
859: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
860: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
861: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

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

854: PROCEDURE Create_Assignment
855: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
856: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
857: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
858: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
859: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
860: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
861: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
862: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

Line 942: FROM pa_projects_all ppa,pa_project_types_all ppt

938:
939: -- Start of Performance Fix 4898314 SQL ID 14905832
940: CURSOR get_project_number_info IS
941: SELECT ppt.administrative_flag, ppa.calendar_id, ppa.project_currency_code, ppt.unassigned_time
942: FROM pa_projects_all ppa,pa_project_types_all ppt
943: WHERE segment1 = p_project_number
944: AND PPA.PROJECT_TYPE = PPT.PROJECT_TYPE
945: AND PPA.ORG_ID = PPT.ORG_ID;
946: -- End of Performance Fix 4898314 SQL ID 14905832

Line 1340: FROM pa_projects_all

1336: --- -999 should be treated as FND_API.G_MISS_NUM
1337: IF p_role_list_id = FND_API.G_MISS_NUM OR p_role_list_id = -999 THEN
1338: IF l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM THEN
1339: SELECT role_list_id INTO l_role_list_id
1340: FROM pa_projects_all
1341: WHERE project_id = l_assignment_rec.project_id;
1342: ELSIF l_assignment_rec.assignment_template_id IS NOT NULL AND l_assignment_rec.assignment_template_id <> FND_API.G_MISS_NUM THEN
1343: SELECT role_list_id INTO l_role_list_id
1344: FROM pa_team_templates

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

3138: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
3139: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
3140: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
3141: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
3142: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR /* Bug 1851096 */
3143: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
3144: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
3145: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
3146: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

Line 3221: FROM PA_IMPLEMENTATIONS_ALL impl,pa_projects_all proj

3217: l_req_rdisc_reason VARCHAR2(1);
3218: --MOAC changes Bug 4363092: removed nvl with org_id
3219: Cursor bil_rate_oride_imple(p_project_id number) is
3220: SELECT impl.RATE_DISCOUNT_REASON_FLAG,impl.BR_OVERRIDE_FLAG,impl.BR_DISCOUNT_OVERRIDE_FLAG
3221: FROM PA_IMPLEMENTATIONS_ALL impl,pa_projects_all proj
3222: WHERE proj.org_id=impl.org_id
3223: and proj.project_id = p_project_id ;
3224: /*Code addition for bug 3096132 ends*/
3225:

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

3421:
3422: PROCEDURE Update_Assignment
3423: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
3424: ,p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
3425: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR /* Bug 1851096 */
3426: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
3427: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
3428: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
3429: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

Line 3550: ,pa_projects_all proj

3546: SELECT impl.RATE_DISCOUNT_REASON_FLAG
3547: ,impl.BR_OVERRIDE_FLAG
3548: ,impl.BR_DISCOUNT_OVERRIDE_FLAG
3549: FROM PA_IMPLEMENTATIONS_ALL impl
3550: ,pa_projects_all proj
3551: WHERE proj.org_id=impl.org_id
3552: and proj.project_id = l_assignment_rec.project_id ;
3553:
3554: l_rate_discount_reason_flag varchar2(1);

Line 5336: FROM pa_projects_all

5332:
5333: IF l_assignment_rec.calendar_type = 'RESOURCE' THEN
5334: l_assignment_rec.calendar_type := 'PROJECT';
5335: SELECT calendar_id INTO l_assignment_rec.calendar_id
5336: FROM pa_projects_all
5337: WHERE project_id = l_assignment_rec.project_id;
5338: END IF;
5339:
5340: -- Create the requirement

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

5441: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
5442: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
5443: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
5444: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
5445: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
5446: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
5447: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
5448: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
5449: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

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

5442: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
5443: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
5444: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
5445: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
5446: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
5447: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
5448: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
5449: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
5450: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

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

5735: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
5736: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
5737: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
5738: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
5739: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
5740: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
5741: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
5742: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
5743: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

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

5736: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
5737: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
5738: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
5739: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
5740: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
5741: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
5742: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
5743: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
5744: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

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

6595: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
6596: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
6597: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
6598: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
6599: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR /* Bug 1851096 */
6600: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
6601: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
6602: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
6603: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR