3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ovd_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: context_intent OKL_OPV_RULES.CONTEXT_INTENT%TYPE := OKC_API.G_MISS_CHAR,
9: orl_id NUMBER := OKC_API.G_MISS_NUM,
10: ove_id NUMBER := OKC_API.G_MISS_NUM,
11: copy_or_enter_flag OKL_OPV_RULES.COPY_OR_ENTER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ovd_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: context_intent OKL_OPV_RULES.CONTEXT_INTENT%TYPE := OKC_API.G_MISS_CHAR,
9: orl_id NUMBER := OKC_API.G_MISS_NUM,
10: ove_id NUMBER := OKC_API.G_MISS_NUM,
11: copy_or_enter_flag OKL_OPV_RULES.COPY_OR_ENTER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE ovd_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: context_intent OKL_OPV_RULES.CONTEXT_INTENT%TYPE := OKC_API.G_MISS_CHAR,
9: orl_id NUMBER := OKC_API.G_MISS_NUM,
10: ove_id NUMBER := OKC_API.G_MISS_NUM,
11: copy_or_enter_flag OKL_OPV_RULES.COPY_OR_ENTER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: context_inv_org NUMBER := OKC_API.G_MISS_NUM,
6: TYPE ovd_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: context_intent OKL_OPV_RULES.CONTEXT_INTENT%TYPE := OKC_API.G_MISS_CHAR,
9: orl_id NUMBER := OKC_API.G_MISS_NUM,
10: ove_id NUMBER := OKC_API.G_MISS_NUM,
11: copy_or_enter_flag OKL_OPV_RULES.COPY_OR_ENTER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: context_inv_org NUMBER := OKC_API.G_MISS_NUM,
14: context_org NUMBER := OKC_API.G_MISS_NUM,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: context_intent OKL_OPV_RULES.CONTEXT_INTENT%TYPE := OKC_API.G_MISS_CHAR,
9: orl_id NUMBER := OKC_API.G_MISS_NUM,
10: ove_id NUMBER := OKC_API.G_MISS_NUM,
11: copy_or_enter_flag OKL_OPV_RULES.COPY_OR_ENTER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: context_inv_org NUMBER := OKC_API.G_MISS_NUM,
14: context_org NUMBER := OKC_API.G_MISS_NUM,
15: context_asset_book OKL_OPV_RULES.CONTEXT_ASSET_BOOK%TYPE := OKC_API.G_MISS_CHAR,
8: context_intent OKL_OPV_RULES.CONTEXT_INTENT%TYPE := OKC_API.G_MISS_CHAR,
9: orl_id NUMBER := OKC_API.G_MISS_NUM,
10: ove_id NUMBER := OKC_API.G_MISS_NUM,
11: copy_or_enter_flag OKL_OPV_RULES.COPY_OR_ENTER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: context_inv_org NUMBER := OKC_API.G_MISS_NUM,
14: context_org NUMBER := OKC_API.G_MISS_NUM,
15: context_asset_book OKL_OPV_RULES.CONTEXT_ASSET_BOOK%TYPE := OKC_API.G_MISS_CHAR,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
9: orl_id NUMBER := OKC_API.G_MISS_NUM,
10: ove_id NUMBER := OKC_API.G_MISS_NUM,
11: copy_or_enter_flag OKL_OPV_RULES.COPY_OR_ENTER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: context_inv_org NUMBER := OKC_API.G_MISS_NUM,
14: context_org NUMBER := OKC_API.G_MISS_NUM,
15: context_asset_book OKL_OPV_RULES.CONTEXT_ASSET_BOOK%TYPE := OKC_API.G_MISS_CHAR,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKL_OPV_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
10: ove_id NUMBER := OKC_API.G_MISS_NUM,
11: copy_or_enter_flag OKL_OPV_RULES.COPY_OR_ENTER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: context_inv_org NUMBER := OKC_API.G_MISS_NUM,
14: context_org NUMBER := OKC_API.G_MISS_NUM,
15: context_asset_book OKL_OPV_RULES.CONTEXT_ASSET_BOOK%TYPE := OKC_API.G_MISS_CHAR,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKL_OPV_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
11: copy_or_enter_flag OKL_OPV_RULES.COPY_OR_ENTER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: context_inv_org NUMBER := OKC_API.G_MISS_NUM,
14: context_org NUMBER := OKC_API.G_MISS_NUM,
15: context_asset_book OKL_OPV_RULES.CONTEXT_ASSET_BOOK%TYPE := OKC_API.G_MISS_CHAR,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKL_OPV_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKL_OPV_RULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: context_inv_org NUMBER := OKC_API.G_MISS_NUM,
14: context_org NUMBER := OKC_API.G_MISS_NUM,
15: context_asset_book OKL_OPV_RULES.CONTEXT_ASSET_BOOK%TYPE := OKC_API.G_MISS_CHAR,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKL_OPV_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKL_OPV_RULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: individual_instructions OKL_OPV_RULES.INDIVIDUAL_INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
13: context_inv_org NUMBER := OKC_API.G_MISS_NUM,
14: context_org NUMBER := OKC_API.G_MISS_NUM,
15: context_asset_book OKL_OPV_RULES.CONTEXT_ASSET_BOOK%TYPE := OKC_API.G_MISS_CHAR,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKL_OPV_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKL_OPV_RULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: individual_instructions OKL_OPV_RULES.INDIVIDUAL_INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM);
14: context_org NUMBER := OKC_API.G_MISS_NUM,
15: context_asset_book OKL_OPV_RULES.CONTEXT_ASSET_BOOK%TYPE := OKC_API.G_MISS_CHAR,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKL_OPV_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKL_OPV_RULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: individual_instructions OKL_OPV_RULES.INDIVIDUAL_INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM);
22: g_miss_ovd_rec ovd_rec_type;
15: context_asset_book OKL_OPV_RULES.CONTEXT_ASSET_BOOK%TYPE := OKC_API.G_MISS_CHAR,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKL_OPV_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKL_OPV_RULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: individual_instructions OKL_OPV_RULES.INDIVIDUAL_INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM);
22: g_miss_ovd_rec ovd_rec_type;
23: TYPE ovd_tbl_type IS TABLE OF ovd_rec_type
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKL_OPV_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKL_OPV_RULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: individual_instructions OKL_OPV_RULES.INDIVIDUAL_INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM);
22: g_miss_ovd_rec ovd_rec_type;
23: TYPE ovd_tbl_type IS TABLE OF ovd_rec_type
24: INDEX BY BINARY_INTEGER;
17: creation_date OKL_OPV_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKL_OPV_RULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: individual_instructions OKL_OPV_RULES.INDIVIDUAL_INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM);
22: g_miss_ovd_rec ovd_rec_type;
23: TYPE ovd_tbl_type IS TABLE OF ovd_rec_type
24: INDEX BY BINARY_INTEGER;
25: TYPE ovdv_rec_type IS RECORD (
22: g_miss_ovd_rec ovd_rec_type;
23: TYPE ovd_tbl_type IS TABLE OF ovd_rec_type
24: INDEX BY BINARY_INTEGER;
25: TYPE ovdv_rec_type IS RECORD (
26: id NUMBER := OKC_API.G_MISS_NUM,
27: context_intent OKL_OPV_RULES_V.CONTEXT_INTENT%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: orl_id NUMBER := OKC_API.G_MISS_NUM,
30: ove_id NUMBER := OKC_API.G_MISS_NUM,
23: TYPE ovd_tbl_type IS TABLE OF ovd_rec_type
24: INDEX BY BINARY_INTEGER;
25: TYPE ovdv_rec_type IS RECORD (
26: id NUMBER := OKC_API.G_MISS_NUM,
27: context_intent OKL_OPV_RULES_V.CONTEXT_INTENT%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: orl_id NUMBER := OKC_API.G_MISS_NUM,
30: ove_id NUMBER := OKC_API.G_MISS_NUM,
31: individual_instructions OKL_OPV_RULES_V.INDIVIDUAL_INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
24: INDEX BY BINARY_INTEGER;
25: TYPE ovdv_rec_type IS RECORD (
26: id NUMBER := OKC_API.G_MISS_NUM,
27: context_intent OKL_OPV_RULES_V.CONTEXT_INTENT%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: orl_id NUMBER := OKC_API.G_MISS_NUM,
30: ove_id NUMBER := OKC_API.G_MISS_NUM,
31: individual_instructions OKL_OPV_RULES_V.INDIVIDUAL_INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
32: copy_or_enter_flag OKL_OPV_RULES_V.COPY_OR_ENTER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: TYPE ovdv_rec_type IS RECORD (
26: id NUMBER := OKC_API.G_MISS_NUM,
27: context_intent OKL_OPV_RULES_V.CONTEXT_INTENT%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: orl_id NUMBER := OKC_API.G_MISS_NUM,
30: ove_id NUMBER := OKC_API.G_MISS_NUM,
31: individual_instructions OKL_OPV_RULES_V.INDIVIDUAL_INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
32: copy_or_enter_flag OKL_OPV_RULES_V.COPY_OR_ENTER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
33: context_org NUMBER := OKC_API.G_MISS_NUM,
26: id NUMBER := OKC_API.G_MISS_NUM,
27: context_intent OKL_OPV_RULES_V.CONTEXT_INTENT%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: orl_id NUMBER := OKC_API.G_MISS_NUM,
30: ove_id NUMBER := OKC_API.G_MISS_NUM,
31: individual_instructions OKL_OPV_RULES_V.INDIVIDUAL_INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
32: copy_or_enter_flag OKL_OPV_RULES_V.COPY_OR_ENTER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
33: context_org NUMBER := OKC_API.G_MISS_NUM,
34: context_inv_org NUMBER := OKC_API.G_MISS_NUM,
27: context_intent OKL_OPV_RULES_V.CONTEXT_INTENT%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: orl_id NUMBER := OKC_API.G_MISS_NUM,
30: ove_id NUMBER := OKC_API.G_MISS_NUM,
31: individual_instructions OKL_OPV_RULES_V.INDIVIDUAL_INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
32: copy_or_enter_flag OKL_OPV_RULES_V.COPY_OR_ENTER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
33: context_org NUMBER := OKC_API.G_MISS_NUM,
34: context_inv_org NUMBER := OKC_API.G_MISS_NUM,
35: context_asset_book OKL_OPV_RULES_V.CONTEXT_ASSET_BOOK%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: orl_id NUMBER := OKC_API.G_MISS_NUM,
30: ove_id NUMBER := OKC_API.G_MISS_NUM,
31: individual_instructions OKL_OPV_RULES_V.INDIVIDUAL_INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
32: copy_or_enter_flag OKL_OPV_RULES_V.COPY_OR_ENTER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
33: context_org NUMBER := OKC_API.G_MISS_NUM,
34: context_inv_org NUMBER := OKC_API.G_MISS_NUM,
35: context_asset_book OKL_OPV_RULES_V.CONTEXT_ASSET_BOOK%TYPE := OKC_API.G_MISS_CHAR,
36: created_by NUMBER := OKC_API.G_MISS_NUM,
29: orl_id NUMBER := OKC_API.G_MISS_NUM,
30: ove_id NUMBER := OKC_API.G_MISS_NUM,
31: individual_instructions OKL_OPV_RULES_V.INDIVIDUAL_INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
32: copy_or_enter_flag OKL_OPV_RULES_V.COPY_OR_ENTER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
33: context_org NUMBER := OKC_API.G_MISS_NUM,
34: context_inv_org NUMBER := OKC_API.G_MISS_NUM,
35: context_asset_book OKL_OPV_RULES_V.CONTEXT_ASSET_BOOK%TYPE := OKC_API.G_MISS_CHAR,
36: created_by NUMBER := OKC_API.G_MISS_NUM,
37: creation_date OKL_OPV_RULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: ove_id NUMBER := OKC_API.G_MISS_NUM,
31: individual_instructions OKL_OPV_RULES_V.INDIVIDUAL_INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
32: copy_or_enter_flag OKL_OPV_RULES_V.COPY_OR_ENTER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
33: context_org NUMBER := OKC_API.G_MISS_NUM,
34: context_inv_org NUMBER := OKC_API.G_MISS_NUM,
35: context_asset_book OKL_OPV_RULES_V.CONTEXT_ASSET_BOOK%TYPE := OKC_API.G_MISS_CHAR,
36: created_by NUMBER := OKC_API.G_MISS_NUM,
37: creation_date OKL_OPV_RULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
38: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: individual_instructions OKL_OPV_RULES_V.INDIVIDUAL_INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
32: copy_or_enter_flag OKL_OPV_RULES_V.COPY_OR_ENTER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
33: context_org NUMBER := OKC_API.G_MISS_NUM,
34: context_inv_org NUMBER := OKC_API.G_MISS_NUM,
35: context_asset_book OKL_OPV_RULES_V.CONTEXT_ASSET_BOOK%TYPE := OKC_API.G_MISS_CHAR,
36: created_by NUMBER := OKC_API.G_MISS_NUM,
37: creation_date OKL_OPV_RULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
38: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
39: last_update_date OKL_OPV_RULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: copy_or_enter_flag OKL_OPV_RULES_V.COPY_OR_ENTER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
33: context_org NUMBER := OKC_API.G_MISS_NUM,
34: context_inv_org NUMBER := OKC_API.G_MISS_NUM,
35: context_asset_book OKL_OPV_RULES_V.CONTEXT_ASSET_BOOK%TYPE := OKC_API.G_MISS_CHAR,
36: created_by NUMBER := OKC_API.G_MISS_NUM,
37: creation_date OKL_OPV_RULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
38: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
39: last_update_date OKL_OPV_RULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
40: last_update_login NUMBER := OKC_API.G_MISS_NUM);
33: context_org NUMBER := OKC_API.G_MISS_NUM,
34: context_inv_org NUMBER := OKC_API.G_MISS_NUM,
35: context_asset_book OKL_OPV_RULES_V.CONTEXT_ASSET_BOOK%TYPE := OKC_API.G_MISS_CHAR,
36: created_by NUMBER := OKC_API.G_MISS_NUM,
37: creation_date OKL_OPV_RULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
38: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
39: last_update_date OKL_OPV_RULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
40: last_update_login NUMBER := OKC_API.G_MISS_NUM);
41: g_miss_ovdv_rec ovdv_rec_type;
34: context_inv_org NUMBER := OKC_API.G_MISS_NUM,
35: context_asset_book OKL_OPV_RULES_V.CONTEXT_ASSET_BOOK%TYPE := OKC_API.G_MISS_CHAR,
36: created_by NUMBER := OKC_API.G_MISS_NUM,
37: creation_date OKL_OPV_RULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
38: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
39: last_update_date OKL_OPV_RULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
40: last_update_login NUMBER := OKC_API.G_MISS_NUM);
41: g_miss_ovdv_rec ovdv_rec_type;
42: TYPE ovdv_tbl_type IS TABLE OF ovdv_rec_type
35: context_asset_book OKL_OPV_RULES_V.CONTEXT_ASSET_BOOK%TYPE := OKC_API.G_MISS_CHAR,
36: created_by NUMBER := OKC_API.G_MISS_NUM,
37: creation_date OKL_OPV_RULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
38: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
39: last_update_date OKL_OPV_RULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
40: last_update_login NUMBER := OKC_API.G_MISS_NUM);
41: g_miss_ovdv_rec ovdv_rec_type;
42: TYPE ovdv_tbl_type IS TABLE OF ovdv_rec_type
43: INDEX BY BINARY_INTEGER;
36: created_by NUMBER := OKC_API.G_MISS_NUM,
37: creation_date OKL_OPV_RULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
38: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
39: last_update_date OKL_OPV_RULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
40: last_update_login NUMBER := OKC_API.G_MISS_NUM);
41: g_miss_ovdv_rec ovdv_rec_type;
42: TYPE ovdv_tbl_type IS TABLE OF ovdv_rec_type
43: INDEX BY BINARY_INTEGER;
44: ---------------------------------------------------------------------------
43: INDEX BY BINARY_INTEGER;
44: ---------------------------------------------------------------------------
45: -- GLOBAL MESSAGE CONSTANTS
46: ---------------------------------------------------------------------------
47: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
48: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
49: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
44: ---------------------------------------------------------------------------
45: -- GLOBAL MESSAGE CONSTANTS
46: ---------------------------------------------------------------------------
47: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
48: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
49: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
45: -- GLOBAL MESSAGE CONSTANTS
46: ---------------------------------------------------------------------------
47: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
48: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
49: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
46: ---------------------------------------------------------------------------
47: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
48: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
49: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
47: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
48: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
49: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
48: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
49: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
56: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
49: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
56: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
57:
50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
56: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
57:
58: -- RPOONUGA001: Add new global variables
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
56: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
57:
58: -- RPOONUGA001: Add new global variables
59: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
56: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
57:
58: -- RPOONUGA001: Add new global variables
59: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
60: G_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_TABLE_NAME';
71: ---------------------------------------------------------------------------
72: -- GLOBAL VARIABLES
73: ---------------------------------------------------------------------------
74: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_OVD_PVT';
75: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
76: -- RPOONUGA001: Add new global variables
77: G_LOOKUP_TYPE CONSTANT VARCHAR2(50) := 'OKL_OPTION_VALUE_RULE_FLAG';
78: G_INTENT_TYPE CONSTANT VARCHAR2(50) := 'OKL_INTENT_TYPE';
79: ---------------------------------------------------------------------------
84: PROCEDURE change_version;
85: PROCEDURE api_copy;
86: PROCEDURE insert_row(
87: p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
89: x_return_status OUT NOCOPY VARCHAR2,
90: x_msg_count OUT NOCOPY NUMBER,
91: x_msg_data OUT NOCOPY VARCHAR2,
92: p_ovdv_rec IN ovdv_rec_type,
93: x_ovdv_rec OUT NOCOPY ovdv_rec_type);
94:
95: PROCEDURE insert_row(
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2,
101: p_ovdv_tbl IN ovdv_tbl_type,
102: x_ovdv_tbl OUT NOCOPY ovdv_tbl_type);
103:
104: PROCEDURE lock_row(
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
107: x_return_status OUT NOCOPY VARCHAR2,
108: x_msg_count OUT NOCOPY NUMBER,
109: x_msg_data OUT NOCOPY VARCHAR2,
110: p_ovdv_rec IN ovdv_rec_type);
110: p_ovdv_rec IN ovdv_rec_type);
111:
112: PROCEDURE lock_row(
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_ovdv_tbl IN ovdv_tbl_type);
118: p_ovdv_tbl IN ovdv_tbl_type);
119:
120: PROCEDURE update_row(
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,
126: p_ovdv_rec IN ovdv_rec_type,
127: x_ovdv_rec OUT NOCOPY ovdv_rec_type);
128:
129: PROCEDURE update_row(
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2,
135: p_ovdv_tbl IN ovdv_tbl_type,
136: x_ovdv_tbl OUT NOCOPY ovdv_tbl_type);
137:
138: PROCEDURE delete_row(
139: p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_ovdv_rec IN ovdv_rec_type);
144: p_ovdv_rec IN ovdv_rec_type);
145:
146: PROCEDURE delete_row(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_ovdv_tbl IN ovdv_tbl_type);
152: p_ovdv_tbl IN ovdv_tbl_type);
153:
154: PROCEDURE validate_row(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_ovdv_rec IN ovdv_rec_type);
160: p_ovdv_rec IN ovdv_rec_type);
161:
162: PROCEDURE validate_row(
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_ovdv_tbl IN ovdv_tbl_type);