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_TASK_MANAGER dependencies on PA_PROJECT_PARTIES

Line 35: from pa_project_parties pp

31:
32: CURSOR c_member_end_date (p_project_id IN NUMBER,
33: p_task_manager_person_id IN NUMBER) IS
34: select 1
35: from pa_project_parties pp
36: where pp.project_id = p_project_id
37: and resource_source_id = p_task_manager_person_id
38: and project_role_id = p_proj_role_id
39: and pp.end_date_active is NULL;

Line 44: from pa_project_parties

40:
41: CURSOR c_proj_member_exists (p_project_id IN NUMBER,
42: p_task_manager_person_id IN NUMBER) IS
43: select start_date_active, end_date_active
44: from pa_project_parties
45: where project_id = p_project_id
46: and resource_source_id = p_task_manager_person_id
47: and project_role_id = p_proj_role_id
48: order by start_date_active; /* Important to process in order. Please do not remove. */

Line 88: from pa_project_parties

84: l_project_end_date := p_project_end_date;
85:
86: select max(end_date_active)
87: into l_member_end_date_active
88: from pa_project_parties
89: where project_id = p_project_id
90: and resource_source_id = p_task_manager_person_id
91: and project_role_id = p_proj_role_id;
92:

Line 125: from pa_project_parties

121: if l_create_project_member = 'Y' then
122:
123: select min(start_date_active)
124: into l_min_member_start_date
125: from pa_project_parties
126: where project_id = p_project_id
127: and resource_source_id = p_task_manager_person_id
128: and project_role_id = p_proj_role_id;
129:

Line 139: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

135: tm_log('7 The person is existing as a project member. ');
136: tm_log('Creating the project member for the period '||l_start_date_active||' to '||l_end_date_active_tmp);
137: end if;
138:
139: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
140: p_api_version => 1.0
141: , p_init_msg_list => FND_API.G_TRUE
142: , p_commit => FND_API.G_FALSE
143: , p_validate_only => FND_API.G_FALSE

Line 206: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

202: tm_log('8 The person is existing as a project member. ');
203: tm_log('Creating the project member for the period '||l_start_date_active||' to '||l_end_date_active_tmp);
204: end if;
205:
206: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
207: p_api_version => 1.0
208: , p_init_msg_list => FND_API.G_TRUE
209: , p_commit => FND_API.G_FALSE
210: , p_validate_only => FND_API.G_FALSE

Line 274: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

270: tm_log('9 The person is existing as a project member. ');
271: tm_log('Creating the project member for the period '||l_start_date_active||' to '||l_end_date_active);
272: end if;
273:
274: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
275: p_api_version => 1.0
276: , p_init_msg_list => FND_API.G_TRUE
277: , p_commit => FND_API.G_FALSE
278: , p_validate_only => FND_API.G_FALSE

Line 327: from pa_project_parties

323: elsif (l_member_end_date_active is NOT NULL and l_end_date_active is NOT NULL) then
324:
325: select min(start_date_active)
326: into l_min_member_start_date
327: from pa_project_parties
328: where project_id = p_project_id
329: and resource_source_id = p_task_manager_person_id
330: and project_role_id = p_proj_role_id;
331:

Line 341: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

337: tm_log('10 The person is existing as a project member. ');
338: tm_log('Creating the project member for the period '||l_start_date_active||' to '||l_end_date_active_tmp);
339: end if;
340:
341: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
342: p_api_version => 1.0
343: , p_init_msg_list => FND_API.G_TRUE
344: , p_commit => FND_API.G_FALSE
345: , p_validate_only => FND_API.G_FALSE

Line 407: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

403: tm_log('11 The person is existing as a project member. ');
404: tm_log('Creating the project member for the period '||l_start_date_active||' to '||l_end_date_active_tmp);
405: end if;
406:
407: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
408: p_api_version => 1.0
409: , p_init_msg_list => FND_API.G_TRUE
410: , p_commit => FND_API.G_FALSE
411: , p_validate_only => FND_API.G_FALSE

Line 476: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

472: tm_log('12 The person is existing as a project member. ');
473: tm_log('Creating the project member for the period '||l_start_date_active||' to '||l_end_date_active);
474: end if;
475:
476: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
477: p_api_version => 1.0
478: , p_init_msg_list => FND_API.G_TRUE
479: , p_commit => FND_API.G_FALSE
480: , p_validate_only => FND_API.G_FALSE

Line 529: from pa_project_parties

525: elsif (l_member_end_date_active is NOT NULL and l_end_date_active is NULL) then
526:
527: select min(start_date_active)
528: into l_min_member_start_date
529: from pa_project_parties
530: where project_id = p_project_id
531: and resource_source_id = p_task_manager_person_id
532: and project_role_id = p_proj_role_id;
533:

Line 543: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

539: tm_log('13 The person is existing as a project member. ');
540: tm_log('Creating the project member for the period '||l_start_date_active||' to '||l_end_date_active_tmp);
541: end if;
542:
543: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
544: p_api_version => 1.0
545: , p_init_msg_list => FND_API.G_TRUE
546: , p_commit => FND_API.G_FALSE
547: , p_validate_only => FND_API.G_FALSE

Line 608: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

604: tm_log('14 The person is existing as a project member. ');
605: tm_log('Creating the project member for the period '||l_start_date_active||' to '||l_end_date_active_tmp);
606: end if;
607:
608: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
609: p_api_version => 1.0
610: , p_init_msg_list => FND_API.G_TRUE
611: , p_commit => FND_API.G_FALSE
612: , p_validate_only => FND_API.G_FALSE

Line 675: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

671: tm_log('15 The person is existing as a project member. ');
672: tm_log('Creating the project member for the period '||l_start_date_active||' to '||l_end_date_active);
673: end if;
674:
675: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
676: p_api_version => 1.0
677: , p_init_msg_list => FND_API.G_TRUE
678: , p_commit => FND_API.G_FALSE
679: , p_validate_only => FND_API.G_FALSE

Line 760: from pa_project_parties

756:
757: CURSOR c_proj_member (p_project_id IN NUMBER,
758: p_task_manager_person_id IN NUMBER) IS
759: select 1
760: from pa_project_parties
761: where project_id = p_project_id
762: and resource_source_id = p_task_manager_person_id
763: and project_role_id = p_project_role;
764:

Line 831: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_DATES(p_project_id => l_selprojs_rec.project_id,

827: for l_selprojs_rec in c_selprojs LOOP
828:
829: l_proj_counter := l_proj_counter + 1;
830:
831: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_DATES(p_project_id => l_selprojs_rec.project_id,
832: x_project_start_date => l_project_start_date,
833: x_project_end_date => l_project_end_date,
834: x_return_status => x_return_status);
835: if l_debug_mode = 'Y' then

Line 877: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

873: tm_log('Creating the project member for the period '||l_start_date_active||' to '||l_end_date_active);
874: end if;
875:
876:
877: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
878: p_api_version => 1.0
879: , p_init_msg_list => FND_API.G_TRUE
880: , p_commit => FND_API.G_FALSE
881: , p_validate_only => FND_API.G_FALSE