[Home] [Help]
PACKAGE: APPS.EAM_CONSTRUCTION_UNIT_PUB
Source
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
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
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 );
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
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
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
48 PROCEDURE create_construction_unit(
49 p_api_version IN NUMBER
50 ,p_commit IN VARCHAR2
51 ,p_cu_rec IN CU_rec
52 ,p_cu_activity_tbl IN CU_Activity_tbl
53 ,x_cu_id OUT NOCOPY NUMBER
54 ,x_return_status OUT NOCOPY VARCHAR2
55 ,x_msg_count OUT NOCOPY NUMBER
56 ,x_msg_data OUT NOCOPY VARCHAR2
57 );
58
59 PROCEDURE update_construction_unit(
60 p_api_version IN NUMBER
61 ,p_commit IN VARCHAR2
62 ,p_cu_rec IN EAM_CONSTRUCTION_UNIT_PUB.CU_rec
63 ,p_cu_activity_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl
64 ,x_cu_id OUT NOCOPY NUMBER
65 ,x_return_status OUT NOCOPY VARCHAR2
66 ,x_msg_count OUT NOCOPY NUMBER
67 ,x_msg_data OUT NOCOPY VARCHAR2
68 );
69
70 PROCEDURE copy_construction_unit(
71 p_api_version IN NUMBER
72 ,p_commit IN VARCHAR2
73 ,p_cu_rec IN EAM_CONSTRUCTION_UNIT_PUB.CU_rec
74 ,p_cu_activity_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl
75 ,p_source_cu_id_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_ID_tbl
76 ,x_cu_id OUT NOCOPY NUMBER
77 ,x_return_status OUT NOCOPY VARCHAR2
78 ,x_msg_count OUT NOCOPY NUMBER
79 ,x_msg_data OUT NOCOPY VARCHAR2
80 );
81
82 End EAM_CONSTRUCTION_UNIT_PUB;