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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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: );
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:
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;
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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:
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: USAGE_TYPE VARCHAR2(10) := 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: USAGE_TYPE VARCHAR2(10) := FND_API.G_MISS_CHAR,
131: DEST_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
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: USAGE_TYPE VARCHAR2(10) := FND_API.G_MISS_CHAR,
131: DEST_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
132: DEST_SUBINVENTORY_NAME VARCHAR2(10) := 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: USAGE_TYPE VARCHAR2(10) := FND_API.G_MISS_CHAR,
131: DEST_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
132: DEST_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
133: CARRIER_CODE VARCHAR2(25) := FND_API.G_MISS_CHAR,
134: SHIPPING_METHOD VARCHAR2(60) := 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: USAGE_TYPE VARCHAR2(10) := FND_API.G_MISS_CHAR,
131: DEST_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
132: DEST_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
133: CARRIER_CODE VARCHAR2(25) := FND_API.G_MISS_CHAR,
134: SHIPPING_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
135: SHIPMENT_NUMBER VARCHAR2(60) := FND_API.G_MISS_CHAR,
128: RETURN_DATE DATE := FND_API.G_MISS_DATE,
129:
130: USAGE_TYPE VARCHAR2(10) := FND_API.G_MISS_CHAR,
131: DEST_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
132: DEST_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
133: CARRIER_CODE VARCHAR2(25) := FND_API.G_MISS_CHAR,
134: SHIPPING_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
135: SHIPMENT_NUMBER VARCHAR2(60) := FND_API.G_MISS_CHAR,
136: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
129:
130: USAGE_TYPE VARCHAR2(10) := FND_API.G_MISS_CHAR,
131: DEST_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
132: DEST_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
133: CARRIER_CODE VARCHAR2(25) := FND_API.G_MISS_CHAR,
134: SHIPPING_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
135: SHIPMENT_NUMBER VARCHAR2(60) := FND_API.G_MISS_CHAR,
136: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
137:
130: USAGE_TYPE VARCHAR2(10) := FND_API.G_MISS_CHAR,
131: DEST_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
132: DEST_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
133: CARRIER_CODE VARCHAR2(25) := FND_API.G_MISS_CHAR,
134: SHIPPING_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
135: SHIPMENT_NUMBER VARCHAR2(60) := FND_API.G_MISS_CHAR,
136: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
137:
138: EXPENDITURE_ORG_ID NUMBER := FND_API.G_MISS_NUM,
131: DEST_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
132: DEST_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
133: CARRIER_CODE VARCHAR2(25) := FND_API.G_MISS_CHAR,
134: SHIPPING_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
135: SHIPMENT_NUMBER VARCHAR2(60) := FND_API.G_MISS_CHAR,
136: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
137:
138: EXPENDITURE_ORG_ID NUMBER := FND_API.G_MISS_NUM,
139: PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
132: DEST_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
133: CARRIER_CODE VARCHAR2(25) := FND_API.G_MISS_CHAR,
134: SHIPPING_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
135: SHIPMENT_NUMBER VARCHAR2(60) := FND_API.G_MISS_CHAR,
136: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
137:
138: EXPENDITURE_ORG_ID NUMBER := FND_API.G_MISS_NUM,
139: PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
140: PROJECT_TASK_ID NUMBER := FND_API.G_MISS_NUM
134: SHIPPING_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
135: SHIPMENT_NUMBER VARCHAR2(60) := FND_API.G_MISS_CHAR,
136: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
137:
138: EXPENDITURE_ORG_ID NUMBER := FND_API.G_MISS_NUM,
139: PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
140: PROJECT_TASK_ID NUMBER := FND_API.G_MISS_NUM
141: );
142:
135: SHIPMENT_NUMBER VARCHAR2(60) := FND_API.G_MISS_CHAR,
136: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
137:
138: EXPENDITURE_ORG_ID NUMBER := FND_API.G_MISS_NUM,
139: PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
140: PROJECT_TASK_ID NUMBER := FND_API.G_MISS_NUM
141: );
142:
143: G_MISS_DEBRIEF_LINE_REC DEBRIEF_LINE_Rec_Type;
136: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
137:
138: EXPENDITURE_ORG_ID NUMBER := FND_API.G_MISS_NUM,
139: PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
140: PROJECT_TASK_ID NUMBER := FND_API.G_MISS_NUM
141: );
142:
143: G_MISS_DEBRIEF_LINE_REC DEBRIEF_LINE_Rec_Type;
144: TYPE DEBRIEF_LINE_Tbl_Type IS TABLE OF DEBRIEF_LINE_Rec_Type
149: -- Type : Private
150:
151: PROCEDURE Create_debrief(
152: P_Api_Version_Number IN NUMBER,
153: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
154: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
155: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
156: P_DEBRIEF_Rec IN DEBRIEF_Rec_Type := G_MISS_DEBRIEF_REC,
157: P_DEBRIEF_LINE_tbl IN DEBRIEF_LINE_tbl_type
150:
151: PROCEDURE Create_debrief(
152: P_Api_Version_Number IN NUMBER,
153: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
154: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
155: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
156: P_DEBRIEF_Rec IN DEBRIEF_Rec_Type := G_MISS_DEBRIEF_REC,
157: P_DEBRIEF_LINE_tbl IN DEBRIEF_LINE_tbl_type
158: := G_MISS_DEBRIEF_LINE_tbl,
151: PROCEDURE Create_debrief(
152: P_Api_Version_Number IN NUMBER,
153: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
154: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
155: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
156: P_DEBRIEF_Rec IN DEBRIEF_Rec_Type := G_MISS_DEBRIEF_REC,
157: P_DEBRIEF_LINE_tbl IN DEBRIEF_LINE_tbl_type
158: := G_MISS_DEBRIEF_LINE_tbl,
159: x_DEBRIEF_HEADER_ID OUT NOCOPY NUMBER,
165: -- API Name: Update_debrief
166:
167: PROCEDURE Update_debrief(
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_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: P_debrief_Rec IN debrief_Rec_Type,
173: X_Return_Status OUT NOCOPY VARCHAR2,
166:
167: PROCEDURE Update_debrief(
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_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: P_debrief_Rec IN debrief_Rec_Type,
173: X_Return_Status OUT NOCOPY VARCHAR2,
174: X_Msg_Count OUT NOCOPY NUMBER,
167: PROCEDURE Update_debrief(
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_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: P_debrief_Rec IN debrief_Rec_Type,
173: X_Return_Status OUT NOCOPY VARCHAR2,
174: X_Msg_Count OUT NOCOPY NUMBER,
175: X_Msg_Data OUT NOCOPY VARCHAR2
177:
178:
179: PROCEDURE Create_debrief_lines(
180: P_Api_Version_Number IN NUMBER,
181: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
182: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
183: P_Upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
184: P_Task_Assignment_status IN VARCHAR2 DEFAULT NULL,
185: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178:
179: PROCEDURE Create_debrief_lines(
180: P_Api_Version_Number IN NUMBER,
181: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
182: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
183: P_Upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
184: P_Task_Assignment_status IN VARCHAR2 DEFAULT NULL,
185: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
186: P_DEBRIEF_LINE_tbl IN DEBRIEF_LINE_tbl_type,
181: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
182: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
183: P_Upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
184: P_Task_Assignment_status IN VARCHAR2 DEFAULT NULL,
185: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
186: P_DEBRIEF_LINE_tbl IN DEBRIEF_LINE_tbl_type,
187: -- DEFAULT G_MISS_DEBRIEF_LINE_tbl,
188: P_DEBRIEF_HEADER_ID IN NUMBER ,
189: P_SOURCE_OBJECT_TYPE_CODE IN VARCHAR2,
194:
195:
196: PROCEDURE Update_debrief_line(
197: P_Api_Version_Number IN NUMBER,
198: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
199: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
200: P_Upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
201: P_Task_Assignment_status IN VARCHAR2 DEFAULT NULL,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195:
196: PROCEDURE Update_debrief_line(
197: P_Api_Version_Number IN NUMBER,
198: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
199: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
200: P_Upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
201: P_Task_Assignment_status IN VARCHAR2 DEFAULT NULL,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203: P_DEBRIEF_LINE_Rec IN OUT NOCOPY DEBRIEF_LINE_Rec_type,
198: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
199: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
200: P_Upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
201: P_Task_Assignment_status IN VARCHAR2 DEFAULT NULL,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203: P_DEBRIEF_LINE_Rec IN OUT NOCOPY DEBRIEF_LINE_Rec_type,
204: X_Return_Status OUT NOCOPY VARCHAR2,
205: X_Msg_Count OUT NOCOPY NUMBER,
206: X_Msg_Data OUT NOCOPY VARCHAR2
206: X_Msg_Data OUT NOCOPY VARCHAR2
207: ) ;
208:
209: PROCEDURE Validate_Task_Assignment_ID (
210: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
211: P_Validation_mode IN VARCHAR2,
212: P_TASK_Assignment_ID IN NUMBER,
213: X_Return_Status OUT NOCOPY VARCHAR2,
214: X_Msg_Count OUT NOCOPY NUMBER,
215: X_Msg_Data OUT NOCOPY VARCHAR2
216: );
217:
218: PROCEDURE Validate_Debrief_Date (
219: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
220: P_Validation_mode IN VARCHAR2,
221: P_Debrief_Date IN DATE,
222: X_Return_Status OUT NOCOPY VARCHAR2,
223: X_Msg_Count OUT NOCOPY NUMBER,
224: X_Msg_Data OUT NOCOPY VARCHAR2
225: );
226:
227: PROCEDURE Validate_Service_Date (
228: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
229: P_Service_Date IN DATE,
230: X_Return_Status OUT NOCOPY VARCHAR2,
231: X_Msg_Count OUT NOCOPY NUMBER,
232: X_Msg_Data OUT NOCOPY VARCHAR2
232: X_Msg_Data OUT NOCOPY VARCHAR2
233: );
234:
235: PROCEDURE Validate_DEBRIEF_LINE_NUMBER (
236: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
237: P_Validation_mode IN VARCHAR2,
238: P_DEBRIEF_LINE_NUMBER IN NUMBER,
239: X_Return_Status OUT NOCOPY VARCHAR2,
240: X_Msg_Count OUT NOCOPY NUMBER,
241: X_Msg_Data OUT NOCOPY VARCHAR2
242: );
243:
244: PROCEDURE Validate_BUSINESS_PROCESS_ID (
245: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
246: P_BUSINESS_PROCESS_ID IN NUMBER,
247: X_Return_Status OUT NOCOPY VARCHAR2,
248: X_Msg_Count OUT NOCOPY NUMBER,
249: X_Msg_Data OUT NOCOPY VARCHAR2
248: X_Msg_Count OUT NOCOPY NUMBER,
249: X_Msg_Data OUT NOCOPY VARCHAR2
250: );
251: PROCEDURE Validate_TRANSACTION_TYPE_ID (
252: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
253: P_TRANSACTION_TYPE_ID IN NUMBER,
254: X_Return_Status OUT NOCOPY VARCHAR2,
255: X_Msg_Count OUT NOCOPY NUMBER,
256: X_Msg_Data OUT NOCOPY VARCHAR2
257: );
258:
259:
260: PROCEDURE Validate_Inventory_Item_ID (
261: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
262: p_organization_id IN NUMBER,
263: P_Inventory_Item_ID IN NUMBER,
264: X_Return_Status OUT NOCOPY VARCHAR2,
265: X_Msg_Count OUT NOCOPY NUMBER,
265: X_Msg_Count OUT NOCOPY NUMBER,
266: X_Msg_Data OUT NOCOPY VARCHAR2 );
267:
268: PROCEDURE Validate_Instance_ID (
269: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
270: P_Instance_ID IN NUMBER,
271: X_Return_Status OUT NOCOPY VARCHAR2,
272: X_Msg_Count OUT NOCOPY NUMBER,
273: X_Msg_Data OUT NOCOPY VARCHAR2 );
273: X_Msg_Data OUT NOCOPY VARCHAR2 );
274:
275:
276: PROCEDURE Validate_Debrief_Header_ID (
277: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
278: P_Debrief_Header_ID IN NUMBER,
279: X_Return_Status OUT NOCOPY VARCHAR2,
280: X_Msg_Count OUT NOCOPY NUMBER,
281: X_Msg_Data OUT NOCOPY VARCHAR2);
280: X_Msg_Count OUT NOCOPY NUMBER,
281: X_Msg_Data OUT NOCOPY VARCHAR2);
282: PROCEDURE Validate_Task_Assignment_Satus(
283: P_Api_Version_Number IN NUMBER,
284: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
285: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
286: P_Task_Assignment_status IN VARCHAR2 DEFAULT NULL,
287: X_TA_STATUS_ID OUT NOCOPY NUMBER,
288: X_Return_Status OUT NOCOPY VARCHAR2,
281: X_Msg_Data OUT NOCOPY VARCHAR2);
282: PROCEDURE Validate_Task_Assignment_Satus(
283: P_Api_Version_Number IN NUMBER,
284: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
285: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
286: P_Task_Assignment_status IN VARCHAR2 DEFAULT NULL,
287: X_TA_STATUS_ID OUT NOCOPY NUMBER,
288: X_Return_Status OUT NOCOPY VARCHAR2,
289: X_Msg_Count OUT NOCOPY NUMBER,
291: );
292: Function IS_DEBRIEF_HEADER_REC_MISSING(P_DEBRIEF_REC DEBRIEF_REC_TYPE) Return BOOLEAN ;
293:
294: Procedure CREATE_INTERACTION(P_Api_Version_Number IN NUMBER,
295: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
296: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
297: P_TASK_ASSIGNMENT_ID IN NUMBER,
298: P_DEBRIEF_HEADER_ID IN NUMBER,
299: P_MEDIA_ID IN NUMBER,
292: Function IS_DEBRIEF_HEADER_REC_MISSING(P_DEBRIEF_REC DEBRIEF_REC_TYPE) Return BOOLEAN ;
293:
294: Procedure CREATE_INTERACTION(P_Api_Version_Number IN NUMBER,
295: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
296: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
297: P_TASK_ASSIGNMENT_ID IN NUMBER,
298: P_DEBRIEF_HEADER_ID IN NUMBER,
299: P_MEDIA_ID IN NUMBER,
300: P_ACTION_ID IN NUMBER,
302: X_Msg_Count OUT NOCOPY NUMBER,
303: X_Msg_Data OUT NOCOPY VARCHAR2) ;
304:
305: PROCEDURE validate_subinventory_code (
306: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
307: p_organization_id IN number,
308: p_subinventory_code in varchar2,
309: X_Return_Status OUT NOCOPY VARCHAR2,
310: X_Msg_Count OUT NOCOPY NUMBER,
334: x_msg_count out nocopy number,
335: x_msg_data out nocopy varchar2
336: ) ;
337: PROCEDURE VALIDATE_COUNTERS (
338: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
339: p_task_id in number,
340: p_incident_id in number,
341: x_return_status out nocopy varchar2,
342: x_msg_count out nocopy number,
343: x_msg_data out nocopy varchar2
344: ) ;
345:
346: PROCEDURE VALIDATE_LABOR_TIMES (
347: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
348: P_api_version_number In number,
349: p_resource_type_code in Varchar2,
350: p_resource_id in Number,
351: p_debrief_line_id in Number,
388:
389: Procedure validate_travel_times(p_actual_travel_start_time date,
390: p_actual_travel_end_time date,
391: p_task_assignment_id NUMBER,
392: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
393: X_Return_Status OUT NOCOPY VARCHAR2,
394: X_Msg_Count OUT NOCOPY NUMBER,
395: X_Msg_Data OUT NOCOPY VARCHAR2);
396: