APPS.CSE_DATASTRUCTURES_PUB dependencies on FND_API

Line 43: ( INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,

39: ( INVOICE_DISTRIBUTION_ID NUMBER,
40: Message_Id NUMBER
41: );
42: TYPE MTL_ITEM_REC_TYPE IS RECORD
43: ( INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
44: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
45: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
46: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
47: TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM,

Line 44: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

40: Message_Id NUMBER
41: );
42: TYPE MTL_ITEM_REC_TYPE IS RECORD
43: ( INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
44: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
45: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
46: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
47: TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM,
48: TRANSACTION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,

Line 45: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,

41: );
42: TYPE MTL_ITEM_REC_TYPE IS RECORD
43: ( INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
44: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
45: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
46: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
47: TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM,
48: TRANSACTION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
49: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,

Line 46: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,

42: TYPE MTL_ITEM_REC_TYPE IS RECORD
43: ( INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
44: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
45: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
46: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
47: TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM,
48: TRANSACTION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
49: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
50: TRANSACTION_ACTION_ID NUMBER := FND_API.G_MISS_NUM,

Line 47: TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM,

43: ( INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
44: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
45: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
46: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
47: TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM,
48: TRANSACTION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
49: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
50: TRANSACTION_ACTION_ID NUMBER := FND_API.G_MISS_NUM,
51: TRANSACTION_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,

Line 48: TRANSACTION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,

44: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
45: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
46: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
47: TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM,
48: TRANSACTION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
49: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
50: TRANSACTION_ACTION_ID NUMBER := FND_API.G_MISS_NUM,
51: TRANSACTION_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
52: TRANSACTION_SOURCE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,

Line 49: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,

45: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
46: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
47: TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM,
48: TRANSACTION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
49: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
50: TRANSACTION_ACTION_ID NUMBER := FND_API.G_MISS_NUM,
51: TRANSACTION_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
52: TRANSACTION_SOURCE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
53: TRANSFER_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,

Line 50: TRANSACTION_ACTION_ID NUMBER := FND_API.G_MISS_NUM,

46: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
47: TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM,
48: TRANSACTION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
49: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
50: TRANSACTION_ACTION_ID NUMBER := FND_API.G_MISS_NUM,
51: TRANSACTION_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
52: TRANSACTION_SOURCE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
53: TRANSFER_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
54: TRANSFER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 51: TRANSACTION_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,

47: TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM,
48: TRANSACTION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
49: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
50: TRANSACTION_ACTION_ID NUMBER := FND_API.G_MISS_NUM,
51: TRANSACTION_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
52: TRANSACTION_SOURCE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
53: TRANSFER_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
54: TRANSFER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
55: TRANSFER_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 52: TRANSACTION_SOURCE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,

48: TRANSACTION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
49: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
50: TRANSACTION_ACTION_ID NUMBER := FND_API.G_MISS_NUM,
51: TRANSACTION_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
52: TRANSACTION_SOURCE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
53: TRANSFER_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
54: TRANSFER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
55: TRANSFER_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
56: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,

Line 53: TRANSFER_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,

49: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
50: TRANSACTION_ACTION_ID NUMBER := FND_API.G_MISS_NUM,
51: TRANSACTION_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
52: TRANSACTION_SOURCE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
53: TRANSFER_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
54: TRANSFER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
55: TRANSFER_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
56: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
57: SOURCE_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,

Line 54: TRANSFER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

50: TRANSACTION_ACTION_ID NUMBER := FND_API.G_MISS_NUM,
51: TRANSACTION_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
52: TRANSACTION_SOURCE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
53: TRANSFER_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
54: TRANSFER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
55: TRANSFER_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
56: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
57: SOURCE_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
58: SOURCE_TASK_ID NUMBER := FND_API.G_MISS_NUM,

Line 55: TRANSFER_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,

51: TRANSACTION_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
52: TRANSACTION_SOURCE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
53: TRANSFER_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
54: TRANSFER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
55: TRANSFER_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
56: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
57: SOURCE_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
58: SOURCE_TASK_ID NUMBER := FND_API.G_MISS_NUM,
59: FROM_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,

Line 56: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,

52: TRANSACTION_SOURCE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
53: TRANSFER_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
54: TRANSFER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
55: TRANSFER_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
56: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
57: SOURCE_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
58: SOURCE_TASK_ID NUMBER := FND_API.G_MISS_NUM,
59: FROM_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
60: FROM_TASK_ID NUMBER := FND_API.G_MISS_NUM,

Line 57: SOURCE_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,

53: TRANSFER_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
54: TRANSFER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
55: TRANSFER_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
56: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
57: SOURCE_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
58: SOURCE_TASK_ID NUMBER := FND_API.G_MISS_NUM,
59: FROM_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
60: FROM_TASK_ID NUMBER := FND_API.G_MISS_NUM,
61: TO_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,

Line 58: SOURCE_TASK_ID NUMBER := FND_API.G_MISS_NUM,

54: TRANSFER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
55: TRANSFER_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
56: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
57: SOURCE_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
58: SOURCE_TASK_ID NUMBER := FND_API.G_MISS_NUM,
59: FROM_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
60: FROM_TASK_ID NUMBER := FND_API.G_MISS_NUM,
61: TO_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
62: TO_TASK_ID NUMBER := FND_API.G_MISS_NUM,

Line 59: FROM_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,

55: TRANSFER_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
56: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
57: SOURCE_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
58: SOURCE_TASK_ID NUMBER := FND_API.G_MISS_NUM,
59: FROM_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
60: FROM_TASK_ID NUMBER := FND_API.G_MISS_NUM,
61: TO_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
62: TO_TASK_ID NUMBER := FND_API.G_MISS_NUM,
63: TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,

Line 60: FROM_TASK_ID NUMBER := FND_API.G_MISS_NUM,

56: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
57: SOURCE_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
58: SOURCE_TASK_ID NUMBER := FND_API.G_MISS_NUM,
59: FROM_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
60: FROM_TASK_ID NUMBER := FND_API.G_MISS_NUM,
61: TO_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
62: TO_TASK_ID NUMBER := FND_API.G_MISS_NUM,
63: TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
64: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 61: TO_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,

57: SOURCE_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
58: SOURCE_TASK_ID NUMBER := FND_API.G_MISS_NUM,
59: FROM_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
60: FROM_TASK_ID NUMBER := FND_API.G_MISS_NUM,
61: TO_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
62: TO_TASK_ID NUMBER := FND_API.G_MISS_NUM,
63: TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
64: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
65: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 62: TO_TASK_ID NUMBER := FND_API.G_MISS_NUM,

58: SOURCE_TASK_ID NUMBER := FND_API.G_MISS_NUM,
59: FROM_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
60: FROM_TASK_ID NUMBER := FND_API.G_MISS_NUM,
61: TO_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
62: TO_TASK_ID NUMBER := FND_API.G_MISS_NUM,
63: TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
64: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
65: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: LOT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 63: TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,

59: FROM_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
60: FROM_TASK_ID NUMBER := FND_API.G_MISS_NUM,
61: TO_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
62: TO_TASK_ID NUMBER := FND_API.G_MISS_NUM,
63: TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
64: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
65: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: LOT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 64: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

60: FROM_TASK_ID NUMBER := FND_API.G_MISS_NUM,
61: TO_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
62: TO_TASK_ID NUMBER := FND_API.G_MISS_NUM,
63: TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
64: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
65: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: LOT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
68: PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,

Line 65: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,

61: TO_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
62: TO_TASK_ID NUMBER := FND_API.G_MISS_NUM,
63: TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
64: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
65: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: LOT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
68: PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
69: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 66: LOT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,

62: TO_TASK_ID NUMBER := FND_API.G_MISS_NUM,
63: TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
64: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
65: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: LOT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
68: PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
69: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
70: SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 67: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,

63: TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
64: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
65: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: LOT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
68: PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
69: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
70: SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,

Line 68: PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,

64: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
65: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: LOT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
68: PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
69: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
70: SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
72: MOVE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,

Line 69: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,

65: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: LOT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
68: PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
69: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
70: SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
72: MOVE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
73: SERIAL_NUMBER_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,

Line 70: SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,

66: LOT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
68: PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
69: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
70: SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
72: MOVE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
73: SERIAL_NUMBER_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
74: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM

Line 71: TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,

67: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
68: PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
69: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
70: SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
72: MOVE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
73: SERIAL_NUMBER_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
74: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM
75: );

Line 72: MOVE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,

68: PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
69: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
70: SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
72: MOVE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
73: SERIAL_NUMBER_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
74: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM
75: );
76: TYPE MTL_ITEM_TBL_TYPE is TABLE OF MTL_ITEM_REC_TYPE INDEX BY BINARY_INTEGER;

Line 73: SERIAL_NUMBER_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,

69: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
70: SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
72: MOVE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
73: SERIAL_NUMBER_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
74: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM
75: );
76: TYPE MTL_ITEM_TBL_TYPE is TABLE OF MTL_ITEM_REC_TYPE INDEX BY BINARY_INTEGER;
77:

Line 74: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM

70: SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
72: MOVE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
73: SERIAL_NUMBER_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
74: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM
75: );
76: TYPE MTL_ITEM_TBL_TYPE is TABLE OF MTL_ITEM_REC_TYPE INDEX BY BINARY_INTEGER;
77:
78: TYPE MTL_INSTANCE_REC_TYPE is RECORD

Line 277: parent_mass_addition_id NUMBER := FND_API.G_MISS_NUM

273: INDEX BY BINARY_INTEGER;
274:
275: TYPE asset_query_rec IS RECORD
276: (
277: parent_mass_addition_id NUMBER := FND_API.G_MISS_NUM
278: ,mass_addition_id NUMBER := FND_API.G_MISS_NUM
279: ,asset_id NUMBER := FND_API.G_MISS_NUM
280: ,search_method VARCHAR2(4) := FND_API.G_MISS_CHAR
281: ,asset_number VARCHAR2(15) := FND_API.G_MISS_CHAR

Line 278: ,mass_addition_id NUMBER := FND_API.G_MISS_NUM

274:
275: TYPE asset_query_rec IS RECORD
276: (
277: parent_mass_addition_id NUMBER := FND_API.G_MISS_NUM
278: ,mass_addition_id NUMBER := FND_API.G_MISS_NUM
279: ,asset_id NUMBER := FND_API.G_MISS_NUM
280: ,search_method VARCHAR2(4) := FND_API.G_MISS_CHAR
281: ,asset_number VARCHAR2(15) := FND_API.G_MISS_CHAR
282: ,category_id NUMBER := FND_API.G_MISS_NUM

Line 279: ,asset_id NUMBER := FND_API.G_MISS_NUM

275: TYPE asset_query_rec IS RECORD
276: (
277: parent_mass_addition_id NUMBER := FND_API.G_MISS_NUM
278: ,mass_addition_id NUMBER := FND_API.G_MISS_NUM
279: ,asset_id NUMBER := FND_API.G_MISS_NUM
280: ,search_method VARCHAR2(4) := FND_API.G_MISS_CHAR
281: ,asset_number VARCHAR2(15) := FND_API.G_MISS_CHAR
282: ,category_id NUMBER := FND_API.G_MISS_NUM
283: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR

Line 280: ,search_method VARCHAR2(4) := FND_API.G_MISS_CHAR

276: (
277: parent_mass_addition_id NUMBER := FND_API.G_MISS_NUM
278: ,mass_addition_id NUMBER := FND_API.G_MISS_NUM
279: ,asset_id NUMBER := FND_API.G_MISS_NUM
280: ,search_method VARCHAR2(4) := FND_API.G_MISS_CHAR
281: ,asset_number VARCHAR2(15) := FND_API.G_MISS_CHAR
282: ,category_id NUMBER := FND_API.G_MISS_NUM
283: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
284: ,date_placed_in_service DATE := FND_API.G_MISS_DATE

Line 281: ,asset_number VARCHAR2(15) := FND_API.G_MISS_CHAR

277: parent_mass_addition_id NUMBER := FND_API.G_MISS_NUM
278: ,mass_addition_id NUMBER := FND_API.G_MISS_NUM
279: ,asset_id NUMBER := FND_API.G_MISS_NUM
280: ,search_method VARCHAR2(4) := FND_API.G_MISS_CHAR
281: ,asset_number VARCHAR2(15) := FND_API.G_MISS_CHAR
282: ,category_id NUMBER := FND_API.G_MISS_NUM
283: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
284: ,date_placed_in_service DATE := FND_API.G_MISS_DATE
285: ,asset_key_ccid NUMBER := FND_API.G_MISS_NUM

Line 282: ,category_id NUMBER := FND_API.G_MISS_NUM

278: ,mass_addition_id NUMBER := FND_API.G_MISS_NUM
279: ,asset_id NUMBER := FND_API.G_MISS_NUM
280: ,search_method VARCHAR2(4) := FND_API.G_MISS_CHAR
281: ,asset_number VARCHAR2(15) := FND_API.G_MISS_CHAR
282: ,category_id NUMBER := FND_API.G_MISS_NUM
283: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
284: ,date_placed_in_service DATE := FND_API.G_MISS_DATE
285: ,asset_key_ccid NUMBER := FND_API.G_MISS_NUM
286: ,tag_number VARCHAR2(15) := FND_API.G_MISS_CHAR

Line 283: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR

279: ,asset_id NUMBER := FND_API.G_MISS_NUM
280: ,search_method VARCHAR2(4) := FND_API.G_MISS_CHAR
281: ,asset_number VARCHAR2(15) := FND_API.G_MISS_CHAR
282: ,category_id NUMBER := FND_API.G_MISS_NUM
283: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
284: ,date_placed_in_service DATE := FND_API.G_MISS_DATE
285: ,asset_key_ccid NUMBER := FND_API.G_MISS_NUM
286: ,tag_number VARCHAR2(15) := FND_API.G_MISS_CHAR
287: ,description VARCHAR2(80) := FND_API.G_MISS_CHAR

Line 284: ,date_placed_in_service DATE := FND_API.G_MISS_DATE

280: ,search_method VARCHAR2(4) := FND_API.G_MISS_CHAR
281: ,asset_number VARCHAR2(15) := FND_API.G_MISS_CHAR
282: ,category_id NUMBER := FND_API.G_MISS_NUM
283: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
284: ,date_placed_in_service DATE := FND_API.G_MISS_DATE
285: ,asset_key_ccid NUMBER := FND_API.G_MISS_NUM
286: ,tag_number VARCHAR2(15) := FND_API.G_MISS_CHAR
287: ,description VARCHAR2(80) := FND_API.G_MISS_CHAR
288: ,manufacturer_name VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 285: ,asset_key_ccid NUMBER := FND_API.G_MISS_NUM

281: ,asset_number VARCHAR2(15) := FND_API.G_MISS_CHAR
282: ,category_id NUMBER := FND_API.G_MISS_NUM
283: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
284: ,date_placed_in_service DATE := FND_API.G_MISS_DATE
285: ,asset_key_ccid NUMBER := FND_API.G_MISS_NUM
286: ,tag_number VARCHAR2(15) := FND_API.G_MISS_CHAR
287: ,description VARCHAR2(80) := FND_API.G_MISS_CHAR
288: ,manufacturer_name VARCHAR2(30) := FND_API.G_MISS_CHAR
289: ,serial_number VARCHAR2(35) := FND_API.G_MISS_CHAR

Line 286: ,tag_number VARCHAR2(15) := FND_API.G_MISS_CHAR

282: ,category_id NUMBER := FND_API.G_MISS_NUM
283: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
284: ,date_placed_in_service DATE := FND_API.G_MISS_DATE
285: ,asset_key_ccid NUMBER := FND_API.G_MISS_NUM
286: ,tag_number VARCHAR2(15) := FND_API.G_MISS_CHAR
287: ,description VARCHAR2(80) := FND_API.G_MISS_CHAR
288: ,manufacturer_name VARCHAR2(30) := FND_API.G_MISS_CHAR
289: ,serial_number VARCHAR2(35) := FND_API.G_MISS_CHAR
290: ,model_number VARCHAR2(40) := FND_API.G_MISS_CHAR

Line 287: ,description VARCHAR2(80) := FND_API.G_MISS_CHAR

283: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
284: ,date_placed_in_service DATE := FND_API.G_MISS_DATE
285: ,asset_key_ccid NUMBER := FND_API.G_MISS_NUM
286: ,tag_number VARCHAR2(15) := FND_API.G_MISS_CHAR
287: ,description VARCHAR2(80) := FND_API.G_MISS_CHAR
288: ,manufacturer_name VARCHAR2(30) := FND_API.G_MISS_CHAR
289: ,serial_number VARCHAR2(35) := FND_API.G_MISS_CHAR
290: ,model_number VARCHAR2(40) := FND_API.G_MISS_CHAR
291: ,location_id NUMBER := FND_API.G_MISS_NUM

Line 288: ,manufacturer_name VARCHAR2(30) := FND_API.G_MISS_CHAR

284: ,date_placed_in_service DATE := FND_API.G_MISS_DATE
285: ,asset_key_ccid NUMBER := FND_API.G_MISS_NUM
286: ,tag_number VARCHAR2(15) := FND_API.G_MISS_CHAR
287: ,description VARCHAR2(80) := FND_API.G_MISS_CHAR
288: ,manufacturer_name VARCHAR2(30) := FND_API.G_MISS_CHAR
289: ,serial_number VARCHAR2(35) := FND_API.G_MISS_CHAR
290: ,model_number VARCHAR2(40) := FND_API.G_MISS_CHAR
291: ,location_id NUMBER := FND_API.G_MISS_NUM
292: ,employee_id NUMBER := FND_API.G_MISS_NUM

Line 289: ,serial_number VARCHAR2(35) := FND_API.G_MISS_CHAR

285: ,asset_key_ccid NUMBER := FND_API.G_MISS_NUM
286: ,tag_number VARCHAR2(15) := FND_API.G_MISS_CHAR
287: ,description VARCHAR2(80) := FND_API.G_MISS_CHAR
288: ,manufacturer_name VARCHAR2(30) := FND_API.G_MISS_CHAR
289: ,serial_number VARCHAR2(35) := FND_API.G_MISS_CHAR
290: ,model_number VARCHAR2(40) := FND_API.G_MISS_CHAR
291: ,location_id NUMBER := FND_API.G_MISS_NUM
292: ,employee_id NUMBER := FND_API.G_MISS_NUM
293: ,deprn_employee_id NUMBER := FND_API.G_MISS_NUM

Line 290: ,model_number VARCHAR2(40) := FND_API.G_MISS_CHAR

286: ,tag_number VARCHAR2(15) := FND_API.G_MISS_CHAR
287: ,description VARCHAR2(80) := FND_API.G_MISS_CHAR
288: ,manufacturer_name VARCHAR2(30) := FND_API.G_MISS_CHAR
289: ,serial_number VARCHAR2(35) := FND_API.G_MISS_CHAR
290: ,model_number VARCHAR2(40) := FND_API.G_MISS_CHAR
291: ,location_id NUMBER := FND_API.G_MISS_NUM
292: ,employee_id NUMBER := FND_API.G_MISS_NUM
293: ,deprn_employee_id NUMBER := FND_API.G_MISS_NUM
294: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM

Line 291: ,location_id NUMBER := FND_API.G_MISS_NUM

287: ,description VARCHAR2(80) := FND_API.G_MISS_CHAR
288: ,manufacturer_name VARCHAR2(30) := FND_API.G_MISS_CHAR
289: ,serial_number VARCHAR2(35) := FND_API.G_MISS_CHAR
290: ,model_number VARCHAR2(40) := FND_API.G_MISS_CHAR
291: ,location_id NUMBER := FND_API.G_MISS_NUM
292: ,employee_id NUMBER := FND_API.G_MISS_NUM
293: ,deprn_employee_id NUMBER := FND_API.G_MISS_NUM
294: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
295: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM

Line 292: ,employee_id NUMBER := FND_API.G_MISS_NUM

288: ,manufacturer_name VARCHAR2(30) := FND_API.G_MISS_CHAR
289: ,serial_number VARCHAR2(35) := FND_API.G_MISS_CHAR
290: ,model_number VARCHAR2(40) := FND_API.G_MISS_CHAR
291: ,location_id NUMBER := FND_API.G_MISS_NUM
292: ,employee_id NUMBER := FND_API.G_MISS_NUM
293: ,deprn_employee_id NUMBER := FND_API.G_MISS_NUM
294: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
295: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM
296: ,distribution_id NUMBER := FND_API.G_MISS_NUM

Line 293: ,deprn_employee_id NUMBER := FND_API.G_MISS_NUM

289: ,serial_number VARCHAR2(35) := FND_API.G_MISS_CHAR
290: ,model_number VARCHAR2(40) := FND_API.G_MISS_CHAR
291: ,location_id NUMBER := FND_API.G_MISS_NUM
292: ,employee_id NUMBER := FND_API.G_MISS_NUM
293: ,deprn_employee_id NUMBER := FND_API.G_MISS_NUM
294: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
295: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM
296: ,distribution_id NUMBER := FND_API.G_MISS_NUM
297: ,current_mtl_cost NUMBER := FND_API.G_MISS_NUM

Line 294: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM

290: ,model_number VARCHAR2(40) := FND_API.G_MISS_CHAR
291: ,location_id NUMBER := FND_API.G_MISS_NUM
292: ,employee_id NUMBER := FND_API.G_MISS_NUM
293: ,deprn_employee_id NUMBER := FND_API.G_MISS_NUM
294: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
295: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM
296: ,distribution_id NUMBER := FND_API.G_MISS_NUM
297: ,current_mtl_cost NUMBER := FND_API.G_MISS_NUM
298: ,current_non_mtl_cost NUMBER := FND_API.G_MISS_NUM

Line 295: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM

291: ,location_id NUMBER := FND_API.G_MISS_NUM
292: ,employee_id NUMBER := FND_API.G_MISS_NUM
293: ,deprn_employee_id NUMBER := FND_API.G_MISS_NUM
294: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
295: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM
296: ,distribution_id NUMBER := FND_API.G_MISS_NUM
297: ,current_mtl_cost NUMBER := FND_API.G_MISS_NUM
298: ,current_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
299: ,current_units NUMBER := FND_API.G_MISS_NUM

Line 296: ,distribution_id NUMBER := FND_API.G_MISS_NUM

292: ,employee_id NUMBER := FND_API.G_MISS_NUM
293: ,deprn_employee_id NUMBER := FND_API.G_MISS_NUM
294: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
295: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM
296: ,distribution_id NUMBER := FND_API.G_MISS_NUM
297: ,current_mtl_cost NUMBER := FND_API.G_MISS_NUM
298: ,current_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
299: ,current_units NUMBER := FND_API.G_MISS_NUM
300: ,pending_adj_mtl_cost NUMBER := FND_API.G_MISS_NUM

Line 297: ,current_mtl_cost NUMBER := FND_API.G_MISS_NUM

293: ,deprn_employee_id NUMBER := FND_API.G_MISS_NUM
294: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
295: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM
296: ,distribution_id NUMBER := FND_API.G_MISS_NUM
297: ,current_mtl_cost NUMBER := FND_API.G_MISS_NUM
298: ,current_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
299: ,current_units NUMBER := FND_API.G_MISS_NUM
300: ,pending_adj_mtl_cost NUMBER := FND_API.G_MISS_NUM
301: ,pending_adj_non_mtl_cost NUMBER := FND_API.G_MISS_NUM

Line 298: ,current_non_mtl_cost NUMBER := FND_API.G_MISS_NUM

294: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
295: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM
296: ,distribution_id NUMBER := FND_API.G_MISS_NUM
297: ,current_mtl_cost NUMBER := FND_API.G_MISS_NUM
298: ,current_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
299: ,current_units NUMBER := FND_API.G_MISS_NUM
300: ,pending_adj_mtl_cost NUMBER := FND_API.G_MISS_NUM
301: ,pending_adj_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
302: ,pending_ret_mtl_cost NUMBER := FND_API.G_MISS_NUM

Line 299: ,current_units NUMBER := FND_API.G_MISS_NUM

295: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM
296: ,distribution_id NUMBER := FND_API.G_MISS_NUM
297: ,current_mtl_cost NUMBER := FND_API.G_MISS_NUM
298: ,current_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
299: ,current_units NUMBER := FND_API.G_MISS_NUM
300: ,pending_adj_mtl_cost NUMBER := FND_API.G_MISS_NUM
301: ,pending_adj_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
302: ,pending_ret_mtl_cost NUMBER := FND_API.G_MISS_NUM
303: ,pending_ret_non_mtl_cost NUMBER := FND_API.G_MISS_NUM

Line 300: ,pending_adj_mtl_cost NUMBER := FND_API.G_MISS_NUM

296: ,distribution_id NUMBER := FND_API.G_MISS_NUM
297: ,current_mtl_cost NUMBER := FND_API.G_MISS_NUM
298: ,current_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
299: ,current_units NUMBER := FND_API.G_MISS_NUM
300: ,pending_adj_mtl_cost NUMBER := FND_API.G_MISS_NUM
301: ,pending_adj_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
302: ,pending_ret_mtl_cost NUMBER := FND_API.G_MISS_NUM
303: ,pending_ret_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
304: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM

Line 301: ,pending_adj_non_mtl_cost NUMBER := FND_API.G_MISS_NUM

297: ,current_mtl_cost NUMBER := FND_API.G_MISS_NUM
298: ,current_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
299: ,current_units NUMBER := FND_API.G_MISS_NUM
300: ,pending_adj_mtl_cost NUMBER := FND_API.G_MISS_NUM
301: ,pending_adj_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
302: ,pending_ret_mtl_cost NUMBER := FND_API.G_MISS_NUM
303: ,pending_ret_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
304: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM
305: );

Line 302: ,pending_ret_mtl_cost NUMBER := FND_API.G_MISS_NUM

298: ,current_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
299: ,current_units NUMBER := FND_API.G_MISS_NUM
300: ,pending_adj_mtl_cost NUMBER := FND_API.G_MISS_NUM
301: ,pending_adj_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
302: ,pending_ret_mtl_cost NUMBER := FND_API.G_MISS_NUM
303: ,pending_ret_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
304: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM
305: );
306:

Line 303: ,pending_ret_non_mtl_cost NUMBER := FND_API.G_MISS_NUM

299: ,current_units NUMBER := FND_API.G_MISS_NUM
300: ,pending_adj_mtl_cost NUMBER := FND_API.G_MISS_NUM
301: ,pending_adj_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
302: ,pending_ret_mtl_cost NUMBER := FND_API.G_MISS_NUM
303: ,pending_ret_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
304: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM
305: );
306:
307: TYPE asset_query_tbl IS TABLE OF asset_query_rec

Line 304: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM

300: ,pending_adj_mtl_cost NUMBER := FND_API.G_MISS_NUM
301: ,pending_adj_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
302: ,pending_ret_mtl_cost NUMBER := FND_API.G_MISS_NUM
303: ,pending_ret_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
304: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM
305: );
306:
307: TYPE asset_query_tbl IS TABLE OF asset_query_rec
308: INDEX BY BINARY_INTEGER;

Line 314: Instance_ID NUMBER := FND_API.G_MISS_NUM

310:
311: --bnarayan added for R12
312: TYPE asset_attrib_rec IS RECORD
313: (
314: Instance_ID NUMBER := FND_API.G_MISS_NUM
315: ,Inventory_Item_ID NUMBER := FND_API.G_MISS_NUM
316: ,Serial_Number VARCHAR2(30) := FND_API.G_MISS_CHAR
317: ,Organization_ID NUMBER := FND_API.G_MISS_NUM
318: ,INV_MASTER_Organization_ID NUMBER := FND_API.G_MISS_NUM

Line 315: ,Inventory_Item_ID NUMBER := FND_API.G_MISS_NUM

311: --bnarayan added for R12
312: TYPE asset_attrib_rec IS RECORD
313: (
314: Instance_ID NUMBER := FND_API.G_MISS_NUM
315: ,Inventory_Item_ID NUMBER := FND_API.G_MISS_NUM
316: ,Serial_Number VARCHAR2(30) := FND_API.G_MISS_CHAR
317: ,Organization_ID NUMBER := FND_API.G_MISS_NUM
318: ,INV_MASTER_Organization_ID NUMBER := FND_API.G_MISS_NUM
319: ,Subinventory_Name VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 316: ,Serial_Number VARCHAR2(30) := FND_API.G_MISS_CHAR

312: TYPE asset_attrib_rec IS RECORD
313: (
314: Instance_ID NUMBER := FND_API.G_MISS_NUM
315: ,Inventory_Item_ID NUMBER := FND_API.G_MISS_NUM
316: ,Serial_Number VARCHAR2(30) := FND_API.G_MISS_CHAR
317: ,Organization_ID NUMBER := FND_API.G_MISS_NUM
318: ,INV_MASTER_Organization_ID NUMBER := FND_API.G_MISS_NUM
319: ,Subinventory_Name VARCHAR2(30) := FND_API.G_MISS_CHAR
320: ,Transaction_Quantity NUMBER := FND_API.G_MISS_NUM

Line 317: ,Organization_ID NUMBER := FND_API.G_MISS_NUM

313: (
314: Instance_ID NUMBER := FND_API.G_MISS_NUM
315: ,Inventory_Item_ID NUMBER := FND_API.G_MISS_NUM
316: ,Serial_Number VARCHAR2(30) := FND_API.G_MISS_CHAR
317: ,Organization_ID NUMBER := FND_API.G_MISS_NUM
318: ,INV_MASTER_Organization_ID NUMBER := FND_API.G_MISS_NUM
319: ,Subinventory_Name VARCHAR2(30) := FND_API.G_MISS_CHAR
320: ,Transaction_Quantity NUMBER := FND_API.G_MISS_NUM
321: ,Transaction_ID NUMBER := FND_API.G_MISS_NUM

Line 318: ,INV_MASTER_Organization_ID NUMBER := FND_API.G_MISS_NUM

314: Instance_ID NUMBER := FND_API.G_MISS_NUM
315: ,Inventory_Item_ID NUMBER := FND_API.G_MISS_NUM
316: ,Serial_Number VARCHAR2(30) := FND_API.G_MISS_CHAR
317: ,Organization_ID NUMBER := FND_API.G_MISS_NUM
318: ,INV_MASTER_Organization_ID NUMBER := FND_API.G_MISS_NUM
319: ,Subinventory_Name VARCHAR2(30) := FND_API.G_MISS_CHAR
320: ,Transaction_Quantity NUMBER := FND_API.G_MISS_NUM
321: ,Transaction_ID NUMBER := FND_API.G_MISS_NUM
322: ,Transaction_Date DATE := FND_API.G_MISS_DATE

Line 319: ,Subinventory_Name VARCHAR2(30) := FND_API.G_MISS_CHAR

315: ,Inventory_Item_ID NUMBER := FND_API.G_MISS_NUM
316: ,Serial_Number VARCHAR2(30) := FND_API.G_MISS_CHAR
317: ,Organization_ID NUMBER := FND_API.G_MISS_NUM
318: ,INV_MASTER_Organization_ID NUMBER := FND_API.G_MISS_NUM
319: ,Subinventory_Name VARCHAR2(30) := FND_API.G_MISS_CHAR
320: ,Transaction_Quantity NUMBER := FND_API.G_MISS_NUM
321: ,Transaction_ID NUMBER := FND_API.G_MISS_NUM
322: ,Transaction_Date DATE := FND_API.G_MISS_DATE
323: ,Source_Transaction_type VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 320: ,Transaction_Quantity NUMBER := FND_API.G_MISS_NUM

316: ,Serial_Number VARCHAR2(30) := FND_API.G_MISS_CHAR
317: ,Organization_ID NUMBER := FND_API.G_MISS_NUM
318: ,INV_MASTER_Organization_ID NUMBER := FND_API.G_MISS_NUM
319: ,Subinventory_Name VARCHAR2(30) := FND_API.G_MISS_CHAR
320: ,Transaction_Quantity NUMBER := FND_API.G_MISS_NUM
321: ,Transaction_ID NUMBER := FND_API.G_MISS_NUM
322: ,Transaction_Date DATE := FND_API.G_MISS_DATE
323: ,Source_Transaction_type VARCHAR2(30) := FND_API.G_MISS_CHAR
324: ,Depreciable_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 321: ,Transaction_ID NUMBER := FND_API.G_MISS_NUM

317: ,Organization_ID NUMBER := FND_API.G_MISS_NUM
318: ,INV_MASTER_Organization_ID NUMBER := FND_API.G_MISS_NUM
319: ,Subinventory_Name VARCHAR2(30) := FND_API.G_MISS_CHAR
320: ,Transaction_Quantity NUMBER := FND_API.G_MISS_NUM
321: ,Transaction_ID NUMBER := FND_API.G_MISS_NUM
322: ,Transaction_Date DATE := FND_API.G_MISS_DATE
323: ,Source_Transaction_type VARCHAR2(30) := FND_API.G_MISS_CHAR
324: ,Depreciable_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR
325: ,Location_Type_Code VARCHAR2(40) := FND_API.G_MISS_CHAR

Line 322: ,Transaction_Date DATE := FND_API.G_MISS_DATE

318: ,INV_MASTER_Organization_ID NUMBER := FND_API.G_MISS_NUM
319: ,Subinventory_Name VARCHAR2(30) := FND_API.G_MISS_CHAR
320: ,Transaction_Quantity NUMBER := FND_API.G_MISS_NUM
321: ,Transaction_ID NUMBER := FND_API.G_MISS_NUM
322: ,Transaction_Date DATE := FND_API.G_MISS_DATE
323: ,Source_Transaction_type VARCHAR2(30) := FND_API.G_MISS_CHAR
324: ,Depreciable_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR
325: ,Location_Type_Code VARCHAR2(40) := FND_API.G_MISS_CHAR
326: ,Transaction_Type_ID NUMBER := FND_API.G_MISS_NUM

Line 323: ,Source_Transaction_type VARCHAR2(30) := FND_API.G_MISS_CHAR

319: ,Subinventory_Name VARCHAR2(30) := FND_API.G_MISS_CHAR
320: ,Transaction_Quantity NUMBER := FND_API.G_MISS_NUM
321: ,Transaction_ID NUMBER := FND_API.G_MISS_NUM
322: ,Transaction_Date DATE := FND_API.G_MISS_DATE
323: ,Source_Transaction_type VARCHAR2(30) := FND_API.G_MISS_CHAR
324: ,Depreciable_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR
325: ,Location_Type_Code VARCHAR2(40) := FND_API.G_MISS_CHAR
326: ,Transaction_Type_ID NUMBER := FND_API.G_MISS_NUM
327: ,Source_Header_Ref_ID NUMBER := FND_API.G_MISS_NUM

Line 324: ,Depreciable_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR

320: ,Transaction_Quantity NUMBER := FND_API.G_MISS_NUM
321: ,Transaction_ID NUMBER := FND_API.G_MISS_NUM
322: ,Transaction_Date DATE := FND_API.G_MISS_DATE
323: ,Source_Transaction_type VARCHAR2(30) := FND_API.G_MISS_CHAR
324: ,Depreciable_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR
325: ,Location_Type_Code VARCHAR2(40) := FND_API.G_MISS_CHAR
326: ,Transaction_Type_ID NUMBER := FND_API.G_MISS_NUM
327: ,Source_Header_Ref_ID NUMBER := FND_API.G_MISS_NUM
328: ,RCV_Transaction_ID NUMBER := FND_API.G_MISS_NUM

Line 325: ,Location_Type_Code VARCHAR2(40) := FND_API.G_MISS_CHAR

321: ,Transaction_ID NUMBER := FND_API.G_MISS_NUM
322: ,Transaction_Date DATE := FND_API.G_MISS_DATE
323: ,Source_Transaction_type VARCHAR2(30) := FND_API.G_MISS_CHAR
324: ,Depreciable_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR
325: ,Location_Type_Code VARCHAR2(40) := FND_API.G_MISS_CHAR
326: ,Transaction_Type_ID NUMBER := FND_API.G_MISS_NUM
327: ,Source_Header_Ref_ID NUMBER := FND_API.G_MISS_NUM
328: ,RCV_Transaction_ID NUMBER := FND_API.G_MISS_NUM
329: ,PO_Distribution_Id NUMBER := FND_API.G_MISS_NUM

Line 326: ,Transaction_Type_ID NUMBER := FND_API.G_MISS_NUM

322: ,Transaction_Date DATE := FND_API.G_MISS_DATE
323: ,Source_Transaction_type VARCHAR2(30) := FND_API.G_MISS_CHAR
324: ,Depreciable_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR
325: ,Location_Type_Code VARCHAR2(40) := FND_API.G_MISS_CHAR
326: ,Transaction_Type_ID NUMBER := FND_API.G_MISS_NUM
327: ,Source_Header_Ref_ID NUMBER := FND_API.G_MISS_NUM
328: ,RCV_Transaction_ID NUMBER := FND_API.G_MISS_NUM
329: ,PO_Distribution_Id NUMBER := FND_API.G_MISS_NUM
330: ,Inv_Material_Transaction_ID NUMBER := FND_API.G_MISS_NUM

Line 327: ,Source_Header_Ref_ID NUMBER := FND_API.G_MISS_NUM

323: ,Source_Transaction_type VARCHAR2(30) := FND_API.G_MISS_CHAR
324: ,Depreciable_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR
325: ,Location_Type_Code VARCHAR2(40) := FND_API.G_MISS_CHAR
326: ,Transaction_Type_ID NUMBER := FND_API.G_MISS_NUM
327: ,Source_Header_Ref_ID NUMBER := FND_API.G_MISS_NUM
328: ,RCV_Transaction_ID NUMBER := FND_API.G_MISS_NUM
329: ,PO_Distribution_Id NUMBER := FND_API.G_MISS_NUM
330: ,Inv_Material_Transaction_ID NUMBER := FND_API.G_MISS_NUM
331: ,Location_id NUMBER := FND_API.G_MISS_NUM

Line 328: ,RCV_Transaction_ID NUMBER := FND_API.G_MISS_NUM

324: ,Depreciable_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR
325: ,Location_Type_Code VARCHAR2(40) := FND_API.G_MISS_CHAR
326: ,Transaction_Type_ID NUMBER := FND_API.G_MISS_NUM
327: ,Source_Header_Ref_ID NUMBER := FND_API.G_MISS_NUM
328: ,RCV_Transaction_ID NUMBER := FND_API.G_MISS_NUM
329: ,PO_Distribution_Id NUMBER := FND_API.G_MISS_NUM
330: ,Inv_Material_Transaction_ID NUMBER := FND_API.G_MISS_NUM
331: ,Location_id NUMBER := FND_API.G_MISS_NUM
332: ,Asset_Category_ID NUMBER := FND_API.G_MISS_NUM

Line 329: ,PO_Distribution_Id NUMBER := FND_API.G_MISS_NUM

325: ,Location_Type_Code VARCHAR2(40) := FND_API.G_MISS_CHAR
326: ,Transaction_Type_ID NUMBER := FND_API.G_MISS_NUM
327: ,Source_Header_Ref_ID NUMBER := FND_API.G_MISS_NUM
328: ,RCV_Transaction_ID NUMBER := FND_API.G_MISS_NUM
329: ,PO_Distribution_Id NUMBER := FND_API.G_MISS_NUM
330: ,Inv_Material_Transaction_ID NUMBER := FND_API.G_MISS_NUM
331: ,Location_id NUMBER := FND_API.G_MISS_NUM
332: ,Asset_Category_ID NUMBER := FND_API.G_MISS_NUM
333: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR

Line 330: ,Inv_Material_Transaction_ID NUMBER := FND_API.G_MISS_NUM

326: ,Transaction_Type_ID NUMBER := FND_API.G_MISS_NUM
327: ,Source_Header_Ref_ID NUMBER := FND_API.G_MISS_NUM
328: ,RCV_Transaction_ID NUMBER := FND_API.G_MISS_NUM
329: ,PO_Distribution_Id NUMBER := FND_API.G_MISS_NUM
330: ,Inv_Material_Transaction_ID NUMBER := FND_API.G_MISS_NUM
331: ,Location_id NUMBER := FND_API.G_MISS_NUM
332: ,Asset_Category_ID NUMBER := FND_API.G_MISS_NUM
333: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
334:

Line 331: ,Location_id NUMBER := FND_API.G_MISS_NUM

327: ,Source_Header_Ref_ID NUMBER := FND_API.G_MISS_NUM
328: ,RCV_Transaction_ID NUMBER := FND_API.G_MISS_NUM
329: ,PO_Distribution_Id NUMBER := FND_API.G_MISS_NUM
330: ,Inv_Material_Transaction_ID NUMBER := FND_API.G_MISS_NUM
331: ,Location_id NUMBER := FND_API.G_MISS_NUM
332: ,Asset_Category_ID NUMBER := FND_API.G_MISS_NUM
333: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
334:
335: );

Line 332: ,Asset_Category_ID NUMBER := FND_API.G_MISS_NUM

328: ,RCV_Transaction_ID NUMBER := FND_API.G_MISS_NUM
329: ,PO_Distribution_Id NUMBER := FND_API.G_MISS_NUM
330: ,Inv_Material_Transaction_ID NUMBER := FND_API.G_MISS_NUM
331: ,Location_id NUMBER := FND_API.G_MISS_NUM
332: ,Asset_Category_ID NUMBER := FND_API.G_MISS_NUM
333: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
334:
335: );
336:

Line 333: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR

329: ,PO_Distribution_Id NUMBER := FND_API.G_MISS_NUM
330: ,Inv_Material_Transaction_ID NUMBER := FND_API.G_MISS_NUM
331: ,Location_id NUMBER := FND_API.G_MISS_NUM
332: ,Asset_Category_ID NUMBER := FND_API.G_MISS_NUM
333: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
334:
335: );
336:
337:

Line 346: asset_id NUMBER := FND_API.G_MISS_NUM

342:
343:
344: TYPE distribution_rec IS RECORD
345: (
346: asset_id NUMBER := FND_API.G_MISS_NUM
347: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
348: ,distribution_id NUMBER := FND_API.G_MISS_NUM
349: ,location_id NUMBER := FND_API.G_MISS_NUM
350: ,employee_id NUMBER := FND_API.G_MISS_NUM

Line 347: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR

343:
344: TYPE distribution_rec IS RECORD
345: (
346: asset_id NUMBER := FND_API.G_MISS_NUM
347: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
348: ,distribution_id NUMBER := FND_API.G_MISS_NUM
349: ,location_id NUMBER := FND_API.G_MISS_NUM
350: ,employee_id NUMBER := FND_API.G_MISS_NUM
351: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM

Line 348: ,distribution_id NUMBER := FND_API.G_MISS_NUM

344: TYPE distribution_rec IS RECORD
345: (
346: asset_id NUMBER := FND_API.G_MISS_NUM
347: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
348: ,distribution_id NUMBER := FND_API.G_MISS_NUM
349: ,location_id NUMBER := FND_API.G_MISS_NUM
350: ,employee_id NUMBER := FND_API.G_MISS_NUM
351: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
352: ,current_units NUMBER := FND_API.G_MISS_NUM

Line 349: ,location_id NUMBER := FND_API.G_MISS_NUM

345: (
346: asset_id NUMBER := FND_API.G_MISS_NUM
347: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
348: ,distribution_id NUMBER := FND_API.G_MISS_NUM
349: ,location_id NUMBER := FND_API.G_MISS_NUM
350: ,employee_id NUMBER := FND_API.G_MISS_NUM
351: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
352: ,current_units NUMBER := FND_API.G_MISS_NUM
353: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM

Line 350: ,employee_id NUMBER := FND_API.G_MISS_NUM

346: asset_id NUMBER := FND_API.G_MISS_NUM
347: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
348: ,distribution_id NUMBER := FND_API.G_MISS_NUM
349: ,location_id NUMBER := FND_API.G_MISS_NUM
350: ,employee_id NUMBER := FND_API.G_MISS_NUM
351: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
352: ,current_units NUMBER := FND_API.G_MISS_NUM
353: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM
354: );

Line 351: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM

347: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
348: ,distribution_id NUMBER := FND_API.G_MISS_NUM
349: ,location_id NUMBER := FND_API.G_MISS_NUM
350: ,employee_id NUMBER := FND_API.G_MISS_NUM
351: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
352: ,current_units NUMBER := FND_API.G_MISS_NUM
353: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM
354: );
355:

Line 352: ,current_units NUMBER := FND_API.G_MISS_NUM

348: ,distribution_id NUMBER := FND_API.G_MISS_NUM
349: ,location_id NUMBER := FND_API.G_MISS_NUM
350: ,employee_id NUMBER := FND_API.G_MISS_NUM
351: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
352: ,current_units NUMBER := FND_API.G_MISS_NUM
353: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM
354: );
355:
356: TYPE distribution_tbl IS TABLE OF distribution_rec

Line 353: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM

349: ,location_id NUMBER := FND_API.G_MISS_NUM
350: ,employee_id NUMBER := FND_API.G_MISS_NUM
351: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
352: ,current_units NUMBER := FND_API.G_MISS_NUM
353: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM
354: );
355:
356: TYPE distribution_tbl IS TABLE OF distribution_rec
357: INDEX BY BINARY_INTEGER ;