30: -- -------------------------------------------------------
31:
32: TYPE DEBRIEF_Rec_Type IS RECORD
33: (
34: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
35: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
36: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
37: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
38: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
31:
32: TYPE DEBRIEF_Rec_Type IS RECORD
33: (
34: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
35: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
36: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
37: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
38: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
39: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
32: TYPE DEBRIEF_Rec_Type IS RECORD
33: (
34: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
35: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
36: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
37: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
38: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
39: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
40: CREATION_DATE DATE := FND_API.G_MISS_DATE,
33: (
34: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
35: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
36: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
37: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
38: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
39: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
40: CREATION_DATE DATE := FND_API.G_MISS_DATE,
41: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
34: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
35: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
36: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
37: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
38: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
39: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
40: CREATION_DATE DATE := FND_API.G_MISS_DATE,
41: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
42: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
35: DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
36: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
37: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
38: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
39: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
40: CREATION_DATE DATE := FND_API.G_MISS_DATE,
41: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
42: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
43: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
36: DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
37: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
38: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
39: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
40: CREATION_DATE DATE := FND_API.G_MISS_DATE,
41: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
42: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
43: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
44: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
38: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
39: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
40: CREATION_DATE DATE := FND_API.G_MISS_DATE,
41: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
42: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
43: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
44: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
39: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
40: CREATION_DATE DATE := FND_API.G_MISS_DATE,
41: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
42: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
43: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
44: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
40: CREATION_DATE DATE := FND_API.G_MISS_DATE,
41: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
42: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
43: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
44: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: CREATION_DATE DATE := FND_API.G_MISS_DATE,
41: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
42: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
43: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
44: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
42: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
43: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
44: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
43: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
44: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
44: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
53: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
61: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
54: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
61: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
62: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
55: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
61: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
62: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
63: TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM
56: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
61: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
62: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
63: TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM
64: );
57: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
61: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
62: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
63: TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM
64: );
65:
58: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
61: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
62: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
63: TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM
64: );
65:
66: G_MISS_DEBRIEF_REC DEBRIEF_Rec_Type;
59: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
61: TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
62: TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
63: TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM
64: );
65:
66: G_MISS_DEBRIEF_REC DEBRIEF_Rec_Type;
67: TYPE DEBRIEF_Tbl_Type IS TABLE OF DEBRIEF_Rec_Type
74: );
75:
76: TYPE DEBRIEF_LINE_Rec_Type IS RECORD
77: (
78: DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
79: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
80: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
81: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
82: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
75:
76: TYPE DEBRIEF_LINE_Rec_Type IS RECORD
77: (
78: DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
79: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
80: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
81: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
82: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
83: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
76: TYPE DEBRIEF_LINE_Rec_Type IS RECORD
77: (
78: DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
79: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
80: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
81: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
82: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
83: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
84: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
77: (
78: DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
79: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
80: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
81: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
82: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
83: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
84: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
85: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
78: DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
79: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
80: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
81: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
82: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
83: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
84: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
85: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
86: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
79: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
80: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
81: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
82: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
83: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
84: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
85: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
86: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
87: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
80: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
81: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
82: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
83: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
84: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
85: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
86: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
87: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
88: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
81: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
82: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
83: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
84: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
85: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
86: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
87: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
88: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
89: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
82: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
83: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
84: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
85: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
86: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
87: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
88: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
89: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
90: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
83: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
84: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
85: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
86: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
87: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
88: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
89: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
90: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
91: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
84: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
85: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
86: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
87: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
88: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
89: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
90: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
91: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
92: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
85: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
86: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
87: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
88: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
89: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
90: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
91: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
92: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
93: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
86: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
87: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
88: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
89: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
90: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
91: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
92: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
93: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
94: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
88: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
89: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
90: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
91: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
92: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
93: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
94: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
89: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
90: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
91: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
92: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
93: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
94: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
89: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
90: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
91: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
92: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
93: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
94: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
97: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
90: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
91: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
92: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
93: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
94: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
97: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
98: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
91: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
92: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
93: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
94: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
97: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
98: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
99: QUANTITY NUMBER := FND_API.G_MISS_NUM,
92: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
93: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
94: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
97: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
98: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
99: QUANTITY NUMBER := FND_API.G_MISS_NUM,
100: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
93: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
94: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
97: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
98: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
99: QUANTITY NUMBER := FND_API.G_MISS_NUM,
100: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
101: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
94: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
97: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
98: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
99: QUANTITY NUMBER := FND_API.G_MISS_NUM,
100: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
101: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
102: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
97: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
98: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
99: QUANTITY NUMBER := FND_API.G_MISS_NUM,
100: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
101: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
102: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
97: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
98: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
99: QUANTITY NUMBER := FND_API.G_MISS_NUM,
100: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
101: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
102: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
97: ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
98: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
99: QUANTITY NUMBER := FND_API.G_MISS_NUM,
100: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
101: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
102: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
99: QUANTITY NUMBER := FND_API.G_MISS_NUM,
100: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
101: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
102: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
99: QUANTITY NUMBER := FND_API.G_MISS_NUM,
100: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
101: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
102: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
107: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
100: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
101: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
102: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
107: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
108: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
101: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
102: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
107: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
108: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
109: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
102: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
107: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
108: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
109: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
110: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
103: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
107: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
108: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
109: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
110: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
111: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
104: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
107: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
108: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
109: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
110: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
111: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
112: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
105: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
107: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
108: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
109: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
110: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
111: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
112: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
113: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
107: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
108: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
109: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
110: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
111: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
112: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
113: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
114: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
108: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
109: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
110: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
111: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
112: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
113: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
114: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
115: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
109: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
110: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
111: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
112: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
113: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
114: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
115: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
109: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
110: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
111: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
112: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
113: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
114: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
115: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
117: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
111: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
112: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
113: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
114: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
115: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
117: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
112: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
113: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
114: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
115: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
117: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
112: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
113: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
114: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
115: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
117: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
120: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
114: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
115: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
117: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
120: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
114: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
115: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
117: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
120: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
115: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
117: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
120: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
116: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
117: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
120: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
124: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
117: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
120: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
124: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
125: CREATION_DATE DATE := FND_API.G_MISS_DATE,
118: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
120: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
124: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
125: CREATION_DATE DATE := FND_API.G_MISS_DATE,
126: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
119: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
120: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
124: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
125: CREATION_DATE DATE := FND_API.G_MISS_DATE,
126: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
127: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
120: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
124: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
125: CREATION_DATE DATE := FND_API.G_MISS_DATE,
126: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
127: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
128: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
121: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
124: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
125: CREATION_DATE DATE := FND_API.G_MISS_DATE,
126: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
127: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
128: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
129: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
124: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
125: CREATION_DATE DATE := FND_API.G_MISS_DATE,
126: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
127: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
128: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
129: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
124: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
125: CREATION_DATE DATE := FND_API.G_MISS_DATE,
126: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
127: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
128: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
129: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
125: CREATION_DATE DATE := FND_API.G_MISS_DATE,
126: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
127: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
128: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
129: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: CREATION_DATE DATE := FND_API.G_MISS_DATE,
126: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
127: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
128: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
129: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
127: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
128: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
129: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
128: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
129: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
128: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
129: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE_CATEGORY VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE_CATEGORY VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE_CATEGORY VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
146: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
139: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE_CATEGORY VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
146: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
147: RETURN_DATE DATE := FND_API.G_MISS_DATE,
140: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE_CATEGORY VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
146: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
147: RETURN_DATE DATE := FND_API.G_MISS_DATE,
148: MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
141: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE_CATEGORY VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
146: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
147: RETURN_DATE DATE := FND_API.G_MISS_DATE,
148: MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
149: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
142: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE_CATEGORY VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
146: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
147: RETURN_DATE DATE := FND_API.G_MISS_DATE,
148: MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
149: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
150:
143: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE_CATEGORY VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
146: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
147: RETURN_DATE DATE := FND_API.G_MISS_DATE,
148: MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
149: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
150:
151: USAGE_TYPE VARCHAR2(10) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE_CATEGORY VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
146: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
147: RETURN_DATE DATE := FND_API.G_MISS_DATE,
148: MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
149: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
150:
151: USAGE_TYPE VARCHAR2(10) := FND_API.G_MISS_CHAR,
152: DEST_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
145: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
146: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
147: RETURN_DATE DATE := FND_API.G_MISS_DATE,
148: MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
149: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
150:
151: USAGE_TYPE VARCHAR2(10) := FND_API.G_MISS_CHAR,
152: DEST_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
153: DEST_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
147: RETURN_DATE DATE := FND_API.G_MISS_DATE,
148: MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
149: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
150:
151: USAGE_TYPE VARCHAR2(10) := FND_API.G_MISS_CHAR,
152: DEST_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
153: DEST_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
154: CARRIER_CODE VARCHAR2(25) := FND_API.G_MISS_CHAR,
155: SHIPPING_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
148: MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
149: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
150:
151: USAGE_TYPE VARCHAR2(10) := FND_API.G_MISS_CHAR,
152: DEST_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
153: DEST_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
154: CARRIER_CODE VARCHAR2(25) := FND_API.G_MISS_CHAR,
155: SHIPPING_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
156: SHIPMENT_NUMBER VARCHAR2(60) := FND_API.G_MISS_CHAR,
149: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
150:
151: USAGE_TYPE VARCHAR2(10) := FND_API.G_MISS_CHAR,
152: DEST_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
153: DEST_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
154: CARRIER_CODE VARCHAR2(25) := FND_API.G_MISS_CHAR,
155: SHIPPING_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
156: SHIPMENT_NUMBER VARCHAR2(60) := FND_API.G_MISS_CHAR,
157: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
150:
151: USAGE_TYPE VARCHAR2(10) := FND_API.G_MISS_CHAR,
152: DEST_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
153: DEST_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
154: CARRIER_CODE VARCHAR2(25) := FND_API.G_MISS_CHAR,
155: SHIPPING_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
156: SHIPMENT_NUMBER VARCHAR2(60) := FND_API.G_MISS_CHAR,
157: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
158:
151: USAGE_TYPE VARCHAR2(10) := FND_API.G_MISS_CHAR,
152: DEST_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
153: DEST_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
154: CARRIER_CODE VARCHAR2(25) := FND_API.G_MISS_CHAR,
155: SHIPPING_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
156: SHIPMENT_NUMBER VARCHAR2(60) := FND_API.G_MISS_CHAR,
157: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
158:
159: EXPENDITURE_ORG_ID NUMBER := FND_API.G_MISS_NUM,
152: DEST_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
153: DEST_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
154: CARRIER_CODE VARCHAR2(25) := FND_API.G_MISS_CHAR,
155: SHIPPING_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
156: SHIPMENT_NUMBER VARCHAR2(60) := FND_API.G_MISS_CHAR,
157: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
158:
159: EXPENDITURE_ORG_ID NUMBER := FND_API.G_MISS_NUM,
160: PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
153: DEST_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
154: CARRIER_CODE VARCHAR2(25) := FND_API.G_MISS_CHAR,
155: SHIPPING_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
156: SHIPMENT_NUMBER VARCHAR2(60) := FND_API.G_MISS_CHAR,
157: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
158:
159: EXPENDITURE_ORG_ID NUMBER := FND_API.G_MISS_NUM,
160: PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
161: PROJECT_TASK_ID NUMBER := FND_API.G_MISS_NUM
155: SHIPPING_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
156: SHIPMENT_NUMBER VARCHAR2(60) := FND_API.G_MISS_CHAR,
157: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
158:
159: EXPENDITURE_ORG_ID NUMBER := FND_API.G_MISS_NUM,
160: PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
161: PROJECT_TASK_ID NUMBER := FND_API.G_MISS_NUM
162: );
163:
156: SHIPMENT_NUMBER VARCHAR2(60) := FND_API.G_MISS_CHAR,
157: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
158:
159: EXPENDITURE_ORG_ID NUMBER := FND_API.G_MISS_NUM,
160: PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
161: PROJECT_TASK_ID NUMBER := FND_API.G_MISS_NUM
162: );
163:
164: G_MISS_DEBRIEF_LINE_REC DEBRIEF_LINE_Rec_Type;
157: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
158:
159: EXPENDITURE_ORG_ID NUMBER := FND_API.G_MISS_NUM,
160: PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
161: PROJECT_TASK_ID NUMBER := FND_API.G_MISS_NUM
162: );
163:
164: G_MISS_DEBRIEF_LINE_REC DEBRIEF_LINE_Rec_Type;
165: TYPE DEBRIEF_LINE_Tbl_Type IS TABLE OF DEBRIEF_LINE_Rec_Type
189: * @rep:displayname Create Debrief Header and Lines
190: */
191: PROCEDURE Create_DEBRIEF(
192: p_api_version_number IN NUMBER,
193: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
194: p_commit IN VARCHAR2 := FND_API.G_FALSE,
195: p_debrief_rec IN DEBRIEF_Rec_Type := G_MISS_DEBRIEF_REC,
196: p_debrief_line_tbl IN DEBRIEF_LINE_tbl_type ,
197: -- DEFAULT G_MISS_DEBRIEF_LINE_tbl,
190: */
191: PROCEDURE Create_DEBRIEF(
192: p_api_version_number IN NUMBER,
193: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
194: p_commit IN VARCHAR2 := FND_API.G_FALSE,
195: p_debrief_rec IN DEBRIEF_Rec_Type := G_MISS_DEBRIEF_REC,
196: p_debrief_line_tbl IN DEBRIEF_LINE_tbl_type ,
197: -- DEFAULT G_MISS_DEBRIEF_LINE_tbl,
198: x_debrief_header_id OUT NOCOPY NUMBER,
204: -- Bug 12671055.
205: -- shadas - Create_Debrief overloaded procedure added for updating default dff values.
206: PROCEDURE Create_Debrief_With_Dff_Vals(
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 := G_MISS_DEBRIEF_REC,
211: p_debrief_line_tbl IN DEBRIEF_LINE_tbl_type ,
212: -- DEFAULT G_MISS_DEBRIEF_LINE_tbl,
205: -- shadas - Create_Debrief overloaded procedure added for updating default dff values.
206: PROCEDURE Create_Debrief_With_Dff_Vals(
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 := G_MISS_DEBRIEF_REC,
211: p_debrief_line_tbl IN DEBRIEF_LINE_tbl_type ,
212: -- DEFAULT G_MISS_DEBRIEF_LINE_tbl,
213: x_debrief_header_id OUT NOCOPY NUMBER,
231: * @rep:displayname Update a Debrief Header
232: */
233: PROCEDURE Update_debrief(
234: p_api_version_number IN NUMBER,
235: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
236: p_commit IN VARCHAR2 := FND_API.G_FALSE,
237: p_debrief_rec IN DEBRIEF_Rec_Type DEFAULT G_MISS_DEBRIEF_REC,
238: x_return_status OUT NOCOPY VARCHAR2,
239: x_msg_count OUT NOCOPY NUMBER,
232: */
233: PROCEDURE Update_debrief(
234: p_api_version_number IN NUMBER,
235: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
236: p_commit IN VARCHAR2 := FND_API.G_FALSE,
237: p_debrief_rec IN DEBRIEF_Rec_Type DEFAULT G_MISS_DEBRIEF_REC,
238: x_return_status OUT NOCOPY VARCHAR2,
239: x_msg_count OUT NOCOPY NUMBER,
240: x_msg_data OUT NOCOPY VARCHAR2
262: * @rep:displayname Create Debrief Header and Lines
263: */
264: PROCEDURE Create_debrief_lines(
265: p_api_version_number IN NUMBER,
266: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
267: p_commit IN VARCHAR2 := FND_API.G_FALSE,
268: p_upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
269: p_task_assignment_status IN VARCHAR2 DEFAULT NULL,
270: p_debrief_line_tbl IN DEBRIEF_LINE_Tbl_Type := G_MISS_DEBRIEF_LINE_Tbl,
263: */
264: PROCEDURE Create_debrief_lines(
265: p_api_version_number IN NUMBER,
266: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
267: p_commit IN VARCHAR2 := FND_API.G_FALSE,
268: p_upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
269: p_task_assignment_status IN VARCHAR2 DEFAULT NULL,
270: p_debrief_line_tbl IN DEBRIEF_LINE_Tbl_Type := G_MISS_DEBRIEF_LINE_Tbl,
271: p_debrief_header_id IN NUMBER,
294: * @rep:displayname Update Debrief Line
295: */
296: PROCEDURE Update_debrief_line(
297: p_api_version_number IN NUMBER,
298: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
299: p_commit IN VARCHAR2 := FND_API.G_FALSE,
300: p_upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
301: p_task_assignment_status IN VARCHAR2 DEFAULT NULL,
302: p_debrief_line_rec IN DEBRIEF_LINE_Rec_Type,
295: */
296: PROCEDURE Update_debrief_line(
297: p_api_version_number IN NUMBER,
298: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
299: p_commit IN VARCHAR2 := FND_API.G_FALSE,
300: p_upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
301: p_task_assignment_status IN VARCHAR2 DEFAULT NULL,
302: p_debrief_line_rec IN DEBRIEF_LINE_Rec_Type,
303: x_return_status OUT NOCOPY VARCHAR2,