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_CONSTRUCTION_ESTIMATES

Line 364: FROM EAM_CONSTRUCTION_ESTIMATES

360: SELECT ESTIMATE_ID ,
361: ORGANIZATION_ID ,
362: CREATE_PARENT_WO_FLAG,
363: PARENT_WO_ID
364: FROM EAM_CONSTRUCTION_ESTIMATES
365: WHERE ESTIMATE_ID = p_estimate_id
366: AND ORGANIZATION_ID = p_parent_wo_line_rec.ORGANIZATION_ID;
367:
368: -- Bug 12541554

Line 612: EAM_CONSTRUCTION_ESTIMATES_PKG.UPDATE_ROW(

608:
609: debug(' Updating Estimate header.');
610: -- Update the estimates table with the ESTIMATE_WORK_ORDER_LINE_ID
611: -- generated
612: EAM_CONSTRUCTION_ESTIMATES_PKG.UPDATE_ROW(
613: p_ESTIMATE_ID => p_estimate_id,
614: p_ORGANIZATION_ID => l_estimate_rec.ORGANIZATION_ID,
615: p_ESTIMATE_NUMBER => l_estimate_rec.ESTIMATE_NUMBER,
616: p_ESTIMATE_DESCRIPTION => l_estimate_rec.ESTIMATE_DESCRIPTION,

Line 655: EAM_CONSTRUCTION_ESTIMATES_PKG.UPDATE_ROW(

651: debug(' Updating estimate header with parent wip entity id - ' || l_parent_wo_num);
652:
653: l_parent_wo_num := TO_NUMBER(p_parent_wo_line_rec.PARENT_WORK_ORDER_NUMBER);
654:
655: EAM_CONSTRUCTION_ESTIMATES_PKG.UPDATE_ROW(
656: p_ESTIMATE_ID => p_estimate_id,
657: p_ORGANIZATION_ID => l_estimate_rec.ORGANIZATION_ID,
658: p_ESTIMATE_NUMBER => l_estimate_rec.ESTIMATE_NUMBER,
659: p_ESTIMATE_DESCRIPTION => l_estimate_rec.ESTIMATE_DESCRIPTION,

Line 700: EAM_CONSTRUCTION_ESTIMATES_PKG.UPDATE_ROW(

696: ELSE
697: -- No parent record entered
698: -- make work order number in the estimate table as null
699: debug(' No parent work order entered. Making work order number NULL in Estimate table.');
700: EAM_CONSTRUCTION_ESTIMATES_PKG.UPDATE_ROW(
701: p_ESTIMATE_ID => p_estimate_id,
702: p_ORGANIZATION_ID => l_estimate_rec.ORGANIZATION_ID,
703: p_ESTIMATE_NUMBER => l_estimate_rec.ESTIMATE_NUMBER,
704: p_ESTIMATE_DESCRIPTION => l_estimate_rec.ESTIMATE_DESCRIPTION,

Line 2270: FROM EAM_CONSTRUCTION_ESTIMATES

2266: ELSE
2267: BEGIN
2268: SELECT 'Y'
2269: INTO l_estimate_exist
2270: FROM EAM_CONSTRUCTION_ESTIMATES
2271: WHERE ESTIMATE_NUMBER = px_estimate_rec.ESTIMATE_NUMBER
2272: AND ROWNUM = 1;
2273: EXCEPTION
2274: WHEN NO_DATA_FOUND THEN

Line 2287: EAM_CONSTRUCTION_ESTIMATES_PKG.INSERT_ROW(

2283: END IF;
2284:
2285:
2286:
2287: EAM_CONSTRUCTION_ESTIMATES_PKG.INSERT_ROW(
2288: px_ESTIMATE_ID => px_estimate_rec.ESTIMATE_ID,
2289: p_ORGANIZATION_ID => px_estimate_rec.ORGANIZATION_ID,
2290: p_ESTIMATE_NUMBER => px_estimate_rec.ESTIMATE_NUMBER,
2291: p_ESTIMATE_DESCRIPTION => px_estimate_rec.ESTIMATE_DESCRIPTION,

Line 2444: FROM EAM_CONSTRUCTION_ESTIMATES

2440: ELSE
2441: BEGIN
2442: SELECT 'Y'
2443: INTO l_estimate_exist
2444: FROM EAM_CONSTRUCTION_ESTIMATES
2445: WHERE ESTIMATE_NUMBER = p_estimate_rec.ESTIMATE_NUMBER
2446: AND ESTIMATE_ID <> p_estimate_rec.ESTIMATE_ID
2447: AND ROWNUM = 1;
2448: EXCEPTION

Line 2480: p_desc_flex_name => 'EAM_CONSTRUCTION_ESTIMATES_DFF',

2476: END IF;
2477:
2478: l_validate := EAM_COMMON_UTILITIES_PVT.validate_desc_flex_field (
2479: p_app_short_name => 'EAM',
2480: p_desc_flex_name => 'EAM_CONSTRUCTION_ESTIMATES_DFF',
2481: p_ATTRIBUTE_CATEGORY => l_attribute_category ,
2482: p_ATTRIBUTE1 => p_estimate_rec.attribute1 ,
2483: p_ATTRIBUTE2 => p_estimate_rec.attribute2 ,
2484: p_ATTRIBUTE3 => p_estimate_rec.attribute3 ,

Line 2508: EAM_CONSTRUCTION_ESTIMATES_PKG.UPDATE_ROW(

2504: RAISE FND_API.G_EXC_ERROR;
2505: END IF;
2506:
2507:
2508: EAM_CONSTRUCTION_ESTIMATES_PKG.UPDATE_ROW(
2509: p_ESTIMATE_ID => p_estimate_rec.ESTIMATE_ID,
2510: p_ORGANIZATION_ID => p_estimate_rec.ORGANIZATION_ID,
2511: p_ESTIMATE_NUMBER => p_estimate_rec.ESTIMATE_NUMBER,
2512: p_ESTIMATE_DESCRIPTION => p_estimate_rec.ESTIMATE_DESCRIPTION,

Line 2667: FROM EAM_CONSTRUCTION_ESTIMATES

2663: SELECT ESTIMATE_ID,
2664: ORGANIZATION_ID
2665: INTO l_ce_id,
2666: l_organization_id
2667: FROM EAM_CONSTRUCTION_ESTIMATES
2668: WHERE ESTIMATE_ID = p_ce_id;
2669: EXCEPTION
2670: WHEN OTHERS THEN
2671: FND_MESSAGE.SET_NAME('EAM','EAM_INVALID_CE_ID');

Line 2821: FROM EAM_CONSTRUCTION_ESTIMATES

2817: SELECT *
2818: FROM EAM_CE_WORK_ORDER_LINES
2819: WHERE ESTIMATE_ID = p_ce_id
2820: AND estimate_work_order_line_id NOT IN (SELECT parent_wo_id
2821: FROM EAM_CONSTRUCTION_ESTIMATES
2822: WHERE estimate_id = p_ce_id
2823: AND nvl(create_parent_wo_flag, 'N') = 'Y');
2824:
2825: --The group by 'Single Work Order', 'Construction Unit' and 'Activity' options all work as follow:

Line 2839: FROM EAM_CONSTRUCTION_ESTIMATES

2835: NVL(ECWOL.OP_SEQ_NUM, ECWOL.SRC_OP_SEQ_NUM) OP_SEQ_NUM_DERIVED
2836: FROM EAM_CE_WORK_ORDER_LINES ECWOL
2837: WHERE ECWOL.ESTIMATE_ID = p_ce_id
2838: AND ECWOL.estimate_work_order_line_id NOT IN (SELECT parent_wo_id
2839: FROM EAM_CONSTRUCTION_ESTIMATES
2840: WHERE estimate_id = p_ce_id
2841: AND nvl(create_parent_wo_flag, 'N') = 'Y')
2842: ORDER BY ECWOL.SRC_CU_ID,
2843: ECWOL.SRC_ACTIVITY_ID,

Line 2864: FROM EAM_CONSTRUCTION_ESTIMATES

2860: NVL(ECWOL.OP_SEQ_NUM, ECWOL.SRC_OP_SEQ_NUM) OP_SEQ_NUM_DERIVED
2861: FROM EAM_CE_WORK_ORDER_LINES ECWOL
2862: WHERE ECWOL.ESTIMATE_ID = p_ce_id
2863: AND ECWOL.estimate_work_order_line_id NOT IN (SELECT parent_wo_id
2864: FROM EAM_CONSTRUCTION_ESTIMATES
2865: WHERE estimate_id = p_ce_id
2866: AND nvl(create_parent_wo_flag, 'N') = 'Y')
2867: ORDER BY ECWOL.SRC_ACCT_CLASS_CODE,
2868: ECWOL.SRC_CU_ID,

Line 3767: FROM EAM_CONSTRUCTION_ESTIMATES

3763: FROM EAM_CE_WORK_ORDER_LINES
3764: WHERE organization_id = p_organization_id
3765: AND estimate_id = p_estimate_id
3766: AND estimate_work_order_line_id NOT IN (SELECT parent_wo_id
3767: FROM EAM_CONSTRUCTION_ESTIMATES
3768: WHERE ORGANIZATION_ID = P_ORGANIzATION_ID
3769: AND estimate_id = p_estimate_id
3770: AND nvl(create_parent_wo_flag, 'N') = 'Y'
3771: )

Line 3887: FROM EAM_CONSTRUCTION_ESTIMATES

3883: -------------------------------------------------------------------------
3884:
3885: SELECT nvl(create_parent_wo_flag, 'N'), parent_wo_id
3886: INTO l_create_parent, l_parent_job_id
3887: FROM EAM_CONSTRUCTION_ESTIMATES
3888: WHERE organization_id = p_organization_id
3889: AND estimate_id = p_estimate_id;
3890:
3891: -------------------------------------------------------------------------

Line 4988: FROM EAM_CONSTRUCTION_ESTIMATES ECE

4984: ORDER BY ESTIMATE_WORK_ORDER_LINE_ID;
4985:
4986: CURSOR SRC_ESTIMATES_CUR IS
4987: SELECT ECE.*
4988: FROM EAM_CONSTRUCTION_ESTIMATES ECE
4989: WHERE ESTIMATE_ID = p_src_estimate_id
4990: AND ORGANIZATION_ID = p_org_id;
4991: l_estimate_rec SRC_ESTIMATES_CUR%ROWTYPE;
4992:

Line 4996: -- Estimate Entries in EAM_CONSTRUCTION_ESTIMATES

4992:
4993: BEGIN
4994: SAVEPOINT COPY_EST_WORKBENCH;
4995: -- Copy the following from the src estimate id
4996: -- Estimate Entries in EAM_CONSTRUCTION_ESTIMATES
4997: -- Estimate Work Bench Enteries in EAM_CE_WORK_ORDER_LINES
4998: -- Clear out WO Order Related details
4999:
5000: -- Checking input parameters

Line 5023: -- and call EAM_CONSTRUCTION_ESTIMATES_PKG.INSERT_ROW API

5019: FETCH SRC_ESTIMATES_CUR INTO l_estimate_rec;
5020: CLOSE SRC_ESTIMATES_CUR;
5021:
5022: -- Initialize destination estimate rec
5023: -- and call EAM_CONSTRUCTION_ESTIMATES_PKG.INSERT_ROW API
5024: l_estimate_rec.ESTIMATE_ID := NULL;
5025: -- Bug 13698217
5026: l_estimate_rec.ESTIMATE_NUMBER := 'Copy of ' || substr(l_estimate_rec.ESTIMATE_NUMBER,1,20);
5027: IF l_estimate_rec.ESTIMATE_DESCRIPTION IS NULL THEN

Line 5064: EAM_CONSTRUCTION_ESTIMATES_PKG.INSERT_ROW(

5060:
5061: END IF; -- NVL(l_estimate_rec.CREATE_PARENT_WO_FLAG,'N') = 'Y'
5062:
5063:
5064: EAM_CONSTRUCTION_ESTIMATES_PKG.INSERT_ROW(
5065: px_ESTIMATE_ID => l_estimate_rec.ESTIMATE_ID,
5066: p_ORGANIZATION_ID => l_estimate_rec.ORGANIZATION_ID,
5067: p_ESTIMATE_NUMBER => l_estimate_rec.ESTIMATE_NUMBER,
5068: p_ESTIMATE_DESCRIPTION => l_estimate_rec.ESTIMATE_DESCRIPTION,

Line 5190: EAM_CONSTRUCTION_ESTIMATES_PKG.UPDATE_ROW(

5186: ,p_res_sch_flag => l_est_workorder_line_rec.RES_SCHEDULED_FLAG
5187: );
5188:
5189: -- Update the estimate with the estimate line id
5190: EAM_CONSTRUCTION_ESTIMATES_PKG.UPDATE_ROW(
5191: p_ESTIMATE_ID => l_estimate_rec.ESTIMATE_ID,
5192: p_ORGANIZATION_ID => l_estimate_rec.ORGANIZATION_ID,
5193: p_ESTIMATE_NUMBER => l_estimate_rec.ESTIMATE_NUMBER,
5194: p_ESTIMATE_DESCRIPTION => l_estimate_rec.ESTIMATE_DESCRIPTION,