3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE amhv_rec_type IS RECORD (
7: id NUMBER := OKL_API.G_MISS_NUM
8: ,object_version_number NUMBER := okl_api.G_MISS_NUM
9: ,hold_period_days NUMBER := okl_api.G_MISS_NUM
10: ,category_id NUMBER := okl_api.G_MISS_NUM
11: ,book_type_code OKL_AMORT_HLD_SETUPS_ALL.BOOK_TYPE_CODE%TYPE := okl_api.G_MISS_CHAR
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE amhv_rec_type IS RECORD (
7: id NUMBER := OKL_API.G_MISS_NUM
8: ,object_version_number NUMBER := okl_api.G_MISS_NUM
9: ,hold_period_days NUMBER := okl_api.G_MISS_NUM
10: ,category_id NUMBER := okl_api.G_MISS_NUM
11: ,book_type_code OKL_AMORT_HLD_SETUPS_ALL.BOOK_TYPE_CODE%TYPE := okl_api.G_MISS_CHAR
12: ,method_id NUMBER := okl_api.G_MISS_NUM
5: ---------------------------------------------------------------------------
6: TYPE amhv_rec_type IS RECORD (
7: id NUMBER := OKL_API.G_MISS_NUM
8: ,object_version_number NUMBER := okl_api.G_MISS_NUM
9: ,hold_period_days NUMBER := okl_api.G_MISS_NUM
10: ,category_id NUMBER := okl_api.G_MISS_NUM
11: ,book_type_code OKL_AMORT_HLD_SETUPS_ALL.BOOK_TYPE_CODE%TYPE := okl_api.G_MISS_CHAR
12: ,method_id NUMBER := okl_api.G_MISS_NUM
13: -- SECHAWLA 26-MAY-04 3645574 : addded deprn_rate
6: TYPE amhv_rec_type IS RECORD (
7: id NUMBER := OKL_API.G_MISS_NUM
8: ,object_version_number NUMBER := okl_api.G_MISS_NUM
9: ,hold_period_days NUMBER := okl_api.G_MISS_NUM
10: ,category_id NUMBER := okl_api.G_MISS_NUM
11: ,book_type_code OKL_AMORT_HLD_SETUPS_ALL.BOOK_TYPE_CODE%TYPE := okl_api.G_MISS_CHAR
12: ,method_id NUMBER := okl_api.G_MISS_NUM
13: -- SECHAWLA 26-MAY-04 3645574 : addded deprn_rate
14: ,DEPRN_RATE NUMBER := okl_api.G_MISS_NUM
7: id NUMBER := OKL_API.G_MISS_NUM
8: ,object_version_number NUMBER := okl_api.G_MISS_NUM
9: ,hold_period_days NUMBER := okl_api.G_MISS_NUM
10: ,category_id NUMBER := okl_api.G_MISS_NUM
11: ,book_type_code OKL_AMORT_HLD_SETUPS_ALL.BOOK_TYPE_CODE%TYPE := okl_api.G_MISS_CHAR
12: ,method_id NUMBER := okl_api.G_MISS_NUM
13: -- SECHAWLA 26-MAY-04 3645574 : addded deprn_rate
14: ,DEPRN_RATE NUMBER := okl_api.G_MISS_NUM
15: ,org_id NUMBER := okl_api.G_MISS_NUM
8: ,object_version_number NUMBER := okl_api.G_MISS_NUM
9: ,hold_period_days NUMBER := okl_api.G_MISS_NUM
10: ,category_id NUMBER := okl_api.G_MISS_NUM
11: ,book_type_code OKL_AMORT_HLD_SETUPS_ALL.BOOK_TYPE_CODE%TYPE := okl_api.G_MISS_CHAR
12: ,method_id NUMBER := okl_api.G_MISS_NUM
13: -- SECHAWLA 26-MAY-04 3645574 : addded deprn_rate
14: ,DEPRN_RATE NUMBER := okl_api.G_MISS_NUM
15: ,org_id NUMBER := okl_api.G_MISS_NUM
16: ,created_by NUMBER := okl_api.G_MISS_NUM
10: ,category_id NUMBER := okl_api.G_MISS_NUM
11: ,book_type_code OKL_AMORT_HLD_SETUPS_ALL.BOOK_TYPE_CODE%TYPE := okl_api.G_MISS_CHAR
12: ,method_id NUMBER := okl_api.G_MISS_NUM
13: -- SECHAWLA 26-MAY-04 3645574 : addded deprn_rate
14: ,DEPRN_RATE NUMBER := okl_api.G_MISS_NUM
15: ,org_id NUMBER := okl_api.G_MISS_NUM
16: ,created_by NUMBER := okl_api.G_MISS_NUM
17: ,creation_date OKL_AMORT_HLD_SETUPS_ALL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE
18: ,last_updated_by NUMBER := okl_api.G_MISS_NUM
11: ,book_type_code OKL_AMORT_HLD_SETUPS_ALL.BOOK_TYPE_CODE%TYPE := okl_api.G_MISS_CHAR
12: ,method_id NUMBER := okl_api.G_MISS_NUM
13: -- SECHAWLA 26-MAY-04 3645574 : addded deprn_rate
14: ,DEPRN_RATE NUMBER := okl_api.G_MISS_NUM
15: ,org_id NUMBER := okl_api.G_MISS_NUM
16: ,created_by NUMBER := okl_api.G_MISS_NUM
17: ,creation_date OKL_AMORT_HLD_SETUPS_ALL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE
18: ,last_updated_by NUMBER := okl_api.G_MISS_NUM
19: ,last_update_date OKL_AMORT_HLD_SETUPS_ALL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE
12: ,method_id NUMBER := okl_api.G_MISS_NUM
13: -- SECHAWLA 26-MAY-04 3645574 : addded deprn_rate
14: ,DEPRN_RATE NUMBER := okl_api.G_MISS_NUM
15: ,org_id NUMBER := okl_api.G_MISS_NUM
16: ,created_by NUMBER := okl_api.G_MISS_NUM
17: ,creation_date OKL_AMORT_HLD_SETUPS_ALL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE
18: ,last_updated_by NUMBER := okl_api.G_MISS_NUM
19: ,last_update_date OKL_AMORT_HLD_SETUPS_ALL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE
20: ,last_update_login NUMBER := okl_api.G_MISS_NUM);
13: -- SECHAWLA 26-MAY-04 3645574 : addded deprn_rate
14: ,DEPRN_RATE NUMBER := okl_api.G_MISS_NUM
15: ,org_id NUMBER := okl_api.G_MISS_NUM
16: ,created_by NUMBER := okl_api.G_MISS_NUM
17: ,creation_date OKL_AMORT_HLD_SETUPS_ALL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE
18: ,last_updated_by NUMBER := okl_api.G_MISS_NUM
19: ,last_update_date OKL_AMORT_HLD_SETUPS_ALL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE
20: ,last_update_login NUMBER := okl_api.G_MISS_NUM);
21: G_MISS_amhv_rec amhv_rec_type;
14: ,DEPRN_RATE NUMBER := okl_api.G_MISS_NUM
15: ,org_id NUMBER := okl_api.G_MISS_NUM
16: ,created_by NUMBER := okl_api.G_MISS_NUM
17: ,creation_date OKL_AMORT_HLD_SETUPS_ALL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE
18: ,last_updated_by NUMBER := okl_api.G_MISS_NUM
19: ,last_update_date OKL_AMORT_HLD_SETUPS_ALL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE
20: ,last_update_login NUMBER := okl_api.G_MISS_NUM);
21: G_MISS_amhv_rec amhv_rec_type;
22: TYPE amhv_tbl_type IS TABLE OF amhv_rec_type
15: ,org_id NUMBER := okl_api.G_MISS_NUM
16: ,created_by NUMBER := okl_api.G_MISS_NUM
17: ,creation_date OKL_AMORT_HLD_SETUPS_ALL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE
18: ,last_updated_by NUMBER := okl_api.G_MISS_NUM
19: ,last_update_date OKL_AMORT_HLD_SETUPS_ALL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE
20: ,last_update_login NUMBER := okl_api.G_MISS_NUM);
21: G_MISS_amhv_rec amhv_rec_type;
22: TYPE amhv_tbl_type IS TABLE OF amhv_rec_type
23: INDEX BY BINARY_INTEGER;
16: ,created_by NUMBER := okl_api.G_MISS_NUM
17: ,creation_date OKL_AMORT_HLD_SETUPS_ALL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE
18: ,last_updated_by NUMBER := okl_api.G_MISS_NUM
19: ,last_update_date OKL_AMORT_HLD_SETUPS_ALL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE
20: ,last_update_login NUMBER := okl_api.G_MISS_NUM);
21: G_MISS_amhv_rec amhv_rec_type;
22: TYPE amhv_tbl_type IS TABLE OF amhv_rec_type
23: INDEX BY BINARY_INTEGER;
24: TYPE amh_rec_type IS RECORD (
21: G_MISS_amhv_rec amhv_rec_type;
22: TYPE amhv_tbl_type IS TABLE OF amhv_rec_type
23: INDEX BY BINARY_INTEGER;
24: TYPE amh_rec_type IS RECORD (
25: id NUMBER := okl_api.G_MISS_NUM
26: ,object_version_number NUMBER := okl_api.G_MISS_NUM
27: ,hold_period_days NUMBER := okl_api.G_MISS_NUM
28: ,category_id NUMBER := okl_api.G_MISS_NUM
29: ,book_type_code OKL_AMORT_HOLD_SETUPS.BOOK_TYPE_CODE%TYPE := okl_api.G_MISS_CHAR
22: TYPE amhv_tbl_type IS TABLE OF amhv_rec_type
23: INDEX BY BINARY_INTEGER;
24: TYPE amh_rec_type IS RECORD (
25: id NUMBER := okl_api.G_MISS_NUM
26: ,object_version_number NUMBER := okl_api.G_MISS_NUM
27: ,hold_period_days NUMBER := okl_api.G_MISS_NUM
28: ,category_id NUMBER := okl_api.G_MISS_NUM
29: ,book_type_code OKL_AMORT_HOLD_SETUPS.BOOK_TYPE_CODE%TYPE := okl_api.G_MISS_CHAR
30: ,method_id NUMBER := okl_api.G_MISS_NUM
23: INDEX BY BINARY_INTEGER;
24: TYPE amh_rec_type IS RECORD (
25: id NUMBER := okl_api.G_MISS_NUM
26: ,object_version_number NUMBER := okl_api.G_MISS_NUM
27: ,hold_period_days NUMBER := okl_api.G_MISS_NUM
28: ,category_id NUMBER := okl_api.G_MISS_NUM
29: ,book_type_code OKL_AMORT_HOLD_SETUPS.BOOK_TYPE_CODE%TYPE := okl_api.G_MISS_CHAR
30: ,method_id NUMBER := okl_api.G_MISS_NUM
31: -- SECHAWLA 26-MAY-04 3645574 : addded deprn_rate
24: TYPE amh_rec_type IS RECORD (
25: id NUMBER := okl_api.G_MISS_NUM
26: ,object_version_number NUMBER := okl_api.G_MISS_NUM
27: ,hold_period_days NUMBER := okl_api.G_MISS_NUM
28: ,category_id NUMBER := okl_api.G_MISS_NUM
29: ,book_type_code OKL_AMORT_HOLD_SETUPS.BOOK_TYPE_CODE%TYPE := okl_api.G_MISS_CHAR
30: ,method_id NUMBER := okl_api.G_MISS_NUM
31: -- SECHAWLA 26-MAY-04 3645574 : addded deprn_rate
32: ,deprn_rate NUMBER := okl_api.G_MISS_NUM
25: id NUMBER := okl_api.G_MISS_NUM
26: ,object_version_number NUMBER := okl_api.G_MISS_NUM
27: ,hold_period_days NUMBER := okl_api.G_MISS_NUM
28: ,category_id NUMBER := okl_api.G_MISS_NUM
29: ,book_type_code OKL_AMORT_HOLD_SETUPS.BOOK_TYPE_CODE%TYPE := okl_api.G_MISS_CHAR
30: ,method_id NUMBER := okl_api.G_MISS_NUM
31: -- SECHAWLA 26-MAY-04 3645574 : addded deprn_rate
32: ,deprn_rate NUMBER := okl_api.G_MISS_NUM
33: ,org_id NUMBER := okl_api.G_MISS_NUM
26: ,object_version_number NUMBER := okl_api.G_MISS_NUM
27: ,hold_period_days NUMBER := okl_api.G_MISS_NUM
28: ,category_id NUMBER := okl_api.G_MISS_NUM
29: ,book_type_code OKL_AMORT_HOLD_SETUPS.BOOK_TYPE_CODE%TYPE := okl_api.G_MISS_CHAR
30: ,method_id NUMBER := okl_api.G_MISS_NUM
31: -- SECHAWLA 26-MAY-04 3645574 : addded deprn_rate
32: ,deprn_rate NUMBER := okl_api.G_MISS_NUM
33: ,org_id NUMBER := okl_api.G_MISS_NUM
34: ,created_by NUMBER := okl_api.G_MISS_NUM
28: ,category_id NUMBER := okl_api.G_MISS_NUM
29: ,book_type_code OKL_AMORT_HOLD_SETUPS.BOOK_TYPE_CODE%TYPE := okl_api.G_MISS_CHAR
30: ,method_id NUMBER := okl_api.G_MISS_NUM
31: -- SECHAWLA 26-MAY-04 3645574 : addded deprn_rate
32: ,deprn_rate NUMBER := okl_api.G_MISS_NUM
33: ,org_id NUMBER := okl_api.G_MISS_NUM
34: ,created_by NUMBER := okl_api.G_MISS_NUM
35: ,creation_date OKL_AMORT_HOLD_SETUPS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE
36: ,last_updated_by NUMBER := okl_api.G_MISS_NUM
29: ,book_type_code OKL_AMORT_HOLD_SETUPS.BOOK_TYPE_CODE%TYPE := okl_api.G_MISS_CHAR
30: ,method_id NUMBER := okl_api.G_MISS_NUM
31: -- SECHAWLA 26-MAY-04 3645574 : addded deprn_rate
32: ,deprn_rate NUMBER := okl_api.G_MISS_NUM
33: ,org_id NUMBER := okl_api.G_MISS_NUM
34: ,created_by NUMBER := okl_api.G_MISS_NUM
35: ,creation_date OKL_AMORT_HOLD_SETUPS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE
36: ,last_updated_by NUMBER := okl_api.G_MISS_NUM
37: ,last_update_date OKL_AMORT_HOLD_SETUPS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE
30: ,method_id NUMBER := okl_api.G_MISS_NUM
31: -- SECHAWLA 26-MAY-04 3645574 : addded deprn_rate
32: ,deprn_rate NUMBER := okl_api.G_MISS_NUM
33: ,org_id NUMBER := okl_api.G_MISS_NUM
34: ,created_by NUMBER := okl_api.G_MISS_NUM
35: ,creation_date OKL_AMORT_HOLD_SETUPS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE
36: ,last_updated_by NUMBER := okl_api.G_MISS_NUM
37: ,last_update_date OKL_AMORT_HOLD_SETUPS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE
38: ,last_update_login NUMBER := okl_api.G_MISS_NUM);
31: -- SECHAWLA 26-MAY-04 3645574 : addded deprn_rate
32: ,deprn_rate NUMBER := okl_api.G_MISS_NUM
33: ,org_id NUMBER := okl_api.G_MISS_NUM
34: ,created_by NUMBER := okl_api.G_MISS_NUM
35: ,creation_date OKL_AMORT_HOLD_SETUPS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE
36: ,last_updated_by NUMBER := okl_api.G_MISS_NUM
37: ,last_update_date OKL_AMORT_HOLD_SETUPS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE
38: ,last_update_login NUMBER := okl_api.G_MISS_NUM);
39: G_MISS_amh_rec amh_rec_type;
32: ,deprn_rate NUMBER := okl_api.G_MISS_NUM
33: ,org_id NUMBER := okl_api.G_MISS_NUM
34: ,created_by NUMBER := okl_api.G_MISS_NUM
35: ,creation_date OKL_AMORT_HOLD_SETUPS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE
36: ,last_updated_by NUMBER := okl_api.G_MISS_NUM
37: ,last_update_date OKL_AMORT_HOLD_SETUPS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE
38: ,last_update_login NUMBER := okl_api.G_MISS_NUM);
39: G_MISS_amh_rec amh_rec_type;
40: TYPE amh_tbl_type IS TABLE OF amh_rec_type
33: ,org_id NUMBER := okl_api.G_MISS_NUM
34: ,created_by NUMBER := okl_api.G_MISS_NUM
35: ,creation_date OKL_AMORT_HOLD_SETUPS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE
36: ,last_updated_by NUMBER := okl_api.G_MISS_NUM
37: ,last_update_date OKL_AMORT_HOLD_SETUPS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE
38: ,last_update_login NUMBER := okl_api.G_MISS_NUM);
39: G_MISS_amh_rec amh_rec_type;
40: TYPE amh_tbl_type IS TABLE OF amh_rec_type
41: INDEX BY BINARY_INTEGER;
34: ,created_by NUMBER := okl_api.G_MISS_NUM
35: ,creation_date OKL_AMORT_HOLD_SETUPS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE
36: ,last_updated_by NUMBER := okl_api.G_MISS_NUM
37: ,last_update_date OKL_AMORT_HOLD_SETUPS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE
38: ,last_update_login NUMBER := okl_api.G_MISS_NUM);
39: G_MISS_amh_rec amh_rec_type;
40: TYPE amh_tbl_type IS TABLE OF amh_rec_type
41: INDEX BY BINARY_INTEGER;
42: ---------------------------------------------------------------------------
74: PROCEDURE change_version;
75: PROCEDURE api_copy;
76: PROCEDURE insert_row(
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
79: x_return_status OUT NOCOPY VARCHAR2,
80: x_msg_count OUT NOCOPY NUMBER,
81: x_msg_data OUT NOCOPY VARCHAR2,
82: p_amhv_rec IN amhv_rec_type,
82: p_amhv_rec IN amhv_rec_type,
83: x_amhv_rec OUT NOCOPY amhv_rec_type);
84: PROCEDURE insert_row(
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
87: x_return_status OUT NOCOPY VARCHAR2,
88: x_msg_count OUT NOCOPY NUMBER,
89: x_msg_data OUT NOCOPY VARCHAR2,
90: p_amhv_tbl IN amhv_tbl_type,
88: x_msg_count OUT NOCOPY NUMBER,
89: x_msg_data OUT NOCOPY VARCHAR2,
90: p_amhv_tbl IN amhv_tbl_type,
91: x_amhv_tbl OUT NOCOPY amhv_tbl_type,
92: px_error_tbl IN OUT NOCOPY okl_api.ERROR_TBL_TYPE);
93: PROCEDURE insert_row(
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
96: x_return_status OUT NOCOPY VARCHAR2,
91: x_amhv_tbl OUT NOCOPY amhv_tbl_type,
92: px_error_tbl IN OUT NOCOPY okl_api.ERROR_TBL_TYPE);
93: PROCEDURE insert_row(
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 DEFAULT okl_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_amhv_tbl IN amhv_tbl_type,
99: p_amhv_tbl IN amhv_tbl_type,
100: x_amhv_tbl OUT NOCOPY amhv_tbl_type);
101: PROCEDURE lock_row(
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_amhv_rec IN amhv_rec_type);
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_amhv_rec IN amhv_rec_type);
108: PROCEDURE lock_row(
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
113: x_msg_data OUT NOCOPY VARCHAR2,
114: p_amhv_tbl IN amhv_tbl_type,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
113: x_msg_data OUT NOCOPY VARCHAR2,
114: p_amhv_tbl IN amhv_tbl_type,
115: px_error_tbl IN OUT NOCOPY okl_api.ERROR_TBL_TYPE);
116: PROCEDURE lock_row(
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
119: x_return_status OUT NOCOPY VARCHAR2,
114: p_amhv_tbl IN amhv_tbl_type,
115: px_error_tbl IN OUT NOCOPY okl_api.ERROR_TBL_TYPE);
116: PROCEDURE lock_row(
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
121: x_msg_data OUT NOCOPY VARCHAR2,
122: p_amhv_tbl IN amhv_tbl_type);
121: x_msg_data OUT NOCOPY VARCHAR2,
122: p_amhv_tbl IN amhv_tbl_type);
123: PROCEDURE update_row(
124: p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 DEFAULT okl_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_amhv_rec IN amhv_rec_type,
129: p_amhv_rec IN amhv_rec_type,
130: x_amhv_rec OUT NOCOPY amhv_rec_type);
131: PROCEDURE update_row(
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 DEFAULT okl_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_amhv_tbl IN amhv_tbl_type,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_amhv_tbl IN amhv_tbl_type,
138: x_amhv_tbl OUT NOCOPY amhv_tbl_type,
139: px_error_tbl IN OUT NOCOPY okl_api.ERROR_TBL_TYPE);
140: PROCEDURE update_row(
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
143: x_return_status OUT NOCOPY VARCHAR2,
138: x_amhv_tbl OUT NOCOPY amhv_tbl_type,
139: px_error_tbl IN OUT NOCOPY okl_api.ERROR_TBL_TYPE);
140: PROCEDURE update_row(
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2,
146: p_amhv_tbl IN amhv_tbl_type,
146: p_amhv_tbl IN amhv_tbl_type,
147: x_amhv_tbl OUT NOCOPY amhv_tbl_type);
148: PROCEDURE delete_row(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_amhv_rec IN amhv_rec_type);
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_amhv_rec IN amhv_rec_type);
155: PROCEDURE delete_row(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_amhv_tbl IN amhv_tbl_type,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_amhv_tbl IN amhv_tbl_type,
162: px_error_tbl IN OUT NOCOPY okl_api.ERROR_TBL_TYPE);
163: PROCEDURE delete_row(
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
166: x_return_status OUT NOCOPY VARCHAR2,
161: p_amhv_tbl IN amhv_tbl_type,
162: px_error_tbl IN OUT NOCOPY okl_api.ERROR_TBL_TYPE);
163: PROCEDURE delete_row(
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_amhv_tbl IN amhv_tbl_type);
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_amhv_tbl IN amhv_tbl_type);
170: PROCEDURE validate_row(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_amhv_rec IN amhv_rec_type);
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_amhv_rec IN amhv_rec_type);
177: PROCEDURE validate_row(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_amhv_tbl IN amhv_tbl_type,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_amhv_tbl IN amhv_tbl_type,
184: px_error_tbl IN OUT NOCOPY okl_api.ERROR_TBL_TYPE);
185: PROCEDURE validate_row(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
188: x_return_status OUT NOCOPY VARCHAR2,
183: p_amhv_tbl IN amhv_tbl_type,
184: px_error_tbl IN OUT NOCOPY okl_api.ERROR_TBL_TYPE);
185: PROCEDURE validate_row(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_amhv_tbl IN amhv_tbl_type);