1: PACKAGE CSF_DEBRIEF_HEADERS_PKG AUTHID CURRENT_USER as
2: /* $Header: csftdbhs.pls 120.1 2008/05/12 06:32:33 syenduri ship $ */
3: TYPE internal_user_hooks_rec IS RECORD
4: (
5: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
6: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
7: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
8: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
9: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
2: /* $Header: csftdbhs.pls 120.1 2008/05/12 06:32:33 syenduri ship $ */
3: TYPE internal_user_hooks_rec IS RECORD
4: (
5: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
6: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
7: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
8: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
9: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
10: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
3: TYPE internal_user_hooks_rec IS RECORD
4: (
5: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
6: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
7: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
8: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
9: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
10: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
11: CREATION_DATE DATE := FND_API.G_MISS_DATE,
4: (
5: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
6: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
7: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
8: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
9: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
10: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
11: CREATION_DATE DATE := FND_API.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
5: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
6: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
7: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
8: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
9: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
10: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
11: CREATION_DATE DATE := FND_API.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
13: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
6: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
7: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
8: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
9: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
10: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
11: CREATION_DATE DATE := FND_API.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
13: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
14: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
7: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
8: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
9: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
10: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
11: CREATION_DATE DATE := FND_API.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
13: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
14: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
15: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
8: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
9: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
10: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
11: CREATION_DATE DATE := FND_API.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
13: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
14: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
15: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
9: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
10: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
11: CREATION_DATE DATE := FND_API.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
13: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
14: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
15: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
10: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
11: CREATION_DATE DATE := FND_API.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
13: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
14: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
15: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
11: CREATION_DATE DATE := FND_API.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
13: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
14: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
15: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
12: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
13: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
14: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
15: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
14: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
15: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
15: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
31: object_version_number NUMBER := FND_API.G_MISS_NUM,
24: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
31: object_version_number NUMBER := FND_API.G_MISS_NUM,
32: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
25: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
31: object_version_number NUMBER := FND_API.G_MISS_NUM,
32: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
33: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
26: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
31: object_version_number NUMBER := FND_API.G_MISS_NUM,
32: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
33: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
34: TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM);
27: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
31: object_version_number NUMBER := FND_API.G_MISS_NUM,
32: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
33: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
34: TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM);
35: user_hooks_rec CSF_DEBRIEF_HEADERS_PKG.internal_user_hooks_rec ;
28: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
31: object_version_number NUMBER := FND_API.G_MISS_NUM,
32: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
33: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
34: TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM);
35: user_hooks_rec CSF_DEBRIEF_HEADERS_PKG.internal_user_hooks_rec ;
36:
29: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
31: object_version_number NUMBER := FND_API.G_MISS_NUM,
32: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
33: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
34: TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM);
35: user_hooks_rec CSF_DEBRIEF_HEADERS_PKG.internal_user_hooks_rec ;
36:
37: PROCEDURE Insert_Row(
30: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
31: object_version_number NUMBER := FND_API.G_MISS_NUM,
32: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
33: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
34: TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM);
35: user_hooks_rec CSF_DEBRIEF_HEADERS_PKG.internal_user_hooks_rec ;
36:
37: PROCEDURE Insert_Row(
38: px_DEBRIEF_HEADER_ID IN OUT NOCOPY NUMBER,