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_PKG dependencies on PA_TEAM_TEMPLATES

Line 1: PACKAGE BODY pa_team_templates_pkg AS

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

Line 6: (p_team_template_name IN pa_team_templates.team_template_name%TYPE

2: /*$Header: PARTPKGB.pls 120.1 2005/08/19 17:01:03 mwasowic noship $*/
3: --
4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: PROCEDURE Insert_Row
6: (p_team_template_name IN pa_team_templates.team_template_name%TYPE
7: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
8: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE
9: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
10: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM

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

3: --
4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: PROCEDURE Insert_Row
6: (p_team_template_name IN pa_team_templates.team_template_name%TYPE
7: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
8: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE
9: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
10: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
11: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM

Line 8: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE

4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: PROCEDURE Insert_Row
6: (p_team_template_name IN pa_team_templates.team_template_name%TYPE
7: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
8: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE
9: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
10: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
11: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
12: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM

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

5: PROCEDURE Insert_Row
6: (p_team_template_name IN pa_team_templates.team_template_name%TYPE
7: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
8: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE
9: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
10: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
11: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
12: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
13: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE

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

6: (p_team_template_name IN pa_team_templates.team_template_name%TYPE
7: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
8: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE
9: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
10: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
11: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
12: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
13: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE
14: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR

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

7: ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
8: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE
9: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
10: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
11: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
12: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
13: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE
14: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
15: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR

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

8: ,p_start_date_active IN pa_team_templates.start_date_active%TYPE
9: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
10: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
11: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
12: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
13: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE
14: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
15: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
16: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR

Line 13: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE

9: ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
10: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
11: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
12: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
13: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE
14: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
15: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
16: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
17: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR

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

10: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
11: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
12: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
13: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE
14: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
15: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
16: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
17: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
18: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR

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

11: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
12: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
13: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE
14: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
15: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
16: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
17: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
18: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
19: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR

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

12: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
13: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE
14: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
15: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
16: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
17: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
18: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
19: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
20: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR

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

13: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE
14: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
15: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
16: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
17: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
18: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
19: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
20: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
21: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR

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

14: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
15: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
16: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
17: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
18: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
19: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
20: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
21: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
22: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR

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

15: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
16: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
17: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
18: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
19: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
20: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
21: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
22: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
23: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR

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

16: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
17: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
18: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
19: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
20: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
21: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
22: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
23: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
24: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR

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

17: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
18: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
19: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
20: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
21: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
22: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
23: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
24: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
25: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR

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

18: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
19: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
20: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
21: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
22: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
23: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
24: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
25: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
26: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR

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

19: ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
20: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
21: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
22: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
23: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
24: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
25: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
26: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
27: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR

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

20: ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
21: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
22: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
23: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
24: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
25: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
26: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
27: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
28: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR

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

21: ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
22: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
23: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
24: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
25: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
26: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
27: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
28: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
29: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR

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

22: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
23: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
24: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
25: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
26: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
27: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
28: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
29: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
30: ,x_team_template_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

23: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
24: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
25: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
26: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
27: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
28: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
29: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
30: ,x_team_template_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
31: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

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

24: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
25: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
26: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
27: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
28: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
29: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
30: ,x_team_template_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
31: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
32: IS

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

25: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
26: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
27: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
28: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
29: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
30: ,x_team_template_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
31: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
32: IS
33:

Line 34: l_team_template_id PA_TEAM_TEMPLATES.team_template_id%TYPE;

30: ,x_team_template_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
31: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
32: IS
33:
34: l_team_template_id PA_TEAM_TEMPLATES.team_template_id%TYPE;
35:
36: BEGIN
37:
38: -- Initialize the Error Stack

Line 43: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PKG.insert_row'

39: PA_DEBUG.set_err_stack('PA_TEAM_TEMPLATE_PKG.Insert_Row');
40:
41: --Log Message
42: IF (P_DEBUG_MODE = 'Y') THEN
43: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PKG.insert_row'
44: ,x_msg => 'Beginning of the Team Template insert row'
45: ,x_log_level => 5);
46: END IF;
47:

Line 51: SELECT pa_team_templates_s.NEXTVAL

47:
48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49:
50: --Fetch the next sequence number for team template
51: SELECT pa_team_templates_s.NEXTVAL
52: INTO x_team_template_id
53: FROM dual;
54:
55: INSERT INTO pa_team_templates

Line 55: INSERT INTO pa_team_templates

51: SELECT pa_team_templates_s.NEXTVAL
52: INTO x_team_template_id
53: FROM dual;
54:
55: INSERT INTO pa_team_templates
56: (team_template_id
57: ,record_version_number
58: ,team_template_name
59: ,start_date_active

Line 126: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_TEAM_TEMPLATES_PKG.Insert_Row'

122:
123: EXCEPTION
124: WHEN OTHERS THEN -- catch the exceptions here
125: -- Set the exception Message and the stack
126: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_TEAM_TEMPLATES_PKG.Insert_Row'
127: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
129: RAISE;
130:

Line 136: (p_team_template_id IN pa_team_templates.team_template_id%TYPE

132:
133:
134:
135: PROCEDURE Update_Row
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

Line 137: ,p_record_version_number IN pa_team_templates.record_version_number%TYPE

133:
134:
135: PROCEDURE Update_Row
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

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

134:
135: PROCEDURE Update_Row
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_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM

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

135: PROCEDURE Update_Row
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_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
143: ,p_work_type_id IN pa_team_templates.work_type_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_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
143: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
144: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM

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_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
143: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
144: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
145: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE

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

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_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
143: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
144: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
145: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
146: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR

Line 143: ,p_work_type_id IN pa_team_templates.work_type_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_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
143: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
144: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
145: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
146: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
147: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR

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

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_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
143: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
144: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
145: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
146: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
147: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
148: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR

Line 145: ,p_team_start_date IN pa_team_templates.team_start_date%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_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
143: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
144: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
145: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
146: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
147: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
148: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
149: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR

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

142: ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
143: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
144: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
145: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
146: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
147: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
148: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
149: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
150: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR

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

143: ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
144: ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
145: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
146: ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
147: ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
148: ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
149: ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
150: ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
151: ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

155: ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
163: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

156: ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
163: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
164: )

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

157: ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
163: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
164: )
165: IS

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

158: ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
163: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
164: )
165: IS
166:

Line 167: l_record_version_number pa_team_templates.record_version_number%TYPE;

163: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
164: )
165: IS
166:
167: l_record_version_number pa_team_templates.record_version_number%TYPE;
168:
169: BEGIN
170:
171: -- Initialize the Error Stack

Line 176: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PKG.Update_Row'

172: PA_DEBUG.set_err_stack('PA_TEAM_TEMPLATE_PKG.Update_Row');
173:
174: --Log Message
175: IF (P_DEBUG_MODE = 'Y') THEN
176: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PKG.Update_Row'
177: ,x_msg => 'Beginning of the Team Template update row'
178: ,x_log_level => 5);
179: END IF;
180:

Line 185: UPDATE pa_team_templates

181: x_return_status := FND_API.G_RET_STS_SUCCESS;
182:
183: l_record_version_number := p_record_version_number +1;
184:
185: UPDATE pa_team_templates
186: SET team_template_name = DECODE(p_team_template_name, FND_API.G_MISS_CHAR, team_template_name, p_team_template_name)
187: ,record_version_number = l_record_version_number
188: ,start_date_active = DECODE(p_start_date_active, FND_API.G_MISS_DATE, start_date_active, p_start_date_active)
189: ,end_date_active = DECODE(p_end_date_active, FND_API.G_MISS_DATE, end_date_active, p_end_date_active)

Line 235: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_TEAM_TEMPLATES_PKG.Update_Row'

231:
232: EXCEPTION
233: WHEN OTHERS THEN -- catch the exceptions here
234: -- Set the exception Message and the stack
235: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_TEAM_TEMPLATES_PKG.Update_Row'
236: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
238: RAISE;
239:

Line 244: ( p_team_template_id IN pa_team_templates.team_template_id%TYPE

240: END Update_Row;
241:
242:
243: PROCEDURE Delete_Row
244: ( p_team_template_id IN pa_team_templates.team_template_id%TYPE
245: ,p_record_version_number IN NUMBER
246: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
247: )
248: IS

Line 253: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PKG.delete_row'

249:
250: BEGIN
251:
252: IF (P_DEBUG_MODE = 'Y') THEN
253: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TEAM_TEMPLATES_PKG.delete_row'
254: ,x_msg => 'Beginning of the Team Template delete row'
255: ,x_log_level => 5);
256: END IF;
257:

Line 263: DELETE FROM pa_team_templates

259:
260: --check the record version number, workflow in progress, and template in use
261: --AGAIN before allowing delete.
262:
263: DELETE FROM pa_team_templates
264: WHERE team_template_id = p_team_template_id
265: AND record_version_number = p_record_version_number
266: AND nvl(workflow_in_progress_flag, 'N') <> 'Y'
267: AND NOT EXISTS

Line 297: END pa_team_templates_pkg;

293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
294: RAISE;
295: END Delete_Row;
296:
297: END pa_team_templates_pkg;