DBA Data[Home] [Help]

APPS.AHL_PP_MATERIALS_PVT dependencies on AHL_WO_OPERATIONS_TXNS_S

Line 1808: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id

1804: END IF;
1805: --
1806: END IF; --Material id g_miss_num
1807: --
1808: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id
1809: FROM DUAL;
1810: --
1811: IF G_DEBUG='Y' THEN
1812: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);

Line 2401: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id

2397: -- Assign workorder operation id if null
2398: p_x_req_material_tbl(i).workorder_operation_id := l_req_material_rec.workorder_operation_id;
2399: --
2400: --Call transaction log to create record ahl_wo_operations_txns
2401: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id
2402: FROM DUAL;
2403: --
2404: IF G_DEBUG='Y' THEN
2405: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);