2: /* $Header: OKLSVIPS.pls 115.3 2003/02/19 22:07:41 sanahuja noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_VAR_INT_PROCESS_V Record Spec
7: TYPE vipv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,parent_trx_id NUMBER := OKC_API.G_MISS_NUM
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,parent_trx_id NUMBER := OKC_API.G_MISS_NUM
11: ,child_trx_id NUMBER := OKC_API.G_MISS_NUM
12: ,contract_number OKL_VAR_INT_PROCESS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
13: ,rebook_status OKL_VAR_INT_PROCESS_V.REBOOK_STATUS%TYPE := OKC_API.G_MISS_CHAR
14: ,request_id NUMBER := Okl_Api.G_MISS_NUM
15: ,program_application_id NUMBER := Okl_Api.G_MISS_NUM
16: ,program_id NUMBER := Okl_Api.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,parent_trx_id NUMBER := OKC_API.G_MISS_NUM
11: ,child_trx_id NUMBER := OKC_API.G_MISS_NUM
12: ,contract_number OKL_VAR_INT_PROCESS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
13: ,rebook_status OKL_VAR_INT_PROCESS_V.REBOOK_STATUS%TYPE := OKC_API.G_MISS_CHAR
14: ,request_id NUMBER := Okl_Api.G_MISS_NUM
15: ,program_application_id NUMBER := Okl_Api.G_MISS_NUM
16: ,program_id NUMBER := Okl_Api.G_MISS_NUM
17: ,program_update_date OKL_TRX_AR_INVOICES_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE
15: ,program_application_id NUMBER := Okl_Api.G_MISS_NUM
16: ,program_id NUMBER := Okl_Api.G_MISS_NUM
17: ,program_update_date OKL_TRX_AR_INVOICES_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE
18: ,org_id NUMBER := Okl_Api.G_MISS_NUM
19: ,attribute_category OKL_VAR_INT_PROCESS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute1 OKL_VAR_INT_PROCESS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute2 OKL_VAR_INT_PROCESS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute3 OKL_VAR_INT_PROCESS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute4 OKL_VAR_INT_PROCESS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
16: ,program_id NUMBER := Okl_Api.G_MISS_NUM
17: ,program_update_date OKL_TRX_AR_INVOICES_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE
18: ,org_id NUMBER := Okl_Api.G_MISS_NUM
19: ,attribute_category OKL_VAR_INT_PROCESS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute1 OKL_VAR_INT_PROCESS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute2 OKL_VAR_INT_PROCESS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute3 OKL_VAR_INT_PROCESS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute4 OKL_VAR_INT_PROCESS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute5 OKL_VAR_INT_PROCESS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
17: ,program_update_date OKL_TRX_AR_INVOICES_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE
18: ,org_id NUMBER := Okl_Api.G_MISS_NUM
19: ,attribute_category OKL_VAR_INT_PROCESS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute1 OKL_VAR_INT_PROCESS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute2 OKL_VAR_INT_PROCESS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute3 OKL_VAR_INT_PROCESS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute4 OKL_VAR_INT_PROCESS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute5 OKL_VAR_INT_PROCESS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute6 OKL_VAR_INT_PROCESS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
18: ,org_id NUMBER := Okl_Api.G_MISS_NUM
19: ,attribute_category OKL_VAR_INT_PROCESS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute1 OKL_VAR_INT_PROCESS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute2 OKL_VAR_INT_PROCESS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute3 OKL_VAR_INT_PROCESS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute4 OKL_VAR_INT_PROCESS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute5 OKL_VAR_INT_PROCESS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute6 OKL_VAR_INT_PROCESS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute7 OKL_VAR_INT_PROCESS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute_category OKL_VAR_INT_PROCESS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute1 OKL_VAR_INT_PROCESS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute2 OKL_VAR_INT_PROCESS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute3 OKL_VAR_INT_PROCESS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute4 OKL_VAR_INT_PROCESS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute5 OKL_VAR_INT_PROCESS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute6 OKL_VAR_INT_PROCESS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute7 OKL_VAR_INT_PROCESS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute8 OKL_VAR_INT_PROCESS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute1 OKL_VAR_INT_PROCESS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute2 OKL_VAR_INT_PROCESS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute3 OKL_VAR_INT_PROCESS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute4 OKL_VAR_INT_PROCESS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute5 OKL_VAR_INT_PROCESS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute6 OKL_VAR_INT_PROCESS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute7 OKL_VAR_INT_PROCESS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute8 OKL_VAR_INT_PROCESS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute9 OKL_VAR_INT_PROCESS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute2 OKL_VAR_INT_PROCESS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute3 OKL_VAR_INT_PROCESS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute4 OKL_VAR_INT_PROCESS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute5 OKL_VAR_INT_PROCESS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute6 OKL_VAR_INT_PROCESS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute7 OKL_VAR_INT_PROCESS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute8 OKL_VAR_INT_PROCESS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute9 OKL_VAR_INT_PROCESS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute10 OKL_VAR_INT_PROCESS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute3 OKL_VAR_INT_PROCESS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute4 OKL_VAR_INT_PROCESS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute5 OKL_VAR_INT_PROCESS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute6 OKL_VAR_INT_PROCESS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute7 OKL_VAR_INT_PROCESS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute8 OKL_VAR_INT_PROCESS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute9 OKL_VAR_INT_PROCESS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute10 OKL_VAR_INT_PROCESS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute11 OKL_VAR_INT_PROCESS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute4 OKL_VAR_INT_PROCESS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute5 OKL_VAR_INT_PROCESS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute6 OKL_VAR_INT_PROCESS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute7 OKL_VAR_INT_PROCESS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute8 OKL_VAR_INT_PROCESS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute9 OKL_VAR_INT_PROCESS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute10 OKL_VAR_INT_PROCESS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute11 OKL_VAR_INT_PROCESS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute12 OKL_VAR_INT_PROCESS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute5 OKL_VAR_INT_PROCESS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute6 OKL_VAR_INT_PROCESS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute7 OKL_VAR_INT_PROCESS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute8 OKL_VAR_INT_PROCESS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute9 OKL_VAR_INT_PROCESS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute10 OKL_VAR_INT_PROCESS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute11 OKL_VAR_INT_PROCESS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute12 OKL_VAR_INT_PROCESS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute13 OKL_VAR_INT_PROCESS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute6 OKL_VAR_INT_PROCESS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute7 OKL_VAR_INT_PROCESS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute8 OKL_VAR_INT_PROCESS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute9 OKL_VAR_INT_PROCESS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute10 OKL_VAR_INT_PROCESS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute11 OKL_VAR_INT_PROCESS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute12 OKL_VAR_INT_PROCESS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute13 OKL_VAR_INT_PROCESS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute14 OKL_VAR_INT_PROCESS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute7 OKL_VAR_INT_PROCESS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute8 OKL_VAR_INT_PROCESS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute9 OKL_VAR_INT_PROCESS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute10 OKL_VAR_INT_PROCESS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute11 OKL_VAR_INT_PROCESS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute12 OKL_VAR_INT_PROCESS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute13 OKL_VAR_INT_PROCESS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute14 OKL_VAR_INT_PROCESS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute15 OKL_VAR_INT_PROCESS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute8 OKL_VAR_INT_PROCESS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute9 OKL_VAR_INT_PROCESS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute10 OKL_VAR_INT_PROCESS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute11 OKL_VAR_INT_PROCESS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute12 OKL_VAR_INT_PROCESS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute13 OKL_VAR_INT_PROCESS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute14 OKL_VAR_INT_PROCESS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute15 OKL_VAR_INT_PROCESS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
35: ,created_by NUMBER := OKC_API.G_MISS_NUM
28: ,attribute9 OKL_VAR_INT_PROCESS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute10 OKL_VAR_INT_PROCESS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute11 OKL_VAR_INT_PROCESS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute12 OKL_VAR_INT_PROCESS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute13 OKL_VAR_INT_PROCESS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute14 OKL_VAR_INT_PROCESS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute15 OKL_VAR_INT_PROCESS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
35: ,created_by NUMBER := OKC_API.G_MISS_NUM
36: ,creation_date OKL_VAR_INT_PROCESS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,attribute10 OKL_VAR_INT_PROCESS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute11 OKL_VAR_INT_PROCESS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute12 OKL_VAR_INT_PROCESS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute13 OKL_VAR_INT_PROCESS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute14 OKL_VAR_INT_PROCESS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute15 OKL_VAR_INT_PROCESS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
35: ,created_by NUMBER := OKC_API.G_MISS_NUM
36: ,creation_date OKL_VAR_INT_PROCESS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
30: ,attribute11 OKL_VAR_INT_PROCESS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute12 OKL_VAR_INT_PROCESS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute13 OKL_VAR_INT_PROCESS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute14 OKL_VAR_INT_PROCESS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute15 OKL_VAR_INT_PROCESS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
35: ,created_by NUMBER := OKC_API.G_MISS_NUM
36: ,creation_date OKL_VAR_INT_PROCESS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
38: ,last_update_date OKL_VAR_INT_PROCESS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,attribute13 OKL_VAR_INT_PROCESS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute14 OKL_VAR_INT_PROCESS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute15 OKL_VAR_INT_PROCESS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
35: ,created_by NUMBER := OKC_API.G_MISS_NUM
36: ,creation_date OKL_VAR_INT_PROCESS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
38: ,last_update_date OKL_VAR_INT_PROCESS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
40: G_MISS_vipv_rec vipv_rec_type;
34: ,attribute15 OKL_VAR_INT_PROCESS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
35: ,created_by NUMBER := OKC_API.G_MISS_NUM
36: ,creation_date OKL_VAR_INT_PROCESS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
38: ,last_update_date OKL_VAR_INT_PROCESS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
40: G_MISS_vipv_rec vipv_rec_type;
41: TYPE vipv_tbl_type IS TABLE OF vipv_rec_type
42: INDEX BY BINARY_INTEGER;