APPS.WMS_CONTAINER_PVT dependencies on WMS_DATA_TYPE_DEFINITIONS_PUB

Line 38: LPN_ID WMS_Data_Type_Definitions_PUB.NumberTableType

34: /*----------------------------------------------------------------*
35: * Data Types used by container pvt apis
36: *----------------------------------------------------------------*/
37: TYPE LPNBulkRecType is RECORD (
38: LPN_ID WMS_Data_Type_Definitions_PUB.NumberTableType
39: , LICENSE_PLATE_NUMBER WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
40: , PARENT_LPN_ID WMS_Data_Type_Definitions_PUB.NumberTableType
41: , OUTERMOST_LPN_ID WMS_Data_Type_Definitions_PUB.NumberTableType
42: , LPN_CONTEXT WMS_Data_Type_Definitions_PUB.NumberTableType

Line 39: , LICENSE_PLATE_NUMBER WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType

35: * Data Types used by container pvt apis
36: *----------------------------------------------------------------*/
37: TYPE LPNBulkRecType is RECORD (
38: LPN_ID WMS_Data_Type_Definitions_PUB.NumberTableType
39: , LICENSE_PLATE_NUMBER WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
40: , PARENT_LPN_ID WMS_Data_Type_Definitions_PUB.NumberTableType
41: , OUTERMOST_LPN_ID WMS_Data_Type_Definitions_PUB.NumberTableType
42: , LPN_CONTEXT WMS_Data_Type_Definitions_PUB.NumberTableType
43:

Line 40: , PARENT_LPN_ID WMS_Data_Type_Definitions_PUB.NumberTableType

36: *----------------------------------------------------------------*/
37: TYPE LPNBulkRecType is RECORD (
38: LPN_ID WMS_Data_Type_Definitions_PUB.NumberTableType
39: , LICENSE_PLATE_NUMBER WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
40: , PARENT_LPN_ID WMS_Data_Type_Definitions_PUB.NumberTableType
41: , OUTERMOST_LPN_ID WMS_Data_Type_Definitions_PUB.NumberTableType
42: , LPN_CONTEXT WMS_Data_Type_Definitions_PUB.NumberTableType
43:
44: , ORGANIZATION_ID WMS_Data_Type_Definitions_PUB.NumberTableType

Line 41: , OUTERMOST_LPN_ID WMS_Data_Type_Definitions_PUB.NumberTableType

37: TYPE LPNBulkRecType is RECORD (
38: LPN_ID WMS_Data_Type_Definitions_PUB.NumberTableType
39: , LICENSE_PLATE_NUMBER WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
40: , PARENT_LPN_ID WMS_Data_Type_Definitions_PUB.NumberTableType
41: , OUTERMOST_LPN_ID WMS_Data_Type_Definitions_PUB.NumberTableType
42: , LPN_CONTEXT WMS_Data_Type_Definitions_PUB.NumberTableType
43:
44: , ORGANIZATION_ID WMS_Data_Type_Definitions_PUB.NumberTableType
45: , SUBINVENTORY_CODE WMS_Data_Type_Definitions_PUB.Varchar2_10_TableType

Line 42: , LPN_CONTEXT WMS_Data_Type_Definitions_PUB.NumberTableType

38: LPN_ID WMS_Data_Type_Definitions_PUB.NumberTableType
39: , LICENSE_PLATE_NUMBER WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
40: , PARENT_LPN_ID WMS_Data_Type_Definitions_PUB.NumberTableType
41: , OUTERMOST_LPN_ID WMS_Data_Type_Definitions_PUB.NumberTableType
42: , LPN_CONTEXT WMS_Data_Type_Definitions_PUB.NumberTableType
43:
44: , ORGANIZATION_ID WMS_Data_Type_Definitions_PUB.NumberTableType
45: , SUBINVENTORY_CODE WMS_Data_Type_Definitions_PUB.Varchar2_10_TableType
46: , LOCATOR_ID WMS_Data_Type_Definitions_PUB.NumberTableType

Line 44: , ORGANIZATION_ID WMS_Data_Type_Definitions_PUB.NumberTableType

40: , PARENT_LPN_ID WMS_Data_Type_Definitions_PUB.NumberTableType
41: , OUTERMOST_LPN_ID WMS_Data_Type_Definitions_PUB.NumberTableType
42: , LPN_CONTEXT WMS_Data_Type_Definitions_PUB.NumberTableType
43:
44: , ORGANIZATION_ID WMS_Data_Type_Definitions_PUB.NumberTableType
45: , SUBINVENTORY_CODE WMS_Data_Type_Definitions_PUB.Varchar2_10_TableType
46: , LOCATOR_ID WMS_Data_Type_Definitions_PUB.NumberTableType
47:
48: , INVENTORY_ITEM_ID WMS_Data_Type_Definitions_PUB.NumberTableType

Line 45: , SUBINVENTORY_CODE WMS_Data_Type_Definitions_PUB.Varchar2_10_TableType

41: , OUTERMOST_LPN_ID WMS_Data_Type_Definitions_PUB.NumberTableType
42: , LPN_CONTEXT WMS_Data_Type_Definitions_PUB.NumberTableType
43:
44: , ORGANIZATION_ID WMS_Data_Type_Definitions_PUB.NumberTableType
45: , SUBINVENTORY_CODE WMS_Data_Type_Definitions_PUB.Varchar2_10_TableType
46: , LOCATOR_ID WMS_Data_Type_Definitions_PUB.NumberTableType
47:
48: , INVENTORY_ITEM_ID WMS_Data_Type_Definitions_PUB.NumberTableType
49: , REVISION WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType

Line 46: , LOCATOR_ID WMS_Data_Type_Definitions_PUB.NumberTableType

42: , LPN_CONTEXT WMS_Data_Type_Definitions_PUB.NumberTableType
43:
44: , ORGANIZATION_ID WMS_Data_Type_Definitions_PUB.NumberTableType
45: , SUBINVENTORY_CODE WMS_Data_Type_Definitions_PUB.Varchar2_10_TableType
46: , LOCATOR_ID WMS_Data_Type_Definitions_PUB.NumberTableType
47:
48: , INVENTORY_ITEM_ID WMS_Data_Type_Definitions_PUB.NumberTableType
49: , REVISION WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
50: , LOT_NUMBER WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType

Line 48: , INVENTORY_ITEM_ID WMS_Data_Type_Definitions_PUB.NumberTableType

44: , ORGANIZATION_ID WMS_Data_Type_Definitions_PUB.NumberTableType
45: , SUBINVENTORY_CODE WMS_Data_Type_Definitions_PUB.Varchar2_10_TableType
46: , LOCATOR_ID WMS_Data_Type_Definitions_PUB.NumberTableType
47:
48: , INVENTORY_ITEM_ID WMS_Data_Type_Definitions_PUB.NumberTableType
49: , REVISION WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
50: , LOT_NUMBER WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
51: , SERIAL_NUMBER WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
52: , COST_GROUP_ID WMS_Data_Type_Definitions_PUB.NumberTableType

Line 49: , REVISION WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType

45: , SUBINVENTORY_CODE WMS_Data_Type_Definitions_PUB.Varchar2_10_TableType
46: , LOCATOR_ID WMS_Data_Type_Definitions_PUB.NumberTableType
47:
48: , INVENTORY_ITEM_ID WMS_Data_Type_Definitions_PUB.NumberTableType
49: , REVISION WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
50: , LOT_NUMBER WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
51: , SERIAL_NUMBER WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
52: , COST_GROUP_ID WMS_Data_Type_Definitions_PUB.NumberTableType
53:

Line 50: , LOT_NUMBER WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType

46: , LOCATOR_ID WMS_Data_Type_Definitions_PUB.NumberTableType
47:
48: , INVENTORY_ITEM_ID WMS_Data_Type_Definitions_PUB.NumberTableType
49: , REVISION WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
50: , LOT_NUMBER WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
51: , SERIAL_NUMBER WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
52: , COST_GROUP_ID WMS_Data_Type_Definitions_PUB.NumberTableType
53:
54: , TARE_WEIGHT_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType

Line 51: , SERIAL_NUMBER WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType

47:
48: , INVENTORY_ITEM_ID WMS_Data_Type_Definitions_PUB.NumberTableType
49: , REVISION WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
50: , LOT_NUMBER WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
51: , SERIAL_NUMBER WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
52: , COST_GROUP_ID WMS_Data_Type_Definitions_PUB.NumberTableType
53:
54: , TARE_WEIGHT_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
55: , TARE_WEIGHT WMS_Data_Type_Definitions_PUB.NumberTableType

Line 52: , COST_GROUP_ID WMS_Data_Type_Definitions_PUB.NumberTableType

48: , INVENTORY_ITEM_ID WMS_Data_Type_Definitions_PUB.NumberTableType
49: , REVISION WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
50: , LOT_NUMBER WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
51: , SERIAL_NUMBER WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
52: , COST_GROUP_ID WMS_Data_Type_Definitions_PUB.NumberTableType
53:
54: , TARE_WEIGHT_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
55: , TARE_WEIGHT WMS_Data_Type_Definitions_PUB.NumberTableType
56: , GROSS_WEIGHT_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType

Line 54: , TARE_WEIGHT_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType

50: , LOT_NUMBER WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
51: , SERIAL_NUMBER WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
52: , COST_GROUP_ID WMS_Data_Type_Definitions_PUB.NumberTableType
53:
54: , TARE_WEIGHT_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
55: , TARE_WEIGHT WMS_Data_Type_Definitions_PUB.NumberTableType
56: , GROSS_WEIGHT_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
57: , GROSS_WEIGHT WMS_Data_Type_Definitions_PUB.NumberTableType
58: , CONTAINER_VOLUME_UOM WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType

Line 55: , TARE_WEIGHT WMS_Data_Type_Definitions_PUB.NumberTableType

51: , SERIAL_NUMBER WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
52: , COST_GROUP_ID WMS_Data_Type_Definitions_PUB.NumberTableType
53:
54: , TARE_WEIGHT_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
55: , TARE_WEIGHT WMS_Data_Type_Definitions_PUB.NumberTableType
56: , GROSS_WEIGHT_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
57: , GROSS_WEIGHT WMS_Data_Type_Definitions_PUB.NumberTableType
58: , CONTAINER_VOLUME_UOM WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
59: , CONTAINER_VOLUME WMS_Data_Type_Definitions_PUB.NumberTableType

Line 56: , GROSS_WEIGHT_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType

52: , COST_GROUP_ID WMS_Data_Type_Definitions_PUB.NumberTableType
53:
54: , TARE_WEIGHT_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
55: , TARE_WEIGHT WMS_Data_Type_Definitions_PUB.NumberTableType
56: , GROSS_WEIGHT_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
57: , GROSS_WEIGHT WMS_Data_Type_Definitions_PUB.NumberTableType
58: , CONTAINER_VOLUME_UOM WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
59: , CONTAINER_VOLUME WMS_Data_Type_Definitions_PUB.NumberTableType
60: , CONTENT_VOLUME_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType

Line 57: , GROSS_WEIGHT WMS_Data_Type_Definitions_PUB.NumberTableType

53:
54: , TARE_WEIGHT_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
55: , TARE_WEIGHT WMS_Data_Type_Definitions_PUB.NumberTableType
56: , GROSS_WEIGHT_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
57: , GROSS_WEIGHT WMS_Data_Type_Definitions_PUB.NumberTableType
58: , CONTAINER_VOLUME_UOM WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
59: , CONTAINER_VOLUME WMS_Data_Type_Definitions_PUB.NumberTableType
60: , CONTENT_VOLUME_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
61: , CONTENT_VOLUME WMS_Data_Type_Definitions_PUB.NumberTableType

Line 58: , CONTAINER_VOLUME_UOM WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType

54: , TARE_WEIGHT_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
55: , TARE_WEIGHT WMS_Data_Type_Definitions_PUB.NumberTableType
56: , GROSS_WEIGHT_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
57: , GROSS_WEIGHT WMS_Data_Type_Definitions_PUB.NumberTableType
58: , CONTAINER_VOLUME_UOM WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
59: , CONTAINER_VOLUME WMS_Data_Type_Definitions_PUB.NumberTableType
60: , CONTENT_VOLUME_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
61: , CONTENT_VOLUME WMS_Data_Type_Definitions_PUB.NumberTableType
62:

Line 59: , CONTAINER_VOLUME WMS_Data_Type_Definitions_PUB.NumberTableType

55: , TARE_WEIGHT WMS_Data_Type_Definitions_PUB.NumberTableType
56: , GROSS_WEIGHT_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
57: , GROSS_WEIGHT WMS_Data_Type_Definitions_PUB.NumberTableType
58: , CONTAINER_VOLUME_UOM WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
59: , CONTAINER_VOLUME WMS_Data_Type_Definitions_PUB.NumberTableType
60: , CONTENT_VOLUME_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
61: , CONTENT_VOLUME WMS_Data_Type_Definitions_PUB.NumberTableType
62:
63: , SOURCE_TYPE_ID WMS_Data_Type_Definitions_PUB.NumberTableType

Line 60: , CONTENT_VOLUME_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType

56: , GROSS_WEIGHT_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
57: , GROSS_WEIGHT WMS_Data_Type_Definitions_PUB.NumberTableType
58: , CONTAINER_VOLUME_UOM WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
59: , CONTAINER_VOLUME WMS_Data_Type_Definitions_PUB.NumberTableType
60: , CONTENT_VOLUME_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
61: , CONTENT_VOLUME WMS_Data_Type_Definitions_PUB.NumberTableType
62:
63: , SOURCE_TYPE_ID WMS_Data_Type_Definitions_PUB.NumberTableType
64: , SOURCE_HEADER_ID WMS_Data_Type_Definitions_PUB.NumberTableType

Line 61: , CONTENT_VOLUME WMS_Data_Type_Definitions_PUB.NumberTableType

57: , GROSS_WEIGHT WMS_Data_Type_Definitions_PUB.NumberTableType
58: , CONTAINER_VOLUME_UOM WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
59: , CONTAINER_VOLUME WMS_Data_Type_Definitions_PUB.NumberTableType
60: , CONTENT_VOLUME_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
61: , CONTENT_VOLUME WMS_Data_Type_Definitions_PUB.NumberTableType
62:
63: , SOURCE_TYPE_ID WMS_Data_Type_Definitions_PUB.NumberTableType
64: , SOURCE_HEADER_ID WMS_Data_Type_Definitions_PUB.NumberTableType
65: , SOURCE_LINE_ID WMS_Data_Type_Definitions_PUB.NumberTableType

Line 63: , SOURCE_TYPE_ID WMS_Data_Type_Definitions_PUB.NumberTableType

59: , CONTAINER_VOLUME WMS_Data_Type_Definitions_PUB.NumberTableType
60: , CONTENT_VOLUME_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
61: , CONTENT_VOLUME WMS_Data_Type_Definitions_PUB.NumberTableType
62:
63: , SOURCE_TYPE_ID WMS_Data_Type_Definitions_PUB.NumberTableType
64: , SOURCE_HEADER_ID WMS_Data_Type_Definitions_PUB.NumberTableType
65: , SOURCE_LINE_ID WMS_Data_Type_Definitions_PUB.NumberTableType
66: , SOURCE_LINE_DETAIL_ID WMS_Data_Type_Definitions_PUB.NumberTableType
67: , SOURCE_NAME WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType

Line 64: , SOURCE_HEADER_ID WMS_Data_Type_Definitions_PUB.NumberTableType

60: , CONTENT_VOLUME_UOM_CODE WMS_Data_Type_Definitions_PUB.Varchar2_3_TableType
61: , CONTENT_VOLUME WMS_Data_Type_Definitions_PUB.NumberTableType
62:
63: , SOURCE_TYPE_ID WMS_Data_Type_Definitions_PUB.NumberTableType
64: , SOURCE_HEADER_ID WMS_Data_Type_Definitions_PUB.NumberTableType
65: , SOURCE_LINE_ID WMS_Data_Type_Definitions_PUB.NumberTableType
66: , SOURCE_LINE_DETAIL_ID WMS_Data_Type_Definitions_PUB.NumberTableType
67: , SOURCE_NAME WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
68: , SOURCE_TRANSACTION_ID WMS_Data_Type_Definitions_PUB.NumberTableType

Line 65: , SOURCE_LINE_ID WMS_Data_Type_Definitions_PUB.NumberTableType

61: , CONTENT_VOLUME WMS_Data_Type_Definitions_PUB.NumberTableType
62:
63: , SOURCE_TYPE_ID WMS_Data_Type_Definitions_PUB.NumberTableType
64: , SOURCE_HEADER_ID WMS_Data_Type_Definitions_PUB.NumberTableType
65: , SOURCE_LINE_ID WMS_Data_Type_Definitions_PUB.NumberTableType
66: , SOURCE_LINE_DETAIL_ID WMS_Data_Type_Definitions_PUB.NumberTableType
67: , SOURCE_NAME WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
68: , SOURCE_TRANSACTION_ID WMS_Data_Type_Definitions_PUB.NumberTableType
69: , REFERENCE_ID WMS_Data_Type_Definitions_PUB.NumberTableType

Line 66: , SOURCE_LINE_DETAIL_ID WMS_Data_Type_Definitions_PUB.NumberTableType

62:
63: , SOURCE_TYPE_ID WMS_Data_Type_Definitions_PUB.NumberTableType
64: , SOURCE_HEADER_ID WMS_Data_Type_Definitions_PUB.NumberTableType
65: , SOURCE_LINE_ID WMS_Data_Type_Definitions_PUB.NumberTableType
66: , SOURCE_LINE_DETAIL_ID WMS_Data_Type_Definitions_PUB.NumberTableType
67: , SOURCE_NAME WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
68: , SOURCE_TRANSACTION_ID WMS_Data_Type_Definitions_PUB.NumberTableType
69: , REFERENCE_ID WMS_Data_Type_Definitions_PUB.NumberTableType
70:

Line 67: , SOURCE_NAME WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType

63: , SOURCE_TYPE_ID WMS_Data_Type_Definitions_PUB.NumberTableType
64: , SOURCE_HEADER_ID WMS_Data_Type_Definitions_PUB.NumberTableType
65: , SOURCE_LINE_ID WMS_Data_Type_Definitions_PUB.NumberTableType
66: , SOURCE_LINE_DETAIL_ID WMS_Data_Type_Definitions_PUB.NumberTableType
67: , SOURCE_NAME WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
68: , SOURCE_TRANSACTION_ID WMS_Data_Type_Definitions_PUB.NumberTableType
69: , REFERENCE_ID WMS_Data_Type_Definitions_PUB.NumberTableType
70:
71: , ATTRIBUTE_CATEGORY WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType

Line 68: , SOURCE_TRANSACTION_ID WMS_Data_Type_Definitions_PUB.NumberTableType

64: , SOURCE_HEADER_ID WMS_Data_Type_Definitions_PUB.NumberTableType
65: , SOURCE_LINE_ID WMS_Data_Type_Definitions_PUB.NumberTableType
66: , SOURCE_LINE_DETAIL_ID WMS_Data_Type_Definitions_PUB.NumberTableType
67: , SOURCE_NAME WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
68: , SOURCE_TRANSACTION_ID WMS_Data_Type_Definitions_PUB.NumberTableType
69: , REFERENCE_ID WMS_Data_Type_Definitions_PUB.NumberTableType
70:
71: , ATTRIBUTE_CATEGORY WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
72: , ATTRIBUTE1 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

Line 69: , REFERENCE_ID WMS_Data_Type_Definitions_PUB.NumberTableType

65: , SOURCE_LINE_ID WMS_Data_Type_Definitions_PUB.NumberTableType
66: , SOURCE_LINE_DETAIL_ID WMS_Data_Type_Definitions_PUB.NumberTableType
67: , SOURCE_NAME WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
68: , SOURCE_TRANSACTION_ID WMS_Data_Type_Definitions_PUB.NumberTableType
69: , REFERENCE_ID WMS_Data_Type_Definitions_PUB.NumberTableType
70:
71: , ATTRIBUTE_CATEGORY WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
72: , ATTRIBUTE1 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
73: , ATTRIBUTE2 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

Line 71: , ATTRIBUTE_CATEGORY WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType

67: , SOURCE_NAME WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
68: , SOURCE_TRANSACTION_ID WMS_Data_Type_Definitions_PUB.NumberTableType
69: , REFERENCE_ID WMS_Data_Type_Definitions_PUB.NumberTableType
70:
71: , ATTRIBUTE_CATEGORY WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
72: , ATTRIBUTE1 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
73: , ATTRIBUTE2 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
74: , ATTRIBUTE3 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
75: , ATTRIBUTE4 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

Line 72: , ATTRIBUTE1 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

68: , SOURCE_TRANSACTION_ID WMS_Data_Type_Definitions_PUB.NumberTableType
69: , REFERENCE_ID WMS_Data_Type_Definitions_PUB.NumberTableType
70:
71: , ATTRIBUTE_CATEGORY WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
72: , ATTRIBUTE1 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
73: , ATTRIBUTE2 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
74: , ATTRIBUTE3 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
75: , ATTRIBUTE4 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
76: , ATTRIBUTE5 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

Line 73: , ATTRIBUTE2 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

69: , REFERENCE_ID WMS_Data_Type_Definitions_PUB.NumberTableType
70:
71: , ATTRIBUTE_CATEGORY WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
72: , ATTRIBUTE1 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
73: , ATTRIBUTE2 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
74: , ATTRIBUTE3 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
75: , ATTRIBUTE4 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
76: , ATTRIBUTE5 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
77: , ATTRIBUTE6 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

Line 74: , ATTRIBUTE3 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

70:
71: , ATTRIBUTE_CATEGORY WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
72: , ATTRIBUTE1 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
73: , ATTRIBUTE2 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
74: , ATTRIBUTE3 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
75: , ATTRIBUTE4 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
76: , ATTRIBUTE5 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
77: , ATTRIBUTE6 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
78: , ATTRIBUTE7 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

Line 75: , ATTRIBUTE4 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

71: , ATTRIBUTE_CATEGORY WMS_Data_Type_Definitions_PUB.Varchar2_30_TableType
72: , ATTRIBUTE1 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
73: , ATTRIBUTE2 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
74: , ATTRIBUTE3 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
75: , ATTRIBUTE4 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
76: , ATTRIBUTE5 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
77: , ATTRIBUTE6 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
78: , ATTRIBUTE7 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
79: , ATTRIBUTE8 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

Line 76: , ATTRIBUTE5 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

72: , ATTRIBUTE1 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
73: , ATTRIBUTE2 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
74: , ATTRIBUTE3 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
75: , ATTRIBUTE4 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
76: , ATTRIBUTE5 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
77: , ATTRIBUTE6 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
78: , ATTRIBUTE7 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
79: , ATTRIBUTE8 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
80: , ATTRIBUTE9 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

Line 77: , ATTRIBUTE6 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

73: , ATTRIBUTE2 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
74: , ATTRIBUTE3 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
75: , ATTRIBUTE4 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
76: , ATTRIBUTE5 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
77: , ATTRIBUTE6 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
78: , ATTRIBUTE7 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
79: , ATTRIBUTE8 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
80: , ATTRIBUTE9 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
81: , ATTRIBUTE10 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

Line 78: , ATTRIBUTE7 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

74: , ATTRIBUTE3 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
75: , ATTRIBUTE4 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
76: , ATTRIBUTE5 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
77: , ATTRIBUTE6 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
78: , ATTRIBUTE7 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
79: , ATTRIBUTE8 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
80: , ATTRIBUTE9 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
81: , ATTRIBUTE10 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
82: , ATTRIBUTE11 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

Line 79: , ATTRIBUTE8 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

75: , ATTRIBUTE4 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
76: , ATTRIBUTE5 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
77: , ATTRIBUTE6 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
78: , ATTRIBUTE7 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
79: , ATTRIBUTE8 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
80: , ATTRIBUTE9 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
81: , ATTRIBUTE10 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
82: , ATTRIBUTE11 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
83: , ATTRIBUTE12 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

Line 80: , ATTRIBUTE9 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

76: , ATTRIBUTE5 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
77: , ATTRIBUTE6 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
78: , ATTRIBUTE7 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
79: , ATTRIBUTE8 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
80: , ATTRIBUTE9 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
81: , ATTRIBUTE10 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
82: , ATTRIBUTE11 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
83: , ATTRIBUTE12 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
84: , ATTRIBUTE13 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

Line 81: , ATTRIBUTE10 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

77: , ATTRIBUTE6 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
78: , ATTRIBUTE7 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
79: , ATTRIBUTE8 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
80: , ATTRIBUTE9 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
81: , ATTRIBUTE10 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
82: , ATTRIBUTE11 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
83: , ATTRIBUTE12 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
84: , ATTRIBUTE13 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
85: , ATTRIBUTE14 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

Line 82: , ATTRIBUTE11 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

78: , ATTRIBUTE7 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
79: , ATTRIBUTE8 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
80: , ATTRIBUTE9 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
81: , ATTRIBUTE10 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
82: , ATTRIBUTE11 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
83: , ATTRIBUTE12 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
84: , ATTRIBUTE13 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
85: , ATTRIBUTE14 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
86: , ATTRIBUTE15 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

Line 83: , ATTRIBUTE12 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

79: , ATTRIBUTE8 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
80: , ATTRIBUTE9 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
81: , ATTRIBUTE10 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
82: , ATTRIBUTE11 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
83: , ATTRIBUTE12 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
84: , ATTRIBUTE13 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
85: , ATTRIBUTE14 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
86: , ATTRIBUTE15 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
87: );

Line 84: , ATTRIBUTE13 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

80: , ATTRIBUTE9 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
81: , ATTRIBUTE10 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
82: , ATTRIBUTE11 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
83: , ATTRIBUTE12 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
84: , ATTRIBUTE13 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
85: , ATTRIBUTE14 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
86: , ATTRIBUTE15 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
87: );
88:

Line 85: , ATTRIBUTE14 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

81: , ATTRIBUTE10 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
82: , ATTRIBUTE11 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
83: , ATTRIBUTE12 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
84: , ATTRIBUTE13 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
85: , ATTRIBUTE14 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
86: , ATTRIBUTE15 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
87: );
88:
89: /*---------------------------------------------------------------------*/

Line 86: , ATTRIBUTE15 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType

82: , ATTRIBUTE11 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
83: , ATTRIBUTE12 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
84: , ATTRIBUTE13 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
85: , ATTRIBUTE14 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
86: , ATTRIBUTE15 WMS_Data_Type_Definitions_PUB.Varchar2_150_TableType
87: );
88:
89: /*---------------------------------------------------------------------*/
90: -- Name

Line 136: -- into a shipping WMS_Data_Type_Definitions_PUB.LPNRecordType type for

132: -- FUNCTION To_DeliveryDetailsRecType
133: /*---------------------------------------------------------------------*/
134: -- Purpose
135: -- This api takes in a LPN record type and translates it's attributes
136: -- into a shipping WMS_Data_Type_Definitions_PUB.LPNRecordType type for
137: -- use in their APIs
138: --
139: -- Not intended for general use
140: --

Line 164: -- WMS_Data_Type_Definitions_PUB.LPNRecordType with shipping field

160: -- Input Parameters
161: -- p_lpn_record LPN rec type with values to be converted to WSH rec type
162: --
163: -- Returns:
164: -- WMS_Data_Type_Definitions_PUB.LPNRecordType with shipping field
165: -- values populated that correspond the above LPN attributes
166: --
167:
168: FUNCTION To_DeliveryDetailsRecType (

Line 169: p_lpn_record IN WMS_Data_Type_Definitions_PUB.LPNRecordType

165: -- values populated that correspond the above LPN attributes
166: --
167:
168: FUNCTION To_DeliveryDetailsRecType (
169: p_lpn_record IN WMS_Data_Type_Definitions_PUB.LPNRecordType
170: )
171: RETURN WSH_Glbl_Var_Strct_GRP.Delivery_Details_Rec_Type;
172:
173: /*---------------------------------------------------------------------*/

Line 242: , p_lpn_table IN OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType

238: , x_return_status OUT NOCOPY VARCHAR2
239: , x_msg_count OUT NOCOPY NUMBER
240: , x_msg_data OUT NOCOPY VARCHAR2
241: , p_caller IN VARCHAR2
242: , p_lpn_table IN OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
243: );
244:
245: /*---------------------------------------------------------------------*/
246: -- Name

Line 315: , p_lpn_attributes IN WMS_Data_Type_Definitions_PUB.LPNRecordType

311: , p_lpn_suffix IN VARCHAR2
312: , p_starting_number IN NUMBER
313: , p_total_lpn_length IN NUMBER
314: , p_ucc_128_suffix_flag IN VARCHAR2
315: , p_lpn_attributes IN WMS_Data_Type_Definitions_PUB.LPNRecordType
316: , p_serial_ranges IN WMS_Data_Type_Definitions_PUB.SerialRangeTableType
317: , x_created_lpns OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
318: );
319:

Line 316: , p_serial_ranges IN WMS_Data_Type_Definitions_PUB.SerialRangeTableType

312: , p_starting_number IN NUMBER
313: , p_total_lpn_length IN NUMBER
314: , p_ucc_128_suffix_flag IN VARCHAR2
315: , p_lpn_attributes IN WMS_Data_Type_Definitions_PUB.LPNRecordType
316: , p_serial_ranges IN WMS_Data_Type_Definitions_PUB.SerialRangeTableType
317: , x_created_lpns OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
318: );
319:
320:

Line 317: , x_created_lpns OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType

313: , p_total_lpn_length IN NUMBER
314: , p_ucc_128_suffix_flag IN VARCHAR2
315: , p_lpn_attributes IN WMS_Data_Type_Definitions_PUB.LPNRecordType
316: , p_serial_ranges IN WMS_Data_Type_Definitions_PUB.SerialRangeTableType
317: , x_created_lpns OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
318: );
319:
320:
321: ------------------------

Line 396: , p_lpn_attributes IN WMS_Data_Type_Definitions_PUB.LPNRecordType

392: , p_lpn_suffix IN VARCHAR2
393: , p_starting_number IN NUMBER
394: , p_total_lpn_length IN NUMBER
395: , p_ucc_128_suffix_flag IN VARCHAR2
396: , p_lpn_attributes IN WMS_Data_Type_Definitions_PUB.LPNRecordType
397: , p_serial_ranges IN WMS_Data_Type_Definitions_PUB.SerialRangeTableType
398: , x_created_lpns OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
399: , p_client_code IN VARCHAR2 -- Adding for LSP, bug 9087971
400: );

Line 397: , p_serial_ranges IN WMS_Data_Type_Definitions_PUB.SerialRangeTableType

393: , p_starting_number IN NUMBER
394: , p_total_lpn_length IN NUMBER
395: , p_ucc_128_suffix_flag IN VARCHAR2
396: , p_lpn_attributes IN WMS_Data_Type_Definitions_PUB.LPNRecordType
397: , p_serial_ranges IN WMS_Data_Type_Definitions_PUB.SerialRangeTableType
398: , x_created_lpns OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
399: , p_client_code IN VARCHAR2 -- Adding for LSP, bug 9087971
400: );
401:

Line 398: , x_created_lpns OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType

394: , p_total_lpn_length IN NUMBER
395: , p_ucc_128_suffix_flag IN VARCHAR2
396: , p_lpn_attributes IN WMS_Data_Type_Definitions_PUB.LPNRecordType
397: , p_serial_ranges IN WMS_Data_Type_Definitions_PUB.SerialRangeTableType
398: , x_created_lpns OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
399: , p_client_code IN VARCHAR2 -- Adding for LSP, bug 9087971
400: );
401:
402:

Line 468: , p_lpn_table IN WMS_Data_Type_Definitions_PUB.LPNTableType

464: , x_return_status OUT NOCOPY VARCHAR2
465: , x_msg_count OUT NOCOPY NUMBER
466: , x_msg_data OUT NOCOPY VARCHAR2
467: , p_caller IN VARCHAR2
468: , p_lpn_table IN WMS_Data_Type_Definitions_PUB.LPNTableType
469: );
470:
471: /*---------------------------------------------------------------------*/
472: -- Name