60: ,last_update_login NUMBER);
61: G_MISS_tell_rec tell_rec_type;
62: TYPE tell_tbl_type IS TABLE OF tell_rec_type
63: INDEX BY BINARY_INTEGER;
64: -- OKL_TXL_EXTENSION_B Record Spec
65: TYPE tel_rec_type IS RECORD (
66: line_extension_id NUMBER
67: ,source_id NUMBER
68: ,source_table OKL_TXL_EXTENSION_B.SOURCE_TABLE%TYPE
64: -- OKL_TXL_EXTENSION_B Record Spec
65: TYPE tel_rec_type IS RECORD (
66: line_extension_id NUMBER
67: ,source_id NUMBER
68: ,source_table OKL_TXL_EXTENSION_B.SOURCE_TABLE%TYPE
69: ,object_version_number NUMBER
70: ,contract_line_number OKL_TXL_EXTENSION_B.CONTRACT_LINE_NUMBER%TYPE
71: ,fee_type_code OKL_TXL_EXTENSION_B.FEE_TYPE_CODE%TYPE
72: ,asset_number OKL_TXL_EXTENSION_B.ASSET_NUMBER%TYPE
66: line_extension_id NUMBER
67: ,source_id NUMBER
68: ,source_table OKL_TXL_EXTENSION_B.SOURCE_TABLE%TYPE
69: ,object_version_number NUMBER
70: ,contract_line_number OKL_TXL_EXTENSION_B.CONTRACT_LINE_NUMBER%TYPE
71: ,fee_type_code OKL_TXL_EXTENSION_B.FEE_TYPE_CODE%TYPE
72: ,asset_number OKL_TXL_EXTENSION_B.ASSET_NUMBER%TYPE
73: ,asset_category_name OKL_TXL_EXTENSION_B.ASSET_CATEGORY_NAME%TYPE
74: ,asset_vendor_name OKL_TXL_EXTENSION_B.ASSET_VENDOR_NAME%TYPE
67: ,source_id NUMBER
68: ,source_table OKL_TXL_EXTENSION_B.SOURCE_TABLE%TYPE
69: ,object_version_number NUMBER
70: ,contract_line_number OKL_TXL_EXTENSION_B.CONTRACT_LINE_NUMBER%TYPE
71: ,fee_type_code OKL_TXL_EXTENSION_B.FEE_TYPE_CODE%TYPE
72: ,asset_number OKL_TXL_EXTENSION_B.ASSET_NUMBER%TYPE
73: ,asset_category_name OKL_TXL_EXTENSION_B.ASSET_CATEGORY_NAME%TYPE
74: ,asset_vendor_name OKL_TXL_EXTENSION_B.ASSET_VENDOR_NAME%TYPE
75: ,asset_manufacturer_name OKL_TXL_EXTENSION_B.ASSET_MANUFACTURER_NAME%TYPE
68: ,source_table OKL_TXL_EXTENSION_B.SOURCE_TABLE%TYPE
69: ,object_version_number NUMBER
70: ,contract_line_number OKL_TXL_EXTENSION_B.CONTRACT_LINE_NUMBER%TYPE
71: ,fee_type_code OKL_TXL_EXTENSION_B.FEE_TYPE_CODE%TYPE
72: ,asset_number OKL_TXL_EXTENSION_B.ASSET_NUMBER%TYPE
73: ,asset_category_name OKL_TXL_EXTENSION_B.ASSET_CATEGORY_NAME%TYPE
74: ,asset_vendor_name OKL_TXL_EXTENSION_B.ASSET_VENDOR_NAME%TYPE
75: ,asset_manufacturer_name OKL_TXL_EXTENSION_B.ASSET_MANUFACTURER_NAME%TYPE
76: ,asset_year_manufactured OKL_TXL_EXTENSION_B.ASSET_YEAR_MANUFACTURED%TYPE
69: ,object_version_number NUMBER
70: ,contract_line_number OKL_TXL_EXTENSION_B.CONTRACT_LINE_NUMBER%TYPE
71: ,fee_type_code OKL_TXL_EXTENSION_B.FEE_TYPE_CODE%TYPE
72: ,asset_number OKL_TXL_EXTENSION_B.ASSET_NUMBER%TYPE
73: ,asset_category_name OKL_TXL_EXTENSION_B.ASSET_CATEGORY_NAME%TYPE
74: ,asset_vendor_name OKL_TXL_EXTENSION_B.ASSET_VENDOR_NAME%TYPE
75: ,asset_manufacturer_name OKL_TXL_EXTENSION_B.ASSET_MANUFACTURER_NAME%TYPE
76: ,asset_year_manufactured OKL_TXL_EXTENSION_B.ASSET_YEAR_MANUFACTURED%TYPE
77: ,asset_model_number OKL_TXL_EXTENSION_B.ASSET_MODEL_NUMBER%TYPE
70: ,contract_line_number OKL_TXL_EXTENSION_B.CONTRACT_LINE_NUMBER%TYPE
71: ,fee_type_code OKL_TXL_EXTENSION_B.FEE_TYPE_CODE%TYPE
72: ,asset_number OKL_TXL_EXTENSION_B.ASSET_NUMBER%TYPE
73: ,asset_category_name OKL_TXL_EXTENSION_B.ASSET_CATEGORY_NAME%TYPE
74: ,asset_vendor_name OKL_TXL_EXTENSION_B.ASSET_VENDOR_NAME%TYPE
75: ,asset_manufacturer_name OKL_TXL_EXTENSION_B.ASSET_MANUFACTURER_NAME%TYPE
76: ,asset_year_manufactured OKL_TXL_EXTENSION_B.ASSET_YEAR_MANUFACTURED%TYPE
77: ,asset_model_number OKL_TXL_EXTENSION_B.ASSET_MODEL_NUMBER%TYPE
78: ,asset_delivered_date OKL_TXL_EXTENSION_B.ASSET_DELIVERED_DATE%TYPE
71: ,fee_type_code OKL_TXL_EXTENSION_B.FEE_TYPE_CODE%TYPE
72: ,asset_number OKL_TXL_EXTENSION_B.ASSET_NUMBER%TYPE
73: ,asset_category_name OKL_TXL_EXTENSION_B.ASSET_CATEGORY_NAME%TYPE
74: ,asset_vendor_name OKL_TXL_EXTENSION_B.ASSET_VENDOR_NAME%TYPE
75: ,asset_manufacturer_name OKL_TXL_EXTENSION_B.ASSET_MANUFACTURER_NAME%TYPE
76: ,asset_year_manufactured OKL_TXL_EXTENSION_B.ASSET_YEAR_MANUFACTURED%TYPE
77: ,asset_model_number OKL_TXL_EXTENSION_B.ASSET_MODEL_NUMBER%TYPE
78: ,asset_delivered_date OKL_TXL_EXTENSION_B.ASSET_DELIVERED_DATE%TYPE
79: ,installed_site_id NUMBER
72: ,asset_number OKL_TXL_EXTENSION_B.ASSET_NUMBER%TYPE
73: ,asset_category_name OKL_TXL_EXTENSION_B.ASSET_CATEGORY_NAME%TYPE
74: ,asset_vendor_name OKL_TXL_EXTENSION_B.ASSET_VENDOR_NAME%TYPE
75: ,asset_manufacturer_name OKL_TXL_EXTENSION_B.ASSET_MANUFACTURER_NAME%TYPE
76: ,asset_year_manufactured OKL_TXL_EXTENSION_B.ASSET_YEAR_MANUFACTURED%TYPE
77: ,asset_model_number OKL_TXL_EXTENSION_B.ASSET_MODEL_NUMBER%TYPE
78: ,asset_delivered_date OKL_TXL_EXTENSION_B.ASSET_DELIVERED_DATE%TYPE
79: ,installed_site_id NUMBER
80: ,fixed_asset_location_name OKL_TXL_EXTENSION_B.FIXED_ASSET_LOCATION_NAME%TYPE
73: ,asset_category_name OKL_TXL_EXTENSION_B.ASSET_CATEGORY_NAME%TYPE
74: ,asset_vendor_name OKL_TXL_EXTENSION_B.ASSET_VENDOR_NAME%TYPE
75: ,asset_manufacturer_name OKL_TXL_EXTENSION_B.ASSET_MANUFACTURER_NAME%TYPE
76: ,asset_year_manufactured OKL_TXL_EXTENSION_B.ASSET_YEAR_MANUFACTURED%TYPE
77: ,asset_model_number OKL_TXL_EXTENSION_B.ASSET_MODEL_NUMBER%TYPE
78: ,asset_delivered_date OKL_TXL_EXTENSION_B.ASSET_DELIVERED_DATE%TYPE
79: ,installed_site_id NUMBER
80: ,fixed_asset_location_name OKL_TXL_EXTENSION_B.FIXED_ASSET_LOCATION_NAME%TYPE
81: ,contingency_code OKL_TXL_EXTENSION_B.CONTINGENCY_CODE%TYPE
74: ,asset_vendor_name OKL_TXL_EXTENSION_B.ASSET_VENDOR_NAME%TYPE
75: ,asset_manufacturer_name OKL_TXL_EXTENSION_B.ASSET_MANUFACTURER_NAME%TYPE
76: ,asset_year_manufactured OKL_TXL_EXTENSION_B.ASSET_YEAR_MANUFACTURED%TYPE
77: ,asset_model_number OKL_TXL_EXTENSION_B.ASSET_MODEL_NUMBER%TYPE
78: ,asset_delivered_date OKL_TXL_EXTENSION_B.ASSET_DELIVERED_DATE%TYPE
79: ,installed_site_id NUMBER
80: ,fixed_asset_location_name OKL_TXL_EXTENSION_B.FIXED_ASSET_LOCATION_NAME%TYPE
81: ,contingency_code OKL_TXL_EXTENSION_B.CONTINGENCY_CODE%TYPE
82: ,subsidy_name OKL_TXL_EXTENSION_B.SUBSIDY_NAME%TYPE
76: ,asset_year_manufactured OKL_TXL_EXTENSION_B.ASSET_YEAR_MANUFACTURED%TYPE
77: ,asset_model_number OKL_TXL_EXTENSION_B.ASSET_MODEL_NUMBER%TYPE
78: ,asset_delivered_date OKL_TXL_EXTENSION_B.ASSET_DELIVERED_DATE%TYPE
79: ,installed_site_id NUMBER
80: ,fixed_asset_location_name OKL_TXL_EXTENSION_B.FIXED_ASSET_LOCATION_NAME%TYPE
81: ,contingency_code OKL_TXL_EXTENSION_B.CONTINGENCY_CODE%TYPE
82: ,subsidy_name OKL_TXL_EXTENSION_B.SUBSIDY_NAME%TYPE
83: ,subsidy_party_name OKL_TXL_EXTENSION_B.SUBSIDY_PARTY_NAME%TYPE
84: ,memo_flag OKL_TXL_EXTENSION_B.MEMO_FLAG%TYPE
77: ,asset_model_number OKL_TXL_EXTENSION_B.ASSET_MODEL_NUMBER%TYPE
78: ,asset_delivered_date OKL_TXL_EXTENSION_B.ASSET_DELIVERED_DATE%TYPE
79: ,installed_site_id NUMBER
80: ,fixed_asset_location_name OKL_TXL_EXTENSION_B.FIXED_ASSET_LOCATION_NAME%TYPE
81: ,contingency_code OKL_TXL_EXTENSION_B.CONTINGENCY_CODE%TYPE
82: ,subsidy_name OKL_TXL_EXTENSION_B.SUBSIDY_NAME%TYPE
83: ,subsidy_party_name OKL_TXL_EXTENSION_B.SUBSIDY_PARTY_NAME%TYPE
84: ,memo_flag OKL_TXL_EXTENSION_B.MEMO_FLAG%TYPE
85: ,recievables_trx_type_name OKL_TXL_EXTENSION_B.RECIEVABLES_TRX_TYPE_NAME%TYPE
78: ,asset_delivered_date OKL_TXL_EXTENSION_B.ASSET_DELIVERED_DATE%TYPE
79: ,installed_site_id NUMBER
80: ,fixed_asset_location_name OKL_TXL_EXTENSION_B.FIXED_ASSET_LOCATION_NAME%TYPE
81: ,contingency_code OKL_TXL_EXTENSION_B.CONTINGENCY_CODE%TYPE
82: ,subsidy_name OKL_TXL_EXTENSION_B.SUBSIDY_NAME%TYPE
83: ,subsidy_party_name OKL_TXL_EXTENSION_B.SUBSIDY_PARTY_NAME%TYPE
84: ,memo_flag OKL_TXL_EXTENSION_B.MEMO_FLAG%TYPE
85: ,recievables_trx_type_name OKL_TXL_EXTENSION_B.RECIEVABLES_TRX_TYPE_NAME%TYPE
86: ,aging_bucket_name OKL_TXL_EXTENSION_B.AGING_BUCKET_NAME%TYPE
79: ,installed_site_id NUMBER
80: ,fixed_asset_location_name OKL_TXL_EXTENSION_B.FIXED_ASSET_LOCATION_NAME%TYPE
81: ,contingency_code OKL_TXL_EXTENSION_B.CONTINGENCY_CODE%TYPE
82: ,subsidy_name OKL_TXL_EXTENSION_B.SUBSIDY_NAME%TYPE
83: ,subsidy_party_name OKL_TXL_EXTENSION_B.SUBSIDY_PARTY_NAME%TYPE
84: ,memo_flag OKL_TXL_EXTENSION_B.MEMO_FLAG%TYPE
85: ,recievables_trx_type_name OKL_TXL_EXTENSION_B.RECIEVABLES_TRX_TYPE_NAME%TYPE
86: ,aging_bucket_name OKL_TXL_EXTENSION_B.AGING_BUCKET_NAME%TYPE
87: ,contract_line_type OKL_TXL_EXTENSION_B.CONTRACT_LINE_TYPE%TYPE
80: ,fixed_asset_location_name OKL_TXL_EXTENSION_B.FIXED_ASSET_LOCATION_NAME%TYPE
81: ,contingency_code OKL_TXL_EXTENSION_B.CONTINGENCY_CODE%TYPE
82: ,subsidy_name OKL_TXL_EXTENSION_B.SUBSIDY_NAME%TYPE
83: ,subsidy_party_name OKL_TXL_EXTENSION_B.SUBSIDY_PARTY_NAME%TYPE
84: ,memo_flag OKL_TXL_EXTENSION_B.MEMO_FLAG%TYPE
85: ,recievables_trx_type_name OKL_TXL_EXTENSION_B.RECIEVABLES_TRX_TYPE_NAME%TYPE
86: ,aging_bucket_name OKL_TXL_EXTENSION_B.AGING_BUCKET_NAME%TYPE
87: ,contract_line_type OKL_TXL_EXTENSION_B.CONTRACT_LINE_TYPE%TYPE
88: ,pay_supplier_site_name OKL_TXL_EXTENSION_B.PAY_SUPPLIER_SITE_NAME%TYPE
81: ,contingency_code OKL_TXL_EXTENSION_B.CONTINGENCY_CODE%TYPE
82: ,subsidy_name OKL_TXL_EXTENSION_B.SUBSIDY_NAME%TYPE
83: ,subsidy_party_name OKL_TXL_EXTENSION_B.SUBSIDY_PARTY_NAME%TYPE
84: ,memo_flag OKL_TXL_EXTENSION_B.MEMO_FLAG%TYPE
85: ,recievables_trx_type_name OKL_TXL_EXTENSION_B.RECIEVABLES_TRX_TYPE_NAME%TYPE
86: ,aging_bucket_name OKL_TXL_EXTENSION_B.AGING_BUCKET_NAME%TYPE
87: ,contract_line_type OKL_TXL_EXTENSION_B.CONTRACT_LINE_TYPE%TYPE
88: ,pay_supplier_site_name OKL_TXL_EXTENSION_B.PAY_SUPPLIER_SITE_NAME%TYPE
89: ,created_by NUMBER
82: ,subsidy_name OKL_TXL_EXTENSION_B.SUBSIDY_NAME%TYPE
83: ,subsidy_party_name OKL_TXL_EXTENSION_B.SUBSIDY_PARTY_NAME%TYPE
84: ,memo_flag OKL_TXL_EXTENSION_B.MEMO_FLAG%TYPE
85: ,recievables_trx_type_name OKL_TXL_EXTENSION_B.RECIEVABLES_TRX_TYPE_NAME%TYPE
86: ,aging_bucket_name OKL_TXL_EXTENSION_B.AGING_BUCKET_NAME%TYPE
87: ,contract_line_type OKL_TXL_EXTENSION_B.CONTRACT_LINE_TYPE%TYPE
88: ,pay_supplier_site_name OKL_TXL_EXTENSION_B.PAY_SUPPLIER_SITE_NAME%TYPE
89: ,created_by NUMBER
90: ,creation_date OKL_TXL_EXTENSION_B.CREATION_DATE%TYPE
83: ,subsidy_party_name OKL_TXL_EXTENSION_B.SUBSIDY_PARTY_NAME%TYPE
84: ,memo_flag OKL_TXL_EXTENSION_B.MEMO_FLAG%TYPE
85: ,recievables_trx_type_name OKL_TXL_EXTENSION_B.RECIEVABLES_TRX_TYPE_NAME%TYPE
86: ,aging_bucket_name OKL_TXL_EXTENSION_B.AGING_BUCKET_NAME%TYPE
87: ,contract_line_type OKL_TXL_EXTENSION_B.CONTRACT_LINE_TYPE%TYPE
88: ,pay_supplier_site_name OKL_TXL_EXTENSION_B.PAY_SUPPLIER_SITE_NAME%TYPE
89: ,created_by NUMBER
90: ,creation_date OKL_TXL_EXTENSION_B.CREATION_DATE%TYPE
91: ,last_updated_by NUMBER
84: ,memo_flag OKL_TXL_EXTENSION_B.MEMO_FLAG%TYPE
85: ,recievables_trx_type_name OKL_TXL_EXTENSION_B.RECIEVABLES_TRX_TYPE_NAME%TYPE
86: ,aging_bucket_name OKL_TXL_EXTENSION_B.AGING_BUCKET_NAME%TYPE
87: ,contract_line_type OKL_TXL_EXTENSION_B.CONTRACT_LINE_TYPE%TYPE
88: ,pay_supplier_site_name OKL_TXL_EXTENSION_B.PAY_SUPPLIER_SITE_NAME%TYPE
89: ,created_by NUMBER
90: ,creation_date OKL_TXL_EXTENSION_B.CREATION_DATE%TYPE
91: ,last_updated_by NUMBER
92: ,last_update_date OKL_TXL_EXTENSION_B.LAST_UPDATE_DATE%TYPE
86: ,aging_bucket_name OKL_TXL_EXTENSION_B.AGING_BUCKET_NAME%TYPE
87: ,contract_line_type OKL_TXL_EXTENSION_B.CONTRACT_LINE_TYPE%TYPE
88: ,pay_supplier_site_name OKL_TXL_EXTENSION_B.PAY_SUPPLIER_SITE_NAME%TYPE
89: ,created_by NUMBER
90: ,creation_date OKL_TXL_EXTENSION_B.CREATION_DATE%TYPE
91: ,last_updated_by NUMBER
92: ,last_update_date OKL_TXL_EXTENSION_B.LAST_UPDATE_DATE%TYPE
93: ,last_update_login NUMBER
94: ,teh_id NUMBER
88: ,pay_supplier_site_name OKL_TXL_EXTENSION_B.PAY_SUPPLIER_SITE_NAME%TYPE
89: ,created_by NUMBER
90: ,creation_date OKL_TXL_EXTENSION_B.CREATION_DATE%TYPE
91: ,last_updated_by NUMBER
92: ,last_update_date OKL_TXL_EXTENSION_B.LAST_UPDATE_DATE%TYPE
93: ,last_update_login NUMBER
94: ,teh_id NUMBER
95: ,inventory_item_name_code OKL_TXL_EXTENSION_B.INVENTORY_ITEM_NAME_CODE%TYPE
96: ,inventory_org_code OKL_TXL_EXTENSION_B.INVENTORY_ORG_CODE%TYPE
91: ,last_updated_by NUMBER
92: ,last_update_date OKL_TXL_EXTENSION_B.LAST_UPDATE_DATE%TYPE
93: ,last_update_login NUMBER
94: ,teh_id NUMBER
95: ,inventory_item_name_code OKL_TXL_EXTENSION_B.INVENTORY_ITEM_NAME_CODE%TYPE
96: ,inventory_org_code OKL_TXL_EXTENSION_B.INVENTORY_ORG_CODE%TYPE
97: ,vendor_site_id OKL_TXL_EXTENSION_B.VENDOR_SITE_ID%TYPE
98: , subsidy_vendor_id OKL_TXL_EXTENSION_B.SUBSIDY_VENDOR_ID%TYPE
99: ,asset_vendor_id OKL_TXL_EXTENSION_B.ASSET_VENDOR_ID%TYPE);
92: ,last_update_date OKL_TXL_EXTENSION_B.LAST_UPDATE_DATE%TYPE
93: ,last_update_login NUMBER
94: ,teh_id NUMBER
95: ,inventory_item_name_code OKL_TXL_EXTENSION_B.INVENTORY_ITEM_NAME_CODE%TYPE
96: ,inventory_org_code OKL_TXL_EXTENSION_B.INVENTORY_ORG_CODE%TYPE
97: ,vendor_site_id OKL_TXL_EXTENSION_B.VENDOR_SITE_ID%TYPE
98: , subsidy_vendor_id OKL_TXL_EXTENSION_B.SUBSIDY_VENDOR_ID%TYPE
99: ,asset_vendor_id OKL_TXL_EXTENSION_B.ASSET_VENDOR_ID%TYPE);
100: G_MISS_tel_rec tel_rec_type;
93: ,last_update_login NUMBER
94: ,teh_id NUMBER
95: ,inventory_item_name_code OKL_TXL_EXTENSION_B.INVENTORY_ITEM_NAME_CODE%TYPE
96: ,inventory_org_code OKL_TXL_EXTENSION_B.INVENTORY_ORG_CODE%TYPE
97: ,vendor_site_id OKL_TXL_EXTENSION_B.VENDOR_SITE_ID%TYPE
98: , subsidy_vendor_id OKL_TXL_EXTENSION_B.SUBSIDY_VENDOR_ID%TYPE
99: ,asset_vendor_id OKL_TXL_EXTENSION_B.ASSET_VENDOR_ID%TYPE);
100: G_MISS_tel_rec tel_rec_type;
101: TYPE tel_tbl_type IS TABLE OF tel_rec_type
94: ,teh_id NUMBER
95: ,inventory_item_name_code OKL_TXL_EXTENSION_B.INVENTORY_ITEM_NAME_CODE%TYPE
96: ,inventory_org_code OKL_TXL_EXTENSION_B.INVENTORY_ORG_CODE%TYPE
97: ,vendor_site_id OKL_TXL_EXTENSION_B.VENDOR_SITE_ID%TYPE
98: , subsidy_vendor_id OKL_TXL_EXTENSION_B.SUBSIDY_VENDOR_ID%TYPE
99: ,asset_vendor_id OKL_TXL_EXTENSION_B.ASSET_VENDOR_ID%TYPE);
100: G_MISS_tel_rec tel_rec_type;
101: TYPE tel_tbl_type IS TABLE OF tel_rec_type
102: INDEX BY BINARY_INTEGER;
95: ,inventory_item_name_code OKL_TXL_EXTENSION_B.INVENTORY_ITEM_NAME_CODE%TYPE
96: ,inventory_org_code OKL_TXL_EXTENSION_B.INVENTORY_ORG_CODE%TYPE
97: ,vendor_site_id OKL_TXL_EXTENSION_B.VENDOR_SITE_ID%TYPE
98: , subsidy_vendor_id OKL_TXL_EXTENSION_B.SUBSIDY_VENDOR_ID%TYPE
99: ,asset_vendor_id OKL_TXL_EXTENSION_B.ASSET_VENDOR_ID%TYPE);
100: G_MISS_tel_rec tel_rec_type;
101: TYPE tel_tbl_type IS TABLE OF tel_rec_type
102: INDEX BY BINARY_INTEGER;
103: -- Start : PRASJAIN : Bug# 6268782
107: );
108: TYPE tel_tbl_tbl_type IS TABLE OF tel_tbl_rec_type
109: INDEX BY BINARY_INTEGER;
110: -- End : PRASJAIN : Bug# 6268782
111: TYPE txl_tbl_type IS TABLE OF OKL_TXL_EXTENSION_B%ROWTYPE;
112: TYPE txll_tbl_type IS TABLE OF OKL_TXL_EXTENSION_TL%ROWTYPE;
113: ---------------------------------------------------------------------------
114: -- GLOBAL MESSAGE CONSTANTS
115: ---------------------------------------------------------------------------