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 345: FROM EAM_CONSTRUCTION_ESTIMATES

341: SELECT ESTIMATE_ID ,
342: ORGANIZATION_ID ,
343: CREATE_PARENT_WO_FLAG,
344: PARENT_WO_ID
345: FROM EAM_CONSTRUCTION_ESTIMATES
346: WHERE ESTIMATE_ID = p_estimate_id
347: AND ORGANIZATION_ID = p_parent_wo_line_rec.ORGANIZATION_ID;
348:
349: l_estimate_parent_rec EST_PARENT_CSR%ROWTYPE;

Line 563: EAM_CONSTRUCTION_ESTIMATES_PKG.UPDATE_ROW(

559: END IF; -- IF l_estimate_parent_rec.PARENT_WO_ID IS NULL THEN
560:
561: -- Update the estimates table with the ESTIMATE_WORK_ORDER_LINE_ID
562: -- generated
563: EAM_CONSTRUCTION_ESTIMATES_PKG.UPDATE_ROW(
564: p_ESTIMATE_ID => p_estimate_id,
565: p_ORGANIZATION_ID => l_estimate_rec.ORGANIZATION_ID,
566: p_ESTIMATE_NUMBER => l_estimate_rec.ESTIMATE_NUMBER,
567: p_ESTIMATE_DESCRIPTION => l_estimate_rec.ESTIMATE_DESCRIPTION,

Line 605: EAM_CONSTRUCTION_ESTIMATES_PKG.UPDATE_ROW(

601:
602:
603: l_parent_wo_num := TO_NUMBER(p_parent_wo_line_rec.PARENT_WORK_ORDER_NUMBER);
604:
605: EAM_CONSTRUCTION_ESTIMATES_PKG.UPDATE_ROW(
606: p_ESTIMATE_ID => p_estimate_id,
607: p_ORGANIZATION_ID => l_estimate_rec.ORGANIZATION_ID,
608: p_ESTIMATE_NUMBER => l_estimate_rec.ESTIMATE_NUMBER,
609: p_ESTIMATE_DESCRIPTION => l_estimate_rec.ESTIMATE_DESCRIPTION,

Line 647: EAM_CONSTRUCTION_ESTIMATES_PKG.UPDATE_ROW(

643: END IF; -- NVL(l_estimate_parent_rec.CREATE_PARENT_WO_FLAG,'N') = 'Y'
644: ELSE
645: -- No parent record entered
646: -- make work order number in the estimate table as null
647: EAM_CONSTRUCTION_ESTIMATES_PKG.UPDATE_ROW(
648: p_ESTIMATE_ID => p_estimate_id,
649: p_ORGANIZATION_ID => l_estimate_rec.ORGANIZATION_ID,
650: p_ESTIMATE_NUMBER => l_estimate_rec.ESTIMATE_NUMBER,
651: p_ESTIMATE_DESCRIPTION => l_estimate_rec.ESTIMATE_DESCRIPTION,

Line 2133: FROM EAM_CONSTRUCTION_ESTIMATES

2129: ELSE
2130: BEGIN
2131: SELECT 'Y'
2132: INTO l_estimate_exist
2133: FROM EAM_CONSTRUCTION_ESTIMATES
2134: WHERE ESTIMATE_NUMBER = px_estimate_rec.ESTIMATE_NUMBER
2135: AND ROWNUM = 1;
2136: EXCEPTION
2137: WHEN NO_DATA_FOUND THEN

Line 2148: EAM_CONSTRUCTION_ESTIMATES_PKG.INSERT_ROW(

2144: RAISE FND_API.G_EXC_ERROR;
2145: END IF;
2146: END IF;
2147:
2148: EAM_CONSTRUCTION_ESTIMATES_PKG.INSERT_ROW(
2149: px_ESTIMATE_ID => px_estimate_rec.ESTIMATE_ID,
2150: p_ORGANIZATION_ID => px_estimate_rec.ORGANIZATION_ID,
2151: p_ESTIMATE_NUMBER => px_estimate_rec.ESTIMATE_NUMBER,
2152: p_ESTIMATE_DESCRIPTION => px_estimate_rec.ESTIMATE_DESCRIPTION,

Line 2301: FROM EAM_CONSTRUCTION_ESTIMATES

2297: ELSE
2298: BEGIN
2299: SELECT 'Y'
2300: INTO l_estimate_exist
2301: FROM EAM_CONSTRUCTION_ESTIMATES
2302: WHERE ESTIMATE_NUMBER = p_estimate_rec.ESTIMATE_NUMBER
2303: AND ESTIMATE_ID <> p_estimate_rec.ESTIMATE_ID
2304: AND ROWNUM = 1;
2305: EXCEPTION

Line 2329: EAM_CONSTRUCTION_ESTIMATES_PKG.UPDATE_ROW(

2325: l_parent_creation_flag := p_estimate_rec.CREATE_PARENT_WO_FLAG;
2326: END IF; -- NVL(p_estimate_rec.PARENT_WO_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
2327:
2328:
2329: EAM_CONSTRUCTION_ESTIMATES_PKG.UPDATE_ROW(
2330: p_ESTIMATE_ID => p_estimate_rec.ESTIMATE_ID,
2331: p_ORGANIZATION_ID => p_estimate_rec.ORGANIZATION_ID,
2332: p_ESTIMATE_NUMBER => p_estimate_rec.ESTIMATE_NUMBER,
2333: p_ESTIMATE_DESCRIPTION => p_estimate_rec.ESTIMATE_DESCRIPTION,

Line 2488: FROM EAM_CONSTRUCTION_ESTIMATES

2484: SELECT ESTIMATE_ID,
2485: ORGANIZATION_ID
2486: INTO l_ce_id,
2487: l_organization_id
2488: FROM EAM_CONSTRUCTION_ESTIMATES
2489: WHERE ESTIMATE_ID = p_ce_id;
2490: EXCEPTION
2491: WHEN OTHERS THEN
2492: FND_MESSAGE.SET_NAME('EAM','EAM_INVALID_CE_ID');

Line 2642: FROM EAM_CONSTRUCTION_ESTIMATES

2638: SELECT *
2639: FROM EAM_CE_WORK_ORDER_LINES
2640: WHERE ESTIMATE_ID = p_ce_id
2641: AND estimate_work_order_line_id NOT IN (SELECT parent_wo_id
2642: FROM EAM_CONSTRUCTION_ESTIMATES
2643: WHERE estimate_id = p_ce_id
2644: AND nvl(create_parent_wo_flag, 'N') = 'Y');
2645:
2646: --The group by 'Single Work Order', 'Construction Unit' and 'Activity' options all work as follow:

Line 2660: FROM EAM_CONSTRUCTION_ESTIMATES

2656: NVL(ECWOL.OP_SEQ_NUM, ECWOL.SRC_OP_SEQ_NUM) OP_SEQ_NUM_DERIVED
2657: FROM EAM_CE_WORK_ORDER_LINES ECWOL
2658: WHERE ECWOL.ESTIMATE_ID = p_ce_id
2659: AND ECWOL.estimate_work_order_line_id NOT IN (SELECT parent_wo_id
2660: FROM EAM_CONSTRUCTION_ESTIMATES
2661: WHERE estimate_id = p_ce_id
2662: AND nvl(create_parent_wo_flag, 'N') = 'Y')
2663: ORDER BY ECWOL.SRC_CU_ID,
2664: ECWOL.SRC_ACTIVITY_ID,

Line 2685: FROM EAM_CONSTRUCTION_ESTIMATES

2681: NVL(ECWOL.OP_SEQ_NUM, ECWOL.SRC_OP_SEQ_NUM) OP_SEQ_NUM_DERIVED
2682: FROM EAM_CE_WORK_ORDER_LINES ECWOL
2683: WHERE ECWOL.ESTIMATE_ID = p_ce_id
2684: AND ECWOL.estimate_work_order_line_id NOT IN (SELECT parent_wo_id
2685: FROM EAM_CONSTRUCTION_ESTIMATES
2686: WHERE estimate_id = p_ce_id
2687: AND nvl(create_parent_wo_flag, 'N') = 'Y')
2688: ORDER BY ECWOL.SRC_ACCT_CLASS_CODE,
2689: ECWOL.SRC_CU_ID,

Line 3588: FROM EAM_CONSTRUCTION_ESTIMATES

3584: FROM EAM_CE_WORK_ORDER_LINES
3585: WHERE organization_id = p_organization_id
3586: AND estimate_id = p_estimate_id
3587: AND estimate_work_order_line_id NOT IN (SELECT parent_wo_id
3588: FROM EAM_CONSTRUCTION_ESTIMATES
3589: WHERE ORGANIZATION_ID = P_ORGANIzATION_ID
3590: AND estimate_id = p_estimate_id
3591: AND nvl(create_parent_wo_flag, 'N') = 'Y'
3592: )

Line 3708: FROM EAM_CONSTRUCTION_ESTIMATES

3704: -------------------------------------------------------------------------
3705:
3706: SELECT nvl(create_parent_wo_flag, 'N'), parent_wo_id
3707: INTO l_create_parent, l_parent_job_id
3708: FROM EAM_CONSTRUCTION_ESTIMATES
3709: WHERE organization_id = p_organization_id
3710: AND estimate_id = p_estimate_id;
3711:
3712: -------------------------------------------------------------------------

Line 4799: FROM EAM_CONSTRUCTION_ESTIMATES ECE

4795: ORDER BY ESTIMATE_WORK_ORDER_LINE_ID;
4796:
4797: CURSOR SRC_ESTIMATES_CUR IS
4798: SELECT ECE.*
4799: FROM EAM_CONSTRUCTION_ESTIMATES ECE
4800: WHERE ESTIMATE_ID = p_src_estimate_id
4801: AND ORGANIZATION_ID = p_org_id;
4802: l_estimate_rec SRC_ESTIMATES_CUR%ROWTYPE;
4803:

Line 4807: -- Estimate Entries in EAM_CONSTRUCTION_ESTIMATES

4803:
4804: BEGIN
4805: SAVEPOINT COPY_EST_WORKBENCH;
4806: -- Copy the following from the src estimate id
4807: -- Estimate Entries in EAM_CONSTRUCTION_ESTIMATES
4808: -- Estimate Work Bench Enteries in EAM_CE_WORK_ORDER_LINES
4809: -- Clear out WO Order Related details
4810:
4811: -- Checking input parameters

Line 4834: -- and call EAM_CONSTRUCTION_ESTIMATES_PKG.INSERT_ROW API

4830: FETCH SRC_ESTIMATES_CUR INTO l_estimate_rec;
4831: CLOSE SRC_ESTIMATES_CUR;
4832:
4833: -- Initialize destination estimate rec
4834: -- and call EAM_CONSTRUCTION_ESTIMATES_PKG.INSERT_ROW API
4835: l_estimate_rec.ESTIMATE_ID := NULL;
4836: l_estimate_rec.ESTIMATE_NUMBER := 'Copy of ' || l_estimate_rec.ESTIMATE_NUMBER;
4837: IF l_estimate_rec.ESTIMATE_DESCRIPTION IS NULL THEN
4838: l_estimate_rec.ESTIMATE_DESCRIPTION := '';

Line 4874: EAM_CONSTRUCTION_ESTIMATES_PKG.INSERT_ROW(

4870:
4871: END IF; -- NVL(l_estimate_rec.CREATE_PARENT_WO_FLAG,'N') = 'Y'
4872:
4873:
4874: EAM_CONSTRUCTION_ESTIMATES_PKG.INSERT_ROW(
4875: px_ESTIMATE_ID => l_estimate_rec.ESTIMATE_ID,
4876: p_ORGANIZATION_ID => l_estimate_rec.ORGANIZATION_ID,
4877: p_ESTIMATE_NUMBER => l_estimate_rec.ESTIMATE_NUMBER,
4878: p_ESTIMATE_DESCRIPTION => l_estimate_rec.ESTIMATE_DESCRIPTION,

Line 5000: EAM_CONSTRUCTION_ESTIMATES_PKG.UPDATE_ROW(

4996: ,p_res_sch_flag => l_est_workorder_line_rec.RES_SCHEDULED_FLAG
4997: );
4998:
4999: -- Update the estimate with the estimate line id
5000: EAM_CONSTRUCTION_ESTIMATES_PKG.UPDATE_ROW(
5001: p_ESTIMATE_ID => l_estimate_rec.ESTIMATE_ID,
5002: p_ORGANIZATION_ID => l_estimate_rec.ORGANIZATION_ID,
5003: p_ESTIMATE_NUMBER => l_estimate_rec.ESTIMATE_NUMBER,
5004: p_ESTIMATE_DESCRIPTION => l_estimate_rec.ESTIMATE_DESCRIPTION,