1 PACKAGE EAM_CONSTRUCTION_EST_PUB AS
2 /* $Header: EAMPCESS.pls 120.0.12010000.3 2008/12/09 21:08:56 devijay noship $ */
3 -- Start of Comments
4 -- Package name : EAM_CONSTRUCTION_EST_PUB
5 -- Purpose : Spec of package EAM_CONSTRUCTION_EST_PUB
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE EXPLODE_INITIAL_ESTIMATE(
11 p_api_version IN NUMBER := 1.0
12 , p_init_msg_list IN VARCHAR2 := 'F'
13 , p_commit IN VARCHAR2
14 , p_estimate_id IN NUMBER
15 , x_ce_msg_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_MESSAGE_TBL
16 , x_return_status OUT NOCOPY VARCHAR2
17 , x_msg_count OUT NOCOPY NUMBER
18 , x_msg_data OUT NOCOPY VARCHAR2);
19
20 PROCEDURE INSERT_ALL_WO_LINES(
21 p_api_version IN NUMBER := 1.0
22 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
23 , p_commit IN VARCHAR2
24 , p_estimate_id IN NUMBER
25 , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
26 , x_return_status OUT NOCOPY VARCHAR2
27 , x_msg_count OUT NOCOPY NUMBER
28 , x_msg_data OUT NOCOPY VARCHAR2
29 );
30
31 PROCEDURE INSERT_PARENT_WO_LINE(
32 p_api_version IN NUMBER := 1.0
33 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
34 , p_commit IN VARCHAR2
35 , p_estimate_id IN NUMBER
36 , p_parent_wo_line_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_PARENT_WO_REC
37 , x_return_status OUT NOCOPY VARCHAR2
38 , x_msg_count OUT NOCOPY NUMBER
39 , x_msg_data OUT NOCOPY VARCHAR2
40 );
41
42 PROCEDURE DELETE_WO_LINE(
43 p_api_version IN NUMBER := 1.0
44 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
45 , p_commit IN VARCHAR2
46 , p_work_order_line_id IN NUMBER
47 , x_return_status OUT NOCOPY VARCHAR2
48 , x_msg_count OUT NOCOPY NUMBER
49 , x_msg_data OUT NOCOPY VARCHAR2
50 );
51
52 PROCEDURE CREATE_CU_WORKORDERS(
53 p_api_version IN NUMBER := 1.0
54 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
55 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
56 ,p_estimate_id IN NUMBER
57 ,x_return_status OUT NOCOPY VARCHAR2
58 ,x_msg_count OUT NOCOPY NUMBER
59 ,x_msg_data OUT NOCOPY VARCHAR2
60 ,p_organization_id IN NUMBER
61 ,p_debug_filename IN VARCHAR2 := 'EAM_CU_DEBUG.log'
62 ,p_debug_file_mode IN VARCHAR2 := 'w'
63 );
64
65 PROCEDURE GET_CU_RECS(
66 p_api_version IN NUMBER,
67 p_commit IN VARCHAR2,
68 p_init_msg_list IN VARCHAR2,
69 p_validation_level IN NUMBER,
70 p_org_id IN NUMBER,
71 px_cu_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_UNITS_TBL,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2
75 );
76
77 PROCEDURE GET_CU_ACTIVITIES(
78 p_api_version IN NUMBER,
79 p_commit IN VARCHAR2,
80 p_init_msg_list IN VARCHAR2,
81 p_validation_level IN NUMBER,
82 p_cu_id IN NUMBER,
83 x_activities_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_TBL,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2
87 );
88
89 PROCEDURE CREATE_ESTIMATE(
90 p_api_version IN NUMBER,
91 p_commit IN VARCHAR2,
92 p_init_msg_list IN VARCHAR2,
93 p_validation_level IN NUMBER,
94 px_estimate_rec IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2
98 );
99
100 PROCEDURE UPDATE_ESTIMATE(
101 p_api_version IN NUMBER,
102 p_commit IN VARCHAR2,
103 p_init_msg_list IN VARCHAR2,
104 p_validation_level IN NUMBER,
105 p_estimate_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2
109 );
110
111 PROCEDURE SET_ACTIVITIES_FOR_CE(
112 p_api_version IN NUMBER,
113 p_commit IN VARCHAR2,
114 p_init_msg_list IN VARCHAR2,
115 p_validation_level IN NUMBER,
116 p_ce_id IN NUMBER,
117 px_activities_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_TBL,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2
121 );
122
123 PROCEDURE UPDATE_CE_WO_LNS_BY_GROUP_OPT(
124 p_api_version IN NUMBER,
125 p_commit IN VARCHAR2,
126 p_init_msg_list IN VARCHAR2,
127 p_validation_level IN NUMBER,
128 p_ce_wo_defaults IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WO_DEFAULTS_REC,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2
132 );
133
134 PROCEDURE COPY_EST_WORKBENCH(
135 p_api_version IN NUMBER := 1.0
136 , p_init_msg_list IN VARCHAR2 := 'F'
137 , p_commit IN VARCHAR2
138 , p_src_estimate_id IN NUMBER
139 , p_org_id IN NUMBER
140 , p_cpy_estimate_id OUT NOCOPY NUMBER
141 , x_return_status OUT NOCOPY VARCHAR2
142 , x_msg_count OUT NOCOPY NUMBER
143 , x_msg_data OUT NOCOPY VARCHAR2
144 );
145
146 End EAM_CONSTRUCTION_EST_PUB;