DBA Data[Home] [Help]

APPS.OKL_IPT_PVT dependencies on OKC_API

Line 7: id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 8: isu_id 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,

Line 9: ipd_id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 10: ipt_type OKL_INS_PRODUCTS_B.IPT_TYPE%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,

Line 11: object_version_number 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,

Line 12: policy_symbol OKL_INS_PRODUCTS_B.POLICY_SYMBOL%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 13: factor_code OKL_INS_PRODUCTS_B.FACTOR_CODE%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 14: factor_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,

Line 15: factor_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,

Line 16: coverage_min 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,

Line 17: coverage_max NUMBER := OKC_API.G_MISS_NUM,

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,

Line 18: deal_months_min NUMBER := OKC_API.G_MISS_NUM,

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,

Line 19: deal_months_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,
23: attribute_category OKL_INS_PRODUCTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

Line 20: date_from OKL_INS_PRODUCTS_B.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,

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,

Line 21: date_to OKL_INS_PRODUCTS_B.DATE_TO%TYPE := OKC_API.G_MISS_DATE,

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,

Line 22: factor_amount_yn OKL_INS_PRODUCTS_B.FACTOR_AMOUNT_YN%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,

Line 23: attribute_category OKL_INS_PRODUCTS_B.ATTRIBUTE_CATEGORY%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,

Line 24: attribute1 OKL_INS_PRODUCTS_B.ATTRIBUTE1%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,

Line 25: attribute2 OKL_INS_PRODUCTS_B.ATTRIBUTE2%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,

Line 26: attribute3 OKL_INS_PRODUCTS_B.ATTRIBUTE3%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,

Line 27: attribute4 OKL_INS_PRODUCTS_B.ATTRIBUTE4%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,

Line 28: attribute5 OKL_INS_PRODUCTS_B.ATTRIBUTE5%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,

Line 29: attribute6 OKL_INS_PRODUCTS_B.ATTRIBUTE6%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,

Line 30: attribute7 OKL_INS_PRODUCTS_B.ATTRIBUTE7%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,

Line 31: attribute8 OKL_INS_PRODUCTS_B.ATTRIBUTE8%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,

Line 32: attribute9 OKL_INS_PRODUCTS_B.ATTRIBUTE9%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,

Line 33: attribute10 OKL_INS_PRODUCTS_B.ATTRIBUTE10%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,

Line 34: attribute11 OKL_INS_PRODUCTS_B.ATTRIBUTE11%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,

Line 35: attribute12 OKL_INS_PRODUCTS_B.ATTRIBUTE12%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,

Line 36: attribute13 OKL_INS_PRODUCTS_B.ATTRIBUTE13%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,
40: creation_date OKL_INS_PRODUCTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 37: attribute14 OKL_INS_PRODUCTS_B.ATTRIBUTE14%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,
41: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 38: attribute15 OKL_INS_PRODUCTS_B.ATTRIBUTE15%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,
42: last_update_date OKL_INS_PRODUCTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 39: created_by NUMBER := OKC_API.G_MISS_NUM,

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);

Line 40: creation_date OKL_INS_PRODUCTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

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;

Line 41: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

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

Line 42: last_update_date OKL_INS_PRODUCTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

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;

Line 43: last_update_login NUMBER := OKC_API.G_MISS_NUM);

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 (

Line 48: id 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 (
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,

Line 49: language OKL_INS_PRODUCTS_TL.LANGUAGE%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,

Line 50: source_lang OKL_INS_PRODUCTS_TL.SOURCE_LANG%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,

Line 51: sfwt_flag OKL_INS_PRODUCTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 52: name OKL_INS_PRODUCTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 53: factor_name OKL_INS_PRODUCTS_TL.FACTOR_NAME%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 54: created_by NUMBER := OKC_API.G_MISS_NUM,

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);

Line 55: creation_date OKL_INS_PRODUCTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

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;

Line 56: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

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

Line 57: last_update_date OKL_INS_PRODUCTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

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;

Line 58: last_update_login NUMBER := OKC_API.G_MISS_NUM);

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 (

Line 63: id 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 (
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,

Line 64: object_version_number 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,

Line 65: sfwt_flag OKL_INS_PRODUCTS_V.SFWT_FLAG%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,

Line 66: isu_id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 67: ipd_id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 68: policy_symbol OKL_INS_PRODUCTS_V.POLICY_SYMBOL%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 69: ipt_type OKL_INS_PRODUCTS_V.IPT_TYPE%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 70: name OKL_INS_PRODUCTS_V.NAME%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,
74: date_to OKL_INS_PRODUCTS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE,

Line 71: factor_max 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,
75: factor_name OKL_INS_PRODUCTS_V.FACTOR_NAME%TYPE := OKC_API.G_MISS_CHAR,

Line 72: date_from OKL_INS_PRODUCTS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,

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,

Line 73: factor_min NUMBER := OKC_API.G_MISS_NUM,

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,

Line 74: date_to OKL_INS_PRODUCTS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE,

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,

Line 75: factor_name OKL_INS_PRODUCTS_V.FACTOR_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,
79: deal_months_min NUMBER := OKC_API.G_MISS_NUM,

Line 76: factor_code OKL_INS_PRODUCTS_V.FACTOR_CODE%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 77: coverage_min 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,

Line 78: coverage_max 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,
82: attribute_category OKL_INS_PRODUCTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

Line 79: deal_months_min NUMBER := OKC_API.G_MISS_NUM,

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,

Line 80: deal_months_max NUMBER := OKC_API.G_MISS_NUM,

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,

Line 81: factor_amount_yn OKL_INS_PRODUCTS_V.FACTOR_AMOUNT_YN%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,

Line 82: attribute_category OKL_INS_PRODUCTS_V.ATTRIBUTE_CATEGORY%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,

Line 83: attribute1 OKL_INS_PRODUCTS_V.ATTRIBUTE1%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,

Line 84: attribute2 OKL_INS_PRODUCTS_V.ATTRIBUTE2%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,

Line 85: attribute3 OKL_INS_PRODUCTS_V.ATTRIBUTE3%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,

Line 86: attribute4 OKL_INS_PRODUCTS_V.ATTRIBUTE4%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,

Line 87: attribute5 OKL_INS_PRODUCTS_V.ATTRIBUTE5%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,

Line 88: attribute6 OKL_INS_PRODUCTS_V.ATTRIBUTE6%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,

Line 89: attribute7 OKL_INS_PRODUCTS_V.ATTRIBUTE7%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,

Line 90: attribute8 OKL_INS_PRODUCTS_V.ATTRIBUTE8%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,

Line 91: attribute9 OKL_INS_PRODUCTS_V.ATTRIBUTE9%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,

Line 92: attribute10 OKL_INS_PRODUCTS_V.ATTRIBUTE10%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,

Line 93: attribute11 OKL_INS_PRODUCTS_V.ATTRIBUTE11%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,

Line 94: attribute12 OKL_INS_PRODUCTS_V.ATTRIBUTE12%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,

Line 95: attribute13 OKL_INS_PRODUCTS_V.ATTRIBUTE13%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,
99: creation_date OKL_INS_PRODUCTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 96: attribute14 OKL_INS_PRODUCTS_V.ATTRIBUTE14%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,
100: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 97: attribute15 OKL_INS_PRODUCTS_V.ATTRIBUTE15%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,
101: last_update_date OKL_INS_PRODUCTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 98: created_by NUMBER := OKC_API.G_MISS_NUM,

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);

Line 99: creation_date OKL_INS_PRODUCTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

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;

Line 100: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

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

Line 101: last_update_date OKL_INS_PRODUCTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

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;

Line 102: last_update_login NUMBER := OKC_API.G_MISS_NUM);

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: ---------------------------------------------------------------------------

Line 109: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

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;

Line 110: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

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;

Line 111: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

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;

Line 112: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

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;

Line 113: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

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;

Line 114: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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;

Line 115: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

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

Line 116: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

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';

Line 117: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

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';

Line 118: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

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';

Line 143: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 151: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 159: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 173: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 181: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 189: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 196: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 203: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 210: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);