3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE okl_repair_costs_tl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: language OKL_REPAIR_COSTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKL_REPAIR_COSTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKL_REPAIR_COSTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: repair_type OKL_REPAIR_COSTS_TL.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE okl_repair_costs_tl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: language OKL_REPAIR_COSTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKL_REPAIR_COSTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKL_REPAIR_COSTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: repair_type OKL_REPAIR_COSTS_TL.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
12: description OKL_REPAIR_COSTS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE okl_repair_costs_tl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: language OKL_REPAIR_COSTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKL_REPAIR_COSTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKL_REPAIR_COSTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: repair_type OKL_REPAIR_COSTS_TL.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
12: description OKL_REPAIR_COSTS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
6: TYPE okl_repair_costs_tl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: language OKL_REPAIR_COSTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKL_REPAIR_COSTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKL_REPAIR_COSTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: repair_type OKL_REPAIR_COSTS_TL.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
12: description OKL_REPAIR_COSTS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_REPAIR_COSTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: language OKL_REPAIR_COSTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKL_REPAIR_COSTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKL_REPAIR_COSTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: repair_type OKL_REPAIR_COSTS_TL.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
12: description OKL_REPAIR_COSTS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_REPAIR_COSTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
8: language OKL_REPAIR_COSTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKL_REPAIR_COSTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKL_REPAIR_COSTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: repair_type OKL_REPAIR_COSTS_TL.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
12: description OKL_REPAIR_COSTS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_REPAIR_COSTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_REPAIR_COSTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
9: source_lang OKL_REPAIR_COSTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKL_REPAIR_COSTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: repair_type OKL_REPAIR_COSTS_TL.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
12: description OKL_REPAIR_COSTS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_REPAIR_COSTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_REPAIR_COSTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
10: sfwt_flag OKL_REPAIR_COSTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: repair_type OKL_REPAIR_COSTS_TL.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
12: description OKL_REPAIR_COSTS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_REPAIR_COSTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_REPAIR_COSTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18:
11: repair_type OKL_REPAIR_COSTS_TL.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
12: description OKL_REPAIR_COSTS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_REPAIR_COSTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_REPAIR_COSTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18:
19: g_miss_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
12: description OKL_REPAIR_COSTS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_REPAIR_COSTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_REPAIR_COSTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18:
19: g_miss_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
20: TYPE okl_repair_costs_tl_tbl_type IS TABLE OF okl_repair_costs_tl_rec_type
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_REPAIR_COSTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_REPAIR_COSTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18:
19: g_miss_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
20: TYPE okl_repair_costs_tl_tbl_type IS TABLE OF okl_repair_costs_tl_rec_type
21: INDEX BY BINARY_INTEGER;
19: g_miss_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
20: TYPE okl_repair_costs_tl_tbl_type IS TABLE OF okl_repair_costs_tl_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE rpc_rec_type IS RECORD (
23: id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: enabled_yn OKL_REPAIR_COSTS_B.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
26: cost NUMBER := OKC_API.G_MISS_NUM,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
20: TYPE okl_repair_costs_tl_tbl_type IS TABLE OF okl_repair_costs_tl_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE rpc_rec_type IS RECORD (
23: id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: enabled_yn OKL_REPAIR_COSTS_B.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
26: cost NUMBER := OKC_API.G_MISS_NUM,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
21: INDEX BY BINARY_INTEGER;
22: TYPE rpc_rec_type IS RECORD (
23: id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: enabled_yn OKL_REPAIR_COSTS_B.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
26: cost NUMBER := OKC_API.G_MISS_NUM,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_REPAIR_COSTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
22: TYPE rpc_rec_type IS RECORD (
23: id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: enabled_yn OKL_REPAIR_COSTS_B.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
26: cost NUMBER := OKC_API.G_MISS_NUM,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_REPAIR_COSTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
23: id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: enabled_yn OKL_REPAIR_COSTS_B.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
26: cost NUMBER := OKC_API.G_MISS_NUM,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_REPAIR_COSTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKL_REPAIR_COSTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: enabled_yn OKL_REPAIR_COSTS_B.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
26: cost NUMBER := OKC_API.G_MISS_NUM,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_REPAIR_COSTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKL_REPAIR_COSTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
25: enabled_yn OKL_REPAIR_COSTS_B.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
26: cost NUMBER := OKC_API.G_MISS_NUM,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_REPAIR_COSTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKL_REPAIR_COSTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: -- SPILLAIP - 2667636 - Start
26: cost NUMBER := OKC_API.G_MISS_NUM,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_REPAIR_COSTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKL_REPAIR_COSTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: -- SPILLAIP - 2667636 - Start
34: currency_code OKL_REPAIR_COSTS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_REPAIR_COSTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKL_REPAIR_COSTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: -- SPILLAIP - 2667636 - Start
34: currency_code OKL_REPAIR_COSTS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
35: currency_conversion_code OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_REPAIR_COSTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKL_REPAIR_COSTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: -- SPILLAIP - 2667636 - Start
34: currency_code OKL_REPAIR_COSTS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
35: currency_conversion_code OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: currency_conversion_type OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKL_REPAIR_COSTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: -- SPILLAIP - 2667636 - Start
34: currency_code OKL_REPAIR_COSTS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
35: currency_conversion_code OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: currency_conversion_type OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
37: currency_conversion_rate OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
38: currency_conversion_date OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
31: last_update_date OKL_REPAIR_COSTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: -- SPILLAIP - 2667636 - Start
34: currency_code OKL_REPAIR_COSTS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
35: currency_conversion_code OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: currency_conversion_type OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
37: currency_conversion_rate OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
38: currency_conversion_date OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
39: -- SPILLAIP - 2667636 - End
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: -- SPILLAIP - 2667636 - Start
34: currency_code OKL_REPAIR_COSTS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
35: currency_conversion_code OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: currency_conversion_type OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
37: currency_conversion_rate OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
38: currency_conversion_date OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
39: -- SPILLAIP - 2667636 - End
40: g_miss_rpc_rec rpc_rec_type;
33: -- SPILLAIP - 2667636 - Start
34: currency_code OKL_REPAIR_COSTS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
35: currency_conversion_code OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: currency_conversion_type OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
37: currency_conversion_rate OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
38: currency_conversion_date OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
39: -- SPILLAIP - 2667636 - End
40: g_miss_rpc_rec rpc_rec_type;
41: TYPE rpc_tbl_type IS TABLE OF rpc_rec_type
34: currency_code OKL_REPAIR_COSTS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
35: currency_conversion_code OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: currency_conversion_type OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
37: currency_conversion_rate OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
38: currency_conversion_date OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
39: -- SPILLAIP - 2667636 - End
40: g_miss_rpc_rec rpc_rec_type;
41: TYPE rpc_tbl_type IS TABLE OF rpc_rec_type
42: INDEX BY BINARY_INTEGER;
40: g_miss_rpc_rec rpc_rec_type;
41: TYPE rpc_tbl_type IS TABLE OF rpc_rec_type
42: INDEX BY BINARY_INTEGER;
43: TYPE rpcv_rec_type IS RECORD (
44: id NUMBER := OKC_API.G_MISS_NUM,
45: object_version_number NUMBER := OKC_API.G_MISS_NUM,
46: sfwt_flag OKL_REPAIR_COSTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
47: enabled_yn OKL_REPAIR_COSTS_V.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
48: cost NUMBER := OKC_API.G_MISS_NUM,
41: TYPE rpc_tbl_type IS TABLE OF rpc_rec_type
42: INDEX BY BINARY_INTEGER;
43: TYPE rpcv_rec_type IS RECORD (
44: id NUMBER := OKC_API.G_MISS_NUM,
45: object_version_number NUMBER := OKC_API.G_MISS_NUM,
46: sfwt_flag OKL_REPAIR_COSTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
47: enabled_yn OKL_REPAIR_COSTS_V.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
48: cost NUMBER := OKC_API.G_MISS_NUM,
49: repair_type OKL_REPAIR_COSTS_V.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
42: INDEX BY BINARY_INTEGER;
43: TYPE rpcv_rec_type IS RECORD (
44: id NUMBER := OKC_API.G_MISS_NUM,
45: object_version_number NUMBER := OKC_API.G_MISS_NUM,
46: sfwt_flag OKL_REPAIR_COSTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
47: enabled_yn OKL_REPAIR_COSTS_V.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
48: cost NUMBER := OKC_API.G_MISS_NUM,
49: repair_type OKL_REPAIR_COSTS_V.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: description OKL_REPAIR_COSTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
43: TYPE rpcv_rec_type IS RECORD (
44: id NUMBER := OKC_API.G_MISS_NUM,
45: object_version_number NUMBER := OKC_API.G_MISS_NUM,
46: sfwt_flag OKL_REPAIR_COSTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
47: enabled_yn OKL_REPAIR_COSTS_V.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
48: cost NUMBER := OKC_API.G_MISS_NUM,
49: repair_type OKL_REPAIR_COSTS_V.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: description OKL_REPAIR_COSTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: org_id NUMBER := OKC_API.G_MISS_NUM,
44: id NUMBER := OKC_API.G_MISS_NUM,
45: object_version_number NUMBER := OKC_API.G_MISS_NUM,
46: sfwt_flag OKL_REPAIR_COSTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
47: enabled_yn OKL_REPAIR_COSTS_V.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
48: cost NUMBER := OKC_API.G_MISS_NUM,
49: repair_type OKL_REPAIR_COSTS_V.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: description OKL_REPAIR_COSTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: org_id NUMBER := OKC_API.G_MISS_NUM,
52: created_by NUMBER := OKC_API.G_MISS_NUM,
45: object_version_number NUMBER := OKC_API.G_MISS_NUM,
46: sfwt_flag OKL_REPAIR_COSTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
47: enabled_yn OKL_REPAIR_COSTS_V.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
48: cost NUMBER := OKC_API.G_MISS_NUM,
49: repair_type OKL_REPAIR_COSTS_V.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: description OKL_REPAIR_COSTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: org_id NUMBER := OKC_API.G_MISS_NUM,
52: created_by NUMBER := OKC_API.G_MISS_NUM,
53: creation_date OKL_REPAIR_COSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
46: sfwt_flag OKL_REPAIR_COSTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
47: enabled_yn OKL_REPAIR_COSTS_V.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
48: cost NUMBER := OKC_API.G_MISS_NUM,
49: repair_type OKL_REPAIR_COSTS_V.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: description OKL_REPAIR_COSTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: org_id NUMBER := OKC_API.G_MISS_NUM,
52: created_by NUMBER := OKC_API.G_MISS_NUM,
53: creation_date OKL_REPAIR_COSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
54: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
47: enabled_yn OKL_REPAIR_COSTS_V.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
48: cost NUMBER := OKC_API.G_MISS_NUM,
49: repair_type OKL_REPAIR_COSTS_V.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: description OKL_REPAIR_COSTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: org_id NUMBER := OKC_API.G_MISS_NUM,
52: created_by NUMBER := OKC_API.G_MISS_NUM,
53: creation_date OKL_REPAIR_COSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
54: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
55: last_update_date OKL_REPAIR_COSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
48: cost NUMBER := OKC_API.G_MISS_NUM,
49: repair_type OKL_REPAIR_COSTS_V.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: description OKL_REPAIR_COSTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: org_id NUMBER := OKC_API.G_MISS_NUM,
52: created_by NUMBER := OKC_API.G_MISS_NUM,
53: creation_date OKL_REPAIR_COSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
54: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
55: last_update_date OKL_REPAIR_COSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_update_login NUMBER := OKC_API.G_MISS_NUM,
49: repair_type OKL_REPAIR_COSTS_V.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: description OKL_REPAIR_COSTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: org_id NUMBER := OKC_API.G_MISS_NUM,
52: created_by NUMBER := OKC_API.G_MISS_NUM,
53: creation_date OKL_REPAIR_COSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
54: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
55: last_update_date OKL_REPAIR_COSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_update_login NUMBER := OKC_API.G_MISS_NUM,
57: -- SPILLAIP - 2667636 - Start
50: description OKL_REPAIR_COSTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: org_id NUMBER := OKC_API.G_MISS_NUM,
52: created_by NUMBER := OKC_API.G_MISS_NUM,
53: creation_date OKL_REPAIR_COSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
54: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
55: last_update_date OKL_REPAIR_COSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_update_login NUMBER := OKC_API.G_MISS_NUM,
57: -- SPILLAIP - 2667636 - Start
58: currency_code OKL_REPAIR_COSTS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
51: org_id NUMBER := OKC_API.G_MISS_NUM,
52: created_by NUMBER := OKC_API.G_MISS_NUM,
53: creation_date OKL_REPAIR_COSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
54: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
55: last_update_date OKL_REPAIR_COSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_update_login NUMBER := OKC_API.G_MISS_NUM,
57: -- SPILLAIP - 2667636 - Start
58: currency_code OKL_REPAIR_COSTS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: currency_conversion_code OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
52: created_by NUMBER := OKC_API.G_MISS_NUM,
53: creation_date OKL_REPAIR_COSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
54: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
55: last_update_date OKL_REPAIR_COSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_update_login NUMBER := OKC_API.G_MISS_NUM,
57: -- SPILLAIP - 2667636 - Start
58: currency_code OKL_REPAIR_COSTS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: currency_conversion_code OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: currency_conversion_type OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
54: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
55: last_update_date OKL_REPAIR_COSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_update_login NUMBER := OKC_API.G_MISS_NUM,
57: -- SPILLAIP - 2667636 - Start
58: currency_code OKL_REPAIR_COSTS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: currency_conversion_code OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: currency_conversion_type OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: currency_conversion_rate OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
62: currency_conversion_date OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
55: last_update_date OKL_REPAIR_COSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_update_login NUMBER := OKC_API.G_MISS_NUM,
57: -- SPILLAIP - 2667636 - Start
58: currency_code OKL_REPAIR_COSTS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: currency_conversion_code OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: currency_conversion_type OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: currency_conversion_rate OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
62: currency_conversion_date OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
63: -- SPILLAIP - 2667636 - End
56: last_update_login NUMBER := OKC_API.G_MISS_NUM,
57: -- SPILLAIP - 2667636 - Start
58: currency_code OKL_REPAIR_COSTS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: currency_conversion_code OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: currency_conversion_type OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: currency_conversion_rate OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
62: currency_conversion_date OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
63: -- SPILLAIP - 2667636 - End
64: g_miss_rpcv_rec rpcv_rec_type;
57: -- SPILLAIP - 2667636 - Start
58: currency_code OKL_REPAIR_COSTS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: currency_conversion_code OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: currency_conversion_type OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: currency_conversion_rate OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
62: currency_conversion_date OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
63: -- SPILLAIP - 2667636 - End
64: g_miss_rpcv_rec rpcv_rec_type;
65: TYPE rpcv_tbl_type IS TABLE OF rpcv_rec_type
58: currency_code OKL_REPAIR_COSTS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: currency_conversion_code OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: currency_conversion_type OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: currency_conversion_rate OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
62: currency_conversion_date OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
63: -- SPILLAIP - 2667636 - End
64: g_miss_rpcv_rec rpcv_rec_type;
65: TYPE rpcv_tbl_type IS TABLE OF rpcv_rec_type
66: INDEX BY BINARY_INTEGER;
66: INDEX BY BINARY_INTEGER;
67: ---------------------------------------------------------------------------
68: -- GLOBAL MESSAGE CONSTANTS
69: ---------------------------------------------------------------------------
70: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
71: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
72: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
73: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
74: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
67: ---------------------------------------------------------------------------
68: -- GLOBAL MESSAGE CONSTANTS
69: ---------------------------------------------------------------------------
70: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
71: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
72: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
73: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
74: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
75: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
68: -- GLOBAL MESSAGE CONSTANTS
69: ---------------------------------------------------------------------------
70: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
71: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
72: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
73: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
74: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
75: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
76: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
69: ---------------------------------------------------------------------------
70: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
71: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
72: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
73: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
74: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
75: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
76: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
77: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
70: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
71: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
72: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
73: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
74: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
75: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
76: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
77: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
78: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
71: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
72: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
73: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
74: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
75: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
76: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
77: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
78: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
79: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
72: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
73: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
74: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
75: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
76: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
77: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
78: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
79: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
80: ---------------------------------------------------------------------------
73: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
74: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
75: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
76: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
77: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
78: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
79: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
80: ---------------------------------------------------------------------------
81: -- GLOBAL VARIABLES
74: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
75: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
76: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
77: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
78: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
79: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
80: ---------------------------------------------------------------------------
81: -- GLOBAL VARIABLES
82: ---------------------------------------------------------------------------
75: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
76: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
77: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
78: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
79: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
80: ---------------------------------------------------------------------------
81: -- GLOBAL VARIABLES
82: ---------------------------------------------------------------------------
83: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_RPC_PVT';
80: ---------------------------------------------------------------------------
81: -- GLOBAL VARIABLES
82: ---------------------------------------------------------------------------
83: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_RPC_PVT';
84: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
85: ---------------------------------------------------------------------------
86: -- Procedures and Functions
87: ---------------------------------------------------------------------------
88:
91: PROCEDURE api_copy;
92: PROCEDURE add_language;
93: PROCEDURE insert_row(
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
96: x_return_status OUT NOCOPY VARCHAR2,
97: x_msg_count OUT NOCOPY NUMBER,
98: x_msg_data OUT NOCOPY VARCHAR2,
99: p_rpcv_rec IN rpcv_rec_type,
100: x_rpcv_rec OUT NOCOPY rpcv_rec_type);
101:
102: PROCEDURE insert_row(
103: p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2,
108: p_rpcv_tbl IN rpcv_tbl_type,
109: x_rpcv_tbl OUT NOCOPY rpcv_tbl_type);
110:
111: PROCEDURE lock_row(
112: p_api_version IN NUMBER,
113: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
114: x_return_status OUT NOCOPY VARCHAR2,
115: x_msg_count OUT NOCOPY NUMBER,
116: x_msg_data OUT NOCOPY VARCHAR2,
117: p_rpcv_rec IN rpcv_rec_type);
117: p_rpcv_rec IN rpcv_rec_type);
118:
119: PROCEDURE lock_row(
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
125: p_rpcv_tbl IN rpcv_tbl_type);
125: p_rpcv_tbl IN rpcv_tbl_type);
126:
127: PROCEDURE update_row(
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_rpcv_rec IN rpcv_rec_type,
134: x_rpcv_rec OUT NOCOPY rpcv_rec_type);
135:
136: PROCEDURE update_row(
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,
142: p_rpcv_tbl IN rpcv_tbl_type,
143: x_rpcv_tbl OUT NOCOPY rpcv_tbl_type);
144:
145: PROCEDURE delete_row(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,
151: p_rpcv_rec IN rpcv_rec_type);
151: p_rpcv_rec IN rpcv_rec_type);
152:
153: PROCEDURE delete_row(
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
159: p_rpcv_tbl IN rpcv_tbl_type);
159: p_rpcv_tbl IN rpcv_tbl_type);
160:
161: PROCEDURE validate_row(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_rpcv_rec IN rpcv_rec_type);
167: p_rpcv_rec IN rpcv_rec_type);
168:
169: PROCEDURE validate_row(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_rpcv_tbl IN rpcv_tbl_type);