20: TYPE ubn_tbl_type IS TABLE OF ubn_rec_type
21: INDEX BY BINARY_INTEGER;
22:
23: TYPE ubnv_rec_type IS RECORD (
24: id OKC_USER_BINS_V.ID%TYPE, -- := OKC_API.G_MISS_NUM,
25: contract_id OKC_USER_BINS_V.CONTRACT_ID%TYPE, -- := OKC_API.G_MISS_NUM,
26: contract_number OKC_USER_BINS_V.CONTRACT_NUMBER%TYPE, -- := OKC_API.G_MISS_CHAR,
27: bin_type OKC_USER_BINS_V.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
28: contract_type OKC_USER_BINS_V.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
21: INDEX BY BINARY_INTEGER;
22:
23: TYPE ubnv_rec_type IS RECORD (
24: id OKC_USER_BINS_V.ID%TYPE, -- := OKC_API.G_MISS_NUM,
25: contract_id OKC_USER_BINS_V.CONTRACT_ID%TYPE, -- := OKC_API.G_MISS_NUM,
26: contract_number OKC_USER_BINS_V.CONTRACT_NUMBER%TYPE, -- := OKC_API.G_MISS_CHAR,
27: bin_type OKC_USER_BINS_V.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
28: contract_type OKC_USER_BINS_V.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
29: program_name OKC_USER_BINS_V.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
22:
23: TYPE ubnv_rec_type IS RECORD (
24: id OKC_USER_BINS_V.ID%TYPE, -- := OKC_API.G_MISS_NUM,
25: contract_id OKC_USER_BINS_V.CONTRACT_ID%TYPE, -- := OKC_API.G_MISS_NUM,
26: contract_number OKC_USER_BINS_V.CONTRACT_NUMBER%TYPE, -- := OKC_API.G_MISS_CHAR,
27: bin_type OKC_USER_BINS_V.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
28: contract_type OKC_USER_BINS_V.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
29: program_name OKC_USER_BINS_V.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
30: created_by OKC_USER_BINS_V.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,
23: TYPE ubnv_rec_type IS RECORD (
24: id OKC_USER_BINS_V.ID%TYPE, -- := OKC_API.G_MISS_NUM,
25: contract_id OKC_USER_BINS_V.CONTRACT_ID%TYPE, -- := OKC_API.G_MISS_NUM,
26: contract_number OKC_USER_BINS_V.CONTRACT_NUMBER%TYPE, -- := OKC_API.G_MISS_CHAR,
27: bin_type OKC_USER_BINS_V.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
28: contract_type OKC_USER_BINS_V.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
29: program_name OKC_USER_BINS_V.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
30: created_by OKC_USER_BINS_V.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,
31: creation_date OKC_USER_BINS_V.CREATION_DATE%TYPE, -- := OKC_API.G_MISS_DATE,
24: id OKC_USER_BINS_V.ID%TYPE, -- := OKC_API.G_MISS_NUM,
25: contract_id OKC_USER_BINS_V.CONTRACT_ID%TYPE, -- := OKC_API.G_MISS_NUM,
26: contract_number OKC_USER_BINS_V.CONTRACT_NUMBER%TYPE, -- := OKC_API.G_MISS_CHAR,
27: bin_type OKC_USER_BINS_V.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
28: contract_type OKC_USER_BINS_V.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
29: program_name OKC_USER_BINS_V.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
30: created_by OKC_USER_BINS_V.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,
31: creation_date OKC_USER_BINS_V.CREATION_DATE%TYPE, -- := OKC_API.G_MISS_DATE,
32: contract_number_modifier OKC_USER_BINS_V.CONTRACT_NUMBER_MODIFIER%TYPE, -- := OKC_API.G_MISS_CHAR,
25: contract_id OKC_USER_BINS_V.CONTRACT_ID%TYPE, -- := OKC_API.G_MISS_NUM,
26: contract_number OKC_USER_BINS_V.CONTRACT_NUMBER%TYPE, -- := OKC_API.G_MISS_CHAR,
27: bin_type OKC_USER_BINS_V.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
28: contract_type OKC_USER_BINS_V.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
29: program_name OKC_USER_BINS_V.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
30: created_by OKC_USER_BINS_V.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,
31: creation_date OKC_USER_BINS_V.CREATION_DATE%TYPE, -- := OKC_API.G_MISS_DATE,
32: contract_number_modifier OKC_USER_BINS_V.CONTRACT_NUMBER_MODIFIER%TYPE, -- := OKC_API.G_MISS_CHAR,
33: short_description OKC_USER_BINS_V.SHORT_DESCRIPTION%TYPE); -- := OKC_API.G_MISS_CHAR);
26: contract_number OKC_USER_BINS_V.CONTRACT_NUMBER%TYPE, -- := OKC_API.G_MISS_CHAR,
27: bin_type OKC_USER_BINS_V.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
28: contract_type OKC_USER_BINS_V.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
29: program_name OKC_USER_BINS_V.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
30: created_by OKC_USER_BINS_V.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,
31: creation_date OKC_USER_BINS_V.CREATION_DATE%TYPE, -- := OKC_API.G_MISS_DATE,
32: contract_number_modifier OKC_USER_BINS_V.CONTRACT_NUMBER_MODIFIER%TYPE, -- := OKC_API.G_MISS_CHAR,
33: short_description OKC_USER_BINS_V.SHORT_DESCRIPTION%TYPE); -- := OKC_API.G_MISS_CHAR);
34:
27: bin_type OKC_USER_BINS_V.BIN_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
28: contract_type OKC_USER_BINS_V.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
29: program_name OKC_USER_BINS_V.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
30: created_by OKC_USER_BINS_V.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,
31: creation_date OKC_USER_BINS_V.CREATION_DATE%TYPE, -- := OKC_API.G_MISS_DATE,
32: contract_number_modifier OKC_USER_BINS_V.CONTRACT_NUMBER_MODIFIER%TYPE, -- := OKC_API.G_MISS_CHAR,
33: short_description OKC_USER_BINS_V.SHORT_DESCRIPTION%TYPE); -- := OKC_API.G_MISS_CHAR);
34:
35: g_miss_ubnv_rec ubnv_rec_type;
28: contract_type OKC_USER_BINS_V.CONTRACT_TYPE%TYPE, -- := OKC_API.G_MISS_CHAR,
29: program_name OKC_USER_BINS_V.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
30: created_by OKC_USER_BINS_V.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,
31: creation_date OKC_USER_BINS_V.CREATION_DATE%TYPE, -- := OKC_API.G_MISS_DATE,
32: contract_number_modifier OKC_USER_BINS_V.CONTRACT_NUMBER_MODIFIER%TYPE, -- := OKC_API.G_MISS_CHAR,
33: short_description OKC_USER_BINS_V.SHORT_DESCRIPTION%TYPE); -- := OKC_API.G_MISS_CHAR);
34:
35: g_miss_ubnv_rec ubnv_rec_type;
36:
29: program_name OKC_USER_BINS_V.PROGRAM_NAME%TYPE, -- := OKC_API.G_MISS_CHAR,
30: created_by OKC_USER_BINS_V.CREATED_BY%TYPE, -- := OKC_API.G_MISS_NUM,
31: creation_date OKC_USER_BINS_V.CREATION_DATE%TYPE, -- := OKC_API.G_MISS_DATE,
32: contract_number_modifier OKC_USER_BINS_V.CONTRACT_NUMBER_MODIFIER%TYPE, -- := OKC_API.G_MISS_CHAR,
33: short_description OKC_USER_BINS_V.SHORT_DESCRIPTION%TYPE); -- := OKC_API.G_MISS_CHAR);
34:
35: g_miss_ubnv_rec ubnv_rec_type;
36:
37: TYPE ubnv_tbl_type IS TABLE OF ubnv_rec_type