eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_REP_PVT dependencies on OKC_API

Line 8: id NUMBER := OKC_API.G_MISS_NUM

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_REPROCESSING_V Record Spec
7: TYPE repv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,order_id NUMBER := OKC_API.G_MISS_NUM
10: ,order_line_id NUMBER := OKC_API.G_MISS_NUM
11: ,contract_id NUMBER := OKC_API.G_MISS_NUM
12: ,contract_line_id NUMBER := OKC_API.G_MISS_NUM

Line 9: ,order_id NUMBER := OKC_API.G_MISS_NUM

5: ---------------------------------------------------------------------------
6: -- OKS_REPROCESSING_V Record Spec
7: TYPE repv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,order_id NUMBER := OKC_API.G_MISS_NUM
10: ,order_line_id NUMBER := OKC_API.G_MISS_NUM
11: ,contract_id NUMBER := OKC_API.G_MISS_NUM
12: ,contract_line_id NUMBER := OKC_API.G_MISS_NUM
13: ,subline_id NUMBER := OKC_API.G_MISS_NUM

Line 10: ,order_line_id NUMBER := OKC_API.G_MISS_NUM

6: -- OKS_REPROCESSING_V Record Spec
7: TYPE repv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,order_id NUMBER := OKC_API.G_MISS_NUM
10: ,order_line_id NUMBER := OKC_API.G_MISS_NUM
11: ,contract_id NUMBER := OKC_API.G_MISS_NUM
12: ,contract_line_id NUMBER := OKC_API.G_MISS_NUM
13: ,subline_id NUMBER := OKC_API.G_MISS_NUM
14: ,error_text OKS_REPROCESSING_V.ERROR_TEXT%TYPE := OKC_API.G_MISS_CHAR

Line 11: ,contract_id NUMBER := OKC_API.G_MISS_NUM

7: TYPE repv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,order_id NUMBER := OKC_API.G_MISS_NUM
10: ,order_line_id NUMBER := OKC_API.G_MISS_NUM
11: ,contract_id NUMBER := OKC_API.G_MISS_NUM
12: ,contract_line_id NUMBER := OKC_API.G_MISS_NUM
13: ,subline_id NUMBER := OKC_API.G_MISS_NUM
14: ,error_text OKS_REPROCESSING_V.ERROR_TEXT%TYPE := OKC_API.G_MISS_CHAR
15: ,success_flag OKS_REPROCESSING_V.SUCCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 12: ,contract_line_id NUMBER := OKC_API.G_MISS_NUM

8: id NUMBER := OKC_API.G_MISS_NUM
9: ,order_id NUMBER := OKC_API.G_MISS_NUM
10: ,order_line_id NUMBER := OKC_API.G_MISS_NUM
11: ,contract_id NUMBER := OKC_API.G_MISS_NUM
12: ,contract_line_id NUMBER := OKC_API.G_MISS_NUM
13: ,subline_id NUMBER := OKC_API.G_MISS_NUM
14: ,error_text OKS_REPROCESSING_V.ERROR_TEXT%TYPE := OKC_API.G_MISS_CHAR
15: ,success_flag OKS_REPROCESSING_V.SUCCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,source_flag OKS_REPROCESSING_V.SOURCE_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 13: ,subline_id NUMBER := OKC_API.G_MISS_NUM

9: ,order_id NUMBER := OKC_API.G_MISS_NUM
10: ,order_line_id NUMBER := OKC_API.G_MISS_NUM
11: ,contract_id NUMBER := OKC_API.G_MISS_NUM
12: ,contract_line_id NUMBER := OKC_API.G_MISS_NUM
13: ,subline_id NUMBER := OKC_API.G_MISS_NUM
14: ,error_text OKS_REPROCESSING_V.ERROR_TEXT%TYPE := OKC_API.G_MISS_CHAR
15: ,success_flag OKS_REPROCESSING_V.SUCCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,source_flag OKS_REPROCESSING_V.SOURCE_FLAG%TYPE := OKC_API.G_MISS_CHAR
17: ,conc_request_id NUMBER := OKC_API.G_MISS_NUM

Line 14: ,error_text OKS_REPROCESSING_V.ERROR_TEXT%TYPE := OKC_API.G_MISS_CHAR

10: ,order_line_id NUMBER := OKC_API.G_MISS_NUM
11: ,contract_id NUMBER := OKC_API.G_MISS_NUM
12: ,contract_line_id NUMBER := OKC_API.G_MISS_NUM
13: ,subline_id NUMBER := OKC_API.G_MISS_NUM
14: ,error_text OKS_REPROCESSING_V.ERROR_TEXT%TYPE := OKC_API.G_MISS_CHAR
15: ,success_flag OKS_REPROCESSING_V.SUCCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,source_flag OKS_REPROCESSING_V.SOURCE_FLAG%TYPE := OKC_API.G_MISS_CHAR
17: ,conc_request_id NUMBER := OKC_API.G_MISS_NUM
18: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 15: ,success_flag OKS_REPROCESSING_V.SUCCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR

11: ,contract_id NUMBER := OKC_API.G_MISS_NUM
12: ,contract_line_id NUMBER := OKC_API.G_MISS_NUM
13: ,subline_id NUMBER := OKC_API.G_MISS_NUM
14: ,error_text OKS_REPROCESSING_V.ERROR_TEXT%TYPE := OKC_API.G_MISS_CHAR
15: ,success_flag OKS_REPROCESSING_V.SUCCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,source_flag OKS_REPROCESSING_V.SOURCE_FLAG%TYPE := OKC_API.G_MISS_CHAR
17: ,conc_request_id NUMBER := OKC_API.G_MISS_NUM
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_REPROCESSING_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 16: ,source_flag OKS_REPROCESSING_V.SOURCE_FLAG%TYPE := OKC_API.G_MISS_CHAR

12: ,contract_line_id NUMBER := OKC_API.G_MISS_NUM
13: ,subline_id NUMBER := OKC_API.G_MISS_NUM
14: ,error_text OKS_REPROCESSING_V.ERROR_TEXT%TYPE := OKC_API.G_MISS_CHAR
15: ,success_flag OKS_REPROCESSING_V.SUCCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,source_flag OKS_REPROCESSING_V.SOURCE_FLAG%TYPE := OKC_API.G_MISS_CHAR
17: ,conc_request_id NUMBER := OKC_API.G_MISS_NUM
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_REPROCESSING_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 17: ,conc_request_id NUMBER := OKC_API.G_MISS_NUM

13: ,subline_id NUMBER := OKC_API.G_MISS_NUM
14: ,error_text OKS_REPROCESSING_V.ERROR_TEXT%TYPE := OKC_API.G_MISS_CHAR
15: ,success_flag OKS_REPROCESSING_V.SUCCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,source_flag OKS_REPROCESSING_V.SOURCE_FLAG%TYPE := OKC_API.G_MISS_CHAR
17: ,conc_request_id NUMBER := OKC_API.G_MISS_NUM
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_REPROCESSING_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_REPROCESSING_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 18: ,created_by NUMBER := OKC_API.G_MISS_NUM

14: ,error_text OKS_REPROCESSING_V.ERROR_TEXT%TYPE := OKC_API.G_MISS_CHAR
15: ,success_flag OKS_REPROCESSING_V.SUCCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,source_flag OKS_REPROCESSING_V.SOURCE_FLAG%TYPE := OKC_API.G_MISS_CHAR
17: ,conc_request_id NUMBER := OKC_API.G_MISS_NUM
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_REPROCESSING_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_REPROCESSING_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 19: ,creation_date OKS_REPROCESSING_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

15: ,success_flag OKS_REPROCESSING_V.SUCCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,source_flag OKS_REPROCESSING_V.SOURCE_FLAG%TYPE := OKC_API.G_MISS_CHAR
17: ,conc_request_id NUMBER := OKC_API.G_MISS_NUM
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_REPROCESSING_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_REPROCESSING_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

16: ,source_flag OKS_REPROCESSING_V.SOURCE_FLAG%TYPE := OKC_API.G_MISS_CHAR
17: ,conc_request_id NUMBER := OKC_API.G_MISS_NUM
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_REPROCESSING_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_REPROCESSING_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
24: ,security_group_id NUMBER := OKC_API.G_MISS_NUM

Line 21: ,last_update_date OKS_REPROCESSING_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

17: ,conc_request_id NUMBER := OKC_API.G_MISS_NUM
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_REPROCESSING_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_REPROCESSING_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
24: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
25: ,reprocess_yn OKS_REPROCESSING_V.REPROCESS_YN%TYPE := OKC_API.G_MISS_CHAR

Line 22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_REPROCESSING_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_REPROCESSING_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
24: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
25: ,reprocess_yn OKS_REPROCESSING_V.REPROCESS_YN%TYPE := OKC_API.G_MISS_CHAR
26: ,order_number NUMBER := OKC_API.G_MISS_NUM);

Line 23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

19: ,creation_date OKS_REPROCESSING_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_REPROCESSING_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
24: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
25: ,reprocess_yn OKS_REPROCESSING_V.REPROCESS_YN%TYPE := OKC_API.G_MISS_CHAR
26: ,order_number NUMBER := OKC_API.G_MISS_NUM);
27: G_MISS_repv_rec repv_rec_type;

Line 24: ,security_group_id NUMBER := OKC_API.G_MISS_NUM

20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_REPROCESSING_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
24: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
25: ,reprocess_yn OKS_REPROCESSING_V.REPROCESS_YN%TYPE := OKC_API.G_MISS_CHAR
26: ,order_number NUMBER := OKC_API.G_MISS_NUM);
27: G_MISS_repv_rec repv_rec_type;
28: TYPE repv_tbl_type IS TABLE OF repv_rec_type

Line 25: ,reprocess_yn OKS_REPROCESSING_V.REPROCESS_YN%TYPE := OKC_API.G_MISS_CHAR

21: ,last_update_date OKS_REPROCESSING_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
24: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
25: ,reprocess_yn OKS_REPROCESSING_V.REPROCESS_YN%TYPE := OKC_API.G_MISS_CHAR
26: ,order_number NUMBER := OKC_API.G_MISS_NUM);
27: G_MISS_repv_rec repv_rec_type;
28: TYPE repv_tbl_type IS TABLE OF repv_rec_type
29: INDEX BY BINARY_INTEGER;

Line 26: ,order_number NUMBER := OKC_API.G_MISS_NUM);

22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
24: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
25: ,reprocess_yn OKS_REPROCESSING_V.REPROCESS_YN%TYPE := OKC_API.G_MISS_CHAR
26: ,order_number NUMBER := OKC_API.G_MISS_NUM);
27: G_MISS_repv_rec repv_rec_type;
28: TYPE repv_tbl_type IS TABLE OF repv_rec_type
29: INDEX BY BINARY_INTEGER;
30: -- OKS_REPROCESSING Record Spec

Line 32: id NUMBER := OKC_API.G_MISS_NUM

28: TYPE repv_tbl_type IS TABLE OF repv_rec_type
29: INDEX BY BINARY_INTEGER;
30: -- OKS_REPROCESSING Record Spec
31: TYPE rep_rec_type IS RECORD (
32: id NUMBER := OKC_API.G_MISS_NUM
33: ,order_id NUMBER := OKC_API.G_MISS_NUM
34: ,order_line_id NUMBER := OKC_API.G_MISS_NUM
35: ,contract_id NUMBER := OKC_API.G_MISS_NUM
36: ,contract_line_id NUMBER := OKC_API.G_MISS_NUM

Line 33: ,order_id NUMBER := OKC_API.G_MISS_NUM

29: INDEX BY BINARY_INTEGER;
30: -- OKS_REPROCESSING Record Spec
31: TYPE rep_rec_type IS RECORD (
32: id NUMBER := OKC_API.G_MISS_NUM
33: ,order_id NUMBER := OKC_API.G_MISS_NUM
34: ,order_line_id NUMBER := OKC_API.G_MISS_NUM
35: ,contract_id NUMBER := OKC_API.G_MISS_NUM
36: ,contract_line_id NUMBER := OKC_API.G_MISS_NUM
37: ,subline_id NUMBER := OKC_API.G_MISS_NUM

Line 34: ,order_line_id NUMBER := OKC_API.G_MISS_NUM

30: -- OKS_REPROCESSING Record Spec
31: TYPE rep_rec_type IS RECORD (
32: id NUMBER := OKC_API.G_MISS_NUM
33: ,order_id NUMBER := OKC_API.G_MISS_NUM
34: ,order_line_id NUMBER := OKC_API.G_MISS_NUM
35: ,contract_id NUMBER := OKC_API.G_MISS_NUM
36: ,contract_line_id NUMBER := OKC_API.G_MISS_NUM
37: ,subline_id NUMBER := OKC_API.G_MISS_NUM
38: ,error_text OKS_REPROCESSING.ERROR_TEXT%TYPE := OKC_API.G_MISS_CHAR

Line 35: ,contract_id NUMBER := OKC_API.G_MISS_NUM

31: TYPE rep_rec_type IS RECORD (
32: id NUMBER := OKC_API.G_MISS_NUM
33: ,order_id NUMBER := OKC_API.G_MISS_NUM
34: ,order_line_id NUMBER := OKC_API.G_MISS_NUM
35: ,contract_id NUMBER := OKC_API.G_MISS_NUM
36: ,contract_line_id NUMBER := OKC_API.G_MISS_NUM
37: ,subline_id NUMBER := OKC_API.G_MISS_NUM
38: ,error_text OKS_REPROCESSING.ERROR_TEXT%TYPE := OKC_API.G_MISS_CHAR
39: ,success_flag OKS_REPROCESSING.SUCCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 36: ,contract_line_id NUMBER := OKC_API.G_MISS_NUM

32: id NUMBER := OKC_API.G_MISS_NUM
33: ,order_id NUMBER := OKC_API.G_MISS_NUM
34: ,order_line_id NUMBER := OKC_API.G_MISS_NUM
35: ,contract_id NUMBER := OKC_API.G_MISS_NUM
36: ,contract_line_id NUMBER := OKC_API.G_MISS_NUM
37: ,subline_id NUMBER := OKC_API.G_MISS_NUM
38: ,error_text OKS_REPROCESSING.ERROR_TEXT%TYPE := OKC_API.G_MISS_CHAR
39: ,success_flag OKS_REPROCESSING.SUCCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
40: ,source_flag OKS_REPROCESSING.SOURCE_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 37: ,subline_id NUMBER := OKC_API.G_MISS_NUM

33: ,order_id NUMBER := OKC_API.G_MISS_NUM
34: ,order_line_id NUMBER := OKC_API.G_MISS_NUM
35: ,contract_id NUMBER := OKC_API.G_MISS_NUM
36: ,contract_line_id NUMBER := OKC_API.G_MISS_NUM
37: ,subline_id NUMBER := OKC_API.G_MISS_NUM
38: ,error_text OKS_REPROCESSING.ERROR_TEXT%TYPE := OKC_API.G_MISS_CHAR
39: ,success_flag OKS_REPROCESSING.SUCCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
40: ,source_flag OKS_REPROCESSING.SOURCE_FLAG%TYPE := OKC_API.G_MISS_CHAR
41: ,conc_request_id NUMBER := OKC_API.G_MISS_NUM

Line 38: ,error_text OKS_REPROCESSING.ERROR_TEXT%TYPE := OKC_API.G_MISS_CHAR

34: ,order_line_id NUMBER := OKC_API.G_MISS_NUM
35: ,contract_id NUMBER := OKC_API.G_MISS_NUM
36: ,contract_line_id NUMBER := OKC_API.G_MISS_NUM
37: ,subline_id NUMBER := OKC_API.G_MISS_NUM
38: ,error_text OKS_REPROCESSING.ERROR_TEXT%TYPE := OKC_API.G_MISS_CHAR
39: ,success_flag OKS_REPROCESSING.SUCCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
40: ,source_flag OKS_REPROCESSING.SOURCE_FLAG%TYPE := OKC_API.G_MISS_CHAR
41: ,conc_request_id NUMBER := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 39: ,success_flag OKS_REPROCESSING.SUCCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR

35: ,contract_id NUMBER := OKC_API.G_MISS_NUM
36: ,contract_line_id NUMBER := OKC_API.G_MISS_NUM
37: ,subline_id NUMBER := OKC_API.G_MISS_NUM
38: ,error_text OKS_REPROCESSING.ERROR_TEXT%TYPE := OKC_API.G_MISS_CHAR
39: ,success_flag OKS_REPROCESSING.SUCCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
40: ,source_flag OKS_REPROCESSING.SOURCE_FLAG%TYPE := OKC_API.G_MISS_CHAR
41: ,conc_request_id NUMBER := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKS_REPROCESSING.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 40: ,source_flag OKS_REPROCESSING.SOURCE_FLAG%TYPE := OKC_API.G_MISS_CHAR

36: ,contract_line_id NUMBER := OKC_API.G_MISS_NUM
37: ,subline_id NUMBER := OKC_API.G_MISS_NUM
38: ,error_text OKS_REPROCESSING.ERROR_TEXT%TYPE := OKC_API.G_MISS_CHAR
39: ,success_flag OKS_REPROCESSING.SUCCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
40: ,source_flag OKS_REPROCESSING.SOURCE_FLAG%TYPE := OKC_API.G_MISS_CHAR
41: ,conc_request_id NUMBER := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKS_REPROCESSING.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 41: ,conc_request_id NUMBER := OKC_API.G_MISS_NUM

37: ,subline_id NUMBER := OKC_API.G_MISS_NUM
38: ,error_text OKS_REPROCESSING.ERROR_TEXT%TYPE := OKC_API.G_MISS_CHAR
39: ,success_flag OKS_REPROCESSING.SUCCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
40: ,source_flag OKS_REPROCESSING.SOURCE_FLAG%TYPE := OKC_API.G_MISS_CHAR
41: ,conc_request_id NUMBER := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKS_REPROCESSING.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKS_REPROCESSING.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 42: ,created_by NUMBER := OKC_API.G_MISS_NUM

38: ,error_text OKS_REPROCESSING.ERROR_TEXT%TYPE := OKC_API.G_MISS_CHAR
39: ,success_flag OKS_REPROCESSING.SUCCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
40: ,source_flag OKS_REPROCESSING.SOURCE_FLAG%TYPE := OKC_API.G_MISS_CHAR
41: ,conc_request_id NUMBER := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKS_REPROCESSING.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKS_REPROCESSING.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 43: ,creation_date OKS_REPROCESSING.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

39: ,success_flag OKS_REPROCESSING.SUCCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
40: ,source_flag OKS_REPROCESSING.SOURCE_FLAG%TYPE := OKC_API.G_MISS_CHAR
41: ,conc_request_id NUMBER := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKS_REPROCESSING.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKS_REPROCESSING.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

40: ,source_flag OKS_REPROCESSING.SOURCE_FLAG%TYPE := OKC_API.G_MISS_CHAR
41: ,conc_request_id NUMBER := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKS_REPROCESSING.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKS_REPROCESSING.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: ,reprocess_yn OKS_REPROCESSING.REPROCESS_YN%TYPE := OKC_API.G_MISS_CHAR

Line 45: ,last_update_date OKS_REPROCESSING.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

41: ,conc_request_id NUMBER := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKS_REPROCESSING.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKS_REPROCESSING.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: ,reprocess_yn OKS_REPROCESSING.REPROCESS_YN%TYPE := OKC_API.G_MISS_CHAR
49: ,order_number NUMBER := OKC_API.G_MISS_NUM);

Line 46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKS_REPROCESSING.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKS_REPROCESSING.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: ,reprocess_yn OKS_REPROCESSING.REPROCESS_YN%TYPE := OKC_API.G_MISS_CHAR
49: ,order_number NUMBER := OKC_API.G_MISS_NUM);
50: G_MISS_rep_rec rep_rec_type;

Line 47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

43: ,creation_date OKS_REPROCESSING.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKS_REPROCESSING.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: ,reprocess_yn OKS_REPROCESSING.REPROCESS_YN%TYPE := OKC_API.G_MISS_CHAR
49: ,order_number NUMBER := OKC_API.G_MISS_NUM);
50: G_MISS_rep_rec rep_rec_type;
51: TYPE rep_tbl_type IS TABLE OF rep_rec_type

Line 48: ,reprocess_yn OKS_REPROCESSING.REPROCESS_YN%TYPE := OKC_API.G_MISS_CHAR

44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKS_REPROCESSING.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: ,reprocess_yn OKS_REPROCESSING.REPROCESS_YN%TYPE := OKC_API.G_MISS_CHAR
49: ,order_number NUMBER := OKC_API.G_MISS_NUM);
50: G_MISS_rep_rec rep_rec_type;
51: TYPE rep_tbl_type IS TABLE OF rep_rec_type
52: INDEX BY BINARY_INTEGER;

Line 49: ,order_number NUMBER := OKC_API.G_MISS_NUM);

45: ,last_update_date OKS_REPROCESSING.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: ,reprocess_yn OKS_REPROCESSING.REPROCESS_YN%TYPE := OKC_API.G_MISS_CHAR
49: ,order_number NUMBER := OKC_API.G_MISS_NUM);
50: G_MISS_rep_rec rep_rec_type;
51: TYPE rep_tbl_type IS TABLE OF rep_rec_type
52: INDEX BY BINARY_INTEGER;
53: ---------------------------------------------------------------------------

Line 56: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

52: INDEX BY BINARY_INTEGER;
53: ---------------------------------------------------------------------------
54: -- GLOBAL MESSAGE CONSTANTS
55: ---------------------------------------------------------------------------
56: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
57: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
58: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
59: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
60: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line 57: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

53: ---------------------------------------------------------------------------
54: -- GLOBAL MESSAGE CONSTANTS
55: ---------------------------------------------------------------------------
56: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
57: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
58: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
59: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
60: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
61: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

Line 58: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

54: -- GLOBAL MESSAGE CONSTANTS
55: ---------------------------------------------------------------------------
56: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
57: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
58: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
59: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
60: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
61: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
62: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

Line 59: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

55: ---------------------------------------------------------------------------
56: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
57: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
58: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
59: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
60: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
61: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
62: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
63: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

Line 60: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

56: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
57: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
58: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
59: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
60: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
61: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
62: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
63: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
64: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

Line 61: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

57: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
58: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
59: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
60: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
61: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
62: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
63: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
64: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
65: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 62: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

58: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
59: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
60: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
61: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
62: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
63: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
64: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
65: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
66: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';

Line 63: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

59: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
60: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
61: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
62: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
63: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
64: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
65: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
66: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
67: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 64: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

60: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
61: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
62: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
63: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
64: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
65: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
66: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
67: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
68: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 65: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

61: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
62: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
63: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
64: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
65: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
66: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
67: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
68: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
69:

Line 79: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

75: ---------------------------------------------------------------------------
76: -- GLOBAL VARIABLES
77: ---------------------------------------------------------------------------
78: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_REP_PVT';
79: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
80: ---------------------------------------------------------------------------
81: -- Procedures and Functions
82: ---------------------------------------------------------------------------
83:

Line 103: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2,
101: p_repv_tbl IN repv_tbl_type,
102: x_repv_tbl OUT NOCOPY repv_tbl_type,
103: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
104: PROCEDURE insert_row(
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2,
107: x_return_status OUT NOCOPY VARCHAR2,

Line 126: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
125: p_repv_tbl IN repv_tbl_type,
126: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
127: PROCEDURE lock_row(
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2,
130: x_return_status OUT NOCOPY VARCHAR2,

Line 150: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_repv_tbl IN repv_tbl_type,
149: x_repv_tbl OUT NOCOPY repv_tbl_type,
150: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
151: PROCEDURE update_row(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2,
154: x_return_status OUT NOCOPY VARCHAR2,

Line 173: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_repv_tbl IN repv_tbl_type,
173: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
174: PROCEDURE delete_row(
175: p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2,
177: x_return_status OUT NOCOPY VARCHAR2,

Line 195: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

191: x_return_status OUT NOCOPY VARCHAR2,
192: x_msg_count OUT NOCOPY NUMBER,
193: x_msg_data OUT NOCOPY VARCHAR2,
194: p_repv_tbl IN repv_tbl_type,
195: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
196: PROCEDURE validate_row(
197: p_api_version IN NUMBER,
198: p_init_msg_list IN VARCHAR2,
199: x_return_status OUT NOCOPY VARCHAR2,