APPS.AHL_PP_MATERIALS_PVT dependencies on AHL_WO_OPERATIONS_TXNS

Line 2608: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id

2604: END IF;
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);

Line 2936: FROM ahl_wo_operations_txns

2932: SELECT inventory_item_id,
2933: schedule_material_id,
2934: date_required,
2935: required_quantity
2936: FROM ahl_wo_operations_txns
2937: WHERE wo_operation_txn_id = c_wo_trans_id;
2938: --
2939: --Check for status Released or Unreleased
2940: /* MANESING::NR Analysis, 03-Jun-2011,

Line 2958: FROM ahl_wo_operations_txns

2954: --Get wo transaction id
2955: CURSOR Get_wo_transaction_id(c_sch_material_id IN NUMBER)
2956: IS
2957: SELECT max(wo_operation_txn_id)
2958: FROM ahl_wo_operations_txns
2959: WHERE schedule_material_id = c_sch_material_id;
2960: -- rroy
2961: -- ACL Changes
2962: -- Get job number details

Line 3288: --Call transaction log to create record ahl_wo_operations_txns

3284: END IF;
3285: -- Assign workorder operation id if null
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

Line 3289: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id

3285: -- Assign workorder operation id if null
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);

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;

Line 5377: INSERT INTO AHL_WO_OPERATIONS_TXNS

5373: p_attribute15 IN VARCHAR2 := NULL)
5374: IS
5375: BEGIN
5376: --
5377: INSERT INTO AHL_WO_OPERATIONS_TXNS
5378: ( wo_operation_txn_id ,
5379: object_version_number ,
5380: last_update_date ,
5381: last_updated_by ,