eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR, --bug 10322621

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: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR, --bug 10322621
68: HR_LOCATION_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: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR, --bug 10322621
68: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
69: PO_DISTRIBUTION_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: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR, --bug 10322621
68: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
69: PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
70: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 67: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR, --bug 10322621

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: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR, --bug 10322621
68: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
69: PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
70: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
71: SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 68: HR_LOCATION_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: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR, --bug 10322621
68: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
69: PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
70: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
71: SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,

Line 69: PO_DISTRIBUTION_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: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR, --bug 10322621
68: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
69: PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
70: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
71: SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
73: MOVE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,

Line 70: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,

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

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

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

Line 72: TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,

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

Line 73: MOVE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,

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

Line 74: SERIAL_NUMBER_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,

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

Line 75: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM

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

Line 288: parent_mass_addition_id NUMBER := FND_API.G_MISS_NUM

284: INDEX BY BINARY_INTEGER;
285:
286: TYPE asset_query_rec IS RECORD
287: (
288: parent_mass_addition_id NUMBER := FND_API.G_MISS_NUM
289: ,mass_addition_id NUMBER := FND_API.G_MISS_NUM
290: ,asset_id NUMBER := FND_API.G_MISS_NUM
291: ,search_method VARCHAR2(4) := FND_API.G_MISS_CHAR
292: ,asset_number VARCHAR2(15) := FND_API.G_MISS_CHAR

Line 289: ,mass_addition_id NUMBER := FND_API.G_MISS_NUM

285:
286: TYPE asset_query_rec IS RECORD
287: (
288: parent_mass_addition_id NUMBER := FND_API.G_MISS_NUM
289: ,mass_addition_id NUMBER := FND_API.G_MISS_NUM
290: ,asset_id NUMBER := FND_API.G_MISS_NUM
291: ,search_method VARCHAR2(4) := FND_API.G_MISS_CHAR
292: ,asset_number VARCHAR2(15) := FND_API.G_MISS_CHAR
293: ,category_id NUMBER := FND_API.G_MISS_NUM

Line 290: ,asset_id NUMBER := FND_API.G_MISS_NUM

286: TYPE asset_query_rec IS RECORD
287: (
288: parent_mass_addition_id NUMBER := FND_API.G_MISS_NUM
289: ,mass_addition_id NUMBER := FND_API.G_MISS_NUM
290: ,asset_id NUMBER := FND_API.G_MISS_NUM
291: ,search_method VARCHAR2(4) := FND_API.G_MISS_CHAR
292: ,asset_number VARCHAR2(15) := FND_API.G_MISS_CHAR
293: ,category_id NUMBER := FND_API.G_MISS_NUM
294: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR

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

287: (
288: parent_mass_addition_id NUMBER := FND_API.G_MISS_NUM
289: ,mass_addition_id NUMBER := FND_API.G_MISS_NUM
290: ,asset_id NUMBER := FND_API.G_MISS_NUM
291: ,search_method VARCHAR2(4) := FND_API.G_MISS_CHAR
292: ,asset_number VARCHAR2(15) := FND_API.G_MISS_CHAR
293: ,category_id NUMBER := FND_API.G_MISS_NUM
294: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
295: ,date_placed_in_service DATE := FND_API.G_MISS_DATE

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

288: parent_mass_addition_id NUMBER := FND_API.G_MISS_NUM
289: ,mass_addition_id NUMBER := FND_API.G_MISS_NUM
290: ,asset_id NUMBER := FND_API.G_MISS_NUM
291: ,search_method VARCHAR2(4) := FND_API.G_MISS_CHAR
292: ,asset_number VARCHAR2(15) := FND_API.G_MISS_CHAR
293: ,category_id NUMBER := FND_API.G_MISS_NUM
294: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
295: ,date_placed_in_service DATE := FND_API.G_MISS_DATE
296: ,asset_key_ccid NUMBER := FND_API.G_MISS_NUM

Line 293: ,category_id NUMBER := FND_API.G_MISS_NUM

289: ,mass_addition_id NUMBER := FND_API.G_MISS_NUM
290: ,asset_id NUMBER := FND_API.G_MISS_NUM
291: ,search_method VARCHAR2(4) := FND_API.G_MISS_CHAR
292: ,asset_number VARCHAR2(15) := FND_API.G_MISS_CHAR
293: ,category_id NUMBER := FND_API.G_MISS_NUM
294: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
295: ,date_placed_in_service DATE := FND_API.G_MISS_DATE
296: ,asset_key_ccid NUMBER := FND_API.G_MISS_NUM
297: ,tag_number VARCHAR2(15) := FND_API.G_MISS_CHAR

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

290: ,asset_id NUMBER := FND_API.G_MISS_NUM
291: ,search_method VARCHAR2(4) := FND_API.G_MISS_CHAR
292: ,asset_number VARCHAR2(15) := FND_API.G_MISS_CHAR
293: ,category_id NUMBER := FND_API.G_MISS_NUM
294: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
295: ,date_placed_in_service DATE := FND_API.G_MISS_DATE
296: ,asset_key_ccid NUMBER := FND_API.G_MISS_NUM
297: ,tag_number VARCHAR2(15) := FND_API.G_MISS_CHAR
298: ,description VARCHAR2(80) := FND_API.G_MISS_CHAR

Line 295: ,date_placed_in_service DATE := FND_API.G_MISS_DATE

291: ,search_method VARCHAR2(4) := FND_API.G_MISS_CHAR
292: ,asset_number VARCHAR2(15) := FND_API.G_MISS_CHAR
293: ,category_id NUMBER := FND_API.G_MISS_NUM
294: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
295: ,date_placed_in_service DATE := FND_API.G_MISS_DATE
296: ,asset_key_ccid NUMBER := FND_API.G_MISS_NUM
297: ,tag_number VARCHAR2(15) := FND_API.G_MISS_CHAR
298: ,description VARCHAR2(80) := FND_API.G_MISS_CHAR
299: ,manufacturer_name VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 296: ,asset_key_ccid NUMBER := FND_API.G_MISS_NUM

292: ,asset_number VARCHAR2(15) := FND_API.G_MISS_CHAR
293: ,category_id NUMBER := FND_API.G_MISS_NUM
294: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
295: ,date_placed_in_service DATE := FND_API.G_MISS_DATE
296: ,asset_key_ccid NUMBER := FND_API.G_MISS_NUM
297: ,tag_number VARCHAR2(15) := FND_API.G_MISS_CHAR
298: ,description VARCHAR2(80) := FND_API.G_MISS_CHAR
299: ,manufacturer_name VARCHAR2(30) := FND_API.G_MISS_CHAR
300: ,serial_number VARCHAR2(35) := FND_API.G_MISS_CHAR

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

293: ,category_id NUMBER := FND_API.G_MISS_NUM
294: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
295: ,date_placed_in_service DATE := FND_API.G_MISS_DATE
296: ,asset_key_ccid NUMBER := FND_API.G_MISS_NUM
297: ,tag_number VARCHAR2(15) := FND_API.G_MISS_CHAR
298: ,description VARCHAR2(80) := FND_API.G_MISS_CHAR
299: ,manufacturer_name VARCHAR2(30) := FND_API.G_MISS_CHAR
300: ,serial_number VARCHAR2(35) := FND_API.G_MISS_CHAR
301: ,model_number VARCHAR2(40) := FND_API.G_MISS_CHAR

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

294: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
295: ,date_placed_in_service DATE := FND_API.G_MISS_DATE
296: ,asset_key_ccid NUMBER := FND_API.G_MISS_NUM
297: ,tag_number VARCHAR2(15) := FND_API.G_MISS_CHAR
298: ,description VARCHAR2(80) := FND_API.G_MISS_CHAR
299: ,manufacturer_name VARCHAR2(30) := FND_API.G_MISS_CHAR
300: ,serial_number VARCHAR2(35) := FND_API.G_MISS_CHAR
301: ,model_number VARCHAR2(40) := FND_API.G_MISS_CHAR
302: ,location_id NUMBER := FND_API.G_MISS_NUM

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

295: ,date_placed_in_service DATE := FND_API.G_MISS_DATE
296: ,asset_key_ccid NUMBER := FND_API.G_MISS_NUM
297: ,tag_number VARCHAR2(15) := FND_API.G_MISS_CHAR
298: ,description VARCHAR2(80) := FND_API.G_MISS_CHAR
299: ,manufacturer_name VARCHAR2(30) := FND_API.G_MISS_CHAR
300: ,serial_number VARCHAR2(35) := FND_API.G_MISS_CHAR
301: ,model_number VARCHAR2(40) := FND_API.G_MISS_CHAR
302: ,location_id NUMBER := FND_API.G_MISS_NUM
303: ,employee_id NUMBER := FND_API.G_MISS_NUM

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

296: ,asset_key_ccid NUMBER := FND_API.G_MISS_NUM
297: ,tag_number VARCHAR2(15) := FND_API.G_MISS_CHAR
298: ,description VARCHAR2(80) := FND_API.G_MISS_CHAR
299: ,manufacturer_name VARCHAR2(30) := FND_API.G_MISS_CHAR
300: ,serial_number VARCHAR2(35) := FND_API.G_MISS_CHAR
301: ,model_number VARCHAR2(40) := FND_API.G_MISS_CHAR
302: ,location_id NUMBER := FND_API.G_MISS_NUM
303: ,employee_id NUMBER := FND_API.G_MISS_NUM
304: ,deprn_employee_id NUMBER := FND_API.G_MISS_NUM

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

297: ,tag_number VARCHAR2(15) := FND_API.G_MISS_CHAR
298: ,description VARCHAR2(80) := FND_API.G_MISS_CHAR
299: ,manufacturer_name VARCHAR2(30) := FND_API.G_MISS_CHAR
300: ,serial_number VARCHAR2(35) := FND_API.G_MISS_CHAR
301: ,model_number VARCHAR2(40) := FND_API.G_MISS_CHAR
302: ,location_id NUMBER := FND_API.G_MISS_NUM
303: ,employee_id NUMBER := FND_API.G_MISS_NUM
304: ,deprn_employee_id NUMBER := FND_API.G_MISS_NUM
305: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM

Line 302: ,location_id NUMBER := FND_API.G_MISS_NUM

298: ,description VARCHAR2(80) := FND_API.G_MISS_CHAR
299: ,manufacturer_name VARCHAR2(30) := FND_API.G_MISS_CHAR
300: ,serial_number VARCHAR2(35) := FND_API.G_MISS_CHAR
301: ,model_number VARCHAR2(40) := FND_API.G_MISS_CHAR
302: ,location_id NUMBER := FND_API.G_MISS_NUM
303: ,employee_id NUMBER := FND_API.G_MISS_NUM
304: ,deprn_employee_id NUMBER := FND_API.G_MISS_NUM
305: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
306: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM

Line 303: ,employee_id NUMBER := FND_API.G_MISS_NUM

299: ,manufacturer_name VARCHAR2(30) := FND_API.G_MISS_CHAR
300: ,serial_number VARCHAR2(35) := FND_API.G_MISS_CHAR
301: ,model_number VARCHAR2(40) := FND_API.G_MISS_CHAR
302: ,location_id NUMBER := FND_API.G_MISS_NUM
303: ,employee_id NUMBER := FND_API.G_MISS_NUM
304: ,deprn_employee_id NUMBER := FND_API.G_MISS_NUM
305: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
306: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM
307: ,distribution_id NUMBER := FND_API.G_MISS_NUM

Line 304: ,deprn_employee_id NUMBER := FND_API.G_MISS_NUM

300: ,serial_number VARCHAR2(35) := FND_API.G_MISS_CHAR
301: ,model_number VARCHAR2(40) := FND_API.G_MISS_CHAR
302: ,location_id NUMBER := FND_API.G_MISS_NUM
303: ,employee_id NUMBER := FND_API.G_MISS_NUM
304: ,deprn_employee_id NUMBER := FND_API.G_MISS_NUM
305: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
306: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM
307: ,distribution_id NUMBER := FND_API.G_MISS_NUM
308: ,current_mtl_cost NUMBER := FND_API.G_MISS_NUM

Line 305: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM

301: ,model_number VARCHAR2(40) := FND_API.G_MISS_CHAR
302: ,location_id NUMBER := FND_API.G_MISS_NUM
303: ,employee_id NUMBER := FND_API.G_MISS_NUM
304: ,deprn_employee_id NUMBER := FND_API.G_MISS_NUM
305: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
306: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM
307: ,distribution_id NUMBER := FND_API.G_MISS_NUM
308: ,current_mtl_cost NUMBER := FND_API.G_MISS_NUM
309: ,current_non_mtl_cost NUMBER := FND_API.G_MISS_NUM

Line 306: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM

302: ,location_id NUMBER := FND_API.G_MISS_NUM
303: ,employee_id NUMBER := FND_API.G_MISS_NUM
304: ,deprn_employee_id NUMBER := FND_API.G_MISS_NUM
305: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
306: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM
307: ,distribution_id NUMBER := FND_API.G_MISS_NUM
308: ,current_mtl_cost NUMBER := FND_API.G_MISS_NUM
309: ,current_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
310: ,current_units NUMBER := FND_API.G_MISS_NUM

Line 307: ,distribution_id NUMBER := FND_API.G_MISS_NUM

303: ,employee_id NUMBER := FND_API.G_MISS_NUM
304: ,deprn_employee_id NUMBER := FND_API.G_MISS_NUM
305: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
306: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM
307: ,distribution_id NUMBER := FND_API.G_MISS_NUM
308: ,current_mtl_cost NUMBER := FND_API.G_MISS_NUM
309: ,current_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
310: ,current_units NUMBER := FND_API.G_MISS_NUM
311: ,pending_adj_mtl_cost NUMBER := FND_API.G_MISS_NUM

Line 308: ,current_mtl_cost NUMBER := FND_API.G_MISS_NUM

304: ,deprn_employee_id NUMBER := FND_API.G_MISS_NUM
305: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
306: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM
307: ,distribution_id NUMBER := FND_API.G_MISS_NUM
308: ,current_mtl_cost NUMBER := FND_API.G_MISS_NUM
309: ,current_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
310: ,current_units NUMBER := FND_API.G_MISS_NUM
311: ,pending_adj_mtl_cost NUMBER := FND_API.G_MISS_NUM
312: ,pending_adj_non_mtl_cost NUMBER := FND_API.G_MISS_NUM

Line 309: ,current_non_mtl_cost NUMBER := FND_API.G_MISS_NUM

305: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
306: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM
307: ,distribution_id NUMBER := FND_API.G_MISS_NUM
308: ,current_mtl_cost NUMBER := FND_API.G_MISS_NUM
309: ,current_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
310: ,current_units NUMBER := FND_API.G_MISS_NUM
311: ,pending_adj_mtl_cost NUMBER := FND_API.G_MISS_NUM
312: ,pending_adj_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
313: ,pending_ret_mtl_cost NUMBER := FND_API.G_MISS_NUM

Line 310: ,current_units NUMBER := FND_API.G_MISS_NUM

306: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM
307: ,distribution_id NUMBER := FND_API.G_MISS_NUM
308: ,current_mtl_cost NUMBER := FND_API.G_MISS_NUM
309: ,current_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
310: ,current_units NUMBER := FND_API.G_MISS_NUM
311: ,pending_adj_mtl_cost NUMBER := FND_API.G_MISS_NUM
312: ,pending_adj_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
313: ,pending_ret_mtl_cost NUMBER := FND_API.G_MISS_NUM
314: ,pending_ret_non_mtl_cost NUMBER := FND_API.G_MISS_NUM

Line 311: ,pending_adj_mtl_cost NUMBER := FND_API.G_MISS_NUM

307: ,distribution_id NUMBER := FND_API.G_MISS_NUM
308: ,current_mtl_cost NUMBER := FND_API.G_MISS_NUM
309: ,current_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
310: ,current_units NUMBER := FND_API.G_MISS_NUM
311: ,pending_adj_mtl_cost NUMBER := FND_API.G_MISS_NUM
312: ,pending_adj_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
313: ,pending_ret_mtl_cost NUMBER := FND_API.G_MISS_NUM
314: ,pending_ret_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
315: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM

Line 312: ,pending_adj_non_mtl_cost NUMBER := FND_API.G_MISS_NUM

308: ,current_mtl_cost NUMBER := FND_API.G_MISS_NUM
309: ,current_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
310: ,current_units NUMBER := FND_API.G_MISS_NUM
311: ,pending_adj_mtl_cost NUMBER := FND_API.G_MISS_NUM
312: ,pending_adj_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
313: ,pending_ret_mtl_cost NUMBER := FND_API.G_MISS_NUM
314: ,pending_ret_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
315: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM
316: );

Line 313: ,pending_ret_mtl_cost NUMBER := FND_API.G_MISS_NUM

309: ,current_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
310: ,current_units NUMBER := FND_API.G_MISS_NUM
311: ,pending_adj_mtl_cost NUMBER := FND_API.G_MISS_NUM
312: ,pending_adj_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
313: ,pending_ret_mtl_cost NUMBER := FND_API.G_MISS_NUM
314: ,pending_ret_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
315: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM
316: );
317:

Line 314: ,pending_ret_non_mtl_cost NUMBER := FND_API.G_MISS_NUM

310: ,current_units NUMBER := FND_API.G_MISS_NUM
311: ,pending_adj_mtl_cost NUMBER := FND_API.G_MISS_NUM
312: ,pending_adj_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
313: ,pending_ret_mtl_cost NUMBER := FND_API.G_MISS_NUM
314: ,pending_ret_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
315: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM
316: );
317:
318: TYPE asset_query_tbl IS TABLE OF asset_query_rec

Line 315: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM

311: ,pending_adj_mtl_cost NUMBER := FND_API.G_MISS_NUM
312: ,pending_adj_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
313: ,pending_ret_mtl_cost NUMBER := FND_API.G_MISS_NUM
314: ,pending_ret_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
315: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM
316: );
317:
318: TYPE asset_query_tbl IS TABLE OF asset_query_rec
319: INDEX BY BINARY_INTEGER;

Line 325: Instance_ID NUMBER := FND_API.G_MISS_NUM

321:
322: --bnarayan added for R12
323: TYPE asset_attrib_rec IS RECORD
324: (
325: Instance_ID NUMBER := FND_API.G_MISS_NUM
326: ,Inventory_Item_ID NUMBER := FND_API.G_MISS_NUM
327: ,Serial_Number VARCHAR2(30) := FND_API.G_MISS_CHAR
328: ,Organization_ID NUMBER := FND_API.G_MISS_NUM
329: ,INV_MASTER_Organization_ID NUMBER := FND_API.G_MISS_NUM

Line 326: ,Inventory_Item_ID NUMBER := FND_API.G_MISS_NUM

322: --bnarayan added for R12
323: TYPE asset_attrib_rec IS RECORD
324: (
325: Instance_ID NUMBER := FND_API.G_MISS_NUM
326: ,Inventory_Item_ID NUMBER := FND_API.G_MISS_NUM
327: ,Serial_Number VARCHAR2(30) := FND_API.G_MISS_CHAR
328: ,Organization_ID NUMBER := FND_API.G_MISS_NUM
329: ,INV_MASTER_Organization_ID NUMBER := FND_API.G_MISS_NUM
330: ,Subinventory_Name VARCHAR2(30) := FND_API.G_MISS_CHAR

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

323: TYPE asset_attrib_rec IS RECORD
324: (
325: Instance_ID NUMBER := FND_API.G_MISS_NUM
326: ,Inventory_Item_ID NUMBER := FND_API.G_MISS_NUM
327: ,Serial_Number VARCHAR2(30) := FND_API.G_MISS_CHAR
328: ,Organization_ID NUMBER := FND_API.G_MISS_NUM
329: ,INV_MASTER_Organization_ID NUMBER := FND_API.G_MISS_NUM
330: ,Subinventory_Name VARCHAR2(30) := FND_API.G_MISS_CHAR
331: ,Transaction_Quantity NUMBER := FND_API.G_MISS_NUM

Line 328: ,Organization_ID NUMBER := FND_API.G_MISS_NUM

324: (
325: Instance_ID NUMBER := FND_API.G_MISS_NUM
326: ,Inventory_Item_ID NUMBER := FND_API.G_MISS_NUM
327: ,Serial_Number VARCHAR2(30) := FND_API.G_MISS_CHAR
328: ,Organization_ID NUMBER := FND_API.G_MISS_NUM
329: ,INV_MASTER_Organization_ID NUMBER := FND_API.G_MISS_NUM
330: ,Subinventory_Name VARCHAR2(30) := FND_API.G_MISS_CHAR
331: ,Transaction_Quantity NUMBER := FND_API.G_MISS_NUM
332: ,Transaction_ID NUMBER := FND_API.G_MISS_NUM

Line 329: ,INV_MASTER_Organization_ID NUMBER := FND_API.G_MISS_NUM

325: Instance_ID NUMBER := FND_API.G_MISS_NUM
326: ,Inventory_Item_ID NUMBER := FND_API.G_MISS_NUM
327: ,Serial_Number VARCHAR2(30) := FND_API.G_MISS_CHAR
328: ,Organization_ID NUMBER := FND_API.G_MISS_NUM
329: ,INV_MASTER_Organization_ID NUMBER := FND_API.G_MISS_NUM
330: ,Subinventory_Name VARCHAR2(30) := FND_API.G_MISS_CHAR
331: ,Transaction_Quantity NUMBER := FND_API.G_MISS_NUM
332: ,Transaction_ID NUMBER := FND_API.G_MISS_NUM
333: ,Transaction_Date DATE := FND_API.G_MISS_DATE

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

326: ,Inventory_Item_ID NUMBER := FND_API.G_MISS_NUM
327: ,Serial_Number VARCHAR2(30) := FND_API.G_MISS_CHAR
328: ,Organization_ID NUMBER := FND_API.G_MISS_NUM
329: ,INV_MASTER_Organization_ID NUMBER := FND_API.G_MISS_NUM
330: ,Subinventory_Name VARCHAR2(30) := FND_API.G_MISS_CHAR
331: ,Transaction_Quantity NUMBER := FND_API.G_MISS_NUM
332: ,Transaction_ID NUMBER := FND_API.G_MISS_NUM
333: ,Transaction_Date DATE := FND_API.G_MISS_DATE
334: ,Source_Transaction_type VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 331: ,Transaction_Quantity NUMBER := FND_API.G_MISS_NUM

327: ,Serial_Number VARCHAR2(30) := FND_API.G_MISS_CHAR
328: ,Organization_ID NUMBER := FND_API.G_MISS_NUM
329: ,INV_MASTER_Organization_ID NUMBER := FND_API.G_MISS_NUM
330: ,Subinventory_Name VARCHAR2(30) := FND_API.G_MISS_CHAR
331: ,Transaction_Quantity NUMBER := FND_API.G_MISS_NUM
332: ,Transaction_ID NUMBER := FND_API.G_MISS_NUM
333: ,Transaction_Date DATE := FND_API.G_MISS_DATE
334: ,Source_Transaction_type VARCHAR2(30) := FND_API.G_MISS_CHAR
335: ,Depreciable_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 332: ,Transaction_ID NUMBER := FND_API.G_MISS_NUM

328: ,Organization_ID NUMBER := FND_API.G_MISS_NUM
329: ,INV_MASTER_Organization_ID NUMBER := FND_API.G_MISS_NUM
330: ,Subinventory_Name VARCHAR2(30) := FND_API.G_MISS_CHAR
331: ,Transaction_Quantity NUMBER := FND_API.G_MISS_NUM
332: ,Transaction_ID NUMBER := FND_API.G_MISS_NUM
333: ,Transaction_Date DATE := FND_API.G_MISS_DATE
334: ,Source_Transaction_type VARCHAR2(30) := FND_API.G_MISS_CHAR
335: ,Depreciable_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR
336: ,Location_Type_Code VARCHAR2(40) := FND_API.G_MISS_CHAR

Line 333: ,Transaction_Date DATE := FND_API.G_MISS_DATE

329: ,INV_MASTER_Organization_ID NUMBER := FND_API.G_MISS_NUM
330: ,Subinventory_Name VARCHAR2(30) := FND_API.G_MISS_CHAR
331: ,Transaction_Quantity NUMBER := FND_API.G_MISS_NUM
332: ,Transaction_ID NUMBER := FND_API.G_MISS_NUM
333: ,Transaction_Date DATE := FND_API.G_MISS_DATE
334: ,Source_Transaction_type VARCHAR2(30) := FND_API.G_MISS_CHAR
335: ,Depreciable_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR
336: ,Location_Type_Code VARCHAR2(40) := FND_API.G_MISS_CHAR
337: ,Transaction_Type_ID NUMBER := FND_API.G_MISS_NUM

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

330: ,Subinventory_Name VARCHAR2(30) := FND_API.G_MISS_CHAR
331: ,Transaction_Quantity NUMBER := FND_API.G_MISS_NUM
332: ,Transaction_ID NUMBER := FND_API.G_MISS_NUM
333: ,Transaction_Date DATE := FND_API.G_MISS_DATE
334: ,Source_Transaction_type VARCHAR2(30) := FND_API.G_MISS_CHAR
335: ,Depreciable_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR
336: ,Location_Type_Code VARCHAR2(40) := FND_API.G_MISS_CHAR
337: ,Transaction_Type_ID NUMBER := FND_API.G_MISS_NUM
338: ,Source_Header_Ref_ID NUMBER := FND_API.G_MISS_NUM

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

331: ,Transaction_Quantity NUMBER := FND_API.G_MISS_NUM
332: ,Transaction_ID NUMBER := FND_API.G_MISS_NUM
333: ,Transaction_Date DATE := FND_API.G_MISS_DATE
334: ,Source_Transaction_type VARCHAR2(30) := FND_API.G_MISS_CHAR
335: ,Depreciable_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR
336: ,Location_Type_Code VARCHAR2(40) := FND_API.G_MISS_CHAR
337: ,Transaction_Type_ID NUMBER := FND_API.G_MISS_NUM
338: ,Source_Header_Ref_ID NUMBER := FND_API.G_MISS_NUM
339: ,RCV_Transaction_ID NUMBER := FND_API.G_MISS_NUM

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

332: ,Transaction_ID NUMBER := FND_API.G_MISS_NUM
333: ,Transaction_Date DATE := FND_API.G_MISS_DATE
334: ,Source_Transaction_type VARCHAR2(30) := FND_API.G_MISS_CHAR
335: ,Depreciable_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR
336: ,Location_Type_Code VARCHAR2(40) := FND_API.G_MISS_CHAR
337: ,Transaction_Type_ID NUMBER := FND_API.G_MISS_NUM
338: ,Source_Header_Ref_ID NUMBER := FND_API.G_MISS_NUM
339: ,RCV_Transaction_ID NUMBER := FND_API.G_MISS_NUM
340: ,PO_Distribution_Id NUMBER := FND_API.G_MISS_NUM

Line 337: ,Transaction_Type_ID NUMBER := FND_API.G_MISS_NUM

333: ,Transaction_Date DATE := FND_API.G_MISS_DATE
334: ,Source_Transaction_type VARCHAR2(30) := FND_API.G_MISS_CHAR
335: ,Depreciable_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR
336: ,Location_Type_Code VARCHAR2(40) := FND_API.G_MISS_CHAR
337: ,Transaction_Type_ID NUMBER := FND_API.G_MISS_NUM
338: ,Source_Header_Ref_ID NUMBER := FND_API.G_MISS_NUM
339: ,RCV_Transaction_ID NUMBER := FND_API.G_MISS_NUM
340: ,PO_Distribution_Id NUMBER := FND_API.G_MISS_NUM
341: ,Inv_Material_Transaction_ID NUMBER := FND_API.G_MISS_NUM

Line 338: ,Source_Header_Ref_ID NUMBER := FND_API.G_MISS_NUM

334: ,Source_Transaction_type VARCHAR2(30) := FND_API.G_MISS_CHAR
335: ,Depreciable_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR
336: ,Location_Type_Code VARCHAR2(40) := FND_API.G_MISS_CHAR
337: ,Transaction_Type_ID NUMBER := FND_API.G_MISS_NUM
338: ,Source_Header_Ref_ID NUMBER := FND_API.G_MISS_NUM
339: ,RCV_Transaction_ID NUMBER := FND_API.G_MISS_NUM
340: ,PO_Distribution_Id NUMBER := FND_API.G_MISS_NUM
341: ,Inv_Material_Transaction_ID NUMBER := FND_API.G_MISS_NUM
342: ,Location_id NUMBER := FND_API.G_MISS_NUM

Line 339: ,RCV_Transaction_ID NUMBER := FND_API.G_MISS_NUM

335: ,Depreciable_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR
336: ,Location_Type_Code VARCHAR2(40) := FND_API.G_MISS_CHAR
337: ,Transaction_Type_ID NUMBER := FND_API.G_MISS_NUM
338: ,Source_Header_Ref_ID NUMBER := FND_API.G_MISS_NUM
339: ,RCV_Transaction_ID NUMBER := FND_API.G_MISS_NUM
340: ,PO_Distribution_Id NUMBER := FND_API.G_MISS_NUM
341: ,Inv_Material_Transaction_ID NUMBER := FND_API.G_MISS_NUM
342: ,Location_id NUMBER := FND_API.G_MISS_NUM
343: ,Asset_Category_ID NUMBER := FND_API.G_MISS_NUM

Line 340: ,PO_Distribution_Id NUMBER := FND_API.G_MISS_NUM

336: ,Location_Type_Code VARCHAR2(40) := FND_API.G_MISS_CHAR
337: ,Transaction_Type_ID NUMBER := FND_API.G_MISS_NUM
338: ,Source_Header_Ref_ID NUMBER := FND_API.G_MISS_NUM
339: ,RCV_Transaction_ID NUMBER := FND_API.G_MISS_NUM
340: ,PO_Distribution_Id NUMBER := FND_API.G_MISS_NUM
341: ,Inv_Material_Transaction_ID NUMBER := FND_API.G_MISS_NUM
342: ,Location_id NUMBER := FND_API.G_MISS_NUM
343: ,Asset_Category_ID NUMBER := FND_API.G_MISS_NUM
344: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR

Line 341: ,Inv_Material_Transaction_ID NUMBER := FND_API.G_MISS_NUM

337: ,Transaction_Type_ID NUMBER := FND_API.G_MISS_NUM
338: ,Source_Header_Ref_ID NUMBER := FND_API.G_MISS_NUM
339: ,RCV_Transaction_ID NUMBER := FND_API.G_MISS_NUM
340: ,PO_Distribution_Id NUMBER := FND_API.G_MISS_NUM
341: ,Inv_Material_Transaction_ID NUMBER := FND_API.G_MISS_NUM
342: ,Location_id NUMBER := FND_API.G_MISS_NUM
343: ,Asset_Category_ID NUMBER := FND_API.G_MISS_NUM
344: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
345:

Line 342: ,Location_id NUMBER := FND_API.G_MISS_NUM

338: ,Source_Header_Ref_ID NUMBER := FND_API.G_MISS_NUM
339: ,RCV_Transaction_ID NUMBER := FND_API.G_MISS_NUM
340: ,PO_Distribution_Id NUMBER := FND_API.G_MISS_NUM
341: ,Inv_Material_Transaction_ID NUMBER := FND_API.G_MISS_NUM
342: ,Location_id NUMBER := FND_API.G_MISS_NUM
343: ,Asset_Category_ID NUMBER := FND_API.G_MISS_NUM
344: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
345:
346: );

Line 343: ,Asset_Category_ID NUMBER := FND_API.G_MISS_NUM

339: ,RCV_Transaction_ID NUMBER := FND_API.G_MISS_NUM
340: ,PO_Distribution_Id NUMBER := FND_API.G_MISS_NUM
341: ,Inv_Material_Transaction_ID NUMBER := FND_API.G_MISS_NUM
342: ,Location_id NUMBER := FND_API.G_MISS_NUM
343: ,Asset_Category_ID NUMBER := FND_API.G_MISS_NUM
344: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
345:
346: );
347:

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

340: ,PO_Distribution_Id NUMBER := FND_API.G_MISS_NUM
341: ,Inv_Material_Transaction_ID NUMBER := FND_API.G_MISS_NUM
342: ,Location_id NUMBER := FND_API.G_MISS_NUM
343: ,Asset_Category_ID NUMBER := FND_API.G_MISS_NUM
344: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
345:
346: );
347:
348:

Line 357: asset_id NUMBER := FND_API.G_MISS_NUM

353:
354:
355: TYPE distribution_rec IS RECORD
356: (
357: asset_id NUMBER := FND_API.G_MISS_NUM
358: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
359: ,distribution_id NUMBER := FND_API.G_MISS_NUM
360: ,location_id NUMBER := FND_API.G_MISS_NUM
361: ,employee_id NUMBER := FND_API.G_MISS_NUM

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

354:
355: TYPE distribution_rec IS RECORD
356: (
357: asset_id NUMBER := FND_API.G_MISS_NUM
358: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
359: ,distribution_id NUMBER := FND_API.G_MISS_NUM
360: ,location_id NUMBER := FND_API.G_MISS_NUM
361: ,employee_id NUMBER := FND_API.G_MISS_NUM
362: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM

Line 359: ,distribution_id NUMBER := FND_API.G_MISS_NUM

355: TYPE distribution_rec IS RECORD
356: (
357: asset_id NUMBER := FND_API.G_MISS_NUM
358: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
359: ,distribution_id NUMBER := FND_API.G_MISS_NUM
360: ,location_id NUMBER := FND_API.G_MISS_NUM
361: ,employee_id NUMBER := FND_API.G_MISS_NUM
362: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
363: ,current_units NUMBER := FND_API.G_MISS_NUM

Line 360: ,location_id NUMBER := FND_API.G_MISS_NUM

356: (
357: asset_id NUMBER := FND_API.G_MISS_NUM
358: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
359: ,distribution_id NUMBER := FND_API.G_MISS_NUM
360: ,location_id NUMBER := FND_API.G_MISS_NUM
361: ,employee_id NUMBER := FND_API.G_MISS_NUM
362: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
363: ,current_units NUMBER := FND_API.G_MISS_NUM
364: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM

Line 361: ,employee_id NUMBER := FND_API.G_MISS_NUM

357: asset_id NUMBER := FND_API.G_MISS_NUM
358: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
359: ,distribution_id NUMBER := FND_API.G_MISS_NUM
360: ,location_id NUMBER := FND_API.G_MISS_NUM
361: ,employee_id NUMBER := FND_API.G_MISS_NUM
362: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
363: ,current_units NUMBER := FND_API.G_MISS_NUM
364: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM
365: );

Line 362: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM

358: ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
359: ,distribution_id NUMBER := FND_API.G_MISS_NUM
360: ,location_id NUMBER := FND_API.G_MISS_NUM
361: ,employee_id NUMBER := FND_API.G_MISS_NUM
362: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
363: ,current_units NUMBER := FND_API.G_MISS_NUM
364: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM
365: );
366:

Line 363: ,current_units NUMBER := FND_API.G_MISS_NUM

359: ,distribution_id NUMBER := FND_API.G_MISS_NUM
360: ,location_id NUMBER := FND_API.G_MISS_NUM
361: ,employee_id NUMBER := FND_API.G_MISS_NUM
362: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
363: ,current_units NUMBER := FND_API.G_MISS_NUM
364: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM
365: );
366:
367: TYPE distribution_tbl IS TABLE OF distribution_rec

Line 364: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM

360: ,location_id NUMBER := FND_API.G_MISS_NUM
361: ,employee_id NUMBER := FND_API.G_MISS_NUM
362: ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
363: ,current_units NUMBER := FND_API.G_MISS_NUM
364: ,pending_ret_units NUMBER := FND_API.G_MISS_NUM
365: );
366:
367: TYPE distribution_tbl IS TABLE OF distribution_rec
368: INDEX BY BINARY_INTEGER ;