3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ipt_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: isu_id NUMBER := OKC_API.G_MISS_NUM,
9: ipd_id NUMBER := OKC_API.G_MISS_NUM,
10: ipt_type OKL_INS_PRODUCTS_B.IPT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ipt_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: isu_id NUMBER := OKC_API.G_MISS_NUM,
9: ipd_id NUMBER := OKC_API.G_MISS_NUM,
10: ipt_type OKL_INS_PRODUCTS_B.IPT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: policy_symbol OKL_INS_PRODUCTS_B.POLICY_SYMBOL%TYPE := OKC_API.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE ipt_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: isu_id NUMBER := OKC_API.G_MISS_NUM,
9: ipd_id NUMBER := OKC_API.G_MISS_NUM,
10: ipt_type OKL_INS_PRODUCTS_B.IPT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: policy_symbol OKL_INS_PRODUCTS_B.POLICY_SYMBOL%TYPE := OKC_API.G_MISS_CHAR,
13: factor_code OKL_INS_PRODUCTS_B.FACTOR_CODE%TYPE := OKC_API.G_MISS_CHAR,
6: TYPE ipt_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: isu_id NUMBER := OKC_API.G_MISS_NUM,
9: ipd_id NUMBER := OKC_API.G_MISS_NUM,
10: ipt_type OKL_INS_PRODUCTS_B.IPT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: policy_symbol OKL_INS_PRODUCTS_B.POLICY_SYMBOL%TYPE := OKC_API.G_MISS_CHAR,
13: factor_code OKL_INS_PRODUCTS_B.FACTOR_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: factor_max NUMBER := OKC_API.G_MISS_NUM,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: isu_id NUMBER := OKC_API.G_MISS_NUM,
9: ipd_id NUMBER := OKC_API.G_MISS_NUM,
10: ipt_type OKL_INS_PRODUCTS_B.IPT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: policy_symbol OKL_INS_PRODUCTS_B.POLICY_SYMBOL%TYPE := OKC_API.G_MISS_CHAR,
13: factor_code OKL_INS_PRODUCTS_B.FACTOR_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: factor_max NUMBER := OKC_API.G_MISS_NUM,
15: factor_min NUMBER := OKC_API.G_MISS_NUM,
8: isu_id NUMBER := OKC_API.G_MISS_NUM,
9: ipd_id NUMBER := OKC_API.G_MISS_NUM,
10: ipt_type OKL_INS_PRODUCTS_B.IPT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: policy_symbol OKL_INS_PRODUCTS_B.POLICY_SYMBOL%TYPE := OKC_API.G_MISS_CHAR,
13: factor_code OKL_INS_PRODUCTS_B.FACTOR_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: factor_max NUMBER := OKC_API.G_MISS_NUM,
15: factor_min NUMBER := OKC_API.G_MISS_NUM,
16: coverage_min NUMBER := OKC_API.G_MISS_NUM,
9: ipd_id NUMBER := OKC_API.G_MISS_NUM,
10: ipt_type OKL_INS_PRODUCTS_B.IPT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: policy_symbol OKL_INS_PRODUCTS_B.POLICY_SYMBOL%TYPE := OKC_API.G_MISS_CHAR,
13: factor_code OKL_INS_PRODUCTS_B.FACTOR_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: factor_max NUMBER := OKC_API.G_MISS_NUM,
15: factor_min NUMBER := OKC_API.G_MISS_NUM,
16: coverage_min NUMBER := OKC_API.G_MISS_NUM,
17: coverage_max NUMBER := OKC_API.G_MISS_NUM,
10: ipt_type OKL_INS_PRODUCTS_B.IPT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: policy_symbol OKL_INS_PRODUCTS_B.POLICY_SYMBOL%TYPE := OKC_API.G_MISS_CHAR,
13: factor_code OKL_INS_PRODUCTS_B.FACTOR_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: factor_max NUMBER := OKC_API.G_MISS_NUM,
15: factor_min NUMBER := OKC_API.G_MISS_NUM,
16: coverage_min NUMBER := OKC_API.G_MISS_NUM,
17: coverage_max NUMBER := OKC_API.G_MISS_NUM,
18: deal_months_min NUMBER := OKC_API.G_MISS_NUM,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: policy_symbol OKL_INS_PRODUCTS_B.POLICY_SYMBOL%TYPE := OKC_API.G_MISS_CHAR,
13: factor_code OKL_INS_PRODUCTS_B.FACTOR_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: factor_max NUMBER := OKC_API.G_MISS_NUM,
15: factor_min NUMBER := OKC_API.G_MISS_NUM,
16: coverage_min NUMBER := OKC_API.G_MISS_NUM,
17: coverage_max NUMBER := OKC_API.G_MISS_NUM,
18: deal_months_min NUMBER := OKC_API.G_MISS_NUM,
19: deal_months_max NUMBER := OKC_API.G_MISS_NUM,
12: policy_symbol OKL_INS_PRODUCTS_B.POLICY_SYMBOL%TYPE := OKC_API.G_MISS_CHAR,
13: factor_code OKL_INS_PRODUCTS_B.FACTOR_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: factor_max NUMBER := OKC_API.G_MISS_NUM,
15: factor_min NUMBER := OKC_API.G_MISS_NUM,
16: coverage_min NUMBER := OKC_API.G_MISS_NUM,
17: coverage_max NUMBER := OKC_API.G_MISS_NUM,
18: deal_months_min NUMBER := OKC_API.G_MISS_NUM,
19: deal_months_max NUMBER := OKC_API.G_MISS_NUM,
20: date_from OKL_INS_PRODUCTS_B.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
13: factor_code OKL_INS_PRODUCTS_B.FACTOR_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: factor_max NUMBER := OKC_API.G_MISS_NUM,
15: factor_min NUMBER := OKC_API.G_MISS_NUM,
16: coverage_min NUMBER := OKC_API.G_MISS_NUM,
17: coverage_max NUMBER := OKC_API.G_MISS_NUM,
18: deal_months_min NUMBER := OKC_API.G_MISS_NUM,
19: deal_months_max NUMBER := OKC_API.G_MISS_NUM,
20: date_from OKL_INS_PRODUCTS_B.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
21: date_to OKL_INS_PRODUCTS_B.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
14: factor_max NUMBER := OKC_API.G_MISS_NUM,
15: factor_min NUMBER := OKC_API.G_MISS_NUM,
16: coverage_min NUMBER := OKC_API.G_MISS_NUM,
17: coverage_max NUMBER := OKC_API.G_MISS_NUM,
18: deal_months_min NUMBER := OKC_API.G_MISS_NUM,
19: deal_months_max NUMBER := OKC_API.G_MISS_NUM,
20: date_from OKL_INS_PRODUCTS_B.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
21: date_to OKL_INS_PRODUCTS_B.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
22: factor_amount_yn OKL_INS_PRODUCTS_B.FACTOR_AMOUNT_YN%TYPE := OKC_API.G_MISS_CHAR,
15: factor_min NUMBER := OKC_API.G_MISS_NUM,
16: coverage_min NUMBER := OKC_API.G_MISS_NUM,
17: coverage_max NUMBER := OKC_API.G_MISS_NUM,
18: deal_months_min NUMBER := OKC_API.G_MISS_NUM,
19: deal_months_max NUMBER := OKC_API.G_MISS_NUM,
20: date_from OKL_INS_PRODUCTS_B.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
21: date_to OKL_INS_PRODUCTS_B.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
22: factor_amount_yn OKL_INS_PRODUCTS_B.FACTOR_AMOUNT_YN%TYPE := OKC_API.G_MISS_CHAR,
23: attribute_category OKL_INS_PRODUCTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
16: coverage_min NUMBER := OKC_API.G_MISS_NUM,
17: coverage_max NUMBER := OKC_API.G_MISS_NUM,
18: deal_months_min NUMBER := OKC_API.G_MISS_NUM,
19: deal_months_max NUMBER := OKC_API.G_MISS_NUM,
20: date_from OKL_INS_PRODUCTS_B.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
21: date_to OKL_INS_PRODUCTS_B.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
22: factor_amount_yn OKL_INS_PRODUCTS_B.FACTOR_AMOUNT_YN%TYPE := OKC_API.G_MISS_CHAR,
23: attribute_category OKL_INS_PRODUCTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKL_INS_PRODUCTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
17: coverage_max NUMBER := OKC_API.G_MISS_NUM,
18: deal_months_min NUMBER := OKC_API.G_MISS_NUM,
19: deal_months_max NUMBER := OKC_API.G_MISS_NUM,
20: date_from OKL_INS_PRODUCTS_B.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
21: date_to OKL_INS_PRODUCTS_B.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
22: factor_amount_yn OKL_INS_PRODUCTS_B.FACTOR_AMOUNT_YN%TYPE := OKC_API.G_MISS_CHAR,
23: attribute_category OKL_INS_PRODUCTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKL_INS_PRODUCTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKL_INS_PRODUCTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
18: deal_months_min NUMBER := OKC_API.G_MISS_NUM,
19: deal_months_max NUMBER := OKC_API.G_MISS_NUM,
20: date_from OKL_INS_PRODUCTS_B.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
21: date_to OKL_INS_PRODUCTS_B.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
22: factor_amount_yn OKL_INS_PRODUCTS_B.FACTOR_AMOUNT_YN%TYPE := OKC_API.G_MISS_CHAR,
23: attribute_category OKL_INS_PRODUCTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKL_INS_PRODUCTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKL_INS_PRODUCTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKL_INS_PRODUCTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
19: deal_months_max NUMBER := OKC_API.G_MISS_NUM,
20: date_from OKL_INS_PRODUCTS_B.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
21: date_to OKL_INS_PRODUCTS_B.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
22: factor_amount_yn OKL_INS_PRODUCTS_B.FACTOR_AMOUNT_YN%TYPE := OKC_API.G_MISS_CHAR,
23: attribute_category OKL_INS_PRODUCTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKL_INS_PRODUCTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKL_INS_PRODUCTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKL_INS_PRODUCTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKL_INS_PRODUCTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
20: date_from OKL_INS_PRODUCTS_B.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
21: date_to OKL_INS_PRODUCTS_B.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
22: factor_amount_yn OKL_INS_PRODUCTS_B.FACTOR_AMOUNT_YN%TYPE := OKC_API.G_MISS_CHAR,
23: attribute_category OKL_INS_PRODUCTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKL_INS_PRODUCTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKL_INS_PRODUCTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKL_INS_PRODUCTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKL_INS_PRODUCTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKL_INS_PRODUCTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
21: date_to OKL_INS_PRODUCTS_B.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
22: factor_amount_yn OKL_INS_PRODUCTS_B.FACTOR_AMOUNT_YN%TYPE := OKC_API.G_MISS_CHAR,
23: attribute_category OKL_INS_PRODUCTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKL_INS_PRODUCTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKL_INS_PRODUCTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKL_INS_PRODUCTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKL_INS_PRODUCTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKL_INS_PRODUCTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKL_INS_PRODUCTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
22: factor_amount_yn OKL_INS_PRODUCTS_B.FACTOR_AMOUNT_YN%TYPE := OKC_API.G_MISS_CHAR,
23: attribute_category OKL_INS_PRODUCTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKL_INS_PRODUCTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKL_INS_PRODUCTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKL_INS_PRODUCTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKL_INS_PRODUCTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKL_INS_PRODUCTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKL_INS_PRODUCTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKL_INS_PRODUCTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
23: attribute_category OKL_INS_PRODUCTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKL_INS_PRODUCTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKL_INS_PRODUCTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKL_INS_PRODUCTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKL_INS_PRODUCTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKL_INS_PRODUCTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKL_INS_PRODUCTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKL_INS_PRODUCTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKL_INS_PRODUCTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
24: attribute1 OKL_INS_PRODUCTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKL_INS_PRODUCTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKL_INS_PRODUCTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKL_INS_PRODUCTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKL_INS_PRODUCTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKL_INS_PRODUCTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKL_INS_PRODUCTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKL_INS_PRODUCTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKL_INS_PRODUCTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
25: attribute2 OKL_INS_PRODUCTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKL_INS_PRODUCTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKL_INS_PRODUCTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKL_INS_PRODUCTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKL_INS_PRODUCTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKL_INS_PRODUCTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKL_INS_PRODUCTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKL_INS_PRODUCTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKL_INS_PRODUCTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
26: attribute3 OKL_INS_PRODUCTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKL_INS_PRODUCTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKL_INS_PRODUCTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKL_INS_PRODUCTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKL_INS_PRODUCTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKL_INS_PRODUCTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKL_INS_PRODUCTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKL_INS_PRODUCTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKL_INS_PRODUCTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
27: attribute4 OKL_INS_PRODUCTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKL_INS_PRODUCTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKL_INS_PRODUCTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKL_INS_PRODUCTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKL_INS_PRODUCTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKL_INS_PRODUCTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKL_INS_PRODUCTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKL_INS_PRODUCTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKL_INS_PRODUCTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
28: attribute5 OKL_INS_PRODUCTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKL_INS_PRODUCTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKL_INS_PRODUCTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKL_INS_PRODUCTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKL_INS_PRODUCTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKL_INS_PRODUCTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKL_INS_PRODUCTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKL_INS_PRODUCTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: attribute13 OKL_INS_PRODUCTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
29: attribute6 OKL_INS_PRODUCTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKL_INS_PRODUCTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKL_INS_PRODUCTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKL_INS_PRODUCTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKL_INS_PRODUCTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKL_INS_PRODUCTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKL_INS_PRODUCTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: attribute13 OKL_INS_PRODUCTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: attribute14 OKL_INS_PRODUCTS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
30: attribute7 OKL_INS_PRODUCTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKL_INS_PRODUCTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKL_INS_PRODUCTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKL_INS_PRODUCTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKL_INS_PRODUCTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKL_INS_PRODUCTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: attribute13 OKL_INS_PRODUCTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: attribute14 OKL_INS_PRODUCTS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: attribute15 OKL_INS_PRODUCTS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
31: attribute8 OKL_INS_PRODUCTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32: attribute9 OKL_INS_PRODUCTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKL_INS_PRODUCTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKL_INS_PRODUCTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKL_INS_PRODUCTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: attribute13 OKL_INS_PRODUCTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: attribute14 OKL_INS_PRODUCTS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: attribute15 OKL_INS_PRODUCTS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39: created_by NUMBER := OKC_API.G_MISS_NUM,
32: attribute9 OKL_INS_PRODUCTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33: attribute10 OKL_INS_PRODUCTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKL_INS_PRODUCTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKL_INS_PRODUCTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: attribute13 OKL_INS_PRODUCTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: attribute14 OKL_INS_PRODUCTS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: attribute15 OKL_INS_PRODUCTS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39: created_by NUMBER := OKC_API.G_MISS_NUM,
40: creation_date OKL_INS_PRODUCTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
33: attribute10 OKL_INS_PRODUCTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: attribute11 OKL_INS_PRODUCTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKL_INS_PRODUCTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: attribute13 OKL_INS_PRODUCTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: attribute14 OKL_INS_PRODUCTS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: attribute15 OKL_INS_PRODUCTS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39: created_by NUMBER := OKC_API.G_MISS_NUM,
40: creation_date OKL_INS_PRODUCTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
41: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
34: attribute11 OKL_INS_PRODUCTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: attribute12 OKL_INS_PRODUCTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: attribute13 OKL_INS_PRODUCTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: attribute14 OKL_INS_PRODUCTS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: attribute15 OKL_INS_PRODUCTS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39: created_by NUMBER := OKC_API.G_MISS_NUM,
40: creation_date OKL_INS_PRODUCTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
41: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
42: last_update_date OKL_INS_PRODUCTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
35: attribute12 OKL_INS_PRODUCTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: attribute13 OKL_INS_PRODUCTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: attribute14 OKL_INS_PRODUCTS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: attribute15 OKL_INS_PRODUCTS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39: created_by NUMBER := OKC_API.G_MISS_NUM,
40: creation_date OKL_INS_PRODUCTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
41: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
42: last_update_date OKL_INS_PRODUCTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_update_login NUMBER := OKC_API.G_MISS_NUM);
36: attribute13 OKL_INS_PRODUCTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: attribute14 OKL_INS_PRODUCTS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: attribute15 OKL_INS_PRODUCTS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39: created_by NUMBER := OKC_API.G_MISS_NUM,
40: creation_date OKL_INS_PRODUCTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
41: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
42: last_update_date OKL_INS_PRODUCTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_update_login NUMBER := OKC_API.G_MISS_NUM);
44: g_miss_ipt_rec ipt_rec_type;
37: attribute14 OKL_INS_PRODUCTS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: attribute15 OKL_INS_PRODUCTS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39: created_by NUMBER := OKC_API.G_MISS_NUM,
40: creation_date OKL_INS_PRODUCTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
41: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
42: last_update_date OKL_INS_PRODUCTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_update_login NUMBER := OKC_API.G_MISS_NUM);
44: g_miss_ipt_rec ipt_rec_type;
45: TYPE ipt_tbl_type IS TABLE OF ipt_rec_type
38: attribute15 OKL_INS_PRODUCTS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39: created_by NUMBER := OKC_API.G_MISS_NUM,
40: creation_date OKL_INS_PRODUCTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
41: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
42: last_update_date OKL_INS_PRODUCTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_update_login NUMBER := OKC_API.G_MISS_NUM);
44: g_miss_ipt_rec ipt_rec_type;
45: TYPE ipt_tbl_type IS TABLE OF ipt_rec_type
46: INDEX BY BINARY_INTEGER;
39: created_by NUMBER := OKC_API.G_MISS_NUM,
40: creation_date OKL_INS_PRODUCTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
41: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
42: last_update_date OKL_INS_PRODUCTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_update_login NUMBER := OKC_API.G_MISS_NUM);
44: g_miss_ipt_rec ipt_rec_type;
45: TYPE ipt_tbl_type IS TABLE OF ipt_rec_type
46: INDEX BY BINARY_INTEGER;
47: TYPE okl_ins_products_tl_rec_type IS RECORD (
44: g_miss_ipt_rec ipt_rec_type;
45: TYPE ipt_tbl_type IS TABLE OF ipt_rec_type
46: INDEX BY BINARY_INTEGER;
47: TYPE okl_ins_products_tl_rec_type IS RECORD (
48: id NUMBER := OKC_API.G_MISS_NUM,
49: language OKL_INS_PRODUCTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
50: source_lang OKL_INS_PRODUCTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
51: sfwt_flag OKL_INS_PRODUCTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
52: name OKL_INS_PRODUCTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
45: TYPE ipt_tbl_type IS TABLE OF ipt_rec_type
46: INDEX BY BINARY_INTEGER;
47: TYPE okl_ins_products_tl_rec_type IS RECORD (
48: id NUMBER := OKC_API.G_MISS_NUM,
49: language OKL_INS_PRODUCTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
50: source_lang OKL_INS_PRODUCTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
51: sfwt_flag OKL_INS_PRODUCTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
52: name OKL_INS_PRODUCTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
53: factor_name OKL_INS_PRODUCTS_TL.FACTOR_NAME%TYPE := OKC_API.G_MISS_CHAR,
46: INDEX BY BINARY_INTEGER;
47: TYPE okl_ins_products_tl_rec_type IS RECORD (
48: id NUMBER := OKC_API.G_MISS_NUM,
49: language OKL_INS_PRODUCTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
50: source_lang OKL_INS_PRODUCTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
51: sfwt_flag OKL_INS_PRODUCTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
52: name OKL_INS_PRODUCTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
53: factor_name OKL_INS_PRODUCTS_TL.FACTOR_NAME%TYPE := OKC_API.G_MISS_CHAR,
54: created_by NUMBER := OKC_API.G_MISS_NUM,
47: TYPE okl_ins_products_tl_rec_type IS RECORD (
48: id NUMBER := OKC_API.G_MISS_NUM,
49: language OKL_INS_PRODUCTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
50: source_lang OKL_INS_PRODUCTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
51: sfwt_flag OKL_INS_PRODUCTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
52: name OKL_INS_PRODUCTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
53: factor_name OKL_INS_PRODUCTS_TL.FACTOR_NAME%TYPE := OKC_API.G_MISS_CHAR,
54: created_by NUMBER := OKC_API.G_MISS_NUM,
55: creation_date OKL_INS_PRODUCTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: id NUMBER := OKC_API.G_MISS_NUM,
49: language OKL_INS_PRODUCTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
50: source_lang OKL_INS_PRODUCTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
51: sfwt_flag OKL_INS_PRODUCTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
52: name OKL_INS_PRODUCTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
53: factor_name OKL_INS_PRODUCTS_TL.FACTOR_NAME%TYPE := OKC_API.G_MISS_CHAR,
54: created_by NUMBER := OKC_API.G_MISS_NUM,
55: creation_date OKL_INS_PRODUCTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
49: language OKL_INS_PRODUCTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
50: source_lang OKL_INS_PRODUCTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
51: sfwt_flag OKL_INS_PRODUCTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
52: name OKL_INS_PRODUCTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
53: factor_name OKL_INS_PRODUCTS_TL.FACTOR_NAME%TYPE := OKC_API.G_MISS_CHAR,
54: created_by NUMBER := OKC_API.G_MISS_NUM,
55: creation_date OKL_INS_PRODUCTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
57: last_update_date OKL_INS_PRODUCTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
50: source_lang OKL_INS_PRODUCTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
51: sfwt_flag OKL_INS_PRODUCTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
52: name OKL_INS_PRODUCTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
53: factor_name OKL_INS_PRODUCTS_TL.FACTOR_NAME%TYPE := OKC_API.G_MISS_CHAR,
54: created_by NUMBER := OKC_API.G_MISS_NUM,
55: creation_date OKL_INS_PRODUCTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
57: last_update_date OKL_INS_PRODUCTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
58: last_update_login NUMBER := OKC_API.G_MISS_NUM);
51: sfwt_flag OKL_INS_PRODUCTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
52: name OKL_INS_PRODUCTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
53: factor_name OKL_INS_PRODUCTS_TL.FACTOR_NAME%TYPE := OKC_API.G_MISS_CHAR,
54: created_by NUMBER := OKC_API.G_MISS_NUM,
55: creation_date OKL_INS_PRODUCTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
57: last_update_date OKL_INS_PRODUCTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
58: last_update_login NUMBER := OKC_API.G_MISS_NUM);
59: g_miss_okl_ins_products_tl_rec okl_ins_products_tl_rec_type;
52: name OKL_INS_PRODUCTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
53: factor_name OKL_INS_PRODUCTS_TL.FACTOR_NAME%TYPE := OKC_API.G_MISS_CHAR,
54: created_by NUMBER := OKC_API.G_MISS_NUM,
55: creation_date OKL_INS_PRODUCTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
57: last_update_date OKL_INS_PRODUCTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
58: last_update_login NUMBER := OKC_API.G_MISS_NUM);
59: g_miss_okl_ins_products_tl_rec okl_ins_products_tl_rec_type;
60: TYPE okl_ins_products_tl_tbl_type IS TABLE OF okl_ins_products_tl_rec_type
53: factor_name OKL_INS_PRODUCTS_TL.FACTOR_NAME%TYPE := OKC_API.G_MISS_CHAR,
54: created_by NUMBER := OKC_API.G_MISS_NUM,
55: creation_date OKL_INS_PRODUCTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
57: last_update_date OKL_INS_PRODUCTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
58: last_update_login NUMBER := OKC_API.G_MISS_NUM);
59: g_miss_okl_ins_products_tl_rec okl_ins_products_tl_rec_type;
60: TYPE okl_ins_products_tl_tbl_type IS TABLE OF okl_ins_products_tl_rec_type
61: INDEX BY BINARY_INTEGER;
54: created_by NUMBER := OKC_API.G_MISS_NUM,
55: creation_date OKL_INS_PRODUCTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
57: last_update_date OKL_INS_PRODUCTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
58: last_update_login NUMBER := OKC_API.G_MISS_NUM);
59: g_miss_okl_ins_products_tl_rec okl_ins_products_tl_rec_type;
60: TYPE okl_ins_products_tl_tbl_type IS TABLE OF okl_ins_products_tl_rec_type
61: INDEX BY BINARY_INTEGER;
62: TYPE iptv_rec_type IS RECORD (
59: g_miss_okl_ins_products_tl_rec okl_ins_products_tl_rec_type;
60: TYPE okl_ins_products_tl_tbl_type IS TABLE OF okl_ins_products_tl_rec_type
61: INDEX BY BINARY_INTEGER;
62: TYPE iptv_rec_type IS RECORD (
63: id NUMBER := OKC_API.G_MISS_NUM,
64: object_version_number NUMBER := OKC_API.G_MISS_NUM,
65: sfwt_flag OKL_INS_PRODUCTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
66: isu_id NUMBER := OKC_API.G_MISS_NUM,
67: ipd_id NUMBER := OKC_API.G_MISS_NUM,
60: TYPE okl_ins_products_tl_tbl_type IS TABLE OF okl_ins_products_tl_rec_type
61: INDEX BY BINARY_INTEGER;
62: TYPE iptv_rec_type IS RECORD (
63: id NUMBER := OKC_API.G_MISS_NUM,
64: object_version_number NUMBER := OKC_API.G_MISS_NUM,
65: sfwt_flag OKL_INS_PRODUCTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
66: isu_id NUMBER := OKC_API.G_MISS_NUM,
67: ipd_id NUMBER := OKC_API.G_MISS_NUM,
68: policy_symbol OKL_INS_PRODUCTS_V.POLICY_SYMBOL%TYPE := OKC_API.G_MISS_CHAR,
61: INDEX BY BINARY_INTEGER;
62: TYPE iptv_rec_type IS RECORD (
63: id NUMBER := OKC_API.G_MISS_NUM,
64: object_version_number NUMBER := OKC_API.G_MISS_NUM,
65: sfwt_flag OKL_INS_PRODUCTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
66: isu_id NUMBER := OKC_API.G_MISS_NUM,
67: ipd_id NUMBER := OKC_API.G_MISS_NUM,
68: policy_symbol OKL_INS_PRODUCTS_V.POLICY_SYMBOL%TYPE := OKC_API.G_MISS_CHAR,
69: ipt_type OKL_INS_PRODUCTS_V.IPT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
62: TYPE iptv_rec_type IS RECORD (
63: id NUMBER := OKC_API.G_MISS_NUM,
64: object_version_number NUMBER := OKC_API.G_MISS_NUM,
65: sfwt_flag OKL_INS_PRODUCTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
66: isu_id NUMBER := OKC_API.G_MISS_NUM,
67: ipd_id NUMBER := OKC_API.G_MISS_NUM,
68: policy_symbol OKL_INS_PRODUCTS_V.POLICY_SYMBOL%TYPE := OKC_API.G_MISS_CHAR,
69: ipt_type OKL_INS_PRODUCTS_V.IPT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
70: name OKL_INS_PRODUCTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
63: id NUMBER := OKC_API.G_MISS_NUM,
64: object_version_number NUMBER := OKC_API.G_MISS_NUM,
65: sfwt_flag OKL_INS_PRODUCTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
66: isu_id NUMBER := OKC_API.G_MISS_NUM,
67: ipd_id NUMBER := OKC_API.G_MISS_NUM,
68: policy_symbol OKL_INS_PRODUCTS_V.POLICY_SYMBOL%TYPE := OKC_API.G_MISS_CHAR,
69: ipt_type OKL_INS_PRODUCTS_V.IPT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
70: name OKL_INS_PRODUCTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: factor_max NUMBER := OKC_API.G_MISS_NUM,
64: object_version_number NUMBER := OKC_API.G_MISS_NUM,
65: sfwt_flag OKL_INS_PRODUCTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
66: isu_id NUMBER := OKC_API.G_MISS_NUM,
67: ipd_id NUMBER := OKC_API.G_MISS_NUM,
68: policy_symbol OKL_INS_PRODUCTS_V.POLICY_SYMBOL%TYPE := OKC_API.G_MISS_CHAR,
69: ipt_type OKL_INS_PRODUCTS_V.IPT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
70: name OKL_INS_PRODUCTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: factor_max NUMBER := OKC_API.G_MISS_NUM,
72: date_from OKL_INS_PRODUCTS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
65: sfwt_flag OKL_INS_PRODUCTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
66: isu_id NUMBER := OKC_API.G_MISS_NUM,
67: ipd_id NUMBER := OKC_API.G_MISS_NUM,
68: policy_symbol OKL_INS_PRODUCTS_V.POLICY_SYMBOL%TYPE := OKC_API.G_MISS_CHAR,
69: ipt_type OKL_INS_PRODUCTS_V.IPT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
70: name OKL_INS_PRODUCTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: factor_max NUMBER := OKC_API.G_MISS_NUM,
72: date_from OKL_INS_PRODUCTS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
73: factor_min NUMBER := OKC_API.G_MISS_NUM,
66: isu_id NUMBER := OKC_API.G_MISS_NUM,
67: ipd_id NUMBER := OKC_API.G_MISS_NUM,
68: policy_symbol OKL_INS_PRODUCTS_V.POLICY_SYMBOL%TYPE := OKC_API.G_MISS_CHAR,
69: ipt_type OKL_INS_PRODUCTS_V.IPT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
70: name OKL_INS_PRODUCTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: factor_max NUMBER := OKC_API.G_MISS_NUM,
72: date_from OKL_INS_PRODUCTS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
73: factor_min NUMBER := OKC_API.G_MISS_NUM,
74: date_to OKL_INS_PRODUCTS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
67: ipd_id NUMBER := OKC_API.G_MISS_NUM,
68: policy_symbol OKL_INS_PRODUCTS_V.POLICY_SYMBOL%TYPE := OKC_API.G_MISS_CHAR,
69: ipt_type OKL_INS_PRODUCTS_V.IPT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
70: name OKL_INS_PRODUCTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: factor_max NUMBER := OKC_API.G_MISS_NUM,
72: date_from OKL_INS_PRODUCTS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
73: factor_min NUMBER := OKC_API.G_MISS_NUM,
74: date_to OKL_INS_PRODUCTS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
75: factor_name OKL_INS_PRODUCTS_V.FACTOR_NAME%TYPE := OKC_API.G_MISS_CHAR,
68: policy_symbol OKL_INS_PRODUCTS_V.POLICY_SYMBOL%TYPE := OKC_API.G_MISS_CHAR,
69: ipt_type OKL_INS_PRODUCTS_V.IPT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
70: name OKL_INS_PRODUCTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: factor_max NUMBER := OKC_API.G_MISS_NUM,
72: date_from OKL_INS_PRODUCTS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
73: factor_min NUMBER := OKC_API.G_MISS_NUM,
74: date_to OKL_INS_PRODUCTS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
75: factor_name OKL_INS_PRODUCTS_V.FACTOR_NAME%TYPE := OKC_API.G_MISS_CHAR,
76: factor_code OKL_INS_PRODUCTS_V.FACTOR_CODE%TYPE := OKC_API.G_MISS_CHAR,
69: ipt_type OKL_INS_PRODUCTS_V.IPT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
70: name OKL_INS_PRODUCTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: factor_max NUMBER := OKC_API.G_MISS_NUM,
72: date_from OKL_INS_PRODUCTS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
73: factor_min NUMBER := OKC_API.G_MISS_NUM,
74: date_to OKL_INS_PRODUCTS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
75: factor_name OKL_INS_PRODUCTS_V.FACTOR_NAME%TYPE := OKC_API.G_MISS_CHAR,
76: factor_code OKL_INS_PRODUCTS_V.FACTOR_CODE%TYPE := OKC_API.G_MISS_CHAR,
77: coverage_min NUMBER := OKC_API.G_MISS_NUM,
70: name OKL_INS_PRODUCTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: factor_max NUMBER := OKC_API.G_MISS_NUM,
72: date_from OKL_INS_PRODUCTS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
73: factor_min NUMBER := OKC_API.G_MISS_NUM,
74: date_to OKL_INS_PRODUCTS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
75: factor_name OKL_INS_PRODUCTS_V.FACTOR_NAME%TYPE := OKC_API.G_MISS_CHAR,
76: factor_code OKL_INS_PRODUCTS_V.FACTOR_CODE%TYPE := OKC_API.G_MISS_CHAR,
77: coverage_min NUMBER := OKC_API.G_MISS_NUM,
78: coverage_max NUMBER := OKC_API.G_MISS_NUM,
71: factor_max NUMBER := OKC_API.G_MISS_NUM,
72: date_from OKL_INS_PRODUCTS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
73: factor_min NUMBER := OKC_API.G_MISS_NUM,
74: date_to OKL_INS_PRODUCTS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
75: factor_name OKL_INS_PRODUCTS_V.FACTOR_NAME%TYPE := OKC_API.G_MISS_CHAR,
76: factor_code OKL_INS_PRODUCTS_V.FACTOR_CODE%TYPE := OKC_API.G_MISS_CHAR,
77: coverage_min NUMBER := OKC_API.G_MISS_NUM,
78: coverage_max NUMBER := OKC_API.G_MISS_NUM,
79: deal_months_min NUMBER := OKC_API.G_MISS_NUM,
72: date_from OKL_INS_PRODUCTS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
73: factor_min NUMBER := OKC_API.G_MISS_NUM,
74: date_to OKL_INS_PRODUCTS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
75: factor_name OKL_INS_PRODUCTS_V.FACTOR_NAME%TYPE := OKC_API.G_MISS_CHAR,
76: factor_code OKL_INS_PRODUCTS_V.FACTOR_CODE%TYPE := OKC_API.G_MISS_CHAR,
77: coverage_min NUMBER := OKC_API.G_MISS_NUM,
78: coverage_max NUMBER := OKC_API.G_MISS_NUM,
79: deal_months_min NUMBER := OKC_API.G_MISS_NUM,
80: deal_months_max NUMBER := OKC_API.G_MISS_NUM,
73: factor_min NUMBER := OKC_API.G_MISS_NUM,
74: date_to OKL_INS_PRODUCTS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
75: factor_name OKL_INS_PRODUCTS_V.FACTOR_NAME%TYPE := OKC_API.G_MISS_CHAR,
76: factor_code OKL_INS_PRODUCTS_V.FACTOR_CODE%TYPE := OKC_API.G_MISS_CHAR,
77: coverage_min NUMBER := OKC_API.G_MISS_NUM,
78: coverage_max NUMBER := OKC_API.G_MISS_NUM,
79: deal_months_min NUMBER := OKC_API.G_MISS_NUM,
80: deal_months_max NUMBER := OKC_API.G_MISS_NUM,
81: factor_amount_yn OKL_INS_PRODUCTS_V.FACTOR_AMOUNT_YN%TYPE := OKC_API.G_MISS_CHAR,
74: date_to OKL_INS_PRODUCTS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
75: factor_name OKL_INS_PRODUCTS_V.FACTOR_NAME%TYPE := OKC_API.G_MISS_CHAR,
76: factor_code OKL_INS_PRODUCTS_V.FACTOR_CODE%TYPE := OKC_API.G_MISS_CHAR,
77: coverage_min NUMBER := OKC_API.G_MISS_NUM,
78: coverage_max NUMBER := OKC_API.G_MISS_NUM,
79: deal_months_min NUMBER := OKC_API.G_MISS_NUM,
80: deal_months_max NUMBER := OKC_API.G_MISS_NUM,
81: factor_amount_yn OKL_INS_PRODUCTS_V.FACTOR_AMOUNT_YN%TYPE := OKC_API.G_MISS_CHAR,
82: attribute_category OKL_INS_PRODUCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
75: factor_name OKL_INS_PRODUCTS_V.FACTOR_NAME%TYPE := OKC_API.G_MISS_CHAR,
76: factor_code OKL_INS_PRODUCTS_V.FACTOR_CODE%TYPE := OKC_API.G_MISS_CHAR,
77: coverage_min NUMBER := OKC_API.G_MISS_NUM,
78: coverage_max NUMBER := OKC_API.G_MISS_NUM,
79: deal_months_min NUMBER := OKC_API.G_MISS_NUM,
80: deal_months_max NUMBER := OKC_API.G_MISS_NUM,
81: factor_amount_yn OKL_INS_PRODUCTS_V.FACTOR_AMOUNT_YN%TYPE := OKC_API.G_MISS_CHAR,
82: attribute_category OKL_INS_PRODUCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
83: attribute1 OKL_INS_PRODUCTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
76: factor_code OKL_INS_PRODUCTS_V.FACTOR_CODE%TYPE := OKC_API.G_MISS_CHAR,
77: coverage_min NUMBER := OKC_API.G_MISS_NUM,
78: coverage_max NUMBER := OKC_API.G_MISS_NUM,
79: deal_months_min NUMBER := OKC_API.G_MISS_NUM,
80: deal_months_max NUMBER := OKC_API.G_MISS_NUM,
81: factor_amount_yn OKL_INS_PRODUCTS_V.FACTOR_AMOUNT_YN%TYPE := OKC_API.G_MISS_CHAR,
82: attribute_category OKL_INS_PRODUCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
83: attribute1 OKL_INS_PRODUCTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
84: attribute2 OKL_INS_PRODUCTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
77: coverage_min NUMBER := OKC_API.G_MISS_NUM,
78: coverage_max NUMBER := OKC_API.G_MISS_NUM,
79: deal_months_min NUMBER := OKC_API.G_MISS_NUM,
80: deal_months_max NUMBER := OKC_API.G_MISS_NUM,
81: factor_amount_yn OKL_INS_PRODUCTS_V.FACTOR_AMOUNT_YN%TYPE := OKC_API.G_MISS_CHAR,
82: attribute_category OKL_INS_PRODUCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
83: attribute1 OKL_INS_PRODUCTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
84: attribute2 OKL_INS_PRODUCTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
85: attribute3 OKL_INS_PRODUCTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
78: coverage_max NUMBER := OKC_API.G_MISS_NUM,
79: deal_months_min NUMBER := OKC_API.G_MISS_NUM,
80: deal_months_max NUMBER := OKC_API.G_MISS_NUM,
81: factor_amount_yn OKL_INS_PRODUCTS_V.FACTOR_AMOUNT_YN%TYPE := OKC_API.G_MISS_CHAR,
82: attribute_category OKL_INS_PRODUCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
83: attribute1 OKL_INS_PRODUCTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
84: attribute2 OKL_INS_PRODUCTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
85: attribute3 OKL_INS_PRODUCTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
86: attribute4 OKL_INS_PRODUCTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
79: deal_months_min NUMBER := OKC_API.G_MISS_NUM,
80: deal_months_max NUMBER := OKC_API.G_MISS_NUM,
81: factor_amount_yn OKL_INS_PRODUCTS_V.FACTOR_AMOUNT_YN%TYPE := OKC_API.G_MISS_CHAR,
82: attribute_category OKL_INS_PRODUCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
83: attribute1 OKL_INS_PRODUCTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
84: attribute2 OKL_INS_PRODUCTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
85: attribute3 OKL_INS_PRODUCTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
86: attribute4 OKL_INS_PRODUCTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
87: attribute5 OKL_INS_PRODUCTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
80: deal_months_max NUMBER := OKC_API.G_MISS_NUM,
81: factor_amount_yn OKL_INS_PRODUCTS_V.FACTOR_AMOUNT_YN%TYPE := OKC_API.G_MISS_CHAR,
82: attribute_category OKL_INS_PRODUCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
83: attribute1 OKL_INS_PRODUCTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
84: attribute2 OKL_INS_PRODUCTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
85: attribute3 OKL_INS_PRODUCTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
86: attribute4 OKL_INS_PRODUCTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
87: attribute5 OKL_INS_PRODUCTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
88: attribute6 OKL_INS_PRODUCTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
81: factor_amount_yn OKL_INS_PRODUCTS_V.FACTOR_AMOUNT_YN%TYPE := OKC_API.G_MISS_CHAR,
82: attribute_category OKL_INS_PRODUCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
83: attribute1 OKL_INS_PRODUCTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
84: attribute2 OKL_INS_PRODUCTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
85: attribute3 OKL_INS_PRODUCTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
86: attribute4 OKL_INS_PRODUCTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
87: attribute5 OKL_INS_PRODUCTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
88: attribute6 OKL_INS_PRODUCTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
89: attribute7 OKL_INS_PRODUCTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
82: attribute_category OKL_INS_PRODUCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
83: attribute1 OKL_INS_PRODUCTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
84: attribute2 OKL_INS_PRODUCTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
85: attribute3 OKL_INS_PRODUCTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
86: attribute4 OKL_INS_PRODUCTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
87: attribute5 OKL_INS_PRODUCTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
88: attribute6 OKL_INS_PRODUCTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
89: attribute7 OKL_INS_PRODUCTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
90: attribute8 OKL_INS_PRODUCTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
83: attribute1 OKL_INS_PRODUCTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
84: attribute2 OKL_INS_PRODUCTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
85: attribute3 OKL_INS_PRODUCTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
86: attribute4 OKL_INS_PRODUCTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
87: attribute5 OKL_INS_PRODUCTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
88: attribute6 OKL_INS_PRODUCTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
89: attribute7 OKL_INS_PRODUCTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
90: attribute8 OKL_INS_PRODUCTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
91: attribute9 OKL_INS_PRODUCTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
84: attribute2 OKL_INS_PRODUCTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
85: attribute3 OKL_INS_PRODUCTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
86: attribute4 OKL_INS_PRODUCTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
87: attribute5 OKL_INS_PRODUCTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
88: attribute6 OKL_INS_PRODUCTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
89: attribute7 OKL_INS_PRODUCTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
90: attribute8 OKL_INS_PRODUCTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
91: attribute9 OKL_INS_PRODUCTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
92: attribute10 OKL_INS_PRODUCTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
85: attribute3 OKL_INS_PRODUCTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
86: attribute4 OKL_INS_PRODUCTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
87: attribute5 OKL_INS_PRODUCTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
88: attribute6 OKL_INS_PRODUCTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
89: attribute7 OKL_INS_PRODUCTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
90: attribute8 OKL_INS_PRODUCTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
91: attribute9 OKL_INS_PRODUCTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
92: attribute10 OKL_INS_PRODUCTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
93: attribute11 OKL_INS_PRODUCTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
86: attribute4 OKL_INS_PRODUCTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
87: attribute5 OKL_INS_PRODUCTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
88: attribute6 OKL_INS_PRODUCTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
89: attribute7 OKL_INS_PRODUCTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
90: attribute8 OKL_INS_PRODUCTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
91: attribute9 OKL_INS_PRODUCTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
92: attribute10 OKL_INS_PRODUCTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
93: attribute11 OKL_INS_PRODUCTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
94: attribute12 OKL_INS_PRODUCTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
87: attribute5 OKL_INS_PRODUCTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
88: attribute6 OKL_INS_PRODUCTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
89: attribute7 OKL_INS_PRODUCTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
90: attribute8 OKL_INS_PRODUCTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
91: attribute9 OKL_INS_PRODUCTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
92: attribute10 OKL_INS_PRODUCTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
93: attribute11 OKL_INS_PRODUCTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
94: attribute12 OKL_INS_PRODUCTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
95: attribute13 OKL_INS_PRODUCTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
88: attribute6 OKL_INS_PRODUCTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
89: attribute7 OKL_INS_PRODUCTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
90: attribute8 OKL_INS_PRODUCTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
91: attribute9 OKL_INS_PRODUCTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
92: attribute10 OKL_INS_PRODUCTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
93: attribute11 OKL_INS_PRODUCTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
94: attribute12 OKL_INS_PRODUCTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
95: attribute13 OKL_INS_PRODUCTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
96: attribute14 OKL_INS_PRODUCTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
89: attribute7 OKL_INS_PRODUCTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
90: attribute8 OKL_INS_PRODUCTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
91: attribute9 OKL_INS_PRODUCTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
92: attribute10 OKL_INS_PRODUCTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
93: attribute11 OKL_INS_PRODUCTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
94: attribute12 OKL_INS_PRODUCTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
95: attribute13 OKL_INS_PRODUCTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
96: attribute14 OKL_INS_PRODUCTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
97: attribute15 OKL_INS_PRODUCTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
90: attribute8 OKL_INS_PRODUCTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
91: attribute9 OKL_INS_PRODUCTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
92: attribute10 OKL_INS_PRODUCTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
93: attribute11 OKL_INS_PRODUCTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
94: attribute12 OKL_INS_PRODUCTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
95: attribute13 OKL_INS_PRODUCTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
96: attribute14 OKL_INS_PRODUCTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
97: attribute15 OKL_INS_PRODUCTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
98: created_by NUMBER := OKC_API.G_MISS_NUM,
91: attribute9 OKL_INS_PRODUCTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
92: attribute10 OKL_INS_PRODUCTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
93: attribute11 OKL_INS_PRODUCTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
94: attribute12 OKL_INS_PRODUCTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
95: attribute13 OKL_INS_PRODUCTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
96: attribute14 OKL_INS_PRODUCTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
97: attribute15 OKL_INS_PRODUCTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
98: created_by NUMBER := OKC_API.G_MISS_NUM,
99: creation_date OKL_INS_PRODUCTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
92: attribute10 OKL_INS_PRODUCTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
93: attribute11 OKL_INS_PRODUCTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
94: attribute12 OKL_INS_PRODUCTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
95: attribute13 OKL_INS_PRODUCTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
96: attribute14 OKL_INS_PRODUCTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
97: attribute15 OKL_INS_PRODUCTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
98: created_by NUMBER := OKC_API.G_MISS_NUM,
99: creation_date OKL_INS_PRODUCTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
100: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
93: attribute11 OKL_INS_PRODUCTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
94: attribute12 OKL_INS_PRODUCTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
95: attribute13 OKL_INS_PRODUCTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
96: attribute14 OKL_INS_PRODUCTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
97: attribute15 OKL_INS_PRODUCTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
98: created_by NUMBER := OKC_API.G_MISS_NUM,
99: creation_date OKL_INS_PRODUCTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
100: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
101: last_update_date OKL_INS_PRODUCTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
94: attribute12 OKL_INS_PRODUCTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
95: attribute13 OKL_INS_PRODUCTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
96: attribute14 OKL_INS_PRODUCTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
97: attribute15 OKL_INS_PRODUCTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
98: created_by NUMBER := OKC_API.G_MISS_NUM,
99: creation_date OKL_INS_PRODUCTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
100: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
101: last_update_date OKL_INS_PRODUCTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
102: last_update_login NUMBER := OKC_API.G_MISS_NUM);
95: attribute13 OKL_INS_PRODUCTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
96: attribute14 OKL_INS_PRODUCTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
97: attribute15 OKL_INS_PRODUCTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
98: created_by NUMBER := OKC_API.G_MISS_NUM,
99: creation_date OKL_INS_PRODUCTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
100: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
101: last_update_date OKL_INS_PRODUCTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
102: last_update_login NUMBER := OKC_API.G_MISS_NUM);
103: g_miss_iptv_rec iptv_rec_type;
96: attribute14 OKL_INS_PRODUCTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
97: attribute15 OKL_INS_PRODUCTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
98: created_by NUMBER := OKC_API.G_MISS_NUM,
99: creation_date OKL_INS_PRODUCTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
100: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
101: last_update_date OKL_INS_PRODUCTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
102: last_update_login NUMBER := OKC_API.G_MISS_NUM);
103: g_miss_iptv_rec iptv_rec_type;
104: TYPE iptv_tbl_type IS TABLE OF iptv_rec_type
97: attribute15 OKL_INS_PRODUCTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
98: created_by NUMBER := OKC_API.G_MISS_NUM,
99: creation_date OKL_INS_PRODUCTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
100: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
101: last_update_date OKL_INS_PRODUCTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
102: last_update_login NUMBER := OKC_API.G_MISS_NUM);
103: g_miss_iptv_rec iptv_rec_type;
104: TYPE iptv_tbl_type IS TABLE OF iptv_rec_type
105: INDEX BY BINARY_INTEGER;
98: created_by NUMBER := OKC_API.G_MISS_NUM,
99: creation_date OKL_INS_PRODUCTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
100: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
101: last_update_date OKL_INS_PRODUCTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
102: last_update_login NUMBER := OKC_API.G_MISS_NUM);
103: g_miss_iptv_rec iptv_rec_type;
104: TYPE iptv_tbl_type IS TABLE OF iptv_rec_type
105: INDEX BY BINARY_INTEGER;
106: ---------------------------------------------------------------------------
105: INDEX BY BINARY_INTEGER;
106: ---------------------------------------------------------------------------
107: -- GLOBAL MESSAGE CONSTANTS
108: ---------------------------------------------------------------------------
109: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
110: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
111: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
112: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
113: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
106: ---------------------------------------------------------------------------
107: -- GLOBAL MESSAGE CONSTANTS
108: ---------------------------------------------------------------------------
109: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
110: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
111: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
112: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
113: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
114: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
107: -- GLOBAL MESSAGE CONSTANTS
108: ---------------------------------------------------------------------------
109: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
110: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
111: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
112: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
113: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
114: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
115: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
108: ---------------------------------------------------------------------------
109: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
110: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
111: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
112: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
113: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
114: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
115: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
116: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
109: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
110: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
111: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
112: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
113: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
114: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
115: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
116: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
117: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
110: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
111: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
112: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
113: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
114: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
115: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
116: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
117: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
118: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
111: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
112: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
113: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
114: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
115: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
116: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
117: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
118: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
119: -- Added by Sridhar
112: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
113: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
114: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
115: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
116: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
117: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
118: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
119: -- Added by Sridhar
120: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
113: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
114: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
115: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
116: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
117: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
118: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
119: -- Added by Sridhar
120: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
121: G_DATE_RANGE_ERROR CONSTANT VARCHAR2(200) := 'OKC_DATE_RANGE_ERROR';
114: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
115: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
116: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
117: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
118: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
119: -- Added by Sridhar
120: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
121: G_DATE_RANGE_ERROR CONSTANT VARCHAR2(200) := 'OKC_DATE_RANGE_ERROR';
122: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
139: PROCEDURE api_copy;
140: PROCEDURE add_language;
141: PROCEDURE insert_row(
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,
147: p_iptv_rec IN iptv_rec_type,
147: p_iptv_rec IN iptv_rec_type,
148: x_iptv_rec OUT NOCOPY iptv_rec_type);
149: PROCEDURE insert_row(
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,
155: p_iptv_tbl IN iptv_tbl_type,
155: p_iptv_tbl IN iptv_tbl_type,
156: x_iptv_tbl OUT NOCOPY iptv_tbl_type);
157: PROCEDURE lock_row(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_iptv_rec IN iptv_rec_type);
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_iptv_rec IN iptv_rec_type);
164: PROCEDURE lock_row(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_iptv_tbl IN iptv_tbl_type);
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_iptv_tbl IN iptv_tbl_type);
171: PROCEDURE update_row(
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_iptv_rec IN iptv_rec_type,
177: p_iptv_rec IN iptv_rec_type,
178: x_iptv_rec OUT NOCOPY iptv_rec_type);
179: PROCEDURE update_row(
180: p_api_version IN NUMBER,
181: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
184: x_msg_data OUT NOCOPY VARCHAR2,
185: p_iptv_tbl IN iptv_tbl_type,
185: p_iptv_tbl IN iptv_tbl_type,
186: x_iptv_tbl OUT NOCOPY iptv_tbl_type);
187: PROCEDURE delete_row(
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_iptv_rec IN iptv_rec_type);
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_iptv_rec IN iptv_rec_type);
194: PROCEDURE delete_row(
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,
200: p_iptv_tbl IN iptv_tbl_type);
199: x_msg_data OUT NOCOPY VARCHAR2,
200: p_iptv_tbl IN iptv_tbl_type);
201: PROCEDURE validate_row(
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
207: p_iptv_rec IN iptv_rec_type);
206: x_msg_data OUT NOCOPY VARCHAR2,
207: p_iptv_rec IN iptv_rec_type);
208: PROCEDURE validate_row(
209: p_api_version IN NUMBER,
210: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
211: x_return_status OUT NOCOPY VARCHAR2,
212: x_msg_count OUT NOCOPY NUMBER,
213: x_msg_data OUT NOCOPY VARCHAR2,
214: p_iptv_tbl IN iptv_tbl_type);