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_TEAM_TEMPLATES_PVT dependencies on PA_PROJECTS_ALL

Line 7: ,p_project_id IN pa_projects_all.project_id%TYPE

3: --
4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: PROCEDURE Start_Apply_Team_Template_WF
6: (p_team_template_id_tbl IN PA_TEAM_TEMPLATES_PUB.team_template_id_tbl
7: ,p_project_id IN pa_projects_all.project_id%TYPE
8: ,p_project_start_date IN pa_projects_all.start_date%TYPE
9: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
10: ,p_use_project_location IN VARCHAR2 := 'N'
11: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL

Line 8: ,p_project_start_date IN pa_projects_all.start_date%TYPE

4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: PROCEDURE Start_Apply_Team_Template_WF
6: (p_team_template_id_tbl IN PA_TEAM_TEMPLATES_PUB.team_template_id_tbl
7: ,p_project_id IN pa_projects_all.project_id%TYPE
8: ,p_project_start_date IN pa_projects_all.start_date%TYPE
9: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
10: ,p_use_project_location IN VARCHAR2 := 'N'
11: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
12: ,p_use_project_calendar IN VARCHAR2 := 'N'

Line 11: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL

7: ,p_project_id IN pa_projects_all.project_id%TYPE
8: ,p_project_start_date IN pa_projects_all.start_date%TYPE
9: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
10: ,p_use_project_location IN VARCHAR2 := 'N'
11: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
12: ,p_use_project_calendar IN VARCHAR2 := 'N'
13: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL
14: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
15: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 13: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL

9: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
10: ,p_use_project_location IN VARCHAR2 := 'N'
11: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
12: ,p_use_project_calendar IN VARCHAR2 := 'N'
13: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL
14: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
15: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
16: )
17: IS

Line 22: l_project_name pa_projects_all.name%TYPE;

18:
19: l_item_type VARCHAR2(8) := 'PARAPTEM';
20: l_item_key VARCHAR2(2000);
21: l_team_template_id pa_team_templates.team_template_id%TYPE;
22: l_project_name pa_projects_all.name%TYPE;
23: l_project_number pa_projects_all.segment1%TYPE;
24: l_team_template_name pa_team_templates.team_template_name%TYPE;
25: l_save_threshold NUMBER;
26: l_nextval NUMBER;

Line 23: l_project_number pa_projects_all.segment1%TYPE;

19: l_item_type VARCHAR2(8) := 'PARAPTEM';
20: l_item_key VARCHAR2(2000);
21: l_team_template_id pa_team_templates.team_template_id%TYPE;
22: l_project_name pa_projects_all.name%TYPE;
23: l_project_number pa_projects_all.segment1%TYPE;
24: l_team_template_name pa_team_templates.team_template_name%TYPE;
25: l_save_threshold NUMBER;
26: l_nextval NUMBER;
27:

Line 30: FROM pa_projects_all

26: l_nextval NUMBER;
27:
28: CURSOR get_project_name_and_number IS
29: SELECT name, segment1
30: FROM pa_projects_all
31: WHERE project_id = p_project_id;
32:
33: CURSOR get_team_template_name(l_team_template_id NUMBER) IS
34: SELECT team_template_name

Line 202: l_project_id pa_projects_all.project_id%TYPE;

198: p_result OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
199: IS
200:
201: l_team_template_id pa_team_templates.team_template_id%TYPE;
202: l_project_id pa_projects_all.project_id%TYPE;
203: l_project_start_date pa_projects_all.start_date%TYPE;
204: l_team_start_date pa_team_templates.team_start_date%TYPE;
205: l_use_project_location VARCHAR2(1);
206: l_project_location_id pa_projects_all.location_id%TYPE;

Line 203: l_project_start_date pa_projects_all.start_date%TYPE;

199: IS
200:
201: l_team_template_id pa_team_templates.team_template_id%TYPE;
202: l_project_id pa_projects_all.project_id%TYPE;
203: l_project_start_date pa_projects_all.start_date%TYPE;
204: l_team_start_date pa_team_templates.team_start_date%TYPE;
205: l_use_project_location VARCHAR2(1);
206: l_project_location_id pa_projects_all.location_id%TYPE;
207: l_use_project_calendar VARCHAR2(1);

Line 206: l_project_location_id pa_projects_all.location_id%TYPE;

202: l_project_id pa_projects_all.project_id%TYPE;
203: l_project_start_date pa_projects_all.start_date%TYPE;
204: l_team_start_date pa_team_templates.team_start_date%TYPE;
205: l_use_project_location VARCHAR2(1);
206: l_project_location_id pa_projects_all.location_id%TYPE;
207: l_use_project_calendar VARCHAR2(1);
208: l_project_calendar_id pa_projects_all.calendar_id%TYPE;
209: l_return_status VARCHAR2(1);
210: l_msg_count NUMBER;

Line 208: l_project_calendar_id pa_projects_all.calendar_id%TYPE;

204: l_team_start_date pa_team_templates.team_start_date%TYPE;
205: l_use_project_location VARCHAR2(1);
206: l_project_location_id pa_projects_all.location_id%TYPE;
207: l_use_project_calendar VARCHAR2(1);
208: l_project_calendar_id pa_projects_all.calendar_id%TYPE;
209: l_return_status VARCHAR2(1);
210: l_msg_count NUMBER;
211: l_count NUMBER;
212: l_msg_data fnd_new_messages.message_text%TYPE;

Line 353: ,p_project_id IN pa_projects_all.project_id%TYPE

349:
350:
351: PROCEDURE Apply_Team_Template
352: (p_team_template_id IN pa_team_templates.team_template_id%TYPE
353: ,p_project_id IN pa_projects_all.project_id%TYPE
354: ,p_project_start_date IN pa_projects_all.start_date%TYPE
355: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
356: ,p_use_project_location IN VARCHAR2 := 'N'
357: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL

Line 354: ,p_project_start_date IN pa_projects_all.start_date%TYPE

350:
351: PROCEDURE Apply_Team_Template
352: (p_team_template_id IN pa_team_templates.team_template_id%TYPE
353: ,p_project_id IN pa_projects_all.project_id%TYPE
354: ,p_project_start_date IN pa_projects_all.start_date%TYPE
355: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
356: ,p_use_project_location IN VARCHAR2 := 'N'
357: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
358: ,p_use_project_calendar IN VARCHAR2 := 'N'

Line 357: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL

353: ,p_project_id IN pa_projects_all.project_id%TYPE
354: ,p_project_start_date IN pa_projects_all.start_date%TYPE
355: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
356: ,p_use_project_location IN VARCHAR2 := 'N'
357: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
358: ,p_use_project_calendar IN VARCHAR2 := 'N'
359: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL
360: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
361: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 359: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL

355: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
356: ,p_use_project_location IN VARCHAR2 := 'N'
357: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
358: ,p_use_project_calendar IN VARCHAR2 := 'N'
359: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL
360: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
361: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
362: )
363: IS

Line 374: l_project_calendar_id pa_projects_all.calendar_id%TYPE;

370: l_error_message_code fnd_new_messages.message_name%TYPE;
371: l_msg_count NUMBER;
372: l_msg_data fnd_new_messages.message_text%TYPE;
373: l_index NUMBER;
374: l_project_calendar_id pa_projects_all.calendar_id%TYPE;
375: l_project_location_id pa_projects_all.location_id%TYPE;
376: l_number_of_days NUMBER;
377: l_project_subteam_id pa_project_subteams.project_subteam_id%TYPE;
378: l_subteam_name pa_project_subteams.name%TYPE;

Line 375: l_project_location_id pa_projects_all.location_id%TYPE;

371: l_msg_count NUMBER;
372: l_msg_data fnd_new_messages.message_text%TYPE;
373: l_index NUMBER;
374: l_project_calendar_id pa_projects_all.calendar_id%TYPE;
375: l_project_location_id pa_projects_all.location_id%TYPE;
376: l_number_of_days NUMBER;
377: l_project_subteam_id pa_project_subteams.project_subteam_id%TYPE;
378: l_subteam_name pa_project_subteams.name%TYPE;
379: l_subteam_row_id ROWID;

Line 387: FROM pa_projects_all

383: l_err_msg_code VARCHAR2(80);
384:
385: CURSOR get_project_location_and_cal IS
386: SELECT calendar_id, location_id
387: FROM pa_projects_all
388: WHERE project_id = p_project_id;
389:
390: CURSOR get_template_req_attributes(p_team_template_id NUMBER) IS
391: SELECT assignment_name