19: INDEX BY BINARY_INTEGER;
20: TYPE aqmv_rec_type IS RECORD (
21: aqe_id NUMBER := OKC_API.G_MISS_NUM,
22: msg_seq_no NUMBER := OKC_API.G_MISS_NUM,
23: message_name OKC_AQMSGSTACKS_V.MESSAGE_NAME%TYPE := OKC_API.G_MISS_CHAR,
24: message_number OKC_AQMSGSTACKS_V.MESSAGE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
25: message_text OKC_AQMSGSTACKS_V.MESSAGE_TEXT%TYPE := OKC_API.G_MISS_CHAR,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_AQMSGSTACKS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
20: TYPE aqmv_rec_type IS RECORD (
21: aqe_id NUMBER := OKC_API.G_MISS_NUM,
22: msg_seq_no NUMBER := OKC_API.G_MISS_NUM,
23: message_name OKC_AQMSGSTACKS_V.MESSAGE_NAME%TYPE := OKC_API.G_MISS_CHAR,
24: message_number OKC_AQMSGSTACKS_V.MESSAGE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
25: message_text OKC_AQMSGSTACKS_V.MESSAGE_TEXT%TYPE := OKC_API.G_MISS_CHAR,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_AQMSGSTACKS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
21: aqe_id NUMBER := OKC_API.G_MISS_NUM,
22: msg_seq_no NUMBER := OKC_API.G_MISS_NUM,
23: message_name OKC_AQMSGSTACKS_V.MESSAGE_NAME%TYPE := OKC_API.G_MISS_CHAR,
24: message_number OKC_AQMSGSTACKS_V.MESSAGE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
25: message_text OKC_AQMSGSTACKS_V.MESSAGE_TEXT%TYPE := OKC_API.G_MISS_CHAR,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_AQMSGSTACKS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_AQMSGSTACKS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
23: message_name OKC_AQMSGSTACKS_V.MESSAGE_NAME%TYPE := OKC_API.G_MISS_CHAR,
24: message_number OKC_AQMSGSTACKS_V.MESSAGE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
25: message_text OKC_AQMSGSTACKS_V.MESSAGE_TEXT%TYPE := OKC_API.G_MISS_CHAR,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_AQMSGSTACKS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_AQMSGSTACKS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_update_login NUMBER := OKC_API.G_MISS_NUM);
31: g_miss_aqmv_rec aqmv_rec_type;
25: message_text OKC_AQMSGSTACKS_V.MESSAGE_TEXT%TYPE := OKC_API.G_MISS_CHAR,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_AQMSGSTACKS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_AQMSGSTACKS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_update_login NUMBER := OKC_API.G_MISS_NUM);
31: g_miss_aqmv_rec aqmv_rec_type;
32: TYPE aqmv_tbl_type IS TABLE OF aqmv_rec_type
33: INDEX BY BINARY_INTEGER;
53: -- GLOBAL VARIABLES
54: ---------------------------------------------------------------------------
55: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_AQM_PVT';
56: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
57: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_AQMSGSTACKS_V';
58:
59: --Global Exception
60: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
61: ---------------------------------------------------------------------------