7: -- NOTE :
8: -- End of Comments
9: TYPE internal_user_hooks_rec IS RECORD
10: (
11: DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
12: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
13: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
14: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
15: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
8: -- End of Comments
9: TYPE internal_user_hooks_rec IS RECORD
10: (
11: DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
12: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
13: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
14: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
15: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
16: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
9: TYPE internal_user_hooks_rec IS RECORD
10: (
11: DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
12: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
13: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
14: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
15: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
16: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
17: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
10: (
11: DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
12: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
13: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
14: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
15: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
16: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
17: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
18: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
11: DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
12: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
13: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
14: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
15: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
16: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
17: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
18: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
19: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
12: DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
13: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
14: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
15: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
16: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
17: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
18: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
19: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
20: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
13: DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
14: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
15: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
16: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
17: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
18: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
19: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
20: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
21: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
14: SERVICE_DATE DATE := FND_API.G_MISS_DATE,
15: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
16: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
17: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
18: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
19: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
20: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
21: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
22: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
15: BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
16: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
17: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
18: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
19: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
20: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
21: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
22: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
23: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
16: TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
17: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
18: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
19: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
20: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
21: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
22: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
23: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
24: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
17: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
18: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
19: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
20: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
21: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
22: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
23: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
24: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
25: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
18: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
19: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
20: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
21: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
22: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
23: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
24: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
25: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
26: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
19: ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
20: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
21: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
22: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
23: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
24: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
25: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
26: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
27: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
21: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
22: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
23: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
24: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
25: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
26: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
27: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
21: ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
22: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
23: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
24: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
25: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
26: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
27: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
22: RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
23: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
24: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
25: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
26: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
27: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
30: ITEM_LOTNUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
23: ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
24: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
25: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
26: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
27: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
30: ITEM_LOTNUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
31: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
24: RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
25: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
26: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
27: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
30: ITEM_LOTNUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
31: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
32: QUANTITY NUMBER := FND_API.G_MISS_NUM,
25: PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
26: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
27: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
30: ITEM_LOTNUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
31: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
32: QUANTITY NUMBER := FND_API.G_MISS_NUM,
33: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
26: REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
27: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
30: ITEM_LOTNUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
31: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
32: QUANTITY NUMBER := FND_API.G_MISS_NUM,
33: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
34: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
27: STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
30: ITEM_LOTNUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
31: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
32: QUANTITY NUMBER := FND_API.G_MISS_NUM,
33: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
34: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
35: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
30: ITEM_LOTNUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
31: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
32: QUANTITY NUMBER := FND_API.G_MISS_NUM,
33: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
34: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
35: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
30: ITEM_LOTNUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
31: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
32: QUANTITY NUMBER := FND_API.G_MISS_NUM,
33: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
34: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
35: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
37: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
30: ITEM_LOTNUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
31: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
32: QUANTITY NUMBER := FND_API.G_MISS_NUM,
33: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
34: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
35: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
37: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
38: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
31: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
32: QUANTITY NUMBER := FND_API.G_MISS_NUM,
33: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
34: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
35: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
37: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
38: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
32: QUANTITY NUMBER := FND_API.G_MISS_NUM,
33: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
34: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
35: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
37: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
38: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
40: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
33: -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
34: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
35: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
37: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
38: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
40: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
41: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
34: RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
35: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
37: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
38: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
40: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
41: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
42: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
35: DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
37: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
38: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
40: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
41: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
42: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
43: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
36: MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
37: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
38: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
40: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
41: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
42: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
43: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
44: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
37: LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
38: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
40: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
41: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
42: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
43: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
44: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
45: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
38: EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
40: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
41: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
42: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
43: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
44: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
45: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
46: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
40: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
41: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
42: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
43: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
44: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
45: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
46: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
47: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
40: LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
41: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
42: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
43: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
44: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
45: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
46: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
47: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
41: STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
42: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
43: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
44: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
45: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
46: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
47: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
43: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
44: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
45: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
46: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
47: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
44: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
45: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
46: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
47: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
44: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
45: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
46: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
47: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
46: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
47: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
53: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
46: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
47: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
53: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
47: CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
53: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
53: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
56: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
49: CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
53: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
56: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
50: IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
53: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
56: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: CREATION_DATE DATE := FND_API.G_MISS_DATE,
51: IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
53: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
56: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: CREATION_DATE DATE := FND_API.G_MISS_DATE,
59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
52: IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
53: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
56: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: CREATION_DATE DATE := FND_API.G_MISS_DATE,
59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
53: SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
56: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: CREATION_DATE DATE := FND_API.G_MISS_DATE,
59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
54: SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
56: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: CREATION_DATE DATE := FND_API.G_MISS_DATE,
59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
56: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: CREATION_DATE DATE := FND_API.G_MISS_DATE,
59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: CREATION_DATE DATE := FND_API.G_MISS_DATE,
59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: CREATION_DATE DATE := FND_API.G_MISS_DATE,
59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: CREATION_DATE DATE := FND_API.G_MISS_DATE,
59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
72: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
80: RETURN_DATE DATE := FND_API.G_MISS_DATE
73: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
80: RETURN_DATE DATE := FND_API.G_MISS_DATE
81:
74: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
80: RETURN_DATE DATE := FND_API.G_MISS_DATE
81:
82: );
75: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
80: RETURN_DATE DATE := FND_API.G_MISS_DATE
81:
82: );
83: user_hooks_rec CSF_DEBRIEF_LINES_PKG.internal_user_hooks_rec ;
76: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
80: RETURN_DATE DATE := FND_API.G_MISS_DATE
81:
82: );
83: user_hooks_rec CSF_DEBRIEF_LINES_PKG.internal_user_hooks_rec ;
84: PROCEDURE Insert_Row(
154: );
155:
156: PROCEDURE Update_Row(
157: p_DEBRIEF_LINE_ID NUMBER,
158: p_DEBRIEF_HEADER_ID NUMBER default fnd_api.g_miss_num,
159: p_DEBRIEF_LINE_NUMBER NUMBER default fnd_api.g_miss_num,
160: p_SERVICE_DATE DATE default fnd_api.g_miss_date,
161: p_BUSINESS_PROCESS_ID NUMBER default fnd_api.g_miss_num,
162: p_TXN_BILLING_TYPE_ID NUMBER default fnd_api.g_miss_num,
155:
156: PROCEDURE Update_Row(
157: p_DEBRIEF_LINE_ID NUMBER,
158: p_DEBRIEF_HEADER_ID NUMBER default fnd_api.g_miss_num,
159: p_DEBRIEF_LINE_NUMBER NUMBER default fnd_api.g_miss_num,
160: p_SERVICE_DATE DATE default fnd_api.g_miss_date,
161: p_BUSINESS_PROCESS_ID NUMBER default fnd_api.g_miss_num,
162: p_TXN_BILLING_TYPE_ID NUMBER default fnd_api.g_miss_num,
163: p_INVENTORY_ITEM_ID NUMBER default fnd_api.g_miss_num,
156: PROCEDURE Update_Row(
157: p_DEBRIEF_LINE_ID NUMBER,
158: p_DEBRIEF_HEADER_ID NUMBER default fnd_api.g_miss_num,
159: p_DEBRIEF_LINE_NUMBER NUMBER default fnd_api.g_miss_num,
160: p_SERVICE_DATE DATE default fnd_api.g_miss_date,
161: p_BUSINESS_PROCESS_ID NUMBER default fnd_api.g_miss_num,
162: p_TXN_BILLING_TYPE_ID NUMBER default fnd_api.g_miss_num,
163: p_INVENTORY_ITEM_ID NUMBER default fnd_api.g_miss_num,
164: p_INSTANCE_ID NUMBER default fnd_api.g_miss_num,
157: p_DEBRIEF_LINE_ID NUMBER,
158: p_DEBRIEF_HEADER_ID NUMBER default fnd_api.g_miss_num,
159: p_DEBRIEF_LINE_NUMBER NUMBER default fnd_api.g_miss_num,
160: p_SERVICE_DATE DATE default fnd_api.g_miss_date,
161: p_BUSINESS_PROCESS_ID NUMBER default fnd_api.g_miss_num,
162: p_TXN_BILLING_TYPE_ID NUMBER default fnd_api.g_miss_num,
163: p_INVENTORY_ITEM_ID NUMBER default fnd_api.g_miss_num,
164: p_INSTANCE_ID NUMBER default fnd_api.g_miss_num,
165: p_ISSUING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
158: p_DEBRIEF_HEADER_ID NUMBER default fnd_api.g_miss_num,
159: p_DEBRIEF_LINE_NUMBER NUMBER default fnd_api.g_miss_num,
160: p_SERVICE_DATE DATE default fnd_api.g_miss_date,
161: p_BUSINESS_PROCESS_ID NUMBER default fnd_api.g_miss_num,
162: p_TXN_BILLING_TYPE_ID NUMBER default fnd_api.g_miss_num,
163: p_INVENTORY_ITEM_ID NUMBER default fnd_api.g_miss_num,
164: p_INSTANCE_ID NUMBER default fnd_api.g_miss_num,
165: p_ISSUING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
166: p_RECEIVING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
159: p_DEBRIEF_LINE_NUMBER NUMBER default fnd_api.g_miss_num,
160: p_SERVICE_DATE DATE default fnd_api.g_miss_date,
161: p_BUSINESS_PROCESS_ID NUMBER default fnd_api.g_miss_num,
162: p_TXN_BILLING_TYPE_ID NUMBER default fnd_api.g_miss_num,
163: p_INVENTORY_ITEM_ID NUMBER default fnd_api.g_miss_num,
164: p_INSTANCE_ID NUMBER default fnd_api.g_miss_num,
165: p_ISSUING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
166: p_RECEIVING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
167: p_ISSUING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
160: p_SERVICE_DATE DATE default fnd_api.g_miss_date,
161: p_BUSINESS_PROCESS_ID NUMBER default fnd_api.g_miss_num,
162: p_TXN_BILLING_TYPE_ID NUMBER default fnd_api.g_miss_num,
163: p_INVENTORY_ITEM_ID NUMBER default fnd_api.g_miss_num,
164: p_INSTANCE_ID NUMBER default fnd_api.g_miss_num,
165: p_ISSUING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
166: p_RECEIVING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
167: p_ISSUING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
168: p_RECEIVING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
161: p_BUSINESS_PROCESS_ID NUMBER default fnd_api.g_miss_num,
162: p_TXN_BILLING_TYPE_ID NUMBER default fnd_api.g_miss_num,
163: p_INVENTORY_ITEM_ID NUMBER default fnd_api.g_miss_num,
164: p_INSTANCE_ID NUMBER default fnd_api.g_miss_num,
165: p_ISSUING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
166: p_RECEIVING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
167: p_ISSUING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
168: p_RECEIVING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
169: p_ISSUING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
162: p_TXN_BILLING_TYPE_ID NUMBER default fnd_api.g_miss_num,
163: p_INVENTORY_ITEM_ID NUMBER default fnd_api.g_miss_num,
164: p_INSTANCE_ID NUMBER default fnd_api.g_miss_num,
165: p_ISSUING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
166: p_RECEIVING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
167: p_ISSUING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
168: p_RECEIVING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
169: p_ISSUING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
170: p_RECEIVING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
163: p_INVENTORY_ITEM_ID NUMBER default fnd_api.g_miss_num,
164: p_INSTANCE_ID NUMBER default fnd_api.g_miss_num,
165: p_ISSUING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
166: p_RECEIVING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
167: p_ISSUING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
168: p_RECEIVING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
169: p_ISSUING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
170: p_RECEIVING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
171: p_PARENT_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
164: p_INSTANCE_ID NUMBER default fnd_api.g_miss_num,
165: p_ISSUING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
166: p_RECEIVING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
167: p_ISSUING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
168: p_RECEIVING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
169: p_ISSUING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
170: p_RECEIVING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
171: p_PARENT_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
172: p_REMOVED_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
165: p_ISSUING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
166: p_RECEIVING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
167: p_ISSUING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
168: p_RECEIVING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
169: p_ISSUING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
170: p_RECEIVING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
171: p_PARENT_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
172: p_REMOVED_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
173: p_STATUS_OF_RECEIVED_PART VARCHAR2 default fnd_api.g_miss_char,
166: p_RECEIVING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
167: p_ISSUING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
168: p_RECEIVING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
169: p_ISSUING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
170: p_RECEIVING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
171: p_PARENT_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
172: p_REMOVED_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
173: p_STATUS_OF_RECEIVED_PART VARCHAR2 default fnd_api.g_miss_char,
174: p_ITEM_SERIAL_NUMBER VARCHAR2 default fnd_api.g_miss_char,
167: p_ISSUING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
168: p_RECEIVING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
169: p_ISSUING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
170: p_RECEIVING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
171: p_PARENT_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
172: p_REMOVED_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
173: p_STATUS_OF_RECEIVED_PART VARCHAR2 default fnd_api.g_miss_char,
174: p_ITEM_SERIAL_NUMBER VARCHAR2 default fnd_api.g_miss_char,
175: p_ITEM_REVISION VARCHAR2 default fnd_api.g_miss_char,
168: p_RECEIVING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
169: p_ISSUING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
170: p_RECEIVING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
171: p_PARENT_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
172: p_REMOVED_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
173: p_STATUS_OF_RECEIVED_PART VARCHAR2 default fnd_api.g_miss_char,
174: p_ITEM_SERIAL_NUMBER VARCHAR2 default fnd_api.g_miss_char,
175: p_ITEM_REVISION VARCHAR2 default fnd_api.g_miss_char,
176: p_ITEM_LOTNUMBER VARCHAR2 default fnd_api.g_miss_char,
169: p_ISSUING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
170: p_RECEIVING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
171: p_PARENT_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
172: p_REMOVED_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
173: p_STATUS_OF_RECEIVED_PART VARCHAR2 default fnd_api.g_miss_char,
174: p_ITEM_SERIAL_NUMBER VARCHAR2 default fnd_api.g_miss_char,
175: p_ITEM_REVISION VARCHAR2 default fnd_api.g_miss_char,
176: p_ITEM_LOTNUMBER VARCHAR2 default fnd_api.g_miss_char,
177: p_UOM_CODE VARCHAR2 default fnd_api.g_miss_char,
170: p_RECEIVING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
171: p_PARENT_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
172: p_REMOVED_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
173: p_STATUS_OF_RECEIVED_PART VARCHAR2 default fnd_api.g_miss_char,
174: p_ITEM_SERIAL_NUMBER VARCHAR2 default fnd_api.g_miss_char,
175: p_ITEM_REVISION VARCHAR2 default fnd_api.g_miss_char,
176: p_ITEM_LOTNUMBER VARCHAR2 default fnd_api.g_miss_char,
177: p_UOM_CODE VARCHAR2 default fnd_api.g_miss_char,
178: p_QUANTITY NUMBER default fnd_api.g_miss_num,
171: p_PARENT_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
172: p_REMOVED_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
173: p_STATUS_OF_RECEIVED_PART VARCHAR2 default fnd_api.g_miss_char,
174: p_ITEM_SERIAL_NUMBER VARCHAR2 default fnd_api.g_miss_char,
175: p_ITEM_REVISION VARCHAR2 default fnd_api.g_miss_char,
176: p_ITEM_LOTNUMBER VARCHAR2 default fnd_api.g_miss_char,
177: p_UOM_CODE VARCHAR2 default fnd_api.g_miss_char,
178: p_QUANTITY NUMBER default fnd_api.g_miss_num,
179: p_RMA_HEADER_ID NUMBER default fnd_api.g_miss_num,
172: p_REMOVED_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
173: p_STATUS_OF_RECEIVED_PART VARCHAR2 default fnd_api.g_miss_char,
174: p_ITEM_SERIAL_NUMBER VARCHAR2 default fnd_api.g_miss_char,
175: p_ITEM_REVISION VARCHAR2 default fnd_api.g_miss_char,
176: p_ITEM_LOTNUMBER VARCHAR2 default fnd_api.g_miss_char,
177: p_UOM_CODE VARCHAR2 default fnd_api.g_miss_char,
178: p_QUANTITY NUMBER default fnd_api.g_miss_num,
179: p_RMA_HEADER_ID NUMBER default fnd_api.g_miss_num,
180: p_DISPOSITION_CODE VARCHAR2 default fnd_api.g_miss_char,
173: p_STATUS_OF_RECEIVED_PART VARCHAR2 default fnd_api.g_miss_char,
174: p_ITEM_SERIAL_NUMBER VARCHAR2 default fnd_api.g_miss_char,
175: p_ITEM_REVISION VARCHAR2 default fnd_api.g_miss_char,
176: p_ITEM_LOTNUMBER VARCHAR2 default fnd_api.g_miss_char,
177: p_UOM_CODE VARCHAR2 default fnd_api.g_miss_char,
178: p_QUANTITY NUMBER default fnd_api.g_miss_num,
179: p_RMA_HEADER_ID NUMBER default fnd_api.g_miss_num,
180: p_DISPOSITION_CODE VARCHAR2 default fnd_api.g_miss_char,
181: p_MATERIAL_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
174: p_ITEM_SERIAL_NUMBER VARCHAR2 default fnd_api.g_miss_char,
175: p_ITEM_REVISION VARCHAR2 default fnd_api.g_miss_char,
176: p_ITEM_LOTNUMBER VARCHAR2 default fnd_api.g_miss_char,
177: p_UOM_CODE VARCHAR2 default fnd_api.g_miss_char,
178: p_QUANTITY NUMBER default fnd_api.g_miss_num,
179: p_RMA_HEADER_ID NUMBER default fnd_api.g_miss_num,
180: p_DISPOSITION_CODE VARCHAR2 default fnd_api.g_miss_char,
181: p_MATERIAL_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
182: p_LABOR_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
175: p_ITEM_REVISION VARCHAR2 default fnd_api.g_miss_char,
176: p_ITEM_LOTNUMBER VARCHAR2 default fnd_api.g_miss_char,
177: p_UOM_CODE VARCHAR2 default fnd_api.g_miss_char,
178: p_QUANTITY NUMBER default fnd_api.g_miss_num,
179: p_RMA_HEADER_ID NUMBER default fnd_api.g_miss_num,
180: p_DISPOSITION_CODE VARCHAR2 default fnd_api.g_miss_char,
181: p_MATERIAL_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
182: p_LABOR_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
183: p_EXPENSE_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
176: p_ITEM_LOTNUMBER VARCHAR2 default fnd_api.g_miss_char,
177: p_UOM_CODE VARCHAR2 default fnd_api.g_miss_char,
178: p_QUANTITY NUMBER default fnd_api.g_miss_num,
179: p_RMA_HEADER_ID NUMBER default fnd_api.g_miss_num,
180: p_DISPOSITION_CODE VARCHAR2 default fnd_api.g_miss_char,
181: p_MATERIAL_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
182: p_LABOR_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
183: p_EXPENSE_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
184: p_LABOR_START_DATE DATE default fnd_api.g_miss_date,
177: p_UOM_CODE VARCHAR2 default fnd_api.g_miss_char,
178: p_QUANTITY NUMBER default fnd_api.g_miss_num,
179: p_RMA_HEADER_ID NUMBER default fnd_api.g_miss_num,
180: p_DISPOSITION_CODE VARCHAR2 default fnd_api.g_miss_char,
181: p_MATERIAL_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
182: p_LABOR_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
183: p_EXPENSE_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
184: p_LABOR_START_DATE DATE default fnd_api.g_miss_date,
185: p_LABOR_END_DATE DATE default fnd_api.g_miss_date,
178: p_QUANTITY NUMBER default fnd_api.g_miss_num,
179: p_RMA_HEADER_ID NUMBER default fnd_api.g_miss_num,
180: p_DISPOSITION_CODE VARCHAR2 default fnd_api.g_miss_char,
181: p_MATERIAL_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
182: p_LABOR_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
183: p_EXPENSE_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
184: p_LABOR_START_DATE DATE default fnd_api.g_miss_date,
185: p_LABOR_END_DATE DATE default fnd_api.g_miss_date,
186: p_STARTING_MILEAGE NUMBER default fnd_api.g_miss_num,
179: p_RMA_HEADER_ID NUMBER default fnd_api.g_miss_num,
180: p_DISPOSITION_CODE VARCHAR2 default fnd_api.g_miss_char,
181: p_MATERIAL_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
182: p_LABOR_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
183: p_EXPENSE_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
184: p_LABOR_START_DATE DATE default fnd_api.g_miss_date,
185: p_LABOR_END_DATE DATE default fnd_api.g_miss_date,
186: p_STARTING_MILEAGE NUMBER default fnd_api.g_miss_num,
187: p_ENDING_MILEAGE NUMBER default fnd_api.g_miss_num,
180: p_DISPOSITION_CODE VARCHAR2 default fnd_api.g_miss_char,
181: p_MATERIAL_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
182: p_LABOR_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
183: p_EXPENSE_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
184: p_LABOR_START_DATE DATE default fnd_api.g_miss_date,
185: p_LABOR_END_DATE DATE default fnd_api.g_miss_date,
186: p_STARTING_MILEAGE NUMBER default fnd_api.g_miss_num,
187: p_ENDING_MILEAGE NUMBER default fnd_api.g_miss_num,
188: p_EXPENSE_AMOUNT NUMBER default fnd_api.g_miss_num,
181: p_MATERIAL_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
182: p_LABOR_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
183: p_EXPENSE_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
184: p_LABOR_START_DATE DATE default fnd_api.g_miss_date,
185: p_LABOR_END_DATE DATE default fnd_api.g_miss_date,
186: p_STARTING_MILEAGE NUMBER default fnd_api.g_miss_num,
187: p_ENDING_MILEAGE NUMBER default fnd_api.g_miss_num,
188: p_EXPENSE_AMOUNT NUMBER default fnd_api.g_miss_num,
189: p_CURRENCY_CODE VARCHAR2 default fnd_api.g_miss_char,
182: p_LABOR_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
183: p_EXPENSE_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
184: p_LABOR_START_DATE DATE default fnd_api.g_miss_date,
185: p_LABOR_END_DATE DATE default fnd_api.g_miss_date,
186: p_STARTING_MILEAGE NUMBER default fnd_api.g_miss_num,
187: p_ENDING_MILEAGE NUMBER default fnd_api.g_miss_num,
188: p_EXPENSE_AMOUNT NUMBER default fnd_api.g_miss_num,
189: p_CURRENCY_CODE VARCHAR2 default fnd_api.g_miss_char,
190: p_DEBRIEF_LINE_STATUS_ID NUMBER default fnd_api.g_miss_num,
183: p_EXPENSE_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
184: p_LABOR_START_DATE DATE default fnd_api.g_miss_date,
185: p_LABOR_END_DATE DATE default fnd_api.g_miss_date,
186: p_STARTING_MILEAGE NUMBER default fnd_api.g_miss_num,
187: p_ENDING_MILEAGE NUMBER default fnd_api.g_miss_num,
188: p_EXPENSE_AMOUNT NUMBER default fnd_api.g_miss_num,
189: p_CURRENCY_CODE VARCHAR2 default fnd_api.g_miss_char,
190: p_DEBRIEF_LINE_STATUS_ID NUMBER default fnd_api.g_miss_num,
191: p_RETURN_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
184: p_LABOR_START_DATE DATE default fnd_api.g_miss_date,
185: p_LABOR_END_DATE DATE default fnd_api.g_miss_date,
186: p_STARTING_MILEAGE NUMBER default fnd_api.g_miss_num,
187: p_ENDING_MILEAGE NUMBER default fnd_api.g_miss_num,
188: p_EXPENSE_AMOUNT NUMBER default fnd_api.g_miss_num,
189: p_CURRENCY_CODE VARCHAR2 default fnd_api.g_miss_char,
190: p_DEBRIEF_LINE_STATUS_ID NUMBER default fnd_api.g_miss_num,
191: p_RETURN_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
192: p_CHANNEL_CODE VARCHAR2 default fnd_api.g_miss_char,
185: p_LABOR_END_DATE DATE default fnd_api.g_miss_date,
186: p_STARTING_MILEAGE NUMBER default fnd_api.g_miss_num,
187: p_ENDING_MILEAGE NUMBER default fnd_api.g_miss_num,
188: p_EXPENSE_AMOUNT NUMBER default fnd_api.g_miss_num,
189: p_CURRENCY_CODE VARCHAR2 default fnd_api.g_miss_char,
190: p_DEBRIEF_LINE_STATUS_ID NUMBER default fnd_api.g_miss_num,
191: p_RETURN_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
192: p_CHANNEL_CODE VARCHAR2 default fnd_api.g_miss_char,
193: p_CHARGE_UPLOAD_STATUS VARCHAR2 default fnd_api.g_miss_char,
186: p_STARTING_MILEAGE NUMBER default fnd_api.g_miss_num,
187: p_ENDING_MILEAGE NUMBER default fnd_api.g_miss_num,
188: p_EXPENSE_AMOUNT NUMBER default fnd_api.g_miss_num,
189: p_CURRENCY_CODE VARCHAR2 default fnd_api.g_miss_char,
190: p_DEBRIEF_LINE_STATUS_ID NUMBER default fnd_api.g_miss_num,
191: p_RETURN_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
192: p_CHANNEL_CODE VARCHAR2 default fnd_api.g_miss_char,
193: p_CHARGE_UPLOAD_STATUS VARCHAR2 default fnd_api.g_miss_char,
194: p_CHARGE_UPLOAD_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
187: p_ENDING_MILEAGE NUMBER default fnd_api.g_miss_num,
188: p_EXPENSE_AMOUNT NUMBER default fnd_api.g_miss_num,
189: p_CURRENCY_CODE VARCHAR2 default fnd_api.g_miss_char,
190: p_DEBRIEF_LINE_STATUS_ID NUMBER default fnd_api.g_miss_num,
191: p_RETURN_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
192: p_CHANNEL_CODE VARCHAR2 default fnd_api.g_miss_char,
193: p_CHARGE_UPLOAD_STATUS VARCHAR2 default fnd_api.g_miss_char,
194: p_CHARGE_UPLOAD_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
195: p_CHARGE_UPLOAD_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
188: p_EXPENSE_AMOUNT NUMBER default fnd_api.g_miss_num,
189: p_CURRENCY_CODE VARCHAR2 default fnd_api.g_miss_char,
190: p_DEBRIEF_LINE_STATUS_ID NUMBER default fnd_api.g_miss_num,
191: p_RETURN_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
192: p_CHANNEL_CODE VARCHAR2 default fnd_api.g_miss_char,
193: p_CHARGE_UPLOAD_STATUS VARCHAR2 default fnd_api.g_miss_char,
194: p_CHARGE_UPLOAD_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
195: p_CHARGE_UPLOAD_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
196: p_IB_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
189: p_CURRENCY_CODE VARCHAR2 default fnd_api.g_miss_char,
190: p_DEBRIEF_LINE_STATUS_ID NUMBER default fnd_api.g_miss_num,
191: p_RETURN_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
192: p_CHANNEL_CODE VARCHAR2 default fnd_api.g_miss_char,
193: p_CHARGE_UPLOAD_STATUS VARCHAR2 default fnd_api.g_miss_char,
194: p_CHARGE_UPLOAD_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
195: p_CHARGE_UPLOAD_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
196: p_IB_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
197: p_IB_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
190: p_DEBRIEF_LINE_STATUS_ID NUMBER default fnd_api.g_miss_num,
191: p_RETURN_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
192: p_CHANNEL_CODE VARCHAR2 default fnd_api.g_miss_char,
193: p_CHARGE_UPLOAD_STATUS VARCHAR2 default fnd_api.g_miss_char,
194: p_CHARGE_UPLOAD_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
195: p_CHARGE_UPLOAD_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
196: p_IB_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
197: p_IB_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
198: p_IB_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
191: p_RETURN_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
192: p_CHANNEL_CODE VARCHAR2 default fnd_api.g_miss_char,
193: p_CHARGE_UPLOAD_STATUS VARCHAR2 default fnd_api.g_miss_char,
194: p_CHARGE_UPLOAD_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
195: p_CHARGE_UPLOAD_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
196: p_IB_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
197: p_IB_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
198: p_IB_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
199: p_SPARE_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
192: p_CHANNEL_CODE VARCHAR2 default fnd_api.g_miss_char,
193: p_CHARGE_UPLOAD_STATUS VARCHAR2 default fnd_api.g_miss_char,
194: p_CHARGE_UPLOAD_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
195: p_CHARGE_UPLOAD_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
196: p_IB_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
197: p_IB_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
198: p_IB_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
199: p_SPARE_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
200: p_SPARE_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
193: p_CHARGE_UPLOAD_STATUS VARCHAR2 default fnd_api.g_miss_char,
194: p_CHARGE_UPLOAD_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
195: p_CHARGE_UPLOAD_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
196: p_IB_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
197: p_IB_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
198: p_IB_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
199: p_SPARE_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
200: p_SPARE_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
201: p_SPARE_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
194: p_CHARGE_UPLOAD_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
195: p_CHARGE_UPLOAD_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
196: p_IB_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
197: p_IB_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
198: p_IB_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
199: p_SPARE_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
200: p_SPARE_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
201: p_SPARE_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
202: p_error_text VARCHAR2 default fnd_api.g_miss_char,
195: p_CHARGE_UPLOAD_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
196: p_IB_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
197: p_IB_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
198: p_IB_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
199: p_SPARE_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
200: p_SPARE_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
201: p_SPARE_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
202: p_error_text VARCHAR2 default fnd_api.g_miss_char,
203: p_CREATED_BY NUMBER default fnd_api.g_miss_num,
196: p_IB_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
197: p_IB_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
198: p_IB_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
199: p_SPARE_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
200: p_SPARE_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
201: p_SPARE_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
202: p_error_text VARCHAR2 default fnd_api.g_miss_char,
203: p_CREATED_BY NUMBER default fnd_api.g_miss_num,
204: p_CREATION_DATE DATE default fnd_api.g_miss_date,
197: p_IB_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
198: p_IB_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
199: p_SPARE_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
200: p_SPARE_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
201: p_SPARE_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
202: p_error_text VARCHAR2 default fnd_api.g_miss_char,
203: p_CREATED_BY NUMBER default fnd_api.g_miss_num,
204: p_CREATION_DATE DATE default fnd_api.g_miss_date,
205: p_LAST_UPDATED_BY NUMBER default fnd_api.g_miss_num,
198: p_IB_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
199: p_SPARE_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
200: p_SPARE_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
201: p_SPARE_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
202: p_error_text VARCHAR2 default fnd_api.g_miss_char,
203: p_CREATED_BY NUMBER default fnd_api.g_miss_num,
204: p_CREATION_DATE DATE default fnd_api.g_miss_date,
205: p_LAST_UPDATED_BY NUMBER default fnd_api.g_miss_num,
206: p_LAST_UPDATE_DATE DATE default fnd_api.g_miss_date,
199: p_SPARE_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
200: p_SPARE_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
201: p_SPARE_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
202: p_error_text VARCHAR2 default fnd_api.g_miss_char,
203: p_CREATED_BY NUMBER default fnd_api.g_miss_num,
204: p_CREATION_DATE DATE default fnd_api.g_miss_date,
205: p_LAST_UPDATED_BY NUMBER default fnd_api.g_miss_num,
206: p_LAST_UPDATE_DATE DATE default fnd_api.g_miss_date,
207: p_LAST_UPDATE_LOGIN NUMBER default fnd_api.g_miss_num,
200: p_SPARE_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
201: p_SPARE_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
202: p_error_text VARCHAR2 default fnd_api.g_miss_char,
203: p_CREATED_BY NUMBER default fnd_api.g_miss_num,
204: p_CREATION_DATE DATE default fnd_api.g_miss_date,
205: p_LAST_UPDATED_BY NUMBER default fnd_api.g_miss_num,
206: p_LAST_UPDATE_DATE DATE default fnd_api.g_miss_date,
207: p_LAST_UPDATE_LOGIN NUMBER default fnd_api.g_miss_num,
208: p_ATTRIBUTE1 VARCHAR2 default fnd_api.g_miss_char,
201: p_SPARE_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
202: p_error_text VARCHAR2 default fnd_api.g_miss_char,
203: p_CREATED_BY NUMBER default fnd_api.g_miss_num,
204: p_CREATION_DATE DATE default fnd_api.g_miss_date,
205: p_LAST_UPDATED_BY NUMBER default fnd_api.g_miss_num,
206: p_LAST_UPDATE_DATE DATE default fnd_api.g_miss_date,
207: p_LAST_UPDATE_LOGIN NUMBER default fnd_api.g_miss_num,
208: p_ATTRIBUTE1 VARCHAR2 default fnd_api.g_miss_char,
209: p_ATTRIBUTE2 VARCHAR2 default fnd_api.g_miss_char,
202: p_error_text VARCHAR2 default fnd_api.g_miss_char,
203: p_CREATED_BY NUMBER default fnd_api.g_miss_num,
204: p_CREATION_DATE DATE default fnd_api.g_miss_date,
205: p_LAST_UPDATED_BY NUMBER default fnd_api.g_miss_num,
206: p_LAST_UPDATE_DATE DATE default fnd_api.g_miss_date,
207: p_LAST_UPDATE_LOGIN NUMBER default fnd_api.g_miss_num,
208: p_ATTRIBUTE1 VARCHAR2 default fnd_api.g_miss_char,
209: p_ATTRIBUTE2 VARCHAR2 default fnd_api.g_miss_char,
210: p_ATTRIBUTE3 VARCHAR2 default fnd_api.g_miss_char,
203: p_CREATED_BY NUMBER default fnd_api.g_miss_num,
204: p_CREATION_DATE DATE default fnd_api.g_miss_date,
205: p_LAST_UPDATED_BY NUMBER default fnd_api.g_miss_num,
206: p_LAST_UPDATE_DATE DATE default fnd_api.g_miss_date,
207: p_LAST_UPDATE_LOGIN NUMBER default fnd_api.g_miss_num,
208: p_ATTRIBUTE1 VARCHAR2 default fnd_api.g_miss_char,
209: p_ATTRIBUTE2 VARCHAR2 default fnd_api.g_miss_char,
210: p_ATTRIBUTE3 VARCHAR2 default fnd_api.g_miss_char,
211: p_ATTRIBUTE4 VARCHAR2 default fnd_api.g_miss_char,
204: p_CREATION_DATE DATE default fnd_api.g_miss_date,
205: p_LAST_UPDATED_BY NUMBER default fnd_api.g_miss_num,
206: p_LAST_UPDATE_DATE DATE default fnd_api.g_miss_date,
207: p_LAST_UPDATE_LOGIN NUMBER default fnd_api.g_miss_num,
208: p_ATTRIBUTE1 VARCHAR2 default fnd_api.g_miss_char,
209: p_ATTRIBUTE2 VARCHAR2 default fnd_api.g_miss_char,
210: p_ATTRIBUTE3 VARCHAR2 default fnd_api.g_miss_char,
211: p_ATTRIBUTE4 VARCHAR2 default fnd_api.g_miss_char,
212: p_ATTRIBUTE5 VARCHAR2 default fnd_api.g_miss_char,
205: p_LAST_UPDATED_BY NUMBER default fnd_api.g_miss_num,
206: p_LAST_UPDATE_DATE DATE default fnd_api.g_miss_date,
207: p_LAST_UPDATE_LOGIN NUMBER default fnd_api.g_miss_num,
208: p_ATTRIBUTE1 VARCHAR2 default fnd_api.g_miss_char,
209: p_ATTRIBUTE2 VARCHAR2 default fnd_api.g_miss_char,
210: p_ATTRIBUTE3 VARCHAR2 default fnd_api.g_miss_char,
211: p_ATTRIBUTE4 VARCHAR2 default fnd_api.g_miss_char,
212: p_ATTRIBUTE5 VARCHAR2 default fnd_api.g_miss_char,
213: p_ATTRIBUTE6 VARCHAR2 default fnd_api.g_miss_char,
206: p_LAST_UPDATE_DATE DATE default fnd_api.g_miss_date,
207: p_LAST_UPDATE_LOGIN NUMBER default fnd_api.g_miss_num,
208: p_ATTRIBUTE1 VARCHAR2 default fnd_api.g_miss_char,
209: p_ATTRIBUTE2 VARCHAR2 default fnd_api.g_miss_char,
210: p_ATTRIBUTE3 VARCHAR2 default fnd_api.g_miss_char,
211: p_ATTRIBUTE4 VARCHAR2 default fnd_api.g_miss_char,
212: p_ATTRIBUTE5 VARCHAR2 default fnd_api.g_miss_char,
213: p_ATTRIBUTE6 VARCHAR2 default fnd_api.g_miss_char,
214: p_ATTRIBUTE7 VARCHAR2 default fnd_api.g_miss_char,
207: p_LAST_UPDATE_LOGIN NUMBER default fnd_api.g_miss_num,
208: p_ATTRIBUTE1 VARCHAR2 default fnd_api.g_miss_char,
209: p_ATTRIBUTE2 VARCHAR2 default fnd_api.g_miss_char,
210: p_ATTRIBUTE3 VARCHAR2 default fnd_api.g_miss_char,
211: p_ATTRIBUTE4 VARCHAR2 default fnd_api.g_miss_char,
212: p_ATTRIBUTE5 VARCHAR2 default fnd_api.g_miss_char,
213: p_ATTRIBUTE6 VARCHAR2 default fnd_api.g_miss_char,
214: p_ATTRIBUTE7 VARCHAR2 default fnd_api.g_miss_char,
215: p_ATTRIBUTE8 VARCHAR2 default fnd_api.g_miss_char,
208: p_ATTRIBUTE1 VARCHAR2 default fnd_api.g_miss_char,
209: p_ATTRIBUTE2 VARCHAR2 default fnd_api.g_miss_char,
210: p_ATTRIBUTE3 VARCHAR2 default fnd_api.g_miss_char,
211: p_ATTRIBUTE4 VARCHAR2 default fnd_api.g_miss_char,
212: p_ATTRIBUTE5 VARCHAR2 default fnd_api.g_miss_char,
213: p_ATTRIBUTE6 VARCHAR2 default fnd_api.g_miss_char,
214: p_ATTRIBUTE7 VARCHAR2 default fnd_api.g_miss_char,
215: p_ATTRIBUTE8 VARCHAR2 default fnd_api.g_miss_char,
216: p_ATTRIBUTE9 VARCHAR2 default fnd_api.g_miss_char,
209: p_ATTRIBUTE2 VARCHAR2 default fnd_api.g_miss_char,
210: p_ATTRIBUTE3 VARCHAR2 default fnd_api.g_miss_char,
211: p_ATTRIBUTE4 VARCHAR2 default fnd_api.g_miss_char,
212: p_ATTRIBUTE5 VARCHAR2 default fnd_api.g_miss_char,
213: p_ATTRIBUTE6 VARCHAR2 default fnd_api.g_miss_char,
214: p_ATTRIBUTE7 VARCHAR2 default fnd_api.g_miss_char,
215: p_ATTRIBUTE8 VARCHAR2 default fnd_api.g_miss_char,
216: p_ATTRIBUTE9 VARCHAR2 default fnd_api.g_miss_char,
217: p_ATTRIBUTE10 VARCHAR2 default fnd_api.g_miss_char,
210: p_ATTRIBUTE3 VARCHAR2 default fnd_api.g_miss_char,
211: p_ATTRIBUTE4 VARCHAR2 default fnd_api.g_miss_char,
212: p_ATTRIBUTE5 VARCHAR2 default fnd_api.g_miss_char,
213: p_ATTRIBUTE6 VARCHAR2 default fnd_api.g_miss_char,
214: p_ATTRIBUTE7 VARCHAR2 default fnd_api.g_miss_char,
215: p_ATTRIBUTE8 VARCHAR2 default fnd_api.g_miss_char,
216: p_ATTRIBUTE9 VARCHAR2 default fnd_api.g_miss_char,
217: p_ATTRIBUTE10 VARCHAR2 default fnd_api.g_miss_char,
218: p_ATTRIBUTE11 VARCHAR2 default fnd_api.g_miss_char,
211: p_ATTRIBUTE4 VARCHAR2 default fnd_api.g_miss_char,
212: p_ATTRIBUTE5 VARCHAR2 default fnd_api.g_miss_char,
213: p_ATTRIBUTE6 VARCHAR2 default fnd_api.g_miss_char,
214: p_ATTRIBUTE7 VARCHAR2 default fnd_api.g_miss_char,
215: p_ATTRIBUTE8 VARCHAR2 default fnd_api.g_miss_char,
216: p_ATTRIBUTE9 VARCHAR2 default fnd_api.g_miss_char,
217: p_ATTRIBUTE10 VARCHAR2 default fnd_api.g_miss_char,
218: p_ATTRIBUTE11 VARCHAR2 default fnd_api.g_miss_char,
219: p_ATTRIBUTE12 VARCHAR2 default fnd_api.g_miss_char,
212: p_ATTRIBUTE5 VARCHAR2 default fnd_api.g_miss_char,
213: p_ATTRIBUTE6 VARCHAR2 default fnd_api.g_miss_char,
214: p_ATTRIBUTE7 VARCHAR2 default fnd_api.g_miss_char,
215: p_ATTRIBUTE8 VARCHAR2 default fnd_api.g_miss_char,
216: p_ATTRIBUTE9 VARCHAR2 default fnd_api.g_miss_char,
217: p_ATTRIBUTE10 VARCHAR2 default fnd_api.g_miss_char,
218: p_ATTRIBUTE11 VARCHAR2 default fnd_api.g_miss_char,
219: p_ATTRIBUTE12 VARCHAR2 default fnd_api.g_miss_char,
220: p_ATTRIBUTE13 VARCHAR2 default fnd_api.g_miss_char,
213: p_ATTRIBUTE6 VARCHAR2 default fnd_api.g_miss_char,
214: p_ATTRIBUTE7 VARCHAR2 default fnd_api.g_miss_char,
215: p_ATTRIBUTE8 VARCHAR2 default fnd_api.g_miss_char,
216: p_ATTRIBUTE9 VARCHAR2 default fnd_api.g_miss_char,
217: p_ATTRIBUTE10 VARCHAR2 default fnd_api.g_miss_char,
218: p_ATTRIBUTE11 VARCHAR2 default fnd_api.g_miss_char,
219: p_ATTRIBUTE12 VARCHAR2 default fnd_api.g_miss_char,
220: p_ATTRIBUTE13 VARCHAR2 default fnd_api.g_miss_char,
221: p_ATTRIBUTE14 VARCHAR2 default fnd_api.g_miss_char,
214: p_ATTRIBUTE7 VARCHAR2 default fnd_api.g_miss_char,
215: p_ATTRIBUTE8 VARCHAR2 default fnd_api.g_miss_char,
216: p_ATTRIBUTE9 VARCHAR2 default fnd_api.g_miss_char,
217: p_ATTRIBUTE10 VARCHAR2 default fnd_api.g_miss_char,
218: p_ATTRIBUTE11 VARCHAR2 default fnd_api.g_miss_char,
219: p_ATTRIBUTE12 VARCHAR2 default fnd_api.g_miss_char,
220: p_ATTRIBUTE13 VARCHAR2 default fnd_api.g_miss_char,
221: p_ATTRIBUTE14 VARCHAR2 default fnd_api.g_miss_char,
222: p_ATTRIBUTE15 VARCHAR2 default fnd_api.g_miss_char,
215: p_ATTRIBUTE8 VARCHAR2 default fnd_api.g_miss_char,
216: p_ATTRIBUTE9 VARCHAR2 default fnd_api.g_miss_char,
217: p_ATTRIBUTE10 VARCHAR2 default fnd_api.g_miss_char,
218: p_ATTRIBUTE11 VARCHAR2 default fnd_api.g_miss_char,
219: p_ATTRIBUTE12 VARCHAR2 default fnd_api.g_miss_char,
220: p_ATTRIBUTE13 VARCHAR2 default fnd_api.g_miss_char,
221: p_ATTRIBUTE14 VARCHAR2 default fnd_api.g_miss_char,
222: p_ATTRIBUTE15 VARCHAR2 default fnd_api.g_miss_char,
223: p_ATTRIBUTE_CATEGORY VARCHAR2 default fnd_api.g_miss_char,
216: p_ATTRIBUTE9 VARCHAR2 default fnd_api.g_miss_char,
217: p_ATTRIBUTE10 VARCHAR2 default fnd_api.g_miss_char,
218: p_ATTRIBUTE11 VARCHAR2 default fnd_api.g_miss_char,
219: p_ATTRIBUTE12 VARCHAR2 default fnd_api.g_miss_char,
220: p_ATTRIBUTE13 VARCHAR2 default fnd_api.g_miss_char,
221: p_ATTRIBUTE14 VARCHAR2 default fnd_api.g_miss_char,
222: p_ATTRIBUTE15 VARCHAR2 default fnd_api.g_miss_char,
223: p_ATTRIBUTE_CATEGORY VARCHAR2 default fnd_api.g_miss_char,
224: P_TRANSACTION_TYPE_ID NUMBER default fnd_api.g_miss_num,
217: p_ATTRIBUTE10 VARCHAR2 default fnd_api.g_miss_char,
218: p_ATTRIBUTE11 VARCHAR2 default fnd_api.g_miss_char,
219: p_ATTRIBUTE12 VARCHAR2 default fnd_api.g_miss_char,
220: p_ATTRIBUTE13 VARCHAR2 default fnd_api.g_miss_char,
221: p_ATTRIBUTE14 VARCHAR2 default fnd_api.g_miss_char,
222: p_ATTRIBUTE15 VARCHAR2 default fnd_api.g_miss_char,
223: p_ATTRIBUTE_CATEGORY VARCHAR2 default fnd_api.g_miss_char,
224: P_TRANSACTION_TYPE_ID NUMBER default fnd_api.g_miss_num,
225: p_RETURN_DATE DATE default fnd_api.g_miss_date,
218: p_ATTRIBUTE11 VARCHAR2 default fnd_api.g_miss_char,
219: p_ATTRIBUTE12 VARCHAR2 default fnd_api.g_miss_char,
220: p_ATTRIBUTE13 VARCHAR2 default fnd_api.g_miss_char,
221: p_ATTRIBUTE14 VARCHAR2 default fnd_api.g_miss_char,
222: p_ATTRIBUTE15 VARCHAR2 default fnd_api.g_miss_char,
223: p_ATTRIBUTE_CATEGORY VARCHAR2 default fnd_api.g_miss_char,
224: P_TRANSACTION_TYPE_ID NUMBER default fnd_api.g_miss_num,
225: p_RETURN_DATE DATE default fnd_api.g_miss_date,
226: p_DML_mode VARCHAR2 default NULL --added for bug 6914559
219: p_ATTRIBUTE12 VARCHAR2 default fnd_api.g_miss_char,
220: p_ATTRIBUTE13 VARCHAR2 default fnd_api.g_miss_char,
221: p_ATTRIBUTE14 VARCHAR2 default fnd_api.g_miss_char,
222: p_ATTRIBUTE15 VARCHAR2 default fnd_api.g_miss_char,
223: p_ATTRIBUTE_CATEGORY VARCHAR2 default fnd_api.g_miss_char,
224: P_TRANSACTION_TYPE_ID NUMBER default fnd_api.g_miss_num,
225: p_RETURN_DATE DATE default fnd_api.g_miss_date,
226: p_DML_mode VARCHAR2 default NULL --added for bug 6914559
227: );
220: p_ATTRIBUTE13 VARCHAR2 default fnd_api.g_miss_char,
221: p_ATTRIBUTE14 VARCHAR2 default fnd_api.g_miss_char,
222: p_ATTRIBUTE15 VARCHAR2 default fnd_api.g_miss_char,
223: p_ATTRIBUTE_CATEGORY VARCHAR2 default fnd_api.g_miss_char,
224: P_TRANSACTION_TYPE_ID NUMBER default fnd_api.g_miss_num,
225: p_RETURN_DATE DATE default fnd_api.g_miss_date,
226: p_DML_mode VARCHAR2 default NULL --added for bug 6914559
227: );
228:
221: p_ATTRIBUTE14 VARCHAR2 default fnd_api.g_miss_char,
222: p_ATTRIBUTE15 VARCHAR2 default fnd_api.g_miss_char,
223: p_ATTRIBUTE_CATEGORY VARCHAR2 default fnd_api.g_miss_char,
224: P_TRANSACTION_TYPE_ID NUMBER default fnd_api.g_miss_num,
225: p_RETURN_DATE DATE default fnd_api.g_miss_date,
226: p_DML_mode VARCHAR2 default NULL --added for bug 6914559
227: );
228:
229: PROCEDURE Lock_Row(