DBA Data[Home] [Help]

APPS.EAM_CONSTRUCTION_EST_PVT dependencies on EAM_EST_DATASTRUCTURES_PUB

Line 15: , x_ce_msg_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_MESSAGE_TBL

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: );

Line 23: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL

19: );
20:
21: PROCEDURE EXPLODE_CE_ACTIVITIES(
22: p_estimate_id IN NUMBER
23: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
24: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
25: , x_ce_msg_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_MESSAGE_TBL
26: , x_return_status OUT NOCOPY VARCHAR2);
27:

Line 24: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL

20:
21: PROCEDURE EXPLODE_CE_ACTIVITIES(
22: p_estimate_id IN NUMBER
23: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
24: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
25: , x_ce_msg_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_MESSAGE_TBL
26: , x_return_status OUT NOCOPY VARCHAR2);
27:
28: PROCEDURE EXPLODE_STD_OP(

Line 25: , x_ce_msg_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_MESSAGE_TBL

21: PROCEDURE EXPLODE_CE_ACTIVITIES(
22: p_estimate_id IN NUMBER
23: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
24: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
25: , x_ce_msg_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_MESSAGE_TBL
26: , x_return_status OUT NOCOPY VARCHAR2);
27:
28: PROCEDURE EXPLODE_STD_OP(
29: p_std_op_id IN NUMBER

Line 41: , p_ce_associatin_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC

37: );
38:
39: PROCEDURE POPULATE_CE_WORK_ORDER_LINES(
40: p_estimate_id IN NUMBER
41: , p_ce_associatin_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC
42: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
43: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
44: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
45: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type

Line 42: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL

38:
39: PROCEDURE POPULATE_CE_WORK_ORDER_LINES(
40: p_estimate_id IN NUMBER
41: , p_ce_associatin_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_REC
42: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
43: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
44: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
45: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
46: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type

Line 50: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL

46: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
47: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
48: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
49: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
50: , x_eam_ce_wo_lines_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
51: , x_return_status OUT NOCOPY VARCHAR2);
52:
53: PROCEDURE INSERT_PARENT_WO_LINE(
54: p_api_version IN NUMBER := 1.0

Line 58: , p_parent_wo_line_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_PARENT_WO_REC

54: p_api_version IN NUMBER := 1.0
55: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
56: , p_commit IN VARCHAR2
57: , p_estimate_id IN NUMBER
58: , p_parent_wo_line_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_PARENT_WO_REC
59: , x_return_status OUT NOCOPY VARCHAR2
60: , x_msg_count OUT NOCOPY NUMBER
61: , x_msg_data OUT NOCOPY VARCHAR2
62: );

Line 79: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL

75: p_api_version IN NUMBER := 1.0
76: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
77: , p_commit IN VARCHAR2
78: , p_estimate_id IN NUMBER
79: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
80: , x_return_status OUT NOCOPY VARCHAR2
81: , x_msg_count OUT NOCOPY NUMBER
82: , x_msg_data OUT NOCOPY VARCHAR2
83: );

Line 171: px_cu_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_UNITS_TBL,

167: p_commit IN VARCHAR2,
168: p_init_msg_list IN VARCHAR2,
169: p_validation_level IN NUMBER,
170: p_org_id IN NUMBER,
171: px_cu_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_UNITS_TBL,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2
175: );

Line 183: x_activities_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_TBL,

179: p_commit IN VARCHAR2,
180: p_init_msg_list IN VARCHAR2,
181: p_validation_level IN NUMBER,
182: p_cu_id IN NUMBER,
183: x_activities_tbl OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_TBL,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2
187: );

Line 194: px_estimate_rec IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC,

190: p_api_version IN NUMBER,
191: p_commit IN VARCHAR2,
192: p_init_msg_list IN VARCHAR2,
193: p_validation_level IN NUMBER,
194: px_estimate_rec IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2
198: );

Line 205: p_estimate_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC,

201: p_api_version IN NUMBER,
202: p_commit IN VARCHAR2,
203: p_init_msg_list IN VARCHAR2,
204: p_validation_level IN NUMBER,
205: p_estimate_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC,
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
208: x_msg_data OUT NOCOPY VARCHAR2
209: );

Line 217: px_activities_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_TBL,

213: p_commit IN VARCHAR2,
214: p_init_msg_list IN VARCHAR2,
215: p_validation_level IN NUMBER,
216: p_ce_id IN NUMBER,
217: px_activities_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_ESTIMATE_ASSOCIATIONS_TBL,
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2
221: );

Line 228: p_ce_wo_defaults IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WO_DEFAULTS_REC,

224: p_api_version IN NUMBER,
225: p_commit IN VARCHAR2,
226: p_init_msg_list IN VARCHAR2,
227: p_validation_level IN NUMBER,
228: p_ce_wo_defaults IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WO_DEFAULTS_REC,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
231: x_msg_data OUT NOCOPY VARCHAR2
232: );