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
47: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
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
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
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
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
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
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
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
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);
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
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:
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
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(
113: PROCEDURE POPULATE_WO(
114: p_parent_wo IN NUMBER
115: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
116: , p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
117: , x_eam_wo_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_WO_REC_TYPE
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 POPULATE_OPERATION(
124: p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
125: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
126: , x_eam_op_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_OP_REC_TYPE
127: , x_return_status OUT NOCOPY VARCHAR2
128: , x_msg_count OUT NOCOPY NUMBER
129: , x_msg_data OUT NOCOPY VARCHAR2
130: );
131:
132: PROCEDURE POPULATE_RESOURCE(
133: p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
134: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
135: , x_eam_res_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_RES_REC_TYPE
136: , x_return_status OUT NOCOPY VARCHAR2
137: , x_msg_count OUT NOCOPY NUMBER
138: , x_msg_data OUT NOCOPY VARCHAR2
139: );
140:
141: PROCEDURE POPULATE_MATERIAL(
142: p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
143: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
144: , x_eam_mat_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_MAT_REQ_REC_TYPE
145: , x_eam_direct_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_REC_TYPE
146: , x_return_status OUT NOCOPY VARCHAR2
147: , x_msg_count OUT NOCOPY NUMBER
148: , x_msg_data OUT NOCOPY VARCHAR2
141: PROCEDURE POPULATE_MATERIAL(
142: p_ce_line_rec IN EAM_CE_WORK_ORDER_LINES%ROWTYPE
143: , p_init_msg_list VARCHAR2 := FND_API.G_FALSE
144: , x_eam_mat_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_MAT_REQ_REC_TYPE
145: , x_eam_direct_rec IN OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_DIRECT_ITEMS_REC_TYPE
146: , x_return_status OUT NOCOPY VARCHAR2
147: , x_msg_count OUT NOCOPY NUMBER
148: , x_msg_data OUT NOCOPY VARCHAR2
149: );
147: , x_msg_count OUT NOCOPY NUMBER
148: , x_msg_data OUT NOCOPY VARCHAR2
149: );
150:
151: FUNCTION INIT_EAM_OP_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_tbl_type;
152:
153: FUNCTION INIT_EAM_OP_NTK_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
154:
155: FUNCTION INIT_EAM_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_tbl_type;
149: );
150:
151: FUNCTION INIT_EAM_OP_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_tbl_type;
152:
153: FUNCTION INIT_EAM_OP_NTK_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
154:
155: FUNCTION INIT_EAM_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_tbl_type;
156:
157: FUNCTION INIT_EAM_RES_INST_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
151: FUNCTION INIT_EAM_OP_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_tbl_type;
152:
153: FUNCTION INIT_EAM_OP_NTK_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
154:
155: FUNCTION INIT_EAM_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_tbl_type;
156:
157: FUNCTION INIT_EAM_RES_INST_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
158:
159: FUNCTION INIT_EAM_SUB_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
153: FUNCTION INIT_EAM_OP_NTK_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
154:
155: FUNCTION INIT_EAM_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_tbl_type;
156:
157: FUNCTION INIT_EAM_RES_INST_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
158:
159: FUNCTION INIT_EAM_SUB_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
160:
161: FUNCTION INIT_EAM_RES_USG_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
155: FUNCTION INIT_EAM_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_tbl_type;
156:
157: FUNCTION INIT_EAM_RES_INST_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
158:
159: FUNCTION INIT_EAM_SUB_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
160:
161: FUNCTION INIT_EAM_RES_USG_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
162:
163: FUNCTION INIT_EAM_MAT_REQ_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
157: FUNCTION INIT_EAM_RES_INST_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
158:
159: FUNCTION INIT_EAM_SUB_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
160:
161: FUNCTION INIT_EAM_RES_USG_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
162:
163: FUNCTION INIT_EAM_MAT_REQ_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
164:
165: PROCEDURE GET_CU_RECS(
159: FUNCTION INIT_EAM_SUB_RES_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
160:
161: FUNCTION INIT_EAM_RES_USG_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
162:
163: FUNCTION INIT_EAM_MAT_REQ_TBL_TYPE RETURN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
164:
165: PROCEDURE GET_CU_RECS(
166: p_api_version IN NUMBER,
167: p_commit IN VARCHAR2,