1: PACKAGE EAM_CONSTRUCTION_UNIT_PUB AUTHID CURRENT_USER as
2: /* $Header: EAMPCUS.pls 120.1 2010/10/13 11:34:13 somitra noship $*/
3:
4: TYPE CU_rec IS RECORD(
5: CU_ID NUMBER := FND_API.G_MISS_NUM
6: ,CU_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
7: ,DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR
8: ,ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM
9: ,CU_EFFECTIVE_FROM DATE := FND_API.G_MISS_DATE
2: /* $Header: EAMPCUS.pls 120.1 2010/10/13 11:34:13 somitra noship $*/
3:
4: TYPE CU_rec IS RECORD(
5: CU_ID NUMBER := FND_API.G_MISS_NUM
6: ,CU_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
7: ,DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR
8: ,ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM
9: ,CU_EFFECTIVE_FROM DATE := FND_API.G_MISS_DATE
10: ,CU_EFFECTIVE_TO DATE := FND_API.G_MISS_DATE
3:
4: TYPE CU_rec IS RECORD(
5: CU_ID NUMBER := FND_API.G_MISS_NUM
6: ,CU_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
7: ,DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR
8: ,ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM
9: ,CU_EFFECTIVE_FROM DATE := FND_API.G_MISS_DATE
10: ,CU_EFFECTIVE_TO DATE := FND_API.G_MISS_DATE
11: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
4: TYPE CU_rec IS RECORD(
5: CU_ID NUMBER := FND_API.G_MISS_NUM
6: ,CU_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
7: ,DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR
8: ,ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM
9: ,CU_EFFECTIVE_FROM DATE := FND_API.G_MISS_DATE
10: ,CU_EFFECTIVE_TO DATE := FND_API.G_MISS_DATE
11: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
12: ,ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
5: CU_ID NUMBER := FND_API.G_MISS_NUM
6: ,CU_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
7: ,DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR
8: ,ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM
9: ,CU_EFFECTIVE_FROM DATE := FND_API.G_MISS_DATE
10: ,CU_EFFECTIVE_TO DATE := FND_API.G_MISS_DATE
11: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
12: ,ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: ,ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
6: ,CU_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
7: ,DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR
8: ,ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM
9: ,CU_EFFECTIVE_FROM DATE := FND_API.G_MISS_DATE
10: ,CU_EFFECTIVE_TO DATE := FND_API.G_MISS_DATE
11: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
12: ,ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: ,ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: ,ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
7: ,DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR
8: ,ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM
9: ,CU_EFFECTIVE_FROM DATE := FND_API.G_MISS_DATE
10: ,CU_EFFECTIVE_TO DATE := FND_API.G_MISS_DATE
11: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
12: ,ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: ,ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: ,ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: ,ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
8: ,ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM
9: ,CU_EFFECTIVE_FROM DATE := FND_API.G_MISS_DATE
10: ,CU_EFFECTIVE_TO DATE := FND_API.G_MISS_DATE
11: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
12: ,ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: ,ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: ,ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: ,ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: ,ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
9: ,CU_EFFECTIVE_FROM DATE := FND_API.G_MISS_DATE
10: ,CU_EFFECTIVE_TO DATE := FND_API.G_MISS_DATE
11: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
12: ,ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: ,ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: ,ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: ,ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: ,ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: ,ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
10: ,CU_EFFECTIVE_TO DATE := FND_API.G_MISS_DATE
11: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
12: ,ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: ,ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: ,ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: ,ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: ,ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: ,ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: ,ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
11: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
12: ,ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: ,ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: ,ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: ,ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: ,ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: ,ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: ,ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: ,ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
12: ,ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: ,ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: ,ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: ,ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: ,ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: ,ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: ,ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: ,ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: ,ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: ,ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: ,ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: ,ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: ,ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: ,ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: ,ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: ,ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: ,ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: ,ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: ,ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: ,ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: ,ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: ,ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: ,ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: ,ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: ,ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: ,ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: ,ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: ,ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: ,ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: ,ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: ,ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: ,ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: ,ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: ,ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: ,ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: ,ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: ,ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: ,ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: ,ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: ,ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: ,ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: ,ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: ,ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: ,ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: ,ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: ,ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: ,ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: ,ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: ,ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: ,ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: ,ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: ,ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: ,ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: ,ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: ,ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: ,ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: ,ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: ,ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: ,ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: ,ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: ,ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: ,ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: ,ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: ,ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: ,ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: ,ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: ,ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: ,ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: ,ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: ,ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: ,ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: );
20: ,ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: ,ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: ,ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: ,ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: ,ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: ,ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: ,ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: );
28:
21: ,ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: ,ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: ,ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: ,ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: ,ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: ,ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: );
28:
29: TYPE CU_Activity_rec IS RECORD(
22: ,ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: ,ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: ,ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: ,ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: ,ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: );
28:
29: TYPE CU_Activity_rec IS RECORD(
30: CU_DETAIL_ID NUMBER := FND_API.G_MISS_NUM
26: ,ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: );
28:
29: TYPE CU_Activity_rec IS RECORD(
30: CU_DETAIL_ID NUMBER := FND_API.G_MISS_NUM
31: ,CU_ID NUMBER := FND_API.G_MISS_NUM
32: ,ACCT_CLASS_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
33: ,ACTIVITY_ID NUMBER := FND_API.G_MISS_NUM
34: ,CU_ACTIVITY_QTY NUMBER := FND_API.G_MISS_NUM
27: );
28:
29: TYPE CU_Activity_rec IS RECORD(
30: CU_DETAIL_ID NUMBER := FND_API.G_MISS_NUM
31: ,CU_ID NUMBER := FND_API.G_MISS_NUM
32: ,ACCT_CLASS_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
33: ,ACTIVITY_ID NUMBER := FND_API.G_MISS_NUM
34: ,CU_ACTIVITY_QTY NUMBER := FND_API.G_MISS_NUM
35: ,CU_ACTIVITY_EFFECTIVE_FROM DATE := FND_API.G_MISS_DATE
28:
29: TYPE CU_Activity_rec IS RECORD(
30: CU_DETAIL_ID NUMBER := FND_API.G_MISS_NUM
31: ,CU_ID NUMBER := FND_API.G_MISS_NUM
32: ,ACCT_CLASS_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
33: ,ACTIVITY_ID NUMBER := FND_API.G_MISS_NUM
34: ,CU_ACTIVITY_QTY NUMBER := FND_API.G_MISS_NUM
35: ,CU_ACTIVITY_EFFECTIVE_FROM DATE := FND_API.G_MISS_DATE
36: ,CU_ACTIVITY_EFFECTIVE_TO DATE := FND_API.G_MISS_DATE
29: TYPE CU_Activity_rec IS RECORD(
30: CU_DETAIL_ID NUMBER := FND_API.G_MISS_NUM
31: ,CU_ID NUMBER := FND_API.G_MISS_NUM
32: ,ACCT_CLASS_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
33: ,ACTIVITY_ID NUMBER := FND_API.G_MISS_NUM
34: ,CU_ACTIVITY_QTY NUMBER := FND_API.G_MISS_NUM
35: ,CU_ACTIVITY_EFFECTIVE_FROM DATE := FND_API.G_MISS_DATE
36: ,CU_ACTIVITY_EFFECTIVE_TO DATE := FND_API.G_MISS_DATE
37: ,CU_ASSIGN_TO_ORG VARCHAR2(2) := FND_API.G_MISS_CHAR
30: CU_DETAIL_ID NUMBER := FND_API.G_MISS_NUM
31: ,CU_ID NUMBER := FND_API.G_MISS_NUM
32: ,ACCT_CLASS_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
33: ,ACTIVITY_ID NUMBER := FND_API.G_MISS_NUM
34: ,CU_ACTIVITY_QTY NUMBER := FND_API.G_MISS_NUM
35: ,CU_ACTIVITY_EFFECTIVE_FROM DATE := FND_API.G_MISS_DATE
36: ,CU_ACTIVITY_EFFECTIVE_TO DATE := FND_API.G_MISS_DATE
37: ,CU_ASSIGN_TO_ORG VARCHAR2(2) := FND_API.G_MISS_CHAR
38: );
31: ,CU_ID NUMBER := FND_API.G_MISS_NUM
32: ,ACCT_CLASS_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
33: ,ACTIVITY_ID NUMBER := FND_API.G_MISS_NUM
34: ,CU_ACTIVITY_QTY NUMBER := FND_API.G_MISS_NUM
35: ,CU_ACTIVITY_EFFECTIVE_FROM DATE := FND_API.G_MISS_DATE
36: ,CU_ACTIVITY_EFFECTIVE_TO DATE := FND_API.G_MISS_DATE
37: ,CU_ASSIGN_TO_ORG VARCHAR2(2) := FND_API.G_MISS_CHAR
38: );
39: TYPE CU_Activity_tbl IS TABLE OF CU_Activity_rec
32: ,ACCT_CLASS_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
33: ,ACTIVITY_ID NUMBER := FND_API.G_MISS_NUM
34: ,CU_ACTIVITY_QTY NUMBER := FND_API.G_MISS_NUM
35: ,CU_ACTIVITY_EFFECTIVE_FROM DATE := FND_API.G_MISS_DATE
36: ,CU_ACTIVITY_EFFECTIVE_TO DATE := FND_API.G_MISS_DATE
37: ,CU_ASSIGN_TO_ORG VARCHAR2(2) := FND_API.G_MISS_CHAR
38: );
39: TYPE CU_Activity_tbl IS TABLE OF CU_Activity_rec
40: INDEX BY BINARY_INTEGER;
33: ,ACTIVITY_ID NUMBER := FND_API.G_MISS_NUM
34: ,CU_ACTIVITY_QTY NUMBER := FND_API.G_MISS_NUM
35: ,CU_ACTIVITY_EFFECTIVE_FROM DATE := FND_API.G_MISS_DATE
36: ,CU_ACTIVITY_EFFECTIVE_TO DATE := FND_API.G_MISS_DATE
37: ,CU_ASSIGN_TO_ORG VARCHAR2(2) := FND_API.G_MISS_CHAR
38: );
39: TYPE CU_Activity_tbl IS TABLE OF CU_Activity_rec
40: INDEX BY BINARY_INTEGER;
41:
39: TYPE CU_Activity_tbl IS TABLE OF CU_Activity_rec
40: INDEX BY BINARY_INTEGER;
41:
42: TYPE CU_ID_rec IS RECORD(
43: CU_ID NUMBER := FND_API.G_MISS_NUM
44: );
45:
46: TYPE CU_ID_tbl IS TABLE OF CU_ID_rec INDEX BY BINARY_INTEGER;
47: