DBA Data[Home] [Help]

APPS.OKS_PMA_PVT dependencies on OKS_PM_ACTIVITIES

Line 6: -- OKS_PM_ACTIVITIES_V Record Spec

2: /* $Header: OKSSPMAS.pls 120.1 2005/07/15 09:21:16 parkumar noship $ */
3: ---------------------------------------------------------------------------
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

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 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 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 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 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 35: -- OKS_PM_ACTIVITIES Record Spec

31: );
32: G_MISS_pmav_rec pmav_rec_type;
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

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 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 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 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 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