[Home] [Help]
102: */
103: /*
104: ** Global Column Headings
105: */
106: G_INGCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
107: G_INGMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
108: G_INGCONC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
109: G_INGUSER_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
110: G_INGEEC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
103: /*
104: ** Global Column Headings
105: */
106: G_INGCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
107: G_INGMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
108: G_INGCONC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
109: G_INGUSER_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
110: G_INGEEC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
111: G_INGHAZARD_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
104: ** Global Column Headings
105: */
106: G_INGCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
107: G_INGMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
108: G_INGCONC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
109: G_INGUSER_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
110: G_INGEEC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
111: G_INGHAZARD_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
112: G_INGNFPA_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
105: */
106: G_INGCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
107: G_INGMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
108: G_INGCONC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
109: G_INGUSER_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
110: G_INGEEC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
111: G_INGHAZARD_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
112: G_INGNFPA_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
113: G_INGHMIS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
106: G_INGCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
107: G_INGMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
108: G_INGCONC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
109: G_INGUSER_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
110: G_INGEEC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
111: G_INGHAZARD_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
112: G_INGNFPA_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
113: G_INGHMIS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
114: G_INGRISK_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
107: G_INGMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
108: G_INGCONC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
109: G_INGUSER_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
110: G_INGEEC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
111: G_INGHAZARD_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
112: G_INGNFPA_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
113: G_INGHMIS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
114: G_INGRISK_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
115: G_INGSAFETY_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
108: G_INGCONC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
109: G_INGUSER_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
110: G_INGEEC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
111: G_INGHAZARD_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
112: G_INGNFPA_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
113: G_INGHMIS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
114: G_INGRISK_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
115: G_INGSAFETY_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
116: G_EXPCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
109: G_INGUSER_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
110: G_INGEEC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
111: G_INGHAZARD_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
112: G_INGNFPA_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
113: G_INGHMIS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
114: G_INGRISK_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
115: G_INGSAFETY_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
116: G_EXPCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
117: G_EXPMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
110: G_INGEEC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
111: G_INGHAZARD_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
112: G_INGNFPA_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
113: G_INGHMIS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
114: G_INGRISK_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
115: G_INGSAFETY_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
116: G_EXPCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
117: G_EXPMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
118: G_EXPAUTH_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
111: G_INGHAZARD_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
112: G_INGNFPA_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
113: G_INGHMIS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
114: G_INGRISK_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
115: G_INGSAFETY_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
116: G_EXPCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
117: G_EXPMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
118: G_EXPAUTH_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
119: G_EXPTYPE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
112: G_INGNFPA_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
113: G_INGHMIS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
114: G_INGRISK_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
115: G_INGSAFETY_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
116: G_EXPCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
117: G_EXPMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
118: G_EXPAUTH_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
119: G_EXPTYPE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
120: G_EXPDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
113: G_INGHMIS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
114: G_INGRISK_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
115: G_INGSAFETY_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
116: G_EXPCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
117: G_EXPMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
118: G_EXPAUTH_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
119: G_EXPTYPE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
120: G_EXPDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
121: G_EXPNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
114: G_INGRISK_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
115: G_INGSAFETY_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
116: G_EXPCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
117: G_EXPMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
118: G_EXPAUTH_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
119: G_EXPTYPE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
120: G_EXPDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
121: G_EXPNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
122: G_TOXCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
115: G_INGSAFETY_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
116: G_EXPCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
117: G_EXPMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
118: G_EXPAUTH_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
119: G_EXPTYPE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
120: G_EXPDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
121: G_EXPNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
122: G_TOXCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
123: G_TOXMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
116: G_EXPCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
117: G_EXPMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
118: G_EXPAUTH_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
119: G_EXPTYPE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
120: G_EXPDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
121: G_EXPNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
122: G_TOXCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
123: G_TOXMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
124: G_TOXSPECIES_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
117: G_EXPMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
118: G_EXPAUTH_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
119: G_EXPTYPE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
120: G_EXPDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
121: G_EXPNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
122: G_TOXCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
123: G_TOXMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
124: G_TOXSPECIES_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
125: G_TOXEXPOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
118: G_EXPAUTH_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
119: G_EXPTYPE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
120: G_EXPDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
121: G_EXPNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
122: G_TOXCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
123: G_TOXMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
124: G_TOXSPECIES_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
125: G_TOXEXPOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
126: G_TOXROUTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
119: G_EXPTYPE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
120: G_EXPDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
121: G_EXPNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
122: G_TOXCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
123: G_TOXMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
124: G_TOXSPECIES_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
125: G_TOXEXPOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
126: G_TOXROUTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
127: G_TOXDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
120: G_EXPDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
121: G_EXPNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
122: G_TOXCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
123: G_TOXMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
124: G_TOXSPECIES_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
125: G_TOXEXPOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
126: G_TOXROUTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
127: G_TOXDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
128: G_TOXNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
121: G_EXPNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
122: G_TOXCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
123: G_TOXMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
124: G_TOXSPECIES_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
125: G_TOXEXPOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
126: G_TOXROUTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
127: G_TOXDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
128: G_TOXNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
129: G_PRINT_COL_HDG VARCHAR2(1);
122: G_TOXCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
123: G_TOXMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
124: G_TOXSPECIES_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
125: G_TOXEXPOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
126: G_TOXROUTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
127: G_TOXDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
128: G_TOXNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
129: G_PRINT_COL_HDG VARCHAR2(1);
130:
123: G_TOXMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
124: G_TOXSPECIES_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
125: G_TOXEXPOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
126: G_TOXROUTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
127: G_TOXDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
128: G_TOXNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
129: G_PRINT_COL_HDG VARCHAR2(1);
130:
131: /*
124: G_TOXSPECIES_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
125: G_TOXEXPOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
126: G_TOXROUTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
127: G_TOXDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
128: G_TOXNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
129: G_PRINT_COL_HDG VARCHAR2(1);
130:
131: /*
132: ** Global numeric variable definitions
262: IS
263: SELECT shb.sub_heading_print_font,
264: shb.sub_heading_print_size,
265: sht.sub_heading_desc
266: FROM gr_sub_headings_tl sht,
267: gr_sub_headings_b shb
268: WHERE shb.sub_heading_code = g_sub_heading
269: AND sht.sub_heading_code = g_sub_heading
270: AND sht.language = g_language_code;