3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE agb_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: khr_id OKL_ACC_GROUP_BAL.KHR_ID%TYPE := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: date_balance OKL_ACC_GROUP_BAL.DATE_BALANCE%TYPE := OKC_API.G_MISS_DATE,
11: acc_group_id OKL_ACC_GROUP_BAL.ACC_GROUP_ID%TYPE := OKC_API.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE agb_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: khr_id OKL_ACC_GROUP_BAL.KHR_ID%TYPE := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: date_balance OKL_ACC_GROUP_BAL.DATE_BALANCE%TYPE := OKC_API.G_MISS_DATE,
11: acc_group_id OKL_ACC_GROUP_BAL.ACC_GROUP_ID%TYPE := OKC_API.G_MISS_NUM,
12: amount NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE agb_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: khr_id OKL_ACC_GROUP_BAL.KHR_ID%TYPE := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: date_balance OKL_ACC_GROUP_BAL.DATE_BALANCE%TYPE := OKC_API.G_MISS_DATE,
11: acc_group_id OKL_ACC_GROUP_BAL.ACC_GROUP_ID%TYPE := OKC_API.G_MISS_NUM,
12: amount NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
6: TYPE agb_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: khr_id OKL_ACC_GROUP_BAL.KHR_ID%TYPE := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: date_balance OKL_ACC_GROUP_BAL.DATE_BALANCE%TYPE := OKC_API.G_MISS_DATE,
11: acc_group_id OKL_ACC_GROUP_BAL.ACC_GROUP_ID%TYPE := OKC_API.G_MISS_NUM,
12: amount NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_ACC_GROUP_BAL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: khr_id OKL_ACC_GROUP_BAL.KHR_ID%TYPE := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: date_balance OKL_ACC_GROUP_BAL.DATE_BALANCE%TYPE := OKC_API.G_MISS_DATE,
11: acc_group_id OKL_ACC_GROUP_BAL.ACC_GROUP_ID%TYPE := OKC_API.G_MISS_NUM,
12: amount NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_ACC_GROUP_BAL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
8: khr_id OKL_ACC_GROUP_BAL.KHR_ID%TYPE := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: date_balance OKL_ACC_GROUP_BAL.DATE_BALANCE%TYPE := OKC_API.G_MISS_DATE,
11: acc_group_id OKL_ACC_GROUP_BAL.ACC_GROUP_ID%TYPE := OKC_API.G_MISS_NUM,
12: amount NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_ACC_GROUP_BAL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_ACC_GROUP_BAL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: date_balance OKL_ACC_GROUP_BAL.DATE_BALANCE%TYPE := OKC_API.G_MISS_DATE,
11: acc_group_id OKL_ACC_GROUP_BAL.ACC_GROUP_ID%TYPE := OKC_API.G_MISS_NUM,
12: amount NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_ACC_GROUP_BAL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_ACC_GROUP_BAL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
10: date_balance OKL_ACC_GROUP_BAL.DATE_BALANCE%TYPE := OKC_API.G_MISS_DATE,
11: acc_group_id OKL_ACC_GROUP_BAL.ACC_GROUP_ID%TYPE := OKC_API.G_MISS_NUM,
12: amount NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_ACC_GROUP_BAL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_ACC_GROUP_BAL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18:
11: acc_group_id OKL_ACC_GROUP_BAL.ACC_GROUP_ID%TYPE := OKC_API.G_MISS_NUM,
12: amount NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_ACC_GROUP_BAL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_ACC_GROUP_BAL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18:
19: g_miss_agb_rec agb_rec_type;
12: amount NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_ACC_GROUP_BAL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_ACC_GROUP_BAL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18:
19: g_miss_agb_rec agb_rec_type;
20: TYPE agb_tbl_type IS TABLE OF agb_rec_type
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_ACC_GROUP_BAL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_ACC_GROUP_BAL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18:
19: g_miss_agb_rec agb_rec_type;
20: TYPE agb_tbl_type IS TABLE OF agb_rec_type
21: INDEX BY BINARY_INTEGER;
20: TYPE agb_tbl_type IS TABLE OF agb_rec_type
21: INDEX BY BINARY_INTEGER;
22:
23: TYPE agbv_rec_type IS RECORD (
24: id NUMBER := OKC_API.G_MISS_NUM,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: acc_group_id OKL_ACC_GROUP_BAL_V.ACC_GROUP_ID%TYPE := OKC_API.G_MISS_NUM,
27: khr_id OKL_ACC_GROUP_BAL_V.KHR_ID%TYPE := OKC_API.G_MISS_NUM,
28: date_balance OKL_ACC_GROUP_BAL_V.DATE_BALANCE%TYPE := OKC_API.G_MISS_DATE,
21: INDEX BY BINARY_INTEGER;
22:
23: TYPE agbv_rec_type IS RECORD (
24: id NUMBER := OKC_API.G_MISS_NUM,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: acc_group_id OKL_ACC_GROUP_BAL_V.ACC_GROUP_ID%TYPE := OKC_API.G_MISS_NUM,
27: khr_id OKL_ACC_GROUP_BAL_V.KHR_ID%TYPE := OKC_API.G_MISS_NUM,
28: date_balance OKL_ACC_GROUP_BAL_V.DATE_BALANCE%TYPE := OKC_API.G_MISS_DATE,
29: amount NUMBER := OKC_API.G_MISS_NUM,
22:
23: TYPE agbv_rec_type IS RECORD (
24: id NUMBER := OKC_API.G_MISS_NUM,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: acc_group_id OKL_ACC_GROUP_BAL_V.ACC_GROUP_ID%TYPE := OKC_API.G_MISS_NUM,
27: khr_id OKL_ACC_GROUP_BAL_V.KHR_ID%TYPE := OKC_API.G_MISS_NUM,
28: date_balance OKL_ACC_GROUP_BAL_V.DATE_BALANCE%TYPE := OKC_API.G_MISS_DATE,
29: amount NUMBER := OKC_API.G_MISS_NUM,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
23: TYPE agbv_rec_type IS RECORD (
24: id NUMBER := OKC_API.G_MISS_NUM,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: acc_group_id OKL_ACC_GROUP_BAL_V.ACC_GROUP_ID%TYPE := OKC_API.G_MISS_NUM,
27: khr_id OKL_ACC_GROUP_BAL_V.KHR_ID%TYPE := OKC_API.G_MISS_NUM,
28: date_balance OKL_ACC_GROUP_BAL_V.DATE_BALANCE%TYPE := OKC_API.G_MISS_DATE,
29: amount NUMBER := OKC_API.G_MISS_NUM,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_ACC_GROUP_BAL_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
24: id NUMBER := OKC_API.G_MISS_NUM,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: acc_group_id OKL_ACC_GROUP_BAL_V.ACC_GROUP_ID%TYPE := OKC_API.G_MISS_NUM,
27: khr_id OKL_ACC_GROUP_BAL_V.KHR_ID%TYPE := OKC_API.G_MISS_NUM,
28: date_balance OKL_ACC_GROUP_BAL_V.DATE_BALANCE%TYPE := OKC_API.G_MISS_DATE,
29: amount NUMBER := OKC_API.G_MISS_NUM,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_ACC_GROUP_BAL_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: acc_group_id OKL_ACC_GROUP_BAL_V.ACC_GROUP_ID%TYPE := OKC_API.G_MISS_NUM,
27: khr_id OKL_ACC_GROUP_BAL_V.KHR_ID%TYPE := OKC_API.G_MISS_NUM,
28: date_balance OKL_ACC_GROUP_BAL_V.DATE_BALANCE%TYPE := OKC_API.G_MISS_DATE,
29: amount NUMBER := OKC_API.G_MISS_NUM,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_ACC_GROUP_BAL_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKL_ACC_GROUP_BAL_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
26: acc_group_id OKL_ACC_GROUP_BAL_V.ACC_GROUP_ID%TYPE := OKC_API.G_MISS_NUM,
27: khr_id OKL_ACC_GROUP_BAL_V.KHR_ID%TYPE := OKC_API.G_MISS_NUM,
28: date_balance OKL_ACC_GROUP_BAL_V.DATE_BALANCE%TYPE := OKC_API.G_MISS_DATE,
29: amount NUMBER := OKC_API.G_MISS_NUM,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_ACC_GROUP_BAL_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKL_ACC_GROUP_BAL_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_update_login NUMBER := OKC_API.G_MISS_NUM);
27: khr_id OKL_ACC_GROUP_BAL_V.KHR_ID%TYPE := OKC_API.G_MISS_NUM,
28: date_balance OKL_ACC_GROUP_BAL_V.DATE_BALANCE%TYPE := OKC_API.G_MISS_DATE,
29: amount NUMBER := OKC_API.G_MISS_NUM,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_ACC_GROUP_BAL_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKL_ACC_GROUP_BAL_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_update_login NUMBER := OKC_API.G_MISS_NUM);
35:
28: date_balance OKL_ACC_GROUP_BAL_V.DATE_BALANCE%TYPE := OKC_API.G_MISS_DATE,
29: amount NUMBER := OKC_API.G_MISS_NUM,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_ACC_GROUP_BAL_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKL_ACC_GROUP_BAL_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_update_login NUMBER := OKC_API.G_MISS_NUM);
35:
36: g_miss_agbv_rec agbv_rec_type;
29: amount NUMBER := OKC_API.G_MISS_NUM,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_ACC_GROUP_BAL_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKL_ACC_GROUP_BAL_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_update_login NUMBER := OKC_API.G_MISS_NUM);
35:
36: g_miss_agbv_rec agbv_rec_type;
37:
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_ACC_GROUP_BAL_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKL_ACC_GROUP_BAL_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_update_login NUMBER := OKC_API.G_MISS_NUM);
35:
36: g_miss_agbv_rec agbv_rec_type;
37:
38: TYPE agbv_tbl_type IS TABLE OF agbv_rec_type
39: INDEX BY BINARY_INTEGER;
40: ---------------------------------------------------------------------------
41: -- GLOBAL MESSAGE CONSTANTS
42: ---------------------------------------------------------------------------
43: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
44: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
45: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
46: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
47: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
40: ---------------------------------------------------------------------------
41: -- GLOBAL MESSAGE CONSTANTS
42: ---------------------------------------------------------------------------
43: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
44: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
45: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
46: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
47: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
48: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
41: -- GLOBAL MESSAGE CONSTANTS
42: ---------------------------------------------------------------------------
43: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
44: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
45: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
46: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
47: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
48: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
49: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
42: ---------------------------------------------------------------------------
43: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
44: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
45: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
46: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
47: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
48: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
49: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
50: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
43: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
44: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
45: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
46: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
47: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
48: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
49: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
50: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
51: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
44: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
45: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
46: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
47: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
48: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
49: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
50: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
51: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
52: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
45: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
46: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
47: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
48: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
49: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
50: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
51: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
52: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
53: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200):='OKL_CONTRACTS_UNEXPECTED_ERROR';
46: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
47: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
48: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
49: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
50: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
51: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
52: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
53: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200):='OKL_CONTRACTS_UNEXPECTED_ERROR';
54: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
47: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
48: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
49: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
50: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
51: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
52: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
53: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200):='OKL_CONTRACTS_UNEXPECTED_ERROR';
54: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
55:
48: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
49: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
50: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
51: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
52: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
53: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200):='OKL_CONTRACTS_UNEXPECTED_ERROR';
54: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
55:
56: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
59: ---------------------------------------------------------------------------
60: -- GLOBAL VARIABLES
61: ---------------------------------------------------------------------------
62: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AGB_PVT';
63: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
64: G_UNQS CONSTANT VARCHAR2(200) := 'OKL_AGB_ELEMENT_NOT_UNIQUE';
65:
66: ---------------------------------------------------------------------------
67:
79: PROCEDURE change_version;
80: PROCEDURE api_copy;
81: PROCEDURE insert_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_agbv_rec IN agbv_rec_type,
88: x_agbv_rec OUT NOCOPY agbv_rec_type);
89:
90: PROCEDURE insert_row(
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
93: x_return_status OUT NOCOPY VARCHAR2,
94: x_msg_count OUT NOCOPY NUMBER,
95: x_msg_data OUT NOCOPY VARCHAR2,
96: p_agbv_tbl IN agbv_tbl_type,
97: x_agbv_tbl OUT NOCOPY agbv_tbl_type);
98:
99: PROCEDURE lock_row(
100: p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
102: x_return_status OUT NOCOPY VARCHAR2,
103: x_msg_count OUT NOCOPY NUMBER,
104: x_msg_data OUT NOCOPY VARCHAR2,
105: p_agbv_rec IN agbv_rec_type);
105: p_agbv_rec IN agbv_rec_type);
106:
107: PROCEDURE lock_row(
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2,
113: p_agbv_tbl IN agbv_tbl_type);
113: p_agbv_tbl IN agbv_tbl_type);
114:
115: PROCEDURE update_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_agbv_rec IN agbv_rec_type,
122: x_agbv_rec OUT NOCOPY agbv_rec_type);
123:
124: PROCEDURE update_row(
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
130: p_agbv_tbl IN agbv_tbl_type,
131: x_agbv_tbl OUT NOCOPY agbv_tbl_type);
132:
133: PROCEDURE delete_row(
134: p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2,
139: p_agbv_rec IN agbv_rec_type);
139: p_agbv_rec IN agbv_rec_type);
140:
141: PROCEDURE delete_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_agbv_tbl IN agbv_tbl_type);
147: p_agbv_tbl IN agbv_tbl_type);
148:
149: PROCEDURE validate_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_agbv_rec IN agbv_rec_type);
155: p_agbv_rec IN agbv_rec_type);
156:
157: PROCEDURE validate_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_agbv_tbl IN agbv_tbl_type);