3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE mrd_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: oie_id NUMBER := OKC_API.G_MISS_NUM,
9: ole_id NUMBER := OKC_API.G_MISS_NUM,
10: attribute_name OKC_MASSCHANGE_REQ_DTLS.ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
11: old_value OKC_MASSCHANGE_REQ_DTLS.OLD_VALUE%TYPE := OKC_API.G_MISS_CHAR,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE mrd_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: oie_id NUMBER := OKC_API.G_MISS_NUM,
9: ole_id NUMBER := OKC_API.G_MISS_NUM,
10: attribute_name OKC_MASSCHANGE_REQ_DTLS.ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
11: old_value OKC_MASSCHANGE_REQ_DTLS.OLD_VALUE%TYPE := OKC_API.G_MISS_CHAR,
12: new_value OKC_MASSCHANGE_REQ_DTLS.NEW_VALUE%TYPE := OKC_API.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE mrd_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: oie_id NUMBER := OKC_API.G_MISS_NUM,
9: ole_id NUMBER := OKC_API.G_MISS_NUM,
10: attribute_name OKC_MASSCHANGE_REQ_DTLS.ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
11: old_value OKC_MASSCHANGE_REQ_DTLS.OLD_VALUE%TYPE := OKC_API.G_MISS_CHAR,
12: new_value OKC_MASSCHANGE_REQ_DTLS.NEW_VALUE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
6: TYPE mrd_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: oie_id NUMBER := OKC_API.G_MISS_NUM,
9: ole_id NUMBER := OKC_API.G_MISS_NUM,
10: attribute_name OKC_MASSCHANGE_REQ_DTLS.ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
11: old_value OKC_MASSCHANGE_REQ_DTLS.OLD_VALUE%TYPE := OKC_API.G_MISS_CHAR,
12: new_value OKC_MASSCHANGE_REQ_DTLS.NEW_VALUE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: oie_id NUMBER := OKC_API.G_MISS_NUM,
9: ole_id NUMBER := OKC_API.G_MISS_NUM,
10: attribute_name OKC_MASSCHANGE_REQ_DTLS.ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
11: old_value OKC_MASSCHANGE_REQ_DTLS.OLD_VALUE%TYPE := OKC_API.G_MISS_CHAR,
12: new_value OKC_MASSCHANGE_REQ_DTLS.NEW_VALUE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKC_MASSCHANGE_REQ_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
8: oie_id NUMBER := OKC_API.G_MISS_NUM,
9: ole_id NUMBER := OKC_API.G_MISS_NUM,
10: attribute_name OKC_MASSCHANGE_REQ_DTLS.ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
11: old_value OKC_MASSCHANGE_REQ_DTLS.OLD_VALUE%TYPE := OKC_API.G_MISS_CHAR,
12: new_value OKC_MASSCHANGE_REQ_DTLS.NEW_VALUE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKC_MASSCHANGE_REQ_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
9: ole_id NUMBER := OKC_API.G_MISS_NUM,
10: attribute_name OKC_MASSCHANGE_REQ_DTLS.ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
11: old_value OKC_MASSCHANGE_REQ_DTLS.OLD_VALUE%TYPE := OKC_API.G_MISS_CHAR,
12: new_value OKC_MASSCHANGE_REQ_DTLS.NEW_VALUE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKC_MASSCHANGE_REQ_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKC_MASSCHANGE_REQ_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
10: attribute_name OKC_MASSCHANGE_REQ_DTLS.ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
11: old_value OKC_MASSCHANGE_REQ_DTLS.OLD_VALUE%TYPE := OKC_API.G_MISS_CHAR,
12: new_value OKC_MASSCHANGE_REQ_DTLS.NEW_VALUE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKC_MASSCHANGE_REQ_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKC_MASSCHANGE_REQ_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_update_login NUMBER := OKC_API.G_MISS_NUM);
11: old_value OKC_MASSCHANGE_REQ_DTLS.OLD_VALUE%TYPE := OKC_API.G_MISS_CHAR,
12: new_value OKC_MASSCHANGE_REQ_DTLS.NEW_VALUE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKC_MASSCHANGE_REQ_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKC_MASSCHANGE_REQ_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_update_login NUMBER := OKC_API.G_MISS_NUM);
19: g_miss_mrd_rec mrd_rec_type;
12: new_value OKC_MASSCHANGE_REQ_DTLS.NEW_VALUE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKC_MASSCHANGE_REQ_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKC_MASSCHANGE_REQ_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_update_login NUMBER := OKC_API.G_MISS_NUM);
19: g_miss_mrd_rec mrd_rec_type;
20: TYPE mrd_tbl_type IS TABLE OF mrd_rec_type
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKC_MASSCHANGE_REQ_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKC_MASSCHANGE_REQ_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_update_login NUMBER := OKC_API.G_MISS_NUM);
19: g_miss_mrd_rec mrd_rec_type;
20: TYPE mrd_tbl_type IS TABLE OF mrd_rec_type
21: INDEX BY BINARY_INTEGER;
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKC_MASSCHANGE_REQ_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKC_MASSCHANGE_REQ_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_update_login NUMBER := OKC_API.G_MISS_NUM);
19: g_miss_mrd_rec mrd_rec_type;
20: TYPE mrd_tbl_type IS TABLE OF mrd_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE mrdv_rec_type IS RECORD (
19: g_miss_mrd_rec mrd_rec_type;
20: TYPE mrd_tbl_type IS TABLE OF mrd_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE mrdv_rec_type IS RECORD (
23: id NUMBER := OKC_API.G_MISS_NUM,
24: oie_id NUMBER := OKC_API.G_MISS_NUM,
25: ole_id NUMBER := OKC_API.G_MISS_NUM,
26: attribute_name OKC_MASSCHANGE_REQ_DTLS_V.ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
27: old_value OKC_MASSCHANGE_REQ_DTLS_V.OLD_VALUE%TYPE := OKC_API.G_MISS_CHAR,
20: TYPE mrd_tbl_type IS TABLE OF mrd_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE mrdv_rec_type IS RECORD (
23: id NUMBER := OKC_API.G_MISS_NUM,
24: oie_id NUMBER := OKC_API.G_MISS_NUM,
25: ole_id NUMBER := OKC_API.G_MISS_NUM,
26: attribute_name OKC_MASSCHANGE_REQ_DTLS_V.ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
27: old_value OKC_MASSCHANGE_REQ_DTLS_V.OLD_VALUE%TYPE := OKC_API.G_MISS_CHAR,
28: new_value OKC_MASSCHANGE_REQ_DTLS_V.NEW_VALUE%TYPE := OKC_API.G_MISS_CHAR,
21: INDEX BY BINARY_INTEGER;
22: TYPE mrdv_rec_type IS RECORD (
23: id NUMBER := OKC_API.G_MISS_NUM,
24: oie_id NUMBER := OKC_API.G_MISS_NUM,
25: ole_id NUMBER := OKC_API.G_MISS_NUM,
26: attribute_name OKC_MASSCHANGE_REQ_DTLS_V.ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
27: old_value OKC_MASSCHANGE_REQ_DTLS_V.OLD_VALUE%TYPE := OKC_API.G_MISS_CHAR,
28: new_value OKC_MASSCHANGE_REQ_DTLS_V.NEW_VALUE%TYPE := OKC_API.G_MISS_CHAR,
29: object_version_number NUMBER := OKC_API.G_MISS_NUM,
22: TYPE mrdv_rec_type IS RECORD (
23: id NUMBER := OKC_API.G_MISS_NUM,
24: oie_id NUMBER := OKC_API.G_MISS_NUM,
25: ole_id NUMBER := OKC_API.G_MISS_NUM,
26: attribute_name OKC_MASSCHANGE_REQ_DTLS_V.ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
27: old_value OKC_MASSCHANGE_REQ_DTLS_V.OLD_VALUE%TYPE := OKC_API.G_MISS_CHAR,
28: new_value OKC_MASSCHANGE_REQ_DTLS_V.NEW_VALUE%TYPE := OKC_API.G_MISS_CHAR,
29: object_version_number NUMBER := OKC_API.G_MISS_NUM,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
23: id NUMBER := OKC_API.G_MISS_NUM,
24: oie_id NUMBER := OKC_API.G_MISS_NUM,
25: ole_id NUMBER := OKC_API.G_MISS_NUM,
26: attribute_name OKC_MASSCHANGE_REQ_DTLS_V.ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
27: old_value OKC_MASSCHANGE_REQ_DTLS_V.OLD_VALUE%TYPE := OKC_API.G_MISS_CHAR,
28: new_value OKC_MASSCHANGE_REQ_DTLS_V.NEW_VALUE%TYPE := OKC_API.G_MISS_CHAR,
29: object_version_number NUMBER := OKC_API.G_MISS_NUM,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKC_MASSCHANGE_REQ_DTLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
24: oie_id NUMBER := OKC_API.G_MISS_NUM,
25: ole_id NUMBER := OKC_API.G_MISS_NUM,
26: attribute_name OKC_MASSCHANGE_REQ_DTLS_V.ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
27: old_value OKC_MASSCHANGE_REQ_DTLS_V.OLD_VALUE%TYPE := OKC_API.G_MISS_CHAR,
28: new_value OKC_MASSCHANGE_REQ_DTLS_V.NEW_VALUE%TYPE := OKC_API.G_MISS_CHAR,
29: object_version_number NUMBER := OKC_API.G_MISS_NUM,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKC_MASSCHANGE_REQ_DTLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
25: ole_id NUMBER := OKC_API.G_MISS_NUM,
26: attribute_name OKC_MASSCHANGE_REQ_DTLS_V.ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
27: old_value OKC_MASSCHANGE_REQ_DTLS_V.OLD_VALUE%TYPE := OKC_API.G_MISS_CHAR,
28: new_value OKC_MASSCHANGE_REQ_DTLS_V.NEW_VALUE%TYPE := OKC_API.G_MISS_CHAR,
29: object_version_number NUMBER := OKC_API.G_MISS_NUM,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKC_MASSCHANGE_REQ_DTLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKC_MASSCHANGE_REQ_DTLS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
26: attribute_name OKC_MASSCHANGE_REQ_DTLS_V.ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
27: old_value OKC_MASSCHANGE_REQ_DTLS_V.OLD_VALUE%TYPE := OKC_API.G_MISS_CHAR,
28: new_value OKC_MASSCHANGE_REQ_DTLS_V.NEW_VALUE%TYPE := OKC_API.G_MISS_CHAR,
29: object_version_number NUMBER := OKC_API.G_MISS_NUM,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKC_MASSCHANGE_REQ_DTLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKC_MASSCHANGE_REQ_DTLS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_update_login NUMBER := OKC_API.G_MISS_NUM);
27: old_value OKC_MASSCHANGE_REQ_DTLS_V.OLD_VALUE%TYPE := OKC_API.G_MISS_CHAR,
28: new_value OKC_MASSCHANGE_REQ_DTLS_V.NEW_VALUE%TYPE := OKC_API.G_MISS_CHAR,
29: object_version_number NUMBER := OKC_API.G_MISS_NUM,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKC_MASSCHANGE_REQ_DTLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKC_MASSCHANGE_REQ_DTLS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_update_login NUMBER := OKC_API.G_MISS_NUM);
35: g_miss_mrdv_rec mrdv_rec_type;
28: new_value OKC_MASSCHANGE_REQ_DTLS_V.NEW_VALUE%TYPE := OKC_API.G_MISS_CHAR,
29: object_version_number NUMBER := OKC_API.G_MISS_NUM,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKC_MASSCHANGE_REQ_DTLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKC_MASSCHANGE_REQ_DTLS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_update_login NUMBER := OKC_API.G_MISS_NUM);
35: g_miss_mrdv_rec mrdv_rec_type;
36: TYPE mrdv_tbl_type IS TABLE OF mrdv_rec_type
29: object_version_number NUMBER := OKC_API.G_MISS_NUM,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKC_MASSCHANGE_REQ_DTLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKC_MASSCHANGE_REQ_DTLS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_update_login NUMBER := OKC_API.G_MISS_NUM);
35: g_miss_mrdv_rec mrdv_rec_type;
36: TYPE mrdv_tbl_type IS TABLE OF mrdv_rec_type
37: INDEX BY BINARY_INTEGER;
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKC_MASSCHANGE_REQ_DTLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKC_MASSCHANGE_REQ_DTLS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_update_login NUMBER := OKC_API.G_MISS_NUM);
35: g_miss_mrdv_rec mrdv_rec_type;
36: TYPE mrdv_tbl_type IS TABLE OF mrdv_rec_type
37: INDEX BY BINARY_INTEGER;
38: ---------------------------------------------------------------------------
37: INDEX BY BINARY_INTEGER;
38: ---------------------------------------------------------------------------
39: -- GLOBAL MESSAGE CONSTANTS
40: ---------------------------------------------------------------------------
41: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
38: ---------------------------------------------------------------------------
39: -- GLOBAL MESSAGE CONSTANTS
40: ---------------------------------------------------------------------------
41: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
39: -- GLOBAL MESSAGE CONSTANTS
40: ---------------------------------------------------------------------------
41: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40: ---------------------------------------------------------------------------
41: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
41: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
51: ---------------------------------------------------------------------------
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
51: ---------------------------------------------------------------------------
52: -- GLOBAL VARIABLES
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
51: ---------------------------------------------------------------------------
52: -- GLOBAL VARIABLES
53: ---------------------------------------------------------------------------
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
51: ---------------------------------------------------------------------------
52: -- GLOBAL VARIABLES
53: ---------------------------------------------------------------------------
54: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_MRD_PVT';
51: ---------------------------------------------------------------------------
52: -- GLOBAL VARIABLES
53: ---------------------------------------------------------------------------
54: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_MRD_PVT';
55: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
56: ---------------------------------------------------------------------------
57: -- Procedures and Functions
58: ---------------------------------------------------------------------------
59:
61: PROCEDURE change_version;
62: PROCEDURE api_copy;
63: PROCEDURE insert_row(
64: p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
66: x_return_status OUT NOCOPY VARCHAR2,
67: x_msg_count OUT NOCOPY NUMBER,
68: x_msg_data OUT NOCOPY VARCHAR2,
69: p_mrdv_rec IN mrdv_rec_type,
70: x_mrdv_rec OUT NOCOPY mrdv_rec_type);
71:
72: PROCEDURE insert_row(
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
75: x_return_status OUT NOCOPY VARCHAR2,
76: x_msg_count OUT NOCOPY NUMBER,
77: x_msg_data OUT NOCOPY VARCHAR2,
78: p_mrdv_tbl IN mrdv_tbl_type,
79: x_mrdv_tbl OUT NOCOPY mrdv_tbl_type);
80:
81: PROCEDURE lock_row(
82: p_api_version IN NUMBER,
83: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
84: x_return_status OUT NOCOPY VARCHAR2,
85: x_msg_count OUT NOCOPY NUMBER,
86: x_msg_data OUT NOCOPY VARCHAR2,
87: p_mrdv_rec IN mrdv_rec_type);
87: p_mrdv_rec IN mrdv_rec_type);
88:
89: PROCEDURE lock_row(
90: p_api_version IN NUMBER,
91: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
92: x_return_status OUT NOCOPY VARCHAR2,
93: x_msg_count OUT NOCOPY NUMBER,
94: x_msg_data OUT NOCOPY VARCHAR2,
95: p_mrdv_tbl IN mrdv_tbl_type);
95: p_mrdv_tbl IN mrdv_tbl_type);
96:
97: PROCEDURE update_row(
98: p_api_version IN NUMBER,
99: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
102: x_msg_data OUT NOCOPY VARCHAR2,
103: p_mrdv_rec IN mrdv_rec_type,
104: x_mrdv_rec OUT NOCOPY mrdv_rec_type);
105:
106: PROCEDURE update_row(
107: p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
109: x_return_status OUT NOCOPY VARCHAR2,
110: x_msg_count OUT NOCOPY NUMBER,
111: x_msg_data OUT NOCOPY VARCHAR2,
112: p_mrdv_tbl IN mrdv_tbl_type,
113: x_mrdv_tbl OUT NOCOPY mrdv_tbl_type);
114:
115: PROCEDURE delete_row(
116: p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2,
121: p_mrdv_rec IN mrdv_rec_type);
121: p_mrdv_rec IN mrdv_rec_type);
122:
123: PROCEDURE delete_row(
124: p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2,
129: p_mrdv_tbl IN mrdv_tbl_type);
129: p_mrdv_tbl IN mrdv_tbl_type);
130:
131: PROCEDURE validate_row(
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_mrdv_rec IN mrdv_rec_type);
137: p_mrdv_rec IN mrdv_rec_type);
138:
139: PROCEDURE validate_row(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_mrdv_tbl IN mrdv_tbl_type);