APPS.CSF_DEBRIEF_PVT dependencies on FND_API

Line 21: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,

17:
18:
19: TYPE DEBRIEF_Rec_Type IS RECORD
20: (
21: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
22: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
23: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
24: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
25: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,

Line 22: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,

18:
19: TYPE DEBRIEF_Rec_Type IS RECORD
20: (
21: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
22: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
23: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
24: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
25: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
26: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 23: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,

19: TYPE DEBRIEF_Rec_Type IS RECORD
20: (
21: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
22: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
23: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
24: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
25: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
26: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
27: CREATION_DATE DATE := FND_API.G_MISS_DATE,

Line 24: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,

20: (
21: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
22: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
23: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
24: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
25: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
26: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
27: CREATION_DATE DATE := FND_API.G_MISS_DATE,
28: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 25: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,

21: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
22: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
23: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
24: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
25: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
26: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
27: CREATION_DATE DATE := FND_API.G_MISS_DATE,
28: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
29: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 26: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

22: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
23: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
24: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
25: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
26: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
27: CREATION_DATE DATE := FND_API.G_MISS_DATE,
28: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
29: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 27: CREATION_DATE DATE := FND_API.G_MISS_DATE,

23: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
24: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
25: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
26: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
27: CREATION_DATE DATE := FND_API.G_MISS_DATE,
28: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
29: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
31: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 28: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

24: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
25: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
26: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
27: CREATION_DATE DATE := FND_API.G_MISS_DATE,
28: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
29: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
31: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 29: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

25: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
26: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
27: CREATION_DATE DATE := FND_API.G_MISS_DATE,
28: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
29: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
31: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 30: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

26: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
27: CREATION_DATE DATE := FND_API.G_MISS_DATE,
28: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
29: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
31: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 31: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

27: CREATION_DATE DATE := FND_API.G_MISS_DATE,
28: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
29: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
31: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 32: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

28: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
29: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
31: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 33: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

29: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
31: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 34: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

30: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
31: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 35: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

31: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 36: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

32: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 37: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

33: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 38: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

34: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 39: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

35: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 40: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

36: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 41: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

37: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 42: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

38: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 43: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

39: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
47: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 44: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

40: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
47: object_version_number NUMBER := FND_API.G_MISS_NUM,
48: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,

Line 45: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

41: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
47: object_version_number NUMBER := FND_API.G_MISS_NUM,
48: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
49: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,

Line 46: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

42: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
47: object_version_number NUMBER := FND_API.G_MISS_NUM,
48: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
49: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
50: TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM

Line 47: object_version_number NUMBER := FND_API.G_MISS_NUM,

43: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
47: object_version_number NUMBER := FND_API.G_MISS_NUM,
48: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
49: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
50: TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM
51: );

Line 48: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,

44: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
47: object_version_number NUMBER := FND_API.G_MISS_NUM,
48: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
49: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
50: TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM
51: );
52:

Line 49: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,

45: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
47: object_version_number NUMBER := FND_API.G_MISS_NUM,
48: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
49: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
50: TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM
51: );
52:
53: G_MISS_DEBRIEF_REC DEBRIEF_Rec_Type;

Line 50: TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM

46: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
47: object_version_number NUMBER := FND_API.G_MISS_NUM,
48: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
49: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
50: TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM
51: );
52:
53: G_MISS_DEBRIEF_REC DEBRIEF_Rec_Type;
54: TYPE DEBRIEF_Tbl_Type IS TABLE OF DEBRIEF_Rec_Type

Line 60: DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,

56: G_MISS_DEBRIEF_TBL DEBRIEF_Tbl_Type;
57:
58: TYPE DEBRIEF_LINE_Rec_Type IS RECORD
59: (
60: DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
61: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
62: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
63: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
64: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,

Line 61: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,

57:
58: TYPE DEBRIEF_LINE_Rec_Type IS RECORD
59: (
60: DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
61: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
62: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
63: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
64: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
65: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,

Line 62: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,

58: TYPE DEBRIEF_LINE_Rec_Type IS RECORD
59: (
60: DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
61: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
62: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
63: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
64: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
65: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
66: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,

Line 63: SERVICE_DATE DATE := FND_API.G_MISS_DATE,

59: (
60: DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
61: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
62: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
63: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
64: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
65: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
66: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
67: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,

Line 64: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,

60: DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
61: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
62: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
63: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
64: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
65: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
66: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
67: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
68: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,

Line 65: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,

61: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
62: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
63: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
64: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
65: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
66: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
67: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
68: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
69: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,

Line 66: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,

62: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
63: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
64: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
65: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
66: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
67: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
68: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
69: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
70: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 67: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,

63: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
64: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
65: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
66: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
67: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
68: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
69: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
70: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 68: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,

64: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
65: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
66: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
67: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
68: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
69: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
70: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
72: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,

Line 69: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,

65: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
66: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
67: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
68: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
69: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
70: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
72: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
73: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,

Line 70: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,

66: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
67: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
68: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
69: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
70: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
72: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
73: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
74: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,

Line 71: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,

67: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
68: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
69: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
70: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
72: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
73: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
74: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
75: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,

Line 72: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,

68: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
69: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
70: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
72: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
73: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
74: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
75: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
76: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 73: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,

69: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
70: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
72: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
73: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
74: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
75: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
76: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 74: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,

70: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
72: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
73: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
74: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
75: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
76: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,

Line 75: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,

71: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
72: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
73: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
74: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
75: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
76: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
79: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,

Line 76: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,

72: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
73: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
74: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
75: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
76: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
79: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
80: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,

Line 77: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,

73: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
74: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
75: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
76: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
79: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
80: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
81: QUANTITY NUMBER := FND_API.G_MISS_NUM,

Line 78: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,

74: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
75: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
76: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
79: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
80: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
81: QUANTITY NUMBER := FND_API.G_MISS_NUM,
82: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,

Line 79: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,

75: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
76: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
79: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
80: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
81: QUANTITY NUMBER := FND_API.G_MISS_NUM,
82: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
83: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,

Line 80: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,

76: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
79: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
80: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
81: QUANTITY NUMBER := FND_API.G_MISS_NUM,
82: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
83: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
84: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 81: QUANTITY NUMBER := FND_API.G_MISS_NUM,

77: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
79: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
80: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
81: QUANTITY NUMBER := FND_API.G_MISS_NUM,
82: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
83: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
84: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 82: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,

78: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
79: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
80: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
81: QUANTITY NUMBER := FND_API.G_MISS_NUM,
82: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
83: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
84: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 83: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,

79: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
80: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
81: QUANTITY NUMBER := FND_API.G_MISS_NUM,
82: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
83: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
84: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 84: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

80: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
81: QUANTITY NUMBER := FND_API.G_MISS_NUM,
82: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
83: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
84: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,

Line 85: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

81: QUANTITY NUMBER := FND_API.G_MISS_NUM,
82: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
83: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
84: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
89: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,

Line 86: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

82: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
83: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
84: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
89: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
90: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,

Line 87: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

83: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
84: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
89: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
90: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
91: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,

Line 88: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,

84: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
89: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
90: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
91: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
92: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,

Line 89: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,

85: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
89: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
90: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
91: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
92: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
93: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,

Line 90: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,

86: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
89: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
90: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
91: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
92: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
93: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
94: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,

Line 91: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,

87: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
89: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
90: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
91: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
92: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
93: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
94: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
95: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 92: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,

88: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
89: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
90: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
91: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
92: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
93: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
94: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
95: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 93: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,

89: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
90: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
91: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
92: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
93: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
94: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
95: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
97: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 94: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,

90: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
91: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
92: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
93: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
94: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
95: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
97: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 95: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

91: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
92: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
93: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
94: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
95: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
97: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 96: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,

92: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
93: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
94: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
95: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
97: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 97: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

93: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
94: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
95: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
97: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 98: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,

94: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
95: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
97: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 99: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,

95: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
97: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 100: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

96: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
97: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 101: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,

97: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 102: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,

98: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
106: CREATION_DATE DATE := FND_API.G_MISS_DATE,

Line 103: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

99: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
106: CREATION_DATE DATE := FND_API.G_MISS_DATE,
107: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 104: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,

100: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
106: CREATION_DATE DATE := FND_API.G_MISS_DATE,
107: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
108: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 105: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

101: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
106: CREATION_DATE DATE := FND_API.G_MISS_DATE,
107: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
108: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
109: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 106: CREATION_DATE DATE := FND_API.G_MISS_DATE,

102: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
106: CREATION_DATE DATE := FND_API.G_MISS_DATE,
107: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
108: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
109: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
110: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 107: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

103: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
106: CREATION_DATE DATE := FND_API.G_MISS_DATE,
107: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
108: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
109: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
110: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 108: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

104: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
106: CREATION_DATE DATE := FND_API.G_MISS_DATE,
107: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
108: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
109: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
110: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 109: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

105: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
106: CREATION_DATE DATE := FND_API.G_MISS_DATE,
107: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
108: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
109: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
110: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 110: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

106: CREATION_DATE DATE := FND_API.G_MISS_DATE,
107: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
108: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
109: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
110: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 111: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

107: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
108: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
109: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
110: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 112: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

108: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
109: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
110: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 113: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

109: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
110: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 114: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

110: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 115: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

111: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 116: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

112: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 117: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

113: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 118: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

114: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 119: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

115: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 120: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

116: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 121: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

117: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 122: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

118: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 123: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

119: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,

Line 124: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

120: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
128: RETURN_DATE DATE := FND_API.G_MISS_DATE

Line 125: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

121: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
128: RETURN_DATE DATE := FND_API.G_MISS_DATE
129: );

Line 126: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

122: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
128: RETURN_DATE DATE := FND_API.G_MISS_DATE
129: );
130:

Line 127: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,

123: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
128: RETURN_DATE DATE := FND_API.G_MISS_DATE
129: );
130:
131: G_MISS_DEBRIEF_LINE_REC DEBRIEF_LINE_Rec_Type;

Line 128: RETURN_DATE DATE := FND_API.G_MISS_DATE

124: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
128: RETURN_DATE DATE := FND_API.G_MISS_DATE
129: );
130:
131: G_MISS_DEBRIEF_LINE_REC DEBRIEF_LINE_Rec_Type;
132: TYPE DEBRIEF_LINE_Tbl_Type IS TABLE OF DEBRIEF_LINE_Rec_Type

Line 141: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

137: -- Type : Private
138:
139: PROCEDURE Create_debrief(
140: P_Api_Version_Number IN NUMBER,
141: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
142: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
143: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
144: P_DEBRIEF_Rec IN DEBRIEF_Rec_Type := G_MISS_DEBRIEF_REC,
145: P_DEBRIEF_LINE_tbl IN DEBRIEF_LINE_tbl_type

Line 142: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

138:
139: PROCEDURE Create_debrief(
140: P_Api_Version_Number IN NUMBER,
141: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
142: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
143: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
144: P_DEBRIEF_Rec IN DEBRIEF_Rec_Type := G_MISS_DEBRIEF_REC,
145: P_DEBRIEF_LINE_tbl IN DEBRIEF_LINE_tbl_type
146: := G_MISS_DEBRIEF_LINE_tbl,

Line 143: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

139: PROCEDURE Create_debrief(
140: P_Api_Version_Number IN NUMBER,
141: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
142: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
143: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
144: P_DEBRIEF_Rec IN DEBRIEF_Rec_Type := G_MISS_DEBRIEF_REC,
145: P_DEBRIEF_LINE_tbl IN DEBRIEF_LINE_tbl_type
146: := G_MISS_DEBRIEF_LINE_tbl,
147: x_DEBRIEF_HEADER_ID OUT NOCOPY NUMBER,

Line 157: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

153: -- API Name: Update_debrief
154:
155: PROCEDURE Update_debrief(
156: P_Api_Version_Number IN NUMBER,
157: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
158: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160: P_debrief_Rec IN debrief_Rec_Type,
161: X_Return_Status OUT NOCOPY VARCHAR2,

Line 158: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

154:
155: PROCEDURE Update_debrief(
156: P_Api_Version_Number IN NUMBER,
157: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
158: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160: P_debrief_Rec IN debrief_Rec_Type,
161: X_Return_Status OUT NOCOPY VARCHAR2,
162: X_Msg_Count OUT NOCOPY NUMBER,

Line 159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

155: PROCEDURE Update_debrief(
156: P_Api_Version_Number IN NUMBER,
157: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
158: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160: P_debrief_Rec IN debrief_Rec_Type,
161: X_Return_Status OUT NOCOPY VARCHAR2,
162: X_Msg_Count OUT NOCOPY NUMBER,
163: X_Msg_Data OUT NOCOPY VARCHAR2

Line 169: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

165:
166:
167: PROCEDURE Create_debrief_lines(
168: P_Api_Version_Number IN NUMBER,
169: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
170: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
171: P_Upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
172: P_Task_Assignment_status IN VARCHAR2 DEFAULT NULL,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

166:
167: PROCEDURE Create_debrief_lines(
168: P_Api_Version_Number IN NUMBER,
169: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
170: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
171: P_Upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
172: P_Task_Assignment_status IN VARCHAR2 DEFAULT NULL,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: P_DEBRIEF_LINE_tbl IN DEBRIEF_LINE_tbl_type,

Line 173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

169: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
170: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
171: P_Upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
172: P_Task_Assignment_status IN VARCHAR2 DEFAULT NULL,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: P_DEBRIEF_LINE_tbl IN DEBRIEF_LINE_tbl_type,
175: -- DEFAULT G_MISS_DEBRIEF_LINE_tbl,
176: P_DEBRIEF_HEADER_ID IN NUMBER ,
177: P_SOURCE_OBJECT_TYPE_CODE IN VARCHAR2,

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

182:
183:
184: PROCEDURE Update_debrief_line(
185: P_Api_Version_Number IN NUMBER,
186: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
187: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
188: P_Upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
189: P_Task_Assignment_status IN VARCHAR2 DEFAULT NULL,
190: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 187: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

183:
184: PROCEDURE Update_debrief_line(
185: P_Api_Version_Number IN NUMBER,
186: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
187: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
188: P_Upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
189: P_Task_Assignment_status IN VARCHAR2 DEFAULT NULL,
190: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191: P_DEBRIEF_LINE_Rec IN OUT NOCOPY DEBRIEF_LINE_Rec_type,

Line 190: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

186: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
187: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
188: P_Upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
189: P_Task_Assignment_status IN VARCHAR2 DEFAULT NULL,
190: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191: P_DEBRIEF_LINE_Rec IN OUT NOCOPY DEBRIEF_LINE_Rec_type,
192: X_Return_Status OUT NOCOPY VARCHAR2,
193: X_Msg_Count OUT NOCOPY NUMBER,
194: X_Msg_Data OUT NOCOPY VARCHAR2

Line 198: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

194: X_Msg_Data OUT NOCOPY VARCHAR2
195: ) ;
196:
197: PROCEDURE Validate_Task_Assignment_ID (
198: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
199: P_Validation_mode IN VARCHAR2,
200: P_TASK_Assignment_ID IN NUMBER,
201: X_Return_Status OUT NOCOPY VARCHAR2,
202: X_Msg_Count OUT NOCOPY NUMBER,

Line 207: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

203: X_Msg_Data OUT NOCOPY VARCHAR2
204: );
205:
206: PROCEDURE Validate_Debrief_Date (
207: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
208: P_Validation_mode IN VARCHAR2,
209: P_Debrief_Date IN DATE,
210: X_Return_Status OUT NOCOPY VARCHAR2,
211: X_Msg_Count OUT NOCOPY NUMBER,

Line 216: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

212: X_Msg_Data OUT NOCOPY VARCHAR2
213: );
214:
215: PROCEDURE Validate_Service_Date (
216: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
217: P_Service_Date IN DATE,
218: X_Return_Status OUT NOCOPY VARCHAR2,
219: X_Msg_Count OUT NOCOPY NUMBER,
220: X_Msg_Data OUT NOCOPY VARCHAR2

Line 224: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

220: X_Msg_Data OUT NOCOPY VARCHAR2
221: );
222:
223: PROCEDURE Validate_DEBRIEF_LINE_NUMBER (
224: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
225: P_Validation_mode IN VARCHAR2,
226: P_DEBRIEF_LINE_NUMBER IN NUMBER,
227: X_Return_Status OUT NOCOPY VARCHAR2,
228: X_Msg_Count OUT NOCOPY NUMBER,

Line 233: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

229: X_Msg_Data OUT NOCOPY VARCHAR2
230: );
231:
232: PROCEDURE Validate_BUSINESS_PROCESS_ID (
233: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
234: P_BUSINESS_PROCESS_ID IN NUMBER,
235: X_Return_Status OUT NOCOPY VARCHAR2,
236: X_Msg_Count OUT NOCOPY NUMBER,
237: X_Msg_Data OUT NOCOPY VARCHAR2

Line 240: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

236: X_Msg_Count OUT NOCOPY NUMBER,
237: X_Msg_Data OUT NOCOPY VARCHAR2
238: );
239: PROCEDURE Validate_TRANSACTION_TYPE_ID (
240: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
241: P_TRANSACTION_TYPE_ID IN NUMBER,
242: X_Return_Status OUT NOCOPY VARCHAR2,
243: X_Msg_Count OUT NOCOPY NUMBER,
244: X_Msg_Data OUT NOCOPY VARCHAR2

Line 249: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

245: );
246:
247:
248: PROCEDURE Validate_Inventory_Item_ID (
249: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
250: p_organization_id IN NUMBER,
251: P_Inventory_Item_ID IN NUMBER,
252: X_Return_Status OUT NOCOPY VARCHAR2,
253: X_Msg_Count OUT NOCOPY NUMBER,

Line 257: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

253: X_Msg_Count OUT NOCOPY NUMBER,
254: X_Msg_Data OUT NOCOPY VARCHAR2 );
255:
256: PROCEDURE Validate_Instance_ID (
257: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
258: P_Instance_ID IN NUMBER,
259: X_Return_Status OUT NOCOPY VARCHAR2,
260: X_Msg_Count OUT NOCOPY NUMBER,
261: X_Msg_Data OUT NOCOPY VARCHAR2 );

Line 265: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

261: X_Msg_Data OUT NOCOPY VARCHAR2 );
262:
263:
264: PROCEDURE Validate_Debrief_Header_ID (
265: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
266: P_Debrief_Header_ID IN NUMBER,
267: X_Return_Status OUT NOCOPY VARCHAR2,
268: X_Msg_Count OUT NOCOPY NUMBER,
269: X_Msg_Data OUT NOCOPY VARCHAR2);

Line 272: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

268: X_Msg_Count OUT NOCOPY NUMBER,
269: X_Msg_Data OUT NOCOPY VARCHAR2);
270: PROCEDURE Validate_Task_Assignment_Satus(
271: P_Api_Version_Number IN NUMBER,
272: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
273: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
274: P_Task_Assignment_status IN VARCHAR2 DEFAULT NULL,
275: X_TA_STATUS_ID OUT NOCOPY NUMBER,
276: X_Return_Status OUT NOCOPY VARCHAR2,

Line 273: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

269: X_Msg_Data OUT NOCOPY VARCHAR2);
270: PROCEDURE Validate_Task_Assignment_Satus(
271: P_Api_Version_Number IN NUMBER,
272: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
273: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
274: P_Task_Assignment_status IN VARCHAR2 DEFAULT NULL,
275: X_TA_STATUS_ID OUT NOCOPY NUMBER,
276: X_Return_Status OUT NOCOPY VARCHAR2,
277: X_Msg_Count OUT NOCOPY NUMBER,

Line 283: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

279: );
280: Function IS_DEBRIEF_HEADER_REC_MISSING(P_DEBRIEF_REC DEBRIEF_REC_TYPE) Return BOOLEAN ;
281:
282: Procedure CREATE_INTERACTION(P_Api_Version_Number IN NUMBER,
283: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
284: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
285: P_TASK_ASSIGNMENT_ID IN NUMBER,
286: P_DEBRIEF_HEADER_ID IN NUMBER,
287: P_MEDIA_ID IN NUMBER,

Line 284: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

280: Function IS_DEBRIEF_HEADER_REC_MISSING(P_DEBRIEF_REC DEBRIEF_REC_TYPE) Return BOOLEAN ;
281:
282: Procedure CREATE_INTERACTION(P_Api_Version_Number IN NUMBER,
283: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
284: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
285: P_TASK_ASSIGNMENT_ID IN NUMBER,
286: P_DEBRIEF_HEADER_ID IN NUMBER,
287: P_MEDIA_ID IN NUMBER,
288: P_ACTION_ID IN NUMBER,

Line 294: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

290: X_Msg_Count OUT NOCOPY NUMBER,
291: X_Msg_Data OUT NOCOPY VARCHAR2) ;
292:
293: PROCEDURE validate_subinventory_code (
294: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
295: p_organization_id IN number,
296: p_subinventory_code in varchar2,
297: X_Return_Status OUT NOCOPY VARCHAR2,
298: X_Msg_Count OUT NOCOPY NUMBER,

Line 326: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

322: x_msg_count out nocopy number,
323: x_msg_data out nocopy varchar2
324: ) ;
325: PROCEDURE VALIDATE_COUNTERS (
326: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
327: p_task_id in number,
328: p_incident_id in number,
329: x_return_status out nocopy varchar2,
330: x_msg_count out nocopy number,

Line 335: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

331: x_msg_data out nocopy varchar2
332: ) ;
333:
334: PROCEDURE VALIDATE_LABOR_TIMES (
335: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
336: P_api_version_number In number,
337: p_resource_type_code in Varchar2,
338: p_resource_id in Number,
339: p_debrief_line_id in Number,

Line 372: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

368:
369: Procedure validate_travel_times(p_actual_travel_start_time date,
370: p_actual_travel_end_time date,
371: p_task_assignment_id NUMBER,
372: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
373: X_Return_Status OUT NOCOPY VARCHAR2,
374: X_Msg_Count OUT NOCOPY NUMBER,
375: X_Msg_Data OUT NOCOPY VARCHAR2);
376: