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_ACM_PVT dependencies on OKC_API

Line 8: id NUMBER := OKC_API.G_MISS_NUM

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_ACTION_TIMES_V Record Spec
7: TYPE oks_action_times_v_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cov_action_type_id NUMBER := OKC_API.G_MISS_NUM
10: ,cle_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,uom_code OKS_ACTION_TIMES_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 9: ,cov_action_type_id NUMBER := OKC_API.G_MISS_NUM

5: ---------------------------------------------------------------------------
6: -- OKS_ACTION_TIMES_V Record Spec
7: TYPE oks_action_times_v_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cov_action_type_id NUMBER := OKC_API.G_MISS_NUM
10: ,cle_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,uom_code OKS_ACTION_TIMES_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
13: ,sun_duration NUMBER := OKC_API.G_MISS_NUM

Line 10: ,cle_id NUMBER := OKC_API.G_MISS_NUM

6: -- OKS_ACTION_TIMES_V Record Spec
7: TYPE oks_action_times_v_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cov_action_type_id NUMBER := OKC_API.G_MISS_NUM
10: ,cle_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,uom_code OKS_ACTION_TIMES_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
13: ,sun_duration NUMBER := OKC_API.G_MISS_NUM
14: ,mon_duration NUMBER := OKC_API.G_MISS_NUM

Line 11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

7: TYPE oks_action_times_v_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cov_action_type_id NUMBER := OKC_API.G_MISS_NUM
10: ,cle_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,uom_code OKS_ACTION_TIMES_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
13: ,sun_duration NUMBER := OKC_API.G_MISS_NUM
14: ,mon_duration NUMBER := OKC_API.G_MISS_NUM
15: ,tue_duration NUMBER := OKC_API.G_MISS_NUM

Line 12: ,uom_code OKS_ACTION_TIMES_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR

8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cov_action_type_id NUMBER := OKC_API.G_MISS_NUM
10: ,cle_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,uom_code OKS_ACTION_TIMES_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
13: ,sun_duration NUMBER := OKC_API.G_MISS_NUM
14: ,mon_duration NUMBER := OKC_API.G_MISS_NUM
15: ,tue_duration NUMBER := OKC_API.G_MISS_NUM
16: ,wed_duration NUMBER := OKC_API.G_MISS_NUM

Line 13: ,sun_duration NUMBER := OKC_API.G_MISS_NUM

9: ,cov_action_type_id NUMBER := OKC_API.G_MISS_NUM
10: ,cle_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,uom_code OKS_ACTION_TIMES_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
13: ,sun_duration NUMBER := OKC_API.G_MISS_NUM
14: ,mon_duration NUMBER := OKC_API.G_MISS_NUM
15: ,tue_duration NUMBER := OKC_API.G_MISS_NUM
16: ,wed_duration NUMBER := OKC_API.G_MISS_NUM
17: ,thu_duration NUMBER := OKC_API.G_MISS_NUM

Line 14: ,mon_duration NUMBER := OKC_API.G_MISS_NUM

10: ,cle_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,uom_code OKS_ACTION_TIMES_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
13: ,sun_duration NUMBER := OKC_API.G_MISS_NUM
14: ,mon_duration NUMBER := OKC_API.G_MISS_NUM
15: ,tue_duration NUMBER := OKC_API.G_MISS_NUM
16: ,wed_duration NUMBER := OKC_API.G_MISS_NUM
17: ,thu_duration NUMBER := OKC_API.G_MISS_NUM
18: ,fri_duration NUMBER := OKC_API.G_MISS_NUM

Line 15: ,tue_duration NUMBER := OKC_API.G_MISS_NUM

11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,uom_code OKS_ACTION_TIMES_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
13: ,sun_duration NUMBER := OKC_API.G_MISS_NUM
14: ,mon_duration NUMBER := OKC_API.G_MISS_NUM
15: ,tue_duration NUMBER := OKC_API.G_MISS_NUM
16: ,wed_duration NUMBER := OKC_API.G_MISS_NUM
17: ,thu_duration NUMBER := OKC_API.G_MISS_NUM
18: ,fri_duration NUMBER := OKC_API.G_MISS_NUM
19: ,sat_duration NUMBER := OKC_API.G_MISS_NUM

Line 16: ,wed_duration NUMBER := OKC_API.G_MISS_NUM

12: ,uom_code OKS_ACTION_TIMES_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
13: ,sun_duration NUMBER := OKC_API.G_MISS_NUM
14: ,mon_duration NUMBER := OKC_API.G_MISS_NUM
15: ,tue_duration NUMBER := OKC_API.G_MISS_NUM
16: ,wed_duration NUMBER := OKC_API.G_MISS_NUM
17: ,thu_duration NUMBER := OKC_API.G_MISS_NUM
18: ,fri_duration NUMBER := OKC_API.G_MISS_NUM
19: ,sat_duration NUMBER := OKC_API.G_MISS_NUM
20: ,security_group_id NUMBER := OKC_API.G_MISS_NUM

Line 17: ,thu_duration NUMBER := OKC_API.G_MISS_NUM

13: ,sun_duration NUMBER := OKC_API.G_MISS_NUM
14: ,mon_duration NUMBER := OKC_API.G_MISS_NUM
15: ,tue_duration NUMBER := OKC_API.G_MISS_NUM
16: ,wed_duration NUMBER := OKC_API.G_MISS_NUM
17: ,thu_duration NUMBER := OKC_API.G_MISS_NUM
18: ,fri_duration NUMBER := OKC_API.G_MISS_NUM
19: ,sat_duration NUMBER := OKC_API.G_MISS_NUM
20: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
21: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

Line 18: ,fri_duration NUMBER := OKC_API.G_MISS_NUM

14: ,mon_duration NUMBER := OKC_API.G_MISS_NUM
15: ,tue_duration NUMBER := OKC_API.G_MISS_NUM
16: ,wed_duration NUMBER := OKC_API.G_MISS_NUM
17: ,thu_duration NUMBER := OKC_API.G_MISS_NUM
18: ,fri_duration NUMBER := OKC_API.G_MISS_NUM
19: ,sat_duration NUMBER := OKC_API.G_MISS_NUM
20: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
21: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
22: ,program_id NUMBER := OKC_API.G_MISS_NUM

Line 19: ,sat_duration NUMBER := OKC_API.G_MISS_NUM

15: ,tue_duration NUMBER := OKC_API.G_MISS_NUM
16: ,wed_duration NUMBER := OKC_API.G_MISS_NUM
17: ,thu_duration NUMBER := OKC_API.G_MISS_NUM
18: ,fri_duration NUMBER := OKC_API.G_MISS_NUM
19: ,sat_duration NUMBER := OKC_API.G_MISS_NUM
20: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
21: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
22: ,program_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_update_date OKS_ACTION_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 20: ,security_group_id NUMBER := OKC_API.G_MISS_NUM

16: ,wed_duration NUMBER := OKC_API.G_MISS_NUM
17: ,thu_duration NUMBER := OKC_API.G_MISS_NUM
18: ,fri_duration NUMBER := OKC_API.G_MISS_NUM
19: ,sat_duration NUMBER := OKC_API.G_MISS_NUM
20: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
21: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
22: ,program_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_update_date OKS_ACTION_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,request_id NUMBER := OKC_API.G_MISS_NUM

Line 21: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

17: ,thu_duration NUMBER := OKC_API.G_MISS_NUM
18: ,fri_duration NUMBER := OKC_API.G_MISS_NUM
19: ,sat_duration NUMBER := OKC_API.G_MISS_NUM
20: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
21: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
22: ,program_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_update_date OKS_ACTION_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,request_id NUMBER := OKC_API.G_MISS_NUM
25: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 22: ,program_id NUMBER := OKC_API.G_MISS_NUM

18: ,fri_duration NUMBER := OKC_API.G_MISS_NUM
19: ,sat_duration NUMBER := OKC_API.G_MISS_NUM
20: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
21: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
22: ,program_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_update_date OKS_ACTION_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,request_id NUMBER := OKC_API.G_MISS_NUM
25: ,created_by NUMBER := OKC_API.G_MISS_NUM
26: ,creation_date OKS_ACTION_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 23: ,program_update_date OKS_ACTION_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

19: ,sat_duration NUMBER := OKC_API.G_MISS_NUM
20: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
21: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
22: ,program_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_update_date OKS_ACTION_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,request_id NUMBER := OKC_API.G_MISS_NUM
25: ,created_by NUMBER := OKC_API.G_MISS_NUM
26: ,creation_date OKS_ACTION_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 24: ,request_id NUMBER := OKC_API.G_MISS_NUM

20: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
21: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
22: ,program_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_update_date OKS_ACTION_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,request_id NUMBER := OKC_API.G_MISS_NUM
25: ,created_by NUMBER := OKC_API.G_MISS_NUM
26: ,creation_date OKS_ACTION_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
28: ,last_update_date OKS_ACTION_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 25: ,created_by NUMBER := OKC_API.G_MISS_NUM

21: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
22: ,program_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_update_date OKS_ACTION_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,request_id NUMBER := OKC_API.G_MISS_NUM
25: ,created_by NUMBER := OKC_API.G_MISS_NUM
26: ,creation_date OKS_ACTION_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
28: ,last_update_date OKS_ACTION_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 26: ,creation_date OKS_ACTION_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

22: ,program_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_update_date OKS_ACTION_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,request_id NUMBER := OKC_API.G_MISS_NUM
25: ,created_by NUMBER := OKC_API.G_MISS_NUM
26: ,creation_date OKS_ACTION_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
28: ,last_update_date OKS_ACTION_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
30: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);

Line 27: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

23: ,program_update_date OKS_ACTION_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,request_id NUMBER := OKC_API.G_MISS_NUM
25: ,created_by NUMBER := OKC_API.G_MISS_NUM
26: ,creation_date OKS_ACTION_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
28: ,last_update_date OKS_ACTION_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
30: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
31: G_MISS_oks_action_times_v_rec oks_action_times_v_rec_type;

Line 28: ,last_update_date OKS_ACTION_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

24: ,request_id NUMBER := OKC_API.G_MISS_NUM
25: ,created_by NUMBER := OKC_API.G_MISS_NUM
26: ,creation_date OKS_ACTION_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
28: ,last_update_date OKS_ACTION_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
30: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
31: G_MISS_oks_action_times_v_rec oks_action_times_v_rec_type;
32: TYPE oks_action_times_v_tbl_type IS TABLE OF oks_action_times_v_rec_type

Line 29: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

25: ,created_by NUMBER := OKC_API.G_MISS_NUM
26: ,creation_date OKS_ACTION_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
28: ,last_update_date OKS_ACTION_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
30: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
31: G_MISS_oks_action_times_v_rec oks_action_times_v_rec_type;
32: TYPE oks_action_times_v_tbl_type IS TABLE OF oks_action_times_v_rec_type
33: INDEX BY BINARY_INTEGER;

Line 30: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);

26: ,creation_date OKS_ACTION_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
28: ,last_update_date OKS_ACTION_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
30: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
31: G_MISS_oks_action_times_v_rec oks_action_times_v_rec_type;
32: TYPE oks_action_times_v_tbl_type IS TABLE OF oks_action_times_v_rec_type
33: INDEX BY BINARY_INTEGER;
34: -- OKS_ACTION_TIMES Record Spec

Line 36: id NUMBER := OKC_API.G_MISS_NUM

32: TYPE oks_action_times_v_tbl_type IS TABLE OF oks_action_times_v_rec_type
33: INDEX BY BINARY_INTEGER;
34: -- OKS_ACTION_TIMES Record Spec
35: TYPE oks_action_times_rec_type IS RECORD (
36: id NUMBER := OKC_API.G_MISS_NUM
37: ,cov_action_type_id NUMBER := OKC_API.G_MISS_NUM
38: ,cle_id NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,uom_code OKS_ACTION_TIMES.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 37: ,cov_action_type_id NUMBER := OKC_API.G_MISS_NUM

33: INDEX BY BINARY_INTEGER;
34: -- OKS_ACTION_TIMES Record Spec
35: TYPE oks_action_times_rec_type IS RECORD (
36: id NUMBER := OKC_API.G_MISS_NUM
37: ,cov_action_type_id NUMBER := OKC_API.G_MISS_NUM
38: ,cle_id NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,uom_code OKS_ACTION_TIMES.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
41: ,sun_duration NUMBER := OKC_API.G_MISS_NUM

Line 38: ,cle_id NUMBER := OKC_API.G_MISS_NUM

34: -- OKS_ACTION_TIMES Record Spec
35: TYPE oks_action_times_rec_type IS RECORD (
36: id NUMBER := OKC_API.G_MISS_NUM
37: ,cov_action_type_id NUMBER := OKC_API.G_MISS_NUM
38: ,cle_id NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,uom_code OKS_ACTION_TIMES.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
41: ,sun_duration NUMBER := OKC_API.G_MISS_NUM
42: ,mon_duration NUMBER := OKC_API.G_MISS_NUM

Line 39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

35: TYPE oks_action_times_rec_type IS RECORD (
36: id NUMBER := OKC_API.G_MISS_NUM
37: ,cov_action_type_id NUMBER := OKC_API.G_MISS_NUM
38: ,cle_id NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,uom_code OKS_ACTION_TIMES.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
41: ,sun_duration NUMBER := OKC_API.G_MISS_NUM
42: ,mon_duration NUMBER := OKC_API.G_MISS_NUM
43: ,tue_duration NUMBER := OKC_API.G_MISS_NUM

Line 40: ,uom_code OKS_ACTION_TIMES.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR

36: id NUMBER := OKC_API.G_MISS_NUM
37: ,cov_action_type_id NUMBER := OKC_API.G_MISS_NUM
38: ,cle_id NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,uom_code OKS_ACTION_TIMES.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
41: ,sun_duration NUMBER := OKC_API.G_MISS_NUM
42: ,mon_duration NUMBER := OKC_API.G_MISS_NUM
43: ,tue_duration NUMBER := OKC_API.G_MISS_NUM
44: ,wed_duration NUMBER := OKC_API.G_MISS_NUM

Line 41: ,sun_duration NUMBER := OKC_API.G_MISS_NUM

37: ,cov_action_type_id NUMBER := OKC_API.G_MISS_NUM
38: ,cle_id NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,uom_code OKS_ACTION_TIMES.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
41: ,sun_duration NUMBER := OKC_API.G_MISS_NUM
42: ,mon_duration NUMBER := OKC_API.G_MISS_NUM
43: ,tue_duration NUMBER := OKC_API.G_MISS_NUM
44: ,wed_duration NUMBER := OKC_API.G_MISS_NUM
45: ,thu_duration NUMBER := OKC_API.G_MISS_NUM

Line 42: ,mon_duration NUMBER := OKC_API.G_MISS_NUM

38: ,cle_id NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,uom_code OKS_ACTION_TIMES.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
41: ,sun_duration NUMBER := OKC_API.G_MISS_NUM
42: ,mon_duration NUMBER := OKC_API.G_MISS_NUM
43: ,tue_duration NUMBER := OKC_API.G_MISS_NUM
44: ,wed_duration NUMBER := OKC_API.G_MISS_NUM
45: ,thu_duration NUMBER := OKC_API.G_MISS_NUM
46: ,fri_duration NUMBER := OKC_API.G_MISS_NUM

Line 43: ,tue_duration NUMBER := OKC_API.G_MISS_NUM

39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,uom_code OKS_ACTION_TIMES.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
41: ,sun_duration NUMBER := OKC_API.G_MISS_NUM
42: ,mon_duration NUMBER := OKC_API.G_MISS_NUM
43: ,tue_duration NUMBER := OKC_API.G_MISS_NUM
44: ,wed_duration NUMBER := OKC_API.G_MISS_NUM
45: ,thu_duration NUMBER := OKC_API.G_MISS_NUM
46: ,fri_duration NUMBER := OKC_API.G_MISS_NUM
47: ,sat_duration NUMBER := OKC_API.G_MISS_NUM

Line 44: ,wed_duration NUMBER := OKC_API.G_MISS_NUM

40: ,uom_code OKS_ACTION_TIMES.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
41: ,sun_duration NUMBER := OKC_API.G_MISS_NUM
42: ,mon_duration NUMBER := OKC_API.G_MISS_NUM
43: ,tue_duration NUMBER := OKC_API.G_MISS_NUM
44: ,wed_duration NUMBER := OKC_API.G_MISS_NUM
45: ,thu_duration NUMBER := OKC_API.G_MISS_NUM
46: ,fri_duration NUMBER := OKC_API.G_MISS_NUM
47: ,sat_duration NUMBER := OKC_API.G_MISS_NUM
48: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

Line 45: ,thu_duration NUMBER := OKC_API.G_MISS_NUM

41: ,sun_duration NUMBER := OKC_API.G_MISS_NUM
42: ,mon_duration NUMBER := OKC_API.G_MISS_NUM
43: ,tue_duration NUMBER := OKC_API.G_MISS_NUM
44: ,wed_duration NUMBER := OKC_API.G_MISS_NUM
45: ,thu_duration NUMBER := OKC_API.G_MISS_NUM
46: ,fri_duration NUMBER := OKC_API.G_MISS_NUM
47: ,sat_duration NUMBER := OKC_API.G_MISS_NUM
48: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
49: ,program_id NUMBER := OKC_API.G_MISS_NUM

Line 46: ,fri_duration NUMBER := OKC_API.G_MISS_NUM

42: ,mon_duration NUMBER := OKC_API.G_MISS_NUM
43: ,tue_duration NUMBER := OKC_API.G_MISS_NUM
44: ,wed_duration NUMBER := OKC_API.G_MISS_NUM
45: ,thu_duration NUMBER := OKC_API.G_MISS_NUM
46: ,fri_duration NUMBER := OKC_API.G_MISS_NUM
47: ,sat_duration NUMBER := OKC_API.G_MISS_NUM
48: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
49: ,program_id NUMBER := OKC_API.G_MISS_NUM
50: ,program_update_date OKS_ACTION_TIMES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 47: ,sat_duration NUMBER := OKC_API.G_MISS_NUM

43: ,tue_duration NUMBER := OKC_API.G_MISS_NUM
44: ,wed_duration NUMBER := OKC_API.G_MISS_NUM
45: ,thu_duration NUMBER := OKC_API.G_MISS_NUM
46: ,fri_duration NUMBER := OKC_API.G_MISS_NUM
47: ,sat_duration NUMBER := OKC_API.G_MISS_NUM
48: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
49: ,program_id NUMBER := OKC_API.G_MISS_NUM
50: ,program_update_date OKS_ACTION_TIMES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,request_id NUMBER := OKC_API.G_MISS_NUM

Line 48: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

44: ,wed_duration NUMBER := OKC_API.G_MISS_NUM
45: ,thu_duration NUMBER := OKC_API.G_MISS_NUM
46: ,fri_duration NUMBER := OKC_API.G_MISS_NUM
47: ,sat_duration NUMBER := OKC_API.G_MISS_NUM
48: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
49: ,program_id NUMBER := OKC_API.G_MISS_NUM
50: ,program_update_date OKS_ACTION_TIMES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,request_id NUMBER := OKC_API.G_MISS_NUM
52: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 49: ,program_id NUMBER := OKC_API.G_MISS_NUM

45: ,thu_duration NUMBER := OKC_API.G_MISS_NUM
46: ,fri_duration NUMBER := OKC_API.G_MISS_NUM
47: ,sat_duration NUMBER := OKC_API.G_MISS_NUM
48: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
49: ,program_id NUMBER := OKC_API.G_MISS_NUM
50: ,program_update_date OKS_ACTION_TIMES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,request_id NUMBER := OKC_API.G_MISS_NUM
52: ,created_by NUMBER := OKC_API.G_MISS_NUM
53: ,creation_date OKS_ACTION_TIMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 50: ,program_update_date OKS_ACTION_TIMES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

46: ,fri_duration NUMBER := OKC_API.G_MISS_NUM
47: ,sat_duration NUMBER := OKC_API.G_MISS_NUM
48: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
49: ,program_id NUMBER := OKC_API.G_MISS_NUM
50: ,program_update_date OKS_ACTION_TIMES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,request_id NUMBER := OKC_API.G_MISS_NUM
52: ,created_by NUMBER := OKC_API.G_MISS_NUM
53: ,creation_date OKS_ACTION_TIMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 51: ,request_id NUMBER := OKC_API.G_MISS_NUM

47: ,sat_duration NUMBER := OKC_API.G_MISS_NUM
48: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
49: ,program_id NUMBER := OKC_API.G_MISS_NUM
50: ,program_update_date OKS_ACTION_TIMES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,request_id NUMBER := OKC_API.G_MISS_NUM
52: ,created_by NUMBER := OKC_API.G_MISS_NUM
53: ,creation_date OKS_ACTION_TIMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
55: ,last_update_date OKS_ACTION_TIMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 52: ,created_by NUMBER := OKC_API.G_MISS_NUM

48: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
49: ,program_id NUMBER := OKC_API.G_MISS_NUM
50: ,program_update_date OKS_ACTION_TIMES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,request_id NUMBER := OKC_API.G_MISS_NUM
52: ,created_by NUMBER := OKC_API.G_MISS_NUM
53: ,creation_date OKS_ACTION_TIMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
55: ,last_update_date OKS_ACTION_TIMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 53: ,creation_date OKS_ACTION_TIMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

49: ,program_id NUMBER := OKC_API.G_MISS_NUM
50: ,program_update_date OKS_ACTION_TIMES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,request_id NUMBER := OKC_API.G_MISS_NUM
52: ,created_by NUMBER := OKC_API.G_MISS_NUM
53: ,creation_date OKS_ACTION_TIMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
55: ,last_update_date OKS_ACTION_TIMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
57: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);

Line 54: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

50: ,program_update_date OKS_ACTION_TIMES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,request_id NUMBER := OKC_API.G_MISS_NUM
52: ,created_by NUMBER := OKC_API.G_MISS_NUM
53: ,creation_date OKS_ACTION_TIMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
55: ,last_update_date OKS_ACTION_TIMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
57: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
58: G_MISS_oks_action_times_rec oks_action_times_rec_type;

Line 55: ,last_update_date OKS_ACTION_TIMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

51: ,request_id NUMBER := OKC_API.G_MISS_NUM
52: ,created_by NUMBER := OKC_API.G_MISS_NUM
53: ,creation_date OKS_ACTION_TIMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
55: ,last_update_date OKS_ACTION_TIMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
57: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
58: G_MISS_oks_action_times_rec oks_action_times_rec_type;
59: TYPE oks_action_times_tbl_type IS TABLE OF oks_action_times_rec_type

Line 56: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

52: ,created_by NUMBER := OKC_API.G_MISS_NUM
53: ,creation_date OKS_ACTION_TIMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
55: ,last_update_date OKS_ACTION_TIMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
57: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
58: G_MISS_oks_action_times_rec oks_action_times_rec_type;
59: TYPE oks_action_times_tbl_type IS TABLE OF oks_action_times_rec_type
60: INDEX BY BINARY_INTEGER;

Line 57: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);

53: ,creation_date OKS_ACTION_TIMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
55: ,last_update_date OKS_ACTION_TIMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
57: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
58: G_MISS_oks_action_times_rec oks_action_times_rec_type;
59: TYPE oks_action_times_tbl_type IS TABLE OF oks_action_times_rec_type
60: INDEX BY BINARY_INTEGER;
61: ---------------------------------------------------------------------------

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

60: INDEX BY BINARY_INTEGER;
61: ---------------------------------------------------------------------------
62: -- GLOBAL MESSAGE CONSTANTS
63: ---------------------------------------------------------------------------
64: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
65: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
66: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
67: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
68: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

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

61: ---------------------------------------------------------------------------
62: -- GLOBAL MESSAGE CONSTANTS
63: ---------------------------------------------------------------------------
64: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
65: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
66: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
67: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
68: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
69: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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

62: -- GLOBAL MESSAGE CONSTANTS
63: ---------------------------------------------------------------------------
64: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
65: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
66: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
67: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
68: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
69: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
70: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

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

63: ---------------------------------------------------------------------------
64: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
65: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
66: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
67: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
68: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
69: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
70: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
71: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

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

64: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
65: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
66: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
67: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
68: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
69: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
70: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
71: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
72: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

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

65: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
66: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
67: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
68: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
69: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
70: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
71: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
72: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
73: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

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

66: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
67: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
68: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
69: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
70: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
71: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
72: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
73: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
74: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';

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

67: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
68: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
69: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
70: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
71: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
72: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
73: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
74: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
75: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

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

68: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
69: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
70: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
71: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
72: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
73: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
74: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
75: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
76: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

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

69: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
70: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
71: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
72: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
73: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
74: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
75: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
76: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
77:

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

83: ---------------------------------------------------------------------------
84: -- GLOBAL VARIABLES
85: ---------------------------------------------------------------------------
86: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_ACM_PVT';
87: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
88: ---------------------------------------------------------------------------
89: -- Procedures and Functions
90: ---------------------------------------------------------------------------
91:

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

107: x_msg_count OUT NOCOPY NUMBER,
108: x_msg_data OUT NOCOPY VARCHAR2,
109: p_oks_action_times_v_tbl IN oks_action_times_v_tbl_type,
110: x_oks_action_times_v_tbl OUT NOCOPY oks_action_times_v_tbl_type,
111: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
112: PROCEDURE insert_row(
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2,
115: x_return_status OUT NOCOPY VARCHAR2,

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

130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_oks_action_times_v_tbl IN oks_action_times_v_tbl_type,
134: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
135: PROCEDURE lock_row(
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2,
138: x_return_status OUT NOCOPY VARCHAR2,

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

154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_oks_action_times_v_tbl IN oks_action_times_v_tbl_type,
157: x_oks_action_times_v_tbl OUT NOCOPY oks_action_times_v_tbl_type,
158: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
159: PROCEDURE update_row(
160: p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2,
162: x_return_status OUT NOCOPY VARCHAR2,

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

177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: p_oks_action_times_v_tbl IN oks_action_times_v_tbl_type,
181: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
182: PROCEDURE delete_row(
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2,
185: x_return_status OUT NOCOPY VARCHAR2,

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

199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,
202: p_oks_action_times_v_tbl IN oks_action_times_v_tbl_type,
203: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
204: PROCEDURE validate_row(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2,
207: x_return_status OUT NOCOPY VARCHAR2,