2: /* $Header: GMDPITDS.pls 120.3.12010000.1 2008/07/24 09:56:36 appldev ship $ */
3:
4: -- Header record type
5: TYPE technical_data_hdr_rec IS RECORD
6: (Tech_Data_Id gmd_technical_data_hdr.Tech_Data_Id%TYPE,
7: Organization_Id gmd_technical_data_hdr.Organization_Id%TYPE,
8: Inventory_Item_Id gmd_technical_data_hdr.Inventory_Item_Id%TYPE,
9: Lot_Number gmd_technical_data_hdr.lot_number%TYPE,
10: Lot_Organization_Id gmd_technical_data_hdr.Lot_Organization_Id%TYPE,
3:
4: -- Header record type
5: TYPE technical_data_hdr_rec IS RECORD
6: (Tech_Data_Id gmd_technical_data_hdr.Tech_Data_Id%TYPE,
7: Organization_Id gmd_technical_data_hdr.Organization_Id%TYPE,
8: Inventory_Item_Id gmd_technical_data_hdr.Inventory_Item_Id%TYPE,
9: Lot_Number gmd_technical_data_hdr.lot_number%TYPE,
10: Lot_Organization_Id gmd_technical_data_hdr.Lot_Organization_Id%TYPE,
11: Formula_Id gmd_technical_data_hdr.Formula_Id%TYPE,
4: -- Header record type
5: TYPE technical_data_hdr_rec IS RECORD
6: (Tech_Data_Id gmd_technical_data_hdr.Tech_Data_Id%TYPE,
7: Organization_Id gmd_technical_data_hdr.Organization_Id%TYPE,
8: Inventory_Item_Id gmd_technical_data_hdr.Inventory_Item_Id%TYPE,
9: Lot_Number gmd_technical_data_hdr.lot_number%TYPE,
10: Lot_Organization_Id gmd_technical_data_hdr.Lot_Organization_Id%TYPE,
11: Formula_Id gmd_technical_data_hdr.Formula_Id%TYPE,
12: Batch_Id gmd_technical_data_hdr.Batch_Id%TYPE,
5: TYPE technical_data_hdr_rec IS RECORD
6: (Tech_Data_Id gmd_technical_data_hdr.Tech_Data_Id%TYPE,
7: Organization_Id gmd_technical_data_hdr.Organization_Id%TYPE,
8: Inventory_Item_Id gmd_technical_data_hdr.Inventory_Item_Id%TYPE,
9: Lot_Number gmd_technical_data_hdr.lot_number%TYPE,
10: Lot_Organization_Id gmd_technical_data_hdr.Lot_Organization_Id%TYPE,
11: Formula_Id gmd_technical_data_hdr.Formula_Id%TYPE,
12: Batch_Id gmd_technical_data_hdr.Batch_Id%TYPE,
13: Text_Code gmd_technical_data_hdr.Text_Code%TYPE );
6: (Tech_Data_Id gmd_technical_data_hdr.Tech_Data_Id%TYPE,
7: Organization_Id gmd_technical_data_hdr.Organization_Id%TYPE,
8: Inventory_Item_Id gmd_technical_data_hdr.Inventory_Item_Id%TYPE,
9: Lot_Number gmd_technical_data_hdr.lot_number%TYPE,
10: Lot_Organization_Id gmd_technical_data_hdr.Lot_Organization_Id%TYPE,
11: Formula_Id gmd_technical_data_hdr.Formula_Id%TYPE,
12: Batch_Id gmd_technical_data_hdr.Batch_Id%TYPE,
13: Text_Code gmd_technical_data_hdr.Text_Code%TYPE );
14:
7: Organization_Id gmd_technical_data_hdr.Organization_Id%TYPE,
8: Inventory_Item_Id gmd_technical_data_hdr.Inventory_Item_Id%TYPE,
9: Lot_Number gmd_technical_data_hdr.lot_number%TYPE,
10: Lot_Organization_Id gmd_technical_data_hdr.Lot_Organization_Id%TYPE,
11: Formula_Id gmd_technical_data_hdr.Formula_Id%TYPE,
12: Batch_Id gmd_technical_data_hdr.Batch_Id%TYPE,
13: Text_Code gmd_technical_data_hdr.Text_Code%TYPE );
14:
15: -- Detail record type
8: Inventory_Item_Id gmd_technical_data_hdr.Inventory_Item_Id%TYPE,
9: Lot_Number gmd_technical_data_hdr.lot_number%TYPE,
10: Lot_Organization_Id gmd_technical_data_hdr.Lot_Organization_Id%TYPE,
11: Formula_Id gmd_technical_data_hdr.Formula_Id%TYPE,
12: Batch_Id gmd_technical_data_hdr.Batch_Id%TYPE,
13: Text_Code gmd_technical_data_hdr.Text_Code%TYPE );
14:
15: -- Detail record type
16: TYPE technical_data_dtl_rec IS RECORD
9: Lot_Number gmd_technical_data_hdr.lot_number%TYPE,
10: Lot_Organization_Id gmd_technical_data_hdr.Lot_Organization_Id%TYPE,
11: Formula_Id gmd_technical_data_hdr.Formula_Id%TYPE,
12: Batch_Id gmd_technical_data_hdr.Batch_Id%TYPE,
13: Text_Code gmd_technical_data_hdr.Text_Code%TYPE );
14:
15: -- Detail record type
16: TYPE technical_data_dtl_rec IS RECORD
17: (Tech_Parm_Id gmd_technical_data_dtl.Tech_Parm_Id%TYPE,