147: ,cust_site_use_id OKL_TRX_EXTENSION_V.CUST_SITE_USE_ID%TYPE );
148: G_MISS_teh_rec teh_rec_type;
149: TYPE teh_tbl_type IS TABLE OF teh_rec_type
150: INDEX BY BINARY_INTEGER;
151: -- OKL_TRX_EXTENSION_TL Record Spec
152: TYPE tehl_rec_type IS RECORD (
153: header_extension_id NUMBER
154: ,language OKL_TRX_EXTENSION_TL.LANGUAGE%TYPE
155: ,source_lang OKL_TRX_EXTENSION_TL.SOURCE_LANG%TYPE
150: INDEX BY BINARY_INTEGER;
151: -- OKL_TRX_EXTENSION_TL Record Spec
152: TYPE tehl_rec_type IS RECORD (
153: header_extension_id NUMBER
154: ,language OKL_TRX_EXTENSION_TL.LANGUAGE%TYPE
155: ,source_lang OKL_TRX_EXTENSION_TL.SOURCE_LANG%TYPE
156: ,sfwt_flag OKL_TRX_EXTENSION_TL.SFWT_FLAG%TYPE
157: ,contract_status OKL_TRX_EXTENSION_TL.CONTRACT_STATUS%TYPE
158: ,inv_agrmnt_status OKL_TRX_EXTENSION_TL.INV_AGRMNT_STATUS%TYPE
151: -- OKL_TRX_EXTENSION_TL Record Spec
152: TYPE tehl_rec_type IS RECORD (
153: header_extension_id NUMBER
154: ,language OKL_TRX_EXTENSION_TL.LANGUAGE%TYPE
155: ,source_lang OKL_TRX_EXTENSION_TL.SOURCE_LANG%TYPE
156: ,sfwt_flag OKL_TRX_EXTENSION_TL.SFWT_FLAG%TYPE
157: ,contract_status OKL_TRX_EXTENSION_TL.CONTRACT_STATUS%TYPE
158: ,inv_agrmnt_status OKL_TRX_EXTENSION_TL.INV_AGRMNT_STATUS%TYPE
159: ,chr_operating_unit_name OKL_TRX_EXTENSION_TL.CHR_OPERATING_UNIT_NAME%TYPE
152: TYPE tehl_rec_type IS RECORD (
153: header_extension_id NUMBER
154: ,language OKL_TRX_EXTENSION_TL.LANGUAGE%TYPE
155: ,source_lang OKL_TRX_EXTENSION_TL.SOURCE_LANG%TYPE
156: ,sfwt_flag OKL_TRX_EXTENSION_TL.SFWT_FLAG%TYPE
157: ,contract_status OKL_TRX_EXTENSION_TL.CONTRACT_STATUS%TYPE
158: ,inv_agrmnt_status OKL_TRX_EXTENSION_TL.INV_AGRMNT_STATUS%TYPE
159: ,chr_operating_unit_name OKL_TRX_EXTENSION_TL.CHR_OPERATING_UNIT_NAME%TYPE
160: ,transaction_type_name OKL_TRX_EXTENSION_TL.TRANSACTION_TYPE_NAME%TYPE
153: header_extension_id NUMBER
154: ,language OKL_TRX_EXTENSION_TL.LANGUAGE%TYPE
155: ,source_lang OKL_TRX_EXTENSION_TL.SOURCE_LANG%TYPE
156: ,sfwt_flag OKL_TRX_EXTENSION_TL.SFWT_FLAG%TYPE
157: ,contract_status OKL_TRX_EXTENSION_TL.CONTRACT_STATUS%TYPE
158: ,inv_agrmnt_status OKL_TRX_EXTENSION_TL.INV_AGRMNT_STATUS%TYPE
159: ,chr_operating_unit_name OKL_TRX_EXTENSION_TL.CHR_OPERATING_UNIT_NAME%TYPE
160: ,transaction_type_name OKL_TRX_EXTENSION_TL.TRANSACTION_TYPE_NAME%TYPE
161: ,created_by NUMBER
154: ,language OKL_TRX_EXTENSION_TL.LANGUAGE%TYPE
155: ,source_lang OKL_TRX_EXTENSION_TL.SOURCE_LANG%TYPE
156: ,sfwt_flag OKL_TRX_EXTENSION_TL.SFWT_FLAG%TYPE
157: ,contract_status OKL_TRX_EXTENSION_TL.CONTRACT_STATUS%TYPE
158: ,inv_agrmnt_status OKL_TRX_EXTENSION_TL.INV_AGRMNT_STATUS%TYPE
159: ,chr_operating_unit_name OKL_TRX_EXTENSION_TL.CHR_OPERATING_UNIT_NAME%TYPE
160: ,transaction_type_name OKL_TRX_EXTENSION_TL.TRANSACTION_TYPE_NAME%TYPE
161: ,created_by NUMBER
162: ,creation_date OKL_TRX_EXTENSION_TL.CREATION_DATE%TYPE
155: ,source_lang OKL_TRX_EXTENSION_TL.SOURCE_LANG%TYPE
156: ,sfwt_flag OKL_TRX_EXTENSION_TL.SFWT_FLAG%TYPE
157: ,contract_status OKL_TRX_EXTENSION_TL.CONTRACT_STATUS%TYPE
158: ,inv_agrmnt_status OKL_TRX_EXTENSION_TL.INV_AGRMNT_STATUS%TYPE
159: ,chr_operating_unit_name OKL_TRX_EXTENSION_TL.CHR_OPERATING_UNIT_NAME%TYPE
160: ,transaction_type_name OKL_TRX_EXTENSION_TL.TRANSACTION_TYPE_NAME%TYPE
161: ,created_by NUMBER
162: ,creation_date OKL_TRX_EXTENSION_TL.CREATION_DATE%TYPE
163: ,last_updated_by NUMBER
156: ,sfwt_flag OKL_TRX_EXTENSION_TL.SFWT_FLAG%TYPE
157: ,contract_status OKL_TRX_EXTENSION_TL.CONTRACT_STATUS%TYPE
158: ,inv_agrmnt_status OKL_TRX_EXTENSION_TL.INV_AGRMNT_STATUS%TYPE
159: ,chr_operating_unit_name OKL_TRX_EXTENSION_TL.CHR_OPERATING_UNIT_NAME%TYPE
160: ,transaction_type_name OKL_TRX_EXTENSION_TL.TRANSACTION_TYPE_NAME%TYPE
161: ,created_by NUMBER
162: ,creation_date OKL_TRX_EXTENSION_TL.CREATION_DATE%TYPE
163: ,last_updated_by NUMBER
164: ,last_update_date OKL_TRX_EXTENSION_TL.LAST_UPDATE_DATE%TYPE
158: ,inv_agrmnt_status OKL_TRX_EXTENSION_TL.INV_AGRMNT_STATUS%TYPE
159: ,chr_operating_unit_name OKL_TRX_EXTENSION_TL.CHR_OPERATING_UNIT_NAME%TYPE
160: ,transaction_type_name OKL_TRX_EXTENSION_TL.TRANSACTION_TYPE_NAME%TYPE
161: ,created_by NUMBER
162: ,creation_date OKL_TRX_EXTENSION_TL.CREATION_DATE%TYPE
163: ,last_updated_by NUMBER
164: ,last_update_date OKL_TRX_EXTENSION_TL.LAST_UPDATE_DATE%TYPE
165: ,last_update_login NUMBER);
166: G_MISS_tehl_rec tehl_rec_type;
160: ,transaction_type_name OKL_TRX_EXTENSION_TL.TRANSACTION_TYPE_NAME%TYPE
161: ,created_by NUMBER
162: ,creation_date OKL_TRX_EXTENSION_TL.CREATION_DATE%TYPE
163: ,last_updated_by NUMBER
164: ,last_update_date OKL_TRX_EXTENSION_TL.LAST_UPDATE_DATE%TYPE
165: ,last_update_login NUMBER);
166: G_MISS_tehl_rec tehl_rec_type;
167: TYPE tehl_tbl_type IS TABLE OF tehl_rec_type
168: INDEX BY BINARY_INTEGER;