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_FAILURE_ANALYSIS_PVT dependencies on EAM_FAILURE_HISTORY_TEMP

Line 30: /This is to rollback all transactions done w.r.t. EAM_FAILURE_HISTORY_TEMP in the current session /

26:
27: BEGIN
28: g_module_name := 'GET_HISTORY_RECORDS_ADV';
29:
30: /*This is to rollback all transactions done w.r.t. EAM_FAILURE_HISTORY_TEMP in the current session */
31: ROLLBACK;
32:
33: GET_FAILURE_METER_RECS_CURSOR(p_where_clause => p_where_clause,
34: p_selected_meter => p_selected_meter,

Line 52: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_GROUP_ID FROM DUAL;

48: p_current_org_id => p_current_org_id,
49: x_unmatched_uom_class => l_unmatched_uom_class,
50: x_unmatched_currency => l_unmatched_currency); */
51:
52: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_GROUP_ID FROM DUAL;
53:
54: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
55: p_asset_failure_tbl => l_asset_failure_tbl);
56:

Line 115: /This is to rollback all transactions (uncommited) done w.r.t. EAM_FAILURE_HISTORY_TEMP in the current session /

111: BEGIN
112:
113: g_module_name := 'GET_HISTORY_RECORDS_FA_ADV';
114: l_return_status := 'S';
115: /*This is to rollback all transactions (uncommited) done w.r.t. EAM_FAILURE_HISTORY_TEMP in the current session */
116: ROLLBACK;
117:
118: l_current_org_id := p_current_org_id;
119:

Line 157: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

153: p_current_org_id => l_current_org_id,
154: x_unmatched_uom_class => l_unmatched_uom_class,
155: x_unmatched_currency => l_unmatched_currency);
156:
157: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
158:
159: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
160: p_asset_failure_tbl => l_asset_failure_tbl);
161:

Line 742: /This is to rollback all transactions (uncommited) done w.r.t. EAM_FAILURE_HISTORY_TEMP in the current session /

738:
739: BEGIN
740: g_module_name := 'GET_HISTORY_RECORDS_SIMPLE';
741:
742: /*This is to rollback all transactions (uncommited) done w.r.t. EAM_FAILURE_HISTORY_TEMP in the current session */
743: ROLLBACK;
744:
745: IF p_gen_object_id = 0 THEN
746: l_gen_object_id := NULL;

Line 787: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

783: p_current_org_id => l_current_org_id,
784: x_unmatched_uom_class => l_unmatched_uom_class,
785: x_unmatched_currency => l_unmatched_currency); */
786:
787: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
788:
789: INSERT_INTO_TEMP_TABLE(l_group_id, l_asset_failure_tbl);
790:
791: --No need to calculate Repair Costs in Failure History Page.

Line 1335: /This is to rollback all transactions (uncommited) done w.r.t. EAM_FAILURE_HISTORY_TEMP in the current session /

1331:
1332:
1333: BEGIN
1334: g_module_name := 'GET_HISTORY_RECORDS_FA_SIMPLE';
1335: /*This is to rollback all transactions (uncommited) done w.r.t. EAM_FAILURE_HISTORY_TEMP in the current session */
1336: ROLLBACK;
1337: IF p_gen_object_id = 0 THEN
1338: l_gen_object_id := NULL;
1339: ELSE

Line 1384: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

1380: p_current_org_id => p_current_org_id,
1381: x_unmatched_uom_class => l_unmatched_uom_class,
1382: x_unmatched_currency => l_unmatched_currency);
1383:
1384: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
1385:
1386: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
1387: p_asset_failure_tbl => l_asset_failure_tbl);
1388:

Line 1411: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

1407: p_current_org_id => p_current_org_id,
1408: x_unmatched_uom_class => l_unmatched_uom_class,
1409: x_unmatched_currency => l_unmatched_currency);
1410:
1411: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
1412:
1413: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
1414: p_asset_failure_tbl => l_asset_failure_tbl);
1415:

Line 1438: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

1434: p_current_org_id => p_current_org_id,
1435: x_unmatched_uom_class => l_unmatched_uom_class,
1436: x_unmatched_currency => l_unmatched_currency);
1437:
1438: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
1439:
1440: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
1441: p_asset_failure_tbl => l_asset_failure_tbl);
1442:

Line 1465: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

1461: p_current_org_id => p_current_org_id,
1462: x_unmatched_uom_class => l_unmatched_uom_class,
1463: x_unmatched_currency => l_unmatched_currency);
1464:
1465: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
1466:
1467: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
1468: p_asset_failure_tbl => l_asset_failure_tbl);
1469:

Line 1526: INSERT INTO EAM_FAILURE_HISTORY_TEMP

1522:
1523: FOR i in l_asset_failure_tbl.first .. l_asset_failure_tbl.last
1524: LOOP
1525:
1526: INSERT INTO EAM_FAILURE_HISTORY_TEMP
1527: (GROUP_ID,
1528: ASSET_TYPE,
1529: MAINTENANCE_OBJECT_ID,
1530: MAINTAINED_NUMBER,

Line 1598: FROM WIP_EAM_PERIOD_BALANCES WEPB, EAM_FAILURE_HISTORY_TEMP EFHT

1594:
1595: CURSOR c_cost_calc is
1596: SELECT SUM(WEPB.ACTUAL_MAT_COST+WEPB.ACTUAL_LAB_COST+WEPB.ACTUAL_EQP_COST) COST,
1597: WEPB.WIP_ENTITY_ID
1598: FROM WIP_EAM_PERIOD_BALANCES WEPB, EAM_FAILURE_HISTORY_TEMP EFHT
1599: WHERE EFHT.GROUP_ID = p_group_id
1600: AND EFHT.MAINT_ORGANIZATION_ID = WEPB.ORGANIZATION_ID
1601: AND EFHT.WIP_ENTITY_ID = WEPB.WIP_ENTITY_ID
1602: AND EFHT.INCLUDE_FOR_COST_AGGR = 'Y'

Line 1615: UPDATE EAM_FAILURE_HISTORY_TEMP

1611: FETCH c_cost_calc BULK COLLECT INTO p_repair_cost_tbl, p_wip_entity_id_tbl LIMIT 500;
1612:
1613: IF ( p_wip_entity_id_tbl.Count > 0 ) THEN
1614: FORALL i IN p_wip_entity_id_tbl.first .. p_wip_entity_id_tbl.last
1615: UPDATE EAM_FAILURE_HISTORY_TEMP
1616: SET COST_TO_REPAIR = Nvl(P_repair_cost_tbl(i),0)
1617: WHERE WIP_ENTITY_ID = P_wip_entity_id_tbl(i)
1618: AND GROUP_ID = p_group_id
1619: AND INCLUDE_FOR_COST_AGGR = 'Y';

Line 3138: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

3134: x_unmatched_uom_class => l_unmatched_uom_class,
3135: x_unmatched_currency => l_unmatched_currency);
3136:
3137: IF ( l_group_id IS NULL OR l_group_id = 0) then
3138: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3139: END IF;
3140:
3141: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
3142: p_asset_failure_tbl => l_asset_failure_tbl);

Line 3166: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

3162: x_unmatched_uom_class => l_unmatched_uom_class,
3163: x_unmatched_currency => l_unmatched_currency);
3164:
3165: IF ( l_group_id IS NULL OR l_group_id = 0) then
3166: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3167: END IF;
3168:
3169: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
3170: p_asset_failure_tbl => l_asset_failure_tbl);

Line 3194: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

3190: p_current_org_id => p_current_org_id,
3191: x_unmatched_uom_class => l_unmatched_uom_class,
3192: x_unmatched_currency => l_unmatched_currency);
3193: IF ( l_group_id IS NULL OR l_group_id = 0) then
3194: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3195: END IF;
3196:
3197: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
3198: p_asset_failure_tbl => l_asset_failure_tbl);

Line 3221: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

3217: p_current_org_id => p_current_org_id,
3218: x_unmatched_uom_class => l_unmatched_uom_class,
3219: x_unmatched_currency => l_unmatched_currency);
3220: IF ( l_group_id IS NULL OR l_group_id = 0) then
3221: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3222: END IF;
3223:
3224: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
3225: p_asset_failure_tbl => l_asset_failure_tbl);

Line 3252: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

3248: x_unmatched_uom_class => l_unmatched_uom_class,
3249: x_unmatched_currency => l_unmatched_currency);
3250:
3251: IF ( l_group_id IS NULL OR l_group_id = 0) then
3252: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3253: END IF;
3254:
3255: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
3256: p_asset_failure_tbl => l_asset_failure_tbl);

Line 3280: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

3276: x_unmatched_uom_class => l_unmatched_uom_class,
3277: x_unmatched_currency => l_unmatched_currency);
3278:
3279: IF ( l_group_id IS NULL OR l_group_id = 0) then
3280: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3281: END IF;
3282:
3283: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
3284: p_asset_failure_tbl => l_asset_failure_tbl);

Line 3308: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

3304: p_current_org_id => p_current_org_id,
3305: x_unmatched_uom_class => l_unmatched_uom_class,
3306: x_unmatched_currency => l_unmatched_currency);
3307: IF ( l_group_id IS NULL OR l_group_id = 0) then
3308: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3309: END IF;
3310:
3311: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
3312: p_asset_failure_tbl => l_asset_failure_tbl);

Line 3335: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

3331: p_current_org_id => p_current_org_id,
3332: x_unmatched_uom_class => l_unmatched_uom_class,
3333: x_unmatched_currency => l_unmatched_currency);
3334: IF ( l_group_id IS NULL OR l_group_id = 0) then
3335: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3336: END IF;
3337:
3338: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
3339: p_asset_failure_tbl => l_asset_failure_tbl);

Line 3439: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

3435: x_unmatched_uom_class => l_unmatched_uom_class,
3436: x_unmatched_currency => l_unmatched_currency);
3437:
3438: IF ( l_group_id IS NULL OR l_group_id = 0) then
3439: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3440: END IF;
3441:
3442: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
3443: p_asset_failure_tbl => l_asset_failure_tbl);