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_PUB dependencies on FND_API

Line 6: (team_template_id pa_team_templates.team_template_id%TYPE := FND_API.G_MISS_NUM

2: /*$Header: PARTPUBS.pls 120.1 2005/08/19 17:01:16 mwasowic noship $*/
3: --
4:
5: TYPE team_template_rec IS RECORD
6: (team_template_id pa_team_templates.team_template_id%TYPE := FND_API.G_MISS_NUM
7: ,record_version_number pa_team_templates.record_version_number%TYPE := FND_API.G_MISS_NUM
8: ,team_template_name pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR
9: ,start_date_active pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
10: ,end_date_active pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE

Line 7: ,record_version_number pa_team_templates.record_version_number%TYPE := FND_API.G_MISS_NUM

3: --
4:
5: TYPE team_template_rec IS RECORD
6: (team_template_id pa_team_templates.team_template_id%TYPE := FND_API.G_MISS_NUM
7: ,record_version_number pa_team_templates.record_version_number%TYPE := FND_API.G_MISS_NUM
8: ,team_template_name pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR
9: ,start_date_active pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
10: ,end_date_active pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
11: ,description pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR

Line 8: ,team_template_name pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR

4:
5: TYPE team_template_rec IS RECORD
6: (team_template_id pa_team_templates.team_template_id%TYPE := FND_API.G_MISS_NUM
7: ,record_version_number pa_team_templates.record_version_number%TYPE := FND_API.G_MISS_NUM
8: ,team_template_name pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR
9: ,start_date_active pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
10: ,end_date_active pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
11: ,description pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
12: ,role_list_id pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM

Line 9: ,start_date_active pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE

5: TYPE team_template_rec IS RECORD
6: (team_template_id pa_team_templates.team_template_id%TYPE := FND_API.G_MISS_NUM
7: ,record_version_number pa_team_templates.record_version_number%TYPE := FND_API.G_MISS_NUM
8: ,team_template_name pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR
9: ,start_date_active pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
10: ,end_date_active pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
11: ,description pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
12: ,role_list_id pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
13: ,calendar_id pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM

Line 10: ,end_date_active pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE

6: (team_template_id pa_team_templates.team_template_id%TYPE := FND_API.G_MISS_NUM
7: ,record_version_number pa_team_templates.record_version_number%TYPE := FND_API.G_MISS_NUM
8: ,team_template_name pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR
9: ,start_date_active pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
10: ,end_date_active pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
11: ,description pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
12: ,role_list_id pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
13: ,calendar_id pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
14: ,work_type_id pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM

Line 11: ,description pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR

7: ,record_version_number pa_team_templates.record_version_number%TYPE := FND_API.G_MISS_NUM
8: ,team_template_name pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR
9: ,start_date_active pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
10: ,end_date_active pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
11: ,description pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
12: ,role_list_id pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
13: ,calendar_id pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
14: ,work_type_id pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
15: ,team_start_date pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE

Line 12: ,role_list_id pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM

8: ,team_template_name pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR
9: ,start_date_active pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
10: ,end_date_active pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
11: ,description pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
12: ,role_list_id pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
13: ,calendar_id pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
14: ,work_type_id pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
15: ,team_start_date pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
16: ,workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR

Line 13: ,calendar_id pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM

9: ,start_date_active pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
10: ,end_date_active pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
11: ,description pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
12: ,role_list_id pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
13: ,calendar_id pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
14: ,work_type_id pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
15: ,team_start_date pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
16: ,workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
17: ,attribute_category pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR

Line 14: ,work_type_id pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM

10: ,end_date_active pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
11: ,description pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
12: ,role_list_id pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
13: ,calendar_id pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
14: ,work_type_id pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
15: ,team_start_date pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
16: ,workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
17: ,attribute_category pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
18: ,attribute1 pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR

Line 15: ,team_start_date pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE

11: ,description pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
12: ,role_list_id pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
13: ,calendar_id pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
14: ,work_type_id pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
15: ,team_start_date pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
16: ,workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
17: ,attribute_category pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
18: ,attribute1 pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
19: ,attribute2 pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR

Line 16: ,workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR

12: ,role_list_id pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
13: ,calendar_id pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
14: ,work_type_id pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
15: ,team_start_date pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
16: ,workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
17: ,attribute_category pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
18: ,attribute1 pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
19: ,attribute2 pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
20: ,attribute3 pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR

Line 17: ,attribute_category pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR

13: ,calendar_id pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
14: ,work_type_id pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
15: ,team_start_date pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
16: ,workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
17: ,attribute_category pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
18: ,attribute1 pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
19: ,attribute2 pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
20: ,attribute3 pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
21: ,attribute4 pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR

Line 18: ,attribute1 pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR

14: ,work_type_id pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
15: ,team_start_date pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
16: ,workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
17: ,attribute_category pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
18: ,attribute1 pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
19: ,attribute2 pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
20: ,attribute3 pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
21: ,attribute4 pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
22: ,attribute5 pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR

Line 19: ,attribute2 pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR

15: ,team_start_date pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
16: ,workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
17: ,attribute_category pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
18: ,attribute1 pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
19: ,attribute2 pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
20: ,attribute3 pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
21: ,attribute4 pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
22: ,attribute5 pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
23: ,attribute6 pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR

Line 20: ,attribute3 pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR

16: ,workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
17: ,attribute_category pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
18: ,attribute1 pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
19: ,attribute2 pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
20: ,attribute3 pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
21: ,attribute4 pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
22: ,attribute5 pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
23: ,attribute6 pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
24: ,attribute7 pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR

Line 21: ,attribute4 pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR

17: ,attribute_category pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
18: ,attribute1 pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
19: ,attribute2 pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
20: ,attribute3 pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
21: ,attribute4 pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
22: ,attribute5 pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
23: ,attribute6 pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
24: ,attribute7 pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
25: ,attribute8 pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR

Line 22: ,attribute5 pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR

18: ,attribute1 pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
19: ,attribute2 pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
20: ,attribute3 pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
21: ,attribute4 pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
22: ,attribute5 pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
23: ,attribute6 pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
24: ,attribute7 pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
25: ,attribute8 pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
26: ,attribute9 pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR

Line 23: ,attribute6 pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR

19: ,attribute2 pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
20: ,attribute3 pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
21: ,attribute4 pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
22: ,attribute5 pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
23: ,attribute6 pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
24: ,attribute7 pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
25: ,attribute8 pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
26: ,attribute9 pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
27: ,attribute10 pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR

Line 24: ,attribute7 pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR

20: ,attribute3 pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
21: ,attribute4 pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
22: ,attribute5 pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
23: ,attribute6 pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
24: ,attribute7 pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
25: ,attribute8 pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
26: ,attribute9 pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
27: ,attribute10 pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
28: ,attribute11 pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR

Line 25: ,attribute8 pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR

21: ,attribute4 pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
22: ,attribute5 pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
23: ,attribute6 pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
24: ,attribute7 pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
25: ,attribute8 pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
26: ,attribute9 pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
27: ,attribute10 pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
28: ,attribute11 pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
29: ,attribute12 pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR

Line 26: ,attribute9 pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR

22: ,attribute5 pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
23: ,attribute6 pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
24: ,attribute7 pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
25: ,attribute8 pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
26: ,attribute9 pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
27: ,attribute10 pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
28: ,attribute11 pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
29: ,attribute12 pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
30: ,attribute13 pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR

Line 27: ,attribute10 pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR

23: ,attribute6 pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
24: ,attribute7 pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
25: ,attribute8 pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
26: ,attribute9 pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
27: ,attribute10 pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
28: ,attribute11 pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
29: ,attribute12 pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
30: ,attribute13 pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
31: ,attribute14 pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR

Line 28: ,attribute11 pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR

24: ,attribute7 pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
25: ,attribute8 pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
26: ,attribute9 pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
27: ,attribute10 pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
28: ,attribute11 pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
29: ,attribute12 pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
30: ,attribute13 pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
31: ,attribute14 pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
32: ,attribute15 pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR );

Line 29: ,attribute12 pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR

25: ,attribute8 pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
26: ,attribute9 pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
27: ,attribute10 pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
28: ,attribute11 pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
29: ,attribute12 pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
30: ,attribute13 pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
31: ,attribute14 pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
32: ,attribute15 pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR );
33:

Line 30: ,attribute13 pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR

26: ,attribute9 pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
27: ,attribute10 pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
28: ,attribute11 pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
29: ,attribute12 pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
30: ,attribute13 pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
31: ,attribute14 pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
32: ,attribute15 pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR );
33:
34:

Line 31: ,attribute14 pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR

27: ,attribute10 pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
28: ,attribute11 pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
29: ,attribute12 pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
30: ,attribute13 pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
31: ,attribute14 pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
32: ,attribute15 pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR );
33:
34:
35: TYPE team_template_id_rec IS RECORD(

Line 32: ,attribute15 pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR );

28: ,attribute11 pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
29: ,attribute12 pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
30: ,attribute13 pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
31: ,attribute14 pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
32: ,attribute15 pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR );
33:
34:
35: TYPE team_template_id_rec IS RECORD(
36: team_template_id pa_team_templates.team_template_id%TYPE);

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

43: PROCEDURE Execute_Apply_Team_Template
44: (p_team_template_id IN pa_team_templates.team_template_id%TYPE
45: ,p_project_id IN pa_projects_all.project_id%TYPE
46: ,p_project_start_date IN pa_projects_all.start_date%TYPE
47: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
48: ,p_use_project_location IN VARCHAR2 := 'N'
49: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
50: ,p_use_project_calendar IN VARCHAR2 := 'N'
51: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL

Line 54: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

50: ,p_use_project_calendar IN VARCHAR2 := 'N'
51: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL
52: ,p_apply IN VARCHAR2 := 'Y'
53: ,p_api_version IN NUMBER := 1.0
54: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
55: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
56: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
57: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
58: ,x_msg_count OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 55: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

51: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL
52: ,p_apply IN VARCHAR2 := 'Y'
53: ,p_api_version IN NUMBER := 1.0
54: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
55: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
56: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
57: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
58: ,x_msg_count OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
59: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 56: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE

52: ,p_apply IN VARCHAR2 := 'Y'
53: ,p_api_version IN NUMBER := 1.0
54: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
55: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
56: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
57: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
58: ,x_msg_count OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
59: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
60: );

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

62: PROCEDURE Apply_Team_Template
63: (p_team_template_id_tbl IN team_template_id_tbl
64: ,p_project_id IN pa_projects_all.project_id%TYPE
65: ,p_project_start_date IN pa_projects_all.start_date%TYPE
66: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
67: ,p_use_project_location IN VARCHAR2 := 'N'
68: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
69: ,p_use_project_calendar IN VARCHAR2 := 'N'
70: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL

Line 72: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

68: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
69: ,p_use_project_calendar IN VARCHAR2 := 'N'
70: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL
71: ,p_api_version IN NUMBER := 1.0
72: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
73: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
74: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
75: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
76: ,x_msg_count OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 73: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

69: ,p_use_project_calendar IN VARCHAR2 := 'N'
70: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL
71: ,p_api_version IN NUMBER := 1.0
72: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
73: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
74: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
75: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
76: ,x_msg_count OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
77: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 74: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE

70: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL
71: ,p_api_version IN NUMBER := 1.0
72: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
73: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
74: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
75: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
76: ,x_msg_count OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
77: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
78: );

Line 82: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR

78: );
79:
80: PROCEDURE Execute_Create_Team_Template
81: (p_team_template_name IN pa_team_templates.team_template_name%TYPE
82: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
83: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE
84: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
85: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
86: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM

Line 84: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE

80: PROCEDURE Execute_Create_Team_Template
81: (p_team_template_name IN pa_team_templates.team_template_name%TYPE
82: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
83: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE
84: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
85: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
86: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
87: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
88: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM

Line 85: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

81: (p_team_template_name IN pa_team_templates.team_template_name%TYPE
82: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
83: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE
84: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
85: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
86: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
87: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
88: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
89: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR

Line 86: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM

82: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
83: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE
84: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
85: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
86: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
87: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
88: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
89: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
90: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM

Line 87: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

83: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE
84: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
85: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
86: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
87: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
88: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
89: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
90: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
91: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE

Line 88: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM

84: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
85: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
86: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
87: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
88: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
89: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
90: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
91: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE
92: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR

Line 89: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR

85: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
86: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
87: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
88: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
89: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
90: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
91: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE
92: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
93: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR

Line 90: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM

86: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
87: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
88: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
89: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
90: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
91: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE
92: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
93: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
94: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR

Line 92: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR

88: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
89: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
90: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
91: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE
92: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
93: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
94: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
95: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
96: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR

Line 93: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR

89: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
90: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
91: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE
92: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
93: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
94: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
95: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
96: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
97: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR

Line 94: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR

90: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
91: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE
92: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
93: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
94: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
95: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
96: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
97: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
98: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR

Line 95: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR

91: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE
92: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
93: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
94: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
95: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
96: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
97: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
98: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
99: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR

Line 96: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR

92: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
93: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
94: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
95: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
96: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
97: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
98: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
99: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
100: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR

Line 97: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR

93: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
94: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
95: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
96: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
97: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
98: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
99: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
100: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
101: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR

Line 98: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR

94: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
95: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
96: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
97: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
98: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
99: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
100: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
101: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
102: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR

Line 99: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR

95: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
96: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
97: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
98: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
99: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
100: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
101: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
102: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
103: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR

Line 100: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR

96: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
97: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
98: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
99: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
100: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
101: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
102: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
103: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
104: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR

Line 101: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR

97: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
98: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
99: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
100: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
101: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
102: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
103: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
104: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
105: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR

Line 102: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR

98: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
99: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
100: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
101: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
102: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
103: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
104: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
105: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
106: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR

Line 103: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR

99: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
100: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
101: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
102: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
103: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
104: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
105: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
106: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
107: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR

Line 104: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR

100: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
101: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
102: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
103: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
104: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
105: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
106: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
107: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
108: ,p_api_version IN NUMBER := 1.0

Line 105: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR

101: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
102: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
103: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
104: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
105: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
106: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
107: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
108: ,p_api_version IN NUMBER := 1.0
109: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

Line 106: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR

102: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
103: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
104: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
105: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
106: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
107: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
108: ,p_api_version IN NUMBER := 1.0
109: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
110: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 107: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR

103: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
104: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
105: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
106: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
107: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
108: ,p_api_version IN NUMBER := 1.0
109: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
110: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
111: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

Line 109: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

105: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
106: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
107: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
108: ,p_api_version IN NUMBER := 1.0
109: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
110: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
111: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
112: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
113: ,x_team_template_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 110: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

106: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
107: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
108: ,p_api_version IN NUMBER := 1.0
109: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
110: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
111: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
112: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
113: ,x_team_template_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
114: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 111: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

107: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
108: ,p_api_version IN NUMBER := 1.0
109: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
110: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
111: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
112: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
113: ,x_team_template_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
114: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
115: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 112: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE

108: ,p_api_version IN NUMBER := 1.0
109: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
110: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
111: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
112: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
113: ,x_team_template_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
114: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
115: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
116: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 121: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

117: );
118:
119: PROCEDURE Create_Team_Template
120: ( p_team_template_rec IN team_template_rec
121: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
122: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
123: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
124: ,p_api_version IN NUMBER := 1.0
125: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

Line 122: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

118:
119: PROCEDURE Create_Team_Template
120: ( p_team_template_rec IN team_template_rec
121: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
122: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
123: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
124: ,p_api_version IN NUMBER := 1.0
125: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
126: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 123: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR

119: PROCEDURE Create_Team_Template
120: ( p_team_template_rec IN team_template_rec
121: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
122: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
123: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
124: ,p_api_version IN NUMBER := 1.0
125: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
126: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
127: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

Line 125: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

121: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
122: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
123: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
124: ,p_api_version IN NUMBER := 1.0
125: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
126: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
127: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
128: ,p_validate_only IN VARCHAR2 := FND_API.G_FAlSE
129: ,x_team_template_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 126: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

122: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
123: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
124: ,p_api_version IN NUMBER := 1.0
125: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
126: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
127: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
128: ,p_validate_only IN VARCHAR2 := FND_API.G_FAlSE
129: ,x_team_template_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
130: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 127: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

123: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
124: ,p_api_version IN NUMBER := 1.0
125: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
126: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
127: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
128: ,p_validate_only IN VARCHAR2 := FND_API.G_FAlSE
129: ,x_team_template_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
130: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
131: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 128: ,p_validate_only IN VARCHAR2 := FND_API.G_FAlSE

124: ,p_api_version IN NUMBER := 1.0
125: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
126: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
127: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
128: ,p_validate_only IN VARCHAR2 := FND_API.G_FAlSE
129: ,x_team_template_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
130: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
131: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
132: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 138: ,p_team_template_name IN pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR

134:
135: PROCEDURE Execute_Update_Team_Template
136: ( p_team_template_id IN pa_team_templates.team_template_id%TYPE
137: ,p_record_version_number IN pa_team_templates.record_version_number%TYPE
138: ,p_team_template_name IN pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR
139: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
140: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
141: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
142: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

Line 139: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR

135: PROCEDURE Execute_Update_Team_Template
136: ( p_team_template_id IN pa_team_templates.team_template_id%TYPE
137: ,p_record_version_number IN pa_team_templates.record_version_number%TYPE
138: ,p_team_template_name IN pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR
139: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
140: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
141: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
142: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
143: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM

Line 140: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE

136: ( p_team_template_id IN pa_team_templates.team_template_id%TYPE
137: ,p_record_version_number IN pa_team_templates.record_version_number%TYPE
138: ,p_team_template_name IN pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR
139: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
140: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
141: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
142: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
143: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
144: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

Line 141: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE

137: ,p_record_version_number IN pa_team_templates.record_version_number%TYPE
138: ,p_team_template_name IN pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR
139: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
140: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
141: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
142: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
143: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
144: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
145: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM

Line 142: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

138: ,p_team_template_name IN pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR
139: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
140: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
141: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
142: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
143: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
144: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
145: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
146: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR

Line 143: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM

139: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
140: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
141: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
142: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
143: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
144: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
145: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
146: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
147: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM

Line 144: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

140: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
141: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
142: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
143: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
144: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
145: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
146: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
147: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
148: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE

Line 145: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM

141: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
142: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
143: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
144: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
145: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
146: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
147: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
148: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
149: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR

Line 146: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR

142: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
143: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
144: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
145: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
146: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
147: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
148: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
149: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
150: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR

Line 147: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM

143: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
144: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
145: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
146: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
147: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
148: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
149: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
150: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
151: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR

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

144: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
145: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
146: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
147: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
148: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
149: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
150: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
151: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
152: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR

Line 149: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR

145: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
146: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
147: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
148: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
149: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
150: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
151: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
152: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
153: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR

Line 150: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR

146: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
147: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
148: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
149: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
150: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
151: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
152: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
153: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
154: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR

Line 151: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR

147: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
148: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
149: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
150: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
151: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
152: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
153: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
154: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR

Line 152: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR

148: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
149: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
150: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
151: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
152: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
153: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
154: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR

Line 153: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR

149: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
150: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
151: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
152: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
153: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
154: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR

Line 154: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR

150: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
151: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
152: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
153: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
154: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR

Line 155: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR

151: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
152: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
153: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
154: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR

Line 156: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR

152: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
153: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
154: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR

Line 157: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR

153: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
154: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR

Line 158: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR

154: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR

Line 159: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR

155: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR

Line 160: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR

156: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR

Line 161: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR

157: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR

Line 162: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR

158: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
166: ,p_api_version IN NUMBER := 1.0

Line 163: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR

159: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
166: ,p_api_version IN NUMBER := 1.0
167: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

Line 164: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR

160: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
166: ,p_api_version IN NUMBER := 1.0
167: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
168: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 165: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR

161: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
166: ,p_api_version IN NUMBER := 1.0
167: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
168: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
169: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

Line 167: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

163: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
166: ,p_api_version IN NUMBER := 1.0
167: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
168: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
169: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
170: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
171: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 168: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

164: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
166: ,p_api_version IN NUMBER := 1.0
167: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
168: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
169: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
170: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
171: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
172: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 169: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

165: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
166: ,p_api_version IN NUMBER := 1.0
167: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
168: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
169: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
170: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
171: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
172: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
173: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 170: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE

166: ,p_api_version IN NUMBER := 1.0
167: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
168: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
169: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
170: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
171: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
172: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
173: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
174: );

Line 179: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

175:
176:
177: PROCEDURE Update_Team_Template
178: ( p_team_template_rec IN team_template_rec
179: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
180: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
181: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
182: ,p_api_version IN NUMBER := 1.0
183: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

Line 180: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

176:
177: PROCEDURE Update_Team_Template
178: ( p_team_template_rec IN team_template_rec
179: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
180: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
181: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
182: ,p_api_version IN NUMBER := 1.0
183: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
184: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 181: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR

177: PROCEDURE Update_Team_Template
178: ( p_team_template_rec IN team_template_rec
179: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
180: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
181: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
182: ,p_api_version IN NUMBER := 1.0
183: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
184: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
185: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

Line 183: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

179: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
180: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
181: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
182: ,p_api_version IN NUMBER := 1.0
183: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
184: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
185: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
186: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
187: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 184: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

180: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
181: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
182: ,p_api_version IN NUMBER := 1.0
183: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
184: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
185: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
186: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
187: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
188: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 185: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

181: ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
182: ,p_api_version IN NUMBER := 1.0
183: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
184: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
185: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
186: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
187: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
188: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
189: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 186: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE

182: ,p_api_version IN NUMBER := 1.0
183: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
184: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
185: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
186: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
187: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
188: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
189: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
190: );

Line 196: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

192: PROCEDURE Delete_Team_Template
193: ( p_team_template_id IN pa_team_templates.team_template_id%TYPE
194: ,p_record_version_number IN NUMBER
195: ,p_api_version IN NUMBER := 1
196: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
197: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
198: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
199: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
200: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 197: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

193: ( p_team_template_id IN pa_team_templates.team_template_id%TYPE
194: ,p_record_version_number IN NUMBER
195: ,p_api_version IN NUMBER := 1
196: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
197: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
198: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
199: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
200: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
201: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 198: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

194: ,p_record_version_number IN NUMBER
195: ,p_api_version IN NUMBER := 1
196: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
197: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
198: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
199: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
200: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
201: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
202: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 199: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE

195: ,p_api_version IN NUMBER := 1
196: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
197: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
198: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
199: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
200: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
201: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
202: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
203: );