DBA Data[Home] [Help]

APPS.EAM_CONSTRUCTION_EST_PVT dependencies on EAM_CE_WORK_ORDER_LINES_PKG

Line 286: EAM_CE_WORK_ORDER_LINES_PKG.DELETE_ROW(

282: --FND_MSG_PUB.ADD;
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;
285:
286: EAM_CE_WORK_ORDER_LINES_PKG.DELETE_ROW(
287: p_work_order_line_id => p_work_order_line_id
288: );
289:
290: IF NVL(p_commit,'F') = 'T' THEN

Line 404: EAM_CE_WORK_ORDER_LINES_PKG.UPDATE_ROW(

400: AND NVL(l_estimate_parent_rec.CREATE_PARENT_WO_FLAG,'N') <> 'N' THEN
401:
402: l_wo_line_id_seq := l_estimate_parent_rec.PARENT_WO_ID;
403:
404: EAM_CE_WORK_ORDER_LINES_PKG.UPDATE_ROW(
405: p_estimate_work_order_line_id => l_wo_line_id_seq
406: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
407: ,p_src_cu_id => FND_API.G_MISS_NUM
408: ,p_src_activity_id => FND_API.G_MISS_NUM

Line 483: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(

479: ELSE
480:
481: SELECT EAM_CE_WORK_ORDER_LINES_S.NEXTVAL INTO l_wo_line_id_seq FROM DUAL;
482:
483: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
484: p_estimate_work_order_line_id => l_wo_line_id_seq
485: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
486: ,p_src_cu_id => FND_API.G_MISS_NUM
487: ,p_src_activity_id => FND_API.G_MISS_NUM

Line 640: EAM_CE_WORK_ORDER_LINES_PKG.DELETE_ROW (

636: -- If the create work order flag has been switched from Y to N
637: -- then delete the work order line created when the flag was Y
638: IF NVL(l_estimate_parent_rec.CREATE_PARENT_WO_FLAG,'N') = 'Y' AND
639: NVL(l_estimate_parent_rec.PARENT_WO_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
640: EAM_CE_WORK_ORDER_LINES_PKG.DELETE_ROW (
641: p_work_order_line_id => l_estimate_parent_rec.PARENT_WO_ID
642: );
643: END IF; -- NVL(l_estimate_parent_rec.CREATE_PARENT_WO_FLAG,'N') = 'Y'
644: ELSE

Line 680: EAM_CE_WORK_ORDER_LINES_PKG.DELETE_ROW (

676: );
677:
678: IF NVL(l_estimate_parent_rec.CREATE_PARENT_WO_FLAG,'N') = 'Y' AND
679: NVL(l_estimate_parent_rec.PARENT_WO_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
680: EAM_CE_WORK_ORDER_LINES_PKG.DELETE_ROW (
681: p_work_order_line_id => l_estimate_parent_rec.PARENT_WO_ID
682: );
683: END IF;
684: END IF;

Line 820: -- Call EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW

816: RAISE FND_API.G_EXC_ERROR;
817: END IF; -- nvl(l_return_status,'S') <> 'S'
818: END IF;
819:
820: -- Call EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW
821: -- to insert wo line row
822:
823: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
824: p_estimate_work_order_line_id => NULL

Line 823: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(

819:
820: -- Call EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW
821: -- to insert wo line row
822:
823: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
824: p_estimate_work_order_line_id => NULL
825: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
826: ,p_src_cu_id => NULL
827: ,p_src_activity_id => NULL

Line 1003: EAM_CE_WORK_ORDER_LINES_PKG.DELETE_ALL_WITH_ESTIMATE_ID(

999: -- When new set of work order lines are being estimated
1000: -- The old WO lines needs to be deleted
1001: -- None of these operations are committed until saved
1002: --
1003: EAM_CE_WORK_ORDER_LINES_PKG.DELETE_ALL_WITH_ESTIMATE_ID(
1004: p_estimate_id => p_estimate_id
1005: );
1006: */
1007: -- If the p_estimate_work_order_line_id exists then update the

Line 1051: EAM_CE_WORK_ORDER_LINES_PKG.UPDATE_ROW(

1047: l_system_status_rec.SYSTEM_STATUS := p_eam_ce_wo_lines_tbl(l_ce_tab_index).USER_DEFINED_STATUS_ID;
1048: END;
1049:
1050: -- Call UPDATE_ROW TO update the changes
1051: EAM_CE_WORK_ORDER_LINES_PKG.UPDATE_ROW(
1052: p_estimate_work_order_line_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ESTIMATE_WORK_ORDER_LINE_ID
1053: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
1054: ,p_src_cu_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_CU_ID
1055: ,p_src_activity_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_ACTIVITY_ID

Line 1160: -- Call EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW

1156: WHEN OTHERS THEN
1157: l_system_status_rec.SYSTEM_STATUS := p_eam_ce_wo_lines_tbl(l_ce_tab_index).USER_DEFINED_STATUS_ID;
1158: END;
1159:
1160: -- Call EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW
1161: -- to insert wo line row
1162:
1163: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
1164: p_estimate_work_order_line_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ESTIMATE_WORK_ORDER_LINE_ID

Line 1163: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(

1159:
1160: -- Call EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW
1161: -- to insert wo line row
1162:
1163: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
1164: p_estimate_work_order_line_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ESTIMATE_WORK_ORDER_LINE_ID
1165: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
1166: ,p_src_cu_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_CU_ID
1167: ,p_src_activity_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_ACTIVITY_ID

Line 1709: -- EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW

1705: END IF; -- l_op_tbl_count > 0
1706:
1707: -- This block populates the common attributes for all the work order lines
1708: -- Also once all the attribute are populated, it calles
1709: -- EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW
1710: /* IF l_wo_ind > 0 THEN
1711: FOR l_ce_tab_index IN l_eam_ce_wo_lines_tbl.FIRST .. l_eam_ce_wo_lines_tbl.LAST
1712: LOOP
1713:

Line 3352: EAM_CE_WORK_ORDER_LINES_PKG.UPDATE_ROW(

3348:
3349: --Now update the wo lines
3350: IF l_ce_wo_ln_tbl.COUNT > 0 THEN
3351: FOR i IN l_ce_wo_ln_tbl.FIRST..l_ce_wo_ln_tbl.LAST LOOP
3352: EAM_CE_WORK_ORDER_LINES_PKG.UPDATE_ROW(
3353: p_estimate_work_order_line_id => l_ce_wo_ln_tbl(i).ESTIMATE_WORK_ORDER_LINE_ID,
3354: p_estimate_work_order_id => FND_API.G_MISS_NUM,
3355: p_src_cu_id => l_ce_wo_ln_tbl(i).SRC_CU_ID,
3356: p_src_activity_id => l_ce_wo_ln_tbl(i).SRC_ACTIVITY_ID,

Line 4924: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(

4920: l_parent_estimate_wo_line_id = l_est_workorder_line_rec.ESTIMATE_WORK_ORDER_LINE_ID) THEN
4921:
4922: SELECT EAM_CE_WORK_ORDER_LINES_S.NEXTVAL INTO l_wo_line_id_seq FROM DUAL;
4923:
4924: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
4925: p_estimate_work_order_line_id => l_wo_line_id_seq
4926: ,p_estimate_work_order_id => NULL
4927: ,p_src_cu_id => l_est_workorder_line_rec.SRC_CU_ID
4928: ,p_src_activity_id => l_est_workorder_line_rec.SRC_ACTIVITY_ID

Line 5032: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(

5028: p_ATTRIBUTE15 => l_estimate_rec.attribute15
5029: );
5030:
5031: ELSE
5032: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
5033: p_estimate_work_order_line_id => NULL
5034: ,p_estimate_work_order_id => NULL
5035: ,p_src_cu_id => l_est_workorder_line_rec.SRC_CU_ID
5036: ,p_src_activity_id => l_est_workorder_line_rec.SRC_ACTIVITY_ID