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

Line 8: id NUMBER := OKC_API.G_MISS_NUM

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_PM_ACTIVITIES_V Record Spec
7: TYPE pmav_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,activity_id NUMBER := OKC_API.G_MISS_NUM
12: ,select_yn OKS_PM_ACTIVITIES_V.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR

Line 9: ,cle_id NUMBER := OKC_API.G_MISS_NUM

5: ---------------------------------------------------------------------------
6: -- OKS_PM_ACTIVITIES_V Record Spec
7: TYPE pmav_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,activity_id NUMBER := OKC_API.G_MISS_NUM
12: ,select_yn OKS_PM_ACTIVITIES_V.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,conf_req_yn OKS_PM_ACTIVITIES_V.CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR

Line 10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

6: -- OKS_PM_ACTIVITIES_V Record Spec
7: TYPE pmav_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,activity_id NUMBER := OKC_API.G_MISS_NUM
12: ,select_yn OKS_PM_ACTIVITIES_V.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,conf_req_yn OKS_PM_ACTIVITIES_V.CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,sch_exists_yn OKS_PM_ACTIVITIES_V.SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR

Line 11: ,activity_id NUMBER := OKC_API.G_MISS_NUM

7: TYPE pmav_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,activity_id NUMBER := OKC_API.G_MISS_NUM
12: ,select_yn OKS_PM_ACTIVITIES_V.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,conf_req_yn OKS_PM_ACTIVITIES_V.CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,sch_exists_yn OKS_PM_ACTIVITIES_V.SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR
15: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

Line 12: ,select_yn OKS_PM_ACTIVITIES_V.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR

8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,activity_id NUMBER := OKC_API.G_MISS_NUM
12: ,select_yn OKS_PM_ACTIVITIES_V.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,conf_req_yn OKS_PM_ACTIVITIES_V.CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,sch_exists_yn OKS_PM_ACTIVITIES_V.SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR
15: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_id NUMBER := OKC_API.G_MISS_NUM

Line 13: ,conf_req_yn OKS_PM_ACTIVITIES_V.CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR

9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,activity_id NUMBER := OKC_API.G_MISS_NUM
12: ,select_yn OKS_PM_ACTIVITIES_V.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,conf_req_yn OKS_PM_ACTIVITIES_V.CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,sch_exists_yn OKS_PM_ACTIVITIES_V.SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR
15: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_update_date OKS_PM_ACTIVITIES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 14: ,sch_exists_yn OKS_PM_ACTIVITIES_V.SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR

10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,activity_id NUMBER := OKC_API.G_MISS_NUM
12: ,select_yn OKS_PM_ACTIVITIES_V.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,conf_req_yn OKS_PM_ACTIVITIES_V.CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,sch_exists_yn OKS_PM_ACTIVITIES_V.SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR
15: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_update_date OKS_PM_ACTIVITIES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 15: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

11: ,activity_id NUMBER := OKC_API.G_MISS_NUM
12: ,select_yn OKS_PM_ACTIVITIES_V.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,conf_req_yn OKS_PM_ACTIVITIES_V.CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,sch_exists_yn OKS_PM_ACTIVITIES_V.SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR
15: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_update_date OKS_PM_ACTIVITIES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
19: ,security_group_id NUMBER := OKC_API.G_MISS_NUM

Line 16: ,program_id NUMBER := OKC_API.G_MISS_NUM

12: ,select_yn OKS_PM_ACTIVITIES_V.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,conf_req_yn OKS_PM_ACTIVITIES_V.CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,sch_exists_yn OKS_PM_ACTIVITIES_V.SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR
15: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_update_date OKS_PM_ACTIVITIES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
19: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
20: ,request_id NUMBER := OKC_API.G_MISS_NUM

Line 17: ,program_update_date OKS_PM_ACTIVITIES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

13: ,conf_req_yn OKS_PM_ACTIVITIES_V.CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,sch_exists_yn OKS_PM_ACTIVITIES_V.SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR
15: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_update_date OKS_PM_ACTIVITIES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
19: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
20: ,request_id NUMBER := OKC_API.G_MISS_NUM
21: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 18: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

14: ,sch_exists_yn OKS_PM_ACTIVITIES_V.SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR
15: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_update_date OKS_PM_ACTIVITIES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
19: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
20: ,request_id NUMBER := OKC_API.G_MISS_NUM
21: ,created_by NUMBER := OKC_API.G_MISS_NUM
22: ,creation_date OKS_PM_ACTIVITIES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 19: ,security_group_id NUMBER := OKC_API.G_MISS_NUM

15: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_update_date OKS_PM_ACTIVITIES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
19: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
20: ,request_id NUMBER := OKC_API.G_MISS_NUM
21: ,created_by NUMBER := OKC_API.G_MISS_NUM
22: ,creation_date OKS_PM_ACTIVITIES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 20: ,request_id NUMBER := OKC_API.G_MISS_NUM

16: ,program_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_update_date OKS_PM_ACTIVITIES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
19: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
20: ,request_id NUMBER := OKC_API.G_MISS_NUM
21: ,created_by NUMBER := OKC_API.G_MISS_NUM
22: ,creation_date OKS_PM_ACTIVITIES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
24: ,last_update_date OKS_PM_ACTIVITIES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 21: ,created_by NUMBER := OKC_API.G_MISS_NUM

17: ,program_update_date OKS_PM_ACTIVITIES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
19: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
20: ,request_id NUMBER := OKC_API.G_MISS_NUM
21: ,created_by NUMBER := OKC_API.G_MISS_NUM
22: ,creation_date OKS_PM_ACTIVITIES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
24: ,last_update_date OKS_PM_ACTIVITIES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
25: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 22: ,creation_date OKS_PM_ACTIVITIES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

18: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
19: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
20: ,request_id NUMBER := OKC_API.G_MISS_NUM
21: ,created_by NUMBER := OKC_API.G_MISS_NUM
22: ,creation_date OKS_PM_ACTIVITIES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
24: ,last_update_date OKS_PM_ACTIVITIES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
25: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
26: -- R12 Data Model Changes 4485150 Start

Line 23: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

19: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
20: ,request_id NUMBER := OKC_API.G_MISS_NUM
21: ,created_by NUMBER := OKC_API.G_MISS_NUM
22: ,creation_date OKS_PM_ACTIVITIES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
24: ,last_update_date OKS_PM_ACTIVITIES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
25: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
26: -- R12 Data Model Changes 4485150 Start
27: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM

Line 24: ,last_update_date OKS_PM_ACTIVITIES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

20: ,request_id NUMBER := OKC_API.G_MISS_NUM
21: ,created_by NUMBER := OKC_API.G_MISS_NUM
22: ,creation_date OKS_PM_ACTIVITIES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
24: ,last_update_date OKS_PM_ACTIVITIES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
25: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
26: -- R12 Data Model Changes 4485150 Start
27: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
28: ,orig_system_reference1 OKS_PM_ACTIVITIES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR

Line 25: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

21: ,created_by NUMBER := OKC_API.G_MISS_NUM
22: ,creation_date OKS_PM_ACTIVITIES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
24: ,last_update_date OKS_PM_ACTIVITIES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
25: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
26: -- R12 Data Model Changes 4485150 Start
27: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
28: ,orig_system_reference1 OKS_PM_ACTIVITIES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
29: ,orig_system_source_code OKS_PM_ACTIVITIES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 27: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM

23: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
24: ,last_update_date OKS_PM_ACTIVITIES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
25: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
26: -- R12 Data Model Changes 4485150 Start
27: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
28: ,orig_system_reference1 OKS_PM_ACTIVITIES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
29: ,orig_system_source_code OKS_PM_ACTIVITIES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
30: -- R12 Data Model Changes 4485150 End
31: );

Line 28: ,orig_system_reference1 OKS_PM_ACTIVITIES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR

24: ,last_update_date OKS_PM_ACTIVITIES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
25: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
26: -- R12 Data Model Changes 4485150 Start
27: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
28: ,orig_system_reference1 OKS_PM_ACTIVITIES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
29: ,orig_system_source_code OKS_PM_ACTIVITIES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
30: -- R12 Data Model Changes 4485150 End
31: );
32: G_MISS_pmav_rec pmav_rec_type;

Line 29: ,orig_system_source_code OKS_PM_ACTIVITIES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR

25: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
26: -- R12 Data Model Changes 4485150 Start
27: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
28: ,orig_system_reference1 OKS_PM_ACTIVITIES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
29: ,orig_system_source_code OKS_PM_ACTIVITIES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
30: -- R12 Data Model Changes 4485150 End
31: );
32: G_MISS_pmav_rec pmav_rec_type;
33: TYPE pmav_tbl_type IS TABLE OF pmav_rec_type

Line 37: id NUMBER := OKC_API.G_MISS_NUM

33: TYPE pmav_tbl_type IS TABLE OF pmav_rec_type
34: INDEX BY BINARY_INTEGER;
35: -- OKS_PM_ACTIVITIES Record Spec
36: TYPE pma_rec_type IS RECORD (
37: 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: ,activity_id NUMBER := OKC_API.G_MISS_NUM
41: ,select_yn OKS_PM_ACTIVITIES.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR

Line 38: ,cle_id NUMBER := OKC_API.G_MISS_NUM

34: INDEX BY BINARY_INTEGER;
35: -- OKS_PM_ACTIVITIES Record Spec
36: TYPE pma_rec_type IS RECORD (
37: 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: ,activity_id NUMBER := OKC_API.G_MISS_NUM
41: ,select_yn OKS_PM_ACTIVITIES.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR
42: ,conf_req_yn OKS_PM_ACTIVITIES.CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR

Line 39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

35: -- OKS_PM_ACTIVITIES Record Spec
36: TYPE pma_rec_type IS RECORD (
37: 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: ,activity_id NUMBER := OKC_API.G_MISS_NUM
41: ,select_yn OKS_PM_ACTIVITIES.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR
42: ,conf_req_yn OKS_PM_ACTIVITIES.CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
43: ,sch_exists_yn OKS_PM_ACTIVITIES.SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR

Line 40: ,activity_id NUMBER := OKC_API.G_MISS_NUM

36: TYPE pma_rec_type IS RECORD (
37: 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: ,activity_id NUMBER := OKC_API.G_MISS_NUM
41: ,select_yn OKS_PM_ACTIVITIES.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR
42: ,conf_req_yn OKS_PM_ACTIVITIES.CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
43: ,sch_exists_yn OKS_PM_ACTIVITIES.SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR
44: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

Line 41: ,select_yn OKS_PM_ACTIVITIES.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR

37: 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: ,activity_id NUMBER := OKC_API.G_MISS_NUM
41: ,select_yn OKS_PM_ACTIVITIES.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR
42: ,conf_req_yn OKS_PM_ACTIVITIES.CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
43: ,sch_exists_yn OKS_PM_ACTIVITIES.SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR
44: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
45: ,program_id NUMBER := OKC_API.G_MISS_NUM

Line 42: ,conf_req_yn OKS_PM_ACTIVITIES.CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR

38: ,cle_id NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,activity_id NUMBER := OKC_API.G_MISS_NUM
41: ,select_yn OKS_PM_ACTIVITIES.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR
42: ,conf_req_yn OKS_PM_ACTIVITIES.CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
43: ,sch_exists_yn OKS_PM_ACTIVITIES.SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR
44: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
45: ,program_id NUMBER := OKC_API.G_MISS_NUM
46: ,program_update_date OKS_PM_ACTIVITIES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 43: ,sch_exists_yn OKS_PM_ACTIVITIES.SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR

39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,activity_id NUMBER := OKC_API.G_MISS_NUM
41: ,select_yn OKS_PM_ACTIVITIES.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR
42: ,conf_req_yn OKS_PM_ACTIVITIES.CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
43: ,sch_exists_yn OKS_PM_ACTIVITIES.SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR
44: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
45: ,program_id NUMBER := OKC_API.G_MISS_NUM
46: ,program_update_date OKS_PM_ACTIVITIES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 44: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

40: ,activity_id NUMBER := OKC_API.G_MISS_NUM
41: ,select_yn OKS_PM_ACTIVITIES.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR
42: ,conf_req_yn OKS_PM_ACTIVITIES.CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
43: ,sch_exists_yn OKS_PM_ACTIVITIES.SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR
44: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
45: ,program_id NUMBER := OKC_API.G_MISS_NUM
46: ,program_update_date OKS_PM_ACTIVITIES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: ,request_id NUMBER := OKC_API.G_MISS_NUM

Line 45: ,program_id NUMBER := OKC_API.G_MISS_NUM

41: ,select_yn OKS_PM_ACTIVITIES.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR
42: ,conf_req_yn OKS_PM_ACTIVITIES.CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
43: ,sch_exists_yn OKS_PM_ACTIVITIES.SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR
44: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
45: ,program_id NUMBER := OKC_API.G_MISS_NUM
46: ,program_update_date OKS_PM_ACTIVITIES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: ,request_id NUMBER := OKC_API.G_MISS_NUM
49: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 46: ,program_update_date OKS_PM_ACTIVITIES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

42: ,conf_req_yn OKS_PM_ACTIVITIES.CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
43: ,sch_exists_yn OKS_PM_ACTIVITIES.SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR
44: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
45: ,program_id NUMBER := OKC_API.G_MISS_NUM
46: ,program_update_date OKS_PM_ACTIVITIES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: ,request_id NUMBER := OKC_API.G_MISS_NUM
49: ,created_by NUMBER := OKC_API.G_MISS_NUM
50: ,creation_date OKS_PM_ACTIVITIES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

43: ,sch_exists_yn OKS_PM_ACTIVITIES.SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR
44: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
45: ,program_id NUMBER := OKC_API.G_MISS_NUM
46: ,program_update_date OKS_PM_ACTIVITIES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: ,request_id NUMBER := OKC_API.G_MISS_NUM
49: ,created_by NUMBER := OKC_API.G_MISS_NUM
50: ,creation_date OKS_PM_ACTIVITIES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 48: ,request_id NUMBER := OKC_API.G_MISS_NUM

44: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
45: ,program_id NUMBER := OKC_API.G_MISS_NUM
46: ,program_update_date OKS_PM_ACTIVITIES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: ,request_id NUMBER := OKC_API.G_MISS_NUM
49: ,created_by NUMBER := OKC_API.G_MISS_NUM
50: ,creation_date OKS_PM_ACTIVITIES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
52: ,last_update_date OKS_PM_ACTIVITIES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 49: ,created_by NUMBER := OKC_API.G_MISS_NUM

45: ,program_id NUMBER := OKC_API.G_MISS_NUM
46: ,program_update_date OKS_PM_ACTIVITIES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: ,request_id NUMBER := OKC_API.G_MISS_NUM
49: ,created_by NUMBER := OKC_API.G_MISS_NUM
50: ,creation_date OKS_PM_ACTIVITIES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
52: ,last_update_date OKS_PM_ACTIVITIES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 50: ,creation_date OKS_PM_ACTIVITIES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

46: ,program_update_date OKS_PM_ACTIVITIES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: ,request_id NUMBER := OKC_API.G_MISS_NUM
49: ,created_by NUMBER := OKC_API.G_MISS_NUM
50: ,creation_date OKS_PM_ACTIVITIES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
52: ,last_update_date OKS_PM_ACTIVITIES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
54: -- R12 Data Model Changes 4485150 Start

Line 51: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: ,request_id NUMBER := OKC_API.G_MISS_NUM
49: ,created_by NUMBER := OKC_API.G_MISS_NUM
50: ,creation_date OKS_PM_ACTIVITIES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
52: ,last_update_date OKS_PM_ACTIVITIES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
54: -- R12 Data Model Changes 4485150 Start
55: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM

Line 52: ,last_update_date OKS_PM_ACTIVITIES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

48: ,request_id NUMBER := OKC_API.G_MISS_NUM
49: ,created_by NUMBER := OKC_API.G_MISS_NUM
50: ,creation_date OKS_PM_ACTIVITIES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
52: ,last_update_date OKS_PM_ACTIVITIES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
54: -- R12 Data Model Changes 4485150 Start
55: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
56: ,orig_system_reference1 OKS_PM_ACTIVITIES.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR

Line 53: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

49: ,created_by NUMBER := OKC_API.G_MISS_NUM
50: ,creation_date OKS_PM_ACTIVITIES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
52: ,last_update_date OKS_PM_ACTIVITIES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
54: -- R12 Data Model Changes 4485150 Start
55: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
56: ,orig_system_reference1 OKS_PM_ACTIVITIES.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
57: ,orig_system_source_code OKS_PM_ACTIVITIES.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 55: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM

51: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
52: ,last_update_date OKS_PM_ACTIVITIES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
54: -- R12 Data Model Changes 4485150 Start
55: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
56: ,orig_system_reference1 OKS_PM_ACTIVITIES.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
57: ,orig_system_source_code OKS_PM_ACTIVITIES.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
58: -- R12 Data Model Changes 4485150 End
59: );

Line 56: ,orig_system_reference1 OKS_PM_ACTIVITIES.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR

52: ,last_update_date OKS_PM_ACTIVITIES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
54: -- R12 Data Model Changes 4485150 Start
55: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
56: ,orig_system_reference1 OKS_PM_ACTIVITIES.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
57: ,orig_system_source_code OKS_PM_ACTIVITIES.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
58: -- R12 Data Model Changes 4485150 End
59: );
60: G_MISS_pma_rec pma_rec_type;

Line 57: ,orig_system_source_code OKS_PM_ACTIVITIES.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR

53: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
54: -- R12 Data Model Changes 4485150 Start
55: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
56: ,orig_system_reference1 OKS_PM_ACTIVITIES.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
57: ,orig_system_source_code OKS_PM_ACTIVITIES.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
58: -- R12 Data Model Changes 4485150 End
59: );
60: G_MISS_pma_rec pma_rec_type;
61: TYPE pma_tbl_type IS TABLE OF pma_rec_type

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 99: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

95: PROCEDURE change_version;
96: PROCEDURE api_copy;
97: PROCEDURE insert_row(
98: p_api_version IN NUMBER,
99: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
102: x_msg_data OUT NOCOPY VARCHAR2,
103: p_pmav_rec IN pmav_rec_type,

Line 107: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

103: p_pmav_rec IN pmav_rec_type,
104: x_pmav_rec OUT NOCOPY pmav_rec_type);
105: PROCEDURE insert_row(
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2,
111: p_pmav_tbl IN pmav_tbl_type,

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

109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2,
111: p_pmav_tbl IN pmav_tbl_type,
112: x_pmav_tbl OUT NOCOPY pmav_tbl_type,
113: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
114: PROCEDURE insert_row(
115: p_api_version IN NUMBER,
116: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
117: x_return_status OUT NOCOPY VARCHAR2,

Line 116: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

112: x_pmav_tbl OUT NOCOPY pmav_tbl_type,
113: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
114: PROCEDURE insert_row(
115: p_api_version IN NUMBER,
116: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_pmav_tbl IN pmav_tbl_type,

Line 124: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

120: p_pmav_tbl IN pmav_tbl_type,
121: x_pmav_tbl OUT NOCOPY pmav_tbl_type);
122: PROCEDURE lock_row(
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_pmav_rec IN pmav_rec_type);

Line 131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_pmav_rec IN pmav_rec_type);
129: PROCEDURE lock_row(
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2,
135: p_pmav_tbl IN pmav_tbl_type,

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

132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2,
135: p_pmav_tbl IN pmav_tbl_type,
136: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
137: PROCEDURE lock_row(
138: p_api_version IN NUMBER,
139: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
140: x_return_status OUT NOCOPY VARCHAR2,

Line 139: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

135: p_pmav_tbl IN pmav_tbl_type,
136: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
137: PROCEDURE lock_row(
138: p_api_version IN NUMBER,
139: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_pmav_tbl IN pmav_tbl_type);

Line 146: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_pmav_tbl IN pmav_tbl_type);
144: PROCEDURE update_row(
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2,
150: p_pmav_rec IN pmav_rec_type,

Line 154: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

150: p_pmav_rec IN pmav_rec_type,
151: x_pmav_rec OUT NOCOPY pmav_rec_type);
152: PROCEDURE update_row(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_pmav_tbl IN pmav_tbl_type,

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

156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_pmav_tbl IN pmav_tbl_type,
159: x_pmav_tbl OUT NOCOPY pmav_tbl_type,
160: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
161: PROCEDURE update_row(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
164: x_return_status OUT NOCOPY VARCHAR2,

Line 163: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

159: x_pmav_tbl OUT NOCOPY pmav_tbl_type,
160: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
161: PROCEDURE update_row(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_pmav_tbl IN pmav_tbl_type,

Line 171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

167: p_pmav_tbl IN pmav_tbl_type,
168: x_pmav_tbl OUT NOCOPY pmav_tbl_type);
169: PROCEDURE delete_row(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_pmav_rec IN pmav_rec_type);

Line 178: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_pmav_rec IN pmav_rec_type);
176: PROCEDURE delete_row(
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_pmav_tbl IN pmav_tbl_type,

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

179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_pmav_tbl IN pmav_tbl_type,
183: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
184: PROCEDURE delete_row(
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
187: x_return_status OUT NOCOPY VARCHAR2,

Line 186: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

182: p_pmav_tbl IN pmav_tbl_type,
183: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
184: PROCEDURE delete_row(
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,
189: x_msg_data OUT NOCOPY VARCHAR2,
190: p_pmav_tbl IN pmav_tbl_type);

Line 193: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

189: x_msg_data OUT NOCOPY VARCHAR2,
190: p_pmav_tbl IN pmav_tbl_type);
191: PROCEDURE validate_row(
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_pmav_rec IN pmav_rec_type);

Line 200: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_pmav_rec IN pmav_rec_type);
198: PROCEDURE validate_row(
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
201: x_return_status OUT NOCOPY VARCHAR2,
202: x_msg_count OUT NOCOPY NUMBER,
203: x_msg_data OUT NOCOPY VARCHAR2,
204: p_pmav_tbl IN pmav_tbl_type,

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

201: x_return_status OUT NOCOPY VARCHAR2,
202: x_msg_count OUT NOCOPY NUMBER,
203: x_msg_data OUT NOCOPY VARCHAR2,
204: p_pmav_tbl IN pmav_tbl_type,
205: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
206: PROCEDURE validate_row(
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
209: x_return_status OUT NOCOPY VARCHAR2,

Line 208: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

204: p_pmav_tbl IN pmav_tbl_type,
205: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
206: PROCEDURE validate_row(
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,
212: p_pmav_tbl IN pmav_tbl_type);