eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_CONSTRUCTION_EST_PVT dependencies on EAM_CE_WORK_ORDER_LINES_PKG

Line 301: EAM_CE_WORK_ORDER_LINES_PKG.DELETE_ROW(

297: --FND_MSG_PUB.ADD;
298: RAISE FND_API.G_EXC_ERROR;
299: END IF;
300:
301: EAM_CE_WORK_ORDER_LINES_PKG.DELETE_ROW(
302: p_work_order_line_id => p_work_order_line_id
303: );
304:
305: IF NVL(p_commit,'F') = 'T' THEN

Line 447: debug(' Updating EAM_CE_WORK_ORDER_LINES_PKG Parent Work Order line - ' || l_wo_line_id_seq);

443: AND NVL(l_estimate_parent_rec.CREATE_PARENT_WO_FLAG,'N') <> 'N' THEN
444:
445: l_wo_line_id_seq := l_estimate_parent_rec.PARENT_WO_ID;
446:
447: debug(' Updating EAM_CE_WORK_ORDER_LINES_PKG Parent Work Order line - ' || l_wo_line_id_seq);
448: EAM_CE_WORK_ORDER_LINES_PKG.UPDATE_ROW(
449: p_estimate_work_order_line_id => l_wo_line_id_seq
450: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
451: ,p_src_cu_id => FND_API.G_MISS_NUM

Line 448: EAM_CE_WORK_ORDER_LINES_PKG.UPDATE_ROW(

444:
445: l_wo_line_id_seq := l_estimate_parent_rec.PARENT_WO_ID;
446:
447: debug(' Updating EAM_CE_WORK_ORDER_LINES_PKG Parent Work Order line - ' || l_wo_line_id_seq);
448: EAM_CE_WORK_ORDER_LINES_PKG.UPDATE_ROW(
449: p_estimate_work_order_line_id => l_wo_line_id_seq
450: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
451: ,p_src_cu_id => FND_API.G_MISS_NUM
452: ,p_src_activity_id => FND_API.G_MISS_NUM

Line 529: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(

525:
526: SELECT EAM_CE_WORK_ORDER_LINES_S.NEXTVAL INTO l_wo_line_id_seq FROM DUAL;
527: debug(' Generating new Parent Work order - ' || l_wo_line_id_seq);
528:
529: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
530: p_estimate_work_order_line_id => l_wo_line_id_seq
531: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
532: ,p_src_cu_id => FND_API.G_MISS_NUM
533: ,p_src_activity_id => FND_API.G_MISS_NUM

Line 692: EAM_CE_WORK_ORDER_LINES_PKG.DELETE_ROW (

688: IF NVL(l_estimate_parent_rec.CREATE_PARENT_WO_FLAG,'N') = 'Y' AND
689: NVL(l_estimate_parent_rec.PARENT_WO_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
690:
691: debug(' Create parent work order flag flipped. Deleting existing work order line');
692: EAM_CE_WORK_ORDER_LINES_PKG.DELETE_ROW (
693: p_work_order_line_id => l_estimate_parent_rec.PARENT_WO_ID
694: );
695: END IF; -- NVL(l_estimate_parent_rec.CREATE_PARENT_WO_FLAG,'N') = 'Y'
696: ELSE

Line 733: EAM_CE_WORK_ORDER_LINES_PKG.DELETE_ROW (

729: );
730:
731: IF NVL(l_estimate_parent_rec.CREATE_PARENT_WO_FLAG,'N') = 'Y' AND
732: NVL(l_estimate_parent_rec.PARENT_WO_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
733: EAM_CE_WORK_ORDER_LINES_PKG.DELETE_ROW (
734: p_work_order_line_id => l_estimate_parent_rec.PARENT_WO_ID
735: );
736: END IF;
737: END IF;

Line 888: -- Call EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW

884: RAISE FND_API.G_EXC_ERROR;
885: END IF; -- nvl(l_return_status,'S') <> 'S'
886: END IF;
887:
888: -- Call EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW
889: -- to insert wo line row
890:
891: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
892: p_estimate_work_order_line_id => NULL

Line 891: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(

887:
888: -- Call EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW
889: -- to insert wo line row
890:
891: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
892: p_estimate_work_order_line_id => NULL
893: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
894: ,p_src_cu_id => NULL
895: ,p_src_activity_id => NULL

Line 1082: EAM_CE_WORK_ORDER_LINES_PKG.DELETE_ALL_WITH_ESTIMATE_ID(

1078: -- When new set of work order lines are being estimated
1079: -- The old WO lines needs to be deleted
1080: -- None of these operations are committed until saved
1081: --
1082: EAM_CE_WORK_ORDER_LINES_PKG.DELETE_ALL_WITH_ESTIMATE_ID(
1083: p_estimate_id => p_estimate_id
1084: );
1085: */
1086: -- If the p_estimate_work_order_line_id exists then update the

Line 1131: EAM_CE_WORK_ORDER_LINES_PKG.UPDATE_ROW(

1127: l_system_status_rec.SYSTEM_STATUS := p_eam_ce_wo_lines_tbl(l_ce_tab_index).USER_DEFINED_STATUS_ID;
1128: END;
1129:
1130: -- Call UPDATE_ROW TO update the changes
1131: EAM_CE_WORK_ORDER_LINES_PKG.UPDATE_ROW(
1132: p_estimate_work_order_line_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ESTIMATE_WORK_ORDER_LINE_ID
1133: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
1134: ,p_src_cu_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_CU_ID
1135: ,p_src_activity_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_ACTIVITY_ID

Line 1241: -- Call EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW

1237: WHEN OTHERS THEN
1238: l_system_status_rec.SYSTEM_STATUS := p_eam_ce_wo_lines_tbl(l_ce_tab_index).USER_DEFINED_STATUS_ID;
1239: END;
1240:
1241: -- Call EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW
1242: -- to insert wo line row
1243:
1244: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
1245: p_estimate_work_order_line_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ESTIMATE_WORK_ORDER_LINE_ID

Line 1244: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(

1240:
1241: -- Call EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW
1242: -- to insert wo line row
1243:
1244: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
1245: p_estimate_work_order_line_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ESTIMATE_WORK_ORDER_LINE_ID
1246: ,p_estimate_work_order_id => FND_API.G_MISS_NUM
1247: ,p_src_cu_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_CU_ID
1248: ,p_src_activity_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).SRC_ACTIVITY_ID

Line 1843: -- EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW

1839: debug(' Total Populated in l_eam_ce_wo_lines_tbl - ' || l_eam_ce_wo_lines_tbl.count);
1840:
1841: -- This block populates the common attributes for all the work order lines
1842: -- Also once all the attribute are populated, it calles
1843: -- EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW
1844: /* IF l_wo_ind > 0 THEN
1845: FOR l_ce_tab_index IN l_eam_ce_wo_lines_tbl.FIRST .. l_eam_ce_wo_lines_tbl.LAST
1846: LOOP
1847:

Line 3531: EAM_CE_WORK_ORDER_LINES_PKG.UPDATE_ROW(

3527:
3528: --Now update the wo lines
3529: IF l_ce_wo_ln_tbl.COUNT > 0 THEN
3530: FOR i IN l_ce_wo_ln_tbl.FIRST..l_ce_wo_ln_tbl.LAST LOOP
3531: EAM_CE_WORK_ORDER_LINES_PKG.UPDATE_ROW(
3532: p_estimate_work_order_line_id => l_ce_wo_ln_tbl(i).ESTIMATE_WORK_ORDER_LINE_ID,
3533: p_estimate_work_order_id => FND_API.G_MISS_NUM,
3534: p_src_cu_id => l_ce_wo_ln_tbl(i).SRC_CU_ID,
3535: p_src_activity_id => l_ce_wo_ln_tbl(i).SRC_ACTIVITY_ID,

Line 5114: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(

5110: l_parent_estimate_wo_line_id = l_est_workorder_line_rec.ESTIMATE_WORK_ORDER_LINE_ID) THEN
5111:
5112: SELECT EAM_CE_WORK_ORDER_LINES_S.NEXTVAL INTO l_wo_line_id_seq FROM DUAL;
5113:
5114: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
5115: p_estimate_work_order_line_id => l_wo_line_id_seq
5116: ,p_estimate_work_order_id => NULL
5117: ,p_src_cu_id => l_est_workorder_line_rec.SRC_CU_ID
5118: ,p_src_activity_id => l_est_workorder_line_rec.SRC_ACTIVITY_ID

Line 5222: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(

5218: p_ATTRIBUTE15 => l_estimate_rec.attribute15
5219: );
5220:
5221: ELSE
5222: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
5223: p_estimate_work_order_line_id => NULL
5224: ,p_estimate_work_order_id => NULL
5225: ,p_src_cu_id => l_est_workorder_line_rec.SRC_CU_ID
5226: ,p_src_activity_id => l_est_workorder_line_rec.SRC_ACTIVITY_ID