32: G_PAST_RECORDS CONSTANT VARCHAR2(200) := 'OKL_PAST_RECORDS';
33: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
34: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
35:
36: SUBTYPE aesv_rec_type IS okl_tmpt_set_pub.aesv_rec_type;
37: SUBTYPE aesv_tbl_type IS okl_tmpt_set_pub.aesv_tbl_type;
38: SUBTYPE avlv_rec_type IS okl_tmpt_set_pub.avlv_rec_type;
39: SUBTYPE avlv_tbl_type IS okl_tmpt_set_pub.avlv_tbl_type;
40: SUBTYPE atlv_rec_type IS okl_tmpt_set_pub.atlv_rec_type;
33: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
34: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
35:
36: SUBTYPE aesv_rec_type IS okl_tmpt_set_pub.aesv_rec_type;
37: SUBTYPE aesv_tbl_type IS okl_tmpt_set_pub.aesv_tbl_type;
38: SUBTYPE avlv_rec_type IS okl_tmpt_set_pub.avlv_rec_type;
39: SUBTYPE avlv_tbl_type IS okl_tmpt_set_pub.avlv_tbl_type;
40: SUBTYPE atlv_rec_type IS okl_tmpt_set_pub.atlv_rec_type;
41: SUBTYPE atlv_tbl_type IS okl_tmpt_set_pub.atlv_tbl_type;
34: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
35:
36: SUBTYPE aesv_rec_type IS okl_tmpt_set_pub.aesv_rec_type;
37: SUBTYPE aesv_tbl_type IS okl_tmpt_set_pub.aesv_tbl_type;
38: SUBTYPE avlv_rec_type IS okl_tmpt_set_pub.avlv_rec_type;
39: SUBTYPE avlv_tbl_type IS okl_tmpt_set_pub.avlv_tbl_type;
40: SUBTYPE atlv_rec_type IS okl_tmpt_set_pub.atlv_rec_type;
41: SUBTYPE atlv_tbl_type IS okl_tmpt_set_pub.atlv_tbl_type;
42:
35:
36: SUBTYPE aesv_rec_type IS okl_tmpt_set_pub.aesv_rec_type;
37: SUBTYPE aesv_tbl_type IS okl_tmpt_set_pub.aesv_tbl_type;
38: SUBTYPE avlv_rec_type IS okl_tmpt_set_pub.avlv_rec_type;
39: SUBTYPE avlv_tbl_type IS okl_tmpt_set_pub.avlv_tbl_type;
40: SUBTYPE atlv_rec_type IS okl_tmpt_set_pub.atlv_rec_type;
41: SUBTYPE atlv_tbl_type IS okl_tmpt_set_pub.atlv_tbl_type;
42:
43:
36: SUBTYPE aesv_rec_type IS okl_tmpt_set_pub.aesv_rec_type;
37: SUBTYPE aesv_tbl_type IS okl_tmpt_set_pub.aesv_tbl_type;
38: SUBTYPE avlv_rec_type IS okl_tmpt_set_pub.avlv_rec_type;
39: SUBTYPE avlv_tbl_type IS okl_tmpt_set_pub.avlv_tbl_type;
40: SUBTYPE atlv_rec_type IS okl_tmpt_set_pub.atlv_rec_type;
41: SUBTYPE atlv_tbl_type IS okl_tmpt_set_pub.atlv_tbl_type;
42:
43:
44: PROCEDURE create_tmpt_set(
37: SUBTYPE aesv_tbl_type IS okl_tmpt_set_pub.aesv_tbl_type;
38: SUBTYPE avlv_rec_type IS okl_tmpt_set_pub.avlv_rec_type;
39: SUBTYPE avlv_tbl_type IS okl_tmpt_set_pub.avlv_tbl_type;
40: SUBTYPE atlv_rec_type IS okl_tmpt_set_pub.atlv_rec_type;
41: SUBTYPE atlv_tbl_type IS okl_tmpt_set_pub.atlv_tbl_type;
42:
43:
44: PROCEDURE create_tmpt_set(
45: p_api_version IN NUMBER