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.AHL_PP_MATERIALS_PVT dependencies on DUAL

Line 2397: INTO l_schedule_material_id FROM DUAL;

2393: END IF;
2394: -- end of changes by debadey for Marshalling
2395: -- Get Sequence Number for schedule material ID
2396: SELECT ahl_schedule_materials_s.NEXTVAL
2397: INTO l_schedule_material_id FROM DUAL;
2398: --
2399: --
2400: IF G_DEBUG='Y' THEN
2401: AHL_DEBUG_PUB.debug( 'before interface flag:'||p_x_req_material_tbl(i).rt_oper_material_id);

Line 2609: FROM DUAL;

2605: --
2606: END IF; --Material id g_miss_num
2607: --
2608: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id
2609: FROM DUAL;
2610: --
2611: IF G_DEBUG='Y' THEN
2612: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);
2613: END IF;

Line 3290: FROM DUAL;

3286: p_x_req_material_tbl(i).workorder_operation_id := l_req_material_rec.workorder_operation_id;
3287: --
3288: --Call transaction log to create record ahl_wo_operations_txns
3289: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id
3290: FROM DUAL;
3291: --
3292: IF G_DEBUG='Y' THEN
3293: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);
3294: END IF;

Line 4511: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id FROM DUAL;

4507: IF (l_old_wip_req_rec.required_quantity > l_material_req_rec.old_requested_quantity) THEN
4508: -- Reduce the original ASM quantity from WIP requirement quantity..
4509: l_new_requested_qty := l_old_wip_req_rec.required_quantity - l_material_req_rec.old_requested_quantity;
4510:
4511: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id FROM DUAL;
4512: --
4513: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4514: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);
4515: END IF;

Line 4600: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id FROM DUAL;

4596: Fnd_Msg_Pub.ADD;
4597: RAISE FND_API.G_EXC_ERROR;
4598: ELSE
4599: -- If no WIP requirement exists for the new item then create a WIP requirement.
4600: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id FROM DUAL;
4601: --
4602: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4603: fnd_log.string(fnd_log.level_statement, l_debug_key, 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);
4604: END IF;