6: ---------------------------------------------------------------------------
7: -- Rec Type to store IA Details
8: TYPE va_rec_type IS RECORD (
9: id NUMBER,
10: va_number OKC_K_HEADERS_B.contract_number%TYPE,
11: start_date DATE,
12: end_date DATE,
13: sts_code OKC_K_HEADERS_B.sts_code%TYPE,
14: date_terminated DATE,
9: id NUMBER,
10: va_number OKC_K_HEADERS_B.contract_number%TYPE,
11: start_date DATE,
12: end_date DATE,
13: sts_code OKC_K_HEADERS_B.sts_code%TYPE,
14: date_terminated DATE,
15: scs_code OKC_K_HEADERS_B.scs_code%TYPE);
16:
17: ---------------------------------------------------------------------------
11: start_date DATE,
12: end_date DATE,
13: sts_code OKC_K_HEADERS_B.sts_code%TYPE,
14: date_terminated DATE,
15: scs_code OKC_K_HEADERS_B.scs_code%TYPE);
16:
17: ---------------------------------------------------------------------------
18: -- PROCEDURES
19: ---------------------------------------------------------------------------