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.INV_LOT_APIS dependencies on MTL_LOT_NUMBERS

Line 120: FROM mtl_lot_numbers mln

116: , nvl(TO_CHAR(mln.retest_date,'YYYY-MM-DD'),'') retest_date
117: , nvl(TO_CHAR(mln.hold_date,'YYYY-MM-DD'),'') hold_date
118: , nvl(TO_CHAR(mln.maturity_date,'YYYY-MM-DD'),'') maturity_date
119: , nvl(mln.supplier_lot_number,'') supplier_lot_number
120: FROM mtl_lot_numbers mln
121: WHERE inventory_item_id = p_inventory_item_id
122: AND organization_id = p_organization_id
123: AND lot_number = p_lot_number;
124:

Line 139: FROM mtl_lot_numbers mln

135: , nvl(TO_CHAR(mln.retest_date,'YYYY-MM-DD'),'') retest_date
136: , nvl(TO_CHAR(mln.hold_date,'YYYY-MM-DD'),'') hold_date
137: , nvl(TO_CHAR(mln.maturity_date,'YYYY-MM-DD'),'') maturity_date
138: , nvl(mln.supplier_lot_number,'') supplier_lot_number
139: FROM mtl_lot_numbers mln
140: WHERE inventory_item_id = p_inventory_item_id
141: AND organization_id = p_organization_id
142: AND lot_number = p_lot_number
143: AND nvl(parent_lot_number,' ') = nvl(p_parent_lot_number, ' ');

Line 456: FROM mtl_lot_numbers mln

452: , nvl(TO_CHAR(mln.maturity_date,'YYYY-MM-DD'),'') maturity_date
453: , nvl(mln.supplier_lot_number,'') supplier_lot_number
454: -- nsinghi bug#5209065 rework. Fetch exp date also, to default it.
455: , nvl(TO_CHAR(mln.expiration_date,'YYYY-MM-DD'),'') expiration_date
456: FROM mtl_lot_numbers mln
457: WHERE inventory_item_id = p_inventory_item_id
458: AND organization_id = p_organization_id
459: AND lot_number = p_lot_number;
460:

Line 494: FROM mtl_lot_numbers

490: , origination_date
491: , retest_date
492: , maturity_date
493: , hold_date
494: FROM mtl_lot_numbers
495: WHERE organization_id = cp_organization_id
496: AND inventory_item_id = cp_inventory_item_id
497: AND lot_number = cp_lot_number;
498:

Line 702: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

698: , msik.description
699: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
700: , mms.status_code status_code
701: , mms.status_id
702: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
703: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
704: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
705: AND mln.organization_id = p_organization_id
706: AND mln.organization_id = msik.organization_id

Line 721: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

717: , msik.description
718: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
719: , NULL status_code
720: , msik.default_lot_status_id -- Bug#2267947
721: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
722: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
723: AND mln.organization_id = p_organization_id
724: AND mln.organization_id = msik.organization_id
725: AND mln.inventory_item_id = msik.inventory_item_id

Line 737: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

733: , msik.description
734: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
735: , mms.status_code status_code
736: , mms.status_id
737: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
738: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
739: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
740: AND mln.organization_id = p_organization_id
741: AND mln.organization_id = msik.organization_id

Line 756: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

752: , msik.description
753: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
754: , NULL status_code
755: , msik.default_lot_status_id -- Bug#2267947
756: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
757: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
758: AND mln.organization_id = p_organization_id
759: AND mln.organization_id = msik.organization_id
760: AND mln.inventory_item_id = msik.inventory_item_id

Line 777: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil

773: , msik.description
774: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
775: , mms.status_code
776: , mms.status_id
777: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
778: WHERE moq.organization_id = p_organization_id
779: AND moq.lot_number IS NOT NULL
780: AND moq.organization_id = mil.organization_id
781: AND moq.organization_id = mln.organization_id

Line 806: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil

802: , msik.description
803: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
804: , NULL status_code
805: , msik.default_lot_status_id -- Bug#2267947
806: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
807: WHERE moq.organization_id = p_organization_id
808: AND moq.lot_number IS NOT NULL
809: AND moq.organization_id = mil.organization_id
810: AND moq.organization_id = mln.organization_id

Line 836: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

832: , msik.description
833: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
834: , mms.status_code
835: , mms.status_id
836: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
837: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
838: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
839: AND mln.organization_id = p_organization_id
840: AND mln.organization_id = msik.organization_id

Line 855: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

851: , msik.description
852: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
853: , NULL status_code
854: , msik.default_lot_status_id -- Bug#2267947
855: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
856: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
857: AND mln.organization_id = p_organization_id
858: AND mln.organization_id = msik.organization_id
859: AND mln.inventory_item_id = msik.inventory_item_id

Line 876: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

872: , msik.description
873: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
874: , mms.status_code
875: , mms.status_id
876: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
877: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
878: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
879: AND mln.organization_id = p_organization_id
880: AND mln.organization_id = msik.organization_id

Line 895: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

891: , msik.description
892: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
893: , NULL status_code
894: , msik.default_lot_status_id -- Bug#2267947
895: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
896: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
897: AND mln.organization_id = p_organization_id
898: AND mln.organization_id = msik.organization_id
899: AND mln.inventory_item_id = msik.inventory_item_id

Line 1074: p_inventory_item_id MTL_LOT_NUMBERS.inventory_item_id%TYPE,

1070:
1071: End;
1072:
1073: PROCEDURE Save_Lot_UOM_Conv(
1074: p_inventory_item_id MTL_LOT_NUMBERS.inventory_item_id%TYPE,
1075: p_org_id NUMBER,
1076: P_TRANSACTION_QUANTITY IN NUMBER,
1077: p_primary_quantity IN NUMBER ,
1078: P_TRANSACTION_UOM IN VARCHAR2 ,

Line 1080: p_lot_number MTL_LOT_NUMBERS.lot_number%TYPE,

1076: P_TRANSACTION_QUANTITY IN NUMBER,
1077: p_primary_quantity IN NUMBER ,
1078: P_TRANSACTION_UOM IN VARCHAR2 ,
1079: p_primary_uom IN VARCHAR2 ,
1080: p_lot_number MTL_LOT_NUMBERS.lot_number%TYPE,
1081: p_expiration_date MTL_LOT_NUMBERS.expiration_date%TYPE,
1082: x_return_status OUT NOCOPY VARCHAR2,
1083: x_msg_data OUT NOCOPY VARCHAR2,
1084: x_msg_count OUT NOCOPY NUMBER,

Line 1081: p_expiration_date MTL_LOT_NUMBERS.expiration_date%TYPE,

1077: p_primary_quantity IN NUMBER ,
1078: P_TRANSACTION_UOM IN VARCHAR2 ,
1079: p_primary_uom IN VARCHAR2 ,
1080: p_lot_number MTL_LOT_NUMBERS.lot_number%TYPE,
1081: p_expiration_date MTL_LOT_NUMBERS.expiration_date%TYPE,
1082: x_return_status OUT NOCOPY VARCHAR2,
1083: x_msg_data OUT NOCOPY VARCHAR2,
1084: x_msg_count OUT NOCOPY NUMBER,
1085: P_SUPPLIER_LOT_NUMBER MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,

Line 1085: P_SUPPLIER_LOT_NUMBER MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,

1081: p_expiration_date MTL_LOT_NUMBERS.expiration_date%TYPE,
1082: x_return_status OUT NOCOPY VARCHAR2,
1083: x_msg_data OUT NOCOPY VARCHAR2,
1084: x_msg_count OUT NOCOPY NUMBER,
1085: P_SUPPLIER_LOT_NUMBER MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
1086: p_grade_code MTL_LOT_NUMBERS.grade_code%TYPE,
1087: p_ORIGINATION_DATE MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
1088: P_STATUS_ID MTL_LOT_NUMBERS.STATUS_ID%TYPE,
1089: p_RETEST_DATE MTL_LOT_NUMBERS.RETEST_DATE%TYPE,

Line 1086: p_grade_code MTL_LOT_NUMBERS.grade_code%TYPE,

1082: x_return_status OUT NOCOPY VARCHAR2,
1083: x_msg_data OUT NOCOPY VARCHAR2,
1084: x_msg_count OUT NOCOPY NUMBER,
1085: P_SUPPLIER_LOT_NUMBER MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
1086: p_grade_code MTL_LOT_NUMBERS.grade_code%TYPE,
1087: p_ORIGINATION_DATE MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
1088: P_STATUS_ID MTL_LOT_NUMBERS.STATUS_ID%TYPE,
1089: p_RETEST_DATE MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
1090: P_MATURITY_DATE MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,

Line 1087: p_ORIGINATION_DATE MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,

1083: x_msg_data OUT NOCOPY VARCHAR2,
1084: x_msg_count OUT NOCOPY NUMBER,
1085: P_SUPPLIER_LOT_NUMBER MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
1086: p_grade_code MTL_LOT_NUMBERS.grade_code%TYPE,
1087: p_ORIGINATION_DATE MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
1088: P_STATUS_ID MTL_LOT_NUMBERS.STATUS_ID%TYPE,
1089: p_RETEST_DATE MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
1090: P_MATURITY_DATE MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
1091: P_LOT_ATTRIBUTE_CATEGORY MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,

Line 1088: P_STATUS_ID MTL_LOT_NUMBERS.STATUS_ID%TYPE,

1084: x_msg_count OUT NOCOPY NUMBER,
1085: P_SUPPLIER_LOT_NUMBER MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
1086: p_grade_code MTL_LOT_NUMBERS.grade_code%TYPE,
1087: p_ORIGINATION_DATE MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
1088: P_STATUS_ID MTL_LOT_NUMBERS.STATUS_ID%TYPE,
1089: p_RETEST_DATE MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
1090: P_MATURITY_DATE MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
1091: P_LOT_ATTRIBUTE_CATEGORY MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
1092: P_C_ATTRIBUTE1 MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,

Line 1089: p_RETEST_DATE MTL_LOT_NUMBERS.RETEST_DATE%TYPE,

1085: P_SUPPLIER_LOT_NUMBER MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
1086: p_grade_code MTL_LOT_NUMBERS.grade_code%TYPE,
1087: p_ORIGINATION_DATE MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
1088: P_STATUS_ID MTL_LOT_NUMBERS.STATUS_ID%TYPE,
1089: p_RETEST_DATE MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
1090: P_MATURITY_DATE MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
1091: P_LOT_ATTRIBUTE_CATEGORY MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
1092: P_C_ATTRIBUTE1 MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
1093: P_C_ATTRIBUTE2 MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,

Line 1090: P_MATURITY_DATE MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,

1086: p_grade_code MTL_LOT_NUMBERS.grade_code%TYPE,
1087: p_ORIGINATION_DATE MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
1088: P_STATUS_ID MTL_LOT_NUMBERS.STATUS_ID%TYPE,
1089: p_RETEST_DATE MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
1090: P_MATURITY_DATE MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
1091: P_LOT_ATTRIBUTE_CATEGORY MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
1092: P_C_ATTRIBUTE1 MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
1093: P_C_ATTRIBUTE2 MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
1094: P_C_ATTRIBUTE3 MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,

Line 1091: P_LOT_ATTRIBUTE_CATEGORY MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,

1087: p_ORIGINATION_DATE MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
1088: P_STATUS_ID MTL_LOT_NUMBERS.STATUS_ID%TYPE,
1089: p_RETEST_DATE MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
1090: P_MATURITY_DATE MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
1091: P_LOT_ATTRIBUTE_CATEGORY MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
1092: P_C_ATTRIBUTE1 MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
1093: P_C_ATTRIBUTE2 MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
1094: P_C_ATTRIBUTE3 MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
1095: P_C_ATTRIBUTE4 MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,

Line 1092: P_C_ATTRIBUTE1 MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,

1088: P_STATUS_ID MTL_LOT_NUMBERS.STATUS_ID%TYPE,
1089: p_RETEST_DATE MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
1090: P_MATURITY_DATE MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
1091: P_LOT_ATTRIBUTE_CATEGORY MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
1092: P_C_ATTRIBUTE1 MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
1093: P_C_ATTRIBUTE2 MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
1094: P_C_ATTRIBUTE3 MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
1095: P_C_ATTRIBUTE4 MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
1096: P_C_ATTRIBUTE5 MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,

Line 1093: P_C_ATTRIBUTE2 MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,

1089: p_RETEST_DATE MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
1090: P_MATURITY_DATE MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
1091: P_LOT_ATTRIBUTE_CATEGORY MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
1092: P_C_ATTRIBUTE1 MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
1093: P_C_ATTRIBUTE2 MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
1094: P_C_ATTRIBUTE3 MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
1095: P_C_ATTRIBUTE4 MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
1096: P_C_ATTRIBUTE5 MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
1097: P_C_ATTRIBUTE6 MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,

Line 1094: P_C_ATTRIBUTE3 MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,

1090: P_MATURITY_DATE MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
1091: P_LOT_ATTRIBUTE_CATEGORY MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
1092: P_C_ATTRIBUTE1 MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
1093: P_C_ATTRIBUTE2 MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
1094: P_C_ATTRIBUTE3 MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
1095: P_C_ATTRIBUTE4 MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
1096: P_C_ATTRIBUTE5 MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
1097: P_C_ATTRIBUTE6 MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
1098: P_C_ATTRIBUTE7 MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,

Line 1095: P_C_ATTRIBUTE4 MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,

1091: P_LOT_ATTRIBUTE_CATEGORY MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
1092: P_C_ATTRIBUTE1 MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
1093: P_C_ATTRIBUTE2 MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
1094: P_C_ATTRIBUTE3 MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
1095: P_C_ATTRIBUTE4 MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
1096: P_C_ATTRIBUTE5 MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
1097: P_C_ATTRIBUTE6 MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
1098: P_C_ATTRIBUTE7 MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
1099: P_C_ATTRIBUTE8 MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,

Line 1096: P_C_ATTRIBUTE5 MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,

1092: P_C_ATTRIBUTE1 MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
1093: P_C_ATTRIBUTE2 MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
1094: P_C_ATTRIBUTE3 MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
1095: P_C_ATTRIBUTE4 MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
1096: P_C_ATTRIBUTE5 MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
1097: P_C_ATTRIBUTE6 MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
1098: P_C_ATTRIBUTE7 MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
1099: P_C_ATTRIBUTE8 MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
1100: P_C_ATTRIBUTE9 MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,

Line 1097: P_C_ATTRIBUTE6 MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,

1093: P_C_ATTRIBUTE2 MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
1094: P_C_ATTRIBUTE3 MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
1095: P_C_ATTRIBUTE4 MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
1096: P_C_ATTRIBUTE5 MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
1097: P_C_ATTRIBUTE6 MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
1098: P_C_ATTRIBUTE7 MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
1099: P_C_ATTRIBUTE8 MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
1100: P_C_ATTRIBUTE9 MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
1101: P_C_ATTRIBUTE10 MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,

Line 1098: P_C_ATTRIBUTE7 MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,

1094: P_C_ATTRIBUTE3 MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
1095: P_C_ATTRIBUTE4 MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
1096: P_C_ATTRIBUTE5 MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
1097: P_C_ATTRIBUTE6 MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
1098: P_C_ATTRIBUTE7 MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
1099: P_C_ATTRIBUTE8 MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
1100: P_C_ATTRIBUTE9 MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
1101: P_C_ATTRIBUTE10 MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
1102: P_C_ATTRIBUTE11 MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,

Line 1099: P_C_ATTRIBUTE8 MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,

1095: P_C_ATTRIBUTE4 MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
1096: P_C_ATTRIBUTE5 MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
1097: P_C_ATTRIBUTE6 MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
1098: P_C_ATTRIBUTE7 MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
1099: P_C_ATTRIBUTE8 MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
1100: P_C_ATTRIBUTE9 MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
1101: P_C_ATTRIBUTE10 MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
1102: P_C_ATTRIBUTE11 MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
1103: P_C_ATTRIBUTE12 MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,

Line 1100: P_C_ATTRIBUTE9 MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,

1096: P_C_ATTRIBUTE5 MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
1097: P_C_ATTRIBUTE6 MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
1098: P_C_ATTRIBUTE7 MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
1099: P_C_ATTRIBUTE8 MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
1100: P_C_ATTRIBUTE9 MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
1101: P_C_ATTRIBUTE10 MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
1102: P_C_ATTRIBUTE11 MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
1103: P_C_ATTRIBUTE12 MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
1104: P_C_ATTRIBUTE13 MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,

Line 1101: P_C_ATTRIBUTE10 MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,

1097: P_C_ATTRIBUTE6 MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
1098: P_C_ATTRIBUTE7 MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
1099: P_C_ATTRIBUTE8 MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
1100: P_C_ATTRIBUTE9 MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
1101: P_C_ATTRIBUTE10 MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
1102: P_C_ATTRIBUTE11 MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
1103: P_C_ATTRIBUTE12 MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
1104: P_C_ATTRIBUTE13 MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
1105: P_C_ATTRIBUTE14 MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,

Line 1102: P_C_ATTRIBUTE11 MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,

1098: P_C_ATTRIBUTE7 MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
1099: P_C_ATTRIBUTE8 MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
1100: P_C_ATTRIBUTE9 MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
1101: P_C_ATTRIBUTE10 MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
1102: P_C_ATTRIBUTE11 MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
1103: P_C_ATTRIBUTE12 MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
1104: P_C_ATTRIBUTE13 MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
1105: P_C_ATTRIBUTE14 MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
1106: P_C_ATTRIBUTE15 MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,

Line 1103: P_C_ATTRIBUTE12 MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,

1099: P_C_ATTRIBUTE8 MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
1100: P_C_ATTRIBUTE9 MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
1101: P_C_ATTRIBUTE10 MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
1102: P_C_ATTRIBUTE11 MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
1103: P_C_ATTRIBUTE12 MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
1104: P_C_ATTRIBUTE13 MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
1105: P_C_ATTRIBUTE14 MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
1106: P_C_ATTRIBUTE15 MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
1107: P_C_ATTRIBUTE16 MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,

Line 1104: P_C_ATTRIBUTE13 MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,

1100: P_C_ATTRIBUTE9 MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
1101: P_C_ATTRIBUTE10 MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
1102: P_C_ATTRIBUTE11 MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
1103: P_C_ATTRIBUTE12 MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
1104: P_C_ATTRIBUTE13 MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
1105: P_C_ATTRIBUTE14 MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
1106: P_C_ATTRIBUTE15 MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
1107: P_C_ATTRIBUTE16 MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
1108: P_C_ATTRIBUTE17 MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,

Line 1105: P_C_ATTRIBUTE14 MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,

1101: P_C_ATTRIBUTE10 MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
1102: P_C_ATTRIBUTE11 MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
1103: P_C_ATTRIBUTE12 MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
1104: P_C_ATTRIBUTE13 MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
1105: P_C_ATTRIBUTE14 MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
1106: P_C_ATTRIBUTE15 MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
1107: P_C_ATTRIBUTE16 MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
1108: P_C_ATTRIBUTE17 MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
1109: P_C_ATTRIBUTE18 MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,

Line 1106: P_C_ATTRIBUTE15 MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,

1102: P_C_ATTRIBUTE11 MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
1103: P_C_ATTRIBUTE12 MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
1104: P_C_ATTRIBUTE13 MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
1105: P_C_ATTRIBUTE14 MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
1106: P_C_ATTRIBUTE15 MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
1107: P_C_ATTRIBUTE16 MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
1108: P_C_ATTRIBUTE17 MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
1109: P_C_ATTRIBUTE18 MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
1110: P_C_ATTRIBUTE19 MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,

Line 1107: P_C_ATTRIBUTE16 MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,

1103: P_C_ATTRIBUTE12 MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
1104: P_C_ATTRIBUTE13 MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
1105: P_C_ATTRIBUTE14 MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
1106: P_C_ATTRIBUTE15 MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
1107: P_C_ATTRIBUTE16 MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
1108: P_C_ATTRIBUTE17 MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
1109: P_C_ATTRIBUTE18 MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
1110: P_C_ATTRIBUTE19 MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
1111: P_C_ATTRIBUTE20 MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,

Line 1108: P_C_ATTRIBUTE17 MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,

1104: P_C_ATTRIBUTE13 MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
1105: P_C_ATTRIBUTE14 MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
1106: P_C_ATTRIBUTE15 MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
1107: P_C_ATTRIBUTE16 MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
1108: P_C_ATTRIBUTE17 MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
1109: P_C_ATTRIBUTE18 MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
1110: P_C_ATTRIBUTE19 MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
1111: P_C_ATTRIBUTE20 MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
1112: P_D_ATTRIBUTE1 MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,

Line 1109: P_C_ATTRIBUTE18 MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,

1105: P_C_ATTRIBUTE14 MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
1106: P_C_ATTRIBUTE15 MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
1107: P_C_ATTRIBUTE16 MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
1108: P_C_ATTRIBUTE17 MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
1109: P_C_ATTRIBUTE18 MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
1110: P_C_ATTRIBUTE19 MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
1111: P_C_ATTRIBUTE20 MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
1112: P_D_ATTRIBUTE1 MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
1113: P_D_ATTRIBUTE2 MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,

Line 1110: P_C_ATTRIBUTE19 MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,

1106: P_C_ATTRIBUTE15 MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
1107: P_C_ATTRIBUTE16 MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
1108: P_C_ATTRIBUTE17 MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
1109: P_C_ATTRIBUTE18 MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
1110: P_C_ATTRIBUTE19 MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
1111: P_C_ATTRIBUTE20 MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
1112: P_D_ATTRIBUTE1 MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
1113: P_D_ATTRIBUTE2 MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
1114: P_D_ATTRIBUTE3 MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,

Line 1111: P_C_ATTRIBUTE20 MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,

1107: P_C_ATTRIBUTE16 MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
1108: P_C_ATTRIBUTE17 MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
1109: P_C_ATTRIBUTE18 MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
1110: P_C_ATTRIBUTE19 MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
1111: P_C_ATTRIBUTE20 MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
1112: P_D_ATTRIBUTE1 MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
1113: P_D_ATTRIBUTE2 MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
1114: P_D_ATTRIBUTE3 MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
1115: P_D_ATTRIBUTE4 MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,

Line 1112: P_D_ATTRIBUTE1 MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,

1108: P_C_ATTRIBUTE17 MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
1109: P_C_ATTRIBUTE18 MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
1110: P_C_ATTRIBUTE19 MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
1111: P_C_ATTRIBUTE20 MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
1112: P_D_ATTRIBUTE1 MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
1113: P_D_ATTRIBUTE2 MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
1114: P_D_ATTRIBUTE3 MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
1115: P_D_ATTRIBUTE4 MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
1116: P_D_ATTRIBUTE5 MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,

Line 1113: P_D_ATTRIBUTE2 MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,

1109: P_C_ATTRIBUTE18 MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
1110: P_C_ATTRIBUTE19 MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
1111: P_C_ATTRIBUTE20 MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
1112: P_D_ATTRIBUTE1 MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
1113: P_D_ATTRIBUTE2 MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
1114: P_D_ATTRIBUTE3 MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
1115: P_D_ATTRIBUTE4 MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
1116: P_D_ATTRIBUTE5 MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
1117: P_D_ATTRIBUTE6 MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,

Line 1114: P_D_ATTRIBUTE3 MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,

1110: P_C_ATTRIBUTE19 MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
1111: P_C_ATTRIBUTE20 MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
1112: P_D_ATTRIBUTE1 MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
1113: P_D_ATTRIBUTE2 MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
1114: P_D_ATTRIBUTE3 MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
1115: P_D_ATTRIBUTE4 MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
1116: P_D_ATTRIBUTE5 MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
1117: P_D_ATTRIBUTE6 MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
1118: P_D_ATTRIBUTE7 MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,

Line 1115: P_D_ATTRIBUTE4 MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,

1111: P_C_ATTRIBUTE20 MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
1112: P_D_ATTRIBUTE1 MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
1113: P_D_ATTRIBUTE2 MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
1114: P_D_ATTRIBUTE3 MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
1115: P_D_ATTRIBUTE4 MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
1116: P_D_ATTRIBUTE5 MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
1117: P_D_ATTRIBUTE6 MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
1118: P_D_ATTRIBUTE7 MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
1119: P_D_ATTRIBUTE8 MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,

Line 1116: P_D_ATTRIBUTE5 MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,

1112: P_D_ATTRIBUTE1 MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
1113: P_D_ATTRIBUTE2 MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
1114: P_D_ATTRIBUTE3 MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
1115: P_D_ATTRIBUTE4 MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
1116: P_D_ATTRIBUTE5 MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
1117: P_D_ATTRIBUTE6 MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
1118: P_D_ATTRIBUTE7 MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
1119: P_D_ATTRIBUTE8 MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
1120: P_D_ATTRIBUTE9 MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,

Line 1117: P_D_ATTRIBUTE6 MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,

1113: P_D_ATTRIBUTE2 MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
1114: P_D_ATTRIBUTE3 MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
1115: P_D_ATTRIBUTE4 MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
1116: P_D_ATTRIBUTE5 MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
1117: P_D_ATTRIBUTE6 MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
1118: P_D_ATTRIBUTE7 MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
1119: P_D_ATTRIBUTE8 MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
1120: P_D_ATTRIBUTE9 MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
1121: P_D_ATTRIBUTE10 MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,

Line 1118: P_D_ATTRIBUTE7 MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,

1114: P_D_ATTRIBUTE3 MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
1115: P_D_ATTRIBUTE4 MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
1116: P_D_ATTRIBUTE5 MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
1117: P_D_ATTRIBUTE6 MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
1118: P_D_ATTRIBUTE7 MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
1119: P_D_ATTRIBUTE8 MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
1120: P_D_ATTRIBUTE9 MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
1121: P_D_ATTRIBUTE10 MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
1122: P_N_ATTRIBUTE1 MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,

Line 1119: P_D_ATTRIBUTE8 MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,

1115: P_D_ATTRIBUTE4 MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
1116: P_D_ATTRIBUTE5 MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
1117: P_D_ATTRIBUTE6 MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
1118: P_D_ATTRIBUTE7 MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
1119: P_D_ATTRIBUTE8 MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
1120: P_D_ATTRIBUTE9 MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
1121: P_D_ATTRIBUTE10 MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
1122: P_N_ATTRIBUTE1 MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
1123: P_N_ATTRIBUTE2 MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,

Line 1120: P_D_ATTRIBUTE9 MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,

1116: P_D_ATTRIBUTE5 MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
1117: P_D_ATTRIBUTE6 MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
1118: P_D_ATTRIBUTE7 MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
1119: P_D_ATTRIBUTE8 MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
1120: P_D_ATTRIBUTE9 MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
1121: P_D_ATTRIBUTE10 MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
1122: P_N_ATTRIBUTE1 MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
1123: P_N_ATTRIBUTE2 MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
1124: P_N_ATTRIBUTE3 MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,

Line 1121: P_D_ATTRIBUTE10 MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,

1117: P_D_ATTRIBUTE6 MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
1118: P_D_ATTRIBUTE7 MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
1119: P_D_ATTRIBUTE8 MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
1120: P_D_ATTRIBUTE9 MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
1121: P_D_ATTRIBUTE10 MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
1122: P_N_ATTRIBUTE1 MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
1123: P_N_ATTRIBUTE2 MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
1124: P_N_ATTRIBUTE3 MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
1125: P_N_ATTRIBUTE4 MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,

Line 1122: P_N_ATTRIBUTE1 MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,

1118: P_D_ATTRIBUTE7 MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
1119: P_D_ATTRIBUTE8 MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
1120: P_D_ATTRIBUTE9 MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
1121: P_D_ATTRIBUTE10 MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
1122: P_N_ATTRIBUTE1 MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
1123: P_N_ATTRIBUTE2 MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
1124: P_N_ATTRIBUTE3 MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
1125: P_N_ATTRIBUTE4 MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
1126: P_N_ATTRIBUTE5 MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,

Line 1123: P_N_ATTRIBUTE2 MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,

1119: P_D_ATTRIBUTE8 MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
1120: P_D_ATTRIBUTE9 MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
1121: P_D_ATTRIBUTE10 MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
1122: P_N_ATTRIBUTE1 MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
1123: P_N_ATTRIBUTE2 MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
1124: P_N_ATTRIBUTE3 MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
1125: P_N_ATTRIBUTE4 MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
1126: P_N_ATTRIBUTE5 MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
1127: P_N_ATTRIBUTE6 MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,

Line 1124: P_N_ATTRIBUTE3 MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,

1120: P_D_ATTRIBUTE9 MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
1121: P_D_ATTRIBUTE10 MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
1122: P_N_ATTRIBUTE1 MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
1123: P_N_ATTRIBUTE2 MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
1124: P_N_ATTRIBUTE3 MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
1125: P_N_ATTRIBUTE4 MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
1126: P_N_ATTRIBUTE5 MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
1127: P_N_ATTRIBUTE6 MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
1128: P_N_ATTRIBUTE7 MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,

Line 1125: P_N_ATTRIBUTE4 MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,

1121: P_D_ATTRIBUTE10 MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
1122: P_N_ATTRIBUTE1 MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
1123: P_N_ATTRIBUTE2 MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
1124: P_N_ATTRIBUTE3 MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
1125: P_N_ATTRIBUTE4 MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
1126: P_N_ATTRIBUTE5 MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
1127: P_N_ATTRIBUTE6 MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
1128: P_N_ATTRIBUTE7 MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
1129: P_N_ATTRIBUTE8 MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,

Line 1126: P_N_ATTRIBUTE5 MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,

1122: P_N_ATTRIBUTE1 MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
1123: P_N_ATTRIBUTE2 MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
1124: P_N_ATTRIBUTE3 MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
1125: P_N_ATTRIBUTE4 MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
1126: P_N_ATTRIBUTE5 MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
1127: P_N_ATTRIBUTE6 MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
1128: P_N_ATTRIBUTE7 MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
1129: P_N_ATTRIBUTE8 MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
1130: P_N_ATTRIBUTE9 MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,

Line 1127: P_N_ATTRIBUTE6 MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,

1123: P_N_ATTRIBUTE2 MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
1124: P_N_ATTRIBUTE3 MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
1125: P_N_ATTRIBUTE4 MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
1126: P_N_ATTRIBUTE5 MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
1127: P_N_ATTRIBUTE6 MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
1128: P_N_ATTRIBUTE7 MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
1129: P_N_ATTRIBUTE8 MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
1130: P_N_ATTRIBUTE9 MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
1131: P_N_ATTRIBUTE10 MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,

Line 1128: P_N_ATTRIBUTE7 MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,

1124: P_N_ATTRIBUTE3 MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
1125: P_N_ATTRIBUTE4 MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
1126: P_N_ATTRIBUTE5 MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
1127: P_N_ATTRIBUTE6 MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
1128: P_N_ATTRIBUTE7 MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
1129: P_N_ATTRIBUTE8 MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
1130: P_N_ATTRIBUTE9 MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
1131: P_N_ATTRIBUTE10 MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
1132: P_SECONDARY_QUANTITY IN NUMBER,

Line 1129: P_N_ATTRIBUTE8 MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,

1125: P_N_ATTRIBUTE4 MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
1126: P_N_ATTRIBUTE5 MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
1127: P_N_ATTRIBUTE6 MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
1128: P_N_ATTRIBUTE7 MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
1129: P_N_ATTRIBUTE8 MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
1130: P_N_ATTRIBUTE9 MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
1131: P_N_ATTRIBUTE10 MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
1132: P_SECONDARY_QUANTITY IN NUMBER,
1133: P_SECONDARY_UOM_CODE IN VARCHAR2 ,

Line 1130: P_N_ATTRIBUTE9 MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,

1126: P_N_ATTRIBUTE5 MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
1127: P_N_ATTRIBUTE6 MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
1128: P_N_ATTRIBUTE7 MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
1129: P_N_ATTRIBUTE8 MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
1130: P_N_ATTRIBUTE9 MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
1131: P_N_ATTRIBUTE10 MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
1132: P_SECONDARY_QUANTITY IN NUMBER,
1133: P_SECONDARY_UOM_CODE IN VARCHAR2 ,
1134: p_parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE,

Line 1131: P_N_ATTRIBUTE10 MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,

1127: P_N_ATTRIBUTE6 MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
1128: P_N_ATTRIBUTE7 MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
1129: P_N_ATTRIBUTE8 MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
1130: P_N_ATTRIBUTE9 MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
1131: P_N_ATTRIBUTE10 MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
1132: P_SECONDARY_QUANTITY IN NUMBER,
1133: P_SECONDARY_UOM_CODE IN VARCHAR2 ,
1134: p_parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE,
1135: P_ORIGINATION_TYPE MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE,

Line 1134: p_parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE,

1130: P_N_ATTRIBUTE9 MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
1131: P_N_ATTRIBUTE10 MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
1132: P_SECONDARY_QUANTITY IN NUMBER,
1133: P_SECONDARY_UOM_CODE IN VARCHAR2 ,
1134: p_parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE,
1135: P_ORIGINATION_TYPE MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE,
1136: P_EXPIRATION_ACTION_DATE MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE,
1137: P_EXPIRATION_ACTION_CODE MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE,
1138: P_HOLD_DATE MTL_LOT_NUMBERS.HOLD_DATE%TYPE,

Line 1135: P_ORIGINATION_TYPE MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE,

1131: P_N_ATTRIBUTE10 MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
1132: P_SECONDARY_QUANTITY IN NUMBER,
1133: P_SECONDARY_UOM_CODE IN VARCHAR2 ,
1134: p_parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE,
1135: P_ORIGINATION_TYPE MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE,
1136: P_EXPIRATION_ACTION_DATE MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE,
1137: P_EXPIRATION_ACTION_CODE MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE,
1138: P_HOLD_DATE MTL_LOT_NUMBERS.HOLD_DATE%TYPE,
1139: P_REASON_ID IN VARCHAR2 ,

Line 1136: P_EXPIRATION_ACTION_DATE MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE,

1132: P_SECONDARY_QUANTITY IN NUMBER,
1133: P_SECONDARY_UOM_CODE IN VARCHAR2 ,
1134: p_parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE,
1135: P_ORIGINATION_TYPE MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE,
1136: P_EXPIRATION_ACTION_DATE MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE,
1137: P_EXPIRATION_ACTION_CODE MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE,
1138: P_HOLD_DATE MTL_LOT_NUMBERS.HOLD_DATE%TYPE,
1139: P_REASON_ID IN VARCHAR2 ,
1140: p_response IN VARCHAR2 ,

Line 1137: P_EXPIRATION_ACTION_CODE MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE,

1133: P_SECONDARY_UOM_CODE IN VARCHAR2 ,
1134: p_parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE,
1135: P_ORIGINATION_TYPE MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE,
1136: P_EXPIRATION_ACTION_DATE MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE,
1137: P_EXPIRATION_ACTION_CODE MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE,
1138: P_HOLD_DATE MTL_LOT_NUMBERS.HOLD_DATE%TYPE,
1139: P_REASON_ID IN VARCHAR2 ,
1140: p_response IN VARCHAR2 ,
1141: P_ATTRIBUTE_CATEGORY MTL_LOT_NUMBERS.ATTRIBUTE_CATEGORY%TYPE,

Line 1138: P_HOLD_DATE MTL_LOT_NUMBERS.HOLD_DATE%TYPE,

1134: p_parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE,
1135: P_ORIGINATION_TYPE MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE,
1136: P_EXPIRATION_ACTION_DATE MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE,
1137: P_EXPIRATION_ACTION_CODE MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE,
1138: P_HOLD_DATE MTL_LOT_NUMBERS.HOLD_DATE%TYPE,
1139: P_REASON_ID IN VARCHAR2 ,
1140: p_response IN VARCHAR2 ,
1141: P_ATTRIBUTE_CATEGORY MTL_LOT_NUMBERS.ATTRIBUTE_CATEGORY%TYPE,
1142: P_ATTRIBUTE1 MTL_LOT_NUMBERS.ATTRIBUTE1%TYPE,

Line 1141: P_ATTRIBUTE_CATEGORY MTL_LOT_NUMBERS.ATTRIBUTE_CATEGORY%TYPE,

1137: P_EXPIRATION_ACTION_CODE MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE,
1138: P_HOLD_DATE MTL_LOT_NUMBERS.HOLD_DATE%TYPE,
1139: P_REASON_ID IN VARCHAR2 ,
1140: p_response IN VARCHAR2 ,
1141: P_ATTRIBUTE_CATEGORY MTL_LOT_NUMBERS.ATTRIBUTE_CATEGORY%TYPE,
1142: P_ATTRIBUTE1 MTL_LOT_NUMBERS.ATTRIBUTE1%TYPE,
1143: P_ATTRIBUTE2 MTL_LOT_NUMBERS.ATTRIBUTE2%TYPE,
1144: P_ATTRIBUTE3 MTL_LOT_NUMBERS.ATTRIBUTE3%TYPE,
1145: P_ATTRIBUTE4 MTL_LOT_NUMBERS.ATTRIBUTE4%TYPE,

Line 1142: P_ATTRIBUTE1 MTL_LOT_NUMBERS.ATTRIBUTE1%TYPE,

1138: P_HOLD_DATE MTL_LOT_NUMBERS.HOLD_DATE%TYPE,
1139: P_REASON_ID IN VARCHAR2 ,
1140: p_response IN VARCHAR2 ,
1141: P_ATTRIBUTE_CATEGORY MTL_LOT_NUMBERS.ATTRIBUTE_CATEGORY%TYPE,
1142: P_ATTRIBUTE1 MTL_LOT_NUMBERS.ATTRIBUTE1%TYPE,
1143: P_ATTRIBUTE2 MTL_LOT_NUMBERS.ATTRIBUTE2%TYPE,
1144: P_ATTRIBUTE3 MTL_LOT_NUMBERS.ATTRIBUTE3%TYPE,
1145: P_ATTRIBUTE4 MTL_LOT_NUMBERS.ATTRIBUTE4%TYPE,
1146: P_ATTRIBUTE5 MTL_LOT_NUMBERS.ATTRIBUTE5%TYPE,

Line 1143: P_ATTRIBUTE2 MTL_LOT_NUMBERS.ATTRIBUTE2%TYPE,

1139: P_REASON_ID IN VARCHAR2 ,
1140: p_response IN VARCHAR2 ,
1141: P_ATTRIBUTE_CATEGORY MTL_LOT_NUMBERS.ATTRIBUTE_CATEGORY%TYPE,
1142: P_ATTRIBUTE1 MTL_LOT_NUMBERS.ATTRIBUTE1%TYPE,
1143: P_ATTRIBUTE2 MTL_LOT_NUMBERS.ATTRIBUTE2%TYPE,
1144: P_ATTRIBUTE3 MTL_LOT_NUMBERS.ATTRIBUTE3%TYPE,
1145: P_ATTRIBUTE4 MTL_LOT_NUMBERS.ATTRIBUTE4%TYPE,
1146: P_ATTRIBUTE5 MTL_LOT_NUMBERS.ATTRIBUTE5%TYPE,
1147: P_ATTRIBUTE6 MTL_LOT_NUMBERS.ATTRIBUTE6%TYPE,

Line 1144: P_ATTRIBUTE3 MTL_LOT_NUMBERS.ATTRIBUTE3%TYPE,

1140: p_response IN VARCHAR2 ,
1141: P_ATTRIBUTE_CATEGORY MTL_LOT_NUMBERS.ATTRIBUTE_CATEGORY%TYPE,
1142: P_ATTRIBUTE1 MTL_LOT_NUMBERS.ATTRIBUTE1%TYPE,
1143: P_ATTRIBUTE2 MTL_LOT_NUMBERS.ATTRIBUTE2%TYPE,
1144: P_ATTRIBUTE3 MTL_LOT_NUMBERS.ATTRIBUTE3%TYPE,
1145: P_ATTRIBUTE4 MTL_LOT_NUMBERS.ATTRIBUTE4%TYPE,
1146: P_ATTRIBUTE5 MTL_LOT_NUMBERS.ATTRIBUTE5%TYPE,
1147: P_ATTRIBUTE6 MTL_LOT_NUMBERS.ATTRIBUTE6%TYPE,
1148: P_ATTRIBUTE7 MTL_LOT_NUMBERS.ATTRIBUTE7%TYPE,

Line 1145: P_ATTRIBUTE4 MTL_LOT_NUMBERS.ATTRIBUTE4%TYPE,

1141: P_ATTRIBUTE_CATEGORY MTL_LOT_NUMBERS.ATTRIBUTE_CATEGORY%TYPE,
1142: P_ATTRIBUTE1 MTL_LOT_NUMBERS.ATTRIBUTE1%TYPE,
1143: P_ATTRIBUTE2 MTL_LOT_NUMBERS.ATTRIBUTE2%TYPE,
1144: P_ATTRIBUTE3 MTL_LOT_NUMBERS.ATTRIBUTE3%TYPE,
1145: P_ATTRIBUTE4 MTL_LOT_NUMBERS.ATTRIBUTE4%TYPE,
1146: P_ATTRIBUTE5 MTL_LOT_NUMBERS.ATTRIBUTE5%TYPE,
1147: P_ATTRIBUTE6 MTL_LOT_NUMBERS.ATTRIBUTE6%TYPE,
1148: P_ATTRIBUTE7 MTL_LOT_NUMBERS.ATTRIBUTE7%TYPE,
1149: P_ATTRIBUTE8 MTL_LOT_NUMBERS.ATTRIBUTE8%TYPE,

Line 1146: P_ATTRIBUTE5 MTL_LOT_NUMBERS.ATTRIBUTE5%TYPE,

1142: P_ATTRIBUTE1 MTL_LOT_NUMBERS.ATTRIBUTE1%TYPE,
1143: P_ATTRIBUTE2 MTL_LOT_NUMBERS.ATTRIBUTE2%TYPE,
1144: P_ATTRIBUTE3 MTL_LOT_NUMBERS.ATTRIBUTE3%TYPE,
1145: P_ATTRIBUTE4 MTL_LOT_NUMBERS.ATTRIBUTE4%TYPE,
1146: P_ATTRIBUTE5 MTL_LOT_NUMBERS.ATTRIBUTE5%TYPE,
1147: P_ATTRIBUTE6 MTL_LOT_NUMBERS.ATTRIBUTE6%TYPE,
1148: P_ATTRIBUTE7 MTL_LOT_NUMBERS.ATTRIBUTE7%TYPE,
1149: P_ATTRIBUTE8 MTL_LOT_NUMBERS.ATTRIBUTE8%TYPE,
1150: P_ATTRIBUTE9 MTL_LOT_NUMBERS.ATTRIBUTE9%TYPE,

Line 1147: P_ATTRIBUTE6 MTL_LOT_NUMBERS.ATTRIBUTE6%TYPE,

1143: P_ATTRIBUTE2 MTL_LOT_NUMBERS.ATTRIBUTE2%TYPE,
1144: P_ATTRIBUTE3 MTL_LOT_NUMBERS.ATTRIBUTE3%TYPE,
1145: P_ATTRIBUTE4 MTL_LOT_NUMBERS.ATTRIBUTE4%TYPE,
1146: P_ATTRIBUTE5 MTL_LOT_NUMBERS.ATTRIBUTE5%TYPE,
1147: P_ATTRIBUTE6 MTL_LOT_NUMBERS.ATTRIBUTE6%TYPE,
1148: P_ATTRIBUTE7 MTL_LOT_NUMBERS.ATTRIBUTE7%TYPE,
1149: P_ATTRIBUTE8 MTL_LOT_NUMBERS.ATTRIBUTE8%TYPE,
1150: P_ATTRIBUTE9 MTL_LOT_NUMBERS.ATTRIBUTE9%TYPE,
1151: P_ATTRIBUTE10 MTL_LOT_NUMBERS.ATTRIBUTE10%TYPE,

Line 1148: P_ATTRIBUTE7 MTL_LOT_NUMBERS.ATTRIBUTE7%TYPE,

1144: P_ATTRIBUTE3 MTL_LOT_NUMBERS.ATTRIBUTE3%TYPE,
1145: P_ATTRIBUTE4 MTL_LOT_NUMBERS.ATTRIBUTE4%TYPE,
1146: P_ATTRIBUTE5 MTL_LOT_NUMBERS.ATTRIBUTE5%TYPE,
1147: P_ATTRIBUTE6 MTL_LOT_NUMBERS.ATTRIBUTE6%TYPE,
1148: P_ATTRIBUTE7 MTL_LOT_NUMBERS.ATTRIBUTE7%TYPE,
1149: P_ATTRIBUTE8 MTL_LOT_NUMBERS.ATTRIBUTE8%TYPE,
1150: P_ATTRIBUTE9 MTL_LOT_NUMBERS.ATTRIBUTE9%TYPE,
1151: P_ATTRIBUTE10 MTL_LOT_NUMBERS.ATTRIBUTE10%TYPE,
1152: P_ATTRIBUTE11 MTL_LOT_NUMBERS.ATTRIBUTE11%TYPE,

Line 1149: P_ATTRIBUTE8 MTL_LOT_NUMBERS.ATTRIBUTE8%TYPE,

1145: P_ATTRIBUTE4 MTL_LOT_NUMBERS.ATTRIBUTE4%TYPE,
1146: P_ATTRIBUTE5 MTL_LOT_NUMBERS.ATTRIBUTE5%TYPE,
1147: P_ATTRIBUTE6 MTL_LOT_NUMBERS.ATTRIBUTE6%TYPE,
1148: P_ATTRIBUTE7 MTL_LOT_NUMBERS.ATTRIBUTE7%TYPE,
1149: P_ATTRIBUTE8 MTL_LOT_NUMBERS.ATTRIBUTE8%TYPE,
1150: P_ATTRIBUTE9 MTL_LOT_NUMBERS.ATTRIBUTE9%TYPE,
1151: P_ATTRIBUTE10 MTL_LOT_NUMBERS.ATTRIBUTE10%TYPE,
1152: P_ATTRIBUTE11 MTL_LOT_NUMBERS.ATTRIBUTE11%TYPE,
1153: P_ATTRIBUTE12 MTL_LOT_NUMBERS.ATTRIBUTE12%TYPE,

Line 1150: P_ATTRIBUTE9 MTL_LOT_NUMBERS.ATTRIBUTE9%TYPE,

1146: P_ATTRIBUTE5 MTL_LOT_NUMBERS.ATTRIBUTE5%TYPE,
1147: P_ATTRIBUTE6 MTL_LOT_NUMBERS.ATTRIBUTE6%TYPE,
1148: P_ATTRIBUTE7 MTL_LOT_NUMBERS.ATTRIBUTE7%TYPE,
1149: P_ATTRIBUTE8 MTL_LOT_NUMBERS.ATTRIBUTE8%TYPE,
1150: P_ATTRIBUTE9 MTL_LOT_NUMBERS.ATTRIBUTE9%TYPE,
1151: P_ATTRIBUTE10 MTL_LOT_NUMBERS.ATTRIBUTE10%TYPE,
1152: P_ATTRIBUTE11 MTL_LOT_NUMBERS.ATTRIBUTE11%TYPE,
1153: P_ATTRIBUTE12 MTL_LOT_NUMBERS.ATTRIBUTE12%TYPE,
1154: P_ATTRIBUTE13 MTL_LOT_NUMBERS.ATTRIBUTE13%TYPE,

Line 1151: P_ATTRIBUTE10 MTL_LOT_NUMBERS.ATTRIBUTE10%TYPE,

1147: P_ATTRIBUTE6 MTL_LOT_NUMBERS.ATTRIBUTE6%TYPE,
1148: P_ATTRIBUTE7 MTL_LOT_NUMBERS.ATTRIBUTE7%TYPE,
1149: P_ATTRIBUTE8 MTL_LOT_NUMBERS.ATTRIBUTE8%TYPE,
1150: P_ATTRIBUTE9 MTL_LOT_NUMBERS.ATTRIBUTE9%TYPE,
1151: P_ATTRIBUTE10 MTL_LOT_NUMBERS.ATTRIBUTE10%TYPE,
1152: P_ATTRIBUTE11 MTL_LOT_NUMBERS.ATTRIBUTE11%TYPE,
1153: P_ATTRIBUTE12 MTL_LOT_NUMBERS.ATTRIBUTE12%TYPE,
1154: P_ATTRIBUTE13 MTL_LOT_NUMBERS.ATTRIBUTE13%TYPE,
1155: P_ATTRIBUTE14 MTL_LOT_NUMBERS.ATTRIBUTE14%TYPE,

Line 1152: P_ATTRIBUTE11 MTL_LOT_NUMBERS.ATTRIBUTE11%TYPE,

1148: P_ATTRIBUTE7 MTL_LOT_NUMBERS.ATTRIBUTE7%TYPE,
1149: P_ATTRIBUTE8 MTL_LOT_NUMBERS.ATTRIBUTE8%TYPE,
1150: P_ATTRIBUTE9 MTL_LOT_NUMBERS.ATTRIBUTE9%TYPE,
1151: P_ATTRIBUTE10 MTL_LOT_NUMBERS.ATTRIBUTE10%TYPE,
1152: P_ATTRIBUTE11 MTL_LOT_NUMBERS.ATTRIBUTE11%TYPE,
1153: P_ATTRIBUTE12 MTL_LOT_NUMBERS.ATTRIBUTE12%TYPE,
1154: P_ATTRIBUTE13 MTL_LOT_NUMBERS.ATTRIBUTE13%TYPE,
1155: P_ATTRIBUTE14 MTL_LOT_NUMBERS.ATTRIBUTE14%TYPE,
1156: P_ATTRIBUTE15 MTL_LOT_NUMBERS.ATTRIBUTE15%TYPE,

Line 1153: P_ATTRIBUTE12 MTL_LOT_NUMBERS.ATTRIBUTE12%TYPE,

1149: P_ATTRIBUTE8 MTL_LOT_NUMBERS.ATTRIBUTE8%TYPE,
1150: P_ATTRIBUTE9 MTL_LOT_NUMBERS.ATTRIBUTE9%TYPE,
1151: P_ATTRIBUTE10 MTL_LOT_NUMBERS.ATTRIBUTE10%TYPE,
1152: P_ATTRIBUTE11 MTL_LOT_NUMBERS.ATTRIBUTE11%TYPE,
1153: P_ATTRIBUTE12 MTL_LOT_NUMBERS.ATTRIBUTE12%TYPE,
1154: P_ATTRIBUTE13 MTL_LOT_NUMBERS.ATTRIBUTE13%TYPE,
1155: P_ATTRIBUTE14 MTL_LOT_NUMBERS.ATTRIBUTE14%TYPE,
1156: P_ATTRIBUTE15 MTL_LOT_NUMBERS.ATTRIBUTE15%TYPE,
1157: P_ITEM_DUAL_UOM_CONTROL IN VARCHAR2 , -- hold item's Tracking indicator

Line 1154: P_ATTRIBUTE13 MTL_LOT_NUMBERS.ATTRIBUTE13%TYPE,

1150: P_ATTRIBUTE9 MTL_LOT_NUMBERS.ATTRIBUTE9%TYPE,
1151: P_ATTRIBUTE10 MTL_LOT_NUMBERS.ATTRIBUTE10%TYPE,
1152: P_ATTRIBUTE11 MTL_LOT_NUMBERS.ATTRIBUTE11%TYPE,
1153: P_ATTRIBUTE12 MTL_LOT_NUMBERS.ATTRIBUTE12%TYPE,
1154: P_ATTRIBUTE13 MTL_LOT_NUMBERS.ATTRIBUTE13%TYPE,
1155: P_ATTRIBUTE14 MTL_LOT_NUMBERS.ATTRIBUTE14%TYPE,
1156: P_ATTRIBUTE15 MTL_LOT_NUMBERS.ATTRIBUTE15%TYPE,
1157: P_ITEM_DUAL_UOM_CONTROL IN VARCHAR2 , -- hold item's Tracking indicator
1158: P_copy_pnt_lot_att_flag IN VARCHAR2 ,

Line 1155: P_ATTRIBUTE14 MTL_LOT_NUMBERS.ATTRIBUTE14%TYPE,

1151: P_ATTRIBUTE10 MTL_LOT_NUMBERS.ATTRIBUTE10%TYPE,
1152: P_ATTRIBUTE11 MTL_LOT_NUMBERS.ATTRIBUTE11%TYPE,
1153: P_ATTRIBUTE12 MTL_LOT_NUMBERS.ATTRIBUTE12%TYPE,
1154: P_ATTRIBUTE13 MTL_LOT_NUMBERS.ATTRIBUTE13%TYPE,
1155: P_ATTRIBUTE14 MTL_LOT_NUMBERS.ATTRIBUTE14%TYPE,
1156: P_ATTRIBUTE15 MTL_LOT_NUMBERS.ATTRIBUTE15%TYPE,
1157: P_ITEM_DUAL_UOM_CONTROL IN VARCHAR2 , -- hold item's Tracking indicator
1158: P_copy_pnt_lot_att_flag IN VARCHAR2 ,
1159: p_secondary_default_ind IN VARCHAR2 ,

Line 1156: P_ATTRIBUTE15 MTL_LOT_NUMBERS.ATTRIBUTE15%TYPE,

1152: P_ATTRIBUTE11 MTL_LOT_NUMBERS.ATTRIBUTE11%TYPE,
1153: P_ATTRIBUTE12 MTL_LOT_NUMBERS.ATTRIBUTE12%TYPE,
1154: P_ATTRIBUTE13 MTL_LOT_NUMBERS.ATTRIBUTE13%TYPE,
1155: P_ATTRIBUTE14 MTL_LOT_NUMBERS.ATTRIBUTE14%TYPE,
1156: P_ATTRIBUTE15 MTL_LOT_NUMBERS.ATTRIBUTE15%TYPE,
1157: P_ITEM_DUAL_UOM_CONTROL IN VARCHAR2 , -- hold item's Tracking indicator
1158: P_copy_pnt_lot_att_flag IN VARCHAR2 ,
1159: p_secondary_default_ind IN VARCHAR2 ,
1160: p_disable_flag IN MTL_LOT_NUMBERS.DISABLE_FLAG%TYPE DEFAULT NULL, -- 4239238 Start

Line 1160: p_disable_flag IN MTL_LOT_NUMBERS.DISABLE_FLAG%TYPE DEFAULT NULL, -- 4239238 Start

1156: P_ATTRIBUTE15 MTL_LOT_NUMBERS.ATTRIBUTE15%TYPE,
1157: P_ITEM_DUAL_UOM_CONTROL IN VARCHAR2 , -- hold item's Tracking indicator
1158: P_copy_pnt_lot_att_flag IN VARCHAR2 ,
1159: p_secondary_default_ind IN VARCHAR2 ,
1160: p_disable_flag IN MTL_LOT_NUMBERS.DISABLE_FLAG%TYPE DEFAULT NULL, -- 4239238 Start
1161: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE DEFAULT NULL,
1162: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE DEFAULT NULL,
1163: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE DEFAULT NULL,
1164: p_age IN MTL_LOT_NUMBERS.AGE%TYPE DEFAULT NULL,

Line 1161: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE DEFAULT NULL,

1157: P_ITEM_DUAL_UOM_CONTROL IN VARCHAR2 , -- hold item's Tracking indicator
1158: P_copy_pnt_lot_att_flag IN VARCHAR2 ,
1159: p_secondary_default_ind IN VARCHAR2 ,
1160: p_disable_flag IN MTL_LOT_NUMBERS.DISABLE_FLAG%TYPE DEFAULT NULL, -- 4239238 Start
1161: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE DEFAULT NULL,
1162: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE DEFAULT NULL,
1163: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE DEFAULT NULL,
1164: p_age IN MTL_LOT_NUMBERS.AGE%TYPE DEFAULT NULL,
1165: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE DEFAULT NULL,

Line 1162: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE DEFAULT NULL,

1158: P_copy_pnt_lot_att_flag IN VARCHAR2 ,
1159: p_secondary_default_ind IN VARCHAR2 ,
1160: p_disable_flag IN MTL_LOT_NUMBERS.DISABLE_FLAG%TYPE DEFAULT NULL, -- 4239238 Start
1161: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE DEFAULT NULL,
1162: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE DEFAULT NULL,
1163: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE DEFAULT NULL,
1164: p_age IN MTL_LOT_NUMBERS.AGE%TYPE DEFAULT NULL,
1165: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE DEFAULT NULL,
1166: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE DEFAULT NULL,

Line 1163: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE DEFAULT NULL,

1159: p_secondary_default_ind IN VARCHAR2 ,
1160: p_disable_flag IN MTL_LOT_NUMBERS.DISABLE_FLAG%TYPE DEFAULT NULL, -- 4239238 Start
1161: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE DEFAULT NULL,
1162: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE DEFAULT NULL,
1163: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE DEFAULT NULL,
1164: p_age IN MTL_LOT_NUMBERS.AGE%TYPE DEFAULT NULL,
1165: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE DEFAULT NULL,
1166: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE DEFAULT NULL,
1167: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE DEFAULT NULL,

Line 1164: p_age IN MTL_LOT_NUMBERS.AGE%TYPE DEFAULT NULL,

1160: p_disable_flag IN MTL_LOT_NUMBERS.DISABLE_FLAG%TYPE DEFAULT NULL, -- 4239238 Start
1161: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE DEFAULT NULL,
1162: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE DEFAULT NULL,
1163: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE DEFAULT NULL,
1164: p_age IN MTL_LOT_NUMBERS.AGE%TYPE DEFAULT NULL,
1165: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE DEFAULT NULL,
1166: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE DEFAULT NULL,
1167: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE DEFAULT NULL,
1168: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE DEFAULT NULL,

Line 1165: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE DEFAULT NULL,

1161: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE DEFAULT NULL,
1162: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE DEFAULT NULL,
1163: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE DEFAULT NULL,
1164: p_age IN MTL_LOT_NUMBERS.AGE%TYPE DEFAULT NULL,
1165: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE DEFAULT NULL,
1166: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE DEFAULT NULL,
1167: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE DEFAULT NULL,
1168: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE DEFAULT NULL,
1169: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE DEFAULT NULL,

Line 1166: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE DEFAULT NULL,

1162: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE DEFAULT NULL,
1163: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE DEFAULT NULL,
1164: p_age IN MTL_LOT_NUMBERS.AGE%TYPE DEFAULT NULL,
1165: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE DEFAULT NULL,
1166: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE DEFAULT NULL,
1167: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE DEFAULT NULL,
1168: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE DEFAULT NULL,
1169: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE DEFAULT NULL,
1170: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE DEFAULT NULL,

Line 1167: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE DEFAULT NULL,

1163: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE DEFAULT NULL,
1164: p_age IN MTL_LOT_NUMBERS.AGE%TYPE DEFAULT NULL,
1165: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE DEFAULT NULL,
1166: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE DEFAULT NULL,
1167: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE DEFAULT NULL,
1168: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE DEFAULT NULL,
1169: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE DEFAULT NULL,
1170: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE DEFAULT NULL,
1171: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE DEFAULT NULL,

Line 1168: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE DEFAULT NULL,

1164: p_age IN MTL_LOT_NUMBERS.AGE%TYPE DEFAULT NULL,
1165: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE DEFAULT NULL,
1166: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE DEFAULT NULL,
1167: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE DEFAULT NULL,
1168: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE DEFAULT NULL,
1169: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE DEFAULT NULL,
1170: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE DEFAULT NULL,
1171: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE DEFAULT NULL,
1172: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE DEFAULT NULL,

Line 1169: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE DEFAULT NULL,

1165: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE DEFAULT NULL,
1166: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE DEFAULT NULL,
1167: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE DEFAULT NULL,
1168: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE DEFAULT NULL,
1169: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE DEFAULT NULL,
1170: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE DEFAULT NULL,
1171: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE DEFAULT NULL,
1172: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE DEFAULT NULL,
1173: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE DEFAULT NULL,

Line 1170: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE DEFAULT NULL,

1166: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE DEFAULT NULL,
1167: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE DEFAULT NULL,
1168: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE DEFAULT NULL,
1169: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE DEFAULT NULL,
1170: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE DEFAULT NULL,
1171: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE DEFAULT NULL,
1172: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE DEFAULT NULL,
1173: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE DEFAULT NULL,
1174: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE DEFAULT NULL,

Line 1171: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE DEFAULT NULL,

1167: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE DEFAULT NULL,
1168: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE DEFAULT NULL,
1169: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE DEFAULT NULL,
1170: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE DEFAULT NULL,
1171: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE DEFAULT NULL,
1172: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE DEFAULT NULL,
1173: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE DEFAULT NULL,
1174: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE DEFAULT NULL,
1175: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE DEFAULT NULL,

Line 1172: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE DEFAULT NULL,

1168: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE DEFAULT NULL,
1169: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE DEFAULT NULL,
1170: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE DEFAULT NULL,
1171: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE DEFAULT NULL,
1172: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE DEFAULT NULL,
1173: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE DEFAULT NULL,
1174: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE DEFAULT NULL,
1175: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE DEFAULT NULL,
1176: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE DEFAULT NULL,

Line 1173: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE DEFAULT NULL,

1169: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE DEFAULT NULL,
1170: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE DEFAULT NULL,
1171: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE DEFAULT NULL,
1172: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE DEFAULT NULL,
1173: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE DEFAULT NULL,
1174: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE DEFAULT NULL,
1175: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE DEFAULT NULL,
1176: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE DEFAULT NULL,
1177: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE DEFAULT NULL,

Line 1174: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE DEFAULT NULL,

1170: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE DEFAULT NULL,
1171: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE DEFAULT NULL,
1172: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE DEFAULT NULL,
1173: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE DEFAULT NULL,
1174: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE DEFAULT NULL,
1175: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE DEFAULT NULL,
1176: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE DEFAULT NULL,
1177: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE DEFAULT NULL,
1178: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE DEFAULT NULL,

Line 1175: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE DEFAULT NULL,

1171: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE DEFAULT NULL,
1172: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE DEFAULT NULL,
1173: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE DEFAULT NULL,
1174: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE DEFAULT NULL,
1175: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE DEFAULT NULL,
1176: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE DEFAULT NULL,
1177: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE DEFAULT NULL,
1178: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE DEFAULT NULL,
1179: p_vendor_name IN MTL_LOT_NUMBERS.VENDOR_NAME%TYPE DEFAULT NULL, -- 4239238 End

Line 1176: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE DEFAULT NULL,

1172: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE DEFAULT NULL,
1173: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE DEFAULT NULL,
1174: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE DEFAULT NULL,
1175: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE DEFAULT NULL,
1176: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE DEFAULT NULL,
1177: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE DEFAULT NULL,
1178: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE DEFAULT NULL,
1179: p_vendor_name IN MTL_LOT_NUMBERS.VENDOR_NAME%TYPE DEFAULT NULL, -- 4239238 End
1180: p_source_lot IN VARCHAR2 DEFAULT NULL, --Bug#5349912

Line 1177: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE DEFAULT NULL,

1173: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE DEFAULT NULL,
1174: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE DEFAULT NULL,
1175: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE DEFAULT NULL,
1176: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE DEFAULT NULL,
1177: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE DEFAULT NULL,
1178: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE DEFAULT NULL,
1179: p_vendor_name IN MTL_LOT_NUMBERS.VENDOR_NAME%TYPE DEFAULT NULL, -- 4239238 End
1180: p_source_lot IN VARCHAR2 DEFAULT NULL, --Bug#5349912
1181: p_copy_other_conversions IN VARCHAR2 DEFAULT 'F', --Bug#5349912

Line 1178: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE DEFAULT NULL,

1174: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE DEFAULT NULL,
1175: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE DEFAULT NULL,
1176: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE DEFAULT NULL,
1177: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE DEFAULT NULL,
1178: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE DEFAULT NULL,
1179: p_vendor_name IN MTL_LOT_NUMBERS.VENDOR_NAME%TYPE DEFAULT NULL, -- 4239238 End
1180: p_source_lot IN VARCHAR2 DEFAULT NULL, --Bug#5349912
1181: p_copy_other_conversions IN VARCHAR2 DEFAULT 'F', --Bug#5349912
1182: p_vendor_id IN MTL_LOT_NUMBERS.VENDOR_ID%TYPE DEFAULT NULL, --Bug 9762204

Line 1179: p_vendor_name IN MTL_LOT_NUMBERS.VENDOR_NAME%TYPE DEFAULT NULL, -- 4239238 End

1175: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE DEFAULT NULL,
1176: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE DEFAULT NULL,
1177: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE DEFAULT NULL,
1178: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE DEFAULT NULL,
1179: p_vendor_name IN MTL_LOT_NUMBERS.VENDOR_NAME%TYPE DEFAULT NULL, -- 4239238 End
1180: p_source_lot IN VARCHAR2 DEFAULT NULL, --Bug#5349912
1181: p_copy_other_conversions IN VARCHAR2 DEFAULT 'F', --Bug#5349912
1182: p_vendor_id IN MTL_LOT_NUMBERS.VENDOR_ID%TYPE DEFAULT NULL, --Bug 9762204
1183: p_caculate_flag IN VARCHAR2 DEFAULT 'T' --bug 16604687

Line 1182: p_vendor_id IN MTL_LOT_NUMBERS.VENDOR_ID%TYPE DEFAULT NULL, --Bug 9762204

1178: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE DEFAULT NULL,
1179: p_vendor_name IN MTL_LOT_NUMBERS.VENDOR_NAME%TYPE DEFAULT NULL, -- 4239238 End
1180: p_source_lot IN VARCHAR2 DEFAULT NULL, --Bug#5349912
1181: p_copy_other_conversions IN VARCHAR2 DEFAULT 'F', --Bug#5349912
1182: p_vendor_id IN MTL_LOT_NUMBERS.VENDOR_ID%TYPE DEFAULT NULL, --Bug 9762204
1183: p_caculate_flag IN VARCHAR2 DEFAULT 'T' --bug 16604687
1184: )
1185: IS
1186: l_return_status VARCHAR2(1) ;

Line 1189: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE; -- for lot api

1185: IS
1186: l_return_status VARCHAR2(1) ;
1187: l_msg_data VARCHAR2(3000) ;
1188: l_msg_count NUMBER ;
1189: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE; -- for lot api
1190: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE; -- for lot api
1191: l_lot_uom_conv_rec mtl_lot_uom_class_conversions%ROWTYPE; -- for uom conv
1192: l_qty_update_tbl MTL_LOT_UOM_CONV_PUB.quantity_update_rec_type; -- for uom conv
1193: l_api_version NUMBER;

Line 1190: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE; -- for lot api

1186: l_return_status VARCHAR2(1) ;
1187: l_msg_data VARCHAR2(3000) ;
1188: l_msg_count NUMBER ;
1189: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE; -- for lot api
1190: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE; -- for lot api
1191: l_lot_uom_conv_rec mtl_lot_uom_class_conversions%ROWTYPE; -- for uom conv
1192: l_qty_update_tbl MTL_LOT_UOM_CONV_PUB.quantity_update_rec_type; -- for uom conv
1193: l_api_version NUMBER;
1194: l_init_msg_list VARCHAR2(100);

Line 1251: FROM mtl_lot_numbers

1247:
1248: /* Cursor to check if a lot already exists*/
1249: CURSOR c_lot_exists IS
1250: SELECT 1
1251: FROM mtl_lot_numbers
1252: WHERE organization_id = p_org_id
1253: AND inventory_item_id = p_inventory_item_id
1254: AND lot_number = p_lot_number ;
1255:

Line 1495: FROM mtl_lot_numbers

1491: --Bug#5349912 changed from p_lot_number to p_parent_lot_number in the following query
1492: BEGIN
1493: SELECT count('1')
1494: INTO l_exists
1495: FROM mtl_lot_numbers
1496: WHERE inventory_item_id = P_inventory_item_id
1497: AND organization_id = p_org_id
1498: AND lot_number = p_parent_lot_number
1499: AND ROWNUM = 1;