45: TYPE strm_tbl_type IS TABLE OF strm_rec_type
46: INDEX BY BINARY_INTEGER;
47:
48: TYPE strm_excp_rec_type IS RECORD (
49: error_code OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE,
50: error_message OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE,
51: tag_name OKL_SIF_RET_ERRORS.TAG_NAME%TYPE
52: );
53:
46: INDEX BY BINARY_INTEGER;
47:
48: TYPE strm_excp_rec_type IS RECORD (
49: error_code OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE,
50: error_message OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE,
51: tag_name OKL_SIF_RET_ERRORS.TAG_NAME%TYPE
52: );
53:
54: TYPE strm_excp_tbl_type IS TABLE OF strm_excp_rec_type
47:
48: TYPE strm_excp_rec_type IS RECORD (
49: error_code OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE,
50: error_message OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE,
51: tag_name OKL_SIF_RET_ERRORS.TAG_NAME%TYPE
52: );
53:
54: TYPE strm_excp_tbl_type IS TABLE OF strm_excp_rec_type
55: INDEX BY BINARY_INTEGER;
106: PROCEDURE populate_sif_ret_errors (
107: x_return_status OUT NOCOPY VARCHAR2,
108: x_id OUT NOCOPY NUMBER,
109: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
110: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
111: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
112: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
113: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
114: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
107: x_return_status OUT NOCOPY VARCHAR2,
108: x_id OUT NOCOPY NUMBER,
109: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
110: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
111: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
112: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
113: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
114: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
115: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);
108: x_id OUT NOCOPY NUMBER,
109: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
110: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
111: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
112: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
113: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
114: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
115: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);
116:
109: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
110: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
111: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
112: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
113: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
114: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
115: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);
116:
117:
110: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
111: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
112: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
113: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
114: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
115: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);
116:
117:
118: PROCEDURE populate_sif_ret_errors (
111: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
112: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
113: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
114: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
115: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);
116:
117:
118: PROCEDURE populate_sif_ret_errors (
119: x_return_status OUT NOCOPY VARCHAR2,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_id OUT NOCOPY NUMBER,
121: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
122: p_strm_excp_tbl IN strm_excp_tbl_type,
123: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
124: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
125: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);
126: -- Bug -End Of Changes
127:
120: x_id OUT NOCOPY NUMBER,
121: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
122: p_strm_excp_tbl IN strm_excp_tbl_type,
123: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
124: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
125: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);
126: -- Bug -End Of Changes
127:
128: -- mvasudev, 04/24/2002 added
121: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
122: p_strm_excp_tbl IN strm_excp_tbl_type,
123: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
124: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
125: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);
126: -- Bug -End Of Changes
127:
128: -- mvasudev, 04/24/2002 added
129: PROCEDURE populate_insured_residual (