29: -- -------------------------------------------------------
30:
31: TYPE DEBRIEF_Rec_Type IS RECORD
32: (
33: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
34: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
35: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
36: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
37: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
30:
31: TYPE DEBRIEF_Rec_Type IS RECORD
32: (
33: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
34: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
35: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
36: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
37: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
38: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
31: TYPE DEBRIEF_Rec_Type IS RECORD
32: (
33: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
34: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
35: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
36: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
37: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
38: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
39: CREATION_DATE DATE := FND_API.G_MISS_DATE,
32: (
33: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
34: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
35: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
36: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
37: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
38: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
39: CREATION_DATE DATE := FND_API.G_MISS_DATE,
40: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
33: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
34: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
35: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
36: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
37: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
38: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
39: CREATION_DATE DATE := FND_API.G_MISS_DATE,
40: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
41: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
34: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
35: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
36: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
37: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
38: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
39: CREATION_DATE DATE := FND_API.G_MISS_DATE,
40: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
41: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
42: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
35: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
36: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
37: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
38: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
39: CREATION_DATE DATE := FND_API.G_MISS_DATE,
40: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
41: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
42: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
43: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
37: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
38: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
39: CREATION_DATE DATE := FND_API.G_MISS_DATE,
40: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
41: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
42: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
43: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
38: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
39: CREATION_DATE DATE := FND_API.G_MISS_DATE,
40: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
41: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
42: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
43: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
39: CREATION_DATE DATE := FND_API.G_MISS_DATE,
40: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
41: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
42: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
43: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: CREATION_DATE DATE := FND_API.G_MISS_DATE,
40: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
41: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
42: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
43: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
41: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
42: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
43: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
42: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
43: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
43: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
52: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
53: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
61: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
54: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
61: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
62: TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM
55: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
61: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
62: TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM
63: );
56: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
61: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
62: TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM
63: );
64:
57: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
61: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
62: TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM
63: );
64:
65: G_MISS_DEBRIEF_REC DEBRIEF_Rec_Type;
58: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
61: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
62: TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM
63: );
64:
65: G_MISS_DEBRIEF_REC DEBRIEF_Rec_Type;
66: TYPE DEBRIEF_Tbl_Type IS TABLE OF DEBRIEF_Rec_Type
73: );
74:
75: TYPE DEBRIEF_LINE_Rec_Type IS RECORD
76: (
77: DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
78: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
79: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
80: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
81: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
74:
75: TYPE DEBRIEF_LINE_Rec_Type IS RECORD
76: (
77: DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
78: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
79: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
80: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
81: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
82: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
75: TYPE DEBRIEF_LINE_Rec_Type IS RECORD
76: (
77: DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
78: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
79: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
80: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
81: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
82: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
83: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
76: (
77: DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
78: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
79: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
80: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
81: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
82: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
83: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
84: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
77: DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
78: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
79: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
80: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
81: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
82: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
83: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
84: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
85: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
78: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
79: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
80: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
81: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
82: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
83: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
84: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
85: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
86: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
79: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
80: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
81: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
82: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
83: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
84: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
85: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
86: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
87: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
80: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
81: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
82: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
83: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
84: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
85: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
86: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
87: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
88: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
81: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
82: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
83: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
84: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
85: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
86: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
87: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
88: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
89: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
82: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
83: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
84: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
85: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
86: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
87: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
88: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
89: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
90: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
83: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
84: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
85: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
86: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
87: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
88: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
89: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
90: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
91: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
84: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
85: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
86: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
87: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
88: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
89: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
90: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
91: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
92: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
85: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
86: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
87: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
88: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
89: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
90: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
91: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
92: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
93: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
87: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
88: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
89: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
90: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
91: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
92: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
93: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
88: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
89: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
90: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
91: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
92: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
93: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
88: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
89: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
90: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
91: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
92: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
93: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
96: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
90: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
91: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
92: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
93: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
96: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
97: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
90: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
91: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
92: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
93: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
96: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
97: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
98: QUANTITY NUMBER := FND_API.G_MISS_NUM,
91: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
92: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
93: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
96: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
97: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
98: QUANTITY NUMBER := FND_API.G_MISS_NUM,
99: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
92: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
93: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
96: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
97: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
98: QUANTITY NUMBER := FND_API.G_MISS_NUM,
99: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
100: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
93: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
96: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
97: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
98: QUANTITY NUMBER := FND_API.G_MISS_NUM,
99: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
100: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
101: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
96: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
97: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
98: QUANTITY NUMBER := FND_API.G_MISS_NUM,
99: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
100: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
101: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
96: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
97: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
98: QUANTITY NUMBER := FND_API.G_MISS_NUM,
99: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
100: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
101: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
97: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
98: QUANTITY NUMBER := FND_API.G_MISS_NUM,
99: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
100: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
101: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
97: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
98: QUANTITY NUMBER := FND_API.G_MISS_NUM,
99: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
100: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
101: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
98: QUANTITY NUMBER := FND_API.G_MISS_NUM,
99: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
100: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
101: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
106: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
99: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
100: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
101: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
106: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
107: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
100: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
101: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
106: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
107: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
108: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
101: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
106: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
107: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
108: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
109: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
102: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
106: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
107: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
108: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
109: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
110: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
103: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
106: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
107: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
108: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
109: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
110: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
111: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
104: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
106: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
107: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
108: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
109: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
110: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
111: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
112: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
106: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
107: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
108: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
109: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
110: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
111: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
112: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
107: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
108: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
109: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
110: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
111: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
112: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
114: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
108: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
109: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
110: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
111: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
112: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
114: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
115: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
108: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
109: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
110: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
111: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
112: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
114: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
115: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
116: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
110: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
111: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
112: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
114: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
115: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
116: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
111: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
112: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
114: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
115: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
116: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
111: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
112: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
114: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
115: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
116: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
119: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
114: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
115: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
116: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
119: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
114: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
115: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
116: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
119: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
114: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
115: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
116: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
119: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
122: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
115: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
116: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
119: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
122: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
123: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
116: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
119: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
122: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
123: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
124: CREATION_DATE DATE := FND_API.G_MISS_DATE,
117: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
119: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
122: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
123: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
124: CREATION_DATE DATE := FND_API.G_MISS_DATE,
125: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
118: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
119: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
122: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
123: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
124: CREATION_DATE DATE := FND_API.G_MISS_DATE,
125: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
126: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
119: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
122: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
123: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
124: CREATION_DATE DATE := FND_API.G_MISS_DATE,
125: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
126: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
127: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
120: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
122: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
123: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
124: CREATION_DATE DATE := FND_API.G_MISS_DATE,
125: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
126: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
127: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
128: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
122: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
123: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
124: CREATION_DATE DATE := FND_API.G_MISS_DATE,
125: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
126: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
127: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
128: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
123: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
124: CREATION_DATE DATE := FND_API.G_MISS_DATE,
125: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
126: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
127: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
128: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
124: CREATION_DATE DATE := FND_API.G_MISS_DATE,
125: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
126: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
127: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
128: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: CREATION_DATE DATE := FND_API.G_MISS_DATE,
125: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
126: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
127: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
128: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
126: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
127: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
128: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
127: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
128: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
128: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
128: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
145: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
138: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
145: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
146: RETURN_DATE DATE := FND_API.G_MISS_DATE,
139: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
145: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
146: RETURN_DATE DATE := FND_API.G_MISS_DATE,
147: MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
140: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
145: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
146: RETURN_DATE DATE := FND_API.G_MISS_DATE,
147: MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
148: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
141: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
145: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
146: RETURN_DATE DATE := FND_API.G_MISS_DATE,
147: MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
148: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
149: );
142: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
145: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
146: RETURN_DATE DATE := FND_API.G_MISS_DATE,
147: MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
148: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
149: );
150:
143: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
145: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
146: RETURN_DATE DATE := FND_API.G_MISS_DATE,
147: MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
148: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
149: );
150:
151: G_MISS_DEBRIEF_LINE_REC DEBRIEF_LINE_Rec_Type;
144: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
145: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
146: RETURN_DATE DATE := FND_API.G_MISS_DATE,
147: MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
148: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
149: );
150:
151: G_MISS_DEBRIEF_LINE_REC DEBRIEF_LINE_Rec_Type;
152: TYPE DEBRIEF_LINE_Tbl_Type IS TABLE OF DEBRIEF_LINE_Rec_Type
176: * @rep:displayname Create Debrief Header and Lines
177: */
178: PROCEDURE Create_DEBRIEF(
179: p_api_version_number IN NUMBER,
180: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
181: p_commit IN VARCHAR2 := FND_API.G_FALSE,
182: p_debrief_rec IN DEBRIEF_Rec_Type := G_MISS_DEBRIEF_REC,
183: p_debrief_line_tbl IN DEBRIEF_LINE_tbl_type ,
184: -- DEFAULT G_MISS_DEBRIEF_LINE_tbl,
177: */
178: PROCEDURE Create_DEBRIEF(
179: p_api_version_number IN NUMBER,
180: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
181: p_commit IN VARCHAR2 := FND_API.G_FALSE,
182: p_debrief_rec IN DEBRIEF_Rec_Type := G_MISS_DEBRIEF_REC,
183: p_debrief_line_tbl IN DEBRIEF_LINE_tbl_type ,
184: -- DEFAULT G_MISS_DEBRIEF_LINE_tbl,
185: x_debrief_header_id OUT NOCOPY NUMBER,
204: * @rep:displayname Update a Debrief Header
205: */
206: PROCEDURE Update_debrief(
207: p_api_version_number IN NUMBER,
208: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
209: p_commit IN VARCHAR2 := FND_API.G_FALSE,
210: p_debrief_rec IN DEBRIEF_Rec_Type DEFAULT G_MISS_DEBRIEF_REC,
211: x_return_status OUT NOCOPY VARCHAR2,
212: x_msg_count OUT NOCOPY NUMBER,
205: */
206: PROCEDURE Update_debrief(
207: p_api_version_number IN NUMBER,
208: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
209: p_commit IN VARCHAR2 := FND_API.G_FALSE,
210: p_debrief_rec IN DEBRIEF_Rec_Type DEFAULT G_MISS_DEBRIEF_REC,
211: x_return_status OUT NOCOPY VARCHAR2,
212: x_msg_count OUT NOCOPY NUMBER,
213: x_msg_data OUT NOCOPY VARCHAR2
235: * @rep:displayname Create Debrief Header and Lines
236: */
237: PROCEDURE Create_debrief_lines(
238: p_api_version_number IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240: p_commit IN VARCHAR2 := FND_API.G_FALSE,
241: p_upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
242: p_task_assignment_status IN VARCHAR2 DEFAULT NULL,
243: p_debrief_line_tbl IN DEBRIEF_LINE_Tbl_Type := G_MISS_DEBRIEF_LINE_Tbl,
236: */
237: PROCEDURE Create_debrief_lines(
238: p_api_version_number IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240: p_commit IN VARCHAR2 := FND_API.G_FALSE,
241: p_upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
242: p_task_assignment_status IN VARCHAR2 DEFAULT NULL,
243: p_debrief_line_tbl IN DEBRIEF_LINE_Tbl_Type := G_MISS_DEBRIEF_LINE_Tbl,
244: p_debrief_header_id IN NUMBER,
267: * @rep:displayname Update Debrief Line
268: */
269: PROCEDURE Update_debrief_line(
270: p_api_version_number IN NUMBER,
271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272: p_commit IN VARCHAR2 := FND_API.G_FALSE,
273: p_upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
274: p_task_assignment_status IN VARCHAR2 DEFAULT NULL,
275: p_debrief_line_rec IN DEBRIEF_LINE_Rec_Type,
268: */
269: PROCEDURE Update_debrief_line(
270: p_api_version_number IN NUMBER,
271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272: p_commit IN VARCHAR2 := FND_API.G_FALSE,
273: p_upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
274: p_task_assignment_status IN VARCHAR2 DEFAULT NULL,
275: p_debrief_line_rec IN DEBRIEF_LINE_Rec_Type,
276: x_return_status OUT NOCOPY VARCHAR2,