45: -- Record structure for contract details search.
46: TYPE achr_rec_type IS RECORD (
47: asset_number OKC_K_LINES_TL.NAME%TYPE := NULL,
48: serial_number CSI_ITEM_INSTANCES.SERIAL_NUMBER%TYPE := NULL,
49: chr_id OKC_K_HEADERS_B.ID%TYPE := NULL,
50: contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL,
51: from_start_date OKC_K_HEADERS_B.START_DATE%TYPE := NULL,
52: to_start_date OKC_K_HEADERS_B.START_DATE%TYPE := NULL,
53: from_end_date OKC_K_HEADERS_B.END_DATE%TYPE := NULL,
46: TYPE achr_rec_type IS RECORD (
47: asset_number OKC_K_LINES_TL.NAME%TYPE := NULL,
48: serial_number CSI_ITEM_INSTANCES.SERIAL_NUMBER%TYPE := NULL,
49: chr_id OKC_K_HEADERS_B.ID%TYPE := NULL,
50: contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL,
51: from_start_date OKC_K_HEADERS_B.START_DATE%TYPE := NULL,
52: to_start_date OKC_K_HEADERS_B.START_DATE%TYPE := NULL,
53: from_end_date OKC_K_HEADERS_B.END_DATE%TYPE := NULL,
54: to_end_date OKC_K_HEADERS_B.END_DATE%TYPE := NULL,
47: asset_number OKC_K_LINES_TL.NAME%TYPE := NULL,
48: serial_number CSI_ITEM_INSTANCES.SERIAL_NUMBER%TYPE := NULL,
49: chr_id OKC_K_HEADERS_B.ID%TYPE := NULL,
50: contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL,
51: from_start_date OKC_K_HEADERS_B.START_DATE%TYPE := NULL,
52: to_start_date OKC_K_HEADERS_B.START_DATE%TYPE := NULL,
53: from_end_date OKC_K_HEADERS_B.END_DATE%TYPE := NULL,
54: to_end_date OKC_K_HEADERS_B.END_DATE%TYPE := NULL,
55: sts_code OKC_K_HEADERS_B.STS_CODE%TYPE := NULL,
48: serial_number CSI_ITEM_INSTANCES.SERIAL_NUMBER%TYPE := NULL,
49: chr_id OKC_K_HEADERS_B.ID%TYPE := NULL,
50: contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL,
51: from_start_date OKC_K_HEADERS_B.START_DATE%TYPE := NULL,
52: to_start_date OKC_K_HEADERS_B.START_DATE%TYPE := NULL,
53: from_end_date OKC_K_HEADERS_B.END_DATE%TYPE := NULL,
54: to_end_date OKC_K_HEADERS_B.END_DATE%TYPE := NULL,
55: sts_code OKC_K_HEADERS_B.STS_CODE%TYPE := NULL,
56: sts_meaning OKC_STATUSES_TL.MEANING%TYPE := NULL,
49: chr_id OKC_K_HEADERS_B.ID%TYPE := NULL,
50: contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL,
51: from_start_date OKC_K_HEADERS_B.START_DATE%TYPE := NULL,
52: to_start_date OKC_K_HEADERS_B.START_DATE%TYPE := NULL,
53: from_end_date OKC_K_HEADERS_B.END_DATE%TYPE := NULL,
54: to_end_date OKC_K_HEADERS_B.END_DATE%TYPE := NULL,
55: sts_code OKC_K_HEADERS_B.STS_CODE%TYPE := NULL,
56: sts_meaning OKC_STATUSES_TL.MEANING%TYPE := NULL,
57: org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE := NULL,
50: contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL,
51: from_start_date OKC_K_HEADERS_B.START_DATE%TYPE := NULL,
52: to_start_date OKC_K_HEADERS_B.START_DATE%TYPE := NULL,
53: from_end_date OKC_K_HEADERS_B.END_DATE%TYPE := NULL,
54: to_end_date OKC_K_HEADERS_B.END_DATE%TYPE := NULL,
55: sts_code OKC_K_HEADERS_B.STS_CODE%TYPE := NULL,
56: sts_meaning OKC_STATUSES_TL.MEANING%TYPE := NULL,
57: org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE := NULL,
58: party_name HZ_PARTIES.PARTY_NAME%TYPE := NULL);
51: from_start_date OKC_K_HEADERS_B.START_DATE%TYPE := NULL,
52: to_start_date OKC_K_HEADERS_B.START_DATE%TYPE := NULL,
53: from_end_date OKC_K_HEADERS_B.END_DATE%TYPE := NULL,
54: to_end_date OKC_K_HEADERS_B.END_DATE%TYPE := NULL,
55: sts_code OKC_K_HEADERS_B.STS_CODE%TYPE := NULL,
56: sts_meaning OKC_STATUSES_TL.MEANING%TYPE := NULL,
57: org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE := NULL,
58: party_name HZ_PARTIES.PARTY_NAME%TYPE := NULL);
59:
53: from_end_date OKC_K_HEADERS_B.END_DATE%TYPE := NULL,
54: to_end_date OKC_K_HEADERS_B.END_DATE%TYPE := NULL,
55: sts_code OKC_K_HEADERS_B.STS_CODE%TYPE := NULL,
56: sts_meaning OKC_STATUSES_TL.MEANING%TYPE := NULL,
57: org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE := NULL,
58: party_name HZ_PARTIES.PARTY_NAME%TYPE := NULL);
59:
60: TYPE achr_tbl_type IS TABLE OF achr_rec_type
61: INDEX BY BINARY_INTEGER;