APPS.EAM_CONSTRUCTION_EST_PUB dependencies on EAM_CE_WORK_ORDER_LINES

Line 109: FROM EAM_CE_WORK_ORDER_LINES

105: WHERE WIP_ENTITY_ID = p_wip_entityid;
106:
107: CURSOR EST_WORKORDERS IS
108: SELECT DISTINCT ESTIMATE_WORK_ORDER_ID
109: FROM EAM_CE_WORK_ORDER_LINES
110: WHERE ESTIMATE_ID = p_estimate_id
111: AND ORGANIZATION_ID = p_organization_id;
112:
113: l_wip_name_rec GET_WOKRODER_NAME%ROWTYPE;

Line 147: -- Update EAM_CE_WORK_ORDER_LINES with the wip entity name

143: OPEN GET_WOKRODER_NAME(l_est_wo_rec.ESTIMATE_WORK_ORDER_ID);
144: FETCH GET_WOKRODER_NAME INTO l_wip_name_rec;
145: CLOSE GET_WOKRODER_NAME;
146:
147: -- Update EAM_CE_WORK_ORDER_LINES with the wip entity name
148: UPDATE EAM_CE_WORK_ORDER_LINES SET WORK_ORDER_NUMBER = l_wip_name_rec.WIP_ENTITY_NAME
149: WHERE ESTIMATE_ID = p_estimate_id
150: AND ORGANIZATION_ID = p_organization_id
151: AND ESTIMATE_WORK_ORDER_ID = l_est_wo_rec.ESTIMATE_WORK_ORDER_ID;

Line 148: UPDATE EAM_CE_WORK_ORDER_LINES SET WORK_ORDER_NUMBER = l_wip_name_rec.WIP_ENTITY_NAME

144: FETCH GET_WOKRODER_NAME INTO l_wip_name_rec;
145: CLOSE GET_WOKRODER_NAME;
146:
147: -- Update EAM_CE_WORK_ORDER_LINES with the wip entity name
148: UPDATE EAM_CE_WORK_ORDER_LINES SET WORK_ORDER_NUMBER = l_wip_name_rec.WIP_ENTITY_NAME
149: WHERE ESTIMATE_ID = p_estimate_id
150: AND ORGANIZATION_ID = p_organization_id
151: AND ESTIMATE_WORK_ORDER_ID = l_est_wo_rec.ESTIMATE_WORK_ORDER_ID;
152:

Line 173: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL

169: p_api_version IN NUMBER := 1.0
170: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
171: , p_commit IN VARCHAR2
172: , p_estimate_id IN NUMBER
173: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
174: , x_return_status OUT NOCOPY VARCHAR2
175: , x_msg_count OUT NOCOPY NUMBER
176: , x_msg_data OUT NOCOPY VARCHAR2)
177: IS