34: ---------------------------------------------------------------------------
35: -- GLOBAL DATASTRUCTURES
36: ---------------------------------------------------------------------------
37: TYPE cntr_bill_rec_type IS RECORD (
38: clg_id NUMBER := Okl_Api.G_MISS_NUM,
39: counter_group OKL_CNTR_LVLNG_GRPS_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
40: counter_number NUMBER := Okl_Api.G_MISS_NUM,
41: counter_name CS_COUNTERS.NAME%TYPE := Okl_Api.G_MISS_CHAR,
42: contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
35: -- GLOBAL DATASTRUCTURES
36: ---------------------------------------------------------------------------
37: TYPE cntr_bill_rec_type IS RECORD (
38: clg_id NUMBER := Okl_Api.G_MISS_NUM,
39: counter_group OKL_CNTR_LVLNG_GRPS_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
40: counter_number NUMBER := Okl_Api.G_MISS_NUM,
41: counter_name CS_COUNTERS.NAME%TYPE := Okl_Api.G_MISS_CHAR,
42: contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
43: asset_number OKC_K_LINES_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
36: ---------------------------------------------------------------------------
37: TYPE cntr_bill_rec_type IS RECORD (
38: clg_id NUMBER := Okl_Api.G_MISS_NUM,
39: counter_group OKL_CNTR_LVLNG_GRPS_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
40: counter_number NUMBER := Okl_Api.G_MISS_NUM,
41: counter_name CS_COUNTERS.NAME%TYPE := Okl_Api.G_MISS_CHAR,
42: contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
43: asset_number OKC_K_LINES_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
44: asset_serial_number OKX_ASSETS_V.SERIAL_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
37: TYPE cntr_bill_rec_type IS RECORD (
38: clg_id NUMBER := Okl_Api.G_MISS_NUM,
39: counter_group OKL_CNTR_LVLNG_GRPS_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
40: counter_number NUMBER := Okl_Api.G_MISS_NUM,
41: counter_name CS_COUNTERS.NAME%TYPE := Okl_Api.G_MISS_CHAR,
42: contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
43: asset_number OKC_K_LINES_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
44: asset_serial_number OKX_ASSETS_V.SERIAL_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
45: asset_description OKX_ASSETS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
38: clg_id NUMBER := Okl_Api.G_MISS_NUM,
39: counter_group OKL_CNTR_LVLNG_GRPS_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
40: counter_number NUMBER := Okl_Api.G_MISS_NUM,
41: counter_name CS_COUNTERS.NAME%TYPE := Okl_Api.G_MISS_CHAR,
42: contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
43: asset_number OKC_K_LINES_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
44: asset_serial_number OKX_ASSETS_V.SERIAL_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
45: asset_description OKX_ASSETS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
46: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okl_Api.G_MISS_DATE,
39: counter_group OKL_CNTR_LVLNG_GRPS_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
40: counter_number NUMBER := Okl_Api.G_MISS_NUM,
41: counter_name CS_COUNTERS.NAME%TYPE := Okl_Api.G_MISS_CHAR,
42: contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
43: asset_number OKC_K_LINES_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
44: asset_serial_number OKX_ASSETS_V.SERIAL_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
45: asset_description OKX_ASSETS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
46: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okl_Api.G_MISS_DATE,
47: effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okl_Api.G_MISS_DATE,
40: counter_number NUMBER := Okl_Api.G_MISS_NUM,
41: counter_name CS_COUNTERS.NAME%TYPE := Okl_Api.G_MISS_CHAR,
42: contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
43: asset_number OKC_K_LINES_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
44: asset_serial_number OKX_ASSETS_V.SERIAL_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
45: asset_description OKX_ASSETS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
46: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okl_Api.G_MISS_DATE,
47: effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okl_Api.G_MISS_DATE,
48: counter_reading NUMBER := Okl_Api.G_MISS_NUM,
41: counter_name CS_COUNTERS.NAME%TYPE := Okl_Api.G_MISS_CHAR,
42: contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
43: asset_number OKC_K_LINES_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
44: asset_serial_number OKX_ASSETS_V.SERIAL_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
45: asset_description OKX_ASSETS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
46: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okl_Api.G_MISS_DATE,
47: effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okl_Api.G_MISS_DATE,
48: counter_reading NUMBER := Okl_Api.G_MISS_NUM,
49: counter_reading_date DATE := Okl_Api.G_MISS_DATE,
42: contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
43: asset_number OKC_K_LINES_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
44: asset_serial_number OKX_ASSETS_V.SERIAL_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
45: asset_description OKX_ASSETS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
46: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okl_Api.G_MISS_DATE,
47: effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okl_Api.G_MISS_DATE,
48: counter_reading NUMBER := Okl_Api.G_MISS_NUM,
49: counter_reading_date DATE := Okl_Api.G_MISS_DATE,
50: counter_bill_amount NUMBER := Okl_Api.G_MISS_NUM,
43: asset_number OKC_K_LINES_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
44: asset_serial_number OKX_ASSETS_V.SERIAL_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
45: asset_description OKX_ASSETS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
46: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okl_Api.G_MISS_DATE,
47: effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okl_Api.G_MISS_DATE,
48: counter_reading NUMBER := Okl_Api.G_MISS_NUM,
49: counter_reading_date DATE := Okl_Api.G_MISS_DATE,
50: counter_bill_amount NUMBER := Okl_Api.G_MISS_NUM,
51: legal_entity_id NUMBER := Okl_Api.G_MISS_NUM
44: asset_serial_number OKX_ASSETS_V.SERIAL_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
45: asset_description OKX_ASSETS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
46: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okl_Api.G_MISS_DATE,
47: effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okl_Api.G_MISS_DATE,
48: counter_reading NUMBER := Okl_Api.G_MISS_NUM,
49: counter_reading_date DATE := Okl_Api.G_MISS_DATE,
50: counter_bill_amount NUMBER := Okl_Api.G_MISS_NUM,
51: legal_entity_id NUMBER := Okl_Api.G_MISS_NUM
52: );
45: asset_description OKX_ASSETS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
46: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okl_Api.G_MISS_DATE,
47: effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okl_Api.G_MISS_DATE,
48: counter_reading NUMBER := Okl_Api.G_MISS_NUM,
49: counter_reading_date DATE := Okl_Api.G_MISS_DATE,
50: counter_bill_amount NUMBER := Okl_Api.G_MISS_NUM,
51: legal_entity_id NUMBER := Okl_Api.G_MISS_NUM
52: );
53: TYPE cntr_bill_tbl_type IS TABLE OF cntr_bill_rec_type
46: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okl_Api.G_MISS_DATE,
47: effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okl_Api.G_MISS_DATE,
48: counter_reading NUMBER := Okl_Api.G_MISS_NUM,
49: counter_reading_date DATE := Okl_Api.G_MISS_DATE,
50: counter_bill_amount NUMBER := Okl_Api.G_MISS_NUM,
51: legal_entity_id NUMBER := Okl_Api.G_MISS_NUM
52: );
53: TYPE cntr_bill_tbl_type IS TABLE OF cntr_bill_rec_type
54: INDEX BY BINARY_INTEGER;
47: effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okl_Api.G_MISS_DATE,
48: counter_reading NUMBER := Okl_Api.G_MISS_NUM,
49: counter_reading_date DATE := Okl_Api.G_MISS_DATE,
50: counter_bill_amount NUMBER := Okl_Api.G_MISS_NUM,
51: legal_entity_id NUMBER := Okl_Api.G_MISS_NUM
52: );
53: TYPE cntr_bill_tbl_type IS TABLE OF cntr_bill_rec_type
54: INDEX BY BINARY_INTEGER;
55: