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_TEAM_TEMPLATES

Line 1: PACKAGE BODY pa_team_templates_pvt AS

1: PACKAGE BODY pa_team_templates_pvt AS
2: /*$Header: PARTPVTB.pls 120.1 2005/08/19 17:01:20 mwasowic noship $*/
3: --
4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: PROCEDURE Start_Apply_Team_Template_WF

Line 6: (p_team_template_id_tbl IN PA_TEAM_TEMPLATES_PUB.team_template_id_tbl

2: /*$Header: PARTPVTB.pls 120.1 2005/08/19 17:01:20 mwasowic noship $*/
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'

Line 9: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE

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'
13: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL

Line 21: l_team_template_id pa_team_templates.team_template_id%TYPE;

17: IS
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;

Line 24: l_team_template_name pa_team_templates.team_template_name%TYPE;

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:
28: CURSOR get_project_name_and_number IS

Line 35: FROM pa_team_templates

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
35: FROM pa_team_templates
36: WHERE team_template_id = l_team_template_id;
37:
38: BEGIN
39: --initialize return status to Success

Line 168: UPDATE pa_team_templates

164: WF_ENGINE.StartProcess( itemtype => l_item_type,
165: itemkey => l_item_key);
166:
167:
168: UPDATE pa_team_templates
169: SET workflow_in_progress_flag = 'Y'
170: WHERE team_template_id = p_team_template_id_tbl(l_index).team_template_id;
171:
172: END LOOP;

Line 184: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_PVT.Apply_Team_Template'

180: --Setting the original value
181: wf_engine.threshold := l_save_threshold;
182:
183: -- Set the excetption Message and the stack
184: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_PVT.Apply_Team_Template'
185: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
186: --
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
188: RAISE;

Line 201: l_team_template_id pa_team_templates.team_template_id%TYPE;

197: p_funcmode IN VARCHAR2,
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);

Line 204: l_team_start_date pa_team_templates.team_start_date%TYPE;

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);
208: l_project_calendar_id pa_projects_all.calendar_id%TYPE;

Line 272: PA_TEAM_TEMPLATES_PVT.Apply_Team_Template( p_team_template_id => l_team_template_id,

268: dbms_output.put_line('l_project_start_date = '||l_project_start_date);
269: dbms_output.put_line('l_team_start_date = '||l_team_start_date);
270: */
271:
272: PA_TEAM_TEMPLATES_PVT.Apply_Team_Template( p_team_template_id => l_team_template_id,
273: p_project_id => l_project_id,
274: p_project_start_date => l_project_start_date,
275: p_team_start_date => l_team_start_date,
276: p_use_project_location => l_use_project_location,

Line 311: UPDATE PA_TEAM_TEMPLATES

307:
308: /* Bug 3271891 - Added AND condition for item_key <> p_item_key along with
309: activity_status_code <> 'DEFERRED' in the below query */
310:
311: UPDATE PA_TEAM_TEMPLATES
312: SET workflow_in_progress_flag = 'N'
313: WHERE team_template_id = l_team_template_id
314: AND NOT EXISTS(
315: SELECT 'Y'

Line 343: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_PVT.Apply_Team_Template'

339: EXCEPTION
340:
341: WHEN OTHERS THEN
342: -- Set the excetption Message and the stack
343: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_PVT.Apply_Team_Template'
344: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
345: RAISE;
346:
347:

Line 352: (p_team_template_id IN pa_team_templates.team_template_id%TYPE

348: END Apply_Team_Template_WF;
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'

Line 355: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE

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'
359: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL

Line 380: l_team_start_date pa_team_templates.team_start_date%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;
380: l_team_start_date pa_team_templates.team_start_date%TYPE;
381: l_template_requirement_rec PA_ASSIGNMENTS_PUB.assignment_rec_type;
382: l_person_name PER_PEOPLE_F.full_name%TYPE;
383: l_err_msg_code VARCHAR2(80);
384:

Line 440: WHERE object_type = 'PA_TEAM_TEMPLATES'

436:
437: CURSOR get_team_template_subteams(p_team_template_id NUMBER) IS
438: SELECT name
439: FROM pa_project_subteams
440: WHERE object_type = 'PA_TEAM_TEMPLATES'
441: AND object_id = p_team_template_id;
442:
443: CURSOR get_team_start_date(p_team_template_id NUMBER) IS
444: SELECT team_start_date

Line 445: FROM pa_team_templates

441: AND object_id = p_team_template_id;
442:
443: CURSOR get_team_start_date(p_team_template_id NUMBER) IS
444: SELECT team_start_date
445: FROM pa_team_templates
446: WHERE team_template_id = p_team_template_id;
447:
448: BEGIN
449:

Line 451: PA_DEBUG.init_err_stack('PA_TEAM_TEMPLATES_PVT.Apply_Team_Template');

447:
448: BEGIN
449:
450: -- Initialize the Error Stack
451: PA_DEBUG.init_err_stack('PA_TEAM_TEMPLATES_PVT.Apply_Team_Template');
452:
453: -- Initialize the return status to success
454: x_return_status := FND_API.G_RET_STS_SUCCESS;
455:

Line 463: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PVT.apply_team_template'

459: END IF;
460:
461: --Log Message
462: IF (P_DEBUG_MODE ='Y') THEN
463: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PVT.apply_team_template'
464: ,x_msg => 'Beginning of Apply_Team_Template'
465: ,x_log_level => 5);
466: END IF;
467:

Line 705: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_PVT.Apply_Team_Template'

701: ROLLBACK TO ASG_PVT_APPLY_TEAM_TEMPLATE;
702: END IF;
703:
704: -- Set the excetption Message and the stack
705: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_PVT.Apply_Team_Template'
706: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
707: --
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
709: RAISE;

Line 716: ( p_team_template_rec IN PA_TEAM_TEMPLATES_PUB.team_template_rec

712:
713:
714:
715: PROCEDURE Create_Team_Template
716: ( p_team_template_rec IN PA_TEAM_TEMPLATES_PUB.team_template_rec
717: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
718: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
719: ,x_team_template_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
720: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 725: l_team_template_rec PA_TEAM_TEMPLATES_PUB.team_template_rec;

721: )
722: IS
723:
724: l_msg_count NUMBER;
725: l_team_template_rec PA_TEAM_TEMPLATES_PUB.team_template_rec;
726: l_team_template_name_unique VARCHAR2(1);
727:
728: BEGIN
729:

Line 735: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PVT.Create_Team_Template.begin'

731: PA_DEBUG.set_err_stack('PA_TEAM_TEMPLATE_PVT.Create_Team_Template');
732:
733: --Log Message
734: IF (P_DEBUG_MODE ='Y') THEN
735: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PVT.Create_Team_Template.begin'
736: ,x_msg => 'Beginning of the PVT Create_Team_Template'
737: ,x_log_level => 5);
738: END IF;
739:

Line 751: l_team_template_name_unique := PA_TEAM_TEMPLATES_UTILS.Is_Team_Template_Name_Unique

747:
748: l_team_template_rec := p_team_template_rec;
749:
750: --validate that team template name is unique
751: l_team_template_name_unique := PA_TEAM_TEMPLATES_UTILS.Is_Team_Template_Name_Unique
752: (p_team_template_name => l_team_template_rec.team_template_name);
753:
754: IF l_team_template_name_unique = 'N' THEN
755:

Line 771: ,x_msg => 'calling pa_team_templates.insert_row.'

767: --If no validation errors then insert the team template.
768: IF p_validate_only = FND_API.G_FALSE AND FND_MSG_PUB.Count_Msg = 0 THEN
769: IF (P_DEBUG_MODE ='Y') THEN
770: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATE_PVT.Create_Team_Template.calling_insert_row'
771: ,x_msg => 'calling pa_team_templates.insert_row.'
772: ,x_log_level => 5);
773: END IF;
774:
775: PA_TEAM_TEMPLATES_PKG.Insert_Row(

Line 775: PA_TEAM_TEMPLATES_PKG.Insert_Row(

771: ,x_msg => 'calling pa_team_templates.insert_row.'
772: ,x_log_level => 5);
773: END IF;
774:
775: PA_TEAM_TEMPLATES_PKG.Insert_Row(
776: p_team_template_name => l_team_template_rec.team_template_name,
777: p_description => l_team_template_rec.description,
778: p_start_date_active => l_team_template_rec.start_date_active,
779: p_end_date_active => l_team_template_rec.end_date_active,

Line 825: ( p_team_template_rec IN PA_TEAM_TEMPLATES_PUB.team_template_rec

821: END Create_Team_Template;
822:
823:
824: PROCEDURE Update_Team_Template
825: ( p_team_template_rec IN PA_TEAM_TEMPLATES_PUB.team_template_rec
826: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
827: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
828: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
829: )

Line 833: l_team_template_rec PA_TEAM_TEMPLATES_PUB.team_template_rec;

829: )
830: IS
831:
832: l_msg_count NUMBER;
833: l_team_template_rec PA_TEAM_TEMPLATES_PUB.team_template_rec;
834:
835: BEGIN
836:
837: -- Initialize the Error Stack

Line 842: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PVT.Update_Team_Template.begin'

838: PA_DEBUG.set_err_stack('PA_TEAM_TEMPLATE_PVT.Update_Team_Template');
839:
840: --Log Message
841: IF (P_DEBUG_MODE ='Y') THEN
842: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PVT.Update_Team_Template.begin'
843: ,x_msg => 'Beginning of the PVT Update_Team_Template'
844: ,x_log_level => 5);
845: END IF;
846:

Line 867: ,x_msg => 'calling pa_team_templates.update_row.'

863: --If no validation errors then insert the team template.
864: IF p_validate_only = FND_API.G_FALSE AND FND_MSG_PUB.Count_Msg = 0 THEN
865: IF (P_DEBUG_MODE ='Y') THEN
866: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATE_PVT.Update_Team_Template.calling_update_row'
867: ,x_msg => 'calling pa_team_templates.update_row.'
868: ,x_log_level => 5);
869: END IF;
870:
871: PA_TEAM_TEMPLATES_PKG.Update_Row(

Line 871: PA_TEAM_TEMPLATES_PKG.Update_Row(

867: ,x_msg => 'calling pa_team_templates.update_row.'
868: ,x_log_level => 5);
869: END IF;
870:
871: PA_TEAM_TEMPLATES_PKG.Update_Row(
872: p_team_template_id => l_team_template_rec.team_template_id,
873: p_team_template_name => l_team_template_rec.team_template_name,
874: p_record_version_number => l_team_template_rec.record_version_number,
875: p_description => l_team_template_rec.description,

Line 922: ( p_team_template_id IN pa_team_templates.team_template_id%TYPE

918:
919: END Update_Team_Template;
920:
921: PROCEDURE Delete_Team_Template
922: ( p_team_template_id IN pa_team_templates.team_template_id%TYPE
923: ,p_record_version_number IN NUMBER
924: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
925: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
926: )

Line 994: p_object_type => 'PA_TEAM_TEMPLATES',

990: --team template.
991: PA_PROJECT_SUBTEAMS_PUB.Delete_Subteam_By_Obj
992: (p_init_msg_list => FND_API.G_FALSE,
993: p_validate_only => FND_API.G_FALSE,
994: p_object_type => 'PA_TEAM_TEMPLATES',
995: p_object_id => p_team_template_id,
996: x_return_status => l_return_status,
997: x_msg_count => l_msg_count,
998: x_msg_data => l_msg_data);

Line 1030: PA_TEAM_TEMPLATES_PKG.Delete_Row(p_team_template_id => p_team_template_id

1026: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATE_PVT.Delete_Team_Template'
1027: ,x_msg => 'calling delete_row'
1028: ,x_log_level => 5);
1029: END IF;
1030: PA_TEAM_TEMPLATES_PKG.Delete_Row(p_team_template_id => p_team_template_id
1031: ,p_record_version_number => p_record_version_number
1032: ,x_return_status => x_return_status);
1033:
1034: END IF; --check team template in use.

Line 1060: END pa_team_templates_pvt;

1056: RAISE;
1057:
1058: END Delete_Team_Template;
1059:
1060: END pa_team_templates_pvt;