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

Line 8: id NUMBER := OKC_API.G_MISS_NUM

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_PM_SCHEDULES_V Record Spec
7: TYPE oks_pm_schedules_v_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,rule_id NUMBER := OKC_API.G_MISS_NUM
10: ,pma_rule_id NUMBER := OKC_API.G_MISS_NUM
11: ,pmp_rule_id NUMBER := OKC_API.G_MISS_NUM
12: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 9: ,rule_id NUMBER := OKC_API.G_MISS_NUM

5: ---------------------------------------------------------------------------
6: -- OKS_PM_SCHEDULES_V Record Spec
7: TYPE oks_pm_schedules_v_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,rule_id NUMBER := OKC_API.G_MISS_NUM
10: ,pma_rule_id NUMBER := OKC_API.G_MISS_NUM
11: ,pmp_rule_id NUMBER := OKC_API.G_MISS_NUM
12: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
13: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

Line 10: ,pma_rule_id NUMBER := OKC_API.G_MISS_NUM

6: -- OKS_PM_SCHEDULES_V Record Spec
7: TYPE oks_pm_schedules_v_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,rule_id NUMBER := OKC_API.G_MISS_NUM
10: ,pma_rule_id NUMBER := OKC_API.G_MISS_NUM
11: ,pmp_rule_id NUMBER := OKC_API.G_MISS_NUM
12: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
13: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
14: ,cle_id NUMBER := OKC_API.G_MISS_NUM

Line 11: ,pmp_rule_id NUMBER := OKC_API.G_MISS_NUM

7: TYPE oks_pm_schedules_v_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,rule_id NUMBER := OKC_API.G_MISS_NUM
10: ,pma_rule_id NUMBER := OKC_API.G_MISS_NUM
11: ,pmp_rule_id NUMBER := OKC_API.G_MISS_NUM
12: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
13: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
14: ,cle_id NUMBER := OKC_API.G_MISS_NUM
15: ,sch_sequence NUMBER := OKC_API.G_MISS_NUM

Line 12: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

8: id NUMBER := OKC_API.G_MISS_NUM
9: ,rule_id NUMBER := OKC_API.G_MISS_NUM
10: ,pma_rule_id NUMBER := OKC_API.G_MISS_NUM
11: ,pmp_rule_id NUMBER := OKC_API.G_MISS_NUM
12: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
13: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
14: ,cle_id NUMBER := OKC_API.G_MISS_NUM
15: ,sch_sequence NUMBER := OKC_API.G_MISS_NUM
16: ,schedule_date OKS_PM_SCHEDULES_V.SCHEDULE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 13: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

9: ,rule_id NUMBER := OKC_API.G_MISS_NUM
10: ,pma_rule_id NUMBER := OKC_API.G_MISS_NUM
11: ,pmp_rule_id NUMBER := OKC_API.G_MISS_NUM
12: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
13: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
14: ,cle_id NUMBER := OKC_API.G_MISS_NUM
15: ,sch_sequence NUMBER := OKC_API.G_MISS_NUM
16: ,schedule_date OKS_PM_SCHEDULES_V.SCHEDULE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,schedule_date_from OKS_PM_SCHEDULES_V.SCHEDULE_DATE_FROM%TYPE := OKC_API.G_MISS_DATE

Line 14: ,cle_id NUMBER := OKC_API.G_MISS_NUM

10: ,pma_rule_id NUMBER := OKC_API.G_MISS_NUM
11: ,pmp_rule_id NUMBER := OKC_API.G_MISS_NUM
12: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
13: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
14: ,cle_id NUMBER := OKC_API.G_MISS_NUM
15: ,sch_sequence NUMBER := OKC_API.G_MISS_NUM
16: ,schedule_date OKS_PM_SCHEDULES_V.SCHEDULE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,schedule_date_from OKS_PM_SCHEDULES_V.SCHEDULE_DATE_FROM%TYPE := OKC_API.G_MISS_DATE
18: ,schedule_date_to OKS_PM_SCHEDULES_V.SCHEDULE_DATE_TO%TYPE := OKC_API.G_MISS_DATE

Line 15: ,sch_sequence NUMBER := OKC_API.G_MISS_NUM

11: ,pmp_rule_id NUMBER := OKC_API.G_MISS_NUM
12: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
13: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
14: ,cle_id NUMBER := OKC_API.G_MISS_NUM
15: ,sch_sequence NUMBER := OKC_API.G_MISS_NUM
16: ,schedule_date OKS_PM_SCHEDULES_V.SCHEDULE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,schedule_date_from OKS_PM_SCHEDULES_V.SCHEDULE_DATE_FROM%TYPE := OKC_API.G_MISS_DATE
18: ,schedule_date_to OKS_PM_SCHEDULES_V.SCHEDULE_DATE_TO%TYPE := OKC_API.G_MISS_DATE
19: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 16: ,schedule_date OKS_PM_SCHEDULES_V.SCHEDULE_DATE%TYPE := OKC_API.G_MISS_DATE

12: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
13: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
14: ,cle_id NUMBER := OKC_API.G_MISS_NUM
15: ,sch_sequence NUMBER := OKC_API.G_MISS_NUM
16: ,schedule_date OKS_PM_SCHEDULES_V.SCHEDULE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,schedule_date_from OKS_PM_SCHEDULES_V.SCHEDULE_DATE_FROM%TYPE := OKC_API.G_MISS_DATE
18: ,schedule_date_to OKS_PM_SCHEDULES_V.SCHEDULE_DATE_TO%TYPE := OKC_API.G_MISS_DATE
19: ,created_by NUMBER := OKC_API.G_MISS_NUM
20: ,creation_date OKS_PM_SCHEDULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 17: ,schedule_date_from OKS_PM_SCHEDULES_V.SCHEDULE_DATE_FROM%TYPE := OKC_API.G_MISS_DATE

13: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
14: ,cle_id NUMBER := OKC_API.G_MISS_NUM
15: ,sch_sequence NUMBER := OKC_API.G_MISS_NUM
16: ,schedule_date OKS_PM_SCHEDULES_V.SCHEDULE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,schedule_date_from OKS_PM_SCHEDULES_V.SCHEDULE_DATE_FROM%TYPE := OKC_API.G_MISS_DATE
18: ,schedule_date_to OKS_PM_SCHEDULES_V.SCHEDULE_DATE_TO%TYPE := OKC_API.G_MISS_DATE
19: ,created_by NUMBER := OKC_API.G_MISS_NUM
20: ,creation_date OKS_PM_SCHEDULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 18: ,schedule_date_to OKS_PM_SCHEDULES_V.SCHEDULE_DATE_TO%TYPE := OKC_API.G_MISS_DATE

14: ,cle_id NUMBER := OKC_API.G_MISS_NUM
15: ,sch_sequence NUMBER := OKC_API.G_MISS_NUM
16: ,schedule_date OKS_PM_SCHEDULES_V.SCHEDULE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,schedule_date_from OKS_PM_SCHEDULES_V.SCHEDULE_DATE_FROM%TYPE := OKC_API.G_MISS_DATE
18: ,schedule_date_to OKS_PM_SCHEDULES_V.SCHEDULE_DATE_TO%TYPE := OKC_API.G_MISS_DATE
19: ,created_by NUMBER := OKC_API.G_MISS_NUM
20: ,creation_date OKS_PM_SCHEDULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
22: ,last_update_date OKS_PM_SCHEDULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 19: ,created_by NUMBER := OKC_API.G_MISS_NUM

15: ,sch_sequence NUMBER := OKC_API.G_MISS_NUM
16: ,schedule_date OKS_PM_SCHEDULES_V.SCHEDULE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,schedule_date_from OKS_PM_SCHEDULES_V.SCHEDULE_DATE_FROM%TYPE := OKC_API.G_MISS_DATE
18: ,schedule_date_to OKS_PM_SCHEDULES_V.SCHEDULE_DATE_TO%TYPE := OKC_API.G_MISS_DATE
19: ,created_by NUMBER := OKC_API.G_MISS_NUM
20: ,creation_date OKS_PM_SCHEDULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
22: ,last_update_date OKS_PM_SCHEDULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 20: ,creation_date OKS_PM_SCHEDULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

16: ,schedule_date OKS_PM_SCHEDULES_V.SCHEDULE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,schedule_date_from OKS_PM_SCHEDULES_V.SCHEDULE_DATE_FROM%TYPE := OKC_API.G_MISS_DATE
18: ,schedule_date_to OKS_PM_SCHEDULES_V.SCHEDULE_DATE_TO%TYPE := OKC_API.G_MISS_DATE
19: ,created_by NUMBER := OKC_API.G_MISS_NUM
20: ,creation_date OKS_PM_SCHEDULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
22: ,last_update_date OKS_PM_SCHEDULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
24: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM

Line 21: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

17: ,schedule_date_from OKS_PM_SCHEDULES_V.SCHEDULE_DATE_FROM%TYPE := OKC_API.G_MISS_DATE
18: ,schedule_date_to OKS_PM_SCHEDULES_V.SCHEDULE_DATE_TO%TYPE := OKC_API.G_MISS_DATE
19: ,created_by NUMBER := OKC_API.G_MISS_NUM
20: ,creation_date OKS_PM_SCHEDULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
22: ,last_update_date OKS_PM_SCHEDULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
24: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
25: ,stream_line_id NUMBER := OKC_API.G_MISS_NUM

Line 22: ,last_update_date OKS_PM_SCHEDULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

18: ,schedule_date_to OKS_PM_SCHEDULES_V.SCHEDULE_DATE_TO%TYPE := OKC_API.G_MISS_DATE
19: ,created_by NUMBER := OKC_API.G_MISS_NUM
20: ,creation_date OKS_PM_SCHEDULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
22: ,last_update_date OKS_PM_SCHEDULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
24: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
25: ,stream_line_id NUMBER := OKC_API.G_MISS_NUM
26: ,security_group_id NUMBER := OKC_API.G_MISS_NUM

Line 23: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

19: ,created_by NUMBER := OKC_API.G_MISS_NUM
20: ,creation_date OKS_PM_SCHEDULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
22: ,last_update_date OKS_PM_SCHEDULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
24: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
25: ,stream_line_id NUMBER := OKC_API.G_MISS_NUM
26: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
27: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

Line 24: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM

20: ,creation_date OKS_PM_SCHEDULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
22: ,last_update_date OKS_PM_SCHEDULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
24: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
25: ,stream_line_id NUMBER := OKC_API.G_MISS_NUM
26: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
27: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
28: ,program_id NUMBER := OKC_API.G_MISS_NUM

Line 25: ,stream_line_id NUMBER := OKC_API.G_MISS_NUM

21: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
22: ,last_update_date OKS_PM_SCHEDULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
24: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
25: ,stream_line_id NUMBER := OKC_API.G_MISS_NUM
26: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
27: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
28: ,program_id NUMBER := OKC_API.G_MISS_NUM
29: ,program_update_date OKS_PM_SCHEDULES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 26: ,security_group_id NUMBER := OKC_API.G_MISS_NUM

22: ,last_update_date OKS_PM_SCHEDULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
24: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
25: ,stream_line_id NUMBER := OKC_API.G_MISS_NUM
26: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
27: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
28: ,program_id NUMBER := OKC_API.G_MISS_NUM
29: ,program_update_date OKS_PM_SCHEDULES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
30: ,request_id NUMBER := OKC_API.G_MISS_NUM);

Line 27: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

23: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
24: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
25: ,stream_line_id NUMBER := OKC_API.G_MISS_NUM
26: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
27: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
28: ,program_id NUMBER := OKC_API.G_MISS_NUM
29: ,program_update_date OKS_PM_SCHEDULES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
30: ,request_id NUMBER := OKC_API.G_MISS_NUM);
31: G_MISS_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type;

Line 28: ,program_id NUMBER := OKC_API.G_MISS_NUM

24: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
25: ,stream_line_id NUMBER := OKC_API.G_MISS_NUM
26: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
27: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
28: ,program_id NUMBER := OKC_API.G_MISS_NUM
29: ,program_update_date OKS_PM_SCHEDULES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
30: ,request_id NUMBER := OKC_API.G_MISS_NUM);
31: G_MISS_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type;
32: TYPE oks_pm_schedules_v_tbl_type IS TABLE OF oks_pm_schedules_v_rec_type

Line 29: ,program_update_date OKS_PM_SCHEDULES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

25: ,stream_line_id NUMBER := OKC_API.G_MISS_NUM
26: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
27: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
28: ,program_id NUMBER := OKC_API.G_MISS_NUM
29: ,program_update_date OKS_PM_SCHEDULES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
30: ,request_id NUMBER := OKC_API.G_MISS_NUM);
31: G_MISS_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type;
32: TYPE oks_pm_schedules_v_tbl_type IS TABLE OF oks_pm_schedules_v_rec_type
33: INDEX BY BINARY_INTEGER;

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

26: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
27: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
28: ,program_id NUMBER := OKC_API.G_MISS_NUM
29: ,program_update_date OKS_PM_SCHEDULES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
30: ,request_id NUMBER := OKC_API.G_MISS_NUM);
31: G_MISS_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type;
32: TYPE oks_pm_schedules_v_tbl_type IS TABLE OF oks_pm_schedules_v_rec_type
33: INDEX BY BINARY_INTEGER;
34: -- OKS_PM_SCHEDULES Record Spec

Line 36: id NUMBER := OKC_API.G_MISS_NUM

32: TYPE oks_pm_schedules_v_tbl_type IS TABLE OF oks_pm_schedules_v_rec_type
33: INDEX BY BINARY_INTEGER;
34: -- OKS_PM_SCHEDULES Record Spec
35: TYPE oks_pm_schedules_rec_type IS RECORD (
36: id NUMBER := OKC_API.G_MISS_NUM
37: ,rule_id NUMBER := OKC_API.G_MISS_NUM
38: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,cle_id NUMBER := OKC_API.G_MISS_NUM

Line 37: ,rule_id NUMBER := OKC_API.G_MISS_NUM

33: INDEX BY BINARY_INTEGER;
34: -- OKS_PM_SCHEDULES Record Spec
35: TYPE oks_pm_schedules_rec_type IS RECORD (
36: id NUMBER := OKC_API.G_MISS_NUM
37: ,rule_id NUMBER := OKC_API.G_MISS_NUM
38: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,cle_id NUMBER := OKC_API.G_MISS_NUM
41: ,sch_sequence NUMBER := OKC_API.G_MISS_NUM

Line 38: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

34: -- OKS_PM_SCHEDULES Record Spec
35: TYPE oks_pm_schedules_rec_type IS RECORD (
36: id NUMBER := OKC_API.G_MISS_NUM
37: ,rule_id NUMBER := OKC_API.G_MISS_NUM
38: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,cle_id NUMBER := OKC_API.G_MISS_NUM
41: ,sch_sequence NUMBER := OKC_API.G_MISS_NUM
42: ,schedule_date OKS_PM_SCHEDULES.SCHEDULE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

35: TYPE oks_pm_schedules_rec_type IS RECORD (
36: id NUMBER := OKC_API.G_MISS_NUM
37: ,rule_id NUMBER := OKC_API.G_MISS_NUM
38: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,cle_id NUMBER := OKC_API.G_MISS_NUM
41: ,sch_sequence NUMBER := OKC_API.G_MISS_NUM
42: ,schedule_date OKS_PM_SCHEDULES.SCHEDULE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,schedule_date_from OKS_PM_SCHEDULES.SCHEDULE_DATE_FROM%TYPE := OKC_API.G_MISS_DATE

Line 40: ,cle_id NUMBER := OKC_API.G_MISS_NUM

36: id NUMBER := OKC_API.G_MISS_NUM
37: ,rule_id NUMBER := OKC_API.G_MISS_NUM
38: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,cle_id NUMBER := OKC_API.G_MISS_NUM
41: ,sch_sequence NUMBER := OKC_API.G_MISS_NUM
42: ,schedule_date OKS_PM_SCHEDULES.SCHEDULE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,schedule_date_from OKS_PM_SCHEDULES.SCHEDULE_DATE_FROM%TYPE := OKC_API.G_MISS_DATE
44: ,schedule_date_to OKS_PM_SCHEDULES.SCHEDULE_DATE_TO%TYPE := OKC_API.G_MISS_DATE

Line 41: ,sch_sequence NUMBER := OKC_API.G_MISS_NUM

37: ,rule_id NUMBER := OKC_API.G_MISS_NUM
38: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,cle_id NUMBER := OKC_API.G_MISS_NUM
41: ,sch_sequence NUMBER := OKC_API.G_MISS_NUM
42: ,schedule_date OKS_PM_SCHEDULES.SCHEDULE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,schedule_date_from OKS_PM_SCHEDULES.SCHEDULE_DATE_FROM%TYPE := OKC_API.G_MISS_DATE
44: ,schedule_date_to OKS_PM_SCHEDULES.SCHEDULE_DATE_TO%TYPE := OKC_API.G_MISS_DATE
45: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 42: ,schedule_date OKS_PM_SCHEDULES.SCHEDULE_DATE%TYPE := OKC_API.G_MISS_DATE

38: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,cle_id NUMBER := OKC_API.G_MISS_NUM
41: ,sch_sequence NUMBER := OKC_API.G_MISS_NUM
42: ,schedule_date OKS_PM_SCHEDULES.SCHEDULE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,schedule_date_from OKS_PM_SCHEDULES.SCHEDULE_DATE_FROM%TYPE := OKC_API.G_MISS_DATE
44: ,schedule_date_to OKS_PM_SCHEDULES.SCHEDULE_DATE_TO%TYPE := OKC_API.G_MISS_DATE
45: ,created_by NUMBER := OKC_API.G_MISS_NUM
46: ,creation_date OKS_PM_SCHEDULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 43: ,schedule_date_from OKS_PM_SCHEDULES.SCHEDULE_DATE_FROM%TYPE := OKC_API.G_MISS_DATE

39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,cle_id NUMBER := OKC_API.G_MISS_NUM
41: ,sch_sequence NUMBER := OKC_API.G_MISS_NUM
42: ,schedule_date OKS_PM_SCHEDULES.SCHEDULE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,schedule_date_from OKS_PM_SCHEDULES.SCHEDULE_DATE_FROM%TYPE := OKC_API.G_MISS_DATE
44: ,schedule_date_to OKS_PM_SCHEDULES.SCHEDULE_DATE_TO%TYPE := OKC_API.G_MISS_DATE
45: ,created_by NUMBER := OKC_API.G_MISS_NUM
46: ,creation_date OKS_PM_SCHEDULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 44: ,schedule_date_to OKS_PM_SCHEDULES.SCHEDULE_DATE_TO%TYPE := OKC_API.G_MISS_DATE

40: ,cle_id NUMBER := OKC_API.G_MISS_NUM
41: ,sch_sequence NUMBER := OKC_API.G_MISS_NUM
42: ,schedule_date OKS_PM_SCHEDULES.SCHEDULE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,schedule_date_from OKS_PM_SCHEDULES.SCHEDULE_DATE_FROM%TYPE := OKC_API.G_MISS_DATE
44: ,schedule_date_to OKS_PM_SCHEDULES.SCHEDULE_DATE_TO%TYPE := OKC_API.G_MISS_DATE
45: ,created_by NUMBER := OKC_API.G_MISS_NUM
46: ,creation_date OKS_PM_SCHEDULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
48: ,last_update_date OKS_PM_SCHEDULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 45: ,created_by NUMBER := OKC_API.G_MISS_NUM

41: ,sch_sequence NUMBER := OKC_API.G_MISS_NUM
42: ,schedule_date OKS_PM_SCHEDULES.SCHEDULE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,schedule_date_from OKS_PM_SCHEDULES.SCHEDULE_DATE_FROM%TYPE := OKC_API.G_MISS_DATE
44: ,schedule_date_to OKS_PM_SCHEDULES.SCHEDULE_DATE_TO%TYPE := OKC_API.G_MISS_DATE
45: ,created_by NUMBER := OKC_API.G_MISS_NUM
46: ,creation_date OKS_PM_SCHEDULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
48: ,last_update_date OKS_PM_SCHEDULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 46: ,creation_date OKS_PM_SCHEDULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

42: ,schedule_date OKS_PM_SCHEDULES.SCHEDULE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,schedule_date_from OKS_PM_SCHEDULES.SCHEDULE_DATE_FROM%TYPE := OKC_API.G_MISS_DATE
44: ,schedule_date_to OKS_PM_SCHEDULES.SCHEDULE_DATE_TO%TYPE := OKC_API.G_MISS_DATE
45: ,created_by NUMBER := OKC_API.G_MISS_NUM
46: ,creation_date OKS_PM_SCHEDULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
48: ,last_update_date OKS_PM_SCHEDULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
50: ,pma_rule_id NUMBER := OKC_API.G_MISS_NUM

Line 47: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

43: ,schedule_date_from OKS_PM_SCHEDULES.SCHEDULE_DATE_FROM%TYPE := OKC_API.G_MISS_DATE
44: ,schedule_date_to OKS_PM_SCHEDULES.SCHEDULE_DATE_TO%TYPE := OKC_API.G_MISS_DATE
45: ,created_by NUMBER := OKC_API.G_MISS_NUM
46: ,creation_date OKS_PM_SCHEDULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
48: ,last_update_date OKS_PM_SCHEDULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
50: ,pma_rule_id NUMBER := OKC_API.G_MISS_NUM
51: ,pmp_rule_id NUMBER := OKC_API.G_MISS_NUM

Line 48: ,last_update_date OKS_PM_SCHEDULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

44: ,schedule_date_to OKS_PM_SCHEDULES.SCHEDULE_DATE_TO%TYPE := OKC_API.G_MISS_DATE
45: ,created_by NUMBER := OKC_API.G_MISS_NUM
46: ,creation_date OKS_PM_SCHEDULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
48: ,last_update_date OKS_PM_SCHEDULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
50: ,pma_rule_id NUMBER := OKC_API.G_MISS_NUM
51: ,pmp_rule_id NUMBER := OKC_API.G_MISS_NUM
52: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM

Line 49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

45: ,created_by NUMBER := OKC_API.G_MISS_NUM
46: ,creation_date OKS_PM_SCHEDULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
48: ,last_update_date OKS_PM_SCHEDULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
50: ,pma_rule_id NUMBER := OKC_API.G_MISS_NUM
51: ,pmp_rule_id NUMBER := OKC_API.G_MISS_NUM
52: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
53: ,stream_line_id NUMBER := OKC_API.G_MISS_NUM

Line 50: ,pma_rule_id NUMBER := OKC_API.G_MISS_NUM

46: ,creation_date OKS_PM_SCHEDULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
48: ,last_update_date OKS_PM_SCHEDULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
50: ,pma_rule_id NUMBER := OKC_API.G_MISS_NUM
51: ,pmp_rule_id NUMBER := OKC_API.G_MISS_NUM
52: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
53: ,stream_line_id NUMBER := OKC_API.G_MISS_NUM
54: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

Line 51: ,pmp_rule_id NUMBER := OKC_API.G_MISS_NUM

47: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
48: ,last_update_date OKS_PM_SCHEDULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
50: ,pma_rule_id NUMBER := OKC_API.G_MISS_NUM
51: ,pmp_rule_id NUMBER := OKC_API.G_MISS_NUM
52: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
53: ,stream_line_id NUMBER := OKC_API.G_MISS_NUM
54: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
55: ,program_id NUMBER := OKC_API.G_MISS_NUM

Line 52: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM

48: ,last_update_date OKS_PM_SCHEDULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
50: ,pma_rule_id NUMBER := OKC_API.G_MISS_NUM
51: ,pmp_rule_id NUMBER := OKC_API.G_MISS_NUM
52: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
53: ,stream_line_id NUMBER := OKC_API.G_MISS_NUM
54: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
55: ,program_id NUMBER := OKC_API.G_MISS_NUM
56: ,program_update_date OKS_PM_SCHEDULES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 53: ,stream_line_id NUMBER := OKC_API.G_MISS_NUM

49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
50: ,pma_rule_id NUMBER := OKC_API.G_MISS_NUM
51: ,pmp_rule_id NUMBER := OKC_API.G_MISS_NUM
52: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
53: ,stream_line_id NUMBER := OKC_API.G_MISS_NUM
54: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
55: ,program_id NUMBER := OKC_API.G_MISS_NUM
56: ,program_update_date OKS_PM_SCHEDULES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,request_id NUMBER := OKC_API.G_MISS_NUM);

Line 54: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

50: ,pma_rule_id NUMBER := OKC_API.G_MISS_NUM
51: ,pmp_rule_id NUMBER := OKC_API.G_MISS_NUM
52: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
53: ,stream_line_id NUMBER := OKC_API.G_MISS_NUM
54: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
55: ,program_id NUMBER := OKC_API.G_MISS_NUM
56: ,program_update_date OKS_PM_SCHEDULES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,request_id NUMBER := OKC_API.G_MISS_NUM);
58: G_MISS_oks_pm_schedules_rec oks_pm_schedules_rec_type;

Line 55: ,program_id NUMBER := OKC_API.G_MISS_NUM

51: ,pmp_rule_id NUMBER := OKC_API.G_MISS_NUM
52: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
53: ,stream_line_id NUMBER := OKC_API.G_MISS_NUM
54: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
55: ,program_id NUMBER := OKC_API.G_MISS_NUM
56: ,program_update_date OKS_PM_SCHEDULES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,request_id NUMBER := OKC_API.G_MISS_NUM);
58: G_MISS_oks_pm_schedules_rec oks_pm_schedules_rec_type;
59: TYPE oks_pm_schedules_tbl_type IS TABLE OF oks_pm_schedules_rec_type

Line 56: ,program_update_date OKS_PM_SCHEDULES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

52: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
53: ,stream_line_id NUMBER := OKC_API.G_MISS_NUM
54: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
55: ,program_id NUMBER := OKC_API.G_MISS_NUM
56: ,program_update_date OKS_PM_SCHEDULES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,request_id NUMBER := OKC_API.G_MISS_NUM);
58: G_MISS_oks_pm_schedules_rec oks_pm_schedules_rec_type;
59: TYPE oks_pm_schedules_tbl_type IS TABLE OF oks_pm_schedules_rec_type
60: INDEX BY BINARY_INTEGER;

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

53: ,stream_line_id NUMBER := OKC_API.G_MISS_NUM
54: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
55: ,program_id NUMBER := OKC_API.G_MISS_NUM
56: ,program_update_date OKS_PM_SCHEDULES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,request_id NUMBER := OKC_API.G_MISS_NUM);
58: G_MISS_oks_pm_schedules_rec oks_pm_schedules_rec_type;
59: TYPE oks_pm_schedules_tbl_type IS TABLE OF oks_pm_schedules_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) := '_OKSPMSCHEDPVT';
87: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
88: ---------------------------------------------------------------------------
89: -- Procedures and Functions
90: ---------------------------------------------------------------------------
91:

Line 97: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

93: PROCEDURE change_version;
94: PROCEDURE api_copy;
95: PROCEDURE insert_row(
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2,
101: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,

Line 105: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

101: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
102: x_oks_pm_schedules_v_rec OUT NOCOPY oks_pm_schedules_v_rec_type);
103: PROCEDURE insert_row(
104: p_api_version IN NUMBER,
105: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,
108: x_msg_data OUT NOCOPY VARCHAR2,
109: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type,

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_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type,
110: x_oks_pm_schedules_v_tbl OUT NOCOPY oks_pm_schedules_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 DEFAULT OKC_API.G_FALSE,
115: x_return_status OUT NOCOPY VARCHAR2,

Line 114: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

110: x_oks_pm_schedules_v_tbl OUT NOCOPY oks_pm_schedules_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 DEFAULT OKC_API.G_FALSE,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type,

Line 122: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

118: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type,
119: x_oks_pm_schedules_v_tbl OUT NOCOPY oks_pm_schedules_v_tbl_type);
120: PROCEDURE lock_row(
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,
126: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type);

Line 129: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

125: x_msg_data OUT NOCOPY VARCHAR2,
126: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type);
127: PROCEDURE lock_row(
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type,

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_pm_schedules_v_tbl IN oks_pm_schedules_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 DEFAULT OKC_API.G_FALSE,
138: x_return_status OUT NOCOPY VARCHAR2,

Line 137: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

133: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_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 DEFAULT OKC_API.G_FALSE,
138: x_return_status OUT NOCOPY VARCHAR2,
139: x_msg_count OUT NOCOPY NUMBER,
140: x_msg_data OUT NOCOPY VARCHAR2,
141: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type);

Line 144: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

140: x_msg_data OUT NOCOPY VARCHAR2,
141: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type);
142: PROCEDURE update_row(
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,

Line 152: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

148: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
149: x_oks_pm_schedules_v_rec OUT NOCOPY oks_pm_schedules_v_rec_type);
150: PROCEDURE update_row(
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type,

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_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type,
157: x_oks_pm_schedules_v_tbl OUT NOCOPY oks_pm_schedules_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 DEFAULT OKC_API.G_FALSE,
162: x_return_status OUT NOCOPY VARCHAR2,

Line 161: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

157: x_oks_pm_schedules_v_tbl OUT NOCOPY oks_pm_schedules_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 DEFAULT OKC_API.G_FALSE,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type,

Line 169: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

165: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type,
166: x_oks_pm_schedules_v_tbl OUT NOCOPY oks_pm_schedules_v_tbl_type);
167: PROCEDURE delete_row(
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2,
173: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type);

Line 176: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

172: x_msg_data OUT NOCOPY VARCHAR2,
173: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type);
174: PROCEDURE delete_row(
175: p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type,

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_pm_schedules_v_tbl IN oks_pm_schedules_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 DEFAULT OKC_API.G_FALSE,
185: x_return_status OUT NOCOPY VARCHAR2,

Line 184: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

180: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_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 DEFAULT OKC_API.G_FALSE,
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2,
188: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type);

Line 191: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

187: x_msg_data OUT NOCOPY VARCHAR2,
188: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type);
189: PROCEDURE validate_row(
190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type);

Line 198: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type);
196: PROCEDURE validate_row(
197: p_api_version IN NUMBER,
198: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,
202: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type,

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_pm_schedules_v_tbl IN oks_pm_schedules_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 DEFAULT OKC_API.G_FALSE,
207: x_return_status OUT NOCOPY VARCHAR2,

Line 206: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

202: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_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 DEFAULT OKC_API.G_FALSE,
207: x_return_status OUT NOCOPY VARCHAR2,
208: x_msg_count OUT NOCOPY NUMBER,
209: x_msg_data OUT NOCOPY VARCHAR2,
210: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type);